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

4 Nov, 22:40

Gross

€3,001.00

PSP fee

€45.77

Net to the bank

€2,955.23

Settlement journal

#387088

Breaks for a person to look at

  • missing linein the books, not in the filecapture:01a1a8be-c1c3-7cd6-9ba3-ebe1914b2278 is in no file
LineKindReferenceGrossFeeStatus
1capture01a1a8b2-aed1-73bf-8b65-1f8dd59aec1a€15.00€0.26matched
2refund01a1a8b8-2401-78d6-b51d-7d377e8de6cc-€29.00€0.00matched
3capture01a1a8b8-3be6-74c1-a4de-571c5cd61afd€9.00€0.19matched
4capture01a1a8b8-64c8-70af-bda6-18208a733ca5€35.00€0.50matched
5capture01a1a8b8-6e56-74d6-92ec-a6b96eb3fec5€24.00€0.37matched
6capture01a1a8b8-ca18-7d0c-a59e-a5555bfc2b8d€49.00€0.67matched
7capture01a1a8b8-d8a4-7e9a-92d6-525a82a53d0b€15.00€0.26matched
8capture01a1a8b8-da55-7873-a435-28ba8b375ecd€15.00€0.26matched
9capture01a1a8b8-fcd3-740d-8f13-cb49d7b890d4€49.00€0.67matched
10capture01a1a8b9-0ddf-7d7b-b2d9-515549a49836€9.00€0.19matched
11capture01a1a8b9-12e7-7e9e-8f31-181cd91ea9d1€24.00€0.37matched
12capture01a1a8b9-25e4-74ae-ade8-5c02551e1a7c€35.00€0.50matched
13capture01a1a8b9-2b19-707d-8420-114469fb4cf8€49.00€0.67matched
14capture01a1a8b9-33d6-7536-9c9f-4dcd73abb9b6€49.00€0.67matched
15capture01a1a8b9-716e-70bd-9ab9-734a706e4656€49.00€0.67matched
16capture01a1a8b9-838e-75fc-9968-8d9fb2aa45cd€35.00€0.50matched
17capture01a1a8b9-c944-7f2f-8576-9c34243e464a€24.00€0.37matched
18capture01a1a8ba-0013-7ebf-b0c8-fae04891cbec€15.00€0.26matched
19capture01a1a8ba-0152-7195-bb99-5a523424ad52€9.00€0.19matched
20capture01a1a8ba-164e-71c1-b4fc-522b6b634202€9.00€0.19matched
21capture01a1a8ba-1f06-70c6-b64c-5fef870c7ab1€49.00€0.67matched
22capture01a1a8ba-1fb5-7f39-aff8-c73ae19c82f4€49.00€0.67matched
23capture01a1a8ba-4d1c-79b5-9c4a-ca52b8ca6184€15.00€0.26matched
24capture01a1a8ba-5b92-78cc-800e-146896bfa78d€49.00€0.67matched
25capture01a1a8ba-5be7-79a2-8b75-41910f3e7472€49.00€0.67matched
26capture01a1a8ba-6791-7e2d-8627-14d578b1a87f€35.00€0.50matched
27refund01a1a8ba-878b-7ee5-a7e5-a757b5bb000d-€8.00€0.00matched
28capture01a1a8ba-d81c-75a2-b37e-3a43c863d14e€35.00€0.50matched
29capture01a1a8ba-e3d1-70b9-a767-5073f1283a3c€9.00€0.19matched
30capture01a1a8ba-e997-7307-a204-2f1fbb2ef7e1€35.00€0.50matched
31capture01a1a8bb-39e5-7df6-af0c-c2566b308fe7€9.00€0.19matched
32capture01a1a8bb-4b1c-76b1-8bc0-97b8ae2aa5e2€24.00€0.37matched
33capture01a1a8bb-6387-760a-8657-d8edf19f3a20€35.00€0.50matched
34capture01a1a8bb-9287-7512-9674-a841f0151f3e€49.00€0.67matched
35capture01a1a8bb-9c43-74d8-8afd-a2ac7b8b17bd€24.00€0.37matched
36capture01a1a8bb-bfb3-7556-8ab4-29638e98ea89€49.00€0.67matched
37capture01a1a8bb-d210-779e-9fbc-c4b928cafa9c€15.00€0.26matched
38capture01a1a8bc-2d66-7d03-ba9d-dc471eb6e2a9€9.00€0.19matched
39capture01a1a8bc-359e-74d7-8718-9a07ef861090€49.00€0.67matched
40capture01a1a8bc-37b5-7a8d-9339-56f358e9fdef€9.00€0.19matched
41capture01a1a8bc-4f01-7f05-b98a-f59563f4512b€35.00€0.50matched
42capture01a1a8bc-5d6b-7839-9b63-413be522d067€35.00€0.50matched
43capture01a1a8bc-8531-72b1-b00f-1bc6221feeba€49.00€0.67matched
44capture01a1a8bc-9534-77c5-9cec-f779c55c2e5f€49.00€0.67matched
45refund01a1a8bc-ad29-7eeb-b003-5a8dda28da81-€21.00€0.00matched
46capture01a1a8bc-b729-7dc3-a38f-cab82fc8af12€24.00€0.37matched
47capture01a1a8bc-bb31-7f3e-98cc-efe5a98cf8bc€24.00€0.37matched
48capture01a1a8bc-eb9c-778f-98f4-e577cced3ee9€35.00€0.50matched
49capture01a1a8bc-eee3-7c35-80e5-375ebcf42360€49.00€0.67matched
50capture01a1a8bc-fe2d-73ad-a3c6-ea960ac39e00€49.00€0.67matched
51capture01a1a8bd-1806-74a3-8b5d-e73420788971€49.00€0.67matched
52capture01a1a8bd-2a5a-7504-9d17-f3989d23672d€35.00€0.50matched
53capture01a1a8bd-2eee-78ef-a1ec-9f574b84b525€15.00€0.26matched
54capture01a1a8bd-3617-759f-af68-7a2abc023581€24.00€0.37matched
55capture01a1a8bd-4d0b-7393-94f4-0b0f86db7b1c€49.00€0.67matched
56capture01a1a8bd-4db1-7b67-a54c-f9b0c7e3061f€15.00€0.26matched
57capture01a1a8bd-5392-7d38-ad2b-82f770758b10€35.00€0.50matched
58refund01a1a8bd-5570-7c9a-b241-afedb45fb2fa-€33.00€0.00matched
59capture01a1a8bd-5f88-7c1a-be04-236b36436514€15.00€0.26matched
60capture01a1a8bd-6383-7376-a1a0-4d7888e8b043€9.00€0.19matched
61capture01a1a8bd-65e8-7de1-b864-d10610fc66bb€49.00€0.67matched
62capture01a1a8bd-76d5-751d-8b72-226bdc7c49bd€15.00€0.26matched
63capture01a1a8bd-7dec-787e-ba4b-40b03403a1bf€24.00€0.37matched
64capture01a1a8bd-7fa1-772c-916d-f4c22c479bdf€24.00€0.37matched
65capture01a1a8bd-8154-7c0e-bf23-0a5fd0deab8c€15.00€0.26matched
66capture01a1a8bd-8619-706c-a67b-7557fc1ca389€35.00€0.50matched
67capture01a1a8bd-95bc-7297-90b5-b2ba59233ad5€49.00€0.67matched
68capture01a1a8bd-a131-7e57-93c5-45e2d8d04a46€35.00€0.50matched
69capture01a1a8bd-d11f-701b-a624-8991744c30e9€35.00€0.50matched
70capture01a1a8be-09ff-756d-8a53-9489134bcf8d€49.00€0.67matched
71capture01a1a8be-0d36-7964-903e-48476041d3ce€15.00€0.26matched
72capture01a1a8be-3563-72b0-b068-e4a43fed612e€24.00€0.37matched
73capture01a1a8be-3756-7e47-9a2e-3676e2e976b8€9.00€0.19matched
74capture01a1a8be-5077-7b94-ac11-5da3eff2d7fc€9.00€0.19matched
75capture01a1a8be-7a12-724b-b11b-be04c1d117df€9.00€0.19matched
76capture01a1a8be-9bdb-7d21-b9b4-305256117d4b€35.00€0.50matched
77capture01a1a8be-b6ab-7817-85c3-d7011c670ced€49.00€0.67matched
78capture01a1a8be-ca0c-742b-ae03-54a52f89d7e2€15.00€0.26matched
79capture01a1a8be-d63a-7846-85ec-ad1ff3c75f3c€49.00€0.67matched
80capture01a1a8be-f293-78f0-8aaa-2af7f25e736d€15.00€0.26matched
81capture01a1a8bf-0dad-7dfa-a1b1-113c2d6dc359€24.00€0.37matched
82capture01a1a8bf-3041-77d0-a1c7-ae3ce4817cf6€15.00€0.26matched
83capture01a1a8bf-3bd7-74cc-a93a-dcdf7302f68d€9.00€0.19matched
84capture01a1a8bf-3dd2-742a-b709-747052bc6ced€9.00€0.19matched
85capture01a1a8bf-3fe6-7e3b-8cdd-1af7e8369c9d€35.00€0.50matched
86capture01a1a8bf-48dd-732c-817f-2b00bf96efb8€15.00€0.26matched
87capture01a1a8bf-4f0f-7152-ab83-4e73e65b9def€15.00€0.26matched
88capture01a1a8bf-5391-7877-9b2a-5181bc4e0501€9.00€0.19matched
89capture01a1a8bf-59b6-7200-a6fa-3c197a6d806c€49.00€0.67matched
90capture01a1a8bf-5ed1-791d-8f6d-17a384135c1d€24.00€0.37matched
91capture01a1a8bf-626a-7ea0-9e2d-79e62cfc6d77€15.00€0.26matched
92capture01a1a8bf-7d65-75db-b878-4da12457a773€49.00€0.67matched
93capture01a1a8bf-8941-74be-80f9-251e0d985fff€49.00€0.67matched
94capture01a1a8bf-89b7-7496-9c25-efac49625a14€24.00€0.37matched
95capture01a1a8bf-8d76-71ab-9e54-c4b3f88aad7c€49.00€0.67matched
96capture01a1a8bf-aafc-79b1-958c-dcb73340dfe1€49.00€0.67matched
97refund01a1a8bf-afde-73e0-8f35-eb4f7e132880-€5.00€0.00matched
98capture01a1a8bf-b231-769b-9b41-0489ab9300b6€15.00€0.26matched
99capture01a1a8c0-1b87-764b-a484-78cf15433993€15.00€0.26matched
100capture01a1a8c0-2cdd-76c6-ae9d-c9ea574d3ccd€49.00€0.67matched
101capture01a1a8c0-3b11-7f53-882e-e414b5169b33€35.00€0.50matched
102capture01a1a8c0-4af9-7e69-8ea9-c68854952c7d€35.00€0.50matched
103capture01a1a8c0-653c-7040-9ea6-6af985cba086€9.00€0.19matched
104capture01a1a8c0-8cfc-7f36-b067-d5d60f4b1db0€49.00€0.67matched
105capture01a1a8c0-8dab-7167-bd66-38bc03f4ae29€9.00€0.19matched
106capture01a1a8c0-90c2-72b4-8875-57f68ec43ff4€35.00€0.50matched
107capture01a1a8c0-9a33-7e2c-847b-7bfa78ef4c21€49.00€0.67matched
108capture01a1a8c0-a1b5-7421-b5fc-02f33d2f3d7d€15.00€0.26matched
109capture01a1a8c0-c39c-7bb0-b827-beda41b7fae2€24.00€0.37matched
110capture01a1a8c1-0b78-7a83-bc63-f1ce031be706€15.00€0.26matched
111capture01a1a8c1-1aa9-76d0-892b-fe93f9e022e8€35.00€0.50matched