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

Gross

€3,132.00

PSP fee

€48.24

Net to the bank

€3,083.76

Settlement journal

#346639

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19d53-23ca-72f6-b517-6cdb3136d7f7 is already settled by stl_EUR_2989401 line 33
  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
LineKindReferenceGrossFeeStatus
3capture01a19d4f-a6f8-71dc-9e22-3e7de6eea5e9€9.00€0.21fee difference
34capture01a19d53-240a-71fc-9feb-47c7bfcb69d8€9.00€0.19duplicate line
37capture01a19d53-56a1-7c7b-84d3-8b58de2f5f9c€15.00€0.29fee difference
45capture01a19d53-b59e-76ab-935d-347e885fb111€49.00€0.72fee difference
1refund01a19d4c-aefa-7ca8-9221-e08a7c54d8cb-€7.00€0.00matched
2refund01a19d4f-9dad-74db-9eb8-fc1b476d3e0d-€20.00€0.00matched
4capture01a19d4f-c77d-7e73-9a87-08cce684b0c3€15.00€0.26matched
5capture01a19d4f-f5d9-7674-968e-5dc69dfbc8e4€9.00€0.19matched
6capture01a19d4f-ff96-7a44-b44d-f45710070dc5€15.00€0.26matched
7capture01a19d50-2e30-70fd-8684-9a0525cd8665€24.00€0.37matched
8capture01a19d50-34d0-7349-a1ff-bc22e2ceff37€49.00€0.67matched
9capture01a19d50-4810-7c2c-9d74-c29b87091375€24.00€0.37matched
10capture01a19d50-b057-72bc-9dbb-437209ed3bc2€49.00€0.67matched
11capture01a19d50-ba80-7726-8daa-1b232ccd6db7€24.00€0.37matched
12capture01a19d51-2496-7dfd-9149-30094238a0e9€9.00€0.19matched
13capture01a19d51-2a38-7572-8c08-5a737ca08908€24.00€0.37matched
14capture01a19d51-493c-763c-981b-465dee7a5deb€9.00€0.19matched
15capture01a19d51-5448-7598-9290-840e9c9be211€49.00€0.67matched
16capture01a19d51-7bb5-7e0c-bc14-0c80a79b1597€24.00€0.37matched
17capture01a19d51-7d89-71ea-b172-85821dccc524€49.00€0.67matched
18capture01a19d51-827b-7d30-b160-63784ced09e9€24.00€0.37matched
19capture01a19d51-83f3-7a92-9463-e3d3e69a2567€35.00€0.50matched
20capture01a19d51-95f4-77b8-8ef9-d2805db65998€24.00€0.37matched
21capture01a19d51-b26c-7fdf-a50a-5038088d0d58€15.00€0.26matched
22capture01a19d51-be99-7d4e-84a5-6c19334c99a9€24.00€0.37matched
23capture01a19d51-cbe9-7fad-979f-ee6c6332c8c0€15.00€0.26matched
24capture01a19d51-d19e-7eff-b773-19b5182186b7€24.00€0.37matched
25capture01a19d51-e5ed-707b-b4eb-706b2279e0e6€35.00€0.50matched
26capture01a19d51-ec30-7ee6-b4b9-c380a38924c8€15.00€0.26matched
27capture01a19d52-0348-793b-b142-6bd151c25547€35.00€0.50matched
28capture01a19d52-2dca-74ea-976d-7dd7021b7fa9€49.00€0.67matched
29capture01a19d52-baf8-701a-855d-e39dde80f2ef€15.00€0.26matched
30capture01a19d52-bf4a-7cff-a57d-0297f3bd5714€24.00€0.37matched
31capture01a19d52-e5b5-7196-8b06-253b1e17affb€49.00€0.67matched
32capture01a19d53-04b7-72aa-8e94-0d0869a13e1b€9.00€0.19matched
33capture01a19d53-240a-71fc-9feb-47c7bfcb69d8€9.00€0.19matched
35capture01a19d53-294d-7616-aaa3-eff3ba43ab9a€24.00€0.37matched
36capture01a19d53-44fe-71b7-9088-f5bd75e8b2c5€15.00€0.26matched
38capture01a19d53-6199-7800-92a4-ae2562eda881€15.00€0.26matched
39capture01a19d53-6323-7106-b34d-f0c240945e32€24.00€0.37matched
40capture01a19d53-6fc0-7d93-af6a-4d44d74392fc€15.00€0.26matched
41capture01a19d53-77e5-754c-b5f9-efd4a7557bef€49.00€0.67matched
42capture01a19d53-879c-76d0-9702-cbad59e1b9b2€9.00€0.19matched
43capture01a19d53-962a-745f-a5f7-b33db839c78b€15.00€0.26matched
44capture01a19d53-b375-7c4d-9ae1-0eab92795e1d€24.00€0.37matched
46capture01a19d53-bbe8-7a64-8d5f-3aba45ead12d€9.00€0.19matched
47capture01a19d53-ca61-7f77-acb8-eebed2365d5e€24.00€0.37matched
48capture01a19d53-dabe-7994-a7ec-f5d0f293ad8f€35.00€0.50matched
49capture01a19d53-e15b-71c0-8853-8aa98e52125b€35.00€0.50matched
50capture01a19d53-ee9a-7a9e-be78-7a1a29b1c066€49.00€0.67matched
51capture01a19d53-f54e-7295-bce0-7a9a21f358fb€24.00€0.37matched
52capture01a19d54-076a-71f1-85b3-867ec50aa5a3€15.00€0.26matched
53capture01a19d54-1172-76b8-abfb-d8078f12051d€35.00€0.50matched
54capture01a19d54-2d86-7152-85c0-91efc90a3cb9€15.00€0.26matched
55capture01a19d54-6149-7913-8161-7079f908d148€35.00€0.50matched
56capture01a19d54-6267-7fdc-9ebd-eee200ee2025€9.00€0.19matched
57capture01a19d54-90ce-759d-85df-39ef19961975€24.00€0.37matched
58capture01a19d54-a050-76e3-9364-987b3c747e3d€24.00€0.37matched
59capture01a19d54-a513-735a-b5cd-6e1d50f33011€24.00€0.37matched
60capture01a19d54-a83d-7405-8173-a25e548067db€15.00€0.26matched
61capture01a19d54-c391-7f57-b384-4250ab855fd1€49.00€0.67matched
62capture01a19d54-c6be-7197-9bb5-850a06990d54€9.00€0.19matched
63capture01a19d54-d9bc-72b6-8861-3b39e612a127€35.00€0.50matched
64capture01a19d54-db0d-76ce-8ba0-43fbeb7bebf4€24.00€0.37matched
65capture01a19d54-df8b-7313-af05-a2e83b326d0c€24.00€0.37matched
66capture01a19d55-02b6-75b6-9b9f-fe24e5d2a0d9€15.00€0.26matched
67capture01a19d55-2a73-75fc-94be-57f5be08dc74€35.00€0.50matched
68capture01a19d55-5a62-7e4a-a936-301ff7554995€49.00€0.67matched
69capture01a19d55-5b86-7be6-93b0-a8e7a8a2bf24€49.00€0.67matched
70capture01a19d55-5e2b-7a7f-948c-250de5a53ebf€24.00€0.37matched
71capture01a19d55-6ed1-75b6-9c7c-f320ff29cc41€9.00€0.19matched
72capture01a19d55-8213-7e41-91c3-7d7493d3f00a€49.00€0.67matched
73capture01a19d55-985f-7d2b-acac-93e33bb5d88e€24.00€0.37matched
74capture01a19d55-a9d2-76de-9f32-07d1da4d5e3f€15.00€0.26matched
75capture01a19d55-ac4f-735e-bbdd-09b9deedb9d5€35.00€0.50matched
76capture01a19d55-c4d2-7014-9ec6-69b061a785a1€35.00€0.50matched
77capture01a19d55-ef86-74a8-957a-9aecfc6f0ff8€49.00€0.67matched
78capture01a19d55-f170-7992-8e9a-2ecf9457b199€49.00€0.67matched
79capture01a19d56-05ad-77e3-91b5-e0aa2fee61c0€9.00€0.19matched
80capture01a19d56-0a3f-753d-992c-8721109b5e58€9.00€0.19matched
81capture01a19d56-1150-7d19-a267-52f248b672e7€49.00€0.67matched
82capture01a19d56-1299-77a1-aa2d-354b3ff5b9ad€49.00€0.67matched
83capture01a19d56-1fbd-7c32-a707-03ced0097452€15.00€0.26matched
84capture01a19d56-343e-70b8-8743-4fba52f0c730€15.00€0.26matched
85capture01a19d56-4478-774b-a763-5065bcc5bb65€15.00€0.26matched
86capture01a19d56-45cf-732f-be07-20688b54d5d9€15.00€0.26matched
87capture01a19d56-4ce9-7297-ac8a-9818a76d1332€35.00€0.50matched
88capture01a19d56-590f-701e-bec1-c9ff8a14aceb€24.00€0.37matched
89capture01a19d56-5c9d-7177-8414-1420b1a8143e€15.00€0.26matched
90refund01a19d56-7bcc-715f-b063-6838fe156410-€15.00€0.00matched
91capture01a19d56-7eea-7b21-83a8-3f4d1f555abc€49.00€0.67matched
92capture01a19d56-941d-7b99-88fb-70cced7a7b29€15.00€0.26matched
93capture01a19d56-b490-7d0e-bde3-89be3451142c€49.00€0.67matched
94capture01a19d56-ba9b-7d62-89e0-9bb2ed8c1f02€49.00€0.67matched
95capture01a19d56-c5d9-717e-bb3b-703fbfe5c6ce€35.00€0.50matched
96capture01a19d56-d20b-77dc-8d2a-060bfa78e52d€15.00€0.26matched
97capture01a19d56-ffca-70a5-aa69-51fdb160e32d€49.00€0.67matched
98capture01a19d57-050b-79cd-b33f-41b42f135911€35.00€0.50matched
99refund01a19d57-1dbe-7f2c-8ebd-066e1a6f2cc3-€46.00€0.00matched
100capture01a19d57-2260-7020-94aa-bffa84d03a94€35.00€0.50matched
101capture01a19d57-2952-7e0e-aa86-3604311410f2€49.00€0.67matched
102refund01a19d57-3e59-79cf-b306-7c1ec6edf838-€7.00€0.00matched
103capture01a19d57-4514-7967-a3e8-8f834f1f75a8€35.00€0.50matched
104capture01a19d57-59e5-79e8-b865-c6a4fa05e875€15.00€0.26matched
105capture01a19d57-5dfe-7740-a856-6cf30f4bbab1€35.00€0.50matched
106capture01a19d57-5f72-782e-97ab-28a0d37e011d€35.00€0.50matched
107capture01a19d57-dd22-7578-ae1c-7626f04582ad€49.00€0.67matched
108capture01a19d57-ea20-7286-a861-15095e6ac996€35.00€0.50matched
109capture01a19d57-ed0c-7c69-bfcc-262c483e5ab8€35.00€0.50matched
110capture01a19d58-0c16-7207-a44c-e19eca174c5f€35.00€0.50matched
111capture01a19d58-17e1-739a-ab52-91ad6bf52bde€35.00€0.50matched
112capture01a19d58-3a7d-71b0-bded-f9a08a8644fa€35.00€0.50matched
113capture01a19d58-4024-78bd-8a89-db10e69ba83c€9.00€0.19matched
114capture01a19d58-41bd-7532-b3aa-4c4b9ede0b18€49.00€0.67matched
115capture01a19d58-463f-7efb-a24f-4bd907d00fab€35.00€0.50matched
116capture01a19d58-5f22-70eb-848f-9275ab33325d€49.00€0.67matched
117capture01a19d58-5fef-709f-9be9-cac68416ed16€49.00€0.67matched
118capture01a19d58-7eaa-752a-b966-11d8f17ba93d€24.00€0.37matched
119capture01a19d58-90dc-7897-9488-08e6568c3bae€9.00€0.19matched
120capture01a19d58-924a-7342-946e-91f63ff72c38€24.00€0.37matched
121capture01a19d58-9e3e-734d-9878-08e131fd444e€9.00€0.19matched