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

3 Nov, 19:50

Gross

€2,878.00

PSP fee

€46.18

Net to the bank

€2,831.82

Settlement journal

#366687

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a2fa-c512-7698-b26b-a7c3cc8427fd is already settled by stl_EUR_2989559 line 63
  • duplicate linethe file lists it twicerefund:01a1a2fe-562a-7790-aae2-40f428b55a13 is already settled by stl_EUR_2989559 line 118
  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
LineKindReferenceGrossFeeStatus
5capture01a1a2f6-3371-7f36-a3ed-f2cb919c7b9c€9.00€0.21fee difference
24capture01a1a2f8-05f5-756e-9cfb-d5bf027951b2€9.00€0.21fee difference
64capture01a1a2fa-db88-7563-94e9-7c53ecd78e60€24.00€0.37duplicate line
119refund01a1a2fe-562b-7330-b46c-a549caccedd2-€9.00€0.00duplicate line
1capture01a1a2ee-efe8-70a5-a485-c1f1ccde8686€15.00€0.26matched
2capture01a1a2f0-05d3-7c8c-92cd-bed6dcd3c0bb€35.00€0.50matched
3capture01a1a2f3-ba9f-74e2-88e8-d85bd016f6c7€24.00€0.37matched
4capture01a1a2f6-3362-711a-a23e-cf2bb037524a€15.00€0.26matched
6capture01a1a2f6-5dfa-79a1-8f5b-063caed6bf7c€9.00€0.19matched
7capture01a1a2f6-7132-7ee1-baee-7661bcbabd26€24.00€0.37matched
8capture01a1a2f6-7a74-7709-b847-6fe1723af695€9.00€0.19matched
9capture01a1a2f6-79d3-7270-84ad-749c0d3a623b€49.00€0.67matched
10capture01a1a2f6-8754-7ca7-a3ec-e1d9ee2631ad€15.00€0.26matched
11capture01a1a2f6-940a-7269-9661-cc019556055a€24.00€0.37matched
12capture01a1a2f6-9cac-7dff-bc82-65817e974b30€24.00€0.37matched
13capture01a1a2f6-b973-76a1-b9e6-1aa7c8cad525€49.00€0.67matched
14capture01a1a2f6-d9a1-7283-b746-f8336af19648€15.00€0.26matched
15capture01a1a2f7-2ef9-7f27-93ab-d49d5bf8d9f4€24.00€0.37matched
16capture01a1a2f7-4385-7d99-96f6-211ff986b99e€49.00€0.67matched
17refund01a1a2f7-5eff-741b-9f19-62fae8c28e33-€16.00€0.00matched
18capture01a1a2f7-8af0-7c4d-8973-209a671143fe€49.00€0.67matched
19capture01a1a2f7-aa6c-704c-9b6a-2a209ed2b339€15.00€0.26matched
20capture01a1a2f7-cf8d-721a-823e-d5692c614003€15.00€0.26matched
21capture01a1a2f7-d2b1-7430-a2f1-a84160e8c0a3€49.00€0.67matched
22capture01a1a2f7-da09-77b4-9ff4-e5aebca997dd€9.00€0.19matched
23capture01a1a2f7-dd6c-7cde-8910-4a595cd5155f€35.00€0.50matched
25capture01a1a2f8-0ebf-7ce2-820f-1f3590cc9689€9.00€0.19matched
26capture01a1a2f8-16e6-783c-800d-dc4ece351d15€15.00€0.26matched
27capture01a1a2f8-1e37-7ca0-8671-5c2c29318fc5€35.00€0.50matched
28capture01a1a2f8-34c0-7def-af80-7b7ebcfb8629€49.00€0.67matched
29capture01a1a2f8-4426-718d-b229-43933998bf85€49.00€0.67matched
30capture01a1a2f8-4ea9-725b-b4c0-621c974daf97€15.00€0.26matched
31capture01a1a2f8-840c-7e0e-942e-3a39b81d00f2€15.00€0.26matched
32capture01a1a2f8-9bcc-772b-b37f-2eaa284505d0€35.00€0.50matched
33capture01a1a2f8-beb2-70c6-a2d7-9fb67b5819f1€35.00€0.50matched
34capture01a1a2f8-d814-78b7-8744-05428049ef4c€49.00€0.67matched
35capture01a1a2f8-e244-7f3c-b4b3-061b874386a3€24.00€0.37matched
36capture01a1a2f9-08ab-7f10-bfc0-68ec084b749e€49.00€0.67matched
37capture01a1a2f9-19b0-7957-a30c-5dc69653888a€24.00€0.37matched
38capture01a1a2f9-2123-7665-9ac0-fcb4dd765e35€35.00€0.50matched
39capture01a1a2f9-37bc-7ed4-bc7a-aad386019d21€49.00€0.67matched
40capture01a1a2f9-5275-7836-8fd9-f08d858334f8€15.00€0.26matched
41refund01a1a2f9-52b5-7186-ae28-ef20f46841c2-€18.00€0.00matched
42capture01a1a2f9-55f2-78f0-8a15-caa53f3efbea€9.00€0.19matched
43capture01a1a2f9-924f-7cd7-9288-4cae2771e7af€9.00€0.19matched
44capture01a1a2f9-b518-7eb4-a0a5-a4bc3bb8cae0€15.00€0.26matched
45capture01a1a2f9-cd5b-74a5-a90d-cab67e793c45€15.00€0.26matched
46capture01a1a2f9-ed99-71ca-bed0-005e2ef01eed€15.00€0.26matched
47capture01a1a2f9-ef13-7815-a7c9-9c3409e6abc4€15.00€0.26matched
48capture01a1a2f9-f159-71e6-b8b0-fba1cca3e8cb€35.00€0.50matched
49capture01a1a2f9-fbf9-7d2a-9ace-5d723faf30a0€9.00€0.19matched
50capture01a1a2fa-0504-70b2-b2c4-b0fed728a8df€9.00€0.19matched
51capture01a1a2fa-314e-70cd-b552-7944bbbc79e0€35.00€0.50matched
52capture01a1a2fa-469b-74aa-9c90-db3e4b263e79€24.00€0.37matched
53capture01a1a2fa-474f-7dd5-9a3e-0ded0266cc0c€24.00€0.37matched
54capture01a1a2fa-4be1-7312-9b59-a83146f6b7e9€24.00€0.37matched
55capture01a1a2fa-568f-7fc5-bfc2-811b8aec9aaf€9.00€0.19matched
56capture01a1a2fa-573f-729e-bf56-a92f6d942109€24.00€0.37matched
57capture01a1a2fa-5c8e-7b1a-9199-2bbf7688a91e€9.00€0.19matched
58capture01a1a2fa-725d-7e07-912b-612be5edd18f€35.00€0.50matched
59capture01a1a2fa-8b0f-7e75-90a7-89617a51f0a7€35.00€0.50matched
60capture01a1a2fa-a382-70ef-9719-a25371938adc€35.00€0.50matched
61refund01a1a2fa-ab5a-73e2-9c11-25248ee64d05-€17.00€0.00matched
62capture01a1a2fa-ca72-7e08-b798-e86144d66ed3€15.00€0.26matched
63capture01a1a2fa-db88-7563-94e9-7c53ecd78e60€24.00€0.37matched
65capture01a1a2fa-ed69-74b9-815a-cbca2fae304e€49.00€0.67matched
66capture01a1a2fb-0593-73b2-9928-e425752b0a96€35.00€0.50matched
67capture01a1a2fb-08e7-7cda-906a-786b3566c679€24.00€0.37matched
68refund01a1a2fb-3107-750a-a606-f3dd1ded17f6-€33.00€0.00matched
69capture01a1a2fb-35c9-701b-98a4-a370c97ee1fa€49.00€0.67matched
70capture01a1a2fb-3bdd-7ecd-960f-4de3e543e058€49.00€0.67matched
71capture01a1a2fb-4613-7587-8832-a8c2271c676b€49.00€0.67matched
72capture01a1a2fb-80e2-747c-8241-0ac1e636bd6d€35.00€0.50matched
73capture01a1a2fb-871c-7706-a6c9-cd63543ae8da€35.00€0.50matched
74capture01a1a2fb-8e8f-71fb-b0f6-9b64a633019a€15.00€0.26matched
75capture01a1a2fb-91be-748a-8273-c36cbabd3ed4€49.00€0.67matched
76capture01a1a2fb-93b1-73e0-87d3-cc7194a76e36€49.00€0.67matched
77capture01a1a2fb-ad36-7eaf-b1e8-d7da61384c5c€35.00€0.50matched
78refund01a1a2fb-cd62-7716-a613-e529556eccac-€40.00€0.00matched
79capture01a1a2fb-dd6b-7d51-aa6d-f4e8d83b3c05€15.00€0.26matched
80capture01a1a2fb-e226-7e7e-881c-0930f05eb78e€35.00€0.50matched
81capture01a1a2fb-f574-7f3b-b68c-753619944c11€24.00€0.37matched
82capture01a1a2fc-06dd-7288-b9dd-26421d0b185b€49.00€0.67matched
83capture01a1a2fc-072c-744a-a08d-89e6494a4bb1€9.00€0.19matched
84capture01a1a2fc-098b-7f80-9e67-18d45d42d406€15.00€0.26matched
85capture01a1a2fc-1192-70b6-9aae-0adbd9a46f83€35.00€0.50matched
86capture01a1a2fc-1f18-7b7e-9cef-81fa0592659b€9.00€0.19matched
87capture01a1a2fc-5ea5-7e30-946b-fd51b956a611€49.00€0.67matched
88capture01a1a2fc-683d-7c27-ba76-66bd4940a2bb€24.00€0.37matched
89capture01a1a2fc-6b1f-7f3b-80a5-c6916d7febbb€9.00€0.19matched
90refund01a1a2fc-6e6b-7ef6-8080-3070d1b48f9f-€33.00€0.00matched
91capture01a1a2fc-6eba-79f7-99ef-d70bdfdebd4c€49.00€0.67matched
92capture01a1a2fc-798f-791f-b27a-f9be9c9d41b5€9.00€0.19matched
93capture01a1a2fc-b9bd-7cef-98e8-006808b6bdce€9.00€0.19matched
94capture01a1a2fc-bc4d-7048-98be-c1b7bf35a46d€35.00€0.50matched
95capture01a1a2fc-c804-70b3-8a67-cd4351ecc12f€9.00€0.19matched
96capture01a1a2fc-d915-7ec6-b4e7-a26becf0952a€35.00€0.50matched
97capture01a1a2fc-ef92-7872-9e47-98e6ae8a5cb3€35.00€0.50matched
98capture01a1a2fd-0739-7556-8f0a-6a0dcff756f4€9.00€0.19matched
99capture01a1a2fd-0a88-7229-98f0-f346eff0e78b€35.00€0.50matched
100capture01a1a2fd-0b42-7b80-9f95-3f1cf00ad545€15.00€0.26matched
101capture01a1a2fd-0ce2-7b3a-8e0c-9b4f036feb6e€15.00€0.26matched
102capture01a1a2fd-1c5b-739b-98d9-83b57f1fc18f€35.00€0.50matched
103capture01a1a2fd-1dd8-745d-8669-72d12573844d€24.00€0.37matched
104capture01a1a2fd-1f6b-7f13-8bc2-5b5db5fdf40f€15.00€0.26matched
105capture01a1a2fd-2095-767d-ade7-97444ad1d55a€9.00€0.19matched
106capture01a1a2fd-70de-762b-bf08-31afae220f64€9.00€0.19matched
107capture01a1a2fd-7303-72af-8371-edd34e3333a3€24.00€0.37matched
108capture01a1a2fd-87e7-711c-8637-359fd66862bb€9.00€0.19matched
109capture01a1a2fd-bf7f-70be-82cf-47f6c9dd134e€9.00€0.19matched
110capture01a1a2fd-dc20-79d8-8376-f6be1d9af4c3€24.00€0.37matched
111capture01a1a2fd-e3d7-7e10-a4f0-1cc9d6e2beb4€24.00€0.37matched
112capture01a1a2fe-003b-7d59-b185-4f144ef52aec€15.00€0.26matched
113capture01a1a2fe-0803-75b2-89ca-ade4242734f4€24.00€0.37matched
114capture01a1a2fe-1669-7ffd-8071-50122e96bd47€49.00€0.67matched
115capture01a1a2fe-16ce-70be-8829-0bca3873648f€35.00€0.50matched
116capture01a1a2fe-1e04-7a29-9700-3755cfb81082€24.00€0.37matched
117capture01a1a2fe-334f-786c-83a0-f7a3d76f1043€49.00€0.67matched
118refund01a1a2fe-562b-7330-b46c-a549caccedd2-€9.00€0.00matched
120capture01a1a2fe-7a21-7f70-bc75-5e8aba258aca€49.00€0.67matched
121capture01a1a2fe-9c76-7144-a384-5b11ea16c791€24.00€0.37matched
122capture01a1a2fe-de5a-7cb1-b710-aebce00a62b7€24.00€0.37matched
123capture01a1a2fe-ee64-7672-8e83-9fddd138e71f€9.00€0.19matched
124capture01a1a2ff-0e0f-7890-a9d1-675228eba9cd€24.00€0.37matched
125capture01a1a2ff-3235-794c-a419-b5d4e1d07c5d€24.00€0.37matched