Car Wash Ledger

The bank's file against the books.

At the end of each day the payment provider sends a settlement file: every capture and refund it settled, with its fee. The matcher pairs each line with the ledger by reference. Whatever doesn't pair is a break, and a person looks at it. In the demo a day is compressed to a few minutes.

Settled days

3 Nov, 05:10

Gross

€3,737.00

PSP fee

€56.81

Net to the bank

€3,680.19

Settlement journal

#355630

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19fd4-fda5-7312-b476-ae46ebdacb40 is already settled by stl_EUR_2989471 line 54
  • fee differencethe fee is not the contract feethe fee is 71, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 53, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 38, the contract says 37
LineKindReferenceGrossFeeStatus
29capture01a19fd2-e328-7a81-8221-92205ec68667€49.00€0.71fee difference
34capture01a19fd3-497a-72a5-9215-aecc7a8d69bc€35.00€0.53fee difference
38capture01a19fd3-84a6-719e-8dd6-f0246c712c50€35.00€0.55fee difference
53capture01a19fd4-f74d-75d3-a9b5-70419f5a9888€24.00€0.38fee difference
55capture01a19fd4-fdbf-7310-8a29-c3d82cfacb79€35.00€0.50duplicate line
1capture01a19fc9-2a67-7fd1-9c14-1044f7a0d2fd€49.00€0.67matched
2capture01a19fce-b62f-773a-844c-8db0e12d6a5d€24.00€0.37matched
3capture01a19fd0-768f-7bd8-9c21-65853d50495b€49.00€0.67matched
4capture01a19fd0-883f-742c-bc7e-ef659dcacfa9€9.00€0.19matched
5capture01a19fd0-8f37-752c-b8ba-57682d102119€15.00€0.26matched
6capture01a19fd0-daf0-7ff0-87d6-744a6434feb3€49.00€0.67matched
7capture01a19fd1-1554-72b2-832a-900643eb1e81€24.00€0.37matched
8capture01a19fd1-1596-77e1-9aa4-99ca9acd9997€49.00€0.67matched
9capture01a19fd1-1729-787e-8421-df3713d3ca60€35.00€0.50matched
10capture01a19fd1-588f-7259-ade2-1a47ed3df162€9.00€0.19matched
11capture01a19fd1-59f1-7c70-98d9-989dff6bcbe4€15.00€0.26matched
12capture01a19fd1-6562-7591-8886-dcf6959e986c€24.00€0.37matched
13capture01a19fd1-7a58-7f0a-8ce4-3f409f3e74b2€15.00€0.26matched
14capture01a19fd1-9572-7c9e-a443-cd8814ab24c7€49.00€0.67matched
15capture01a19fd1-b906-7a76-9e48-9b1378da4827€15.00€0.26matched
16capture01a19fd1-be95-76b7-ad48-f3f0eeec2ba4€35.00€0.50matched
17refund01a19fd1-cabb-7a50-82ca-346813da533d-€21.00€0.00matched
18capture01a19fd1-d11d-77a8-ada2-d435717e7ddb€49.00€0.67matched
19capture01a19fd1-fd7f-7768-b7b5-8a229db3c4dd€35.00€0.50matched
20capture01a19fd2-0613-71fb-af35-22f3642e8017€24.00€0.37matched
21capture01a19fd2-0b84-79ce-964c-1986499c283d€24.00€0.37matched
22capture01a19fd2-1c6e-75e3-8785-8bbc523519de€24.00€0.37matched
23capture01a19fd2-20c8-7272-9179-1458972ff26e€35.00€0.50matched
24capture01a19fd2-2a24-7cae-8025-6d0c69ae707c€9.00€0.19matched
25capture01a19fd2-311a-7ecf-a039-14a79a6333a9€35.00€0.50matched
26capture01a19fd2-6781-7634-b438-0ddda75e7aa2€15.00€0.26matched
27capture01a19fd2-83fe-7346-9c4c-6cf26e2458d2€49.00€0.67matched
28capture01a19fd2-97a9-79b0-bd5c-64f18b544fbe€9.00€0.19matched
30capture01a19fd2-e629-7451-bddd-0f4d77afb79d€24.00€0.37matched
31capture01a19fd2-fafd-7663-9a5a-af535a12adc0€49.00€0.67matched
32capture01a19fd3-3545-7fdd-9697-3b5d9ceaa95f€49.00€0.67matched
33capture01a19fd3-38cc-769e-bc5e-8bd7d525c925€15.00€0.26matched
35capture01a19fd3-549b-7034-9340-08d282f68a7f€15.00€0.26matched
36capture01a19fd3-5b6d-7fa8-8648-546e2225a0b8€9.00€0.19matched
37capture01a19fd3-6a82-7695-bc8e-cbd881bccb9f€24.00€0.37matched
39capture01a19fd3-b085-768f-a973-1541baf0ba04€9.00€0.19matched
40capture01a19fd3-bb03-789c-81e5-b47dc9dad0a0€49.00€0.67matched
41capture01a19fd4-0823-74d2-bfe8-4efbd3de3e69€15.00€0.26matched
42capture01a19fd4-1164-7d67-9cda-d9f4e05e72a8€49.00€0.67matched
43capture01a19fd4-26c9-713d-aec3-b1bf020fce24€35.00€0.50matched
44capture01a19fd4-2629-7fd4-9079-bdc2239c727a€35.00€0.50matched
45capture01a19fd4-67ba-7f40-be79-27e2fe777d17€15.00€0.26matched
46capture01a19fd4-6b7c-7cec-ba12-590deef22c2a€35.00€0.50matched
47capture01a19fd4-7b89-7d02-b0d1-240613ee49f0€15.00€0.26matched
48capture01a19fd4-88d5-7cb2-9316-22ca69a3b2d5€24.00€0.37matched
49capture01a19fd4-9505-7903-a12d-4dc78979597c€35.00€0.50matched
50capture01a19fd4-d471-707f-8de8-c9049f898731€24.00€0.37matched
51capture01a19fd4-ec60-7298-85c5-afda2deb89cc€9.00€0.19matched
52capture01a19fd4-ed83-7bd2-8fba-5b0b41e292a2€24.00€0.37matched
54capture01a19fd4-fdbf-7310-8a29-c3d82cfacb79€35.00€0.50matched
56capture01a19fd5-07a3-79d1-a7d7-8fa564e994b0€9.00€0.19matched
57capture01a19fd5-1300-73af-9564-644da7a08ecd€9.00€0.19matched
58capture01a19fd5-3b07-7763-9822-5a52a5a2ecbe€9.00€0.19matched
59capture01a19fd5-4ffc-7d28-92a2-09943d4a4868€49.00€0.67matched
60capture01a19fd5-557f-7985-a8a2-4181049e2050€35.00€0.50matched
61capture01a19fd5-4f1f-7559-930d-6ffb76c10d72€9.00€0.19matched
62capture01a19fd5-6ecb-748a-a464-5fe2a694e484€35.00€0.50matched
63capture01a19fd5-7253-70fa-9cb1-0e9774919d16€24.00€0.37matched
64capture01a19fd5-73ed-71e0-afed-d46bc81d4580€49.00€0.67matched
65capture01a19fd5-8603-7ebc-92ad-4c7116e8bc58€15.00€0.26matched
66capture01a19fd5-86ab-7541-807b-ba6261e0a631€24.00€0.37matched
67capture01a19fd5-90aa-7a4f-ae4d-749a091819c8€9.00€0.19matched
68capture01a19fd5-961f-7ec0-bcd5-4a35a330db74€49.00€0.67matched
69capture01a19fd5-ac0a-7c2c-9d2b-1c4beebc2a4e€49.00€0.67matched
70capture01a19fd5-c6bc-7c14-bef0-09272aa12a76€24.00€0.37matched
71capture01a19fd5-d0b2-7d29-96a5-dac39e4597c3€24.00€0.37matched
72capture01a19fd5-d862-7e59-ae81-5584fb372e7a€49.00€0.67matched
73refund01a19fd5-d883-789f-933b-797ea13a1d01-€14.00€0.00matched
74capture01a19fd5-e50d-7a80-86b2-4f5b3d8c52d7€49.00€0.67matched
75capture01a19fd5-f398-7ea0-9e15-b0ff3923928e€35.00€0.50matched
76refund01a19fd6-0404-7d1e-8777-9ca0c6e9d612-€23.00€0.00matched
77capture01a19fd6-11de-7048-a6e9-81a15270b13c€24.00€0.37matched
78capture01a19fd6-12c1-7681-abe3-b46bdacded46€24.00€0.37matched
79capture01a19fd6-144d-72af-bfde-43803431e69b€24.00€0.37matched
80capture01a19fd6-262f-7715-86cd-a342ed6b61b1€49.00€0.67matched
81capture01a19fd6-2da1-7317-aba0-647f6ab7936f€15.00€0.26matched
82capture01a19fd6-2f24-7eee-a0b7-f0501e71623d€15.00€0.26matched
83capture01a19fd6-3e4d-70e7-8da5-2667254a9878€35.00€0.50matched
84capture01a19fd6-41c0-7187-8db6-6da48b99cc41€49.00€0.67matched
85capture01a19fd6-4464-7f2a-8ec9-3784da2734a8€24.00€0.37matched
86capture01a19fd6-4540-7720-8baf-c39b8ff22c19€49.00€0.67matched
87capture01a19fd6-67aa-7631-a18c-bbbaeb8646a6€35.00€0.50matched
88capture01a19fd6-8014-7481-a791-c569df6bb3d3€24.00€0.37matched
89capture01a19fd6-8453-7327-b886-f4cfb3774bfd€15.00€0.26matched
90capture01a19fd6-8521-7cb6-a4a8-e82211a5f017€24.00€0.37matched
91capture01a19fd6-869b-79c6-91b9-dc820f4aec72€15.00€0.26matched
92capture01a19fd6-a754-75d7-8be8-d78811eedc3a€49.00€0.67matched
93capture01a19fd6-aa98-77e6-9bfe-706cdf03bc29€49.00€0.67matched
94capture01a19fd6-b2ce-74f5-aba3-5f1b142d01dd€35.00€0.50matched
95capture01a19fd6-d767-7257-836a-252ecbd3cac2€15.00€0.26matched
96capture01a19fd6-ef31-7c08-87bc-6db3ba5f5bcb€24.00€0.37matched
97capture01a19fd6-f56e-74f4-a11d-97515f11f324€35.00€0.50matched
98capture01a19fd6-f89c-78a7-914e-c1856b646d27€24.00€0.37matched
99capture01a19fd6-fae7-7ab4-9071-c444fc2db3eb€35.00€0.50matched
100capture01a19fd7-1767-749a-8db1-62c190a98f1d€9.00€0.19matched
101capture01a19fd7-50d8-7569-955c-95e9cb1f5b48€9.00€0.19matched
102capture01a19fd7-5194-7f6b-91a8-b18045cd4a47€24.00€0.37matched
103capture01a19fd7-527a-78ef-bbb5-ed29efa35f14€9.00€0.19matched
104capture01a19fd7-746c-79fd-88ec-4d85b0f213f4€49.00€0.67matched
105capture01a19fd7-8d6e-74aa-a794-5625e5cfa74c€24.00€0.37matched
106capture01a19fd7-93f3-7706-9888-9217072f9452€24.00€0.37matched
107capture01a19fd7-ab84-7320-b4ca-ed9576e8cd65€9.00€0.19matched
108capture01a19fd7-bf92-738e-82c2-74cb5143f72d€9.00€0.19matched
109capture01a19fd7-cec1-7cf5-85fc-f39ea3fe8395€15.00€0.26matched
110capture01a19fd7-cef0-79fd-962c-cc2729c66ed3€24.00€0.37matched
111capture01a19fd7-e179-7a0e-a2c1-cbdbd4002002€9.00€0.19matched
112capture01a19fd7-e2e3-722f-acdc-650fe8a64f65€9.00€0.19matched
113capture01a19fd7-df19-7836-84bf-905b4baebe4c€24.00€0.37matched
114capture01a19fd8-0743-793a-9baa-4e31bd275a0a€49.00€0.67matched
115capture01a19fd8-2eac-7eb4-8159-66665555b1b1€15.00€0.26matched
116capture01a19fd8-35d3-7a5d-8cfd-b4cc5169fcf2€9.00€0.19matched
117capture01a19fd8-405e-7fad-a952-81cc718c0092€24.00€0.37matched
118capture01a19fd8-6217-7810-91e0-67f97bb28aff€35.00€0.50matched
119capture01a19fd8-6749-79c0-8948-3cffc1eaf180€35.00€0.50matched
120capture01a19fd8-856e-7cd7-95c6-0631bfdefd6c€49.00€0.67matched
121capture01a19fd8-8ba6-7df0-bd90-95caa6e79d0e€49.00€0.67matched
122capture01a19fd8-ad1d-70eb-a695-af4ab927ac24€15.00€0.26matched
123capture01a19fd8-b272-7a48-b70e-8875a22faf6b€15.00€0.26matched
124capture01a19fd8-c1e1-7907-a03a-5bdf538b18ea€24.00€0.37matched
125capture01a19fd8-e9b4-7008-abb1-77ec82051bb5€49.00€0.67matched
126capture01a19fd9-04be-734c-8c34-da8efe2def6f€49.00€0.67matched
127capture01a19fd9-1f48-7d64-9db3-8d37ff175374€35.00€0.50matched
128capture01a19fd9-3bc8-7aa5-ad25-b1462c2bbb72€35.00€0.50matched
129capture01a19fd9-51b8-7b4d-9dd2-a95240dc59c1€9.00€0.19matched
130capture01a19fd9-59b0-763f-8cd8-186b91ec4712€9.00€0.19matched
131capture01a19fd9-5cdb-7f9d-89e6-5fb0d0fdf9cf€9.00€0.19matched
132capture01a19fd9-66cb-7907-81fc-c0ce3d42a50f€24.00€0.37matched
133capture01a19fd9-75cf-7743-9486-675cddea6601€49.00€0.67matched
134capture01a19fd9-788a-79f9-8098-afca9751ecdf€9.00€0.19matched
135capture01a19fd9-7f2c-79b8-ad94-cd18642108d7€15.00€0.26matched
136capture01a19fd9-8042-78d4-9f1f-6dd2edd5c428€9.00€0.19matched
137capture01a19fd9-892b-7353-8383-41cce3632592€35.00€0.50matched
138capture01a19fd9-8ab4-7d0b-8a7a-58692e62e11d€49.00€0.67matched
139capture01a19fd9-8da1-78f2-836d-b905c649c8f3€49.00€0.67matched
140capture01a19fd9-7b34-7590-9ea1-e57e9cfa07fb€9.00€0.19matched