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

Gross

€2,592.00

PSP fee

€41.02

Net to the bank

€2,550.98

Settlement journal

#408563

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aec5-b84e-7c75-ab49-628fb298530c is already settled by stl_EUR_2989889 line 30
  • fee differencethe fee is not the contract feethe fee is 28, the contract says 26
  • missing linein the books, not in the filecapture:01a1aec3-da70-7d77-990f-54fc864259e0 is in no file
  • missing linein the books, not in the filecapture:01a1aec8-666c-71ef-ac1f-4e75290c6255 is in no file
LineKindReferenceGrossFeeStatus
31capture01a1aec5-b866-7aa4-b2e8-3dcfc02afb0c€49.00€0.67duplicate line
93capture01a1aecb-c2d0-7000-a2f8-b190e236084b€15.00€0.28fee difference
1capture01a1aeba-c8e1-799f-9c6f-5a55dcf5c8b2€15.00€0.26matched
2capture01a1aebe-be09-75b4-87b7-9c845853bf06€35.00€0.50matched
3capture01a1aec3-7a4f-72eb-a2c8-c3251690faaa€35.00€0.50matched
4capture01a1aec3-9ff0-71a3-84ee-d2ac837d1c5a€15.00€0.26matched
5capture01a1aec3-a03e-704c-9fac-a84048952ef0€35.00€0.50matched
6capture01a1aec3-c2e3-77b8-8e37-98208662c30c€15.00€0.26matched
7capture01a1aec3-c821-7cb5-9d68-131b2a89e21e€35.00€0.50matched
8capture01a1aec3-dbd2-7520-a2f7-670f4292a254€15.00€0.26matched
9capture01a1aec3-e014-7045-a268-d830f50fd730€15.00€0.26matched
10capture01a1aec3-fd7e-7d12-9963-2bf1c8e5cd75€49.00€0.67matched
11capture01a1aec3-f655-70b5-910e-6e18ba365ae2€15.00€0.26matched
12capture01a1aec4-0f2b-7b93-b664-55eb73ea7423€15.00€0.26matched
13capture01a1aec4-1133-7c07-95d2-049da7d819f4€9.00€0.19matched
14capture01a1aec4-2062-7850-a13a-a7acb5809f0a€24.00€0.37matched
15refund01a1aec4-2d12-76b7-b770-06ffa1b5d48a-€4.00€0.00matched
16capture01a1aec4-67a0-7dad-9eac-64601ebc2473€15.00€0.26matched
17capture01a1aec4-6be6-7df4-a0bb-b792215b2a88€15.00€0.26matched
18capture01a1aec4-83b1-7d14-b104-66125ba8bc58€9.00€0.19matched
19capture01a1aec4-9f82-7a64-942c-885b1efe7746€35.00€0.50matched
20capture01a1aec4-e3e6-7e6f-bdb4-e9034e56fa4d€49.00€0.67matched
21capture01a1aec4-e64d-77b6-9088-49623fdbabb3€35.00€0.50matched
22capture01a1aec4-e681-72cf-b5d5-e4ae7f8a7c11€24.00€0.37matched
23capture01a1aec5-1406-7546-91f2-8a6f7b24a66d€49.00€0.67matched
24capture01a1aec5-26b6-7724-90bf-acc9b50baf20€9.00€0.19matched
25capture01a1aec5-286f-7a7f-84bc-de907c9bcf6a€49.00€0.67matched
26capture01a1aec5-6fda-7407-886c-a99d3e0a0afc€35.00€0.50matched
27capture01a1aec5-7986-72d1-a955-afa84bd396a9€49.00€0.67matched
28capture01a1aec5-80bc-7ef6-ab3a-44fe03bdc125€15.00€0.26matched
29capture01a1aec5-86d8-726b-bb0a-9bc620bb73e0€15.00€0.26matched
30capture01a1aec5-b866-7aa4-b2e8-3dcfc02afb0c€49.00€0.67matched
32capture01a1aec5-bbd9-740b-a477-390f6a3f8c34€15.00€0.26matched
33capture01a1aec5-bc54-75cd-8fcd-d36a0d0c4492€24.00€0.37matched
34capture01a1aec5-d17c-7b14-a09b-2fb7fd879b0c€15.00€0.26matched
35capture01a1aec5-d527-7b8a-9cba-142f96ce7c8d€15.00€0.26matched
36capture01a1aec5-da74-7245-9940-4dccde9f62b0€35.00€0.50matched
37capture01a1aec5-e1df-74f8-a462-2da8004fab13€24.00€0.37matched
38capture01a1aec5-e6ce-72f1-8891-c119af86c45b€49.00€0.67matched
39capture01a1aec5-e6ff-7a06-a2db-7ecfbda3c261€35.00€0.50matched
40capture01a1aec6-44c9-756a-9859-31256ad16397€15.00€0.26matched
41refund01a1aec6-8689-7375-99f2-e0c8cabdcf94-€11.00€0.00matched
42capture01a1aec6-8d9b-7991-bcc9-fd4eb8229cb4€35.00€0.50matched
43capture01a1aec6-b1b6-750a-bc28-875f57b953b6€9.00€0.19matched
44capture01a1aec6-c14a-7d49-914d-0fabdf2f7f10€15.00€0.26matched
45capture01a1aec6-d5f9-7dce-b0b8-193c2ff3ebd1€35.00€0.50matched
46capture01a1aec6-e100-790c-9030-af346d954184€9.00€0.19matched
47capture01a1aec6-e2a1-7da2-8e3d-d7176c790893€9.00€0.19matched
48capture01a1aec6-ee28-7431-a75d-62e75311c9f1€15.00€0.26matched
49capture01a1aec7-1578-7e05-8cc5-4e5aa7b97536€49.00€0.67matched
50capture01a1aec7-189a-704c-9f66-4ab449ab0814€24.00€0.37matched
51capture01a1aec7-3644-70e1-9d9d-8d4935f23259€9.00€0.19matched
52capture01a1aec7-66c5-73e3-bc46-2feefc856047€15.00€0.26matched
53refund01a1aec7-9fd6-7659-8639-c9b83e83b389-€13.00€0.00matched
54capture01a1aec7-e8d0-7b82-84aa-c531ec571118€35.00€0.50matched
55capture01a1aec8-3e9b-7e26-a981-9e18559a0bd6€49.00€0.67matched
56capture01a1aec8-4d58-7f32-9cfc-56b530d898da€24.00€0.37matched
57capture01a1aec8-96ff-70c5-8e50-50505d9a3668€49.00€0.67matched
58capture01a1aec8-ce04-7592-8fe0-b94d4cd0b288€24.00€0.37matched
59capture01a1aec8-ed61-7259-b15a-e91a32ce2d33€24.00€0.37matched
60capture01a1aec8-ff92-7566-8dfd-89f68acc4a4f€49.00€0.67matched
61capture01a1aec9-1a47-7dac-aa53-202c409dbe3e€9.00€0.19matched
62capture01a1aec9-2002-7b85-9d62-3697eff40081€49.00€0.67matched
63capture01a1aec9-5e79-79bb-9738-d447711bae68€49.00€0.67matched
64capture01a1aec9-5e83-7a1a-8bfc-cba389b0dc0d€9.00€0.19matched
65capture01a1aec9-6791-7956-843b-57257ebc8057€35.00€0.50matched
66capture01a1aec9-87dc-768e-84de-2f74ebf2c5a8€24.00€0.37matched
67capture01a1aec9-9afe-7308-9cdf-c45556725767€35.00€0.50matched
68capture01a1aec9-b084-719e-a174-bd6f63f1fc88€15.00€0.26matched
69capture01a1aec9-c0bb-7365-a666-21920b5125a6€24.00€0.37matched
70refund01a1aec9-d88a-735a-91de-0f45433bd802-€28.00€0.00matched
71capture01a1aec9-ec8b-729d-b0ce-25b11f25c6c8€9.00€0.19matched
72capture01a1aec9-ee2d-79ad-8fda-47f31b77d6ef€35.00€0.50matched
73capture01a1aeca-1794-7f70-9cb1-e81f85d522cc€49.00€0.67matched
74refund01a1aeca-1886-7c29-941f-2d216bb6c06f-€7.00€0.00matched
75refund01a1aeca-60e4-794c-b47c-ebadb40adb29-€33.00€0.00matched
76capture01a1aeca-8610-7d17-b049-69b5b97125a4€9.00€0.19matched
77capture01a1aeca-aa39-739a-8adb-7ddf77e91105€15.00€0.26matched
78capture01a1aeca-ac96-74da-b0a0-ce76e7d06cc7€24.00€0.37matched
79capture01a1aeca-b570-7358-bbad-662a5d11d488€9.00€0.19matched
80capture01a1aeca-e1b5-7d04-8f5d-5c11dab5d2e2€15.00€0.26matched
81capture01a1aeca-e82a-7f43-abda-18c158f8d2bb€49.00€0.67matched
82capture01a1aecb-1be9-799f-85fb-c13d1b696511€15.00€0.26matched
83capture01a1aecb-2ef0-7f39-8823-bdac0d0add44€24.00€0.37matched
84refund01a1aecb-3447-7808-915f-4d38292cbad0-€4.00€0.00matched
85capture01a1aecb-395b-70c3-b63a-625dd17a6aff€9.00€0.19matched
86capture01a1aecb-465c-7996-82e0-d28f3a404f9b€15.00€0.26matched
87capture01a1aecb-4d00-7185-acee-99cc14194d29€49.00€0.67matched
88capture01a1aecb-59e8-789e-889d-b0956b9d3aca€49.00€0.67matched
89capture01a1aecb-5cdc-75e5-9ee3-af657251cb55€9.00€0.19matched
90capture01a1aecb-6213-7eea-8071-c65f6fb565a6€24.00€0.37matched
91capture01a1aecb-7d0a-750d-8cc6-85945a45f216€35.00€0.50matched
92capture01a1aecb-7e72-78c6-8db8-1ac60c85c8d7€9.00€0.19matched
94capture01a1aecb-d500-72e8-ac62-f663e5c64a72€49.00€0.67matched
95capture01a1aecb-e6d5-7b6c-a56d-6f1ceabb3f66€35.00€0.50matched
96capture01a1aecb-f018-7d51-b9b0-21bab80518bb€49.00€0.67matched
97capture01a1aecb-f0a6-70b4-a183-96e7fdd06d39€24.00€0.37matched
98capture01a1aecb-f609-7cfa-91b6-61bfd49963c5€15.00€0.26matched
99capture01a1aecc-09fd-762f-b8b6-172251b13598€35.00€0.50matched
100capture01a1aecc-367e-7169-b949-73868520c89f€9.00€0.19matched
101capture01a1aecc-3cbd-73f5-ba63-fb847e5a8381€35.00€0.50matched
102refund01a1aecc-4446-7c8b-9623-a3f2b23730cf-€49.00€0.00matched
103capture01a1aecc-460c-761b-a02d-e9cd6b5d73ee€35.00€0.50matched
104capture01a1aecc-5596-7a49-9770-c1a02943127b€24.00€0.37matched
105capture01a1aecc-5897-7429-b74c-f0fbdcdc65fa€49.00€0.67matched
106capture01a1aecc-5e00-76c6-b681-71163b7858f7€35.00€0.50matched
107capture01a1aecc-7b54-7303-86ce-446731305bf2€49.00€0.67matched
108capture01a1aecc-7c44-7ea2-81cb-41f59a8a5260€49.00€0.67matched