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

Gross

€2,761.00

PSP fee

€44.38

Net to the bank

€2,716.62

Settlement journal

#398665

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 41, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
LineKindReferenceGrossFeeStatus
5capture01a1abf9-548f-7318-ac92-72dc3b7a72a0€24.00€0.41fee difference
82capture01a1abfe-faa4-7301-af4f-8462825cac7c€9.00€0.23fee difference
1capture01a1abf2-32c5-7622-81e1-cd616c9e8372€24.00€0.37matched
2capture01a1abf3-e72c-72f8-b4d2-f8b95ca271f9€24.00€0.37matched
3capture01a1abf5-3162-789f-a455-cd512904522c€9.00€0.19matched
4capture01a1abf8-7e63-7403-8f40-8f6d2f20b8e7€15.00€0.26matched
6capture01a1abf9-61ba-72ea-87f1-b5e5ec5b6610€49.00€0.67matched
7capture01a1abf9-6300-75df-97f9-3472925f9fb5€49.00€0.67matched
8capture01a1abf9-7142-74ad-8afb-331d25435728€35.00€0.50matched
9capture01a1abf9-7c7b-789e-a03f-dbdc950cc098€35.00€0.50matched
10capture01a1abf9-7ce9-708a-903a-88e5455135f5€9.00€0.19matched
11capture01a1abf9-86d5-700f-b403-2a66545446fe€15.00€0.26matched
12refund01a1abf9-bffa-7ee4-93f3-db9a1e49ab39-€3.00€0.00matched
13refund01a1abf9-c1a0-714f-a1c3-34d0f8a42dab-€17.00€0.00matched
14capture01a1abf9-cb34-7d04-9516-e5c758c6acaf€9.00€0.19matched
15capture01a1abf9-ce0e-71f4-8139-dd404ddefb04€35.00€0.50matched
16capture01a1abf9-d35d-77a6-9c27-029b66e1b0e9€49.00€0.67matched
17capture01a1abf9-dbbb-78c8-b8e9-a719e31f4a1a€15.00€0.26matched
18capture01a1abfa-02c6-7c04-b330-2a5aec57c36a€24.00€0.37matched
19capture01a1abfa-04f4-79e5-be80-19e6c64b9d9c€24.00€0.37matched
20capture01a1abfa-0c59-788c-83f1-1562eb699edc€15.00€0.26matched
21capture01a1abfa-194d-7a79-ae3f-84f78453876d€15.00€0.26matched
22capture01a1abfa-2445-700c-8b36-fd2ef780a00b€15.00€0.26matched
23capture01a1abfa-24ac-7fd6-a885-eebd6f55dfce€24.00€0.37matched
24capture01a1abfa-45aa-7e4b-bbc1-105a1dfd49f7€9.00€0.19matched
25capture01a1abfa-8504-77e1-acc3-617d44050d30€24.00€0.37matched
26capture01a1abfa-9ae9-7979-8411-ae5a2a4ad6eb€49.00€0.67matched
27capture01a1abfa-fede-7e51-91f4-4a25ccb2d714€35.00€0.50matched
28capture01a1abfb-286e-7d04-85dd-9956f44b3155€24.00€0.37matched
29capture01a1abfb-36bc-70b4-b64f-f599b1571e56€35.00€0.50matched
30refund01a1abfb-3fe7-7dd9-bcd6-5c6a07871853-€27.00€0.00matched
31capture01a1abfb-4043-7f02-bf75-d318aeead877€9.00€0.19matched
32capture01a1abfb-4489-79c3-9dfc-b72310b30ac2€49.00€0.67matched
33capture01a1abfb-5211-7cc1-8f6b-0617b4277cca€49.00€0.67matched
34capture01a1abfb-5519-75bf-993d-6857a9f35398€49.00€0.67matched
35capture01a1abfb-582a-765b-a4a8-775cc139379c€9.00€0.19matched
36capture01a1abfb-6276-73a9-89ec-ac9729d20a1c€49.00€0.67matched
37capture01a1abfb-6664-7569-b0b1-d5122907e40f€9.00€0.19matched
38capture01a1abfb-673c-78ba-983c-3e51b7211df2€15.00€0.26matched
39capture01a1abfb-72a3-7c3a-8744-4bd925ca8cf7€24.00€0.37matched
40refund01a1abfb-a24d-7426-885d-f2cbbc5c6203-€25.00€0.00matched
41capture01a1abfb-a45f-73fe-80f1-25c46f01f07e€15.00€0.26matched
42capture01a1abfb-ba7b-7ef5-8f66-dcbe7fa91727€15.00€0.26matched
43capture01a1abfb-c333-7d0e-9e4d-29722a17c668€49.00€0.67matched
44capture01a1abfb-f5e8-7c73-8e85-e6f8a84683c0€15.00€0.26matched
45capture01a1abfb-fc31-7bba-9d7a-a0909b7370e3€35.00€0.50matched
46capture01a1abfc-16e9-7379-9359-b35d330126f2€49.00€0.67matched
47capture01a1abfc-1cbe-763a-ae41-b71ebf5725e1€9.00€0.19matched
48capture01a1abfc-1fa3-7480-b331-996218fbcf2a€24.00€0.37matched
49capture01a1abfc-2e63-70c1-95d5-af05b0ead6a4€49.00€0.67matched
50capture01a1abfc-70ab-739b-bed9-d348d4638156€49.00€0.67matched
51capture01a1abfc-945e-7dc4-803a-37a6bafc613f€15.00€0.26matched
52capture01a1abfc-96c8-7baf-a74d-2967da4a9492€15.00€0.26matched
53capture01a1abfc-999d-75d3-a0e9-a44d94417f01€24.00€0.37matched
54capture01a1abfc-a4d2-7652-bc27-ffa8e1f035ff€15.00€0.26matched
55capture01a1abfc-b19e-732d-96a8-cbad4168282e€9.00€0.19matched
56capture01a1abfc-c87e-75ca-926f-26a01cb373b7€35.00€0.50matched
57capture01a1abfc-d326-7852-858d-b5d98a118d5c€35.00€0.50matched
58capture01a1abfc-d738-7e53-9af6-464f63c91c6d€49.00€0.67matched
59capture01a1abfc-e6d5-70be-90ba-1d89c928aba2€9.00€0.19matched
60capture01a1abfc-e6db-749b-8c40-fa19e3627e12€24.00€0.37matched
61refund01a1abfd-0033-7048-9990-1a0d27f2c4b4-€14.00€0.00matched
62capture01a1abfd-4271-78a7-bc1a-33a0552fedbf€9.00€0.19matched
63capture01a1abfd-4da9-7bb6-9ec6-11d8c6cacf8e€49.00€0.67matched
64capture01a1abfd-531c-73c3-aacf-edb26001e390€49.00€0.67matched
65capture01a1abfd-5ccf-7c65-bf88-909233260a02€35.00€0.50matched
66capture01a1abfd-70b4-7f77-9160-0f27736a5dca€9.00€0.19matched
67capture01a1abfd-7690-70d2-adf3-dfb5d076f9d5€35.00€0.50matched
68capture01a1abfd-804c-7ab4-99bc-4f2da13014fe€49.00€0.67matched
69capture01a1abfd-8175-7345-ab4c-685a2e8a1e34€9.00€0.19matched
70capture01a1abfd-9c7c-77d4-afd5-3c2ae698f7c0€49.00€0.67matched
71refund01a1abfd-ab74-79e4-9319-2a810adb15a8-€35.00€0.00matched
72capture01a1abfd-adeb-77e5-9e9d-a594577bf054€9.00€0.19matched
73capture01a1abfd-bc75-760e-81d7-662bce91a50f€15.00€0.26matched
74capture01a1abfd-e295-77d5-b5ae-183b34b062f3€49.00€0.67matched
75capture01a1abfd-f58d-7c64-aec9-2eb839f8b580€15.00€0.26matched
76capture01a1abfe-1d64-747a-a87a-65c35c8dd025€24.00€0.37matched
77capture01a1abfe-1d88-7876-b216-4e26637b88fc€49.00€0.67matched
78capture01a1abfe-2ad6-734a-8186-f1788e3f62fc€15.00€0.26matched
79capture01a1abfe-3caf-7d1c-8c4d-649a0e004c47€24.00€0.37matched
80capture01a1abfe-80c5-7023-a3ed-c1209f803ec5€24.00€0.37matched
81capture01a1abfe-cca9-7037-87a4-679d808913e3€9.00€0.19matched
83capture01a1abff-02d2-7234-b732-15cfa9ad6213€24.00€0.37matched
84capture01a1abff-13ca-76d3-9fce-fe350e172b9d€15.00€0.26matched
85capture01a1abff-1f61-73df-a591-0b4f4595b562€35.00€0.50matched
86capture01a1abff-5386-7216-8fa2-aa1ed7a21c1f€9.00€0.19matched
87capture01a1abff-742c-721a-8b63-22f784f5bd93€9.00€0.19matched
88capture01a1abff-7b56-7d8d-aa8c-dfb9b5b920cb€15.00€0.26matched
89capture01a1abff-b1a8-7752-b347-7cd86e5349c0€49.00€0.67matched
90capture01a1abff-b62f-7f93-8076-9a26e4f7dbbd€24.00€0.37matched
91refund01a1abff-eab1-78b4-985e-6f3cb81688bf-€2.00€0.00matched
92capture01a1ac00-125b-71a7-baaa-eff98239cab8€35.00€0.50matched
93capture01a1ac00-3042-7e70-adf5-4e0edb3b8b0d€15.00€0.26matched
94capture01a1ac00-5701-77e3-8728-c0bfc8f1ea96€15.00€0.26matched
95capture01a1ac00-595b-7d28-bf14-483e62d3b977€24.00€0.37matched
96refund01a1ac00-6d36-726d-9f76-ac8849c25fe6-€11.00€0.00matched
97capture01a1ac00-7b3b-7618-b1d1-80ab00f414fa€49.00€0.67matched
98capture01a1ac00-8e03-7506-81d8-d8c41aa9a0dc€15.00€0.26matched
99capture01a1ac00-97ca-7d74-b21b-6d81c23ff7d9€24.00€0.37matched
100capture01a1ac00-b31f-7a6b-b00d-c5bf7e5e59b9€49.00€0.67matched
101capture01a1ac00-bbef-78fd-b8e0-97c19871634a€9.00€0.19matched
102capture01a1ac00-c1e9-7e13-9db8-a1dfdee90490€35.00€0.50matched
103capture01a1ac00-dd77-78a6-8475-65dc9791d2bf€49.00€0.67matched
104refund01a1ac00-e950-72da-adf8-637b218b7e71-€28.00€0.00matched
105refund01a1ac00-ea60-74da-8bc2-697fdf3ae019-€7.00€0.00matched
106refund01a1ac01-0957-7402-8389-72bebbde3681-€10.00€0.00matched
107capture01a1ac01-1b3e-705d-b130-ed6fe7de8e51€49.00€0.67matched
108capture01a1ac01-296a-7c84-9186-f16e755ca2ed€35.00€0.50matched
109capture01a1ac01-34f6-7b89-b343-31f47eeafca7€15.00€0.26matched
110capture01a1ac01-42eb-7874-ae19-adc0930d7e54€35.00€0.50matched
111capture01a1ac01-6074-7900-a9af-412eb5cca59c€9.00€0.19matched
112capture01a1ac01-6dc0-7a02-8acd-8e690824e378€24.00€0.37matched
113capture01a1ac01-7ead-7d3b-962b-8d20eff2a908€9.00€0.19matched
114capture01a1ac01-8d6a-77e7-85c3-bb9eb88c40a5€15.00€0.26matched
115capture01a1ac01-9084-76f8-90db-847dd0e9818b€49.00€0.67matched
116capture01a1ac01-9deb-7809-96cc-3271183e0deb€15.00€0.26matched
117capture01a1ac01-b27f-7d76-a5c4-a66daac717ec€35.00€0.50matched
118capture01a1ac01-e9c1-7f5d-bdd3-d3b4ae79dc50€9.00€0.19matched
119capture01a1ac02-09b4-70c4-b518-4b4b51989a75€49.00€0.67matched
120capture01a1ac02-21c7-77d9-9c2b-f192c5a673aa€35.00€0.50matched
121capture01a1ac02-3247-7558-bcd8-cdb20ca1d905€9.00€0.19matched
122capture01a1ac02-33d0-77e9-a80c-d223d728d190€24.00€0.37matched