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

Gross

€3,113.00

PSP fee

€49.27

Net to the bank

€3,063.73

Settlement journal

#415067

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b08f-cee8-71b1-b187-a6632ae9da7e is already settled by stl_EUR_2989939 line 43
  • duplicate linethe file lists it twicecapture:01a1b092-484a-7461-b069-4206ed5bf955 is already settled by stl_EUR_2989939 line 83
  • duplicate linethe file lists it twicecapture:01a1b094-d1aa-7a02-b7a7-e4bf41c06359 is already settled by stl_EUR_2989939 line 118
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 39, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 71, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
LineKindReferenceGrossFeeStatus
44capture01a1b08f-cf57-795b-b660-b294d687b2f1€49.00€0.67duplicate line
62capture01a1b091-0c05-79c0-9151-b73e86cf31aa€49.00€0.68fee difference
72capture01a1b091-a7c6-7651-a323-b16f3690854b€24.00€0.39fee difference
84capture01a1b092-4868-7753-969d-fc6948b71fff€49.00€0.67duplicate line
98capture01a1b093-34f7-7d6c-a502-8321a6207da2€49.00€0.71fee difference
119capture01a1b094-d216-7441-95b6-59c1f4f84796€35.00€0.50duplicate line
126capture01a1b095-7bb8-786f-bf67-07fb2a8163e6€35.00€0.54fee difference
1capture01a1b085-4de2-7ebf-8f1b-12ee7212cd37€15.00€0.26matched
2capture01a1b086-fb6d-7408-bd1b-3c9a3f615867€9.00€0.19matched
3capture01a1b087-2fef-73eb-bf32-66f9ec5ac9a7€9.00€0.19matched
4capture01a1b088-e0fd-7bae-b222-e137254f9d67€24.00€0.37matched
5capture01a1b089-582f-7849-a65f-09a8c92cfaef€9.00€0.19matched
6capture01a1b08a-dec7-796c-a144-6ba23a8723f6€15.00€0.26matched
7capture01a1b08d-4564-7154-98dd-5a4bcff40fc6€49.00€0.67matched
8capture01a1b08d-49e3-76a6-88a9-947177e4fcdb€49.00€0.67matched
9capture01a1b08d-4be2-7ccf-bcdb-bae5657d1d13€15.00€0.26matched
10capture01a1b08d-5a45-7772-a9a4-2b917af0bd6d€15.00€0.26matched
11capture01a1b08d-7b1f-7a11-a733-fcfc07d0af26€49.00€0.67matched
12capture01a1b08d-815c-7ed3-9fe8-4d08dab3513b€24.00€0.37matched
13capture01a1b08d-8f52-7b57-90a5-c0909c2c36fc€49.00€0.67matched
14capture01a1b08d-94e3-7910-bc2e-b1e9906080bf€49.00€0.67matched
15capture01a1b08d-a21d-7e7e-b816-7370b2cc35b8€9.00€0.19matched
16capture01a1b08d-a4b8-766d-a4af-b57a1e84e963€9.00€0.19matched
17capture01a1b08d-b300-70ab-8f9f-e4db02119495€49.00€0.67matched
18capture01a1b08d-cc67-7c1e-9f31-4eac0cd3d398€35.00€0.50matched
19capture01a1b08d-e094-7019-a763-7aebc0f11a6f€24.00€0.37matched
20capture01a1b08d-e9aa-7a79-9b18-ca99bd100faa€15.00€0.26matched
21refund01a1b08d-f1af-7544-a686-be36f1b7556b-€37.00€0.00matched
22capture01a1b08d-f566-7ede-b77e-5092e033f375€35.00€0.50matched
23capture01a1b08e-13f1-7345-b4eb-88f2d1cfe997€49.00€0.67matched
24capture01a1b08e-22d3-7f1b-a529-5b330631b41a€35.00€0.50matched
25capture01a1b08e-3680-71ad-91cb-9a997cde02fe€49.00€0.67matched
26capture01a1b08e-6632-79cc-9587-1411965aa84e€49.00€0.67matched
27capture01a1b08e-7054-746e-bcbd-fe31c76c261c€24.00€0.37matched
28capture01a1b08e-7c70-71cf-9e53-0183f4b6486c€15.00€0.26matched
29capture01a1b08e-d072-7786-87c7-0196c87458db€49.00€0.67matched
30capture01a1b08e-d554-77ba-8aaa-dca9071daa71€9.00€0.19matched
31capture01a1b08e-e344-71bf-bee1-f25aa2f79817€9.00€0.19matched
32capture01a1b08e-e9e1-7e35-86d0-4ae4292d9f91€35.00€0.50matched
33capture01a1b08e-f409-74bc-b4ad-421ea908044d€15.00€0.26matched
34refund01a1b08f-35d6-72d1-bab4-499d8a398b20-€46.00€0.00matched
35capture01a1b08f-40ee-792a-9599-80b16cd87f9c€24.00€0.37matched
36capture01a1b08f-441b-7aa4-8b3a-43bfa66a9ad7€49.00€0.67matched
37capture01a1b08f-4ec7-7f1b-96ad-105a0f5a9d8b€24.00€0.37matched
38capture01a1b08f-6bc2-77bc-ac86-1697b4216038€9.00€0.19matched
39capture01a1b08f-7249-7145-a79d-06d2215fcfb9€15.00€0.26matched
40capture01a1b08f-87b1-7a7e-b7f2-0e97d66f9e57€24.00€0.37matched
41capture01a1b08f-948f-79b4-bceb-5a05eaa8c05e€49.00€0.67matched
42capture01a1b08f-c336-7179-8588-2a0cb1467e98€9.00€0.19matched
43capture01a1b08f-cf57-795b-b660-b294d687b2f1€49.00€0.67matched
45capture01a1b08f-d2f6-7ddb-9447-077c17261b35€15.00€0.26matched
46capture01a1b090-09b2-7bbe-b083-d040d8a92d0c€24.00€0.37matched
47capture01a1b090-10f9-7618-baf3-f67f3d015c29€9.00€0.19matched
48capture01a1b090-209f-7627-a7f9-1ada10967629€9.00€0.19matched
49capture01a1b090-47b9-7078-924b-3d90e40b50f8€15.00€0.26matched
50capture01a1b090-5a99-75ca-8e79-e7e5001a654c€24.00€0.37matched
51capture01a1b090-752e-7d66-8498-5342ecf57f4e€24.00€0.37matched
52capture01a1b090-904e-7d77-9d23-ff9f383b7bb0€15.00€0.26matched
53capture01a1b090-9fdf-7b95-8ba0-f5d7aa425b70€24.00€0.37matched
54capture01a1b090-ab0a-71b3-84df-62fb0b2bfa36€49.00€0.67matched
55capture01a1b090-af0e-7fbc-938d-d664eefa4ce9€35.00€0.50matched
56capture01a1b090-bea1-7053-ba93-c76ec332c244€9.00€0.19matched
57capture01a1b090-ccb6-7ed4-80a5-19bb04ebfc0e€9.00€0.19matched
58capture01a1b090-de36-7d8d-ab5b-8caa99e41c65€24.00€0.37matched
59refund01a1b090-e801-725d-afb5-65ad728e506f-€32.00€0.00matched
60capture01a1b090-f435-7f83-a5c6-bbd8d572434b€9.00€0.19matched
61refund01a1b090-fdb9-7510-8133-45e3e4d52509-€9.00€0.00matched
63capture01a1b091-22a5-7fb3-8c2f-0490e8246e1a€35.00€0.50matched
64capture01a1b091-2aed-7746-8652-2a0a425cdb11€35.00€0.50matched
65capture01a1b091-374b-787c-84af-4d2e40d6e8ae€9.00€0.19matched
66capture01a1b091-3c75-7df5-a82f-abcd9e3d6430€9.00€0.19matched
67capture01a1b091-45ab-78a1-bbae-73e9d4933342€9.00€0.19matched
68capture01a1b091-5432-7e8f-911a-ac1f9c49e38a€49.00€0.67matched
69capture01a1b091-6c5a-73dd-8cd7-c9754721f860€49.00€0.67matched
70capture01a1b091-98bb-7e6e-b02c-200dbc0dcf5e€15.00€0.26matched
71capture01a1b091-97f3-7c0a-bfb2-eb3bf826b946€49.00€0.67matched
73capture01a1b091-ac4c-7d87-840a-59b19f74b8b6€24.00€0.37matched
74capture01a1b091-ce74-71ce-8a77-cef0ac48dd56€9.00€0.19matched
75capture01a1b091-d384-72b7-951b-623e7b79a9a7€15.00€0.26matched
76capture01a1b091-eb89-7647-bcf8-4b81f5fb4e62€24.00€0.37matched
77capture01a1b091-fecc-799e-97a6-85c5c8de28d5€24.00€0.37matched
78capture01a1b092-0285-71ea-85fd-c74c6994da95€49.00€0.67matched
79refund01a1b092-0357-7158-bad2-18d09aa6f55f-€12.00€0.00matched
80capture01a1b092-095b-7722-a54a-302635ee8ade€15.00€0.26matched
81capture01a1b092-34d3-717e-91c8-4f2b37f45d7e€49.00€0.67matched
82capture01a1b092-3880-78b8-be68-5b872dc0ab06€24.00€0.37matched
83capture01a1b092-4868-7753-969d-fc6948b71fff€49.00€0.67matched
85capture01a1b092-4899-7dca-985d-b08159464cc1€15.00€0.26matched
86refund01a1b092-6fa6-7f67-a273-af9c679538da-€12.00€0.00matched
87capture01a1b092-8793-7de6-9ac0-ba91ee6141cb€35.00€0.50matched
88capture01a1b092-8af9-7dd5-a7d8-9f09ba728600€49.00€0.67matched
89refund01a1b092-9779-7ec0-85c5-6bc57544595a-€9.00€0.00matched
90capture01a1b092-b035-7a89-964a-3143eafab230€24.00€0.37matched
91capture01a1b092-b88c-7285-8df9-45da84c783fe€15.00€0.26matched
92capture01a1b092-cd03-7f07-979c-635d5f67eaf1€9.00€0.19matched
93capture01a1b092-d303-797b-9a09-5e80b5fcd8c7€49.00€0.67matched
94capture01a1b092-d664-76b1-9687-3e6cc677e8a2€9.00€0.19matched
95capture01a1b092-e941-7abb-bde3-76903b415cbf€9.00€0.19matched
96capture01a1b092-f655-7395-80e0-b6dd01ed687d€35.00€0.50matched
97capture01a1b092-f849-79cd-b26c-38d6fcdd2528€9.00€0.19matched
99capture01a1b093-41ec-7561-88b2-e0c4fd8d9a6d€24.00€0.37matched
100capture01a1b093-4b64-7b9e-ae20-b2d7478d0b9a€35.00€0.50matched
101capture01a1b093-5cd6-7039-ae5a-9c4b7f1b6850€24.00€0.37matched
102capture01a1b093-78fa-71a2-b594-0b40d945e92a€35.00€0.50matched
103capture01a1b093-95d9-7a82-89f8-45939c0682bf€9.00€0.19matched
104capture01a1b093-bf18-7184-b868-a27e2930c288€35.00€0.50matched
105capture01a1b094-06b5-772b-a246-aace8d8f0d8c€35.00€0.50matched
106capture01a1b094-082e-7dc6-8955-d2bee05f3314€9.00€0.19matched
107capture01a1b094-1239-71ff-a2ea-0fad404d7b87€15.00€0.26matched
108capture01a1b094-124e-7242-9193-33db4c46d778€35.00€0.50matched
109capture01a1b094-17b9-794b-ae13-d4ba8aa54ed4€15.00€0.26matched
110capture01a1b094-2e00-79c4-beb6-9b2f13c9be0f€24.00€0.37matched
111capture01a1b094-4a0b-79e2-8375-e0a1e536f81b€15.00€0.26matched
112capture01a1b094-6a11-7b1e-81b4-1d691d1881e2€35.00€0.50matched
113capture01a1b094-8094-73ac-b54e-5fdace542ace€49.00€0.67matched
114capture01a1b094-a551-7128-b27b-8b0ee69b5cc4€35.00€0.50matched
115capture01a1b094-ae9b-7c83-9ece-749cded63d95€9.00€0.19matched
116capture01a1b094-b69c-7f2e-a5a8-72c74a71c574€35.00€0.50matched
117capture01a1b094-c441-7d0d-91a6-52aad5553613€9.00€0.19matched
118capture01a1b094-d216-7441-95b6-59c1f4f84796€35.00€0.50matched
120capture01a1b094-e70f-71ed-868a-dd11391f43d8€49.00€0.67matched
121capture01a1b095-0e68-7275-b95c-25c02093deb9€35.00€0.50matched
122capture01a1b095-121f-7b9a-b99e-101779684598€9.00€0.19matched
123capture01a1b095-2c31-75ec-9ef8-e945eef2841d€24.00€0.37matched
124capture01a1b095-3068-736a-91ac-3239ebda686f€24.00€0.37matched
125capture01a1b095-7329-7176-8484-559e2e1e6da3€15.00€0.26matched
127capture01a1b096-03a8-7f58-adf1-cf587c9580c8€24.00€0.37matched
128capture01a1b096-2635-7c13-8242-57634893190f€9.00€0.19matched
129capture01a1b096-2680-785c-bb0c-fc313e784f28€35.00€0.50matched