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

Gross

€2,995.00

PSP fee

€47.34

Net to the bank

€2,947.66

Settlement journal

#353955

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19f5e-a399-79e4-a21d-32643a5d7c1f is already settled by stl_EUR_2989458 line 74
  • missing linein the books, not in the filecapture:01a19f5c-5d3f-7505-b7f2-1d25c0a5cc30 is in no file
  • missing linein the books, not in the filecapture:01a19f61-f4ea-7eed-87eb-8f29782080c9 is in no file
LineKindReferenceGrossFeeStatus
75capture01a19f5e-a3c7-7043-bee0-49bf4905586b€24.00€0.37duplicate line
1capture01a19f55-7549-7e77-8a91-2e476453d785€49.00€0.67matched
2capture01a19f56-4c15-76ba-8a42-0c42ab8cf710€9.00€0.19matched
3capture01a19f57-f6fc-7c78-80da-64e1994b2c8c€35.00€0.50matched
4capture01a19f59-7ffd-79f2-9d8c-b20d11d03150€49.00€0.67matched
5capture01a19f59-adbe-79fc-8014-c28326e3f24d€24.00€0.37matched
6capture01a19f59-cd36-7947-85d9-4b12fa8f2d4e€35.00€0.50matched
7capture01a19f59-cf5b-721c-b51c-a5877dc78a7f€9.00€0.19matched
8capture01a19f59-d96c-724e-8697-5b2b868e355a€15.00€0.26matched
9capture01a19f59-dbc6-7800-a6ac-27ae61ad758f€24.00€0.37matched
10capture01a19f59-f741-7114-bee5-b6dc88a9f505€49.00€0.67matched
11capture01a19f5a-0851-73b2-8fa7-4611c357bb94€24.00€0.37matched
12refund01a19f5a-1343-79ee-a21e-abbc892a571e-€17.00€0.00matched
13capture01a19f5a-2358-7835-ae38-f28bafadc214€35.00€0.50matched
14capture01a19f5a-28b4-7de1-9266-8d67304d977b€9.00€0.19matched
15capture01a19f5a-149f-7131-9c29-ff6faf6c5726€24.00€0.37matched
16capture01a19f5a-3794-7265-ad26-e818e7e12634€49.00€0.67matched
17capture01a19f5a-4dc3-7a63-9d48-32de93179518€49.00€0.67matched
18capture01a19f5a-5f93-7f42-acb6-fa65189f61e6€49.00€0.67matched
19capture01a19f5a-7c60-71b6-aa8b-ac08832c4e4f€9.00€0.19matched
20capture01a19f5a-7fe7-73fc-a504-70f7a548ef1e€35.00€0.50matched
21capture01a19f5a-96aa-7cdf-9563-d5e5d59bbdc1€35.00€0.50matched
22capture01a19f5a-ab81-790e-8377-b316615eb260€24.00€0.37matched
23refund01a19f5a-ba60-74ba-97f5-8021157f59aa-€32.00€0.00matched
24capture01a19f5a-c02d-774d-90a6-bc5ae1c81f72€24.00€0.37matched
25capture01a19f5a-e5cb-705a-bc92-c8a7f0230a3b€24.00€0.37matched
26capture01a19f5a-c5d9-733b-a072-b8442c446f30€9.00€0.19matched
27capture01a19f5a-fae1-7400-ba6b-a3fb46580a9b€9.00€0.19matched
28capture01a19f5b-11a6-7f9a-a80a-dbedff15acc7€24.00€0.37matched
29capture01a19f5b-144b-703c-8384-000155b3b2a9€35.00€0.50matched
30capture01a19f5b-1a5f-726e-8bc5-f153a93e09f6€49.00€0.67matched
31capture01a19f5b-1ed7-767e-9eaa-a7797878f960€15.00€0.26matched
32capture01a19f5b-2d42-7138-844c-9335458281c7€35.00€0.50matched
33capture01a19f5b-3218-7e55-aa24-aeb3b31abae2€35.00€0.50matched
34capture01a19f5b-3e74-7d41-9a1d-29992c46433b€15.00€0.26matched
35capture01a19f5b-4dac-7975-b90f-4f9e4a377ef0€49.00€0.67matched
36capture01a19f5b-6144-7337-973e-ebbe5b6a8126€9.00€0.19matched
37capture01a19f5b-bb35-7d73-805a-85e63074b763€49.00€0.67matched
38capture01a19f5b-c13d-798e-9fd0-01dd494679e1€15.00€0.26matched
39capture01a19f5b-cc1f-7958-aa37-b42f0f96d2da€35.00€0.50matched
40capture01a19f5b-d397-7b58-9869-ad3ed6a57643€49.00€0.67matched
41capture01a19f5b-df97-7eca-bab2-316b77cda55a€24.00€0.37matched
42capture01a19f5c-013c-728d-b930-0d2ee6142275€35.00€0.50matched
43capture01a19f5c-01c8-7764-8aec-20614e668154€24.00€0.37matched
44refund01a19f5c-0a72-72a4-8aad-d21e63727dae-€26.00€0.00matched
45capture01a19f5c-0ac9-7798-bd0e-a3afbb698fa0€49.00€0.67matched
46refund01a19f5c-0ef3-7b5d-8b9c-a6e596483776-€13.00€0.00matched
47capture01a19f5c-21ef-7490-99d8-5d87f9104945€15.00€0.26matched
48capture01a19f5c-353d-791a-9435-aa16c0d3c044€35.00€0.50matched
49capture01a19f5c-3cd9-7cfc-997a-ec848b20c418€49.00€0.67matched
50capture01a19f5c-3d15-7c14-8206-9942e5453914€24.00€0.37matched
51refund01a19f5c-8912-7566-92f0-1a460cf91822-€24.00€0.00matched
52capture01a19f5c-ab9b-7fc8-8b38-7feb1de6bfdd€24.00€0.37matched
53capture01a19f5c-c4ea-7d27-a781-39a2e6c011ef€24.00€0.37matched
54capture01a19f5c-e15c-77c0-886c-9781f2ba7407€35.00€0.50matched
55capture01a19f5c-ffc1-7e66-be04-1ca510f160e7€24.00€0.37matched
56capture01a19f5d-09ea-764a-a65d-36e8741b6d27€49.00€0.67matched
57capture01a19f5d-31e4-7d29-bea0-67c952438a6b€35.00€0.50matched
58capture01a19f5d-7ed7-7483-b417-25e319f4306b€24.00€0.37matched
59capture01a19f5d-8009-7974-a443-01b2cf421a36€24.00€0.37matched
60capture01a19f5d-841f-7ff1-9941-154a4d863fb3€9.00€0.19matched
61refund01a19f5d-8b75-7bf4-b274-8d7064d2c278-€34.00€0.00matched
62capture01a19f5d-93b9-7fa7-a253-1d6222c26e78€35.00€0.50matched
63capture01a19f5d-9db6-7e35-b711-85e7f98d072c€15.00€0.26matched
64capture01a19f5d-ad3c-7748-b905-613638d482f3€15.00€0.26matched
65capture01a19f5d-adb0-7f89-8bca-2c426135569f€49.00€0.67matched
66capture01a19f5d-d5b6-7547-b925-07ae51901432€24.00€0.37matched
67capture01a19f5d-e6a9-74c7-8130-4721183ae3ec€35.00€0.50matched
68capture01a19f5d-f660-7340-9c84-1f720ccdeb02€9.00€0.19matched
69capture01a19f5e-3335-7791-840e-493531e10c36€15.00€0.26matched
70capture01a19f5e-65a5-77ea-9ee9-d228fd128a97€35.00€0.50matched
71capture01a19f5e-6dfc-727c-b821-a6552abf6073€35.00€0.50matched
72capture01a19f5e-91a6-7e34-868d-cc0d00bd93b0€24.00€0.37matched
73refund01a19f5e-982f-71f8-b47f-cd41ed9c55bb-€11.00€0.00matched
74capture01a19f5e-a3c7-7043-bee0-49bf4905586b€24.00€0.37matched
76capture01a19f5e-db9e-7ab4-aa57-a5edfe0696ef€49.00€0.67matched
77capture01a19f5e-e0ac-7c27-bb3d-03fb06eb0c14€9.00€0.19matched
78capture01a19f5e-d694-7581-9d82-754df1febad1€15.00€0.26matched
79capture01a19f5e-f72c-79a7-82f1-3e4533bd3e09€9.00€0.19matched
80capture01a19f5f-198b-771c-b884-82b38650d490€24.00€0.37matched
81capture01a19f5f-27d6-7264-9ace-b27592549335€24.00€0.37matched
82refund01a19f5f-4056-71d4-a9a0-00d1415e209d-€15.00€0.00matched
83capture01a19f5f-7247-7a15-a707-e9b1bbf426dc€35.00€0.50matched
84capture01a19f5f-a81e-7587-9968-f3a01101f08e€35.00€0.50matched
85capture01a19f5f-aa63-73a0-9f21-6841c40cca15€49.00€0.67matched
86capture01a19f5f-bbe8-7f04-abe0-9e9cd7ee265e€24.00€0.37matched
87capture01a19f5f-bce0-775c-a89f-657ca1e8e1da€9.00€0.19matched
88capture01a19f5f-c56e-7bf6-9114-9ba5b89104b9€15.00€0.26matched
89capture01a19f5f-ce07-772c-8578-9f274a6bdd11€49.00€0.67matched
90capture01a19f5f-ebff-7723-8658-28902b2d12ff€35.00€0.50matched
91capture01a19f5f-fad4-771a-ab7c-a83a931eeeb3€35.00€0.50matched
92capture01a19f60-17fa-7f3c-9499-6becf47e745e€15.00€0.26matched
93capture01a19f60-1f83-7065-80ef-a1d30230dae1€15.00€0.26matched
94capture01a19f60-2804-7739-bace-fd0a8f504a5a€24.00€0.37matched
95capture01a19f60-3a9f-79f6-b963-7d4e824ecb57€49.00€0.67matched
96capture01a19f60-4278-75e8-b5fc-f49b686458e0€9.00€0.19matched
97capture01a19f60-66bd-7126-82a5-a2e3a5f000ec€15.00€0.26matched
98capture01a19f60-907a-7841-93ac-03283cfd9296€15.00€0.26matched
99capture01a19f60-931b-7d87-864c-221bd70c2e13€15.00€0.26matched
100capture01a19f60-9d0a-7cb0-b5d6-b1c9dbbc6c52€35.00€0.50matched
101capture01a19f60-ac57-780a-88bf-44a15661bf90€9.00€0.19matched
102capture01a19f60-b839-7ab2-93e0-8189c8af8811€35.00€0.50matched
103capture01a19f60-bc76-7a67-bba2-39313acf6832€9.00€0.19matched
104capture01a19f60-bdce-7250-a015-25721fd10682€15.00€0.26matched
105capture01a19f60-bf74-76ea-88d8-6ccd11802dee€15.00€0.26matched
106capture01a19f60-bf7f-7964-9847-75a430c4a96d€15.00€0.26matched
107capture01a19f60-ccf5-7167-9696-1f2460e2ca81€49.00€0.67matched
108capture01a19f60-d606-72cb-a619-1dcafcadaa17€9.00€0.19matched
109capture01a19f61-1ae3-7652-8cfa-8b2ba7ece4d7€15.00€0.26matched
110capture01a19f61-3f48-771b-aef8-064b1b003197€35.00€0.50matched
111capture01a19f61-5223-7d81-add5-4df0148c5785€9.00€0.19matched
112capture01a19f61-5e61-7ff0-9b49-61a9c67522a1€49.00€0.67matched
113capture01a19f61-6c26-7563-a8ee-de60335128a8€9.00€0.19matched
114capture01a19f61-6f6b-731f-85c5-9da2f3f7a369€35.00€0.50matched
115capture01a19f61-aaa7-7b2d-9284-15d3a7ff05d2€24.00€0.37matched
116capture01a19f61-add6-74ef-8400-256621af9132€49.00€0.67matched
117capture01a19f61-b603-7c8b-bc13-5766b1dfa13f€49.00€0.67matched
118capture01a19f61-cad4-7ef7-810d-b618c37614c4€9.00€0.19matched
119capture01a19f61-e33f-7c2b-9272-a8dfc9ab8f67€35.00€0.50matched
120capture01a19f61-e997-7e9d-8fe9-5ef36f3f3451€15.00€0.26matched
121capture01a19f62-261b-74f2-a07e-7e90d6728a2b€49.00€0.67matched
122capture01a19f62-315f-7f52-a570-d77a64818e23€35.00€0.50matched
123capture01a19f62-37de-7e26-9be5-c78aa9e05093€24.00€0.37matched