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, 04:10

Gross

€2,883.00

PSP fee

€47.52

Net to the bank

€2,835.48

Settlement journal

#409610

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1af0d-a6c4-73b8-8468-c601b8866af3 is already settled by stl_EUR_2989897 line 17
  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
  • missing linein the books, not in the filecapture:01a1af0e-adb4-7e50-b750-dd8498bd1c71 is in no file
  • missing linein the books, not in the filecapture:01a1af13-9192-72ff-9348-35b92dec544d is in no file
LineKindReferenceGrossFeeStatus
18capture01a1af0d-a6e3-7c04-8b0a-b1ad27dc51b3€9.00€0.19duplicate line
123capture01a1af15-2a1d-71fa-8685-f50e23e58da5€9.00€0.21fee difference
1capture01a1af04-28d7-7634-8051-1d7c5c2e5a9d€9.00€0.19matched
2capture01a1af04-60bd-7248-91a0-d18a1fd80dc8€9.00€0.19matched
3capture01a1af07-40de-736c-983c-077d3bbf4550€24.00€0.37matched
4capture01a1af09-3db9-7439-9a70-b6baebe31f31€9.00€0.19matched
5capture01a1af09-50be-799d-8dd3-38a3973295b2€9.00€0.19matched
6capture01a1af0c-a2bd-7337-9e86-65a74686f88b€35.00€0.50matched
7capture01a1af0c-a564-71a3-ae76-83c8c89f9d3b€9.00€0.19matched
8capture01a1af0c-ce23-778f-98d5-c10c08ddeb88€15.00€0.26matched
9refund01a1af0c-dc5d-7190-a59c-adeffa7202fd-€5.00€0.00matched
10capture01a1af0c-dfcf-7308-9777-21783b505574€9.00€0.19matched
11refund01a1af0c-e563-7d30-a1bc-3c3c75717001-€13.00€0.00matched
12capture01a1af0c-f29c-7498-a308-bedc7cfac4cf€9.00€0.19matched
13capture01a1af0d-07dc-7371-a892-3cca0260e8a0€24.00€0.37matched
14refund01a1af0d-390b-74ee-831a-c3c57d8914e2-€9.00€0.00matched
15capture01a1af0d-9eac-762d-b707-11bd9b07e64e€15.00€0.26matched
16capture01a1af0d-9edc-7dd1-91f0-929542b4db39€15.00€0.26matched
17capture01a1af0d-a6e3-7c04-8b0a-b1ad27dc51b3€9.00€0.19matched
19capture01a1af0d-aa66-793b-aa02-b588fc9c85c8€15.00€0.26matched
20capture01a1af0d-b827-75bd-a26c-5911c3f3b021€9.00€0.19matched
21capture01a1af0d-cd92-7f05-853b-c83cb6aa6ad3€49.00€0.67matched
22capture01a1af0d-f04f-70b7-97f8-816c93eefcb6€35.00€0.50matched
23capture01a1af0d-f252-76a9-8ba4-5ce232c0de33€35.00€0.50matched
24capture01a1af0d-f374-75b2-988c-aa2ae7c114bc€9.00€0.19matched
25capture01a1af0d-fb10-7cb3-8acc-426befc2ec8c€9.00€0.19matched
26capture01a1af0e-1d91-72b2-ba6d-b52305573f81€24.00€0.37matched
27capture01a1af0e-2126-7eaa-bc98-f68ec1b8d9ff€9.00€0.19matched
28capture01a1af0e-25c8-7f28-b141-e010e7c3e291€49.00€0.67matched
29refund01a1af0e-432c-740d-804a-4e32b36af32f-€9.00€0.00matched
30capture01a1af0e-59b9-7d83-87e6-1332cd7946ed€15.00€0.26matched
31capture01a1af0e-5d4b-788e-bbb5-b3435f4a4168€24.00€0.37matched
32capture01a1af0e-6236-7eca-b3f9-3dcea0b51eb3€24.00€0.37matched
33capture01a1af0e-6bf7-717d-86a6-0e7bf302b55b€35.00€0.50matched
34capture01a1af0e-95c1-78d9-99b3-5b8697d649e5€35.00€0.50matched
35capture01a1af0e-b4d3-7e52-8ebb-9a2bbb0f2992€15.00€0.26matched
36capture01a1af0e-cb65-70ee-ab67-e0fd92f5b472€24.00€0.37matched
37refund01a1af0e-cf19-7d7a-a184-2726b883d7ae-€21.00€0.00matched
38capture01a1af0e-d7a9-7494-8826-176cb5c23149€24.00€0.37matched
39capture01a1af0e-e06a-7814-8761-f4b087b5871b€35.00€0.50matched
40capture01a1af0f-0880-72e3-b256-f97bae7e3607€49.00€0.67matched
41capture01a1af0f-2417-7b49-9454-16da864eb706€35.00€0.50matched
42capture01a1af0f-363e-7267-85eb-d19da979655d€15.00€0.26matched
43capture01a1af0f-41c3-7c22-99a4-272ed80a7e18€24.00€0.37matched
44refund01a1af0f-52b4-7c50-ab8e-1e334f2ca8b9-€43.00€0.00matched
45capture01a1af0f-68c2-7ff7-bece-da45abdc802d€24.00€0.37matched
46capture01a1af0f-743b-75c3-97d9-030eda27769b€49.00€0.67matched
47capture01a1af0f-837e-7da6-a245-1d94427a0ccb€15.00€0.26matched
48capture01a1af0f-8ad8-7662-97ff-8f1a46417a72€9.00€0.19matched
49capture01a1af0f-96c0-7486-896e-6730341f1b87€24.00€0.37matched
50capture01a1af0f-9b30-78de-9036-62fe97d6466d€15.00€0.26matched
51capture01a1af0f-9c6a-7271-988b-f480b8e51565€15.00€0.26matched
52capture01a1af0f-aa8e-7691-bfd2-58190a97079e€24.00€0.37matched
53capture01a1af0f-e2f0-7f62-8a53-a87f532f0dc8€15.00€0.26matched
54capture01a1af0f-f6bd-7844-be58-e0e4a4aad0dc€49.00€0.67matched
55capture01a1af10-1054-728e-b5d7-9990cb0a07c8€49.00€0.67matched
56capture01a1af10-205d-74e6-b1cf-954fa5b1c5f0€35.00€0.50matched
57capture01a1af10-3574-7bfe-89bb-40324fcec2ea€49.00€0.67matched
58capture01a1af10-38f6-749d-9bad-dd0ffcf894a6€24.00€0.37matched
59capture01a1af10-3968-7c8d-b087-b2e8f9f4e59b€49.00€0.67matched
60capture01a1af10-57e1-7414-8c0b-6dc59281b3ff€35.00€0.50matched
61capture01a1af10-8007-7d46-8b81-4c44fedf16e5€35.00€0.50matched
62capture01a1af10-8231-7732-8688-b22c4893d734€49.00€0.67matched
63refund01a1af10-8374-741d-b7b7-2a3d02b01ac6-€48.00€0.00matched
64capture01a1af10-8f4e-7f8e-91cb-d7c687662906€35.00€0.50matched
65capture01a1af10-a4e5-7ecf-be6d-94756012de38€49.00€0.67matched
66capture01a1af10-a68e-7132-886f-3cf9f7deaff2€49.00€0.67matched
67capture01a1af10-ba07-793f-a931-0cc22e776a82€24.00€0.37matched
68capture01a1af10-d049-752c-b0e3-a7ea57e01bb6€49.00€0.67matched
69capture01a1af10-ea44-7b7b-bb31-b70c78781bb8€24.00€0.37matched
70refund01a1af10-fd17-78fe-8db5-e40be8ce92e8-€28.00€0.00matched
71capture01a1af11-0b5c-7301-bc8b-4447a7dc9f84€35.00€0.50matched
72capture01a1af11-10ce-71a3-9f53-00dd886b5c69€49.00€0.67matched
73capture01a1af11-2119-7b64-ab8a-099fa84f206d€9.00€0.19matched
74capture01a1af11-355b-7a69-8ebf-0c45e609c235€15.00€0.26matched
75capture01a1af11-644c-77e5-b09a-4379a7a8010c€49.00€0.67matched
76capture01a1af11-6763-7f81-8dba-1aa262414c63€24.00€0.37matched
77capture01a1af11-bd1b-783a-9aed-ce645d40500e€35.00€0.50matched
78capture01a1af11-c37b-7985-94f5-e4bc607c85ac€15.00€0.26matched
79capture01a1af11-ca18-76ea-8dfe-1e42c0139a10€9.00€0.19matched
80capture01a1af11-d4bf-78d7-a69a-8706e0443c0e€35.00€0.50matched
81capture01a1af11-dc38-79a0-8f50-9575d7af8d9c€35.00€0.50matched
82capture01a1af11-f49e-7bb0-8fe8-bf7e8e314c25€24.00€0.37matched
83capture01a1af12-0328-7581-b016-ed33530d01eb€15.00€0.26matched
84capture01a1af12-144b-7bb8-b3e1-bf2b3e1f245f€9.00€0.19matched
85refund01a1af12-1d63-73fd-a62f-c0e1c0be3557-€27.00€0.00matched
86capture01a1af12-1e0c-7594-a594-899e88ed2721€49.00€0.67matched
87capture01a1af12-4257-7014-8111-e6d99e774760€49.00€0.67matched
88capture01a1af12-462d-7888-82e0-ccf3a49ec6cd€9.00€0.19matched
89capture01a1af12-6c62-7387-a1d7-99e43cf821d5€9.00€0.19matched
90capture01a1af12-80c4-72ed-ae09-e1f25a38ba90€15.00€0.26matched
91capture01a1af12-9717-7e17-be38-c7dd94762a70€15.00€0.26matched
92capture01a1af12-a28f-7310-975b-18f403b13e3a€49.00€0.67matched
93refund01a1af12-a977-7b66-82a6-41756849a4c7-€3.00€0.00matched
94capture01a1af12-d8f0-7b41-b2bf-ed47f90ccf5f€15.00€0.26matched
95capture01a1af12-e44a-75e9-8663-19177e68b448€24.00€0.37matched
96capture01a1af13-1822-76eb-9daa-321292cc0598€24.00€0.37matched
97capture01a1af13-1f8a-7ef4-a739-3c6d80216ea0€35.00€0.50matched
98capture01a1af13-21b4-788d-92d9-edf2bb84b14c€49.00€0.67matched
99capture01a1af13-30ac-7383-93c3-ae897236d4cf€49.00€0.67matched
100capture01a1af13-49ac-7ab7-8cc9-9a1985cd4ae2€15.00€0.26matched
101capture01a1af13-51af-7186-a4a1-5119af6a5b67€35.00€0.50matched
102capture01a1af13-5f89-7282-834d-d00d4b07ee83€49.00€0.67matched
103refund01a1af13-7d6c-7cd2-ab52-a219ca35bf88-€9.00€0.00matched
104capture01a1af13-904e-7dd3-b0d8-951b53ecca54€35.00€0.50matched
105capture01a1af13-9def-707d-aab4-ea591efc4ff6€49.00€0.67matched
106capture01a1af13-b0f9-7637-bd63-3d9908e3923e€49.00€0.67matched
107capture01a1af13-b83a-7672-80a0-7fddfe796de2€35.00€0.50matched
108capture01a1af13-bf49-7e2b-8c2a-8dd2b1f4ade7€15.00€0.26matched
109refund01a1af13-cfc3-7793-a5be-467fae1cfc0a-€35.00€0.00matched
110capture01a1af14-0556-7599-985f-2bc469692a7e€35.00€0.50matched
111capture01a1af14-1d06-7d82-88dd-182c3b80a4a6€49.00€0.67matched
112capture01a1af14-2a51-784c-ae83-f8e28a88ae61€15.00€0.26matched
113capture01a1af14-5a2c-7f26-8598-c24e5b37f8f2€9.00€0.19matched
114capture01a1af14-5cf8-7785-a55e-ae57d5ebf7f1€9.00€0.19matched
115capture01a1af14-97c1-766b-bb56-4750b215e792€35.00€0.50matched
116capture01a1af14-9a65-755c-a2e4-30153d4c59ad€9.00€0.19matched
117capture01a1af14-9d74-7294-8220-49792dc64f48€9.00€0.19matched
118capture01a1af14-bb50-7859-8b22-5fcbd8872ee8€49.00€0.67matched
119capture01a1af14-c9fb-7693-924d-b1d9a7483c2c€15.00€0.26matched
120capture01a1af14-e34f-7fba-81cf-6b76ce3a8871€9.00€0.19matched
121capture01a1af14-fad8-7e4b-8190-8ac08c29123f€9.00€0.19matched
122capture01a1af15-29c3-77fd-b455-87a4f61a3491€24.00€0.37matched
124capture01a1af15-3222-796b-8af1-56f771c6176a€24.00€0.37matched
125capture01a1af15-3a7c-7c33-87d3-7442d61a5575€9.00€0.19matched
126capture01a1af15-3cfe-7b09-a4c9-a54c2733a9b7€24.00€0.37matched
127capture01a1af15-4356-76f0-9412-1d2fbd15ba56€24.00€0.37matched
128capture01a1af15-5091-7995-9979-a226ecc054fa€15.00€0.26matched
129capture01a1af15-611d-764f-b705-17775b93e430€35.00€0.50matched
130capture01a1af15-6ed0-725a-a6e2-b9b5a062df83€35.00€0.50matched
131capture01a1af15-7ec1-70c2-bccd-623042c428b1€15.00€0.26matched
132capture01a1af15-9fbc-7604-9566-2a4a0e7a7097€49.00€0.67matched
133refund01a1af15-b6b6-7a22-b798-6cc89ef9386d-€13.00€0.00matched