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, 04:50

Gross

€2,935.00

PSP fee

€47.41

Net to the bank

€2,887.59

Settlement journal

#410112

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1af38-f403-7579-9ee4-c40f50d0c96f is already settled by stl_EUR_2989901 line 102
  • fee differencethe fee is not the contract feethe fee is 30, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 27, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 28, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 41, the contract says 37
LineKindReferenceGrossFeeStatus
6capture01a1af31-f038-78a1-b352-15177841ca13€15.00€0.30fee difference
23capture01a1af32-b982-70d0-9330-190989bb37fb€15.00€0.27fee difference
64capture01a1af36-10b5-76e4-ba61-0edb4b011e8a€15.00€0.28fee difference
103capture01a1af38-f41f-7e35-bffb-56f4bbb3b598€49.00€0.67duplicate line
106capture01a1af39-1557-710f-b200-6d80e470be6d€49.00€0.70fee difference
111capture01a1af39-6890-7d04-a8b8-7a255ce6bd63€24.00€0.41fee difference
1refund01a1af31-5093-784d-b08d-2b09d5a44634-€5.00€0.00matched
2capture01a1af31-63ee-747f-a907-0827e42756ea€35.00€0.50matched
3capture01a1af31-c0bc-7416-b2d4-783d58227e82€15.00€0.26matched
4capture01a1af31-ca71-75a7-a0e5-782e502cea5d€15.00€0.26matched
5capture01a1af31-eeff-75b8-b12f-f56de4e2f0b3€15.00€0.26matched
7capture01a1af31-dc7e-797b-9c8d-cee674678c36€49.00€0.67matched
8capture01a1af31-f6d4-73ad-b4b5-4a8cc952e088€24.00€0.37matched
9capture01a1af31-f8d3-7ce6-adab-b3499bce3477€35.00€0.50matched
10capture01a1af31-fd17-70ec-b0f8-5a651d88679c€49.00€0.67matched
11capture01a1af32-04b8-743a-b727-e47850b091ed€9.00€0.19matched
12capture01a1af32-13d7-7da6-8862-d137a09e348f€15.00€0.26matched
13capture01a1af32-1caf-700e-bb3e-40d276e17204€24.00€0.37matched
14capture01a1af32-233c-76b8-8f02-f0522b070522€49.00€0.67matched
15capture01a1af32-2ba4-7fd7-8f33-d41315b4bfa4€15.00€0.26matched
16capture01a1af32-3fc1-75ed-8d23-ebd4a654f5f5€15.00€0.26matched
17refund01a1af32-503c-78ae-a6bb-186632d85a44-€15.00€0.00matched
18capture01a1af32-57af-7fdc-bd29-048a805ef8b5€9.00€0.19matched
19capture01a1af32-6f3a-7275-a72f-55baaa8d87db€9.00€0.19matched
20capture01a1af32-9214-7d04-9833-324a064e9897€49.00€0.67matched
21capture01a1af32-b2ba-7a7b-8c8c-4d22c2e90ebf€15.00€0.26matched
22capture01a1af32-b977-7487-8af8-f2ba492b4eda€9.00€0.19matched
24capture01a1af32-bb1c-7062-972b-3833192b8cba€49.00€0.67matched
25capture01a1af32-e65c-726a-afc2-f49d69a1248c€49.00€0.67matched
26capture01a1af32-eafe-7f0c-a09c-959fd7cce55c€24.00€0.37matched
27capture01a1af33-098e-797d-bfe4-91d391b09c07€35.00€0.50matched
28capture01a1af33-17e8-784c-8a9d-0bf4a5c94a4c€15.00€0.26matched
29capture01a1af33-60af-7be8-95c3-667453cbdc24€49.00€0.67matched
30capture01a1af33-70a9-7420-aa2f-4626f2f30154€15.00€0.26matched
31capture01a1af33-8060-7a72-8bfc-7751e41f4f69€15.00€0.26matched
32capture01a1af33-83ca-7630-9698-d0ca76e29da1€49.00€0.67matched
33capture01a1af33-9598-7ddc-8666-836e6f79405c€15.00€0.26matched
34refund01a1af33-c374-7307-928e-536203996382-€13.00€0.00matched
35capture01a1af33-c856-7563-ac88-20ff69cad59c€9.00€0.19matched
36capture01a1af33-cc30-7449-b503-e68fb4eb1583€35.00€0.50matched
37capture01a1af33-d568-7bff-bce9-9458b7a31cc7€9.00€0.19matched
38capture01a1af33-e3e3-7886-ac58-5b6286111c31€35.00€0.50matched
39capture01a1af33-faae-758c-a212-2887009eb1b6€9.00€0.19matched
40capture01a1af33-fd6e-752f-9d8b-0d48783b2622€35.00€0.50matched
41capture01a1af33-fd8d-7a80-8abc-685e837d2ae8€35.00€0.50matched
42capture01a1af34-2c2d-7399-b207-0e93dc8607b4€49.00€0.67matched
43capture01a1af34-421b-7dc3-95c3-bbd0c5c403cd€49.00€0.67matched
44capture01a1af34-4efa-7845-892e-35ded4b1543d€9.00€0.19matched
45capture01a1af34-8240-79b6-80f8-28f7a8d3075e€9.00€0.19matched
46capture01a1af34-8672-7f1a-afc6-2b1ba3d95b78€35.00€0.50matched
47capture01a1af34-89f4-79b7-93a3-18da1ea87272€49.00€0.67matched
48refund01a1af34-91a9-7430-a126-ed384a660271-€48.00€0.00matched
49capture01a1af34-987c-7e83-8698-5724c8d4b6ab€35.00€0.50matched
50capture01a1af34-be93-7f7d-9b16-0053a322d5fb€9.00€0.19matched
51capture01a1af34-cda9-7e4a-a146-858a28e1d1b9€24.00€0.37matched
52capture01a1af34-d9f2-7cb2-b481-980a866f308d€15.00€0.26matched
53capture01a1af34-dbcb-74e2-bf58-b4ebb256f492€49.00€0.67matched
54capture01a1af34-f8f5-75a5-9d1e-18882e3d0589€15.00€0.26matched
55capture01a1af34-faaa-7370-8bb2-563424589851€9.00€0.19matched
56capture01a1af35-0cf8-70e1-85fc-5e787e4754c9€49.00€0.67matched
57capture01a1af35-4328-7f0f-bbc3-e418c8c06305€49.00€0.67matched
58capture01a1af35-6ecc-7eb5-b827-218d3cedbc4e€24.00€0.37matched
59capture01a1af35-8f09-730c-94f6-8504c54cac20€9.00€0.19matched
60capture01a1af35-adb1-7254-b883-8b383ab3560f€35.00€0.50matched
61capture01a1af35-d3cb-7d25-9c59-a072d0665da9€24.00€0.37matched
62refund01a1af36-046d-7f97-85c9-52bb85b9e09d-€20.00€0.00matched
63capture01a1af36-078f-795f-bc1c-35717c79bd2c€35.00€0.50matched
65capture01a1af36-3567-78d4-ab33-490b288807c4€9.00€0.19matched
66capture01a1af36-4415-7fa8-a3a6-8c8a24ea2323€49.00€0.67matched
67capture01a1af36-5af8-7c72-9f7f-e9c2bd0d42c8€49.00€0.67matched
68capture01a1af36-5bdb-70be-8158-3fc0d4086d0f€9.00€0.19matched
69capture01a1af36-6c36-7175-90c3-898e0cacd6b9€35.00€0.50matched
70capture01a1af36-7882-7f82-bced-d0adfa3519c4€49.00€0.67matched
71capture01a1af36-8b0b-7e79-9e3c-d9954f1be3a3€35.00€0.50matched
72capture01a1af36-8d2d-7d61-86e0-b496fe693135€24.00€0.37matched
73capture01a1af36-dfe4-78ec-b503-8da315413f77€49.00€0.67matched
74capture01a1af36-ece4-7ec6-8e7e-10dc99b40e81€15.00€0.26matched
75capture01a1af36-ed38-760b-ac6e-35d6b25e74f3€24.00€0.37matched
76capture01a1af36-efce-7e17-8fed-4759d035ba83€9.00€0.19matched
77capture01a1af37-007e-7c07-b47d-bd23012c1e6c€35.00€0.50matched
78capture01a1af37-1be4-7360-88b7-c46cbfada27e€24.00€0.37matched
79capture01a1af37-20f6-7814-8d66-0a31e6c6ac9b€49.00€0.67matched
80capture01a1af37-2b18-78ef-8b84-5b73f9d98ce0€9.00€0.19matched
81capture01a1af37-6fa8-7163-95bd-026e0ea0c59f€9.00€0.19matched
82capture01a1af37-ab36-7a8b-8e91-3d5322b34bc7€24.00€0.37matched
83capture01a1af37-b218-72e5-8037-3b8759a2c01d€49.00€0.67matched
84capture01a1af37-c09c-76e2-8c85-b1c1ad86c3c5€49.00€0.67matched
85capture01a1af37-d16e-721a-abb5-08d5a80bb37c€24.00€0.37matched
86capture01a1af37-d710-7c54-a91a-4b31dd9312ef€24.00€0.37matched
87capture01a1af37-d7da-787a-9817-9e9286eb3eb2€35.00€0.50matched
88capture01a1af37-f530-7060-967b-4c7bdf62e92a€49.00€0.67matched
89refund01a1af38-011f-7994-be56-06f77f801735-€46.00€0.00matched
90capture01a1af38-0574-75ba-a09a-1994276b8d83€15.00€0.26matched
91capture01a1af38-0ec0-738e-aba9-479ffa8cf13e€24.00€0.37matched
92capture01a1af38-1a2b-7dd9-bc29-f734e940ca89€35.00€0.50matched
93capture01a1af38-1c20-77db-bab8-77784bae5a7f€35.00€0.50matched
94refund01a1af38-4c27-7170-b775-fe476a101b60-€33.00€0.00matched
95capture01a1af38-8c82-747c-b78b-d826e7f93e24€15.00€0.26matched
96capture01a1af38-a96a-72f0-8290-1c808c676a71€9.00€0.19matched
97capture01a1af38-b440-762d-9058-c083f5ba1021€9.00€0.19matched
98capture01a1af38-cff0-77a2-ba38-b8e2ae1edd0d€15.00€0.26matched
99capture01a1af38-e8ad-7e44-92f4-d74d9623f16a€49.00€0.67matched
100capture01a1af38-eb56-78ec-aadf-a7b5ab16bbfa€15.00€0.26matched
101capture01a1af38-ebbc-7fc3-8a6e-c70e18622268€24.00€0.37matched
102capture01a1af38-f41f-7e35-bffb-56f4bbb3b598€49.00€0.67matched
104capture01a1af39-0fea-70c3-86f1-3d0480131f48€35.00€0.50matched
105capture01a1af39-0f43-73dd-b9f7-ceb58a729e5d€35.00€0.50matched
107capture01a1af39-20e3-7fbc-b927-b9fde636f682€35.00€0.50matched
108capture01a1af39-2ca6-789f-8ca5-3e755a48ed94€35.00€0.50matched
109capture01a1af39-32c3-7c38-9f64-2b29c35ed5ef€15.00€0.26matched
110refund01a1af39-46f8-7c11-b735-df0ae061fac6-€34.00€0.00matched
112capture01a1af39-6a7b-77b1-807f-6195638d3af5€49.00€0.67matched
113capture01a1af39-76de-7012-a4f1-2d8c0a62c002€15.00€0.26matched
114refund01a1af39-774d-72e3-9ce5-018dbe7afa92-€19.00€0.00matched
115capture01a1af39-7bbc-74a8-9aa3-d0ef0ef99e4d€35.00€0.50matched
116capture01a1af39-9600-72fc-b51a-6da5e02243de€9.00€0.19matched
117capture01a1af39-adc1-7192-9529-d17b1352938b€9.00€0.19matched
118capture01a1af39-ba75-716e-b33f-449a89ac7c36€35.00€0.50matched
119capture01a1af39-cafe-7413-a170-17ac9fa0d18b€9.00€0.19matched
120capture01a1af3a-15c5-75da-8fcc-54e2b88e335a€49.00€0.67matched
121capture01a1af3a-1fa6-72d2-88bc-8dc5f080e490€49.00€0.67matched
122capture01a1af3a-4248-7ebb-bf32-3d22b0ef9ba2€24.00€0.37matched
123capture01a1af3a-5bbc-7672-bd2e-98292128df14€15.00€0.26matched