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

5 Nov, 02:20

Gross

€2,965.00

PSP fee

€46.27

Net to the bank

€2,918.73

Settlement journal

#389961

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a98a-016a-7e63-9174-b722290f121b is already settled by stl_EUR_2989742 line 109
  • fee differencethe fee is not the contract feethe fee is 31, the contract says 26
  • missing linein the books, not in the filecapture:01a1a982-eb13-7462-a849-8978c82acc03 is in no file
LineKindReferenceGrossFeeStatus
1refund01a1a97a-5045-763a-a14d-2b8d081b4660-€6.00€0.02fee difference
47capture01a1a985-268e-754a-a706-2c67500dc32c€15.00€0.31fee difference
110capture01a1a98a-018a-71f1-a657-2c12b3fa0889€15.00€0.26duplicate line
2capture01a1a97b-6fcc-762a-a067-77b429fdb0a7€15.00€0.26matched
3capture01a1a97c-fd75-7a21-a88c-14e00ce9f220€9.00€0.19matched
4capture01a1a97f-4af2-79f7-85ea-9b5b6385b389€15.00€0.26matched
5capture01a1a97f-9bb5-7371-99b7-8c1e3970a1fc€15.00€0.26matched
6capture01a1a981-9d25-7a03-ad80-f2b61feed8a9€15.00€0.26matched
7capture01a1a981-bb4c-733b-829d-7299cef31365€24.00€0.37matched
8refund01a1a981-c6bf-7dea-8e0f-6251f49b75b5-€10.00€0.00matched
9capture01a1a981-d526-7c9e-b8bd-899b47e8a3e7€24.00€0.37matched
10capture01a1a981-ed89-7d69-b36c-7457229ecf09€49.00€0.67matched
11capture01a1a981-edcd-7a4e-81d9-2e45ad545706€49.00€0.67matched
12capture01a1a982-2769-72c5-851b-66699ce417ae€24.00€0.37matched
13capture01a1a982-2d5e-75f2-8980-7ddf959f3815€24.00€0.37matched
14capture01a1a982-2e19-704d-99d3-d4b76589a5bc€24.00€0.37matched
15capture01a1a982-2f06-7ec8-84cd-ab6f08fb2823€35.00€0.50matched
16capture01a1a982-48c6-71e3-953a-132483c9695c€24.00€0.37matched
17capture01a1a982-65c0-749e-b049-918e5ffca8fd€24.00€0.37matched
18capture01a1a982-7608-7fe9-8565-f743fb406f36€9.00€0.19matched
19capture01a1a982-ab77-7a9d-a909-610bf1f4d93f€49.00€0.67matched
20capture01a1a982-caed-72d1-abf7-ee4d9fbd88d5€15.00€0.26matched
21capture01a1a982-f365-729b-906e-2e1a016108d1€49.00€0.67matched
22capture01a1a982-f719-7a47-b110-60d0f693b0b3€15.00€0.26matched
23capture01a1a983-1039-7819-a12b-1a250909cd0c€15.00€0.26matched
24capture01a1a983-2d07-76d7-a911-0eaa50618330€49.00€0.67matched
25capture01a1a983-34fc-732b-a41e-4034875ffd19€9.00€0.19matched
26capture01a1a983-36b7-731f-a230-c530edb51d72€24.00€0.37matched
27refund01a1a983-4070-7c8b-af53-ee7a656800fc-€9.00€0.00matched
28capture01a1a983-41c8-72d9-ad18-9be50991ccac€35.00€0.50matched
29capture01a1a983-43d2-763a-b95d-c835d2b98790€49.00€0.67matched
30capture01a1a983-4a4c-7caf-bf7e-bcc686421019€24.00€0.37matched
31capture01a1a983-7e68-7308-b141-e6d207ee097e€49.00€0.67matched
32capture01a1a983-7f97-7342-a605-32ad65a04b67€9.00€0.19matched
33capture01a1a983-9a24-7d13-964a-d8bf413bec26€9.00€0.19matched
34capture01a1a983-cabb-72e9-8470-eaa40c1d7998€35.00€0.50matched
35capture01a1a984-2484-7a82-8d4a-a80c001b769a€35.00€0.50matched
36capture01a1a984-294f-769c-b58d-0fc4905dcdae€35.00€0.50matched
37capture01a1a984-30dd-78ad-8d40-bbb432497b9e€9.00€0.19matched
38capture01a1a984-477b-7a3d-9482-36e1fd13060f€15.00€0.26matched
39capture01a1a984-55bf-72b7-9ba1-59e0cff9ef23€49.00€0.67matched
40capture01a1a984-5a16-734f-b9fd-4359c8d5934f€15.00€0.26matched
41capture01a1a984-6f3a-7576-9be5-3f9b972a1b2e€24.00€0.37matched
42capture01a1a984-b5cb-7664-a372-200ef372df86€35.00€0.50matched
43capture01a1a984-f5cd-788f-b616-64e15955f8be€49.00€0.67matched
44capture01a1a984-fcbd-7224-898a-68b464ffe0ad€35.00€0.50matched
45capture01a1a985-1754-7781-a533-29f5070abedc€35.00€0.50matched
46capture01a1a985-20cb-707c-913e-ee96f71e125d€49.00€0.67matched
48capture01a1a985-296a-7dc5-9d93-39b1db73be39€35.00€0.50matched
49refund01a1a985-275b-7b6d-8d22-feefbd3b8679-€12.00€0.00matched
50capture01a1a985-43e4-7dcb-816e-b0bd1138a6fc€15.00€0.26matched
51capture01a1a985-5e28-791b-9017-617edc4209aa€35.00€0.50matched
52capture01a1a985-79a6-7ee5-8f14-1d040c3f7b8e€35.00€0.50matched
53refund01a1a985-8e94-7eb0-af6b-9cd857786d75-€26.00€0.00matched
54capture01a1a985-9151-7046-86e2-6d059d25a2a3€49.00€0.67matched
55capture01a1a985-9276-7c16-a568-6e4c539f198d€15.00€0.26matched
56capture01a1a985-b03a-7643-8868-3c15b322b0eb€49.00€0.67matched
57capture01a1a985-c8b9-75ee-881a-c105f91075b9€24.00€0.37matched
58capture01a1a985-d7c7-777b-a372-420c71a7a134€49.00€0.67matched
59capture01a1a985-f0a4-7351-9a18-61f78aeab6d4€49.00€0.67matched
60capture01a1a985-fe38-711b-ade8-3f5ed77bcbf2€24.00€0.37matched
61capture01a1a986-198f-75a9-b0cb-4c7c369e8091€15.00€0.26matched
62capture01a1a986-1af2-7d2a-8e82-b51fdee40b6a€49.00€0.67matched
63capture01a1a986-2ce2-7e05-825b-e6d9b25d934d€9.00€0.19matched
64capture01a1a986-4013-79aa-8ef7-619eab8f09db€49.00€0.67matched
65capture01a1a986-49af-7b8d-ac15-ff8f44272019€15.00€0.26matched
66capture01a1a986-b3f9-72ac-bf3f-67529bcd9be2€49.00€0.67matched
67capture01a1a986-c2a6-7f1d-8276-22c38e1decbe€15.00€0.26matched
68capture01a1a986-ce36-7e9b-bab0-f3dc09e720c9€9.00€0.19matched
69capture01a1a986-d1c4-72c6-a87b-31ce19c96001€9.00€0.19matched
70capture01a1a986-d4fe-7f55-983c-6e27c76a4db3€9.00€0.19matched
71capture01a1a986-e8d2-73ab-b68e-6d984cc2f716€35.00€0.50matched
72capture01a1a987-27dd-75c4-bb6a-de18f72611f9€35.00€0.50matched
73capture01a1a987-2a81-7502-90cd-cb9065840d64€9.00€0.19matched
74capture01a1a987-2fd1-7745-8805-71ac74c657e9€15.00€0.26matched
75capture01a1a987-5346-7ee3-9537-9feee3988942€9.00€0.19matched
76capture01a1a987-8880-79fd-810b-716a446281a1€49.00€0.67matched
77capture01a1a987-bbda-79f2-867d-a82805673eb9€49.00€0.67matched
78refund01a1a987-c981-77ea-a23c-8c6b5de7d8a2-€35.00€0.00matched
79capture01a1a987-ee77-79af-8188-54fa545a839d€24.00€0.37matched
80capture01a1a987-f472-7039-90cf-b5a26fbb95c3€9.00€0.19matched
81capture01a1a988-0450-7dc3-b7cf-767593a5dd08€35.00€0.50matched
82capture01a1a988-10fb-71ee-906f-a495daa27c96€35.00€0.50matched
83capture01a1a988-20dc-78b2-8002-db7e6cf96420€15.00€0.26matched
84capture01a1a988-2963-7919-b792-5e302aa57449€24.00€0.37matched
85capture01a1a988-382f-7fd1-8e16-6ce30d503c3c€35.00€0.50matched
86refund01a1a988-6513-7110-b54c-903b608d2fdd-€24.00€0.00matched
87capture01a1a988-687e-7291-adff-99d831873f1f€9.00€0.19matched
88capture01a1a988-ad14-7cf5-8699-04b700137ae7€49.00€0.67matched
89capture01a1a988-aec8-7a01-b25d-b1117f0dae3d€49.00€0.67matched
90capture01a1a988-d6d1-767d-85ba-3cdda40cdf71€24.00€0.37matched
91capture01a1a988-db49-7e2b-b013-8026d61bf10c€15.00€0.26matched
92capture01a1a988-e6f5-76ef-9d4e-3b004921987a€15.00€0.26matched
93capture01a1a988-f5b7-7613-8171-64217c2378f9€15.00€0.26matched
94capture01a1a989-07fd-73df-bbd4-9cdb8c7f8a1f€35.00€0.50matched
95capture01a1a989-1a36-79f3-bc23-0119f52c972b€35.00€0.50matched
96capture01a1a989-1c0a-7ccd-8958-dae0ea840c21€24.00€0.37matched
97capture01a1a989-39fd-75c9-ba61-01907ba8d83e€35.00€0.50matched
98capture01a1a989-3b34-7810-9891-b568017f3719€24.00€0.37matched
99capture01a1a989-3bb6-7428-a8cb-03d5e0a6dbc5€49.00€0.67matched
100capture01a1a989-4860-7683-9cd1-aaabc63d8cc3€35.00€0.50matched
101capture01a1a989-496c-71be-a72b-84f410706cc2€24.00€0.37matched
102capture01a1a989-62aa-739a-925d-28fc04c64718€15.00€0.26matched
103capture01a1a989-7903-7617-8049-9364b9b4b24f€15.00€0.26matched
104capture01a1a989-8b6b-76dc-afaf-ee2b7b9e6e0d€35.00€0.50matched
105capture01a1a989-c231-76d1-af50-0cc73434caa8€24.00€0.37matched
106capture01a1a989-c6c7-738c-95a1-5b694125d47f€15.00€0.26matched
107capture01a1a989-d158-751f-862f-63efcf8e1e3d€15.00€0.26matched
108capture01a1a989-ecfd-7c28-8f71-202aab6c01d2€15.00€0.26matched
109capture01a1a98a-018a-71f1-a657-2c12b3fa0889€15.00€0.26matched
111capture01a1a98a-0211-7bc6-8803-2bc315992b2d€24.00€0.37matched
112capture01a1a98a-13cf-7b9e-9523-1e9b27aa6397€35.00€0.50matched
113capture01a1a98a-1a36-7ed6-a6f8-305ab141996d€15.00€0.26matched
114capture01a1a98a-2984-7ecc-995c-206e78b442da€49.00€0.67matched
115capture01a1a98a-3363-7663-a962-3f1d678e4620€15.00€0.26matched
116capture01a1a98a-390e-764b-952e-4251df419668€15.00€0.26matched
117capture01a1a98a-4a7f-7edb-8f91-6169fb4c6541€35.00€0.50matched
118capture01a1a98a-4e24-7e27-aa56-9d0f069098e9€49.00€0.67matched
119capture01a1a98a-8933-7746-ba91-66f15749b91e€35.00€0.50matched
120capture01a1a98a-9d70-7d7b-afad-33539febb9dc€15.00€0.26matched