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

4 Nov, 05:40

Gross

€2,769.00

PSP fee

€42.63

Net to the bank

€2,726.37

Settlement journal

#374174

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a513-8012-713a-8e86-99aaed9f870c is already settled by stl_EUR_2989618 line 18
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
LineKindReferenceGrossFeeStatus
19capture01a1a513-8834-7592-8258-e4ab6457b4e8€49.00€0.67duplicate line
63capture01a1a516-6663-7880-860c-ce7ed700a49f€9.00€0.22fee difference
1capture01a1a512-6b2c-7e3a-90aa-69138b8866dc€15.00€0.26matched
2capture01a1a512-70f3-78ed-a5cd-1d869df7ff74€24.00€0.37matched
3capture01a1a512-7aa9-74e2-887e-beaf1fd72f3d€35.00€0.50matched
4capture01a1a512-904e-754a-bdd8-7cc3a6808c72€15.00€0.26matched
5capture01a1a512-94e9-7ab2-b012-73e054840108€35.00€0.50matched
6capture01a1a512-96e8-72a6-922a-9655e9599260€24.00€0.37matched
7capture01a1a512-c2ed-7425-af44-236f5929f402€15.00€0.26matched
8capture01a1a512-cb49-74a5-8083-caea4f20a688€9.00€0.19matched
9capture01a1a512-ce92-7bec-b752-abf98eebc53d€24.00€0.37matched
10capture01a1a512-d099-7c08-a2d2-f674976c1ae9€24.00€0.37matched
11capture01a1a512-dcad-7978-92da-067342cd566e€35.00€0.50matched
12capture01a1a513-2190-78bf-a9e5-77c16b288518€35.00€0.50matched
13capture01a1a513-27ef-717c-a738-3d6bcbb018d8€15.00€0.26matched
14capture01a1a513-3139-7033-9c55-dfa723c393c8€24.00€0.37matched
15capture01a1a513-5697-71ac-9c06-aad62f31ca50€24.00€0.37matched
16capture01a1a513-5aa7-77be-91ba-2e7afe88f42e€49.00€0.67matched
17capture01a1a513-8078-70b4-890e-9ce4042bad0d€35.00€0.50matched
18capture01a1a513-8834-7592-8258-e4ab6457b4e8€49.00€0.67matched
20capture01a1a513-8d53-715c-adc7-ed3e3bf04614€15.00€0.26matched
21capture01a1a513-9acb-7d42-8ed9-72eaf89f2eb0€15.00€0.26matched
22capture01a1a513-9b4b-768e-9015-300fcd0a7b98€49.00€0.67matched
23capture01a1a513-ad50-7db8-b3a2-20e323a95fff€15.00€0.26matched
24capture01a1a513-cb67-762f-9dda-b49bb933dd0b€49.00€0.67matched
25capture01a1a513-db48-72b0-91cd-17a9485e80ae€15.00€0.26matched
26capture01a1a514-0a58-7e0a-a962-908e4b5a838a€49.00€0.67matched
27capture01a1a514-0c2b-7623-9521-26e28f4d6134€49.00€0.67matched
28capture01a1a514-1ab5-7671-afab-23aef0eba97e€35.00€0.50matched
29capture01a1a514-1fc1-7562-b2e5-8552dde7001f€24.00€0.37matched
30capture01a1a514-438e-7366-935a-71302369b123€49.00€0.67matched
31capture01a1a514-4c48-77b5-afba-c0701300e688€24.00€0.37matched
32capture01a1a514-6471-7c19-9b52-c7746ce9c8c1€24.00€0.37matched
33capture01a1a514-7d43-7962-acbc-e99fa38c7502€9.00€0.19matched
34capture01a1a514-83b7-7e4f-9a42-8cd26ef16ab5€24.00€0.37matched
35capture01a1a514-83cc-78fd-854c-45e0c3c9e2b0€15.00€0.26matched
36capture01a1a514-86d8-7749-bfaa-88c73a838998€24.00€0.37matched
37capture01a1a514-9652-7301-b5d1-c5c955f6d373€49.00€0.67matched
38refund01a1a514-9722-7043-9213-eed7c0e14f96-€5.00€0.00matched
39capture01a1a514-a6eb-7fac-96ea-b4e14d807a1f€24.00€0.37matched
40capture01a1a514-a7a8-7447-a44a-889226866a8b€35.00€0.50matched
41refund01a1a514-baf4-73ec-b77b-317140b35f0f-€18.00€0.00matched
42capture01a1a514-e21b-788f-91bd-979bf8cd1823€15.00€0.26matched
43capture01a1a514-f9bb-74bb-957a-acdce9405e6a€15.00€0.26matched
44capture01a1a515-223c-79b8-a627-cf6d86bb9326€9.00€0.19matched
45capture01a1a515-3079-738a-87c5-300699d49bef€15.00€0.26matched
46capture01a1a515-3199-7709-af3d-8245c3543d1e€49.00€0.67matched
47capture01a1a515-400b-7f04-9075-74a1551fc572€9.00€0.19matched
48capture01a1a515-5ae8-76bb-80d2-284ae6757c43€35.00€0.50matched
49capture01a1a515-7349-7598-aaaf-4fd3c50c6789€24.00€0.37matched
50capture01a1a515-88c1-7b49-b810-6eb19c5bc92a€15.00€0.26matched
51capture01a1a515-8a29-74e9-b12d-d602b367f7ac€24.00€0.37matched
52capture01a1a515-b69e-7ef3-8f02-96798a8de76d€49.00€0.67matched
53capture01a1a515-b525-7b60-83bc-6953fb0940ad€49.00€0.67matched
54capture01a1a515-c097-741d-893e-f031cef00d3a€15.00€0.26matched
55capture01a1a515-cf97-731b-a761-3c5233513753€24.00€0.37matched
56capture01a1a515-e60a-735b-88de-c78f967fa600€15.00€0.26matched
57capture01a1a516-2bda-7a7b-914c-477c66118f47€35.00€0.50matched
58capture01a1a516-30bd-7fdd-a2ae-f31b57c6a7c5€15.00€0.26matched
59capture01a1a516-4d41-79f3-9259-c0cdf2fc38c6€24.00€0.37matched
60capture01a1a516-4db9-7902-86c8-1c0f61a5dd6c€35.00€0.50matched
61capture01a1a516-4ecc-75d6-9fe5-46bdd21aa700€49.00€0.67matched
62capture01a1a516-5a86-71cc-8082-3ff874c20604€35.00€0.50matched
64capture01a1a516-689f-761b-9638-095dba76c76e€9.00€0.19matched
65capture01a1a516-702c-772d-ad46-ecb177c4413c€35.00€0.50matched
66refund01a1a516-922f-7fcd-bf60-0a5eeac501cf-€11.00€0.00matched
67capture01a1a516-96b3-7497-9b36-7d606070e8b6€15.00€0.26matched
68capture01a1a516-add2-7d4a-8588-c312ef3fbb38€9.00€0.19matched
69capture01a1a516-c234-7531-b9c8-bf299098a0c6€24.00€0.37matched
70capture01a1a516-cf26-70dd-9795-289d4d5332b6€24.00€0.37matched
71capture01a1a516-d95a-7c1a-8c49-2901b1d9bc21€15.00€0.26matched
72capture01a1a516-e050-7d5a-9879-ef36292f0b06€15.00€0.26matched
73capture01a1a516-e9e2-783c-b769-7ed1ae759fae€15.00€0.26matched
74capture01a1a516-ee20-741c-b0a2-2b58746de610€35.00€0.50matched
75capture01a1a516-f232-7cf3-97e8-7a0e32701fe9€15.00€0.26matched
76capture01a1a517-0729-799b-86aa-f91c16a40f3b€15.00€0.26matched
77capture01a1a517-2b33-70de-ab98-19f1202b962b€9.00€0.19matched
78capture01a1a517-6bd9-7dd8-9d50-28e6275e9885€35.00€0.50matched
79capture01a1a518-09da-76d4-abc1-0e46184a0a64€9.00€0.19matched
80capture01a1a518-247b-7925-9274-64f67c9b013a€35.00€0.50matched
81capture01a1a518-45f0-7c47-9947-c43d9d95b115€9.00€0.19matched
82capture01a1a518-49fc-7d5b-8291-f46d7ea2161c€49.00€0.67matched
83capture01a1a518-4c0e-791b-8af6-66679beff6c2€35.00€0.50matched
84capture01a1a518-4740-78d4-b254-2c2bc6ede33d€15.00€0.26matched
85capture01a1a518-55bd-7f5f-81ad-1d0e267e90fa€35.00€0.50matched
86capture01a1a518-7a4a-7cab-8eff-89fd2f78a9e5€15.00€0.26matched
87capture01a1a518-81ed-7221-910b-f98d34d48419€35.00€0.50matched
88capture01a1a518-8ab1-7bfc-9e42-c36cccc71daf€35.00€0.50matched
89capture01a1a518-a106-734f-9780-8584b5d607d0€24.00€0.37matched
90capture01a1a518-abe4-7ba4-a952-3ad0ea2f3df6€15.00€0.26matched
91capture01a1a518-bb19-7e99-af55-f5ece487c7f2€24.00€0.37matched
92capture01a1a518-d55b-709e-9092-00db42cdcd81€15.00€0.26matched
93capture01a1a518-e945-7727-80b3-ad89b6351eac€15.00€0.26matched
94capture01a1a518-f15d-770e-b0c3-604642ffc09a€24.00€0.37matched
95capture01a1a518-f70d-7ce5-aac3-bbe02f608c4c€24.00€0.37matched
96capture01a1a519-0ea1-7bd2-8195-5f8ad253f4f4€35.00€0.50matched
97capture01a1a519-1c12-74cc-8627-9581812c1ebb€15.00€0.26matched
98capture01a1a519-b98c-7748-8625-5ab9df1b9214€24.00€0.37matched
99capture01a1a519-c65f-70a6-b514-425cd28bb0ce€35.00€0.50matched
100capture01a1a519-c887-79f5-b8b2-37fb856e3ea8€9.00€0.19matched
101capture01a1a519-f54b-7239-a2c1-c79e0828fad6€35.00€0.50matched
102capture01a1a51a-10ff-796e-81bd-ef0fb367c93f€24.00€0.37matched
103capture01a1a51a-1cad-727e-af11-d4874edcd04f€35.00€0.50matched
104capture01a1a51a-23fd-77dd-b71a-1f0d37f84338€9.00€0.19matched
105refund01a1a51a-4774-73d4-82ee-88e30dded471-€11.00€0.00matched
106capture01a1a51a-8db1-7628-b8e2-871b10bbdc4c€9.00€0.19matched
107capture01a1a51a-9ce3-7a11-8633-ab239e829cfc€35.00€0.50matched
108capture01a1a51a-a6cb-78fd-b4f8-17397bd2f4a1€9.00€0.19matched
109capture01a1a51a-d2bb-75a0-931b-e5895e9a43c3€35.00€0.50matched
110capture01a1a51a-ea2c-731a-b231-9190424b7032€24.00€0.37matched
111capture01a1a51b-0e0e-7e15-b3ea-d81e2bebf9c8€9.00€0.19matched
112capture01a1a51b-27c6-7434-9dbb-06e7015ee0aa€49.00€0.67matched
113capture01a1a51b-2b3b-742e-846b-826fc3dee81d€49.00€0.67matched