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

6 Nov, 00:30

Gross

€2,715.00

PSP fee

€42.51

Net to the bank

€2,672.49

Settlement journal

#406745

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ae49-7f3b-7905-94f6-6a4d3a3a6b5c is already settled by stl_EUR_2989875 line 73
  • fee differencethe fee is not the contract feethe fee is 31, the contract says 26
LineKindReferenceGrossFeeStatus
16capture01a1ae44-be13-7dd3-8c4c-f07210907f70€15.00€0.31fee difference
74capture01a1ae49-7f53-7cb2-a084-f0b02ebeac50€35.00€0.50duplicate line
1capture01a1ae3d-574e-7149-a762-46cfcdecf65b€9.00€0.19matched
2capture01a1ae41-ced9-70cd-9e35-f402a0fb447a€49.00€0.67matched
3capture01a1ae42-9aff-7e73-b4d8-348b69ae22da€24.00€0.37matched
4capture01a1ae43-4196-7932-98e1-fc9bc16ab1c8€24.00€0.37matched
5capture01a1ae43-6f1f-749b-8287-f2901f31a5f4€9.00€0.19matched
6capture01a1ae43-7689-7747-ae09-34d55027d423€9.00€0.19matched
7capture01a1ae43-8995-7eeb-b8da-532dd5a64abe€9.00€0.19matched
8capture01a1ae43-c6af-7d2d-b4bc-77a6d3bc85a6€15.00€0.26matched
9capture01a1ae43-dddd-788a-ade3-e4981aaa8b8e€35.00€0.50matched
10capture01a1ae43-ff36-7e4c-b5ae-bd01ccdbc256€35.00€0.50matched
11capture01a1ae44-1556-75ad-9f1d-d5bd48396e3e€15.00€0.26matched
12capture01a1ae44-894f-7737-bde0-424429162d6e€15.00€0.26matched
13capture01a1ae44-9156-72e4-bd3c-02fb5dbe4761€35.00€0.50matched
14capture01a1ae44-ae98-7d6b-8066-44c58b6a8889€49.00€0.67matched
15capture01a1ae44-b689-7439-84ec-280bbd44bfe8€15.00€0.26matched
17refund01a1ae44-e65a-7b5e-a30c-5159e615a6c0-€11.00€0.00matched
18capture01a1ae44-edd3-7a4f-9738-c56b68963892€24.00€0.37matched
19capture01a1ae44-f36e-73fb-93d7-3fb6e07d0e61€35.00€0.50matched
20capture01a1ae44-f526-7c88-872e-1ca7f5147060€9.00€0.19matched
21capture01a1ae45-120e-7ebc-9039-c7bae4f5555a€9.00€0.19matched
22capture01a1ae45-4e81-798b-bd8f-1096b67599ec€35.00€0.50matched
23capture01a1ae45-627c-7671-9d67-96e100a1a51f€15.00€0.26matched
24capture01a1ae45-79a8-70c3-9f59-38092636e034€24.00€0.37matched
25capture01a1ae45-c46e-79eb-b89a-7b4acb8be040€15.00€0.26matched
26capture01a1ae45-cad6-70dc-b54d-3fb264e29c94€24.00€0.37matched
27capture01a1ae46-0830-73ca-977f-51b48da8333c€9.00€0.19matched
28capture01a1ae46-246f-773a-8472-9c68e4209126€15.00€0.26matched
29capture01a1ae46-49eb-7061-a967-04b392ebd80c€9.00€0.19matched
30capture01a1ae46-5b16-7fc1-8ee4-b68ef5494e84€35.00€0.50matched
31capture01a1ae46-5c58-765c-bc88-c4c7f52ab059€49.00€0.67matched
32capture01a1ae46-5dc4-7e06-b28f-37c2882d82a8€49.00€0.67matched
33capture01a1ae46-6270-76d7-9403-1d9307bc7362€24.00€0.37matched
34capture01a1ae46-6d44-74a1-8c87-573d0682899d€49.00€0.67matched
35capture01a1ae46-7416-7ffb-9dcc-2185e9b2fbd0€35.00€0.50matched
36capture01a1ae46-80ea-7d2e-98f7-38afeb729269€49.00€0.67matched
37capture01a1ae46-8db4-7f72-aecb-2897f75d0166€49.00€0.67matched
38capture01a1ae46-8e26-772f-9b6c-b8bc8edd8766€9.00€0.19matched
39capture01a1ae46-bd81-751e-b4a0-0772e7691557€35.00€0.50matched
40capture01a1ae46-cb96-78b1-b955-50ab45f93bef€24.00€0.37matched
41capture01a1ae46-e352-7a25-b87d-96df625f10c8€15.00€0.26matched
42capture01a1ae46-f858-76eb-810e-2ae1a73e1f6e€49.00€0.67matched
43capture01a1ae47-2824-7871-8260-6d30c02536d7€49.00€0.67matched
44capture01a1ae47-316e-76e4-aa7c-0f85700d02dd€9.00€0.19matched
45capture01a1ae47-61e2-7bc0-b89f-2b975e88906b€49.00€0.67matched
46capture01a1ae47-8121-7c1e-896b-1b8558eb6d43€24.00€0.37matched
47capture01a1ae47-bb14-70a2-ac45-8845a04fa3cc€49.00€0.67matched
48refund01a1ae47-bb97-78c6-9a59-33b9ea351d07-€26.00€0.00matched
49capture01a1ae47-c309-7f68-a380-770f5a89ef1e€49.00€0.67matched
50capture01a1ae47-ce06-732e-be98-02456e53e23f€24.00€0.37matched
51capture01a1ae47-e1e9-7768-ad85-5d1924b72aec€35.00€0.50matched
52capture01a1ae48-08ef-7cf3-82ac-17819960d9b2€24.00€0.37matched
53capture01a1ae48-2034-7e0b-badf-e3569f69426d€24.00€0.37matched
54capture01a1ae48-4f58-7862-8a1d-e68e5bcc45c0€24.00€0.37matched
55capture01a1ae48-533d-78c0-9cb6-2f60db0586ef€9.00€0.19matched
56capture01a1ae48-57c2-7333-820a-a77edf741342€49.00€0.67matched
57refund01a1ae48-62ae-78cd-9a37-6f9c83ce6671-€6.00€0.00matched
58capture01a1ae48-6c9f-742b-b060-ca94a38ddce3€9.00€0.19matched
59capture01a1ae48-8092-7dbc-8d40-1715fb0bbb5d€15.00€0.26matched
60capture01a1ae48-8335-7b5d-8de2-7eb22eac02c4€24.00€0.37matched
61refund01a1ae48-8cc1-7062-a4d9-6824de8837d9-€16.00€0.00matched
62capture01a1ae48-9e8d-7498-a750-6399204e0d59€49.00€0.67matched
63capture01a1ae48-a447-76c5-a691-1bce3a62d2da€49.00€0.67matched
64capture01a1ae48-e0f2-741f-bf5f-c15a6796d8dc€24.00€0.37matched
65capture01a1ae48-e59c-71f3-90cf-2b4b81d7c376€15.00€0.26matched
66capture01a1ae48-ed71-70cf-9042-77ce531711a1€24.00€0.37matched
67capture01a1ae49-004a-7409-9001-fc84bc1c0af7€24.00€0.37matched
68capture01a1ae49-1104-73ce-95e7-d5ae643d3973€24.00€0.37matched
69capture01a1ae49-166e-74de-94b4-5d99d4b54a04€9.00€0.19matched
70capture01a1ae49-2ec7-75c8-928e-d14eb93b327f€9.00€0.19matched
71capture01a1ae49-60e8-7108-8c51-23097a87755f€15.00€0.26matched
72capture01a1ae49-7285-790f-a7c4-c01e1ae9fff6€24.00€0.37matched
73capture01a1ae49-7f53-7cb2-a084-f0b02ebeac50€35.00€0.50matched
75capture01a1ae49-81d7-7000-99fe-86f5e8c07d3f€9.00€0.19matched
76capture01a1ae49-9f11-7849-b58c-487d21f38b99€15.00€0.26matched
77capture01a1ae49-a9f2-7405-9f1c-0a3d070bc0b0€35.00€0.50matched
78capture01a1ae49-ba01-741e-a06e-16549c9be631€49.00€0.67matched
79refund01a1ae49-bc46-708f-954f-777b69c3df96-€8.00€0.00matched
80refund01a1ae49-c411-7e2e-b9c4-aeae10bc9881-€19.00€0.00matched
81capture01a1ae49-d4eb-7643-ab41-4f7099092356€15.00€0.26matched
82capture01a1ae49-ddaa-75a4-8458-f2217f1cfda0€35.00€0.50matched
83capture01a1ae4a-135c-7daf-a482-335651a8dc0c€24.00€0.37matched
84capture01a1ae4a-1e6a-7ded-bcc3-203bd728d582€24.00€0.37matched
85capture01a1ae4a-5036-756c-86ee-d3b3c7540fff€49.00€0.67matched
86capture01a1ae4a-6328-7dbd-b9f9-686cba432540€49.00€0.67matched
87capture01a1ae4a-6645-73b0-8195-734cbaa5310f€49.00€0.67matched
88capture01a1ae4a-a441-7c8e-8cc3-18574c263388€9.00€0.19matched
89capture01a1ae4a-a69c-72a1-89e9-0ad89d69165e€9.00€0.19matched
90capture01a1ae4a-bdcd-7a90-a053-36a3b2018a84€35.00€0.50matched
91capture01a1ae4a-caf3-7023-a17e-dbc31b36c1af€9.00€0.19matched
92capture01a1ae4a-d438-75bb-b794-e7bb07c06c67€49.00€0.67matched
93capture01a1ae4a-e74f-75f6-a13b-4cab1a580d8e€15.00€0.26matched
94refund01a1ae4b-0acf-73db-8bd7-b3fa643d416d-€12.00€0.00matched
95capture01a1ae4b-16ea-7607-b262-0f95b9afc868€24.00€0.37matched
96capture01a1ae4b-3d6b-72f2-b544-2c2d30f77bdb€24.00€0.37matched
97capture01a1ae4b-4771-75e1-9047-e4330821ed63€15.00€0.26matched
98refund01a1ae4b-4b85-770a-af20-c4c83a997d57-€8.00€0.00matched
99capture01a1ae4b-4e58-7bf3-b67f-7bf78490672f€35.00€0.50matched
100capture01a1ae4b-6bc2-7916-aca8-d541de639727€35.00€0.50matched
101capture01a1ae4b-8382-7770-b6f1-3390f85f0b19€49.00€0.67matched
102capture01a1ae4b-93a1-701a-a7ef-3282acffc267€24.00€0.37matched
103capture01a1ae4b-9861-7eb5-8bf4-67c4c19b052d€9.00€0.19matched
104capture01a1ae4b-bf50-704a-8a96-3c8b152e0b8b€49.00€0.67matched
105capture01a1ae4b-cefa-7ffc-87d2-d05dfdfa1f08€24.00€0.37matched
106capture01a1ae4b-e732-772c-985a-f6470cebadf4€35.00€0.50matched
107capture01a1ae4b-f14a-743a-95c4-53081e4882ec€49.00€0.67matched
108capture01a1ae4b-fa41-7288-b273-b18dd7bdb85f€24.00€0.37matched
109capture01a1ae4c-0059-755c-b1f8-ecd50118fc1f€9.00€0.19matched
110refund01a1ae4c-42a3-71af-a4d7-1332c087180b-€19.00€0.00matched
111capture01a1ae4c-4fd1-73bc-bd42-4409200a7968€49.00€0.67matched
112capture01a1ae4c-50c2-7052-a752-a5826c619f04€49.00€0.67matched