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

3 Nov, 23:00

Gross

€2,692.00

PSP fee

€43.98

Net to the bank

€2,648.02

Settlement journal

#369065

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a3a6-1fe2-74a2-949f-d43b7a469d0b is already settled by stl_EUR_2989578 line 32
  • duplicate linethe file lists it twicecapture:01a1a3a7-a921-771c-b954-9b6745c61230 is already settled by stl_EUR_2989578 line 65
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
LineKindReferenceGrossFeeStatus
33capture01a1a3a6-1ffa-72f4-9c08-461418d215a5€35.00€0.50duplicate line
66capture01a1a3a7-a93b-7224-b9ef-d7e5a434d8a3€15.00€0.26duplicate line
76capture01a1a3a8-ec5b-7927-a7bc-1c6ce88541b4€49.00€0.70fee difference
1capture01a1a39b-687e-7c2c-a3e7-d2b185ef7743€35.00€0.50matched
2capture01a1a39d-fe9d-7e06-972c-e9d0d77c7be1€24.00€0.37matched
3capture01a1a3a2-e55a-7fca-9f0c-a624831bfa60€9.00€0.19matched
4capture01a1a3a4-103c-775f-b287-d0ae6c0fede2€15.00€0.26matched
5capture01a1a3a4-1243-7ea0-9184-dd49fd0adc78€15.00€0.26matched
6refund01a1a3a4-2699-7cc7-8b21-07e6ad479c52-€20.00€0.00matched
7capture01a1a3a4-4ce2-7e72-9e42-70bf35cc6679€9.00€0.19matched
8capture01a1a3a4-5006-766c-9eb2-d58fe0524640€35.00€0.50matched
9capture01a1a3a4-a39e-742b-83b3-a7011668a1d8€24.00€0.37matched
10capture01a1a3a4-b7a4-70b4-ba22-fce74f005a08€24.00€0.37matched
11capture01a1a3a4-c94a-7534-9176-0879279a922f€35.00€0.50matched
12capture01a1a3a4-f22f-7d74-8e57-20febd2e9463€49.00€0.67matched
13capture01a1a3a5-0e4b-7ea0-8262-a95fc48229a7€9.00€0.19matched
14capture01a1a3a5-0f06-75a0-a70c-ec134360500a€35.00€0.50matched
15capture01a1a3a5-23a6-725b-8e09-25b82746e598€15.00€0.26matched
16capture01a1a3a5-44e5-7f72-82d0-cfc8e473cb8b€24.00€0.37matched
17capture01a1a3a5-4ec1-7f53-aa0a-741ae53f5352€15.00€0.26matched
18capture01a1a3a5-6927-7b65-98b1-bed0dd7525c5€49.00€0.67matched
19capture01a1a3a5-6c76-705c-a58d-df4c58e14b15€9.00€0.19matched
20capture01a1a3a5-75c4-7f9b-a489-f133f533395c€35.00€0.50matched
21capture01a1a3a5-7879-7c70-90aa-511f6f8d1f78€35.00€0.50matched
22capture01a1a3a5-7f60-7070-b84f-b2e58104e8ea€24.00€0.37matched
23capture01a1a3a5-8501-70d7-82dc-d9ee4bf6afdb€24.00€0.37matched
24capture01a1a3a5-a123-7cbb-8834-29fafe6358e5€15.00€0.26matched
25capture01a1a3a5-aba4-77d9-997c-94e029079805€9.00€0.19matched
26refund01a1a3a5-cc01-7dd5-84f2-53443084cb33-€13.00€0.00matched
27capture01a1a3a5-d8c7-7b3a-9b7d-125cea866793€49.00€0.67matched
28capture01a1a3a5-da1e-7933-9abd-fcbe5319f953€35.00€0.50matched
29refund01a1a3a5-dc38-7356-8dcb-1bfaae2b9f24-€14.00€0.00matched
30capture01a1a3a5-e1e0-7040-9cec-69dd23d71c75€9.00€0.19matched
31capture01a1a3a6-1534-7048-a6b7-19f5ba6b0d61€9.00€0.19matched
32capture01a1a3a6-1ffa-72f4-9c08-461418d215a5€35.00€0.50matched
34capture01a1a3a6-2887-7131-8056-1a38eda9c3dc€9.00€0.19matched
35capture01a1a3a6-2ecc-7fc1-9f88-d949397d6c8b€24.00€0.37matched
36capture01a1a3a6-3874-730b-91d8-c27a1ba1f3f8€9.00€0.19matched
37capture01a1a3a6-3bca-7cc7-87b3-e2e8167da601€49.00€0.67matched
38capture01a1a3a6-4f7a-7692-a4bb-c40c4b7f53b2€15.00€0.26matched
39capture01a1a3a6-540f-7e02-afb8-a5008499691c€35.00€0.50matched
40capture01a1a3a6-86b8-7643-a8af-89ae63ebc88c€9.00€0.19matched
41capture01a1a3a6-8dfb-7733-808b-b6d610130136€9.00€0.19matched
42capture01a1a3a6-97a4-7c27-a670-7c2b408df2eb€15.00€0.26matched
43refund01a1a3a6-aadd-7ca6-bcad-2c19282bea54-€10.00€0.00matched
44capture01a1a3a6-b81b-7da9-a59a-acf847d65d8f€9.00€0.19matched
45capture01a1a3a6-e248-7d4e-ac4c-b713a5ade720€15.00€0.26matched
46capture01a1a3a6-e7e0-76a7-b91b-685596402d53€9.00€0.19matched
47capture01a1a3a6-edda-7508-a217-7de341f65ed9€24.00€0.37matched
48capture01a1a3a6-f040-73f0-a036-05a4b8370c3c€15.00€0.26matched
49capture01a1a3a6-fac8-7ee9-a1c1-25d2707456de€49.00€0.67matched
50capture01a1a3a7-0756-7601-849f-6613a9410f46€15.00€0.26matched
51capture01a1a3a7-0837-7422-aec5-0b54afc8fc79€49.00€0.67matched
52capture01a1a3a7-0cde-7a4b-8c45-b88047473ebb€9.00€0.19matched
53capture01a1a3a7-34e1-71a0-b07f-ab3b2bd55896€35.00€0.50matched
54refund01a1a3a7-5065-7cd5-8f7a-e589700e424c-€7.00€0.00matched
55capture01a1a3a7-5503-7009-a443-bce0f7359a65€24.00€0.37matched
56capture01a1a3a7-53d4-74b8-8ed0-1c71e433d8fd€49.00€0.67matched
57capture01a1a3a7-625f-7c03-9cb8-1bb6d6107b19€35.00€0.50matched
58refund01a1a3a7-6554-7412-a827-dac6ab860edd-€34.00€0.00matched
59capture01a1a3a7-75b3-77ff-ac98-dace08e89aab€9.00€0.19matched
60capture01a1a3a7-7c7a-7e11-b0b7-01ba99ea6e57€24.00€0.37matched
61capture01a1a3a7-84d9-76db-8a42-90866cddb372€15.00€0.26matched
62capture01a1a3a7-8981-7ab4-9b1d-8527d8bffa40€9.00€0.19matched
63capture01a1a3a7-8d5b-79da-b852-f382ae20b859€35.00€0.50matched
64capture01a1a3a7-a475-788e-a52e-b5b01a0eae51€35.00€0.50matched
65capture01a1a3a7-a93b-7224-b9ef-d7e5a434d8a3€15.00€0.26matched
67capture01a1a3a7-b892-7e18-a55f-2173092025dd€35.00€0.50matched
68capture01a1a3a8-2620-744f-88f5-cd219b235f50€35.00€0.50matched
69capture01a1a3a8-37dc-7426-a5b1-c2327925997f€49.00€0.67matched
70capture01a1a3a8-467a-72cb-bb58-660cdb012a57€49.00€0.67matched
71capture01a1a3a8-56b1-7804-b774-70c86031119f€35.00€0.50matched
72capture01a1a3a8-7846-7133-8863-d75b71e06f12€49.00€0.67matched
73capture01a1a3a8-8d93-75b3-82e9-0b3cb19d0c96€15.00€0.26matched
74capture01a1a3a8-dc6b-7f82-86a3-25761d9a8978€35.00€0.50matched
75capture01a1a3a8-e43c-7977-84d7-0e63a216be42€9.00€0.19matched
77capture01a1a3a8-fe8d-7985-8e53-3db308860b5d€9.00€0.19matched
78capture01a1a3a9-0000-77da-9685-54af08881172€15.00€0.26matched
79capture01a1a3a9-0d1f-7f67-b84b-efe105df987b€9.00€0.19matched
80capture01a1a3a9-0f3f-758f-a46c-ec571cc0f338€9.00€0.19matched
81capture01a1a3a9-1170-76cd-97df-1536226d11eb€24.00€0.37matched
82capture01a1a3a9-24cc-7cdf-b511-1a4d7f712506€15.00€0.26matched
83capture01a1a3a9-2603-7833-864e-efbc8a0426fb€35.00€0.50matched
84capture01a1a3a9-2e46-78e4-8b80-9a5a79735e63€24.00€0.37matched
85capture01a1a3a9-5052-71ee-aa24-bdd1dbf5fca1€9.00€0.19matched
86refund01a1a3a9-6204-786c-aed3-dca6ddc512ce-€14.00€0.00matched
87capture01a1a3a9-96c2-7f79-9d1e-4ab11499de86€49.00€0.67matched
88capture01a1a3a9-a286-7749-9a43-d6f3fcdfbd85€15.00€0.26matched
89capture01a1a3a9-cb0d-7eae-a519-b977b118eaf5€24.00€0.37matched
90capture01a1a3a9-d0aa-739e-acb8-d5a9bbdd6e4f€49.00€0.67matched
91capture01a1a3a9-e3a1-71ce-b8c7-b99e89ff31dd€49.00€0.67matched
92capture01a1a3a9-eb2f-7d47-8e84-1ca41528eaf0€24.00€0.37matched
93capture01a1a3aa-042f-7834-b805-fd1a21923a0b€9.00€0.19matched
94refund01a1a3aa-0999-7105-8f7f-bc93558dfb72-€29.00€0.00matched
95capture01a1a3aa-0c69-7d8a-9af3-64e4d0a972ef€9.00€0.19matched
96capture01a1a3aa-13b8-7523-bda4-5f7c9eacedde€9.00€0.19matched
97capture01a1a3aa-17d7-713b-85ba-5b0995f65bb4€24.00€0.37matched
98capture01a1a3aa-19bd-7077-a17a-29d24615b8da€9.00€0.19matched
99capture01a1a3aa-1f90-7f64-bb7a-98f0ec5758b0€24.00€0.37matched
100capture01a1a3aa-2710-7d5e-aba2-8486135b2709€35.00€0.50matched
101capture01a1a3aa-2ab6-7f21-8098-4bf6c47b4829€9.00€0.19matched
102refund01a1a3aa-51dd-7daf-aa7a-890ca1755be2-€16.00€0.00matched
103capture01a1a3aa-745e-736c-b115-5cc1aebde61e€35.00€0.50matched
104capture01a1a3aa-7eb1-7d40-9b5a-faf02e33492f€35.00€0.50matched
105capture01a1a3aa-af3f-7d27-92fd-8a9252be5107€15.00€0.26matched
106capture01a1a3aa-b7f4-72d2-989f-f1e8082153eb€15.00€0.26matched
107capture01a1a3aa-ca8b-737b-9bfe-c162dde63901€9.00€0.19matched
108capture01a1a3aa-d4e8-7381-b4f3-3c2bedf74c3e€9.00€0.19matched
109capture01a1a3aa-e4dc-7c36-b60b-ccb94d2f3999€24.00€0.37matched
110refund01a1a3aa-ed10-735a-9189-eb209149704e-€15.00€0.00matched
111capture01a1a3ab-0ccf-713c-9906-3d58d85e2fe2€9.00€0.19matched
112capture01a1a3ab-10e4-7620-acd2-1fb6b81acd35€9.00€0.19matched
113capture01a1a3ab-195c-76e9-bcba-81e0ae6f6ce5€35.00€0.50matched
114capture01a1a3ab-3bdf-7149-bbe0-f6d5e3669100€15.00€0.26matched
115capture01a1a3ab-490a-7dbb-b2cd-4f3b20c125ea€9.00€0.19matched
116capture01a1a3ab-78de-7902-9748-9e8ed5d2f14b€15.00€0.26matched
117capture01a1a3ab-a12d-7e2e-8acf-1b48ebbe9563€24.00€0.37matched
118capture01a1a3ab-d6a2-7de6-b298-5e590a24ba30€24.00€0.37matched
119capture01a1a3ac-277c-7b1f-b5cb-0ca81d9ca7f6€9.00€0.19matched
120capture01a1a3ac-4a4a-75b6-a6c2-3d9d2cd788ec€24.00€0.37matched
121capture01a1a3ac-5381-70dd-8c6d-e51279e55279€49.00€0.67matched
122capture01a1a3ac-60d1-7b51-8151-7ec32776ebfc€15.00€0.26matched
123capture01a1a3ac-81e9-7d81-ad11-5eb7fd9836d2€49.00€0.67matched
124capture01a1a3ac-8295-7de3-b4c8-286ffb1ed218€49.00€0.67matched
125capture01a1a3ac-9403-79d7-8f06-5aab903c2f8c€35.00€0.50matched
126capture01a1a3ac-aa1a-73c3-a31d-ee9662f9aa2d€49.00€0.67matched
127capture01a1a3ac-b015-7fa0-a845-292ba4152290€35.00€0.50matched
128capture01a1a3ac-f5e0-74ad-bff8-20cdcce0104e€9.00€0.19matched