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, 16:00

Gross

€2,371.00

PSP fee

€38.17

Net to the bank

€2,332.83

Settlement journal

#400301

Every line paired with the books, and every capture and refund of the day is in the file.

LineKindReferenceGrossFeeStatus
1capture01a1ac69-6059-77aa-9fc9-7e2c7a0d2c29€35.00€0.50matched
2capture01a1ac6a-63da-7f3c-891d-e46227ce4673€15.00€0.26matched
3capture01a1ac70-15c2-7502-b130-7d11a4a89aab€15.00€0.26matched
4capture01a1ac70-61ca-7a8f-956f-7d2ad11d396d€24.00€0.37matched
5refund01a1ac70-65ac-75fe-998f-51bb3fe78e22-€7.00€0.00matched
6capture01a1ac70-7ae7-7845-aa81-02fc47915b6d€49.00€0.67matched
7capture01a1ac70-8614-717a-b5cc-3f8a2ac76977€24.00€0.37matched
8capture01a1ac70-91dc-7ed2-84eb-7fe5ed6f3ee7€49.00€0.67matched
9capture01a1ac70-99ed-7085-b7ad-1f1b7e238dd1€35.00€0.50matched
10capture01a1ac70-9ff2-761f-9604-e56f26d3a2f1€49.00€0.67matched
11capture01a1ac70-a695-7776-a9f3-cd28f105abb7€49.00€0.67matched
12refund01a1ac70-de38-742d-a87a-51c5e3de0efd-€18.00€0.00matched
13refund01a1ac70-ebb5-77c1-bfe8-c66219820cf8-€23.00€0.00matched
14capture01a1ac70-fb18-7a6e-9e2b-9def5d3f149a€9.00€0.19matched
15capture01a1ac71-01b2-7fdd-8079-afb6e6ed6995€9.00€0.19matched
16refund01a1ac71-3a14-7c9c-94c2-453d78e42633-€7.00€0.00matched
17capture01a1ac71-4e97-7e6e-8eac-31ac7c5bc104€24.00€0.37matched
18capture01a1ac71-8381-7efd-a16f-76464838f522€9.00€0.19matched
19capture01a1ac71-9a43-70c0-b331-ffb5a58c4c9c€49.00€0.67matched
20capture01a1ac71-9f4b-7d60-9908-5ac376114535€9.00€0.19matched
21capture01a1ac71-ab7e-7e42-aa5a-00d8c20549b1€49.00€0.67matched
22capture01a1ac71-b90e-7f7b-b7f0-f1f40ea6485c€15.00€0.26matched
23capture01a1ac71-d0c8-73d7-999a-15daec2f1b9a€35.00€0.50matched
24capture01a1ac72-1737-74e4-8088-0c74ab121115€24.00€0.37matched
25capture01a1ac72-30be-74df-aa99-a9e7fabf2c74€9.00€0.19matched
26capture01a1ac72-5720-7836-9279-2c61e1cdddcf€9.00€0.19matched
27capture01a1ac72-5b41-71bd-ac4f-4563b9f11680€24.00€0.37matched
28capture01a1ac72-77f1-7051-bd28-b2aded19331f€24.00€0.37matched
29capture01a1ac72-8db1-7fb2-9f64-d1589b999a47€15.00€0.26matched
30capture01a1ac72-8e75-70b9-a1f3-b4aee64fb89b€49.00€0.67matched
31capture01a1ac72-ad50-74d8-b4ea-2611458adf1b€24.00€0.37matched
32capture01a1ac72-b6e5-747d-a68a-a19b04c3b855€49.00€0.67matched
33refund01a1ac72-c22a-7762-a4a4-b7124d1a844f-€5.00€0.00matched
34capture01a1ac72-f1d0-7831-a445-95b7955d38f9€24.00€0.37matched
35capture01a1ac73-08c1-7d59-860b-3688746b94f5€9.00€0.19matched
36refund01a1ac73-0ca2-7fc7-91c1-6101b0659acd-€7.00€0.00matched
37capture01a1ac73-1149-7a62-9f4d-b0ac2bbbf5c8€9.00€0.19matched
38capture01a1ac73-11f6-72d0-b325-aab228f6f48a€35.00€0.50matched
39capture01a1ac73-2366-7488-b355-00e2163ed271€9.00€0.19matched
40capture01a1ac73-4499-776a-b595-b26f152f87b8€49.00€0.67matched
41capture01a1ac73-468d-71ff-93a9-5fcd2a8ace1b€24.00€0.37matched
42capture01a1ac73-8c50-760a-bf25-3adc3dfb024c€15.00€0.26matched
43capture01a1ac73-8ce8-73e7-93f7-ab4271ba18e0€9.00€0.19matched
44capture01a1ac73-bbbd-7e0d-bc8d-70d60cd95e95€9.00€0.19matched
45capture01a1ac73-dd1d-7cd3-93fc-97220b73e3d8€24.00€0.37matched
46capture01a1ac74-011c-7026-aede-c0428bc72a7b€24.00€0.37matched
47capture01a1ac74-0f94-7dec-986a-cf0ff3ff5652€9.00€0.19matched
48refund01a1ac74-1a41-71e4-9f25-e95a285a3241-€14.00€0.00matched
49capture01a1ac74-2ce7-73f3-9fa7-e927f4c10c35€24.00€0.37matched
50capture01a1ac74-4a8e-752a-85f2-f39e6d00facb€35.00€0.50matched
51capture01a1ac74-5f8a-77bb-90a8-532f56adcb4d€9.00€0.19matched
52capture01a1ac74-6359-732a-a6e4-7004cd44b4f5€35.00€0.50matched
53capture01a1ac74-6b15-7f5b-822a-86dcdb2bf69c€24.00€0.37matched
54capture01a1ac74-6bd6-7410-be27-fd56fc8243a8€15.00€0.26matched
55capture01a1ac74-7356-74de-9937-e6a4653143f0€24.00€0.37matched
56capture01a1ac74-7c2e-76a1-8360-1af8bf9fef40€24.00€0.37matched
57capture01a1ac74-969c-7632-998a-5a07eb49ff5d€9.00€0.19matched
58refund01a1ac74-9879-7a2e-ac36-5e512975bdf2-€9.00€0.00matched
59capture01a1ac74-bdf3-711f-8f6f-b8e769d7ded2€15.00€0.26matched
60capture01a1ac74-ca5b-7637-9f3e-a4c7cf3574d9€35.00€0.50matched
61capture01a1ac74-e76b-7db4-bb2d-0d3f3c6abc1e€9.00€0.19matched
62capture01a1ac75-066d-7e5d-a121-7ee472a1b21e€35.00€0.50matched
63capture01a1ac75-1dfb-76fd-bafa-76811b7c6509€49.00€0.67matched
64capture01a1ac75-74c3-7356-b98b-3c880003a4e5€49.00€0.67matched
65capture01a1ac75-7a79-72c6-a06f-a236614f67ee€9.00€0.19matched
66capture01a1ac75-9775-7506-abb4-0a305b083c78€24.00€0.37matched
67capture01a1ac75-9924-7a1d-8d16-079e8f06a091€49.00€0.67matched
68capture01a1ac75-97ba-7054-8e0a-b9e0fe709957€24.00€0.37matched
69capture01a1ac75-d13b-74ad-8d10-4eaa6cd02503€49.00€0.67matched
70capture01a1ac76-039d-7d3d-a88f-b5c1c06d697e€35.00€0.50matched
71capture01a1ac76-3731-7022-8f6e-f1c3ee44f3a2€35.00€0.50matched
72capture01a1ac76-5d74-7645-be87-fd2612badf14€9.00€0.19matched
73capture01a1ac76-6416-73a2-a509-db3e53ef755a€15.00€0.26matched
74capture01a1ac76-7e16-7b90-b49c-ba76e77c67d5€15.00€0.26matched
75capture01a1ac76-8420-750f-a7c4-03af3d33bf21€49.00€0.67matched
76capture01a1ac76-98b7-7838-ab32-e8a4ceb6fe63€35.00€0.50matched
77capture01a1ac76-ceaa-789a-b3dc-9220678da276€35.00€0.50matched
78refund01a1ac76-d15e-7eed-93bc-1cc38d308401-€18.00€0.00matched
79capture01a1ac76-defd-7734-b279-ca201f1afbd5€35.00€0.50matched
80capture01a1ac76-e5c9-7828-811f-90f05ee5b784€24.00€0.37matched
81capture01a1ac77-03e8-7dd7-8a29-2db9ee1510a3€15.00€0.26matched
82capture01a1ac77-1462-76f0-9451-3091ff05bb01€9.00€0.19matched
83capture01a1ac77-3221-7823-ae3d-c1362264efc0€35.00€0.50matched
84capture01a1ac77-43c4-796d-a39d-98731eee5ab8€35.00€0.50matched
85capture01a1ac77-46b8-72a4-9286-400d373592f0€35.00€0.50matched
86capture01a1ac77-521a-7ca3-b8e6-6400a7760731€35.00€0.50matched
87capture01a1ac77-53ff-7935-be76-d2a359b1e2a4€24.00€0.37matched
88capture01a1ac77-54c8-7ec2-97d8-6810fcdbaed3€9.00€0.19matched
89capture01a1ac77-64e3-74f4-a8a9-37018bf57ac2€35.00€0.50matched
90capture01a1ac77-74ec-7343-9da9-46c397f8ba3c€9.00€0.19matched
91capture01a1ac77-8a3c-7222-b7c7-39db50bccef1€15.00€0.26matched
92refund01a1ac77-94d4-7a14-87f1-a7735a8f8ec1-€18.00€0.00matched
93capture01a1ac77-9d14-782e-bd1d-8affceef5b54€35.00€0.50matched
94capture01a1ac77-a89d-771b-80c3-a6cbb25c5879€15.00€0.26matched
95capture01a1ac77-aba3-79bc-abfe-0815d55339ee€9.00€0.19matched
96capture01a1ac77-b8b7-7627-8b4a-0701a672d896€35.00€0.50matched
97capture01a1ac77-c7b0-7d3b-8f4e-d7f1799527dc€35.00€0.50matched
98capture01a1ac77-db76-7b44-8160-5a36f335d57f€24.00€0.37matched
99capture01a1ac78-0cab-7f0a-8186-7e77f60abb10€15.00€0.26matched
100capture01a1ac78-14bd-7fa0-b19e-d8a77ba9cb4c€9.00€0.19matched
101capture01a1ac78-8e03-79b3-bf0a-77ad38c1c4d5€35.00€0.50matched
102capture01a1ac78-afcd-7393-9f54-fdd135e894c1€15.00€0.26matched
103capture01a1ac78-b7ad-7dd7-ae7d-77458c7e935b€9.00€0.19matched
104capture01a1ac78-c0a5-7688-bee2-297f8842117f€9.00€0.19matched
105capture01a1ac78-d280-7106-a763-1d3aa803baee€9.00€0.19matched
106capture01a1ac78-f48d-7192-a299-5bd1226a67f8€9.00€0.19matched
107capture01a1ac79-10ba-7b89-888c-b11614a211f5€9.00€0.19matched
108capture01a1ac79-1763-763f-ad0a-110616ea8879€49.00€0.67matched
109capture01a1ac79-3162-75ff-98cb-9b1a5787490a€15.00€0.26matched
110capture01a1ac79-3a8f-7f29-829a-9e2a63e116d2€35.00€0.50matched
111capture01a1ac79-5340-78e7-b6ed-6cdb0fbcd90e€9.00€0.19matched