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, 07:00

Gross

€3,149.00

PSP fee

€51.11

Net to the bank

€3,097.89

Settlement journal

#411802

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1afae-06a6-7044-be01-0b1296780c05 is already settled by stl_EUR_2989914 line 92
LineKindReferenceGrossFeeStatus
93capture01a1afae-06c8-781c-927b-0ae19fb4763c€49.00€0.67duplicate line
1capture01a1afa3-314e-75ea-bb12-fc7d9f924ef0€9.00€0.19matched
2refund01a1afa3-7f3f-7679-9d9d-929f8cdf063d-€26.00€0.00matched
3capture01a1afa8-3ca8-7f44-b6c1-954299d7624f€9.00€0.19matched
4capture01a1afa8-425c-777e-a1a4-badd6dac6f53€24.00€0.37matched
5capture01a1afa8-461d-7777-8cca-2fb3fad71655€15.00€0.26matched
6capture01a1afa8-4956-777c-8a8c-1eb3981fdc17€15.00€0.26matched
7capture01a1afa8-68ba-7a34-8e77-bb267d4fecbc€49.00€0.67matched
8capture01a1afa8-7366-72be-b7fb-ecae7d9d0323€9.00€0.19matched
9capture01a1afa8-a1e9-7d1f-b745-658dc375354b€24.00€0.37matched
10capture01a1afa8-a895-7388-8449-b74ecf88c0e8€9.00€0.19matched
11capture01a1afa8-b458-7e22-8dc9-1e6c8b3a0acb€24.00€0.37matched
12capture01a1afa8-bbba-733c-a3db-cc923389bcf8€24.00€0.37matched
13capture01a1afa8-ebe0-799b-8161-2dfad55be363€15.00€0.26matched
14capture01a1afa8-f3a6-7175-befd-27b7d17bd53d€35.00€0.50matched
15capture01a1afa8-f539-7003-b525-14f31d09c26c€9.00€0.19matched
16capture01a1afa9-555f-7d3e-af72-5275f09069b9€24.00€0.37matched
17capture01a1afa9-58ac-789c-a7b8-00c5ab42a395€15.00€0.26matched
18capture01a1afa9-5b88-79c2-884b-a6a60a5ff173€49.00€0.67matched
19capture01a1afa9-5e00-753b-955e-140db2e8e5c6€24.00€0.37matched
20capture01a1afa9-67b0-7548-8aad-8d0e0d6535f6€15.00€0.26matched
21capture01a1afa9-7c18-7cfb-98a3-6f26560237d0€15.00€0.26matched
22capture01a1afa9-8f8d-7bc7-bb04-cc5c84e18bdd€35.00€0.50matched
23capture01a1afa9-95d6-7e20-95aa-1f33739c9c19€35.00€0.50matched
24capture01a1afa9-98ac-7ffa-8190-0dd4196f79e2€24.00€0.37matched
25capture01a1afa9-cf57-70d0-8608-98b0fb7982bd€9.00€0.19matched
26capture01a1afa9-d649-7ee1-9577-a73081e615a2€15.00€0.26matched
27capture01a1afaa-296c-7a1d-9cf3-a8b22f267131€49.00€0.67matched
28capture01a1afaa-4b05-7f52-989b-10385fb0958d€9.00€0.19matched
29capture01a1afaa-7fba-7bc6-ac37-55a5417874e3€9.00€0.19matched
30capture01a1afaa-94c1-73cf-befe-f3ac2c07e32a€24.00€0.37matched
31capture01a1afaa-a74f-7b2d-977b-aff83c008c35€49.00€0.67matched
32capture01a1afaa-b6c8-786d-bbd9-885f4d65689a€9.00€0.19matched
33capture01a1afaa-bebf-79ed-a33f-cfdd01c9d9e8€24.00€0.37matched
34capture01a1afaa-c048-7db1-a4e1-ab397f594916€9.00€0.19matched
35capture01a1afaa-cd63-76e3-84f4-503b471a3b5e€24.00€0.37matched
36capture01a1afaa-d3e0-7084-b639-fc0962e5e540€15.00€0.26matched
37capture01a1afaa-f25b-7f26-a8a0-12e1609d5196€35.00€0.50matched
38capture01a1afab-0aa7-71bf-a432-f28e5519ca3f€35.00€0.50matched
39refund01a1afab-1641-71a8-84e9-41bca42faa60-€14.00€0.00matched
40capture01a1afab-45c0-70b2-bd7b-fffadd016993€15.00€0.26matched
41capture01a1afab-4e6c-78e1-8cd5-a16bb5ffb101€9.00€0.19matched
42capture01a1afab-4f63-7251-909b-70f19d5a9d9e€24.00€0.37matched
43capture01a1afab-52b0-73fb-9b7f-0a7e6f39eee3€9.00€0.19matched
44capture01a1afab-6112-74ed-af7f-548223b68582€49.00€0.67matched
45capture01a1afab-7818-71bf-a7b6-3af5562be13e€49.00€0.67matched
46capture01a1afab-84a3-797d-a017-22c8d65206a8€15.00€0.26matched
47capture01a1afab-8e40-7aaf-bc3a-811cf4b88b46€49.00€0.67matched
48capture01a1afab-9d8f-7c07-81cf-1a3aca2f01f6€24.00€0.37matched
49capture01a1afab-9f9c-7051-8d67-953a425483b6€15.00€0.26matched
50capture01a1afab-a3d4-7dfc-b9f5-225f1f9884f9€24.00€0.37matched
51capture01a1afab-a52d-7bb6-91e6-58458518a86e€24.00€0.37matched
52capture01a1afab-aa23-7527-b888-6ce9da28deec€49.00€0.67matched
53refund01a1afab-ad5e-7da9-851f-7578817cda32-€14.00€0.00matched
54capture01a1afab-b943-75c2-b89f-a1a3ee83d1e6€49.00€0.67matched
55capture01a1afab-bd5f-725a-a689-4f37f4023744€35.00€0.50matched
56capture01a1afab-cf2e-7a00-b764-c394c9ce7e9d€15.00€0.26matched
57capture01a1afab-dfb0-7a91-b1a3-b51433d1c2dd€24.00€0.37matched
58refund01a1afab-ed08-7838-bf41-869759d35ceb-€13.00€0.00matched
59capture01a1afab-effc-7edc-8a1d-74b7d5d6857f€24.00€0.37matched
60capture01a1afac-011e-7fca-97c2-d9dd57cd8d22€24.00€0.37matched
61capture01a1afac-19dd-73f6-99ad-7500604df83e€24.00€0.37matched
62capture01a1afac-1d27-7033-81ad-8018992a9fa6€24.00€0.37matched
63capture01a1afac-220e-760d-9b76-4830307e29d3€9.00€0.19matched
64capture01a1afac-27e9-777a-9fd2-f2cbf72e8265€9.00€0.19matched
65capture01a1afac-316c-7922-b3e2-3293fbb6af8b€35.00€0.50matched
66capture01a1afac-3956-763d-9f5a-032e361e47a3€49.00€0.67matched
67capture01a1afac-39a9-7fbf-8980-08ade1e85a6a€49.00€0.67matched
68capture01a1afac-4ae7-7c45-98f3-2f543b61561e€24.00€0.37matched
69capture01a1afac-50e1-770e-99a0-1cd51daafe84€15.00€0.26matched
70capture01a1afac-751a-7903-a586-43a84cd46b78€24.00€0.37matched
71capture01a1afac-a991-75e4-b801-c31f8fd3c2fa€35.00€0.50matched
72capture01a1afac-b0c2-76e1-b9a5-945570e48d5d€15.00€0.26matched
73capture01a1afac-bcb0-7d73-a769-a859beb367ae€9.00€0.19matched
74capture01a1afac-e65a-7a0a-806d-2a411d0a5f3b€9.00€0.19matched
75capture01a1afac-ea09-79d6-b75b-1a17822ebc93€49.00€0.67matched
76refund01a1afac-f628-7509-95ff-e317b4c448d3-€34.00€0.00matched
77capture01a1afad-02fc-7e02-badc-37e03bbb955f€9.00€0.19matched
78capture01a1afad-39db-7453-8342-41657fb84a92€9.00€0.19matched
79capture01a1afad-4ff1-7142-824a-4553d445ac6b€9.00€0.19matched
80capture01a1afad-56e1-7a60-bc4c-f0daa6cf88a0€49.00€0.67matched
81capture01a1afad-5dfc-788b-8d85-44f0498ed7ed€9.00€0.19matched
82capture01a1afad-967e-70e5-ba48-827c122cfddc€9.00€0.19matched
83capture01a1afad-9ecd-784f-9691-72f6e57b7b95€15.00€0.26matched
84capture01a1afad-bb47-7768-a384-a7eb1c467b2b€49.00€0.67matched
85capture01a1afad-d6d3-7641-b933-0b5fa95b9c83€24.00€0.37matched
86capture01a1afad-f1e0-7f03-98ff-69d40a2a7c1a€15.00€0.26matched
87capture01a1afad-ef8c-7819-b0f7-e8a4e24eb0e1€15.00€0.26matched
88capture01a1afad-f399-7725-ae2c-7e93eb14dc69€49.00€0.67matched
89capture01a1afae-013d-799a-ad02-4c86d9ac70d0€49.00€0.67matched
90capture01a1afae-013f-7480-84c7-1f8d29d2e85c€35.00€0.50matched
91capture01a1afae-0650-7e28-99dd-9bbd84e1e7d5€24.00€0.37matched
92capture01a1afae-06c8-781c-927b-0ae19fb4763c€49.00€0.67matched
94refund01a1afae-06d4-7061-b406-d221299065cc-€7.00€0.00matched
95capture01a1afae-1a0a-7150-9437-327cb8a05bd4€35.00€0.50matched
96capture01a1afae-1e73-7ee5-a69b-1fb598320007€35.00€0.50matched
97capture01a1afae-2c1d-7835-b8c0-28d40984d720€24.00€0.37matched
98capture01a1afae-2fec-79fb-895f-f326720ceeff€9.00€0.19matched
99capture01a1afae-2ff2-72fb-8f9a-5a1a375d62cd€35.00€0.50matched
100capture01a1afae-328a-7671-8d09-0e21310980c1€9.00€0.19matched
101refund01a1afae-6885-7756-b33b-e3c2fd3eb148-€10.00€0.00matched
102refund01a1afae-65d1-7a7f-8970-a2d85e04b986-€13.00€0.00matched
103capture01a1afae-744e-7525-bcf8-7367edebe7d1€15.00€0.26matched
104capture01a1afae-80b1-7758-a045-2fa61786f3e5€49.00€0.67matched
105capture01a1afae-8f3a-7a16-acd1-0370ce71caab€9.00€0.19matched
106capture01a1afae-9d8d-7113-87f7-32ab6c7048c9€9.00€0.19matched
107capture01a1afae-d105-7f45-97ab-58395b8f4056€49.00€0.67matched
108capture01a1afae-da8e-71b7-9605-995277ee6491€24.00€0.37matched
109capture01a1afae-dcf1-79c1-a140-df8f5e221a58€9.00€0.19matched
110capture01a1afae-e5e9-7192-8e23-a1883cf81df2€49.00€0.67matched
111capture01a1afae-ffa3-729f-8137-66b0dd37f9d8€9.00€0.19matched
112refund01a1afaf-0692-7146-a32c-c3936d9a3425-€4.00€0.00matched
113capture01a1afaf-16e9-783f-8980-813814583bbd€49.00€0.67matched
114capture01a1afaf-17b6-734a-93ce-ccbc9db80532€49.00€0.67matched
115capture01a1afaf-4451-7789-92dd-1e69af9ceb96€9.00€0.19matched
116capture01a1afaf-7cdc-7513-b03d-db4abe5e7ddc€35.00€0.50matched
117capture01a1afaf-9030-76d7-a728-daac4c701749€15.00€0.26matched
118capture01a1afaf-b5ac-7c0d-a227-5e26fa31b358€24.00€0.37matched
119capture01a1afaf-be21-7d98-acaa-d8b644b293c8€24.00€0.37matched
120capture01a1afaf-c207-71a7-960e-3e1cee25105f€9.00€0.19matched
121capture01a1afaf-c668-73e6-ae22-5ea0cd43d686€9.00€0.19matched
122capture01a1afaf-e653-72da-8115-d5b115e0168e€49.00€0.67matched
123capture01a1afaf-f85d-70b4-a73f-697c8c385b6c€35.00€0.50matched
124capture01a1afb0-0d7e-76c3-a522-c4db2c75e1f2€24.00€0.37matched
125capture01a1afb0-0ebd-7108-9c58-7181a88796af€49.00€0.67matched
126capture01a1afb0-3d80-78ed-b8e6-a1bc3197474f€15.00€0.26matched
127capture01a1afb0-42a4-7153-a637-4784ed915ad3€49.00€0.67matched
128refund01a1afb0-5109-72bf-97bf-b124b7d61ec0-€13.00€0.00matched
129capture01a1afb0-5131-7e6d-bc62-d0e836155e3a€49.00€0.67matched
130capture01a1afb0-5c4d-7910-8779-ab253687fb61€49.00€0.67matched
131capture01a1afb0-689a-7033-ac78-dc680004dbdf€15.00€0.26matched
132capture01a1afb0-6b20-7ed9-b1f6-a81f8f80446c€9.00€0.19matched
133capture01a1afb0-73f7-70fc-9ea5-9cdbee41aeaa€15.00€0.26matched
134capture01a1afb0-8229-76d4-8f5a-78d8c68c7abe€24.00€0.37matched
135capture01a1afb0-968e-7cc8-8539-b3e38e052684€9.00€0.19matched
136capture01a1afb0-995a-7cae-958b-849d43b328aa€35.00€0.50matched
137refund01a1afb0-b83f-7ecb-987b-00e55e00a51e-€25.00€0.00matched
138capture01a1afb0-bbb4-7b1f-b019-a70b7d98758e€24.00€0.37matched
139capture01a1afb0-c0f9-7ed8-a58c-698a3ff862a0€24.00€0.37matched
140capture01a1afb0-cb51-7070-9548-7394435ff8af€24.00€0.37matched
141refund01a1afb0-d9f4-7c55-88bf-314c821d2d33-€13.00€0.00matched
142refund01a1afb0-e11c-7f2e-9241-69fff9dd5dd3-€22.00€0.00matched
143capture01a1afb1-0df2-7440-bd74-f341162dc811€15.00€0.26matched
144capture01a1afb1-2053-7014-879a-4ec102113a05€15.00€0.26matched
145capture01a1afb1-5a0c-7633-8ee4-eb11d74642a6€35.00€0.50matched
146capture01a1afb1-5a38-7b69-9d29-c38c6e1db564€9.00€0.19matched