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

1 Nov, 10:20

Gross

€3,031.00

PSP fee

€48.30

Net to the bank

€2,982.70

Settlement journal

#322915

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a196a5-2da1-7469-8a27-22341812d9a3 is already settled by stl_EUR_2989214 line 86
  • fee differencethe fee is not the contract feethe fee is 4, the contract says 0
  • missing linein the books, not in the filecapture:01a196a2-be00-7c17-9c36-5e85d878c9b1 is in no file
LineKindReferenceGrossFeeStatus
87capture01a196a5-2dcc-7754-83e7-aa3dca363d1b€9.00€0.19duplicate line
115refund01a196a6-ad30-7c7d-8c78-0e7688050423-€5.00€0.04fee difference
1capture01a19698-f1c2-75a7-93d2-9ec744935c91€9.00€0.19matched
2capture01a1969d-bc9c-766d-a30a-41ef611e9cf5€35.00€0.50matched
3capture01a1969f-ce17-7623-8205-47afda1c2890€49.00€0.67matched
4capture01a1969f-dabd-7bb6-b5f6-258e3c4d386e€49.00€0.67matched
5capture01a1969f-f0ea-770b-8cc1-beeda48498e2€15.00€0.26matched
6capture01a196a0-0958-79af-94a7-a6f3ba6442a8€49.00€0.67matched
7capture01a196a0-2501-7491-beac-f4e6b17bf23d€15.00€0.26matched
8capture01a196a0-5d3e-7b46-83a3-146644929ebb€35.00€0.50matched
9capture01a196a0-7139-76fe-bd9e-04d0332d6f5b€35.00€0.50matched
10capture01a196a0-72c0-7f4f-9899-2617576687aa€9.00€0.19matched
11capture01a196a0-73bf-7465-a5f4-0110a4ac3203€15.00€0.26matched
12capture01a196a0-a02f-7cfb-ae3e-5f2253723e4c€49.00€0.67matched
13capture01a196a0-a420-7656-ac0c-eec7ba715bf3€24.00€0.37matched
14capture01a196a0-bbcf-7937-89d1-c6c1acdfa1a6€24.00€0.37matched
15capture01a196a0-cdf5-7fee-a610-4b0094866616€49.00€0.67matched
16capture01a196a1-06db-7ca6-9a7d-31d3d30dc59d€35.00€0.50matched
17capture01a196a1-4549-7412-9ee0-ea8f34fafc17€15.00€0.26matched
18capture01a196a1-8996-75ab-a25f-47eef6be0251€24.00€0.37matched
19capture01a196a1-93a1-74f7-b450-bc67d7f3692b€15.00€0.26matched
20refund01a196a1-a875-73f4-9555-4457441a5619-€11.00€0.00matched
21capture01a196a1-b286-7baf-a777-e482eff986a4€35.00€0.50matched
22capture01a196a1-b2ee-7193-b4ea-4eda10955cf5€15.00€0.26matched
23capture01a196a1-c9ac-70ea-8006-79946bd9f0b1€15.00€0.26matched
24capture01a196a1-dd9b-7199-af24-61f3cc085512€35.00€0.50matched
25capture01a196a1-e03d-72a0-a9cf-8b1f24b51293€35.00€0.50matched
26capture01a196a1-fc29-7f23-aa19-b76aecc4b123€9.00€0.19matched
27refund01a196a2-11e7-7c4c-987b-3b1315408a7e-€14.00€0.00matched
28capture01a196a2-126c-718a-af61-4bf54fbec29a€15.00€0.26matched
29capture01a196a2-18c9-7082-a1f9-c008272577a9€49.00€0.67matched
30capture01a196a2-218d-72e9-8dd1-f54ace116ae9€9.00€0.19matched
31refund01a196a2-3116-72f4-bf3a-a679ead48825-€12.00€0.00matched
32capture01a196a2-3982-73d0-84ea-6b4e0a5a25d2€35.00€0.50matched
33capture01a196a2-453c-7608-b8cc-08fd7aea748c€24.00€0.37matched
34refund01a196a2-5bbb-746c-b554-b744c63498d5-€12.00€0.00matched
35capture01a196a2-63fe-77dc-82e4-85f840424cde€15.00€0.26matched
36refund01a196a2-68cb-7221-96d5-19a50e6400e9-€5.00€0.00matched
37capture01a196a2-68d8-7304-8941-7e7bde922bb0€24.00€0.37matched
38capture01a196a2-6de2-7f5b-ac42-83aaeb5a9730€9.00€0.19matched
39capture01a196a2-6e0b-70dc-bc05-be764fee772f€9.00€0.19matched
40capture01a196a2-7459-7d48-97d7-482153c4883a€24.00€0.37matched
41capture01a196a2-77d9-7853-b826-49ce99511150€35.00€0.50matched
42capture01a196a2-82bd-7b20-acaa-cd3e49472caa€24.00€0.37matched
43capture01a196a2-97a3-72c1-9dbe-b65e7b7e1313€49.00€0.67matched
44capture01a196a2-9a8a-77c8-b963-2c548b4e3687€9.00€0.19matched
45refund01a196a2-a9dd-7fea-aef9-b3452b728605-€19.00€0.00matched
46capture01a196a2-b2ca-7469-8fb9-877022183e8c€49.00€0.67matched
47capture01a196a2-b3f4-7679-a5e1-2e08e5cdf963€15.00€0.26matched
48capture01a196a2-b414-7a7a-83a2-990ea44118e8€15.00€0.26matched
49refund01a196a2-bdd8-724a-9941-34a95a695082-€8.00€0.00matched
50capture01a196a2-e838-7ca9-9987-836d7211c99c€9.00€0.19matched
51capture01a196a2-eb43-7d1f-bad0-250d17c2423a€35.00€0.50matched
52capture01a196a2-ffd0-7740-9ec0-e8e169d8f1cf€15.00€0.26matched
53capture01a196a3-08bd-7522-b733-776f6fa1c6f7€49.00€0.67matched
54capture01a196a3-17f2-798d-ac72-325df20fe938€24.00€0.37matched
55capture01a196a3-1ddf-7480-8737-304f1aeabcb4€35.00€0.50matched
56capture01a196a3-258c-7587-b9d0-c487474d0fac€24.00€0.37matched
57capture01a196a3-2ce6-72c3-9d91-e394f81eaef4€15.00€0.26matched
58capture01a196a3-2dde-7c23-b03d-66a47da9cf00€35.00€0.50matched
59capture01a196a3-6377-7664-8e95-607ce1de68b1€9.00€0.19matched
60capture01a196a3-6845-70e1-9e75-f7b7e1289869€24.00€0.37matched
61capture01a196a3-7a05-7e53-8f2a-3555e48e3063€9.00€0.19matched
62capture01a196a3-7cb8-79b6-9eae-6d6077ae9c04€35.00€0.50matched
63capture01a196a3-8fa2-797c-aecc-395d2b0f9dbc€9.00€0.19matched
64capture01a196a3-b52d-76d3-af9b-29f919dc8b4a€24.00€0.37matched
65capture01a196a3-ba5c-7984-a56a-c9a80861301c€35.00€0.50matched
66capture01a196a3-c6f8-7b70-90fd-4baccb458c12€49.00€0.67matched
67capture01a196a3-c8e3-782f-b6fd-a61282988dd0€24.00€0.37matched
68capture01a196a3-d5dd-7c41-98de-0ada5dd07a0f€49.00€0.67matched
69capture01a196a3-f062-7a66-a395-904bf06a732d€9.00€0.19matched
70capture01a196a4-03fa-7fe1-a01b-3583b55ed863€24.00€0.37matched
71capture01a196a4-1691-72ab-be89-c8bf05474c96€15.00€0.26matched
72capture01a196a4-578d-784e-8ecd-54ad4dce1645€24.00€0.37matched
73capture01a196a4-7fc2-7cd4-ba23-618e17f8319d€49.00€0.67matched
74capture01a196a4-7fbd-783b-a0cd-89674fb0eef2€24.00€0.37matched
75capture01a196a4-8e01-78a3-8171-3a8fffd20071€49.00€0.67matched
76capture01a196a4-92bb-765e-961e-832a450a3b11€9.00€0.19matched
77capture01a196a4-9cd2-7ef8-ae2e-1ba8aafb3dbf€9.00€0.19matched
78capture01a196a4-a739-76d0-a051-0f34f18c4e3c€24.00€0.37matched
79capture01a196a4-bc11-765d-8857-f479b2e070f2€9.00€0.19matched
80capture01a196a4-bc23-72df-b2ed-aaf9d446c239€49.00€0.67matched
81capture01a196a4-d5c5-7d20-b308-dd8c0d2f9158€9.00€0.19matched
82refund01a196a4-ee86-72ef-a1f9-6821e95bdb25-€3.00€0.00matched
83capture01a196a4-fbb3-7b31-a8ff-96fd3fe79f11€49.00€0.67matched
84capture01a196a5-11da-7f44-9518-060774e0c426€24.00€0.37matched
85refund01a196a5-1bba-7e48-8f33-333e2fcbcd2c-€13.00€0.00matched
86capture01a196a5-2dcc-7754-83e7-aa3dca363d1b€9.00€0.19matched
88capture01a196a5-4e43-722f-84a6-672efeacceaa€35.00€0.50matched
89capture01a196a5-7876-76c8-9dbb-fde6c2cda593€35.00€0.50matched
90capture01a196a5-7d8d-7560-905d-29f342820d4b€24.00€0.37matched
91capture01a196a5-85ae-77c9-a357-e8bfcaeae682€35.00€0.50matched
92capture01a196a5-8ba8-73d9-ad38-4ccaa27ad6af€15.00€0.26matched
93capture01a196a5-a44a-72a7-b774-9da3365eb82b€24.00€0.37matched
94capture01a196a5-a54a-72f4-84aa-6615448a2e67€35.00€0.50matched
95capture01a196a5-aafb-738b-96a4-1e6ceea11e15€49.00€0.67matched
96capture01a196a5-cac1-793c-8585-31c5390f4688€24.00€0.37matched
97capture01a196a5-d04c-7c37-9880-604120d81839€24.00€0.37matched
98capture01a196a5-de8a-7e09-8bd4-443424ad2b73€24.00€0.37matched
99capture01a196a5-e503-7fb3-aeb9-04ba5e5ee7a9€9.00€0.19matched
100capture01a196a5-eeff-7942-bfc1-7c1c2d5669ef€15.00€0.26matched
101capture01a196a5-f7ec-71ef-bcc8-72b6ae4b9ff6€49.00€0.67matched
102capture01a196a6-0a06-7e11-a4cf-e144f3e87f54€9.00€0.19matched
103capture01a196a6-15c3-730d-b3c6-9de5f1b28fff€49.00€0.67matched
104capture01a196a6-17cf-70dc-9bb8-e09784c2b29a€49.00€0.67matched
105refund01a196a6-1844-79d8-87f4-8170073d51c4-€9.00€0.00matched
106capture01a196a6-1b01-7f82-aea6-4d752d8abeeb€15.00€0.26matched
107capture01a196a6-2855-7681-a064-a5c763da9927€9.00€0.19matched
108capture01a196a6-41ab-748e-bd3b-c0e05c2ad5c2€9.00€0.19matched
109capture01a196a6-4259-704e-b416-0538f579528e€9.00€0.19matched
110capture01a196a6-520b-74be-96b2-0616e3710114€35.00€0.50matched
111capture01a196a6-53a5-786c-81e1-f3a4ebd8abdc€9.00€0.19matched
112capture01a196a6-5620-7988-8775-2a7c3fed5788€35.00€0.50matched
113capture01a196a6-5e8f-787e-bd14-4009c05d78d8€15.00€0.26matched
114capture01a196a6-693b-7805-8951-6c8c31ca870b€9.00€0.19matched
116capture01a196a6-b728-7f2c-9332-1c16d241cc69€15.00€0.26matched
117capture01a196a6-ba84-7590-b4af-8b7f556288bd€9.00€0.19matched
118refund01a196a6-ccc1-786f-a4f7-821ddfe9c6c3-€13.00€0.00matched
119capture01a196a6-d799-7e95-a1d6-b1075be05958€35.00€0.50matched
120refund01a196a6-e57c-789d-bfd8-74432a03e58c-€3.00€0.00matched
121capture01a196a6-f2c6-774a-9412-7c86419125ed€15.00€0.26matched
122capture01a196a7-14e8-7e5a-af3c-7bc405c5f52d€35.00€0.50matched
123capture01a196a7-23df-78d0-a8ed-9b70d514408d€15.00€0.26matched
124capture01a196a7-5095-7ee9-9616-937e6f7dbb0f€49.00€0.67matched
125capture01a196a7-5a0c-7930-b9ff-19c07f368aa1€49.00€0.67matched
126capture01a196a7-6164-722f-b758-336aeab1debb€15.00€0.26matched
127capture01a196a7-ad38-7a75-844c-f622f1cc2e10€49.00€0.67matched
128capture01a196a7-b4ac-7d99-b555-4a9445f8ff6e€49.00€0.67matched
129capture01a196a7-b8a4-7ec5-aa32-0a5e724da0fb€35.00€0.50matched
130capture01a196a7-d8b6-7213-907b-6edfef02639f€35.00€0.50matched
131refund01a196a7-e1a3-7a3b-b0fb-4971fc42ecab-€38.00€0.00matched
132capture01a196a7-e6e2-7d57-a4b3-4988279e5be0€9.00€0.19matched
133capture01a196a8-119c-70f5-ac4d-20b9eb1aaba5€35.00€0.50matched
134capture01a196a8-4e0b-7fef-964b-a429487eb39c€49.00€0.67matched
135capture01a196a8-773b-7fdf-8c51-96fd0df73a96€9.00€0.19matched
136capture01a196a8-8660-78c0-b353-4ba39bd1b3ae€35.00€0.50matched