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, 02:40

Gross

€3,068.00

PSP fee

€48.33

Net to the bank

€3,019.67

Settlement journal

#353713

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19f4f-e836-7ed7-9381-89c95ef9b9f1 is already settled by stl_EUR_2989456 line 123
  • 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 68, the contract says 67
LineKindReferenceGrossFeeStatus
25capture01a19f49-0267-75a2-94eb-16e2d9fac854€24.00€0.41fee difference
120capture01a19f4f-a254-7b4e-a995-0dc306bea8c5€49.00€0.68fee difference
124capture01a19f4f-e855-7e6e-a443-eca67beb0e23€49.00€0.67duplicate line
1capture01a19f42-c112-79b0-bfaf-671c60577fee€24.00€0.37matched
2capture01a19f47-350b-7d23-ac5d-baf0275d3f07€24.00€0.37matched
3capture01a19f47-4815-7c17-8d91-0ba708987cbe€9.00€0.19matched
4capture01a19f47-497c-74b9-b7c5-37fb2d47d7f7€35.00€0.50matched
5capture01a19f47-5170-7251-be16-bdfe0b028802€49.00€0.67matched
6capture01a19f47-5dc6-79d7-8a09-3801eb29a502€24.00€0.37matched
7capture01a19f47-8ce2-7747-9b52-6b1f1890ddfe€9.00€0.19matched
8capture01a19f47-92b8-7452-8232-9221b1708945€24.00€0.37matched
9capture01a19f47-bc7a-76f0-aa0a-d7c99079b04f€9.00€0.19matched
10capture01a19f47-be3f-7d1e-866e-2db552f5c798€15.00€0.26matched
11refund01a19f48-10b4-70a3-8089-c24de7089e31-€7.00€0.00matched
12capture01a19f48-157b-760c-bdc2-54a029d58711€24.00€0.37matched
13capture01a19f48-2ede-75d8-bee2-48bc19df94b9€9.00€0.19matched
14capture01a19f48-35b6-7485-b7e3-614bf9145273€49.00€0.67matched
15capture01a19f48-368e-7a8b-b090-16dbee945e32€35.00€0.50matched
16capture01a19f48-37e8-7bc8-8740-8284430fc696€35.00€0.50matched
17capture01a19f48-3c05-735f-85da-8cf2b9455ccd€24.00€0.37matched
18capture01a19f48-5cd2-7e8e-94f8-4826544fca7f€9.00€0.19matched
19capture01a19f48-839a-7308-bc2a-2bdaaea3777d€15.00€0.26matched
20capture01a19f48-8551-7135-a49e-e3ee4a134db3€15.00€0.26matched
21capture01a19f48-923b-750f-9e9c-70a3d8c9edf1€35.00€0.50matched
22capture01a19f48-a508-72fe-a3ad-16bf7da1425c€35.00€0.50matched
23capture01a19f48-b197-7623-a322-9cc0cdaa4dc4€35.00€0.50matched
24capture01a19f48-c126-7f14-b35e-978431b4f5bc€35.00€0.50matched
26refund01a19f49-0f24-7d25-8a52-0c9bf4b2dbae-€28.00€0.00matched
27capture01a19f49-6538-7c67-8ceb-5d68bbf41f6f€15.00€0.26matched
28capture01a19f49-7b15-7da4-a77b-9cf53e57b22d€9.00€0.19matched
29capture01a19f49-839f-7a25-a6b4-97496fedb0e9€15.00€0.26matched
30capture01a19f49-9cfa-757b-8a98-66f0ccc5ad8d€15.00€0.26matched
31capture01a19f49-a85c-785f-a131-7b9078643eb1€24.00€0.37matched
32capture01a19f49-bd81-7404-8b03-78879bb58674€15.00€0.26matched
33capture01a19f49-cf8f-764f-92f3-66d978085cdc€35.00€0.50matched
34capture01a19f49-d212-7481-b1d7-b9f133c390ba€24.00€0.37matched
35capture01a19f4a-133b-7691-8830-085e07cfad10€24.00€0.37matched
36capture01a19f4a-1713-7b65-ad5f-583c68a23366€49.00€0.67matched
37capture01a19f4a-3237-776a-b5f2-b6d868e76d91€49.00€0.67matched
38capture01a19f4a-372e-7241-9cac-b4944e1dc810€15.00€0.26matched
39capture01a19f4a-4958-78b0-9b29-dc66d64e88f5€15.00€0.26matched
40capture01a19f4a-4aea-729d-b068-f156c4a3e3a9€24.00€0.37matched
41capture01a19f4a-5469-7564-85e7-befb302c1014€24.00€0.37matched
42capture01a19f4a-5998-7d01-a1cb-97646a73000c€9.00€0.19matched
43capture01a19f4a-6c21-7840-91dc-d68e3e52023d€35.00€0.50matched
44capture01a19f4a-7091-72c8-bacf-2fa6f6ea8b79€49.00€0.67matched
45capture01a19f4a-71c1-7811-93b5-f04891a27197€9.00€0.19matched
46capture01a19f4a-8330-73c2-a61f-d3ba0b737891€24.00€0.37matched
47refund01a19f4a-a5c6-74b6-9978-9412935dbfcb-€4.00€0.00matched
48capture01a19f4a-b44b-75c9-a9b7-bc6a1432db5d€24.00€0.37matched
49capture01a19f4a-cb4a-7f62-8a4a-a2aba8bc05d2€9.00€0.19matched
50capture01a19f4a-db23-7a14-bc47-296e94e0d663€24.00€0.37matched
51capture01a19f4a-f4db-7874-9686-ecd2f81aa059€24.00€0.37matched
52capture01a19f4a-fe10-797d-ac42-d9d4b4f82fe6€15.00€0.26matched
53capture01a19f4b-20ec-7fe2-aa12-9148e4740904€15.00€0.26matched
54refund01a19f4b-4b4b-783a-8b7e-baad1c364c7d-€17.00€0.00matched
55capture01a19f4b-7de2-76c6-bdd0-f70cd38c55f5€9.00€0.19matched
56capture01a19f4b-b199-7db8-ba20-86b797f8c7fb€35.00€0.50matched
57capture01a19f4b-c317-7a0f-91b6-35bed7715a4d€9.00€0.19matched
58capture01a19f4b-f32f-759d-8ce6-9e69b2a4ebf1€24.00€0.37matched
59capture01a19f4c-1bb4-763f-adcf-40e2556f62b3€9.00€0.19matched
60capture01a19f4c-31f3-747a-acf2-dd41bfe57f55€15.00€0.26matched
61capture01a19f4c-3c18-7a8a-a8c4-65356f099d7d€15.00€0.26matched
62capture01a19f4c-5a74-7ff2-b3c9-a1b5b0d95e80€15.00€0.26matched
63capture01a19f4c-7672-73cd-a80f-3ac4cfef20e1€24.00€0.37matched
64capture01a19f4c-7c44-746d-83e9-f615775415a1€35.00€0.50matched
65capture01a19f4c-9cba-7cf9-93a2-4cf43074a299€49.00€0.67matched
66capture01a19f4c-a363-723e-a008-82e15cb17a7d€9.00€0.19matched
67capture01a19f4c-d33b-7da5-a8ab-a4fcb434ca86€49.00€0.67matched
68capture01a19f4c-d373-715b-8009-ec3c92ef9cbe€15.00€0.26matched
69capture01a19f4c-d7f3-75f8-86a2-a039108a2de9€15.00€0.26matched
70capture01a19f4c-da18-782b-8681-91536b1188ce€35.00€0.50matched
71capture01a19f4c-f816-78fb-bbcb-a3453fda9341€15.00€0.26matched
72capture01a19f4c-f835-73ed-a645-2df0c7e70bff€24.00€0.37matched
73capture01a19f4c-fd03-7e53-b1e9-7a64bb3e0362€15.00€0.26matched
74capture01a19f4d-1485-71e8-a278-4fe80d1feb8f€35.00€0.50matched
75refund01a19f4d-37ab-7a91-a6ee-3d0ae0133426-€16.00€0.00matched
76capture01a19f4d-3a45-73a4-a8ce-2973ca212845€49.00€0.67matched
77capture01a19f4d-3e70-7cfd-98e6-10f723325975€15.00€0.26matched
78capture01a19f4d-4236-7456-93f8-769e5eca4c3c€49.00€0.67matched
79capture01a19f4d-5fc3-761f-a650-01842b8a9933€35.00€0.50matched
80capture01a19f4d-7b04-774c-b48d-9778ee4d7f2d€15.00€0.26matched
81capture01a19f4d-8641-7cb0-a625-9d8c504002d4€49.00€0.67matched
82capture01a19f4d-b92e-7c66-9dff-f67403bc0fe7€15.00€0.26matched
83capture01a19f4d-d685-7dce-ae96-1c9c466d36a6€49.00€0.67matched
84capture01a19f4d-e15b-70a8-8f85-07d846399911€49.00€0.67matched
85capture01a19f4e-060c-7f8e-a302-31515dbf43ef€15.00€0.26matched
86capture01a19f4e-09ad-7ab1-ae67-2815146d957e€35.00€0.50matched
87capture01a19f4e-12fd-732a-a69f-0c0d6dfd3e9a€9.00€0.19matched
88capture01a19f4e-1bbd-7809-89bf-c302b1d0bf89€35.00€0.50matched
89capture01a19f4e-1bf3-72c1-99f5-cd8a44daa433€9.00€0.19matched
90capture01a19f4e-3241-71cf-80b3-1b7a3c14ab22€24.00€0.37matched
91capture01a19f4e-3244-78c4-a181-3174acdb027d€35.00€0.50matched
92capture01a19f4e-33e8-794d-82ab-77d8e16df656€15.00€0.26matched
93capture01a19f4e-35ff-7e55-879e-b92feb108b4b€49.00€0.67matched
94capture01a19f4e-3f27-74b9-b00d-7105e38df02a€49.00€0.67matched
95capture01a19f4e-4ce5-7346-a17c-90fffcb1fe41€15.00€0.26matched
96capture01a19f4e-7366-73c0-82fd-8757ba9fc6f1€24.00€0.37matched
97capture01a19f4e-78a2-7e6d-abcb-9a2cd550e4d1€24.00€0.37matched
98capture01a19f4e-845b-760f-a4cd-61d53180f721€15.00€0.26matched
99capture01a19f4e-87a6-7257-8ae7-6a964f929a63€49.00€0.67matched
100capture01a19f4e-9da1-7598-ac44-f529783ab4b6€9.00€0.19matched
101capture01a19f4e-b095-74ec-a66c-7e0392bf5d1f€9.00€0.19matched
102capture01a19f4e-c809-743b-a0e4-2480c2757402€9.00€0.19matched
103capture01a19f4e-dbbc-774f-b7d7-1c6fdde8a1e1€24.00€0.37matched
104capture01a19f4e-eda5-791e-ad5b-42d123aa1421€24.00€0.37matched
105capture01a19f4f-0d92-7d3e-a847-56229a400947€24.00€0.37matched
106capture01a19f4f-1ae6-76e3-bce0-c67effb9fc12€49.00€0.67matched
107capture01a19f4f-2b54-7778-9ee9-811789b4b3c5€24.00€0.37matched
108capture01a19f4f-3405-74d0-a30c-08c1e6aec2b6€35.00€0.50matched
109capture01a19f4f-41cb-7ffb-9027-462ac233fa98€35.00€0.50matched
110capture01a19f4f-44d9-75eb-9e2b-ff09dc8aee01€15.00€0.26matched
111refund01a19f4f-4619-7249-8bc4-2475dd627ddd-€48.00€0.00matched
112capture01a19f4f-5b4f-7f92-88d0-294ef64f7cee€9.00€0.19matched
113capture01a19f4f-5e35-7ea8-8f6f-157592e01c11€15.00€0.26matched
114capture01a19f4f-5fcc-7f76-b6e2-e5fc63b00b9b€49.00€0.67matched
115capture01a19f4f-74de-7962-9bab-0f8b8f97000a€15.00€0.26matched
116capture01a19f4f-75fe-7003-b1b9-9b88a6104919€35.00€0.50matched
117capture01a19f4f-8620-7841-8e2d-5239b8c5943b€49.00€0.67matched
118refund01a19f4f-8669-72b5-8a79-0de20698bd1b-€10.00€0.00matched
119capture01a19f4f-a03d-75c6-b8b7-2478a17a2c27€49.00€0.67matched
121capture01a19f4f-b289-7d63-8132-eb3d4b04cbf6€24.00€0.37matched
122capture01a19f4f-e933-7f85-81a5-2dca7940c71c€49.00€0.67matched
123capture01a19f4f-e855-7e6e-a443-eca67beb0e23€49.00€0.67matched
125capture01a19f4f-f9a2-7c53-90d3-a449fd9f6312€35.00€0.50matched
126capture01a19f50-027b-7b30-912f-02a7ab0e9731€49.00€0.67matched
127capture01a19f50-0683-7891-8aac-eaf1330983f1€9.00€0.19matched
128capture01a19f50-0aa0-7bdb-afb3-037e2f325c1c€15.00€0.26matched
129capture01a19f50-2cf9-7f79-9b85-20341f004121€24.00€0.37matched