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:10

Gross

€3,313.00

PSP fee

€53.22

Net to the bank

€3,259.78

Settlement journal

#398143

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 53, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 71, the contract says 67
  • missing linein the books, not in the filerefund:01a1abdb-ec06-7228-b431-eab221cc5bb2 is in no file
LineKindReferenceGrossFeeStatus
78capture01a1abd9-8c66-767a-952a-d2d5a82e85c3€35.00€0.53fee difference
121capture01a1abdc-152f-75a6-9be1-02248950542f€49.00€0.71fee difference
1capture01a1abcd-cf8d-7ff5-8c51-9f44238cc902€49.00€0.67matched
2capture01a1abd1-1464-7a85-9697-8093449503d1€24.00€0.37matched
3capture01a1abd3-c623-70f4-bc0c-cc7d8299fbb0€9.00€0.19matched
4capture01a1abd4-b86c-7f2b-8cae-fd6d598297e8€49.00€0.67matched
5capture01a1abd4-b915-7864-aa83-2411d5a57e13€9.00€0.19matched
6capture01a1abd4-bcd6-73a7-a0aa-73548b8eaa9d€9.00€0.19matched
7capture01a1abd4-e38e-7285-9395-c4bb2d093552€9.00€0.19matched
8capture01a1abd5-0247-74c4-a416-de2abd5b8a71€49.00€0.67matched
9capture01a1abd5-0c03-73b9-bf57-b7fef3d8ed96€15.00€0.26matched
10capture01a1abd5-0d84-7352-ba60-5756a47440d8€24.00€0.37matched
11capture01a1abd5-18f4-7533-8caf-376c0f1a293f€9.00€0.19matched
12capture01a1abd5-391b-77ff-9606-13e73687ac1c€35.00€0.50matched
13capture01a1abd5-4926-7e1f-9cdf-cb4f785e062c€35.00€0.50matched
14capture01a1abd5-6d57-7b84-8ffe-a4ce56d450fc€24.00€0.37matched
15capture01a1abd5-7a70-7d56-935a-1a810cfb88dd€9.00€0.19matched
16capture01a1abd5-8d4e-775f-8eef-78f941daced8€24.00€0.37matched
17capture01a1abd5-b40d-78b8-b11a-4de8a2cbfb44€49.00€0.67matched
18capture01a1abd5-c71e-73d7-b4fe-69cdb980e239€15.00€0.26matched
19refund01a1abd5-e294-7e24-9625-b53f63dffd55-€4.00€0.00matched
20capture01a1abd6-005d-79b8-ae52-ce5e050b09d2€15.00€0.26matched
21capture01a1abd6-1bb3-77c3-9c43-ad98865d5b03€15.00€0.26matched
22capture01a1abd6-1f1c-78a1-ac30-3892107f1872€24.00€0.37matched
23capture01a1abd6-3138-74d2-ba8c-c639305f40da€35.00€0.50matched
24refund01a1abd6-36a5-7b8c-97c4-6faaa377bf47-€11.00€0.00matched
25capture01a1abd6-35e9-7fb4-8bef-dd3c789d5fdc€9.00€0.19matched
26capture01a1abd6-5eb5-711b-99e8-c31375050ea7€24.00€0.37matched
27capture01a1abd6-7298-7b5e-90d5-084fb8404d7b€49.00€0.67matched
28capture01a1abd6-9a5b-7c5b-b0fe-d22af14500f3€24.00€0.37matched
29capture01a1abd6-9e0b-7c3d-abaa-750cb54b0af5€49.00€0.67matched
30capture01a1abd6-a119-789d-8753-6cf0b15cc7a9€15.00€0.26matched
31capture01a1abd6-b50e-71ef-829b-59069ca83241€15.00€0.26matched
32capture01a1abd6-b85b-78df-9244-c186e5cd8385€49.00€0.67matched
33capture01a1abd6-bf0e-7002-ab49-eb0296fe45fb€35.00€0.50matched
34capture01a1abd6-c044-782c-875e-b5cfc77f0962€15.00€0.26matched
35capture01a1abd6-c385-70fc-8c73-61d6b84804ea€24.00€0.37matched
36capture01a1abd6-d087-7107-a36d-2511d96515ec€24.00€0.37matched
37capture01a1abd6-dc87-77e1-a26a-62ce55bc10ae€49.00€0.67matched
38capture01a1abd6-e5ed-7221-91ec-51193616d382€35.00€0.50matched
39capture01a1abd6-e885-77ab-8c16-7144a604078e€24.00€0.37matched
40capture01a1abd6-f443-7f83-be5f-be32ac674694€35.00€0.50matched
41capture01a1abd6-f6b2-7717-a23a-55659eb8c224€15.00€0.26matched
42capture01a1abd7-14d4-7ebf-b6e7-6d338d096db1€35.00€0.50matched
43capture01a1abd7-2ca4-7e7b-be3e-ad875718016d€49.00€0.67matched
44refund01a1abd7-4670-7868-9381-4ee09b835e3d-€28.00€0.00matched
45capture01a1abd7-5aa2-7f7d-b8d8-a1fa996b4881€9.00€0.19matched
46capture01a1abd7-5b2b-71e2-8de0-495d694448f6€49.00€0.67matched
47capture01a1abd7-648c-7f67-8d57-55ed94bd157d€24.00€0.37matched
48capture01a1abd7-6df2-79ee-98fe-4f2ce54f0006€35.00€0.50matched
49capture01a1abd7-775c-7330-a205-855bebb9765f€24.00€0.37matched
50capture01a1abd7-7e9f-7a34-b38b-32928bcd2cce€35.00€0.50matched
51capture01a1abd7-88f8-7f52-8970-3904ac6e9f88€35.00€0.50matched
52capture01a1abd7-89cf-7cda-82c5-a6f020f63fa8€35.00€0.50matched
53capture01a1abd7-8b91-7fa9-9e10-cb319f62c3ca€15.00€0.26matched
54capture01a1abd7-a1bc-7ee6-9391-6f8e42199a50€24.00€0.37matched
55capture01a1abd7-b124-7556-b940-6cb2a19ea78b€24.00€0.37matched
56capture01a1abd7-b517-74bd-87f8-9581ae04a595€24.00€0.37matched
57capture01a1abd7-c6e1-7fcb-9689-212697c87c8f€9.00€0.19matched
58capture01a1abd7-d252-72f5-83d9-9062285ff56c€24.00€0.37matched
59capture01a1abd7-e793-72e2-a894-91f5906dba87€24.00€0.37matched
60refund01a1abd7-ee5e-7a6c-93ea-6ce2b7426cee-€16.00€0.00matched
61refund01a1abd7-f64c-7451-9dd6-d0aad0f0d5ba-€24.00€0.00matched
62capture01a1abd8-0953-714d-91b3-0cdd933b2816€49.00€0.67matched
63refund01a1abd8-16cf-719f-bd21-50fda207215a-€19.00€0.00matched
64capture01a1abd8-35cb-7e94-ae5e-3935af4c76a2€15.00€0.26matched
65capture01a1abd8-3c25-70bd-8664-99d2468d3c99€15.00€0.26matched
66capture01a1abd8-630d-7ed3-b3c9-0404abf9d1f1€49.00€0.67matched
67capture01a1abd8-7ec5-7b5a-af0a-491c8b632cb5€35.00€0.50matched
68capture01a1abd8-901d-76df-af0e-af15471d351b€35.00€0.50matched
69capture01a1abd8-9a24-7b9a-8bf6-f86f2d751ae9€49.00€0.67matched
70refund01a1abd8-abf8-74e4-a25e-fefeff560fb6-€25.00€0.00matched
71capture01a1abd8-c5e6-7e8a-8c8f-e52f5167f8af€9.00€0.19matched
72capture01a1abd8-cf4d-7d5f-80e8-ffe1136ef4ac€9.00€0.19matched
73capture01a1abd8-ed45-78a4-8476-2f9579830d6e€35.00€0.50matched
74capture01a1abd9-10dd-72e0-b798-e8262bb5f256€35.00€0.50matched
75capture01a1abd9-295d-74d0-9df1-a52dde396158€24.00€0.37matched
76capture01a1abd9-3adb-7782-bf8d-20e408d12cec€49.00€0.67matched
77capture01a1abd9-52cf-7cff-ad8c-2b5d4e156067€35.00€0.50matched
79capture01a1abd9-957f-7068-8b11-84b127cea0cf€9.00€0.19matched
80capture01a1abd9-97b7-754e-9664-94e12a398726€15.00€0.26matched
81capture01a1abd9-bb74-7e7d-8ade-8e1bedb2f8b1€35.00€0.50matched
82capture01a1abd9-c8a1-763f-921f-539757918d69€15.00€0.26matched
83capture01a1abd9-e1dd-777b-9ead-8e4b85d3bb4e€15.00€0.26matched
84refund01a1abd9-f10d-7b49-8378-05f1c56e41cf-€10.00€0.00matched
85capture01a1abda-13f3-79d6-915e-4605e949e79e€35.00€0.50matched
86capture01a1abda-16e8-7e94-b5de-1aa375e38d70€35.00€0.50matched
87capture01a1abda-33b4-7523-b2d2-761417cf7232€24.00€0.37matched
88capture01a1abda-3a9e-7310-9bb8-d067ad3dd731€24.00€0.37matched
89capture01a1abda-3ae6-7cd7-9370-a49686522bfd€15.00€0.26matched
90capture01a1abda-57ce-7ff9-aa74-68364927a067€15.00€0.26matched
91capture01a1abda-7e97-748b-8d5b-b0f6e825f889€9.00€0.19matched
92capture01a1abda-a44d-728a-8fdd-b621952e4661€35.00€0.50matched
93refund01a1abda-abad-795b-b820-6c06dc378930-€4.00€0.00matched
94capture01a1abda-aeff-7579-9623-8d754acafa01€24.00€0.37matched
95capture01a1abda-bf1a-72dc-bec3-06afacc0ad06€35.00€0.50matched
96capture01a1abda-cbc1-769b-981b-163c8cbf6d4c€24.00€0.37matched
97capture01a1abda-ed6f-7605-92f1-01ac21fcca64€24.00€0.37matched
98capture01a1abdb-0122-7314-aa2c-92446cfd1446€24.00€0.37matched
99capture01a1abdb-027d-767f-b570-47e51ec5605d€49.00€0.67matched
100capture01a1abdb-0ea0-7678-b5b1-53624b0256ad€49.00€0.67matched
101capture01a1abdb-11d5-7158-85b3-2465d1407357€35.00€0.50matched
102capture01a1abdb-18ff-70c2-b250-6e1e060ef7f0€9.00€0.19matched
103capture01a1abdb-4489-7178-b565-39dc96415c34€9.00€0.19matched
104capture01a1abdb-450f-70a1-8b45-1914a0b68234€24.00€0.37matched
105refund01a1abdb-4e39-79c2-b555-221961b58dd6-€37.00€0.00matched
106capture01a1abdb-65f0-7c39-b566-f731838c3620€49.00€0.67matched
107capture01a1abdb-7b56-76b6-830b-90e998ec119a€49.00€0.67matched
108capture01a1abdb-8194-77d7-a168-90b3eb1d1ab3€24.00€0.37matched
109capture01a1abdb-983f-7d6c-9d68-7f54e7d98bef€35.00€0.50matched
110capture01a1abdb-9c6e-758b-bfa5-aaa9fe2f6487€9.00€0.19matched
111capture01a1abdb-a419-7dfd-bd9e-05c0db303ebb€24.00€0.37matched
112capture01a1abdb-aaf4-7500-8302-4de647415414€9.00€0.19matched
113capture01a1abdb-b65c-71d3-ba02-8cd67ea4e25b€35.00€0.50matched
114capture01a1abdb-b9b8-73b2-9c4e-87278e857e56€9.00€0.19matched
115capture01a1abdb-c226-704a-95f2-8a3e7b542e4a€24.00€0.37matched
116capture01a1abdb-d2b2-73fd-939a-e6a373c4949d€49.00€0.67matched
117capture01a1abdb-d683-7f1f-b13e-4d316f2cdf7e€24.00€0.37matched
118capture01a1abdb-ebc8-716f-9654-319d32a18cca€9.00€0.19matched
119capture01a1abdb-ef2d-72c4-b3b0-b3116459aa20€24.00€0.37matched
120capture01a1abdc-1115-7166-8385-f9dfbc4fe8b2€49.00€0.67matched
122capture01a1abdc-28c8-745b-b1fe-7b786f3d06a4€24.00€0.37matched
123capture01a1abdc-3f68-7153-9722-59eea1905013€24.00€0.37matched
124refund01a1abdc-45d2-7032-8214-85648891caa3-€22.00€0.00matched
125capture01a1abdc-72df-7945-b3fe-1e18abf41bf2€9.00€0.19matched
126refund01a1abdc-7d5d-7104-8a55-4907bca4413a-€14.00€0.00matched
127capture01a1abdc-a0ab-7b9f-aaa7-dfc10c826b5d€24.00€0.37matched
128capture01a1abdc-a799-72b9-8d94-1d1e02ef1470€35.00€0.50matched
129capture01a1abdc-a9ab-7287-9d65-07694a0e55ad€15.00€0.26matched
130capture01a1abdc-bc4b-76e6-a562-891b0b0fd3b2€35.00€0.50matched
131capture01a1abdc-c4b2-728b-8bba-002e954733e1€49.00€0.67matched
132capture01a1abdc-dd46-77d7-8cb3-378705c71fa3€49.00€0.67matched
133capture01a1abdc-e101-79fa-a4b6-d9356919ae5d€15.00€0.26matched
134capture01a1abdd-014f-7389-8c0d-19223db4f0cd€15.00€0.26matched
135capture01a1abdd-4163-71ef-96bf-7a8817291859€24.00€0.37matched
136capture01a1abdd-4397-726c-bcfd-b2729fe88112€15.00€0.26matched
137refund01a1abdd-4385-729d-bd40-ecd14d86874c-€9.00€0.00matched
138refund01a1abdd-4936-799a-95eb-4060dd6eb370-€6.00€0.00matched
139refund01a1abdd-740a-7164-b508-5130286ec611-€7.00€0.00matched
140capture01a1abdd-7a34-735b-ae13-caddacbfb029€49.00€0.67matched
141capture01a1abdd-7975-7a03-9919-cbf4e8b1082a€49.00€0.67matched
142capture01a1abdd-80c9-7aa8-b076-562897778ddd€24.00€0.37matched
143capture01a1abdd-8c35-7643-a797-40ba0da8ef69€35.00€0.50matched
144capture01a1abdd-a006-758d-a1a0-3a96c6bde361€15.00€0.26matched
145capture01a1abdd-bd6e-7dc8-95ef-467230f4046a€9.00€0.19matched