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

Gross

€3,063.00

PSP fee

€48.41

Net to the bank

€3,014.59

Settlement journal

#385709

Breaks for a person to look at

  • missing linein the books, not in the filecapture:01a1a85b-842d-7c40-adbe-98242d68fa8d is in no file
LineKindReferenceGrossFeeStatus
1capture01a1a853-9719-7360-88ec-d7942eaf13fd€24.00€0.37matched
2capture01a1a853-9b80-7ab8-ba53-eaeec06b4a2e€24.00€0.37matched
3refund01a1a853-a5c2-720f-8082-531f900bb82f-€8.00€0.00matched
4capture01a1a853-b054-7c53-ba7f-f1f99015998b€35.00€0.50matched
5capture01a1a853-bcff-73dd-a871-a4b40f108cec€35.00€0.50matched
6capture01a1a853-bec8-7341-a954-212a0c649e24€9.00€0.19matched
7capture01a1a853-cdce-7409-b2ae-732c062e14f9€49.00€0.67matched
8capture01a1a853-de38-7e0a-8f40-a39c330497b5€24.00€0.37matched
9capture01a1a853-ec5b-7b65-9689-aa9627ff1f2e€9.00€0.19matched
10capture01a1a854-0876-77b7-b661-19e245dbb100€24.00€0.37matched
11capture01a1a854-4188-791e-80f4-ed1712c7be59€49.00€0.67matched
12capture01a1a854-47c8-797d-aafb-6ec42a3f55b5€24.00€0.37matched
13capture01a1a854-5590-700b-874f-e3fa7ed4c66c€24.00€0.37matched
14capture01a1a854-57e2-786e-885a-90a56199abbc€9.00€0.19matched
15capture01a1a854-7f28-7425-a64d-406e18e1b194€9.00€0.19matched
16capture01a1a854-9d72-76a0-8865-4b7c586a9710€15.00€0.26matched
17capture01a1a854-aad0-76ba-8689-39fac1291813€49.00€0.67matched
18capture01a1a854-b386-7f43-8c17-2f19177e05b7€9.00€0.19matched
19capture01a1a854-cb5b-71d5-b76e-0b2bb312e604€24.00€0.37matched
20capture01a1a854-d8d7-7114-a2aa-393eb32782a2€49.00€0.67matched
21capture01a1a854-eb9a-74ac-ac89-1d1b6c047101€9.00€0.19matched
22capture01a1a854-f043-7a47-ba6a-0240d5411d5b€49.00€0.67matched
23capture01a1a855-0b0f-7ab0-96c6-fcf81ac6af47€9.00€0.19matched
24refund01a1a855-3889-7e8f-baec-b43a2bf0ef05-€39.00€0.00matched
25capture01a1a855-3afe-74b4-b959-baa05e057b20€35.00€0.50matched
26capture01a1a855-529b-7847-9aa8-4d0e906ec0fa€35.00€0.50matched
27capture01a1a855-5368-709e-b8c8-c8f78a90d3da€35.00€0.50matched
28capture01a1a855-5470-7e02-b1d8-fb13485f2b15€49.00€0.67matched
29capture01a1a855-59f2-72c9-8c70-a782accd47b6€24.00€0.37matched
30capture01a1a855-639a-7f49-83ce-b2c950447c5b€35.00€0.50matched
31capture01a1a855-803e-756a-8b00-cca82ea1e853€24.00€0.37matched
32capture01a1a855-8506-7fe0-9bd6-5d36214db33f€49.00€0.67matched
33refund01a1a855-884d-77cd-8d5c-7114bd7d8575-€5.00€0.00matched
34refund01a1a855-8ae3-7f1d-8e5e-aa8d1cffdfee-€32.00€0.00matched
35capture01a1a855-9124-74b8-8f31-c80f373a43a0€24.00€0.37matched
36capture01a1a855-b4ad-78f5-87ed-2da33ae358d5€15.00€0.26matched
37capture01a1a855-c576-7465-a5c1-4795186e6a66€9.00€0.19matched
38capture01a1a855-cc2a-715d-8c53-992dd0b4a711€24.00€0.37matched
39capture01a1a855-e5f1-7793-b76b-7e34e47dff72€9.00€0.19matched
40capture01a1a855-e6b6-7e52-9d7a-daa61b7dcd71€35.00€0.50matched
41capture01a1a856-1a3b-70ee-8886-ed43b30cc19d€49.00€0.67matched
42capture01a1a856-31f4-709e-b9b7-30280530d2a3€35.00€0.50matched
43capture01a1a856-63cf-7b8c-b187-91922e493842€35.00€0.50matched
44capture01a1a856-6d09-7f3e-835a-77fa83a70f48€49.00€0.67matched
45capture01a1a856-6ef3-7104-8c9e-6c26e1e73816€35.00€0.50matched
46capture01a1a856-87f7-7712-9f21-305c74772111€49.00€0.67matched
47capture01a1a856-a752-733c-b086-881f01ca3393€49.00€0.67matched
48capture01a1a856-c43b-7529-8819-6e2b3725fcc2€35.00€0.50matched
49capture01a1a856-d715-7592-9d42-37fb28f4c566€24.00€0.37matched
50capture01a1a857-1dab-7e73-be27-8d10d37f7796€9.00€0.19matched
51capture01a1a857-3d07-7d45-ba58-d53525d7a35e€35.00€0.50matched
52capture01a1a857-3ed0-7c78-a53d-2dd8d746249a€35.00€0.50matched
53capture01a1a857-413c-7a67-bf45-d8aa320cde5c€15.00€0.26matched
54capture01a1a857-46ee-7157-ac48-1f86f290aa0a€24.00€0.37matched
55refund01a1a857-91cb-70f0-8e70-e13b51bda826-€6.00€0.00matched
56capture01a1a857-aa4d-7d88-913a-f63d484a89e8€15.00€0.26matched
57capture01a1a857-bb1e-7ccc-9994-3cdee11f1a5f€15.00€0.26matched
58capture01a1a857-c6a9-70e4-a2f9-c3e5607ab402€15.00€0.26matched
59capture01a1a857-c8c9-784f-a89a-4e50d45243a3€9.00€0.19matched
60capture01a1a857-cc9e-703e-b969-96b0040af703€15.00€0.26matched
61capture01a1a857-d979-78fd-8867-b665dc44668a€15.00€0.26matched
62capture01a1a857-f01d-7ef3-96e4-491997a9efab€49.00€0.67matched
63capture01a1a857-f06a-795b-a60f-2f20a44f793b€24.00€0.37matched
64capture01a1a857-feb9-7fec-9417-9123cff5831a€24.00€0.37matched
65capture01a1a858-041e-7326-9e13-6ee820e4d8a4€15.00€0.26matched
66capture01a1a858-20ca-77cb-bf20-dd6bf2a00d08€35.00€0.50matched
67capture01a1a858-225b-751e-ae09-77c33f8d861b€24.00€0.37matched
68capture01a1a858-39ee-7092-a724-7c02cc206f75€24.00€0.37matched
69refund01a1a858-400a-710f-97a9-03ad6171e9c4-€12.00€0.00matched
70capture01a1a858-8bee-7441-8f80-0fb91ff43609€35.00€0.50matched
71capture01a1a858-8c90-7c8b-9475-7e16bca562cf€24.00€0.37matched
72capture01a1a858-a3c9-7239-8813-92a23d702ca8€9.00€0.19matched
73capture01a1a858-c1bd-7df9-bfaf-96b8fd92ba37€49.00€0.67matched
74capture01a1a858-cace-7de5-bb6b-08c687701831€9.00€0.19matched
75capture01a1a858-e8bf-791b-9560-7adad296b37c€15.00€0.26matched
76capture01a1a859-1001-70ce-aa74-e76ab1ed89d4€35.00€0.50matched
77capture01a1a859-1eaf-7c18-9de1-c5ea591194b8€15.00€0.26matched
78capture01a1a859-2b14-7278-88a5-bb917c2e2d86€35.00€0.50matched
79capture01a1a859-36f6-7bfa-82c0-1cc1e8269591€9.00€0.19matched
80capture01a1a859-4fe2-70b2-b829-b94c29c0e896€49.00€0.67matched
81capture01a1a859-796c-7da6-af8c-86a448c275ab€15.00€0.26matched
82capture01a1a859-7e32-71f2-aa48-a62cacfd9e56€24.00€0.37matched
83capture01a1a859-8f4b-77af-8c42-9d864841fb55€35.00€0.50matched
84capture01a1a859-bd5b-76d8-9bff-add20f467901€15.00€0.26matched
85capture01a1a859-d951-7a67-a1b0-7f6ec02290cd€35.00€0.50matched
86capture01a1a859-dfa1-7237-89c5-8e8fcf2d96c1€35.00€0.50matched
87capture01a1a859-e0ad-72e0-8f13-19d20e294765€9.00€0.19matched
88capture01a1a859-ee46-7b20-81db-1c7a1b532d65€9.00€0.19matched
89capture01a1a859-f571-7e37-818a-51c18dade8c8€15.00€0.26matched
90capture01a1a859-fb81-72ef-a7f9-ce21e859721d€49.00€0.67matched
91capture01a1a85a-1dcc-7178-9556-ad81c7ff679a€49.00€0.67matched
92capture01a1a85a-20f9-7cf7-8c5f-ef9c642366bd€35.00€0.50matched
93capture01a1a85a-2807-78c5-a3d7-fe4617bdfc6a€24.00€0.37matched
94capture01a1a85a-296c-7c43-8ea5-d0d93a938f1a€35.00€0.50matched
95capture01a1a85a-5ae2-7587-8157-cfcf061629fe€35.00€0.50matched
96capture01a1a85a-625c-71ec-992f-2a1abc88a207€35.00€0.50matched
97capture01a1a85a-815b-7cdc-862f-2d3e1cd3639b€9.00€0.19matched
98capture01a1a85a-885c-7dad-876a-8bda545a4d3b€49.00€0.67matched
99capture01a1a85a-8b46-7ffd-b5ee-37da31a3fcb1€35.00€0.50matched
100capture01a1a85a-8ffe-7132-8907-55500436b058€15.00€0.26matched
101capture01a1a85a-9dce-77ca-9dba-5c216237301a€35.00€0.50matched
102capture01a1a85a-bead-7195-a43e-b20a0bfd16c3€9.00€0.19matched
103capture01a1a85a-bcfc-77e8-a7e6-0e8cad503ab4€49.00€0.67matched
104capture01a1a85a-e06f-7813-ab89-437520153cb7€9.00€0.19matched
105capture01a1a85a-d924-7517-bcfd-124ff43e7db6€9.00€0.19matched
106refund01a1a85a-e1ff-716e-a2cb-4b4c4b68caa9-€16.00€0.00matched
107capture01a1a85a-eab4-73bc-9043-5bd50b681fe8€9.00€0.19matched
108capture01a1a85a-f599-75ff-ad7e-c4d25c9a5be7€9.00€0.19matched
109capture01a1a85a-fe96-7ea8-abde-bf59dd2a7753€24.00€0.37matched
110capture01a1a85b-0046-79d2-b1ad-0341bd9d9be8€15.00€0.26matched
111capture01a1a85b-07a7-7232-be68-5a92c6ee7712€35.00€0.50matched
112capture01a1a85b-05ce-7551-9ffe-fe2d48de38bb€24.00€0.37matched
113capture01a1a85b-07df-7b56-905c-8742aa779b94€24.00€0.37matched
114refund01a1a85b-1097-746f-991d-0e0b98536f3d-€5.00€0.00matched
115capture01a1a85b-5257-78a3-be09-d66f730798f1€35.00€0.50matched
116capture01a1a85b-9602-7e90-8427-5a64aa90e20e€35.00€0.50matched
117capture01a1a85b-9c0f-7c06-81a0-4b142caba2ec€35.00€0.50matched
118capture01a1a85b-d459-77a0-977d-378f4bef2d7b€9.00€0.19matched
119capture01a1a85b-dc08-7483-aecd-761b3882296a€15.00€0.26matched
120capture01a1a85b-e30d-7a15-8f40-cad05777f54b€9.00€0.19matched
121capture01a1a85b-e7a0-7f79-a1e4-e9f6a651bde3€49.00€0.67matched
122capture01a1a85b-e8a4-7bb8-955b-343a29cc6a94€15.00€0.26matched
123refund01a1a85b-f5d1-7781-a30b-78aabe73dff0-€30.00€0.00matched
124capture01a1a85b-fb46-7e53-8c0a-e2e9018cfc97€49.00€0.67matched
125capture01a1a85c-46e5-7912-9595-6bc1f3b9bd64€15.00€0.26matched
126capture01a1a85c-534c-71c9-9d26-0259da15fc3e€35.00€0.50matched
127capture01a1a85c-5756-7260-9a83-cbd7b4712c49€24.00€0.37matched
128capture01a1a85c-4489-7baf-b099-405bdb40f804€35.00€0.50matched
129capture01a1a85c-5d6c-7008-a4a5-889d253a8e6c€24.00€0.37matched
130capture01a1a85c-6b3b-70db-907b-1fa5014d30d3€15.00€0.26matched