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, 19:50

Gross

€2,972.00

PSP fee

€47.23

Net to the bank

€2,924.77

Settlement journal

#403273

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 40, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
  • missing linein the books, not in the filecapture:01a1ad48-3bbc-7224-b331-31c586c9ab78 is in no file
LineKindReferenceGrossFeeStatus
1capture01a1ad42-d259-7142-ac92-219fc30cd740€9.00€0.24fee difference
20capture01a1ad43-ff7b-704e-8cdf-1e140e20c908€24.00€0.40fee difference
49capture01a1ad46-4b67-7379-821d-5b310b4d1c75€15.00€0.29fee difference
69capture01a1ad47-6902-79f6-91af-cd41e087fe4b€9.00€0.22fee difference
2refund01a1ad42-d304-7117-b4d6-1287dd3f3152-€20.00€0.00matched
3capture01a1ad42-e295-7dd4-b030-5d46abb64764€35.00€0.50matched
4capture01a1ad42-ef63-7118-860b-5ed39c2323a7€49.00€0.67matched
5capture01a1ad42-f892-7c13-96a7-fef9bc392ced€35.00€0.50matched
6capture01a1ad43-1bf7-7911-8eb8-bd18ac76c28f€9.00€0.19matched
7capture01a1ad43-1cf0-786c-8bcc-1c1efd8f6813€15.00€0.26matched
8capture01a1ad43-3fc4-7c3a-a576-1d4496b4e0c4€49.00€0.67matched
9capture01a1ad43-4488-7265-b712-4b0262fd696e€9.00€0.19matched
10capture01a1ad43-62c3-72e1-96e5-5bc50ad23abd€49.00€0.67matched
11capture01a1ad43-7a74-7440-935b-772930c30c63€9.00€0.19matched
12capture01a1ad43-85eb-71c6-8c77-631c96af84ed€15.00€0.26matched
13capture01a1ad43-a62b-7406-a7fa-da33cf39b24f€24.00€0.37matched
14capture01a1ad43-a7c0-71a0-aaa0-270cb053a86d€35.00€0.50matched
15capture01a1ad43-b42d-728f-a79e-e12bf8071e74€15.00€0.26matched
16capture01a1ad43-c2e9-73fc-bbeb-1f9d40bf9c36€15.00€0.26matched
17capture01a1ad43-ed59-774d-8c56-e0dd955364fb€35.00€0.50matched
18capture01a1ad43-ef30-7f00-87c5-c403dbe95953€9.00€0.19matched
19capture01a1ad43-f1d5-7a0f-9aaf-e3d069a5c4ef€24.00€0.37matched
21capture01a1ad44-4e19-786d-b2d6-62b8571e2d13€49.00€0.67matched
22capture01a1ad44-68e9-7313-b127-0839a081f2cd€24.00€0.37matched
23capture01a1ad44-82d6-78d3-a529-c9a583a5ea52€24.00€0.37matched
24capture01a1ad44-865b-70e0-afb4-2d6c4e57f2d6€15.00€0.26matched
25capture01a1ad44-c368-79bd-a255-775bf1d670b8€49.00€0.67matched
26capture01a1ad44-e6ab-7e5d-abb6-0c28a2661ed1€49.00€0.67matched
27capture01a1ad44-ec19-7ec6-9652-9591eaa42479€24.00€0.37matched
28capture01a1ad44-f869-70f7-9f23-ab5bc4b9d9b6€9.00€0.19matched
29capture01a1ad45-056c-7cb5-b94d-265f102913e5€35.00€0.50matched
30capture01a1ad45-10da-7663-8f63-4a42bc2853db€24.00€0.37matched
31capture01a1ad45-15ab-7a8b-a414-697e11905b6b€49.00€0.67matched
32capture01a1ad45-1d2d-74b7-982d-c745f40c252c€9.00€0.19matched
33capture01a1ad45-280a-787c-be8a-829ee0750f71€15.00€0.26matched
34capture01a1ad45-3ca0-7f04-be62-90109f87b9d1€9.00€0.19matched
35capture01a1ad45-530b-76e5-aead-53d43593cc4f€49.00€0.67matched
36capture01a1ad45-7ec4-797c-ac3d-f31319b243b8€35.00€0.50matched
37capture01a1ad45-899d-71fe-bf29-c17df52df197€35.00€0.50matched
38capture01a1ad45-9790-752b-b2ca-c84f0499a055€24.00€0.37matched
39capture01a1ad45-9bd7-7674-b91f-ab342a28ff38€15.00€0.26matched
40capture01a1ad45-aecd-782a-95a7-4734420e8a1f€15.00€0.26matched
41capture01a1ad45-bcff-7d5a-821a-372a8069e8ba€49.00€0.67matched
42capture01a1ad45-fc31-764a-8d1d-837aa96ac499€49.00€0.67matched
43capture01a1ad46-03a1-7a76-8fb5-e889e05a9cb7€9.00€0.19matched
44capture01a1ad46-13b3-79a6-af5e-e6f761e56375€9.00€0.19matched
45capture01a1ad46-13de-7520-8080-c283bc587a29€24.00€0.37matched
46capture01a1ad46-380f-7a8c-9eae-d26817d8ee1d€35.00€0.50matched
47capture01a1ad46-405f-7230-a5ff-aa22bbaae7c2€9.00€0.19matched
48capture01a1ad46-4b5c-7891-9d7c-57e2c8a25725€35.00€0.50matched
50capture01a1ad46-6b18-72d0-a87f-7481507cbb48€35.00€0.50matched
51capture01a1ad46-7503-7e45-9195-60eb06c3d998€9.00€0.19matched
52refund01a1ad46-7656-7a32-8911-df4e877dbb3a-€4.00€0.00matched
53capture01a1ad46-7a34-7293-9c51-f739b4ab3519€9.00€0.19matched
54capture01a1ad46-aaad-7809-b176-f6c8ceb50b4b€15.00€0.26matched
55capture01a1ad46-b562-7023-9f2e-2a4373ed9506€9.00€0.19matched
56capture01a1ad46-bd54-7e08-9888-5087e2382add€24.00€0.37matched
57capture01a1ad46-c185-76af-8aad-09339822ce7b€15.00€0.26matched
58capture01a1ad46-c9a3-76bf-9439-6c5bd7f463aa€35.00€0.50matched
59capture01a1ad46-d1cb-7523-b9bb-65ccca184f69€24.00€0.37matched
60refund01a1ad47-0728-7343-b78a-8e7033e2bb81-€4.00€0.00matched
61capture01a1ad47-0a7f-7ba8-9622-c18e2b2c0f8d€24.00€0.37matched
62capture01a1ad47-2692-77c7-b2d1-737ba958546c€15.00€0.26matched
63capture01a1ad47-3107-77f2-a884-f52dcce86216€15.00€0.26matched
64capture01a1ad47-47b9-77eb-96de-172df2ce8a77€24.00€0.37matched
65capture01a1ad47-49d5-7f88-8f96-ef0da4a246fd€24.00€0.37matched
66capture01a1ad47-56f3-7ead-b5b1-e184759b9016€24.00€0.37matched
67capture01a1ad47-65ed-7b1a-ab6c-0ce1be4b8996€15.00€0.26matched
68capture01a1ad47-66d3-794e-b3a1-9205bb9d9661€49.00€0.67matched
70capture01a1ad47-7134-775c-a13d-52ee00e0d5ec€9.00€0.19matched
71capture01a1ad47-83df-74e8-a692-5d865ea21e00€9.00€0.19matched
72refund01a1ad47-9697-7258-87de-23eb76fe49ac-€13.00€0.00matched
73capture01a1ad47-ad73-7dc2-a975-2a8a8f1eb3f6€9.00€0.19matched
74capture01a1ad47-af8b-70e7-ab6d-cd8b40ed3f5f€35.00€0.50matched
75capture01a1ad47-bf6c-7c32-89e8-9b72834a8272€49.00€0.67matched
76capture01a1ad47-d92a-7ea7-99d6-88a0e061bdd3€24.00€0.37matched
77capture01a1ad47-dc65-73c0-b8ff-e2cc286289a6€35.00€0.50matched
78refund01a1ad47-de1c-742a-9844-ae82b8787a7d-€4.00€0.00matched
79capture01a1ad48-07ac-7ecb-9324-532073fcb14d€24.00€0.37matched
80capture01a1ad48-2932-73e1-8055-a7d18e553419€15.00€0.26matched
81capture01a1ad48-2b7d-7938-a8e4-f39c83826ac4€35.00€0.50matched
82capture01a1ad48-491b-7131-a1b1-d37f3f9d3e28€9.00€0.19matched
83capture01a1ad48-4c20-74ad-bcf7-d3bdf7cbe8bd€9.00€0.19matched
84capture01a1ad48-5a42-74f9-89c7-a46f54144682€24.00€0.37matched
85capture01a1ad48-7e01-7398-9a83-6f881014fb79€35.00€0.50matched
86capture01a1ad48-8507-73d6-9629-34be4fdc41b8€9.00€0.19matched
87capture01a1ad48-88f5-7597-a698-8fed5d1a784c€35.00€0.50matched
88capture01a1ad48-8af5-7f14-984f-f6c6c02a35eb€35.00€0.50matched
89capture01a1ad48-8c7b-7df8-a423-059b9d854987€9.00€0.19matched
90capture01a1ad48-8ced-78ba-9019-f5c2a2d026e9€24.00€0.37matched
91capture01a1ad48-8e9a-7833-83a2-ab3efaacd7e2€9.00€0.19matched
92capture01a1ad48-a73d-7237-8f21-1bdde35c3e74€15.00€0.26matched
93capture01a1ad48-bce2-7658-9e5b-f460ccd8af63€9.00€0.19matched
94refund01a1ad49-042a-7bcd-9ac0-2986943e26b4-€13.00€0.00matched
95capture01a1ad49-0740-78e1-92c3-3719484bcdd2€35.00€0.50matched
96capture01a1ad49-1015-7cb9-9137-04b790544fee€35.00€0.50matched
97capture01a1ad49-12ec-7c87-a61c-629d86250dfc€49.00€0.67matched
98capture01a1ad49-2cb0-750a-b235-06ef2ee99bf1€24.00€0.37matched
99capture01a1ad49-5ba9-7a93-9267-a63de909a91c€49.00€0.67matched
100refund01a1ad49-5be1-764e-8148-afb25f6c885b-€28.00€0.00matched
101capture01a1ad49-6a4e-74d4-ac0b-87783e56f10d€15.00€0.26matched
102capture01a1ad49-6f04-7b6a-bbe4-a3fb8d1876df€9.00€0.19matched
103capture01a1ad49-994b-76f0-8852-fa49e2912837€49.00€0.67matched
104capture01a1ad49-b80d-72a9-865a-778fd8f33837€35.00€0.50matched
105capture01a1ad49-e7b0-7245-be84-eb7278996550€9.00€0.19matched
106refund01a1ad4a-042f-7730-be1e-242a3ef3562c-€25.00€0.00matched
107capture01a1ad4a-13f6-7275-9762-515425fd76ea€9.00€0.19matched
108capture01a1ad4a-42e0-7b82-be81-1912a5eaaaad€24.00€0.37matched
109capture01a1ad4a-43f7-7dc4-a505-b4ddcb2d5d92€35.00€0.50matched
110capture01a1ad4a-6153-7678-af56-f21c165c8e8a€24.00€0.37matched
111capture01a1ad4a-624c-72d5-a65a-144d910ccb9e€49.00€0.67matched
112capture01a1ad4a-6846-79e0-966e-b01823940f43€9.00€0.19matched
113capture01a1ad4a-7078-736b-bb32-f3ecd659fbd2€35.00€0.50matched
114capture01a1ad4a-888c-7cea-ae4d-06a2b6cfdedb€35.00€0.50matched
115capture01a1ad4a-9e14-7147-bd3d-8ed1dbf382b3€35.00€0.50matched
116capture01a1ad4a-a1a9-76f6-bd78-0dc8fc25939d€24.00€0.37matched
117refund01a1ad4a-b8c5-7c7d-be51-5234205594ec-€7.00€0.00matched
118capture01a1ad4a-bbed-7297-a77f-55a4e547c844€49.00€0.67matched
119capture01a1ad4a-cc98-7bcb-9d86-a6e49427ee16€15.00€0.26matched
120capture01a1ad4a-d9d4-7ec5-9a98-6b799a018d17€9.00€0.19matched
121capture01a1ad4a-e7ff-73a4-99c3-0e3e883e476f€24.00€0.37matched
122capture01a1ad4a-fe4d-735c-9685-3fe6248e3c2a€24.00€0.37matched
123refund01a1ad4b-04c1-70e3-a1e0-69c94a745917-€8.00€0.00matched
124capture01a1ad4b-0d24-7bbd-8148-4a7c7f4beb24€35.00€0.50matched
125capture01a1ad4b-4ed6-748f-b3e1-6ff1660b8a53€9.00€0.19matched
126capture01a1ad4b-5de4-767d-a14b-275702727b2e€49.00€0.67matched
127capture01a1ad4b-6895-7b14-bc25-6ba26e4c13e5€49.00€0.67matched
128capture01a1ad4b-86e8-735f-9cb1-7d0c5aeeaaec€9.00€0.19matched
129capture01a1ad4b-8fe5-786b-a273-8a446e2a2560€35.00€0.50matched
130capture01a1ad4b-95e5-7f8a-95e7-9bf122f28db0€24.00€0.37matched
131capture01a1ad4b-a639-7952-a280-2d16a82cc0a1€49.00€0.67matched
132capture01a1ad4b-f90d-7400-8bc4-3afce7a0a149€35.00€0.50matched