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, 05:40

Gross

€2,341.00

PSP fee

€37.17

Net to the bank

€2,303.83

Settlement journal

#356006

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

LineKindReferenceGrossFeeStatus
1capture01a19feb-f731-779d-9e9a-d4ecf13fcb87€9.00€0.19matched
2capture01a19fec-1cb0-7827-9244-cc79dfe822dc€9.00€0.19matched
3capture01a19fec-2942-78d5-a452-44a74b6c7972€24.00€0.37matched
4capture01a19fec-4757-72b4-8fa0-c9d1908dc366€15.00€0.26matched
5refund01a19fec-63fe-7bdd-b4aa-5a0021918be7-€3.00€0.00matched
6capture01a19fec-7d4a-72f0-b0b6-a2e1e572429f€24.00€0.37matched
7capture01a19fec-8ade-7946-beb9-75e89b7e7435€9.00€0.19matched
8capture01a19fec-8b5c-76e0-84e6-12cea96c6288€9.00€0.19matched
9capture01a19fec-dd0b-7cf2-8cfd-956905bf515a€9.00€0.19matched
10capture01a19fec-eb52-7f99-a422-844734b09091€49.00€0.67matched
11refund01a19fec-fb73-7822-9a23-a89eccf3864c-€4.00€0.00matched
12capture01a19fed-2359-79e6-acbc-d6b2e1640a27€9.00€0.19matched
13capture01a19fed-23fa-70f9-a787-75e167989a88€35.00€0.50matched
14capture01a19fed-24db-717c-aa96-aeb9d5fbfce7€49.00€0.67matched
15capture01a19fed-24e7-7f3d-a49d-01647652c9d4€24.00€0.37matched
16capture01a19fed-2d5b-78a2-b47b-46b643184b1d€15.00€0.26matched
17capture01a19fed-391e-789e-9ac5-f36ee492d6fb€35.00€0.50matched
18capture01a19fed-3ee9-773f-8467-03a8308d2bc0€24.00€0.37matched
19capture01a19fed-43f7-7527-86b8-3cb094eac3e6€35.00€0.50matched
20capture01a19fed-5c4e-72a5-8a38-0ae65ae2856b€9.00€0.19matched
21refund01a19fed-5d7d-7b5c-b66f-cdb577da28df-€32.00€0.00matched
22capture01a19fed-ad1d-7dd4-8534-1021612a8671€15.00€0.26matched
23capture01a19fed-b8a5-7039-a6dc-3863ebb6d4d9€35.00€0.50matched
24capture01a19fed-c947-762b-a611-757842a68cc4€24.00€0.37matched
25capture01a19fed-ec07-77cf-a100-a579c8862b90€49.00€0.67matched
26capture01a19fee-0966-74cd-9ace-c41f64e67e2c€49.00€0.67matched
27capture01a19fee-2c51-7f04-beb5-5d44fce415df€9.00€0.19matched
28capture01a19fee-4125-7170-a5da-891b007cc01b€9.00€0.19matched
29capture01a19fee-4b03-7584-80ce-46e3f078e8ec€49.00€0.67matched
30capture01a19fee-5c47-7717-aae5-80dc26679379€49.00€0.67matched
31capture01a19fee-7223-7d4f-b4c9-3e94f09e0cdf€35.00€0.50matched
32capture01a19fee-a01d-71f7-8eca-66d2e677e172€15.00€0.26matched
33capture01a19fee-b197-7047-ae33-2bd089138af0€15.00€0.26matched
34capture01a19fee-b4c5-7801-a9f2-e4d1c0eb9621€49.00€0.67matched
35refund01a19fee-bf57-73e6-bc55-dff2dd812277-€33.00€0.00matched
36capture01a19fef-36b5-716d-8414-c21beb600c3f€35.00€0.50matched
37capture01a19fef-3ca3-78f2-8570-bb4a355149da€15.00€0.26matched
38capture01a19fef-4072-7fba-8118-03a113400e38€9.00€0.19matched
39capture01a19fef-5daf-79a5-9ad1-721a768034d4€49.00€0.67matched
40capture01a19fef-60c7-779f-8622-1cd1375b4150€9.00€0.19matched
41capture01a19fef-6aae-77fd-9f4f-aaf1333a54b0€24.00€0.37matched
42capture01a19fef-819a-77d5-88a2-d9e027e8bb38€9.00€0.19matched
43refund01a19fef-b89b-7eea-9e2c-ac84733ce416-€4.00€0.00matched
44capture01a19fef-d2ec-7d7a-8353-b90c3c80c78f€15.00€0.26matched
45capture01a19ff0-1eb4-71b4-9b02-ae26fb85564e€35.00€0.50matched
46capture01a19ff0-3461-73ec-a7dd-160d4d75d134€9.00€0.19matched
47capture01a19ff0-420a-7e70-a460-c7d2a1c059be€15.00€0.26matched
48capture01a19ff0-4dd4-7e73-adfa-5da2ec7d4c33€49.00€0.67matched
49capture01a19ff0-67e6-7921-91fc-808a3c3cfba7€15.00€0.26matched
50capture01a19ff0-76df-751e-9f41-8572677360e0€9.00€0.19matched
51capture01a19ff0-7d39-78d6-b4c4-06ab0935d9ad€35.00€0.50matched
52capture01a19ff0-8687-7131-842e-c8b9c31da2b0€9.00€0.19matched
53capture01a19ff0-9d98-749b-92f1-ed367735cb98€49.00€0.67matched
54capture01a19ff0-ab65-7b79-a8a9-892cdb9a2815€15.00€0.26matched
55capture01a19ff0-c1c4-72df-be10-84228f193a2b€35.00€0.50matched
56capture01a19ff0-c48f-7cf6-97c6-e9625feb0a8a€35.00€0.50matched
57capture01a19ff0-e94a-7e7d-b86b-b82afdae8e27€9.00€0.19matched
58capture01a19ff1-05db-7103-a38e-051d62ae63e0€49.00€0.67matched
59capture01a19ff1-08b1-74b6-aecd-1f0f592ee30b€49.00€0.67matched
60capture01a19ff1-08f0-7e71-ad3c-b096e86c5c1d€9.00€0.19matched
61capture01a19ff1-7aa6-7de7-8c0d-52ea0c40531e€9.00€0.19matched
62capture01a19ff1-7ad1-7415-bd36-32bc66cc73da€15.00€0.26matched
63capture01a19ff1-8bee-7c5e-9ac8-1cf9419f05f4€35.00€0.50matched
64capture01a19ff1-c5db-72e7-bf2f-76b82d88172c€15.00€0.26matched
65capture01a19ff1-dbc2-7aac-b9fe-76e3a1bd445c€9.00€0.19matched
66capture01a19ff1-fa12-7efb-beb4-3a63d18b5e02€24.00€0.37matched
67capture01a19ff2-1021-7d55-94ab-e0aa0a2542af€15.00€0.26matched
68capture01a19ff2-328c-7f40-afdc-e01438a7bc20€9.00€0.19matched
69capture01a19ff2-61e7-7283-b451-0c80e5bf2f83€9.00€0.19matched
70capture01a19ff2-6d75-7b84-9a59-087063e33246€15.00€0.26matched
71capture01a19ff2-fb86-7d5a-9610-330466f1ed36€49.00€0.67matched
72capture01a19ff2-fd22-7de5-b627-3220e7b45d02€35.00€0.50matched
73capture01a19ff2-fe99-7051-891f-448b871b7534€9.00€0.19matched
74capture01a19ff3-012c-70c4-9043-7586cf994642€49.00€0.67matched
75capture01a19ff3-0a22-7dc7-8575-db4d6d85d1ae€9.00€0.19matched
76refund01a19ff3-4467-7937-ae90-e9970ec86eeb-€11.00€0.00matched
77capture01a19ff3-4ebe-7472-80c3-eb47a47981b8€24.00€0.37matched
78capture01a19ff3-512b-7e41-8fb9-439a64f4f1e3€15.00€0.26matched
79capture01a19ff3-6629-781d-8dae-550d876239b0€49.00€0.67matched
80capture01a19ff3-758f-75a0-8998-317c8d299b6b€24.00€0.37matched
81capture01a19ff3-9f07-78f4-bd12-6480c8e4126a€49.00€0.67matched
82capture01a19ff3-a71a-71ac-b9c1-f2de42a9d355€24.00€0.37matched
83refund01a19ff3-b578-7216-af2e-d394a8b8faca-€5.00€0.00matched
84capture01a19ff3-bc25-7823-b6c7-c475bad08b30€35.00€0.50matched
85capture01a19ff3-c5ea-7858-9e71-71cf38c73d18€15.00€0.26matched
86refund01a19ff3-d1da-7e6f-80d9-9e968c978bff-€17.00€0.00matched
87capture01a19ff3-d3a2-74da-ba58-52efcf2a5f26€49.00€0.67matched
88capture01a19ff3-d8db-7e8d-b5af-2291a0550955€35.00€0.50matched
89capture01a19ff3-ec51-7107-ae1c-66234d07574e€35.00€0.50matched
90capture01a19ff4-0df0-701c-bd20-734602ebd569€9.00€0.19matched
91refund01a19ff4-5292-7253-9b83-c1169c20b39e-€4.00€0.00matched
92capture01a19ff4-65aa-7ccb-8aab-ca9c53d6016e€35.00€0.50matched
93capture01a19ff4-7e49-76c4-83f2-7c73c722dd18€24.00€0.37matched
94capture01a19ff4-7eab-756a-8ae4-6140c884ecbb€49.00€0.67matched
95capture01a19ff4-8077-7a37-b569-eda8c0b916e9€49.00€0.67matched
96capture01a19ff4-8532-76be-a7ec-b43ec1a4e0f4€24.00€0.37matched
97capture01a19ff4-aa91-7a42-84c8-30d32041d213€35.00€0.50matched
98capture01a19ff4-af97-7a8b-b256-978b08b4f56d€24.00€0.37matched
99capture01a19ff4-b86e-700a-830c-8d3028e06280€24.00€0.37matched
100capture01a19ff4-b9b9-723a-856d-4d7e472ae1c4€49.00€0.67matched
101capture01a19ff4-eefd-76a3-89f7-fcd0d696821b€24.00€0.37matched
102capture01a19ff4-f20c-7653-aa1b-9a3a13a5abad€24.00€0.37matched
103capture01a19ff4-fd2b-7c32-8840-b8d3d176a81f€15.00€0.26matched
104capture01a19ff5-007b-71eb-9ae6-8194afe69869€24.00€0.37matched