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

Gross

€2,560.00

PSP fee

€41.39

Net to the bank

€2,518.61

Settlement journal

#391722

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aa04-6bcf-76ef-8399-ce7d537f2877 is already settled by stl_EUR_2989756 line 49
  • duplicate linethe file lists it twicecapture:01a1aa09-dd13-7d61-8f17-06a6eeb63057 is already settled by stl_EUR_2989756 line 109
  • missing linein the books, not in the filecapture:01a1aa09-556a-77d3-9995-c9ddd4ae9f51 is in no file
LineKindReferenceGrossFeeStatus
50capture01a1aa04-6bfe-7df4-a343-bdddf938f354€24.00€0.37duplicate line
110capture01a1aa09-dd2f-78f5-9066-102933ff1b9a€35.00€0.50duplicate line
1capture01a1a9fb-76a6-7f12-98be-bf5e143c2fd8€9.00€0.19matched
2capture01a1a9fb-9440-7d1c-8a31-fd6dfec89299€35.00€0.50matched
3capture01a1a9fc-fc88-7405-9c7f-248cfe25fe55€35.00€0.50matched
4capture01a1aa01-58ca-7dda-a131-48d8f784cd04€15.00€0.26matched
5capture01a1aa01-b1e5-76c1-bc32-15adcadd8cbc€49.00€0.67matched
6capture01a1aa01-b7be-7bd3-ab7d-42e48a718992€15.00€0.26matched
7capture01a1aa01-c801-7a26-a8aa-12eec7372d9c€15.00€0.26matched
8capture01a1aa01-d04c-72b1-96bc-466f23c1d149€49.00€0.67matched
9capture01a1aa01-e636-722e-8cfd-368674de16c8€9.00€0.19matched
10capture01a1aa01-efa9-788b-bb9d-05936215bba4€49.00€0.67matched
11capture01a1aa02-1db7-7f79-a429-a07e2c293cdf€35.00€0.50matched
12capture01a1aa02-213d-7373-a22f-ab6fa6cccd47€24.00€0.37matched
13capture01a1aa02-23aa-7e39-8fb5-39ea8da4da04€15.00€0.26matched
14capture01a1aa02-2948-7a8c-91b6-d71c073babf4€9.00€0.19matched
15refund01a1aa02-2d3a-7dad-9ebc-adccefe90d5d-€15.00€0.00matched
16capture01a1aa02-3485-78e4-adfc-84689b85839f€9.00€0.19matched
17capture01a1aa02-21f2-77e0-a5d1-630da9c0101b€35.00€0.50matched
18capture01a1aa02-739f-7b9b-bdcb-bce7bf6aafca€15.00€0.26matched
19refund01a1aa02-7551-70f8-893a-dc1e8a9dffe1-€9.00€0.00matched
20capture01a1aa02-7c71-71c2-b1f4-e1f487c532b4€15.00€0.26matched
21capture01a1aa02-80fa-7b30-9e6f-4a0ce48577ab€35.00€0.50matched
22refund01a1aa02-9575-7cbd-b1e8-0ed17ac15c06-€10.00€0.00matched
23capture01a1aa02-a08b-7831-9db3-a596164b524c€49.00€0.67matched
24capture01a1aa02-d199-75c7-8d94-29e14218a556€9.00€0.19matched
25capture01a1aa02-e377-7525-8e99-f2b280ac8a61€15.00€0.26matched
26capture01a1aa02-f611-72d0-be4c-f35545aaf7ba€35.00€0.50matched
27capture01a1aa02-f669-7a31-8731-efdbfbfeb57d€35.00€0.50matched
28capture01a1aa02-fda5-717e-85d8-df003e7785d7€24.00€0.37matched
29capture01a1aa02-fb89-7e5c-a70a-322cecbcc792€15.00€0.26matched
30capture01a1aa03-19a8-7951-911a-b0cb03872f63€9.00€0.19matched
31capture01a1aa03-3d1d-7e1d-ac4b-f8550e208aa5€9.00€0.19matched
32capture01a1aa03-5072-75a8-afc3-54f2a5815a95€15.00€0.26matched
33capture01a1aa03-50ce-7ff3-a86d-fc10a8b72ca8€9.00€0.19matched
34refund01a1aa03-6b41-73d7-b864-60771e7501e1-€25.00€0.00matched
35capture01a1aa03-6b6c-735b-a00e-a73c2d9dc30e€15.00€0.26matched
36capture01a1aa03-7226-7fc4-890d-030d911cd430€9.00€0.19matched
37capture01a1aa03-7cdb-79ed-add9-d3616c8263c3€9.00€0.19matched
38capture01a1aa03-9b4c-747f-a5b3-601bdc4463e0€35.00€0.50matched
39capture01a1aa03-a083-784b-bbc7-6af2dffb7cd4€49.00€0.67matched
40capture01a1aa03-addd-7cc1-a4c6-5e7bcf557d46€9.00€0.19matched
41capture01a1aa03-b86c-7140-bca6-3577b6f43ee0€49.00€0.67matched
42capture01a1aa03-db77-7f98-9b2c-d3eeb587b604€35.00€0.50matched
43capture01a1aa03-df8e-7e27-a6ca-8ffea07dda4e€49.00€0.67matched
44capture01a1aa03-f108-749f-b9dc-ee4952df32d2€24.00€0.37matched
45capture01a1aa04-0953-761f-b55b-0a6a8bf2af81€35.00€0.50matched
46capture01a1aa04-1dd2-7ffe-95f2-8decaa1b50f7€9.00€0.19matched
47capture01a1aa04-4bae-7dd3-802a-755ff75989a0€49.00€0.67matched
48capture01a1aa04-60b1-7700-9d02-798d24c4ff15€9.00€0.19matched
49capture01a1aa04-6bfe-7df4-a343-bdddf938f354€24.00€0.37matched
51capture01a1aa04-6cff-7cab-8bc1-b9d9ec3f490b€49.00€0.67matched
52capture01a1aa04-89b4-787c-8534-47c88781054b€9.00€0.19matched
53capture01a1aa04-b453-7591-88b2-c4cb751303d3€35.00€0.50matched
54capture01a1aa04-c20a-7b40-8624-08943d2c9688€9.00€0.19matched
55capture01a1aa04-d481-7c5d-8269-f92e21fa7381€15.00€0.26matched
56capture01a1aa04-e689-7263-97b8-1ccfdfbef6b6€24.00€0.37matched
57capture01a1aa04-ecbf-77be-8aa9-19f66c715655€15.00€0.26matched
58capture01a1aa04-f96c-7fee-ab6a-78f45b9ca4d9€15.00€0.26matched
59capture01a1aa05-03a0-7386-931b-101486014182€24.00€0.37matched
60capture01a1aa05-049e-7a13-802d-afaebe4ea730€15.00€0.26matched
61capture01a1aa05-05d3-76b5-a50e-c16b70663f4d€35.00€0.50matched
62refund01a1aa05-497c-7f02-9fce-64a0207dc803-€22.00€0.00matched
63capture01a1aa05-4b06-7714-8c51-fea0e2864170€9.00€0.19matched
64capture01a1aa05-907c-7e3b-87ca-2a79b2af88dd€9.00€0.19matched
65capture01a1aa05-aea0-72f3-8484-60e621e2e3bd€9.00€0.19matched
66refund01a1aa05-f8ac-786c-9afb-7a961a534808-€5.00€0.00matched
67capture01a1aa06-0297-70ed-b4ae-10783b6b0f27€49.00€0.67matched
68capture01a1aa06-1b92-77c5-b4b4-49805634f3cb€24.00€0.37matched
69capture01a1aa06-4624-7837-9581-1e1c08bbca1c€35.00€0.50matched
70capture01a1aa06-799e-7e46-b2e6-4f9a96f6453b€49.00€0.67matched
71capture01a1aa06-890a-75e6-8fcf-aaf397875d4e€35.00€0.50matched
72capture01a1aa06-9d69-7f2b-a1d4-4fa0e070512f€35.00€0.50matched
73capture01a1aa06-d180-71c4-a8d3-f76d90368442€9.00€0.19matched
74capture01a1aa06-d953-76b4-91b1-6ef8c4a68b05€9.00€0.19matched
75capture01a1aa06-e11c-7d0f-8230-31c322fa2aaa€9.00€0.19matched
76capture01a1aa06-ec0a-7e1a-b541-ecdb9abf7fa6€24.00€0.37matched
77refund01a1aa07-403d-7070-a0e8-ff07f825d23e-€2.00€0.00matched
78capture01a1aa07-4153-7e1a-bbee-de74e10796c5€15.00€0.26matched
79capture01a1aa07-8188-77de-b2c0-5b6a6ea83b23€9.00€0.19matched
80capture01a1aa07-82bb-74d8-aef9-893038b24f26€24.00€0.37matched
81capture01a1aa07-8c73-7e2c-8584-a68c8a6f0c6f€49.00€0.67matched
82capture01a1aa07-ac72-7196-9af3-522ebe1921bb€49.00€0.67matched
83capture01a1aa07-afbb-7a2e-9a01-533a483ca86a€24.00€0.37matched
84capture01a1aa07-ca73-75b3-9b90-0e4f90d22b51€15.00€0.26matched
85capture01a1aa07-eae9-71a0-91fb-061667a4cd48€15.00€0.26matched
86refund01a1aa08-00c8-7f7f-94a7-2b095ebee35e-€45.00€0.00matched
87capture01a1aa08-0379-7753-8728-53b3355b00d0€15.00€0.26matched
88capture01a1aa08-07b2-7c89-a4e2-70f20ae05533€15.00€0.26matched
89capture01a1aa08-0a9a-7d9e-9064-0a00c8a8b342€49.00€0.67matched
90capture01a1aa08-465a-7497-b6f7-592c74a59efa€24.00€0.37matched
91capture01a1aa08-5281-7d82-b1f1-3011b3ddf351€35.00€0.50matched
92capture01a1aa08-8c1f-7512-97f3-e17c7e84b71f€9.00€0.19matched
93capture01a1aa08-9d2f-7064-82c9-ab7c28aa7d4d€49.00€0.67matched
94capture01a1aa08-a9b0-7840-ad84-4d81b91ec38e€24.00€0.37matched
95capture01a1aa08-bc4a-7d2d-a1a3-a9e7626f01ec€15.00€0.26matched
96capture01a1aa08-fd5c-7356-8cdd-80a71b1d53a1€9.00€0.19matched
97capture01a1aa09-4700-74d6-8add-c704e56dfce2€15.00€0.26matched
98capture01a1aa09-4fe2-7106-9ba3-4cfd4ceaf3a3€9.00€0.19matched
99capture01a1aa09-5bd4-7359-8537-108dfd542207€24.00€0.37matched
100capture01a1aa09-5c7b-77a6-b17e-0f546fa73780€35.00€0.50matched
101capture01a1aa09-779f-764d-8c78-0859f160ea18€15.00€0.26matched
102capture01a1aa09-8d2b-7344-8ab9-8d9fc907c740€35.00€0.50matched
103capture01a1aa09-a141-7e8d-9eb8-35dfd6717185€24.00€0.37matched
104capture01a1aa09-aa1e-779d-8b85-ee785d499718€35.00€0.50matched
105capture01a1aa09-bdf5-731c-9103-484f1a9fe69c€9.00€0.19matched
106refund01a1aa09-c35d-79ff-8ff2-d1af07a143d0-€7.00€0.00matched
107capture01a1aa09-c386-718e-8e94-daeba848ad04€49.00€0.67matched
108refund01a1aa09-d431-77b2-9df7-9dcd1c777bea-€5.00€0.00matched
109capture01a1aa09-dd2f-78f5-9066-102933ff1b9a€35.00€0.50matched
111capture01a1aa09-df24-7370-90a6-48628215a24f€49.00€0.67matched
112capture01a1aa09-e5ac-7368-a5d8-dcc53af359a6€24.00€0.37matched
113capture01a1aa09-ea13-78eb-8c56-749242422c0a€9.00€0.19matched
114capture01a1aa0a-08e7-743f-a29e-bedab3652319€15.00€0.26matched
115capture01a1aa0a-333a-7cc2-9196-d98685b6b92e€24.00€0.37matched
116capture01a1aa0a-3465-78db-a682-a99809b750d1€24.00€0.37matched
117capture01a1aa0a-4997-7126-b8e0-b9d7d5a2cfe1€49.00€0.67matched
118capture01a1aa0a-71f8-7962-a224-ac9b4b07ebb1€9.00€0.19matched
119capture01a1aa0a-7b71-7336-ba44-cc3356b48ee3€24.00€0.37matched
120capture01a1aa0a-c2a2-74a6-ae12-43ac6c06220a€35.00€0.50matched