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

3 Nov, 08:20

Gross

€2,644.00

PSP fee

€41.91

Net to the bank

€2,602.09

Settlement journal

#357981

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a07f-7301-701d-8c6c-34bfec47c704 is already settled by stl_EUR_2989490 line 16
  • missing linein the books, not in the filecapture:01a1a07e-7cab-76e8-a996-4cd683a20639 is in no file
LineKindReferenceGrossFeeStatus
17capture01a1a07f-7339-7efc-a598-afee562b53b8€9.00€0.19duplicate line
1capture01a1a076-50e0-7e16-a4eb-8837f791ecbc€9.00€0.19matched
2capture01a1a077-3996-7a80-9356-bc1b94fcddc4€15.00€0.26matched
3capture01a1a07d-5897-7ab3-82e2-cc1a01a6c767€49.00€0.67matched
4capture01a1a07e-7ecc-75e0-a681-dcdeed85bd51€15.00€0.26matched
5capture01a1a07e-9266-72d3-b0a6-28080f8129f5€24.00€0.37matched
6capture01a1a07e-99db-7550-bd10-de054b69a6d9€15.00€0.26matched
7capture01a1a07e-9b5f-779d-ab63-157407e22fd8€35.00€0.50matched
8capture01a1a07e-a595-7bcd-9ce8-2700782a777d€35.00€0.50matched
9capture01a1a07e-c42b-7405-a726-cd6721d4e0f8€49.00€0.67matched
10capture01a1a07e-d23c-70fa-9432-f0d293018312€9.00€0.19matched
11refund01a1a07e-d4b0-7243-b6cb-dfc6f24002ec-€11.00€0.00matched
12capture01a1a07e-f245-7683-8d95-d1d96bee1976€24.00€0.37matched
13capture01a1a07f-0dd9-7a81-8ef7-eb023efb7798€35.00€0.50matched
14capture01a1a07f-2de2-793e-a7d9-6019a7007d56€49.00€0.67matched
15capture01a1a07f-70b7-7348-aa2b-a339f364074f€35.00€0.50matched
16capture01a1a07f-7339-7efc-a598-afee562b53b8€9.00€0.19matched
18capture01a1a07f-7ec2-74bf-b835-fb5e6aefed02€9.00€0.19matched
19capture01a1a07f-cf57-79a0-b263-612f3708c89f€49.00€0.67matched
20capture01a1a07f-d20f-7490-8eab-48721920a797€49.00€0.67matched
21capture01a1a07f-f760-7ec7-9f06-7683f2373198€15.00€0.26matched
22capture01a1a080-3e0a-7231-8807-590ded4f9fa6€9.00€0.19matched
23capture01a1a080-462f-7f8f-8fc5-fdd51759bd98€49.00€0.67matched
24capture01a1a080-6c01-7296-ae48-26d227dc4303€9.00€0.19matched
25capture01a1a080-6d45-71c7-aaae-cf0fcdbca032€35.00€0.50matched
26refund01a1a080-7729-782b-9f4a-a3b0bb3ef19a-€7.00€0.00matched
27capture01a1a080-79a9-7066-b378-5433a67fafd9€15.00€0.26matched
28capture01a1a080-8a40-7cbb-9266-64a5d5305c38€49.00€0.67matched
29capture01a1a080-8bad-7c32-99ad-a6c0fd72cd3d€15.00€0.26matched
30capture01a1a080-940a-7c6b-8cbd-333ed8ced163€49.00€0.67matched
31capture01a1a080-9705-72da-b1a8-e5335258201f€15.00€0.26matched
32capture01a1a080-99a9-74b8-8ad3-e4b836c18838€35.00€0.50matched
33capture01a1a080-9be0-710b-95cd-79e2fac7fe9d€9.00€0.19matched
34capture01a1a080-b322-76bc-9476-5f8e4954892b€24.00€0.37matched
35capture01a1a080-af68-79da-bd4c-7158b09205f5€49.00€0.67matched
36refund01a1a080-c672-7633-a43d-31e02a378c24-€11.00€0.00matched
37capture01a1a080-ca45-714e-9845-8e099d4090f9€35.00€0.50matched
38capture01a1a080-d0c5-7183-adab-35b24b5ec7da€24.00€0.37matched
39capture01a1a080-d383-73ef-918f-af741bfc2fd3€24.00€0.37matched
40capture01a1a080-dd11-7720-a1c3-e89605f38734€9.00€0.19matched
41capture01a1a080-e4f9-780a-b784-4e496b18109e€9.00€0.19matched
42capture01a1a080-e7ad-70ae-961b-ee19ba016cdc€15.00€0.26matched
43refund01a1a080-ebfc-796e-a2a8-c03376d217f3-€14.00€0.00matched
44refund01a1a080-fcfc-78ec-a75e-280980ffa9b1-€7.00€0.00matched
45capture01a1a081-249b-7ff3-9881-4425b5184786€15.00€0.26matched
46capture01a1a081-5b19-75f2-bfb2-6efce42aa266€15.00€0.26matched
47capture01a1a081-5f98-79ab-a62a-d9cafa6dfbf2€49.00€0.67matched
48capture01a1a081-67cd-7a12-bc98-13ba8e66166d€9.00€0.19matched
49capture01a1a081-69ea-73c7-a2b2-cef56a8a7465€15.00€0.26matched
50capture01a1a081-6b83-7e03-913e-72c7e6b6497a€24.00€0.37matched
51capture01a1a081-79a2-7e39-960d-dd4ebc312a50€35.00€0.50matched
52capture01a1a081-7e65-733d-ab84-57bcdb60712b€15.00€0.26matched
53capture01a1a081-bbf3-768d-826a-c8e146ea813c€24.00€0.37matched
54capture01a1a081-c0bc-7224-996e-45be398228a8€24.00€0.37matched
55capture01a1a081-d61c-717d-9237-185d9e77ee68€15.00€0.26matched
56capture01a1a081-e9b9-7731-845e-04e3efc3ef9b€24.00€0.37matched
57capture01a1a082-1bfc-7994-8da9-c2b39fa0cff5€49.00€0.67matched
58capture01a1a082-2a3a-7d87-9bde-7bfe91d97ad2€9.00€0.19matched
59capture01a1a082-33dc-7a03-a565-ec10511a62e4€35.00€0.50matched
60capture01a1a082-357a-760b-984b-1a620c8355f1€35.00€0.50matched
61capture01a1a082-3633-709c-a21e-88f32b752fc9€49.00€0.67matched
62capture01a1a082-52bc-71f4-9e41-e95fe1aa4ba0€9.00€0.19matched
63capture01a1a082-5eb7-72b9-a752-e2d68a15efd7€15.00€0.26matched
64capture01a1a082-8dec-79c1-995b-7fe5073b28b3€9.00€0.19matched
65capture01a1a082-ac27-79da-a8b1-6cabb57ed839€35.00€0.50matched
66refund01a1a082-ac6b-7d8d-9621-98f09d069ee3-€3.00€0.00matched
67capture01a1a082-b4a5-72c3-a0b0-b8fc4a3963cb€49.00€0.67matched
68capture01a1a083-183b-77ed-b341-d890201a3b1d€49.00€0.67matched
69capture01a1a083-1869-7c82-94f6-c7eedbbb84c5€9.00€0.19matched
70capture01a1a083-1e4f-72db-8fef-1048ee3e63a3€24.00€0.37matched
71capture01a1a083-8dd2-7b7c-bc0d-27f856b3d7b4€35.00€0.50matched
72capture01a1a083-abd6-7092-ac44-28adf16a6e32€9.00€0.19matched
73capture01a1a083-b7ac-7ea0-af9e-6a82e9ef5994€9.00€0.19matched
74capture01a1a083-bf49-7704-b3b9-be2847f38693€15.00€0.26matched
75capture01a1a083-e48d-7cf6-b0cd-8c5274a5ec0e€15.00€0.26matched
76capture01a1a083-e4af-77b7-8ddc-069e2ee79a4d€9.00€0.19matched
77capture01a1a083-edb0-7713-afa9-96493af1d314€24.00€0.37matched
78capture01a1a084-0575-796c-8891-d89906040eb6€24.00€0.37matched
79capture01a1a084-142c-75fc-9585-84f374f63923€9.00€0.19matched
80capture01a1a084-15dc-78e0-bca1-ebdbd5b0aefb€15.00€0.26matched
81capture01a1a084-1fae-7cf6-bb9b-0350f2ee81be€35.00€0.50matched
82capture01a1a084-2ba4-79c7-9720-e46820d90289€24.00€0.37matched
83refund01a1a084-33a8-753e-907d-10da2cc8f391-€4.00€0.00matched
84capture01a1a084-4328-702f-9bfd-375cfb1185af€9.00€0.19matched
85capture01a1a084-4da3-7cb8-965d-c6502780bda9€9.00€0.19matched
86capture01a1a084-5ce4-7a7c-b0aa-4f8e057b44ad€9.00€0.19matched
87capture01a1a084-6706-7dfe-a3f5-b4b8b026ef67€49.00€0.67matched
88capture01a1a084-9fa0-7f25-bb06-38b071fccc76€24.00€0.37matched
89capture01a1a084-acc8-70f6-ab5e-da65ed77a8d3€24.00€0.37matched
90capture01a1a084-e469-7cab-b45d-3dfb09ee59ea€35.00€0.50matched
91capture01a1a084-f72f-7235-9d0a-a1ee8023b764€49.00€0.67matched
92capture01a1a084-fcf1-7928-9f50-c0eb8b4b281c€9.00€0.19matched
93capture01a1a085-111a-7dd7-a690-94a61a0b7cf4€24.00€0.37matched
94capture01a1a085-1642-7f35-a5f3-56a03951192d€15.00€0.26matched
95capture01a1a085-3d3d-77f2-96ee-c5f9c75c7850€9.00€0.19matched
96capture01a1a085-6041-7368-8264-d11adeffc70e€15.00€0.26matched
97refund01a1a085-66e3-756c-b565-d94c48288f35-€13.00€0.00matched
98refund01a1a085-7220-7a15-b45d-bad399a2d097-€4.00€0.00matched
99capture01a1a085-8cb1-7c66-897f-c5f763e0c94a€35.00€0.50matched
100capture01a1a085-aaa8-7489-af44-765b838433f1€15.00€0.26matched
101capture01a1a085-ea8b-73fb-8d98-6dcfd294b93d€15.00€0.26matched
102capture01a1a085-fe7c-7223-a850-ae5aeecd6d3c€35.00€0.50matched
103capture01a1a086-0a20-7a45-a44c-bc2b0fa578bb€24.00€0.37matched
104capture01a1a086-1213-7469-bcb9-73692f783d1c€15.00€0.26matched
105capture01a1a086-1425-7d71-b38d-bafa7c011829€35.00€0.50matched
106capture01a1a086-1491-72c6-b1ca-4ede45a03ef4€9.00€0.19matched
107capture01a1a086-1bc6-70a2-b94f-d42692a90953€49.00€0.67matched
108refund01a1a086-36cd-75a9-bc4f-7dc8da8d2e5f-€6.00€0.00matched
109capture01a1a086-3b1d-74e9-86a5-03ccdd59eecc€15.00€0.26matched
110refund01a1a086-3f24-72c3-a58c-b802c3112e06-€4.00€0.00matched
111capture01a1a086-486d-7366-9855-ac8b25924448€35.00€0.50matched
112capture01a1a086-4e41-7d0b-af86-b28967d95d2a€9.00€0.19matched
113capture01a1a086-a6aa-7925-9397-810732d630b3€24.00€0.37matched
114capture01a1a086-a9df-7565-984c-d53edcd8b7ae€15.00€0.26matched
115capture01a1a086-aa91-71b5-9fbf-2dbd6933e3f6€9.00€0.19matched
116capture01a1a086-d30c-7f6f-9f2e-bd8f90dc35a3€15.00€0.26matched
117capture01a1a086-ec0d-7f21-9f79-bf3f6fb32d9e€35.00€0.50matched
118capture01a1a087-0232-730a-bbfb-dbbc28f2c6ad€24.00€0.37matched
119capture01a1a087-2070-7b8a-9e36-7c0731c3b63a€49.00€0.67matched
120capture01a1a087-26d1-7171-80e7-ce0162b3f9b0€35.00€0.50matched
121capture01a1a087-2ff5-7c37-829e-20e9ce95481f€9.00€0.19matched
122capture01a1a087-4cf1-71b3-8ff7-591b5e42fdf2€15.00€0.26matched
123capture01a1a087-552c-7a36-b97c-fdd9872844ae€24.00€0.37matched
124capture01a1a087-7496-71cd-b2c2-8545ba28282c€24.00€0.37matched