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

6 Nov, 09:00

Gross

€3,099.00

PSP fee

€49.05

Net to the bank

€3,049.95

Settlement journal

#413365

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 5, the contract says 0
  • fee differencethe fee is not the contract feethe fee is 53, the contract says 50
LineKindReferenceGrossFeeStatus
20refund01a1b017-3020-71e2-9697-9b1b87187a12-€7.00€0.05fee difference
98capture01a1b01c-79bc-70e2-b0e0-a2c3f4db130c€35.00€0.53fee difference
1capture01a1b012-1f3e-707b-85d4-994619823993€9.00€0.19matched
2capture01a1b016-4927-7508-a097-61d197b58d94€9.00€0.19matched
3capture01a1b016-49eb-77e6-adc6-dd4c43d467aa€24.00€0.37matched
4capture01a1b016-6368-794f-8570-fe4ae349f904€9.00€0.19matched
5capture01a1b016-6400-7da9-8017-fec0350afc04€24.00€0.37matched
6capture01a1b016-65f1-7f15-a3f5-02225a1d2226€49.00€0.67matched
7capture01a1b016-868b-7d44-8ef1-bdc3bf385b03€49.00€0.67matched
8capture01a1b016-8863-72ae-8ccd-be68ce0539bc€9.00€0.19matched
9capture01a1b016-912f-71fb-8c28-3ac0101b27d1€24.00€0.37matched
10capture01a1b016-92f0-7030-a770-31ec11facbe6€24.00€0.37matched
11capture01a1b016-9334-7fc8-ba75-83b91539fd72€24.00€0.37matched
12capture01a1b016-9bfa-76a3-88c8-253e6d407f8c€24.00€0.37matched
13capture01a1b016-a6f3-7e9a-b29c-dfc46021f21b€15.00€0.26matched
14refund01a1b016-bef1-7c42-b1da-3486c145e103-€12.00€0.00matched
15capture01a1b016-c7a9-7a55-ba9a-e69cf41f25f1€15.00€0.26matched
16refund01a1b016-cd53-7dda-a3f0-c9685ea1b0f2-€5.00€0.00matched
17capture01a1b016-dcb5-74ef-8e2a-71735ebfa3fb€35.00€0.50matched
18refund01a1b016-e4b8-7e42-b142-13003e101bdd-€12.00€0.00matched
19capture01a1b016-f479-7c9d-8204-4e5d48909a5f€9.00€0.19matched
21capture01a1b017-4096-7e9f-a2f3-8e93317bc0a0€15.00€0.26matched
22capture01a1b017-8046-7fb4-b4dd-c55c0db7ff93€15.00€0.26matched
23refund01a1b017-80c8-7eae-8138-7c7658df6152-€10.00€0.00matched
24capture01a1b017-8547-7824-a8c7-694f8b2f3979€49.00€0.67matched
25capture01a1b017-8b0b-725a-9e3b-c4af1d3f4d3d€35.00€0.50matched
26capture01a1b017-8c97-7014-a62c-3005481c85e3€35.00€0.50matched
27capture01a1b017-ab4c-785c-886f-cb96b7c28041€49.00€0.67matched
28capture01a1b018-0a0e-7b98-8656-ea8003133688€35.00€0.50matched
29capture01a1b018-0a52-79d7-8268-3764be280576€49.00€0.67matched
30capture01a1b018-1ebd-7d8b-acca-12e9a3fa5fd0€9.00€0.19matched
31capture01a1b018-1fb4-7803-b237-a774f1e52e61€24.00€0.37matched
32capture01a1b018-2412-7245-9c37-8c581b2e5acb€24.00€0.37matched
33capture01a1b018-29ed-7be7-b1a1-ac1d71399a42€35.00€0.50matched
34capture01a1b018-2bba-7cb6-bbbf-dfdb103251f3€49.00€0.67matched
35capture01a1b018-2ced-7e77-a8f3-96c4d833826e€24.00€0.37matched
36capture01a1b018-3843-732d-9587-cf5dfcc36d1a€24.00€0.37matched
37capture01a1b018-4a5e-71c6-9b89-4f40c7d41f80€49.00€0.67matched
38capture01a1b018-52b2-7a89-8dbf-29667f8583ea€9.00€0.19matched
39capture01a1b018-5bb0-7eba-9ced-e98e6c2eb5d8€24.00€0.37matched
40capture01a1b018-6668-79af-b506-119f11333e65€9.00€0.19matched
41capture01a1b018-719d-7b75-919c-c006966fdde0€15.00€0.26matched
42capture01a1b018-7d4a-7dbc-8e74-b26ddd07365a€35.00€0.50matched
43capture01a1b018-a650-7c6a-8920-9d7c674ebbe1€24.00€0.37matched
44capture01a1b018-af5f-7e21-b560-79f3436a65e7€15.00€0.26matched
45capture01a1b018-b139-742b-82e9-7ef4f92e6542€9.00€0.19matched
46capture01a1b018-b5f8-791d-8c7e-dee082accdba€9.00€0.19matched
47capture01a1b018-bfe0-700f-84a7-9d191e279c49€35.00€0.50matched
48capture01a1b018-d2d8-717f-9659-8f85d046099a€35.00€0.50matched
49capture01a1b018-d636-780f-b200-88c042aba041€15.00€0.26matched
50capture01a1b018-ec18-750a-b623-ea3fd4b9b436€49.00€0.67matched
51refund01a1b018-ed6f-7403-9834-e4a4bae82af7-€9.00€0.00matched
52capture01a1b018-e1ae-7e95-a3b6-133bca8bf350€9.00€0.19matched
53capture01a1b018-fa36-77e6-9f41-efd399d11390€35.00€0.50matched
54capture01a1b018-ff67-7b92-9d51-c5da4a48b309€35.00€0.50matched
55capture01a1b019-051e-78bc-9401-969f8ef17a1e€35.00€0.50matched
56capture01a1b019-15a9-70f7-a6cf-907800d2be8a€49.00€0.67matched
57capture01a1b019-208c-76b6-95da-820cce7e4322€15.00€0.26matched
58capture01a1b019-2c79-77a7-9c78-12554aa516a3€24.00€0.37matched
59capture01a1b019-3603-7630-82c8-c29b4a90c6ff€35.00€0.50matched
60capture01a1b019-3a5e-7fdd-a9bd-2ec0ca8ea94d€49.00€0.67matched
61capture01a1b019-76d0-7888-b316-01dd35d8a0a6€49.00€0.67matched
62capture01a1b019-79d7-745d-9186-75ac17440769€24.00€0.37matched
63capture01a1b019-9653-7ec7-aad2-f2602fff2519€9.00€0.19matched
64capture01a1b019-de72-7607-9aa2-62c641c3aff7€35.00€0.50matched
65capture01a1b019-e05b-7ec5-99b4-a404841d3ec2€24.00€0.37matched
66capture01a1b019-fe65-71ac-90f2-4773cc192425€9.00€0.19matched
67capture01a1b01a-0544-72dd-bade-a526443ac295€15.00€0.26matched
68capture01a1b01a-1220-74f6-85e5-176d1abed2bd€24.00€0.37matched
69capture01a1b01a-3711-749e-8f74-b5466427c9c7€24.00€0.37matched
70capture01a1b01a-41c3-774e-94db-bcb75dad6525€9.00€0.19matched
71capture01a1b01a-9f21-774f-ae5b-1475982f84b7€49.00€0.67matched
72refund01a1b01a-aeb4-7a45-876f-ac3faa4e7222-€8.00€0.00matched
73capture01a1b01a-af51-70d1-8ba4-58b5cf1a3f94€24.00€0.37matched
74capture01a1b01a-b995-7b20-98e3-6f056a2374d4€15.00€0.26matched
75capture01a1b01a-cb52-7d52-bde9-3f16172acd30€15.00€0.26matched
76capture01a1b01a-d0ec-7b58-ba06-085b9aa975d0€9.00€0.19matched
77capture01a1b01a-d6c7-7bba-82f5-fa8132f0770c€49.00€0.67matched
78capture01a1b01a-e432-791a-b2fd-5135d8850e2a€24.00€0.37matched
79capture01a1b01a-efc5-75f1-b860-115a42e7765a€9.00€0.19matched
80capture01a1b01a-eff9-77ed-89a9-09200f2a3ae5€49.00€0.67matched
81capture01a1b01b-07c4-758e-b18f-5e925010fe9d€49.00€0.67matched
82capture01a1b01b-1ae0-7cdf-9f1d-625b9340eb2b€35.00€0.50matched
83capture01a1b01b-2c91-7e5c-9415-98e4c22b5eec€49.00€0.67matched
84capture01a1b01b-4ba4-78a7-9af2-21d69de6bd78€24.00€0.37matched
85capture01a1b01b-6694-7441-b867-df6e7b4d7119€9.00€0.19matched
86capture01a1b01b-6851-73d9-a3d7-fe9eeaaa7a19€35.00€0.50matched
87capture01a1b01b-7139-72aa-9d9c-160e7e4d921c€35.00€0.50matched
88capture01a1b01b-75e0-72a1-8e54-4a2fe63f8036€9.00€0.19matched
89capture01a1b01b-8119-7e56-bcb8-dc6e26cdb1b4€9.00€0.19matched
90capture01a1b01b-81d6-73ca-92a2-2921326a18fe€35.00€0.50matched
91capture01a1b01b-8e0c-701f-a866-c687377db2a1€9.00€0.19matched
92capture01a1b01b-8edb-7733-8699-dfdf79fa8e65€15.00€0.26matched
93capture01a1b01b-9801-773c-9cdc-a9b927597525€9.00€0.19matched
94capture01a1b01c-17de-718b-ad06-2b61229c1cd2€49.00€0.67matched
95capture01a1b01c-484c-7127-9a90-a81aa79f1a4f€15.00€0.26matched
96capture01a1b01c-6f17-7eff-9012-11a353e47210€15.00€0.26matched
97capture01a1b01c-7146-778c-acf5-50ef17949170€15.00€0.26matched
99capture01a1b01c-8007-7341-b3e2-19ed777ecdab€49.00€0.67matched
100capture01a1b01c-951f-7c02-a338-dbb407d27700€9.00€0.19matched
101capture01a1b01c-9636-706a-9737-d9840e00b752€9.00€0.19matched
102capture01a1b01c-9c53-7419-9c45-00a33fae6ee3€35.00€0.50matched
103capture01a1b01c-f323-7526-8c0e-10354eeef08b€15.00€0.26matched
104capture01a1b01c-fae7-724c-a83e-5f602709215b€9.00€0.19matched
105capture01a1b01d-1be0-7df7-bce9-f13889a1692b€49.00€0.67matched
106capture01a1b01d-1f51-771a-9d2d-cf704ff940d8€35.00€0.50matched
107capture01a1b01d-4549-7bcb-8ca5-fb387ab554ab€9.00€0.19matched
108capture01a1b01d-5017-74a8-a5da-29ccbecc2713€9.00€0.19matched
109capture01a1b01d-5638-7350-b26f-f66c17e540d2€9.00€0.19matched
110capture01a1b01d-599f-7863-851f-fa6e723be0c6€15.00€0.26matched
111capture01a1b01d-6033-7573-8559-a8fe9be3539d€9.00€0.19matched
112refund01a1b01d-62da-7348-884f-fd3ea4ac8594-€3.00€0.00matched
113capture01a1b01d-7d16-7f07-9513-885430eb15bb€49.00€0.67matched
114capture01a1b01d-aa35-7189-b175-730d01fd1e10€9.00€0.19matched
115capture01a1b01d-b87f-7ff6-81ad-2412d9031451€9.00€0.19matched
116capture01a1b01d-bf6b-79f4-bd8a-57562226a1e0€24.00€0.37matched
117capture01a1b01d-c79c-7375-a06e-5851730dcdc0€15.00€0.26matched
118capture01a1b01d-fb89-76d6-9e4b-2c616cdd0872€24.00€0.37matched
119capture01a1b01e-1a09-7d17-8c5d-93889c3c870d€35.00€0.50matched
120capture01a1b01e-3692-7d88-92ce-355d830c39e1€35.00€0.50matched
121capture01a1b01e-5eb0-7e40-8deb-0bebbf8be109€24.00€0.37matched
122capture01a1b01e-6988-708a-8cc6-8ccbd343c61a€15.00€0.26matched
123capture01a1b01e-73e5-729e-8534-4c8b2c78c571€24.00€0.37matched
124capture01a1b01e-7e3a-7b31-9177-8e016f4ff405€15.00€0.26matched
125capture01a1b01e-805e-7d7f-ae30-541a0d5f14a3€35.00€0.50matched
126capture01a1b01e-8b90-7a4f-bc5e-c141352f4f8a€15.00€0.26matched
127capture01a1b01e-9a4a-79c5-8a42-90c630b4b610€49.00€0.67matched
128capture01a1b01e-a348-7ebc-86a0-b08ff05634d1€49.00€0.67matched
129capture01a1b01e-b59c-7862-b02b-97eeee6914b3€24.00€0.37matched
130capture01a1b01e-ba36-748a-a15f-b2469e3347f6€15.00€0.26matched
131capture01a1b01e-bdfc-7450-85d4-37b8f89c0c25€24.00€0.37matched
132refund01a1b01e-c824-794e-bb82-a42596898061-€19.00€0.00matched
133refund01a1b01e-f832-7822-b277-02aade943021-€30.00€0.00matched
134capture01a1b01f-1720-765c-afc4-22abdfd96b1d€15.00€0.26matched
135capture01a1b01f-2486-7b6d-9190-20af8fc65407€9.00€0.19matched
136capture01a1b01f-2d18-73b6-bab1-8f017b031a3f€24.00€0.37matched
137capture01a1b01f-30a9-72b8-9249-c40bca5fc121€24.00€0.37matched
138capture01a1b01f-3a4a-7992-b08f-86eb24aefa45€35.00€0.50matched