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

Gross

€2,809.00

PSP fee

€45.35

Net to the bank

€2,763.65

Settlement journal

#383017

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a797-5280-7231-bb7c-0bd68ad44c9c is already settled by stl_EUR_2989688 line 71
  • duplicate linethe file lists it twicecapture:01a1a798-ccc2-7cd0-b2d0-38607b8a50db is already settled by stl_EUR_2989688 line 92
LineKindReferenceGrossFeeStatus
72capture01a1a797-52d9-76fc-ab1d-fc38f94aee42€24.00€0.37duplicate line
93capture01a1a798-cce1-7ff1-935f-444df76a8adc€35.00€0.50duplicate line
1capture01a1a78a-30fb-751c-91c8-c54002177454€49.00€0.67matched
2capture01a1a78d-4a24-75f6-a46d-9e850e6b74a6€49.00€0.67matched
3capture01a1a78d-5af9-7e89-b028-c1f025f80298€49.00€0.67matched
4capture01a1a78d-f5b7-7a92-9183-1b132c9e8ef7€15.00€0.26matched
5capture01a1a78e-7201-7492-b417-601f3182c2e8€49.00€0.67matched
6capture01a1a793-2eaf-75c4-8700-0af29844fbec€9.00€0.19matched
7refund01a1a793-454e-76c3-92d7-0f3447b1a13a-€20.00€0.00matched
8refund01a1a793-50a3-72b4-b330-15371c431c12-€19.00€0.00matched
9capture01a1a793-537f-72be-a5da-35732afe414b€49.00€0.67matched
10capture01a1a793-5618-7c73-bf85-bda02fca218a€24.00€0.37matched
11capture01a1a793-56c5-769e-ae43-da9d0cd25eb3€35.00€0.50matched
12capture01a1a793-5530-76ff-b680-7ef267b716c6€15.00€0.26matched
13capture01a1a793-7846-7ab3-84d1-a35fa7c3adea€15.00€0.26matched
14capture01a1a793-89d6-75b7-81a4-5f5a58249f7c€35.00€0.50matched
15capture01a1a793-9674-762b-a3fa-8a17a7e88679€9.00€0.19matched
16capture01a1a793-b9a1-7050-bdd3-e399aef79ed5€24.00€0.37matched
17capture01a1a793-c0bc-7fed-8efd-e2e79e030e88€9.00€0.19matched
18capture01a1a793-c37c-72ca-bcc9-65ecf7580cfd€49.00€0.67matched
19capture01a1a793-c3ae-7239-ae8f-ecdb94fb9dd6€35.00€0.50matched
20refund01a1a793-e725-7775-8740-d4fcd463d0d3-€8.00€0.00matched
21capture01a1a793-f08c-779d-8d7a-7027ae5046c4€9.00€0.19matched
22capture01a1a794-1bbd-749b-88dc-8797e3fa92f8€49.00€0.67matched
23capture01a1a794-37f5-7c1c-a11d-5c1590166437€9.00€0.19matched
24capture01a1a794-42ee-7f79-b56a-74ddfe0229f3€9.00€0.19matched
25capture01a1a794-9672-75b1-a787-89a4251d4bb9€24.00€0.37matched
26capture01a1a794-a5ff-7f9b-a3c3-17498472aa1d€49.00€0.67matched
27capture01a1a794-a914-7f45-8756-8d898f101a93€49.00€0.67matched
28capture01a1a794-ab00-77b4-a3e8-9e221af7199a€15.00€0.26matched
29capture01a1a794-df4b-7cd5-b6cc-0ead6b856312€49.00€0.67matched
30capture01a1a794-e6d7-73e0-8112-0b49f6b6311b€24.00€0.37matched
31capture01a1a794-e816-7e96-ab40-fd3b6ea50c86€35.00€0.50matched
32capture01a1a795-0ee1-752d-893a-752047506008€49.00€0.67matched
33refund01a1a795-0fbc-754a-9e6c-31a8accd4b1f-€13.00€0.00matched
34capture01a1a795-1b93-749d-813d-678197382504€35.00€0.50matched
35capture01a1a795-22db-797a-9820-861c01627ec2€49.00€0.67matched
36capture01a1a795-4320-7c3a-8fe8-89ad9d00a467€15.00€0.26matched
37capture01a1a795-5e57-79c7-8899-0fe7efc9ac60€9.00€0.19matched
38refund01a1a795-7478-78f8-8853-a390e6f8a795-€14.00€0.00matched
39refund01a1a795-8609-7cdb-9b1a-fa5a48360fd2-€35.00€0.00matched
40refund01a1a795-843c-7ca8-9e92-9e1b9de015d4-€42.00€0.00matched
41capture01a1a795-8a94-7b31-985a-8a3337c3ec70€35.00€0.50matched
42capture01a1a795-b82e-7bb7-8643-200b4850f707€9.00€0.19matched
43capture01a1a795-ba57-7400-9583-81e694c0a701€24.00€0.37matched
44capture01a1a795-c513-7abf-843a-149eb670e7c7€15.00€0.26matched
45refund01a1a795-e0a7-73da-85df-0aa67adae52f-€31.00€0.00matched
46refund01a1a795-f1b1-7b7f-add6-6fc8f730566b-€8.00€0.00matched
47capture01a1a795-f9e9-7f6f-8c2c-21db0c7e0786€49.00€0.67matched
48capture01a1a796-1600-70c0-95f7-c0a03826550d€9.00€0.19matched
49capture01a1a796-1e1c-70c7-b25b-3d0f7afb71a0€15.00€0.26matched
50capture01a1a796-232a-787e-b2c1-71d61c4e8da5€9.00€0.19matched
51capture01a1a796-26b8-7fe9-b1ac-22cd8fd67cc5€9.00€0.19matched
52capture01a1a796-2b36-7e3c-90a3-d932a81119d3€15.00€0.26matched
53capture01a1a796-4646-72b4-9ff5-9c4fb1225822€24.00€0.37matched
54capture01a1a796-5ac0-74c4-96bd-ccbbd98dc6cf€49.00€0.67matched
55capture01a1a796-73dd-77b2-9b02-9075e5e969c2€9.00€0.19matched
56capture01a1a796-7a37-74d2-8cd6-def70a62ae06€9.00€0.19matched
57capture01a1a796-852c-705f-a9e3-141bda2513d6€9.00€0.19matched
58capture01a1a796-8802-721f-ab66-b15f29a7dbc0€9.00€0.19matched
59capture01a1a796-8f81-7c66-bd49-50cc7fc28e64€49.00€0.67matched
60refund01a1a796-ace9-723c-92d9-96f99dc12dba-€8.00€0.00matched
61capture01a1a796-bb36-7480-98e7-2c4c850bb731€15.00€0.26matched
62capture01a1a796-e8df-784e-b4a8-8e47c1da6c1e€15.00€0.26matched
63capture01a1a796-e9a4-722e-8809-059202849862€9.00€0.19matched
64capture01a1a796-eefb-7a78-b7dd-e44ef6748c9e€24.00€0.37matched
65capture01a1a796-eeef-713c-a4cf-74a77fe9b36e€35.00€0.50matched
66capture01a1a797-0960-7ed5-8832-d84d5af2af6c€15.00€0.26matched
67capture01a1a797-104d-7ce6-ad63-d9caa1e296f8€24.00€0.37matched
68capture01a1a797-1e65-768d-9ab5-7d6df05c61a2€49.00€0.67matched
69capture01a1a797-4e40-7ac0-9470-615a4ee46bd9€49.00€0.67matched
70capture01a1a797-5083-7000-908c-b34abd9ddd33€24.00€0.37matched
71capture01a1a797-52d9-76fc-ab1d-fc38f94aee42€24.00€0.37matched
73capture01a1a797-6469-7b61-93a1-1d88c1136245€9.00€0.19matched
74capture01a1a797-744d-73d3-9e76-af3b692ea154€15.00€0.26matched
75capture01a1a797-b819-7c3a-8030-9b1639cf6cc7€49.00€0.67matched
76capture01a1a797-ba95-7048-a113-499626305ebd€49.00€0.67matched
77capture01a1a797-c0cf-70c4-ae44-5f1daa1cef86€49.00€0.67matched
78capture01a1a797-cbe7-79ec-8c56-d135ab226339€15.00€0.26matched
79capture01a1a797-d095-7ed7-8ebe-e82284bccfed€15.00€0.26matched
80capture01a1a797-d41f-77c5-b119-a33d3eb61107€35.00€0.50matched
81capture01a1a797-d8f1-7244-abb1-050ca34cf84e€35.00€0.50matched
82capture01a1a798-2c78-7f0d-8886-e7b6eb039ee2€35.00€0.50matched
83capture01a1a798-5cb3-7b6a-862b-b0941baabc29€35.00€0.50matched
84capture01a1a798-66f9-76c4-9168-1d66ddbc456d€49.00€0.67matched
85capture01a1a798-6841-799b-927f-6bf76d8059b3€15.00€0.26matched
86capture01a1a798-6a69-7d5e-bd26-ca56316f8d66€9.00€0.19matched
87capture01a1a798-6a7b-7e59-9022-1c610eda949e€49.00€0.67matched
88capture01a1a798-7f88-7a42-b857-366e98ddaddd€15.00€0.26matched
89capture01a1a798-afb4-7746-8ff5-845ec0aa64da€24.00€0.37matched
90capture01a1a798-b7db-73db-a686-814bde499f50€24.00€0.37matched
91capture01a1a798-bee7-74d7-adbf-ed23c2acdee2€24.00€0.37matched
92capture01a1a798-cce1-7ff1-935f-444df76a8adc€35.00€0.50matched
94capture01a1a798-ce8a-76a3-a52a-92a49e1cbcc0€9.00€0.19matched
95capture01a1a798-d2ad-768c-ad69-8149ea18cbd9€24.00€0.37matched
96capture01a1a799-10c4-7087-8cc2-1628fc40b7c5€24.00€0.37matched
97capture01a1a799-2703-71d4-a746-27ac1ac890c4€24.00€0.37matched
98capture01a1a799-40fd-772e-bc8d-0e9addc23907€35.00€0.50matched
99capture01a1a799-6a55-73b7-aa16-038458338e7a€49.00€0.67matched
100capture01a1a799-6b9f-7cda-8ec2-399c8b73975d€9.00€0.19matched
101capture01a1a799-795a-7bf1-85eb-2e9101dce1ab€24.00€0.37matched
102capture01a1a799-c7c9-79d5-a099-cdbd8731cc55€9.00€0.19matched
103capture01a1a799-f241-7281-865f-2e815b85cfb2€15.00€0.26matched
104capture01a1a79a-01c5-7157-9b43-71bad4cb4933€15.00€0.26matched
105capture01a1a79a-2d7a-7e2b-b56c-dc7ce8c34956€24.00€0.37matched
106capture01a1a79a-2df9-7c7a-91d7-234d973b9d02€24.00€0.37matched
107capture01a1a79a-30e3-787e-b3a2-f59191214a14€9.00€0.19matched
108capture01a1a79a-3c0e-7784-81bd-83e6c20a95a3€35.00€0.50matched
109capture01a1a79a-3c24-741c-9707-35e93ad3995b€24.00€0.37matched
110capture01a1a79a-4722-7a26-8bbd-3cab851b4009€24.00€0.37matched
111capture01a1a79a-d393-7f91-b9bf-5347afc38474€49.00€0.67matched
112capture01a1a79a-f786-7a20-932c-85eabfcb3fad€15.00€0.26matched
113capture01a1a79b-0dc3-7bbc-9d6e-d52e87d96955€35.00€0.50matched
114capture01a1a79b-29d4-7d6c-9502-bdc5ddf769ca€24.00€0.37matched
115capture01a1a79b-703c-78cc-a227-a85363ea36ae€15.00€0.26matched
116capture01a1a79b-7796-7f30-a18e-543427f19c34€9.00€0.19matched
117capture01a1a79b-77d5-7098-8cdc-7143aa5c23a9€24.00€0.37matched
118capture01a1a79b-971d-7e70-9aaa-caf08a2ba840€15.00€0.26matched
119capture01a1a79b-9da7-7a68-ae32-e7122688ba2e€24.00€0.37matched
120capture01a1a79b-a4e1-76ea-af10-a808dc44f78d€15.00€0.26matched
121capture01a1a79b-c574-7976-8177-d41c49fcf553€15.00€0.26matched
122capture01a1a79b-e0c5-7a09-a904-b3e2842b444c€35.00€0.50matched
123capture01a1a79b-f27e-77e2-8a51-425b65170bcc€49.00€0.67matched
124capture01a1a79c-3c13-7f88-b2be-076d63387b1e€35.00€0.50matched