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

5 Nov, 03:30

Gross

€2,322.00

PSP fee

€37.12

Net to the bank

€2,284.88

Settlement journal

#390815

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a9c7-6cc4-7162-bf54-06c01fceffe1 is already settled by stl_EUR_2989749 line 64
LineKindReferenceGrossFeeStatus
65capture01a1a9c7-6ce2-7271-8bd4-c8f4afd67739€49.00€0.67duplicate line
1capture01a1a9c1-af21-77bd-9498-45da1833fe24€24.00€0.37matched
2capture01a1a9c1-b48b-7cfe-ab70-f6492fe3a814€24.00€0.37matched
3capture01a1a9c1-c7a4-73a3-8855-b441e26f5f4c€9.00€0.19matched
4capture01a1a9c1-cc9a-7f85-99f9-302b44af3c9f€35.00€0.50matched
5capture01a1a9c1-ccec-7bfc-affb-e9aff16f71d6€35.00€0.50matched
6capture01a1a9c1-d567-7e32-afbe-b5b2448f7715€49.00€0.67matched
7capture01a1a9c1-e538-7578-8f8e-e5b5f5c66a02€49.00€0.67matched
8capture01a1a9c1-fc21-7fd0-b9c4-5d69ad77b8c5€24.00€0.37matched
9capture01a1a9c1-fca4-7601-b135-87bcd0a06644€9.00€0.19matched
10refund01a1a9c2-01e9-7313-ac65-777d5f43690b-€3.00€0.00matched
11capture01a1a9c2-4faf-7e39-84a9-f8737e0c6b15€24.00€0.37matched
12capture01a1a9c2-66a0-7c1d-b693-b1104c3481c1€35.00€0.50matched
13capture01a1a9c2-6e7b-7b3c-8469-ba84b2926b4a€15.00€0.26matched
14capture01a1a9c2-6f26-7998-9f72-1743b4fae58b€49.00€0.67matched
15capture01a1a9c2-be80-79f1-aecf-1e085b7b30e4€24.00€0.37matched
16capture01a1a9c2-c05a-727b-a5ea-c021576418c6€49.00€0.67matched
17capture01a1a9c2-e45a-78d6-a0aa-5cdb1dec52e7€9.00€0.19matched
18capture01a1a9c3-14bb-7dcd-9ef0-cc3e86fbad31€15.00€0.26matched
19capture01a1a9c3-7c3a-7f6b-b4c7-44631a3520ab€35.00€0.50matched
20capture01a1a9c3-7c95-7a59-909b-6c4a825447d6€35.00€0.50matched
21capture01a1a9c3-b969-7619-b4e1-cfaaced9850e€49.00€0.67matched
22capture01a1a9c3-da70-75c9-8665-bfe0cf8aaf04€9.00€0.19matched
23capture01a1a9c3-ec07-709d-86c9-2379432f5600€49.00€0.67matched
24capture01a1a9c3-f6c1-7248-bd3b-99734a6b9a45€49.00€0.67matched
25capture01a1a9c4-5b86-7b4a-b27f-25e4028d9d5f€35.00€0.50matched
26capture01a1a9c4-6e55-799b-83c6-604d6c895d6c€35.00€0.50matched
27capture01a1a9c4-8678-7738-8cea-d899bfc653ad€24.00€0.37matched
28capture01a1a9c4-968b-7a81-93db-d630d81efa92€24.00€0.37matched
29capture01a1a9c4-b442-7497-a979-2732623c8d4f€9.00€0.19matched
30capture01a1a9c4-cbde-7a91-b4c9-28abf7570048€9.00€0.19matched
31capture01a1a9c4-d51b-76ca-a789-944c11af8589€49.00€0.67matched
32capture01a1a9c4-db96-76b3-b398-df2e47db62ea€35.00€0.50matched
33capture01a1a9c4-e456-71df-a2f7-d334d9283092€15.00€0.26matched
34capture01a1a9c5-107b-71a8-805a-bebe2564e7e1€35.00€0.50matched
35capture01a1a9c5-3e80-7771-95fa-3d7c1a666306€9.00€0.19matched
36refund01a1a9c5-7a7b-7420-b1c0-7d294b5606dc-€10.00€0.00matched
37capture01a1a9c5-88a7-7d56-8ef9-700d0f7e4964€9.00€0.19matched
38capture01a1a9c5-fc6b-7722-b692-8f6e63a89c9e€15.00€0.26matched
39capture01a1a9c6-36f1-71e8-977f-2153f3acdd76€49.00€0.67matched
40capture01a1a9c6-3871-7269-83ae-44b8ba046071€24.00€0.37matched
41capture01a1a9c6-503a-7f42-bd4c-aae43e1a5b13€9.00€0.19matched
42capture01a1a9c6-6006-7f89-96dd-9af01fe2972e€49.00€0.67matched
43capture01a1a9c6-600f-7c19-b222-046a71117e77€9.00€0.19matched
44capture01a1a9c6-62b1-7e6b-bffe-00c6a991f1d8€9.00€0.19matched
45capture01a1a9c6-67b0-73df-b792-926584737ea8€24.00€0.37matched
46capture01a1a9c6-7554-7f9e-bf28-ea53613edbe8€35.00€0.50matched
47capture01a1a9c6-7bde-7ec2-b0d1-cbc002827e75€15.00€0.26matched
48capture01a1a9c6-94b3-7c87-a5b4-dbdb83944420€9.00€0.19matched
49capture01a1a9c6-b03c-70af-89ae-5e0a58ab8605€9.00€0.19matched
50capture01a1a9c6-b3c7-75a9-adab-b2f49952ce6c€35.00€0.50matched
51capture01a1a9c6-b7b0-7c7c-bd42-0b021c0c5329€15.00€0.26matched
52capture01a1a9c6-b9a1-773e-948c-3dc86a97968c€35.00€0.50matched
53capture01a1a9c6-cb22-70f7-9dd5-187f91b999f7€24.00€0.37matched
54refund01a1a9c6-d4bd-7014-b025-54951c45fc02-€5.00€0.00matched
55capture01a1a9c6-e046-7a77-8e66-6ac69244fb4f€49.00€0.67matched
56refund01a1a9c6-f7b4-7bfa-82b1-f488bfbd2429-€32.00€0.00matched
57refund01a1a9c6-f9d7-7d0d-828a-f0bda6783f1c-€21.00€0.00matched
58capture01a1a9c7-2c5e-7a75-a16a-a37625e09439€15.00€0.26matched
59capture01a1a9c7-2cab-7db2-b65b-4c9fc244ef1c€49.00€0.67matched
60capture01a1a9c7-393f-7573-9db1-a231174ce78b€15.00€0.26matched
61capture01a1a9c7-41ee-702a-83cd-9694dbb3b047€9.00€0.19matched
62capture01a1a9c7-54ed-751d-9f5a-138b23d58e93€15.00€0.26matched
63capture01a1a9c7-67ea-76af-9611-5523b98d365c€9.00€0.19matched
64capture01a1a9c7-6ce2-7271-8bd4-c8f4afd67739€49.00€0.67matched
66capture01a1a9c7-6f20-7a6c-a998-cfc2b4aa0cfb€49.00€0.67matched
67capture01a1a9c7-8f48-7653-ae6a-40682797557c€9.00€0.19matched
68capture01a1a9c7-a6ba-7146-ad93-8d88f21e5f5c€15.00€0.26matched
69capture01a1a9c7-b26a-7d35-b1d7-095cf158fcb5€24.00€0.37matched
70capture01a1a9c7-bd26-7c8b-befd-f8418003473b€35.00€0.50matched
71capture01a1a9c7-c495-7a28-9cbd-ced1edf147b2€9.00€0.19matched
72refund01a1a9c7-cb00-7f23-a664-049376071018-€2.00€0.00matched
73capture01a1a9c7-cd85-753e-b76b-6ebd9e395d06€49.00€0.67matched
74capture01a1a9c7-d5f0-74c1-8a27-2554501700a9€9.00€0.19matched
75capture01a1a9c7-e28c-7993-bb3b-1aedc82d6cdb€9.00€0.19matched
76capture01a1a9c7-e4b5-75ac-8015-836ff5500a20€15.00€0.26matched
77refund01a1a9c7-fed0-76cf-b555-7c2464b2b3f8-€14.00€0.00matched
78capture01a1a9c8-1454-76dd-87fe-469201a3dc5c€35.00€0.50matched
79capture01a1a9c8-335d-7e17-8000-b54b1b68bd1a€24.00€0.37matched
80refund01a1a9c8-3c33-7f94-afb8-73b74140ccac-€6.00€0.00matched
81capture01a1a9c8-49a9-72c9-814a-5586698a3384€15.00€0.26matched
82capture01a1a9c8-5f77-7318-a6e4-e177b645cf5c€9.00€0.19matched
83capture01a1a9c8-6deb-7f2f-8040-050701635e3d€9.00€0.19matched
84refund01a1a9c8-77c3-7192-96d7-c4070949bb3d-€11.00€0.00matched
85capture01a1a9c8-9b39-7e6e-a112-6d7f8ba0c089€35.00€0.50matched
86capture01a1a9c8-bc56-722e-91db-1f8daa00b31d€35.00€0.50matched
87capture01a1a9c8-fab3-7dc4-b8cb-aa364b8e45eb€15.00€0.26matched
88capture01a1a9c9-3b98-7cf4-a206-b3f69ef8cbf2€35.00€0.50matched
89capture01a1a9c9-6ded-7b2b-ac9c-798b63db3b0c€9.00€0.19matched
90capture01a1a9c9-9568-767f-92e9-210555c48dc0€15.00€0.26matched
91capture01a1a9c9-a8cd-722e-ae43-de835df379e2€49.00€0.67matched
92capture01a1a9c9-aae5-7317-a1a4-f223f50e3306€49.00€0.67matched
93capture01a1a9c9-ac6c-7a1f-819a-7f0b9da5d49c€9.00€0.19matched
94capture01a1a9c9-ac6c-7b6f-bb40-cae2eadaf1b5€15.00€0.26matched
95capture01a1a9c9-efe8-779d-8c31-9a3bfa4c5f3e€24.00€0.37matched
96capture01a1a9ca-0511-78e3-ae20-2ee7ffcf6295€15.00€0.26matched
97capture01a1a9ca-1e8f-7bac-bf2f-d0c2bf063da5€9.00€0.19matched
98capture01a1a9ca-2303-7414-8aa1-162ce92fea8b€24.00€0.37matched
99refund01a1a9ca-5898-7540-bee2-3db47ca65de1-€24.00€0.00matched
100capture01a1a9ca-677a-796e-8854-7315a94db720€15.00€0.26matched
101capture01a1a9ca-6959-7635-98df-07ee71380c02€9.00€0.19matched
102capture01a1a9ca-7302-756a-bfbb-ea02f5a0acb9€49.00€0.67matched
103capture01a1a9ca-73fe-7e95-98ee-90d7e6674add€35.00€0.50matched
104capture01a1a9ca-8b93-7652-9d7a-bff98dff29be€24.00€0.37matched
105capture01a1a9ca-9edb-7ded-b734-2ddf3ab7b067€49.00€0.67matched