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

6 Nov, 05:20

Gross

€3,418.00

PSP fee

€52.40

Net to the bank

€3,365.60

Settlement journal

#410521

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1af4f-f5a8-7c2a-8880-c599bda08e89 is already settled by stl_EUR_2989904 line 51
  • duplicate linethe file lists it twicecapture:01a1af54-95b4-7c1d-80fe-e6584d2e7a29 is already settled by stl_EUR_2989904 line 124
  • fee differencethe fee is not the contract feethe fee is 31, the contract says 26
  • missing linein the books, not in the filecapture:01a1af4f-bbee-7e90-89c9-d66d7fc762dd is in no file
  • missing linein the books, not in the filerefund:01a1af55-92f4-7678-9028-336e69b00948 is in no file
LineKindReferenceGrossFeeStatus
52capture01a1af4f-f5cf-73c1-abd6-5b3dc5ce382d€35.00€0.50duplicate line
54capture01a1af50-0eaa-742f-87df-3a38e4a0865e€15.00€0.31fee difference
125capture01a1af54-95fe-7deb-afea-0f53817c4350€9.00€0.19duplicate line
1capture01a1af45-30e3-70f3-ab78-35fd7ff14ed8€24.00€0.37matched
2capture01a1af4c-ae6e-7904-8678-61ae01746eb8€49.00€0.67matched
3capture01a1af4c-c7e1-7902-bcfe-e5f5e30ef7c6€49.00€0.67matched
4capture01a1af4c-ccf6-7712-9c10-ba9796e3052c€9.00€0.19matched
5capture01a1af4c-d224-712f-8d96-ec879cfd2f37€24.00€0.37matched
6capture01a1af4c-ebdb-786a-9480-daf9d0423d64€15.00€0.26matched
7capture01a1af4c-ee78-7215-a137-652ac3519588€49.00€0.67matched
8capture01a1af4d-29df-78d9-9aa5-ced93f026e97€9.00€0.19matched
9capture01a1af4d-2f09-7663-a75e-3beaf4df17fb€9.00€0.19matched
10capture01a1af4d-6761-7d40-a5d6-35317e08b424€24.00€0.37matched
11capture01a1af4d-9a93-7e0c-bd2a-837585ae9423€9.00€0.19matched
12capture01a1af4d-ac42-78a9-b685-cf7a2a6206aa€35.00€0.50matched
13capture01a1af4d-b1b2-724b-ad1c-7263a73761ec€24.00€0.37matched
14capture01a1af4d-b7bf-7462-b1f8-e998438041bb€35.00€0.50matched
15capture01a1af4d-bb09-781f-99ce-8deb3ca72105€35.00€0.50matched
16capture01a1af4d-ea00-7989-a3f3-bce4c4e3f4c8€49.00€0.67matched
17capture01a1af4d-f891-79d7-a24d-a329c4a7ded5€35.00€0.50matched
18capture01a1af4e-058c-74aa-a93c-4bd00e6f9cb6€35.00€0.50matched
19capture01a1af4e-137b-7f8a-bc1d-27f3e17bf648€15.00€0.26matched
20capture01a1af4e-2377-7db9-8856-b8ca73804b16€15.00€0.26matched
21capture01a1af4e-3ee1-7670-b78e-88a118de2a79€49.00€0.67matched
22capture01a1af4e-4b7f-727e-a846-9c1d67cb424b€49.00€0.67matched
23capture01a1af4e-5c24-78ae-aa8b-28092bce67f3€15.00€0.26matched
24capture01a1af4e-7406-774c-9940-876cab84a0e5€24.00€0.37matched
25capture01a1af4e-742a-7620-907c-3c663147cb8a€24.00€0.37matched
26capture01a1af4e-857c-7ce5-ba5c-79f9be647587€24.00€0.37matched
27capture01a1af4e-89ad-752f-b7e9-389584fe2cd2€15.00€0.26matched
28capture01a1af4e-9601-75df-b961-c83c078bd999€35.00€0.50matched
29refund01a1af4e-9c67-750a-8978-876d8ab4a214-€9.00€0.00matched
30capture01a1af4e-a0d5-7500-ac9b-ec3cc9f3c41a€15.00€0.26matched
31capture01a1af4e-a17b-70ef-85f5-0f60f393dc5a€49.00€0.67matched
32capture01a1af4e-e2ca-70b3-81ae-44fda9d72823€9.00€0.19matched
33capture01a1af4e-fac5-727d-838a-b2d38a943da7€24.00€0.37matched
34capture01a1af4f-0434-718b-8e78-a962cf40f20a€35.00€0.50matched
35capture01a1af4f-0a80-7e95-9654-572dd298f817€15.00€0.26matched
36capture01a1af4f-4e66-72e6-8b9c-0036df47b8dd€49.00€0.67matched
37capture01a1af4f-5178-77b6-b61b-823914ded41a€35.00€0.50matched
38capture01a1af4f-5a9a-74e2-8150-f75b8b35f528€24.00€0.37matched
39capture01a1af4f-5df5-7d9f-9e8f-ff6b98d75602€24.00€0.37matched
40capture01a1af4f-5f6a-7675-bb79-e7c9f5d5f868€24.00€0.37matched
41capture01a1af4f-7544-7d54-a39c-b4c915e5d1a2€15.00€0.26matched
42capture01a1af4f-7e31-7841-99b9-8032136d0318€35.00€0.50matched
43refund01a1af4f-82f8-7a94-bf06-654017f9bcdb-€6.00€0.00matched
44capture01a1af4f-94a2-7fa1-abae-da6ff635df4e€9.00€0.19matched
45capture01a1af4f-96f5-7383-951e-7431fe85296d€49.00€0.67matched
46capture01a1af4f-9cf7-7eb1-81fa-96124fa05dd9€15.00€0.26matched
47capture01a1af4f-9d52-7374-a5a6-1fdfbe4ae3d6€24.00€0.37matched
48capture01a1af4f-adfb-72f6-a2e6-05f7997ad0d0€49.00€0.67matched
49refund01a1af4f-b263-730b-a297-04f15630b56b-€4.00€0.00matched
50capture01a1af4f-ea35-7d9e-9428-cff541658f8b€49.00€0.67matched
51capture01a1af4f-f5cf-73c1-abd6-5b3dc5ce382d€35.00€0.50matched
53capture01a1af50-0c9d-7d53-b894-9ea1d8ea5265€15.00€0.26matched
55capture01a1af50-1d13-79db-866b-4d081056d536€15.00€0.26matched
56capture01a1af50-4ca8-7d54-aed1-0407b4757a63€9.00€0.19matched
57capture01a1af50-6731-7811-82b8-49d4ddc95b85€15.00€0.26matched
58capture01a1af50-7869-7dfc-9765-bd0259fe030d€35.00€0.50matched
59capture01a1af50-9029-768b-a13c-68e8ec2f6b70€24.00€0.37matched
60capture01a1af50-a368-7932-a1be-95f50787f4ca€24.00€0.37matched
61capture01a1af50-aaae-7e7b-b8bf-f7d1591e2a77€35.00€0.50matched
62capture01a1af50-c67d-72d3-b261-17364f88aa7f€9.00€0.19matched
63capture01a1af50-d0c7-706e-901f-2be5d1648da7€35.00€0.50matched
64capture01a1af50-d4b3-7dc8-8eb8-dbb0076af138€9.00€0.19matched
65capture01a1af50-d799-7087-81e8-2e07e3e06407€49.00€0.67matched
66capture01a1af50-de75-7409-90c5-473749d856ab€9.00€0.19matched
67capture01a1af50-e2af-769c-b7d0-898042593702€49.00€0.67matched
68capture01a1af50-ed26-71b0-8c95-f712d01fc426€9.00€0.19matched
69capture01a1af50-eeef-7523-8f1c-c9cf16b35b11€49.00€0.67matched
70capture01a1af50-effd-768c-ab5d-ff1a60fb06dd€24.00€0.37matched
71capture01a1af50-f17a-7740-b142-7726e197f8b0€35.00€0.50matched
72refund01a1af50-fdcd-7403-928d-9387c8bc589a-€8.00€0.00matched
73capture01a1af51-1e22-755b-8920-c460a3727f1b€35.00€0.50matched
74capture01a1af51-2370-75d8-ad04-24497d243897€35.00€0.50matched
75capture01a1af51-2daa-7926-98ff-740102867b00€49.00€0.67matched
76capture01a1af51-4848-7e38-a1de-bcb52ff0fa90€24.00€0.37matched
77capture01a1af51-5957-7b94-816e-bb911a40f982€35.00€0.50matched
78capture01a1af51-6575-7f44-aca8-ae5b51094102€24.00€0.37matched
79capture01a1af51-ada8-7db5-bc4b-df7f76a332ed€49.00€0.67matched
80capture01a1af51-afa0-774b-a81f-3cc8141df0c4€35.00€0.50matched
81capture01a1af51-b329-7054-8ab7-290d75e506ee€24.00€0.37matched
82capture01a1af51-e147-7338-892e-a6c3d4168bb7€15.00€0.26matched
83capture01a1af51-e5ee-749a-9b14-79ec8a91ec8b€15.00€0.26matched
84capture01a1af52-0762-7fa2-9ff3-fdf102eec08f€15.00€0.26matched
85capture01a1af52-19c8-7fa3-93e6-891698b494f2€9.00€0.19matched
86capture01a1af52-40e9-7a9f-9be6-3be552bf1d6e€35.00€0.50matched
87capture01a1af52-6eb7-7911-98fc-44d3de9510cb€35.00€0.50matched
88capture01a1af52-7acf-7162-b235-14264604b57c€49.00€0.67matched
89capture01a1af52-8ffe-7441-8267-cd6a8d6f382e€35.00€0.50matched
90capture01a1af52-9539-72cc-98f3-0fe8d0cf67b2€15.00€0.26matched
91capture01a1af52-9aae-7fac-ac6f-87e43f998404€15.00€0.26matched
92capture01a1af52-c2c6-7c34-996a-b7d1ae1460cd€9.00€0.19matched
93capture01a1af52-c5f9-7010-a904-d98ec2b1ae3c€15.00€0.26matched
94capture01a1af52-d329-7570-a219-541359b4b8f6€49.00€0.67matched
95capture01a1af52-d96e-7dcd-9da4-60a9a119f3d1€35.00€0.50matched
96capture01a1af52-dced-7953-9a03-016b48c09b5d€24.00€0.37matched
97capture01a1af52-e9fa-70d9-906e-cedf3853aaf9€35.00€0.50matched
98capture01a1af52-eb63-74ea-8ace-5c618b6da8d2€9.00€0.19matched
99capture01a1af52-f43d-7062-9fb9-8cee5feab77b€9.00€0.19matched
100capture01a1af52-fa2a-79c1-919a-7e7ece6e5783€9.00€0.19matched
101capture01a1af53-07df-72ca-8440-aa76fc73ba44€15.00€0.26matched
102capture01a1af53-2086-73a8-a13d-bf6b69835665€24.00€0.37matched
103capture01a1af53-22be-79fa-91ea-338e584ffa7d€24.00€0.37matched
104refund01a1af53-252d-7368-b708-7deb81067c17-€19.00€0.00matched
105capture01a1af53-651e-790f-aca9-792f1e2fbc6a€9.00€0.19matched
106capture01a1af53-7ba2-759c-b8ba-a8b66382a601€35.00€0.50matched
107capture01a1af53-7ffc-730f-99db-66e615542fcd€9.00€0.19matched
108capture01a1af53-9e61-799f-8bc5-4dc5452b500f€35.00€0.50matched
109capture01a1af53-a275-763b-ab51-37940a076f81€15.00€0.26matched
110capture01a1af53-b6d2-785b-afb9-17afd2abb272€24.00€0.37matched
111capture01a1af53-bf99-7dbc-aaed-a1757798e0ed€35.00€0.50matched
112capture01a1af53-c481-71ec-8441-e1fb8cdd42a1€9.00€0.19matched
113capture01a1af53-ee8f-77cb-b2b2-7977370d4bb7€9.00€0.19matched
114capture01a1af53-ef6e-729a-8d64-49215a56254b€9.00€0.19matched
115capture01a1af54-03ee-772f-953a-deea0da97ff4€35.00€0.50matched
116capture01a1af54-1084-7699-b6b3-a5388b11df9c€24.00€0.37matched
117capture01a1af54-2cf2-7cb5-ba9b-1981218a2207€35.00€0.50matched
118capture01a1af54-2fd7-74bd-9251-47abd1efd8c9€35.00€0.50matched
119capture01a1af54-3cf3-7641-8d95-49e22744cfa0€49.00€0.67matched
120capture01a1af54-5ef2-7799-98d9-bd5a62f5cc4c€35.00€0.50matched
121capture01a1af54-6316-74ed-b5db-46f9342a364b€49.00€0.67matched
122capture01a1af54-6698-784a-b0c1-685bc07f215b€15.00€0.26matched
123capture01a1af54-8db0-766a-852c-56679044e9cd€15.00€0.26matched
124capture01a1af54-95fe-7deb-afea-0f53817c4350€9.00€0.19matched
126capture01a1af54-965f-7958-845d-2f9aafa8dfc4€9.00€0.19matched
127capture01a1af54-97ca-791e-8ccb-f46e1716a7bc€15.00€0.26matched
128capture01a1af54-a7c5-7e78-a4d3-4c74b5160094€49.00€0.67matched
129capture01a1af54-e207-7d1a-96d5-1d65b8530a84€24.00€0.37matched
130capture01a1af54-f388-7084-baf7-243ac874e718€35.00€0.50matched
131capture01a1af54-fa59-74af-82fa-43ad7542c4cd€35.00€0.50matched
132capture01a1af55-280d-7710-b384-784141170ceb€15.00€0.26matched
133capture01a1af55-52ee-73ce-bb5c-e774fe9f44a0€9.00€0.19matched
134capture01a1af55-7333-77d7-a0c7-b2e21ef6c3fc€35.00€0.50matched
135capture01a1af55-81ce-762f-b185-b1aa7ad7c071€15.00€0.26matched
136capture01a1af55-a48a-7a01-bdec-e1da6ba4b49b€24.00€0.37matched
137capture01a1af55-bd0c-7443-950c-de3a964600bf€15.00€0.26matched
138capture01a1af55-d181-740f-8028-c3418e37f5e8€15.00€0.26matched