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

3 Nov, 18:40

Gross

€2,291.00

PSP fee

€37.09

Net to the bank

€2,253.91

Settlement journal

#365809

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 39, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
  • missing linein the books, not in the filecapture:01a1a2be-e05e-791d-821f-8a8f0d36eea5 is in no file
LineKindReferenceGrossFeeStatus
17capture01a1a2b7-3ac0-7cb5-960d-487c7edf9d20€49.00€0.70fee difference
85capture01a1a2bd-a126-7569-972c-1863e1232a8b€24.00€0.39fee difference
91capture01a1a2be-2917-70dc-a92e-8321c9caa435€9.00€0.24fee difference
1capture01a1a2ad-1798-7143-b465-a6cacac43334€24.00€0.37matched
2capture01a1a2b4-43f0-7da8-a2b9-cf85b6e33433€24.00€0.37matched
3capture01a1a2b5-c7e0-7888-9101-6b4960c3c03e€15.00€0.26matched
4capture01a1a2b6-0c6e-7648-b0b7-a80fd975b246€35.00€0.50matched
5capture01a1a2b6-18ab-7dc5-9239-4c609322865c€49.00€0.67matched
6capture01a1a2b6-37e6-7e82-b0c1-cfa4678d0cb3€35.00€0.50matched
7capture01a1a2b6-3fa6-7d41-9558-ded816abc3cd€9.00€0.19matched
8capture01a1a2b6-5877-78a0-b38c-f0d39498b78d€24.00€0.37matched
9capture01a1a2b6-6776-7368-b736-a74dcdf68f14€9.00€0.19matched
10capture01a1a2b6-71d8-7f6d-8705-e5a790e0b22f€9.00€0.19matched
11capture01a1a2b6-9cf3-7ed0-9870-a1c1b1032a06€24.00€0.37matched
12capture01a1a2b6-a8b4-7137-9661-ba3c2fd4789e€24.00€0.37matched
13capture01a1a2b6-cc77-7624-9b84-99a0218b5844€35.00€0.50matched
14capture01a1a2b6-e643-72cc-a459-2b7890aad790€24.00€0.37matched
15capture01a1a2b7-05fb-770a-bd00-af5922151386€49.00€0.67matched
16capture01a1a2b7-3348-7cc3-a380-8fbc32bbfdee€9.00€0.19matched
18capture01a1a2b7-3ef7-75b3-8ec5-ac26ca8cda20€24.00€0.37matched
19capture01a1a2b7-681e-773d-b730-cac79dc8d1c4€9.00€0.19matched
20capture01a1a2b7-8bb5-7145-99d2-acc407421daf€15.00€0.26matched
21capture01a1a2b7-d102-76cc-9790-31b653cb6653€15.00€0.26matched
22capture01a1a2b7-d724-7622-8418-c523059d3229€35.00€0.50matched
23capture01a1a2b7-e7d4-7991-a269-d7167805e41c€9.00€0.19matched
24capture01a1a2b7-f060-7304-8e91-22c279fd7dc2€35.00€0.50matched
25capture01a1a2b7-f2fe-7b3f-a177-e0e6ed07f077€49.00€0.67matched
26capture01a1a2b7-fe66-7e33-8b03-155283b99586€24.00€0.37matched
27capture01a1a2b8-0b5e-7877-8cef-7d36b7ae08c1€24.00€0.37matched
28capture01a1a2b8-152c-7355-8c20-c4d483d66ae0€9.00€0.19matched
29capture01a1a2b8-2e8c-7fb3-b2e9-fca738848af5€24.00€0.37matched
30capture01a1a2b8-3cf3-7790-ae4d-b7c35bc0e1d9€15.00€0.26matched
31capture01a1a2b8-4193-75d1-89d2-683b13aa0fcb€49.00€0.67matched
32capture01a1a2b8-4a22-71df-800d-add20f873a7a€24.00€0.37matched
33refund01a1a2b8-7100-70c3-83ae-d1c7dc259e9e-€18.00€0.00matched
34capture01a1a2b8-66d5-704d-9cec-f62cc6891750€35.00€0.50matched
35capture01a1a2b8-9e1b-7cca-9ff4-49d2136b9060€24.00€0.37matched
36capture01a1a2b8-d97b-7cce-b32e-cd2f4c445853€24.00€0.37matched
37refund01a1a2b8-feff-7dcd-bce7-811e2b01cab4-€7.00€0.00matched
38capture01a1a2b9-1f00-713d-bd3a-21cdb193cfe5€49.00€0.67matched
39capture01a1a2b9-2d70-7cfc-a669-b49be193a84f€24.00€0.37matched
40capture01a1a2b9-3813-7342-a7d5-4dd9812ca1a7€9.00€0.19matched
41refund01a1a2b9-5b3e-7797-83fe-eba47d8af580-€15.00€0.00matched
42capture01a1a2b9-6f3c-72dc-b6df-def753863537€15.00€0.26matched
43capture01a1a2b9-a7c8-7641-a52d-159a76553cb3€15.00€0.26matched
44capture01a1a2b9-b12c-7934-85cc-e8335bb60b02€15.00€0.26matched
45capture01a1a2ba-01f8-7228-b488-69d5e05bd206€15.00€0.26matched
46capture01a1a2ba-1610-7f55-9a1f-82a057ee3ca9€35.00€0.50matched
47capture01a1a2ba-1c0a-754f-ba8b-384086809b49€15.00€0.26matched
48capture01a1a2ba-290f-7d6c-8781-c8ed332c8f8a€9.00€0.19matched
49capture01a1a2ba-5d82-7ec8-8484-432660f496cc€15.00€0.26matched
50capture01a1a2ba-5e98-7a24-b7e7-eaf85442a3f3€35.00€0.50matched
51refund01a1a2ba-7088-736d-bc18-a879eb9b0b38-€13.00€0.00matched
52capture01a1a2ba-ac6a-7dfe-8882-03591ad473c0€9.00€0.19matched
53capture01a1a2ba-c730-7285-89a1-3b86381545be€49.00€0.67matched
54capture01a1a2ba-d9a3-77fa-933b-6be40a9b85fe€15.00€0.26matched
55capture01a1a2ba-db1e-712b-abc5-bb4e1e282754€49.00€0.67matched
56capture01a1a2ba-f968-7b2f-94a5-fa1319abe069€35.00€0.50matched
57capture01a1a2ba-ff9f-7346-99fc-0d3f519395b1€24.00€0.37matched
58capture01a1a2bb-23a8-7cfe-8154-d3eb586c11fc€49.00€0.67matched
59capture01a1a2bb-360d-7a6f-9a17-532526083848€24.00€0.37matched
60capture01a1a2bb-9017-761d-bd9a-d962251bb177€49.00€0.67matched
61capture01a1a2bb-b5b4-7a5f-a995-44e38397fa33€15.00€0.26matched
62capture01a1a2bb-b68f-7c8a-8827-20fd28719e66€9.00€0.19matched
63capture01a1a2bb-bd83-7c4a-b33e-01936b2cd96f€24.00€0.37matched
64capture01a1a2bb-e667-76a9-97ed-e54b26078b13€15.00€0.26matched
65capture01a1a2bb-f57e-7e64-ad14-99c383d709e1€9.00€0.19matched
66capture01a1a2bc-00d9-7355-8235-1db6d3cea9ed€9.00€0.19matched
67capture01a1a2bc-2a1f-7def-989c-296c75d3351c€9.00€0.19matched
68capture01a1a2bc-3933-7756-b7b6-a24670ba6dc3€35.00€0.50matched
69capture01a1a2bc-3fc9-783e-9a01-abe9b9757dde€49.00€0.67matched
70capture01a1a2bc-5289-7b64-af47-fb2cbb0f4256€15.00€0.26matched
71capture01a1a2bc-6a82-7e48-9575-819bd05542d7€15.00€0.26matched
72capture01a1a2bc-7ac8-7dca-932c-e827745c5cf0€15.00€0.26matched
73capture01a1a2bc-a093-730d-905a-4a12bcdcbbb1€35.00€0.50matched
74capture01a1a2bc-cd72-7f55-9215-b5bcd9a09ac1€24.00€0.37matched
75capture01a1a2bc-cf7c-703f-8e15-0faa6c3af35d€49.00€0.67matched
76capture01a1a2bc-e950-7738-a604-6b134f84390a€35.00€0.50matched
77refund01a1a2bc-eb96-7c73-b55e-aeb1bf669f38-€18.00€0.00matched
78capture01a1a2bc-ebf5-7df5-9f55-7408e978ae42€49.00€0.67matched
79capture01a1a2bc-f27a-7c88-b8c3-68fa161f4144€35.00€0.50matched
80capture01a1a2bc-f327-7de1-8c4f-96a6455b2f8b€49.00€0.67matched
81capture01a1a2bc-f86a-73df-abb5-b8f06c355125€15.00€0.26matched
82refund01a1a2bd-3456-73b2-8714-7eb8cda902ff-€9.00€0.00matched
83refund01a1a2bd-3f44-7c21-8687-d9d1e54eb7bf-€34.00€0.00matched
84capture01a1a2bd-5891-70cb-b3ae-4e90a0481057€24.00€0.37matched
86capture01a1a2bd-a2f4-7159-a798-797a244f24df€15.00€0.26matched
87capture01a1a2bd-f2b6-706b-9b0d-73436d49d381€15.00€0.26matched
88capture01a1a2bd-f573-71c7-9f6e-50c5a381bf94€15.00€0.26matched
89capture01a1a2be-10d6-7327-89c8-6ab397bcb7ce€9.00€0.19matched
90capture01a1a2be-1527-7698-ac5d-97af5ea3cca9€9.00€0.19matched
92capture01a1a2be-3fb2-7449-bdc0-1666fa0e0721€24.00€0.37matched
93capture01a1a2be-42cb-7a19-a342-42bcab14f1ab€9.00€0.19matched
94capture01a1a2be-46c2-7e2a-bef8-41402c0c9a71€49.00€0.67matched
95capture01a1a2be-56c3-729c-b94f-37b0c821afc7€15.00€0.26matched
96capture01a1a2be-5725-762d-8edd-11e987937572€15.00€0.26matched
97capture01a1a2be-5b5c-7faf-96b5-c8749f29cd3a€15.00€0.26matched
98refund01a1a2be-642b-70f9-979c-621dfa08bde6-€8.00€0.00matched
99capture01a1a2be-96a8-74c8-9082-aafde2d4c616€24.00€0.37matched
100capture01a1a2be-941a-792d-8611-cf909378ba09€35.00€0.50matched
101capture01a1a2be-af2f-7d7a-a69e-8eebd9dc1422€15.00€0.26matched
102capture01a1a2be-bb86-7064-980c-8f7a205c0102€35.00€0.50matched
103capture01a1a2be-e493-7fdf-bf48-c7c73709ae60€9.00€0.19matched
104capture01a1a2be-ee71-7c58-b31f-d215a44b2cc5€15.00€0.26matched
105capture01a1a2be-ef04-734d-a559-425dffe8814c€9.00€0.19matched
106capture01a1a2be-fb56-704c-8385-cb2fef47689b€35.00€0.50matched
107capture01a1a2bf-0f81-7f72-bdd0-a4fa3eeeceea€35.00€0.50matched