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

4 Nov, 23:50

Gross

€3,308.00

PSP fee

€52.10

Net to the bank

€3,255.90

Settlement journal

#388016

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a8fd-1439-722a-b480-75433ff4df07 is already settled by stl_EUR_2989727 line 79
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
LineKindReferenceGrossFeeStatus
80capture01a1a8fd-144e-78c3-a4fc-9ac7c894eacd€15.00€0.26duplicate line
83capture01a1a8fd-42b3-77c5-9b7c-8e9693a3bfe9€35.00€0.52fee difference
1refund01a1a8f3-2685-7d3f-ae2d-2b5f46e8dab5-€13.00€0.00matched
2capture01a1a8f3-4478-7a91-91ba-6a890495a9aa€24.00€0.37matched
3capture01a1a8f6-516c-7db6-8985-3a47fcd181b0€35.00€0.50matched
4capture01a1a8f7-95c8-72ab-b83b-660b5ea3b6b8€24.00€0.37matched
5capture01a1a8f8-514f-7689-9068-12a64695490b€49.00€0.67matched
6capture01a1a8f8-5804-7082-9833-ad47c3ce49fa€9.00€0.19matched
7capture01a1a8f8-5af2-7495-a5a3-936c38dc2783€49.00€0.67matched
8capture01a1a8f8-6fc0-791c-92c2-95e34d051657€15.00€0.26matched
9capture01a1a8f8-8ec1-770d-bd89-6eed427b1d41€15.00€0.26matched
10refund01a1a8f8-92e6-7b79-b511-597c2c19a049-€2.00€0.00matched
11capture01a1a8f8-a0d0-77fe-8735-201f23fbfeb7€35.00€0.50matched
12capture01a1a8f8-a7a7-7dc6-b615-c7796539845e€15.00€0.26matched
13capture01a1a8f8-c2ee-724e-94ca-eae218c06bd7€24.00€0.37matched
14capture01a1a8f8-c43b-7b5c-bff7-6f1c92c4cca3€35.00€0.50matched
15capture01a1a8f8-ea14-7663-b69a-277f0866a41e€15.00€0.26matched
16refund01a1a8f8-fffe-78fe-a7ec-7eb282fc24ec-€15.00€0.00matched
17capture01a1a8f9-17e6-72d8-869e-85488a1de268€24.00€0.37matched
18capture01a1a8f9-23e9-73c7-875a-3aeaeb66444c€9.00€0.19matched
19capture01a1a8f9-36cc-7ee7-b69f-572e0563d4b7€35.00€0.50matched
20capture01a1a8f9-3b0f-7e21-a709-df904006ba5c€15.00€0.26matched
21capture01a1a8f9-43bb-7d0f-85ca-d62b83c7dc14€9.00€0.19matched
22capture01a1a8f9-4b51-7834-b3db-909c09dc2951€35.00€0.50matched
23capture01a1a8f9-7475-7049-b0ad-b463fc9e1dc0€9.00€0.19matched
24refund01a1a8f9-78a8-74ac-b0ff-439490b22d9c-€28.00€0.00matched
25capture01a1a8f9-8145-78b3-95b1-1c496cc96d3c€15.00€0.26matched
26capture01a1a8f9-8be6-745f-9f1e-59661b107513€49.00€0.67matched
27capture01a1a8f9-8f97-70f3-a7ee-6f776fd3e954€15.00€0.26matched
28capture01a1a8f9-e689-7689-8400-eca8a5fdaf72€24.00€0.37matched
29capture01a1a8fa-0943-78c8-9a9c-ef755d2c283e€35.00€0.50matched
30capture01a1a8fa-0e6b-7d09-814b-4a6d745d77e6€9.00€0.19matched
31capture01a1a8fa-177d-7f1a-abac-8da87202cbe8€15.00€0.26matched
32capture01a1a8fa-1a42-74a0-a218-c2f688af52f3€15.00€0.26matched
33capture01a1a8fa-2415-720b-9f78-5d2e99c7bb04€9.00€0.19matched
34capture01a1a8fa-2f1a-77da-9f74-74a88e1ddfba€49.00€0.67matched
35refund01a1a8fa-7d5b-789b-9bd5-6912e2d4a97e-€23.00€0.00matched
36capture01a1a8fa-a371-73e6-9f5e-dcfcaa004a03€15.00€0.26matched
37capture01a1a8fa-ad75-7f54-8ca7-836f79c0c621€15.00€0.26matched
38capture01a1a8fa-b926-7f6e-8523-53b905cace37€15.00€0.26matched
39capture01a1a8fa-c42c-70c1-af0a-041ef895e7ed€49.00€0.67matched
40capture01a1a8fa-ede6-7c07-86e9-a2fc07689761€15.00€0.26matched
41capture01a1a8fa-f394-70fc-811b-571e8115fc2a€24.00€0.37matched
42refund01a1a8fa-f9c5-7e24-b407-e09f6682edc9-€9.00€0.00matched
43capture01a1a8fb-1157-7555-ba60-913850f88c44€24.00€0.37matched
44capture01a1a8fb-252b-7181-a37e-b24d316417df€15.00€0.26matched
45capture01a1a8fb-4a65-76af-8081-f36118a70c0e€24.00€0.37matched
46capture01a1a8fb-52d3-7b29-87ff-b510ca243542€35.00€0.50matched
47capture01a1a8fb-5354-7a67-9bd2-3b7a85b671f9€35.00€0.50matched
48refund01a1a8fb-656d-7e14-bc3e-a21afdd9f0e9-€10.00€0.00matched
49capture01a1a8fb-778e-7c6e-a363-73729f6d33a9€15.00€0.26matched
50capture01a1a8fb-91f2-7cc0-aac0-6b54d86687ca€9.00€0.19matched
51capture01a1a8fb-ba64-7ff5-9270-d9715426c129€9.00€0.19matched
52capture01a1a8fb-c0e6-7ff8-b370-c94fc8a0a484€49.00€0.67matched
53capture01a1a8fb-e27a-7f08-bc02-4f12d454b604€35.00€0.50matched
54capture01a1a8fb-e746-789e-a0b1-54e9f652dcb4€49.00€0.67matched
55capture01a1a8fb-ea9b-7f49-8b37-9e3dbdc22a81€9.00€0.19matched
56capture01a1a8fb-f56c-7257-9b07-ca0e0b00efcd€35.00€0.50matched
57capture01a1a8fb-f5ad-7df1-8be7-84c71202755c€15.00€0.26matched
58capture01a1a8fb-f750-719f-bc46-c5bfb0eb85fc€9.00€0.19matched
59capture01a1a8fc-2ad1-79df-98e8-976a488be39e€35.00€0.50matched
60capture01a1a8fc-2cdb-7220-81a4-d00c75d83063€49.00€0.67matched
61capture01a1a8fc-2e38-7897-ba0e-c25fb6ae22b4€24.00€0.37matched
62capture01a1a8fc-2fdd-75df-ab93-849d68e3889c€9.00€0.19matched
63capture01a1a8fc-48cb-7999-bec6-a077a20e7e5e€24.00€0.37matched
64capture01a1a8fc-4cdc-7dbc-9f55-2cbdce89de1a€35.00€0.50matched
65capture01a1a8fc-5555-7a06-8caf-967146182744€9.00€0.19matched
66capture01a1a8fc-63cd-72af-97e4-865a98ccdc58€49.00€0.67matched
67capture01a1a8fc-7839-77f7-95f3-aac4998763e3€49.00€0.67matched
68capture01a1a8fc-79c5-7e70-add0-2ac96ec36d3e€15.00€0.26matched
69capture01a1a8fc-7bb8-73c4-9b9b-d5c7222c549b€49.00€0.67matched
70capture01a1a8fc-85b0-789b-a638-535aa90a1ace€24.00€0.37matched
71capture01a1a8fc-8e28-7ddd-958d-d312180f106c€35.00€0.50matched
72capture01a1a8fc-aa88-75a7-af7b-27a90bde1ecf€49.00€0.67matched
73capture01a1a8fc-b332-7735-8580-43d433e99703€9.00€0.19matched
74capture01a1a8fc-bbac-7069-97d6-97c9b4ea1589€15.00€0.26matched
75capture01a1a8fc-bfe2-70f0-a96e-9060edcfe36b€9.00€0.19matched
76capture01a1a8fc-c4d1-78e3-964a-c6261e828332€35.00€0.50matched
77capture01a1a8fc-f342-74e0-88d6-bbf26e09c8fd€15.00€0.26matched
78capture01a1a8fd-0f7b-759b-936f-e8b9cc815901€24.00€0.37matched
79capture01a1a8fd-144e-78c3-a4fc-9ac7c894eacd€15.00€0.26matched
81capture01a1a8fd-18e7-76bb-8c5b-97a065d94cad€15.00€0.26matched
82refund01a1a8fd-26f6-71aa-a443-5d79edc0519f-€27.00€0.00matched
84capture01a1a8fd-51b1-74fa-b71c-251722995508€49.00€0.67matched
85capture01a1a8fd-5653-7c6e-a31d-804b15f9a9bb€24.00€0.37matched
86capture01a1a8fd-72d2-7b3c-83e8-695d579fcd05€35.00€0.50matched
87capture01a1a8fd-86af-7ec2-8a29-01761edcaaa1€49.00€0.67matched
88capture01a1a8fd-97a2-7fcf-b223-d327df3beefb€15.00€0.26matched
89capture01a1a8fd-9854-77ea-a134-d2be57d22789€49.00€0.67matched
90capture01a1a8fd-c66d-7837-9dcf-943fbff1cb28€49.00€0.67matched
91capture01a1a8fd-c9c9-737d-a8e8-c763b3acb70f€35.00€0.50matched
92refund01a1a8fd-cbb0-776a-ab98-d015259fdd97-€11.00€0.00matched
93capture01a1a8fd-e7a7-7c21-ae1c-2b2d61f82e65€24.00€0.37matched
94capture01a1a8fd-eadd-7492-92d5-4d610f22284e€9.00€0.19matched
95capture01a1a8fd-f004-7b38-95cc-d3084b3cec22€24.00€0.37matched
96capture01a1a8fe-0011-7836-9774-cc3c63ff9a89€49.00€0.67matched
97capture01a1a8fe-1f37-74d3-aff0-e2a42438add3€35.00€0.50matched
98capture01a1a8fe-2b5b-7776-8c6a-a2380c4680df€9.00€0.19matched
99capture01a1a8fe-2cc1-79f5-96f5-0dad0c37c3bc€24.00€0.37matched
100capture01a1a8fe-35e4-76b6-80e8-7f0abe22daeb€15.00€0.26matched
101capture01a1a8fe-3d73-7557-9c6b-62d074c493a5€24.00€0.37matched
102capture01a1a8fe-554c-7f5f-901b-a5682680ff62€9.00€0.19matched
103capture01a1a8fe-5f48-7e70-b4fa-98f6980f88ec€24.00€0.37matched
104capture01a1a8fe-7a9f-761b-81e3-d915e029d4df€49.00€0.67matched
105refund01a1a8fe-b4f4-7f7c-9c74-606c4fddef58-€8.00€0.00matched
106capture01a1a8fe-b559-7622-8530-6435190aa177€49.00€0.67matched
107capture01a1a8fe-dc8c-72b2-aef0-1b9f77afcdfb€35.00€0.50matched
108capture01a1a8fe-ed48-7176-84c3-ea28d9346e29€24.00€0.37matched
109capture01a1a8fe-fb41-7991-a90b-ecba79bf5739€35.00€0.50matched
110capture01a1a8fe-ffad-7130-b855-f8673871a6cf€49.00€0.67matched
111capture01a1a8ff-0252-71df-9a53-8efe930734a2€9.00€0.19matched
112capture01a1a8ff-0291-7a79-a583-d2813a7ebde8€9.00€0.19matched
113capture01a1a8ff-2ba6-7f80-a317-e7e565039853€49.00€0.67matched
114capture01a1a8ff-37ea-77d9-8d36-b955eff784a3€9.00€0.19matched
115capture01a1a8ff-3952-72fa-86cf-513fdd3bb301€15.00€0.26matched
116capture01a1a8ff-4051-7bfe-9b03-ec4dde6a858a€49.00€0.67matched
117capture01a1a8ff-4735-770d-a0ba-4fe4a9f6cc36€24.00€0.37matched
118capture01a1a8ff-48a6-734e-9f67-e41da4ff1e6c€49.00€0.67matched
119capture01a1a8ff-4d62-7dbb-a25f-0bca7d2bca4e€24.00€0.37matched
120capture01a1a8ff-8227-78cf-97d0-b6f48cde1d27€9.00€0.19matched
121capture01a1a8ff-8672-71e3-87c2-ab46356bad5e€9.00€0.19matched
122capture01a1a8ff-84d7-75aa-9291-d8f76ec17826€24.00€0.37matched
123capture01a1a8ff-955e-777e-8bcb-87975c251657€15.00€0.26matched
124capture01a1a8ff-a830-7c3b-80ef-beae3135f9b3€15.00€0.26matched
125capture01a1a8ff-a8c1-74c2-be0b-63d1df655781€15.00€0.26matched
126capture01a1a8ff-c396-75c7-a5b6-0f2304652713€15.00€0.26matched
127capture01a1a8ff-c9ed-7a5b-8102-920058740307€35.00€0.50matched
128capture01a1a8ff-cc74-7087-bb7d-db62cac8de31€35.00€0.50matched
129capture01a1a8ff-f88b-7043-9155-707b24858cc5€9.00€0.19matched
130capture01a1a8ff-fa7b-79f6-9472-ac98b660ac88€24.00€0.37matched
131capture01a1a900-0d28-73c6-b1ed-5bd603811ce1€49.00€0.67matched
132capture01a1a900-33b4-7469-b7ca-8cdf6e7e456c€35.00€0.50matched
133capture01a1a900-511e-7210-8804-636a402efbb9€15.00€0.26matched
134capture01a1a900-752d-79b5-b714-d3e6ae25fe07€35.00€0.50matched
135capture01a1a900-725f-763d-8fb1-35be94d8c39d€49.00€0.67matched
136capture01a1a900-b8aa-7e91-b3a2-64304ab93739€24.00€0.37matched
137capture01a1a900-ce36-75ae-9515-4b28aa7089dc€35.00€0.50matched
138capture01a1a900-dd3e-7c0e-bd4b-772f66f71381€24.00€0.37matched
139capture01a1a900-fa25-7a71-adb8-9da2b164ea2e€24.00€0.37matched
140capture01a1a901-340d-7c7e-a88e-f51c411890af€24.00€0.37matched
141capture01a1a901-4eac-78a0-a2f2-a0218f1202a6€49.00€0.67matched