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, 16:30

Gross

€3,039.00

PSP fee

€47.78

Net to the bank

€2,991.22

Settlement journal

#382367

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a76a-fb12-7ccc-b1e2-94803695e056 is already settled by stl_EUR_2989683 line 79
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 53, the contract says 50
  • missing linein the books, not in the filecapture:01a1a76b-8935-7219-8ba0-a8ab7ed27491 is in no file
LineKindReferenceGrossFeeStatus
80capture01a1a76a-fb2c-7223-aa9a-c171f796d5e0€35.00€0.50duplicate line
93capture01a1a76b-dcf3-7cb7-9dd7-8ee22609ec47€9.00€0.20fee difference
126capture01a1a76e-4d50-7525-978a-7c1a8204e0f1€35.00€0.53fee difference
1capture01a1a75d-0804-7652-bd23-cc64af99852a€35.00€0.50matched
2capture01a1a75e-967c-74e3-8e6a-7e12d963d51a€35.00€0.50matched
3capture01a1a75f-cec4-73ab-a362-4ad1b9fc1d34€15.00€0.26matched
4capture01a1a761-5887-7f51-86a3-328ea8b34d50€15.00€0.26matched
5capture01a1a765-1cbc-7298-971a-1006e510bf53€49.00€0.67matched
6capture01a1a765-935e-7df9-a52f-c0eb58940d9d€15.00€0.26matched
7capture01a1a765-a22b-7917-9e95-7423e9114010€9.00€0.19matched
8capture01a1a765-b100-7549-9615-34ef7b9fb5f4€35.00€0.50matched
9capture01a1a765-c774-7061-b673-92772bda6fc1€9.00€0.19matched
10capture01a1a766-05a4-7e68-a043-06f28dbddc23€49.00€0.67matched
11capture01a1a766-3f2c-7c59-bded-68b93d7b8bcd€24.00€0.37matched
12capture01a1a766-6c53-768a-b425-3de5cc69ba96€35.00€0.50matched
13capture01a1a766-895b-787d-82d6-f1b64a4ccaf4€49.00€0.67matched
14capture01a1a766-a56d-74b5-9b15-9fd8888199e8€9.00€0.19matched
15capture01a1a766-c520-7661-93e8-a82fe21e6ae1€24.00€0.37matched
16capture01a1a766-d534-79bc-b41b-13f669e4d188€35.00€0.50matched
17capture01a1a766-d876-7148-9133-e4fe5687b4df€49.00€0.67matched
18capture01a1a766-f0d3-70e8-8b10-34b5067a5dd3€35.00€0.50matched
19capture01a1a766-fb42-7ca5-9a9f-3afa937af6cb€24.00€0.37matched
20capture01a1a766-fcae-77ee-a9c0-a46c1f05ae4c€24.00€0.37matched
21capture01a1a767-11fd-7052-b4d2-4289ae8514d9€24.00€0.37matched
22capture01a1a767-22db-7ffa-a204-d1d113967b73€9.00€0.19matched
23capture01a1a767-237f-7fe8-b2ac-89dcbf0e6da6€24.00€0.37matched
24capture01a1a767-267a-70b3-9ad0-6962b1b140cc€15.00€0.26matched
25capture01a1a767-55d3-7c95-af33-d6b61bef5572€24.00€0.37matched
26capture01a1a767-71a4-77be-bf69-5361acfea7df€49.00€0.67matched
27capture01a1a767-7d73-7c0a-8c84-cf9fac3c21af€35.00€0.50matched
28capture01a1a767-9e3f-7ed2-a29e-5507a2920776€35.00€0.50matched
29capture01a1a767-ab8a-7d1d-9ce9-1a04a358b41d€49.00€0.67matched
30capture01a1a767-df78-7c57-af07-6ac62d631e75€9.00€0.19matched
31capture01a1a767-eb82-7b58-a925-e8d2ce3d471e€24.00€0.37matched
32capture01a1a768-1433-7f83-9375-ca6b8fb56999€49.00€0.67matched
33capture01a1a768-382d-734f-a625-6690aa6c70fe€49.00€0.67matched
34capture01a1a768-44bf-7bd9-b2fd-0e64f4095d05€15.00€0.26matched
35capture01a1a768-5c39-7899-85f4-cc28a3dfcdeb€35.00€0.50matched
36capture01a1a768-6457-7668-8da1-fdb7f57313ac€24.00€0.37matched
37capture01a1a768-78a3-709a-9e6c-ff725c39f59f€15.00€0.26matched
38capture01a1a768-9496-7158-91b7-226aeca8436e€15.00€0.26matched
39capture01a1a768-af06-75b8-bc26-7f105d48459a€35.00€0.50matched
40capture01a1a768-af3a-78c9-a2d7-d79b8a96ea86€15.00€0.26matched
41capture01a1a768-c9d1-7bcf-a5a1-639ca13be0f6€9.00€0.19matched
42capture01a1a768-cac6-77e1-8fe6-54dcd12b8de9€9.00€0.19matched
43capture01a1a768-cd3e-7979-ad81-0527f5fd489a€24.00€0.37matched
44capture01a1a768-f6bc-7e81-9a44-53f878a6bfe0€9.00€0.19matched
45capture01a1a769-1497-7a51-9453-a4c0e3f28cfa€24.00€0.37matched
46capture01a1a769-466f-7da4-9610-91db55ce7287€24.00€0.37matched
47capture01a1a769-4b8b-7e3d-bdc6-6611fba6f141€15.00€0.26matched
48capture01a1a769-52e8-7879-9aa6-683a5a3780f6€9.00€0.19matched
49capture01a1a769-541f-78d4-931f-af48275d431a€9.00€0.19matched
50capture01a1a769-5bc2-75be-bc06-396133aea5ee€9.00€0.19matched
51refund01a1a769-6788-7798-9307-a51ecc3cec5f-€20.00€0.00matched
52capture01a1a769-7ae4-785d-8d55-cefce3ad087c€24.00€0.37matched
53capture01a1a769-7cb7-70e8-8226-5a71418af421€35.00€0.50matched
54capture01a1a769-8b73-711e-a3f3-d2c3f500987a€49.00€0.67matched
55capture01a1a769-8f38-7591-9ca9-a761fc4211d5€24.00€0.37matched
56capture01a1a769-8fc4-7bc3-8211-287241e405ec€15.00€0.26matched
57capture01a1a769-9c47-732b-ba4f-d239aa55be17€24.00€0.37matched
58capture01a1a769-a6b8-76b5-a0c9-1fc7c5143969€35.00€0.50matched
59capture01a1a769-ac71-7460-a610-0294daf82986€9.00€0.19matched
60capture01a1a769-acd1-75d6-b77e-37d502f60ccb€15.00€0.26matched
61refund01a1a769-bf4b-7704-8dcb-f9b709b929e0-€8.00€0.00matched
62capture01a1a769-c497-78ad-b5f2-c9d7bfc45a1c€15.00€0.26matched
63capture01a1a769-daba-7daa-82f4-48cdf6869ed9€49.00€0.67matched
64capture01a1a769-e038-77d9-ad92-fbaf2fa43efc€9.00€0.19matched
65capture01a1a769-ea72-7fa7-80f9-ab31b8e52df8€15.00€0.26matched
66capture01a1a769-f30e-7a59-9c53-6d4f86a5c3d5€9.00€0.19matched
67capture01a1a76a-2889-72e2-b1c5-3a08fb50cbb8€24.00€0.37matched
68capture01a1a76a-2bf1-7fa8-a976-3b834db9b1d6€35.00€0.50matched
69capture01a1a76a-8a57-7a36-ab41-7f32663887d7€9.00€0.19matched
70capture01a1a76a-9bf8-792f-99a2-12e918c1443a€24.00€0.37matched
71capture01a1a76a-ab0b-77e4-ba6f-eb4ab57a5165€35.00€0.50matched
72capture01a1a76a-cf5a-7651-ba1a-8ba8eedbf8ff€24.00€0.37matched
73refund01a1a76a-d4ad-7500-89ce-3bffe8d01dba-€29.00€0.00matched
74capture01a1a76a-e509-7b9f-9eb4-e4d87fd2a037€9.00€0.19matched
75capture01a1a76a-dc40-7a3b-8035-3bafe9748b0c€49.00€0.67matched
76capture01a1a76a-f571-768f-a031-6bceaedfcc8e€9.00€0.19matched
77capture01a1a76a-f677-7a72-b322-469b4d0f6df6€35.00€0.50matched
78capture01a1a76a-f9bb-76f1-b0cc-5de4b4485458€24.00€0.37matched
79capture01a1a76a-fb2c-7223-aa9a-c171f796d5e0€35.00€0.50matched
81capture01a1a76a-fffb-7b84-a13a-eb68dc26a394€24.00€0.37matched
82capture01a1a76b-08df-7e63-ab9b-2cac7d9d6408€24.00€0.37matched
83capture01a1a76b-1854-781e-be7d-f62e53d09cf7€35.00€0.50matched
84capture01a1a76b-4b7e-77d8-b175-3fec728b4186€15.00€0.26matched
85capture01a1a76b-5e8c-7371-9182-dbf77764f191€15.00€0.26matched
86capture01a1a76b-6b57-7ca8-9fc3-df84ecc75223€15.00€0.26matched
87capture01a1a76b-72d0-781f-9ef8-366f08cc7772€35.00€0.50matched
88capture01a1a76b-a646-7f36-8762-cee07471ff5b€49.00€0.67matched
89capture01a1a76b-aac2-78b1-9499-f533801eaec9€24.00€0.37matched
90capture01a1a76b-b466-7544-9eef-9d987fc9aec3€35.00€0.50matched
91capture01a1a76b-beaa-7162-9584-5c4daecfc81e€15.00€0.26matched
92capture01a1a76b-d394-71a7-9563-c55e477ab9e0€35.00€0.50matched
94capture01a1a76b-e497-711e-b302-153a4609a56c€35.00€0.50matched
95capture01a1a76c-2103-7f07-9064-9e46da04c0b5€15.00€0.26matched
96capture01a1a76c-378f-7e8e-a0a4-c490d63044e8€49.00€0.67matched
97capture01a1a76c-54cb-71ea-a591-b402a2d03480€35.00€0.50matched
98capture01a1a76c-64d6-7c55-b050-e7fe3414d52b€9.00€0.19matched
99capture01a1a76c-9b85-757f-8b2b-6017ba6fb6e0€9.00€0.19matched
100capture01a1a76c-c9ab-72df-a61d-18f66f2b7985€49.00€0.67matched
101capture01a1a76c-d128-70c4-8e8a-1115805a194f€15.00€0.26matched
102capture01a1a76c-d506-7cd2-bee6-13d6004be6b8€9.00€0.19matched
103capture01a1a76c-dd76-7e1b-8247-0ea3bda3244d€9.00€0.19matched
104capture01a1a76c-d922-774b-99ed-b15d5c68d6fc€9.00€0.19matched
105capture01a1a76c-f12f-7422-a8e8-10e479148a8a€24.00€0.37matched
106capture01a1a76d-0c0b-7de1-af03-6aca96763488€24.00€0.37matched
107refund01a1a76d-1647-7373-b54a-596503773b4f-€24.00€0.00matched
108capture01a1a76d-339d-7e89-bf9a-9a28b728baa6€49.00€0.67matched
109capture01a1a76d-33c6-73a1-951a-8e7b2795f69e€9.00€0.19matched
110capture01a1a76d-428a-7dc1-bb67-bcd0822b5b1a€15.00€0.26matched
111capture01a1a76d-60ac-788a-b03c-22002ec5b53b€49.00€0.67matched
112capture01a1a76d-63d2-7f54-9d7b-d2f69fe8133a€49.00€0.67matched
113capture01a1a76d-6bed-7401-8448-5cbf13bb3c94€9.00€0.19matched
114capture01a1a76d-8a18-7655-ad0a-96b3428da48c€35.00€0.50matched
115capture01a1a76d-9f0c-7c2b-af07-3de9b376bd5c€9.00€0.19matched
116capture01a1a76d-b23e-7fbb-a3b7-8ddb38a569d6€24.00€0.37matched
117capture01a1a76d-b57e-7671-b7a2-ae0c3ced74b6€49.00€0.67matched
118capture01a1a76d-e0c7-7946-b40b-61795e84ff1e€15.00€0.26matched
119refund01a1a76d-f989-7c78-8f5d-c94e03464997-€26.00€0.00matched
120capture01a1a76e-0180-7f13-9d50-8008d436b96e€35.00€0.50matched
121capture01a1a76e-199c-7fae-91bd-f166c073b188€9.00€0.19matched
122capture01a1a76e-26a0-70f1-9959-8a591a56ef2a€24.00€0.37matched
123capture01a1a76e-2993-79ab-930e-dbaf24f1bf23€24.00€0.37matched
124capture01a1a76e-39ff-768e-bb44-ca2a6e8fe38b€49.00€0.67matched
125capture01a1a76e-3d39-717d-b60c-eaa660eb9d0f€15.00€0.26matched
127capture01a1a76e-5fa5-7ec6-92e9-f5b3ba71c16f€49.00€0.67matched
128capture01a1a76e-645d-7fa6-9cf3-00729cb19319€35.00€0.50matched