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

Gross

€2,796.00

PSP fee

€44.30

Net to the bank

€2,751.70

Settlement journal

#413093

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b008-9e45-761e-aeef-52d37b13c749 is already settled by stl_EUR_2989924 line 65
  • duplicate linethe file lists it twicecapture:01a1b009-8378-704c-9cc7-7aaa7483dfbf is already settled by stl_EUR_2989924 line 90
  • duplicate linethe file lists it twicecapture:01a1b00c-a44a-74fb-8f92-96e9c1d1f695 is already settled by stl_EUR_2989924 line 124
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 42, the contract says 37
  • missing linein the books, not in the filecapture:01a1b007-9b39-7daf-9b25-d4f9f25c251f is in no file
LineKindReferenceGrossFeeStatus
37capture01a1b006-1ec1-75e5-85e0-4ef38436d171€49.00€0.70fee difference
66capture01a1b008-9e9b-776b-8b83-e30e04a908ef€49.00€0.67duplicate line
91capture01a1b009-83aa-798b-97ef-8a9693a4032b€24.00€0.37duplicate line
97capture01a1b00a-5089-7d11-bd73-7a5ff6899c93€24.00€0.42fee difference
125capture01a1b00c-a473-784c-b14c-34fbed8c3874€15.00€0.26duplicate line
1capture01a1affc-35b4-79dd-8b28-8d6afd9effab€9.00€0.19matched
2capture01a1affd-ae99-70c7-92a5-7d30f79f5c9f€9.00€0.19matched
3capture01a1b003-5e19-7979-a162-a3f0b78f3aa2€49.00€0.67matched
4capture01a1b003-f617-763b-89c3-75d0aa65dff4€49.00€0.67matched
5capture01a1b004-339e-7295-9ab7-7e1c72c85a56€24.00€0.37matched
6capture01a1b004-398b-732e-9a81-6208139c3153€24.00€0.37matched
7capture01a1b004-39f4-7cd4-9882-537f3cfab3bc€9.00€0.19matched
8capture01a1b004-57fa-7097-9666-042708c70498€9.00€0.19matched
9capture01a1b004-65a6-71fc-9852-9bd9b4653a6d€15.00€0.26matched
10capture01a1b004-a468-76c0-982f-4a555a3a6a0c€9.00€0.19matched
11refund01a1b004-ad35-7022-a547-b5940c9f4886-€9.00€0.00matched
12refund01a1b004-b44d-762c-b4d3-bf5c527ee16f-€13.00€0.00matched
13capture01a1b004-bc7a-7320-9b54-de204b0104a7€15.00€0.26matched
14capture01a1b004-c682-78f3-8308-cbc65e999ad0€9.00€0.19matched
15capture01a1b004-e3f4-7953-aac4-6761c71ae158€15.00€0.26matched
16capture01a1b004-f688-771d-a760-6248e8748e85€15.00€0.26matched
17capture01a1b004-f746-78b2-b162-94de77f5acc8€35.00€0.50matched
18capture01a1b005-0066-77a1-be2d-533589de67ae€49.00€0.67matched
19capture01a1b005-0195-70d6-9efd-cd4c3d6cee56€9.00€0.19matched
20capture01a1b005-18e2-7e88-8c8c-12f42421f9ff€24.00€0.37matched
21capture01a1b005-21f3-79aa-a17b-26737101e4d5€24.00€0.37matched
22capture01a1b005-2851-7521-b99e-932ce3e108eb€35.00€0.50matched
23refund01a1b005-477e-73f6-a828-e14bcb1b3625-€7.00€0.00matched
24capture01a1b005-5139-75f4-9a51-ef2679be0e2f€9.00€0.19matched
25capture01a1b005-68c3-7069-83f7-643d30ba3804€49.00€0.67matched
26refund01a1b005-69b7-7764-b95b-daaa88d9f50e-€14.00€0.00matched
27capture01a1b005-8d5c-7151-b6ac-2521a3eb5dc4€24.00€0.37matched
28capture01a1b005-9633-7b29-9324-5c3fc3485923€49.00€0.67matched
29capture01a1b005-a617-71b3-9be6-433e8bb05502€35.00€0.50matched
30capture01a1b005-c33d-7f3c-aaad-7bee1206f6d3€9.00€0.19matched
31capture01a1b005-c47c-796e-8de6-2b4144722c1a€9.00€0.19matched
32refund01a1b005-c4b3-74c6-addd-edda6478584d-€15.00€0.00matched
33capture01a1b005-cafc-7137-aed8-e6e7d2b1de95€49.00€0.67matched
34capture01a1b005-d048-7783-8035-4931add10d87€15.00€0.26matched
35capture01a1b005-ff17-7d9e-9bfb-492a414624d1€9.00€0.19matched
36capture01a1b006-042e-74f0-82d7-34635cffac91€15.00€0.26matched
38refund01a1b006-334b-709d-9c3a-d07566904c3b-€4.00€0.00matched
39capture01a1b006-3cbb-7551-bca8-913e877068fb€35.00€0.50matched
40capture01a1b006-56ab-78d9-b837-7420da03e370€24.00€0.37matched
41capture01a1b006-91a4-704c-a1cb-7362880bd02a€35.00€0.50matched
42capture01a1b006-9395-7df3-a19f-bec0486f059c€24.00€0.37matched
43capture01a1b006-abc0-7715-acdf-c248e3c2e81b€9.00€0.19matched
44capture01a1b006-baa5-791b-9aa7-9dc928432590€35.00€0.50matched
45capture01a1b006-d9af-7d8d-a678-393b82131d73€15.00€0.26matched
46capture01a1b006-e3ca-7bdd-8574-ac87f6a4c1cf€24.00€0.37matched
47capture01a1b006-ebd5-7f9a-9b5e-d9241386e2c0€49.00€0.67matched
48capture01a1b006-f9d4-7c12-a96d-cc9ec39890f9€15.00€0.26matched
49capture01a1b007-1a17-7222-8e78-47fe1d825cb4€24.00€0.37matched
50capture01a1b007-3b0a-70a1-9b25-7d82e6fd3d61€9.00€0.19matched
51capture01a1b007-51a7-7139-8426-621239328070€49.00€0.67matched
52capture01a1b007-b2db-7bda-ab72-6950a9f38df4€35.00€0.50matched
53capture01a1b007-ba29-7c69-b187-1bed8c7226f0€49.00€0.67matched
54capture01a1b007-d743-7224-be86-25ffced69cd9€49.00€0.67matched
55capture01a1b008-0b48-7c40-956e-844416fea5fe€9.00€0.19matched
56capture01a1b008-1200-7969-acd0-82ac254e0e27€49.00€0.67matched
57capture01a1b008-1e89-7dbd-881b-1942a28c5a9d€24.00€0.37matched
58capture01a1b008-3828-794d-b1ca-5368a9893d3d€49.00€0.67matched
59capture01a1b008-3bd1-7273-b0bd-b042b1c68deb€35.00€0.50matched
60capture01a1b008-4767-7c5a-a498-98c0c8272a22€15.00€0.26matched
61capture01a1b008-6a62-7d89-ae69-6a01c235326b€49.00€0.67matched
62capture01a1b008-6f61-7e07-b976-b636cdb38867€24.00€0.37matched
63capture01a1b008-9001-7b9b-814b-437e72ae2eb0€15.00€0.26matched
64capture01a1b008-9b82-792b-b7c3-ec942fd8612a€24.00€0.37matched
65capture01a1b008-9e9b-776b-8b83-e30e04a908ef€49.00€0.67matched
67capture01a1b008-9fe5-7fd5-b306-7b5a67bd897f€9.00€0.19matched
68capture01a1b008-a344-7824-ad89-83f49688123d€15.00€0.26matched
69capture01a1b008-b156-7500-b60b-365b84a01935€24.00€0.37matched
70capture01a1b008-b59b-7d85-a9f3-9193da20b2d7€9.00€0.19matched
71capture01a1b008-ca33-7232-b388-8d2e3cbd3794€24.00€0.37matched
72capture01a1b008-cd79-7370-9245-6b7503653f53€49.00€0.67matched
73capture01a1b008-ea07-74ee-bcb9-5debfaa33753€15.00€0.26matched
74refund01a1b008-f8f5-75f3-96de-efd288f2486d-€4.00€0.00matched
75capture01a1b009-14f5-76ad-850a-2ca29e582891€9.00€0.19matched
76capture01a1b009-1c32-7da3-8169-4409c1050ed7€24.00€0.37matched
77capture01a1b009-2229-7ba6-acf1-8c27ebd6a3f5€15.00€0.26matched
78refund01a1b009-2730-72b7-8332-1e7005f5809b-€15.00€0.00matched
79capture01a1b009-2ff4-7f4a-bd73-7f2797250324€15.00€0.26matched
80capture01a1b009-32d3-79cb-bc5f-2d0586e26179€15.00€0.26matched
81capture01a1b009-3f99-779c-ae37-319932b5d465€35.00€0.50matched
82capture01a1b009-46e6-705c-9a55-d9f70cedd177€9.00€0.19matched
83capture01a1b009-4a1b-7811-a866-1da3cb1d6e9c€15.00€0.26matched
84capture01a1b009-50c8-7170-bad6-f68da062fa58€15.00€0.26matched
85capture01a1b009-5246-798f-abbc-b5cfa46ca33c€24.00€0.37matched
86capture01a1b009-5d4d-7a7a-9ae4-82509c774715€15.00€0.26matched
87capture01a1b009-5e18-75a1-9117-36cae9dd9f1e€49.00€0.67matched
88capture01a1b009-6d10-7d20-8b0b-e0ff05c3b0ab€35.00€0.50matched
89capture01a1b009-72a9-7f5b-b1d0-5807822f0a26€49.00€0.67matched
90capture01a1b009-83aa-798b-97ef-8a9693a4032b€24.00€0.37matched
92capture01a1b009-c10d-7d8d-b325-f13f1e1fc344€15.00€0.26matched
93capture01a1b009-c115-7035-8855-13a45b1c9e3e€49.00€0.67matched
94capture01a1b00a-1300-74f5-9429-d047b86e294e€49.00€0.67matched
95capture01a1b00a-34a5-7505-a2f7-397e8d075534€9.00€0.19matched
96refund01a1b00a-4f51-77d2-8680-ca44c1897757-€17.00€0.00matched
98capture01a1b00a-9f0a-7294-aeb2-2612a22fe1a7€9.00€0.19matched
99capture01a1b00a-bf60-7852-bda4-fcd150f256ee€15.00€0.26matched
100capture01a1b00a-cc72-73a0-b9e1-14b5fdaaee26€9.00€0.19matched
101capture01a1b00a-ec7e-7c91-a3f9-87460435939e€9.00€0.19matched
102capture01a1b00a-f6f3-72e4-95bf-c1b45f458e00€49.00€0.67matched
103capture01a1b00b-0146-7cce-a690-65e15a07263a€49.00€0.67matched
104capture01a1b00b-17e7-745d-97eb-57a3d8ba5e4c€9.00€0.19matched
105capture01a1b00b-2845-7001-a30b-8201359515e5€49.00€0.67matched
106refund01a1b00b-290d-7de1-88f6-29005067bdb3-€12.00€0.00matched
107capture01a1b00b-3e9a-747e-a2b4-ffcbe578a6a4€9.00€0.19matched
108capture01a1b00b-4d38-717a-90ae-c6257820fcc7€15.00€0.26matched
109capture01a1b00b-559d-7636-8f6d-c4c2a58355ae€49.00€0.67matched
110capture01a1b00b-6fad-7d85-b8cc-db788d98128b€15.00€0.26matched
111capture01a1b00b-7994-71f0-9ad8-016d269eef3e€35.00€0.50matched
112capture01a1b00b-aafb-7db4-bcb6-5f3bc1b24d94€35.00€0.50matched
113capture01a1b00b-b624-79ba-8622-3f45cdae42f8€35.00€0.50matched
114capture01a1b00b-be81-76a4-854d-9f34ce2add91€15.00€0.26matched
115capture01a1b00b-bed4-7106-a26f-fdc49ff8f93f€15.00€0.26matched
116capture01a1b00b-cc50-7fff-9efa-6825cfbd0fcf€49.00€0.67matched
117capture01a1b00b-dede-7158-b63f-162eb5a8233b€9.00€0.19matched
118capture01a1b00c-1a92-7e9a-8a5f-e87c001d02f7€35.00€0.50matched
119capture01a1b00c-3e27-7786-85a8-745cebe03c4e€9.00€0.19matched
120capture01a1b00c-3f80-7729-9970-519be466ba23€9.00€0.19matched
121capture01a1b00c-625f-7179-97b7-7cc006ff4bf2€9.00€0.19matched
122capture01a1b00c-66aa-7985-abbc-2dd7903d743c€9.00€0.19matched
123capture01a1b00c-6b30-7c0a-9863-c500163d622f€35.00€0.50matched
124capture01a1b00c-a473-784c-b14c-34fbed8c3874€15.00€0.26matched