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

31 Oct, 19:00

Gross

€3,211.00

PSP fee

€50.53

Net to the bank

€3,160.47

Settlement journal

#311333

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19359-b969-7752-9bdf-5c220fb71555 is already settled by stl_EUR_2989122 line 63
  • duplicate linethe file lists it twicecapture:01a1935b-62fe-74e5-bc77-443aee5b256d is already settled by stl_EUR_2989122 line 92
  • duplicate linethe file lists it twicecapture:01a1935b-c9ad-78bb-a1ef-5d6eeeec5ff0 is already settled by stl_EUR_2989122 line 96
  • missing linein the books, not in the filecapture:01a1935c-494f-7764-b67f-fbea85ee5db8 is in no file
LineKindReferenceGrossFeeStatus
64capture01a19359-be08-77ca-99ce-1fca0a388611€35.00€0.50duplicate line
93capture01a1935b-632c-78b3-a1b9-c9b2fc4c363d€49.00€0.67duplicate line
97capture01a1935b-ca18-7fba-81c1-510eb24747ce€49.00€0.67duplicate line
1capture01a19355-4307-7fc9-8b58-286bef9e99d5€24.00€0.37matched
2capture01a19355-50ba-7010-85ea-e7f6e1c282d9€49.00€0.67matched
3capture01a19355-51b4-7e6f-879a-a495e16d416f€9.00€0.19matched
4capture01a19355-55eb-7f4c-827e-3d1a867fbdab€49.00€0.67matched
5capture01a19355-80d3-7609-8bf0-6573d26a7388€24.00€0.37matched
6capture01a19355-82d4-71e9-ac9e-426522abf053€24.00€0.37matched
7capture01a19355-83b0-7f97-92b9-08917fdb672a€15.00€0.26matched
8capture01a19355-9253-7a23-a263-a923c2dc59a2€24.00€0.37matched
9refund01a19355-9254-7e91-b358-9aa3532238ac-€21.00€0.00matched
10capture01a19355-965f-7816-a973-28978a4ad41e€49.00€0.67matched
11capture01a19355-983b-7bf5-bff8-3b49b10a9a3e€49.00€0.67matched
12capture01a19355-c06d-7061-b4fa-f157ab3ef75d€9.00€0.19matched
13capture01a19355-d881-72f7-a195-2d64b08b00e7€24.00€0.37matched
14capture01a19355-da6a-7f12-a20a-a7aae4327d4f€49.00€0.67matched
15capture01a19355-dabc-7c86-bcb9-0ef18167d4de€24.00€0.37matched
16capture01a19356-0185-704b-86f1-99f25577ce2e€15.00€0.26matched
17capture01a19356-1631-731c-8820-2a6839fdd2ff€24.00€0.37matched
18capture01a19356-3aef-736a-990f-86b38b9f3d07€24.00€0.37matched
19capture01a19356-71cd-7c84-a4b0-5bf11cc82049€24.00€0.37matched
20refund01a19356-783b-7615-b256-19ae989ced50-€17.00€0.00matched
21capture01a19356-8daf-7000-b1dc-6f9d5c26c832€24.00€0.37matched
22capture01a19356-9a1c-7812-a676-cba64c510b09€35.00€0.50matched
23capture01a19356-b7bf-780d-a8a9-2bafbb047a18€49.00€0.67matched
24refund01a19356-d0fe-7910-80e9-1d6ded1f4aa8-€23.00€0.00matched
25capture01a19356-ed62-72f7-9a01-afbc1e3ca61c€24.00€0.37matched
26capture01a19357-4b60-786b-98d2-394e0494ec4a€9.00€0.19matched
27capture01a19357-4d4c-70a0-ac54-a9c15919c2b0€49.00€0.67matched
28capture01a19357-5ee9-7914-9654-e23d336c100d€24.00€0.37matched
29capture01a19357-b3db-73ef-92e3-a5a69515e91b€24.00€0.37matched
30refund01a19357-b411-741a-aebd-3090c0e3da4a-€20.00€0.00matched
31capture01a19358-07a3-7f8d-856d-dc54c92a460c€49.00€0.67matched
32capture01a19358-10aa-763a-9b98-1c0d44adb8cf€24.00€0.37matched
33capture01a19357-fafa-7113-861f-4c40d3f2ad3c€35.00€0.50matched
34capture01a19358-2f85-7f7e-b059-d0d24441df1b€35.00€0.50matched
35capture01a19358-53fd-7d74-a09b-ebc5482c6b24€24.00€0.37matched
36capture01a19358-664a-70d8-bb46-e1375fe8ba6f€15.00€0.26matched
37capture01a19358-7318-7d9a-9a76-2adcacc107ae€9.00€0.19matched
38capture01a19358-748d-7797-9ac7-1c75bf5d7939€9.00€0.19matched
39capture01a19358-7498-7fdf-9cdf-0b2d603c918d€24.00€0.37matched
40capture01a19358-7928-73e3-aa8a-8bb5181aadd5€15.00€0.26matched
41capture01a19358-8086-7496-b178-3440397c9020€15.00€0.26matched
42capture01a19358-8fff-75ca-929a-e5ae78c5fce3€9.00€0.19matched
43capture01a19358-92c5-70d0-b79a-8027a33dddaa€49.00€0.67matched
44capture01a19358-99b4-7850-856e-25063056f29b€24.00€0.37matched
45capture01a19358-b045-7e3e-b99b-92a1e0e80eec€9.00€0.19matched
46capture01a19358-bff9-7691-aa96-d3cc54935d06€9.00€0.19matched
47capture01a19358-d029-7da7-82b7-026b872fbcca€24.00€0.37matched
48refund01a19358-d531-7ab2-a57c-e31aecb7a634-€8.00€0.00matched
49capture01a19358-e17f-70ab-8fa8-7f869d5e7d7a€49.00€0.67matched
50capture01a19358-eb9f-7e64-b973-30c187ce95ee€35.00€0.50matched
51refund01a19359-030d-741d-ab1b-86209c8d9a4d-€35.00€0.00matched
52capture01a19359-2ddd-79df-8071-35412e3df9f4€15.00€0.26matched
53capture01a19359-362d-7fc1-8fba-859c274d999f€24.00€0.37matched
54capture01a19359-422b-731c-85a9-36c5364c5835€9.00€0.19matched
55capture01a19359-592e-79c3-828b-ec90f1e6fdd8€15.00€0.26matched
56capture01a19359-5c8e-7720-b334-d7627e3b93a3€49.00€0.67matched
57refund01a19359-65ef-7fb6-b3e1-e59011833549-€16.00€0.00matched
58capture01a19359-66b4-7c4e-9b98-c64b9145d66e€15.00€0.26matched
59capture01a19359-6e6b-7f1a-9144-016df0484078€24.00€0.37matched
60capture01a19359-763c-700a-a58b-64347631c259€35.00€0.50matched
61capture01a19359-95b8-7f9a-8766-f2d441cf7592€24.00€0.37matched
62capture01a19359-9b84-7d6a-9058-a76a5c60ca4c€35.00€0.50matched
63capture01a19359-be08-77ca-99ce-1fca0a388611€35.00€0.50matched
65capture01a19359-d1c7-73a3-82f7-e907367c837e€24.00€0.37matched
66capture01a19359-dfb4-7ed0-86be-a99a54c7a6a4€15.00€0.26matched
67capture01a19359-df5d-7aab-b697-4bd02e015522€15.00€0.26matched
68capture01a19359-f8af-7ea2-ac2e-2820b6d4e70d€49.00€0.67matched
69capture01a19359-fa03-7425-9131-760d7b292a7d€35.00€0.50matched
70capture01a1935a-10b6-7914-a46c-d3b0d183dc14€35.00€0.50matched
71capture01a1935a-274e-7ceb-a6be-6bf4fc4364b0€24.00€0.37matched
72capture01a1935a-38a4-71c7-af19-d11daa9d881d€24.00€0.37matched
73capture01a1935a-4458-7f78-9a56-7fcbb8182745€49.00€0.67matched
74capture01a1935a-4703-7a46-9a62-acf24517d2fb€49.00€0.67matched
75capture01a1935a-4e30-719c-86b4-383dab1fc5fd€24.00€0.37matched
76capture01a1935a-4e32-7a96-959f-d9e31a836bbf€15.00€0.26matched
77capture01a1935a-732a-7884-b4fe-a59261ef7982€24.00€0.37matched
78capture01a1935a-7420-767c-8089-92fd02fdcf85€9.00€0.19matched
79capture01a1935a-82a1-7bd2-9acf-f7b6fee7019e€24.00€0.37matched
80capture01a1935a-85e5-7cef-b482-50aa025db08e€24.00€0.37matched
81capture01a1935a-9c0c-7d76-9b38-c3ba0ef3020a€49.00€0.67matched
82capture01a1935a-aa6f-7469-b2de-3c36168a90a4€24.00€0.37matched
83capture01a1935a-b445-7109-a542-05302ffb1ad4€35.00€0.50matched
84capture01a1935a-b481-7ea4-99af-1e16d085dd3a€24.00€0.37matched
85capture01a1935a-b491-7a05-b670-47e24666f7f5€49.00€0.67matched
86capture01a1935a-dff7-7071-849f-f87e2abbd4ce€49.00€0.67matched
87capture01a1935b-1b5b-786c-9b3a-92572f60705d€15.00€0.26matched
88capture01a1935b-2b1e-7815-a458-6ce9366cc0d6€24.00€0.37matched
89capture01a1935b-31ff-79ab-9285-86a0a0884203€15.00€0.26matched
90capture01a1935b-49a9-7bea-9189-f45fc41676cc€15.00€0.26matched
91capture01a1935b-618d-7393-93ac-c6d7b6f3b837€15.00€0.26matched
92capture01a1935b-632c-78b3-a1b9-c9b2fc4c363d€49.00€0.67matched
94capture01a1935b-6d30-7f67-af59-3cc5c617c4b8€35.00€0.50matched
95capture01a1935b-7845-7a07-86f2-39897332ec76€35.00€0.50matched
96capture01a1935b-ca18-7fba-81c1-510eb24747ce€49.00€0.67matched
98refund01a1935b-cf37-77d7-9e29-2cea56a9a285-€33.00€0.00matched
99capture01a1935b-d714-78f4-99a4-07d5068fa0b5€49.00€0.67matched
100capture01a1935b-d9f3-7553-88d9-3ef566cfd5c0€9.00€0.19matched
101capture01a1935b-e36b-7e9d-9c4e-18b838507175€9.00€0.19matched
102capture01a1935b-e560-7ee4-be32-3306d847ebbc€49.00€0.67matched
103capture01a1935c-1ec7-74ff-a4a7-a54cbad227bc€9.00€0.19matched
104capture01a1935c-23c7-7987-b5cb-e7819f6ed028€9.00€0.19matched
105capture01a1935c-2b3c-7b46-a98f-0c650cfd567b€24.00€0.37matched
106capture01a1935c-54c4-7139-b0e0-5da3d797e06e€49.00€0.67matched
107capture01a1935c-8982-7e5d-961d-7f94d40c1a55€9.00€0.19matched
108capture01a1935c-ae5c-789a-9c9f-134a08cb572d€49.00€0.67matched
109capture01a1935d-07ea-7130-a245-35cfc11e8437€9.00€0.19matched
110capture01a1935d-1440-78a1-b2c0-043f250f0387€35.00€0.50matched
111capture01a1935d-19d8-703a-9741-d1d75f3939d8€49.00€0.67matched
112capture01a1935d-2db5-794b-8395-61193a5882ed€15.00€0.26matched
113capture01a1935d-46d9-76c4-8e2c-80ab5ca649cf€9.00€0.19matched
114capture01a1935d-5ce2-7efb-aba4-04fbc295b883€24.00€0.37matched
115capture01a1935d-6133-79ae-bdf9-aff0d86c3f80€24.00€0.37matched
116capture01a1935d-6fe2-7c22-8572-6bf0adafa9c4€9.00€0.19matched
117capture01a1935d-72d3-7210-bdd5-c2640e78cb32€35.00€0.50matched
118capture01a1935d-8b29-7666-902d-c48bee46ba25€15.00€0.26matched
119capture01a1935d-c126-7ec4-b5a9-68cd81aa67fe€9.00€0.19matched
120capture01a1935d-cc4f-7769-81bc-71e979eeb452€49.00€0.67matched
121capture01a1935d-cff1-7248-8deb-2b32a3275e37€9.00€0.19matched
122capture01a1935d-d60e-7a79-a5d8-59fdba95d334€24.00€0.37matched
123capture01a1935d-f4dd-795d-a710-f18f400ea968€15.00€0.26matched
124refund01a1935d-fde5-7ed3-8dda-a5fdb065113c-€6.00€0.00matched
125capture01a1935d-f9d8-7a1c-b727-348840e406cb€35.00€0.50matched
126capture01a1935e-20fe-7d58-b978-4551539b9243€49.00€0.67matched
127capture01a1935e-39e9-7981-b6a7-d17b1f2a2f4a€49.00€0.67matched
128capture01a1935e-44c4-7720-85a1-1e04384e6292€35.00€0.50matched
129capture01a1935e-4521-7c0a-85fe-e4aabcbf941d€49.00€0.67matched
130capture01a1935e-4847-7c5c-8681-9b0c5f5ca713€35.00€0.50matched