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, 21:40

Gross

€3,208.00

PSP fee

€50.42

Net to the bank

€3,157.58

Settlement journal

#386350

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a881-5722-7f08-a19e-dac63d9886de is already settled by stl_EUR_2989714 line 5
  • duplicate linethe file lists it twicecapture:01a1a889-c972-7ce9-884a-a2ba3925ff20 is already settled by stl_EUR_2989714 line 127
  • missing linein the books, not in the filecapture:01a1a881-47e4-7b37-837a-91b6222e0f89 is in no file
LineKindReferenceGrossFeeStatus
6capture01a1a881-5751-763a-970e-4846f1bcf93e€35.00€0.50duplicate line
128capture01a1a889-c98b-7c27-a4d1-822dfbfbfade€15.00€0.26duplicate line
1capture01a1a87d-944c-75f6-99cc-625646b7df71€15.00€0.26matched
2capture01a1a87e-27c5-7f39-9c3d-cdb9e03ce72e€24.00€0.37matched
3capture01a1a881-4e7c-703c-8146-23657a97974f€49.00€0.67matched
4capture01a1a881-5655-7691-a336-6fb4c583e47b€49.00€0.67matched
5capture01a1a881-5751-763a-970e-4846f1bcf93e€35.00€0.50matched
7capture01a1a881-5d32-7423-96f6-10b71344d101€15.00€0.26matched
8capture01a1a881-75f4-7dd2-9b08-2eb10a8854e4€49.00€0.67matched
9capture01a1a881-7e9e-7f36-9303-3027585ff46b€24.00€0.37matched
10capture01a1a881-88eb-7b1d-9a9c-9c8ca264d119€35.00€0.50matched
11capture01a1a881-d079-7ff3-bb2b-d71e313c7026€49.00€0.67matched
12capture01a1a881-d42e-7a49-801e-64164fc8d780€24.00€0.37matched
13capture01a1a881-d5a8-7e8b-b0d7-c2f884a18314€35.00€0.50matched
14capture01a1a882-13f1-7a9b-a85c-0cf63799a33a€49.00€0.67matched
15capture01a1a882-31b6-7a08-93eb-8648259b10df€9.00€0.19matched
16capture01a1a882-4980-7fcb-be84-f9bc9f4019b0€49.00€0.67matched
17capture01a1a882-7d42-7bd7-997b-6a89301ebefd€9.00€0.19matched
18capture01a1a882-9f4b-7fa2-b3fa-aeff8f01f814€9.00€0.19matched
19capture01a1a883-0b5a-7eef-bfad-bcc3b3a99e54€15.00€0.26matched
20capture01a1a883-2087-74fc-a542-790f7d9502ba€15.00€0.26matched
21capture01a1a883-2389-7750-a7f2-ff715938d4c1€9.00€0.19matched
22capture01a1a883-2515-77f9-abe6-a7043e883a51€35.00€0.50matched
23capture01a1a883-2b77-7f3b-a4bb-abe13b2b9f08€15.00€0.26matched
24capture01a1a883-2c13-7ea7-ab63-aba2bdef1fc2€24.00€0.37matched
25capture01a1a883-3585-79e6-aa0c-9fb79cc7eb8e€9.00€0.19matched
26capture01a1a883-45fa-7811-a40f-d5f6ec189bf7€24.00€0.37matched
27capture01a1a883-5089-797e-bdcb-3ae4a6a08bb6€15.00€0.26matched
28capture01a1a883-66f5-71ba-8556-b8b0a4f5ad3d€9.00€0.19matched
29capture01a1a883-77f7-7b37-87ab-2bcf24fa60a6€49.00€0.67matched
30capture01a1a883-7d90-725e-ae24-1de695a1f765€49.00€0.67matched
31capture01a1a883-7d9e-709c-b0b7-dd87196c3a2e€15.00€0.26matched
32capture01a1a883-8dba-7f7c-917c-31521125a4b2€24.00€0.37matched
33capture01a1a883-9b67-73d5-a8bd-e764a4e9bbbd€24.00€0.37matched
34capture01a1a883-9bd3-7526-8f2d-f6fcee510985€35.00€0.50matched
35capture01a1a883-9c3b-799c-976a-041b381fdf0a€35.00€0.50matched
36capture01a1a883-a0cc-7d1e-a774-d298199ec4a5€24.00€0.37matched
37capture01a1a883-abd8-755b-801b-9524555a3d37€9.00€0.19matched
38capture01a1a883-ba35-7595-b35a-8dd180b287e4€35.00€0.50matched
39capture01a1a883-bf37-769c-a74b-e6998df3123f€24.00€0.37matched
40capture01a1a883-c6f7-73aa-9a48-4108a0cca598€15.00€0.26matched
41refund01a1a883-c95a-7bed-b907-224574f5552b-€17.00€0.00matched
42capture01a1a883-de98-701a-82f2-208a7e52ed6c€35.00€0.50matched
43capture01a1a883-e603-7398-8932-3545964cac85€49.00€0.67matched
44capture01a1a883-ed2e-7549-8a83-24578633bf15€9.00€0.19matched
45capture01a1a883-eddc-7537-8805-66735e1c1e3e€49.00€0.67matched
46capture01a1a884-0a8e-7c7b-9415-d297e252099b€15.00€0.26matched
47capture01a1a884-085f-7969-be94-ca35bd8c6891€49.00€0.67matched
48refund01a1a884-1e36-7983-8dbf-a10682738feb-€27.00€0.00matched
49capture01a1a884-2cf8-788f-81fc-2b8b17363696€24.00€0.37matched
50capture01a1a884-3938-711f-9b35-80cce01d9f66€9.00€0.19matched
51capture01a1a884-39e9-7259-a1b6-71f93e5c513e€15.00€0.26matched
52capture01a1a884-68a3-762e-818c-c6bce1a523c8€35.00€0.50matched
53capture01a1a884-80a9-74fe-a828-074e03a37e82€9.00€0.19matched
54capture01a1a884-9ddb-7d47-8d68-c9780eee96ef€15.00€0.26matched
55capture01a1a884-af8e-73c1-a7da-3a81878a3968€35.00€0.50matched
56capture01a1a884-b055-750e-bb20-90b0c52d42cc€24.00€0.37matched
57capture01a1a884-b088-7739-869c-5e97049bd8bc€24.00€0.37matched
58capture01a1a884-bc33-723c-8169-1af381e3a581€35.00€0.50matched
59capture01a1a884-f474-7b32-828f-0eb7d0d2d757€35.00€0.50matched
60capture01a1a884-f5db-73f3-8653-49959e67baf6€9.00€0.19matched
61capture01a1a884-f644-79d2-a0e5-c7f631ae6509€15.00€0.26matched
62capture01a1a885-158b-7cf2-9a42-56d208773a6a€9.00€0.19matched
63capture01a1a885-21d7-71f6-b101-6b778f41073e€9.00€0.19matched
64capture01a1a885-7556-78b3-b19f-7386a13d7286€24.00€0.37matched
65capture01a1a885-8ef1-7e26-9f1b-36c0a2d1e201€24.00€0.37matched
66capture01a1a885-ba4c-7e40-a1e5-2932c24d6f14€9.00€0.19matched
67capture01a1a885-ce45-7963-b318-b61df4c572da€49.00€0.67matched
68refund01a1a885-f6eb-7911-ba01-c303548d21c0-€27.00€0.00matched
69capture01a1a885-faae-74f6-8462-debb801d840f€15.00€0.26matched
70capture01a1a886-1acf-7117-ab78-38d9016d8d48€9.00€0.19matched
71capture01a1a886-1bdb-7d67-b743-367871ee0a28€49.00€0.67matched
72capture01a1a886-1d18-7145-b255-3d77341c4fde€9.00€0.19matched
73capture01a1a886-3393-7763-b012-a92373191332€49.00€0.67matched
74capture01a1a886-3a03-76c9-aca1-865ebb38706b€49.00€0.67matched
75capture01a1a886-534c-7038-9fc6-4a1f6a729b97€24.00€0.37matched
76capture01a1a886-5639-74c2-acfb-e9678c6d4a28€9.00€0.19matched
77capture01a1a886-68c9-754d-917b-67fe8a2ebf55€9.00€0.19matched
78capture01a1a886-7208-7f17-8af8-618d4a538a77€9.00€0.19matched
79capture01a1a886-8b6e-74d2-a127-bf8a30f70c5a€49.00€0.67matched
80capture01a1a886-948b-79c2-a572-6ec9a4b80024€9.00€0.19matched
81capture01a1a886-99a6-7da2-9788-71080eb5695b€35.00€0.50matched
82capture01a1a886-a510-71c9-8437-fb04909c997f€9.00€0.19matched
83capture01a1a886-abde-777c-bdd0-3a12aafca1d5€35.00€0.50matched
84capture01a1a886-b3e1-76aa-8a76-ff72c242039a€15.00€0.26matched
85capture01a1a886-c289-7ce7-805a-7f535830afeb€24.00€0.37matched
86capture01a1a886-d88c-7cce-8997-41037f676f20€15.00€0.26matched
87capture01a1a886-fbd3-70d8-a099-36d585c59ec6€24.00€0.37matched
88refund01a1a886-ff74-7704-867f-6559fb9a7aef-€12.00€0.00matched
89capture01a1a887-0299-76e1-bb61-2b557844a195€49.00€0.67matched
90capture01a1a887-0d8a-7c95-834a-3431a5de3e89€24.00€0.37matched
91capture01a1a887-51a1-7a0a-a60c-5b6aabeee8df€49.00€0.67matched
92capture01a1a887-5b47-72ae-b909-49b83d0e647d€9.00€0.19matched
93capture01a1a887-7ffb-74db-ab56-4ec560bd469f€9.00€0.19matched
94capture01a1a887-86bf-7613-8f8b-5a6d683b097f€15.00€0.26matched
95capture01a1a887-964a-7dc6-a53a-c33eaa2e5c91€15.00€0.26matched
96capture01a1a887-e454-70de-ae1a-928857cfe9b8€24.00€0.37matched
97capture01a1a887-edb6-746d-9798-1b96e36e19d9€24.00€0.37matched
98capture01a1a887-ede5-7a69-9f86-5d1c33bf27be€24.00€0.37matched
99capture01a1a887-edf2-762d-864e-e151f64ce1de€15.00€0.26matched
100capture01a1a887-f1db-7ab7-9d50-8f0715a2c4e8€35.00€0.50matched
101capture01a1a888-0e7e-7339-b0e8-c9b7a515068a€35.00€0.50matched
102capture01a1a888-18b6-75c3-91d4-926cadbc9c96€35.00€0.50matched
103capture01a1a888-2755-7941-ba0f-a95807dc702a€24.00€0.37matched
104capture01a1a888-45eb-726a-b80f-169d4ee2a4b5€15.00€0.26matched
105capture01a1a888-68a1-79b4-be58-12d5fff65c95€15.00€0.26matched
106capture01a1a888-7c3d-755b-9977-1ad7904f4572€49.00€0.67matched
107capture01a1a888-86c3-792e-a155-273961c4d523€9.00€0.19matched
108capture01a1a888-88dc-70b9-a8e3-13ed1b7e91ab€15.00€0.26matched
109capture01a1a888-ac5d-792c-a1ae-64d752cac122€15.00€0.26matched
110capture01a1a888-d069-7c1a-93e2-1aa9ab4d838a€24.00€0.37matched
111capture01a1a888-cc6d-7e1a-9c23-7a81822c0ee8€24.00€0.37matched
112capture01a1a888-d81a-7550-9fa0-fa3bec0613a9€9.00€0.19matched
113capture01a1a888-de8c-7d70-8b3d-6d3b0d08ffa5€49.00€0.67matched
114capture01a1a888-e6c2-7305-979b-68dac7ae9a92€15.00€0.26matched
115capture01a1a888-ea75-7365-9b28-06542dec4587€49.00€0.67matched
116capture01a1a888-faca-7f9c-8981-cf0377711dc8€24.00€0.37matched
117capture01a1a889-21a0-7c52-876e-0cc4d267ddc8€9.00€0.19matched
118refund01a1a889-253b-743d-9b0e-34c5bebebd7e-€7.00€0.00matched
119capture01a1a889-1158-7c3a-aeec-a9c44c91b28c€49.00€0.67matched
120capture01a1a889-3b33-72b7-af17-38c9330687be€35.00€0.50matched
121capture01a1a889-3c8a-7f41-a2c0-cdc6f45845ad€49.00€0.67matched
122capture01a1a889-583d-7e12-929f-108d6bc36641€35.00€0.50matched
123capture01a1a889-6811-7a35-804a-a414a7febb16€24.00€0.37matched
124capture01a1a889-6925-7f21-9476-2f56afd84c75€24.00€0.37matched
125capture01a1a889-9543-7eee-addb-e7ad0edd73dc€15.00€0.26matched
126capture01a1a889-a07b-7924-8dd7-0bff032163ff€15.00€0.26matched
127capture01a1a889-c98b-7c27-a4d1-822dfbfbfade€15.00€0.26matched
129capture01a1a889-d4b9-73e5-bd90-1215abbbb500€35.00€0.50matched
130capture01a1a889-fd60-7877-87e7-5f1f41aa15c8€9.00€0.19matched
131capture01a1a88a-07c1-749f-ae51-7936f6b77b1b€35.00€0.50matched
132capture01a1a88a-356b-791c-a909-e9dd5bc6365e€24.00€0.37matched
133capture01a1a88a-3933-7423-986c-87ab5a055e14€24.00€0.37matched
134capture01a1a88a-3950-7a64-8a84-7a7f0822e587€15.00€0.26matched
135capture01a1a88a-39d1-717b-ad18-616d2f6deb37€24.00€0.37matched
136refund01a1a88a-43c2-7e47-bbdb-25d77389ef15-€17.00€0.00matched
137capture01a1a88a-48a7-7538-b59d-0f7545bcd1a4€35.00€0.50matched