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, 13:30

Gross

€2,749.00

PSP fee

€44.37

Net to the bank

€2,704.63

Settlement journal

#343624

Every line paired with the books, and every capture and refund of the day is in the file.

LineKindReferenceGrossFeeStatus
1capture01a19c6b-5615-7ffe-a6a9-c56f6e8513d1€9.00€0.19matched
2capture01a19c6c-50c5-7271-85b8-52b2e20930d7€15.00€0.26matched
3capture01a19c70-3d45-7eeb-81bd-1c43a7459346€15.00€0.26matched
4capture01a19c73-e185-77d5-90a6-5ea352ef9e59€15.00€0.26matched
5capture01a19c73-ed60-7f4d-bbe9-576f411ec4e1€15.00€0.26matched
6capture01a19c73-ee5d-7136-be4c-7af967378cbe€15.00€0.26matched
7capture01a19c73-f4e2-7211-a676-b5f88293946d€9.00€0.19matched
8capture01a19c73-fc6d-7e5f-a716-bfb747816f9b€9.00€0.19matched
9capture01a19c73-fe9c-7f9c-aa84-57bc3ab3e5ef€24.00€0.37matched
10capture01a19c74-1202-72bf-801b-19fc3a38b997€9.00€0.19matched
11capture01a19c74-2759-76b4-a0ac-aac08d000f66€49.00€0.67matched
12capture01a19c74-3194-736c-89ce-6248f910bcb2€35.00€0.50matched
13capture01a19c74-4773-7908-8b63-c8be84a28d2c€15.00€0.26matched
14capture01a19c74-861b-724b-a63a-4166436e5b0c€15.00€0.26matched
15capture01a19c74-cc76-7fab-8400-81396313f5d0€24.00€0.37matched
16refund01a19c74-cce0-7551-b86a-e108042dab44-€8.00€0.00matched
17capture01a19c74-d992-7fef-a57c-0f82ec37702e€35.00€0.50matched
18capture01a19c74-e070-727f-a1e7-0758130c5dc1€35.00€0.50matched
19capture01a19c74-f0d8-7e86-9e22-b07dd5b75574€49.00€0.67matched
20capture01a19c74-f5b5-786c-821a-2cf91fa3a871€24.00€0.37matched
21capture01a19c75-0174-75b7-a519-d82b55d99f01€9.00€0.19matched
22capture01a19c75-01f8-7317-9434-84bdc0f120ee€24.00€0.37matched
23capture01a19c75-16c0-7164-8799-a8047a3a8fff€9.00€0.19matched
24capture01a19c75-0f4e-7c48-a293-d2de236c1825€35.00€0.50matched
25capture01a19c75-1bd1-7386-9560-1601ce2be65c€15.00€0.26matched
26capture01a19c75-330d-7e97-baae-e3776c7b8aa8€35.00€0.50matched
27capture01a19c75-5556-75e5-abc4-bf944427024f€24.00€0.37matched
28capture01a19c75-5a99-7ed8-ae8b-9fc0a547ba4f€9.00€0.19matched
29capture01a19c75-63ae-7f46-bdae-08dc469e1ced€24.00€0.37matched
30capture01a19c75-7abe-7376-b55e-0bc85d8812e9€49.00€0.67matched
31capture01a19c75-7b18-764b-abae-6ceb872856a3€15.00€0.26matched
32capture01a19c75-9f8d-73d0-bda4-e46a14601a66€24.00€0.37matched
33capture01a19c75-bde6-7a0e-b040-a877d21b3a10€15.00€0.26matched
34capture01a19c75-bff9-724f-b97a-e9f5752463ef€49.00€0.67matched
35capture01a19c75-c8f8-7765-8e44-89f894feada8€9.00€0.19matched
36capture01a19c75-ebf9-7547-9282-f93fe26937e7€35.00€0.50matched
37capture01a19c76-23c0-7357-83fd-d71072bc4f41€15.00€0.26matched
38capture01a19c76-3d25-7b59-ba13-39411364ae2e€35.00€0.50matched
39capture01a19c76-4820-7151-95ad-1570ad353f52€24.00€0.37matched
40capture01a19c76-51fd-7972-82ab-be9544fce6d3€9.00€0.19matched
41capture01a19c76-6978-703a-9b90-933b054ae77c€9.00€0.19matched
42capture01a19c76-6e8b-7897-8070-63b799ed7147€15.00€0.26matched
43capture01a19c76-9cc5-7a21-a511-f809e14fa87a€9.00€0.19matched
44capture01a19c76-a54a-7059-bf99-2c7c49c534d1€15.00€0.26matched
45capture01a19c76-bea8-7324-912d-7e5b344fef6f€9.00€0.19matched
46capture01a19c76-cf53-792f-9ce1-e77c18c1d0bc€9.00€0.19matched
47capture01a19c76-d013-7daf-b8be-305523e96836€24.00€0.37matched
48capture01a19c76-f74d-7399-966f-8e9bd09cc39d€15.00€0.26matched
49capture01a19c77-3369-7152-8c15-3ac8bc5b60c7€24.00€0.37matched
50capture01a19c77-42a3-746f-86ae-fc3ee8488954€24.00€0.37matched
51capture01a19c77-5c5c-71a1-8127-fccd92e4fae4€15.00€0.26matched
52capture01a19c77-6dd6-71cb-9aae-1460c752d800€24.00€0.37matched
53capture01a19c77-7ab4-74dd-85df-d7f08ce54e16€24.00€0.37matched
54capture01a19c77-8726-7720-b64d-d241cf68ea00€9.00€0.19matched
55capture01a19c77-8be5-7063-a898-276f09ea1d44€24.00€0.37matched
56capture01a19c77-9833-7a0c-bea3-3f6bcbb54a0c€24.00€0.37matched
57refund01a19c77-a2b3-78ac-ad89-362181334708-€11.00€0.00matched
58capture01a19c77-c17a-77e5-b236-52e6ed998de4€24.00€0.37matched
59refund01a19c77-db78-7c64-adbf-8ff3a524277a-€10.00€0.00matched
60capture01a19c77-ebea-73bc-a30e-1563ad96a6f8€15.00€0.26matched
61capture01a19c77-f5e3-7e9f-a520-8752521351bd€35.00€0.50matched
62capture01a19c77-f952-76eb-9992-a9e9c5a4f7af€15.00€0.26matched
63capture01a19c78-0076-7450-b714-0bfb3998f112€49.00€0.67matched
64capture01a19c78-2be5-7bfa-8c21-387048a2565d€9.00€0.19matched
65capture01a19c78-3a8f-7f3f-b8cf-39847539b8b7€35.00€0.50matched
66refund01a19c78-3ad0-70d4-9e82-7dc37dc758fe-€13.00€0.00matched
67capture01a19c78-6b2a-7de7-993e-b2c620e8847e€24.00€0.37matched
68capture01a19c78-81c4-78aa-9929-28315cc5ddaa€9.00€0.19matched
69capture01a19c78-905b-72dd-b199-d1818de5c666€24.00€0.37matched
70capture01a19c78-a48e-7653-886a-ebb1bd26ed99€15.00€0.26matched
71capture01a19c78-b02c-7dc2-a678-1adf0f399b3e€24.00€0.37matched
72capture01a19c78-b472-7dff-a2d9-1b1a1daa2e4c€9.00€0.19matched
73capture01a19c78-c0fa-7844-9947-3fefbabeed3a€24.00€0.37matched
74capture01a19c78-e3e3-7c47-b714-872fa9c71824€9.00€0.19matched
75capture01a19c78-e797-77af-8e3c-a57b021dca01€35.00€0.50matched
76capture01a19c79-0f78-7b86-b29c-f8c08540f91b€35.00€0.50matched
77capture01a19c79-27db-7d11-a7ad-a7783bef7c9e€15.00€0.26matched
78capture01a19c79-28ec-77fb-b66f-6f635ff206c2€35.00€0.50matched
79capture01a19c79-46fc-76f1-92bf-ade2dfffb432€49.00€0.67matched
80capture01a19c79-4869-76bc-a807-d9aeaabb2a09€35.00€0.50matched
81capture01a19c79-7510-765e-acf1-12d8dd25fa41€24.00€0.37matched
82capture01a19c79-7a19-7c3b-b939-3fee3b499ffe€9.00€0.19matched
83capture01a19c79-81fe-7679-869f-5beb231f3e33€9.00€0.19matched
84capture01a19c79-959e-7293-9987-7058dc3eed14€35.00€0.50matched
85capture01a19c79-9705-7e59-b13d-ad81968e1b17€15.00€0.26matched
86capture01a19c79-9d24-7e25-8a1c-8f5fcf6fa78d€9.00€0.19matched
87capture01a19c79-add2-780f-adc9-f7b6305ef790€24.00€0.37matched
88capture01a19c79-c829-799e-8e24-1b6b16cb7c34€35.00€0.50matched
89capture01a19c79-cbd5-757a-a45f-dead80702f76€24.00€0.37matched
90refund01a19c79-e9ba-7aaf-802c-39d3ae4c4c6c-€17.00€0.00matched
91capture01a19c7a-0078-772d-9d63-b46cb55c9942€35.00€0.50matched
92capture01a19c7a-0adf-7455-aafd-5f5c05c77378€24.00€0.37matched
93capture01a19c7a-28f6-7334-9602-ca2c9b25b770€35.00€0.50matched
94capture01a19c7a-2e75-712e-b058-2e98dc63345e€9.00€0.19matched
95capture01a19c7a-3460-765d-ab2b-5cad40a8af1c€49.00€0.67matched
96capture01a19c7a-435a-7088-8e16-3e086a6376dd€15.00€0.26matched
97refund01a19c7a-4e30-7d57-8590-484be3dc3c2a-€33.00€0.00matched
98capture01a19c7a-51b1-7d5a-a616-9c795572518b€24.00€0.37matched
99capture01a19c7a-7dee-7fa0-a772-537e6fe6ff64€24.00€0.37matched
100capture01a19c7a-8aae-73ea-85fb-095eb89acedb€24.00€0.37matched
101capture01a19c7a-9c85-72ab-8fa5-df4fd674fc0f€15.00€0.26matched
102capture01a19c7a-ab5c-7c8e-8bd0-2ddea5d43ff7€15.00€0.26matched
103capture01a19c7a-cd88-7e79-b675-25d3f9502a95€49.00€0.67matched
104capture01a19c7a-d74e-7de9-bd5a-96be8bc9f94e€15.00€0.26matched
105capture01a19c7a-d769-74c1-9a47-0bbda7f99cb1€9.00€0.19matched
106capture01a19c7a-f48c-7173-90ae-1fa425b6f606€24.00€0.37matched
107capture01a19c7a-fcac-7ef6-bf17-c5f478b5ea20€49.00€0.67matched
108capture01a19c7b-1ac0-7d27-b032-6d9bf89ec9d5€9.00€0.19matched
109capture01a19c7b-2160-7283-92ca-b37734f9f332€15.00€0.26matched
110capture01a19c7b-47b4-7a26-af4c-1704117fabe7€24.00€0.37matched
111capture01a19c7b-6da6-78a3-b151-6f6533ca4984€24.00€0.37matched
112capture01a19c7b-9fc7-7f8f-9c32-99888cfa503f€49.00€0.67matched
113capture01a19c7b-b1ad-764e-8174-be7b5b5f8682€15.00€0.26matched
114capture01a19c7b-be9c-7278-8738-95bb91f7b584€15.00€0.26matched
115capture01a19c7b-cd49-72f0-935a-fbc7569ff3df€49.00€0.67matched
116capture01a19c7b-e2cb-7fe9-b524-f142dd29f62a€49.00€0.67matched
117capture01a19c7b-ed58-7aa8-acb4-bb90e49e458f€24.00€0.37matched
118refund01a19c7b-f180-7d75-a099-c8d6d20f0a45-€31.00€0.00matched
119capture01a19c7c-0e94-7e19-9040-78569858a5b0€35.00€0.50matched
120capture01a19c7c-3eae-7b83-ba4e-8cd7d6779d21€35.00€0.50matched
121capture01a19c7c-5103-7877-9116-35edadf58995€15.00€0.26matched
122capture01a19c7c-5579-7cb3-89e5-85fe38edcb58€15.00€0.26matched
123capture01a19c7c-8677-77fa-8c58-3ce612a7c022€49.00€0.67matched
124capture01a19c7c-a2ed-7a85-9f4e-7240c6bd2525€49.00€0.67matched
125capture01a19c7c-d218-7049-8ffb-e0112e105312€24.00€0.37matched
126capture01a19c7c-d5e9-76d2-b3fd-c3fed529e6cc€9.00€0.19matched
127capture01a19c7c-dabe-796f-8b1c-d08ad5d865c2€9.00€0.19matched
128capture01a19c7c-db40-7c2c-ab03-c5927fc609c0€35.00€0.50matched
129capture01a19c7c-eade-7019-90db-404799822d68€49.00€0.67matched