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

Gross

€2,493.00

PSP fee

€39.34

Net to the bank

€2,453.66

Settlement journal

#345495

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19d00-9816-7ab2-80a0-ca3af52be452 is already settled by stl_EUR_2989392 line 45
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
LineKindReferenceGrossFeeStatus
46capture01a19d00-9835-7a13-b7a8-5e25df8a4a64€35.00€0.50duplicate line
89capture01a19d04-49ab-7bc9-9734-10f128ad3118€15.00€0.29fee difference
1capture01a19cfd-466d-7134-849b-1727c7b20f2d€49.00€0.67matched
2capture01a19cfd-4e89-769e-a8ee-65ecbda3002a€15.00€0.26matched
3capture01a19cfd-646a-7f14-80a4-ac4054566a34€15.00€0.26matched
4capture01a19cfd-6b10-7623-b64a-f3169c3943c3€24.00€0.37matched
5capture01a19cfd-8f11-70e1-950f-14b6d9a9613f€24.00€0.37matched
6refund01a19cfd-a168-7684-bc5c-56367f1a4ac5-€41.00€0.00matched
7capture01a19cfd-c4e5-76fc-900a-7ef9c74421c7€49.00€0.67matched
8capture01a19cfd-d13b-7228-9f1a-6e63eb8d9fe1€9.00€0.19matched
9capture01a19cfe-18f3-7f83-813d-624b1241792a€9.00€0.19matched
10capture01a19cfe-1ba1-78b6-9207-0b6b39e47a43€9.00€0.19matched
11capture01a19cfe-24d8-793b-9104-afdfec59ec0f€35.00€0.50matched
12capture01a19cfe-2a7f-76ed-8a13-5a319d32d7cb€49.00€0.67matched
13refund01a19cfe-5f5f-758f-9188-23cdd0cc8de0-€4.00€0.00matched
14capture01a19cfe-6d60-7116-838c-18122caa2136€9.00€0.19matched
15refund01a19cfe-762f-72ce-a671-064bcef7da75-€8.00€0.00matched
16capture01a19cfe-76e7-717d-a349-36dcc872924a€9.00€0.19matched
17capture01a19cfe-81c2-7f91-9ac8-97b3588f4fdc€15.00€0.26matched
18capture01a19cfe-92c8-7ead-9bc1-bd68b711b40f€15.00€0.26matched
19capture01a19cfe-933e-7a1b-998a-2166a5676e2d€35.00€0.50matched
20capture01a19cfe-9805-709a-9591-5a6119cf3ce7€15.00€0.26matched
21capture01a19cfe-a575-79b8-baf2-dc4af6c64a10€35.00€0.50matched
22capture01a19cfe-b358-74ae-b15b-08498bdfad6c€15.00€0.26matched
23capture01a19cfe-d18e-70fe-ae81-497b8ea87136€49.00€0.67matched
24capture01a19cfe-e09a-71a4-88aa-3d5ed4de6765€35.00€0.50matched
25capture01a19cfe-e7ef-7fa4-94e1-ae20de41874b€35.00€0.50matched
26refund01a19cfe-eee5-7449-b7a3-8762ad109f88-€5.00€0.00matched
27capture01a19cfe-f21a-70af-ad12-353e37f4bd54€35.00€0.50matched
28capture01a19cff-003a-7a2a-abe5-91d559126972€24.00€0.37matched
29capture01a19cff-11d9-7559-b010-6fc30bb90db2€24.00€0.37matched
30capture01a19cff-1302-7329-8f11-e8e974774b70€9.00€0.19matched
31capture01a19cff-4b9a-7a23-8260-c6684065371c€49.00€0.67matched
32capture01a19cff-645d-7055-b84f-0c46df2f32e4€9.00€0.19matched
33capture01a19cff-8c1c-70df-9c67-80ac555dea68€35.00€0.50matched
34capture01a19cff-8c29-7ccf-a536-20f54f937abc€24.00€0.37matched
35capture01a19cff-cfac-7cf7-88bb-d941cab31173€9.00€0.19matched
36capture01a19d00-0727-7a61-a628-46092948668d€35.00€0.50matched
37capture01a19d00-2039-7eaf-91c5-09669f47ddc8€49.00€0.67matched
38refund01a19d00-3326-7909-8eb5-cefb52a1a26a-€30.00€0.00matched
39capture01a19d00-4485-76cf-9f2d-bbdf50eca673€15.00€0.26matched
40refund01a19d00-4a58-7998-99f5-4b38e30af11e-€12.00€0.00matched
41refund01a19d00-6bd7-7238-b50b-33104e05393d-€3.00€0.00matched
42capture01a19d00-72fa-71fd-b96d-156730a61450€35.00€0.50matched
43capture01a19d00-7ea9-7ca0-95f6-680a08b3e42c€49.00€0.67matched
44capture01a19d00-842d-7aa6-9bb3-a5eff9f5400d€15.00€0.26matched
45capture01a19d00-9835-7a13-b7a8-5e25df8a4a64€35.00€0.50matched
47capture01a19d00-9d3d-7df8-a125-0d5e882c5e5c€35.00€0.50matched
48capture01a19d00-d1ae-7940-956d-a33f11cd27de€15.00€0.26matched
49capture01a19d00-d9e6-74f9-a385-b88ad88a5927€35.00€0.50matched
50capture01a19d00-f087-7a2c-a5c6-b2eb84c73973€24.00€0.37matched
51capture01a19d01-2bf1-7518-a75c-9a4d85eddce0€9.00€0.19matched
52capture01a19d01-70dc-7d1a-965c-dfd03f75eeff€24.00€0.37matched
53capture01a19d01-836f-7f16-8326-0f997606dd36€24.00€0.37matched
54capture01a19d01-920c-77e6-ab8b-51cf5efbf0ea€9.00€0.19matched
55capture01a19d01-996d-7e12-aa4a-64de3a27a4d9€9.00€0.19matched
56refund01a19d01-9fd9-7e46-85b2-8f8b55cc1de0-€19.00€0.00matched
57capture01a19d01-a624-7935-ab44-abedf127b551€9.00€0.19matched
58capture01a19d01-afa8-78ea-a8fa-9ef00c5b4598€24.00€0.37matched
59capture01a19d01-b46d-72c0-9a21-e69dfe56d383€9.00€0.19matched
60capture01a19d01-bad2-7ef0-8d63-6a11e9b928e6€35.00€0.50matched
61capture01a19d01-c91f-7811-9f85-8f8954cf67f4€35.00€0.50matched
62capture01a19d01-d626-7e4a-aa68-27720bee95b4€15.00€0.26matched
63capture01a19d01-e0d6-7204-9de3-31c3fc6d5461€24.00€0.37matched
64refund01a19d01-f765-7731-b45c-d7ee2fcd5bee-€9.00€0.00matched
65capture01a19d02-0645-717a-b17f-22062045a029€15.00€0.26matched
66capture01a19d02-1bd1-7be4-8410-85fdf991efb7€35.00€0.50matched
67capture01a19d02-55e4-7165-9ff4-0000f83510aa€35.00€0.50matched
68capture01a19d02-585a-7b43-bfdd-721f2addf563€24.00€0.37matched
69capture01a19d02-7823-7dce-ae87-2763a8a38631€49.00€0.67matched
70capture01a19d02-90e2-7d79-a9fc-a067d6f64832€35.00€0.50matched
71capture01a19d02-b06e-7165-8e95-ccb5bf8f2272€24.00€0.37matched
72capture01a19d02-b165-79ea-92fc-6e2f5f09cdd7€9.00€0.19matched
73capture01a19d02-bd88-7b53-ac59-8eadec247134€49.00€0.67matched
74capture01a19d02-b337-7ab7-a977-b4a8b714e93d€35.00€0.50matched
75capture01a19d02-c82f-77f0-a96d-671880776bbd€24.00€0.37matched
76capture01a19d03-0383-786b-9a45-b9bc33828ed9€9.00€0.19matched
77capture01a19d03-1d8a-7fb1-b759-5f81ea9898a6€24.00€0.37matched
78capture01a19d03-1e2d-72a1-a99f-784f296d74e5€35.00€0.50matched
79capture01a19d03-3408-7e63-9729-87502aff3da5€49.00€0.67matched
80capture01a19d03-343c-72cf-9bb2-21d171feefb1€49.00€0.67matched
81refund01a19d03-4c25-7756-95f7-28766126cc42-€5.00€0.00matched
82capture01a19d03-6240-7100-ba59-d8cc56a90f34€24.00€0.37matched
83capture01a19d03-a2a3-7da0-ad06-841c2c497161€9.00€0.19matched
84capture01a19d03-b58c-7a6a-9a56-88a5831e98ef€49.00€0.67matched
85capture01a19d03-b792-75f1-9825-c0e235e0c5ca€49.00€0.67matched
86capture01a19d03-d83f-7014-bf05-5359db64ec11€15.00€0.26matched
87capture01a19d04-107c-7283-b05a-7b616a159180€24.00€0.37matched
88capture01a19d04-1afe-783b-9604-1d48f4d014a5€35.00€0.50matched
90capture01a19d04-64b8-732d-a906-37dcc8afd029€35.00€0.50matched
91capture01a19d04-7f7f-781a-b526-ede2645f393a€49.00€0.67matched
92capture01a19d04-7f92-7e72-a8f1-ebb62c1b71a2€35.00€0.50matched
93capture01a19d04-9432-721e-a0ae-e65beb686274€35.00€0.50matched
94capture01a19d04-9647-79d7-8f63-ce11d3ff3ebd€24.00€0.37matched
95capture01a19d04-a2fd-7b9f-abc2-581e6bd3d156€49.00€0.67matched
96capture01a19d04-b2d3-71f2-8aca-69f51a1bda11€49.00€0.67matched
97capture01a19d04-cead-78ab-8ce7-50998fd3490d€15.00€0.26matched
98capture01a19d05-06ba-75da-825d-908bce68e730€49.00€0.67matched
99capture01a19d05-1a4c-7312-9cde-1a8c21dd0901€35.00€0.50matched
100refund01a19d05-1ae4-770d-93aa-ae1a3bc80e96-€5.00€0.00matched
101capture01a19d05-6c9e-75fd-9aee-e295bdf7e959€49.00€0.67matched
102capture01a19d05-962b-7a6f-afdd-ed9faee40f04€35.00€0.50matched
103capture01a19d05-a1cb-715f-8266-d1ae85b80335€35.00€0.50matched
104capture01a19d05-bbba-7604-8ca1-92401b0839b3€15.00€0.26matched
105capture01a19d05-c138-749b-b8bb-ac95b31d86c0€15.00€0.26matched
106capture01a19d06-41c4-7b9f-b683-dc06573e2557€15.00€0.26matched