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

Gross

€3,016.00

PSP fee

€46.86

Net to the bank

€2,969.14

Settlement journal

#378549

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

LineKindReferenceGrossFeeStatus
1capture01a1a652-c92d-72eb-a301-65912667a6b2€35.00€0.50matched
2capture01a1a652-ee08-7baf-b270-de09e562542c€24.00€0.37matched
3refund01a1a652-ef7e-70ff-95b8-b0b507896fa5-€10.00€0.00matched
4capture01a1a652-f434-7031-b757-5f029aa665bb€24.00€0.37matched
5capture01a1a653-4d71-7f10-bf3d-6b3785368234€35.00€0.50matched
6capture01a1a653-a126-7ce4-af7d-6bfd686bd66c€9.00€0.19matched
7capture01a1a653-a3f9-79af-bb16-a05986dc1c6a€24.00€0.37matched
8capture01a1a653-a7a5-7e9d-9991-9e3c53babdb2€15.00€0.26matched
9capture01a1a653-b04a-7d91-9f90-5bd994d6ad71€15.00€0.26matched
10capture01a1a653-c4f1-7201-879f-6780d4ead304€24.00€0.37matched
11capture01a1a653-d8f8-70b5-9b86-978cfada671a€35.00€0.50matched
12capture01a1a653-df8c-71e1-b0e4-1867d72521d9€35.00€0.50matched
13capture01a1a654-1224-7ab8-8c2e-4b1703ba8c65€35.00€0.50matched
14capture01a1a654-1859-7644-b7e9-bec6bcba0882€49.00€0.67matched
15capture01a1a654-1f9f-7c1d-a54e-723a8b2225e7€15.00€0.26matched
16capture01a1a654-287d-7eac-a365-58b3c9a267e0€15.00€0.26matched
17capture01a1a654-29ab-7064-8d9c-f0df1058918c€49.00€0.67matched
18capture01a1a654-2a4c-7820-ad4d-b974eb865ef4€35.00€0.50matched
19capture01a1a654-6480-751d-8b89-c38aa0c1c60d€35.00€0.50matched
20capture01a1a654-7192-729c-a976-60a897b1942d€15.00€0.26matched
21capture01a1a654-7471-7a4b-873e-506b46fcf68f€9.00€0.19matched
22capture01a1a654-7ffd-7861-9b7b-345b60f53853€15.00€0.26matched
23capture01a1a654-8306-79ac-8773-781692084370€15.00€0.26matched
24capture01a1a654-b9eb-72ba-b0f6-9808c201511b€9.00€0.19matched
25capture01a1a654-c5f4-770d-8b71-6083ff00bdac€9.00€0.19matched
26capture01a1a654-d656-72cd-82e3-4b03d6b2e97a€9.00€0.19matched
27capture01a1a654-d65a-7d98-b3e6-c4a7cb51df14€35.00€0.50matched
28capture01a1a655-01d2-7504-ae29-a0266ab9c31c€35.00€0.50matched
29capture01a1a655-0677-7326-888d-0251ddc2957a€24.00€0.37matched
30capture01a1a655-3f50-76b3-a20d-7593e1ba5912€35.00€0.50matched
31capture01a1a655-4af1-73c6-968c-1c152d233b61€35.00€0.50matched
32capture01a1a655-59de-78a7-b643-79fae7424ae3€49.00€0.67matched
33capture01a1a655-5ae9-704e-bb0d-7f9af7e73dd8€24.00€0.37matched
34capture01a1a655-6e4f-73e4-ab5e-5d02f7cd5443€49.00€0.67matched
35capture01a1a655-7b26-793e-bfb1-677baeecceb1€35.00€0.50matched
36capture01a1a655-8d51-7995-9359-2af13142cc21€9.00€0.19matched
37capture01a1a655-a8af-7ed5-98c5-cd5d6fed75c7€35.00€0.50matched
38capture01a1a656-0bc5-7a20-89f7-79b1cc8ea7c0€15.00€0.26matched
39capture01a1a656-3059-7a66-acde-8ea8ba584d5b€15.00€0.26matched
40capture01a1a656-3a92-7061-8bbf-0f6a6dbf2399€49.00€0.67matched
41capture01a1a656-4460-7f78-a308-e6fcf0b877c9€15.00€0.26matched
42capture01a1a656-5a4b-7485-89e5-8fb0d009cd87€49.00€0.67matched
43capture01a1a656-63b6-70a5-bfe0-c7e9d11ad534€15.00€0.26matched
44capture01a1a656-65ba-7e99-8656-7f36a46784f4€35.00€0.50matched
45capture01a1a656-6d5b-7341-8c82-af95b822c9c6€35.00€0.50matched
46capture01a1a656-6fc1-7044-86a8-0d06ec147913€35.00€0.50matched
47capture01a1a656-79e5-70ef-ba97-3667433f1118€49.00€0.67matched
48capture01a1a656-85ba-7b20-a8b0-3d3f1f983fb3€15.00€0.26matched
49capture01a1a656-94fc-723b-ba26-a69de1e4d4e7€24.00€0.37matched
50capture01a1a656-bc12-715d-9ee8-112f87a7fac4€35.00€0.50matched
51capture01a1a656-e50c-7143-8d18-05542731c5c4€9.00€0.19matched
52capture01a1a656-f51f-79f8-a3bf-7918e609ae01€24.00€0.37matched
53capture01a1a656-fab3-771a-9db0-ef373647e7eb€15.00€0.26matched
54capture01a1a657-367c-787a-964b-ae05db5a2f93€49.00€0.67matched
55capture01a1a657-5054-763b-a392-b888fe8490b8€35.00€0.50matched
56capture01a1a657-50aa-7f05-b373-e188553a3162€49.00€0.67matched
57capture01a1a657-598c-7fbc-9dc9-28ec91b444b6€35.00€0.50matched
58capture01a1a657-7c40-7618-96ee-eab0dfd331f2€15.00€0.26matched
59capture01a1a657-8c59-7426-953f-2dae6378fc48€24.00€0.37matched
60capture01a1a657-a94a-7491-838a-23166d870d59€35.00€0.50matched
61capture01a1a657-bdc3-7228-b3ee-fab181e8b615€35.00€0.50matched
62capture01a1a657-e2db-746a-b43c-7a7a362015d6€9.00€0.19matched
63capture01a1a657-e706-7385-a56c-45af74316463€15.00€0.26matched
64capture01a1a658-22b8-75c5-a713-7ab257a4e563€49.00€0.67matched
65capture01a1a658-2c7e-7fdc-91b3-53fa58ac7667€24.00€0.37matched
66refund01a1a658-3830-73ab-9bbe-21ffb80e9c92-€8.00€0.00matched
67capture01a1a658-5cc8-7982-b015-e0484507b21e€24.00€0.37matched
68capture01a1a658-7ef5-7793-9a3e-b57833159e45€24.00€0.37matched
69capture01a1a658-91f7-7867-ae76-720467ea4e6c€15.00€0.26matched
70capture01a1a658-c270-7d40-b5f1-5045fd81e4b2€49.00€0.67matched
71capture01a1a658-cc30-71df-bb92-6449cf5d342d€24.00€0.37matched
72capture01a1a659-01ae-7eca-90b9-208fd9c5d574€15.00€0.26matched
73capture01a1a659-07bd-7358-87ec-a2de2e57d4a1€15.00€0.26matched
74capture01a1a659-1a7f-7e97-8463-7a23d238e78d€35.00€0.50matched
75capture01a1a659-2e24-7fb5-a2e1-332f9a969f80€35.00€0.50matched
76capture01a1a659-3adc-700e-9b81-6b3ba26e55ac€15.00€0.26matched
77capture01a1a659-4866-7e91-8613-bd947a3ac50f€35.00€0.50matched
78capture01a1a659-4b21-728c-a0e3-654073083fba€49.00€0.67matched
79capture01a1a659-55f6-7f71-8c69-e7e86e5ce5d6€9.00€0.19matched
80capture01a1a659-5a0a-7cbd-83ae-81fb5776c885€15.00€0.26matched
81capture01a1a659-6b51-7904-be13-9020b842d1d8€9.00€0.19matched
82refund01a1a659-7b44-71da-86bd-f98e80daa6f7-€17.00€0.00matched
83capture01a1a659-943c-75f2-a47d-5094bec5bcf3€35.00€0.50matched
84capture01a1a659-da85-77ed-8e86-f43c9c3ff962€9.00€0.19matched
85capture01a1a659-e305-740b-9b7b-38edd8902316€35.00€0.50matched
86capture01a1a659-e7fd-7ce4-8cba-94a1d33cae69€9.00€0.19matched
87capture01a1a659-e93e-7a8b-9fe9-99d9f212d7bb€15.00€0.26matched
88capture01a1a65a-1424-76f6-ba92-e72179841055€15.00€0.26matched
89refund01a1a65a-1607-74a5-bf78-25f87e4ace9f-€2.00€0.00matched
90capture01a1a65a-42c3-7017-99ba-e92040c39b0b€9.00€0.19matched
91capture01a1a65a-4a27-7d6a-b166-f837ff7a7121€9.00€0.19matched
92capture01a1a65a-4f00-788b-adc2-733d20effdad€35.00€0.50matched
93capture01a1a65a-6213-779e-be75-a315f490ab47€35.00€0.50matched
94capture01a1a65a-7fe1-79d3-9741-21cdb7414756€24.00€0.37matched
95refund01a1a65a-ac7d-720f-aa68-1f747bf80625-€27.00€0.00matched
96capture01a1a65a-b94d-7401-bb1f-7377c5c4ae9a€24.00€0.37matched
97capture01a1a65a-bd29-7de5-9ada-6c1063985eff€35.00€0.50matched
98capture01a1a65a-d97b-7423-bdff-a1458e68dc16€9.00€0.19matched
99capture01a1a65a-f704-78a5-8353-5375352272a1€15.00€0.26matched
100capture01a1a65a-f9b3-7d7a-88ed-e66e69a19ca1€49.00€0.67matched
101capture01a1a65b-0a0e-767e-a8f2-f943edba855e€49.00€0.67matched
102capture01a1a65b-0ee6-7e41-8378-4d9021d64ab8€49.00€0.67matched
103capture01a1a65b-1463-72dd-9846-641bc85b184d€35.00€0.50matched
104capture01a1a65b-1f01-7805-9625-c598f6578fd6€15.00€0.26matched
105capture01a1a65b-1fc8-7a87-a8a9-5f5d50fc0a2f€49.00€0.67matched
106capture01a1a65b-2c1f-72fe-9224-733adb74756a€49.00€0.67matched
107capture01a1a65b-3d2e-7e22-8f0a-09cb84ee3ada€49.00€0.67matched
108refund01a1a65b-4ba2-7950-9e4d-98fc987d95f1-€49.00€0.00matched
109capture01a1a65b-67c4-7bf6-9b3a-61fd4c3bc193€9.00€0.19matched
110capture01a1a65b-6a07-79a9-b739-7f689ff92c1a€35.00€0.50matched
111capture01a1a65b-6b45-7070-8d16-5bdd34c46928€49.00€0.67matched
112capture01a1a65b-81a8-7252-80ec-6b0d4ba9275e€9.00€0.19matched
113capture01a1a65b-89d2-7116-8575-4e031ad2a668€15.00€0.26matched
114capture01a1a65b-94fa-7def-8c27-4cc155260f0f€9.00€0.19matched
115capture01a1a65b-b34b-71f8-9d9a-085ce7a14dd3€9.00€0.19matched
116capture01a1a65b-b540-76d2-b232-484b7ed9bcb6€24.00€0.37matched
117capture01a1a65b-c15c-79a8-8734-40f53e163fff€49.00€0.67matched
118capture01a1a65b-c63d-773c-8b9c-d8d28aacc9dd€35.00€0.50matched
119capture01a1a65b-ca73-72ac-818f-69a16980e317€35.00€0.50matched
120capture01a1a65b-d2de-763c-ba3f-10a613485e8e€49.00€0.67matched
121capture01a1a65b-d9a2-743f-aba0-8eaed3c52f25€15.00€0.26matched