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

7 Nov, 12:40

Gross

€3,634.00

PSP fee

€56.43

Net to the bank

€3,577.57

Settlement journal

#434624

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b608-78e4-7a10-b11d-8b86dc42b9b1 is already settled by stl_EUR_2990092 line 33
  • duplicate linethe file lists it twicecapture:01a1b60b-4677-706c-b4d2-57011c0a138d is already settled by stl_EUR_2990092 line 92
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
  • missing linein the books, not in the filecapture:01a1b606-e0d6-7b7a-9fd0-3f9231765d90 is in no file
  • missing linein the books, not in the filecapture:01a1b60d-9c7c-7110-adaf-40af935cf7fe is in no file
  • missing linein the books, not in the filecapture:01a1b609-ddee-7995-ba78-2131f812d29f is in no file
LineKindReferenceGrossFeeStatus
22capture01a1b607-c68a-7e2c-aee3-eb9c8b783763€9.00€0.24fee difference
34capture01a1b608-78fd-7f9f-9d6d-83779d816482€15.00€0.26duplicate line
43capture01a1b608-cba9-702b-b6f6-1c210b1e6bdc€35.00€0.54fee difference
93capture01a1b60b-4694-72aa-8f9d-8e3b7d6ff203€9.00€0.19duplicate line
1capture01a1b601-c006-717a-b067-73390927c4d3€49.00€0.67matched
2capture01a1b606-056e-716c-9b1a-eda2179b0f4b€15.00€0.26matched
3capture01a1b606-2baf-7dcd-9b0f-39e21ae8b1a3€9.00€0.19matched
4capture01a1b606-4fc2-7c5b-8c5e-61e43f87e1e2€24.00€0.37matched
5capture01a1b606-8098-7b3e-af44-dfc8aa2065e7€24.00€0.37matched
6capture01a1b606-988f-794f-90c8-d864dfa520d4€24.00€0.37matched
7capture01a1b606-ba64-79bd-b84a-68a99ad9cbb0€35.00€0.50matched
8capture01a1b606-cfbf-753f-b488-033df7f6a6ce€35.00€0.50matched
9capture01a1b606-cf25-7d78-ac24-ef286917544a€35.00€0.50matched
10capture01a1b606-dbbc-712b-8be8-6d6ac1324b83€15.00€0.26matched
11capture01a1b606-fa95-7f1e-a8aa-1655ec95ca35€35.00€0.50matched
12capture01a1b607-06a1-7d59-9198-c236a0e05392€15.00€0.26matched
13capture01a1b607-222a-7e2d-bed3-fa9366927506€49.00€0.67matched
14capture01a1b607-2fb2-7efc-b2cf-cc91c01686df€9.00€0.19matched
15capture01a1b607-38ef-708f-a03f-94e230858fb9€9.00€0.19matched
16capture01a1b607-5fee-7d4b-9baf-1961cd162a17€35.00€0.50matched
17capture01a1b607-7ae4-7b5e-99a4-b226566a1f72€24.00€0.37matched
18capture01a1b607-83ba-74d5-b2e3-932b8bdc0c55€15.00€0.26matched
19capture01a1b607-955a-7255-a525-3076f211c21c€49.00€0.67matched
20capture01a1b607-a14a-7648-b151-da91f0d9b495€24.00€0.37matched
21capture01a1b607-b00c-7db8-9093-b787804d212b€24.00€0.37matched
23capture01a1b607-cf46-7cf9-9cca-c2e3169578b0€35.00€0.50matched
24capture01a1b607-d982-7de8-b6c6-02b4681c9765€15.00€0.26matched
25capture01a1b607-eac1-7981-b8bb-e48ecbad5f8f€9.00€0.19matched
26capture01a1b607-ea74-77ad-b11d-ec9618a0e8c4€35.00€0.50matched
27capture01a1b607-f85f-70f6-86e6-c62dc0f35093€35.00€0.50matched
28refund01a1b608-01dd-7cdd-962c-54370c9c4f97-€9.00€0.00matched
29capture01a1b608-4452-7c56-a932-04bb3af62130€35.00€0.50matched
30capture01a1b608-515c-758f-b0f8-d264d3a796be€9.00€0.19matched
31capture01a1b608-5ad1-7864-a1bf-807a12af1240€9.00€0.19matched
32capture01a1b608-5d35-7b4d-b5e9-b6b11979a296€35.00€0.50matched
33capture01a1b608-78fd-7f9f-9d6d-83779d816482€15.00€0.26matched
35capture01a1b608-7ad3-7ff2-8ccd-790889535691€35.00€0.50matched
36capture01a1b608-83cf-7921-8638-88109b646dfd€35.00€0.50matched
37capture01a1b608-8bc4-7b85-9159-bccc66c1a34a€35.00€0.50matched
38capture01a1b608-8777-79ca-afe8-0e2bf9e47842€49.00€0.67matched
39capture01a1b608-9417-71e3-a012-acd059c415ef€49.00€0.67matched
40capture01a1b608-a6ea-781d-99fc-6931acac2d43€49.00€0.67matched
41capture01a1b608-afb4-7202-a687-25ab97f03236€15.00€0.26matched
42refund01a1b608-ca07-72fa-9fbd-df1be62a61a8-€30.00€0.00matched
44capture01a1b608-cdad-7f24-9378-ab3f544ff527€49.00€0.67matched
45capture01a1b608-dff7-723d-b477-190e2e7846fb€15.00€0.26matched
46capture01a1b608-e377-7945-96ed-4a876483968b€35.00€0.50matched
47capture01a1b609-1181-7a0e-905e-fe3f74d6c760€24.00€0.37matched
48capture01a1b609-0fa0-73be-801d-3ec8b8ff5508€24.00€0.37matched
49capture01a1b609-16a6-72b7-939f-e248f977aaf4€35.00€0.50matched
50capture01a1b609-2805-7fd3-977e-30c6a7ea224b€9.00€0.19matched
51capture01a1b609-377e-7ddc-80b0-f42cf2b38bcd€15.00€0.26matched
52capture01a1b609-367b-7d93-8c43-a50b0330e0f7€9.00€0.19matched
53capture01a1b609-401d-758a-b057-ece66ae9ef76€15.00€0.26matched
54capture01a1b609-4666-737a-9eda-cb49daba3fce€49.00€0.67matched
55capture01a1b609-5644-7d26-82bc-cbf4ef5ad305€15.00€0.26matched
56capture01a1b609-7845-765b-af00-f3af15908acb€24.00€0.37matched
57capture01a1b609-7b6a-7958-bf11-c9eba61c1431€35.00€0.50matched
58capture01a1b609-8771-7590-b883-34eca500d58b€35.00€0.50matched
59capture01a1b609-91a1-7e3b-ac84-f9139de0f120€24.00€0.37matched
60capture01a1b609-9221-79fd-a8cb-42da9e83212a€35.00€0.50matched
61capture01a1b609-a4e7-70dc-a431-e0386200fd5f€49.00€0.67matched
62capture01a1b609-9146-78f8-92c6-2508103d62a5€24.00€0.37matched
63refund01a1b609-b554-73a8-98b0-e8d1071c211c-€26.00€0.00matched
64capture01a1b609-c525-7b31-a5ff-8a451df308df€35.00€0.50matched
65refund01a1b609-cf5a-74b6-9872-a20f464ff293-€5.00€0.00matched
66capture01a1b609-de82-7b99-938c-bfbd3089946b€49.00€0.67matched
67capture01a1b609-f4a9-7574-9a2d-bc5988cfe8b8€24.00€0.37matched
68refund01a1b609-f4f5-7fdb-9c8b-6b59d8dc9bd2-€36.00€0.00matched
69refund01a1b60a-0432-725a-99f3-7181ca7fcc77-€11.00€0.00matched
70capture01a1b60a-27f4-75b5-8fd9-92e75580f32f€15.00€0.26matched
71capture01a1b60a-292b-75cb-bde6-fb439f3c8019€35.00€0.50matched
72capture01a1b60a-3282-7f2f-869a-7d2fbddc1b86€35.00€0.50matched
73capture01a1b60a-3b22-7617-a274-7f4ee97ed73a€35.00€0.50matched
74capture01a1b60a-5aa4-7c7f-84b9-bc1316316b97€49.00€0.67matched
75capture01a1b60a-67d8-7fd5-82b4-dffe0e6dcd8e€24.00€0.37matched
76capture01a1b60a-6856-7565-9ec4-b64d156d0e63€24.00€0.37matched
77capture01a1b60a-7e82-7dbb-9e19-5734213e7070€49.00€0.67matched
78capture01a1b60a-85dd-7150-b277-7a64796d070d€49.00€0.67matched
79capture01a1b60a-8cbf-7dac-b9ef-5395f25d4ccb€49.00€0.67matched
80capture01a1b60a-9438-74ed-8ed7-75cd69fcf97d€35.00€0.50matched
81capture01a1b60a-988e-780c-8e0a-3009e2b8ca0c€35.00€0.50matched
82capture01a1b60a-9d82-7010-aac9-ebc714e1ce49€49.00€0.67matched
83capture01a1b60a-a517-7915-baff-ea0ba93a0b44€35.00€0.50matched
84capture01a1b60a-aebf-70ef-a140-dfdba50af57d€24.00€0.37matched
85capture01a1b60a-d01a-7c49-a850-456e94a19365€49.00€0.67matched
86capture01a1b60a-f409-7df3-98f6-b9c671c8c28e€9.00€0.19matched
87capture01a1b60a-fe55-713c-817a-e48200156ac9€9.00€0.19matched
88capture01a1b60b-00b4-737c-a783-7e0858258d79€49.00€0.67matched
89capture01a1b60b-1218-77d7-a1a1-07a6d77f715e€24.00€0.37matched
90capture01a1b60b-2077-7325-a400-fbc1898bc109€35.00€0.50matched
91capture01a1b60b-3319-73c3-bb92-68d882fc62c4€9.00€0.19matched
92capture01a1b60b-4694-72aa-8f9d-8e3b7d6ff203€9.00€0.19matched
94capture01a1b60b-672b-7c3f-8884-3fa04ee0b008€49.00€0.67matched
95capture01a1b60b-74b2-72d4-8cd6-8995b88c6599€24.00€0.37matched
96capture01a1b60b-7d69-77f7-b840-77d29557cb64€49.00€0.67matched
97capture01a1b60b-9724-7661-a2f9-d1b48d88b3a0€35.00€0.50matched
98capture01a1b60b-a007-7301-a988-1b08dee7a991€24.00€0.37matched
99capture01a1b60b-a9d2-77e8-93b1-fc9a0c2850dc€35.00€0.50matched
100capture01a1b60b-b97f-7899-b03a-bcc56a02ca5d€24.00€0.37matched
101capture01a1b60b-c9d4-71be-b9cd-1add5036329b€15.00€0.26matched
102capture01a1b60b-e270-7034-b6ec-15a51195c38e€35.00€0.50matched
103capture01a1b60b-ef63-7406-a01b-78c8fd3105a8€9.00€0.19matched
104capture01a1b60c-0676-7f27-b547-cb187fdb1b3f€49.00€0.67matched
105capture01a1b60c-18c5-7e49-87e7-0065f1c4e5a4€9.00€0.19matched
106capture01a1b60c-2ceb-7580-82a6-20ad602c46ed€49.00€0.67matched
107capture01a1b60c-5347-72b5-8fbf-f2822575df95€15.00€0.26matched
108capture01a1b60c-629b-74ef-8638-58df50de71ad€15.00€0.26matched
109capture01a1b60c-6608-7bef-b6f4-a64a524dd23a€35.00€0.50matched
110capture01a1b60c-6ed3-7cbf-aa01-461ce35bd451€49.00€0.67matched
111capture01a1b60c-76fe-72df-9de7-28807bce61fe€24.00€0.37matched
112capture01a1b60c-8b55-7a0f-8c5a-902d8d92303d€49.00€0.67matched
113capture01a1b60c-c7d0-742d-9830-641828891d02€9.00€0.19matched
114capture01a1b60c-ce7c-7c6e-8a77-35ae6421a855€49.00€0.67matched
115capture01a1b60c-e450-7a4c-a718-78309da39168€15.00€0.26matched
116capture01a1b60c-e55c-7d8f-b8c7-558ad8169dce€49.00€0.67matched
117capture01a1b60c-f031-7773-a356-57ffe08fee84€24.00€0.37matched
118capture01a1b60c-f65c-7a35-9cf4-4b137088ff28€15.00€0.26matched
119capture01a1b60c-fbc4-7073-a39f-5471f7e07ad9€15.00€0.26matched
120capture01a1b60c-fcd5-7d14-a658-b12ebcd4fd80€49.00€0.67matched
121capture01a1b60d-00c4-7dc8-8f5a-25aece707d69€15.00€0.26matched
122capture01a1b60d-5c44-7baf-865a-e87a5aee10f3€49.00€0.67matched
123capture01a1b60d-7c85-7335-8ec0-9c0c4c43fc09€49.00€0.67matched
124capture01a1b60d-93b7-7727-9dc5-431c0583dcaa€24.00€0.37matched
125capture01a1b60d-9957-7610-affc-3a5eb9cc1af2€9.00€0.19matched
126capture01a1b60d-aba3-7c87-8f41-7aeeb9417dd6€9.00€0.19matched
127capture01a1b60d-c4da-7593-bbcc-60a88508ad92€24.00€0.37matched
128capture01a1b60d-d205-7ef2-8f78-a4d5a6f48eb6€9.00€0.19matched
129capture01a1b60d-e28c-70ee-b643-27e3ad6f2b38€9.00€0.19matched
130capture01a1b60e-0811-75d8-9b77-87e39b46a7f8€49.00€0.67matched
131capture01a1b60e-4390-7c54-9469-a194d35ae0e3€35.00€0.50matched
132capture01a1b60e-5b34-74d7-90de-e0b2a87aa7e4€24.00€0.37matched
133capture01a1b60e-84b2-73f1-8bc0-0755a6be04e0€35.00€0.50matched
134capture01a1b60e-8d4a-7763-833e-b1c91aae4f5f€9.00€0.19matched
135refund01a1b60e-9524-7263-99f7-e0775d950b93-€16.00€0.00matched
136refund01a1b60e-9bed-75f2-89b9-c50506382f72-€22.00€0.00matched
137capture01a1b60e-a950-7c8e-aad9-816a8b84fd09€15.00€0.26matched
138capture01a1b60e-ba75-7602-a570-673a04d3296b€35.00€0.50matched
139capture01a1b60e-bcdd-7cce-b874-9658e4971975€24.00€0.37matched
140capture01a1b60e-be7a-75c2-9c5e-c06dd148dacc€15.00€0.26matched
141capture01a1b60e-d5cc-798c-97d7-443cedb0fede€15.00€0.26matched
142capture01a1b60e-dd72-75ae-8c64-3a419c8eefb2€35.00€0.50matched