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

2 Nov, 23:40

Gross

€2,550.00

PSP fee

€40.90

Net to the bank

€2,509.10

Settlement journal

#351434

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
  • missing linein the books, not in the filerefund:01a19ea7-1fda-7497-b920-00e75ef3d899 is in no file
LineKindReferenceGrossFeeStatus
66capture01a19ea7-6359-73c2-867d-2d39ced2f2c7€49.00€0.72fee difference
85capture01a19ea9-3e32-7e23-af40-718d8f638c67€9.00€0.23fee difference
1capture01a19ea1-3f6c-7c7b-8d94-13d085137250€15.00€0.26matched
2refund01a19ea2-67fd-761d-994e-097ef2a94107-€5.00€0.00matched
3capture01a19ea2-7e40-7375-a94d-e82b499a9a31€15.00€0.26matched
4capture01a19ea2-84d9-7d00-b49d-19d35314a1e9€24.00€0.37matched
5capture01a19ea2-8df8-75d7-abb5-9ddcc78be845€15.00€0.26matched
6capture01a19ea2-9e43-73ca-821f-ee8417b33b8f€35.00€0.50matched
7capture01a19ea2-aeae-7983-a0d9-7028bd30c5b5€9.00€0.19matched
8capture01a19ea2-cf7f-7d8e-922e-b631702c04f0€35.00€0.50matched
9refund01a19ea2-d816-7a13-bb2c-248053ce7ee5-€8.00€0.00matched
10capture01a19ea2-daec-72dd-898f-78ab93f7f96d€24.00€0.37matched
11capture01a19ea2-f7da-78e4-8797-001fa400c43c€35.00€0.50matched
12capture01a19ea2-fe9a-7998-90d8-6f04660e2d62€15.00€0.26matched
13capture01a19ea3-02ad-709b-a4bb-a32f70b0be1e€9.00€0.19matched
14refund01a19ea3-0e91-78b1-b81a-17ebf675517f-€7.00€0.00matched
15capture01a19ea3-1ab5-7962-9cfb-f63acfb26210€49.00€0.67matched
16capture01a19ea3-1b12-77a0-ac95-76dc869576a8€35.00€0.50matched
17capture01a19ea3-2428-74e5-8ca9-a17a87b984ea€15.00€0.26matched
18capture01a19ea3-2f34-7f9f-96a0-c9845dcf52b6€15.00€0.26matched
19capture01a19ea3-2fb7-7a18-ac13-ab61f0213d99€35.00€0.50matched
20capture01a19ea3-4dc1-7213-87a6-1674c80d3219€15.00€0.26matched
21capture01a19ea3-5033-72bc-9a34-e34db786bb2d€9.00€0.19matched
22refund01a19ea3-aee3-7445-83bb-7865d0f59556-€5.00€0.00matched
23capture01a19ea3-b71a-7915-8822-96dd0c621380€15.00€0.26matched
24capture01a19ea3-dae1-7851-bd38-2dde22ef7f7e€9.00€0.19matched
25capture01a19ea3-f13f-7900-b6c7-c21ed43610e3€35.00€0.50matched
26capture01a19ea3-fd16-7e10-a6c0-e6481e00e7f9€9.00€0.19matched
27capture01a19ea4-0b9f-7456-9bcc-10b06b6f9956€24.00€0.37matched
28capture01a19ea4-25ba-755e-ba81-0cbed4eb8a90€9.00€0.19matched
29capture01a19ea4-2894-7597-be0a-6ef879096865€9.00€0.19matched
30capture01a19ea4-37fc-75ff-a426-491425f6bc65€49.00€0.67matched
31capture01a19ea4-57c3-7cfe-97bb-a446a66c7b63€49.00€0.67matched
32capture01a19ea4-7923-7c72-b161-14092372b3cf€15.00€0.26matched
33capture01a19ea4-9bef-745c-9b3b-05edb2218b4c€24.00€0.37matched
34refund01a19ea4-a826-70b4-8cbe-bb7bc22f9f3a-€26.00€0.00matched
35capture01a19ea4-ceda-7a74-ae85-46b00df6ddee€49.00€0.67matched
36capture01a19ea4-dcb3-7670-9d54-e9a7ebf62ef3€24.00€0.37matched
37capture01a19ea4-dd1f-788e-8b87-e990788468be€15.00€0.26matched
38capture01a19ea4-f782-7714-9384-1c349535d2f7€24.00€0.37matched
39capture01a19ea5-53d1-704e-b464-beba76355507€9.00€0.19matched
40capture01a19ea5-5a18-76e9-b1c0-43554c71a1fa€49.00€0.67matched
41capture01a19ea5-8f0c-7390-9652-c85515cfaf75€24.00€0.37matched
42capture01a19ea5-b192-7577-9012-3ecd0242b676€35.00€0.50matched
43capture01a19ea5-b852-7a9a-964c-baa0335c87e5€35.00€0.50matched
44capture01a19ea5-ce5d-7804-918e-8937a5af14aa€49.00€0.67matched
45capture01a19ea5-fa8c-7977-ba37-982a645fc8d5€9.00€0.19matched
46capture01a19ea6-052c-7ee1-a6f8-d170222d2bb5€35.00€0.50matched
47capture01a19ea6-0e5a-73c8-a70c-f1ac404ecbd5€49.00€0.67matched
48capture01a19ea6-0e61-78b3-90ba-fd3cbc5038bb€9.00€0.19matched
49capture01a19ea6-1176-7064-b1fd-05c81a38105e€35.00€0.50matched
50capture01a19ea6-2be1-78a2-bbf0-1d6a6fc19d82€35.00€0.50matched
51capture01a19ea6-3e20-7fe1-b8dd-a75906a40213€49.00€0.67matched
52capture01a19ea6-4573-7244-9f62-931b08687d2f€9.00€0.19matched
53capture01a19ea6-4633-7ed1-980b-4d7dcb2d749d€49.00€0.67matched
54capture01a19ea6-54c2-7907-99bd-7b98f0b8f409€24.00€0.37matched
55capture01a19ea6-7782-743e-8bdf-5155a73ebe1d€15.00€0.26matched
56capture01a19ea6-8252-7e25-a1c9-9aba8022e3d7€9.00€0.19matched
57capture01a19ea6-9178-76c2-b13f-9562588cd3af€35.00€0.50matched
58capture01a19ea6-a5ae-7e9e-9ba5-d79072cd6231€35.00€0.50matched
59refund01a19ea6-a867-7029-b794-c05ad9c8cd15-€6.00€0.00matched
60capture01a19ea6-cb5e-765a-8c17-5c5c984371a1€15.00€0.26matched
61capture01a19ea6-cbe1-7328-a118-14ca276754b3€24.00€0.37matched
62capture01a19ea6-cc6e-78e1-9f70-4c8c6910c663€15.00€0.26matched
63capture01a19ea6-fe95-7330-af50-23a84cbe47f7€49.00€0.67matched
64capture01a19ea7-1621-77d4-b19c-acc2eeab631d€9.00€0.19matched
65capture01a19ea7-28d8-7a6a-bf51-30d68cf24111€15.00€0.26matched
67capture01a19ea7-68d6-7342-a59a-b9cbd58643d6€15.00€0.26matched
68capture01a19ea7-c310-7f54-9dd0-a7b6fae7be74€49.00€0.67matched
69capture01a19ea7-cb02-76ce-bf8c-769330868828€15.00€0.26matched
70capture01a19ea7-e0e7-7094-a756-1447d6d453dd€49.00€0.67matched
71capture01a19ea8-50f8-74c4-8f59-e5190973577d€15.00€0.26matched
72capture01a19ea8-5b74-721a-9b76-e9bc4fa37ee8€35.00€0.50matched
73capture01a19ea8-5c48-7e1b-8e98-d68540147f1e€9.00€0.19matched
74capture01a19ea8-8451-7f57-b749-6678a19942a2€15.00€0.26matched
75capture01a19ea8-8ba9-725d-bbf9-afff6e868567€24.00€0.37matched
76capture01a19ea8-b7c8-7db2-87c1-cd2a212d87ae€9.00€0.19matched
77capture01a19ea8-b835-71a9-afe7-f7bec562f199€49.00€0.67matched
78capture01a19ea8-be18-784a-8ec6-41bb87c09afa€49.00€0.67matched
79capture01a19ea8-d03e-708e-bb6b-e102a81a0a3a€35.00€0.50matched
80capture01a19ea8-d213-7070-a8ff-80bd440802e8€9.00€0.19matched
81capture01a19ea8-eded-7b60-929b-063d76cad719€24.00€0.37matched
82capture01a19ea9-241d-7eb1-97cb-35545eced571€9.00€0.19matched
83capture01a19ea9-3995-7f6e-87f3-a5e944038b26€15.00€0.26matched
84capture01a19ea9-3a73-73bc-a148-cfb1d0d63609€24.00€0.37matched
86capture01a19ea9-5513-7bd4-a40e-d85e3769c651€35.00€0.50matched
87capture01a19ea9-6312-7b46-be80-1cd1aa723036€9.00€0.19matched
88capture01a19ea9-7317-7d1c-bf4f-e9b610534f39€15.00€0.26matched
89capture01a19ea9-9409-7f09-99fa-7a3a4a7dcd64€24.00€0.37matched
90capture01a19ea9-a873-7f25-89e3-69cd5d200c7f€35.00€0.50matched
91capture01a19ea9-ac66-7e33-896e-9fb29bce363a€35.00€0.50matched
92refund01a19ea9-bb68-7f1d-aa1d-7087a58c5bb5-€16.00€0.00matched
93capture01a19ea9-ca4d-7004-b1a4-2e73237b1b24€49.00€0.67matched
94capture01a19ea9-e841-707d-8afd-5c382f85a951€35.00€0.50matched
95capture01a19eaa-09fb-7032-a2e2-5b809801d9a1€49.00€0.67matched
96capture01a19eaa-22e0-7f3e-8e37-6d55a3be01c5€35.00€0.50matched
97capture01a19eaa-2e3e-76f3-ae27-e3c57204db66€9.00€0.19matched
98capture01a19eaa-3c9c-7969-aeac-818e5e543c9d€24.00€0.37matched
99capture01a19eaa-4007-7f85-9cc6-bbf328ac4b52€24.00€0.37matched
100refund01a19eaa-62ca-7b66-a6ca-15f110ac2de9-€31.00€0.00matched
101capture01a19eaa-a347-7de8-b290-c0ec33ec5626€15.00€0.26matched
102refund01a19eaa-b0cf-7383-8fb3-7b2b54547f42-€17.00€0.00matched
103capture01a19eaa-faa7-7385-b51a-a7e80fb08248€15.00€0.26matched
104capture01a19eaa-fe35-77fd-bb17-40506d14d46d€9.00€0.19matched
105capture01a19eab-0af1-7491-8d4c-6046f65f6de2€9.00€0.19matched
106capture01a19eab-0efa-7fa1-befc-a21907ce9b56€35.00€0.50matched
107capture01a19eab-1f1b-763e-9dcc-520695e58489€24.00€0.37matched
108capture01a19eab-366a-7ed5-93aa-c93c295bfcf6€24.00€0.37matched
109capture01a19eab-48e1-74cd-a1c1-690ed265a88e€24.00€0.37matched
110capture01a19eab-5448-7b7c-9ac7-a2f13f07d418€24.00€0.37matched
111refund01a19eab-5457-7f56-afb9-80c74081af8d-€13.00€0.00matched
112capture01a19eab-57c6-728d-90fc-6ed0c70702d8€35.00€0.50matched
113capture01a19eab-5fda-75bd-9dd2-d7a4e996816f€9.00€0.19matched
114capture01a19eab-66e0-70a7-9f55-cc663912ac9d€49.00€0.67matched
115capture01a19eab-6858-7271-9dc8-02bc69d5a33b€24.00€0.37matched
116capture01a19eab-716a-76a0-949e-c5c52e34ae88€15.00€0.26matched