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, 08:50

Gross

€2,635.00

PSP fee

€42.42

Net to the bank

€2,592.58

Settlement journal

#376530

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a5c1-20f7-74f6-99e5-0fe3c3ba6f3b is already settled by stl_EUR_2989637 line 14
  • duplicate linethe file lists it twicecapture:01a1a5c8-105a-7dfe-92df-e8d811286fca is already settled by stl_EUR_2989637 line 101
  • missing linein the books, not in the filecapture:01a1a5c9-33d1-7c49-8dc0-fd1ccf4c5d24 is in no file
  • missing linein the books, not in the filecapture:01a1a5c2-49a1-759f-a8dc-28a5fb96fda2 is in no file
LineKindReferenceGrossFeeStatus
15capture01a1a5c1-222b-7e1f-a415-22ee423eac93€24.00€0.37duplicate line
102capture01a1a5c8-1083-7cc5-9fc5-cd4d193b3934€24.00€0.37duplicate line
1capture01a1a5ba-afe4-79f1-9af8-7505710ec486€9.00€0.19matched
2capture01a1a5be-0302-74c8-8374-0418215004f3€24.00€0.37matched
3capture01a1a5c0-4d3e-7479-800c-4e6d766b0e07€15.00€0.26matched
4capture01a1a5c0-551f-7202-ba8a-0c0e09035c22€35.00€0.50matched
5capture01a1a5c0-7c57-7dc8-ade2-0c9b722ed73e€15.00€0.26matched
6capture01a1a5c0-80ef-7fa3-a942-728c10e611f1€49.00€0.67matched
7capture01a1a5c0-97ef-73e1-bab1-f655cb557db8€15.00€0.26matched
8capture01a1a5c0-97fd-797a-bb53-f784f8e8f816€49.00€0.67matched
9capture01a1a5c0-a7e6-7f31-81d3-4e8c83298d19€49.00€0.67matched
10capture01a1a5c0-d55f-72b2-82a9-0525d0899ec0€24.00€0.37matched
11capture01a1a5c0-e4d5-7fd4-bec2-109cd363cc5f€24.00€0.37matched
12capture01a1a5c0-ef54-7970-b23e-267437464676€35.00€0.50matched
13capture01a1a5c1-17e1-71e8-a803-c88e0af87ad5€49.00€0.67matched
14capture01a1a5c1-222b-7e1f-a415-22ee423eac93€24.00€0.37matched
16capture01a1a5c1-308d-715d-97de-a15ad6b33918€49.00€0.67matched
17capture01a1a5c1-3e01-75ca-bcaf-2b57c2706eb4€9.00€0.19matched
18capture01a1a5c1-6a80-7333-8cf7-3f6fb5f548f4€35.00€0.50matched
19capture01a1a5c1-8cac-7d60-99b2-f7aef3faa501€15.00€0.26matched
20capture01a1a5c1-b3b2-7138-a395-567a786c9cae€24.00€0.37matched
21capture01a1a5c1-cd80-764e-8ede-a4f2a1fe1ee5€24.00€0.37matched
22capture01a1a5c1-d23f-7913-bc41-0f06a5ae2e05€9.00€0.19matched
23capture01a1a5c1-d6c8-75c1-b1d7-f44b243b615e€15.00€0.26matched
24capture01a1a5c2-0dd1-7fb4-95f3-e3b687c44a34€49.00€0.67matched
25capture01a1a5c2-2a3e-7262-8d47-959e40a65f43€49.00€0.67matched
26capture01a1a5c2-369c-7f93-bd00-0d90483ec1ed€15.00€0.26matched
27capture01a1a5c2-3cf3-7d92-aa18-b2951ac0e978€9.00€0.19matched
28capture01a1a5c2-41f1-78c3-97bb-f39ac73439c3€24.00€0.37matched
29capture01a1a5c2-633d-772c-a536-5c554fc499ce€35.00€0.50matched
30refund01a1a5c2-6580-7584-b7a3-cd1eaf595b68-€10.00€0.00matched
31refund01a1a5c2-8166-7b55-9d25-63cd19ec6ceb-€3.00€0.00matched
32capture01a1a5c2-8422-70e8-8300-d5408dc2bfc6€24.00€0.37matched
33capture01a1a5c2-c972-7e94-822e-f475aac9a465€9.00€0.19matched
34capture01a1a5c2-d888-7ef9-9c6e-0301ab2e20de€24.00€0.37matched
35capture01a1a5c3-0545-7971-9091-ae5c175a41ba€9.00€0.19matched
36capture01a1a5c3-16e9-7748-b2e6-a702b7b4942c€24.00€0.37matched
37capture01a1a5c3-24b3-7507-8996-a181d2e19155€15.00€0.26matched
38capture01a1a5c3-3d08-7440-94bf-9e5ed6ed82fa€35.00€0.50matched
39capture01a1a5c3-5636-7f32-8b34-d4b3a394f6a8€24.00€0.37matched
40capture01a1a5c3-6944-755a-a4cc-1e668af52803€15.00€0.26matched
41capture01a1a5c3-9ff8-783d-ba3d-473e63207dce€35.00€0.50matched
42capture01a1a5c3-ac3e-7335-afd8-bd07989727c7€49.00€0.67matched
43capture01a1a5c3-beed-7a07-aac2-5373ecf26261€35.00€0.50matched
44capture01a1a5c3-c4bb-7c3f-b76a-28e7e31c8bc1€24.00€0.37matched
45capture01a1a5c3-c687-794d-97aa-eade61bf6bb0€24.00€0.37matched
46capture01a1a5c3-df9e-7d20-90fd-2ddb35423120€15.00€0.26matched
47capture01a1a5c3-f3fc-76c7-89f5-45e31ca137bb€24.00€0.37matched
48capture01a1a5c4-0652-7fdf-b302-3356f022d2ea€15.00€0.26matched
49capture01a1a5c4-14ee-7cfc-bd1e-1f947db80a37€24.00€0.37matched
50capture01a1a5c4-1730-70f0-a431-7354ba359bfd€15.00€0.26matched
51capture01a1a5c4-3bb7-723c-aa26-9107459be2fa€35.00€0.50matched
52capture01a1a5c4-45f1-7e46-8ba4-e2c12ca4683c€49.00€0.67matched
53capture01a1a5c4-5272-7845-bc03-0cb78dc16536€24.00€0.37matched
54capture01a1a5c4-5314-7be8-a70e-77a070a5d288€9.00€0.19matched
55capture01a1a5c4-678c-7f70-ac77-bdc5c85267e5€24.00€0.37matched
56capture01a1a5c4-67a6-72d0-8c3c-df736f3d96e0€15.00€0.26matched
57capture01a1a5c4-69ab-7eca-8576-81deec6bc8f3€49.00€0.67matched
58capture01a1a5c4-7997-7cf2-93fe-792e58397319€35.00€0.50matched
59refund01a1a5c4-865f-77f8-9fe7-a0b7f5b4c5ef-€22.00€0.00matched
60refund01a1a5c4-a000-7a11-ba34-a81835ef5ea7-€26.00€0.00matched
61refund01a1a5c4-b868-7901-974a-ffcfee42ad3d-€22.00€0.00matched
62capture01a1a5c4-bcaf-7834-8c46-ba7152fb0e44€24.00€0.37matched
63capture01a1a5c4-e9bd-793b-8e95-c1820540ff5d€49.00€0.67matched
64capture01a1a5c5-05a3-7560-b127-37448d174cd3€15.00€0.26matched
65capture01a1a5c5-0601-779c-9fcf-617f8556c6ba€15.00€0.26matched
66capture01a1a5c5-1017-7bfd-a041-f77a0e54f055€35.00€0.50matched
67capture01a1a5c5-19a3-7f83-b5e9-695e78ae5a6a€35.00€0.50matched
68refund01a1a5c5-487a-7b32-b2b1-019313f2a8d8-€25.00€0.00matched
69capture01a1a5c5-4a5a-79e1-b299-4940bc46bbcb€15.00€0.26matched
70capture01a1a5c5-503b-70b6-9b86-cfe5d5785d43€35.00€0.50matched
71capture01a1a5c5-581d-71bd-b930-c604a2ea831d€15.00€0.26matched
72capture01a1a5c5-7709-79e1-8cd0-64d3ee6c834c€15.00€0.26matched
73capture01a1a5c5-84ce-75bb-b7a0-ac68303d5ab1€15.00€0.26matched
74capture01a1a5c5-9333-7132-a300-31d56544f233€24.00€0.37matched
75capture01a1a5c5-b6f3-7b9d-81d1-3b853607be80€35.00€0.50matched
76capture01a1a5c5-e102-7e60-a309-e6bc6ac1eb33€9.00€0.19matched
77capture01a1a5c5-f808-762e-b401-91484f47011e€15.00€0.26matched
78capture01a1a5c6-02ab-7172-8ceb-eebe49b170fb€49.00€0.67matched
79capture01a1a5c6-52a2-755a-874e-aef7218665c3€49.00€0.67matched
80refund01a1a5c6-5cfc-7fe7-91d2-20037bb9afde-€18.00€0.00matched
81capture01a1a5c6-8133-74bd-9875-daea4dabd524€9.00€0.19matched
82capture01a1a5c6-9e94-7da6-8e50-ce7387aa1c3a€9.00€0.19matched
83capture01a1a5c6-a850-7397-96e9-2c165ace1b2c€15.00€0.26matched
84refund01a1a5c6-b43d-7147-adfc-67899032fe72-€30.00€0.00matched
85capture01a1a5c6-d4a5-76e1-9c6c-513bc2076774€49.00€0.67matched
86capture01a1a5c6-dbe0-792f-92eb-52ba8f6d4b63€24.00€0.37matched
87capture01a1a5c6-f366-7d2b-90fa-588f7c44b2ea€35.00€0.50matched
88capture01a1a5c7-1068-78e5-ad0a-ee67b22aaaa7€24.00€0.37matched
89capture01a1a5c7-1476-70a7-a25f-928da194edbb€49.00€0.67matched
90capture01a1a5c7-2b6e-79d4-98a5-ed6d6a639f63€35.00€0.50matched
91capture01a1a5c7-4a17-7e34-a234-d4dd6b53966f€9.00€0.19matched
92capture01a1a5c7-87fd-71ad-846c-84486e060fcc€15.00€0.26matched
93capture01a1a5c7-9e6b-76fc-9329-87013bbf7977€24.00€0.37matched
94capture01a1a5c7-a6d9-75c1-856b-807320c49d2d€35.00€0.50matched
95capture01a1a5c7-b473-7c2d-b828-fa0f190e1371€24.00€0.37matched
96capture01a1a5c7-c795-7a01-a268-e575fd0a3193€15.00€0.26matched
97capture01a1a5c7-d108-7099-9be1-29fe60aae039€9.00€0.19matched
98capture01a1a5c7-e72a-78c9-a51f-2acdf19c6c78€9.00€0.19matched
99capture01a1a5c7-fabb-7fd4-8906-1d67a070c186€15.00€0.26matched
100capture01a1a5c8-0d78-75d2-b7ca-ba5e00e8ec09€35.00€0.50matched
101capture01a1a5c8-1083-7cc5-9fc5-cd4d193b3934€24.00€0.37matched
103capture01a1a5c8-25db-7348-a967-b1f22e77880e€9.00€0.19matched
104capture01a1a5c8-484e-7f84-9d4c-cb264dd37c9b€24.00€0.37matched
105capture01a1a5c8-4e09-7559-9642-7023717fe7c4€15.00€0.26matched
106capture01a1a5c8-5311-7e29-93dd-e6bc192cca2c€15.00€0.26matched
107capture01a1a5c8-53ad-75c3-be7d-8082651e241d€15.00€0.26matched
108capture01a1a5c8-6268-7dd5-91d3-d07af4e39f00€35.00€0.50matched
109refund01a1a5c8-62aa-7238-a91c-7b131c2342d8-€7.00€0.00matched
110capture01a1a5c8-771d-7a26-924e-a5e414a4e468€49.00€0.67matched
111capture01a1a5c8-bb9a-714e-9deb-1cdc5c62661a€15.00€0.26matched
112capture01a1a5c8-d0cc-725c-a17b-f00b5875d174€24.00€0.37matched
113capture01a1a5c8-f53a-7721-8cc9-a256127b65fc€49.00€0.67matched
114capture01a1a5c9-0134-797b-ba41-eb7e15a4c07b€49.00€0.67matched
115capture01a1a5c9-2f90-7c54-845c-5c25cf11222a€9.00€0.19matched
116capture01a1a5c9-30ee-7f85-8d18-439f38c8c6df€35.00€0.50matched
117capture01a1a5c9-36cf-7bfe-b813-c98df27ec0a9€24.00€0.37matched
118capture01a1a5c9-43a6-709a-98e9-a29275bc90a0€15.00€0.26matched