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

6 Nov, 01:30

Gross

€3,172.00

PSP fee

€50.11

Net to the bank

€3,121.89

Settlement journal

#407540

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 38, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
  • missing linein the books, not in the filecapture:01a1ae80-a0f1-7250-a7fa-0cc3e6560a94 is in no file
LineKindReferenceGrossFeeStatus
94capture01a1ae7f-e530-7cec-9727-eada0ead38ae€24.00€0.38fee difference
122capture01a1ae81-fe9c-70a5-bd60-fd482b0d1b47€35.00€0.54fee difference
1capture01a1ae78-9a95-74d8-ad63-37bac58ab846€49.00€0.67matched
2capture01a1ae78-ce3e-789f-b074-66a1a75eac37€35.00€0.50matched
3refund01a1ae79-b87b-7ff8-9817-034f31e2efa5-€48.00€0.00matched
4capture01a1ae7a-249e-74cd-95f7-0b7e7fa70229€24.00€0.37matched
5capture01a1ae7a-3fdc-7898-bc21-753c10db2bc5€24.00€0.37matched
6capture01a1ae7a-492d-7254-9b5b-3f893304d94d€15.00€0.26matched
7capture01a1ae7a-7111-72f7-8ec5-b10b88fffdec€15.00€0.26matched
8capture01a1ae7a-7cca-7128-8361-382b6f63cef0€35.00€0.50matched
9capture01a1ae7a-81aa-7779-90ed-82e5404cd0c6€9.00€0.19matched
10capture01a1ae7a-8bf9-7d00-ae1c-0c089204a8bb€24.00€0.37matched
11capture01a1ae7a-8c9f-7496-9663-dab26bf03424€35.00€0.50matched
12capture01a1ae7a-a3fb-71d9-a2e4-b6f391005e72€15.00€0.26matched
13capture01a1ae7a-ba26-7e9d-a39f-1a907136391f€49.00€0.67matched
14capture01a1ae7a-bd66-74d8-b912-08f89ed8dbd8€49.00€0.67matched
15capture01a1ae7a-c484-7133-9591-1f3f28d6a5b0€24.00€0.37matched
16capture01a1ae7a-d943-76ef-9ce1-094f7475502d€35.00€0.50matched
17capture01a1ae7a-dc3b-7285-af69-64a042bdffdc€35.00€0.50matched
18capture01a1ae7b-08cc-718a-99ec-eea54c92bbe5€35.00€0.50matched
19capture01a1ae7b-1698-7505-a354-ed034f73242f€9.00€0.19matched
20capture01a1ae7b-1e79-707a-9a40-f12da8aa4bca€49.00€0.67matched
21capture01a1ae7b-26f2-762e-82f1-61b6a3d467c9€9.00€0.19matched
22capture01a1ae7b-477d-7d17-bd6b-52e9f0a4ed8c€9.00€0.19matched
23capture01a1ae7b-6538-7bc2-b1b6-5445b2a4bcc9€49.00€0.67matched
24capture01a1ae7b-6763-73f6-95ce-defc37726db4€9.00€0.19matched
25capture01a1ae7b-67b3-722c-bf0b-04a64d092c57€15.00€0.26matched
26refund01a1ae7b-7f1d-7d97-8679-58a53c88f20e-€5.00€0.00matched
27capture01a1ae7b-8015-77a1-93fa-47db22912dff€24.00€0.37matched
28capture01a1ae7b-8d88-7697-a25f-c91786a00e0b€9.00€0.19matched
29capture01a1ae7b-9989-71b5-b815-754349696125€49.00€0.67matched
30capture01a1ae7b-9eec-7a52-a58a-be69ff240ae1€49.00€0.67matched
31capture01a1ae7b-d8ab-799d-8120-6817392f0a0b€15.00€0.26matched
32capture01a1ae7b-d9df-712b-a585-3dd4246e93ea€24.00€0.37matched
33capture01a1ae7b-e7a3-76ca-8e71-6462f85dcd74€35.00€0.50matched
34capture01a1ae7c-022f-7c9f-9546-234faa445e0b€24.00€0.37matched
35capture01a1ae7c-2a46-7cbc-b031-4139380d423d€49.00€0.67matched
36refund01a1ae7c-3791-7ff8-871f-a49caa1c08ca-€11.00€0.00matched
37capture01a1ae7c-6d89-754a-a845-a6264ef0eeff€15.00€0.26matched
38capture01a1ae7c-79a1-7ddd-9921-0291a9e73e38€49.00€0.67matched
39capture01a1ae7c-821c-7218-90a8-2bf271a6c4ca€9.00€0.19matched
40capture01a1ae7c-823b-73ae-b8eb-f202dfbb5376€15.00€0.26matched
41capture01a1ae7c-966d-7a1c-93ee-a760fa225f3d€24.00€0.37matched
42capture01a1ae7c-be76-7e0f-821d-af43486ed603€35.00€0.50matched
43capture01a1ae7c-c028-7ded-98a7-fba057cb7115€9.00€0.19matched
44capture01a1ae7c-c0cc-796b-b428-28bed395c939€49.00€0.67matched
45capture01a1ae7c-c19f-71c7-8112-16a9e777437b€9.00€0.19matched
46capture01a1ae7c-c597-778a-9ad8-0cbe850f288e€15.00€0.26matched
47capture01a1ae7c-e775-792f-8cda-e01c097eba05€15.00€0.26matched
48capture01a1ae7c-fd4d-7901-817e-528299e1b57f€24.00€0.37matched
49capture01a1ae7d-0502-7c4f-8f82-eba7be28c2bf€15.00€0.26matched
50capture01a1ae7d-0e87-7d81-a2eb-80b51135e858€24.00€0.37matched
51refund01a1ae7d-16d4-74d3-ac25-f429a201d123-€19.00€0.00matched
52capture01a1ae7d-1b16-7bb1-9b60-b813274873c7€24.00€0.37matched
53capture01a1ae7d-1e5b-795f-acfa-87394098b011€9.00€0.19matched
54capture01a1ae7d-211d-7521-8406-03c165dfa6c4€35.00€0.50matched
55capture01a1ae7d-2322-798c-84ed-2e816ba00b71€24.00€0.37matched
56capture01a1ae7d-33cc-7156-b8f2-4ef1bfd649f2€35.00€0.50matched
57capture01a1ae7d-36f4-75ae-a130-6b95a8775d38€35.00€0.50matched
58capture01a1ae7d-468f-7124-b14f-a64031f5ef27€49.00€0.67matched
59capture01a1ae7d-762c-7aba-8a8c-9e7a31efc880€35.00€0.50matched
60capture01a1ae7d-89b4-7009-bc2e-3db06c59fc02€15.00€0.26matched
61refund01a1ae7d-9082-7df7-925c-6d336e2fa202-€22.00€0.00matched
62capture01a1ae7d-af7b-7685-8060-a03572b42dc5€24.00€0.37matched
63capture01a1ae7d-dcbb-7f47-ab46-8a9d38373b14€9.00€0.19matched
64capture01a1ae7d-fad6-7ef9-9cec-f68fe6be6df2€15.00€0.26matched
65capture01a1ae7e-1f94-71a7-9a4c-cdcd2eee75d9€24.00€0.37matched
66capture01a1ae7e-2ad5-7e97-9791-119dc494eb22€49.00€0.67matched
67capture01a1ae7e-3318-7e71-839a-7be174d189f3€35.00€0.50matched
68capture01a1ae7e-3729-7707-9ea3-38578989212e€35.00€0.50matched
69capture01a1ae7e-53d9-78d9-ac84-fc4583fa88e5€49.00€0.67matched
70capture01a1ae7e-5ebe-7cff-bd86-30d4aa02f456€15.00€0.26matched
71capture01a1ae7e-61a8-78a1-8e9d-69e95638081d€49.00€0.67matched
72capture01a1ae7e-6d79-7548-891a-379c47e4c201€15.00€0.26matched
73capture01a1ae7e-6e9b-7f61-a97a-8c4f75fc1f21€9.00€0.19matched
74capture01a1ae7e-7b23-7eb6-b0b5-bc8edeeb1528€49.00€0.67matched
75capture01a1ae7e-8d7b-7a25-9a6e-a65eca500c7e€49.00€0.67matched
76capture01a1ae7e-94a8-76a4-bd56-74c4558cfb4a€24.00€0.37matched
77capture01a1ae7e-99c3-7d3e-a790-4c763ce26ec3€49.00€0.67matched
78capture01a1ae7e-bfbf-7a7f-bf1f-bb12c5b32d3b€24.00€0.37matched
79capture01a1ae7e-ff86-7306-874b-8623a5e50675€24.00€0.37matched
80capture01a1ae7f-00f1-747b-9779-4d14010a24dc€9.00€0.19matched
81capture01a1ae7f-1a76-727f-be79-da12251df7e1€15.00€0.26matched
82capture01a1ae7f-1c48-7533-b9e7-9a39c86bbcad€35.00€0.50matched
83capture01a1ae7f-3cb4-75ed-aef9-4f45e9e91761€9.00€0.19matched
84capture01a1ae7f-502f-74c0-8b5a-9fc305524d25€15.00€0.26matched
85refund01a1ae7f-61a2-7fcc-9ec4-8e42b88c5609-€14.00€0.00matched
86capture01a1ae7f-65b3-7609-80b5-3e552cec0a15€24.00€0.37matched
87capture01a1ae7f-692b-79b3-9d89-72d92a7481bb€49.00€0.67matched
88capture01a1ae7f-7298-718a-a4c1-42123c9bb856€35.00€0.50matched
89capture01a1ae7f-8df1-7896-ba59-436598956246€49.00€0.67matched
90refund01a1ae7f-9767-7661-963e-9de42faad755-€5.00€0.00matched
91capture01a1ae7f-9bff-76d9-83a0-354c31f3c717€49.00€0.67matched
92capture01a1ae7f-c39c-719e-a543-353198cc37a9€15.00€0.26matched
93capture01a1ae7f-cb26-7da3-a7d7-e34487dcf5cc€15.00€0.26matched
95capture01a1ae7f-e77a-77ee-b91f-18f80c5e89e5€9.00€0.19matched
96capture01a1ae7f-f4b2-73f7-82d9-6f71a8c90436€9.00€0.19matched
97capture01a1ae80-1412-7d76-9e56-6ece4a038fdd€9.00€0.19matched
98capture01a1ae80-380c-7b9c-915b-7dbe8fbdf7d6€49.00€0.67matched
99capture01a1ae80-59fa-7339-a8ab-cf4816931d9a€24.00€0.37matched
100capture01a1ae80-5dfc-745f-95a7-a6f842184a5c€24.00€0.37matched
101capture01a1ae80-6a48-7ef4-a7cf-fdecc69c6825€35.00€0.50matched
102capture01a1ae80-7d6b-72a5-a88a-f60b8ffa12af€24.00€0.37matched
103capture01a1ae80-b96e-72cf-91e7-d8081e1cf121€9.00€0.19matched
104capture01a1ae80-bcfe-7d37-8723-c128f387b914€15.00€0.26matched
105capture01a1ae80-cf5f-7785-8baf-87ec38c5a38d€24.00€0.37matched
106capture01a1ae80-db8d-75e1-ab23-61f70add575f€9.00€0.19matched
107capture01a1ae80-ded8-71d0-9078-a8002ebb0d28€49.00€0.67matched
108capture01a1ae80-f095-7d71-8350-58278e4c478d€49.00€0.67matched
109capture01a1ae81-0c63-76a8-9394-d57705c96e15€49.00€0.67matched
110capture01a1ae81-1736-77b3-93df-e07c7863bdc5€35.00€0.50matched
111capture01a1ae81-3788-761b-a0bd-40774bca59aa€15.00€0.26matched
112capture01a1ae81-44fc-7591-b9ec-ade034538ddf€35.00€0.50matched
113capture01a1ae81-47ba-7ca6-92e8-b65421fc0672€15.00€0.26matched
114capture01a1ae81-7ee8-7cc4-8738-358962af859a€24.00€0.37matched
115capture01a1ae81-9223-73ad-8c3e-a0afccd6dd7c€35.00€0.50matched
116capture01a1ae81-c00b-7dc7-8ccb-e3c7d77ac670€35.00€0.50matched
117capture01a1ae81-cb9d-7a2c-aab7-78701c90e7c2€9.00€0.19matched
118capture01a1ae81-d89e-7d0b-b4a4-8491243a35a3€49.00€0.67matched
119capture01a1ae81-df5c-76e1-b194-5fd7c0033fb3€15.00€0.26matched
120capture01a1ae81-e4b1-739e-9f64-c0fbe1c5dca9€35.00€0.50matched
121capture01a1ae81-f174-739a-928f-c153d342bdc8€49.00€0.67matched
123capture01a1ae82-0ecd-7ab2-8ee8-2346f2dd7a34€24.00€0.37matched
124refund01a1ae82-31ba-733c-a003-552bbb8b1cb9-€30.00€0.00matched
125capture01a1ae82-3e9c-73d7-8eb3-e487d507462c€9.00€0.19matched
126capture01a1ae82-4d3d-79fd-8d00-374476a22f38€49.00€0.67matched
127capture01a1ae82-94dc-7a88-8768-b88a2f87ce58€24.00€0.37matched
128capture01a1ae82-ad87-7d1d-a0d9-4fb05c654f41€35.00€0.50matched
129capture01a1ae82-be0b-7792-a545-e44c0b2161a4€9.00€0.19matched
130refund01a1ae82-be5b-7e33-8b72-076caa2785de-€13.00€0.00matched
131capture01a1ae82-c805-7e7d-a83e-e9172ea275d7€15.00€0.26matched
132capture01a1ae83-2d50-7178-93dc-9f79823f1078€9.00€0.19matched