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, 17:00

Gross

€3,285.00

PSP fee

€52.33

Net to the bank

€3,232.67

Settlement journal

#364557

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 41, the contract says 37
  • missing linein the books, not in the filecapture:01a1a263-0e67-7846-b03c-41be41c382dc is in no file
LineKindReferenceGrossFeeStatus
6capture01a1a257-f461-705a-8ea0-6338357b068f€15.00€0.26duplicate line
17capture01a1a25b-30b3-7a1c-b5d2-4d8afece6dbc€24.00€0.41fee difference
1capture01a1a251-dead-79b4-9f7d-b69603ffbbd3€49.00€0.67matched
2capture01a1a253-2582-773b-895b-4a20a90dc064€15.00€0.26matched
3capture01a1a255-0a80-7329-bd90-1224155fe189€35.00€0.50matched
4capture01a1a257-387b-76ff-b0b6-92da4a1ef394€24.00€0.37matched
5capture01a1a257-f461-705a-8ea0-6338357b068f€15.00€0.26matched
7capture01a1a259-ce06-7de9-b953-2bf2555039ea€9.00€0.19matched
8capture01a1a25a-ab3e-775b-973f-6da18be31fce€9.00€0.19matched
9capture01a1a25a-b373-7eb8-83b3-4a50fab64a12€9.00€0.19matched
10refund01a1a25a-b461-749c-9512-7cdaf9aae577-€47.00€0.00matched
11capture01a1a25a-bed2-7d9a-8625-632cd24ec793€15.00€0.26matched
12capture01a1a25a-c2df-7d35-b325-1626df26884c€9.00€0.19matched
13capture01a1a25a-eb02-73ce-adfe-ed2c16fbbd3b€24.00€0.37matched
14capture01a1a25a-f470-7ce3-87b2-54d813b61d38€9.00€0.19matched
15capture01a1a25a-f5e2-7b8a-b0c7-044bd7dffb86€15.00€0.26matched
16capture01a1a25b-05f4-72d4-a2e2-dedc8e844dc5€49.00€0.67matched
18capture01a1a25b-378b-79b6-8c2d-dc4472d8333f€24.00€0.37matched
19capture01a1a25b-4fd8-76b7-b741-83b6c16450e9€49.00€0.67matched
20capture01a1a25b-5553-7fe4-a862-eed5f05dec96€35.00€0.50matched
21capture01a1a25b-5656-7b96-9809-355606f32794€9.00€0.19matched
22capture01a1a25b-84c7-7700-b54a-15034356ccb8€15.00€0.26matched
23capture01a1a25b-ab42-7301-be23-d6968bad0545€49.00€0.67matched
24capture01a1a25b-dd1d-7b7f-8f52-4eca13b20293€9.00€0.19matched
25capture01a1a25b-e3c1-7673-9a3e-e6da97f4f0a4€35.00€0.50matched
26capture01a1a25b-e56b-7a0c-b4bb-c6bb1d7a254b€24.00€0.37matched
27refund01a1a25b-e8f0-7824-9b7f-b634651c12c9-€4.00€0.00matched
28capture01a1a25c-29d8-7419-99c1-b4f7c2f5b678€15.00€0.26matched
29capture01a1a25c-422d-7f73-8039-b903155397ba€49.00€0.67matched
30capture01a1a25c-4437-7852-94b7-35a14e23b125€35.00€0.50matched
31capture01a1a25c-46e1-7e0d-87b8-c041521e9c0c€35.00€0.50matched
32capture01a1a25c-62ea-7975-861f-ff19828adec7€49.00€0.67matched
33capture01a1a25c-70e5-7fb1-9961-be1fb82fb0a4€35.00€0.50matched
34capture01a1a25c-9085-7f69-8f16-f92fd166e383€35.00€0.50matched
35capture01a1a25c-b471-7405-b10f-1d89338ec052€35.00€0.50matched
36capture01a1a25c-ba06-74a5-a389-6c7c53f61eb1€9.00€0.19matched
37capture01a1a25c-db78-7a22-a28b-c40b4fff1a31€9.00€0.19matched
38capture01a1a25c-dc39-71f2-a583-e717de1378a3€49.00€0.67matched
39capture01a1a25c-ef91-7323-8911-6180c3e9f365€35.00€0.50matched
40capture01a1a25c-f252-7443-98f0-a609464310fa€35.00€0.50matched
41capture01a1a25c-f4da-7507-bedf-6f9a819a1b33€24.00€0.37matched
42capture01a1a25c-fa97-7193-8710-4aa339008fa1€24.00€0.37matched
43capture01a1a25d-0250-7e14-9b8f-056b3d2c8b3e€15.00€0.26matched
44capture01a1a25d-0b21-714d-a819-d9e908a0b58c€49.00€0.67matched
45capture01a1a25d-13f3-7ff6-ab49-925b18ec86a1€35.00€0.50matched
46refund01a1a25d-1be5-7a75-a1df-dd1d3c0c05f1-€24.00€0.00matched
47capture01a1a25d-2ca2-765a-a279-4e48dde903d3€24.00€0.37matched
48capture01a1a25d-2ced-7ede-b77b-df3ad3f8fd64€35.00€0.50matched
49capture01a1a25d-35cc-76a2-b152-5a69db2008fb€35.00€0.50matched
50capture01a1a25d-3de0-7625-bd3d-5bd3bb886241€15.00€0.26matched
51capture01a1a25d-413a-7087-8c4a-dc77038811f4€24.00€0.37matched
52refund01a1a25d-47ba-7840-aa17-44973cfe679e-€8.00€0.00matched
53capture01a1a25d-5520-7300-a75a-6ec75a39d8ab€35.00€0.50matched
54capture01a1a25d-5b34-72bf-91c7-642e7190efc9€24.00€0.37matched
55capture01a1a25d-6182-7d23-8539-fe93d3cf7b92€35.00€0.50matched
56capture01a1a25d-6af2-7074-8877-e50547435207€24.00€0.37matched
57refund01a1a25d-8237-7035-a1bd-20823a892416-€18.00€0.00matched
58capture01a1a25d-8331-78ff-81c8-7debfc32faeb€24.00€0.37matched
59capture01a1a25d-9c24-7885-b699-a53b37e43f08€49.00€0.67matched
60capture01a1a25d-a570-77ee-ab50-b2469a582ba2€15.00€0.26matched
61capture01a1a25d-a6d1-78c9-a6cc-968e4b3264c9€9.00€0.19matched
62capture01a1a25d-bdd8-78ab-b8bb-217c98086b37€15.00€0.26matched
63capture01a1a25d-cdf7-7837-96d9-1995f8f5c1d8€9.00€0.19matched
64capture01a1a25d-e5b0-7827-98e7-877ceb0f84f5€49.00€0.67matched
65capture01a1a25d-f6db-7a27-a78f-94ef8bd3c8c2€35.00€0.50matched
66capture01a1a25d-f86c-74a6-bc56-eff24e9accc7€49.00€0.67matched
67capture01a1a25e-1f99-7187-b3de-42344349e158€15.00€0.26matched
68refund01a1a25e-3bdd-7eb8-b10a-1a5495645f40-€23.00€0.00matched
69capture01a1a25e-4d6a-7d66-a252-e9d478fb93fc€15.00€0.26matched
70capture01a1a25e-4d9a-7048-881a-7c77ae1525f7€9.00€0.19matched
71capture01a1a25e-7f59-7e02-bc97-56cc2f4a0bd3€35.00€0.50matched
72capture01a1a25e-b212-7981-bf20-0b82c5020caf€15.00€0.26matched
73refund01a1a25e-c4ef-726d-bf2b-7163fdab7f70-€17.00€0.00matched
74capture01a1a25e-d08a-7df3-b57a-35012570c8c5€49.00€0.67matched
75capture01a1a25e-d68c-76a8-8eed-b5bebb71e1bd€15.00€0.26matched
76capture01a1a25e-dcee-793c-836d-32eb932a08c3€15.00€0.26matched
77capture01a1a25e-f3b9-7a7c-b5bd-080f61425513€9.00€0.19matched
78capture01a1a25e-f736-7182-9e92-6234288b5edd€24.00€0.37matched
79capture01a1a25f-0524-7371-8f74-ad5b315ae338€15.00€0.26matched
80capture01a1a25f-09b6-7c4e-b5a5-b875143aefa9€15.00€0.26matched
81capture01a1a25f-1068-7555-8a04-40ef0fe951fc€9.00€0.19matched
82capture01a1a25f-12fa-71ef-be2d-47c86ad442d1€9.00€0.19matched
83capture01a1a25f-1a15-79c1-af24-2fa9dc92daa5€35.00€0.50matched
84capture01a1a25f-2e6a-76a9-9833-1bb589cce444€24.00€0.37matched
85capture01a1a25f-4883-750a-bb0f-30e846ce7b6f€49.00€0.67matched
86capture01a1a25f-8c16-7a8c-977b-faa7b1768540€49.00€0.67matched
87capture01a1a25f-8e8c-780e-b078-abed45e154a6€49.00€0.67matched
88capture01a1a25f-ac67-7d5b-abc0-9fb9bc135db7€9.00€0.19matched
89capture01a1a25f-b7fb-7de8-9802-c59cfb5487ee€24.00€0.37matched
90capture01a1a25f-b9f1-7cb1-b748-79c1895149aa€15.00€0.26matched
91capture01a1a25f-c79f-764b-b98f-7962b43140a4€9.00€0.19matched
92capture01a1a25f-d1b5-7fcf-8388-eca6d4e705fc€9.00€0.19matched
93refund01a1a25f-d8a3-7965-9eca-91e6537c2213-€7.00€0.00matched
94capture01a1a25f-e121-7035-989a-5a23a6e2a401€35.00€0.50matched
95capture01a1a25f-e878-7563-a6c1-c2141ceb1a92€15.00€0.26matched
96capture01a1a260-1283-7109-89b1-7013b503826c€35.00€0.50matched
97capture01a1a260-15f2-71ee-8ac3-fd4d16bb8d38€9.00€0.19matched
98refund01a1a260-1f25-7f55-aec3-12a6ab3a837a-€7.00€0.00matched
99capture01a1a260-55c4-7044-a637-98deb2993eb8€24.00€0.37matched
100capture01a1a260-6f37-7c6b-92b9-2014238b8533€24.00€0.37matched
101capture01a1a260-7567-72ea-b8b3-9decbafcc920€35.00€0.50matched
102capture01a1a260-7a9b-7188-bd45-ddc86ebe5ebd€9.00€0.19matched
103capture01a1a260-7e30-71da-9de2-af12caa9ed44€35.00€0.50matched
104capture01a1a260-891c-78a0-8956-3dea23182c4f€49.00€0.67matched
105capture01a1a260-b0e9-713d-8474-5a782eabce59€35.00€0.50matched
106capture01a1a260-b6de-7ab1-b144-02a694f907c5€9.00€0.19matched
107capture01a1a260-d90d-722a-8d0e-857ae7525b95€35.00€0.50matched
108capture01a1a260-e23e-740e-8a1d-f694b0fbe168€24.00€0.37matched
109capture01a1a260-fc97-7772-b592-963b68d34bdb€35.00€0.50matched
110capture01a1a261-0a4a-76ee-a0e4-c444287ff3c9€9.00€0.19matched
111capture01a1a261-3f4d-7803-bdcc-7a6602c045be€24.00€0.37matched
112capture01a1a261-40a7-7a83-ba12-9cfe90307d59€24.00€0.37matched
113capture01a1a261-4a4d-7cd4-bc74-afb4c354cd07€35.00€0.50matched
114capture01a1a261-4d58-716b-bf45-734fe8d9e7fc€9.00€0.19matched
115capture01a1a261-7c41-7222-908f-6e473b647390€35.00€0.50matched
116capture01a1a261-8b8c-76d8-b3a1-487885d8f59c€9.00€0.19matched
117capture01a1a261-bfc9-7bb4-9649-e0c7ec18bf8a€24.00€0.37matched
118capture01a1a261-c37c-7fc7-b15b-c33ddb5bbf90€9.00€0.19matched
119capture01a1a261-c66e-797e-a034-6e05d0cba249€15.00€0.26matched
120capture01a1a261-cf17-7384-9622-207cb152f68d€49.00€0.67matched
121capture01a1a261-f9de-7719-94e5-a4774908bedc€24.00€0.37matched
122capture01a1a262-04d8-78f2-9bf3-190b9490586a€35.00€0.50matched
123capture01a1a262-1c4a-7a4d-a9e0-3e8f7293e39f€49.00€0.67matched
124refund01a1a262-3844-737c-aef7-257d0e982584-€4.00€0.00matched
125capture01a1a262-3988-7cc7-9306-585b7a6e933b€9.00€0.19matched
126refund01a1a262-5fa3-7d35-901f-ed0bad9193b1-€14.00€0.00matched
127capture01a1a262-614a-7ef0-9ce0-1cfe9f3f31f1€24.00€0.37matched
128capture01a1a262-6c17-7046-80d0-74e6653cbcd2€15.00€0.26matched
129capture01a1a262-8386-7733-acf2-8845a7ed4eb9€49.00€0.67matched
130capture01a1a262-c8f4-7c50-8eb1-129f9cf7e282€24.00€0.37matched
131capture01a1a262-dbc5-7fc9-b005-cd6c6fd631de€35.00€0.50matched
132capture01a1a262-e058-75de-b3d0-0ff0a5fb5a62€35.00€0.50matched
133capture01a1a262-e8ec-7807-8df3-1be29b767d22€49.00€0.67matched
134capture01a1a262-ec3b-7fb1-a0cc-e5dc33fec61b€35.00€0.50matched
135capture01a1a263-08c1-73c2-be17-f66a53d3b93d€49.00€0.67matched
136capture01a1a263-0d42-704a-a49f-e4c0c6cbba96€9.00€0.19matched
137capture01a1a263-43ac-74d1-a5de-c6ecb8fe6c89€49.00€0.67matched
138capture01a1a263-4630-71de-8d45-a93bd3331418€35.00€0.50matched
139capture01a1a263-6635-729d-98ea-a4772849150a€15.00€0.26matched
140capture01a1a263-6bab-75ae-9163-c8f18b5dc9c4€24.00€0.37matched
141capture01a1a263-8ff5-7506-b93b-b648bae2ddbc€24.00€0.37matched
142capture01a1a263-923a-791a-abb5-ef4ec79044cc€9.00€0.19matched
143capture01a1a263-9282-73ff-8505-7478d380b245€24.00€0.37matched
144capture01a1a263-92d6-719c-aaaa-feeb3d7112ea€15.00€0.26matched