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

Gross

€2,995.00

PSP fee

€47.93

Net to the bank

€2,947.07

Settlement journal

#405004

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 31, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
  • missing linein the books, not in the filecapture:01a1adc9-ccc2-77d0-a8f7-b38f58893b1b is in no file
LineKindReferenceGrossFeeStatus
67capture01a1adc7-eb3d-74d7-9e4f-408b9ee2272e€15.00€0.31fee difference
91capture01a1adc9-cfc2-740e-b345-0d28df591278€49.00€0.70fee difference
1capture01a1adbb-0b48-7349-b005-09bceacdfd60€15.00€0.26matched
2capture01a1adbb-c0f3-7f39-9e76-f898774cb36d€49.00€0.67matched
3capture01a1adbc-13bd-732c-9ccd-76cbaf7982ee€35.00€0.50matched
4capture01a1adbd-52c6-779c-b3f7-61426fc42e8e€35.00€0.50matched
5capture01a1adbe-3c3a-7148-8738-d68b5072b519€24.00€0.37matched
6capture01a1adc1-107e-71db-9e6d-cd29f62ae937€15.00€0.26matched
7capture01a1adc3-0063-7362-bcff-2af24b205bbd€35.00€0.50matched
8capture01a1adc3-00ff-74cb-95c6-dc03b1a360e1€9.00€0.19matched
9capture01a1adc3-0c04-79dd-8124-c9ff7ed49110€49.00€0.67matched
10capture01a1adc3-0f04-7aad-a7dc-2f4e295aead5€35.00€0.50matched
11capture01a1adc3-112b-77c7-a4e7-49f4743c432c€24.00€0.37matched
12capture01a1adc3-3fc4-7d9e-9154-6f12041f9c5d€15.00€0.26matched
13capture01a1adc3-5e08-7ff8-8245-e52deeda29b9€49.00€0.67matched
14refund01a1adc3-60ef-72ae-bbe2-c5a12411eb76-€5.00€0.00matched
15capture01a1adc3-7f6a-7e84-9110-4964fe2e9019€9.00€0.19matched
16refund01a1adc3-8467-73e7-8ae5-105121efefb4-€6.00€0.00matched
17capture01a1adc3-8aff-7258-8621-45989d00741a€9.00€0.19matched
18capture01a1adc3-be0c-7a3d-a394-087c65bae02b€15.00€0.26matched
19capture01a1adc3-e042-7e2b-9e67-9ef214bba2b6€35.00€0.50matched
20capture01a1adc4-12b1-7a7a-8f6b-b713602a1201€9.00€0.19matched
21capture01a1adc4-1123-70ff-879c-483cc452860a€9.00€0.19matched
22capture01a1adc4-29e9-7f74-8449-e4c97fce3633€24.00€0.37matched
23capture01a1adc4-4a3d-7161-8912-39f3079fd959€15.00€0.26matched
24capture01a1adc4-5429-7a37-a126-719b9cf87b69€49.00€0.67matched
25capture01a1adc4-7ecb-7144-ab00-f04dd7f587a5€24.00€0.37matched
26capture01a1adc4-af11-78c7-b868-9c6251e5d3a7€9.00€0.19matched
27capture01a1adc4-b9b6-7266-b1e2-958f4bc2dd1a€15.00€0.26matched
28capture01a1adc4-be6b-7281-8be7-29aa377a9a19€9.00€0.19matched
29capture01a1adc4-ce6b-7cac-9e6c-3cc605a7f53b€15.00€0.26matched
30capture01a1adc4-d37e-77b3-a28e-63ebb1a2719c€49.00€0.67matched
31capture01a1adc4-dfd9-7a5f-bbe0-e3b7b906d3c6€49.00€0.67matched
32refund01a1adc5-0459-7fdf-a7f2-c501b567ccfe-€7.00€0.00matched
33capture01a1adc5-0643-72f5-b0de-e9d62cadcc23€24.00€0.37matched
34capture01a1adc5-6eba-7fff-8d72-1e78c0da5244€9.00€0.19matched
35capture01a1adc5-6f7a-7fd1-a5b1-70874197e476€9.00€0.19matched
36capture01a1adc5-7b27-7392-9412-6eb6bcd093ab€35.00€0.50matched
37capture01a1adc5-b4a4-7668-8aad-ae3145ec93cc€9.00€0.19matched
38refund01a1adc5-cd3f-746e-ae6a-5465c9856cb8-€7.00€0.00matched
39capture01a1adc5-d2b2-77f2-94ce-cb7aee89a93c€15.00€0.26matched
40capture01a1adc5-e620-781d-8bc9-eec8fd43527e€24.00€0.37matched
41capture01a1adc5-e698-7bed-aba5-89b0fe254d80€35.00€0.50matched
42capture01a1adc5-f0dd-756f-a356-c5ca92671134€49.00€0.67matched
43capture01a1adc5-f796-75ee-9391-e054bce19560€15.00€0.26matched
44capture01a1adc5-fcbc-73f7-92d2-3bdacc541cee€9.00€0.19matched
45capture01a1adc5-fdac-728d-b63b-6b0b62dbe0e6€35.00€0.50matched
46capture01a1adc6-1f1d-725a-95ff-09eb2b75731c€49.00€0.67matched
47capture01a1adc6-1f74-7452-927d-f468333b3c7c€49.00€0.67matched
48refund01a1adc6-20b3-795b-a5a3-b834394988b9-€4.00€0.00matched
49capture01a1adc6-216f-77d3-bd83-ba84adf58692€9.00€0.19matched
50capture01a1adc6-1dd9-7124-836a-55db9288563b€35.00€0.50matched
51capture01a1adc6-2ca9-744a-8751-31b5366859d3€24.00€0.37matched
52capture01a1adc6-31ec-7924-a0bb-9b20d59da959€49.00€0.67matched
53capture01a1adc6-8f48-753f-97ca-596f43933e98€15.00€0.26matched
54capture01a1adc6-90c8-72bb-9115-0c65b1b7d7db€9.00€0.19matched
55capture01a1adc6-d145-734a-9500-3c65da43a39c€49.00€0.67matched
56capture01a1adc6-dd4f-72b7-9d0b-f8fb5dd969a9€24.00€0.37matched
57capture01a1adc6-e2d1-753c-87cf-a0df480c6d17€35.00€0.50matched
58capture01a1adc6-e31a-743e-bd72-3ca075e66123€35.00€0.50matched
59capture01a1adc6-ead1-79da-a61d-516a449a6f5f€24.00€0.37matched
60capture01a1adc6-fea3-723a-9e58-bc3c703e4ba7€15.00€0.26matched
61capture01a1adc7-194b-787b-bd98-71940cc4cbe1€35.00€0.50matched
62capture01a1adc7-24af-7875-aece-eaeb9326282e€24.00€0.37matched
63capture01a1adc7-2a97-7625-85bb-2178fe0ab03e€49.00€0.67matched
64capture01a1adc7-3372-7782-b6f9-4d38e659fed2€15.00€0.26matched
65refund01a1adc7-55ff-7737-9c39-8fbb53869bb6-€32.00€0.00matched
66capture01a1adc7-67d0-797c-8a0e-9eba21293c0b€15.00€0.26matched
68capture01a1adc8-03a3-7cdc-915e-132729ca7cc1€49.00€0.67matched
69capture01a1adc8-17c1-78f9-880d-f2748250772c€35.00€0.50matched
70capture01a1adc8-1e59-7e31-975f-a2229c4e3177€15.00€0.26matched
71capture01a1adc8-25e7-7841-b3fc-efec258083df€15.00€0.26matched
72capture01a1adc8-3f00-794c-8d7b-b5b19a7c3a0d€35.00€0.50matched
73capture01a1adc8-95d6-70ae-8763-e2b819444582€24.00€0.37matched
74capture01a1adc8-9f41-7f27-9d88-cd31ec5b2ab1€35.00€0.50matched
75capture01a1adc8-a2b4-7a62-91d5-feb5c0be0915€35.00€0.50matched
76capture01a1adc8-ba93-7478-965b-10512d6ce7ac€49.00€0.67matched
77refund01a1adc8-c484-7e6b-b6ba-9a3f6bfe2f09-€8.00€0.00matched
78capture01a1adc8-d145-79c1-be55-8d0155848a8e€24.00€0.37matched
79capture01a1adc9-2f42-7488-bb31-40ce95642784€9.00€0.19matched
80capture01a1adc9-2fc3-7c88-a8cf-35bfe968ec22€49.00€0.67matched
81capture01a1adc9-3102-711f-a925-94b263448d60€35.00€0.50matched
82capture01a1adc9-3a4f-7001-809e-85fc9802380c€15.00€0.26matched
83capture01a1adc9-54c6-7e71-af42-3db6ae090a82€15.00€0.26matched
84capture01a1adc9-60c2-76fc-93ea-436eb73a73b9€35.00€0.50matched
85capture01a1adc9-66b4-7496-83e2-4064d4094e08€35.00€0.50matched
86capture01a1adc9-818e-7a53-aa5d-d13f3b6d90e2€24.00€0.37matched
87capture01a1adc9-90eb-713b-a33a-d8953170f816€49.00€0.67matched
88capture01a1adc9-92fe-7773-8b0c-4bbaec9f6e0a€35.00€0.50matched
89capture01a1adc9-944d-7756-add7-75e9707e51b7€15.00€0.26matched
90capture01a1adc9-a32a-7437-8921-b5e9a8f42504€35.00€0.50matched
92capture01a1adc9-cfc3-7673-8931-bb3a46c594f1€9.00€0.19matched
93capture01a1adc9-e6bc-7708-9559-d00d2a183839€35.00€0.50matched
94refund01a1adc9-e8c7-7242-9e01-cc5109f84fb2-€28.00€0.00matched
95capture01a1adc9-fb05-7e76-8c33-91ac6bdebac9€24.00€0.37matched
96refund01a1adca-04c9-72f9-844b-dd3e84f750e0-€28.00€0.00matched
97capture01a1adca-11c6-7835-a99d-8d353d706c9f€15.00€0.26matched
98capture01a1adca-0f2f-7f8a-b52a-02a909c2c3b1€9.00€0.19matched
99capture01a1adca-22d1-78fd-930c-1ae8e49062bf€35.00€0.50matched
100capture01a1adca-2769-7225-879e-4af2911ffde5€35.00€0.50matched
101capture01a1adca-3c48-73b1-9602-7a2a7202e994€9.00€0.19matched
102capture01a1adca-4ec5-7d45-952d-32897acec122€9.00€0.19matched
103capture01a1adca-50d7-7eb9-8c32-4b0748e01723€35.00€0.50matched
104capture01a1adca-5313-78e0-b314-513decc52c07€15.00€0.26matched
105capture01a1adca-5dc8-7540-b621-fa67b12c6fe6€15.00€0.26matched
106capture01a1adca-712b-7c6f-b3f9-e8b8221fe60d€35.00€0.50matched
107capture01a1adca-805f-739a-8ef8-b07747be407f€15.00€0.26matched
108capture01a1adca-86a9-7e66-b005-970cdab91ebe€9.00€0.19matched
109capture01a1adca-82b4-79a3-bed7-13d9eb626bca€24.00€0.37matched
110refund01a1adca-8f1a-767a-b238-08462e405335-€17.00€0.00matched
111capture01a1adca-9ca4-78d0-903e-93b4fe8a31cf€9.00€0.19matched
112capture01a1adca-d8f1-724b-b494-3c0d827e0f33€35.00€0.50matched
113capture01a1adca-fb87-75cc-9cd5-9875ace95366€9.00€0.19matched
114capture01a1adca-fd0b-7a91-bbdb-6fb21ef08fb7€9.00€0.19matched
115capture01a1adcb-0341-7019-9764-7cc26a746028€24.00€0.37matched
116refund01a1adcb-2adb-7f64-b4ef-d04948621fc0-€19.00€0.00matched
117capture01a1adcb-21f6-71e0-84a8-bf12f9b03f59€15.00€0.26matched
118capture01a1adcb-35c9-7da3-93f2-f0ca4aa10067€49.00€0.67matched
119capture01a1adcb-44b9-7db3-8232-22da894ce7bf€15.00€0.26matched
120capture01a1adcb-6581-7806-b611-8f53f240a049€9.00€0.19matched
121capture01a1adcb-7086-700e-b520-2056dc7be40b€49.00€0.67matched
122capture01a1adcb-7980-7d1f-a194-2a43682534a7€35.00€0.50matched
123capture01a1adcb-b4b7-7224-bcad-4dcc9a2a985b€9.00€0.19matched
124capture01a1adcb-dc70-75c4-9240-f5f3c349f360€49.00€0.67matched
125capture01a1adcb-ddd7-758f-b6e3-beb9d0398a1e€49.00€0.67matched
126capture01a1adcb-dfa2-7834-a6ae-5936f2ead271€49.00€0.67matched
127capture01a1adcb-ed99-7779-ad21-0d348aef3f22€24.00€0.37matched
128capture01a1adcb-f600-7516-91b9-a3f9171f3763€24.00€0.37matched
129capture01a1adcb-fa34-7b8f-aa54-1222052a0a22€9.00€0.19matched
130capture01a1adcb-fa68-7006-b0e2-b37455e88727€9.00€0.19matched
131capture01a1adcb-fed4-755c-9fe8-96b868257ed3€9.00€0.19matched
132capture01a1adcc-0e6f-79d9-9e91-c80d7db02cdc€9.00€0.19matched
133capture01a1adcc-1551-7232-a5e1-efd11e4e88fc€24.00€0.37matched
134capture01a1adcc-20bd-7de3-bc5b-539cf959fa10€15.00€0.26matched