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

2 Nov, 20:10

Gross

€2,286.00

PSP fee

€36.90

Net to the bank

€2,249.10

Settlement journal

#348685

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19de5-f435-7edd-ab56-06530231c394 is already settled by stl_EUR_2989417 line 39
  • missing linein the books, not in the filecapture:01a19dea-59fd-764d-89fe-418e7d280cc3 is in no file
  • missing linein the books, not in the filecapture:01a19de4-77e8-7eaa-9094-913b8a0a14e9 is in no file
LineKindReferenceGrossFeeStatus
40capture01a19de5-f460-7691-883b-fad9f37fa60d€9.00€0.19duplicate line
1capture01a19dd9-9eae-7eb6-b106-231f97d0ea0d€24.00€0.37matched
2capture01a19ddb-f34b-7c6e-803e-ffa07daffa21€15.00€0.26matched
3capture01a19ddf-d883-79a7-9548-5f093c67d467€49.00€0.67matched
4capture01a19de2-3303-7181-922e-03a4083d5314€15.00€0.26matched
5capture01a19de2-6232-7a11-941b-08fb664aedca€24.00€0.37matched
6capture01a19de2-969d-7fdb-af68-5c14d1a760c9€35.00€0.50matched
7capture01a19de2-a66f-7fe3-a545-cf336eed2dd9€24.00€0.37matched
8capture01a19de2-baae-7d34-b6e9-29b81fa4ac16€35.00€0.50matched
9capture01a19de2-c8e2-726c-8399-a5a040cbc80b€15.00€0.26matched
10capture01a19de2-e285-7e93-82e5-d23cc3436069€35.00€0.50matched
11capture01a19de2-ea27-7a75-b592-7ea78aa06b54€15.00€0.26matched
12capture01a19de3-3eeb-7579-9842-6d0a823593e1€15.00€0.26matched
13capture01a19de3-4f8a-7a0a-8900-6b0413078afa€49.00€0.67matched
14capture01a19de3-5b14-7088-a515-c2cd15a7d997€49.00€0.67matched
15capture01a19de3-623f-7db2-a29b-0fe81453f6e7€15.00€0.26matched
16capture01a19de3-82bd-72d5-966c-f4de8b05b3f1€24.00€0.37matched
17capture01a19de3-8e3a-7e94-bd7c-02a25e239408€15.00€0.26matched
18capture01a19de3-d26e-782b-a750-56c5615d3cf5€24.00€0.37matched
19capture01a19de4-06ef-725f-8d97-7ed948a7818f€35.00€0.50matched
20capture01a19de4-3a7c-75d5-981a-d5d84f5a0918€49.00€0.67matched
21capture01a19de4-5062-7aa6-b9e8-fdc6625309d0€24.00€0.37matched
22capture01a19de4-77ce-7771-880a-64eea3fccab3€9.00€0.19matched
23capture01a19de4-aac1-720e-8143-3fdb37bbdf40€15.00€0.26matched
24capture01a19de4-b233-7483-a679-33fd4aa6395d€9.00€0.19matched
25capture01a19de4-c033-7cfa-abb9-6e5fa07ea9f1€9.00€0.19matched
26capture01a19de4-c0c3-7d2f-a95f-3a74167c330a€49.00€0.67matched
27capture01a19de4-e271-7146-bbad-49c0f1ea371c€15.00€0.26matched
28capture01a19de4-e34d-7976-85ec-35b36a434b8c€9.00€0.19matched
29capture01a19de5-075a-7b9a-a7ab-0223e220e948€35.00€0.50matched
30capture01a19de5-1006-724f-b17a-98a0f77dc843€9.00€0.19matched
31capture01a19de5-1314-7d62-947e-82bdef0e24ce€9.00€0.19matched
32capture01a19de5-2b26-7da8-b491-361051b591e9€35.00€0.50matched
33capture01a19de5-38ca-7239-946d-13257520de69€24.00€0.37matched
34capture01a19de5-4555-7d75-b733-70b550d45c3b€49.00€0.67matched
35capture01a19de5-4f7b-7bd5-ba94-e2acfa58c2b4€49.00€0.67matched
36refund01a19de5-50a6-70a4-b1a5-50f5be5a864d-€6.00€0.00matched
37capture01a19de5-7224-79c9-8096-3da53cba8b6c€15.00€0.26matched
38refund01a19de5-cc01-7f46-bac3-cf2ef499dbfd-€4.00€0.00matched
39capture01a19de5-f460-7691-883b-fad9f37fa60d€9.00€0.19matched
41capture01a19de5-f858-7931-af76-07bbacb86ab5€15.00€0.26matched
42refund01a19de6-23b1-7317-99a7-105ab85500eb-€6.00€0.00matched
43refund01a19de6-62e7-751e-be8e-49970025029a-€9.00€0.00matched
44capture01a19de6-8a6c-7001-99d7-05282cb27557€49.00€0.67matched
45capture01a19de6-8bd1-7695-8026-7f4a5f30a8f6€49.00€0.67matched
46capture01a19de6-9ac3-7486-9ab4-f4fca3835ce3€49.00€0.67matched
47capture01a19de6-9ec6-77c9-a2a6-a23a18eed92c€49.00€0.67matched
48capture01a19de6-cebc-793d-9b45-d6c0f8808e67€24.00€0.37matched
49capture01a19de6-d7b1-7c98-a7b6-8307387236aa€35.00€0.50matched
50capture01a19de6-dc3f-71f3-aece-65096c80495c€9.00€0.19matched
51capture01a19de6-ee27-7582-bb0e-7b86a8eb5489€9.00€0.19matched
52capture01a19de6-f06c-7bd8-9a6b-f1a510354e99€49.00€0.67matched
53refund01a19de6-f366-7228-bfee-aba7f0e91d5a-€22.00€0.00matched
54capture01a19de6-fa4f-726e-a865-3926d233c08a€35.00€0.50matched
55capture01a19de7-5cc7-765d-9c7a-dc470664c8b6€15.00€0.26matched
56capture01a19de7-5f9e-7137-8a64-e033ef733859€15.00€0.26matched
57capture01a19de7-6445-7f91-b2c8-cecf428dd63a€49.00€0.67matched
58capture01a19de7-661c-7a59-8aed-8e82c5722728€49.00€0.67matched
59capture01a19de7-87d7-72c3-b745-24a7dd61c970€24.00€0.37matched
60capture01a19de7-9fdc-78c1-8901-3bdfa6fc0d58€9.00€0.19matched
61capture01a19de7-ac81-71f4-a147-fcf333633244€9.00€0.19matched
62refund01a19de7-b1d6-7a7e-9c12-6eec2d4daf64-€47.00€0.00matched
63capture01a19de7-e794-7836-8532-a3e47725b688€9.00€0.19matched
64capture01a19de7-e8f6-7131-af82-a8cb2f80514f€9.00€0.19matched
65capture01a19de8-26a9-7677-ad3e-5dadcc1367a3€35.00€0.50matched
66capture01a19de8-3255-77c5-81df-d499a33b39fc€49.00€0.67matched
67capture01a19de8-3cdc-76d7-aef6-d674a198d605€9.00€0.19matched
68refund01a19de8-63c0-735d-b9fe-c4673682d9b1-€18.00€0.00matched
69capture01a19de8-76ac-7233-bf9f-4126da5fcb38€24.00€0.37matched
70capture01a19de8-9d9c-74cf-a287-6abd9db13ce7€9.00€0.19matched
71capture01a19de8-a774-72cb-93f2-9ed9b4e036f0€35.00€0.50matched
72capture01a19de8-c46b-7de8-b4db-42e35531e5bc€24.00€0.37matched
73capture01a19de8-ce8f-770f-8f7c-a4da378902a7€15.00€0.26matched
74capture01a19de8-e2bb-7310-8cca-411e46288c08€9.00€0.19matched
75capture01a19de8-e8a5-79d8-940d-5bbcb1a0fb3f€24.00€0.37matched
76capture01a19de8-ed61-7671-988c-c93e33693d72€9.00€0.19matched
77capture01a19de8-ff67-7071-9059-5180ebe557f0€49.00€0.67matched
78capture01a19de9-41c1-7696-a0a1-9cad22e1907c€15.00€0.26matched
79capture01a19de9-43b2-756e-8e50-e35c24cdd403€35.00€0.50matched
80capture01a19de9-4723-76dd-9d91-e76c13138b8a€15.00€0.26matched
81capture01a19de9-545c-754e-9694-7a4084348ad9€24.00€0.37matched
82capture01a19de9-56a7-7720-95f6-9465d6a216fd€24.00€0.37matched
83capture01a19de9-56b4-70be-b13b-4b17b8450010€15.00€0.26matched
84capture01a19de9-9922-77ea-a636-2c7e3a96c548€9.00€0.19matched
85capture01a19de9-a316-71ef-b897-36ee1c42d6aa€24.00€0.37matched
86capture01a19de9-b870-7ecf-9721-cc339e7df415€49.00€0.67matched
87capture01a19dea-1260-7928-a406-be5928f452df€15.00€0.26matched
88capture01a19dea-18a0-70bb-a7ed-272ec706cbc6€9.00€0.19matched
89capture01a19dea-6def-713f-b9c0-e1dcfd177236€35.00€0.50matched
90capture01a19dea-6ea0-7f83-aa79-b924206bfab5€49.00€0.67matched
91capture01a19dea-84b5-7ddd-a635-b6e2939bf392€24.00€0.37matched
92capture01a19dea-85a5-78fc-bac9-efa1eb8ecda0€15.00€0.26matched
93capture01a19dea-8f75-7c2a-b147-4c1050278f22€15.00€0.26matched
94capture01a19dea-94ac-7aa7-9b91-028469e83117€15.00€0.26matched
95capture01a19dea-ac9f-7f33-8678-5ec980dca718€49.00€0.67matched
96capture01a19dea-ae57-7fdf-8351-b88040d02131€15.00€0.26matched
97capture01a19dea-ca08-7a0a-9390-a1d1d214316b€24.00€0.37matched
98refund01a19dea-cade-7986-8ca9-6f79f8423684-€14.00€0.00matched
99capture01a19dea-ce21-7cf3-867c-1fefd72e24f8€24.00€0.37matched
100capture01a19dea-e2d2-783a-89c7-991bbd991943€35.00€0.50matched
101refund01a19dea-ece8-79aa-9904-e9d8f69c33f9-€13.00€0.00matched
102capture01a19deb-13ea-7986-bc89-55495c577ac2€49.00€0.67matched
103capture01a19deb-1945-7e97-9fbb-4c0e8016cde1€15.00€0.26matched
104capture01a19deb-28c0-77ae-9168-d34c0fc1937b€9.00€0.19matched
105capture01a19deb-34eb-70e9-8d74-47d7f519acbf€24.00€0.37matched