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

Gross

€3,277.00

PSP fee

€53.21

Net to the bank

€3,223.79

Settlement journal

#349084

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19e01-857e-7dda-aabd-1e13e841ebca is already settled by stl_EUR_2989420 line 52
  • duplicate linethe file lists it twicecapture:01a19e02-27d2-7249-bf5d-6a952fdeea83 is already settled by stl_EUR_2989420 line 65
  • duplicate linethe file lists it twicecapture:01a19e02-7ebb-74de-90a5-09ad0bff29b0 is already settled by stl_EUR_2989420 line 73
  • fee differencethe fee is not the contract feethe fee is 4, the contract says 0
  • missing linein the books, not in the filecapture:01a19e02-71ca-788a-8651-5287c73b9be6 is in no file
LineKindReferenceGrossFeeStatus
53capture01a19e01-85a0-7a17-8ab2-5328e7703453€49.00€0.67duplicate line
66capture01a19e02-2a9b-7b08-ac66-ef3bdb6a3cb6€35.00€0.50duplicate line
74capture01a19e02-7ed8-77c4-a30c-7ef146010df7€9.00€0.19duplicate line
109refund01a19e04-a4ad-7131-b77a-02d2383bda28-€16.00€0.04fee difference
1capture01a19df4-cb7a-7412-9baf-b9cd3cae67dc€9.00€0.19matched
2capture01a19df4-ccc1-7fff-95ca-4ee2c023885a€9.00€0.19matched
3capture01a19dfd-bc3e-732e-9ffd-65c4aba49245€24.00€0.37matched
4capture01a19dfd-df76-7d29-b5d0-cb65261710aa€49.00€0.67matched
5capture01a19dfd-e894-72f7-b3c4-e803ad471ed4€24.00€0.37matched
6capture01a19dfe-0298-7f40-b363-8630b97bcb00€49.00€0.67matched
7capture01a19dfe-0baa-73ee-bd15-2a8c3c10f576€15.00€0.26matched
8capture01a19dfe-3d94-7fc1-8922-b75efd8a6007€24.00€0.37matched
9capture01a19dfe-8a8a-7b8f-92d0-2378db4e87ac€15.00€0.26matched
10capture01a19dfe-8b9c-7c30-b63f-c91d5c431291€24.00€0.37matched
11capture01a19dfe-8f3a-7d63-b8fc-05fc1962ed7c€35.00€0.50matched
12capture01a19dfe-9a83-7e9d-9c37-c972c14b200c€35.00€0.50matched
13capture01a19dfe-a18b-7157-b513-c66dbf922f70€35.00€0.50matched
14capture01a19dfe-a2da-7cd0-a2c0-5b7a58b0e9f6€9.00€0.19matched
15refund01a19dfe-ced2-7cd0-ba67-ab1780d25e4f-€20.00€0.00matched
16capture01a19dfe-d759-7dba-a774-16e7e975f5b5€49.00€0.67matched
17capture01a19dfe-f646-7f53-9657-359c3e23cc82€24.00€0.37matched
18capture01a19dfe-fd56-73d2-9ce8-3ce3e56ca88e€15.00€0.26matched
19capture01a19dff-0305-738c-93b2-683165e654f9€15.00€0.26matched
20capture01a19dff-0995-727c-8183-f0d60aca3a98€35.00€0.50matched
21capture01a19dff-34d1-7322-a1ca-0bb383f5c88f€49.00€0.67matched
22capture01a19dff-35d9-71da-bc44-df090ba254b7€35.00€0.50matched
23capture01a19dff-464f-7978-895f-a45707e78a9c€49.00€0.67matched
24capture01a19dff-58f8-72b0-94a8-d61072d460ac€35.00€0.50matched
25capture01a19dff-5e21-70f6-bf58-2053b73cc43b€49.00€0.67matched
26capture01a19dff-7cb2-7373-a4a5-60670555a5f6€49.00€0.67matched
27capture01a19dff-7e66-700f-a3ff-1923ca39c731€35.00€0.50matched
28capture01a19dff-9993-771b-b407-6a1f33de4ade€15.00€0.26matched
29capture01a19dff-99ae-7337-9943-ea8befc2bfcd€24.00€0.37matched
30capture01a19dff-9bc5-7875-999f-f2927e991f7d€49.00€0.67matched
31capture01a19dff-ae90-7f82-bff3-f7843f299233€35.00€0.50matched
32refund01a19dff-afa0-7e64-b2cc-09f9c647f85a-€20.00€0.00matched
33capture01a19dff-c792-7560-ac2f-3333f9f1791b€35.00€0.50matched
34capture01a19dff-e66e-7ca9-8ad8-72b09ede4bfc€35.00€0.50matched
35capture01a19dff-f65c-7f94-aa5b-c4221334abba€49.00€0.67matched
36capture01a19e00-0680-7258-887b-9460f8bda2c0€24.00€0.37matched
37capture01a19e00-2356-79f8-95fb-f0b9811c4e34€24.00€0.37matched
38capture01a19e00-2ba7-7ec4-99eb-03383f4a840a€15.00€0.26matched
39capture01a19e00-2c88-7e42-93d8-53add68c4c93€24.00€0.37matched
40capture01a19e00-4a3e-7527-8010-79b64c011aa4€24.00€0.37matched
41capture01a19e00-540a-76dc-b9ae-b81e5c68fe6a€9.00€0.19matched
42capture01a19e00-9480-7aaa-bdb5-bf9298a5c5e5€15.00€0.26matched
43capture01a19e00-a078-7b1b-858b-1968ebb35912€24.00€0.37matched
44capture01a19e00-d977-7d60-9a3c-5ab90f1be5e9€9.00€0.19matched
45capture01a19e00-e732-7360-893c-4b1d8fe3bebe€49.00€0.67matched
46capture01a19e00-f4c5-7338-a8e9-40920ddf5ddb€35.00€0.50matched
47capture01a19e01-0765-7847-b9d8-693451c3439d€24.00€0.37matched
48capture01a19e01-3908-7023-8a8d-ecbf054b5941€15.00€0.26matched
49capture01a19e01-5621-761c-98df-5267b11dda22€9.00€0.19matched
50capture01a19e01-5a0a-7e98-bf6d-8d581e37eebb€35.00€0.50matched
51capture01a19e01-651e-7ff3-8742-c36e5ee030cf€15.00€0.26matched
52capture01a19e01-85a0-7a17-8ab2-5328e7703453€49.00€0.67matched
54capture01a19e01-85bd-7794-8503-cea546dbd68c€49.00€0.67matched
55capture01a19e01-86f4-7d30-8235-8e9c97113c1d€24.00€0.37matched
56capture01a19e01-8b82-7608-a1bf-959163248f51€49.00€0.67matched
57capture01a19e01-9004-7716-a6dd-4691b1928e49€9.00€0.19matched
58capture01a19e01-894d-72af-ae08-3fd6cbb20db5€24.00€0.37matched
59capture01a19e01-95ec-765d-9477-8f9d932a0288€35.00€0.50matched
60refund01a19e01-b66f-7127-be5f-d81853ad3ecf-€37.00€0.00matched
61capture01a19e01-cf08-78c0-a22b-89f63d4aa054€49.00€0.67matched
62capture01a19e01-e70c-788e-8bf7-33368ea6b416€15.00€0.26matched
63capture01a19e01-f394-7bea-a972-daf3f548cd45€49.00€0.67matched
64capture01a19e02-1ca5-7ed2-92df-774c4a86fed6€15.00€0.26matched
65capture01a19e02-2a9b-7b08-ac66-ef3bdb6a3cb6€35.00€0.50matched
67capture01a19e02-2cfd-7aa1-9b39-b15786fdb4e8€15.00€0.26matched
68capture01a19e02-36ba-7f4f-a787-3b7aae8512af€15.00€0.26matched
69capture01a19e02-3e22-7e61-926c-8cf16916a3f4€24.00€0.37matched
70capture01a19e02-5984-7288-b3a1-52c7f42a9c59€9.00€0.19matched
71capture01a19e02-779c-7c62-b90d-88eccd0b36b0€9.00€0.19matched
72capture01a19e02-7a56-7fc1-b773-a15f976b43d6€15.00€0.26matched
73capture01a19e02-7ed8-77c4-a30c-7ef146010df7€9.00€0.19matched
75capture01a19e02-7e9c-7c39-956f-6584758282b4€49.00€0.67matched
76refund01a19e02-8497-7ffc-9918-d3bdcfdb8a74-€27.00€0.00matched
77capture01a19e02-8505-749c-bf03-77116ab39db0€9.00€0.19matched
78capture01a19e02-85f3-7f7e-89f6-89c4b8b0cb12€35.00€0.50matched
79capture01a19e02-be86-7f52-b6a9-370bf75d6a1b€15.00€0.26matched
80capture01a19e02-c49d-7808-b427-83fcb1243a4c€49.00€0.67matched
81capture01a19e02-c53c-7642-9eee-b7046f7db079€9.00€0.19matched
82capture01a19e02-ce5c-71b8-8904-116e06a73bf3€49.00€0.67matched
83capture01a19e02-cf6f-711c-8275-5e535e2d7729€15.00€0.26matched
84capture01a19e02-de5a-760d-bf74-3c9f4fb4d7b8€49.00€0.67matched
85capture01a19e02-f2dd-793d-8f58-15fe056f6f3c€35.00€0.50matched
86capture01a19e02-f3f8-7090-8a24-629b79643756€49.00€0.67matched
87refund01a19e03-06cd-7e96-b53f-452f8fa9be73-€46.00€0.00matched
88capture01a19e03-0806-74f0-8198-eb3c90155fd8€24.00€0.37matched
89capture01a19e03-0e2c-72ce-ab95-04d1cad8287b€9.00€0.19matched
90capture01a19e03-224b-781c-bae1-71d0cdbbecb0€9.00€0.19matched
91capture01a19e03-28e5-7f02-83b6-2ca7cc788bda€15.00€0.26matched
92capture01a19e03-2a71-7da2-8d6a-b5a8cb235f21€24.00€0.37matched
93refund01a19e03-419a-71ba-b2f2-2b6b486570fe-€36.00€0.00matched
94refund01a19e03-4484-7c3d-9377-f54543524d96-€13.00€0.00matched
95capture01a19e03-7bd5-717f-94b6-f06881d24c1b€24.00€0.37matched
96capture01a19e03-e0d2-7473-97c1-a4d1966af7cb€15.00€0.26matched
97capture01a19e03-e8da-740d-ad5b-7eb6e68578d6€15.00€0.26matched
98capture01a19e03-f517-7fb2-ba6b-2bf44b3d988e€15.00€0.26matched
99capture01a19e03-f82f-751d-899b-24982911dadd€9.00€0.19matched
100capture01a19e03-fa92-7544-91f8-7deaa60185cb€49.00€0.67matched
101capture01a19e04-1718-7201-b231-63f4bc7ed1f8€24.00€0.37matched
102capture01a19e04-1c9e-7c7d-ae00-c9456208ea8a€9.00€0.19matched
103capture01a19e04-3096-72a9-93d9-01071b9cdf75€35.00€0.50matched
104capture01a19e04-3d5c-707d-8aa6-c25023508964€9.00€0.19matched
105capture01a19e04-4443-7e05-8cfe-76a5129914e4€35.00€0.50matched
106capture01a19e04-6c6e-75ad-8fa1-3be6cc9964d4€35.00€0.50matched
107capture01a19e04-76bc-7a96-8fe5-32f1f0b85c85€24.00€0.37matched
108capture01a19e04-7ca4-7bd4-90c3-c8e65878f4dd€49.00€0.67matched
110capture01a19e04-b215-7a62-8657-dabcfc27cf3c€35.00€0.50matched
111capture01a19e04-c90d-7a53-a1dd-37bd88abbad0€35.00€0.50matched
112capture01a19e04-d563-782d-88d8-bf689dc446d1€35.00€0.50matched
113capture01a19e04-de82-7b6d-9a33-d79f079e71c6€15.00€0.26matched
114capture01a19e04-f526-7fbf-9a69-1ad64d1eb053€49.00€0.67matched
115capture01a19e05-178a-7d60-821a-105b89e2bf11€15.00€0.26matched
116capture01a19e05-1a12-77e8-999d-1dd4042c9230€24.00€0.37matched
117capture01a19e05-4335-7f36-b78f-58b7c77d27d5€35.00€0.50matched
118capture01a19e05-5012-725b-897e-64f8bb060100€24.00€0.37matched
119capture01a19e05-603d-7e60-be7a-bff84fb0b7b3€49.00€0.67matched
120capture01a19e05-6141-7bc6-8136-3d20a75235ce€15.00€0.26matched
121capture01a19e05-681b-7e04-a304-21223e1e9727€9.00€0.19matched
122capture01a19e05-81c5-7a70-8e4a-d96808074471€49.00€0.67matched
123capture01a19e05-9385-7546-abef-072d51a42f19€35.00€0.50matched
124capture01a19e05-9f1f-7405-9679-1bef5a2b3bef€49.00€0.67matched
125refund01a19e05-a4c3-7dae-84c7-4e87e0b6af64-€8.00€0.00matched
126capture01a19e05-b193-7e67-8429-5a7b4a977d24€49.00€0.67matched
127refund01a19e05-c989-7fa8-b804-559f84fcc113-€26.00€0.00matched
128capture01a19e06-31d5-73f2-a6d2-f64f77d58dcf€35.00€0.50matched
129capture01a19e06-3c39-7a94-bc9a-5dc7ef404cd5€15.00€0.26matched
130capture01a19e06-4194-7634-84c0-ca8e933b25b1€35.00€0.50matched
131capture01a19e06-4c4e-74e0-9117-93fed606bbb8€15.00€0.26matched
132capture01a19e06-4e18-7a30-bb97-ff44bf3930e0€15.00€0.26matched
133capture01a19e06-5d05-7b55-8b6c-83ad28f66214€35.00€0.50matched
134refund01a19e06-6813-7d80-a3cd-76f140bb0435-€33.00€0.00matched
135capture01a19e06-6ad6-7eff-a8ac-b31c0056561b€9.00€0.19matched
136capture01a19e06-79df-78b3-aede-2c85226b83cd€35.00€0.50matched
137capture01a19e06-7a63-7311-8e9e-cb778b0250d6€35.00€0.50matched
138capture01a19e06-7b12-7002-b838-5616ea981732€15.00€0.26matched
139capture01a19e06-856f-7034-b640-1b31c346803a€9.00€0.19matched
140capture01a19e06-96cb-70f8-adb9-59037e1dcecd€15.00€0.26matched