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

19 Oct, 01:50

Gross

€2,613.00

PSP fee

€41.94

Net to the bank

€2,571.06

Settlement journal

#79148

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a151e1-09eb-7599-be95-240974f9dbb0 is already settled by stl_EUR_2987291 line 91
LineKindReferenceGrossFeeStatus
92capture01a151e1-0a25-7d3d-92f6-392d6f773a71€9.00€0.19duplicate line
1capture01a151d5-1d68-730b-93e3-6d781fffaca9€35.00€0.50matched
2capture01a151d6-74fd-7917-af91-117d824bc0f4€49.00€0.67matched
3refund01a151d7-8d99-72fa-a2c5-c3d3224fede5-€11.00€0.00matched
4capture01a151da-1dcd-7564-86c9-530eaef7a696€49.00€0.67matched
5capture01a151da-1e26-7536-b20e-d0944306e353€15.00€0.26matched
6capture01a151da-40be-7c94-a295-e88641d146cf€15.00€0.26matched
7capture01a151da-4e3e-743c-b49f-1452c5ce9a1c€9.00€0.19matched
8capture01a151da-5263-71d3-b86f-9612447d09bd€24.00€0.37matched
9capture01a151da-65f9-7cc3-8458-2743b7728e73€35.00€0.50matched
10capture01a151da-7d6f-7fe2-a4fa-3e1185cf7f78€49.00€0.67matched
11refund01a151da-8987-701c-bc9e-ebb5809e67d5-€27.00€0.00matched
12capture01a151da-89ea-7bc5-ad78-297817785561€49.00€0.67matched
13capture01a151da-925e-78b5-a274-df8b26c506be€49.00€0.67matched
14capture01a151da-a367-7366-bc56-e33f50267a92€9.00€0.19matched
15capture01a151da-aa52-78c4-a83e-ad2aa003013a€24.00€0.37matched
16capture01a151da-b15e-7481-bbfa-62d160e1cd53€24.00€0.37matched
17capture01a151da-b40f-7167-9498-af728cb725a7€35.00€0.50matched
18capture01a151da-dde6-731f-90d3-15fde5feb78a€24.00€0.37matched
19capture01a151da-e98f-7e35-9e42-8ecdcc8017c3€49.00€0.67matched
20capture01a151da-f585-78f4-8128-e5f8d107e4eb€49.00€0.67matched
21capture01a151db-13cd-703b-9c06-09246e3fa888€49.00€0.67matched
22capture01a151db-1c03-7732-9f9a-1cecb6fb515e€24.00€0.37matched
23capture01a151db-689a-7d6c-8f08-874490f874a2€35.00€0.50matched
24capture01a151db-6baf-74fd-90e1-828413d3a2b9€49.00€0.67matched
25capture01a151db-7455-719d-8acd-f3476f2bae0c€49.00€0.67matched
26capture01a151db-a74b-7a67-bdc4-477a6f5cab7c€35.00€0.50matched
27capture01a151db-ace7-7601-9022-700a0018cc5f€24.00€0.37matched
28refund01a151db-affe-7184-9aac-a6dce8b33fba-€29.00€0.00matched
29capture01a151db-b7ef-7f8d-8e23-23795a47176b€9.00€0.19matched
30capture01a151dc-0d56-77ad-b857-7b87e1d62e56€9.00€0.19matched
31capture01a151dc-141e-7240-9022-f980093fb250€9.00€0.19matched
32capture01a151dc-27f5-7aab-bd79-88d53c06b644€9.00€0.19matched
33capture01a151dc-4f07-7668-baac-6df56484970e€24.00€0.37matched
34capture01a151dc-5b4e-7f12-91aa-43a065aa7fe3€35.00€0.50matched
35capture01a151dc-6d70-7a43-abc5-c28677008d2e€35.00€0.50matched
36capture01a151dc-692f-703c-9f6b-930a920cbc8d€49.00€0.67matched
37capture01a151dc-908b-7a48-be6e-e789f157a78c€24.00€0.37matched
38capture01a151dc-9f1d-7512-8f11-46d0bcb473a8€9.00€0.19matched
39capture01a151dc-c446-7322-b7c6-957b224cd715€49.00€0.67matched
40capture01a151dc-cf82-7fb5-902e-4149408e6711€15.00€0.26matched
41refund01a151dd-01e7-7941-a34d-97de0abbae94-€7.00€0.00matched
42capture01a151dd-3271-7a64-8c08-5ef4725b438d€9.00€0.19matched
43capture01a151dd-5d34-7e8e-905f-49fc54bbe426€9.00€0.19matched
44refund01a151dd-66c0-7634-b0d1-a5053472669d-€6.00€0.00matched
45capture01a151dd-78f7-7a57-bf5b-ffed624cb16a€35.00€0.50matched
46capture01a151dd-7b5e-7205-9087-59ee03285e13€24.00€0.37matched
47capture01a151dd-91b6-74eb-b07f-2bfdb0931188€49.00€0.67matched
48capture01a151dd-ac3f-770d-95c3-0da69deb9c0f€15.00€0.26matched
49capture01a151dd-cccb-7815-b552-e7f476dbd4f3€15.00€0.26matched
50capture01a151dd-f828-77d8-b25a-e22461107c9f€15.00€0.26matched
51capture01a151de-16a4-7a4b-981a-38b4bd3bd3fb€24.00€0.37matched
52capture01a151de-5f76-7050-bd4d-62194c610ca9€24.00€0.37matched
53capture01a151de-82ba-7689-a5d9-7d8d92f70012€9.00€0.19matched
54capture01a151de-87c3-78d6-97cb-d9b291062fdb€24.00€0.37matched
55capture01a151de-ad81-7646-ae61-15f3fec36323€9.00€0.19matched
56capture01a151de-b16c-7cf8-bd11-5a7e28224bd5€35.00€0.50matched
57capture01a151de-b77f-79b4-853c-7abb0f44065b€15.00€0.26matched
58capture01a151de-ba2a-735b-94a7-224f1ae33152€24.00€0.37matched
59capture01a151de-e0e4-7308-9dc6-b7e77909d493€49.00€0.67matched
60refund01a151de-ff7e-766e-ab3a-61de84ca8426-€2.00€0.00matched
61capture01a151df-3803-7414-a6d1-7f1f410ac1e7€15.00€0.26matched
62capture01a151df-3db2-7faf-9173-61e6d3ea1437€35.00€0.50matched
63capture01a151df-546b-78d7-a139-01697169b3fc€15.00€0.26matched
64capture01a151df-67cd-70fe-84a8-c6c1dab8e04b€24.00€0.37matched
65capture01a151df-6e65-7e15-9b78-4a1e1d47c3fa€15.00€0.26matched
66capture01a151df-8241-7902-9fdb-29bc8fbf7573€9.00€0.19matched
67capture01a151df-8fa1-780f-9aa3-56c4f170cce6€24.00€0.37matched
68capture01a151df-b0ac-7664-a8b0-bfc641bcf2c0€15.00€0.26matched
69capture01a151df-b425-781f-81d4-c25dc3a74d7f€24.00€0.37matched
70capture01a151df-b95b-7def-b2c6-412afac6ea15€35.00€0.50matched
71capture01a151df-b96e-7b97-88c0-03cc0694cfb3€49.00€0.67matched
72capture01a151df-baed-71e3-9fa4-1dffbd2088cb€9.00€0.19matched
73capture01a151e0-075c-7e22-93de-34675341572e€15.00€0.26matched
74capture01a151e0-3a56-75b0-a4b5-5f22c449e390€9.00€0.19matched
75refund01a151e0-51d4-740f-b883-381fa682f658-€13.00€0.00matched
76capture01a151e0-8d3e-767c-abd1-9110cb2298c2€15.00€0.26matched
77capture01a151e0-9421-7846-8ae0-6dac47c0ebd8€24.00€0.37matched
78capture01a151e0-9c3a-783a-bbfd-7706e357580b€24.00€0.37matched
79capture01a151e0-ab60-7bf0-9ad1-988615e62989€35.00€0.50matched
80capture01a151e0-ac93-783c-87ce-d1d7491be2ef€9.00€0.19matched
81capture01a151e0-ad6e-7ff5-8693-272b6c81281b€49.00€0.67matched
82capture01a151e0-ae06-7a85-936d-50c4bface818€49.00€0.67matched
83capture01a151e0-b189-75b6-83a0-3731167d966d€24.00€0.37matched
84capture01a151e0-bca1-77c9-814c-b2bb7b04fc56€15.00€0.26matched
85capture01a151e0-be26-77eb-bc66-c0ec61779a52€35.00€0.50matched
86capture01a151e0-bff9-7351-9eb4-b9abef2e39e7€24.00€0.37matched
87capture01a151e0-c7f3-7848-bf4c-3d81761ad0a1€24.00€0.37matched
88capture01a151e0-c981-724b-a2ea-3ddf654431b9€15.00€0.26matched
89capture01a151e0-cc3f-79be-bd68-5f187c743039€9.00€0.19matched
90capture01a151e0-f529-7443-bac5-905e2cb4852c€9.00€0.19matched
91capture01a151e1-0a25-7d3d-92f6-392d6f773a71€9.00€0.19matched
93refund01a151e1-0d3e-7de9-9b63-7960f42faa1a-€30.00€0.00matched
94capture01a151e1-0e3e-7926-a9b0-4ac43e163606€24.00€0.37matched
95capture01a151e1-37e1-7bbf-b4a8-15755485c6d6€9.00€0.19matched
96capture01a151e1-42be-7a59-a368-a935da42fc95€9.00€0.19matched
97capture01a151e1-6629-79b8-a319-952113608c49€15.00€0.26matched
98capture01a151e1-a88d-7cb2-b1d4-4554340fcc74€49.00€0.67matched
99refund01a151e1-b593-7486-a0b1-70dc58ee9350-€7.00€0.00matched
100capture01a151e1-d15f-7d91-8e60-8c56af217e5f€9.00€0.19matched
101capture01a151e1-d7aa-704f-9319-bb22733e1bda€35.00€0.50matched
102capture01a151e1-dd3d-7ffe-ad58-c2e8b6092979€24.00€0.37matched
103capture01a151e1-e29f-7b5e-9555-276fe72a0fba€15.00€0.26matched
104capture01a151e1-fc2a-7a66-a2be-186cf49d4e2f€35.00€0.50matched
105capture01a151e1-f2e5-7699-8dcc-4b25e4fe6b27€35.00€0.50matched
106capture01a151e2-0aab-730a-b1b8-5aa2b2a48771€9.00€0.19matched
107capture01a151e2-379e-7e87-a08b-a1c97e2b194c€9.00€0.19matched
108capture01a151e2-37a5-7f80-9e15-dedd380711d2€24.00€0.37matched
109capture01a151e2-44f8-7ed4-a0c4-3af9585b87d6€15.00€0.26matched
110capture01a151e2-568b-7d3e-80ee-c92610afb3ba€35.00€0.50matched
111refund01a151e2-70bf-7f53-86ed-7a101aa5ffe3-€6.00€0.00matched
112capture01a151e2-850f-7d8b-b0eb-4feab973c007€49.00€0.67matched
113capture01a151e2-9085-70bc-a30c-0ae38407befc€49.00€0.67matched
114capture01a151e2-98a1-7fc6-a85f-2bbed820aa1f€9.00€0.19matched
115refund01a151e2-98f1-74c6-adb3-68a56d6b6948-€12.00€0.00matched
116capture01a151e2-a06e-7561-bc78-52006afb9c2b€35.00€0.50matched
117capture01a151e2-abb1-770e-925b-1635d8e4a729€24.00€0.37matched
118capture01a151e2-e558-792e-ade5-88d43a287cd0€9.00€0.19matched
119capture01a151e3-04ca-7a25-9321-620c2c50e20e€49.00€0.67matched