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, 10:20

Gross

€3,471.00

PSP fee

€55.02

Net to the bank

€3,415.98

Settlement journal

#377648

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 28, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • missing linein the books, not in the filecapture:01a1a613-8c31-73df-90ad-438ee78cdb82 is in no file
LineKindReferenceGrossFeeStatus
11capture01a1a613-4b9a-7815-9b30-7248370593aa€15.00€0.28fee difference
17capture01a1a613-79e8-7525-ba3b-f34932253e2e€35.00€0.55fee difference
114capture01a1a619-6040-7668-ad76-40663f9410a2€49.00€0.72fee difference
1capture01a1a60a-7c4e-73ec-8d75-001f23ccd7af€49.00€0.67matched
2capture01a1a60b-e91f-79b6-a53f-af3a2dc818a7€24.00€0.37matched
3capture01a1a612-8928-7c8e-9b7c-ca1d9acf4128€9.00€0.19matched
4capture01a1a612-c482-78b9-9034-d348ba2dd6bc€9.00€0.19matched
5capture01a1a612-c8c1-7cc8-8a41-c9b22da601e0€49.00€0.67matched
6capture01a1a612-dc92-78dd-ac8f-1f0f6aaac215€35.00€0.50matched
7capture01a1a612-e304-7ba0-bbd3-399aa3cff033€35.00€0.50matched
8capture01a1a612-e594-708a-b49d-8449cae05f85€15.00€0.26matched
9capture01a1a612-f508-7fe8-801a-e3158ff6f35a€24.00€0.37matched
10capture01a1a613-1806-72e6-9d3d-2a9857360c65€49.00€0.67matched
12capture01a1a613-4e24-74ca-9852-71e0a20cf310€24.00€0.37matched
13capture01a1a613-5333-72a3-808a-51237c2f3152€24.00€0.37matched
14capture01a1a613-55cf-7a6f-916d-2ffedfa9f42a€15.00€0.26matched
15capture01a1a613-75cb-756c-a4f1-5e298d1a3540€15.00€0.26matched
16capture01a1a613-7d1e-7f5d-a4a9-628299dcd434€49.00€0.67matched
18capture01a1a613-9da6-7c3a-b02b-23e927639548€49.00€0.67matched
19capture01a1a613-c46a-7177-8556-8742743851f4€24.00€0.37matched
20capture01a1a613-cdfd-7cb4-af53-7fbdbae3745e€24.00€0.37matched
21capture01a1a613-dff9-7488-b4f4-d91f85287b86€24.00€0.37matched
22capture01a1a613-e4ea-7371-b320-cbd2f24789f5€49.00€0.67matched
23capture01a1a613-fdf0-79ae-ace0-9dbf48656cc6€15.00€0.26matched
24capture01a1a614-2295-7972-b3b4-9a7c670525c7€9.00€0.19matched
25capture01a1a614-2ae4-7153-a9bb-c1fe774dcfe8€49.00€0.67matched
26capture01a1a614-41cc-765c-ac40-f40d9a9f781c€9.00€0.19matched
27capture01a1a614-4d44-7594-b279-190824aa5ebb€15.00€0.26matched
28capture01a1a614-4f7f-76a1-adca-6f3f80407620€24.00€0.37matched
29capture01a1a614-5d83-752a-8c0b-351611ada677€24.00€0.37matched
30capture01a1a614-6cb5-7827-a06d-db16f666020c€9.00€0.19matched
31capture01a1a614-7c30-7435-9647-53b876a88aaf€15.00€0.26matched
32capture01a1a614-7ea3-7ee9-ba7a-01d61ac59752€9.00€0.19matched
33capture01a1a614-8736-70f4-894c-ade6e110cc8e€24.00€0.37matched
34capture01a1a614-87a1-7dbb-b26b-2d326d426a5c€49.00€0.67matched
35capture01a1a614-96fa-7fea-8985-a211c62c7125€24.00€0.37matched
36capture01a1a614-9e6f-7603-96af-a1b554385988€49.00€0.67matched
37capture01a1a614-be74-769a-8b88-de1def669ebd€24.00€0.37matched
38refund01a1a614-c259-72f0-8d27-dccdb2182438-€3.00€0.00matched
39capture01a1a614-d072-7d07-9bd4-d1ed7f2369ec€15.00€0.26matched
40capture01a1a614-d0bd-7974-81ab-031ca204e923€15.00€0.26matched
41capture01a1a614-d1a5-75e1-a733-c9e893fa668d€9.00€0.19matched
42capture01a1a614-c2f2-7624-9804-88868d113202€35.00€0.50matched
43capture01a1a614-e8b8-704e-8c37-665dfdb340b8€24.00€0.37matched
44capture01a1a614-f322-7d47-b4ca-21a9dacb0272€24.00€0.37matched
45refund01a1a615-0369-75f7-bb54-f8feaa57cae5-€12.00€0.00matched
46capture01a1a615-4b03-7c58-bb18-3d30ad33737b€9.00€0.19matched
47capture01a1a615-50f8-7e05-862a-4505406ff972€35.00€0.50matched
48capture01a1a615-7d35-7d2d-b238-392e643d9d21€24.00€0.37matched
49capture01a1a615-82ce-7eb3-aba2-611d2bd393aa€49.00€0.67matched
50capture01a1a615-9a17-7c57-8bba-9d526e3155aa€49.00€0.67matched
51capture01a1a615-9f62-7b78-ac4c-218117413d77€49.00€0.67matched
52capture01a1a615-a188-7473-8215-73946a14cf31€24.00€0.37matched
53capture01a1a615-ae27-72a9-b061-83f0165894bd€49.00€0.67matched
54capture01a1a615-b07b-78ab-a710-962de3e966f3€9.00€0.19matched
55capture01a1a615-b85f-76c1-a279-2322c43ba826€15.00€0.26matched
56capture01a1a615-cf9f-7c70-8672-387d9a154223€24.00€0.37matched
57refund01a1a615-e3a1-7605-8729-abe1ce2439bf-€24.00€0.00matched
58capture01a1a615-e85d-7a08-bc0f-878037afd45b€49.00€0.67matched
59capture01a1a615-eb28-7713-adc5-7c95cf47987e€15.00€0.26matched
60capture01a1a616-1428-71a2-88c5-9e3699968248€9.00€0.19matched
61capture01a1a616-3760-79fc-a9e1-7645724c61ba€9.00€0.19matched
62capture01a1a616-3fe2-7f38-a6b7-bdffc87fb4ba€24.00€0.37matched
63capture01a1a616-4052-7724-aebc-a285ff007c53€49.00€0.67matched
64capture01a1a616-53bf-762d-8d2b-f0987d18603a€15.00€0.26matched
65capture01a1a616-5d58-7da2-83db-92e84cc4f07d€15.00€0.26matched
66capture01a1a616-6aed-7d24-9e82-4f3c7248e115€9.00€0.19matched
67capture01a1a616-6da1-79a3-af05-c7f5515d5622€24.00€0.37matched
68capture01a1a616-802f-7510-94d0-36d9e92ba4a1€9.00€0.19matched
69capture01a1a616-9752-7db2-aa18-072188347cd5€15.00€0.26matched
70capture01a1a616-a8bf-74ea-9c03-68010e941cdc€24.00€0.37matched
71refund01a1a616-c4cd-70e4-9522-d546f01e219c-€4.00€0.00matched
72capture01a1a616-e1f9-7d66-bb2d-6f6d72f3849b€24.00€0.37matched
73capture01a1a616-ef94-71c5-a593-87d7d3333163€9.00€0.19matched
74capture01a1a616-fe43-75c5-a28b-926b2b5f369d€24.00€0.37matched
75capture01a1a617-156d-72ca-bf31-a22fac362ce5€9.00€0.19matched
76capture01a1a617-3833-7d87-993f-9a9d08a34441€49.00€0.67matched
77capture01a1a617-38a4-78fa-8e03-0bd75317c47e€24.00€0.37matched
78capture01a1a617-47d5-7e99-9849-98481b8f5c80€9.00€0.19matched
79capture01a1a617-680e-79e1-9915-28f0922624ff€24.00€0.37matched
80capture01a1a617-6d2c-7cd6-bf01-8492bf86cee2€35.00€0.50matched
81capture01a1a617-75a4-7821-b0ce-4e6b73eaee59€35.00€0.50matched
82capture01a1a617-7e3a-71ca-87d8-891e11843270€15.00€0.26matched
83capture01a1a617-834b-74c9-9fca-b7d9a2eb7fff€24.00€0.37matched
84capture01a1a617-88f1-7aa6-8e39-b27c857f2d2e€24.00€0.37matched
85capture01a1a617-9107-7241-bdb5-af1ed756a8b7€9.00€0.19matched
86capture01a1a617-9604-75e1-be31-d59bb64691b5€9.00€0.19matched
87capture01a1a617-a8ca-7d91-9e2d-6e62a97f63b8€49.00€0.67matched
88capture01a1a617-b84e-7c4e-a936-2df2b7450d41€49.00€0.67matched
89refund01a1a617-c5cd-7944-b0ce-d97c952e0d43-€12.00€0.00matched
90capture01a1a617-d699-7349-bff7-1e739d276f27€9.00€0.19matched
91capture01a1a617-d429-73a9-9136-b238641692a3€15.00€0.26matched
92refund01a1a617-e06c-7dd6-83a6-3966a83b1bbd-€15.00€0.00matched
93capture01a1a617-e2f9-7780-b48a-c6c3482bdb53€35.00€0.50matched
94capture01a1a617-fdc2-773c-a99e-68374cca1862€49.00€0.67matched
95capture01a1a618-22d4-7f58-aecd-f94c5a7f0f50€49.00€0.67matched
96capture01a1a618-3067-7238-a4c4-69d6ac24f65e€24.00€0.37matched
97capture01a1a618-4784-770b-b5ac-520cab91b64f€24.00€0.37matched
98refund01a1a618-56d7-79a8-a20e-b5ba866acd1b-€36.00€0.00matched
99capture01a1a618-6997-7fde-a635-db32dfc6c226€24.00€0.37matched
100capture01a1a618-778c-7481-8177-2f770b23bfb2€9.00€0.19matched
101capture01a1a618-861e-7892-a0ef-be04ec2a9db9€24.00€0.37matched
102capture01a1a618-962a-7845-b6f2-6d424b71e52d€35.00€0.50matched
103capture01a1a618-9eca-7f72-9bcf-d8439add336b€9.00€0.19matched
104capture01a1a618-a1be-76cf-9e64-9906acf8ee4b€24.00€0.37matched
105capture01a1a618-a7fd-70cd-8aa1-4b658c47eb37€9.00€0.19matched
106capture01a1a618-aa0b-713a-b94d-050cf62878e9€49.00€0.67matched
107capture01a1a618-c755-7262-9e62-dcbce8b4cb7b€35.00€0.50matched
108capture01a1a618-d5fa-7060-bd0b-e6dd91db5a5c€24.00€0.37matched
109capture01a1a618-ec90-7830-98c5-13c6199e0ac3€9.00€0.19matched
110refund01a1a618-f15f-7780-a615-9dec662c7add-€19.00€0.00matched
111capture01a1a619-027d-73e2-ac5c-acf6ea7551f1€49.00€0.67matched
112capture01a1a619-0c83-7d24-968d-615c47d1ba60€35.00€0.50matched
113capture01a1a619-2ca5-7eea-b852-325527dbe2bc€15.00€0.26matched
115capture01a1a619-8696-7415-8917-e1f773a34b35€35.00€0.50matched
116capture01a1a619-b00f-70a9-86f0-b04c6a94091f€24.00€0.37matched
117capture01a1a619-b67f-7735-9d0b-d1fbed73c667€15.00€0.26matched
118capture01a1a619-bb72-7a12-ab41-5cad88c0a6da€49.00€0.67matched
119capture01a1a619-be6a-76e8-affe-becaf9f7cca4€24.00€0.37matched
120capture01a1a619-cbc9-717b-bb34-82a744baa162€9.00€0.19matched
121capture01a1a619-e405-7fd1-9468-31735a53081f€24.00€0.37matched
122capture01a1a619-e415-7992-accd-32ec5a3e1029€49.00€0.67matched
123capture01a1a619-f09f-7bbe-9b3a-8424bafde6a5€9.00€0.19matched
124capture01a1a61a-05eb-7c69-a41d-383512187f3e€15.00€0.26matched
125capture01a1a61a-0c17-708f-9d14-c63ea9f36eb9€49.00€0.67matched
126capture01a1a61a-17b8-7e9e-8cd9-498f1a7a87cf€49.00€0.67matched
127capture01a1a61a-1f65-7205-b7cf-ca8f9f3e929a€35.00€0.50matched
128capture01a1a61a-2b6b-7635-bbbd-37463222f8ee€15.00€0.26matched
129capture01a1a61a-329d-70d3-b99e-8c5606df82ed€24.00€0.37matched
130capture01a1a61a-3808-74dd-8ac4-d66ff61658e6€49.00€0.67matched
131capture01a1a61a-6c52-7a97-b391-7817192a73ad€49.00€0.67matched
132capture01a1a61a-73c0-72fe-aeb1-568c4b42878e€49.00€0.67matched
133refund01a1a61a-7643-7908-a73a-f5e61496d489-€44.00€0.00matched
134refund01a1a61a-97fe-7d9f-b605-a5a1d7ed4c89-€12.00€0.00matched
135capture01a1a61a-9c46-7f1b-93c9-73a666f42d81€35.00€0.50matched
136capture01a1a61a-cdf7-7d61-b493-c4a3d9196738€24.00€0.37matched
137capture01a1a61a-d50d-7631-b647-6fc7cadcc26c€15.00€0.26matched
138capture01a1a61a-e31a-7842-96ac-51e1017beb5f€9.00€0.19matched
139capture01a1a61a-e853-711b-bd35-6418e1e0450b€24.00€0.37matched
140capture01a1a61b-0ba1-703f-b386-14b98bb3388e€49.00€0.67matched
141capture01a1a61b-2fb1-7ee4-ba38-85cfb3f85640€35.00€0.50matched
142capture01a1a61b-519a-7ab2-829b-29c0d1e8360e€49.00€0.67matched
143capture01a1a61b-67f9-7451-8e7e-dea7c787b0c8€35.00€0.50matched
144capture01a1a61b-7038-7e67-92cd-2251fc9db4ac€24.00€0.37matched
145capture01a1a61b-bb05-7091-a1df-2d796c39584f€15.00€0.26matched
146capture01a1a61b-bdea-75a3-a6d8-c9dc4a709084€24.00€0.37matched