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

Gross

€3,042.00

PSP fee

€47.18

Net to the bank

€2,994.82

Settlement journal

#376882

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a5df-0f8c-74f2-83bb-641639a7d70a is already settled by stl_EUR_2989640 line 30
  • duplicate linethe file lists it twicecapture:01a1a5e1-f00b-728c-9fbd-0f7f6af9ffa3 is already settled by stl_EUR_2989640 line 73
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
LineKindReferenceGrossFeeStatus
31capture01a1a5df-0fd9-7544-898a-5ae9e599be50€24.00€0.37duplicate line
60capture01a1a5e0-b9d1-70cc-be43-22202804b795€49.00€0.68fee difference
74capture01a1a5e1-f05b-78ef-bb6f-c33a84154a44€24.00€0.37duplicate line
100capture01a1a5e3-19f7-75fe-8a8f-715f9fa325ba€35.00€0.51fee difference
1capture01a1a5d4-24a2-78e2-abe9-ba83fa3c413f€15.00€0.26matched
2capture01a1a5d4-c766-77ce-8319-72073e6f550b€15.00€0.26matched
3capture01a1a5d7-8681-7f34-98f0-23cb56147a9e€15.00€0.26matched
4capture01a1a5d9-4bac-7b83-8bc3-500e0db03498€49.00€0.67matched
5capture01a1a5d9-a217-734c-a089-c26c75ef6f4a€9.00€0.19matched
6capture01a1a5db-df59-720e-bbaa-9c69384f07f8€15.00€0.26matched
7capture01a1a5db-e39e-74d0-8205-52de9fb76b5e€15.00€0.26matched
8capture01a1a5dc-0fc6-71d2-967c-db9432616082€15.00€0.26matched
9capture01a1a5dc-14db-7323-b99e-460af7ddf808€49.00€0.67matched
10capture01a1a5dc-35d0-7d83-a437-6d0775c842ed€49.00€0.67matched
11capture01a1a5dc-53de-75ca-8334-69d5d0ae9002€24.00€0.37matched
12capture01a1a5dc-7798-71ff-89f2-9c6f664bdaae€9.00€0.19matched
13capture01a1a5dc-adf3-74e3-bc04-09b60c2c86e1€49.00€0.67matched
14refund01a1a5dc-f9fc-7ce9-80f9-0c4a9d6eb6a9-€15.00€0.00matched
15capture01a1a5dd-04cc-790d-a9e7-c2ef0a0e3919€15.00€0.26matched
16capture01a1a5dd-20d6-7138-9f6e-cd5ff1519d23€24.00€0.37matched
17capture01a1a5dd-2d26-7712-a6ec-068dfcfd9df3€35.00€0.50matched
18capture01a1a5dd-5484-7cac-a495-ab9adab19d6d€9.00€0.19matched
19capture01a1a5dd-5af0-71d4-ae64-88d4dc955345€49.00€0.67matched
20capture01a1a5dd-7bcd-7443-97c7-2ec9710cd332€24.00€0.37matched
21refund01a1a5dd-beca-79c5-8cef-f6cacf37f407-€15.00€0.00matched
22capture01a1a5dd-d7fc-7517-93d6-f0931ce1c711€49.00€0.67matched
23capture01a1a5dd-bde3-788a-9ca3-a4357f03d836€9.00€0.19matched
24capture01a1a5de-467e-771b-a201-87c60fbe555e€49.00€0.67matched
25capture01a1a5de-49a8-7643-b424-13325e301214€35.00€0.50matched
26capture01a1a5de-7d37-73eb-80a4-e1060c6a05a6€49.00€0.67matched
27capture01a1a5de-8449-7571-9233-f2396aa94e58€9.00€0.19matched
28capture01a1a5de-9d11-7f3c-9506-fd64738e9e3b€24.00€0.37matched
29capture01a1a5df-04bf-7e20-b9bd-243b685d7385€49.00€0.67matched
30capture01a1a5df-0fd9-7544-898a-5ae9e599be50€24.00€0.37matched
32capture01a1a5df-29bf-7f48-a95f-99eb441c8fe5€15.00€0.26matched
33capture01a1a5df-6177-7842-ace4-b71cdeecac78€35.00€0.50matched
34capture01a1a5df-617b-7e61-b823-1fcbe19dde4d€35.00€0.50matched
35capture01a1a5df-65c2-7264-b6e3-2dd575c99ca0€49.00€0.67matched
36capture01a1a5df-68be-73a2-b760-dbc37768877d€35.00€0.50matched
37capture01a1a5df-7b84-77fa-8509-635eeefe92d8€24.00€0.37matched
38capture01a1a5df-8d14-7a32-8abc-c6d299f2086b€24.00€0.37matched
39refund01a1a5df-91b7-7038-b34f-f17b6cd36099-€11.00€0.00matched
40capture01a1a5df-920e-7f3d-bfa2-da755ea8203f€35.00€0.50matched
41capture01a1a5df-b65e-7d4c-baad-354efa6cf0f0€9.00€0.19matched
42capture01a1a5df-c07c-714f-8d8b-ddc4b0a5160d€24.00€0.37matched
43capture01a1a5df-cf1e-719b-b290-eccf294a6114€24.00€0.37matched
44capture01a1a5df-e0df-73c9-913b-b56a8ec73d29€35.00€0.50matched
45capture01a1a5df-e390-7cb5-aded-a6ee636aa066€35.00€0.50matched
46capture01a1a5df-ea61-7480-9916-9e0a7a2d9d89€15.00€0.26matched
47refund01a1a5e0-090d-7a6c-b181-e56cd57b88ef-€7.00€0.00matched
48refund01a1a5e0-17d3-7b53-b57b-8bd38297b1b7-€22.00€0.00matched
49capture01a1a5e0-1ffc-7006-820f-722f402f81c3€9.00€0.19matched
50capture01a1a5e0-3278-7cf0-886a-3ef314fafcbb€15.00€0.26matched
51capture01a1a5e0-4dee-732a-be34-1d32fc229284€35.00€0.50matched
52capture01a1a5e0-5144-7d7d-a298-e6ff0ed76272€35.00€0.50matched
53capture01a1a5e0-54c4-7e62-b6f9-13e401ffd8f7€35.00€0.50matched
54capture01a1a5e0-573f-720b-9699-ef122d17bde2€15.00€0.26matched
55capture01a1a5e0-7ee2-7424-a620-ff1c2102dd78€49.00€0.67matched
56capture01a1a5e0-889e-774c-8b48-713f81152a9b€24.00€0.37matched
57capture01a1a5e0-9215-7e57-81be-f704724345e0€49.00€0.67matched
58capture01a1a5e0-92d5-7ee1-b076-3d62a23e2796€24.00€0.37matched
59capture01a1a5e0-aa3b-7e8d-b643-54126e9910e3€24.00€0.37matched
61refund01a1a5e0-c3a8-7158-9803-c27c35d78461-€5.00€0.00matched
62capture01a1a5e0-dd58-71a0-ab95-ea7088cf3737€35.00€0.50matched
63capture01a1a5e0-e797-7ffa-b370-8cd049b696a7€24.00€0.37matched
64capture01a1a5e0-ed58-7115-a63d-65d01ac02967€49.00€0.67matched
65capture01a1a5e1-0a80-7ce3-835d-eafed1ddf7ff€9.00€0.19matched
66capture01a1a5e1-1fb1-7caf-ae03-beb25f944c4a€24.00€0.37matched
67capture01a1a5e1-2175-76c1-a3e0-1c481a4d575a€9.00€0.19matched
68capture01a1a5e1-29de-7959-b73d-21492215b6da€49.00€0.67matched
69capture01a1a5e1-52fc-751a-9ce0-7d8ef2e4a7dd€9.00€0.19matched
70refund01a1a5e1-7724-7527-8c0b-5e6cbd43f435-€20.00€0.00matched
71capture01a1a5e1-821d-7601-bf9c-8e2cf71e0000€15.00€0.26matched
72capture01a1a5e1-a8c2-7db2-95a8-4a2f5a19a50c€9.00€0.19matched
73capture01a1a5e1-f05b-78ef-bb6f-c33a84154a44€24.00€0.37matched
75capture01a1a5e1-f9b0-7e8a-a088-fe758fcf5e43€35.00€0.50matched
76capture01a1a5e2-0996-788a-8364-df714fb29ff1€9.00€0.19matched
77capture01a1a5e2-0f53-7438-ae41-fdea38b0d8fc€24.00€0.37matched
78capture01a1a5e2-2bf7-714a-9354-3241a13001b1€15.00€0.26matched
79capture01a1a5e2-3189-723a-aa77-6ed4ca8b6801€9.00€0.19matched
80capture01a1a5e2-384d-7586-87aa-213b15fce64c€35.00€0.50matched
81capture01a1a5e2-5f4d-7465-9883-85e5ddb6fe30€35.00€0.50matched
82capture01a1a5e2-6bbf-7026-9f44-4fd8ebd501cb€24.00€0.37matched
83capture01a1a5e2-7eae-7b73-af31-f461fa82e436€35.00€0.50matched
84capture01a1a5e2-95c0-7d5c-8109-73ff72af366e€9.00€0.19matched
85capture01a1a5e2-9e70-7046-b43f-5d92b62796d3€35.00€0.50matched
86capture01a1a5e2-b8e7-7cca-88da-37781707288f€9.00€0.19matched
87capture01a1a5e2-b978-768b-8eef-33571265a812€15.00€0.26matched
88capture01a1a5e2-bfe8-7772-8f41-90c560821aac€15.00€0.26matched
89capture01a1a5e2-c3d2-7a24-8fd4-afd36ea3c870€15.00€0.26matched
90capture01a1a5e2-cc56-7e3d-8d58-8db203392e23€15.00€0.26matched
91capture01a1a5e2-d700-7be0-9b74-b79829759f10€35.00€0.50matched
92capture01a1a5e2-e406-75b5-90c1-57ec6275fd3e€15.00€0.26matched
93capture01a1a5e2-e5eb-7d56-975a-f85602c6bc0c€49.00€0.67matched
94capture01a1a5e2-f3f9-7d7c-942b-7eff3c2c7d15€35.00€0.50matched
95capture01a1a5e2-ff5d-7aa0-9798-a0296dc641c9€9.00€0.19matched
96capture01a1a5e2-ff5f-7842-bb7c-1da08e88150e€15.00€0.26matched
97capture01a1a5e3-0048-7bc2-8cfa-a5e22d506048€49.00€0.67matched
98capture01a1a5e3-0f35-7917-95fd-1c0c54f29aba€49.00€0.67matched
99capture01a1a5e3-1256-78a6-9742-044da0dfabfc€49.00€0.67matched
101capture01a1a5e3-3508-7cdd-9fbf-a5104763897d€49.00€0.67matched
102capture01a1a5e3-72e2-78d3-8bc8-4b5cb44e7db8€35.00€0.50matched
103capture01a1a5e3-8731-724d-be1f-111b0e12b6d8€49.00€0.67matched
104capture01a1a5e3-9c19-7f18-87a3-4db77ee39aa4€35.00€0.50matched
105capture01a1a5e3-a749-71f9-a467-8adca34707ef€49.00€0.67matched
106capture01a1a5e3-a99f-7973-9c1d-ab94da0875e2€24.00€0.37matched
107capture01a1a5e3-d4d8-7458-8bdd-a3914ff817e2€49.00€0.67matched
108capture01a1a5e3-de63-7c1a-8d55-228bf38e1083€49.00€0.67matched
109capture01a1a5e4-0118-785f-818d-7d794ab07b40€24.00€0.37matched
110capture01a1a5e3-ffe4-795b-952d-6f15a9a110d8€24.00€0.37matched
111refund01a1a5e4-10fb-7a64-a489-81d098513c61-€35.00€0.00matched
112capture01a1a5e4-13c6-73c1-9f3a-f6744efcce78€35.00€0.50matched
113capture01a1a5e4-1479-7232-8e51-0e70260cdb69€9.00€0.19matched
114capture01a1a5e4-3192-76d4-9abc-b95494c93c79€35.00€0.50matched
115capture01a1a5e4-34e8-7f98-9cf6-1b2237136f00€24.00€0.37matched
116capture01a1a5e4-6ed6-77b7-9d92-a7630609ee5e€35.00€0.50matched
117capture01a1a5e4-7c05-73fc-9089-2c86c1e16fe7€49.00€0.67matched
118capture01a1a5e4-8365-77eb-8ad2-f5e8a3bb4060€49.00€0.67matched
119capture01a1a5e4-a2d4-7908-80e0-704a6879852f€9.00€0.19matched
120capture01a1a5e4-b933-796a-9b31-16c5f97ab3ab€24.00€0.37matched