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

Gross

€2,917.00

PSP fee

€46.42

Net to the bank

€2,870.58

Settlement journal

#400195

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ac68-364b-7c90-a858-97cd44427dce is already settled by stl_EUR_2989823 line 14
  • duplicate linethe file lists it twicecapture:01a1ac6b-f8c4-76a5-abf5-b23eb9041d97 is already settled by stl_EUR_2989823 line 68
LineKindReferenceGrossFeeStatus
15capture01a1ac68-3679-7d26-b38d-dcc28cb54f28€9.00€0.19duplicate line
69capture01a1ac6b-f8fb-70c3-af36-82899cbb1eaa€9.00€0.19duplicate line
1capture01a1ac5e-8c15-7a40-808b-f3935d65864b€9.00€0.19matched
2capture01a1ac67-2df9-707b-b74d-398e6677d965€49.00€0.67matched
3capture01a1ac67-3054-74ec-b259-724c3881ad17€9.00€0.19matched
4capture01a1ac67-3796-7756-b6ad-fb44656a1ae7€24.00€0.37matched
5capture01a1ac67-3f3e-78ae-a456-9de06092b1b9€49.00€0.67matched
6capture01a1ac67-602e-7c15-b07e-01be82d20aba€24.00€0.37matched
7capture01a1ac67-5770-773b-afbb-254008ab9ec8€24.00€0.37matched
8capture01a1ac67-83e6-7fdc-adce-437ad7f6d686€49.00€0.67matched
9capture01a1ac67-ab8c-7637-8659-0293e7bc2f89€24.00€0.37matched
10capture01a1ac67-ad67-7fb4-bbb4-f5300b2b9072€15.00€0.26matched
11capture01a1ac67-d585-7c8c-bc25-8b96367dcf81€24.00€0.37matched
12capture01a1ac67-f76b-7b95-b182-5cf180f3d5c7€15.00€0.26matched
13capture01a1ac68-1730-700d-a5e0-8cbaea75708f€24.00€0.37matched
14capture01a1ac68-3679-7d26-b38d-dcc28cb54f28€9.00€0.19matched
16refund01a1ac68-36f7-7eb8-b7e2-e2b54fc6210e-€8.00€0.00matched
17capture01a1ac68-7be3-703f-9c94-4a9bf372ba1b€49.00€0.67matched
18capture01a1ac68-8a2e-7812-89f9-d42ea8773286€24.00€0.37matched
19capture01a1ac68-973a-7e81-b693-7e0fefe7f038€49.00€0.67matched
20capture01a1ac68-9953-764d-8cb6-e5941557a3f3€24.00€0.37matched
21capture01a1ac68-c2bd-7d00-bae6-5ace800de32a€9.00€0.19matched
22refund01a1ac68-cdc7-7aab-9fb3-546b49421ed2-€11.00€0.00matched
23capture01a1ac68-d781-7c2e-9609-769acfa15f02€35.00€0.50matched
24refund01a1ac68-d9be-77e5-9077-babe3a8e065f-€35.00€0.00matched
25capture01a1ac68-e314-73e4-880d-1444aeeee295€49.00€0.67matched
26capture01a1ac68-f9f5-7682-92f7-b1bf386a5445€49.00€0.67matched
27capture01a1ac69-1f83-767f-a3f9-876d74c5df2b€24.00€0.37matched
28capture01a1ac69-2455-7873-b5fb-2af048e04da2€15.00€0.26matched
29capture01a1ac69-2a0e-732e-916b-246d03662c85€49.00€0.67matched
30capture01a1ac69-30ab-711c-a972-face38f6329b€49.00€0.67matched
31capture01a1ac69-36ab-7880-8056-bc59405a77d4€15.00€0.26matched
32capture01a1ac69-3f17-7bf1-ac41-b2f7002501dd€9.00€0.19matched
33capture01a1ac69-5955-7822-8597-06f9510670b9€24.00€0.37matched
34capture01a1ac69-7421-7d7f-8cc6-8cc0498fff61€35.00€0.50matched
35capture01a1ac69-91ad-7e6a-b284-d3731b50a1a1€35.00€0.50matched
36capture01a1ac69-932b-74af-bacd-5357965d77e5€24.00€0.37matched
37capture01a1ac69-9643-70bc-aa2c-3c511e074e14€24.00€0.37matched
38capture01a1ac69-a929-7a03-92a9-445f768a588d€15.00€0.26matched
39capture01a1ac69-cb03-7295-9f05-fdd4e9d474a7€24.00€0.37matched
40capture01a1ac6a-0f56-7025-83ee-befa17d15a34€9.00€0.19matched
41capture01a1ac6a-5fc3-7e4f-9f10-7bc850af9593€49.00€0.67matched
42capture01a1ac6a-7043-714e-ae7b-d76edbbbf2df€15.00€0.26matched
43capture01a1ac6a-73e4-77d4-a145-ad252d618604€24.00€0.37matched
44capture01a1ac6a-a35b-7f8f-8bfa-5f9a786dc5e1€35.00€0.50matched
45capture01a1ac6a-d58a-70d8-b281-8c87401febe7€15.00€0.26matched
46capture01a1ac6a-e34f-735d-8ed8-ed0c96269426€35.00€0.50matched
47capture01a1ac6a-efa9-7824-b1f2-da7b776e78c9€24.00€0.37matched
48capture01a1ac6a-f410-766a-a8e8-7ef8bcdc8ac0€35.00€0.50matched
49capture01a1ac6a-fc8c-7214-8df2-bfa559ae866b€9.00€0.19matched
50capture01a1ac6b-1b6d-7d01-8fe5-c3576dcd7bd8€24.00€0.37matched
51capture01a1ac6b-28ef-7547-8ea6-7be8a9887a7e€35.00€0.50matched
52capture01a1ac6b-29d4-7f6f-8d8e-15c03473b42b€49.00€0.67matched
53capture01a1ac6b-31f0-7c33-89aa-f0278f88ff35€15.00€0.26matched
54capture01a1ac6b-353e-793f-8a31-7e5d28d8eb2a€35.00€0.50matched
55capture01a1ac6b-4853-74d2-bb62-0dde4332e554€49.00€0.67matched
56capture01a1ac6b-4b38-70b9-b7da-4ba283167c73€24.00€0.37matched
57refund01a1ac6b-5740-74d8-bbbd-d47c12d7030d-€25.00€0.00matched
58capture01a1ac6b-5b9e-798f-9eab-5968626815e4€15.00€0.26matched
59capture01a1ac6b-6191-7468-99bf-c23cd838130d€24.00€0.37matched
60capture01a1ac6b-71d2-7f19-973b-ecf495782054€35.00€0.50matched
61refund01a1ac6b-b555-7275-b4bb-dccaf11a5900-€9.00€0.00matched
62capture01a1ac6b-b88d-7182-8407-0114428bbb80€9.00€0.19matched
63capture01a1ac6b-c0b0-7b49-9bb6-5acbac655060€49.00€0.67matched
64capture01a1ac6b-d31c-7e54-a384-e181735fd98c€35.00€0.50matched
65capture01a1ac6b-d44d-7cb4-b413-7a4c78c9536e€49.00€0.67matched
66capture01a1ac6b-e0d2-72c1-9ba5-1d7edb44571f€15.00€0.26matched
67capture01a1ac6b-ee41-7773-aaca-a691193cea5a€15.00€0.26matched
68capture01a1ac6b-f8fb-70c3-af36-82899cbb1eaa€9.00€0.19matched
70capture01a1ac6b-fb05-7fb6-b827-90e8a9a61634€15.00€0.26matched
71capture01a1ac6c-1e5f-74a6-8c14-8b7cce38dfbe€35.00€0.50matched
72capture01a1ac6c-43d8-7219-b162-493acdb39c7b€35.00€0.50matched
73capture01a1ac6c-7253-7b35-bbbb-c209d38001e8€15.00€0.26matched
74refund01a1ac6c-829b-7564-bc76-94dc16bcb1ff-€13.00€0.00matched
75capture01a1ac6c-8929-7dd7-ad3a-6b17cbb78527€24.00€0.37matched
76capture01a1ac6c-8f3a-704d-b993-0c4c8ec68742€35.00€0.50matched
77capture01a1ac6c-93f6-761a-833a-f80ebab3319b€9.00€0.19matched
78capture01a1ac6c-a79a-74fd-bdbe-abfde9ddd451€49.00€0.67matched
79capture01a1ac6c-be87-7326-9ede-f010d7be7770€35.00€0.50matched
80capture01a1ac6c-eb45-70e6-94bb-e15c0b39ff1b€49.00€0.67matched
81capture01a1ac6c-f7a9-7055-a480-3dfd64f26b1f€49.00€0.67matched
82capture01a1ac6d-21d1-7733-a4cc-a3d48e6cb398€15.00€0.26matched
83capture01a1ac6d-4a5f-719a-9d2e-4e73f286089d€24.00€0.37matched
84capture01a1ac6d-5442-747b-9ace-6dbb71b61686€49.00€0.67matched
85capture01a1ac6d-5963-7588-bc86-341770553a9d€49.00€0.67matched
86capture01a1ac6d-69da-7b1f-ad5a-ab934ae7e6ea€49.00€0.67matched
87capture01a1ac6d-a4ed-730a-9943-85b56bcd9dcf€49.00€0.67matched
88capture01a1ac6d-afad-7647-8cdc-e31f03cefb44€15.00€0.26matched
89capture01a1ac6d-b87e-774c-9d0b-d587e298186b€24.00€0.37matched
90capture01a1ac6d-c341-7599-88ba-8bf69f6b572d€9.00€0.19matched
91capture01a1ac6d-ff96-737e-a653-36a3642ffba4€9.00€0.19matched
92capture01a1ac6e-18c7-7d8c-b30a-960c96b175ab€49.00€0.67matched
93capture01a1ac6e-24f0-71ae-824e-708521e1978a€49.00€0.67matched
94capture01a1ac6e-5fb7-7fa4-af03-053dd4a13dd6€15.00€0.26matched
95capture01a1ac6e-7d98-7401-95e5-89a0a2bf8a9c€49.00€0.67matched
96capture01a1ac6e-976b-7c9a-bef6-7495e45490c3€35.00€0.50matched
97capture01a1ac6e-c5ff-7db2-84d8-590fb7c1415a€15.00€0.26matched
98capture01a1ac6e-cac2-7799-a329-d083d1d7cd25€24.00€0.37matched
99capture01a1ac6e-d9e5-7a9c-a26b-de945a67114e€24.00€0.37matched
100capture01a1ac6e-e24e-7f4f-bd6e-d43536d8db67€24.00€0.37matched
101refund01a1ac6e-e250-7cf4-bc93-faba4d4dab77-€38.00€0.00matched
102capture01a1ac6e-df63-778b-82c2-4ba6a612a73f€9.00€0.19matched
103capture01a1ac6e-eb55-7d51-8a7a-b12bdbdc4914€49.00€0.67matched
104refund01a1ac6e-eb4c-72e4-a16b-50e8c00c7fec-€32.00€0.00matched
105capture01a1ac6e-fb21-7801-88a3-125729389632€35.00€0.50matched
106capture01a1ac6f-0359-77ee-82f1-da80fb812b5a€35.00€0.50matched
107refund01a1ac6f-25ce-7e3b-9867-5081ce804653-€21.00€0.00matched
108capture01a1ac6f-3625-7f9c-acc1-9d1e26be3eeb€15.00€0.26matched
109capture01a1ac6f-5724-740d-94c4-accab3b75ef8€35.00€0.50matched
110capture01a1ac6f-83d3-79fc-b000-1b1e25bc4ebf€9.00€0.19matched
111capture01a1ac6f-9154-70c9-959d-648b6ef14196€24.00€0.37matched
112capture01a1ac6f-9d5b-770e-9c1c-58e85dd7aba7€49.00€0.67matched
113capture01a1ac6f-a5a9-7df0-9d06-1edab03872c6€49.00€0.67matched
114refund01a1ac6f-dc84-7145-942d-e63f907ac9ab-€14.00€0.00matched
115capture01a1ac6f-e45b-7a2e-91b6-3ee3879cb07e€49.00€0.67matched
116capture01a1ac6f-e5ec-7e0d-8d3a-013797c9af86€9.00€0.19matched
117capture01a1ac6f-ebcb-7dde-9813-c9efa46b6f9a€35.00€0.50matched
118capture01a1ac70-02ed-7b7a-9a03-727456418fa6€15.00€0.26matched
119capture01a1ac70-3a94-7200-89a5-08dbd1d93ad3€24.00€0.37matched
120capture01a1ac70-3ef5-7458-9155-72d965e8726d€24.00€0.37matched