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, 10:30

Gross

€2,485.00

PSP fee

€39.44

Net to the bank

€2,445.56

Settlement journal

#341317

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19bd3-89be-7322-ac2a-2b95c19b27d0 is already settled by stl_EUR_2989359 line 41
  • duplicate linethe file lists it twicecapture:01a19bd5-65e2-7606-84e7-fc6a49463f5e is already settled by stl_EUR_2989359 line 71
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 38, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 40, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 1, the contract says 0
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
LineKindReferenceGrossFeeStatus
9capture01a19bcf-5d56-71a6-bbb1-07ca0ec8c023€9.00€0.24fee difference
19capture01a19bd0-b424-7527-9eab-76cde6dc66ac€24.00€0.38fee difference
29capture01a19bd2-23af-73c9-b6fe-3ec65db2b940€49.00€0.72fee difference
42capture01a19bd3-8a04-7380-b907-f889843dc0eb€9.00€0.19duplicate line
45capture01a19bd3-91da-7e00-a9d0-6c9d9894f763€24.00€0.40fee difference
67refund01a19bd4-d224-7b24-8b17-73353b302791-€14.00€0.01fee difference
72capture01a19bd5-6641-7a46-a5c8-f7a9a6436484€9.00€0.19duplicate line
110capture01a19bd8-256f-7bec-a07e-eb734ab2e270€9.00€0.22fee difference
1capture01a19bc7-7c30-7301-9f34-c7faa80a7ec6€24.00€0.37matched
2capture01a19bca-658b-7c1a-872f-e9d7d878ae76€24.00€0.37matched
3capture01a19bcb-725d-7b7e-a0d9-cbb2165747a4€9.00€0.19matched
4refund01a19bcf-2bd9-7187-ae0d-7056e4ee17ab-€5.00€0.00matched
5capture01a19bcf-3aa7-79df-b6d6-72ca329a5ee0€9.00€0.19matched
6capture01a19bcf-46dd-761f-9e64-a1ca358c0da3€9.00€0.19matched
7capture01a19bcf-4846-73f9-b305-fe4b4899e12f€9.00€0.19matched
8capture01a19bcf-51fb-7275-b72f-9465736c42a9€35.00€0.50matched
10capture01a19bcf-7317-7526-abc0-49d5a7ea0c6b€15.00€0.26matched
11capture01a19bcf-9363-7424-85f4-72bf434c49cb€15.00€0.26matched
12capture01a19bcf-9b5b-7f8e-8b7b-80a21dccb261€49.00€0.67matched
13capture01a19bcf-a06c-7b5a-9df0-7bd252a62c76€35.00€0.50matched
14capture01a19bcf-e2df-73f4-8762-03b54c7bd213€9.00€0.19matched
15capture01a19bcf-ec64-74f8-bc84-76390aff1f79€49.00€0.67matched
16capture01a19bd0-2c4f-716b-9732-38cd67e994ae€9.00€0.19matched
17capture01a19bd0-6ac4-734e-a9a1-b31149999069€49.00€0.67matched
18capture01a19bd0-ac5e-739f-82d6-4f8c2f2948e9€35.00€0.50matched
20capture01a19bd1-6a0a-76ed-abbd-894649d42aa1€35.00€0.50matched
21capture01a19bd1-7ac7-76cb-be74-a988b387e7fc€35.00€0.50matched
22capture01a19bd1-7d9e-7830-a7f6-f10cf7bdedde€9.00€0.19matched
23capture01a19bd1-9fe6-7f6c-8de9-129b70eb9279€24.00€0.37matched
24capture01a19bd1-ef7f-7205-85cd-704f45de3dcc€24.00€0.37matched
25capture01a19bd1-f833-7278-bdfe-5daa3d0c3e20€24.00€0.37matched
26capture01a19bd1-fd3c-73fe-94ec-1a96e1eb5a73€49.00€0.67matched
27capture01a19bd1-fd44-7d41-b2d0-9d7bd8b9cbc8€24.00€0.37matched
28capture01a19bd1-fef8-7947-8356-4bb4b9dce365€35.00€0.50matched
30capture01a19bd2-7c98-7596-ad2e-d1806d15f8e0€15.00€0.26matched
31capture01a19bd2-8b48-7dbb-950a-5c25b1fc3b55€49.00€0.67matched
32capture01a19bd2-bfec-7083-a705-d0b932ed01dd€49.00€0.67matched
33capture01a19bd3-1c08-78c0-81c0-9ca089d33b74€49.00€0.67matched
34capture01a19bd3-31ba-7c78-9033-24500860ca6a€35.00€0.50matched
35refund01a19bd3-46a1-779f-a333-0145c2cc99b6-€34.00€0.00matched
36capture01a19bd3-5c39-7735-81a1-e31bbc570771€49.00€0.67matched
37capture01a19bd3-6706-7674-a8c0-33865df93363€15.00€0.26matched
38capture01a19bd3-6e11-7206-af8f-0b42ef0d3bef€35.00€0.50matched
39capture01a19bd3-7551-70bc-9757-13144446620e€9.00€0.19matched
40capture01a19bd3-7ed4-70db-8dd7-acd213373fff€15.00€0.26matched
41capture01a19bd3-8a04-7380-b907-f889843dc0eb€9.00€0.19matched
43capture01a19bd3-91fb-7f00-8802-7ae865ebad37€15.00€0.26matched
44capture01a19bd3-9510-778b-807d-83c1e29c1a3d€15.00€0.26matched
46refund01a19bd3-9ef1-7ab0-b0cf-950add3c5347-€7.00€0.00matched
47capture01a19bd3-aed3-783b-8cc1-d1de687081aa€9.00€0.19matched
48capture01a19bd3-b3c8-7190-a6af-993d2d404645€9.00€0.19matched
49refund01a19bd3-db8d-7987-ba0c-45e2008199e3-€8.00€0.00matched
50refund01a19bd3-ffbd-798b-8143-52c7b70b5fe1-€12.00€0.00matched
51capture01a19bd4-033b-769f-a80f-410dcc27a80e€35.00€0.50matched
52capture01a19bd4-1904-70cf-8bd2-a5448baedb81€9.00€0.19matched
53capture01a19bd4-1b02-792a-981b-f668aeae4057€9.00€0.19matched
54capture01a19bd4-1cbf-7768-89ba-0becd32b37b9€35.00€0.50matched
55capture01a19bd4-4d73-7cea-8a60-d052ac6affd3€49.00€0.67matched
56capture01a19bd4-5e2d-7303-9423-acefadaa176c€9.00€0.19matched
57capture01a19bd4-8625-7b4a-ad25-1feaed824d85€24.00€0.37matched
58refund01a19bd4-8d1d-7ff8-88a2-f352c46b0c5e-€2.00€0.00matched
59capture01a19bd4-904f-7d8d-9d05-4b75e1e2e1d0€9.00€0.19matched
60capture01a19bd4-9b5d-7379-816f-2b3a4509cb35€35.00€0.50matched
61capture01a19bd4-9df0-7480-9c86-3b87e5fdbce0€35.00€0.50matched
62capture01a19bd4-a10a-7207-8a8b-3c13412c244c€49.00€0.67matched
63capture01a19bd4-a4b8-7e38-a209-eb2e69223b50€15.00€0.26matched
64capture01a19bd4-aed7-7dc1-8309-6fce060b88c4€15.00€0.26matched
65capture01a19bd4-bdc6-7856-bb8a-172b6938836e€9.00€0.19matched
66capture01a19bd4-ce7b-7fcd-9538-e74fd4eca1a9€49.00€0.67matched
68capture01a19bd4-dff3-7e23-8e4d-7e74ef4afe38€49.00€0.67matched
69capture01a19bd5-1baa-7de8-9a3a-277d720cd043€35.00€0.50matched
70capture01a19bd5-34e4-714e-aa64-bde8f7cb4dcf€9.00€0.19matched
71capture01a19bd5-6641-7a46-a5c8-f7a9a6436484€9.00€0.19matched
73capture01a19bd5-6981-7ebb-96df-02f39a815f49€9.00€0.19matched
74capture01a19bd5-76a7-7984-aee7-731c307f6726€9.00€0.19matched
75capture01a19bd5-91fb-7000-8774-685b16474a2f€24.00€0.37matched
76capture01a19bd5-9e29-7186-9ebe-a17b867da3e6€49.00€0.67matched
77capture01a19bd5-b25a-7e8c-a673-4751e64b27bf€35.00€0.50matched
78capture01a19bd5-bb3b-7560-b4a8-ee78eda6b5a7€35.00€0.50matched
79capture01a19bd5-c13f-7874-906e-829a6d1bc049€9.00€0.19matched
80capture01a19bd5-c176-7677-9257-d6add21fea34€9.00€0.19matched
81capture01a19bd5-cda4-7384-9dbc-8c679bd33c2e€24.00€0.37matched
82capture01a19bd5-d1b0-7571-8030-af9fc083731e€35.00€0.50matched
83capture01a19bd5-f0e2-7691-8faa-77a2713c1cef€35.00€0.50matched
84capture01a19bd6-2f16-7f63-a581-1805d33c6d72€15.00€0.26matched
85capture01a19bd6-4106-7c4d-b238-cbd897ed27e5€9.00€0.19matched
86capture01a19bd6-5dee-7a35-80b2-8c73a1f3f1e5€24.00€0.37matched
87capture01a19bd6-a46e-744d-af16-32e0eba3880e€35.00€0.50matched
88capture01a19bd6-c85c-7f7c-b411-bc2a5bea26d1€15.00€0.26matched
89capture01a19bd6-d82b-7d54-8f2f-fa18b0dcb92f€24.00€0.37matched
90capture01a19bd6-e8d6-7e34-97ac-80beb160d954€49.00€0.67matched
91capture01a19bd6-f3e2-7181-a99c-e0d336f9afe5€49.00€0.67matched
92capture01a19bd6-f4aa-72b8-86c8-17313fc8a426€15.00€0.26matched
93capture01a19bd7-0b62-7a29-ba8c-2a0ba8d63f1c€9.00€0.19matched
94capture01a19bd7-3a21-723a-942a-0d767729e910€15.00€0.26matched
95capture01a19bd7-57cb-733c-a5b4-8b4d65ee597d€9.00€0.19matched
96capture01a19bd7-60b5-7dd0-a3da-fc7cc46ffa69€24.00€0.37matched
97capture01a19bd7-6577-7e52-9ac7-d121ecac0447€15.00€0.26matched
98capture01a19bd7-a889-73cf-809d-d89fcbccd75a€9.00€0.19matched
99capture01a19bd7-a9fa-7634-bb01-385b4b2926e0€35.00€0.50matched
100capture01a19bd7-b63e-7005-9caa-f721fe96a834€15.00€0.26matched
101capture01a19bd7-d2ce-79f6-9138-a4140c477e36€35.00€0.50matched
102capture01a19bd7-d807-7472-b2c5-e8f27ebac8c2€49.00€0.67matched
103capture01a19bd7-e1aa-7d66-a099-a45284d63669€9.00€0.19matched
104capture01a19bd7-ed07-77c2-82f4-fe86e1ae40e0€35.00€0.50matched
105capture01a19bd7-efbf-720a-8125-7e397761886d€35.00€0.50matched
106capture01a19bd7-f0b5-74be-b7c1-7f7045edbbbf€49.00€0.67matched
107refund01a19bd8-1a51-7b8f-bd82-fb4ffd134546-€7.00€0.00matched
108capture01a19bd8-1a94-79d3-af21-786da89bdd98€24.00€0.37matched
109capture01a19bd8-1d8e-73f6-a820-27c2fa12dda4€49.00€0.67matched
111capture01a19bd8-2a05-7fc5-8da0-52be15e612e5€9.00€0.19matched