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

2 Nov, 19:30

Gross

€3,148.00

PSP fee

€47.82

Net to the bank

€3,100.18

Settlement journal

#348196

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19dc1-2855-7027-90e0-b4f5ffec2444 is already settled by stl_EUR_2989413 line 42
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
LineKindReferenceGrossFeeStatus
30capture01a19dc0-7c47-7c10-95c0-beea1c92aa54€35.00€0.52fee difference
43capture01a19dc1-28a6-776d-a528-97232e0f4708€35.00€0.50duplicate line
1capture01a19dbd-83f9-7c23-b0c2-e071ae85ac72€15.00€0.26matched
2capture01a19dbd-8480-711a-ac89-2d99d2a8f131€35.00€0.50matched
3capture01a19dbd-89cc-7052-8193-c6c55c67975c€35.00€0.50matched
4capture01a19dbd-8bb9-735c-966e-ef7fada816cc€49.00€0.67matched
5capture01a19dbd-970f-76e6-a48d-5d06f18bedac€24.00€0.37matched
6capture01a19dbd-be3e-761d-9c12-b502af0fdceb€35.00€0.50matched
7capture01a19dbd-d82b-795c-b741-0051bb10d38f€24.00€0.37matched
8capture01a19dbd-e5db-753e-82fa-75ff1fa3260c€49.00€0.67matched
9capture01a19dbe-492e-7be2-9311-c1f6755f9ec2€49.00€0.67matched
10capture01a19dbe-82db-7cda-bb37-66c8e2e85db3€35.00€0.50matched
11capture01a19dbe-9f92-7fc2-83c1-daa5527e35a5€49.00€0.67matched
12capture01a19dbe-fe26-72ec-b6a8-d662e080441f€9.00€0.19matched
13capture01a19dbf-057f-7748-a757-8bcd4ecc1ef7€15.00€0.26matched
14capture01a19dbf-2cab-7cdd-b32e-ab81b7007e8b€15.00€0.26matched
15capture01a19dbf-301f-7705-89f3-9dba79aeea7b€49.00€0.67matched
16capture01a19dbf-36bc-78dd-9172-800f79d18f93€24.00€0.37matched
17capture01a19dbf-383f-7809-947c-8685e87f61df€35.00€0.50matched
18capture01a19dbf-4e7c-7540-87c1-9f031352d18c€9.00€0.19matched
19capture01a19dbf-7d2f-7f7e-8931-dd103024370c€49.00€0.67matched
20capture01a19dbf-823c-7df1-be32-c0dda96ef56c€15.00€0.26matched
21capture01a19dbf-8fb1-7438-946c-28a4ea2cc28a€9.00€0.19matched
22capture01a19dbf-d91b-7156-a65c-ed585e2e933a€35.00€0.50matched
23capture01a19dbf-f783-7542-a759-3830fd27e5db€35.00€0.50matched
24capture01a19dc0-099f-7d77-baf7-306142a25dec€24.00€0.37matched
25capture01a19dc0-1f58-7637-8c6c-ec20e3cced4c€35.00€0.50matched
26capture01a19dc0-353f-75de-ae12-9496d6098fb0€9.00€0.19matched
27capture01a19dc0-62c9-7c34-8af5-3912ae4956c3€24.00€0.37matched
28capture01a19dc0-6ac5-7e34-bbad-53d25477bcb5€35.00€0.50matched
29refund01a19dc0-78df-7995-99f4-bc4da8fdb3ba-€4.00€0.00matched
31capture01a19dc0-918d-794e-9508-35e8f323ad7b€24.00€0.37matched
32capture01a19dc0-9d91-7c90-bea5-d20edf144fc8€9.00€0.19matched
33capture01a19dc0-a41b-72ac-be6c-7229ce4c8d88€49.00€0.67matched
34capture01a19dc0-bdc2-74cf-af63-32a2d4c15c26€15.00€0.26matched
35capture01a19dc0-d04e-7e47-9aa4-9c26c1c9f338€9.00€0.19matched
36capture01a19dc0-fe42-7923-a8f2-9ae2061c30f3€9.00€0.19matched
37capture01a19dc1-1398-74ae-ad92-3f61550882ce€35.00€0.50matched
38capture01a19dc1-1400-76ba-82de-49336db52211€24.00€0.37matched
39capture01a19dc1-1acd-78a6-be2b-681abb3dcde3€49.00€0.67matched
40capture01a19dc1-1f0e-7906-8fd6-45d5d863e23c€24.00€0.37matched
41refund01a19dc1-20c7-759a-8452-0cac14c0872e-€6.00€0.00matched
42capture01a19dc1-28a6-776d-a528-97232e0f4708€35.00€0.50matched
44capture01a19dc1-39b3-74d7-9ece-c064391b5bf9€49.00€0.67matched
45capture01a19dc1-4480-71a2-936d-9d91890622c8€9.00€0.19matched
46capture01a19dc1-7a96-7f99-b364-9d83891ee4dc€35.00€0.50matched
47capture01a19dc1-a5a8-71a7-b2fd-2c8965b375a2€49.00€0.67matched
48capture01a19dc1-af33-70a9-988f-df892cdc2778€15.00€0.26matched
49capture01a19dc1-b70a-7c8a-a4b4-e4e0d297fae6€49.00€0.67matched
50capture01a19dc1-ce7d-7482-bbef-71016f6ad8f7€15.00€0.26matched
51capture01a19dc1-f40d-7923-b036-7194c312a8a0€35.00€0.50matched
52capture01a19dc1-fe65-734e-ab6d-521139fb0ed4€35.00€0.50matched
53capture01a19dc1-feba-7c77-bca0-18e7246b8a75€24.00€0.37matched
54capture01a19dc2-10c7-77c4-b57c-7742b3e9af69€49.00€0.67matched
55capture01a19dc2-1e3d-7e2a-adb8-52b1a62258eb€35.00€0.50matched
56capture01a19dc2-3022-7e89-a4b6-ddfc9d07389f€24.00€0.37matched
57capture01a19dc2-4903-7507-ac5d-b396655030ba€35.00€0.50matched
58capture01a19dc2-5026-7994-aa7d-e4734b5566a5€35.00€0.50matched
59capture01a19dc2-514e-74e4-98f6-0e35eb127e46€9.00€0.19matched
60capture01a19dc2-7968-709e-88f9-249b3fa8c57f€49.00€0.67matched
61capture01a19dc2-c32a-7baa-98cb-4aed4ba16b98€35.00€0.50matched
62capture01a19dc2-d02b-7937-8ce0-3e2049d47151€49.00€0.67matched
63capture01a19dc2-d73a-700f-b737-9e501a28640c€35.00€0.50matched
64capture01a19dc2-f4b9-7470-9bc8-afb64d5c791d€35.00€0.50matched
65capture01a19dc2-f7a4-7139-8022-2983f24125de€49.00€0.67matched
66capture01a19dc2-f9d4-73c4-bae9-d56f53608aee€35.00€0.50matched
67capture01a19dc3-0551-796b-8e12-ab8d72ab29b1€35.00€0.50matched
68refund01a19dc3-43d6-7a9c-9c38-474b67dba628-€18.00€0.00matched
69capture01a19dc3-670e-73d5-8da2-435e52ad3b4b€24.00€0.37matched
70capture01a19dc3-68b8-7cb8-a604-fa1c1b1c0ea6€9.00€0.19matched
71capture01a19dc3-a6ff-707c-92e0-f7d624a13bf3€9.00€0.19matched
72capture01a19dc3-f4ad-7ce8-9db7-271a01385f1a€15.00€0.26matched
73capture01a19dc3-fe65-70a0-bf71-da2effd88359€35.00€0.50matched
74capture01a19dc4-1c5b-701d-b748-34cb17f9c83b€9.00€0.19matched
75capture01a19dc4-2536-761a-a41f-3867bce1fbb6€35.00€0.50matched
76capture01a19dc4-30ab-7e55-8207-6de36c8ea127€9.00€0.19matched
77capture01a19dc4-34ca-7be0-a85f-5a5c2d0d4b69€15.00€0.26matched
78capture01a19dc4-5252-77aa-b3e8-887a74f70bd2€35.00€0.50matched
79capture01a19dc4-530b-7c6e-890e-e2f76df239f4€49.00€0.67matched
80refund01a19dc4-659b-7345-9273-d38e2ea51886-€4.00€0.00matched
81capture01a19dc4-8350-7255-9340-c177429c3cb4€15.00€0.26matched
82capture01a19dc4-8790-77a9-800f-eea0d238ed64€35.00€0.50matched
83capture01a19dc4-8aeb-798b-82cf-e5c73524b3ea€15.00€0.26matched
84capture01a19dc4-a7c3-7e72-8567-794f454e1bf6€35.00€0.50matched
85capture01a19dc4-a7ca-7249-8c46-7f3c2a596e8b€49.00€0.67matched
86capture01a19dc4-ec3c-7e44-a0a9-ac715eb23ac7€24.00€0.37matched
87capture01a19dc5-16ca-7e60-8796-c7ea28639590€24.00€0.37matched
88capture01a19dc5-17b2-7323-b5b0-a11803644e6d€15.00€0.26matched
89capture01a19dc5-180a-7500-b53b-9d224bc48067€24.00€0.37matched
90capture01a19dc5-1d71-7f62-be8d-c3c8e3043f4c€24.00€0.37matched
91capture01a19dc5-3678-759f-84d7-b506caa7ec61€49.00€0.67matched
92capture01a19dc5-3dc3-75a0-82ff-728402cc7eb8€24.00€0.37matched
93capture01a19dc5-42c0-730b-8c84-45e8b7cb204e€9.00€0.19matched
94capture01a19dc5-46a1-79b6-9ad5-67dc35659ab9€15.00€0.26matched
95capture01a19dc5-4bbb-7702-8539-f77b9106215a€24.00€0.37matched
96capture01a19dc5-612e-7d9e-8b09-12e27723be71€35.00€0.50matched
97refund01a19dc5-7a72-7240-95aa-f44e30944ee2-€46.00€0.00matched
98capture01a19dc5-86e7-73d0-ac8d-171b758a21b1€24.00€0.37matched
99capture01a19dc5-93c1-7fcc-a8c1-4985107d2b14€24.00€0.37matched
100capture01a19dc5-9669-7cd5-87ba-56744e437a07€35.00€0.50matched
101capture01a19dc5-9cd0-7bc0-84e4-b582110f9674€49.00€0.67matched
102capture01a19dc5-b042-7cbe-af47-f39536e65499€49.00€0.67matched
103capture01a19dc5-bddb-7c6f-b7fa-e91f2cc3e4b1€49.00€0.67matched
104refund01a19dc5-d1d6-7c19-bd41-cfe8cf711219-€27.00€0.00matched
105capture01a19dc5-fb76-7fbb-99a5-12ab22d9e826€15.00€0.26matched
106capture01a19dc6-0cf4-7882-93b8-a2e28bf95fc6€49.00€0.67matched
107capture01a19dc6-10d2-77df-9e66-0e572b9e5ca7€35.00€0.50matched
108capture01a19dc6-1b65-7fa9-a3fb-2a35f2cb0812€9.00€0.19matched
109capture01a19dc6-4119-7dab-a100-f2d631bb47a0€49.00€0.67matched
110capture01a19dc6-43bf-7608-b137-5ad5d4bf4f6f€49.00€0.67matched
111capture01a19dc6-53d7-7bd5-8ac1-1497917c0f73€49.00€0.67matched
112capture01a19dc6-6d9b-7f7e-a7a7-b68c438364c8€49.00€0.67matched
113capture01a19dc6-7a6d-777f-9a6e-51117b825a28€49.00€0.67matched
114capture01a19dc6-9080-7107-bce0-ee3b5a1bdd7d€9.00€0.19matched