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

5 Nov, 08:50

Gross

€3,008.00

PSP fee

€47.62

Net to the bank

€2,960.38

Settlement journal

#394842

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
  • missing linein the books, not in the filecapture:01a1aaea-20db-7159-af48-c3d6681846e9 is in no file
  • missing linein the books, not in the filecapture:01a1aaea-fa43-79c6-8b27-bfacc0eabd3c is in no file
LineKindReferenceGrossFeeStatus
111capture01a1aaed-f994-77c7-ae70-fda8b6c75251€9.00€0.22fee difference
1capture01a1aae0-eca2-7b58-b771-ebd5f4bac6b2€49.00€0.67matched
2capture01a1aae6-5772-76cf-aaa2-804c51a14f53€49.00€0.67matched
3capture01a1aae6-a366-7a68-a4a7-4e227427f435€35.00€0.50matched
4capture01a1aae6-de91-7ff0-a4ec-c95f1215ae63€35.00€0.50matched
5capture01a1aae6-e5b7-7394-b3b2-6f621565d33b€49.00€0.67matched
6capture01a1aae7-1872-7099-8345-629fe8968de6€9.00€0.19matched
7capture01a1aae7-2398-784a-96a6-5102f0449312€24.00€0.37matched
8capture01a1aae7-2ee3-78d6-af42-1c9bed47175a€49.00€0.67matched
9capture01a1aae7-3ea4-7cf0-a6f3-ceafe7ad9b9a€24.00€0.37matched
10capture01a1aae7-43ef-72a6-8da5-ad5db2dcde0c€49.00€0.67matched
11capture01a1aae7-46cf-77a7-a8ce-71aba1c260a1€15.00€0.26matched
12capture01a1aae7-4d19-78a0-b2d8-42c7723cdc80€9.00€0.19matched
13capture01a1aae7-4efe-70d6-ae88-d4325800a6b3€24.00€0.37matched
14capture01a1aae7-5a6b-7015-9e53-499e3a5fa6cc€9.00€0.19matched
15capture01a1aae7-78b5-71f8-81df-9571cd13f7da€49.00€0.67matched
16capture01a1aae7-7e91-7a43-af2d-70f0ac863c6c€15.00€0.26matched
17capture01a1aae7-89c0-7fce-a0dc-8ada4fed41a2€49.00€0.67matched
18capture01a1aae7-8fa9-7990-a69a-c9ea9d7a147f€49.00€0.67matched
19refund01a1aae7-a5c4-7848-9edd-319fc3645188-€22.00€0.00matched
20capture01a1aae8-048c-7c9b-8541-3fb3cff745f5€9.00€0.19matched
21capture01a1aae8-1a00-7df2-858f-e7e6d3bad133€35.00€0.50matched
22capture01a1aae8-2245-760b-bc0c-40809b8b13ea€49.00€0.67matched
23capture01a1aae8-28fc-72ff-9644-1c29626d8ae4€15.00€0.26matched
24capture01a1aae8-3b67-740d-a6b1-7b4940a8163c€15.00€0.26matched
25capture01a1aae8-5023-7625-a7c2-c3639613f62b€15.00€0.26matched
26capture01a1aae8-94ec-717a-b7c2-87a5e73fcc9c€35.00€0.50matched
27capture01a1aae8-9f52-7008-bdee-f637b1c36552€35.00€0.50matched
28refund01a1aae8-ab6c-7d38-aa9f-dbdbbf4606c5-€10.00€0.00matched
29capture01a1aae8-afa7-74d0-afda-1d6131578c05€9.00€0.19matched
30capture01a1aae8-b851-7a57-8fa8-1f6553a16383€15.00€0.26matched
31capture01a1aae8-d9cf-7eb9-b9f2-2e97d7752615€15.00€0.26matched
32refund01a1aae8-efff-7ab7-be0d-ef7ca2364bbc-€27.00€0.00matched
33capture01a1aae8-f9ea-7df8-9f80-0cfa52747f1f€9.00€0.19matched
34capture01a1aae8-fb67-74ec-bcab-51fd69971d24€24.00€0.37matched
35capture01a1aae9-0da3-7784-8cfd-3a0e383a4ab1€49.00€0.67matched
36capture01a1aae9-2004-76c7-9b94-9887fd4d7932€24.00€0.37matched
37capture01a1aae9-2da5-7799-b778-a471ca67088e€9.00€0.19matched
38refund01a1aae9-385d-728c-a2c3-39b0d3754636-€9.00€0.00matched
39capture01a1aae9-3f78-7e07-a0be-45c1cdefe240€15.00€0.26matched
40capture01a1aae9-57f9-763c-8200-240d38342e57€15.00€0.26matched
41capture01a1aae9-6632-7c12-92c0-051d533e1988€49.00€0.67matched
42capture01a1aae9-7917-7be6-ba81-d20ed67749ff€15.00€0.26matched
43capture01a1aae9-81de-79aa-8d45-47d7c87b183f€9.00€0.19matched
44capture01a1aae9-89e0-7562-93eb-7ac8897aaabc€24.00€0.37matched
45capture01a1aae9-9e2b-72d4-aa7d-46ad87b41d93€49.00€0.67matched
46capture01a1aae9-9f01-7056-9768-27ba0311e74d€15.00€0.26matched
47capture01a1aae9-c1af-7628-8426-6e2405291719€9.00€0.19matched
48capture01a1aae9-d454-7cdc-9148-4f0309fe2604€35.00€0.50matched
49capture01a1aae9-eac7-7de3-ac24-2cb9aae76790€9.00€0.19matched
50capture01a1aae9-f25d-7911-88bc-029aab13fd6d€49.00€0.67matched
51capture01a1aae9-f372-7004-9410-712fee03bc93€49.00€0.67matched
52capture01a1aae9-fd5d-7e6b-ad11-059b9adc9de9€9.00€0.19matched
53capture01a1aaea-18b3-73c0-babb-b33dfc37c18b€49.00€0.67matched
54refund01a1aaea-2a5a-744f-9dd1-0831b138d980-€22.00€0.00matched
55capture01a1aaea-2c69-7489-a47b-5cecf28b9d8f€35.00€0.50matched
56capture01a1aaea-2d4b-7456-a5d0-9dea79df4387€35.00€0.50matched
57capture01a1aaea-47a8-74ef-920c-1f115d9e9e44€35.00€0.50matched
58capture01a1aaea-67ce-7601-8406-6b120fafd144€9.00€0.19matched
59capture01a1aaea-728d-75a0-95c2-06a047add90b€24.00€0.37matched
60capture01a1aaea-8331-7aa1-a4f3-78d473528e99€49.00€0.67matched
61capture01a1aaea-84ac-7ff2-b907-7662f172ed4e€24.00€0.37matched
62capture01a1aaea-9703-7b9d-8778-54aa5910f8ad€49.00€0.67matched
63capture01a1aaea-9e35-7a39-9c4b-12f6ae204d14€15.00€0.26matched
64capture01a1aaea-ac7d-79ab-9f38-fe7dbbe3544b€49.00€0.67matched
65capture01a1aaea-bc7f-7bb2-92cb-d2a471d6ff8f€9.00€0.19matched
66capture01a1aaea-e236-7598-b79e-f029dd51a398€15.00€0.26matched
67capture01a1aaea-f460-770d-9e3b-fe1eb50e8661€24.00€0.37matched
68capture01a1aaea-f993-7377-bf14-488416631542€9.00€0.19matched
69capture01a1aaeb-1034-798a-99bd-d2a01de862d3€49.00€0.67matched
70capture01a1aaeb-10f0-7a75-b293-76b9abdacb5e€35.00€0.50matched
71capture01a1aaeb-2322-7a4d-b8b9-a769ee762209€15.00€0.26matched
72capture01a1aaeb-3049-7be6-859e-329623be7171€35.00€0.50matched
73capture01a1aaeb-3162-7f32-91a8-c702bc3b47e2€35.00€0.50matched
74capture01a1aaeb-4660-766f-a114-a4390a0c67c6€35.00€0.50matched
75capture01a1aaeb-5de8-7c13-aede-e70768eb96eb€35.00€0.50matched
76capture01a1aaeb-a29f-7d3e-b757-89d59d419287€24.00€0.37matched
77capture01a1aaeb-a886-7cfe-86e5-d2ebea1d2395€24.00€0.37matched
78capture01a1aaeb-a964-7f4e-b891-6a079b79d818€49.00€0.67matched
79capture01a1aaeb-cf5e-7c7f-bb79-be548b1412d7€35.00€0.50matched
80capture01a1aaeb-e772-7e7d-8d37-4d6629a5cd66€15.00€0.26matched
81capture01a1aaec-0860-7926-8680-a046d3ba528e€15.00€0.26matched
82capture01a1aaec-0e0e-79c2-ab03-da278342b3d1€9.00€0.19matched
83refund01a1aaec-1d81-7a99-aeaf-b36d54a68ffa-€4.00€0.00matched
84capture01a1aaec-20ea-7dbc-9a95-f5b6e40800b5€9.00€0.19matched
85capture01a1aaec-3f60-736b-b337-e17031b97058€49.00€0.67matched
86capture01a1aaec-449f-75cb-a799-733b5dc6a28c€9.00€0.19matched
87refund01a1aaec-6a3c-7a96-80dd-86c43d2cfd49-€6.00€0.00matched
88capture01a1aaec-78d2-7d90-ae7d-d8195cf35ae3€9.00€0.19matched
89capture01a1aaec-8afa-771b-8ee7-c1af5ef86d52€9.00€0.19matched
90capture01a1aaec-9cd6-7d1f-a1c5-9f0f92497baa€24.00€0.37matched
91capture01a1aaec-a2df-7eea-9b86-54ff3cb4f36d€9.00€0.19matched
92capture01a1aaec-b3cf-7aaf-b89e-583910c97a53€15.00€0.26matched
93capture01a1aaec-b5e9-770e-8614-51009b0504d6€15.00€0.26matched
94capture01a1aaec-b826-7b6c-98fd-3e66fc6b9f3d€24.00€0.37matched
95capture01a1aaed-03ca-7e2a-afb9-81d319c585ef€15.00€0.26matched
96capture01a1aaed-0ba6-7508-8ac3-320cb9c712fe€24.00€0.37matched
97capture01a1aaed-25db-7d33-9a4a-8b12fd9edd29€9.00€0.19matched
98capture01a1aaed-276e-783d-92db-020276c55c37€35.00€0.50matched
99capture01a1aaed-3ccb-72bf-8b51-208b0b4745ca€9.00€0.19matched
100capture01a1aaed-40c6-7e18-90ce-0b50fcbd0c13€9.00€0.19matched
101capture01a1aaed-44ae-733a-a3f2-b9ee7fb1e7b6€24.00€0.37matched
102capture01a1aaed-4c02-784b-a065-6f7c1ef32697€9.00€0.19matched
103capture01a1aaed-577c-7821-be44-cf2ea5a13f41€9.00€0.19matched
104capture01a1aaed-7d0c-7707-baa5-d589a9e008c1€24.00€0.37matched
105capture01a1aaed-8e15-7aaf-84db-7daa26cf7055€24.00€0.37matched
106capture01a1aaed-9093-78df-a8c9-a07f8af2825b€15.00€0.26matched
107capture01a1aaed-90b0-76cf-9b52-0169c2361a4f€9.00€0.19matched
108capture01a1aaed-9ba6-79c7-8993-b6701711ed01€9.00€0.19matched
109capture01a1aaed-ce6a-770b-b77a-627cf66d8af1€9.00€0.19matched
110capture01a1aaed-d1ac-7a76-bea5-d80757cda5b1€35.00€0.50matched
112capture01a1aaed-f9a0-7994-b301-975bf605ceab€15.00€0.26matched
113capture01a1aaee-0199-7d82-8b24-48ecaad6c048€49.00€0.67matched
114capture01a1aaee-0efb-7fdc-a35f-120d43cac439€24.00€0.37matched
115refund01a1aaee-13cf-77c6-a61b-39aa623366dc-€5.00€0.00matched
116capture01a1aaee-3ba9-7d3c-849d-302a3bbf2e0c€24.00€0.37matched
117capture01a1aaee-4c7e-792f-a7a2-6a7fe041e128€15.00€0.26matched
118refund01a1aaee-5195-7d9d-acbb-713767ff11cd-€4.00€0.00matched
119capture01a1aaee-58d3-7936-bdd9-09c0f0d23b49€49.00€0.67matched
120capture01a1aaee-6dde-7a60-be7a-83ab807b2ce2€49.00€0.67matched
121capture01a1aaee-6e48-7c2b-890e-f5bf12f793a5€49.00€0.67matched
122capture01a1aaee-8b76-79b4-8fee-43fcbc82df02€9.00€0.19matched
123capture01a1aaee-af48-7c43-a8cc-f13d08fe2187€15.00€0.26matched
124capture01a1aaee-b2a5-79ec-9e5e-9cbcc84af644€49.00€0.67matched
125capture01a1aaee-c548-7747-bad9-ed11462e27e3€49.00€0.67matched
126capture01a1aaee-db65-7e41-a03f-9c0d00104bf0€49.00€0.67matched
127capture01a1aaef-2852-78ed-810d-ffb6a6b98626€35.00€0.50matched
128capture01a1aaef-2b8e-71d3-9896-0f80de6ee621€49.00€0.67matched
129refund01a1aaef-842e-7ab6-859e-d2c37ae0c4d5-€29.00€0.00matched
130capture01a1aaef-a1fc-7d4b-8a74-0a87a1bc2a7b€9.00€0.19matched
131capture01a1aaef-b31f-75a5-88ba-a3da123152ab€15.00€0.26matched