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

2 Nov, 05:30

Gross

€3,032.00

PSP fee

€46.91

Net to the bank

€2,985.09

Settlement journal

#337496

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19abd-ffbd-7040-aff0-3b515364f55a is already settled by stl_EUR_2989329 line 36
LineKindReferenceGrossFeeStatus
37capture01a19abe-0081-7fab-b7a0-871baf7de72c€49.00€0.67duplicate line
1capture01a19ab8-02b6-724e-a0da-6ab31e548202€49.00€0.67matched
2capture01a19ab8-b814-7152-8332-cbf7abd39b25€35.00€0.50matched
3refund01a19ab9-87fd-7a01-a731-b899a8acd9ff-€14.00€0.00matched
4capture01a19abc-7e55-7092-bd07-0da5a3800092€15.00€0.26matched
5capture01a19abc-868e-7946-9254-2dd07397c581€9.00€0.19matched
6capture01a19abc-9800-7a41-b0d3-803c5ae3e853€35.00€0.50matched
7capture01a19abc-9bdc-7405-9754-a8445d8717ae€49.00€0.67matched
8capture01a19abc-9554-700e-9d3e-d7b0e7207de5€9.00€0.19matched
9refund01a19abc-afb7-7b80-a63e-09dd3bbeb111-€13.00€0.00matched
10capture01a19abc-cf60-713a-bd80-02022f0e3f67€24.00€0.37matched
11capture01a19abc-e0f4-7fbc-96a9-c35e33bcb126€49.00€0.67matched
12capture01a19abc-f313-7469-bb3a-82accdad6186€9.00€0.19matched
13capture01a19abc-ffd8-73e3-b4a0-c1d36b6cdfc2€24.00€0.37matched
14capture01a19abd-0ce5-73d8-b213-2257ecc8719e€24.00€0.37matched
15capture01a19abd-2bc3-75fd-a2cf-9c9d4dc69516€15.00€0.26matched
16capture01a19abd-3911-77e5-8c66-7e5b78e477e7€35.00€0.50matched
17capture01a19abd-4365-78af-ba07-0edd53bea17d€35.00€0.50matched
18capture01a19abd-4411-7b72-b2fa-ea07034bbbd2€9.00€0.19matched
19capture01a19abd-58ef-7eb3-a523-354c3af5f272€49.00€0.67matched
20capture01a19abd-7ddd-7236-830d-8c965add902e€49.00€0.67matched
21capture01a19abd-8660-7ab3-be16-6ab99a75614b€35.00€0.50matched
22capture01a19abd-8a12-7dad-9349-408f064d5b32€35.00€0.50matched
23capture01a19abd-935c-7a37-b5b7-1bf2ba99132b€9.00€0.19matched
24capture01a19abd-9a7e-72e7-ad16-0f8bcb2c3cf7€9.00€0.19matched
25capture01a19abd-9d38-7735-ac15-c25f78081e51€49.00€0.67matched
26capture01a19abd-b192-7f2e-a5b2-71cce8747a22€24.00€0.37matched
27capture01a19abd-b7af-7981-999f-c2b35d68975c€49.00€0.67matched
28capture01a19abd-d84a-70d8-be5b-8c12b39f380b€15.00€0.26matched
29capture01a19abd-e2e0-7faa-9c37-a296ff9bfb2d€24.00€0.37matched
30capture01a19abd-e923-7990-a82e-6d968bc005cc€35.00€0.50matched
31capture01a19abd-ec66-783e-beef-4911ab393cff€24.00€0.37matched
32capture01a19abd-ee9b-7d65-8558-f84cab5ab920€9.00€0.19matched
33capture01a19abd-f2f1-730d-a3f8-f8e94ec24a56€9.00€0.19matched
34capture01a19abd-f53e-7403-8fc7-dcf9e81d2435€9.00€0.19matched
35capture01a19abd-fe5b-7cd6-a06a-46be3e019e92€49.00€0.67matched
36capture01a19abe-0081-7fab-b7a0-871baf7de72c€49.00€0.67matched
38capture01a19abe-0fdf-7153-9318-bf42323c185c€35.00€0.50matched
39capture01a19abe-16ae-7cf7-a35b-d7f2b40c0f6b€24.00€0.37matched
40capture01a19abe-2926-7844-ac4a-33f685c13859€9.00€0.19matched
41capture01a19abe-5127-7921-bf2b-abd1c85557bb€15.00€0.26matched
42capture01a19abe-59b5-71d5-8799-094be35d7436€9.00€0.19matched
43capture01a19abe-6ec0-7978-af70-929909da1a45€35.00€0.50matched
44capture01a19abe-7192-7eea-89fe-2f066de91ca1€35.00€0.50matched
45refund01a19abe-753e-7e72-b029-a81589a5936b-€15.00€0.00matched
46refund01a19abe-90c3-7337-9341-159b25b06e58-€11.00€0.00matched
47capture01a19abe-a5f6-77e7-bb62-44025c20d50f€9.00€0.19matched
48capture01a19abe-aa3f-77a3-8a27-8a0e6e21f17f€49.00€0.67matched
49capture01a19abe-f1dd-7161-ba69-08527c4058d4€49.00€0.67matched
50capture01a19abf-068e-71a3-adcf-6f44909c31fd€35.00€0.50matched
51capture01a19abf-2c69-789c-9318-7a284677dee8€15.00€0.26matched
52capture01a19abf-35e2-7c9b-96f3-b4f9f856c86f€15.00€0.26matched
53capture01a19abf-5c01-785a-bfda-3a1b7942ce25€35.00€0.50matched
54capture01a19abf-623c-7842-8197-28f8f50c280e€35.00€0.50matched
55capture01a19abf-685f-7186-b8d9-7ed8b4525d94€15.00€0.26matched
56capture01a19abf-bb82-7f0b-b017-29a8b749a750€35.00€0.50matched
57capture01a19abf-c2f9-7c43-9c1c-28d2ea56e156€15.00€0.26matched
58capture01a19abf-e2ff-73d8-a140-601495298e7f€35.00€0.50matched
59capture01a19abf-e4a7-7a07-a5f0-f1887c1c40d7€9.00€0.19matched
60capture01a19ac0-0acc-7516-8e80-ad43b6b8aca2€49.00€0.67matched
61capture01a19ac0-1155-794c-a233-a6ee55fb76ae€49.00€0.67matched
62capture01a19ac0-1bd1-7f4c-a988-5f7d127b9415€49.00€0.67matched
63capture01a19ac0-31d9-71a5-86d1-bd33bc60fe22€35.00€0.50matched
64refund01a19ac0-4b48-780a-82b5-fd9a4464dc81-€4.00€0.00matched
65capture01a19ac0-57e4-73ff-b772-17d9ebad6707€9.00€0.19matched
66capture01a19ac0-e9ba-7551-a305-4ea745e49e73€9.00€0.19matched
67capture01a19ac1-1cd5-70c4-bc8b-b59224451d21€35.00€0.50matched
68capture01a19ac1-3bde-7fae-a812-9334c2932859€24.00€0.37matched
69capture01a19ac1-5f6e-7883-820d-718bae21a80f€24.00€0.37matched
70capture01a19ac1-6de8-73eb-9f17-3ff07b0ec7e0€9.00€0.19matched
71capture01a19ac1-b489-7559-ad29-4509f87e1190€35.00€0.50matched
72capture01a19ac1-c587-71d4-be73-0c2bb9b9cdd0€49.00€0.67matched
73capture01a19ac1-ecab-7cac-b74c-854d85b4c2b5€24.00€0.37matched
74capture01a19ac2-0787-7efd-9e8b-b7d784df2eb8€9.00€0.19matched
75capture01a19ac2-3311-7239-9688-a25f03063801€49.00€0.67matched
76refund01a19ac2-3bae-7331-bd37-9b9a16ebe24b-€35.00€0.00matched
77capture01a19ac2-4489-7ebe-8dab-499c3eaae8d6€24.00€0.37matched
78capture01a19ac2-45cd-720f-9a65-ed37a6a99413€15.00€0.26matched
79capture01a19ac2-48e1-7d6a-aae3-be8922f8cbc8€15.00€0.26matched
80capture01a19ac2-4c91-7bbb-925e-107a953ab3b5€49.00€0.67matched
81capture01a19ac2-7200-7d72-8308-c9a2f1d802d2€15.00€0.26matched
82capture01a19ac2-77e2-7242-8d40-df20fc26cd51€49.00€0.67matched
83capture01a19ac2-7a8d-7412-a4fc-5c11e84a421d€15.00€0.26matched
84capture01a19ac2-85a0-7075-8d2b-f0ef9ebd6590€24.00€0.37matched
85capture01a19ac2-a1c9-7306-840f-c81842fd8699€35.00€0.50matched
86capture01a19ac2-a1d2-789f-91a9-b461eb28c59a€9.00€0.19matched
87capture01a19ac2-e0c7-78bc-9508-eac96c027a94€24.00€0.37matched
88capture01a19ac2-eb04-7789-b843-c5e88f433ab8€9.00€0.19matched
89capture01a19ac2-ee45-75b3-984f-f87c36969455€24.00€0.37matched
90capture01a19ac2-f7b7-7133-959c-845635a453a2€15.00€0.26matched
91capture01a19ac2-fabf-7150-9a6d-48fcc90f05d0€49.00€0.67matched
92capture01a19ac3-519d-79ee-9583-4cd96fd435e2€15.00€0.26matched
93capture01a19ac3-656c-7498-83ae-ef4050363c5c€24.00€0.37matched
94capture01a19ac3-8423-774d-8975-7a62c53c2bc0€49.00€0.67matched
95capture01a19ac3-9f0a-7024-993a-a310aa140c89€15.00€0.26matched
96capture01a19ac3-c3e0-7c5e-927a-3db772bc0661€35.00€0.50matched
97capture01a19ac3-e4ac-7433-95f9-c23e3733045f€35.00€0.50matched
98capture01a19ac3-f731-7f34-b4b6-07f561692fb4€35.00€0.50matched
99capture01a19ac4-0c0e-781c-8798-08548f7a5ae5€24.00€0.37matched
100capture01a19ac4-1bc1-7dd3-8638-53886d67fb4a€35.00€0.50matched
101capture01a19ac4-2435-7248-a775-ae1bc90f7bc7€24.00€0.37matched
102capture01a19ac4-2647-7943-839d-addd8aecebe6€24.00€0.37matched
103capture01a19ac4-97ac-71aa-9598-3c74e1c5ad48€9.00€0.19matched
104capture01a19ac4-b577-77e7-8338-7c56aa21bc28€35.00€0.50matched
105capture01a19ac4-c197-768e-8fde-2e031d55d1fd€24.00€0.37matched
106capture01a19ac4-c1f2-7b87-8ab5-cbdf11014eba€49.00€0.67matched
107capture01a19ac4-c701-7e71-a279-9bb760cfe98e€15.00€0.26matched
108capture01a19ac4-d9b2-73b7-b256-c0dc428c30b4€9.00€0.19matched
109capture01a19ac4-e27f-7c3e-b920-be45e11371c8€24.00€0.37matched
110capture01a19ac4-e2c1-7da1-9d8c-6e058ca7c4c8€49.00€0.67matched
111capture01a19ac4-fb04-77be-86f7-44a7a67c7d2a€15.00€0.26matched
112capture01a19ac4-fbe9-7477-b87c-0e5125bd66c4€49.00€0.67matched
113capture01a19ac5-02dd-73fe-a6a5-08f3902606b7€24.00€0.37matched
114capture01a19ac5-0f66-70e4-b6b7-a4192efd220b€15.00€0.26matched
115capture01a19ac5-1cae-7f43-8fcd-823410193940€15.00€0.26matched
116capture01a19ac5-350a-70db-ac98-430a99fce841€9.00€0.19matched
117capture01a19ac5-381a-71ef-87a9-745370decce4€15.00€0.26matched
118capture01a19ac5-45a4-7bd3-a32b-27966ec9f78b€49.00€0.67matched
119capture01a19ac5-4755-75dd-94c6-177a8d1791d1€9.00€0.19matched
120capture01a19ac5-58c6-7c6a-8a34-e825a575356c€9.00€0.19matched
121capture01a19ac5-624e-74a8-8aea-875b1a6475c9€24.00€0.37matched
122capture01a19ac5-6ca1-7efe-8c1b-5417eb18f5c2€15.00€0.26matched