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, 03:50

Gross

€2,713.00

PSP fee

€43.05

Net to the bank

€2,669.95

Settlement journal

#336233

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19a65-7818-788f-96f9-31221f60b1b1 is already settled by stl_EUR_2989319 line 59
  • fee differencethe fee is not the contract feethe fee is 41, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 30, the contract says 26
LineKindReferenceGrossFeeStatus
30capture01a19a63-4366-7a90-b1cd-3eb24cf45a63€24.00€0.41fee difference
60capture01a19a65-7a0a-71cc-a7d6-247db7ef4bb4€35.00€0.50duplicate line
116capture01a19a69-b711-71dd-835e-e4c951f50242€15.00€0.30fee difference
1capture01a19a5b-b7ca-7502-afb6-527a9d0d48dc€49.00€0.67matched
2capture01a19a5f-e600-743e-8d5e-69f2345ea6ae€9.00€0.19matched
3capture01a19a60-65d6-7aff-aee7-42e6a584782c€35.00€0.50matched
4capture01a19a60-75aa-78a8-a31c-658e9175e1d4€49.00€0.67matched
5capture01a19a60-eaee-70d4-9b39-9819c8f0cb94€9.00€0.19matched
6capture01a19a61-66a7-7c53-a736-c638859a4c18€24.00€0.37matched
7capture01a19a61-86e1-7dd5-ab0e-cf9bae45ac62€15.00€0.26matched
8capture01a19a61-892a-785e-a287-d64413dfcb27€9.00€0.19matched
9capture01a19a61-c2bb-7379-82d8-27abd9897ca5€24.00€0.37matched
10capture01a19a61-c453-7d95-bba3-f96dfcf82593€35.00€0.50matched
11capture01a19a61-ea19-7cbe-a8b2-f75a00ec4310€35.00€0.50matched
12capture01a19a61-f345-7448-8813-d5de6895b3ad€15.00€0.26matched
13capture01a19a62-019d-71d5-9190-993ef675b7d8€24.00€0.37matched
14capture01a19a62-0658-791a-aa28-bca9db202cfe€35.00€0.50matched
15capture01a19a62-0c8e-7d54-8c9f-944016a6f401€24.00€0.37matched
16capture01a19a62-124e-7a61-b5b5-d924c9d4b5cc€9.00€0.19matched
17capture01a19a62-15ea-706d-b552-3f72b08fbafa€49.00€0.67matched
18capture01a19a62-1fe3-72f9-b0c8-03e231b2d71a€15.00€0.26matched
19capture01a19a62-4e78-71a3-bfb2-1b7235077b22€15.00€0.26matched
20capture01a19a62-4ddd-706d-9cb5-19b089fba9a2€15.00€0.26matched
21capture01a19a62-6cad-7128-95aa-d8fb84fc6161€24.00€0.37matched
22capture01a19a62-79fa-75fd-823a-fcceea96948f€35.00€0.50matched
23capture01a19a62-7d08-77ad-abb9-0e3f6904b7dc€15.00€0.26matched
24capture01a19a62-8a11-797e-bc0e-553b3d0d0987€49.00€0.67matched
25capture01a19a62-9f08-727e-93fb-165cf3b51feb€24.00€0.37matched
26capture01a19a62-bcea-7308-a972-c980e70c1072€35.00€0.50matched
27capture01a19a62-cc1f-7946-a339-41bcdc361a4d€24.00€0.37matched
28capture01a19a62-ef24-74f7-9ca4-1e5db35514ce€15.00€0.26matched
29capture01a19a63-2e8d-7841-ac22-34b73bb53103€35.00€0.50matched
31capture01a19a63-6231-7ce1-b245-ee58b0623cec€9.00€0.19matched
32capture01a19a63-6a67-7bfb-92b9-590fccabe191€35.00€0.50matched
33capture01a19a63-848d-7100-b1fc-9982e92c91da€24.00€0.37matched
34capture01a19a63-9321-7d62-9688-31f128716ce8€15.00€0.26matched
35capture01a19a63-949e-7434-a751-5bd0d9c6f74c€49.00€0.67matched
36capture01a19a63-b6de-74fb-8810-fe3d81211c8e€15.00€0.26matched
37capture01a19a63-c334-7402-b5fb-5b6794c2aac3€9.00€0.19matched
38capture01a19a63-f718-74e8-94ac-7861030d6386€9.00€0.19matched
39capture01a19a63-fbcd-7720-b163-4dfd28d68e15€49.00€0.67matched
40capture01a19a63-fedc-7e19-881f-8a3cdc2ed908€49.00€0.67matched
41capture01a19a64-591e-7f7e-8511-e56dfb6dea0c€49.00€0.67matched
42capture01a19a64-7506-720f-9fb4-1eb202188f77€24.00€0.37matched
43capture01a19a64-7c8c-7f0e-8c69-19eaf204a27a€35.00€0.50matched
44capture01a19a64-a492-790b-9f43-6fcf541316f5€15.00€0.26matched
45capture01a19a64-a6be-77c7-8042-32cc2b63ed24€9.00€0.19matched
46capture01a19a64-c76f-7a11-a98c-b6d0af3e0755€15.00€0.26matched
47capture01a19a64-e3e7-77ec-ac0e-86c4b47ba9fb€35.00€0.50matched
48capture01a19a64-f3d2-7722-8367-c7daf0545e53€9.00€0.19matched
49capture01a19a64-fddd-7d1e-95fc-51bed0880ce0€9.00€0.19matched
50capture01a19a65-0a11-7747-9a3f-0c683a8ce0d5€49.00€0.67matched
51capture01a19a65-1f77-7f44-8587-55339ffb4d73€15.00€0.26matched
52capture01a19a65-2391-7fd4-998a-e595b84e9ebe€24.00€0.37matched
53refund01a19a65-2ae7-72f1-81f8-ebe93098de19-€8.00€0.00matched
54capture01a19a65-3306-75cf-a63d-53e5982b0dbf€9.00€0.19matched
55capture01a19a65-1e8a-7c6b-bf8e-c003c309c43a€9.00€0.19matched
56capture01a19a65-4f79-7491-a20c-decc3a5675d3€9.00€0.19matched
57refund01a19a65-5652-70ba-a9ca-dee8a7f7d4e2-€4.00€0.00matched
58refund01a19a65-69cd-78b3-bd1f-db2d5ce73d85-€2.00€0.00matched
59capture01a19a65-7a0a-71cc-a7d6-247db7ef4bb4€35.00€0.50matched
61capture01a19a65-a072-789f-bded-48942519b80c€9.00€0.19matched
62capture01a19a65-a84d-79ef-b9c2-2f4563026150€9.00€0.19matched
63capture01a19a65-be4c-7813-9de7-0fb94f5015a3€15.00€0.26matched
64capture01a19a65-bf4d-7658-b6fa-f463d32eb311€24.00€0.37matched
65capture01a19a65-ca1e-7c16-bcef-8d8bd94863a5€15.00€0.26matched
66capture01a19a65-e30d-7594-ada5-5e4b774f76e4€49.00€0.67matched
67capture01a19a66-1b21-7983-a755-78237d0ebd41€35.00€0.50matched
68capture01a19a66-1e29-7264-8784-f37d11b1a6b6€24.00€0.37matched
69refund01a19a66-2e2a-710f-86d7-3874bef0fe48-€18.00€0.00matched
70capture01a19a66-3377-7cc8-bd2b-a4af2782fea1€9.00€0.19matched
71capture01a19a66-7195-71a6-b057-8dde330746a2€9.00€0.19matched
72capture01a19a66-71ef-70d6-81a6-ef48d37436c5€15.00€0.26matched
73capture01a19a66-7bbc-78e8-908a-b8d33c628d2b€15.00€0.26matched
74capture01a19a66-a9fe-724d-85be-9bc0af16d130€49.00€0.67matched
75capture01a19a66-aec7-7732-9a02-4dbd481922e5€15.00€0.26matched
76capture01a19a66-a7c4-7561-99ef-e361e16097d0€49.00€0.67matched
77capture01a19a66-d30f-7504-bb14-dae328c95b3a€15.00€0.26matched
78capture01a19a66-dad8-773a-b8fa-1e9715822dca€24.00€0.37matched
79capture01a19a66-dfbf-79ac-bf98-58a86dabcdae€35.00€0.50matched
80capture01a19a66-ff28-7d1b-93a7-a371c563d0d6€49.00€0.67matched
81capture01a19a67-03f1-7b18-b4a9-1074f9001884€15.00€0.26matched
82capture01a19a67-1083-7b56-a2f6-44d8e043eee1€49.00€0.67matched
83capture01a19a67-3002-7d06-8503-41306fed11f8€49.00€0.67matched
84capture01a19a67-54d0-7c11-a5d7-31cbd40601db€9.00€0.19matched
85refund01a19a67-7932-7f53-9397-6fcc1687b170-€41.00€0.00matched
86capture01a19a67-802a-7795-810f-b4f2a0dc257f€35.00€0.50matched
87capture01a19a67-7d23-7612-821b-1cd17b8f6846€9.00€0.19matched
88capture01a19a67-bddf-7cdf-a7b2-f40e2ef06d87€15.00€0.26matched
89capture01a19a67-cbd5-74a9-8ad4-b214e604cd9a€15.00€0.26matched
90capture01a19a67-db73-7f19-815f-a1523d034c50€49.00€0.67matched
91capture01a19a67-f9d9-7297-8130-782b5c582a68€15.00€0.26matched
92capture01a19a68-1265-7604-a9c9-869293f60bb9€15.00€0.26matched
93capture01a19a68-1969-73ae-8677-a8a9fb1dfff2€15.00€0.26matched
94capture01a19a68-3498-76e8-ad20-2dd834b6c965€9.00€0.19matched
95capture01a19a68-3beb-7fc4-9cfb-41b93d0d336b€49.00€0.67matched
96capture01a19a68-426a-7dcb-b068-e1f17d55b31d€35.00€0.50matched
97capture01a19a68-4b62-7dd5-9317-bce19893a7d2€24.00€0.37matched
98capture01a19a68-66c1-7633-9e2e-2e0842a65c10€15.00€0.26matched
99capture01a19a68-719f-7de9-812f-fe90f3f2b93d€9.00€0.19matched
100capture01a19a68-7244-7830-a47d-d97b60d0db3b€24.00€0.37matched
101capture01a19a68-72e3-70b2-86aa-5f655eb826c3€9.00€0.19matched
102capture01a19a68-7286-70a5-8a8a-ed913f827e3b€9.00€0.19matched
103refund01a19a68-9329-76a2-bbfb-3724aaddbaab-€17.00€0.00matched
104capture01a19a68-ba7a-7c53-aa37-d331ff49b548€35.00€0.50matched
105capture01a19a68-be8a-7e91-9af2-ed650bd74342€9.00€0.19matched
106capture01a19a68-d0d3-74b3-98f1-d10a6e0f7ed8€49.00€0.67matched
107capture01a19a68-da63-7bf7-a79c-c1d0debc0eb8€15.00€0.26matched
108capture01a19a68-e5e7-7995-af72-dcd535240d60€24.00€0.37matched
109capture01a19a68-facd-7eba-9d49-517ccf469ebd€24.00€0.37matched
110capture01a19a69-1d56-7a66-8277-aec4a4f9293e€24.00€0.37matched
111capture01a19a69-3570-725f-89bb-e87198ea244c€15.00€0.26matched
112capture01a19a69-8e76-7362-b3a1-d4eecf61a956€49.00€0.67matched
113capture01a19a69-9230-7be1-8d41-aa2dcb06c503€49.00€0.67matched
114capture01a19a69-af41-7eed-9420-513dc6c21e5e€15.00€0.26matched
115capture01a19a69-b6e8-7c76-b315-97ba6e67a70d€15.00€0.26matched
117capture01a19a69-cacc-700a-bb44-e5641a9b34ed€9.00€0.19matched
118capture01a19a69-d6a4-74ab-863b-1ec14b28c3d7€15.00€0.26matched
119capture01a19a69-e5d0-7e07-a758-9284be9dcaa0€24.00€0.37matched
120capture01a19a69-eec4-7c4c-840d-e0c6de54d98f€49.00€0.67matched
121capture01a19a69-f068-70a4-80ba-d2f89a7cb1b8€9.00€0.19matched