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, 02:00

Gross

€3,344.00

PSP fee

€54.76

Net to the bank

€3,289.24

Settlement journal

#353204

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19f25-2e94-77ac-85e6-af5bb621f977 is already settled by stl_EUR_2989452 line 45
  • duplicate linethe file lists it twicecapture:01a19f27-d718-7a8b-8f87-0765dbdc0bf1 is already settled by stl_EUR_2989452 line 89
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 30, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
LineKindReferenceGrossFeeStatus
12capture01a19f23-5509-7d70-9f5e-0c5e89ce627c€35.00€0.52fee difference
46capture01a19f25-2ea7-7f3c-a449-86a14c5ddcb7€9.00€0.19duplicate line
58capture01a19f25-7edd-7ec2-b606-bea55ea3dce6€15.00€0.30fee difference
59capture01a19f25-875c-704f-9ec1-10469b089caf€9.00€0.23fee difference
90capture01a19f27-d72f-7f00-819e-801c87387048€49.00€0.67duplicate line
136capture01a19f2a-437d-7869-b309-24d6064fa0c5€15.00€0.29fee difference
141capture01a19f2a-892d-7845-850b-99f8f112e541€49.00€0.72fee difference
1capture01a19f1c-db01-7c32-984b-7347dfbc7176€49.00€0.67matched
2capture01a19f22-a244-704d-b387-0161376c51cd€24.00€0.37matched
3capture01a19f22-bab5-7bdc-80ab-c4b06d445a4a€9.00€0.19matched
4capture01a19f22-eb38-71bc-9daf-de100a742860€24.00€0.37matched
5capture01a19f22-f306-76f8-80cf-437ba680d4b7€15.00€0.26matched
6capture01a19f23-04e6-76ef-8d3e-3781997e3943€15.00€0.26matched
7capture01a19f23-0888-762d-86ae-5198f19e641c€24.00€0.37matched
8capture01a19f23-0e33-7522-80e0-f2f522dd1835€24.00€0.37matched
9capture01a19f23-20e5-7fb0-995c-d64f5fc7a37b€9.00€0.19matched
10capture01a19f23-3e78-764c-8fd0-f7034362e9fb€24.00€0.37matched
11capture01a19f23-50b2-7f09-8eeb-6efed3279b3a€35.00€0.50matched
13capture01a19f23-67f3-7037-b988-a0e09fef6fa9€15.00€0.26matched
14capture01a19f23-7f02-7caa-aaf6-f2a40a493abf€24.00€0.37matched
15capture01a19f23-8e92-73aa-ad3b-2f05b862ea90€24.00€0.37matched
16capture01a19f23-90f7-732d-9659-8d8dc2a431e8€9.00€0.19matched
17capture01a19f23-a987-7c6e-86b0-6b43bcd61008€49.00€0.67matched
18capture01a19f23-b655-7830-addc-9fc7860eed4a€49.00€0.67matched
19capture01a19f23-bf1a-7545-aa1a-0663e28a43e3€24.00€0.37matched
20capture01a19f23-ccfd-7d5d-a5d5-fe160e5ac18e€9.00€0.19matched
21capture01a19f23-ceba-775d-8533-d94f32f96530€15.00€0.26matched
22capture01a19f23-d4ce-739a-94c8-c5a28b7aec79€24.00€0.37matched
23capture01a19f23-df46-76a9-8677-8b9c2b40e594€9.00€0.19matched
24capture01a19f23-f9ed-78c1-8fe8-441ff1ee2f6d€15.00€0.26matched
25capture01a19f24-02ec-7058-9362-7f9e12c6e7f0€15.00€0.26matched
26capture01a19f24-5b74-7474-a2b5-1e133f631637€49.00€0.67matched
27capture01a19f24-703b-709a-8f64-0ae43fa1da19€9.00€0.19matched
28capture01a19f24-7258-74b5-9b3b-0b979205f0c6€35.00€0.50matched
29capture01a19f24-7e54-794c-8c70-e6dee1fe646f€49.00€0.67matched
30refund01a19f24-8a1f-7bda-8ec9-e454ac625970-€42.00€0.00matched
31capture01a19f24-b5cd-735b-9fd7-59f346049a79€24.00€0.37matched
32capture01a19f24-ce10-7da1-a01d-89b882a60aa9€35.00€0.50matched
33capture01a19f24-ce35-7a81-b598-05494d7a2936€35.00€0.50matched
34capture01a19f24-d0c7-771b-a8f4-9c7d2e2c6bab€15.00€0.26matched
35capture01a19f24-d940-7c5b-ba73-da56af413417€9.00€0.19matched
36capture01a19f24-e3e1-77ac-a4ee-2a36cf853f8f€49.00€0.67matched
37capture01a19f25-0226-7080-8207-a7d3f8941c17€9.00€0.19matched
38capture01a19f25-04b9-7c06-b224-d862b01c32ef€9.00€0.19matched
39capture01a19f25-0577-794d-9a63-975216dbd02e€15.00€0.26matched
40capture01a19f25-06e2-7b12-ab7a-cac181204d95€49.00€0.67matched
41refund01a19f25-0dd9-7847-8ec6-941c27e0057e-€31.00€0.00matched
42capture01a19f25-0f4c-71b7-b40d-fc1f2df44d6e€24.00€0.37matched
43capture01a19f25-1304-7770-8c63-533472c7febd€49.00€0.67matched
44capture01a19f25-1560-71d8-ad8e-fc3a8b434b0b€24.00€0.37matched
45capture01a19f25-2ea7-7f3c-a449-86a14c5ddcb7€9.00€0.19matched
47capture01a19f25-3929-7809-90f8-f1fb826d0cc3€9.00€0.19matched
48capture01a19f25-43dd-7027-b1ad-c33f1c217fc4€24.00€0.37matched
49capture01a19f25-4528-708e-ac15-bb7ea5d16f31€49.00€0.67matched
50capture01a19f25-452f-77b8-8bab-fecfd76731b2€15.00€0.26matched
51capture01a19f25-46ab-702f-a31a-3c0ef03dc497€9.00€0.19matched
52capture01a19f25-5dbf-7fca-bec2-2a50a0bcc19a€35.00€0.50matched
53refund01a19f25-66fb-765c-8d2d-d4975795f333-€25.00€0.00matched
54capture01a19f25-6f74-7f5b-a93c-d8cca10cfa3d€24.00€0.37matched
55capture01a19f25-743f-7c13-9192-a1350b05bb82€35.00€0.50matched
56capture01a19f25-75cb-77ca-bceb-261a5598dc4a€15.00€0.26matched
57capture01a19f25-7e2b-7b5a-ae73-029540a8b1a0€15.00€0.26matched
60capture01a19f25-97a8-7b91-a484-7e75e23efdac€24.00€0.37matched
61capture01a19f25-99fa-721c-9006-c3ff53d7a498€24.00€0.37matched
62refund01a19f25-b4ec-7b82-a56d-2b68371510a8-€5.00€0.00matched
63capture01a19f25-cff9-77d9-b67f-68924be8fcc3€15.00€0.26matched
64capture01a19f25-e762-7906-b061-ba63ca026adb€49.00€0.67matched
65capture01a19f25-f650-7560-864b-07b3b86421b3€35.00€0.50matched
66capture01a19f25-fa27-7ba0-a396-c9851def60c2€9.00€0.19matched
67capture01a19f26-3026-7c92-bdb3-412e16ec284d€15.00€0.26matched
68capture01a19f26-306b-715b-949a-1ad009f4d1e1€35.00€0.50matched
69capture01a19f26-5562-75e4-8f32-cc3a6c49ba5c€24.00€0.37matched
70capture01a19f26-7040-773f-8cd6-ed068d5209e6€15.00€0.26matched
71refund01a19f26-7514-7323-8042-545193850945-€10.00€0.00matched
72capture01a19f26-85eb-71d9-8522-2437e8c2e0da€24.00€0.37matched
73capture01a19f26-8f22-7f59-9dd0-2642851b68de€24.00€0.37matched
74capture01a19f26-9085-7c44-8008-6bd07199f0cb€24.00€0.37matched
75capture01a19f26-9ed2-7ccb-a7e7-f7e29eb0197d€35.00€0.50matched
76refund01a19f26-acc2-7198-8f51-cb6ce725ddba-€6.00€0.00matched
77capture01a19f26-af55-71be-9884-1e0f71cdae74€15.00€0.26matched
78capture01a19f26-bda6-71dd-b111-400f1995a893€24.00€0.37matched
79capture01a19f26-d120-7c35-ac06-051f91c689bf€15.00€0.26matched
80capture01a19f27-0fd6-7908-b71b-c502c22c58a1€49.00€0.67matched
81capture01a19f27-1c07-7594-a7a5-78943f517ad2€35.00€0.50matched
82capture01a19f27-1e44-7ab7-a26a-221d08f8ec4a€24.00€0.37matched
83capture01a19f27-3354-7fbb-90c1-2292a64781ed€35.00€0.50matched
84capture01a19f27-3ae0-721f-8af9-642c78fa4039€49.00€0.67matched
85capture01a19f27-515f-758e-9264-f32e235c56e1€15.00€0.26matched
86capture01a19f27-7114-7ebe-86fa-a812dc78d90c€15.00€0.26matched
87capture01a19f27-773f-7a22-8ecf-37a7eded2474€9.00€0.19matched
88refund01a19f27-8a7e-730d-8d53-fc7d95876ecd-€20.00€0.00matched
89capture01a19f27-d72f-7f00-819e-801c87387048€49.00€0.67matched
91capture01a19f27-e6a9-75eb-9177-a7c8ddd355b3€24.00€0.37matched
92capture01a19f27-eab3-7b78-8e88-71b9d3875d8c€15.00€0.26matched
93capture01a19f27-fcd7-7696-adb5-0f88a5559885€9.00€0.19matched
94capture01a19f28-016f-7257-b833-3a3294907105€24.00€0.37matched
95capture01a19f28-36de-7571-ada1-5e0c7cca3785€24.00€0.37matched
96capture01a19f28-5391-7cff-b476-15dbe306a057€15.00€0.26matched
97capture01a19f28-5dab-78d5-9d72-969832400832€24.00€0.37matched
98capture01a19f28-6f57-73ea-8594-29e1631d0ace€24.00€0.37matched
99capture01a19f28-8800-778e-b570-d85a68061c0b€24.00€0.37matched
100capture01a19f28-8950-703d-8e7e-5c46b3020ee3€9.00€0.19matched
101capture01a19f28-9024-72cc-bc6a-42153b7054ab€35.00€0.50matched
102capture01a19f28-912d-74ac-a42b-4a50393dc891€24.00€0.37matched
103capture01a19f28-97ff-7717-8b53-0db8e07c4067€35.00€0.50matched
104capture01a19f28-a718-7d57-9919-62243e4f6736€15.00€0.26matched
105refund01a19f28-b783-737c-8f0f-472918b37195-€12.00€0.00matched
106refund01a19f28-be9d-74a6-9281-3cc2f6c671cf-€18.00€0.00matched
107capture01a19f28-cfa0-77f7-a30c-ea48f63ac7bb€49.00€0.67matched
108capture01a19f28-d580-7efe-a593-4c3e8285ef94€9.00€0.19matched
109capture01a19f28-f316-7a98-8448-52043e265fc7€9.00€0.19matched
110capture01a19f28-f851-7d3c-8f03-e91c86da43df€9.00€0.19matched
111capture01a19f28-f8f1-7c63-b341-4c915b1045ec€35.00€0.50matched
112capture01a19f29-0755-7165-b3ad-d004a90bc9b1€15.00€0.26matched
113capture01a19f29-195b-7b57-ac8e-db9929711b84€35.00€0.50matched
114capture01a19f29-2d50-7f47-baab-bfcd8f8a7b83€15.00€0.26matched
115capture01a19f29-3197-7d83-a3fb-7b3639e7954a€49.00€0.67matched
116refund01a19f29-5053-797c-89b8-1777fa4d9429-€10.00€0.00matched
117capture01a19f29-5179-7ef9-bd21-2de1a5de720f€24.00€0.37matched
118capture01a19f29-564e-7fad-850a-3e1420b51d41€15.00€0.26matched
119capture01a19f29-6d24-7a3f-a2d8-cc6866ca64f9€9.00€0.19matched
120capture01a19f29-6f42-7e11-ae1e-2924e270e57b€35.00€0.50matched
121capture01a19f29-79ff-7419-8fa4-c48032f9bc0d€35.00€0.50matched
122capture01a19f29-7ae3-756b-ade6-ecdef94eb517€35.00€0.50matched
123capture01a19f29-84a8-782c-b7b7-4d8508c1793b€15.00€0.26matched
124capture01a19f29-8caf-7010-b41d-0daaada3c755€24.00€0.37matched
125capture01a19f29-91e1-7812-a268-60aef1f1e489€15.00€0.26matched
126capture01a19f29-a58b-7a34-b023-fd35a17df8bc€24.00€0.37matched
127capture01a19f29-df1a-71b4-b6cd-baf3f1e58ab2€9.00€0.19matched
128refund01a19f29-e0cc-7007-bf58-bb14eed5ad2a-€8.00€0.00matched
129refund01a19f29-f7dd-7b59-8e13-e84488faf163-€10.00€0.00matched
130capture01a19f2a-035c-731f-93ee-81991300200e€35.00€0.50matched
131capture01a19f2a-0a2e-7fc4-8198-64dbc9d4ba72€24.00€0.37matched
132capture01a19f2a-16e9-720f-9c3a-b8faa516c655€15.00€0.26matched
133capture01a19f2a-172f-75eb-bd33-0f2c78f5a97a€9.00€0.19matched
134capture01a19f2a-2a14-758e-8e16-f031a7707a2c€49.00€0.67matched
135capture01a19f2a-3998-71c8-a79b-a5f9b5539f44€24.00€0.37matched
137capture01a19f2a-6527-7f99-82fc-aa67f7f93512€9.00€0.19matched
138capture01a19f2a-74bb-7e43-970d-330989598fcf€35.00€0.50matched
139capture01a19f2a-75f3-7d4a-b706-dff5e43437ec€9.00€0.19matched
140refund01a19f2a-85e3-7737-ae5c-12558c2f5ff9-€16.00€0.00matched
142capture01a19f2a-8f88-7a24-90ef-ff5de066c437€49.00€0.67matched
143capture01a19f2a-949f-7d95-81fc-fd19fd4a8490€35.00€0.50matched
144capture01a19f2a-9bcb-774f-adbe-40010d2164bc€9.00€0.19matched
145capture01a19f2a-9f02-71fe-8cef-1a3858279a3c€15.00€0.26matched
146capture01a19f2a-a228-750d-bebf-03f0c59fe06b€49.00€0.67matched
147capture01a19f2a-a633-7f53-a23e-42743f90eebf€15.00€0.26matched
148capture01a19f2a-b5b2-7d2a-9b2d-390ffefa2981€15.00€0.26matched
149capture01a19f2a-dbc6-7c64-ae6f-2475ba315f55€24.00€0.37matched
150refund01a19f2a-ebed-737f-b64a-06cb4068f1de-€10.00€0.00matched
151capture01a19f2a-f7e2-7c4e-b9e5-a2747c5ac093€49.00€0.67matched
152capture01a19f2b-3522-7686-9de5-9e2c78317f70€24.00€0.37matched
153capture01a19f2b-38eb-7c32-a193-5e31097f792e€35.00€0.50matched
154capture01a19f2b-40bc-7616-b884-6ec5dc00a9b8€35.00€0.50matched
155capture01a19f2b-3d70-7a4e-a3da-e743773e8e55€49.00€0.67matched
156capture01a19f2b-5071-7eea-8d47-5e18da1e6e48€9.00€0.19matched
157capture01a19f2b-5136-7598-951d-f1ba65955247€9.00€0.19matched
158capture01a19f2b-83d5-7d2a-ac15-fe16fae4d6c0€9.00€0.19matched
159capture01a19f2b-96a7-7c1b-81e5-196c33e8d51b€35.00€0.50matched