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

6 Nov, 00:50

Gross

€3,189.00

PSP fee

€52.17

Net to the bank

€3,136.83

Settlement journal

#407002

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ae5d-5723-71cf-8b71-54553f548df2 is already settled by stl_EUR_2989877 line 126
  • fee differencethe fee is not the contract feethe fee is 31, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 41, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
LineKindReferenceGrossFeeStatus
56capture01a1ae58-2118-7fcd-a350-d6c2884a2976€15.00€0.31fee difference
74capture01a1ae59-9596-7b78-ae38-8168142cc65c€9.00€0.20fee difference
82capture01a1ae5a-0d93-750c-ac25-635a17e54fa0€24.00€0.41fee difference
97capture01a1ae5b-31b3-75c1-8d3b-9a782cf66aa9€9.00€0.23fee difference
127capture01a1ae5d-573e-71e2-8478-9afd39297519€49.00€0.67duplicate line
1capture01a1ae4f-c968-79a1-b30f-6825e8a80d85€49.00€0.67matched
2capture01a1ae55-7c46-7743-b2e7-6ffabef23541€9.00€0.19matched
3capture01a1ae55-80e8-71ce-9a8b-db1456c29ab1€35.00€0.50matched
4capture01a1ae55-8f33-71ee-a7ca-7f20eed3bf78€49.00€0.67matched
5capture01a1ae55-a580-79f7-84ff-2ba2ce90e8ab€49.00€0.67matched
6capture01a1ae55-b9e0-7955-9d2b-a0d60652e1aa€15.00€0.26matched
7refund01a1ae55-c094-7ec7-b45d-21cb147ca0a8-€6.00€0.00matched
8capture01a1ae55-d761-74dd-9bd8-0a30f9cc9d33€49.00€0.67matched
9capture01a1ae55-ddab-76e6-9dae-a652135dba71€49.00€0.67matched
10capture01a1ae55-e88a-7694-aec8-33170f322f19€35.00€0.50matched
11capture01a1ae56-079c-7f94-b7e4-251dffa41586€9.00€0.19matched
12capture01a1ae56-0f31-75fc-ab16-a22c63f1148c€24.00€0.37matched
13capture01a1ae56-2fc9-7447-b388-5acb22d04e55€49.00€0.67matched
14capture01a1ae56-3263-71cb-bb00-d702a506e2b9€9.00€0.19matched
15capture01a1ae56-3a81-719d-8875-bd76405845f2€15.00€0.26matched
16capture01a1ae56-46d8-7ef4-98da-c116e9e008ab€49.00€0.67matched
17capture01a1ae56-4c02-7d22-97af-8ce3d2608fed€35.00€0.50matched
18capture01a1ae56-500a-73a2-8651-da31d6a69475€49.00€0.67matched
19capture01a1ae56-59e0-79b9-acc2-676d3954f397€35.00€0.50matched
20capture01a1ae56-5a4c-7ed7-a201-f477c6424d95€15.00€0.26matched
21refund01a1ae56-6b20-7b53-91c0-bb71dc01b744-€9.00€0.00matched
22refund01a1ae56-68dc-72a7-9ec9-50c5edab66dd-€14.00€0.00matched
23refund01a1ae56-89bf-7a5b-a86a-1e54b7f2d33b-€19.00€0.00matched
24refund01a1ae56-8bfb-7c4d-81f8-a212ee2ab817-€21.00€0.00matched
25capture01a1ae56-a47e-7fff-b4a2-2dbe908777a5€9.00€0.19matched
26refund01a1ae56-a916-73b9-89ee-19f6e21208f2-€3.00€0.00matched
27capture01a1ae56-b93c-7ca3-ac5d-a4f21b571a27€15.00€0.26matched
28capture01a1ae56-bdbf-7b1d-8275-7fc87763ce7e€9.00€0.19matched
29capture01a1ae56-bf3c-7ec8-bd57-6b8a31e67bee€15.00€0.26matched
30capture01a1ae56-c931-7f6d-8d44-f6c507625744€35.00€0.50matched
31capture01a1ae56-cffa-789d-843f-516b5723d4bf€15.00€0.26matched
32capture01a1ae56-d64f-7d0d-ac0f-4ee25725d4bd€35.00€0.50matched
33capture01a1ae56-d719-7f63-888e-36164e7f1572€35.00€0.50matched
34capture01a1ae56-dd29-7528-992e-5189c06412f7€9.00€0.19matched
35capture01a1ae56-e9da-7355-955a-8d82bdfb4fcd€15.00€0.26matched
36capture01a1ae56-ef41-7ce5-a29e-4bb614811731€15.00€0.26matched
37refund01a1ae57-05ea-7718-8ecf-4878afbd0692-€10.00€0.00matched
38refund01a1ae57-1305-7b75-9190-e5dd321cc033-€24.00€0.00matched
39capture01a1ae57-1f44-7b37-aa9b-43d2c27007b3€35.00€0.50matched
40capture01a1ae57-2138-7c17-8efa-53476639fab9€24.00€0.37matched
41capture01a1ae57-239e-7e15-83d0-d5418210d1a0€15.00€0.26matched
42capture01a1ae57-3c9c-7433-9b33-645c829bc10e€24.00€0.37matched
43capture01a1ae57-40d8-72bc-917e-ea8489f8e2f2€49.00€0.67matched
44refund01a1ae57-55b9-78f2-abfd-d0a733a3ea5f-€24.00€0.00matched
45capture01a1ae57-5755-76ad-b504-b65544f4b9ac€49.00€0.67matched
46capture01a1ae57-5866-7961-857f-10b28ec7f66e€24.00€0.37matched
47capture01a1ae57-74ad-78f2-a4bb-28ba4c264ac1€9.00€0.19matched
48capture01a1ae57-7b37-7cba-a2e4-3c0c0136671c€35.00€0.50matched
49capture01a1ae57-b3d9-7b92-a7ae-5853d970413f€35.00€0.50matched
50capture01a1ae57-bfc5-7974-b5e1-2b6851e84af0€15.00€0.26matched
51refund01a1ae57-e778-7b98-9d51-ef831419a3b0-€3.00€0.00matched
52capture01a1ae57-f393-7a7e-8a51-650f582c380e€35.00€0.50matched
53capture01a1ae58-0e1e-7c0c-a71f-91862c309be7€24.00€0.37matched
54capture01a1ae58-12ac-78fa-8600-0ec35b53405b€35.00€0.50matched
55capture01a1ae58-19c1-7c26-8880-0ba206e87a2d€15.00€0.26matched
57capture01a1ae58-2a41-7e0b-aa40-aa178797c709€49.00€0.67matched
58capture01a1ae58-2b1b-793f-ae7b-d84308a91330€35.00€0.50matched
59capture01a1ae58-441b-7fcb-b3ab-39500a9c0eeb€15.00€0.26matched
60capture01a1ae58-4804-77d4-8902-1e30039edceb€49.00€0.67matched
61capture01a1ae58-5b7f-745c-aaf1-93b9a469c4d1€35.00€0.50matched
62capture01a1ae58-648c-7383-8112-c0001259e314€49.00€0.67matched
63capture01a1ae58-7c02-75a2-99e4-70f7567f77b6€24.00€0.37matched
64capture01a1ae58-7e70-7e68-a990-e1155eab6bfb€24.00€0.37matched
65capture01a1ae58-9561-700e-99a4-8fab240c19f8€35.00€0.50matched
66refund01a1ae58-98b9-7d11-89a4-8caaac987a1a-€32.00€0.00matched
67refund01a1ae58-d921-7002-90dc-1dd8e3bc3f60-€11.00€0.00matched
68capture01a1ae58-de87-7e91-a2ba-51484de99f13€49.00€0.67matched
69capture01a1ae58-e90c-7bc4-b479-6c03663a2f0f€9.00€0.19matched
70capture01a1ae59-031c-7ee3-b7bb-3536656c49e8€9.00€0.19matched
71capture01a1ae59-649f-71b0-aceb-f6e4fe20fa34€49.00€0.67matched
72capture01a1ae59-898e-711f-80cb-e63a26c016ec€15.00€0.26matched
73capture01a1ae59-8ab5-7b9e-93fc-cf4b507f1233€24.00€0.37matched
75capture01a1ae59-95d0-72ad-9b2a-1302669ca4f8€15.00€0.26matched
76capture01a1ae59-b430-7b8f-90dc-536f57e0d835€9.00€0.19matched
77capture01a1ae59-c84c-77b4-b7c0-18a2a57ddc9f€49.00€0.67matched
78capture01a1ae59-ce08-7fd8-b297-a7870555e27b€15.00€0.26matched
79capture01a1ae59-cea5-7c77-9f16-3c94d5285fa4€9.00€0.19matched
80capture01a1ae5a-015f-7e6e-9725-c12b5543bab1€15.00€0.26matched
81capture01a1ae5a-0b1e-74d4-a4df-9e68ac97d2e4€15.00€0.26matched
83capture01a1ae5a-2978-7565-aef8-7b8bb22a0d0b€9.00€0.19matched
84capture01a1ae5a-2b36-7e12-a2b2-10da86034a2a€24.00€0.37matched
85refund01a1ae5a-5636-7bbf-9f5e-588cfd9754b5-€3.00€0.00matched
86capture01a1ae5a-642f-7310-965e-a842c0df6fce€24.00€0.37matched
87capture01a1ae5a-9a03-7c10-af06-e636823119d5€15.00€0.26matched
88capture01a1ae5a-b3f5-7f35-92a1-ab90a3d073c5€24.00€0.37matched
89capture01a1ae5a-b593-7bba-bfeb-e024eda5a2c4€9.00€0.19matched
90capture01a1ae5a-bce0-7c26-ab58-9dd44d946167€9.00€0.19matched
91capture01a1ae5a-c983-77c5-953c-fed484189bf7€49.00€0.67matched
92capture01a1ae5a-d810-71a3-9b14-d15d4a952e05€15.00€0.26matched
93capture01a1ae5b-05c2-7026-8134-80e2d178f71f€49.00€0.67matched
94refund01a1ae5b-0f7e-769c-9b66-5fb6018e6e9e-€12.00€0.00matched
95capture01a1ae5b-0fad-7410-ab86-2daf174e118f€9.00€0.19matched
96capture01a1ae5b-12f5-74c2-9f33-a31f19f0a4f7€35.00€0.50matched
98capture01a1ae5b-399c-7dff-a2da-ac31ee308022€35.00€0.50matched
99capture01a1ae5b-3b1f-7d34-96e7-d70c34e08048€24.00€0.37matched
100capture01a1ae5b-71b7-7e4c-bcc1-f7a733bd0241€35.00€0.50matched
101refund01a1ae5b-71c1-72f5-9a9f-75353aa09050-€45.00€0.00matched
102refund01a1ae5b-78c6-7a2a-8487-2db8cc748cbf-€6.00€0.00matched
103capture01a1ae5b-7cfd-7348-9a16-e4cdbde3e204€24.00€0.37matched
104refund01a1ae5b-8373-7def-a5da-efb7f888b61d-€12.00€0.00matched
105capture01a1ae5b-88d1-7d0c-97ca-fe8a100888fc€35.00€0.50matched
106capture01a1ae5b-9d3d-7f5f-a43d-8fddadbc48c4€9.00€0.19matched
107capture01a1ae5b-b2a4-720b-a16f-0c81fb7951ba€24.00€0.37matched
108capture01a1ae5b-b5c7-7526-8e28-065f1479a75d€49.00€0.67matched
109capture01a1ae5b-bec3-7426-9d04-7eb6217899f9€15.00€0.26matched
110capture01a1ae5b-e107-76df-bcf8-6d8232e86e7e€15.00€0.26matched
111refund01a1ae5b-e82b-73e6-b7cb-ae95240d9679-€7.00€0.00matched
112capture01a1ae5c-0b48-7da4-b2fd-9c3b652676c7€24.00€0.37matched
113capture01a1ae5c-0d85-7ffc-9d19-933f1af810e1€49.00€0.67matched
114capture01a1ae5c-0aea-7e37-80ce-28a3273d553f€49.00€0.67matched
115capture01a1ae5c-224d-74f0-9ef7-2533ccb94ab1€35.00€0.50matched
116capture01a1ae5c-28a3-70d0-b815-009eb059173b€9.00€0.19matched
117capture01a1ae5c-3457-7356-baed-1125707afa42€35.00€0.50matched
118capture01a1ae5c-4e6f-7e5d-9241-e635eb143543€49.00€0.67matched
119capture01a1ae5c-4f25-7b12-93ee-a3af629c955b€24.00€0.37matched
120refund01a1ae5c-688f-75a0-a1d0-437ab19bafb4-€16.00€0.00matched
121capture01a1ae5c-969f-7277-aece-f492bbfedcca€15.00€0.26matched
122capture01a1ae5d-05b0-7d07-b932-c1520af56a58€35.00€0.50matched
123capture01a1ae5d-1e41-70a9-b63f-2e8172897420€35.00€0.50matched
124capture01a1ae5d-26bb-7bed-bd9e-b82db0b205db€49.00€0.67matched
125capture01a1ae5d-4114-7c73-9b5d-2f3b4a4d979b€9.00€0.19matched
126capture01a1ae5d-573e-71e2-8478-9afd39297519€49.00€0.67matched
128capture01a1ae5d-60c0-78e6-a80d-90041e952aeb€15.00€0.26matched
129capture01a1ae5d-661d-7057-ba80-15a191dd64e6€35.00€0.50matched
130capture01a1ae5d-6e1f-754a-959f-547c776230b6€15.00€0.26matched
131capture01a1ae5d-7dfc-72e4-ac2a-70151f379d9d€35.00€0.50matched
132capture01a1ae5d-87ce-7bf1-80c9-9ad455d67125€49.00€0.67matched
133capture01a1ae5d-aa6d-764d-b2af-1aa842de6636€9.00€0.19matched
134capture01a1ae5d-ade4-7c5a-95be-8541461b931b€9.00€0.19matched
135capture01a1ae5d-b0c7-71a6-a22d-95c90bf0a586€49.00€0.67matched
136capture01a1ae5d-c23b-7520-81a9-6a1921ce3811€24.00€0.37matched
137capture01a1ae5d-d165-740f-aa9a-5abca4c4ef80€49.00€0.67matched
138capture01a1ae5d-d264-7862-b713-be0ee3bf67ec€35.00€0.50matched
139capture01a1ae5d-e25c-7e26-aeac-6861c9d44f9d€24.00€0.37matched
140capture01a1ae5e-1e56-7291-9436-812f5309739f€49.00€0.67matched
141capture01a1ae5e-24ea-7ecc-92c1-462a7d5f8628€15.00€0.26matched
142capture01a1ae5e-2dc7-7ca7-b66f-b1c04fabd9d8€35.00€0.50matched
143capture01a1ae5e-33d9-750d-bb3c-939e990d45ae€24.00€0.37matched
144refund01a1ae5e-3923-77d0-9906-e0e9f3d590be-€18.00€0.00matched
145capture01a1ae5e-51c0-78cc-a7d8-90ed1b6a3481€15.00€0.26matched
146capture01a1ae5e-70f5-73a1-ba11-bbbff4d0b473€35.00€0.50matched