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

2 Nov, 05:00

Gross

€2,829.00

PSP fee

€44.18

Net to the bank

€2,784.82

Settlement journal

#337132

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a19aa9-43ea-775e-90dc-bfc43ba2024a is already settled by stl_EUR_2989326 line 103
  • fee differencethe fee is not the contract feethe fee is 28, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
  • 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 68, the contract says 67
  • missing linein the books, not in the filecapture:01a19aa0-e4ef-75c1-8f38-bc647e363c6e is in no file
LineKindReferenceGrossFeeStatus
15capture01a19aa2-0d7e-7197-8d14-5d38c45505e9€15.00€0.28fee difference
28capture01a19aa3-34f2-78eb-9558-a2f58130480a€9.00€0.20fee difference
91capture01a19aa8-65e4-7644-8a93-4c2bc84c130e€35.00€0.52fee difference
104refund01a19aa9-43ed-7b55-8818-a6c062d73d2f-€9.00€0.00duplicate line
115capture01a19aa9-d8a9-7816-95c2-f560bc2046e8€49.00€0.68fee difference
1capture01a19a97-e609-7420-9398-f20ea828027c€9.00€0.19matched
2capture01a19a9e-cc25-7943-9a33-bfe8ae26ca37€24.00€0.37matched
3capture01a19a9f-453e-7c9d-9f63-ae0ecf20b11d€15.00€0.26matched
4capture01a19aa0-ec75-795a-80bf-563ac47e1ad4€9.00€0.19matched
5capture01a19aa1-0833-779c-bf62-9c9421529bf9€9.00€0.19matched
6capture01a19aa1-192f-7ccc-b754-db9e7511ce83€9.00€0.19matched
7capture01a19aa1-2792-7197-904c-21186d931b76€24.00€0.37matched
8capture01a19aa1-790c-7d7c-aefa-e28c1e927319€15.00€0.26matched
9capture01a19aa1-7fdc-71c7-8480-8333320c4428€35.00€0.50matched
10capture01a19aa1-9567-758f-9430-19306e40d087€9.00€0.19matched
11capture01a19aa1-b045-7e31-99ee-fbd1f3a14eb4€15.00€0.26matched
12capture01a19aa1-e28d-77de-b5fb-95407e1ec7cc€49.00€0.67matched
13capture01a19aa1-ea49-7358-a9d7-a35343fbbbb1€24.00€0.37matched
14capture01a19aa2-0146-75ef-859e-238350b838c5€35.00€0.50matched
16capture01a19aa2-31d3-7054-8888-1b3544416cdf€9.00€0.19matched
17capture01a19aa2-41ba-7cd1-9ed6-d47dc1145130€15.00€0.26matched
18capture01a19aa2-7015-7c46-937d-60c9a3561a0a€35.00€0.50matched
19capture01a19aa2-80b2-72e7-a568-2fcbd756e528€35.00€0.50matched
20capture01a19aa2-7b4e-7192-ad81-120f061c03a6€24.00€0.37matched
21capture01a19aa2-97f3-7f2c-9811-6ba024a938d2€15.00€0.26matched
22capture01a19aa2-d867-7aad-9a6a-fc17ef7468d6€15.00€0.26matched
23capture01a19aa2-e460-7992-8502-db0a503d5683€35.00€0.50matched
24refund01a19aa2-ede3-7947-9784-be0d4de2ed23-€26.00€0.00matched
25capture01a19aa2-f738-7502-909c-3dff825fd8fd€49.00€0.67matched
26capture01a19aa2-fb85-7fa0-883a-60605ba8de20€35.00€0.50matched
27capture01a19aa3-1f79-7f09-a50e-99c2399d802e€15.00€0.26matched
29capture01a19aa3-427c-7ff7-be81-d0baeb02484b€9.00€0.19matched
30capture01a19aa3-54f6-75e0-84e6-fce20d37ba79€35.00€0.50matched
31capture01a19aa3-63ce-7171-bbd7-b2d35a59b464€49.00€0.67matched
32capture01a19aa3-6b4a-76db-b832-bd7242e392bf€49.00€0.67matched
33capture01a19aa3-8d82-7c41-9f3b-95faf2f50d44€24.00€0.37matched
34refund01a19aa3-93e6-7684-b2ab-60e79f6fb5e1-€7.00€0.00matched
35capture01a19aa3-a2be-7e8e-9b80-3a176f6143e8€49.00€0.67matched
36capture01a19aa3-b0d6-703d-938c-2c6149f5a0c5€15.00€0.26matched
37capture01a19aa3-b592-70d6-b66e-33b54e1a9f61€35.00€0.50matched
38capture01a19aa3-c7d2-739e-b492-5fbbbfae26f5€9.00€0.19matched
39capture01a19aa4-32af-7bb5-9144-8ca29761ac47€49.00€0.67matched
40capture01a19aa4-37af-73a1-9427-f34e2773f906€35.00€0.50matched
41capture01a19aa4-385b-7927-aacf-341ea26f31ef€49.00€0.67matched
42capture01a19aa4-387d-707d-911c-a458ddfaf12e€35.00€0.50matched
43refund01a19aa4-7575-7c09-919e-6e920347f08f-€12.00€0.00matched
44capture01a19aa4-7911-7402-b3a5-5c208f3285bf€9.00€0.19matched
45capture01a19aa4-7a2e-78b4-8ccd-4a5347a1791c€35.00€0.50matched
46capture01a19aa4-9486-7bf5-80bb-1e13cd7448ac€15.00€0.26matched
47capture01a19aa4-9c01-7e39-9782-3cd81830e732€24.00€0.37matched
48capture01a19aa4-bc22-7148-9d71-a9955672d135€24.00€0.37matched
49capture01a19aa4-e525-7dc1-af8a-c1b238eff5ec€9.00€0.19matched
50capture01a19aa5-120d-7093-9f66-db5de37cd106€24.00€0.37matched
51capture01a19aa5-2f27-7696-b3fb-81ae622b93e9€15.00€0.26matched
52capture01a19aa5-4064-79fc-941a-beaeff5d758c€9.00€0.19matched
53capture01a19aa5-60d8-7c6e-b60e-356c8e8d777b€35.00€0.50matched
54capture01a19aa5-978a-7251-b9f8-e6a717fd33b2€15.00€0.26matched
55capture01a19aa5-acc3-74db-a6b8-d17d5aec54b9€35.00€0.50matched
56capture01a19aa5-b57b-7278-80a0-600336889585€9.00€0.19matched
57capture01a19aa5-c16e-7e42-9902-0724c39a562a€24.00€0.37matched
58capture01a19aa5-c7da-71b9-a7d6-6014be179495€49.00€0.67matched
59capture01a19aa5-fdae-7400-935f-80b91c710ffb€15.00€0.26matched
60capture01a19aa5-fef3-7fb7-bcdb-9bf91f78e73d€49.00€0.67matched
61capture01a19aa6-042b-70b6-ba8b-1c1bac074402€35.00€0.50matched
62capture01a19aa6-067c-736e-9e63-b2bd991d5d19€49.00€0.67matched
63capture01a19aa6-0702-7c8e-b7de-c0842c5ee4ba€9.00€0.19matched
64capture01a19aa6-19e8-7c7e-b51f-33f57116dac5€15.00€0.26matched
65capture01a19aa6-2578-7db8-ac4a-4c2fd0c089e4€49.00€0.67matched
66capture01a19aa6-2ce4-7df9-9342-5658730485b3€35.00€0.50matched
67capture01a19aa6-39ee-7e62-abaf-8b986ca89ad5€49.00€0.67matched
68capture01a19aa6-4d0c-76b8-8db9-0b103a5af085€9.00€0.19matched
69capture01a19aa6-a0a6-73e6-8aeb-4cc931c06010€15.00€0.26matched
70capture01a19aa6-b5b5-76e0-b9fd-789b27af130b€35.00€0.50matched
71capture01a19aa6-f251-7993-8dd0-15a0e77ee442€35.00€0.50matched
72capture01a19aa6-f4c2-7903-b733-4a29619e49a5€24.00€0.37matched
73capture01a19aa7-2007-7202-9512-b7f85d05a9ab€15.00€0.26matched
74capture01a19aa7-2e57-784f-8064-757ee2ac2a73€15.00€0.26matched
75capture01a19aa7-691a-7ebe-b70b-6fc14615d4a4€35.00€0.50matched
76capture01a19aa7-6c9e-77f9-8799-5be22cc43bd1€49.00€0.67matched
77capture01a19aa7-6f52-7e73-974e-3b535cdf450c€35.00€0.50matched
78capture01a19aa7-80c6-7cdb-a43f-34f97c9591dc€24.00€0.37matched
79capture01a19aa7-a306-7bb9-b45b-f10f4be9cfef€9.00€0.19matched
80capture01a19aa7-a5e1-7ca9-849e-2155e0bce69d€9.00€0.19matched
81capture01a19aa7-d625-70cc-8a78-361f3470e364€49.00€0.67matched
82capture01a19aa7-edeb-7307-a9e0-d5744b700581€49.00€0.67matched
83capture01a19aa7-f6b9-7237-8fd4-a81251ff3869€35.00€0.50matched
84capture01a19aa7-f913-73a5-b358-7cb6413c3ecb€24.00€0.37matched
85capture01a19aa7-f94a-7378-9494-aa1fea6d665e€15.00€0.26matched
86capture01a19aa8-0147-7c5e-88b4-a7214a143bd4€35.00€0.50matched
87capture01a19aa8-1df6-773d-bfb0-985ef90b4891€49.00€0.67matched
88capture01a19aa8-1f2f-7aaa-bf16-b750d4e7a3b8€15.00€0.26matched
89capture01a19aa8-2aaf-740e-9bbb-0b2f52164207€35.00€0.50matched
90refund01a19aa8-3855-77ab-b3b6-e18c78cc1dd9-€29.00€0.00matched
92capture01a19aa8-6774-7501-919e-1e81d584ba48€49.00€0.67matched
93capture01a19aa8-c139-7fd6-9846-adeab235894d€35.00€0.50matched
94capture01a19aa8-dad4-7e72-9b26-bd769efb0e39€9.00€0.19matched
95capture01a19aa8-db6e-737e-8b4d-45d932cea279€9.00€0.19matched
96capture01a19aa8-e6af-7c8f-8d0f-01d03b7d9072€15.00€0.26matched
97capture01a19aa9-0f70-70e9-a5e1-8d9b467a55d2€49.00€0.67matched
98capture01a19aa9-10e2-733e-83a0-9f40d24721ea€35.00€0.50matched
99capture01a19aa9-36a9-7c39-be1e-df8420267266€15.00€0.26matched
100capture01a19aa9-3da7-769e-801a-cb08ab5c7c22€35.00€0.50matched
101refund01a19aa9-3f65-7fdf-8568-1ed9bdec074f-€8.00€0.00matched
102capture01a19aa9-4229-7b0d-bd3d-3800c26679f9€49.00€0.67matched
103refund01a19aa9-43ed-7b55-8818-a6c062d73d2f-€9.00€0.00matched
105capture01a19aa9-4b4d-7667-8de7-4cbab64bef8c€49.00€0.67matched
106capture01a19aa9-5433-7ef2-b89e-404d82f9a26a€24.00€0.37matched
107capture01a19aa9-553e-74da-a6a5-5810895ec5cc€24.00€0.37matched
108capture01a19aa9-7641-7367-b6dc-9970ae3bfc45€49.00€0.67matched
109capture01a19aa9-9054-7e12-b0d7-ebe03c2af85c€49.00€0.67matched
110refund01a19aa9-9585-790e-955d-ba73c8c5b6b3-€11.00€0.00matched
111capture01a19aa9-96f1-7d68-ae35-533857e440f7€9.00€0.19matched
112capture01a19aa9-9ae3-726e-af36-cd1f29510b82€15.00€0.26matched
113capture01a19aa9-a257-7347-9088-989db0bb678b€9.00€0.19matched
114capture01a19aa9-baf4-79d4-82cc-7a8d79d3f8e7€24.00€0.37matched
116capture01a19aa9-d5f8-7f37-b8f1-c904e3340b7e€15.00€0.26matched
117capture01a19aa9-ef97-70a1-9b73-d6cc2135a239€9.00€0.19matched