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, 23:30

Gross

€2,765.00

PSP fee

€42.96

Net to the bank

€2,722.04

Settlement journal

#405966

Breaks for a person to look at

  • 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 51, the contract says 50
  • missing linein the books, not in the filecapture:01a1ae0d-c1d0-74cb-94a8-9dc0680af18f is in no file
LineKindReferenceGrossFeeStatus
16capture01a1ae0d-6bfb-79e2-ad1a-c23cde516682€9.00€0.24fee difference
108capture01a1ae15-36b1-7c79-b8eb-1ae61638c372€35.00€0.51fee difference
1capture01a1ae0b-b3c8-7b41-9aa6-fbcd21acc888€15.00€0.26matched
2capture01a1ae0c-4268-7ddf-901c-7c0687f36335€49.00€0.67matched
3capture01a1ae0c-5142-7eab-bc56-24b1b9303e54€15.00€0.26matched
4refund01a1ae0c-55f5-7332-9266-206cb2248fe5-€6.00€0.00matched
5capture01a1ae0c-91f2-70fb-b044-d2c15d85ac30€35.00€0.50matched
6capture01a1ae0c-93c3-7481-a4eb-e802f80a3392€15.00€0.26matched
7capture01a1ae0c-bb0c-7792-9d5a-f1dc6b93b5c3€49.00€0.67matched
8capture01a1ae0c-bfa3-74bc-b652-fe73c7c0d4b7€35.00€0.50matched
9capture01a1ae0c-c1c9-7a12-8167-6ae331efae73€35.00€0.50matched
10capture01a1ae0c-fc67-7125-b55b-8a26af2f0dd4€9.00€0.19matched
11capture01a1ae0d-0286-7bcb-93af-ca45fc460b7a€24.00€0.37matched
12capture01a1ae0d-03e1-7f6d-996c-8244c0ce3262€24.00€0.37matched
13refund01a1ae0d-127f-7707-9fb9-eafaba6b1555-€34.00€0.00matched
14capture01a1ae0d-14ae-70a8-8797-75be04c30b6d€9.00€0.19matched
15capture01a1ae0d-46c3-7502-8d36-4ea3dbe2bbad€9.00€0.19matched
17capture01a1ae0d-7ac5-7978-8a50-0af0839f6c3c€15.00€0.26matched
18capture01a1ae0d-80b4-7ed2-918d-571910ce6d5c€15.00€0.26matched
19capture01a1ae0d-8b96-7c2d-b24e-53d308abcb22€9.00€0.19matched
20capture01a1ae0d-9c2d-7bb8-b6c8-d2a1441c6780€49.00€0.67matched
21capture01a1ae0d-a1ed-7fbd-90c2-14f737daab45€49.00€0.67matched
22capture01a1ae0d-c2b8-7b75-a551-2cb53ec97043€9.00€0.19matched
23capture01a1ae0d-c548-7782-8e7c-6481925f051a€35.00€0.50matched
24capture01a1ae0d-ccc1-732d-aba0-62326bbf36ca€15.00€0.26matched
25capture01a1ae0d-de4f-75e8-9b56-a15c103c17fc€49.00€0.67matched
26capture01a1ae0d-f2ea-7e69-846d-5e2c4c845b20€35.00€0.50matched
27refund01a1ae0e-22d6-78fa-b28f-6750299cc11d-€30.00€0.00matched
28capture01a1ae0e-27b8-76c1-b884-70a262d4a918€15.00€0.26matched
29capture01a1ae0e-2eda-7f1b-8806-8cac77045951€15.00€0.26matched
30capture01a1ae0e-7575-7e22-b768-6d3103ab4a83€9.00€0.19matched
31capture01a1ae0e-7bb9-72e2-b186-c361fb29ec2d€9.00€0.19matched
32capture01a1ae0e-8fe4-71d9-bf73-a8b2f5da05ca€35.00€0.50matched
33capture01a1ae0e-c90f-7f4d-8fd4-186b2f516529€35.00€0.50matched
34capture01a1ae0e-d931-7de8-818d-dc40407107e3€35.00€0.50matched
35capture01a1ae0f-0063-75f3-a92a-d404af539689€15.00€0.26matched
36capture01a1ae0f-0b6f-76e4-8bfb-f2422ac10886€24.00€0.37matched
37capture01a1ae0f-13b2-7708-b68f-aa2cb1573c3b€9.00€0.19matched
38capture01a1ae0f-39e6-7710-a63b-9bcfb5f11a6c€49.00€0.67matched
39capture01a1ae0f-4c83-750b-b505-f02b4ebd9002€15.00€0.26matched
40capture01a1ae0f-51f9-767b-96c7-2883ff9bfa1f€15.00€0.26matched
41capture01a1ae0f-7e47-725f-8298-d6069c875ee5€9.00€0.19matched
42capture01a1ae0f-8367-733d-804e-d9d27a4323cd€24.00€0.37matched
43capture01a1ae0f-8edb-7950-b4de-794e8ea9196d€49.00€0.67matched
44capture01a1ae0f-9a8c-798e-969e-b7f1dc852477€9.00€0.19matched
45refund01a1ae0f-aced-7d1c-85fd-7f123eac2210-€9.00€0.00matched
46capture01a1ae0f-b5ac-7c9c-b18c-6a7359c17207€24.00€0.37matched
47capture01a1ae0f-bef6-7d6a-96c2-82f09cf59400€24.00€0.37matched
48capture01a1ae0f-c115-7933-9a5f-a9aa5e95a005€15.00€0.26matched
49capture01a1ae0f-c43e-7199-b095-73e29d553a88€35.00€0.50matched
50capture01a1ae0f-c721-734a-bc53-34ca22f40c78€24.00€0.37matched
51capture01a1ae0f-cd50-785d-94e2-2639be950e99€49.00€0.67matched
52capture01a1ae0f-dc05-75a1-9931-d7fe6b8be951€49.00€0.67matched
53capture01a1ae0f-ed19-74be-b7db-3021195f9812€15.00€0.26matched
54capture01a1ae0f-f046-769b-9a9a-0d3523a49c04€35.00€0.50matched
55capture01a1ae10-0eea-7cfb-b601-6bb22bd409b4€49.00€0.67matched
56capture01a1ae10-2c29-72d3-baf0-b298b96e3c82€24.00€0.37matched
57capture01a1ae10-7691-74e9-9e65-05283be1cf41€24.00€0.37matched
58capture01a1ae10-8b19-7e42-8c3c-6d73395b47f6€35.00€0.50matched
59capture01a1ae10-b78a-7070-abcf-d822b857b64b€49.00€0.67matched
60capture01a1ae10-d513-7459-b03b-965d495742f0€49.00€0.67matched
61capture01a1ae10-d9aa-74ea-9b57-10077e899682€9.00€0.19matched
62capture01a1ae10-efcd-708d-a882-23b850d8f115€35.00€0.50matched
63capture01a1ae11-32c0-7b90-86e5-6e00902084f1€15.00€0.26matched
64capture01a1ae11-7b89-720d-97ee-12a6fdc22e62€24.00€0.37matched
65capture01a1ae11-87d3-7a12-a4e4-b685f2851495€24.00€0.37matched
66capture01a1ae11-b253-7f27-8975-924f2ed01051€35.00€0.50matched
67capture01a1ae11-ba65-703b-bf5e-ee24b1e01b50€49.00€0.67matched
68capture01a1ae11-d406-7464-9128-e9413d7f7315€35.00€0.50matched
69capture01a1ae12-0303-7596-8596-4f5c85acd403€49.00€0.67matched
70refund01a1ae12-3be1-72c2-a5ee-d819de0181f9-€18.00€0.00matched
71capture01a1ae12-46e1-77f8-91dc-cb774dc07063€35.00€0.50matched
72capture01a1ae12-5de0-7522-8ce4-73a3cae8e2d5€9.00€0.19matched
73capture01a1ae12-84fb-7ee5-8104-e5147735721c€15.00€0.26matched
74capture01a1ae12-9a92-75e7-9a99-b1be48817ea3€24.00€0.37matched
75capture01a1ae12-a3da-7002-9a69-587200372a31€15.00€0.26matched
76capture01a1ae12-c80c-773c-880c-bbcf375f4f55€24.00€0.37matched
77capture01a1ae12-cc30-7ce7-be97-3fd0594522a2€35.00€0.50matched
78capture01a1ae12-cf62-7d9a-9b7c-58ad721a4896€15.00€0.26matched
79capture01a1ae12-d329-730a-8a64-67ed141fbf9d€24.00€0.37matched
80capture01a1ae12-e30a-7cb1-819d-c630562c109e€24.00€0.37matched
81capture01a1ae13-0997-7c55-ae33-033068ef81f0€9.00€0.19matched
82capture01a1ae13-09bc-7c56-ba43-a2764d2742ad€35.00€0.50matched
83capture01a1ae13-1179-70b9-b4b5-c21d98365159€49.00€0.67matched
84capture01a1ae13-1fd2-74a6-af37-81a1dfb0ddb9€15.00€0.26matched
85capture01a1ae13-296c-7074-a8c4-5777f1a9c3cb€15.00€0.26matched
86refund01a1ae13-369a-7240-baf9-000427d6fe3d-€17.00€0.00matched
87capture01a1ae13-4573-7a37-a049-b0bbd9783cb8€49.00€0.67matched
88capture01a1ae13-646d-7854-aba7-645581c2fcf6€24.00€0.37matched
89capture01a1ae13-8172-7664-88ad-189f527d14c4€35.00€0.50matched
90capture01a1ae13-9f6a-70df-a709-59c7311c3271€49.00€0.67matched
91capture01a1ae13-a3f7-7fe6-ab29-5c7a56b30f10€49.00€0.67matched
92capture01a1ae13-abdf-733f-b084-3a338a325148€35.00€0.50matched
93capture01a1ae13-bf5a-7599-af85-97f3acee84ff€49.00€0.67matched
94capture01a1ae13-ef5f-796a-bd27-ffa39fb3f66c€49.00€0.67matched
95capture01a1ae14-189c-72f4-9fc3-994cc46810a9€15.00€0.26matched
96capture01a1ae14-3dff-76ba-8751-6532c715ab83€49.00€0.67matched
97capture01a1ae14-4761-768f-a291-f13b2926e5ee€15.00€0.26matched
98capture01a1ae14-81ad-752f-bbaf-2cef21398855€49.00€0.67matched
99capture01a1ae14-8ed0-7fc0-bc2b-5fea4f73d164€15.00€0.26matched
100capture01a1ae14-a977-7f91-8f80-8c55762ec637€15.00€0.26matched
101capture01a1ae14-bc16-7971-a7b0-05fdfe0661de€24.00€0.37matched
102capture01a1ae14-c7a4-7d14-90b0-c61fd00b3274€35.00€0.50matched
103capture01a1ae14-cbb8-7c81-8110-229d551c3cea€15.00€0.26matched
104capture01a1ae14-e905-759f-99f4-343867f7fc97€15.00€0.26matched
105capture01a1ae14-fe68-7e5c-b03d-4d15939f7cb4€24.00€0.37matched
106capture01a1ae15-09ea-76aa-81be-ff9147fe787a€49.00€0.67matched
107capture01a1ae15-309d-71fe-bf5f-cb782d3428b9€35.00€0.50matched
109capture01a1ae15-5590-7211-a0e4-94927090e70c€49.00€0.67matched