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

Gross

€2,677.00

PSP fee

€41.86

Net to the bank

€2,635.14

Settlement journal

#396606

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ab6e-798f-7025-acbd-1d3f02558e29 is already settled by stl_EUR_2989795 line 87
  • duplicate linethe file lists it twicecapture:01a1ab6f-3230-7949-b9b3-c6d022758b60 is already settled by stl_EUR_2989795 line 99
  • fee differencethe fee is not the contract feethe fee is 40, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 42, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
LineKindReferenceGrossFeeStatus
47capture01a1ab6a-50bc-7c78-a662-63b8bb236775€24.00€0.40fee difference
50capture01a1ab6a-c17e-7aa5-b0fb-00f54718925e€24.00€0.42fee difference
52capture01a1ab6a-f5a0-7185-99ea-cc7371a2c287€35.00€0.52fee difference
75capture01a1ab6d-15fc-7167-98bf-123062f36236€49.00€0.70fee difference
88capture01a1ab6e-96ca-7682-9c39-d0d825a139de€24.00€0.37duplicate line
100capture01a1ab6f-324e-76eb-8a54-cb6caef8e1df€9.00€0.19duplicate line
1capture01a1ab5e-a866-7bbd-9c9c-883fef69a077€15.00€0.26matched
2capture01a1ab66-c988-7ef6-9453-c5c2936ca0da€9.00€0.19matched
3capture01a1ab66-d3cc-7121-9949-c1b97cf3918c€15.00€0.26matched
4capture01a1ab66-d567-75fc-b83e-40d2809980ad€15.00€0.26matched
5capture01a1ab66-f797-7eb2-ae93-e0254361a6dd€49.00€0.67matched
6capture01a1ab67-07a4-7725-8e1a-7a79f9ab280e€15.00€0.26matched
7refund01a1ab67-1944-77c4-9c03-e8b2cd886007-€4.00€0.00matched
8capture01a1ab67-4e57-727d-bde4-1e2b6620261c€49.00€0.67matched
9capture01a1ab67-893b-7c20-a9ec-69bb73043964€24.00€0.37matched
10capture01a1ab67-94dd-7e58-8c3a-a57f45c7bef1€9.00€0.19matched
11capture01a1ab67-9b9c-7062-84eb-286f849fd513€24.00€0.37matched
12capture01a1ab67-a059-7ec2-af10-6674fbaa6d15€9.00€0.19matched
13capture01a1ab67-b8fb-79d7-8df1-dd8d334a4bfa€24.00€0.37matched
14capture01a1ab67-bb4e-799b-96c1-e5672aad195c€9.00€0.19matched
15capture01a1ab67-bcae-7dda-b298-d25306647c7f€15.00€0.26matched
16capture01a1ab67-c1f6-7773-b7d5-dd2445aa1346€24.00€0.37matched
17capture01a1ab67-da98-7fc1-b637-d6ca405f2542€15.00€0.26matched
18capture01a1ab68-010e-73f7-a499-d6a31b8cfd62€35.00€0.50matched
19capture01a1ab68-2cf2-78b0-9afc-17835ae50e09€49.00€0.67matched
20capture01a1ab68-310b-750e-b050-3d73c5e00851€49.00€0.67matched
21capture01a1ab68-6af7-7cc3-9859-72f9838c70ec€9.00€0.19matched
22capture01a1ab68-716a-795a-95d8-84e5e239dc04€35.00€0.50matched
23capture01a1ab68-94d9-72e9-89e8-21e50df1f476€24.00€0.37matched
24capture01a1ab68-a449-7751-ba30-e830c9c4e089€24.00€0.37matched
25capture01a1ab68-a9fb-722f-80c3-e65ae93a5852€24.00€0.37matched
26capture01a1ab68-ec92-7da9-ab10-7329ed561061€15.00€0.26matched
27capture01a1ab68-f1a9-749c-bc87-04d856cdcb1f€35.00€0.50matched
28refund01a1ab69-242a-7c92-9277-9a1c8045a021-€12.00€0.00matched
29capture01a1ab69-2bc6-7115-b0dd-fc768e8fcc24€24.00€0.37matched
30capture01a1ab69-46f7-7ded-accd-d9cf9c9aed45€24.00€0.37matched
31capture01a1ab69-47bb-7c8d-8aa1-546e7923a62e€9.00€0.19matched
32capture01a1ab69-5566-7ed9-99e4-4914e5b7e330€24.00€0.37matched
33capture01a1ab69-6059-7ed9-9114-4891dd1c9135€49.00€0.67matched
34capture01a1ab69-77cc-76a9-8586-f67ff3183299€24.00€0.37matched
35capture01a1ab69-7a4e-7b9a-bd3a-b7b2eba85df2€9.00€0.19matched
36capture01a1ab69-7baf-7e38-b5cb-3fb2799b7eff€9.00€0.19matched
37capture01a1ab69-9586-7048-aed5-cf120238d9e4€9.00€0.19matched
38capture01a1ab69-b021-78f8-9e07-59d4bde2a296€24.00€0.37matched
39refund01a1ab69-c3bf-7f3b-a538-acee4948798b-€19.00€0.00matched
40capture01a1ab69-d072-7928-8dae-9e90ee4027fa€24.00€0.37matched
41capture01a1ab69-de22-705c-b807-9a09773e3653€9.00€0.19matched
42capture01a1ab6a-195b-7887-984a-5dd8bc2b29f6€15.00€0.26matched
43capture01a1ab6a-2cbc-788a-8291-cb533e9786b3€15.00€0.26matched
44capture01a1ab6a-3ac8-7889-8e27-93fbc4a31a1a€49.00€0.67matched
45capture01a1ab6a-3b33-75ce-8019-e8a4510eca2f€24.00€0.37matched
46capture01a1ab6a-587c-701f-9e45-0f92f5deff04€24.00€0.37matched
48capture01a1ab6a-7754-7f5f-81d3-f7cfe9d66f4f€49.00€0.67matched
49capture01a1ab6a-a3be-76bd-8ed0-b5e80c2046dc€49.00€0.67matched
51capture01a1ab6a-f53a-7e82-a8ac-9d82737b7d52€15.00€0.26matched
53capture01a1ab6b-0bad-70bf-a280-bad7d4fd6fee€15.00€0.26matched
54capture01a1ab6b-3f79-7472-b2a0-0483e6c65f74€15.00€0.26matched
55capture01a1ab6b-4467-7929-9664-6d6b334f7dbf€49.00€0.67matched
56capture01a1ab6b-44a7-76bd-88e5-2dc8309f7a67€24.00€0.37matched
57capture01a1ab6b-4ea5-7182-af2f-2a2e94c29f38€15.00€0.26matched
58capture01a1ab6b-5802-7f9d-9af7-7311167594f4€49.00€0.67matched
59capture01a1ab6b-796b-78a1-90ce-7fb502badcdd€9.00€0.19matched
60capture01a1ab6b-8a6d-788b-b7c9-3770fd747d0f€15.00€0.26matched
61capture01a1ab6b-bd83-74f0-886f-15346af3465c€24.00€0.37matched
62capture01a1ab6b-dd44-71b6-98c6-1603830662db€9.00€0.19matched
63capture01a1ab6b-ebab-7905-894c-dd8d4111f658€15.00€0.26matched
64capture01a1ab6b-f78e-74f6-8114-b42cff58d8b1€49.00€0.67matched
65capture01a1ab6c-11da-7889-97d8-58ab1279948e€24.00€0.37matched
66capture01a1ab6c-1053-7950-beca-65871300469a€24.00€0.37matched
67refund01a1ab6c-1663-739b-927b-67f6a7efe541-€15.00€0.00matched
68capture01a1ab6c-5143-7cdf-9e47-b07d2d7156c5€49.00€0.67matched
69refund01a1ab6c-5bf9-7923-b8cf-7a787642ca95-€12.00€0.00matched
70capture01a1ab6c-7506-70b8-a5a1-1b00b99c1305€24.00€0.37matched
71capture01a1ab6c-bb95-7640-9f95-b6173a43f22d€24.00€0.37matched
72capture01a1ab6c-c51f-702c-9c3c-8aa285dd6fcf€49.00€0.67matched
73capture01a1ab6c-e0df-7c62-84bf-1d9b185a1efa€15.00€0.26matched
74capture01a1ab6c-fd90-7bfa-a7bd-d18cb4ac38d9€35.00€0.50matched
76capture01a1ab6d-86ac-7c89-8c8e-6010de8901c8€49.00€0.67matched
77capture01a1ab6d-8c93-72bb-ad9a-0c5d189bc17b€49.00€0.67matched
78capture01a1ab6d-8cee-7989-9d22-3d639bbbba12€24.00€0.37matched
79capture01a1ab6d-8c74-7c80-b2a1-0aa41f6bd648€15.00€0.26matched
80capture01a1ab6d-a9b2-7f4b-8656-b1620c16a693€35.00€0.50matched
81capture01a1ab6d-cccb-7d11-b752-454a9aaec89e€24.00€0.37matched
82refund01a1ab6d-d7b2-79a2-b7d3-b6a7647f677f-€17.00€0.00matched
83capture01a1ab6e-191d-7012-96a1-0d182d6428c0€9.00€0.19matched
84capture01a1ab6e-3060-711a-b65d-f24bf7ed5a45€15.00€0.26matched
85capture01a1ab6e-31ae-7877-97c5-36e6af7f94e4€49.00€0.67matched
86capture01a1ab6e-3d41-74ea-a9a3-f1eb99a33cd5€49.00€0.67matched
87capture01a1ab6e-96ca-7682-9c39-d0d825a139de€24.00€0.37matched
89capture01a1ab6e-9a77-7aa9-8f19-9278b07e4735€35.00€0.50matched
90capture01a1ab6e-a177-7bc4-a7c9-9f6242695554€49.00€0.67matched
91capture01a1ab6e-ae6c-78a5-839c-cbb81f9dafe5€49.00€0.67matched
92capture01a1ab6e-d98e-74c5-9271-2ed9049be9c4€49.00€0.67matched
93capture01a1ab6e-ea3c-7fc9-ae96-7b6fb003e13f€24.00€0.37matched
94capture01a1ab6e-f15a-7102-bf68-c51b3ac24014€35.00€0.50matched
95capture01a1ab6e-f9ad-71cc-9aeb-ac29f5ba07f6€15.00€0.26matched
96capture01a1ab6f-0266-7d6c-ba44-bd4f8d72f028€24.00€0.37matched
97capture01a1ab6f-176a-7770-ad6b-0f2366d4b3ad€49.00€0.67matched
98capture01a1ab6f-22fc-72b0-be49-0cbac01632dd€49.00€0.67matched
99capture01a1ab6f-324e-76eb-8a54-cb6caef8e1df€9.00€0.19matched
101capture01a1ab6f-33da-7d60-a7a6-d11f202e1cc4€9.00€0.19matched
102capture01a1ab6f-4324-746e-b2fb-7fa464d0eaff€49.00€0.67matched
103capture01a1ab6f-4c5c-71fc-83c9-05a15c1a5e3b€9.00€0.19matched
104refund01a1ab6f-695f-7c74-b34d-9f80108e1f90-€9.00€0.00matched
105capture01a1ab6f-6eb4-772b-bd84-c0cc521c671f€15.00€0.26matched
106capture01a1ab6f-77c4-7a66-a508-202396cfaf26€35.00€0.50matched
107capture01a1ab6f-7ef7-7319-8787-5a8d0007c31d€24.00€0.37matched
108capture01a1ab6f-b60e-7510-aa52-aff0b18f5129€9.00€0.19matched
109capture01a1ab6f-c3a2-7656-b106-dc1e1aa2bedb€35.00€0.50matched
110capture01a1ab6f-cbaa-728b-8c65-045861efa01e€24.00€0.37matched
111capture01a1ab6f-d3a4-7a09-947a-1fd7253c0ede€9.00€0.19matched
112capture01a1ab6f-e221-7304-b11c-152a00e230c7€24.00€0.37matched