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, 15:20

Gross

€3,023.00

PSP fee

€47.55

Net to the bank

€2,975.45

Settlement journal

#344976

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19cd9-dedd-727d-a823-172dab4322f8 is already settled by stl_EUR_2989388 line 26
  • 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 70, the contract says 67
LineKindReferenceGrossFeeStatus
18capture01a19cd9-6510-7635-8319-575bfb72ccaa€24.00€0.38fee difference
27capture01a19cd9-df03-79d5-8572-9de6a5aad983€24.00€0.37duplicate line
95capture01a19cde-f4e3-759c-abac-8a1de8253e03€49.00€0.70fee difference
1capture01a19cd4-7f70-7322-a990-14650ce0a1ee€15.00€0.26matched
2capture01a19cd5-4a1c-7089-8d47-ca88d705acfa€15.00€0.26matched
3capture01a19cd8-a102-7068-8f16-892b697d3a6a€9.00€0.19matched
4capture01a19cd8-a271-7ffc-b149-05205af2a392€24.00€0.37matched
5capture01a19cd8-b7be-70c1-96d0-01cab780da83€24.00€0.37matched
6capture01a19cd8-b7f0-74e9-8834-8c6811b1e930€35.00€0.50matched
7capture01a19cd8-bcd2-7d86-a462-2aaa852a1abb€24.00€0.37matched
8capture01a19cd8-de55-79ad-98ec-bf2ca8ec6004€9.00€0.19matched
9capture01a19cd8-f3a4-71de-afef-6fa9c0ca7d32€49.00€0.67matched
10capture01a19cd9-0224-742c-aa44-415383b79458€15.00€0.26matched
11capture01a19cd9-0b1c-7e62-9ab7-056f6ef1b2ab€9.00€0.19matched
12refund01a19cd9-2145-7986-b6ce-02a5e585f1ac-€29.00€0.00matched
13capture01a19cd9-2c02-78cf-8d02-e776d088bef7€15.00€0.26matched
14capture01a19cd9-3c31-7362-a9ef-b27d87efa433€24.00€0.37matched
15capture01a19cd9-484f-726e-9e25-f5f0f2c2a855€15.00€0.26matched
16capture01a19cd9-5341-708a-83bd-8da1f5270223€9.00€0.19matched
17capture01a19cd9-5a26-7f27-bd1f-48fe12d67166€24.00€0.37matched
19capture01a19cd9-669b-72a6-9686-44270fe57a92€49.00€0.67matched
20capture01a19cd9-68d9-7f58-8bfb-3a8569fa1007€15.00€0.26matched
21refund01a19cd9-7027-77ea-b0f1-3b8b2a8081c8-€13.00€0.00matched
22capture01a19cd9-7303-7a26-802e-45711eb84e59€35.00€0.50matched
23capture01a19cd9-86a7-7584-9426-4e0bacea5537€35.00€0.50matched
24refund01a19cd9-a8e4-79fa-a401-ad4627cc50f0-€36.00€0.00matched
25capture01a19cd9-ba1e-7645-a2aa-2910d29177cb€24.00€0.37matched
26capture01a19cd9-df03-79d5-8572-9de6a5aad983€24.00€0.37matched
28capture01a19cd9-f827-7ab4-b65f-e7aee0045caf€35.00€0.50matched
29capture01a19cd9-fb67-7f19-8c9f-c050d2d42f3a€24.00€0.37matched
30capture01a19cda-02a4-7f4b-b68a-b228a3a35279€49.00€0.67matched
31capture01a19cda-11c9-79b9-acdc-c762d5b068d4€35.00€0.50matched
32capture01a19cda-2451-7919-8519-cbd68ad93384€35.00€0.50matched
33capture01a19cda-2d8d-7905-aff8-39b9850e903e€49.00€0.67matched
34capture01a19cda-36cd-7a53-938a-eb230e3283b9€35.00€0.50matched
35capture01a19cda-455f-7f66-9d6b-60719addb1da€9.00€0.19matched
36capture01a19cda-46ee-76fe-9ee8-d24153069ef9€35.00€0.50matched
37capture01a19cda-5e23-761b-af54-eca2135a6a92€15.00€0.26matched
38capture01a19cda-7343-704a-9f1c-50ecd9664448€35.00€0.50matched
39capture01a19cda-7dd8-7bb6-b645-e5aae07b9a2e€9.00€0.19matched
40capture01a19cda-965f-7cab-acab-2dc4887161a7€35.00€0.50matched
41capture01a19cda-d34c-7d8c-83ef-6aaa30043243€35.00€0.50matched
42capture01a19cdb-3017-743a-9b81-b9d931cac149€24.00€0.37matched
43capture01a19cdb-3e44-7e72-af19-3cc5d4ab1445€35.00€0.50matched
44capture01a19cdb-44e7-7a4f-88d8-0a4359f0f84b€35.00€0.50matched
45capture01a19cdb-52b6-7452-ac60-de2839fbacf7€15.00€0.26matched
46capture01a19cdb-5ccf-7b73-af2a-5700b562fd53€9.00€0.19matched
47capture01a19cdb-6e6d-7e5d-9d31-aac06fc331b9€15.00€0.26matched
48capture01a19cdb-7461-7184-a63d-d4bd410e4a04€35.00€0.50matched
49capture01a19cdb-76de-7956-a1f0-ee194ad94b1f€9.00€0.19matched
50capture01a19cdb-7c38-7f60-88d3-b7c6150eecac€35.00€0.50matched
51capture01a19cdb-8d41-74e1-9bc5-d10a93161219€9.00€0.19matched
52capture01a19cdb-dbd2-7c6e-ab40-cda3c2702b00€9.00€0.19matched
53capture01a19cdb-e598-7f54-b742-4fb150cf0a2a€15.00€0.26matched
54capture01a19cdb-ef96-7206-909e-532a2223c4e1€49.00€0.67matched
55capture01a19cdb-fb8f-78da-924f-3b71d40f6ac5€24.00€0.37matched
56capture01a19cdc-12c4-723c-94ea-f61b144233c5€35.00€0.50matched
57capture01a19cdc-2416-7fd7-974b-3c67dd924248€49.00€0.67matched
58capture01a19cdc-3f9d-7713-889e-713b74d9bab4€9.00€0.19matched
59capture01a19cdc-5532-783e-a2ae-dd5317307b69€9.00€0.19matched
60capture01a19cdc-792f-72b7-ac44-cebe6adf9498€15.00€0.26matched
61capture01a19cdc-9d96-7612-8c71-04bc4c7acfe9€15.00€0.26matched
62capture01a19cdc-c25c-739d-a7ed-f3acb460909e€49.00€0.67matched
63capture01a19cdc-c85e-7027-b4d8-88381dd79190€9.00€0.19matched
64capture01a19cdc-d0aa-7844-8ad6-447fe8d4bdba€9.00€0.19matched
65capture01a19cdc-ebfb-7717-8157-5dcb8f9df3c4€15.00€0.26matched
66refund01a19cdc-f3ea-76f6-a315-b1c656526d14-€8.00€0.00matched
67capture01a19cdc-f5d9-76dd-a875-760c047a5fc9€9.00€0.19matched
68capture01a19cdd-0422-79ef-889e-a1153f6aa658€49.00€0.67matched
69capture01a19cdd-1693-767a-bb07-b1fc6244c79c€24.00€0.37matched
70capture01a19cdd-2350-7d35-850b-55ccb105c515€49.00€0.67matched
71capture01a19cdd-3288-7560-98aa-f2553926255c€24.00€0.37matched
72capture01a19cdd-3436-73dc-80d3-a4144b43696e€35.00€0.50matched
73capture01a19cdd-38e0-73b3-baf2-07dfbd4eb2d9€15.00€0.26matched
74capture01a19cdd-52c3-7096-9a2e-01110d695fc4€24.00€0.37matched
75capture01a19cdd-55a6-764b-9830-3d501f507caf€49.00€0.67matched
76capture01a19cdd-6a44-770f-b70a-d95471088c0c€35.00€0.50matched
77capture01a19cdd-7e61-7f66-a21d-337c42eaf86c€24.00€0.37matched
78capture01a19cdd-9276-79b1-be2f-b46a81d64691€9.00€0.19matched
79capture01a19cdd-acec-7ddc-ba2a-5262b08e7288€49.00€0.67matched
80refund01a19cdd-b695-71de-abf7-da88e15015b4-€24.00€0.00matched
81capture01a19cdd-da6f-7537-9dc3-901c28c3a770€49.00€0.67matched
82refund01a19cdd-f390-7798-b221-a11f354b116b-€15.00€0.00matched
83capture01a19cde-2299-7bca-ad5a-6662f95c3ace€35.00€0.50matched
84capture01a19cde-246a-7200-8256-1db4fee5c24b€24.00€0.37matched
85capture01a19cde-3df7-7fee-9fae-b3e22a4eea39€15.00€0.26matched
86capture01a19cde-4ece-7736-8a61-8535908eafb8€24.00€0.37matched
87capture01a19cde-5765-7374-b3ac-300c1b4d790e€24.00€0.37matched
88capture01a19cde-6c30-759b-a306-f6cf1cb48f52€24.00€0.37matched
89capture01a19cde-792d-75ac-87e6-0388629643d1€49.00€0.67matched
90capture01a19cde-c2f6-71f1-8e7e-de1f83c73823€35.00€0.50matched
91capture01a19cde-d8b2-7f0e-bf7d-ceaf51b529da€24.00€0.37matched
92capture01a19cde-df48-7dda-9bc7-66e203fe1ba2€15.00€0.26matched
93capture01a19cde-e192-7f9b-9a12-173e74d69abd€15.00€0.26matched
94capture01a19cde-f349-7e37-a5be-9c8ee5e0d650€24.00€0.37matched
96capture01a19cdf-3eb4-7e00-b41c-cc3071126b5f€15.00€0.26matched
97capture01a19cdf-432a-7589-8126-6cb4480aea6d€35.00€0.50matched
98capture01a19cdf-434a-7dda-8500-a00c070a393d€9.00€0.19matched
99capture01a19cdf-4a6f-7656-aa6b-09d1e55c2e8e€9.00€0.19matched
100capture01a19cdf-5a92-773f-8b4e-d053923c90de€49.00€0.67matched
101capture01a19cdf-6d4d-7eb5-81c9-f9da66f7a4d9€9.00€0.19matched
102capture01a19cdf-8104-78a5-9709-185bd0d4061e€49.00€0.67matched
103capture01a19cdf-78ff-7511-9e47-cc1fb0c1e6f7€24.00€0.37matched
104capture01a19cdf-a06c-7823-bf3e-aee286f63621€35.00€0.50matched
105capture01a19cdf-f348-7dcc-a97c-7c1e52546853€35.00€0.50matched
106capture01a19ce0-07b3-756e-a4b0-6b09a25db856€15.00€0.26matched
107capture01a19ce0-3070-73cc-81c1-7f4c07685936€35.00€0.50matched
108capture01a19ce0-350f-717b-b95a-ec5fa94d5ca6€35.00€0.50matched
109capture01a19ce0-546d-709e-bb5e-30f521ff5434€15.00€0.26matched
110capture01a19ce0-5ff4-7da5-b4ea-b347ce19d94f€24.00€0.37matched
111capture01a19ce0-6984-7b8e-90b8-db82286758d0€15.00€0.26matched
112capture01a19ce0-7de6-7890-b701-335f606e75ac€15.00€0.26matched
113capture01a19ce0-a54e-7b9e-bc75-79ebdb7843a7€9.00€0.19matched
114capture01a19ce0-a690-7799-bde2-e6193ea6ff73€35.00€0.50matched
115capture01a19ce0-ac60-725b-8014-cebe6414011d€35.00€0.50matched
116capture01a19ce0-b100-7a78-a6ab-b788b2f04383€15.00€0.26matched
117capture01a19ce0-d356-7c8b-97cb-9961497845c0€9.00€0.19matched
118capture01a19ce1-05b9-7707-bacf-50f3b1345291€49.00€0.67matched
119capture01a19ce1-1ba0-76ab-a900-15d7e1608e12€9.00€0.19matched
120capture01a19ce1-2829-7911-9f89-cb8bb4357a39€49.00€0.67matched
121capture01a19ce1-2f31-7599-849c-d49dea1ee987€49.00€0.67matched
122capture01a19ce1-63de-7cd3-a089-2845a1971d01€24.00€0.37matched
123capture01a19ce1-8475-7505-ad2e-186ab5809348€35.00€0.50matched
124capture01a19ce1-947e-7cd3-acc9-b20d1d9ec5bc€24.00€0.37matched
125capture01a19ce1-98ce-7c40-ad3a-278e6e28a816€35.00€0.50matched
126capture01a19ce1-9fc7-7e72-8520-ae57238cba60€35.00€0.50matched