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, 15:20

Gross

€2,500.00

PSP fee

€40.23

Net to the bank

€2,459.77

Settlement journal

#363230

Every line paired with the books, and every capture and refund of the day is in the file.

LineKindReferenceGrossFeeStatus
3capture01a1a1fe-d569-784d-9de2-55ddb7842cf0€9.00€0.24fee difference
1capture01a1a1fa-385e-7846-a87f-808744cb4987€35.00€0.50matched
2capture01a1a1fb-fa69-7231-ad0f-4e035c251b0b€15.00€0.26matched
4capture01a1a1ff-0840-77f9-9976-a6f07ff6e62d€49.00€0.67matched
5capture01a1a1ff-0ce4-77cb-bfe2-a4f29472b732€15.00€0.26matched
6capture01a1a1ff-38fe-754e-b476-9af57de130d7€9.00€0.19matched
7capture01a1a1ff-3cef-731c-871a-2a31ea10d057€9.00€0.19matched
8capture01a1a1ff-4071-7c10-ac75-f3ff0baad5ff€24.00€0.37matched
9capture01a1a1ff-5ce3-71ab-85ba-4283e3a8a8e4€35.00€0.50matched
10capture01a1a1ff-67c2-7e38-a8c3-e31061f8d7bd€35.00€0.50matched
11capture01a1a1ff-7390-776b-a32b-afd67ddec9a3€24.00€0.37matched
12capture01a1a1ff-7c59-7194-bea1-0a3cc3262906€9.00€0.19matched
13capture01a1a1ff-7f2d-7638-87ff-873667121009€15.00€0.26matched
14refund01a1a1ff-bb75-76e0-8798-b84df6fb62e2-€30.00€0.00matched
15capture01a1a1ff-c22d-7edc-a2c3-1174a45081cb€24.00€0.37matched
16capture01a1a1ff-e3bc-733c-bf42-6778f1bfad0f€15.00€0.26matched
17capture01a1a200-1010-728c-81b7-29b1f43c633c€15.00€0.26matched
18capture01a1a200-29e6-78c2-824e-8a4a46bd051f€9.00€0.19matched
19capture01a1a200-3954-7c23-b93d-3bf6fcebbd61€15.00€0.26matched
20capture01a1a200-58be-7ce2-aba1-923e1fa570e6€24.00€0.37matched
21capture01a1a200-5b4d-76b2-a95f-8560095645ce€15.00€0.26matched
22refund01a1a200-75d0-792f-a56a-106164116585-€13.00€0.00matched
23capture01a1a200-88c7-72fd-a00c-2214a5071c47€9.00€0.19matched
24capture01a1a200-8a77-74be-bde6-669f78ea78b4€35.00€0.50matched
25capture01a1a200-8ae3-76ae-9634-81c414a81076€15.00€0.26matched
26capture01a1a200-adb0-7259-b6f8-7c9b5b75aaf0€9.00€0.19matched
27capture01a1a200-c684-7072-971e-8133a4f64f7b€15.00€0.26matched
28capture01a1a200-d5d2-7b85-934e-f5dc6bf2b964€9.00€0.19matched
29capture01a1a200-e20c-7330-b809-82305770d707€35.00€0.50matched
30capture01a1a200-f4cb-7779-b5d8-a74df6c2ba95€15.00€0.26matched
31capture01a1a201-01fd-7107-86ec-2704e8ace85e€49.00€0.67matched
32capture01a1a201-0272-7361-8f21-f95033b86057€15.00€0.26matched
33capture01a1a201-0471-7107-9c1d-18f7baa14318€15.00€0.26matched
34capture01a1a201-1e98-7d1f-b208-1c1b08e8d84d€35.00€0.50matched
35capture01a1a201-21d9-701d-8d59-ffd5899313e5€15.00€0.26matched
36capture01a1a201-5aad-7e92-a8e3-1bdd53b86964€15.00€0.26matched
37capture01a1a201-a65c-7fec-8210-bbb38c9ca4e5€49.00€0.67matched
38capture01a1a201-cd7a-7905-a6db-7d79c24dfbbe€15.00€0.26matched
39capture01a1a201-e35f-74eb-9255-03287f72c5c1€15.00€0.26matched
40capture01a1a201-e7d9-7729-b567-d65031596a6e€24.00€0.37matched
41capture01a1a202-179d-78c8-83a0-7753b12ddc95€35.00€0.50matched
42capture01a1a202-222e-7654-bd16-2f0db1ebb544€15.00€0.26matched
43capture01a1a202-2809-7dd8-b366-c077ace7142c€24.00€0.37matched
44capture01a1a202-39f1-7eda-81af-6146224d868a€35.00€0.50matched
45capture01a1a202-5a46-7848-8199-9d86933d81f2€15.00€0.26matched
46capture01a1a202-6098-7287-8810-15a039a7d93a€35.00€0.50matched
47capture01a1a202-974f-7879-b031-eec736d3f719€24.00€0.37matched
48refund01a1a202-b24a-7725-80d3-9a50c2249e17-€20.00€0.00matched
49capture01a1a202-bb76-75e3-a341-efa64772013f€9.00€0.19matched
50capture01a1a202-f0d3-70c0-b79a-bd6e9deca1ed€49.00€0.67matched
51capture01a1a203-1034-7ef7-a673-eefa560ab55f€35.00€0.50matched
52capture01a1a203-355b-7c9d-b701-da412e1a86f2€49.00€0.67matched
53capture01a1a203-359f-788e-8756-82ac60e5b8cb€35.00€0.50matched
54capture01a1a203-44f0-7462-b130-bf007c4cf14f€35.00€0.50matched
55capture01a1a203-4c69-77fe-beb0-99fbae5514e0€15.00€0.26matched
56capture01a1a203-60e6-7e5d-96af-ce718715f45d€35.00€0.50matched
57capture01a1a203-9458-7c7e-9bf3-9bc4039bd414€24.00€0.37matched
58capture01a1a203-94bf-73a2-986f-969202cd84d4€24.00€0.37matched
59capture01a1a203-a128-7757-a068-b4c23722b2c5€15.00€0.26matched
60capture01a1a203-a794-7433-a18e-fb4f318d37af€49.00€0.67matched
61capture01a1a203-c27d-745c-861b-b2a56f396eeb€15.00€0.26matched
62capture01a1a203-c806-7e5e-8cb7-bce6fd06e038€9.00€0.19matched
63capture01a1a203-cf0f-7223-9ac3-5d61820d7864€9.00€0.19matched
64capture01a1a203-e32f-72e3-b0dd-92e630b65178€35.00€0.50matched
65capture01a1a204-0622-7c74-a329-552efc8a0b55€24.00€0.37matched
66refund01a1a204-0b80-73f4-a02e-abaab7526a68-€13.00€0.00matched
67capture01a1a204-0f76-7226-b41e-4d91f6b09eac€35.00€0.50matched
68capture01a1a204-17c0-75b0-89d5-22be833b93b3€24.00€0.37matched
69capture01a1a204-6622-71df-bb67-bbf51e784564€49.00€0.67matched
70capture01a1a204-709c-789c-b0e6-c0df96d7a749€15.00€0.26matched
71capture01a1a204-8466-7da7-aacb-68706ef9d8d1€49.00€0.67matched
72capture01a1a204-a032-7244-9122-c69d0d69008d€24.00€0.37matched
73capture01a1a204-cca8-791a-be3b-6720479622eb€24.00€0.37matched
74capture01a1a204-ec66-7d8f-a890-870828efaa42€9.00€0.19matched
75capture01a1a204-f402-7ce5-9f9b-2ff200b08b98€35.00€0.50matched
76capture01a1a204-f85b-7a72-8476-1be216570aeb€35.00€0.50matched
77capture01a1a205-0537-7249-aa04-4aaa0419f3c5€24.00€0.37matched
78capture01a1a205-0d30-7c0c-b0bf-077ce0b467a0€35.00€0.50matched
79capture01a1a205-1626-752d-8956-497d0b3d25e6€24.00€0.37matched
80capture01a1a205-2593-7a23-aa01-f87b31098c67€15.00€0.26matched
81capture01a1a205-3bcf-74ec-a2e6-d2d749a81583€24.00€0.37matched
82capture01a1a205-4626-70d2-8d99-aaf78174cc84€15.00€0.26matched
83refund01a1a205-5453-7904-ba63-2f6dcc34bf9a-€7.00€0.00matched
84capture01a1a205-8156-7010-894b-878dcd3384e2€35.00€0.50matched
85capture01a1a205-99be-7df6-bce0-1d2d72fdf796€15.00€0.26matched
86capture01a1a205-b0f3-7f08-ade2-dbb30e1db8bd€9.00€0.19matched
87capture01a1a205-d6fb-7fee-a4a3-5b62e84bfe08€9.00€0.19matched
88capture01a1a206-1315-730d-b83f-de4c576a7b79€15.00€0.26matched
89capture01a1a206-266a-7835-9b43-a041b64f85b1€24.00€0.37matched
90capture01a1a206-35bd-7e3e-b539-464ccb0f901e€49.00€0.67matched
91capture01a1a206-567f-73c4-b085-2919b74ba30b€49.00€0.67matched
92capture01a1a206-6d46-78a3-b0c4-36b2c7314a36€35.00€0.50matched
93capture01a1a206-82c3-7d8d-b1fa-f5445181a013€15.00€0.26matched
94capture01a1a206-86ae-7374-9ab6-10e9f6b9a227€15.00€0.26matched
95refund01a1a206-8d9c-70e2-b593-1f506757819d-€24.00€0.00matched
96capture01a1a206-a9c2-752c-bf19-35a85e9e9f88€49.00€0.67matched
97capture01a1a206-bb07-71c2-b4c6-5d470ee7d875€35.00€0.50matched
98capture01a1a206-cf55-792b-aa19-995bfa389ec1€35.00€0.50matched
99refund01a1a206-ef89-7ede-a955-8921ddfb5149-€18.00€0.00matched
100capture01a1a206-ff4f-7090-a62c-37bc06110135€49.00€0.67matched
101capture01a1a207-0f22-709b-91ff-2f0db70deccc€24.00€0.37matched
102capture01a1a207-12ef-7e7e-bf2b-ead8e0ed3090€49.00€0.67matched
103capture01a1a207-170c-7df3-9493-61e867a57d3c€24.00€0.37matched
104capture01a1a207-2d2d-74cd-87d8-9f256ed5badc€35.00€0.50matched
105capture01a1a207-35d6-74d3-86ca-44fe86c785e6€35.00€0.50matched
106capture01a1a207-3b35-7ed7-a558-d37f8c9e4251€24.00€0.37matched
107capture01a1a207-458f-75f5-b971-7762d7b27c16€35.00€0.50matched
108capture01a1a207-6839-718d-afbf-e57f2e83b2b3€9.00€0.19matched
109capture01a1a207-8c68-7d78-873c-66f41fbe3202€35.00€0.50matched
110refund01a1a207-bfc8-7f6c-9007-055837141558-€8.00€0.00matched
111capture01a1a207-bff0-7a6d-a055-33657f93a330€9.00€0.19matched
112capture01a1a207-c86f-7fa1-a578-2ca2ace70295€9.00€0.19matched
113capture01a1a207-e850-7cff-b8a0-1d14111a5d4d€24.00€0.37matched
114capture01a1a207-eb5b-7f4e-963b-13b17183520e€9.00€0.19matched