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

2 Nov, 02:20

Gross

€2,924.00

PSP fee

€48.26

Net to the bank

€2,875.74

Settlement journal

#335142

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19a0f-1b69-74bb-9523-f26e4530f9ff is already settled by stl_EUR_2989310 line 12
  • duplicate linethe file lists it twicerefund:01a19a17-6eab-7224-bf8c-aac466c9f1c8 is already settled by stl_EUR_2989310 line 135
  • fee differencethe fee is not the contract feethe fee is 27, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 41, the contract says 37
LineKindReferenceGrossFeeStatus
13capture01a19a0f-1bc4-7f0e-8376-573b1f174449€15.00€0.26duplicate line
19capture01a19a0f-68b0-7da4-a601-d2c388058c96€15.00€0.27fee difference
64capture01a19a12-1f56-7c4e-86c8-495a3f559f80€9.00€0.20fee difference
136refund01a19a17-6ead-7033-b1e0-e3ad21da6909-€20.00€0.00duplicate line
1capture01a19a0a-ae75-7595-984d-e4270d7eca07€15.00€0.26matched
2refund01a19a0e-7230-764a-8965-8e041a1c3cd0-€15.00€0.00matched
3capture01a19a0e-97b4-7bda-b4a9-e702d7b32819€24.00€0.37matched
4capture01a19a0e-9adb-7fb2-8cd5-611443de2412€49.00€0.67matched
5capture01a19a0e-aea2-7537-a105-e3d7f762ae8e€9.00€0.19matched
6capture01a19a0e-ba7a-73dd-802c-43de0c799ee2€15.00€0.26matched
7capture01a19a0e-fa5a-72ff-9f87-08b95213ee17€24.00€0.37matched
8capture01a19a0f-0e1e-7353-8438-be7ba294f3eb€9.00€0.19matched
9capture01a19a0f-0e3d-7265-b2bc-ac39a3cab418€49.00€0.67matched
10capture01a19a0f-117d-71dd-9456-35fd2910661d€15.00€0.26matched
11capture01a19a0f-1894-7842-b34c-5f9947eba63f€9.00€0.19matched
12capture01a19a0f-1bc4-7f0e-8376-573b1f174449€15.00€0.26matched
14capture01a19a0f-1f51-78ef-be26-6146b4e73d2b€15.00€0.26matched
15capture01a19a0f-2a92-73d5-b475-285216fdb558€49.00€0.67matched
16refund01a19a0f-32ef-7365-894b-aaa2f5648ce2-€21.00€0.00matched
17capture01a19a0f-4f54-78aa-aa10-fdf5e2932611€15.00€0.26matched
18capture01a19a0f-5e12-7c49-8f7c-d154fd24063e€15.00€0.26matched
20capture01a19a0f-6078-7ba0-9255-83cb00c5dabe€49.00€0.67matched
21capture01a19a0f-6d9a-7266-959b-4c38e820d05e€9.00€0.19matched
22capture01a19a0f-8a87-74a7-b3b1-c2f2e1d3c56c€9.00€0.19matched
23capture01a19a0f-9e82-7d45-8ddb-f0200d5e9f7a€24.00€0.37matched
24capture01a19a0f-a2be-7bb3-bab5-0fe45c91e6a0€24.00€0.37matched
25capture01a19a0f-be07-7e04-b8c3-34dbb35edba2€9.00€0.19matched
26capture01a19a0f-be80-7bb3-bb2d-1ebbbc2962da€24.00€0.37matched
27capture01a19a0f-c268-77c7-9b36-11ab1a6641e2€9.00€0.19matched
28refund01a19a0f-c936-72c1-821d-eda694e1136b-€17.00€0.00matched
29refund01a19a0f-d2ad-7fb2-9c1a-9370c5fa6ec3-€9.00€0.00matched
30capture01a19a0f-df4a-77fe-919c-96ad4384b081€35.00€0.50matched
31capture01a19a0f-f71f-7593-ba85-2aec6ee10bb9€49.00€0.67matched
32capture01a19a10-19f8-7d11-b84c-890481a1f133€35.00€0.50matched
33capture01a19a10-2a61-7a6e-a8d9-0e54cc189a87€49.00€0.67matched
34capture01a19a10-3341-773f-9eab-af43e4a9ed0a€35.00€0.50matched
35capture01a19a10-452d-7994-9277-cf30ea324b5e€35.00€0.50matched
36capture01a19a10-49a7-7736-8df5-9689c894ed83€9.00€0.19matched
37capture01a19a10-53e5-7e5a-b405-1590247de78a€24.00€0.37matched
38capture01a19a10-7e97-7370-b146-980a9654aee6€15.00€0.26matched
39refund01a19a10-8b08-751f-8daa-997821183379-€30.00€0.00matched
40refund01a19a10-8e4f-7c1a-b53a-c233108d3937-€17.00€0.00matched
41capture01a19a10-a682-797a-a894-123cde6a1c5b€15.00€0.26matched
42capture01a19a10-af96-7955-9897-24607112663a€9.00€0.19matched
43capture01a19a10-b564-7604-9a65-cb0344f15ca1€35.00€0.50matched
44capture01a19a10-bbaf-7263-bf81-06d48f885051€35.00€0.50matched
45capture01a19a10-c8bb-7bd2-8cb1-e147807b240c€9.00€0.19matched
46capture01a19a10-e45b-751c-8f16-05bb2d3b3b09€35.00€0.50matched
47capture01a19a10-f717-71f3-bacc-6942303a6fd6€15.00€0.26matched
48capture01a19a10-fb46-7486-9b8b-45cae63c42a6€35.00€0.50matched
49capture01a19a10-f753-743a-96de-fa8a3c284714€9.00€0.19matched
50capture01a19a11-1052-7cf3-90d8-a3fc364195d9€49.00€0.67matched
51capture01a19a11-1de3-734f-afb2-932a1c7a4819€35.00€0.50matched
52capture01a19a11-221e-7cd7-bba3-96ed50fba0e0€49.00€0.67matched
53capture01a19a11-23f1-75a6-9505-0f0c2ae6430d€35.00€0.50matched
54capture01a19a11-43b4-7ca1-a6eb-bd3450f664fc€24.00€0.37matched
55refund01a19a11-737c-7d2b-9f4d-8dbada3c5c40-€43.00€0.00matched
56capture01a19a11-a80d-7173-a1b4-51da4eaa1d03€24.00€0.37matched
57capture01a19a11-ad64-73b9-a359-9bb84235887f€15.00€0.26matched
58capture01a19a11-b518-78c9-b947-67f72013e9cc€49.00€0.67matched
59capture01a19a11-d5e9-7efe-ac30-ee06c05ce507€15.00€0.26matched
60capture01a19a12-0447-7da2-88a2-9d2a886830ec€49.00€0.67matched
61capture01a19a12-0882-7e59-9c85-34de7a76d4cf€9.00€0.19matched
62capture01a19a12-096d-7dbf-a115-bf2ba8e21995€15.00€0.26matched
63capture01a19a12-0922-762d-a6f9-4e44dd8db031€15.00€0.26matched
65capture01a19a12-1ec3-724d-84bc-611ce4b2c7f1€24.00€0.37matched
66capture01a19a12-32d4-71b4-b6d5-c6565701bb4d€35.00€0.50matched
67capture01a19a12-3683-79fa-94e5-6a6c1dbf842e€15.00€0.26matched
68capture01a19a12-3f26-7df6-a29e-29573e69ac2e€24.00€0.37matched
69capture01a19a12-6034-7c43-b625-bbf124a3d0eb€15.00€0.26matched
70refund01a19a12-6112-7867-b036-9881acfb6413-€7.00€0.00matched
71capture01a19a12-65f9-7d8f-b9bc-7d8c64888c4c€24.00€0.37matched
72capture01a19a12-75a7-7df3-a09b-df3cde603cc4€15.00€0.26matched
73capture01a19a12-7fa6-76cc-8326-3c5ca6b29b93€24.00€0.37matched
74capture01a19a12-ab70-707d-b784-01f16d95f19f€15.00€0.26matched
75capture01a19a12-bf0e-7ffe-aa46-fe0d765b3a47€35.00€0.50matched
76capture01a19a12-ccb5-78a9-bb2d-42a1e82eeae2€9.00€0.19matched
77capture01a19a12-da63-7385-9f6c-0616a5b01df8€15.00€0.26matched
78capture01a19a12-db86-7bc5-9e54-bd21f3acc0e5€9.00€0.19matched
79capture01a19a13-0da0-7bb5-9bda-06791ff6dd6f€24.00€0.37matched
80refund01a19a13-1ce6-7e09-ba77-aa1029e2a2ef-€2.00€0.00matched
81capture01a19a13-23c0-73bf-ad09-e13cd596ccba€9.00€0.19matched
82capture01a19a13-2822-7aa8-936f-8ddd94c5532f€24.00€0.37matched
83capture01a19a13-3db5-738c-bf6f-9cc8982b4a12€35.00€0.50matched
84capture01a19a13-44ed-7568-89bf-229497081fb4€35.00€0.50matched
85capture01a19a13-6ff6-7e50-bc61-a87159ef6881€15.00€0.26matched
86capture01a19a13-a3e0-73a7-85f4-e525c4a8d3ab€24.00€0.37matched
87capture01a19a13-e64e-7ed5-9306-caa02585c7a1€9.00€0.19matched
88capture01a19a13-e856-7cfc-8e60-dad016bc9333€15.00€0.26matched
89capture01a19a14-0c8f-78e9-abbe-b9ae87c6e625€9.00€0.19matched
90capture01a19a14-1792-76c4-adbc-b2c49573a557€15.00€0.26matched
91capture01a19a14-201a-7539-af4e-d69f38264829€49.00€0.67matched
92capture01a19a14-3f13-73ea-9f44-c476690168c4€49.00€0.67matched
93refund01a19a14-55e0-74f9-948f-999d30f38d9c-€6.00€0.00matched
94capture01a19a14-6e1d-77a5-a5e1-9212afc55b65€49.00€0.67matched
95capture01a19a14-75aa-7ecb-a483-6cc1b80ab1ec€49.00€0.67matched
96capture01a19a14-867b-7819-aa69-47b86248e139€9.00€0.19matched
97capture01a19a14-925e-7613-8f43-11a842369cf3€9.00€0.19matched
98capture01a19a14-b3db-70c6-b999-64bd80ba6aa4€49.00€0.67matched
99capture01a19a14-cb10-734f-b980-38989b14bb0d€24.00€0.37matched
100capture01a19a14-ce0a-7e9e-bae6-7a1e45b5ff85€49.00€0.67matched
101capture01a19a14-e375-72eb-a922-e48f23dcb7f9€9.00€0.19matched
102capture01a19a15-1601-7674-a2c9-2d4ea9f8a5b0€49.00€0.67matched
103capture01a19a15-18e5-72db-b8f1-7d1eafc2906b€24.00€0.37matched
104capture01a19a15-248e-7a4a-800c-6222edc562d0€35.00€0.50matched
105refund01a19a15-24b8-7614-ba39-a44f48c49c57-€19.00€0.00matched
106capture01a19a15-2858-753f-b75f-e4b7b1e8b5f2€35.00€0.50matched
107capture01a19a15-3d9c-7f91-9d68-d91bba75c683€15.00€0.26matched
108capture01a19a15-46ac-79ba-bd3f-e716143e8a44€15.00€0.26matched
109capture01a19a15-5d90-755f-bc11-bb0b15cb856d€49.00€0.67matched
110capture01a19a15-6232-7c8e-803c-20f7d2c3c65f€9.00€0.19matched
111capture01a19a15-9e3b-7307-8978-acc6b14df9c3€49.00€0.67matched
112capture01a19a15-a6d0-7555-bbf5-246e8d9f69b9€9.00€0.19matched
113refund01a19a15-d99f-7751-8d36-88691d3c9a90-€38.00€0.00matched
114capture01a19a16-1a1f-748f-8b89-95c87427c5d0€35.00€0.50matched
115capture01a19a16-22b3-78d8-82bf-aa40a616d76e€35.00€0.50matched
116capture01a19a16-684f-73aa-9993-f2465f44ac9f€49.00€0.67matched
117capture01a19a16-7d44-7d6e-8711-504529dabd18€35.00€0.50matched
118capture01a19a16-8fcd-777e-884e-9605e5166f91€24.00€0.37matched
119capture01a19a16-d260-7ea9-8241-45206424913e€24.00€0.37matched
120capture01a19a16-d951-7019-a043-a5f4d26a9032€15.00€0.26matched
121capture01a19a16-e246-7e24-a06a-888d92b61753€9.00€0.19matched
122capture01a19a16-ee71-75e8-b156-a38d75f67766€49.00€0.67matched
123capture01a19a17-00a2-72a5-805a-d9df74fdabde€35.00€0.50matched
124capture01a19a17-0284-7092-85ac-0223a8f0b400€49.00€0.67matched
125capture01a19a17-046e-7eb9-b987-88f52aec56b5€24.00€0.37matched
126capture01a19a17-064b-7fb7-a633-b9f4fc0859e6€35.00€0.50matched
127capture01a19a17-0917-737d-8afd-00da2a98c31f€49.00€0.67matched
128capture01a19a17-0d83-79a0-8636-02144f38d167€49.00€0.67matched
129capture01a19a17-284c-7987-bf5a-91ccd34424e4€49.00€0.67matched
130capture01a19a17-2f21-7a77-b0b9-5bb103a27476€35.00€0.50matched
131capture01a19a17-3821-7c29-b008-def65f41e708€9.00€0.19matched
132capture01a19a17-3b1a-7aa1-8e15-aa44855a17ae€9.00€0.19matched
133capture01a19a17-4123-7d3a-a44c-b2a6c29f8345€35.00€0.50matched
134capture01a19a17-5ec3-75ed-9223-06fbb604d959€15.00€0.26matched
135refund01a19a17-6ead-7033-b1e0-e3ad21da6909-€20.00€0.00matched
137capture01a19a17-726d-790c-8126-f9ecdc3d5c99€24.00€0.37matched