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, 07:40

Gross

€2,905.00

PSP fee

€46.22

Net to the bank

€2,858.78

Settlement journal

#412316

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a1afd5-8762-78ad-bd0c-554bef1ead08 is already settled by stl_EUR_2989918 line 117
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
LineKindReferenceGrossFeeStatus
48capture01a1afcf-7268-7dc3-a62b-f0b16dd60851€9.00€0.23fee difference
118refund01a1afd5-8763-7376-95e0-988cf7fab695-€19.00€0.00duplicate line
1capture01a1afc4-f5df-7873-9073-c1796fc79355€9.00€0.19matched
2capture01a1afc9-4469-70fa-b7e4-21805834f4ae€24.00€0.37matched
3capture01a1afcb-d85b-7a2b-9f0a-8153661b28c1€35.00€0.50matched
4capture01a1afcc-ddf7-7a20-98c2-bb55e7eef861€35.00€0.50matched
5capture01a1afcc-e1f1-7da2-a102-a6a0d687ddb4€35.00€0.50matched
6capture01a1afcc-eb6e-79fe-b5b5-407192c70827€24.00€0.37matched
7capture01a1afcc-f1ce-7c62-bd46-3214caa5f064€24.00€0.37matched
8capture01a1afcc-ff08-7a7e-8f4f-b322633b0718€49.00€0.67matched
9capture01a1afcd-046b-781c-b948-53e2f48e5575€35.00€0.50matched
10capture01a1afcd-13bc-7d45-ab09-2750cf310aee€35.00€0.50matched
11capture01a1afcd-26ec-771b-bcb7-70ae8147f3b9€9.00€0.19matched
12refund01a1afcd-3516-770e-a526-bdad12692c3c-€7.00€0.00matched
13capture01a1afcd-4ba4-7325-9bff-140bd7a5c97d€15.00€0.26matched
14capture01a1afcd-5474-768c-bf43-3568741f131f€9.00€0.19matched
15capture01a1afcd-5fce-72cd-a92c-8a8c9970ba57€49.00€0.67matched
16capture01a1afcd-6257-7884-91e5-f1d8c4000d1a€24.00€0.37matched
17capture01a1afcd-6b1c-7cc2-974e-72411734a82b€35.00€0.50matched
18capture01a1afcd-817b-77ad-bce3-f67fae3fd836€15.00€0.26matched
19capture01a1afcd-85ff-74e3-a9c8-a193dd8c015e€15.00€0.26matched
20capture01a1afcd-8676-7c1e-9399-6ec07ed3420c€15.00€0.26matched
21capture01a1afcd-981e-7dd0-b40b-45da46ed051e€35.00€0.50matched
22capture01a1afcd-c916-72d0-baba-6f475fd7d80b€24.00€0.37matched
23capture01a1afcd-d324-765a-8b94-31b08cea55a4€15.00€0.26matched
24capture01a1afcd-da81-72de-afbb-a6442d42d46e€15.00€0.26matched
25capture01a1afce-0620-7cc5-87ad-5f7344afd9f7€24.00€0.37matched
26capture01a1afce-2c68-7c31-af2d-ed6170434cda€35.00€0.50matched
27capture01a1afce-2f1c-77c2-8c5f-d6fe929dd156€49.00€0.67matched
28capture01a1afce-384d-7c03-b8b9-5c05886d855f€24.00€0.37matched
29capture01a1afce-5215-7501-b5a9-33595842594b€9.00€0.19matched
30capture01a1afce-5373-7df1-9477-9ac15315a037€24.00€0.37matched
31capture01a1afce-5389-7c6e-a5ca-e4aaf846fc3c€9.00€0.19matched
32capture01a1afce-6b25-76bb-b050-13a12aacfc15€49.00€0.67matched
33capture01a1afce-862e-7614-a3da-8b3f365b8924€24.00€0.37matched
34capture01a1afce-8e70-7f60-bf8d-612d0286fa4a€9.00€0.19matched
35capture01a1afce-93f2-76ee-ab5a-958de53a34f4€49.00€0.67matched
36capture01a1afce-a71e-74c4-8ac9-c124a276b13f€9.00€0.19matched
37refund01a1afce-cdb5-79f7-a66c-348cec9943dc-€22.00€0.00matched
38capture01a1afce-d7c0-7d0c-b0a2-44d5e1a0adb2€49.00€0.67matched
39refund01a1afce-fc55-730f-bcf9-7af427f75879-€3.00€0.00matched
40capture01a1afcf-3397-7e91-8be7-d0b5da69b165€9.00€0.19matched
41capture01a1afcf-3642-7ebf-90af-2ff21210850c€9.00€0.19matched
42capture01a1afcf-38f3-778a-8bd3-e3aad77b0e3d€35.00€0.50matched
43capture01a1afcf-42b8-7a3f-b29d-10cbfdfb32cc€24.00€0.37matched
44capture01a1afcf-548e-77fd-b5d7-e309f96d29cc€9.00€0.19matched
45capture01a1afcf-59e8-70f2-93e2-d303ca714de4€24.00€0.37matched
46refund01a1afcf-62eb-7c8e-b03d-0a1ef444caba-€10.00€0.00matched
47capture01a1afcf-6736-717b-99ca-8a4efe0d7391€49.00€0.67matched
49capture01a1afcf-9990-71d4-be10-029b2c9725b7€15.00€0.26matched
50capture01a1afcf-9c4d-7914-b266-6851b24addd3€24.00€0.37matched
51capture01a1afcf-e19e-7a25-9de2-f9e7df4b5b5a€49.00€0.67matched
52capture01a1afcf-f0b1-7272-bba2-1305c556f586€15.00€0.26matched
53capture01a1afd0-1b2a-739e-b04a-6e3e9dd8d30d€49.00€0.67matched
54capture01a1afd0-1f77-74b0-ad39-0ddaab67c825€49.00€0.67matched
55capture01a1afd0-24ae-7dce-ae2f-1ac86c4bf3e4€15.00€0.26matched
56capture01a1afd0-600e-76ba-aa5b-a10e0d88c8cf€35.00€0.50matched
57capture01a1afd0-6054-71f0-b135-872a9122d810€35.00€0.50matched
58capture01a1afd0-6dbe-7347-8fae-2232da0a1225€49.00€0.67matched
59capture01a1afd0-7bb2-71b3-97e4-21e070c4a40b€35.00€0.50matched
60capture01a1afd0-8611-7b69-9e34-d4970c195f2a€49.00€0.67matched
61capture01a1afd0-8d4e-78f4-bb54-b94d46020fbe€35.00€0.50matched
62capture01a1afd0-a58b-786e-bbc3-821d35663fcc€24.00€0.37matched
63capture01a1afd0-af7c-7ba9-b2a7-3879bf1ce4b1€9.00€0.19matched
64capture01a1afd0-d502-7902-a45a-c3518cbe3417€49.00€0.67matched
65capture01a1afd0-e594-7e28-a476-5107ae7ed2bb€15.00€0.26matched
66capture01a1afd1-41a2-7496-8391-42b9e23850da€15.00€0.26matched
67capture01a1afd1-4892-70be-8e3d-98fde5b95792€24.00€0.37matched
68capture01a1afd1-7dda-7d9f-8314-81e4431f8ea3€49.00€0.67matched
69capture01a1afd1-7e4e-72e3-9985-0c6c95b88031€35.00€0.50matched
70capture01a1afd1-9e40-7552-adb6-d6388a3f0154€9.00€0.19matched
71capture01a1afd1-9b80-78ad-9076-0d7edaf5e813€15.00€0.26matched
72capture01a1afd1-ad9f-7c86-9bf2-42dcf7c39b96€49.00€0.67matched
73refund01a1afd1-b4ee-7cab-b59b-635d956426f4-€14.00€0.00matched
74capture01a1afd1-c131-7818-8b96-6291f8e96749€9.00€0.19matched
75capture01a1afd1-cbd1-74d8-9177-d10386c651da€9.00€0.19matched
76capture01a1afd1-cbe4-77b7-99e2-5cb2ac3671a1€35.00€0.50matched
77capture01a1afd1-cca8-79ab-8fdc-c9d914644b69€49.00€0.67matched
78capture01a1afd1-ebdc-72aa-ad86-28e0d883cfda€35.00€0.50matched
79capture01a1afd1-f85a-7338-814b-75b1e688e8b0€15.00€0.26matched
80refund01a1afd2-4156-7848-8c91-e4ee5d65bf6f-€12.00€0.00matched
81capture01a1afd2-48de-7a87-96b6-9ecadbe918ec€49.00€0.67matched
82capture01a1afd2-4fff-774e-b953-5c5b9bea4d37€9.00€0.19matched
83capture01a1afd2-66a3-78ad-b14b-1893acc0bf41€24.00€0.37matched
84capture01a1afd2-706e-7b86-a0fa-38ee59975ecc€9.00€0.19matched
85capture01a1afd2-a36c-70da-ad24-db6194a165e1€24.00€0.37matched
86capture01a1afd2-ce3f-71cd-a036-e2a124873703€49.00€0.67matched
87capture01a1afd2-d471-7d07-b513-6e2018ba6e81€15.00€0.26matched
88capture01a1afd2-ea30-76ca-9ffc-18b850b16977€24.00€0.37matched
89capture01a1afd3-4561-7b31-8556-83d792ef3401€15.00€0.26matched
90capture01a1afd3-59f4-7411-b21b-01209113ae0b€35.00€0.50matched
91capture01a1afd3-6355-7043-af74-15c741240678€35.00€0.50matched
92capture01a1afd3-807f-7b82-bdd6-a3c6d76e84f9€9.00€0.19matched
93capture01a1afd3-bcd4-719c-8231-d0f1833317dd€35.00€0.50matched
94capture01a1afd3-db12-7620-8610-9d6f219dceff€24.00€0.37matched
95capture01a1afd4-13b5-7524-9101-d6caf1c72f43€49.00€0.67matched
96capture01a1afd4-20a5-7a83-80c6-7f78699af21b€15.00€0.26matched
97capture01a1afd4-2d78-7237-af46-dc64eb892731€35.00€0.50matched
98capture01a1afd4-51e6-7931-9c73-d3fe42b9616c€35.00€0.50matched
99capture01a1afd4-5662-7f39-a1cf-ccdaeb4a556d€24.00€0.37matched
100capture01a1afd4-6cc0-76a4-8041-44d83542ef02€49.00€0.67matched
101refund01a1afd4-87ad-707c-8fd2-c16d8edeb1bb-€36.00€0.00matched
102capture01a1afd4-9207-747f-972b-6c58e810487a€9.00€0.19matched
103capture01a1afd4-a84e-7465-b11f-5ef207961916€15.00€0.26matched
104capture01a1afd4-ac4d-7109-9bc8-5451725ad1da€35.00€0.50matched
105capture01a1afd4-d8cb-7e88-a9a0-2c243ae10f93€35.00€0.50matched
106capture01a1afd4-df5d-71c7-9aa8-d5505f25324c€35.00€0.50matched
107capture01a1afd4-e084-7b2f-afcf-89491aab9f41€9.00€0.19matched
108capture01a1afd4-f4de-719b-8374-55f10411f207€15.00€0.26matched
109capture01a1afd5-286d-76d9-a08b-ebb430dc3281€15.00€0.26matched
110capture01a1afd5-2fb2-7e90-8a3e-7dfd11597094€24.00€0.37matched
111capture01a1afd5-35c1-77e0-af82-9d6e04748783€35.00€0.50matched
112capture01a1afd5-3f4a-7fc5-b46d-2ae247250648€49.00€0.67matched
113capture01a1afd5-4339-7967-81af-dd9100a7580d€49.00€0.67matched
114capture01a1afd5-486a-77a9-8239-109106a60005€9.00€0.19matched
115capture01a1afd5-4c70-7714-8ecc-4fac9a75b2cf€15.00€0.26matched
116capture01a1afd5-7bef-7c12-8c82-317c92f6a258€49.00€0.67matched
117refund01a1afd5-8763-7376-95e0-988cf7fab695-€19.00€0.00matched
119refund01a1afd5-9e15-7f8c-b27e-9e4871889fe7-€23.00€0.00matched
120capture01a1afd5-aea7-7e18-bd3b-0dfc730dce4d€9.00€0.19matched
121capture01a1afd5-b45d-76be-bad5-cb5e9e83a763€24.00€0.37matched
122capture01a1afd5-b836-74b1-9100-1444070ea752€24.00€0.37matched
123capture01a1afd5-cc67-7943-9cd0-41f719eba5d0€24.00€0.37matched
124capture01a1afd5-cdad-732c-936e-0a693e378464€9.00€0.19matched
125capture01a1afd5-fce6-72e6-9348-718adc67c39c€9.00€0.19matched