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

Gross

€2,687.00

PSP fee

€43.18

Net to the bank

€2,643.82

Settlement journal

#379053

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 27, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
  • missing linein the books, not in the filecapture:01a1a67b-282e-751f-b65a-2ce944835155 is in no file
LineKindReferenceGrossFeeStatus
66capture01a1a67c-78a8-797b-a54f-0dcebea5f3f1€15.00€0.27fee difference
89capture01a1a67d-a23c-708b-b31e-6953d8612f49€9.00€0.23fee difference
1capture01a1a671-78ab-7642-806c-c81fe587688e€49.00€0.67matched
2capture01a1a677-5a37-7759-83f4-2e3ce09ed1d5€9.00€0.19matched
3capture01a1a677-6d6e-7111-b4e2-de32fc8d5d12€35.00€0.50matched
4refund01a1a677-aa69-72d4-95d6-7e8fcca891d6-€9.00€0.00matched
5capture01a1a677-ab1a-75ec-bcdf-257b94b514a6€15.00€0.26matched
6capture01a1a677-d3fb-72ef-86af-289f200fada9€9.00€0.19matched
7capture01a1a677-e58b-7554-babd-e0a4da8c060d€49.00€0.67matched
8capture01a1a677-e604-7708-9b05-9ad4992b23e0€24.00€0.37matched
9capture01a1a677-e526-780d-b82b-4e8fe159fe35€9.00€0.19matched
10capture01a1a677-f681-723f-ac81-51f463db11d4€15.00€0.26matched
11capture01a1a677-fa5f-75f6-8aef-4256bc77772a€35.00€0.50matched
12capture01a1a678-0c2f-7a3d-9fa9-9c4e90692723€49.00€0.67matched
13capture01a1a678-2824-701a-b8e4-81f573c8f37c€15.00€0.26matched
14capture01a1a678-2dc3-79bf-a2cf-739300d3b815€15.00€0.26matched
15capture01a1a678-2f87-705f-9007-666e04b40caf€24.00€0.37matched
16capture01a1a678-41cd-7345-9669-b01f2a60a79b€15.00€0.26matched
17capture01a1a678-454c-7b9a-b3ae-32268a1aa1a1€49.00€0.67matched
18capture01a1a678-617e-7715-96e5-7bd8ad2612e0€9.00€0.19matched
19capture01a1a678-6d77-7262-8671-888a8ae7d2db€9.00€0.19matched
20refund01a1a678-a77c-7ccb-8107-5ceebeaf3304-€2.00€0.00matched
21capture01a1a678-b8cd-710a-98da-94f4a3dc56f3€35.00€0.50matched
22capture01a1a678-c74d-7009-9d20-5072a2eabfef€35.00€0.50matched
23capture01a1a678-d27f-7e6e-a188-90198c0a3d42€35.00€0.50matched
24capture01a1a679-182a-75ca-9c6a-d48a804323ef€24.00€0.37matched
25capture01a1a679-1aa7-7a77-895e-0fc121b69a60€35.00€0.50matched
26capture01a1a679-4ee3-7c5f-a5e5-61677ad17521€9.00€0.19matched
27capture01a1a679-4bba-723e-a8f3-47a09951adc5€9.00€0.19matched
28capture01a1a679-529f-7e18-bd4b-bee6ec20d636€15.00€0.26matched
29capture01a1a679-7125-7d89-8311-254c3c952185€15.00€0.26matched
30capture01a1a679-766e-7c29-85c8-4a9bbd07bd65€49.00€0.67matched
31refund01a1a679-9fea-76a2-8a73-1cae15e0debf-€13.00€0.00matched
32capture01a1a679-a5d0-73ac-ba85-6a0f85098094€35.00€0.50matched
33capture01a1a679-e075-7976-ab67-fcd9c7e4c07a€15.00€0.26matched
34capture01a1a679-f460-78cd-b166-985a0e577b2b€35.00€0.50matched
35capture01a1a679-f6ce-74da-9dc7-72b9262d8339€49.00€0.67matched
36capture01a1a679-f869-7201-953f-085b07e46619€24.00€0.37matched
37capture01a1a67a-000c-7444-8487-8611b5b2b463€35.00€0.50matched
38capture01a1a67a-0541-7152-8188-314c85cb702b€35.00€0.50matched
39capture01a1a67a-0f39-73fb-a561-e56ec5241982€9.00€0.19matched
40refund01a1a67a-167b-7a33-a22f-5c15882a847a-€30.00€0.00matched
41capture01a1a67a-52ba-7caa-ba39-94ba6745b8fa€49.00€0.67matched
42capture01a1a67a-6653-738d-9dde-6a587023ba42€24.00€0.37matched
43capture01a1a67a-69a7-7494-834b-612204779ea4€49.00€0.67matched
44capture01a1a67a-7881-78b5-9459-f18366ce69a0€9.00€0.19matched
45capture01a1a67a-998b-7363-9e62-578fd68d63d2€49.00€0.67matched
46capture01a1a67a-adf1-7a0c-bbdf-4cf686af3c37€49.00€0.67matched
47capture01a1a67a-ae6c-77a1-a216-c9cc34aabe6c€24.00€0.37matched
48capture01a1a67a-d11d-7602-8e8a-820da2756ff2€15.00€0.26matched
49capture01a1a67a-e6ee-75ff-b287-55be47173e68€9.00€0.19matched
50capture01a1a67b-0a63-79ee-b7a9-5a5be89a9991€49.00€0.67matched
51capture01a1a67b-0fe0-72a2-8026-8a615a343804€49.00€0.67matched
52capture01a1a67b-12cc-79ce-a2a5-845a76adc694€24.00€0.37matched
53capture01a1a67b-2a2e-7f31-9425-30fdb9f27603€15.00€0.26matched
54capture01a1a67b-2b55-79e9-a591-1c52ead5e3a3€24.00€0.37matched
55capture01a1a67b-538c-7d16-9865-7c5c4c486aaf€49.00€0.67matched
56capture01a1a67b-5d19-7855-ac2d-f24754aa5c20€35.00€0.50matched
57capture01a1a67b-5fc1-7ea3-b852-adeefbf60639€15.00€0.26matched
58capture01a1a67b-ac62-7e76-b08d-305326d5f95f€15.00€0.26matched
59capture01a1a67b-aca8-7085-bab9-65b2678ef218€9.00€0.19matched
60capture01a1a67b-fd7c-7738-8a4a-9ce34d25597d€9.00€0.19matched
61capture01a1a67c-076b-70aa-b292-f6ad1ad81a04€49.00€0.67matched
62capture01a1a67c-26af-73ad-8c38-250fb611e018€9.00€0.19matched
63capture01a1a67c-3829-72f9-a29b-e905913b760c€15.00€0.26matched
64capture01a1a67c-52e1-7d54-8442-d7f1e7ed5d55€35.00€0.50matched
65capture01a1a67c-6f50-73a5-9e55-897de7ae89e0€49.00€0.67matched
67capture01a1a67c-7f36-72d1-bf66-17b2038bc927€24.00€0.37matched
68capture01a1a67c-8ff0-735d-a26d-ebab784d4583€24.00€0.37matched
69capture01a1a67c-9ac3-74fd-8368-c3452034085f€9.00€0.19matched
70capture01a1a67c-9bd9-7dea-9305-ce4efdbdb9cb€35.00€0.50matched
71capture01a1a67c-a19b-71b2-97e2-4f8ba0328395€35.00€0.50matched
72refund01a1a67c-c211-70ff-97b7-8dd5ba1bf083-€9.00€0.00matched
73capture01a1a67c-bf25-7834-aba3-cf2f4cc2955f€35.00€0.50matched
74capture01a1a67c-d5ff-7e66-8a9b-774cbc6706c6€9.00€0.19matched
75capture01a1a67c-e4f7-79d9-882f-14f3e8cfad54€9.00€0.19matched
76capture01a1a67c-e7aa-75aa-9c90-a6e10d76f621€49.00€0.67matched
77capture01a1a67c-f43a-79c1-9629-09bb65010740€24.00€0.37matched
78capture01a1a67c-f5aa-762b-a1ba-7dff82389ac5€9.00€0.19matched
79capture01a1a67d-0bd6-73b1-a1ee-9ec9e84fb148€24.00€0.37matched
80capture01a1a67d-152c-794b-8643-c3b641575414€24.00€0.37matched
81capture01a1a67d-1873-7d35-970c-9d651efcfe29€49.00€0.67matched
82capture01a1a67d-2e6e-760a-9cf2-db3df1514946€24.00€0.37matched
83refund01a1a67d-5883-709b-906b-a926d292c25a-€2.00€0.00matched
84refund01a1a67d-6e02-755c-a1b2-91dea3ffa4c4-€14.00€0.00matched
85capture01a1a67d-70da-7288-8720-14f222d796ad€15.00€0.26matched
86capture01a1a67d-7554-7e0d-81e1-e2551400fb1a€35.00€0.50matched
87capture01a1a67d-9992-7c48-a583-c4e978a5902f€15.00€0.26matched
88capture01a1a67d-a11e-7446-83d1-d92ae45f4816€9.00€0.19matched
90capture01a1a67d-b221-7835-84df-8f87508a88bd€35.00€0.50matched
91refund01a1a67d-b339-7e80-b578-0121efe564ae-€32.00€0.00matched
92capture01a1a67d-b4c8-7175-a709-7b8005e6414c€9.00€0.19matched
93capture01a1a67d-c9ac-7d7c-b80d-2d0115ba35f6€35.00€0.50matched
94capture01a1a67d-cf63-7b88-8965-92f19016ba01€35.00€0.50matched
95capture01a1a67d-cfd8-7a7f-862a-6a54a6c178a8€35.00€0.50matched
96capture01a1a67d-d532-7e15-b5e9-b37c7d8edf39€49.00€0.67matched
97capture01a1a67d-dc1c-7ffb-bed0-d11158713df6€35.00€0.50matched
98refund01a1a67d-fa7f-78bb-8508-c0ca56b601de-€6.00€0.00matched
99capture01a1a67d-fe62-7c4b-b6e3-909e54e977b2€15.00€0.26matched
100refund01a1a67e-0967-7640-95dc-db2835c62edb-€15.00€0.00matched
101capture01a1a67e-462e-7341-a40f-34e810ef2b5f€15.00€0.26matched
102capture01a1a67e-aa1b-758f-9e0d-34a16fc25637€9.00€0.19matched
103capture01a1a67e-c0d3-7b7c-8ca9-ba4c8495b55e€9.00€0.19matched
104capture01a1a67e-c216-7da2-a153-75cc49564d8c€24.00€0.37matched
105capture01a1a67f-09fa-7fe9-af64-8379b97a052e€15.00€0.26matched
106capture01a1a67f-4795-76aa-b8a4-a5210903ee20€9.00€0.19matched
107capture01a1a67f-4c71-7bd6-a7ef-d7ec147b985c€24.00€0.37matched
108capture01a1a67f-58be-7ed6-b5c0-dfb4820fcdec€9.00€0.19matched
109refund01a1a67f-6a47-789f-8476-c1fdc13d2d91-€13.00€0.00matched
110capture01a1a67f-6e60-7dc0-b1ef-47f817f416c2€49.00€0.67matched
111capture01a1a67f-7f13-7b9a-8ae8-e4d26e3b9f05€49.00€0.67matched
112capture01a1a67f-88fb-7618-9115-312f793c85e6€9.00€0.19matched
113capture01a1a67f-ae18-72f6-bdd6-9b422028d09c€9.00€0.19matched
114capture01a1a67f-b095-7a1e-af2e-6386b3f4b406€49.00€0.67matched
115refund01a1a67f-b8b9-787c-bfc2-00085d2fac31-€11.00€0.00matched
116capture01a1a67f-e40f-7cf2-8997-2186bfe10962€15.00€0.26matched
117capture01a1a67f-e4af-73ca-b410-200a2c58422e€35.00€0.50matched
118capture01a1a67f-fc78-7a3d-a4bd-3ee05d997ad9€49.00€0.67matched
119capture01a1a680-27ed-712e-885c-5b748bbff47e€9.00€0.19matched
120capture01a1a680-568f-7ead-8a70-09d8a9e66a83€9.00€0.19matched
121capture01a1a680-58f5-779b-8db4-cfab18d2ec02€9.00€0.19matched
122capture01a1a680-5a49-7ef0-88d6-14d3e3553f3d€15.00€0.26matched
123capture01a1a680-5a60-7a86-a92e-3c36fc136657€35.00€0.50matched