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

5 Nov, 10:20

Gross

€2,675.00

PSP fee

€43.47

Net to the bank

€2,631.53

Settlement journal

#395968

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ab3a-252e-79b2-93fc-bbd50ae7349b is already settled by stl_EUR_2989790 line 15
  • duplicate linethe file lists it twicecapture:01a1ab3a-f8a6-7fef-a524-770d506163a3 is already settled by stl_EUR_2989790 line 25
  • duplicate linethe file lists it twicecapture:01a1ab3f-4bdb-785b-9c93-db4fe566ee54 is already settled by stl_EUR_2989790 line 86
  • duplicate linethe file lists it twicecapture:01a1ab40-3027-7b9b-bfb7-d89d8d845c02 is already settled by stl_EUR_2989790 line 96
  • fee differencethe fee is not the contract feethe fee is 38, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
  • missing linein the books, not in the filecapture:01a1ab3b-cda4-7224-912f-714fee2a2ddb is in no file
LineKindReferenceGrossFeeStatus
3capture01a1ab39-a475-7455-8e2f-3ee41b8490d0€24.00€0.38fee difference
16capture01a1ab3a-2604-7e6a-874c-66237e765671€35.00€0.50duplicate line
26capture01a1ab3a-f8fb-784b-b23b-c4ae4dd60b59€24.00€0.37duplicate line
87capture01a1ab3f-4c15-71ea-ad34-a70c3203db07€9.00€0.19duplicate line
97capture01a1ab40-3052-7e87-93ae-1eafd783868f€15.00€0.26duplicate line
127capture01a1ab41-e8d3-78c1-9b22-a9d4fe1f7cd8€15.00€0.29fee difference
1capture01a1ab39-0e25-7d57-a3e2-2a58fb810331€15.00€0.26matched
2capture01a1ab39-8f1a-7e16-ac5c-fb94864d0ab5€49.00€0.67matched
4capture01a1ab39-af33-723d-a0ba-b9d72bfc4335€24.00€0.37matched
5capture01a1ab39-bc24-7902-98aa-0468efddbeb4€35.00€0.50matched
6capture01a1ab39-c36b-70b7-b610-51b8629a2b04€9.00€0.19matched
7capture01a1ab39-d3b4-7f39-aacf-89952ab6f617€9.00€0.19matched
8capture01a1ab39-f05f-7247-bfa0-26f2b336db13€9.00€0.19matched
9capture01a1ab3a-0364-7833-8ad5-d2e7f2707c82€15.00€0.26matched
10refund01a1ab3a-0b25-7622-83a0-0aaf68ac28a1-€15.00€0.00matched
11capture01a1ab3a-165f-7987-8e60-4dc0d7db4256€35.00€0.50matched
12capture01a1ab3a-27b6-7c6b-81db-e38b349f64f5€49.00€0.67matched
13capture01a1ab3a-288f-7b1b-8af6-6bdb097285c0€15.00€0.26matched
14capture01a1ab3a-2ac7-7c8a-9f6c-bfd902a1bc1d€9.00€0.19matched
15capture01a1ab3a-2604-7e6a-874c-66237e765671€35.00€0.50matched
17capture01a1ab3a-3f5e-7601-ae55-61af7a9a1da5€9.00€0.19matched
18capture01a1ab3a-486b-73fa-ae4e-b466e56bd0d5€35.00€0.50matched
19capture01a1ab3a-5ee6-7013-a249-c3fd8139e6fd€9.00€0.19matched
20capture01a1ab3a-6cdc-7b59-a690-d6b06f027146€35.00€0.50matched
21capture01a1ab3a-86c6-79bb-8db5-ef100bbb9620€15.00€0.26matched
22capture01a1ab3a-93a1-7049-8e13-caec6d4634fd€9.00€0.19matched
23capture01a1ab3a-9c79-77e6-b6d1-ca80df365090€24.00€0.37matched
24capture01a1ab3a-f330-7bae-88a4-cb537f6410f4€24.00€0.37matched
25capture01a1ab3a-f8fb-784b-b23b-c4ae4dd60b59€24.00€0.37matched
27capture01a1ab3b-05ac-701d-a83f-b7711b28a939€35.00€0.50matched
28capture01a1ab3b-164c-7524-8c3f-3c2cc4f41e9f€35.00€0.50matched
29capture01a1ab3b-28e8-7cf9-88bc-8b39a45b8a17€49.00€0.67matched
30capture01a1ab3b-2c7f-779e-91c3-b7ebb5044744€9.00€0.19matched
31capture01a1ab3b-2e9b-7a09-a090-0f19114b2129€9.00€0.19matched
32capture01a1ab3b-2f68-7775-80c5-d7d78babec06€35.00€0.50matched
33capture01a1ab3b-3576-7938-9e11-5fa64ef4752a€9.00€0.19matched
34capture01a1ab3b-4a6a-7f83-a3cf-428d0701bbbd€9.00€0.19matched
35capture01a1ab3b-69da-72ff-9ac1-67223a7c89d0€15.00€0.26matched
36capture01a1ab3b-bad1-7991-ae55-c981e02a12f9€9.00€0.19matched
37capture01a1ab3b-bf8f-789f-973f-76ce9d5392ef€35.00€0.50matched
38capture01a1ab3c-0d71-7549-9611-6ab477bca728€24.00€0.37matched
39capture01a1ab3c-0fcc-7d5f-8f88-4c439009487a€9.00€0.19matched
40refund01a1ab3c-14ca-7f4e-b051-fcb2ce5a368f-€8.00€0.00matched
41refund01a1ab3c-3608-75e0-8c24-370ac48a4343-€5.00€0.00matched
42capture01a1ab3c-3a5b-787b-81d0-d1917058abd9€9.00€0.19matched
43capture01a1ab3c-46eb-7634-8c16-89940db63604€49.00€0.67matched
44capture01a1ab3c-70e1-761a-b404-0394f8283dd7€35.00€0.50matched
45capture01a1ab3c-a862-7206-b8de-3635fb1c2e9a€15.00€0.26matched
46capture01a1ab3c-bc4f-7492-babe-5f2ba50c458a€9.00€0.19matched
47capture01a1ab3c-cb89-73ff-86c2-47251b81d674€35.00€0.50matched
48capture01a1ab3c-d0a0-79d2-b9f6-353fc60e3f2c€15.00€0.26matched
49capture01a1ab3c-dd77-70e8-a292-a1e8961799dd€24.00€0.37matched
50capture01a1ab3c-e24d-76aa-9d5f-851264d62943€9.00€0.19matched
51capture01a1ab3c-f60e-720f-9516-b79feb10c213€24.00€0.37matched
52capture01a1ab3c-f8b0-7493-b132-8f355059e29a€49.00€0.67matched
53capture01a1ab3c-fc2f-7865-a37f-ba84fac4dd91€15.00€0.26matched
54capture01a1ab3d-035b-7567-aec9-9ed7d53c8267€35.00€0.50matched
55capture01a1ab3d-0ce1-79d5-b05b-691cd6b97771€24.00€0.37matched
56capture01a1ab3d-2998-7f81-aef8-e741de60f76b€35.00€0.50matched
57capture01a1ab3d-4720-7283-830f-fcef46093ed3€35.00€0.50matched
58capture01a1ab3d-4c00-7a52-a118-8dd9cf910858€49.00€0.67matched
59capture01a1ab3d-5bd0-734f-bb67-89026bd2a764€35.00€0.50matched
60refund01a1ab3d-bc6c-7307-b9cc-da1760c74273-€14.00€0.00matched
61capture01a1ab3d-c723-796e-bb92-51277dc63af9€15.00€0.26matched
62capture01a1ab3d-c829-709f-86b4-e2813e7b180f€35.00€0.50matched
63capture01a1ab3d-e545-71ae-bc3d-9a35e406cc1e€24.00€0.37matched
64capture01a1ab3e-110f-774a-b35d-7581f8fdebc6€24.00€0.37matched
65capture01a1ab3e-60ab-7f6a-b21e-7f60de44418c€24.00€0.37matched
66capture01a1ab3e-63c2-7ccd-9232-133542b2cde7€9.00€0.19matched
67capture01a1ab3e-65c2-792a-8d9c-488ab11c1981€9.00€0.19matched
68capture01a1ab3e-7110-7f62-b5fb-02e4d1f1e45e€24.00€0.37matched
69capture01a1ab3e-8e72-7838-a897-58d0f86f54a2€24.00€0.37matched
70capture01a1ab3e-99a1-754f-b5f4-47d42e1f9d51€24.00€0.37matched
71capture01a1ab3e-aaea-7c66-a544-ade10ea335af€35.00€0.50matched
72capture01a1ab3e-af12-7bb4-8b6e-06f9a88e3856€9.00€0.19matched
73capture01a1ab3e-b06d-74b9-aefb-17678a7fa5e6€9.00€0.19matched
74capture01a1ab3e-b7fa-705e-869a-8c64ade4ccbe€24.00€0.37matched
75refund01a1ab3e-c1ab-70bf-b849-fd0428d7318e-€19.00€0.00matched
76capture01a1ab3e-c40f-7c6d-b81f-15880e353403€15.00€0.26matched
77capture01a1ab3e-c881-7347-9d28-80a7553eef50€9.00€0.19matched
78capture01a1ab3e-cfbc-7f7b-93c1-cdab74013812€35.00€0.50matched
79capture01a1ab3e-d00b-74f4-925e-796cd191c972€15.00€0.26matched
80capture01a1ab3e-e9f9-73c6-aca0-a552c3565a32€15.00€0.26matched
81capture01a1ab3e-eec4-71e7-80cb-29c5762ea1ef€15.00€0.26matched
82capture01a1ab3f-090b-7f9d-96d6-b1f8b13553fe€15.00€0.26matched
83capture01a1ab3f-27a2-7550-9ddf-777c600d421b€35.00€0.50matched
84capture01a1ab3f-2c1b-70ea-a777-6cc8efcfc4cd€24.00€0.37matched
85capture01a1ab3f-4710-7097-994e-4e36203b1a8e€15.00€0.26matched
86capture01a1ab3f-4c15-71ea-ad34-a70c3203db07€9.00€0.19matched
88capture01a1ab3f-4f71-7207-8bf8-c0313410a4c4€9.00€0.19matched
89capture01a1ab3f-65a7-7d78-92f8-c9747a69c7a7€49.00€0.67matched
90refund01a1ab3f-6c03-77f1-8927-2b5cd8954ae0-€12.00€0.00matched
91capture01a1ab3f-88b9-7f0e-a4a9-00e80b5b00f3€9.00€0.19matched
92capture01a1ab3f-9fca-7f36-8067-60e6e3d34285€15.00€0.26matched
93capture01a1ab3f-c0bc-78d8-9665-279ee9808807€9.00€0.19matched
94capture01a1ab3f-c423-7632-88ab-8fc8b14568cb€35.00€0.50matched
95capture01a1ab3f-fab2-751e-b4b2-ced155a62379€9.00€0.19matched
96capture01a1ab40-3052-7e87-93ae-1eafd783868f€15.00€0.26matched
98capture01a1ab40-6284-7143-aa43-c6746c7648ef€9.00€0.19matched
99capture01a1ab40-6820-7a1b-97f2-f19d214582c9€24.00€0.37matched
100capture01a1ab40-6926-7fa3-8c7e-ed5a166f501c€15.00€0.26matched
101capture01a1ab40-6ae2-7a4b-90e5-bafd729ffa26€9.00€0.19matched
102refund01a1ab40-6cf8-788c-ab71-6ac169aa9ffc-€4.00€0.00matched
103capture01a1ab40-74fe-781d-b739-d5b070fcf867€35.00€0.50matched
104capture01a1ab40-9385-7097-841c-5518d81ef224€9.00€0.19matched
105capture01a1ab40-ba46-7000-bec3-410e13814a06€49.00€0.67matched
106capture01a1ab40-ce8e-7d77-9ff1-13e42945fbff€24.00€0.37matched
107capture01a1ab40-e732-76d5-92a4-258f302cb131€49.00€0.67matched
108capture01a1ab40-f384-70fd-bee1-ff7bdf78b490€15.00€0.26matched
109capture01a1ab41-02f0-7b87-93fe-c311fad234de€15.00€0.26matched
110capture01a1ab41-10cf-7015-99d9-630023b23e7c€9.00€0.19matched
111capture01a1ab41-1e62-75b1-85fd-de76987a43db€9.00€0.19matched
112capture01a1ab41-3dad-796c-b6cc-a38fe1aa1740€9.00€0.19matched
113capture01a1ab41-3e8b-7148-babc-9b9e2d7822f2€49.00€0.67matched
114capture01a1ab41-4827-7bcf-b0b0-1e1aae4ed0f1€9.00€0.19matched
115refund01a1ab41-4e01-7e45-a5fb-99b543305c7a-€15.00€0.00matched
116capture01a1ab41-5474-70cb-bf85-d2d185b86637€15.00€0.26matched
117capture01a1ab41-9141-7dae-97f2-ca1d655ed538€24.00€0.37matched
118capture01a1ab41-a73f-7f49-835f-64dbf0fdf8fc€9.00€0.19matched
119capture01a1ab41-bbfc-79ac-aa3d-bf11f3007182€35.00€0.50matched
120capture01a1ab41-c0ec-7509-a1c9-f1783a8d4c5f€15.00€0.26matched
121capture01a1ab41-c6d9-7dd5-868e-cd9ab588331d€24.00€0.37matched
122capture01a1ab41-c94d-7896-96eb-0b17ac9f0341€35.00€0.50matched
123capture01a1ab41-cff3-763a-84a0-c7543cc97e1d€49.00€0.67matched
124capture01a1ab41-d3cc-7093-977f-48133f4262a2€24.00€0.37matched
125capture01a1ab41-d622-7952-80a0-7753178e10a5€35.00€0.50matched
126capture01a1ab41-e7d4-7f38-ab06-c58400f3bbde€24.00€0.37matched
128capture01a1ab41-eac0-7869-83eb-b78e9eec29b7€9.00€0.19matched
129refund01a1ab41-ea02-7ce8-9421-db4875d1337f-€13.00€0.00matched
130capture01a1ab41-f66b-719e-a136-7d4c783387d4€24.00€0.37matched
131capture01a1ab41-f9a2-7970-a992-49186740fabf€49.00€0.67matched
132capture01a1ab41-fa7d-7f3f-b3d4-49fb37b1c0fe€24.00€0.37matched
133capture01a1ab42-0065-7e5f-9c92-fa7192caedff€9.00€0.19matched