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, 01:20

Gross

€2,500.00

PSP fee

€40.24

Net to the bank

€2,459.76

Settlement journal

#370859

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a429-37e8-7a31-ad2c-aa2b727b46aa is already settled by stl_EUR_2989592 line 47
  • fee differencethe fee is not the contract feethe fee is 31, the contract says 26
LineKindReferenceGrossFeeStatus
48capture01a1a429-3844-71c5-a64f-66a99c181f84€9.00€0.19duplicate line
111capture01a1a42d-5d67-7dbc-bd67-d8d0ebad1380€15.00€0.31fee difference
1refund01a1a421-5c3a-734a-9e16-4b96c9c115e5-€23.00€0.00matched
2capture01a1a422-dfa5-7ddc-a910-bb4ec99734ed€24.00€0.37matched
3capture01a1a424-6720-7d26-8eb4-9702dcbd78fe€24.00€0.37matched
4capture01a1a424-6dbf-7e1c-8713-f8e6444c25e3€9.00€0.19matched
5capture01a1a424-fd52-78c7-9702-5a5eb4fec4ba€35.00€0.50matched
6capture01a1a425-28f5-7ebf-b88f-10303c13924b€15.00€0.26matched
7capture01a1a425-52bb-79f3-8a3c-5f47ad5ce9ac€35.00€0.50matched
8capture01a1a425-690e-73ea-ba73-f5a15393aa99€49.00€0.67matched
9capture01a1a425-6c48-7700-86f5-131ee2bead6e€15.00€0.26matched
10capture01a1a425-7629-7a69-aaf3-079526a277a2€35.00€0.50matched
11capture01a1a425-c0e5-70e7-b8ea-93b18e883649€49.00€0.67matched
12capture01a1a425-ec1c-7a33-ba2a-25f84e74580f€15.00€0.26matched
13capture01a1a425-f34d-7348-a952-e088a75a5f30€24.00€0.37matched
14capture01a1a426-28a6-7fd3-8f8e-bd360a987a75€9.00€0.19matched
15capture01a1a426-3d48-7d56-be19-7a9d94f1924b€24.00€0.37matched
16capture01a1a426-54f7-7878-9dc4-820401948c2d€15.00€0.26matched
17capture01a1a426-6bb6-76a3-a4fe-9412203436c7€49.00€0.67matched
18capture01a1a426-8f8d-793c-a838-97b0ca94782a€24.00€0.37matched
19capture01a1a427-0aa2-796c-810d-e4a37008e9c1€15.00€0.26matched
20capture01a1a427-25ba-7651-9ba8-75464513dcf0€35.00€0.50matched
21capture01a1a427-4698-7fbb-98f6-d7662e377179€9.00€0.19matched
22capture01a1a427-4c3d-7f4a-90cb-d75f06dec20c€15.00€0.26matched
23capture01a1a427-5312-71b7-ae1d-d17f6aecd36f€49.00€0.67matched
24capture01a1a427-5390-734a-ac61-b0e6dd29ad70€15.00€0.26matched
25capture01a1a427-652f-79da-ba14-6d13de8eca80€35.00€0.50matched
26capture01a1a427-7a11-78ef-9ed9-fff79e7807fc€49.00€0.67matched
27capture01a1a427-8379-7e49-ad6c-81f388cb09a0€49.00€0.67matched
28capture01a1a427-8c34-793a-94f3-0513fcd5643a€35.00€0.50matched
29capture01a1a427-8eaa-7513-9eae-c88b9615d4b9€49.00€0.67matched
30capture01a1a427-946a-708b-89ab-b9c5e9ce7314€9.00€0.19matched
31capture01a1a427-beba-738c-82cf-75151c5fd63f€35.00€0.50matched
32capture01a1a427-cf0c-79df-abcb-31d2f7a6f7e9€49.00€0.67matched
33capture01a1a427-e215-7fde-a4d1-4ee7f29a1f16€15.00€0.26matched
34capture01a1a427-e40e-7f02-b2ec-1af07e54b8ac€24.00€0.37matched
35capture01a1a428-2400-7cfa-b0b8-8a434adf49a1€24.00€0.37matched
36capture01a1a428-3a05-7349-8888-7fc2da6d62ef€9.00€0.19matched
37capture01a1a428-43b3-7968-82c7-7d5dbd285752€15.00€0.26matched
38capture01a1a428-5aef-78a0-bd3b-4239c70f7ab9€15.00€0.26matched
39capture01a1a428-86ba-711a-89b4-37220e453794€49.00€0.67matched
40capture01a1a428-9429-7ab4-9ea8-ae1379e9cae7€9.00€0.19matched
41capture01a1a428-a195-79ea-9af7-26eb478699c1€35.00€0.50matched
42refund01a1a428-b8d7-76ce-ae95-ae575f77ee95-€38.00€0.00matched
43capture01a1a428-ef54-7c94-bac9-a5cedf6eb0d1€24.00€0.37matched
44capture01a1a428-f510-705a-aa48-37b2395c1112€15.00€0.26matched
45capture01a1a429-093c-73be-9690-f86ae1c91ed2€24.00€0.37matched
46refund01a1a429-2261-7f53-bb66-50586b280116-€24.00€0.00matched
47capture01a1a429-3844-71c5-a64f-66a99c181f84€9.00€0.19matched
49capture01a1a429-3b12-7307-a53d-ed8bbbf3914d€15.00€0.26matched
50capture01a1a429-3e4e-721a-ac36-a2042fd2cce0€15.00€0.26matched
51capture01a1a429-5544-736f-a378-c1f68f674a20€15.00€0.26matched
52capture01a1a429-56b1-75db-ade1-ea390aa1b3c0€49.00€0.67matched
53capture01a1a429-770a-7a37-84ea-93cfe7f6e7e2€15.00€0.26matched
54capture01a1a429-8046-7e74-9e0d-bb05f2f749de€24.00€0.37matched
55capture01a1a429-8968-7432-97fb-ae5e1bddffb5€9.00€0.19matched
56capture01a1a429-9baa-7bb9-8788-30d314d8d2fb€49.00€0.67matched
57capture01a1a429-d20f-79b4-a858-ce03fb181028€35.00€0.50matched
58capture01a1a429-e22e-710e-a2af-7d7bca285823€9.00€0.19matched
59capture01a1a429-e255-7690-96e8-a349f8504d3a€15.00€0.26matched
60capture01a1a429-f670-7e3e-8bc9-ec5a2f72a865€15.00€0.26matched
61capture01a1a42a-10a5-70cf-ba85-97ddd23c09c4€9.00€0.19matched
62capture01a1a42a-45d7-7eb3-9511-5bd14ba740a8€9.00€0.19matched
63capture01a1a42a-5ea3-764f-b9d2-c793e792421c€35.00€0.50matched
64capture01a1a42a-76f1-722c-8ed2-cfb8c716a80d€49.00€0.67matched
65capture01a1a42a-89bf-714b-a8c5-21850cea2a9e€15.00€0.26matched
66capture01a1a42a-98ca-7c27-ac9b-8b0810245cb9€35.00€0.50matched
67capture01a1a42a-99f4-7200-bae0-3c74e10e8397€9.00€0.19matched
68refund01a1a42a-b285-7f00-ae69-7b7ebc48fb4a-€5.00€0.00matched
69capture01a1a42a-bf83-736f-9b19-b6d1409b3772€35.00€0.50matched
70capture01a1a42a-db9a-7e4e-ae90-75935fe6e451€35.00€0.50matched
71capture01a1a42a-de8b-7d9c-b020-9372453de1e2€9.00€0.19matched
72capture01a1a42a-e8e0-709a-992f-1c1d513c6160€9.00€0.19matched
73capture01a1a42a-fffa-733a-9682-58e97dc0e1ac€35.00€0.50matched
74capture01a1a42b-0ad0-7ce1-9c16-c5cce6591e9d€35.00€0.50matched
75capture01a1a42b-1d30-7571-956e-0a1f1d17b99c€35.00€0.50matched
76capture01a1a42b-202a-7683-bcc5-c9425d832330€49.00€0.67matched
77capture01a1a42b-2518-7892-bbd0-98c2bdc98ecb€24.00€0.37matched
78capture01a1a42b-2aca-7316-84f3-820954b4200d€15.00€0.26matched
79capture01a1a42b-3ece-71f0-8f9d-719f43629e94€9.00€0.19matched
80capture01a1a42b-4557-7f7f-a9d8-a9f95312d158€49.00€0.67matched
81capture01a1a42b-51ee-7960-b98a-456457daa1f3€49.00€0.67matched
82capture01a1a42b-6117-7712-8f60-3aaa00be3236€9.00€0.19matched
83refund01a1a42b-754b-7d67-b68b-c347d1c05803-€41.00€0.00matched
84capture01a1a42b-7dbb-7115-a935-5f1db5736f87€9.00€0.19matched
85capture01a1a42b-7f42-7681-992a-40606ec58438€9.00€0.19matched
86capture01a1a42b-8103-7f5d-928c-1df0520f53b3€49.00€0.67matched
87capture01a1a42b-865b-7119-bb9b-95ae8629e18f€49.00€0.67matched
88capture01a1a42b-919b-7f58-95c2-1b0db6027517€24.00€0.37matched
89capture01a1a42b-bf41-719f-8488-2eee2cb3a9b0€9.00€0.19matched
90capture01a1a42b-c954-784b-b586-1524281d0bf9€35.00€0.50matched
91capture01a1a42b-d011-73a8-a8d0-df67cd50ff63€35.00€0.50matched
92capture01a1a42c-0206-76ba-9af3-3b65b78bce9e€15.00€0.26matched
93capture01a1a42c-0e66-7787-aaa8-521508273710€35.00€0.50matched
94capture01a1a42c-0e78-71d6-8cc4-097fd30a98d8€35.00€0.50matched
95capture01a1a42c-15bf-7069-9081-847a01d251a9€9.00€0.19matched
96refund01a1a42c-1925-7f41-904c-33e371c20e18-€10.00€0.00matched
97capture01a1a42c-2f46-73dc-94c1-1449338f5c60€9.00€0.19matched
98refund01a1a42c-4757-7638-a5fd-f66d574ffc0d-€7.00€0.00matched
99capture01a1a42c-4dd7-7e24-901a-71ff8b5ec390€9.00€0.19matched
100capture01a1a42c-7985-7935-98b4-ef924e3a410a€35.00€0.50matched
101capture01a1a42c-898f-776f-a730-878f0afca557€9.00€0.19matched
102capture01a1a42c-a15f-7784-a10b-4089d68c5926€15.00€0.26matched
103refund01a1a42c-b045-7a11-a565-dcde64c6d528-€5.00€0.00matched
104capture01a1a42c-d244-7e55-b0ce-ce9ea06304dc€49.00€0.67matched
105capture01a1a42c-e8e5-7c64-b385-f8c5a4d136d7€35.00€0.50matched
106capture01a1a42c-f164-721c-b396-87b5ff63088f€49.00€0.67matched
107capture01a1a42d-149b-7691-bdc1-a737e1261f32€24.00€0.37matched
108capture01a1a42d-227f-7e14-a4d0-446fa2e68983€35.00€0.50matched
109capture01a1a42d-32f7-7e2d-823c-a77169c63e1c€35.00€0.50matched
110capture01a1a42d-5cfe-74c1-82f7-a0fedd33fbcf€24.00€0.37matched