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

3 Nov, 07:50

Gross

€3,322.00

PSP fee

€50.80

Net to the bank

€3,271.20

Settlement journal

#357607

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a065-d8f4-734b-a5a4-9ec97537926c is already settled by stl_EUR_2989487 line 42
  • duplicate linethe file lists it twicecapture:01a1a066-05b7-709a-ae2e-f1beac09c545 is already settled by stl_EUR_2989487 line 51
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
LineKindReferenceGrossFeeStatus
1capture01a1a059-fb4a-7e2e-81a2-93df7436f94b€35.00€0.55fee difference
19capture01a1a064-2b73-7ed2-802a-06e3ff1313ad€9.00€0.20fee difference
43capture01a1a065-d910-73ad-a897-8a86600c1ebc€9.00€0.19duplicate line
52capture01a1a066-250b-73d8-b638-bba32ee2e6e9€35.00€0.50duplicate line
2capture01a1a05a-9930-7cd8-b342-ca43884bac9d€49.00€0.67matched
3capture01a1a05c-6f6f-7d7d-8185-f0a6039dae72€35.00€0.50matched
4capture01a1a05d-6db2-7fd2-b06d-85f5cf466ba7€35.00€0.50matched
5capture01a1a062-f890-7fd7-8c98-b63d6808bb19€35.00€0.50matched
6capture01a1a062-fedc-7548-8538-53368930ae7e€35.00€0.50matched
7capture01a1a063-1ba2-78d1-925a-f7468df61de9€35.00€0.50matched
8capture01a1a063-2e70-7f0a-a79a-7bd07bc43500€15.00€0.26matched
9capture01a1a063-35ef-783e-b834-b0979cfa314d€49.00€0.67matched
10capture01a1a063-3c12-70d4-9bec-1c3bff2773ec€15.00€0.26matched
11capture01a1a063-4794-7b60-8f8d-9e312bee13cb€49.00€0.67matched
12capture01a1a063-73c0-7799-a522-60c645ab4df1€15.00€0.26matched
13capture01a1a063-a4d4-75ad-a96f-75e70a6bcae3€24.00€0.37matched
14capture01a1a063-b650-7ffd-8b96-d66de950aefa€35.00€0.50matched
15capture01a1a063-bf5a-73e2-b632-0e89e2348e5d€15.00€0.26matched
16capture01a1a063-e7a0-715d-b90a-987daad1d81a€49.00€0.67matched
17capture01a1a064-209b-7c29-9676-6924c4167dd4€35.00€0.50matched
18capture01a1a064-237c-7d0e-b63c-3880888c95d1€24.00€0.37matched
20capture01a1a064-3674-78e8-b59f-a77256863433€15.00€0.26matched
21capture01a1a064-50bf-70fa-9209-a6e50060ed84€49.00€0.67matched
22refund01a1a064-5a63-7dd3-9576-665e938b5fdd-€12.00€0.00matched
23capture01a1a064-7416-79d1-a5da-2ed9a7bd7bdf€35.00€0.50matched
24capture01a1a064-78a1-7725-99a5-0a868a0ff63e€9.00€0.19matched
25capture01a1a064-9507-733f-ad02-e325b6d097e9€9.00€0.19matched
26capture01a1a064-b675-7d19-9b24-f09475ff86a6€15.00€0.26matched
27capture01a1a064-ba94-71ff-8367-e990f53fc51e€15.00€0.26matched
28capture01a1a064-bd7d-75de-a36c-420494574728€24.00€0.37matched
29capture01a1a064-c6bd-79a5-8861-f442c928a778€9.00€0.19matched
30capture01a1a064-e17b-7e39-a5c7-653459f635d5€49.00€0.67matched
31capture01a1a064-f708-78a0-bb40-9bc2abbdd6a0€9.00€0.19matched
32capture01a1a065-15af-702a-9fe7-6205f095e91a€15.00€0.26matched
33capture01a1a065-3673-7835-962c-d03b88002a28€15.00€0.26matched
34capture01a1a065-3ffe-7d2b-ab74-3b65064e59f7€35.00€0.50matched
35refund01a1a065-4f03-7d33-bab9-55ae11f7c969-€9.00€0.00matched
36capture01a1a065-6610-7973-a729-60d8fcf32676€49.00€0.67matched
37capture01a1a065-85b9-715a-9fc4-e0e1697db525€15.00€0.26matched
38capture01a1a065-8d88-7276-be78-b80fd2ee441f€49.00€0.67matched
39capture01a1a065-91f8-7df6-8572-a8d0024224c2€35.00€0.50matched
40capture01a1a065-9725-7e77-ab4f-98260726ec56€15.00€0.26matched
41capture01a1a065-a17e-7834-85aa-7767e9157731€49.00€0.67matched
42capture01a1a065-d910-73ad-a897-8a86600c1ebc€9.00€0.19matched
44capture01a1a065-e1dc-7d18-82a8-c2ee2d0195a5€15.00€0.26matched
45capture01a1a065-e495-7ee4-9a8a-1c263ca36030€49.00€0.67matched
46capture01a1a065-f542-7171-989a-eea3f5247bcc€9.00€0.19matched
47capture01a1a065-f62b-789f-9d51-0995b77f4f06€9.00€0.19matched
48refund01a1a065-f7ee-71db-bb82-ccc28848f62d-€10.00€0.00matched
49capture01a1a066-16e7-793a-9156-10fda9967f8a€24.00€0.37matched
50capture01a1a066-1a02-7216-8b90-00fc88f09418€49.00€0.67matched
51capture01a1a066-250b-73d8-b638-bba32ee2e6e9€35.00€0.50matched
53refund01a1a066-33d6-7990-838b-866ed513cca2-€8.00€0.00matched
54capture01a1a066-3c91-7ab1-b72a-a144efce0db2€49.00€0.67matched
55capture01a1a066-443e-7e8f-82a0-4ff07b335c47€15.00€0.26matched
56capture01a1a066-650a-71e6-80ce-5dbb3c9a16c6€15.00€0.26matched
57capture01a1a066-8776-715c-b6bf-da4d32d77bc2€15.00€0.26matched
58capture01a1a066-a796-7a5e-a666-4c7872cda475€9.00€0.19matched
59capture01a1a066-aba1-7dbb-bb90-60eca5d5b7f5€35.00€0.50matched
60capture01a1a066-d6d6-7e67-b530-3bdec4ae4d41€9.00€0.19matched
61capture01a1a066-d8ae-7065-a760-535198c7fdc2€15.00€0.26matched
62capture01a1a066-e351-711d-a2c8-570c492d317a€49.00€0.67matched
63capture01a1a066-f812-7df6-9fd9-3c2122ef6f43€15.00€0.26matched
64capture01a1a066-fd51-7f25-8b7f-2dc0fc3293bd€24.00€0.37matched
65capture01a1a067-016e-729c-8381-875f9820ba41€15.00€0.26matched
66capture01a1a067-06b2-70b3-82bc-b9904c893c7e€49.00€0.67matched
67capture01a1a067-19ee-7bcb-a69e-5a7ff328a9bc€35.00€0.50matched
68refund01a1a067-228a-7d54-bb8d-ab6189c56fd0-€37.00€0.00matched
69capture01a1a067-31bb-72fb-8058-717ce7d6ce79€9.00€0.19matched
70capture01a1a067-3d4d-7c04-96f9-9f3338da6fb4€24.00€0.37matched
71capture01a1a067-7750-7f1c-bf01-9593faf1f14c€35.00€0.50matched
72capture01a1a067-8705-7c09-be33-c32daf57fc0f€15.00€0.26matched
73capture01a1a067-9012-7197-9666-70b9251906a7€9.00€0.19matched
74capture01a1a067-984c-7f22-97a7-8d8ce9a2b619€24.00€0.37matched
75capture01a1a067-a576-7508-beef-bbf74939c632€15.00€0.26matched
76capture01a1a067-a9a2-771c-8cb4-9687466489a9€49.00€0.67matched
77capture01a1a067-bb4c-7aa8-a6c3-883ed22db6a1€15.00€0.26matched
78capture01a1a067-c343-7168-a4a0-f673224f4def€15.00€0.26matched
79capture01a1a067-da4d-76fe-9ab0-89b1c8362db4€35.00€0.50matched
80capture01a1a067-ea8f-7001-aa41-3a21f5728276€49.00€0.67matched
81capture01a1a068-10c0-70f6-bfa9-ecc93c686eed€35.00€0.50matched
82capture01a1a068-1044-7893-aff7-0f3bee74d532€49.00€0.67matched
83capture01a1a068-1bbe-745f-9917-26e4e8caa752€9.00€0.19matched
84capture01a1a068-242f-7513-bdf1-81084298585f€24.00€0.37matched
85capture01a1a068-ac58-7a0f-94a2-d96392d352d2€35.00€0.50matched
86capture01a1a068-b1ee-7a9a-8efe-eafc2cc68d95€49.00€0.67matched
87capture01a1a068-b4dc-793a-9f08-99a87da2a44c€35.00€0.50matched
88capture01a1a068-e15a-73b0-8491-a7622ac48103€15.00€0.26matched
89capture01a1a068-f518-7ddc-ae23-593366a7cf61€15.00€0.26matched
90capture01a1a068-fd84-7cfc-bf61-c0a3924ac84a€24.00€0.37matched
91capture01a1a069-14c2-7647-946f-6d138bb755c2€49.00€0.67matched
92capture01a1a069-2055-704e-a5e5-ebdfb35336b0€24.00€0.37matched
93capture01a1a069-3354-7ccc-9a6f-fcd4d6caba86€49.00€0.67matched
94capture01a1a069-3354-7bc7-a7ef-84364a6ab6df€49.00€0.67matched
95capture01a1a069-39e4-7849-a8e9-21f0d5903a75€35.00€0.50matched
96capture01a1a069-49e9-7661-a3ee-b0368af1e17f€9.00€0.19matched
97capture01a1a069-7a7a-7a7b-acd0-2bc6f89111cd€35.00€0.50matched
98capture01a1a069-8946-75dd-be74-bf38d6886e56€24.00€0.37matched
99capture01a1a069-a05a-757a-8186-652dd4d5e7de€35.00€0.50matched
100capture01a1a069-abab-79bd-8361-3df839d837b8€15.00€0.26matched
101capture01a1a069-acae-7f35-a6c7-d547828c51de€49.00€0.67matched
102capture01a1a069-e39c-7b3b-9296-85fa426c92da€35.00€0.50matched
103capture01a1a069-fb68-7956-9123-a02cdd361696€15.00€0.26matched
104capture01a1a06a-060c-7cc3-8329-4b220015e025€24.00€0.37matched
105capture01a1a06a-40b9-7f6a-9ac7-6efb4cc04600€49.00€0.67matched
106capture01a1a06a-483a-7f1d-a58e-df06171d7b2c€15.00€0.26matched
107capture01a1a06a-4ae3-711f-83e4-cbef0a95c5a2€49.00€0.67matched
108capture01a1a06a-5ab3-74b6-af90-6306edaa2c44€24.00€0.37matched
109capture01a1a06a-5ae2-78cd-ba09-f74536c38cf5€15.00€0.26matched
110capture01a1a06a-6233-7792-94b7-602b78412f6f€15.00€0.26matched
111capture01a1a06a-6e95-7582-a688-029f4fbc2927€35.00€0.50matched
112capture01a1a06a-b494-78a8-944c-e194f73ba4ed€49.00€0.67matched
113capture01a1a06a-b6b4-72d6-9f00-3c12b3c42a95€9.00€0.19matched
114capture01a1a06a-cddc-7177-830e-2c0755b01598€9.00€0.19matched
115capture01a1a06a-db3e-76e4-92fc-2fae0cb0b29c€49.00€0.67matched
116capture01a1a06a-dd8b-7900-b3e2-3f3f9b37e0f6€35.00€0.50matched
117capture01a1a06a-de5f-7b6d-9e5c-93f139f2b9b6€35.00€0.50matched
118capture01a1a06b-119c-7a04-8d8d-48c3124f6bc5€9.00€0.19matched
119capture01a1a06b-17d6-775e-8671-f35420e86c20€15.00€0.26matched
120capture01a1a06b-183c-776d-b421-6141db467507€49.00€0.67matched
121capture01a1a06b-239a-7354-a8fe-793e96d0d29d€35.00€0.50matched
122capture01a1a06b-5eea-7b91-b732-e45ebc3753eb€35.00€0.50matched
123capture01a1a06b-852f-7443-87e9-277c14b98f35€24.00€0.37matched
124capture01a1a06b-8d88-750f-9112-d4a11df3542b€15.00€0.26matched
125capture01a1a06b-aaa5-798e-9407-1493031bf5ab€24.00€0.37matched
126capture01a1a06b-f6fa-7246-aa72-6cc82e94d8ec€15.00€0.26matched
127capture01a1a06c-05bb-799c-a4de-fde6cb475a64€49.00€0.67matched
128capture01a1a06c-05c7-75b4-903e-e8d7856fd9c9€9.00€0.19matched