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

2 Nov, 01:50

Gross

€3,033.00

PSP fee

€48.14

Net to the bank

€2,984.86

Settlement journal

#334762

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a199f5-d800-7849-b33d-5efa2c1097da is already settled by stl_EUR_2989307 line 40
  • duplicate linethe file lists it twicecapture:01a199f7-0ab0-7fae-a9c3-e546d8d3738a is already settled by stl_EUR_2989307 line 56
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 28, the contract says 26
  • missing linein the books, not in the filecapture:01a199f3-24ab-77cf-a25e-90940a34835e is in no file
  • missing linein the books, not in the filecapture:01a199fb-3c66-72b4-ace2-60f0b35a5fea is in no file
LineKindReferenceGrossFeeStatus
41capture01a199f5-d821-731a-a349-b5636fadee19€35.00€0.50duplicate line
42capture01a199f5-e1ed-75e2-b9fb-8a77f2a70082€49.00€0.68fee difference
57capture01a199f7-0af1-7435-a2d4-00b4c934bff7€9.00€0.19duplicate line
106capture01a199f9-a257-7dae-948a-eaf2f9c779af€15.00€0.28fee difference
1capture01a199ee-ee6f-77af-bbf5-abe4c83d7ae8€35.00€0.50matched
2capture01a199f1-8f42-72cc-9564-9278a0002bcf€9.00€0.19matched
3capture01a199f3-0324-7dc9-ae09-2727366c648f€15.00€0.26matched
4capture01a199f3-5195-7dd1-a0a2-3d9178524785€9.00€0.19matched
5capture01a199f3-85d3-70e2-b08f-465121d0cf3b€35.00€0.50matched
6capture01a199f3-93d6-7767-b247-756b63bbc28a€49.00€0.67matched
7capture01a199f3-b1d8-7b41-9dd6-3f04de840c3c€49.00€0.67matched
8capture01a199f3-b184-7229-8716-bd447d923239€49.00€0.67matched
9refund01a199f3-c97d-72c5-a3b1-a59810d1b005-€19.00€0.00matched
10capture01a199f3-ce28-7f96-b3ae-89e8edfe6b66€35.00€0.50matched
11capture01a199f3-e588-7f09-a4dd-4c1627c8c596€24.00€0.37matched
12refund01a199f3-ec7b-7d45-9df1-bb109121020e-€40.00€0.00matched
13capture01a199f3-f6f4-7480-95fc-ca510495479e€49.00€0.67matched
14capture01a199f4-27bd-7045-8a5e-538f387f151e€15.00€0.26matched
15capture01a199f4-37c3-75a0-b85d-888fd61e883e€49.00€0.67matched
16capture01a199f4-4291-71a0-a996-a84775f6c398€9.00€0.19matched
17capture01a199f4-5570-71c7-8964-45eecf244f49€49.00€0.67matched
18capture01a199f4-58c1-7903-aefd-da057fddfaa9€49.00€0.67matched
19capture01a199f4-6f9b-7c5e-96bc-fb1f57b8a43f€9.00€0.19matched
20capture01a199f4-84a4-7c99-9f64-8c68ef4cc981€35.00€0.50matched
21capture01a199f4-8ff0-71a7-9034-d2e1460108d9€24.00€0.37matched
22capture01a199f4-993a-7351-b392-02745a32055d€15.00€0.26matched
23capture01a199f4-9b1a-73f6-b422-ad9a1516f6d7€49.00€0.67matched
24capture01a199f4-9f35-7849-837f-99d7239aa665€24.00€0.37matched
25capture01a199f4-cbf1-70b4-acc9-fc30dd9cb41d€35.00€0.50matched
26capture01a199f4-e21d-75fb-b92e-bfdf95472149€49.00€0.67matched
27capture01a199f4-e863-7a24-9542-c3e873952339€15.00€0.26matched
28refund01a199f4-f63a-7354-9c17-69acdd6ea85f-€15.00€0.00matched
29capture01a199f5-181c-7bd3-bb14-b298939ab404€9.00€0.19matched
30capture01a199f5-2478-7847-9028-63dccca818f2€9.00€0.19matched
31capture01a199f5-2d89-7784-827d-d499610c7d30€24.00€0.37matched
32capture01a199f5-3845-724f-aca4-f01b3d9e70ed€24.00€0.37matched
33capture01a199f5-4504-74af-96dc-33b0041b8343€35.00€0.50matched
34capture01a199f5-5776-7101-ad48-8503346a2443€15.00€0.26matched
35capture01a199f5-6fd3-7644-b40d-b523c67aca82€15.00€0.26matched
36capture01a199f5-7a50-7263-b61b-461acaa0d76b€35.00€0.50matched
37capture01a199f5-cee0-7551-b3a2-98d4e81b7aff€24.00€0.37matched
38capture01a199f5-cfc9-7ba9-9053-6846217bc6d5€15.00€0.26matched
39capture01a199f5-d112-7f56-ad7e-8c4890c2c3f9€15.00€0.26matched
40capture01a199f5-d821-731a-a349-b5636fadee19€35.00€0.50matched
43capture01a199f6-0be2-735a-8857-84110aefaf97€35.00€0.50matched
44capture01a199f6-16b6-7a6e-b6c6-233ed83b42e1€24.00€0.37matched
45capture01a199f6-23a2-7b1b-8280-28fd2e5dc1a6€35.00€0.50matched
46capture01a199f6-2a19-7ff3-b8d6-07fc9bb395a4€49.00€0.67matched
47capture01a199f6-7bdb-73a1-8eaa-9dca924479d5€35.00€0.50matched
48capture01a199f6-9872-7a6a-a28a-dc5688f64113€9.00€0.19matched
49capture01a199f6-ad62-7d64-b55b-0bc2c154cd4b€49.00€0.67matched
50capture01a199f6-b163-7469-ace6-5573f4ef221c€49.00€0.67matched
51capture01a199f6-b4f0-74f1-8e56-58d719d8b2bf€9.00€0.19matched
52capture01a199f6-b771-75ca-aff2-d16af62e502c€15.00€0.26matched
53capture01a199f6-dfbc-784a-99f3-526ac9974926€35.00€0.50matched
54capture01a199f6-eeec-75ee-af6a-3d2eb35aab66€9.00€0.19matched
55capture01a199f7-0608-7887-ada8-a982c423291d€35.00€0.50matched
56capture01a199f7-0af1-7435-a2d4-00b4c934bff7€9.00€0.19matched
58capture01a199f7-1413-7756-8e39-89cae2f7ac97€49.00€0.67matched
59capture01a199f7-1de7-7672-a490-5759614b9d0a€15.00€0.26matched
60capture01a199f7-2640-721c-b0f8-81ac248ad674€15.00€0.26matched
61capture01a199f7-5cae-729f-81ce-e2e84a6a3c57€49.00€0.67matched
62capture01a199f7-7af6-7562-a9a7-d87ff2fb5341€15.00€0.26matched
63capture01a199f7-7ea6-7453-aad7-29419e7ec901€35.00€0.50matched
64capture01a199f7-8edb-749b-90db-bb7881be798b€49.00€0.67matched
65capture01a199f7-a0e9-746c-b181-4a1309bb978b€9.00€0.19matched
66capture01a199f7-a330-78a9-8a4b-ab5c48c1f93b€15.00€0.26matched
67capture01a199f7-d52d-7215-9584-14bdc40e1d78€24.00€0.37matched
68capture01a199f7-daa7-7b5d-975c-e87ef0e9fa72€49.00€0.67matched
69capture01a199f7-df67-74a5-8fa4-67ef6f658b29€24.00€0.37matched
70capture01a199f7-e86b-7293-a328-a7aae316286c€24.00€0.37matched
71capture01a199f7-eaf7-7094-862f-42048887d954€24.00€0.37matched
72refund01a199f7-f94d-72a9-9fac-ae67b2f3cc50-€2.00€0.00matched
73capture01a199f7-fa0e-789e-8058-86fc588e9621€9.00€0.19matched
74capture01a199f7-fcbc-71fe-9bc0-ddbef3c21c6d€24.00€0.37matched
75capture01a199f8-0db8-776e-83fb-fe80e715be90€9.00€0.19matched
76capture01a199f8-21bf-743f-8568-036e2f7ac185€35.00€0.50matched
77capture01a199f8-3a37-777f-b484-6b52b1ac8746€15.00€0.26matched
78capture01a199f8-41be-7f53-841f-88226fdeb37a€49.00€0.67matched
79capture01a199f8-4376-796a-be9d-cecf374d05bc€9.00€0.19matched
80capture01a199f8-447f-773b-87d3-1985552dad4d€49.00€0.67matched
81refund01a199f8-6351-77bf-bd3b-0d850801bb68-€4.00€0.00matched
82capture01a199f8-6c24-7856-bcf2-ca490b0218fa€49.00€0.67matched
83capture01a199f8-793f-7541-a4e6-a824c75c212b€9.00€0.19matched
84capture01a199f8-7c85-75f9-a387-5a61162c3ff7€24.00€0.37matched
85capture01a199f8-85ec-7d6f-8e8a-607f35b49203€9.00€0.19matched
86capture01a199f8-88e8-7487-b5ae-d062458c15ae€15.00€0.26matched
87refund01a199f8-9788-75ad-9cf3-bc7898dd8147-€9.00€0.00matched
88capture01a199f8-9fe3-7189-923c-c73680966587€24.00€0.37matched
89refund01a199f8-a18d-761e-ab82-d9a4a827cdd1-€6.00€0.00matched
90capture01a199f8-a834-7610-a7c4-1d60e81dc427€15.00€0.26matched
91capture01a199f8-d4c9-704b-9d59-ade301524197€24.00€0.37matched
92capture01a199f8-ec72-71b4-9164-afe752c48545€15.00€0.26matched
93capture01a199f9-095e-7fa6-9a81-e87ff2102516€9.00€0.19matched
94capture01a199f9-10c7-7f1e-b5f8-ceda8ca30f4c€49.00€0.67matched
95capture01a199f9-12af-7486-99f3-361c58d3bf74€35.00€0.50matched
96capture01a199f9-1c97-7641-8c3b-ae37654031c2€35.00€0.50matched
97capture01a199f9-48e7-768c-ba48-cc9673474a3c€49.00€0.67matched
98capture01a199f9-4c5f-765f-986b-472784543b35€15.00€0.26matched
99capture01a199f9-55d3-7637-bafd-9fd9f6da8f30€9.00€0.19matched
100capture01a199f9-5b59-79c7-b17d-cb7edcbd7e92€9.00€0.19matched
101capture01a199f9-74b3-7a1c-9c71-bfd54264fea8€24.00€0.37matched
102capture01a199f9-8632-715d-81f0-044e391195bc€49.00€0.67matched
103refund01a199f9-8bda-77ac-b2fc-9537d4288ef1-€25.00€0.00matched
104capture01a199f9-959e-7f29-a998-abbee6019bd7€35.00€0.50matched
105capture01a199f9-9984-70cc-85ac-8acfd6a202e4€9.00€0.19matched
107capture01a199f9-b821-7a38-8377-575ccdfb00b7€9.00€0.19matched
108capture01a199f9-b8b1-7e3c-ace2-f198973598e1€15.00€0.26matched
109capture01a199f9-c561-7e48-9060-1734674165d9€15.00€0.26matched
110capture01a199f9-e99c-7209-9ee8-c819f799881d€24.00€0.37matched
111capture01a199fa-0178-7823-be91-0b2a5ceeb150€24.00€0.37matched
112capture01a199fa-0eff-7372-94c6-4590b0433e72€24.00€0.37matched
113capture01a199fa-20a5-70b0-be11-b4e127123c1e€9.00€0.19matched
114capture01a199fa-2185-72b9-b8c1-d7a4e73ed8ca€9.00€0.19matched
115capture01a199fa-2219-7984-9588-aa2c38fa751d€35.00€0.50matched
116capture01a199fa-2aef-7dae-bfd1-3be70c475571€15.00€0.26matched
117refund01a199fa-400c-762e-bbd5-f745f6b53fcf-€21.00€0.00matched
118capture01a199fa-6a66-7186-8a05-44eef9813eff€9.00€0.19matched
119capture01a199fa-8b10-75b7-ac06-49afb8965ce0€9.00€0.19matched
120capture01a199fa-b7f3-74df-b557-922fbd412f76€15.00€0.26matched
121capture01a199fa-b9df-7101-983e-8a21458d9067€24.00€0.37matched
122capture01a199fa-cf8f-7429-aa86-86e9cb01ba7c€49.00€0.67matched
123capture01a199fa-e018-7ed0-8cd7-6166f3001468€49.00€0.67matched
124capture01a199fb-3ecf-73be-b7e7-c32678d6b17f€9.00€0.19matched
125capture01a199fb-7fb5-79c8-a310-fa7981ef719a€9.00€0.19matched
126capture01a199fb-87ca-7098-82d5-4691856a48b9€35.00€0.50matched
127capture01a199fb-aa04-762e-be7b-66f0cb5d2ee1€9.00€0.19matched
128capture01a199fb-ad88-7fd1-8999-6dc546427446€24.00€0.37matched
129refund01a199fb-aec2-7202-b778-74f43dc9e8a3-€2.00€0.00matched
130capture01a199fb-d0d9-7ebd-9792-7a1317f88356€24.00€0.37matched
131capture01a199fb-d54b-7f76-9916-278922beac6d€9.00€0.19matched
132capture01a199fb-fcc2-794f-8e7e-8155e9b644b5€49.00€0.67matched
133capture01a199fc-025f-76b4-9dab-48e571a56e52€24.00€0.37matched