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

Gross

€2,871.00

PSP fee

€44.55

Net to the bank

€2,826.45

Settlement journal

#408683

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aed2-1dee-7449-b095-419580d262f4 is already settled by stl_EUR_2989890 line 66
  • fee differencethe fee is not the contract feethe fee is 3, the contract says 0
  • 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 29, the contract says 26
  • missing linein the books, not in the filecapture:01a1aecd-3b87-791e-972f-abd5d6014dd5 is in no file
LineKindReferenceGrossFeeStatus
3refund01a1aecc-d677-740f-9f91-c0605fef119e-€26.00€0.03fee difference
67capture01a1aed2-1e17-7f98-a479-570e3ad8509e€9.00€0.19duplicate line
82capture01a1aed3-6101-71fd-aa20-eb4ea215728c€15.00€0.31fee difference
115capture01a1aed5-4ddc-718e-b5af-547ea2131b95€15.00€0.29fee difference
1capture01a1aec9-07ee-77a6-b8ce-ea144e8ac0d2€9.00€0.19matched
2capture01a1aecc-bbf7-7b67-9159-fc153e92495f€35.00€0.50matched
4capture01a1aecd-0d49-7a8f-b600-fa8713c8b7ae€9.00€0.19matched
5capture01a1aecd-19df-7b83-ad6e-481e4f0d1ab0€24.00€0.37matched
6capture01a1aecd-2f72-7129-8ee5-28d367a3fd62€15.00€0.26matched
7capture01a1aecd-3a76-70de-b90a-358260b614ae€9.00€0.19matched
8capture01a1aecd-4b3f-760b-b954-66a12007c5eb€9.00€0.19matched
9capture01a1aecd-5331-7e3a-9842-fee0a3a0211b€35.00€0.50matched
10refund01a1aecd-6874-783a-8226-89172b040fa6-€13.00€0.00matched
11capture01a1aecd-77af-724e-98d6-c892397b3f03€9.00€0.19matched
12capture01a1aecd-7fc7-72ce-81ed-597f4da66107€9.00€0.19matched
13capture01a1aecd-9602-7014-985e-c7c04e67e788€35.00€0.50matched
14capture01a1aecd-a840-7de5-a3d8-5e29c788ebc1€24.00€0.37matched
15capture01a1aecd-b209-717e-9e65-80857c851803€15.00€0.26matched
16capture01a1aecd-b345-7d79-8323-c52360eb2610€9.00€0.19matched
17capture01a1aecd-de47-7a64-be77-a672623f4f94€49.00€0.67matched
18capture01a1aecd-fa16-7bf8-8312-632a18ec852d€49.00€0.67matched
19capture01a1aece-1825-7d1b-aa6e-bdf885d7e2ba€35.00€0.50matched
20refund01a1aece-2853-7da7-9a5e-3e2c9bfc373e-€4.00€0.00matched
21capture01a1aece-373f-75b9-adf1-0a3b6602e203€15.00€0.26matched
22capture01a1aece-403c-7466-bea8-177e1a1900e3€9.00€0.19matched
23capture01a1aece-40b3-704b-b750-3d9f25941bce€24.00€0.37matched
24capture01a1aece-6435-70f5-84b3-5c04cfe7ee2c€49.00€0.67matched
25refund01a1aece-810e-7a4d-9653-da140abcd400-€11.00€0.00matched
26capture01a1aece-8329-72ba-9fb9-4d6e6d84eac9€24.00€0.37matched
27capture01a1aece-85bd-7d30-bfae-1323cfdbbf00€49.00€0.67matched
28capture01a1aece-8c44-7f8d-ae3a-037d9a79d6fc€49.00€0.67matched
29capture01a1aece-ae5d-77a6-82f1-a982481a6955€24.00€0.37matched
30capture01a1aece-b2eb-738e-b5da-f8f282d689c5€15.00€0.26matched
31capture01a1aece-c0ff-745d-a662-aca732dfc603€9.00€0.19matched
32capture01a1aece-e022-75a5-8569-e9082f34c863€35.00€0.50matched
33capture01a1aecf-02fe-7efa-a7f3-1da9bfd28aa6€24.00€0.37matched
34capture01a1aecf-040b-7ed0-b6ce-e366ed1df0cb€35.00€0.50matched
35capture01a1aecf-1548-7797-ae24-12b6b9745cb0€49.00€0.67matched
36capture01a1aecf-44c9-7e3f-bcab-b86ec3033471€35.00€0.50matched
37capture01a1aecf-68f2-7c2c-9197-e248aade930f€15.00€0.26matched
38capture01a1aecf-7554-78b3-8de4-113de6768912€9.00€0.19matched
39capture01a1aecf-7845-7eaf-a531-7b5dd0ebacb1€35.00€0.50matched
40capture01a1aecf-7b9f-7db1-82fe-129baf57204b€9.00€0.19matched
41capture01a1aecf-7e8d-7264-bd41-2ac10812a847€49.00€0.67matched
42capture01a1aecf-95e0-7f2f-8917-f7f5920a436c€9.00€0.19matched
43capture01a1aecf-9f55-7747-8acf-b7890486c490€49.00€0.67matched
44capture01a1aecf-a1e6-7bd9-91e5-4f8d2446c96d€49.00€0.67matched
45capture01a1aecf-b056-7ab0-8756-a0a3e11b3a9f€15.00€0.26matched
46capture01a1aecf-ba21-78ab-86a5-604f4f6a34d3€24.00€0.37matched
47capture01a1aecf-d69a-79e3-a5c8-461997b7d7e4€49.00€0.67matched
48capture01a1aecf-f201-752b-ba42-0d043038a2a1€9.00€0.19matched
49capture01a1aed0-01df-7699-be83-c0d322442dda€49.00€0.67matched
50capture01a1aed0-2614-740f-a03f-c1f28b3388e0€35.00€0.50matched
51capture01a1aed0-3644-759f-86ca-b0b90aa9a564€9.00€0.19matched
52capture01a1aed0-6245-70f8-823c-ef9297b3046a€15.00€0.26matched
53capture01a1aed0-a242-7d74-ad02-339006a13d72€9.00€0.19matched
54capture01a1aed0-a672-7d69-ad7a-e2809f3cfdf3€15.00€0.26matched
55capture01a1aed0-adc5-74c2-a76b-d73e591ae777€15.00€0.26matched
56capture01a1aed0-c085-75eb-9a30-e691438cf145€49.00€0.67matched
57capture01a1aed0-e297-7457-b0bc-2088aa3130c7€24.00€0.37matched
58capture01a1aed1-14a3-745f-b35d-16a15711c9e6€9.00€0.19matched
59capture01a1aed1-52e1-76f6-8d88-8fd76588c904€9.00€0.19matched
60capture01a1aed1-3ca3-7a3c-b9bf-f12a3376315d€9.00€0.19matched
61capture01a1aed1-7e83-7842-aac5-269b490252af€15.00€0.26matched
62capture01a1aed1-8ba2-7072-a61d-6b987253e20e€35.00€0.50matched
63capture01a1aed1-beff-7cf7-8bdb-4ff35b545ae6€35.00€0.50matched
64capture01a1aed1-c4af-7c3c-a001-b4b5d0c8c5e7€24.00€0.37matched
65capture01a1aed2-0e9d-7159-9d06-a36693134fe5€24.00€0.37matched
66capture01a1aed2-1e17-7f98-a479-570e3ad8509e€9.00€0.19matched
68capture01a1aed2-28d7-77b9-a1b0-53107307e941€24.00€0.37matched
69capture01a1aed2-30aa-7456-890c-09b2928eae43€49.00€0.67matched
70capture01a1aed2-706f-76e3-93d7-4dd2edff77f5€15.00€0.26matched
71capture01a1aed2-8fb4-7547-8619-ec0bc393c49d€9.00€0.19matched
72capture01a1aed2-9b2b-748c-9a36-2c4573e79dba€24.00€0.37matched
73capture01a1aed2-a0bc-7b8d-aa13-855f6128b5a1€35.00€0.50matched
74capture01a1aed2-b677-7fc4-963e-e398bac70f62€24.00€0.37matched
75capture01a1aed2-ccc7-75fa-9b0f-cc0e253ef8d1€49.00€0.67matched
76capture01a1aed2-f8cc-736f-86d6-a18d454a7e4c€35.00€0.50matched
77capture01a1aed3-13c2-7d38-8388-ae9d97e8248b€35.00€0.50matched
78capture01a1aed3-188e-7422-9f21-0e1d7de5ae48€9.00€0.19matched
79capture01a1aed3-1b7c-7e4d-8c80-79aa6bfa2514€15.00€0.26matched
80capture01a1aed3-2ac7-708b-8bf5-ee0e97b30b5e€24.00€0.37matched
81capture01a1aed3-41eb-7ce3-af20-d57fa640dd81€49.00€0.67matched
83capture01a1aed3-839d-7cf5-a78a-d8ee7303b7da€49.00€0.67matched
84capture01a1aed3-9e6b-72eb-9ef0-f1c00e7a6cf0€9.00€0.19matched
85capture01a1aed3-a07e-765a-99e2-4bac6f41bb31€49.00€0.67matched
86capture01a1aed3-a0d1-79d1-8fb0-200cab62732f€15.00€0.26matched
87capture01a1aed3-b530-768b-925f-826b1f9541f2€35.00€0.50matched
88capture01a1aed3-c949-75df-9caa-5bd1b3a6765a€49.00€0.67matched
89capture01a1aed3-dcdd-7a79-8558-94c8f598b692€9.00€0.19matched
90capture01a1aed3-f8a6-7474-9912-c96acf3f534e€49.00€0.67matched
91capture01a1aed3-fad7-7530-a09b-5a9105452f30€15.00€0.26matched
92capture01a1aed4-2c68-7146-b8dd-dc325f0309b0€49.00€0.67matched
93capture01a1aed4-42fd-79f9-b801-f894e7577622€15.00€0.26matched
94capture01a1aed4-5607-7b56-bd98-73ad86665ad0€24.00€0.37matched
95capture01a1aed4-6712-7742-b79b-6aaaf193f747€9.00€0.19matched
96capture01a1aed4-75f8-75ce-81cc-bd3a1dec670d€15.00€0.26matched
97capture01a1aed4-8816-7928-82d8-be2eef8413e6€35.00€0.50matched
98capture01a1aed4-9b01-7189-9180-72a375d2f978€9.00€0.19matched
99refund01a1aed4-a8dd-7034-b048-0230e90ef9f4-€8.00€0.00matched
100capture01a1aed4-b1ba-7780-82ee-1b168a134a0b€9.00€0.19matched
101capture01a1aed4-bb87-7d68-ac15-fcb0e9d2cdd8€49.00€0.67matched
102capture01a1aed4-c301-7cf3-8878-0d340ef22263€49.00€0.67matched
103capture01a1aed4-d54e-77b0-83ba-da2eb4d46513€35.00€0.50matched
104capture01a1aed4-dcd4-755f-a532-f2faca9f3e66€24.00€0.37matched
105refund01a1aed4-e24b-7c54-81b9-4f27dca1dfe9-€5.00€0.00matched
106capture01a1aed4-e54b-706d-9f4e-3c9916053c25€35.00€0.50matched
107capture01a1aed4-ed78-7e3e-98b9-99afddb9cb95€15.00€0.26matched
108capture01a1aed4-f78c-7639-b612-88249dd0c71e€35.00€0.50matched
109capture01a1aed4-f989-7a9f-87c2-614fe53618c0€15.00€0.26matched
110capture01a1aed5-038e-7a97-a30e-5d6696a58305€49.00€0.67matched
111capture01a1aed5-1ac0-71ad-aaf2-1f42936e4139€24.00€0.37matched
112capture01a1aed5-1ce1-72ea-9310-8a2c88012a22€15.00€0.26matched
113capture01a1aed5-1f3c-7bcb-a2d0-95484c958f67€49.00€0.67matched
114capture01a1aed5-3fcf-7a4d-af6c-168105060f97€24.00€0.37matched
116capture01a1aed5-5a75-7c73-a61e-f9e149a105c1€24.00€0.37matched
117capture01a1aed5-66e0-71e8-b334-b5f2866c8b6c€35.00€0.50matched
118capture01a1aed5-725b-7986-9dc8-bd59a1a003f0€24.00€0.37matched
119capture01a1aed5-86b1-7477-90df-432452e2ece7€24.00€0.37matched