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

Gross

€2,626.00

PSP fee

€42.39

Net to the bank

€2,583.61

Settlement journal

#346234

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19d37-065f-761a-b8e3-5ecccfae91a9 is already settled by stl_EUR_2989398 line 31
  • duplicate linethe file lists it twicecapture:01a19d3b-d993-77f7-8aef-6cf5c380480c is already settled by stl_EUR_2989398 line 92
  • fee differencethe fee is not the contract feethe fee is 53, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 2, the contract says 0
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
LineKindReferenceGrossFeeStatus
32capture01a19d37-0685-7445-ae72-aa2937fb651e€49.00€0.67duplicate line
42capture01a19d37-c807-7aa9-934f-fd655c917948€35.00€0.53fee difference
93capture01a19d3b-d9cf-72af-99e7-43349bbcdcfd€24.00€0.37duplicate line
101refund01a19d3c-34d0-7891-ae0a-14020e7e1033-€26.00€0.02fee difference
112capture01a19d3c-c0b1-7a01-824b-e54bf00649ac€49.00€0.68fee difference
1capture01a19d2b-7743-7e0c-8ff1-324c885d368f€35.00€0.50matched
2capture01a19d2b-b11e-70c6-a10d-a3d9a0f025ae€9.00€0.19matched
3capture01a19d34-11c6-7d2f-954e-702c93dc412f€49.00€0.67matched
4capture01a19d34-4219-7c17-9e35-6c7ca012e0fa€35.00€0.50matched
5capture01a19d34-4db0-7ab3-87ab-502f67399376€49.00€0.67matched
6capture01a19d34-4fc5-7211-9e26-cad11a7af14e€24.00€0.37matched
7capture01a19d34-6480-7bb0-b5de-6d4c6f70f181€24.00€0.37matched
8capture01a19d34-6913-762c-a7c6-6a2b792b2441€9.00€0.19matched
9capture01a19d34-6a0e-7321-a618-ed853ba090d3€9.00€0.19matched
10capture01a19d34-81ea-7ce6-9d26-bd2f6ddaaa17€24.00€0.37matched
11capture01a19d34-8a78-7fbb-8688-83758e53ec79€35.00€0.50matched
12capture01a19d34-d118-71fc-9c51-afb6a1947e19€15.00€0.26matched
13capture01a19d34-d6ad-772a-be95-35d167786f89€35.00€0.50matched
14capture01a19d34-d9f4-7399-aa6c-e9bc8d2c4d0f€9.00€0.19matched
15capture01a19d35-0335-71b3-808f-16f7089cf2ed€15.00€0.26matched
16capture01a19d35-2190-798d-ad53-683dcf044819€9.00€0.19matched
17capture01a19d35-2410-78cd-8754-fd73f99587ab€35.00€0.50matched
18capture01a19d35-80df-7e44-aa4a-4353fd694798€15.00€0.26matched
19capture01a19d35-9075-7104-8d69-13382c8121d7€9.00€0.19matched
20capture01a19d35-90ee-7d8e-8b1e-a0dcc7c1a861€9.00€0.19matched
21capture01a19d35-fb70-766e-93ea-23f97deac9e5€15.00€0.26matched
22capture01a19d36-20e2-7472-8f21-0bb2ced73c6b€15.00€0.26matched
23capture01a19d36-3c66-7d65-a8cd-6e88a6893e9e€24.00€0.37matched
24capture01a19d36-543e-7249-a25c-00904b3a39fa€9.00€0.19matched
25capture01a19d36-5702-75ab-a968-42abec602eac€15.00€0.26matched
26capture01a19d36-92bd-7a6f-9fbc-eb08dd7465dc€15.00€0.26matched
27capture01a19d36-a884-7e6a-90b9-0b9ef5f724ee€9.00€0.19matched
28capture01a19d36-b511-7217-bef6-1ba582a035a7€35.00€0.50matched
29capture01a19d36-d883-73cf-ac5b-c17e7abc1d18€49.00€0.67matched
30capture01a19d36-e0ec-7d5e-a347-385b723b0ee5€49.00€0.67matched
31capture01a19d37-0685-7445-ae72-aa2937fb651e€49.00€0.67matched
33refund01a19d37-31a2-72f2-92fa-f81adb924d4a-€29.00€0.00matched
34capture01a19d37-4314-7e93-88dc-37d67508bbec€49.00€0.67matched
35capture01a19d37-66c3-7ba2-82ca-c20f65ceca66€49.00€0.67matched
36capture01a19d37-6c8c-79ab-9bda-8b6820a6b85c€15.00€0.26matched
37capture01a19d37-7f07-737e-81b2-32088d9e9c08€49.00€0.67matched
38capture01a19d37-842b-791a-9747-21f520c6b6f6€35.00€0.50matched
39capture01a19d37-8b9b-7fb9-b25d-735b4ab17987€9.00€0.19matched
40capture01a19d37-9474-7217-a82d-b124d06cb21f€9.00€0.19matched
41capture01a19d37-b521-75f6-922a-5a26717bd6fa€15.00€0.26matched
43capture01a19d37-cedd-74dc-b00c-6be697e80893€49.00€0.67matched
44capture01a19d37-d42a-785f-b5fb-c5a7689caf00€9.00€0.19matched
45capture01a19d37-fbf7-7c67-a5d1-b78e73f98bb8€24.00€0.37matched
46capture01a19d38-1e9e-7a1c-95bb-0a3e6e29232c€35.00€0.50matched
47capture01a19d38-2e2b-7a03-85c9-0e308ef757db€49.00€0.67matched
48capture01a19d38-36cd-7d9a-866b-c4293ed161b7€9.00€0.19matched
49capture01a19d38-6aa6-7967-8583-b7b253ec4c07€35.00€0.50matched
50capture01a19d38-8bae-73b5-adfd-b745c2608afd€24.00€0.37matched
51capture01a19d38-d266-7c89-a91c-34cb1bc08b3d€15.00€0.26matched
52capture01a19d39-034e-7197-a8f6-249f19438c78€35.00€0.50matched
53capture01a19d39-0aa2-7ceb-8256-7f121f6d5fcf€9.00€0.19matched
54capture01a19d39-3c94-7bd5-9beb-dac4595f423f€15.00€0.26matched
55capture01a19d39-502d-7913-8d9d-9451955ba661€15.00€0.26matched
56capture01a19d39-5c08-71e5-8d66-a26b135be278€15.00€0.26matched
57capture01a19d39-7430-78d4-a9de-216026c34c25€49.00€0.67matched
58capture01a19d39-756c-7770-b9df-c28613e70cf2€24.00€0.37matched
59capture01a19d39-a9c8-7919-acfe-c4c0692ba6cd€24.00€0.37matched
60refund01a19d39-b103-7170-8ab3-c4a0aad6cf54-€12.00€0.00matched
61capture01a19d39-c5dd-7c0b-859f-53821eb07d79€15.00€0.26matched
62capture01a19d39-d54c-7c3c-bbcc-0bd0a06c54da€35.00€0.50matched
63capture01a19d39-fa1a-72d7-a8b0-24f2fe719614€15.00€0.26matched
64capture01a19d39-f131-7661-ac22-adcfed00467b€35.00€0.50matched
65capture01a19d3a-0dd7-7fb4-92f6-ebe3a98e3855€49.00€0.67matched
66refund01a19d3a-1c00-7053-bce3-b3dead1ea8f6-€15.00€0.00matched
67capture01a19d3a-2601-7f81-acd3-0bd183ab032d€15.00€0.26matched
68capture01a19d3a-47ed-715f-a8d6-55161c565302€15.00€0.26matched
69capture01a19d3a-668e-7cc9-82a0-4dd9f79a47e5€24.00€0.37matched
70refund01a19d3a-69f2-7db8-9c38-4c93abaa01c5-€27.00€0.00matched
71capture01a19d3a-b64f-777f-a7cb-015ebc7436c3€9.00€0.19matched
72capture01a19d3a-c9df-78bf-8b82-0ccb713924ac€9.00€0.19matched
73capture01a19d3a-d653-7788-b0ef-96f0ae9304e3€15.00€0.26matched
74capture01a19d3b-03a5-7e65-82d7-c85336579619€9.00€0.19matched
75capture01a19d3b-044b-7731-a1dd-016fd624709b€35.00€0.50matched
76capture01a19d3b-07c2-75a0-9b44-e3310e9d12b4€24.00€0.37matched
77capture01a19d3b-0ac7-77d9-acaa-bcbc45eaecf0€15.00€0.26matched
78capture01a19d3b-17bc-746c-999e-2331df81719d€24.00€0.37matched
79capture01a19d3b-19ff-73d5-96e3-15832443f981€9.00€0.19matched
80capture01a19d3b-2560-72c8-8be1-125f0dda6a59€9.00€0.19matched
81capture01a19d3b-3e88-7330-90d5-bf8a13bd21c1€9.00€0.19matched
82capture01a19d3b-4b5b-7e95-b6bf-d8a58ec5b519€49.00€0.67matched
83capture01a19d3b-4bc0-73c5-b73b-93eec6b9e4c1€49.00€0.67matched
84capture01a19d3b-58cf-714a-9f20-68e2209c731f€24.00€0.37matched
85capture01a19d3b-5da2-7f45-9f82-f3eb675e52d6€9.00€0.19matched
86capture01a19d3b-7ce7-7a04-b5a2-2914abeab2b4€24.00€0.37matched
87capture01a19d3b-ab9b-718d-83fa-7af237af26ad€15.00€0.26matched
88capture01a19d3b-c194-76d7-a3eb-33a8f03a8ea5€24.00€0.37matched
89capture01a19d3b-c9cd-7d7f-a315-ae1e4de4c926€49.00€0.67matched
90capture01a19d3b-d102-7401-9c41-32890bb6afef€24.00€0.37matched
91capture01a19d3b-d7fe-7f57-9f31-fbcf53ac0778€35.00€0.50matched
92capture01a19d3b-d9cf-72af-99e7-43349bbcdcfd€24.00€0.37matched
94capture01a19d3b-de6b-74df-ad96-5a67c3905f94€35.00€0.50matched
95capture01a19d3b-eb5a-7870-9478-a4de62647569€35.00€0.50matched
96capture01a19d3b-ef16-730d-875c-d135e56bb272€9.00€0.19matched
97refund01a19d3c-03bc-7aaf-89b4-bcd4a79b3520-€15.00€0.00matched
98capture01a19d3c-28dc-7a8e-a511-0030fa4cfd2b€15.00€0.26matched
99capture01a19d3c-2a7e-78bf-9e4b-c513101cda58€35.00€0.50matched
100capture01a19d3c-2c98-71f7-b1c2-4726270e9193€35.00€0.50matched
102capture01a19d3c-47f4-7e4b-a88d-ea73d744e8bf€24.00€0.37matched
103capture01a19d3c-59bd-7312-b9c3-1581a61e0df6€9.00€0.19matched
104capture01a19d3c-5ba6-76dc-95c5-539b44317ab6€24.00€0.37matched
105capture01a19d3c-6aa7-71dc-abf9-092c9493461e€49.00€0.67matched
106capture01a19d3c-81f5-7558-af80-1bebe5960ae5€24.00€0.37matched
107capture01a19d3c-878b-7a4e-8cec-5672585dde44€49.00€0.67matched
108capture01a19d3c-8b06-748f-a872-edd77e4540f5€9.00€0.19matched
109capture01a19d3c-a0c9-7372-a372-705803e73cd8€15.00€0.26matched
110capture01a19d3c-b010-7a37-bcca-bd8c564dd1e9€24.00€0.37matched
111capture01a19d3c-b749-7c05-bd32-5810475616fa€49.00€0.67matched
113refund01a19d3c-c97c-7ba2-930f-57c398d04a64-€33.00€0.00matched
114capture01a19d3c-ea1c-7a36-8a18-0ccb09460b23€9.00€0.19matched
115capture01a19d3d-0547-74e8-8beb-08c9bde49794€9.00€0.19matched
116capture01a19d3d-158b-7390-82ec-a49215caee56€35.00€0.50matched
117capture01a19d3d-1c3c-780c-97ff-739771ae59d7€35.00€0.50matched