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, 07:50

Gross

€3,203.00

PSP fee

€51.24

Net to the bank

€3,151.76

Settlement journal

#375785

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a58a-14f8-749e-99b2-e9e6c338081e is already settled by stl_EUR_2989631 line 10
  • duplicate linethe file lists it twicecapture:01a1a58c-ae69-74f8-9350-1354cda9016f is already settled by stl_EUR_2989631 line 55
  • duplicate linethe file lists it twicecapture:01a1a58c-f1d0-79bd-a379-326daf7f675c is already settled by stl_EUR_2989631 line 58
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
  • missing linein the books, not in the filecapture:01a1a58c-6164-78ef-beba-284f3fb99f35 is in no file
  • missing linein the books, not in the filecapture:01a1a591-a16d-7d47-90d5-34de69bab0a6 is in no file
LineKindReferenceGrossFeeStatus
11capture01a1a58a-151a-7a6c-bb5e-95fa2f5c164b€49.00€0.67duplicate line
46capture01a1a58c-5e30-7c34-beee-ecaf9ea1273f€9.00€0.23fee difference
56capture01a1a58c-ae7d-7e11-a032-9b56d94fe0fc€24.00€0.37duplicate line
59capture01a1a58c-f1fa-7f04-91ec-08b263f42484€24.00€0.37duplicate line
1capture01a1a581-064d-7880-8e95-55896691432f€24.00€0.37matched
2capture01a1a589-776e-73e2-9a5e-538ead674f6a€9.00€0.19matched
3capture01a1a589-7ae1-709b-8442-8712766d611b€9.00€0.19matched
4capture01a1a589-ba6b-7f2e-b7b1-651ec0b13c8e€49.00€0.67matched
5capture01a1a589-bc09-7c63-9908-7ce0e84faec9€49.00€0.67matched
6capture01a1a589-efed-7ea3-8734-e099212921c4€49.00€0.67matched
7capture01a1a589-f1ec-7746-b7d1-b944e8c15c4b€49.00€0.67matched
8capture01a1a589-ebc8-7668-8453-bb9328e4c918€24.00€0.37matched
9capture01a1a589-f816-7c6c-9d3a-3587fdad6501€24.00€0.37matched
10capture01a1a58a-151a-7a6c-bb5e-95fa2f5c164b€49.00€0.67matched
12capture01a1a58a-1bd0-7d45-99d5-1637562529be€15.00€0.26matched
13capture01a1a58a-2189-7206-8c8c-21056a5b5ee3€49.00€0.67matched
14refund01a1a58a-4211-793c-aab2-f1565754d248-€44.00€0.00matched
15capture01a1a58a-42dc-7217-8b10-c6fd83e9316d€24.00€0.37matched
16capture01a1a58a-4685-775f-bd89-115cff040526€24.00€0.37matched
17capture01a1a58a-4a1b-779c-a80f-bf3d60321d24€9.00€0.19matched
18capture01a1a58a-5855-70bf-bdd9-02fc709d95b2€9.00€0.19matched
19capture01a1a58a-76cb-7137-9f18-362ac57c049a€35.00€0.50matched
20capture01a1a58a-7a56-72ae-b74e-969c8b320022€24.00€0.37matched
21capture01a1a58a-85a7-7699-9e82-060f4e30a386€49.00€0.67matched
22capture01a1a58a-a4c2-7a2b-ad45-abd2804d1a3d€35.00€0.50matched
23capture01a1a58a-b148-798e-ba3b-fb7cf5d1d572€15.00€0.26matched
24capture01a1a58a-c727-7e83-bc43-16beebf5ed25€15.00€0.26matched
25capture01a1a58a-d510-77e4-b973-7f387e837f52€49.00€0.67matched
26capture01a1a58a-d8ae-7047-b0fc-fe714d153230€49.00€0.67matched
27capture01a1a58a-e4b4-7659-a2fe-3a201777cbc0€35.00€0.50matched
28capture01a1a58b-065a-782d-bd8d-423ac4e013c8€35.00€0.50matched
29capture01a1a58b-2df9-77f6-b37f-7e5edad4589a€15.00€0.26matched
30capture01a1a58b-3576-75e3-b57a-1807dd34bb9c€24.00€0.37matched
31capture01a1a58b-37e0-76fa-a19e-598b2811faf2€9.00€0.19matched
32capture01a1a58b-3bd5-7909-8913-7cfc59a98506€15.00€0.26matched
33capture01a1a58b-5eea-7736-87ff-94b4d14ac9c6€35.00€0.50matched
34capture01a1a58b-6239-75c3-8faf-0f9d97120ed3€15.00€0.26matched
35capture01a1a58b-baf0-7c0f-baed-f8bfb0a6aa82€35.00€0.50matched
36capture01a1a58b-bb66-71c7-bb54-150763e99b3a€15.00€0.26matched
37capture01a1a58b-ed85-7221-97a9-4539d7f3f875€9.00€0.19matched
38capture01a1a58b-f17b-7578-be11-ed922f60c249€35.00€0.50matched
39capture01a1a58b-f708-7f78-a9c8-29cc5b855b8d€49.00€0.67matched
40capture01a1a58b-fce8-703d-9c7f-b432203e1f82€49.00€0.67matched
41capture01a1a58c-048a-77b0-adfb-bb1d7b42ed8c€15.00€0.26matched
42capture01a1a58c-2dd2-7f87-81b3-4a2a4bebb2e0€15.00€0.26matched
43capture01a1a58c-34ec-709d-aeb4-768469a1d0ba€15.00€0.26matched
44capture01a1a58c-3e22-79ff-b759-9f0864f2cfd2€15.00€0.26matched
45capture01a1a58c-4672-7a10-aaa2-c65d1e3758d2€15.00€0.26matched
47capture01a1a58c-5e87-78b2-b923-45024006653f€15.00€0.26matched
48refund01a1a58c-7699-7e89-bb5c-61f541b62da1-€13.00€0.00matched
49refund01a1a58c-7f4d-774d-b351-9af26ad1a74d-€11.00€0.00matched
50capture01a1a58c-892a-7f83-94e7-52dbccec9bd0€15.00€0.26matched
51capture01a1a58c-8b53-70f9-9558-226a93aba282€9.00€0.19matched
52capture01a1a58c-a466-7574-be74-bca2ab531ea9€9.00€0.19matched
53capture01a1a58c-a5f2-72c5-a56b-5b2dad9e978b€49.00€0.67matched
54refund01a1a58c-a856-7247-ac92-f2aa0d983009-€8.00€0.00matched
55capture01a1a58c-ae7d-7e11-a032-9b56d94fe0fc€24.00€0.37matched
57capture01a1a58c-bf96-78e9-976e-266f1e6675bb€24.00€0.37matched
58capture01a1a58c-f1fa-7f04-91ec-08b263f42484€24.00€0.37matched
60capture01a1a58c-f8a7-79f0-ae38-a4751cd621a9€49.00€0.67matched
61capture01a1a58d-1e8c-7d92-9277-05e84c951bce€35.00€0.50matched
62capture01a1a58d-30eb-72db-a56c-5de4e728f667€9.00€0.19matched
63capture01a1a58d-3af2-7428-9d69-6eabb9dc1565€35.00€0.50matched
64capture01a1a58d-3c93-7904-9098-07c75c7d8907€49.00€0.67matched
65capture01a1a58d-5725-782f-8df1-d71c86a7ac10€15.00€0.26matched
66capture01a1a58d-643e-77ec-9553-4f48c1bf9d0c€15.00€0.26matched
67capture01a1a58d-65d8-7cd1-aa53-1663c3b85213€24.00€0.37matched
68capture01a1a58d-67d0-7f53-a4c0-fa929ea0a32b€15.00€0.26matched
69capture01a1a58d-7da3-7ffa-856a-2eac3ffa660a€15.00€0.26matched
70capture01a1a58d-9530-7b29-b135-ec5cda779545€9.00€0.19matched
71capture01a1a58d-999c-724d-aad8-6edeacfd22c4€15.00€0.26matched
72capture01a1a58d-9b0e-78ad-a86e-43e69f649ec4€35.00€0.50matched
73capture01a1a58d-a1aa-7154-a1a1-09f66ebe3f63€9.00€0.19matched
74capture01a1a58d-ad70-71cf-9321-7381ccdd73c8€15.00€0.26matched
75capture01a1a58d-bd95-7dae-86ed-02fa8f50e1b8€9.00€0.19matched
76capture01a1a58d-c646-7aa0-be5f-b13df045b884€24.00€0.37matched
77capture01a1a58d-c8d9-75df-bd5e-695556a2bf8c€15.00€0.26matched
78capture01a1a58d-e790-7693-9442-956d8fbd4c65€49.00€0.67matched
79capture01a1a58d-e792-7878-a4d4-ef2b9119bf37€35.00€0.50matched
80capture01a1a58d-ee61-7fce-8064-2ce5fd9c2e8d€24.00€0.37matched
81capture01a1a58d-f0fa-73b6-af37-1caac9c649e7€9.00€0.19matched
82capture01a1a58e-0ec0-77c6-8729-0ec665248a19€9.00€0.19matched
83capture01a1a58e-4c72-7eeb-83cb-c9b24f73f896€49.00€0.67matched
84capture01a1a58e-6035-76c5-a345-3c29ea4ad5d8€24.00€0.37matched
85capture01a1a58e-6567-770d-b001-cae134c0f385€15.00€0.26matched
86capture01a1a58e-8754-775a-b72e-865aeea8c73f€9.00€0.19matched
87capture01a1a58e-895a-7e91-9ad9-8ea6e44015cb€49.00€0.67matched
88capture01a1a58e-940c-7c9a-b88a-dd4ee8bc0039€49.00€0.67matched
89capture01a1a58e-a850-79f7-8c4c-b7798a0d20d0€35.00€0.50matched
90capture01a1a58e-b8d4-7faf-af7f-5d11a1db9f44€24.00€0.37matched
91capture01a1a58e-c22d-7ee1-adce-c540840ba685€15.00€0.26matched
92capture01a1a58e-ca9a-7ccf-aef6-6e39f37455c8€49.00€0.67matched
93capture01a1a58e-dd03-70a6-87ca-9c1a88a67d7b€24.00€0.37matched
94capture01a1a58e-dd54-7271-bd74-2a1272bf346b€15.00€0.26matched
95capture01a1a58f-5140-7949-a7e7-144eaa0e2f9b€15.00€0.26matched
96capture01a1a58f-5c25-732a-8187-35b7f7423a6c€35.00€0.50matched
97capture01a1a58f-6e8d-79d7-9361-28889ff3e781€35.00€0.50matched
98capture01a1a58f-8387-7442-8cfb-3af2016f8534€35.00€0.50matched
99capture01a1a58f-8c8c-7db3-a08c-5030ecbedf0b€35.00€0.50matched
100capture01a1a58f-b10f-7459-b5e1-6514918a1e4c€9.00€0.19matched
101capture01a1a58f-b175-7e64-81e5-82e3a501214e€24.00€0.37matched
102capture01a1a58f-c367-7b1c-a271-3e604af5d244€24.00€0.37matched
103capture01a1a58f-c3f9-7d2f-8d43-80160ed0c7e2€49.00€0.67matched
104capture01a1a58f-cd43-7dd1-ba54-aa9f399788d9€15.00€0.26matched
105capture01a1a58f-da19-7e08-97b3-63d724963d23€9.00€0.19matched
106capture01a1a58f-ddb8-76bf-9570-6352e3afe0a9€9.00€0.19matched
107capture01a1a58f-f571-79dc-8cfb-7b8b66f5d116€9.00€0.19matched
108capture01a1a590-08a6-760c-b0f3-1000abdb2330€15.00€0.26matched
109capture01a1a590-1d0b-73f7-b281-b1176bed8335€24.00€0.37matched
110capture01a1a590-5bcc-7765-86d2-797b7c4bdd3d€9.00€0.19matched
111capture01a1a590-6ff3-71c1-8e5e-ef87cd98f48c€15.00€0.26matched
112capture01a1a590-7057-7de3-9706-c540c104c7ff€24.00€0.37matched
113capture01a1a590-727a-708a-9464-51b2edd50da0€9.00€0.19matched
114capture01a1a590-8264-7a14-a738-cb2cab579c64€9.00€0.19matched
115refund01a1a590-8752-79f4-8037-c53e0261112c-€6.00€0.00matched
116refund01a1a590-ab5b-7710-9596-abddeb52e73c-€2.00€0.00matched
117capture01a1a590-b255-7c5d-b36e-3fee7c699d57€35.00€0.50matched
118capture01a1a590-bfa6-7096-8144-54542b225422€24.00€0.37matched
119capture01a1a590-c58b-72f7-8d31-ba941dcd8261€35.00€0.50matched
120capture01a1a590-c6a8-785e-bc2b-e63ef631064b€15.00€0.26matched
121capture01a1a590-de1e-727c-8fad-3ed8b906864b€24.00€0.37matched
122capture01a1a590-f673-724f-bc34-e88d8efe4130€35.00€0.50matched
123capture01a1a590-f9cf-7b19-abdd-b8b5cbc6a29a€9.00€0.19matched
124capture01a1a591-1630-7329-ae02-a36ddd85c88d€9.00€0.19matched
125capture01a1a591-1f32-7ec0-ab10-e3589ae5c898€9.00€0.19matched
126capture01a1a591-22ef-75a4-b068-f98610bc0d89€35.00€0.50matched
127capture01a1a591-2427-7b6c-9b2f-babb3c05f9f2€9.00€0.19matched
128capture01a1a591-331b-77c0-8f7d-cf01d94a09e3€9.00€0.19matched
129capture01a1a591-35b4-7f6b-b712-e161b3f6907a€35.00€0.50matched
130capture01a1a591-3ce8-7d62-89ac-599526ab5464€9.00€0.19matched
131capture01a1a591-4870-77bc-b675-582448ec9618€15.00€0.26matched
132capture01a1a591-501c-76c4-bb16-d5bc6b881bcd€49.00€0.67matched
133refund01a1a591-51d8-7aa1-a692-611493250c50-€6.00€0.00matched
134capture01a1a591-607a-7823-9182-beaa5d9d4cbe€35.00€0.50matched
135refund01a1a591-817e-7842-bb92-7ec6a79e918d-€8.00€0.00matched
136capture01a1a591-a1d9-7e7a-a8b8-06fcc6a26b1d€24.00€0.37matched
137refund01a1a591-a7c9-712c-9b14-23c69af6eedf-€45.00€0.00matched
138capture01a1a591-e0cc-784c-af38-dc728ed501fe€15.00€0.26matched
139capture01a1a591-e969-7c56-9bb8-1c633b78f8d1€49.00€0.67matched
140refund01a1a592-05d4-7305-92ff-c3a9167fa0e9-€7.00€0.00matched
141capture01a1a592-1ddb-758d-b0b2-062d8c97ccac€9.00€0.19matched
142capture01a1a592-26f0-79b2-8761-2f67c2feb097€24.00€0.37matched
143capture01a1a592-378e-73b5-ab75-c055cdd06c79€49.00€0.67matched
144capture01a1a592-47dd-72d6-9150-4b797b5b5bdb€24.00€0.37matched
145capture01a1a592-4e3e-77cf-bc5a-38d4df89f98e€24.00€0.37matched