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

Gross

€2,890.00

PSP fee

€44.89

Net to the bank

€2,845.11

Settlement journal

#383253

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a7ac-88e5-7374-b5d0-641543a88c3e is already settled by stl_EUR_2989690 line 89
  • fee differencethe fee is not the contract feethe fee is 42, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
  • 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 69, the contract says 67
LineKindReferenceGrossFeeStatus
20capture01a1a7a7-11f8-7b23-ada4-ae4353aaf5da€24.00€0.42fee difference
24capture01a1a7a7-6571-7fbc-b54f-47ba4f168407€35.00€0.54fee difference
46capture01a1a7a8-e721-764b-bbcd-daed581269b5€24.00€0.39fee difference
84capture01a1a7ac-0c39-7aa1-a1d9-5534ef2eedee€49.00€0.69fee difference
90capture01a1a7ac-8910-78ed-a857-4d838af2fe8e€49.00€0.67duplicate line
1capture01a1a79f-9ca8-7589-bd4b-4c0c152bc86c€35.00€0.50matched
2capture01a1a79f-edc1-7f31-9566-8ad8519461e8€15.00€0.26matched
3capture01a1a7a5-b2f6-73f8-84f9-53ce6627fcbf€9.00€0.19matched
4capture01a1a7a5-c872-7351-8608-03b5af8c5c8d€49.00€0.67matched
5capture01a1a7a5-d084-7048-86c1-8c5273f4f3ee€35.00€0.50matched
6capture01a1a7a5-dd89-7938-8acd-b725476b4788€35.00€0.50matched
7capture01a1a7a5-e328-7a4a-9300-e0ff59b5f72f€49.00€0.67matched
8capture01a1a7a5-f6eb-7900-b3ce-e26d5aaf0fba€24.00€0.37matched
9refund01a1a7a6-268a-78e0-bd36-786f070fe964-€20.00€0.00matched
10capture01a1a7a6-373d-7951-905c-f283867ddd70€24.00€0.37matched
11capture01a1a7a6-440c-79c3-b737-4b7c2d41210b€35.00€0.50matched
12refund01a1a7a6-65a6-722c-9016-0913c9d7ab78-€19.00€0.00matched
13capture01a1a7a6-796a-7a3d-aeec-893c9c943b76€9.00€0.19matched
14capture01a1a7a6-9ab8-7826-ae80-e692d5298fdb€49.00€0.67matched
15capture01a1a7a6-9c33-783a-bb2a-1b933d15b0c5€49.00€0.67matched
16capture01a1a7a6-9dbb-71f3-a8ac-3a0cbb7cd5aa€35.00€0.50matched
17capture01a1a7a6-dae5-756f-8ce3-57f13b1f88e2€9.00€0.19matched
18capture01a1a7a6-f1ba-7ebb-b34d-667da8bb7db3€15.00€0.26matched
19capture01a1a7a7-116d-7cd5-9980-c40c99eac7c1€9.00€0.19matched
21capture01a1a7a7-4f3f-73f3-826b-5ceda15178ba€15.00€0.26matched
22capture01a1a7a7-5b79-7abb-998b-a384ae303b38€35.00€0.50matched
23capture01a1a7a7-5fcc-7b6f-81d6-09f5da1e6b34€9.00€0.19matched
25capture01a1a7a7-72fb-7952-9e7d-20a1e88381a3€35.00€0.50matched
26capture01a1a7a7-7bfa-79d4-b2f9-a373a4c88140€35.00€0.50matched
27capture01a1a7a7-7c1d-7e44-a129-e379f9f3e479€24.00€0.37matched
28refund01a1a7a7-7f63-7ff4-a80e-452c8575ef58-€9.00€0.00matched
29capture01a1a7a7-80aa-742d-816d-ba9733bd28e9€35.00€0.50matched
30capture01a1a7a7-89f6-7e9c-b29b-c34136c99099€9.00€0.19matched
31capture01a1a7a7-97b8-75b1-86f5-582e5ddeffea€49.00€0.67matched
32capture01a1a7a7-9a9e-761d-a3f0-ec154a8a10f4€24.00€0.37matched
33capture01a1a7a7-cb04-7a31-ab46-9d0691221ec0€35.00€0.50matched
34capture01a1a7a7-cef5-7d3b-93c8-643764903e93€49.00€0.67matched
35capture01a1a7a7-d2cb-755c-952e-74c628c78c23€49.00€0.67matched
36capture01a1a7a7-d575-7158-a6ba-f57f1fbdf5ec€35.00€0.50matched
37capture01a1a7a7-f03b-7e3e-969f-4e2125a9ea22€35.00€0.50matched
38capture01a1a7a8-3c43-783e-be3b-ba248ba0d6ae€35.00€0.50matched
39capture01a1a7a8-60fa-7f60-ab6f-0b1b2332c119€49.00€0.67matched
40capture01a1a7a8-80f0-748f-9296-674f4da8e0e7€35.00€0.50matched
41capture01a1a7a8-981e-79c8-b64d-d7b0720fd469€35.00€0.50matched
42capture01a1a7a8-9926-7a05-aea2-d50a09a0c649€9.00€0.19matched
43capture01a1a7a8-bdf3-720a-a441-6678ad82fb60€24.00€0.37matched
44capture01a1a7a8-c1b3-7f39-8296-b372982ac6cb€9.00€0.19matched
45capture01a1a7a8-cd89-7183-9ec4-b147e4790747€15.00€0.26matched
47refund01a1a7a9-0b7b-7545-905a-5252b4b40e4e-€8.00€0.00matched
48capture01a1a7a9-0be5-75d7-9706-b5cd0313798f€35.00€0.50matched
49capture01a1a7a9-0d6f-7125-a4c6-37d5412df950€9.00€0.19matched
50capture01a1a7a9-2acb-7f05-93ed-226a435a0920€24.00€0.37matched
51capture01a1a7a9-33ac-733f-a5c5-01a2a8e3f6ac€35.00€0.50matched
52capture01a1a7a9-67a7-7476-9357-447bbd683fb4€9.00€0.19matched
53capture01a1a7a9-6a91-7f55-9cba-ad675ab63625€49.00€0.67matched
54refund01a1a7a9-7357-79f9-b6db-a5bbfb489c26-€24.00€0.00matched
55capture01a1a7a9-8ba5-75aa-82e7-0b6653a1bbe9€9.00€0.19matched
56capture01a1a7a9-c72a-780c-8e37-87f7676e6ff2€15.00€0.26matched
57capture01a1a7a9-ceb4-7024-b0dc-cd98c829cf9e€24.00€0.37matched
58capture01a1a7a9-d0fb-7203-98a4-22e31e27d3bb€15.00€0.26matched
59capture01a1a7a9-d3fb-7d2c-bf10-b69c7a482d53€24.00€0.37matched
60capture01a1a7aa-16c2-749f-9369-71ed29efb332€15.00€0.26matched
61capture01a1a7aa-2cfb-74a8-9bc8-8e1f8c3af1fc€35.00€0.50matched
62capture01a1a7aa-2e7e-7f67-a184-714266af140a€9.00€0.19matched
63capture01a1a7aa-2fec-71c7-b329-70fe57b22869€49.00€0.67matched
64capture01a1a7aa-5e9f-7fcf-8225-1f39bec7702b€24.00€0.37matched
65capture01a1a7aa-72f3-750c-bcda-fc2e44412d34€35.00€0.50matched
66capture01a1a7aa-793d-79dc-9e62-7be46a1773b5€35.00€0.50matched
67capture01a1a7aa-8646-7680-a880-39dde5f80605€49.00€0.67matched
68capture01a1a7aa-91b4-7828-a21f-c732709eaa3e€24.00€0.37matched
69capture01a1a7aa-965f-7658-ab43-1c457225da95€9.00€0.19matched
70capture01a1a7aa-9680-73e2-a637-698942bfcf64€24.00€0.37matched
71capture01a1a7aa-9aa5-76a4-96a4-e975e2430bab€35.00€0.50matched
72capture01a1a7aa-9c5c-786d-a9f3-e154cb8aeb2f€35.00€0.50matched
73capture01a1a7aa-bea7-7919-86c2-73c00377ed93€15.00€0.26matched
74capture01a1a7aa-c619-714b-bb56-447ebbc150e6€49.00€0.67matched
75capture01a1a7aa-dfc3-733b-b044-2871142cb4ab€49.00€0.67matched
76capture01a1a7aa-e825-76a8-886a-3dd6e2024bfe€49.00€0.67matched
77capture01a1a7aa-febf-7a36-8928-906b8a9c21e4€24.00€0.37matched
78capture01a1a7ab-1e86-7a28-bb88-ef39934e31c5€49.00€0.67matched
79capture01a1a7ab-2e6b-7803-bf68-ccbaa94ecb5c€15.00€0.26matched
80capture01a1a7ab-6b05-798c-b3e5-e202eb18a0f2€9.00€0.19matched
81capture01a1a7ab-7853-7836-a981-a6432d08f84d€24.00€0.37matched
82capture01a1a7ab-8167-7c83-9128-cfefbb821c35€24.00€0.37matched
83capture01a1a7ab-88a3-720a-b529-ec046d557147€35.00€0.50matched
85capture01a1a7ac-10b0-72f9-b74c-7e0e87c171c6€24.00€0.37matched
86capture01a1a7ac-3c97-7f24-8e19-91732adb8cee€35.00€0.50matched
87capture01a1a7ac-5113-70b1-9d9a-0bbceba7cd81€24.00€0.37matched
88capture01a1a7ac-8452-7651-9545-c9e8178c4e73€49.00€0.67matched
89capture01a1a7ac-8910-78ed-a857-4d838af2fe8e€49.00€0.67matched
91refund01a1a7ac-b982-7669-8aeb-21ab7e26b1e9-€40.00€0.00matched
92capture01a1a7ac-d2fe-7dba-8b88-96c37da7f8d2€35.00€0.50matched
93capture01a1a7ac-e0d8-73c4-8f27-e617bef91649€35.00€0.50matched
94capture01a1a7ad-4004-71e3-9f0e-694d3e6dd7c4€49.00€0.67matched
95capture01a1a7ad-6728-7878-a3f7-901b759dbec4€49.00€0.67matched
96capture01a1a7ad-99e5-730f-85b2-4eddf1a22a0d€9.00€0.19matched
97capture01a1a7ad-bb92-7f5e-9a01-9c1e1454173d€35.00€0.50matched
98capture01a1a7ad-cde4-7fab-aaaf-80f7fb08d6fb€9.00€0.19matched
99capture01a1a7ad-d854-7d72-b127-b5191421bf6e€24.00€0.37matched
100capture01a1a7ad-e4a2-76cf-8476-042191dde48e€35.00€0.50matched
101refund01a1a7ad-f75e-7563-ba45-fd2aded1ae76-€3.00€0.00matched
102capture01a1a7ad-f4bc-763c-ba9a-94ecea3f283b€9.00€0.19matched
103capture01a1a7ad-fdd5-7eae-9bc8-8673f9690720€24.00€0.37matched
104capture01a1a7ae-1c9d-703c-89ba-3b13932fa555€24.00€0.37matched
105capture01a1a7ae-3707-7b91-83bb-76445f71959e€15.00€0.26matched
106capture01a1a7ae-4380-7e22-8186-91962c743d48€15.00€0.26matched
107capture01a1a7ae-4571-781e-b818-7ae18d0924fb€49.00€0.67matched
108capture01a1a7ae-4992-7567-a19c-3b34c2e18b2f€15.00€0.26matched
109capture01a1a7ae-4ac2-72e5-a5aa-98388f25cd17€15.00€0.26matched
110capture01a1a7ae-5278-709b-97c3-e63b81453bef€35.00€0.50matched
111capture01a1a7ae-5d5d-7992-bbe6-013520a0fa6e€9.00€0.19matched
112capture01a1a7ae-6770-7908-9fcd-16ec112a51e0€15.00€0.26matched
113capture01a1a7ae-969e-7eb4-a475-6baa6b41f5a4€9.00€0.19matched