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

Gross

€2,579.00

PSP fee

€40.59

Net to the bank

€2,538.41

Settlement journal

#344721

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19cc8-321a-7a80-9e7e-c5b38943ebc2 is already settled by stl_EUR_2989386 line 25
  • duplicate linethe file lists it twicecapture:01a19cc8-f7e2-799e-9622-019a0ef55fe5 is already settled by stl_EUR_2989386 line 36
LineKindReferenceGrossFeeStatus
2capture01a19cc1-1169-788f-b427-7809b1c8163a€15.00€0.26duplicate line
26capture01a19cc8-324e-7440-b9a9-cca9f8730fc4€9.00€0.19duplicate line
37capture01a19cc8-f810-70bd-9d4a-3b0db5c10f14€15.00€0.26duplicate line
1capture01a19cc1-1169-788f-b427-7809b1c8163a€15.00€0.26matched
3capture01a19cc3-aca0-73f9-822d-5832094805e9€35.00€0.50matched
4capture01a19cc6-64b4-7224-aa79-99f1e278dfe8€49.00€0.67matched
5capture01a19cc6-6931-7d96-a104-1e94c324a66e€15.00€0.26matched
6capture01a19cc6-b518-7f1b-8dc5-c9ac1dddbbe9€24.00€0.37matched
7capture01a19cc6-bf04-795f-865b-b62cdb21d048€9.00€0.19matched
8capture01a19cc6-d028-7c25-abad-b14f462a1020€9.00€0.19matched
9capture01a19cc6-e3ae-7809-9632-dcf39999e141€24.00€0.37matched
10capture01a19cc7-1321-7a68-b39f-074b5078a3b9€35.00€0.50matched
11refund01a19cc7-235c-7ee9-b125-d288cc5f3c27-€21.00€0.00matched
12capture01a19cc7-5186-73f7-9037-0d96757181c6€49.00€0.67matched
13capture01a19cc7-53bc-7da7-998e-f0353de5843b€49.00€0.67matched
14capture01a19cc7-61ce-78e1-aee6-27bf279e9259€15.00€0.26matched
15capture01a19cc7-8834-79a1-be4f-091ec708dfdf€24.00€0.37matched
16capture01a19cc7-89b9-76fc-a872-b41702f218e5€35.00€0.50matched
17capture01a19cc7-8ba8-70dd-b101-90e76ac7849e€49.00€0.67matched
18capture01a19cc7-931a-70c6-9eef-42eb253b11de€9.00€0.19matched
19capture01a19cc7-96fe-78df-869d-63d4db053023€24.00€0.37matched
20capture01a19cc7-c246-7bc1-9a34-8bf2725c680d€9.00€0.19matched
21capture01a19cc7-e223-72f9-b8fe-ce277acfe34d€49.00€0.67matched
22capture01a19cc7-e2f6-75e6-8d0a-d0889efef71e€24.00€0.37matched
23capture01a19cc8-16a8-77ce-81ac-3f5cbfe3cb20€49.00€0.67matched
24capture01a19cc8-3058-789b-a8a0-83ca021f412e€35.00€0.50matched
25capture01a19cc8-324e-7440-b9a9-cca9f8730fc4€9.00€0.19matched
27capture01a19cc8-49d1-7eb8-83df-3214341e4c74€9.00€0.19matched
28refund01a19cc8-4bec-7cc1-8520-bd02adb60763-€13.00€0.00matched
29capture01a19cc8-4edb-7800-a4b5-ed12349f3250€15.00€0.26matched
30capture01a19cc8-5876-7cb9-b777-bb17e46c0c75€24.00€0.37matched
31capture01a19cc8-a376-74d2-87cc-80903bf32a03€24.00€0.37matched
32capture01a19cc8-b414-73d8-b1fb-3fba6be9ddb6€24.00€0.37matched
33capture01a19cc8-b5b4-799a-9c53-b633d688ed47€35.00€0.50matched
34capture01a19cc8-b757-7f69-93b1-3a31b82d9f9a€24.00€0.37matched
35capture01a19cc8-d61d-747c-8156-e020e25d157b€24.00€0.37matched
36capture01a19cc8-f810-70bd-9d4a-3b0db5c10f14€15.00€0.26matched
38capture01a19cc9-3cea-70f8-88b0-0b571a2aca6d€49.00€0.67matched
39capture01a19cc9-5da8-733c-be7f-dec9a8527674€15.00€0.26matched
40capture01a19cc9-9896-7e33-bc69-9e8417eb95dd€9.00€0.19matched
41capture01a19cc9-b0f1-7317-825b-e0e53cfcfd95€15.00€0.26matched
42refund01a19cc9-b98f-7e85-bacf-fe7efe6464ea-€12.00€0.00matched
43capture01a19cc9-ded1-7a44-b8b9-900cfc81db36€24.00€0.37matched
44capture01a19cc9-e9c8-7e9f-8c41-97473e45b61d€49.00€0.67matched
45capture01a19cc9-f90c-790a-a0c9-2db38a7087c7€49.00€0.67matched
46capture01a19cca-0844-7775-83b7-25835588743a€9.00€0.19matched
47capture01a19cca-0f63-7f40-a15d-eb720a7c1e94€15.00€0.26matched
48capture01a19cca-486a-7696-819b-288c26057d87€35.00€0.50matched
49capture01a19cca-570f-7505-bf2a-09bad5c8f2e3€49.00€0.67matched
50capture01a19cca-6b14-7e42-ade2-57cdf9602b62€49.00€0.67matched
51refund01a19cca-88e5-70f3-aa16-bdcd18763198-€34.00€0.00matched
52capture01a19cca-dd86-7817-a1ad-9e5bcf9c3d44€9.00€0.19matched
53capture01a19cca-f0e4-74e8-835c-0b045e97a3ce€49.00€0.67matched
54capture01a19ccb-11ab-7220-83f7-c93e95567772€35.00€0.50matched
55capture01a19ccb-18ef-7e2a-a6d9-20250dd21e46€49.00€0.67matched
56capture01a19ccb-1d4e-7504-ba6e-60386b276b88€24.00€0.37matched
57capture01a19ccb-4cc2-70ef-80e3-401ba3c7415e€9.00€0.19matched
58capture01a19ccb-62a8-73dd-b101-6c46042824ef€35.00€0.50matched
59capture01a19ccb-6cd9-7a58-980b-718f43e291bc€9.00€0.19matched
60capture01a19ccb-817a-7a4f-8dbf-d1b9742f1cb5€49.00€0.67matched
61capture01a19ccb-c409-74c3-862b-9920c12f8980€35.00€0.50matched
62capture01a19ccb-c4bd-7bf6-b301-c59962c2b78c€9.00€0.19matched
63capture01a19ccb-d88a-739d-a3ad-c807920e99a9€35.00€0.50matched
64capture01a19ccb-dc00-7385-91aa-759f51150d02€35.00€0.50matched
65capture01a19ccb-ddc4-73b5-b86d-735cf340fb99€9.00€0.19matched
66capture01a19ccb-e007-7d0d-b836-8c38af00c7b2€35.00€0.50matched
67capture01a19ccb-e406-7a71-b961-f62e9ef93542€15.00€0.26matched
68capture01a19ccb-f152-708d-be31-4a949eb879f3€24.00€0.37matched
69capture01a19ccb-f34a-7eae-9ce3-25b6e4f56def€15.00€0.26matched
70capture01a19ccc-33d5-7734-a014-f2becff71cd4€35.00€0.50matched
71capture01a19ccc-6c81-736c-a912-2de970e3d0dd€9.00€0.19matched
72capture01a19ccc-7952-7638-affc-268f9aeacced€9.00€0.19matched
73capture01a19ccc-7cc7-75dd-92d4-10f361490c69€35.00€0.50matched
74capture01a19ccc-b6e1-7c17-b432-dd5280a06910€49.00€0.67matched
75capture01a19ccc-ce6b-777b-8bd1-0e1a63476eb5€35.00€0.50matched
76capture01a19ccc-dcb0-7ec3-8540-6027185dc504€9.00€0.19matched
77refund01a19ccc-dd78-742f-8c0e-64a31631adb5-€20.00€0.00matched
78capture01a19ccd-200f-7403-bf41-2881b044644c€15.00€0.26matched
79capture01a19ccd-253e-7ef1-bf89-fc567da2dd89€9.00€0.19matched
80capture01a19ccd-2bac-71ae-86f9-1cc5eaa165a2€9.00€0.19matched
81capture01a19ccd-42a6-7787-b881-cd7029ecf874€49.00€0.67matched
82refund01a19ccd-4f2f-7412-a8b4-2f5314ae3d5d-€6.00€0.00matched
83capture01a19ccd-5057-7f01-8585-d47315270edc€15.00€0.26matched
84capture01a19ccd-6c2a-789d-bfcc-ad71d0cece02€49.00€0.67matched
85capture01a19ccd-7480-7561-87a9-97f1646ad227€15.00€0.26matched
86capture01a19ccd-7a2d-73dd-9a4b-5ddfc50427b3€49.00€0.67matched
87capture01a19ccd-83b9-7f1a-8610-865483dd65c8€49.00€0.67matched
88capture01a19ccd-875b-7e6b-918f-f7f5807b871c€9.00€0.19matched
89capture01a19ccd-8c95-7eba-a77f-98355656daf5€24.00€0.37matched
90capture01a19ccd-a92d-7900-b14a-8d0ae1e4d754€9.00€0.19matched
91capture01a19ccd-c56f-79f0-a561-34accaf6840d€9.00€0.19matched
92capture01a19cce-06fb-78da-be50-1601700b1b70€49.00€0.67matched
93capture01a19cce-3370-7d84-8e2a-12e3a73108b9€35.00€0.50matched
94capture01a19cce-485e-7e6c-adac-4fcaa3530adc€35.00€0.50matched
95capture01a19cce-4cb6-774c-a73f-ef0633ff5305€24.00€0.37matched
96capture01a19cce-5f82-7b96-9af6-0afcd4a1aa85€15.00€0.26matched
97capture01a19cce-7b90-7eb8-a4ae-f010a37c465e€24.00€0.37matched
98capture01a19cce-9507-70c2-b496-db2c9610ed01€24.00€0.37matched
99capture01a19cce-96c4-73e9-a127-18edb684f934€49.00€0.67matched
100capture01a19cce-a28d-7e38-98df-86f1020dec1b€15.00€0.26matched
101capture01a19cce-cc53-7781-bfd3-cce3d0bd55e2€9.00€0.19matched
102capture01a19cce-d0f8-751e-97ef-0dfa65ac5ea6€15.00€0.26matched
103capture01a19cce-d90b-7566-8341-2afbc2573a9c€9.00€0.19matched
104capture01a19ccf-1427-73d8-990e-8b1c3491ad15€9.00€0.19matched
105capture01a19ccf-1ef0-7d96-85aa-6f3365922574€15.00€0.26matched
106capture01a19ccf-28d6-7ca7-b6aa-1b1263c9a53c€24.00€0.37matched
107capture01a19ccf-4236-77b7-8b6c-d1f5fe7459a9€35.00€0.50matched
108capture01a19ccf-5726-720c-bd77-4ce3a2ad6737€35.00€0.50matched
109capture01a19ccf-5cd2-7895-a93e-6bdca9c7b26b€49.00€0.67matched