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

5 Nov, 12:00

Gross

€2,992.00

PSP fee

€46.60

Net to the bank

€2,945.40

Settlement journal

#397195

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ab99-99bd-7c97-9e90-1e60786ce420 is already settled by stl_EUR_2989800 line 76
  • fee differencethe fee is not the contract feethe fee is 40, the contract says 37
  • missing linein the books, not in the filecapture:01a1ab99-84e7-7885-8cb6-954167b8884b is in no file
LineKindReferenceGrossFeeStatus
77capture01a1ab99-99e8-79df-98e9-416b74c105dc€49.00€0.67duplicate line
1capture01a1ab94-8a5f-70d3-a122-c41790154bc5€9.00€0.19matched
2capture01a1ab94-995b-7b36-8169-408f9e223b99€49.00€0.67matched
3capture01a1ab94-f77a-773d-b1e2-a2f59a24f77f€15.00€0.26matched
4capture01a1ab95-0890-7f8d-bf4d-c51fbc6c0e1c€15.00€0.26matched
5capture01a1ab95-11d9-7612-aa95-2fe7c5674fc1€35.00€0.50matched
6capture01a1ab95-1aac-7d0f-b20c-a3d386a3b5c0€24.00€0.37matched
7capture01a1ab95-1e29-7dec-97a9-ccfcb3f9b695€35.00€0.50matched
8capture01a1ab95-2868-7f7a-813d-0288e798146c€49.00€0.67matched
9capture01a1ab95-2b83-7d73-b124-170f5f7490a8€35.00€0.50matched
10capture01a1ab95-3a4b-710c-9e8e-8005dc4659d7€24.00€0.37matched
11capture01a1ab95-490a-71e8-844a-318d705e73fe€9.00€0.19matched
12capture01a1ab95-7848-7046-92e4-0da1a5a0adfb€9.00€0.19matched
13capture01a1ab95-ad40-746e-b6d1-5f336bead578€15.00€0.26matched
14capture01a1ab95-c30a-70b1-823e-63e31280e18e€15.00€0.26matched
15capture01a1ab95-d24e-73a2-b4e5-cea449f36cb0€9.00€0.19matched
16capture01a1ab95-e60a-75a4-a857-a7254f2084a7€35.00€0.50matched
17capture01a1ab95-e6d3-7aab-88e7-73bf2e5ff150€9.00€0.19matched
18capture01a1ab95-f037-7625-a8f0-6bbe7a33e673€35.00€0.50matched
19capture01a1ab95-f8e3-772d-a9dd-88854dba5fe6€15.00€0.26matched
20capture01a1ab96-03bf-7a75-a319-a036c517c2e4€15.00€0.26matched
21capture01a1ab96-0c21-785f-bf1e-1da670b82119€35.00€0.50matched
22capture01a1ab96-195c-70ac-9e3f-a42f49c8112c€49.00€0.67matched
23refund01a1ab96-1c46-74c9-a3c3-10c48e8386b5-€15.00€0.00matched
24capture01a1ab96-2cfe-77a2-b1dd-1c2112514c46€15.00€0.26matched
25capture01a1ab96-35ff-7843-afb6-00db4ac8ea80€35.00€0.50matched
26capture01a1ab96-6b13-79ad-a6aa-8e4c4ab72dfa€15.00€0.26matched
27capture01a1ab96-7332-7777-a330-9e200429410d€9.00€0.19matched
28capture01a1ab96-73a0-79a8-9259-8e7075fd4629€24.00€0.37matched
29capture01a1ab96-78c7-7ddb-96b5-018994d320d4€24.00€0.37matched
30refund01a1ab96-7ac6-716e-8143-b5e384568556-€19.00€0.00matched
31capture01a1ab96-9675-7ce8-8665-3c01aff5472f€24.00€0.37matched
32capture01a1ab96-d74d-7671-bd52-31dde53765c2€9.00€0.19matched
33capture01a1ab96-da5c-72a3-b241-6973ad24b154€49.00€0.67matched
34capture01a1ab96-da64-7d5e-8b8e-bc4f0d003054€24.00€0.37matched
35capture01a1ab97-0402-761a-9c6f-06a378710004€24.00€0.37matched
36capture01a1ab97-15db-7f5f-99cf-6630bcfc2e0e€15.00€0.26matched
37capture01a1ab97-22a7-74aa-84a3-cc7b126ca147€49.00€0.67matched
38capture01a1ab97-2c4f-78da-be16-22ebf0a343d8€15.00€0.26matched
39capture01a1ab97-3027-78f3-8609-da883a904874€35.00€0.50matched
40capture01a1ab97-42fe-78c9-bde8-a6b373e31e45€15.00€0.26matched
41capture01a1ab97-5c42-783a-a57d-e993b7f62c47€49.00€0.67matched
42capture01a1ab97-5eb1-7868-a1fc-f9b09618485a€35.00€0.50matched
43capture01a1ab97-80e2-768c-9f71-e5aefeb48f46€15.00€0.26matched
44capture01a1ab97-8a12-7e23-b095-d09941480418€49.00€0.67matched
45capture01a1ab97-962d-769f-b7ab-586968b21136€49.00€0.67matched
46capture01a1ab97-a8d4-79f2-a52c-80db51301d38€35.00€0.50matched
47capture01a1ab97-ccd6-777b-a861-599f6c872dc9€15.00€0.26matched
48capture01a1ab97-d57c-7c46-9322-e1269ce8d754€49.00€0.67matched
49capture01a1ab97-e678-7dea-b405-8d8c2f52923f€15.00€0.26matched
50capture01a1ab97-eade-7abb-9563-f69f7a0df454€9.00€0.19matched
51capture01a1ab97-ee6f-76e5-8897-e3c30cc63678€9.00€0.19matched
52capture01a1ab98-0afb-760c-bf43-a38135b129b6€49.00€0.67matched
53capture01a1ab98-6520-7c63-bbae-964f123d3730€35.00€0.50matched
54capture01a1ab98-6dbb-7448-b347-1982cd62bd6d€15.00€0.26matched
55capture01a1ab98-93ab-7e62-9736-d94dd73dd7c4€49.00€0.67matched
56capture01a1ab98-a38a-7334-aa1f-c241ec597f80€15.00€0.26matched
57capture01a1ab98-ac8b-73e2-9b3f-fea342e8fb2f€24.00€0.37matched
58capture01a1ab98-b37c-7c2e-9fd2-9233b4621f25€24.00€0.37matched
59capture01a1ab98-c232-7046-8288-9489b42a3707€24.00€0.37matched
60capture01a1ab98-c7c9-768d-9b43-b50320b1c64d€9.00€0.19matched
61capture01a1ab98-f15e-7f45-bd8f-f188e3264d7a€9.00€0.19matched
62capture01a1ab99-00ed-74e4-96bb-ca7d367693de€15.00€0.26matched
63capture01a1ab99-2b65-7776-8cb3-7e8ce774bd7a€35.00€0.50matched
64capture01a1ab99-3bee-7dc4-8c4e-511b506dd442€35.00€0.50matched
65capture01a1ab99-40e4-746d-a9de-00e0099f6cbe€15.00€0.26matched
66capture01a1ab99-50c6-7499-b591-fb2402213ba2€35.00€0.50matched
67capture01a1ab99-50f6-7f6a-bf56-38dd7821aeea€24.00€0.37matched
68capture01a1ab99-53fb-7e1e-b819-c6142a4bcc22€49.00€0.67matched
69refund01a1ab99-5916-7977-9132-a743d2666cd6-€34.00€0.00matched
70capture01a1ab99-59f1-7e6e-be94-062c975dd40d€9.00€0.19matched
71capture01a1ab99-5e66-7596-957f-cd833ccf6805€35.00€0.50matched
72capture01a1ab99-6ec9-7bdf-bce3-2fca61f66b09€15.00€0.26matched
73capture01a1ab99-749b-70a9-9361-2f59ab6dc460€15.00€0.26matched
74capture01a1ab99-758b-708b-8b20-01b3fb80a1c1€24.00€0.37matched
75refund01a1ab99-8fbc-7890-9e4b-4555ff5b177e-€5.00€0.00matched
76capture01a1ab99-99e8-79df-98e9-416b74c105dc€49.00€0.67matched
78refund01a1ab99-a1d1-72c8-aa5c-d538c7a09725-€8.00€0.00matched
79refund01a1ab99-c420-7792-a017-5058378b51ae-€10.00€0.00matched
80capture01a1ab99-d1bb-74dc-8cd3-60df6aede00d€9.00€0.19matched
81capture01a1ab99-ef84-7c3a-9c89-b8b6f6edb115€49.00€0.67matched
82capture01a1ab9a-021c-7d32-aece-1d117381786d€35.00€0.50matched
83capture01a1ab9a-21f6-7f80-9c5d-9ba3907c4bc0€15.00€0.26matched
84capture01a1ab9a-233d-7fc9-8c8f-7193ccbc7752€24.00€0.37matched
85capture01a1ab9a-4f12-7db5-a68f-decf149436f3€15.00€0.26matched
86capture01a1ab9a-7205-718f-9ca3-c17aa5586c34€49.00€0.67matched
87capture01a1ab9a-7730-78bf-8c16-8ecdaf23f563€49.00€0.67matched
88capture01a1ab9a-7c9d-789f-a2c2-1563aa4781e9€24.00€0.37matched
89capture01a1ab9a-8dbe-769e-89a2-3ca7ee5ad2a1€9.00€0.19matched
90capture01a1ab9a-98f0-7433-959a-6e72cff882d7€15.00€0.26matched
91capture01a1ab9a-a3a6-7e08-ba70-c239b45694d8€15.00€0.26matched
92capture01a1ab9a-c45c-7f77-b572-2592ae9ee021€35.00€0.50matched
93capture01a1ab9a-c84b-78f1-af10-a6fe05bfa66f€49.00€0.67matched
94capture01a1ab9a-d0e9-79c7-9018-50f0ee847b49€24.00€0.37matched
95capture01a1ab9a-e16b-7bd2-a638-48008cabcfec€35.00€0.50matched
96refund01a1ab9a-fced-7343-9d65-78320b8108fa-€7.00€0.00matched
97capture01a1ab9b-04fa-7475-9a21-bbd108f4740c€49.00€0.67matched
98capture01a1ab9b-13f2-7986-845d-219cffc5bd44€24.00€0.37matched
99capture01a1ab9b-31ab-7c69-b03f-c1922887363c€35.00€0.50matched
100capture01a1ab9b-4cf2-7039-8e5a-29ac229ea342€9.00€0.19matched
101capture01a1ab9b-9f09-794b-84ae-d85f7a6794f1€24.00€0.37matched
102capture01a1ab9b-cffd-7e3e-9c57-8a1b2886539b€24.00€0.37matched
103capture01a1ab9b-d5da-735b-8390-dafea5f2049e€35.00€0.50matched
104capture01a1ab9b-f0bf-7ab9-bcfa-8b19208f1a32€24.00€0.37matched
105capture01a1ab9c-09c3-7cb3-86c1-f124229358b9€15.00€0.26matched
106capture01a1ab9c-1743-7075-a6da-ebfe1eec9d52€15.00€0.26matched
107capture01a1ab9c-1750-7404-9452-7e42e8a75429€49.00€0.67matched
108capture01a1ab9c-24c9-70eb-b033-4a28ed92d1f5€15.00€0.26matched
109capture01a1ab9c-253d-7481-8a23-cdb3de46993b€49.00€0.67matched
110capture01a1ab9c-3b54-7286-a1a6-94ce8816cca3€24.00€0.37matched
111capture01a1ab9c-47cd-71cc-bba1-1ab209e564f3€49.00€0.67matched
112refund01a1ab9c-514c-7f10-bea0-62b1b2bb6bad-€23.00€0.00matched
113capture01a1ab9c-79a7-71b2-b279-5915372377ba€49.00€0.67matched
114capture01a1ab9c-7c1f-7b4a-bec6-9f8a5171b2ad€15.00€0.26matched
115capture01a1ab9c-917f-74da-8b55-acb478dd1760€35.00€0.50matched
116capture01a1ab9c-e45d-76c3-9fbf-4532b8ff5c6e€35.00€0.50matched
117capture01a1ab9d-067b-75df-a3f4-ca1c657749f8€24.00€0.37matched
118capture01a1ab9d-3de9-7970-8aed-9d9b9084d56b€49.00€0.67matched
119capture01a1ab9d-4215-70df-943d-a35f820351da€15.00€0.26matched
120capture01a1ab9d-8132-7cbc-b292-289baf24b387€35.00€0.50matched
121capture01a1ab9d-8eff-73db-b787-f19c6fb5e252€9.00€0.19matched
122capture01a1ab9d-acce-7bcc-9d02-59bab1a7def8€49.00€0.67matched