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

Gross

€2,234.00

PSP fee

€35.94

Net to the bank

€2,198.06

Settlement journal

#402738

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 39, the contract says 37
  • missing linein the books, not in the filecapture:01a1ad1e-3a6d-71ac-beeb-780b0f803f12 is in no file
  • missing linein the books, not in the filecapture:01a1ad20-6cff-7841-b1dc-8f7c87143c81 is in no file
LineKindReferenceGrossFeeStatus
10capture01a1ad1e-ed16-7ba3-9c38-7c03c8cc2d23€24.00€0.39fee difference
1capture01a1ad17-1c00-760d-bef2-0e7fd1495151€24.00€0.37matched
2refund01a1ad1b-4617-7e4e-a550-f7cdd6981c98-€21.00€0.00matched
3refund01a1ad1e-4570-7d38-bedd-0b3a24936fba-€4.00€0.00matched
4capture01a1ad1e-46a4-71a9-98fc-fdf43b1e2802€9.00€0.19matched
5refund01a1ad1e-5072-7c42-b752-00fc48746ac2-€11.00€0.00matched
6capture01a1ad1e-65e8-7f0f-b3cc-b3d1d4141bfb€24.00€0.37matched
7capture01a1ad1e-849c-7439-898d-bdada86cc6f5€24.00€0.37matched
8refund01a1ad1e-b021-7d04-a18f-ea13f84b9578-€2.00€0.00matched
9capture01a1ad1e-d6b3-71e4-b6c8-5b614d3b989e€15.00€0.26matched
11capture01a1ad1e-f595-771e-8151-77d3e21f4e0f€24.00€0.37matched
12capture01a1ad1f-2292-7e0c-9726-812a699b48c0€15.00€0.26matched
13capture01a1ad1f-3a61-7787-945a-b0f220b9a4f8€24.00€0.37matched
14capture01a1ad1f-5652-75e0-8fb1-74f6668d977c€49.00€0.67matched
15capture01a1ad1f-57c4-774f-9cc8-d70e3b9afa6f€49.00€0.67matched
16capture01a1ad1f-800f-70f3-90de-513eb564c84d€35.00€0.50matched
17capture01a1ad1f-9c09-7a38-a198-30594020dc8a€35.00€0.50matched
18capture01a1ad1f-be3c-7cf9-b143-109f72a01ccc€15.00€0.26matched
19capture01a1ad1f-c6eb-7e14-80cc-f849ebb9cf9c€15.00€0.26matched
20capture01a1ad1f-d3db-7f04-a938-c71991005da4€9.00€0.19matched
21capture01a1ad1f-d936-7ba5-9385-4cba9518448b€9.00€0.19matched
22capture01a1ad1f-e868-7971-a188-a718513a6129€9.00€0.19matched
23capture01a1ad1f-f539-79b4-be18-96ec999ae8e1€15.00€0.26matched
24capture01a1ad20-1c1f-7028-8ad7-1aee1f13ba33€49.00€0.67matched
25capture01a1ad20-2051-7fa7-8b8e-10431f6d02f2€9.00€0.19matched
26capture01a1ad20-2b4a-7015-beb5-e7bb8ec54f49€49.00€0.67matched
27capture01a1ad20-5f3f-7309-93db-064b8def77f6€15.00€0.26matched
28capture01a1ad20-714c-76d5-8954-7e85d8315808€15.00€0.26matched
29capture01a1ad20-73be-7e74-aa5a-a0e573489a10€24.00€0.37matched
30capture01a1ad20-bf02-77ec-80a4-6fbd30734110€24.00€0.37matched
31capture01a1ad20-c613-7a8b-92a8-28c533d1c2b5€35.00€0.50matched
32capture01a1ad20-c9e1-74a5-b3ce-e5bc2533d8a7€49.00€0.67matched
33capture01a1ad20-f3d2-78f0-b971-ad7777fdaa43€24.00€0.37matched
34capture01a1ad21-0b28-7820-8307-59bb3fe15400€24.00€0.37matched
35capture01a1ad21-18f4-7f67-bad6-e3957be9644f€15.00€0.26matched
36capture01a1ad21-508f-7c76-871d-ddb9e429c35d€15.00€0.26matched
37capture01a1ad21-546b-7ed9-acdb-d33a00577a36€9.00€0.19matched
38capture01a1ad21-5799-70c5-8f6b-3454f5dc87b3€15.00€0.26matched
39capture01a1ad21-9668-7db4-af06-e0acc5189b55€35.00€0.50matched
40capture01a1ad21-bf4d-7300-ad67-397f047377ea€9.00€0.19matched
41capture01a1ad21-ddba-782b-89a3-879f13ce29b0€15.00€0.26matched
42capture01a1ad21-eda8-777a-a93a-6d88879df7c4€15.00€0.26matched
43capture01a1ad22-0c5d-7735-b842-fdf5107eb496€15.00€0.26matched
44refund01a1ad22-170c-75a3-871e-b9438855f09d-€5.00€0.00matched
45capture01a1ad22-252b-7ce2-a5b8-afe6ed2543ce€15.00€0.26matched
46capture01a1ad22-48b4-7309-a1ff-38afff3cc183€49.00€0.67matched
47capture01a1ad22-7e92-74cc-8804-372d0649d563€9.00€0.19matched
48capture01a1ad22-c472-7101-ba5c-075cdc849b06€24.00€0.37matched
49capture01a1ad22-c4af-783a-b829-b815a543f651€49.00€0.67matched
50capture01a1ad22-e290-7d54-a522-ef6828d2f2e4€35.00€0.50matched
51capture01a1ad22-f574-780b-80f8-f5eb951d0f59€24.00€0.37matched
52capture01a1ad22-fecc-7eac-b1e6-7f750ac6cc12€24.00€0.37matched
53capture01a1ad23-187c-715f-b0d3-340857163e2e€35.00€0.50matched
54capture01a1ad23-2ce6-79cc-9281-a864f410f5aa€49.00€0.67matched
55capture01a1ad23-41bd-7d65-ab16-b8cb07797fb1€35.00€0.50matched
56capture01a1ad23-4dea-7a6f-ae7e-49b127c91c9c€24.00€0.37matched
57capture01a1ad23-4e4c-7391-8fde-cdd320d932cc€24.00€0.37matched
58capture01a1ad23-5acd-7a9a-82f0-79b38c5224f4€15.00€0.26matched
59capture01a1ad23-6ee2-7d25-8be3-aef7c1bbf260€35.00€0.50matched
60capture01a1ad23-86e9-7518-9d26-fd5debbe5c22€15.00€0.26matched
61capture01a1ad23-89d0-757a-8e8f-c2178c3eafcd€9.00€0.19matched
62capture01a1ad23-8c80-7c56-b89a-e174d2510abe€35.00€0.50matched
63capture01a1ad23-a92e-7b51-a895-7a82e6138aa8€24.00€0.37matched
64capture01a1ad23-ac37-7e5f-8d52-de5ccf7b8ea1€9.00€0.19matched
65capture01a1ad23-c806-7855-b78a-b4ff65e56c73€24.00€0.37matched
66capture01a1ad23-cbfa-7984-b6e3-5fcb2e20d1e9€9.00€0.19matched
67refund01a1ad23-d76d-760b-bf13-dbe9100401d8-€30.00€0.00matched
68capture01a1ad23-d7b2-7793-971b-51b79165fafb€24.00€0.37matched
69refund01a1ad23-e193-7ef9-88f2-7558a8d62771-€16.00€0.00matched
70capture01a1ad24-1bad-7e53-8d19-f87fec83a507€35.00€0.50matched
71capture01a1ad24-1ea6-71b5-96d4-18f0973e3bde€24.00€0.37matched
72capture01a1ad24-2ea5-70dd-8cc9-86fca434a074€35.00€0.50matched
73capture01a1ad24-8fa0-7642-9038-7209f1f3d4c5€15.00€0.26matched
74capture01a1ad24-961d-7651-ab02-26da76135969€24.00€0.37matched
75capture01a1ad24-b7b8-7e8f-84cf-2ab44866f693€24.00€0.37matched
76capture01a1ad24-cd20-724f-9ace-9aaa4459cd42€35.00€0.50matched
77capture01a1ad24-d427-772d-afba-4b3272fd3da9€9.00€0.19matched
78capture01a1ad24-eb90-7893-bb8c-69a4b80d3753€35.00€0.50matched
79capture01a1ad24-fc3a-76e8-a7ec-96e25bd64406€9.00€0.19matched
80refund01a1ad25-0e0d-7975-b54f-41a3636ac34d-€6.00€0.00matched
81capture01a1ad25-99f4-7670-a4fe-d923ff00ed4b€24.00€0.37matched
82capture01a1ad25-abb7-7401-b865-1831f9cfc412€24.00€0.37matched
83capture01a1ad25-d1d2-736a-b3e7-857212143946€9.00€0.19matched
84capture01a1ad26-00c5-7fa7-81b1-f6b395791e6d€49.00€0.67matched
85capture01a1ad26-0864-7d20-a82f-9fde6d2204b8€35.00€0.50matched
86capture01a1ad26-0c50-7003-b44d-924f6cfc6569€35.00€0.50matched
87capture01a1ad26-1511-7dc2-bdb8-6a0b61f0a349€24.00€0.37matched
88capture01a1ad26-310b-78ee-9307-6b2153b2514d€15.00€0.26matched
89capture01a1ad26-4961-7cd1-9296-4ffd797ced54€24.00€0.37matched
90capture01a1ad26-5fec-7fb9-93ec-88f0a3f0299f€35.00€0.50matched
91capture01a1ad26-65e7-7953-a8df-198ee7ce1fb7€35.00€0.50matched
92capture01a1ad26-65e5-7a9d-8619-6ce894c96052€24.00€0.37matched
93capture01a1ad26-6f7c-7171-bf94-af8020bf2ec3€49.00€0.67matched
94capture01a1ad26-80db-7a2e-b4b1-f2f9ca32e412€9.00€0.19matched
95capture01a1ad26-841b-72db-bcb0-be206af8076b€24.00€0.37matched
96refund01a1ad26-a70b-71f6-a622-7f00b661f23f-€13.00€0.00matched
97capture01a1ad26-b45b-7a41-bbff-39b6f552baae€9.00€0.19matched
98capture01a1ad26-ec42-70df-8e40-ba4cdb973da4€49.00€0.67matched
99capture01a1ad26-eca3-72da-a390-9c2a0461e538€24.00€0.37matched
100capture01a1ad26-eec9-7473-92a8-159a35ac4ef3€35.00€0.50matched
101capture01a1ad26-f347-7dfc-8de9-60023218cb71€15.00€0.26matched
102capture01a1ad26-fc3f-7e43-9695-dab66b4c6e09€9.00€0.19matched
103capture01a1ad27-0261-7151-9ffd-41fc6137d6b7€15.00€0.26matched
104refund01a1ad27-3d28-7b3a-b589-e0c1370269b1-€2.00€0.00matched
105capture01a1ad27-4ffc-7a0b-8180-142bc63ca05d€15.00€0.26matched
106capture01a1ad27-553c-79dc-8e7a-eb95d2ce310c€35.00€0.50matched