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

4 Nov, 02:00

Gross

€2,962.00

PSP fee

€46.87

Net to the bank

€2,915.13

Settlement journal

#371350

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a44b-7b3a-7223-be0f-a2b6db92b112 is already settled by stl_EUR_2989596 line 41
  • missing linein the books, not in the filecapture:01a1a44f-45ba-7ab5-a1be-2b4318185446 is in no file
  • missing linein the books, not in the filecapture:01a1a44d-3937-70fe-bd80-c632ba000d3d is in no file
LineKindReferenceGrossFeeStatus
42capture01a1a44b-97c5-7972-8184-90100ab658f4€49.00€0.67duplicate line
1capture01a1a440-20bf-750f-b07b-b8507b57c990€15.00€0.26matched
2capture01a1a441-d54b-75ee-abf8-e06a765bda62€35.00€0.50matched
3capture01a1a443-f36e-704f-88d5-95d518f3985d€9.00€0.19matched
4capture01a1a448-e32c-7d05-8c74-6819808d58e7€15.00€0.26matched
5capture01a1a448-f472-7d47-a7c8-009e50fcc7f3€15.00€0.26matched
6capture01a1a448-f6bb-76cf-b529-5bfce7589437€15.00€0.26matched
7capture01a1a449-09f7-7380-994e-88478bc4d527€35.00€0.50matched
8capture01a1a449-1636-71ee-9dba-eef2c364883e€24.00€0.37matched
9refund01a1a449-3af3-75d8-a185-76e6aa050aeb-€14.00€0.00matched
10capture01a1a449-5e8f-7036-8b39-b7ba5fb67aad€9.00€0.19matched
11capture01a1a449-88df-7c9a-b687-0b629078fec6€49.00€0.67matched
12capture01a1a449-98e1-7a42-be60-7e6e85d57d70€49.00€0.67matched
13capture01a1a449-b189-7f5f-b7ac-d262755d2331€15.00€0.26matched
14capture01a1a449-b25b-76ac-a6d2-6913c9779756€24.00€0.37matched
15capture01a1a449-b5a3-7a37-bb5e-e02fcecb20cc€15.00€0.26matched
16capture01a1a449-bf0b-75b2-8378-4765779be3d3€24.00€0.37matched
17capture01a1a44a-0720-791d-a8d3-dd436b845565€24.00€0.37matched
18capture01a1a44a-0f12-7840-a66b-6b251d3686e6€9.00€0.19matched
19refund01a1a44a-1cb0-730e-a467-614533075318-€12.00€0.00matched
20capture01a1a44a-47d1-73c5-a875-5627a2bf2c24€35.00€0.50matched
21capture01a1a44a-4e3b-7a24-a6d8-9b4c43d7a19f€15.00€0.26matched
22capture01a1a44a-69ad-7053-8519-54966a1a23e4€15.00€0.26matched
23capture01a1a44a-9158-7d14-bce4-411d2e030002€9.00€0.19matched
24capture01a1a44a-9169-74d8-b734-019adfa5c715€9.00€0.19matched
25capture01a1a44a-ba63-7e73-ae16-13f0b449686e€15.00€0.26matched
26capture01a1a44a-ca75-7f1b-bd6d-81841d671b03€49.00€0.67matched
27capture01a1a44a-d497-7739-802a-edff71c45b37€49.00€0.67matched
28capture01a1a44a-d661-70d7-b664-133a0e9ffa71€24.00€0.37matched
29capture01a1a44a-e376-7dc3-9108-4c33f01b8111€15.00€0.26matched
30capture01a1a44a-f602-7066-950b-f5b7afae87a4€49.00€0.67matched
31capture01a1a44a-f488-7481-ac79-a304e30af0e3€15.00€0.26matched
32capture01a1a44b-05cc-790b-b8df-a44e1c554dee€9.00€0.19matched
33capture01a1a44b-1629-70ab-a00f-c86073388bae€49.00€0.67matched
34refund01a1a44b-231f-796e-92ce-d521961f2bdf-€12.00€0.00matched
35capture01a1a44b-51aa-7f7a-94f4-d48d6fece373€35.00€0.50matched
36capture01a1a44b-6362-7130-9177-31a26198cd4b€15.00€0.26matched
37capture01a1a44b-7c3e-7dbd-a48c-32b9308fe4c0€35.00€0.50matched
38capture01a1a44b-7e30-7dc9-ac8b-bc3fba205fd1€49.00€0.67matched
39capture01a1a44b-8222-7c8f-8a32-4f60ee9a82e1€24.00€0.37matched
40refund01a1a44b-9080-7074-9435-4f749b30e5ea-€12.00€0.00matched
41capture01a1a44b-97c5-7972-8184-90100ab658f4€49.00€0.67matched
43capture01a1a44b-c602-7d40-a0e6-62e6eeb00c51€15.00€0.26matched
44capture01a1a44b-c723-7ef6-bea7-5ae2565a7ec0€15.00€0.26matched
45capture01a1a44b-ef0c-79d4-8028-d49ceb18e5b0€9.00€0.19matched
46capture01a1a44b-fa04-707a-8925-697d056e0f58€49.00€0.67matched
47capture01a1a44b-ffc0-71ee-a4e5-069febd956b5€24.00€0.37matched
48capture01a1a44c-03bc-763a-84d6-a72e5a59c8e1€24.00€0.37matched
49capture01a1a44c-2ae2-7275-bb51-f1e3707f8246€9.00€0.19matched
50capture01a1a44c-3680-76b7-8a07-264fa759569d€15.00€0.26matched
51refund01a1a44c-3b80-7c0d-bd14-8ffa5d2c96aa-€5.00€0.00matched
52capture01a1a44c-5f10-739a-87fe-07de8db5516c€49.00€0.67matched
53capture01a1a44c-690c-7cbf-97a3-71979fb0bfdc€24.00€0.37matched
54capture01a1a44c-7eff-76ae-a8db-f83100677339€9.00€0.19matched
55capture01a1a44c-8e5b-7eef-8564-91a802d6a68a€49.00€0.67matched
56capture01a1a44c-a6f2-7991-8a94-4dc1bc749390€49.00€0.67matched
57capture01a1a44c-d267-7cdb-a183-db8ad16eb71b€24.00€0.37matched
58capture01a1a44c-d800-7d37-8e76-7daecf1f6464€49.00€0.67matched
59capture01a1a44c-dc32-7001-be72-7817299c0f93€15.00€0.26matched
60capture01a1a44c-ddf7-70a3-aca5-a20700354cdd€35.00€0.50matched
61capture01a1a44c-e4a4-7134-8488-ae7d89bad7df€9.00€0.19matched
62capture01a1a44c-ec59-72d8-b7b8-91fc868ed4f7€15.00€0.26matched
63capture01a1a44d-0a80-76c8-8720-e7d98fe986b2€9.00€0.19matched
64capture01a1a44d-0d70-728e-b3c7-2a3c7f14209d€24.00€0.37matched
65capture01a1a44d-15ce-7478-91f5-92b1a41c2e87€35.00€0.50matched
66capture01a1a44d-2006-79f5-96da-91f78e2e52c4€15.00€0.26matched
67capture01a1a44d-281e-70e8-8c8e-4e9f54b4d783€49.00€0.67matched
68refund01a1a44d-39a1-79e2-aaea-94aba316fbe6-€25.00€0.00matched
69capture01a1a44d-459b-7289-b9e2-c48f8aa1b114€9.00€0.19matched
70refund01a1a44d-71b2-71e7-a5ce-9d9c90f1ebce-€7.00€0.00matched
71capture01a1a44d-7298-780d-9b8e-30e9a12141dd€9.00€0.19matched
72capture01a1a44d-7380-7e69-8dae-9f1ee57e1e4d€9.00€0.19matched
73capture01a1a44d-7889-75c0-b122-603abafab60b€9.00€0.19matched
74capture01a1a44d-8d60-7f81-bc09-4231261a64e7€24.00€0.37matched
75capture01a1a44d-9ee5-7696-8350-97da658e90a8€24.00€0.37matched
76capture01a1a44d-a03e-7a1f-a1af-9223b5909c9c€49.00€0.67matched
77capture01a1a44d-d5f9-7aad-a1a0-a9c688b56177€49.00€0.67matched
78capture01a1a44d-fd1f-7261-bbc9-e6a39923b4ba€49.00€0.67matched
79capture01a1a44e-07f6-7be2-b7b3-aaeba197c825€49.00€0.67matched
80capture01a1a44e-0837-7956-b127-ce055462c809€9.00€0.19matched
81capture01a1a44e-096a-7b9c-a23f-2784b692b8c3€49.00€0.67matched
82capture01a1a44e-0e81-71d2-bf4d-e6043f41fead€35.00€0.50matched
83capture01a1a44e-16ae-74e7-88f1-3698b51763aa€35.00€0.50matched
84capture01a1a44e-39f8-7d39-8e16-e35658db0259€35.00€0.50matched
85capture01a1a44e-53a1-757c-93fa-9be3468b8026€49.00€0.67matched
86capture01a1a44e-55fc-7975-bd9c-71829f1332c6€9.00€0.19matched
87capture01a1a44e-6b8a-7a3b-bc1e-d8f3a93db37e€9.00€0.19matched
88capture01a1a44e-8f2f-78d7-8fa5-b9efb264cd97€9.00€0.19matched
89capture01a1a44e-9d9c-7cdc-946f-4349bb688fb2€24.00€0.37matched
90capture01a1a44e-a643-7b74-9752-9abc7a6f06ca€35.00€0.50matched
91capture01a1a44e-a802-7d76-8664-ead8e9a51f24€15.00€0.26matched
92capture01a1a44e-ced8-73ca-a25d-5bb300a6c717€49.00€0.67matched
93capture01a1a44e-dc2d-7595-836f-076429b320fa€9.00€0.19matched
94capture01a1a44e-dd42-777d-be79-c8cd9a89ed16€24.00€0.37matched
95refund01a1a44f-1b82-770c-86b0-a11f95fdc8ec-€5.00€0.00matched
96capture01a1a44f-30e7-726b-85c7-a494a31e3a18€15.00€0.26matched
97capture01a1a44f-3737-7136-b31a-cf83a5cf5a8e€24.00€0.37matched
98capture01a1a44f-5fa3-78de-820c-fb4518156dfc€24.00€0.37matched
99capture01a1a44f-6b55-7ee8-90c4-e6161c3090ce€49.00€0.67matched
100capture01a1a44f-735b-7c9b-804e-e781ed5f9d61€9.00€0.19matched
101capture01a1a44f-9092-7174-a13a-23e0fb1c21ba€24.00€0.37matched
102refund01a1a44f-a82b-736e-af12-569edfe38802-€13.00€0.00matched
103capture01a1a44f-b08f-752b-b27d-ffc10ec8e7f3€9.00€0.19matched
104capture01a1a44f-eec9-72fe-909d-1d7e7ab001f2€35.00€0.50matched
105capture01a1a450-0010-7347-8f6a-5b089d47c86e€24.00€0.37matched
106capture01a1a450-00e9-7bbf-a680-a75eecbe528b€9.00€0.19matched
107capture01a1a450-2106-786b-bef7-b03825e30aa1€15.00€0.26matched
108capture01a1a450-2f01-7eee-bf21-7ad07721bed8€9.00€0.19matched
109capture01a1a450-583a-759f-b16d-897c19f3d2ab€24.00€0.37matched
110capture01a1a450-6454-7809-b53e-ad6c915db554€49.00€0.67matched
111capture01a1a450-7a41-74ec-ab06-c01bfe639d9e€9.00€0.19matched
112capture01a1a450-f0ab-7770-aaa0-c78921f5497d€49.00€0.67matched
113capture01a1a451-0c1a-77f1-8d54-ab6d57d94669€9.00€0.19matched
114capture01a1a451-21eb-7d06-a0b7-18d00a2c607f€24.00€0.37matched
115capture01a1a451-28dc-7671-9c8e-be01824da7e8€9.00€0.19matched
116capture01a1a451-2c6c-7df3-a981-1344ff498582€24.00€0.37matched
117capture01a1a451-5f54-75b9-808c-235bb2248658€24.00€0.37matched
118capture01a1a451-7638-79db-b204-4373865a5174€49.00€0.67matched
119capture01a1a451-7c41-72a7-b5eb-62c9a887c8dd€49.00€0.67matched
120capture01a1a451-839b-7c26-9e37-3c832c2d93ca€15.00€0.26matched
121capture01a1a451-9e89-70ba-91d2-815b1ed3f2ca€49.00€0.67matched
122capture01a1a451-aabf-7116-b510-d68dddb945ce€15.00€0.26matched
123capture01a1a451-aaf0-7631-8772-f15286255043€49.00€0.67matched
124capture01a1a451-b42b-7746-b9f5-eef2a66de50f€24.00€0.37matched
125capture01a1a451-b4b7-7156-b213-e35f30cf7343€35.00€0.50matched
126refund01a1a451-b4d2-7825-a468-97bd35ef0d11-€14.00€0.00matched
127capture01a1a451-ce90-7df9-8d8c-70e3c29a5d3d€35.00€0.50matched
128capture01a1a451-dc27-7c99-81e1-4ce5b36002fe€15.00€0.26matched
129capture01a1a451-df76-75a4-90eb-6e2fde123bc7€9.00€0.19matched
130refund01a1a451-e4c1-7a91-a2fc-bef2a8cefee9-€18.00€0.00matched