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

Gross

€3,182.00

PSP fee

€49.96

Net to the bank

€3,132.04

Settlement journal

#403800

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ad6b-ef01-72e6-8eb4-c9a09d4c04c2 is already settled by stl_EUR_2989851 line 61
LineKindReferenceGrossFeeStatus
62capture01a1ad6b-ef27-77e7-aa68-2bdfcaa5c743€9.00€0.19duplicate line
1capture01a1ad60-a8fb-782c-bca7-b9f4dc1f31f7€9.00€0.19matched
2capture01a1ad60-ecae-75be-906b-a26d5bb6ebda€35.00€0.50matched
3capture01a1ad61-135e-7d9f-96e5-ce369a12927b€49.00€0.67matched
4capture01a1ad64-3552-70d6-92cf-8594d7ab1dcd€35.00€0.50matched
5capture01a1ad67-73a3-7d97-8761-ac7f2eb01f5e€24.00€0.37matched
6capture01a1ad67-920b-7b52-ac2f-0ffb307f0f6b€35.00€0.50matched
7refund01a1ad67-b6a8-7979-b1a5-ad3ec8ce3950-€7.00€0.00matched
8capture01a1ad67-baf5-7fc9-b13f-ab7b2adf28df€15.00€0.26matched
9capture01a1ad67-d4bd-7cc8-8fa1-908aa6a2a6e1€15.00€0.26matched
10capture01a1ad67-ed15-7703-ba33-72f3c8011c2e€9.00€0.19matched
11capture01a1ad68-3341-7a2b-a260-edac991bf095€24.00€0.37matched
12capture01a1ad68-3c36-78ef-aaef-6d050db9f19a€9.00€0.19matched
13capture01a1ad68-4941-7c68-8319-f60e0cebe948€15.00€0.26matched
14capture01a1ad68-4f71-718a-a68b-3b228714d2f1€35.00€0.50matched
15capture01a1ad68-5628-79f9-b1a2-357632535129€15.00€0.26matched
16capture01a1ad68-62d4-7dff-92d3-f770006c2dc3€24.00€0.37matched
17refund01a1ad68-8fff-7725-bda5-d79fed27a354-€20.00€0.00matched
18capture01a1ad68-db49-7289-b8ed-cfde496a3967€35.00€0.50matched
19capture01a1ad68-dba8-7f2e-839d-82a299db1e34€35.00€0.50matched
20capture01a1ad68-e197-7edd-8cc4-e7446c1c21fe€49.00€0.67matched
21capture01a1ad69-35ae-75c8-9524-de1dce937442€15.00€0.26matched
22capture01a1ad69-386e-7fca-ab12-843f9a72d78c€35.00€0.50matched
23capture01a1ad69-58cb-7bbf-8e1d-ee92be868040€49.00€0.67matched
24capture01a1ad69-6c5e-742b-adf2-6944ea73893f€24.00€0.37matched
25capture01a1ad69-776c-7e29-b5a3-047a2c6ab1ad€9.00€0.19matched
26refund01a1ad69-781b-7936-ac94-5caef6c128d5-€3.00€0.00matched
27capture01a1ad69-9dd9-79b3-a1b2-8f25140ec5ed€24.00€0.37matched
28capture01a1ad69-aebd-7fc3-ad4a-24c79b80c8a8€24.00€0.37matched
29capture01a1ad69-aedf-7d03-994a-e21d400188da€49.00€0.67matched
30capture01a1ad69-b3d8-7665-a14b-44b80fb04c46€9.00€0.19matched
31capture01a1ad69-d3bc-7f52-aedb-d0636e2d28e3€35.00€0.50matched
32capture01a1ad69-d3cd-7c9e-aaf6-e97625546d74€24.00€0.37matched
33capture01a1ad69-dc19-718a-9241-7961d3a8f288€35.00€0.50matched
34capture01a1ad69-e91f-77ab-a8ce-e56e9f762b05€49.00€0.67matched
35capture01a1ad6a-0994-71d3-a306-8cd9bbf6039f€35.00€0.50matched
36capture01a1ad6a-1d02-7216-9a80-3be84df3b4ca€24.00€0.37matched
37capture01a1ad6a-2b91-7583-a63c-0d248e144e14€9.00€0.19matched
38capture01a1ad6a-40eb-756c-abe7-7a0acb625952€9.00€0.19matched
39capture01a1ad6a-44cd-75cd-8907-d4f1ba556b84€49.00€0.67matched
40capture01a1ad6a-4793-7528-b79b-871dd480c170€35.00€0.50matched
41refund01a1ad6a-4e1d-70d4-8910-d8582de21b1e-€8.00€0.00matched
42capture01a1ad6a-5088-7493-9299-3a45322ccaa6€9.00€0.19matched
43capture01a1ad6a-b092-72a5-addd-8fd7f3f682e6€35.00€0.50matched
44capture01a1ad6a-cab4-7e91-87ce-43f739012449€24.00€0.37matched
45capture01a1ad6a-d3f3-757d-969a-525a4370a469€24.00€0.37matched
46capture01a1ad6a-dfa9-7002-a8f5-506154168610€24.00€0.37matched
47capture01a1ad6a-e0db-7698-8349-b39043008966€24.00€0.37matched
48capture01a1ad6a-e177-747a-a951-3cfcf0855b63€49.00€0.67matched
49capture01a1ad6b-27d4-7db0-a1fd-bb482ba6fbeb€24.00€0.37matched
50capture01a1ad6b-2e93-717e-aaf1-b86191280bf4€9.00€0.19matched
51capture01a1ad6b-4494-71b1-aad0-086b660b6299€35.00€0.50matched
52capture01a1ad6b-7611-7338-9a50-de0c9fa6e49f€49.00€0.67matched
53capture01a1ad6b-831a-7599-8e78-8c21a0512020€15.00€0.26matched
54capture01a1ad6b-9eca-7451-bd97-fd777e984432€15.00€0.26matched
55capture01a1ad6b-acd6-7948-80e0-f803c96feac0€35.00€0.50matched
56capture01a1ad6b-b4dd-7e28-b4d8-d6899eb0f094€24.00€0.37matched
57capture01a1ad6b-caab-731e-9934-24bb53097cd1€35.00€0.50matched
58capture01a1ad6b-dede-76bc-af75-b4a14bd85b5e€9.00€0.19matched
59refund01a1ad6b-e7fb-7c5b-9118-0706beb95c70-€14.00€0.00matched
60capture01a1ad6b-ef19-7e07-a657-65f8340393d6€35.00€0.50matched
61capture01a1ad6b-ef27-77e7-aa68-2bdfcaa5c743€9.00€0.19matched
63capture01a1ad6b-f25e-7e26-92e5-debb6a839bb3€24.00€0.37matched
64capture01a1ad6c-0fc5-7389-8724-6e4553e99775€24.00€0.37matched
65capture01a1ad6c-21f1-7231-9d58-c633c6efe7a3€24.00€0.37matched
66capture01a1ad6c-2342-7651-b444-9fdc7d9afa77€9.00€0.19matched
67refund01a1ad6c-35c5-7a60-a33b-be97a2bffec5-€32.00€0.00matched
68capture01a1ad6c-5e1c-7eaa-888b-43cae2797d0c€15.00€0.26matched
69capture01a1ad6c-6f1a-7fa3-96dc-dfc4bdefa1ae€35.00€0.50matched
70capture01a1ad6c-7939-765d-96fb-a52bc5cb711c€15.00€0.26matched
71capture01a1ad6c-78a9-785f-be96-01a15f1463fd€24.00€0.37matched
72capture01a1ad6c-7fd1-7a6a-9903-3d4bcc36dea1€24.00€0.37matched
73capture01a1ad6c-83a9-77b2-a018-6c45861ffa49€24.00€0.37matched
74capture01a1ad6c-a1f4-7043-a41c-ed121a5b8747€24.00€0.37matched
75refund01a1ad6c-ac32-7610-adf4-2ed473c52eb4-€27.00€0.00matched
76capture01a1ad6c-bbfa-79ae-a491-123fd6d84e78€35.00€0.50matched
77capture01a1ad6c-c50a-772d-b680-e336e3fdcfb8€49.00€0.67matched
78capture01a1ad6c-c8dd-7dbf-a563-afb531389613€15.00€0.26matched
79capture01a1ad6c-eb1d-7b35-8ec1-11e11d3654e6€49.00€0.67matched
80capture01a1ad6c-fa25-708a-8219-724e36ba11c0€49.00€0.67matched
81capture01a1ad6d-1039-79d2-ba79-8ecdb9067d74€24.00€0.37matched
82capture01a1ad6d-1c82-710c-8ff8-45dfb6bd10f6€49.00€0.67matched
83capture01a1ad6d-4658-7207-8bad-b9fc8449ef54€24.00€0.37matched
84capture01a1ad6d-5cf0-7ea8-bf2e-ce9949af0df6€49.00€0.67matched
85capture01a1ad6d-6546-7387-bc4c-a880f0ec595b€35.00€0.50matched
86capture01a1ad6d-6ee6-7d9e-abee-9ad3007fc4c2€24.00€0.37matched
87capture01a1ad6d-7b2a-7b94-a2c8-b9f635eb72c9€9.00€0.19matched
88capture01a1ad6d-8e28-7758-934e-a8e52b94374d€35.00€0.50matched
89capture01a1ad6d-9735-7fbb-9c7a-c4d90c4889ed€49.00€0.67matched
90capture01a1ad6d-a1da-7a1b-b779-d77ebe4ab7f1€24.00€0.37matched
91capture01a1ad6d-ab6e-75dc-8df7-06b22c7b7289€9.00€0.19matched
92capture01a1ad6d-b5b9-78d4-8b2a-05620bb96b4e€49.00€0.67matched
93capture01a1ad6d-b70c-7532-8a39-75471e31e366€35.00€0.50matched
94capture01a1ad6d-df8e-74e7-99bc-cd1096f0cdcd€24.00€0.37matched
95capture01a1ad6d-e6cc-7c6d-bc83-7246fd310be9€24.00€0.37matched
96capture01a1ad6d-f219-7e30-896b-58cc105f3b80€9.00€0.19matched
97capture01a1ad6e-2869-7619-8bd4-b8b86eb1c635€9.00€0.19matched
98capture01a1ad6e-3399-7ef9-bbe1-7ee60a04cf58€49.00€0.67matched
99capture01a1ad6e-3e3b-7627-86c6-2b20588dd180€9.00€0.19matched
100capture01a1ad6e-42e2-7e7a-84d5-614d12f3c536€35.00€0.50matched
101capture01a1ad6e-57f4-7a70-9218-638d195fc820€15.00€0.26matched
102capture01a1ad6e-5948-7cdf-8006-87e91df2284a€24.00€0.37matched
103capture01a1ad6e-6666-7327-a46a-f390fbde314f€49.00€0.67matched
104capture01a1ad6e-6c0e-7d61-a9cf-f9f8cd1d516a€49.00€0.67matched
105capture01a1ad6e-6c48-7740-a87a-57459f65822a€49.00€0.67matched
106capture01a1ad6e-8875-7080-b79d-ec7268263afa€9.00€0.19matched
107capture01a1ad6e-9211-77ef-be86-c0e86f2f8993€9.00€0.19matched
108capture01a1ad6e-9b81-7885-8a23-ce223ffeb43c€35.00€0.50matched
109capture01a1ad6e-a7e7-71e2-bd84-81e637bab3b0€15.00€0.26matched
110refund01a1ad6e-bdfc-77b1-81d7-82b6e8a0f769-€5.00€0.00matched
111capture01a1ad6e-c45b-7693-8cae-d77679f22960€35.00€0.50matched
112capture01a1ad6e-dc2e-7586-a85e-f63a40497cac€49.00€0.67matched
113capture01a1ad6e-e83c-75a1-8f78-973febb70452€24.00€0.37matched
114capture01a1ad6e-ff82-7793-b1a3-1f2e5fd90f74€24.00€0.37matched
115capture01a1ad6f-0521-719c-91f3-2d57fbfb29c1€9.00€0.19matched
116capture01a1ad6f-08d3-7162-b9f8-7ba53f698da7€9.00€0.19matched
117capture01a1ad6f-1fc6-757e-a4a6-5cb19ac445ff€24.00€0.37matched
118capture01a1ad6f-292e-7719-b48e-5ea1d486b801€9.00€0.19matched
119capture01a1ad6f-4093-789e-ae27-86e91c9e5d57€24.00€0.37matched
120capture01a1ad6f-4244-7ab2-8719-4d40e0086512€9.00€0.19matched
121refund01a1ad6f-5ab6-7e06-a968-3274c3f90810-€11.00€0.00matched
122capture01a1ad6f-5f9d-78f0-867f-4a38fffc217e€49.00€0.67matched
123capture01a1ad6f-6304-7feb-b2a5-add6c7e508fc€9.00€0.19matched
124capture01a1ad6f-64ab-7817-922e-5b1825b7f936€24.00€0.37matched
125capture01a1ad6f-8230-764c-ab13-defbe006caa9€15.00€0.26matched
126capture01a1ad6f-bfbd-7106-b096-c2e6b06d3371€9.00€0.19matched
127capture01a1ad6f-df70-7e89-97d5-de1fcda96b99€9.00€0.19matched
128capture01a1ad6f-f6fe-7444-82a3-099c5cd0cd08€15.00€0.26matched
129capture01a1ad6f-fcb1-7b1a-a8e8-25064c1c6e1a€15.00€0.26matched
130capture01a1ad70-2cfb-7fea-b098-840dcde16c67€49.00€0.67matched
131capture01a1ad70-5907-7974-b31b-de21f9a065a0€49.00€0.67matched
132capture01a1ad70-62a4-7f67-b178-148a78d191e9€15.00€0.26matched
133capture01a1ad70-6e26-7e97-abb9-18ee657b846c€9.00€0.19matched
134capture01a1ad70-92d9-7f17-a13d-b140f5996e5f€49.00€0.67matched
135capture01a1ad70-9406-75af-bcf9-3fa854ed42af€9.00€0.19matched