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, 18:20

Gross

€3,038.00

PSP fee

€48.24

Net to the bank

€2,989.76

Settlement journal

#383786

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a7cc-82f6-73d5-8e16-671eb832fc91 is already settled by stl_EUR_2989694 line 37
  • duplicate linethe file lists it twicecapture:01a1a7cd-70bd-7df3-8eb6-861acd1904e9 is already settled by stl_EUR_2989694 line 55
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
  • missing linein the books, not in the filerefund:01a1a7cb-0ae8-75ec-bd1d-9dbde9316254 is in no file
LineKindReferenceGrossFeeStatus
38capture01a1a7cc-8332-742e-aaa3-652fdc812a1b€9.00€0.19duplicate line
56capture01a1a7cd-70ea-787d-a8fc-01fbaba7558c€49.00€0.67duplicate line
78capture01a1a7ce-e82a-7149-891b-a002bf4f2ea9€35.00€0.55fee difference
1capture01a1a7c1-4db8-7cda-90a6-225b1e59aa33€9.00€0.19matched
2capture01a1a7c5-3221-7912-8c22-f9f672ad105a€24.00€0.37matched
3capture01a1a7ca-1292-715a-9131-797c07724879€9.00€0.19matched
4capture01a1a7ca-5148-7397-9d76-cc11b970c2b8€9.00€0.19matched
5capture01a1a7ca-51d6-7549-adda-5b2d8289a00a€15.00€0.26matched
6capture01a1a7ca-6656-769a-b9bd-4b08c789798a€49.00€0.67matched
7capture01a1a7ca-6f94-7719-a6d8-2d4cbf0a9bd4€24.00€0.37matched
8capture01a1a7ca-86ee-7e62-b68d-01327ead8f7c€24.00€0.37matched
9refund01a1a7ca-9590-7f04-aa8e-e3fa32e612f9-€4.00€0.00matched
10capture01a1a7ca-9d2d-7105-a80c-9b82fd3c44d0€9.00€0.19matched
11capture01a1a7ca-a8e9-7566-b6da-d19f54ab0c4d€15.00€0.26matched
12refund01a1a7ca-ac96-736b-8358-221da06484b4-€9.00€0.00matched
13capture01a1a7ca-b91b-764e-9143-fb0013971856€15.00€0.26matched
14capture01a1a7ca-bc90-71a0-a867-60563093525c€9.00€0.19matched
15capture01a1a7ca-be83-7bd2-8002-b815de8ba995€35.00€0.50matched
16capture01a1a7ca-c958-7eeb-8335-a7245f74899a€15.00€0.26matched
17capture01a1a7ca-ced6-7a6a-851c-4b0198071420€9.00€0.19matched
18capture01a1a7ca-d8c3-7326-9944-1afe23b447a6€35.00€0.50matched
19refund01a1a7cb-0150-7860-ab66-377ccc054a2c-€2.00€0.00matched
20capture01a1a7cb-0527-7705-9e31-3b44e64c3931€9.00€0.19matched
21capture01a1a7cb-139b-7fce-8a07-3d9268588591€9.00€0.19matched
22capture01a1a7cb-212c-7eda-a2c8-ed3f1481b7fb€24.00€0.37matched
23capture01a1a7cb-5be9-7c05-9a51-12104beaaa22€9.00€0.19matched
24capture01a1a7cb-647e-722d-855a-e10cba27720a€35.00€0.50matched
25capture01a1a7cb-9974-7bb9-bf7d-8caa89e8fcca€9.00€0.19matched
26capture01a1a7cb-a0aa-7150-9bdc-d7b0a7e348d4€9.00€0.19matched
27capture01a1a7cb-a6b8-729d-a7ef-a3dc32ca44f8€49.00€0.67matched
28capture01a1a7cb-bc64-7897-ae93-62beff3ebc7f€24.00€0.37matched
29capture01a1a7cb-f27a-784c-aa8d-27f5c520b6e4€49.00€0.67matched
30capture01a1a7cb-f695-7207-b7db-a624e7ec8983€15.00€0.26matched
31capture01a1a7cc-0634-728b-b693-2af5cc5dfd6f€9.00€0.19matched
32capture01a1a7cc-1716-76c9-bc18-55d167426b8c€9.00€0.19matched
33capture01a1a7cc-1dfd-79bb-8c80-bd5e166938e6€49.00€0.67matched
34capture01a1a7cc-3d0f-7a5b-9095-f336bf74a8a1€24.00€0.37matched
35capture01a1a7cc-5708-73d1-9ea9-596fc89d8048€9.00€0.19matched
36capture01a1a7cc-7497-7320-9748-7c90f067b16c€9.00€0.19matched
37capture01a1a7cc-8332-742e-aaa3-652fdc812a1b€9.00€0.19matched
39capture01a1a7cc-89f4-74d8-98dc-85f0f8d60ba0€49.00€0.67matched
40capture01a1a7cc-98a0-7cd1-b267-2bc2b84f39b5€24.00€0.37matched
41capture01a1a7cc-9f06-7b61-bc89-773bb65a0ef3€24.00€0.37matched
42capture01a1a7cc-aa47-72d1-b0be-130c87819ef7€9.00€0.19matched
43refund01a1a7cc-c590-7f76-95cb-762efe779638-€4.00€0.00matched
44capture01a1a7cc-c5bb-7be6-b8b3-8ba7f2a28c30€24.00€0.37matched
45capture01a1a7cc-cf05-7716-bdda-e85f36ae1af6€15.00€0.26matched
46refund01a1a7cc-ff1c-723e-a9c1-0577ba72b2fe-€12.00€0.00matched
47capture01a1a7cd-03de-73f4-881e-d1b3ed7a51fd€49.00€0.67matched
48capture01a1a7cd-08f5-76c9-a817-a5490216e496€49.00€0.67matched
49capture01a1a7cd-0c5d-7040-9f6f-482f1ccb96d2€24.00€0.37matched
50capture01a1a7cd-154d-78a0-a6c0-c8f433c4c4a4€49.00€0.67matched
51capture01a1a7cd-39bc-73c4-b3d2-deccad4e67fc€15.00€0.26matched
52capture01a1a7cd-4ac0-78e0-878e-d635f3225d24€35.00€0.50matched
53capture01a1a7cd-4af9-79f8-a96d-9cd5170983ec€15.00€0.26matched
54capture01a1a7cd-4f84-7e96-a2fc-8398b8107c4e€49.00€0.67matched
55capture01a1a7cd-70ea-787d-a8fc-01fbaba7558c€49.00€0.67matched
57capture01a1a7cd-763f-70ea-baa5-486eca666ffd€49.00€0.67matched
58capture01a1a7cd-8110-7297-b41d-80f4b015850c€49.00€0.67matched
59capture01a1a7cd-b53c-7a9b-b057-623f143e0b55€9.00€0.19matched
60capture01a1a7cd-cde6-7d30-8afa-b8e09f26e1cd€49.00€0.67matched
61capture01a1a7cd-d88d-752a-85e0-d1937e9764c2€35.00€0.50matched
62capture01a1a7cd-da11-7f28-a3bc-18ea133746a3€15.00€0.26matched
63capture01a1a7cd-faee-7703-81d4-168a7fcfcdf4€9.00€0.19matched
64capture01a1a7ce-191d-7dd9-a2f1-33bd413a7842€9.00€0.19matched
65capture01a1a7ce-20a0-7372-aa89-f26e68e0a2b6€24.00€0.37matched
66capture01a1a7ce-2cd1-71cb-85c6-4a56d61b868b€35.00€0.50matched
67capture01a1a7ce-3774-73d4-9d70-347d97c6c06e€15.00€0.26matched
68capture01a1a7ce-3f89-756f-aebc-a97e2da6b48b€9.00€0.19matched
69capture01a1a7ce-5f5b-7e4f-8749-2ffe39a64839€49.00€0.67matched
70capture01a1a7ce-8950-7fd6-ac1f-4610d8257750€15.00€0.26matched
71capture01a1a7ce-ac27-72c2-9a08-c7194c30b64e€15.00€0.26matched
72capture01a1a7ce-b01c-7b91-84d0-d4de111b8b6e€9.00€0.19matched
73capture01a1a7ce-b2c1-7248-946a-b73f21faec03€24.00€0.37matched
74capture01a1a7ce-c240-7149-8571-ed6ede2cc354€15.00€0.26matched
75capture01a1a7ce-c66e-770b-8138-da6f216f566a€15.00€0.26matched
76capture01a1a7ce-d032-7286-9e29-ec35876a1afa€35.00€0.50matched
77capture01a1a7ce-e135-7b26-a1f9-285e5e043113€49.00€0.67matched
79capture01a1a7ce-f0c9-76f7-a237-ce58fc9891cc€9.00€0.19matched
80refund01a1a7cf-0288-7fb5-bd28-448b228c40ba-€15.00€0.00matched
81capture01a1a7cf-10cc-7c9b-a670-3b42ca82d4bd€15.00€0.26matched
82capture01a1a7cf-244b-71a7-90a6-bde8829f2796€15.00€0.26matched
83refund01a1a7cf-31da-7515-9f0d-7e798895ee5e-€18.00€0.00matched
84capture01a1a7cf-3db1-73c8-ad1d-d5275425d605€35.00€0.50matched
85capture01a1a7cf-5545-77c0-b456-51475312571f€15.00€0.26matched
86capture01a1a7cf-569c-7141-8fe0-8f597b50595b€35.00€0.50matched
87capture01a1a7cf-64ff-73b0-98a4-7966a004066a€24.00€0.37matched
88capture01a1a7cf-ba86-768d-9e3e-c964e1ac2c1e€9.00€0.19matched
89capture01a1a7cf-d09f-7f4d-b816-3dfaa42f11e3€9.00€0.19matched
90capture01a1a7cf-e60c-7f63-9b47-019a0e06e7dc€49.00€0.67matched
91capture01a1a7cf-ec50-7370-88a0-de4013a957be€35.00€0.50matched
92capture01a1a7cf-ef1d-7f1a-ab2d-74f5d2c1f95d€9.00€0.19matched
93capture01a1a7cf-ffca-7e59-a26f-38630950c5d3€9.00€0.19matched
94capture01a1a7d0-0ca8-783c-b397-c45eb04b03c1€49.00€0.67matched
95refund01a1a7d0-33c6-7e53-87a6-cd4da30a7914-€5.00€0.00matched
96capture01a1a7d0-38bb-7cf7-8baa-dd268dd09318€49.00€0.67matched
97capture01a1a7d0-5054-726c-afb2-4360dacf3a40€49.00€0.67matched
98capture01a1a7d0-5906-79da-b5bf-48cfb24be41d€35.00€0.50matched
99capture01a1a7d0-60ac-73cd-a6b6-d8e11ca10e65€35.00€0.50matched
100capture01a1a7d0-616a-7c9c-8d02-3bdc229a6d84€49.00€0.67matched
101capture01a1a7d0-655c-7fe4-a0ae-44555ebce97b€49.00€0.67matched
102capture01a1a7d0-a5a6-7572-8f6b-76347849adce€15.00€0.26matched
103capture01a1a7d0-bae2-7757-88a5-2febfa913b41€9.00€0.19matched
104capture01a1a7d0-da2d-701f-a160-011f0ef7136b€15.00€0.26matched
105capture01a1a7d0-eef4-7f4b-b161-f17bc2ec583c€9.00€0.19matched
106capture01a1a7d0-f1b7-7ca7-8212-ecc6e572f491€15.00€0.26matched
107capture01a1a7d1-28b8-74ae-8243-a296e96f0705€24.00€0.37matched
108capture01a1a7d1-4a52-7eae-8721-381fa801e256€24.00€0.37matched
109capture01a1a7d1-5582-7835-aa6b-c5938990c661€35.00€0.50matched
110capture01a1a7d1-6309-786d-b688-a05aa241c8a4€24.00€0.37matched
111refund01a1a7d1-7545-77c4-b492-90b6500074bc-€13.00€0.00matched
112capture01a1a7d1-773e-7327-a283-646bcd9c6458€9.00€0.19matched
113capture01a1a7d1-773d-774e-a00f-17f9e438d915€49.00€0.67matched
114capture01a1a7d1-9789-7ca5-b21c-90f6d8ea814f€35.00€0.50matched
115refund01a1a7d1-abac-7db3-97c2-1eb041839d76-€18.00€0.00matched
116capture01a1a7d1-bc4c-7b68-a08b-d87ccada0ae6€15.00€0.26matched
117refund01a1a7d1-ca22-71bc-be66-d41e3147b945-€11.00€0.00matched
118capture01a1a7d1-cd16-78f9-9a5f-fe1fd68ffbfa€49.00€0.67matched
119capture01a1a7d2-0170-782b-b2b7-711b20d9dac8€49.00€0.67matched
120capture01a1a7d2-08ff-79ba-a76c-1f2631d5af4e€49.00€0.67matched
121capture01a1a7d2-119e-7ff9-84b8-794fb93cc494€49.00€0.67matched
122capture01a1a7d2-20ad-72d1-817e-69a69ed87b5d€49.00€0.67matched
123capture01a1a7d2-3c7f-7585-9089-bb71e948f869€49.00€0.67matched
124capture01a1a7d2-437b-7e37-b440-3a9d9bfc38c5€9.00€0.19matched
125capture01a1a7d2-48ee-75ba-b2ca-83800c96506e€24.00€0.37matched
126refund01a1a7d2-58f4-78c8-9af1-7d638fd2e382-€26.00€0.00matched
127capture01a1a7d2-6ef3-770d-bae0-370c35da2c46€24.00€0.37matched
128capture01a1a7d2-7052-7cba-b2a7-19bb6b72d399€49.00€0.67matched
129capture01a1a7d2-8ea4-74b7-aada-65357a42c37d€9.00€0.19matched
130capture01a1a7d2-b02f-7fb1-a960-92c08a52f696€15.00€0.26matched
131capture01a1a7d2-b4d6-757f-b454-fd7b886e1cfb€15.00€0.26matched
132capture01a1a7d2-bc5c-7225-95c9-ee174b5ddc2c€9.00€0.19matched
133capture01a1a7d2-be3a-7553-b983-68eb7bffa873€49.00€0.67matched
134capture01a1a7d2-ced1-7101-be14-bf1cd0b8268d€24.00€0.37matched
135capture01a1a7d2-d6d0-7a7c-a7d5-10e8304950e6€15.00€0.26matched
136capture01a1a7d2-e91c-7585-a7cc-7ff66a89f80d€9.00€0.19matched