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

19 Oct, 16:30

Gross

€2,374.00

PSP fee

€37.99

Net to the bank

€2,336.01

Settlement journal

#90178

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a15502-52e5-71e0-8e23-12c78c41bce3 is already settled by stl_EUR_2987379 line 36
LineKindReferenceGrossFeeStatus
3refund01a154fb-3836-7405-9498-ec70ff5afa90-€5.00€0.00duplicate line
37capture01a15502-5301-7961-91c4-1b7012bb3a9c€49.00€0.67duplicate line
1capture01a154f7-993b-7fde-8f65-af4242aa4cf2€49.00€0.67matched
2refund01a154fb-3836-7405-9498-ec70ff5afa90-€5.00€0.00matched
4capture01a154fe-77e7-7c6a-a8d0-0e79fad0527a€24.00€0.37matched
5capture01a154ff-d5cc-7e86-938d-f416f5c6fda8€15.00€0.26matched
6capture01a154ff-e029-7032-afac-1c135afead40€49.00€0.67matched
7capture01a154ff-e905-774b-9222-85a3d02676d9€49.00€0.67matched
8capture01a154ff-fa25-73b6-b2a3-080465100961€9.00€0.19matched
9capture01a15500-0922-7a37-92f0-c0a73a29a932€9.00€0.19matched
10capture01a15500-24d1-73f7-8f89-a9e4a669bd2b€15.00€0.26matched
11capture01a15500-3586-7101-923c-d9b7d4565ecc€9.00€0.19matched
12refund01a15500-52ec-7131-a1b5-fa27a61fad1a-€43.00€0.00matched
13capture01a15500-6d54-7a98-bd53-fa925af57a4a€24.00€0.37matched
14capture01a15500-87e8-7826-8b4f-a12257f5d669€15.00€0.26matched
15capture01a15500-a1d3-7c1a-8425-1dfb427f82d0€24.00€0.37matched
16capture01a15500-c5af-7248-9021-fc1a47a0eab3€9.00€0.19matched
17refund01a15500-cdf7-7047-8c16-0e0ae937ab7f-€14.00€0.00matched
18capture01a15500-d8ad-7924-900a-c37294d831fc€49.00€0.67matched
19capture01a15500-df04-7ec2-b90d-b49b6a099686€9.00€0.19matched
20capture01a15500-e742-7472-b791-c9ce05204687€24.00€0.37matched
21capture01a15501-0e83-7eb7-940e-7cd0d359151a€9.00€0.19matched
22capture01a15501-11c4-7f0b-93e5-40f11601e721€15.00€0.26matched
23refund01a15501-1cf8-70bd-8906-f244fc676d88-€6.00€0.00matched
24capture01a15501-2c62-7461-84b5-0207f9efc5c9€24.00€0.37matched
25capture01a15501-4c8b-79d0-9f5c-f928c40e22f1€15.00€0.26matched
26capture01a15501-5920-76dc-a61b-74c1b1eba925€24.00€0.37matched
27capture01a15501-6a79-7a8b-80a3-308d589258f5€15.00€0.26matched
28capture01a15501-72d4-723e-853f-ca4dd30fee9d€24.00€0.37matched
29capture01a15501-7d1a-7c41-a8be-8d9cc4d8aa7d€24.00€0.37matched
30capture01a15501-8d2c-7694-8f90-4357520c398a€9.00€0.19matched
31capture01a15501-9d61-7ceb-8abe-192d7330cac4€15.00€0.26matched
32capture01a15501-e571-7231-a500-17b68174ac41€49.00€0.67matched
33refund01a15501-ec87-7d2b-92c1-263308a7193a-€5.00€0.00matched
34capture01a15501-ee92-719d-861e-d8f874b9679f€35.00€0.50matched
35capture01a15502-3866-7bf9-8bc7-f36b54d4aa20€9.00€0.19matched
36capture01a15502-5301-7961-91c4-1b7012bb3a9c€49.00€0.67matched
38capture01a15502-66d3-7277-957a-27d7f785357d€9.00€0.19matched
39capture01a15502-6c63-7a88-829b-70210b5b0dd2€24.00€0.37matched
40capture01a15502-ef30-7aad-85a0-a424fadd0cdf€15.00€0.26matched
41capture01a15503-7197-75a3-a4f3-933018c103e7€15.00€0.26matched
42capture01a15503-818b-751c-9caf-e093c2ae9760€9.00€0.19matched
43capture01a15503-9dc9-7bf8-bfe5-60b24c6e8554€9.00€0.19matched
44capture01a15503-a137-7e1d-9034-459da95160e5€15.00€0.26matched
45capture01a15503-a5bd-7a2e-8998-a3530b819d76€49.00€0.67matched
46capture01a15503-d0d4-77d3-8e53-8f741e08afb7€49.00€0.67matched
47capture01a15504-08ba-7e26-8987-ec6e23c33a7c€49.00€0.67matched
48capture01a15504-3b70-7151-a01a-20932b559e91€35.00€0.50matched
49capture01a15504-40c5-7992-af7e-6039f5049197€24.00€0.37matched
50capture01a15504-4319-76da-be14-d2259337ec6e€15.00€0.26matched
51capture01a15504-4ee7-72c5-aac2-0c904b867f8e€49.00€0.67matched
52capture01a15504-6a82-7743-9d59-546491ec34e6€35.00€0.50matched
53capture01a15504-7598-7042-97da-06d0bfe7691e€35.00€0.50matched
54refund01a15504-7bb4-72c2-9b12-a5ecfd1242af-€18.00€0.00matched
55capture01a15504-83ce-709f-a493-9928c09566ac€35.00€0.50matched
56capture01a15504-914e-7d06-8809-51da9f1b1ae0€9.00€0.19matched
57capture01a15504-bb69-7341-894b-c3cec7d69e0b€24.00€0.37matched
58capture01a15504-c8f0-77ab-990b-47b2a1319d46€35.00€0.50matched
59capture01a15504-f144-7a88-8eec-ff4f4c563c84€15.00€0.26matched
60capture01a15505-1172-71a1-90f5-bcfa7023ddd4€15.00€0.26matched
61capture01a15505-2251-7ab3-9454-d5370d713d54€15.00€0.26matched
62capture01a15505-1b87-7eda-8c40-f7a61ff7a6a0€9.00€0.19matched
63capture01a15505-2f12-70a5-a38c-2accadf52433€15.00€0.26matched
64capture01a15505-50b4-728f-b3df-45505df8f51b€49.00€0.67matched
65capture01a15505-684f-7a3e-ab8c-9ef64d939a8b€24.00€0.37matched
66capture01a15505-a59e-7c95-9093-66804478c0e2€15.00€0.26matched
67capture01a15505-ce20-7fea-9558-d0c4d697c629€15.00€0.26matched
68capture01a15505-dded-7ffe-ba54-db59377fc102€49.00€0.67matched
69capture01a15505-f5d4-792a-a291-fa4bf9d91aca€15.00€0.26matched
70capture01a15505-f8e5-7a8a-a852-2898b8cbe686€9.00€0.19matched
71capture01a15506-13cb-7099-bee6-4e30d687cb6c€15.00€0.26matched
72capture01a15506-24f1-779c-85c7-9f18e8c7ded1€49.00€0.67matched
73capture01a15506-2632-7554-8f06-333e04f6dd58€24.00€0.37matched
74capture01a15506-2bbc-7445-b416-b0df18255ee1€35.00€0.50matched
75capture01a15506-35b5-792a-aed9-32cd3a37a00c€15.00€0.26matched
76capture01a15506-3677-7b0e-92a3-02cf5148e143€49.00€0.67matched
77capture01a15506-3b79-7888-a20c-cc163a403901€9.00€0.19matched
78capture01a15506-3eca-71ec-b9df-2d28667418dc€15.00€0.26matched
79capture01a15506-380e-7abc-86d0-2b6003276ece€15.00€0.26matched
80capture01a15506-51ec-7d33-833c-e0a6dd1fcc08€24.00€0.37matched
81capture01a15506-676b-7a76-9536-06e5747f3675€49.00€0.67matched
82capture01a15506-6aa5-76ea-9151-689f61cc508e€35.00€0.50matched
83capture01a15506-7cf3-78de-8692-417f403dee82€35.00€0.50matched
84capture01a15506-8ec7-7607-9167-44f1aff536b0€24.00€0.37matched
85capture01a15506-b143-7e14-b0ba-c5dd96bbad65€15.00€0.26matched
86capture01a15506-c495-7df7-9e43-709848f92ef6€15.00€0.26matched
87refund01a15506-cb42-797d-9039-0edf7abadce0-€19.00€0.00matched
88capture01a15506-de23-73b5-bcc3-cb8471315bb6€9.00€0.19matched
89capture01a15506-e0b0-7f51-ae2b-505f8faaf958€15.00€0.26matched
90capture01a15507-366e-73de-80d9-f92e235e6279€24.00€0.37matched
91capture01a15507-3722-7145-ad1b-d4693f8e482a€15.00€0.26matched
92capture01a15507-5608-7a76-8bfb-f1fc002ce467€24.00€0.37matched
93capture01a15507-5a54-7182-a93d-df3cf5d94c73€35.00€0.50matched
94capture01a15507-7b9e-786b-8bef-b31806e902ab€49.00€0.67matched
95capture01a15507-7f3f-744a-910a-64af6e573550€49.00€0.67matched
96capture01a15507-c2a7-7a7d-b4c5-a232158ab233€15.00€0.26matched
97capture01a15507-d7ce-76fd-8a7e-2bfd5cc3ab5b€24.00€0.37matched
98capture01a15507-f89e-715a-9390-fb3f4d84f637€35.00€0.50matched
99refund01a15508-029d-777a-9c61-2a1f40f08bfa-€7.00€0.00matched
100capture01a15508-3a49-7b22-a2af-d61a94f27fa1€9.00€0.19matched
101capture01a15508-7d11-7cdc-beb3-b748259f9e5b€15.00€0.26matched
102capture01a15508-79ae-7469-aca8-15a82dc14a40€9.00€0.19matched
103capture01a15508-8602-73ec-9066-3aa3fbbfda89€9.00€0.19matched
104capture01a15508-9357-747d-96bb-9916613210c6€49.00€0.67matched
105capture01a15508-ab3f-7952-810f-002ee77f2966€24.00€0.37matched
106capture01a15508-b4c6-7ff5-8d9b-74953c849bd0€35.00€0.50matched
107capture01a15508-b52e-7da9-be21-f2f82bc6f08d€49.00€0.67matched
108capture01a15508-be87-7bfe-be75-7aea64b0c3e2€49.00€0.67matched