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

Gross

€2,963.00

PSP fee

€46.24

Net to the bank

€2,916.76

Settlement journal

#338999

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

LineKindReferenceGrossFeeStatus
1capture01a19b23-39d0-7b57-9d8e-b482203abff0€15.00€0.26matched
2capture01a19b27-8181-727d-8b68-0cb182942170€15.00€0.26matched
3capture01a19b2a-5016-7017-9774-eb0c2829fc01€35.00€0.50matched
4capture01a19b2a-7f5e-7122-ad69-f8f1397ab1a9€24.00€0.37matched
5capture01a19b2a-a174-7cac-9ac2-5369604d8983€24.00€0.37matched
6capture01a19b2a-a4ad-7f94-a74d-23673d88697d€24.00€0.37matched
7capture01a19b2a-bbd8-7788-9cb6-1d7f55ef04b2€15.00€0.26matched
8capture01a19b2a-c146-7021-94cd-2078d53b48e3€35.00€0.50matched
9capture01a19b2a-e6c3-7cab-95ac-2719dd188806€49.00€0.67matched
10capture01a19b2a-f56f-7c38-8fde-394ccf97ee0d€49.00€0.67matched
11capture01a19b2b-00a4-7110-ba5c-dd6097bbb80d€24.00€0.37matched
12capture01a19b2b-0c29-7651-a953-b80d32a00106€49.00€0.67matched
13capture01a19b2b-0d55-7927-b4aa-8891fff56b9e€15.00€0.26matched
14capture01a19b2b-38f1-7daa-a6e4-5547a81e6004€15.00€0.26matched
15capture01a19b2b-3b4c-7461-b315-44530ec8cb7e€49.00€0.67matched
16capture01a19b2b-3d53-7a9c-80f7-d0b3d29ad53d€15.00€0.26matched
17capture01a19b2b-4ef3-74f7-8cde-e627212a2cd0€15.00€0.26matched
18capture01a19b2b-64ee-7ecc-b292-ba18b46a7ba7€9.00€0.19matched
19capture01a19b2b-8718-7365-8658-1a73eaa2d044€35.00€0.50matched
20capture01a19b2b-8b86-715e-b4e5-39e325702bd7€49.00€0.67matched
21capture01a19b2b-a558-7961-80f1-922dfa13a8f1€35.00€0.50matched
22capture01a19b2b-b9bb-7dcd-b7b4-b2f3724338f1€15.00€0.26matched
23capture01a19b2b-c822-7535-8afa-60237b401e47€35.00€0.50matched
24capture01a19b2b-c97d-77c7-94e1-c5b74a8257bb€24.00€0.37matched
25capture01a19b2b-cbe4-790f-b9be-f95bd4a47969€49.00€0.67matched
26refund01a19b2b-cd5a-7536-b540-b11f86c61fbf-€31.00€0.00matched
27capture01a19b2c-087e-768c-b557-19d4fa3c4b3c€9.00€0.19matched
28capture01a19b2c-2a32-723c-9ed1-81b6491a12e0€49.00€0.67matched
29capture01a19b2c-2b5a-7dca-8c4e-46b030f376f6€35.00€0.50matched
30capture01a19b2c-3f83-7d11-aefa-72e128c89377€9.00€0.19matched
31capture01a19b2c-5c11-7450-b63a-0273a9f40e47€24.00€0.37matched
32capture01a19b2c-5c40-7613-ae0a-fff700c9e5bc€15.00€0.26matched
33capture01a19b2c-7db5-7ed8-bee2-f8e01d2ed98f€15.00€0.26matched
34capture01a19b2c-8aa3-7d03-a810-8503c3f27f28€24.00€0.37matched
35capture01a19b2c-9b71-7eeb-8a1a-67f98a72cdc2€15.00€0.26matched
36capture01a19b2c-b459-7835-bd13-1c7209bec868€35.00€0.50matched
37capture01a19b2c-b49e-7665-a0b4-14f8ede8a802€24.00€0.37matched
38capture01a19b2c-bd6f-7d8e-b2cf-a03708718656€9.00€0.19matched
39capture01a19b2c-d2ea-7ffd-bff3-f95110bb87e7€35.00€0.50matched
40capture01a19b2c-f92b-746a-99e5-f587339ca0bd€9.00€0.19matched
41capture01a19b2c-ff7a-786d-ae0c-23ee7cf71d1d€35.00€0.50matched
42capture01a19b2d-1384-76cb-968c-0c8187b0fa36€49.00€0.67matched
43capture01a19b2d-213a-78a7-9816-20f2f869426d€35.00€0.50matched
44refund01a19b2d-29c6-7f62-88f3-8a924a9eab75-€3.00€0.00matched
45capture01a19b2d-33d1-7e8d-9826-2db042f6dcbe€15.00€0.26matched
46capture01a19b2d-46dd-77f0-9572-27478adde86a€15.00€0.26matched
47capture01a19b2d-5586-7b7d-98c2-24c81b3dfa4a€15.00€0.26matched
48capture01a19b2d-574a-7144-ab11-1c39e8eb65b0€15.00€0.26matched
49capture01a19b2d-8694-7894-b5df-5f3bc7d33f52€24.00€0.37matched
50capture01a19b2d-89f9-7d0e-bebc-c7b66398dfea€35.00€0.50matched
51capture01a19b2d-d4ec-76ae-ad33-f54bf3738223€49.00€0.67matched
52capture01a19b2d-faeb-7f5d-b2ed-cd0a4742c4f7€49.00€0.67matched
53capture01a19b2e-1b79-77f1-a276-456ebde0c080€49.00€0.67matched
54capture01a19b2e-1c77-75ab-8a58-0352116695d2€35.00€0.50matched
55capture01a19b2e-2039-7f45-8979-cfff95c1b76d€35.00€0.50matched
56capture01a19b2e-2af2-7fb7-9973-6147481bba51€15.00€0.26matched
57capture01a19b2e-5e06-73ae-b062-c3589624be66€9.00€0.19matched
58capture01a19b2e-5f5d-7003-b307-d73166d533b2€49.00€0.67matched
59refund01a19b2e-619b-77e9-82fd-34b9f0777b14-€31.00€0.00matched
60capture01a19b2e-6c62-78b7-93bd-e227c3c3e50d€35.00€0.50matched
61capture01a19b2e-7f19-7df1-8ac6-f4cf7118f5db€24.00€0.37matched
62capture01a19b2e-8632-77cb-9ff9-1592d64e4493€24.00€0.37matched
63capture01a19b2e-9a0e-71db-989d-f0626b23283d€24.00€0.37matched
64capture01a19b2e-9c2f-71fb-af1d-18bd6c41cc65€24.00€0.37matched
65capture01a19b2e-bc24-78b5-ba45-c8fa5cfc88ac€15.00€0.26matched
66capture01a19b2e-e43a-72c6-9ce1-04f7af691bfc€9.00€0.19matched
67capture01a19b2f-034c-77b4-a402-abc4cde097e2€49.00€0.67matched
68capture01a19b2f-52e8-75f7-9754-7e626858125b€49.00€0.67matched
69capture01a19b2f-5954-79a8-a316-473575bc5456€9.00€0.19matched
70capture01a19b2f-6139-7a0a-b533-56e31da35606€49.00€0.67matched
71capture01a19b2f-88b0-7231-a0f2-6b4ea5abc2c1€24.00€0.37matched
72capture01a19b2f-8ee8-74d2-88a3-1911d25e78c8€15.00€0.26matched
73capture01a19b2f-a50a-7243-9294-7a35078c01e3€24.00€0.37matched
74capture01a19b2f-b566-763b-9167-cf461a784997€35.00€0.50matched
75capture01a19b2f-c31d-7404-8efe-cec942f77a06€24.00€0.37matched
76capture01a19b2f-c8f5-7eed-890b-cc4dd181eafa€9.00€0.19matched
77refund01a19b2f-d4f2-7120-9005-10382731661a-€5.00€0.00matched
78capture01a19b2f-e2b9-7f89-89cf-01b64677a7b8€15.00€0.26matched
79capture01a19b2f-f484-7e6e-92d7-ca05c81ced1e€49.00€0.67matched
80capture01a19b30-05f0-7cb2-b88f-8c56de20e3e0€24.00€0.37matched
81capture01a19b30-0c99-70ae-84f2-bca74c6a9124€49.00€0.67matched
82capture01a19b30-0e23-7d42-a8b5-c8c4cb767ed6€9.00€0.19matched
83capture01a19b30-1219-754a-aef5-8a2e2a6e8eed€49.00€0.67matched
84capture01a19b30-24e9-7895-b132-48f897a311e7€24.00€0.37matched
85capture01a19b30-300e-71c8-a252-bef6d0b7da51€35.00€0.50matched
86capture01a19b30-325a-7f78-a5b3-e1303b3ca7ec€15.00€0.26matched
87capture01a19b30-3e29-7661-afa7-cb0d7abdf63e€24.00€0.37matched
88capture01a19b30-40dd-7f86-bc20-540acca3e96a€35.00€0.50matched
89refund01a19b30-45e7-7008-be36-1eb4b0bc423e-€19.00€0.00matched
90capture01a19b30-8523-71d1-8801-d89c3e8b8fbb€35.00€0.50matched
91capture01a19b30-b0e0-7322-9ee2-14bee40ca4d4€35.00€0.50matched
92capture01a19b30-d173-7965-961a-1996cb25e00c€9.00€0.19matched
93capture01a19b30-e92c-78dc-9a12-62fe54e0ec23€24.00€0.37matched
94capture01a19b30-f020-7ba1-a00b-a58f1cdcbcc6€9.00€0.19matched
95capture01a19b31-1f5a-768d-b8cb-83886a39848a€35.00€0.50matched
96capture01a19b31-3ed8-705b-965e-d4b6afdaf7c0€49.00€0.67matched
97capture01a19b31-66f7-788d-b240-58b16493f9df€24.00€0.37matched
98refund01a19b31-8b74-78de-ba36-09a01b9f2fc4-€30.00€0.00matched
99capture01a19b31-940a-71a5-8e26-a4b3e65b0974€15.00€0.26matched
100capture01a19b31-9f86-71a9-b0a9-b7ac91a46c7e€24.00€0.37matched
101refund01a19b31-e11c-7ec5-8b93-3e108219dbb4-€10.00€0.00matched
102capture01a19b31-e6f6-767a-8950-0d5f1739ab5c€49.00€0.67matched
103capture01a19b31-ee15-71e2-a5a8-85013af6e6f0€15.00€0.26matched
104capture01a19b31-f7eb-7f64-8a07-8b7942632e31€35.00€0.50matched
105capture01a19b32-07d4-77a1-8dec-625a501e2368€49.00€0.67matched
106capture01a19b32-10ea-70c4-b4af-b5e68169529a€35.00€0.50matched
107capture01a19b32-20e8-76ce-9532-6bb967c5ac78€24.00€0.37matched
108capture01a19b32-275b-7ab9-869d-f4c79324e743€35.00€0.50matched
109capture01a19b32-356f-701b-aad1-d529e3344e2c€24.00€0.37matched
110capture01a19b32-7ad6-7189-af65-fd46e212ade9€35.00€0.50matched
111capture01a19b32-9d4b-753d-b0af-6ca13d58b2b0€15.00€0.26matched
112capture01a19b32-b043-78fe-9ebd-c74c5cf1ff8e€24.00€0.37matched
113capture01a19b32-ba57-7958-bc54-f7129f012dd7€9.00€0.19matched
114refund01a19b32-d71a-7e3e-8c7a-8ea39b3c9e1f-€11.00€0.00matched
115capture01a19b32-d884-7fa2-be6e-2f94de6656a1€49.00€0.67matched
116capture01a19b32-e4a7-7c91-a1d9-cab6c589be87€49.00€0.67matched
117capture01a19b33-489c-7da5-937e-a2ae76f915ad€15.00€0.26matched
118capture01a19b33-518b-753c-9669-4edcbd48618f€35.00€0.50matched
119capture01a19b33-5b2c-75f9-a544-1ce9c1f47763€24.00€0.37matched