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, 01:10

Gross

€2,741.00

PSP fee

€42.77

Net to the bank

€2,698.23

Settlement journal

#389048

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

LineKindReferenceGrossFeeStatus
1capture01a1a93a-f5e2-749f-89c7-5303f5966d4d€49.00€0.67matched
2capture01a1a941-7ba1-7fdd-8a85-354151325cf5€15.00€0.26matched
3capture01a1a941-808d-7e73-a932-5856d706b45e€35.00€0.50matched
4capture01a1a941-b3a9-725a-8709-d1fc0e503f00€15.00€0.26matched
5capture01a1a941-d6a2-7852-bddc-b0a7bc0eb676€15.00€0.26matched
6capture01a1a941-f2be-79a8-b77b-b84e57f7bd68€35.00€0.50matched
7capture01a1a941-f97e-73bc-91f3-c098f57a26ae€49.00€0.67matched
8capture01a1a942-0674-7a5e-b639-f37ef4dce9c9€49.00€0.67matched
9capture01a1a942-0f18-7452-95b9-af00c2d801a1€24.00€0.37matched
10capture01a1a942-4a42-7506-a3c4-acccf8e9b281€24.00€0.37matched
11capture01a1a942-589f-71d8-b083-bffe6925a311€24.00€0.37matched
12capture01a1a942-b2e2-7201-8075-6e5ce4e40ebe€9.00€0.19matched
13capture01a1a942-c6ab-759b-a0c1-5f1c257af619€35.00€0.50matched
14capture01a1a942-d205-71f8-9f58-4897243268e4€15.00€0.26matched
15capture01a1a942-def0-7bb1-a258-0991f162f517€49.00€0.67matched
16capture01a1a942-f162-7c5b-b97d-08b9bff8bd23€15.00€0.26matched
17capture01a1a943-1dab-75fb-9b0b-17b821ab1304€49.00€0.67matched
18refund01a1a943-4dc7-7e9f-9880-a6a47d19b7eb-€12.00€0.00matched
19capture01a1a943-52f4-7d5a-8029-8f93bf3f94a7€35.00€0.50matched
20capture01a1a943-57ca-71ba-a41c-071fe17c0d67€49.00€0.67matched
21capture01a1a943-8127-7bda-807e-be8c0ea12122€15.00€0.26matched
22capture01a1a943-a2ff-7d4d-b00d-da30acf56ecd€24.00€0.37matched
23capture01a1a943-a364-7398-856a-ea477cb602f9€24.00€0.37matched
24capture01a1a943-b1c8-7fde-ac7e-50d3a115393d€9.00€0.19matched
25capture01a1a943-d4c5-714e-b8a6-3aad1aee56d0€24.00€0.37matched
26capture01a1a944-054f-7e79-89ec-d2e579c08005€35.00€0.50matched
27capture01a1a944-0844-77da-9583-752af12d1868€49.00€0.67matched
28capture01a1a944-1fa1-751c-b89a-5afb1f2e0327€49.00€0.67matched
29capture01a1a944-278f-77a3-8ec6-4af4ce3ad876€15.00€0.26matched
30capture01a1a944-36b9-7d58-ac62-c07557ce87f8€9.00€0.19matched
31capture01a1a944-4019-724c-862e-672c366a294e€9.00€0.19matched
32capture01a1a944-4594-7e7e-9d33-efd428078e99€49.00€0.67matched
33capture01a1a944-51ca-79cc-bda4-eaf7b4b41560€35.00€0.50matched
34refund01a1a944-5c65-7dde-a0fb-06475d3e0d43-€34.00€0.00matched
35capture01a1a944-60b4-7a96-8bb0-253ac7bc924c€24.00€0.37matched
36refund01a1a944-79df-7e3c-8906-f89694cfc448-€33.00€0.00matched
37capture01a1a944-9709-76f7-b6e9-7e413898d601€49.00€0.67matched
38capture01a1a944-9992-7382-8773-c579217b25d4€24.00€0.37matched
39capture01a1a944-9f04-7a4e-a614-54a699a089c0€9.00€0.19matched
40capture01a1a944-afc4-72d7-9ea7-a8d95dfd7a1a€35.00€0.50matched
41capture01a1a944-f3f0-7e23-8152-c53934848de2€49.00€0.67matched
42capture01a1a945-152b-70b0-857d-00b026bc67ba€35.00€0.50matched
43capture01a1a945-1c6f-707f-8133-7f7555e84729€49.00€0.67matched
44capture01a1a945-2d27-753a-92aa-472240e07df5€9.00€0.19matched
45capture01a1a945-6d59-7902-98f5-4626decd71b3€9.00€0.19matched
46capture01a1a945-730b-7222-b7cb-38af6f57fa9f€49.00€0.67matched
47capture01a1a945-9aa0-7476-8085-159f00b9a976€15.00€0.26matched
48capture01a1a945-a5d1-77e3-8b98-6d5c66def448€35.00€0.50matched
49capture01a1a945-bace-7884-bfbb-967385fa6718€35.00€0.50matched
50capture01a1a945-d709-756a-ad0c-dca1cdb7ef4a€35.00€0.50matched
51capture01a1a945-db80-77ff-9fc5-95cf157ee2d3€9.00€0.19matched
52capture01a1a945-dd31-7b2a-a963-6bb6acccf4c7€15.00€0.26matched
53capture01a1a945-f446-7e6e-bfba-be39ce5e9df7€9.00€0.19matched
54capture01a1a945-f727-790f-985e-88e2f409064d€15.00€0.26matched
55capture01a1a946-1ffe-7d92-9bbf-b7fa252a89fd€49.00€0.67matched
56capture01a1a946-37b3-76f8-be22-84b6f4e0ea95€15.00€0.26matched
57capture01a1a946-5af9-74ff-9d53-9c9ee8ab57dc€35.00€0.50matched
58capture01a1a946-713e-7985-a8f1-d4fcba23a74c€49.00€0.67matched
59capture01a1a946-83ad-765f-9d3e-9204e59ac75c€24.00€0.37matched
60capture01a1a946-a0ba-7045-9518-718827dc8f79€49.00€0.67matched
61capture01a1a946-bd16-771f-9599-ccd0faf0eda1€24.00€0.37matched
62capture01a1a946-ca20-732d-bedd-5fd94e0f1de2€35.00€0.50matched
63capture01a1a946-f778-7d26-b17a-6a378a45790e€24.00€0.37matched
64capture01a1a946-f648-714a-bed7-cd36686a387a€49.00€0.67matched
65capture01a1a947-0e01-7e23-bbe0-45a4bed18496€9.00€0.19matched
66capture01a1a947-3e9a-796d-85f9-cef4b8c3f639€49.00€0.67matched
67capture01a1a947-4d43-738f-9f70-f245553a7a92€49.00€0.67matched
68capture01a1a947-50c9-753f-92f1-c26d160cecdb€9.00€0.19matched
69capture01a1a947-70c1-720e-afc7-27ff84b287a1€15.00€0.26matched
70capture01a1a947-8351-7b85-9483-4a3903594b07€9.00€0.19matched
71refund01a1a947-8f6a-7bcc-99a7-a0da8af5f149-€7.00€0.00matched
72capture01a1a947-91c8-7461-9193-689c456d0cde€9.00€0.19matched
73capture01a1a947-964b-7e1f-8a7b-d430f2c35fc7€15.00€0.26matched
74capture01a1a947-add2-76d7-9d7f-d00b777af152€24.00€0.37matched
75refund01a1a947-bd2d-7c13-a9d9-c3ec65a9df57-€18.00€0.00matched
76capture01a1a947-f7a3-7f13-a3f5-38aee9c7e636€15.00€0.26matched
77capture01a1a948-23fc-7354-b63e-47a38135f03b€24.00€0.37matched
78capture01a1a948-24ac-74f9-80cd-f1061c7830ad€35.00€0.50matched
79capture01a1a948-2acb-73d4-8443-a29f25c44828€15.00€0.26matched
80capture01a1a948-4588-7fdd-8eb3-d74e13c2b62b€35.00€0.50matched
81capture01a1a948-473a-76c2-9552-72b5e59481a5€15.00€0.26matched
82capture01a1a948-4efc-70a6-89f0-9dec6af35b63€9.00€0.19matched
83capture01a1a948-72de-7099-9555-139349e17cae€35.00€0.50matched
84capture01a1a948-74de-73af-bbad-f504bd4405f7€49.00€0.67matched
85capture01a1a948-8b03-720d-bd8f-1c3b9edbbed0€15.00€0.26matched
86capture01a1a948-8b1e-74dd-aeba-1ba257c98459€24.00€0.37matched
87refund01a1a948-a628-777f-9112-0bac8c38efef-€16.00€0.00matched
88capture01a1a948-c86e-7814-89be-c8f76e026f5d€35.00€0.50matched
89capture01a1a948-c2fe-7f84-aad4-1ae8497c128e€15.00€0.26matched
90capture01a1a948-deb8-7d06-9bd1-38eb605c2701€49.00€0.67matched
91capture01a1a948-ede1-7101-9702-72db1cb0c9e7€9.00€0.19matched
92capture01a1a948-fa8d-73ad-a9da-cb5c9f73e321€49.00€0.67matched
93capture01a1a949-05cf-7641-beab-68e09e827390€15.00€0.26matched
94capture01a1a949-4824-7c8a-a6e3-26dad79ca802€15.00€0.26matched
95capture01a1a949-5cdd-75a5-ad8d-f3bf9e4e7179€15.00€0.26matched
96capture01a1a949-77af-7609-902e-a00d326fda56€9.00€0.19matched
97capture01a1a949-8106-78a6-a9ef-efe8cc09d65d€24.00€0.37matched
98capture01a1a949-c1a6-7ca4-a923-b2c561d1451d€49.00€0.67matched
99capture01a1a949-c2cd-7a9a-b25b-48e75939ca3f€49.00€0.67matched
100capture01a1a949-db92-7108-842d-f79e4341b619€35.00€0.50matched
101capture01a1a949-f504-799c-bb35-d1b483ba6d37€15.00€0.26matched
102capture01a1a949-f5fb-70e4-8c2f-9ec41e29dfc6€24.00€0.37matched
103capture01a1a94a-015c-7b93-aec9-0a914e9518bf€15.00€0.26matched
104capture01a1a94a-30a9-7106-bfc6-41b6b01facd1€35.00€0.50matched
105capture01a1a94a-339c-7044-a125-bf596c28fb46€24.00€0.37matched
106capture01a1a94a-364c-7277-8b7a-7717c6be5e26€35.00€0.50matched
107capture01a1a94a-4abb-713f-9ccf-926f420c0663€49.00€0.67matched
108capture01a1a94a-59a0-74aa-8201-3506df0413ea€15.00€0.26matched
109capture01a1a94a-65f0-717c-ab10-094833b9117b€15.00€0.26matched
110capture01a1a94a-8047-73b8-bd13-3421500bc011€9.00€0.19matched