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, 05:10

Gross

€2,840.00

PSP fee

€46.43

Net to the bank

€2,793.57

Settlement journal

#410380

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1af44-acb1-7918-ac2a-baa21760c305 is already settled by stl_EUR_2989903 line 24
  • fee differencethe fee is not the contract feethe fee is 2, the contract says 0
LineKindReferenceGrossFeeStatus
25capture01a1af44-b0c2-7bea-b912-d96e65adfe9a€9.00€0.19duplicate line
115refund01a1af4a-ddc8-732b-ae18-2648dab093be-€3.00€0.02fee difference
1refund01a1af3a-df66-7541-a5e9-97f080309a91-€4.00€0.00matched
2capture01a1af3b-b467-72a1-b5ba-ed20b1bad203€49.00€0.67matched
3capture01a1af3d-8888-769b-bbc2-9a3f8517d4ec€15.00€0.26matched
4capture01a1af43-33fd-7dbb-8d48-db5d9298f254€24.00€0.37matched
5capture01a1af43-85ca-7166-8a1b-b9461d0390c0€35.00€0.50matched
6refund01a1af43-9ed6-78ad-ad44-4ba41093ab82-€4.00€0.00matched
7refund01a1af43-b410-7ece-90fe-5139ce0d8348-€13.00€0.00matched
8capture01a1af43-c824-7380-80d7-f5c7154b4d69€24.00€0.37matched
9capture01a1af43-d0b3-7ec6-ba89-53baf7b33f83€24.00€0.37matched
10capture01a1af43-dadf-7fed-bf0e-363026ca199c€35.00€0.50matched
11capture01a1af43-eb3e-706a-a88c-7378813b465c€15.00€0.26matched
12capture01a1af43-eee7-75ec-86a1-7a5aef71cead€9.00€0.19matched
13capture01a1af43-f2ba-78de-b886-d2ab46aa8d12€9.00€0.19matched
14capture01a1af43-ff62-782f-9857-f78440d10ef9€15.00€0.26matched
15capture01a1af44-20d7-7f46-8ab1-6b0d22e0ffa1€24.00€0.37matched
16capture01a1af44-4bdb-7f59-84c9-67e52d362f72€9.00€0.19matched
17capture01a1af44-529a-7dd2-927b-c8aca854299a€15.00€0.26matched
18capture01a1af44-70d6-77cb-a0c1-269e4515c67c€9.00€0.19matched
19capture01a1af44-738f-7a59-aeac-3e17fd3bfd5b€15.00€0.26matched
20capture01a1af44-7773-782c-b5b6-6c83cc3c8543€24.00€0.37matched
21capture01a1af44-8d10-7470-8c32-8c49758b7469€9.00€0.19matched
22capture01a1af44-902f-7526-b0a9-8c6ad3e40354€35.00€0.50matched
23capture01a1af44-924c-71f6-9222-d64de1b49c5f€15.00€0.26matched
24capture01a1af44-b0c2-7bea-b912-d96e65adfe9a€9.00€0.19matched
26capture01a1af44-ca5c-76b8-8a2e-a5e617546890€15.00€0.26matched
27capture01a1af44-fadc-7f5f-818a-a5cb63a6adac€49.00€0.67matched
28capture01a1af44-fde0-748c-8b21-3b109261de0b€49.00€0.67matched
29capture01a1af44-f95a-7228-bac6-119db1e6f574€49.00€0.67matched
30capture01a1af45-0de4-7e4f-adf8-9a9e032ddece€15.00€0.26matched
31capture01a1af45-11ee-7197-8949-c62191a4f68c€24.00€0.37matched
32capture01a1af45-1431-72e3-97ba-1b845d79737d€35.00€0.50matched
33capture01a1af45-1fee-7655-8758-4b95970ac216€9.00€0.19matched
34capture01a1af45-33bf-7c19-9527-f0fab58d94a5€15.00€0.26matched
35refund01a1af45-4d15-7230-95c1-b79478c22999-€31.00€0.00matched
36capture01a1af45-6932-7f8f-a249-a1741719ab7a€9.00€0.19matched
37capture01a1af45-844e-7f37-8f69-4ddcea52cbde€9.00€0.19matched
38capture01a1af45-88a3-767c-8e8d-914535051a83€9.00€0.19matched
39capture01a1af45-8987-7e59-b407-4575d8cb1cef€24.00€0.37matched
40capture01a1af45-8d6c-79fc-b2b8-6cfc05aa5aa5€9.00€0.19matched
41capture01a1af45-a2e6-776a-bbde-c1b28bf8f7b6€35.00€0.50matched
42capture01a1af45-a38a-78bf-82ca-05d1cb9abaf8€9.00€0.19matched
43capture01a1af45-a5e7-7e5a-9031-7fa755ce2257€35.00€0.50matched
44capture01a1af45-ae7c-7ea6-99cd-6a3fa30a9f29€35.00€0.50matched
45capture01a1af45-af8c-772c-9587-a1588ee0ebcc€35.00€0.50matched
46capture01a1af45-dd7f-76c3-b970-5c21e88878e3€15.00€0.26matched
47capture01a1af45-e6c2-78f2-b2df-341e9c36d32f€15.00€0.26matched
48capture01a1af45-e76b-730f-a21a-91dc05f18d2b€15.00€0.26matched
49capture01a1af45-fb46-7c41-98c3-766f13ecb0f8€9.00€0.19matched
50refund01a1af46-12fd-728f-8ea6-df1007483137-€3.00€0.00matched
51capture01a1af46-1c70-7d9e-9dc5-450b3d1a2fc3€35.00€0.50matched
52capture01a1af46-2c34-7c72-9fa5-ab6c80f4d49b€15.00€0.26matched
53refund01a1af46-2c9c-7911-b6f8-c2ffb85b1303-€5.00€0.00matched
54capture01a1af46-3107-75fc-8ce9-b65bb3228914€35.00€0.50matched
55capture01a1af46-3fc6-7845-9ef1-33204fe97090€15.00€0.26matched
56capture01a1af46-4c4c-7637-8afd-42e0aa2cd081€35.00€0.50matched
57capture01a1af46-6281-7d47-85cc-ae7027ad9061€35.00€0.50matched
58capture01a1af46-9202-705d-8c9c-9c07f85a439c€49.00€0.67matched
59capture01a1af46-9adf-77e5-a52e-2edddb4c3745€9.00€0.19matched
60capture01a1af46-be3e-76d2-bff2-6aea42cb4cf4€9.00€0.19matched
61capture01a1af46-e97f-7232-88f0-8551c9e60056€9.00€0.19matched
62capture01a1af47-0192-7467-b3e5-6b82bdd81bad€35.00€0.50matched
63capture01a1af47-06df-7272-9921-fb03bb29b8da€49.00€0.67matched
64capture01a1af47-24bc-7016-a57f-9fc42c7bc196€15.00€0.26matched
65capture01a1af47-24c4-71ac-a3e6-80e79e63bd8b€35.00€0.50matched
66refund01a1af47-39ec-720a-bba0-2fa6bd1b78be-€3.00€0.00matched
67capture01a1af47-415c-7cd0-912b-56d52351d2c0€9.00€0.19matched
68capture01a1af47-5043-7719-aa3a-eb78db3827d6€24.00€0.37matched
69refund01a1af47-5e7e-73ea-93b9-2ad1c25e12ee-€30.00€0.00matched
70capture01a1af47-6b72-7ebc-9f05-310d229474a2€35.00€0.50matched
71capture01a1af47-9751-7fb4-86ef-137ec68e7000€35.00€0.50matched
72refund01a1af47-a238-7e08-9160-382b7622c056-€2.00€0.00matched
73capture01a1af47-c019-7c88-9388-10ab4141f197€24.00€0.37matched
74capture01a1af47-d739-795b-a9c6-18ec3d010763€24.00€0.37matched
75capture01a1af47-f785-7a0c-bcd4-1c924af65c75€9.00€0.19matched
76capture01a1af48-06fe-7cc2-a8e2-17c30a092fcc€15.00€0.26matched
77capture01a1af48-091b-7dd9-be4e-f1f5e79f944d€24.00€0.37matched
78capture01a1af48-0a1b-73da-881e-08b37a6681d3€49.00€0.67matched
79capture01a1af48-28b0-7f41-af47-5624e8821a8d€49.00€0.67matched
80capture01a1af48-28ff-7221-820f-4f73d0c351cb€15.00€0.26matched
81refund01a1af48-4ccd-7872-abeb-6855f0ce42e4-€15.00€0.00matched
82capture01a1af48-5956-73f6-8e24-a8c993f882d6€35.00€0.50matched
83capture01a1af48-5ee7-7388-a9fb-4838aacb76b5€15.00€0.26matched
84capture01a1af48-740a-719c-ab42-599f84864902€49.00€0.67matched
85capture01a1af48-87f9-7fb1-9cc4-f7be6565ed7e€9.00€0.19matched
86capture01a1af48-97d9-7d81-af6a-0a3de741fedd€9.00€0.19matched
87capture01a1af48-a37f-72fa-88ad-fee135380d17€24.00€0.37matched
88capture01a1af48-d573-79dc-9466-db59283d83ca€9.00€0.19matched
89capture01a1af48-dad8-7bda-a10b-c63360a85a0f€49.00€0.67matched
90capture01a1af48-f3f7-775d-9724-b0d30cab90b8€9.00€0.19matched
91capture01a1af48-ffbe-7585-8fca-97f490abb42c€15.00€0.26matched
92capture01a1af49-00d7-78d9-8897-f91eb91a5065€9.00€0.19matched
93capture01a1af49-0f85-768e-8abc-803bd5340615€15.00€0.26matched
94capture01a1af49-1983-7f75-9fcd-b2ea219280cc€9.00€0.19matched
95capture01a1af49-5ae3-7b7b-83ec-2b7542466075€35.00€0.50matched
96capture01a1af49-61f2-73da-9b51-8c0a8ecb79ab€9.00€0.19matched
97capture01a1af49-699c-7c3a-a9b5-8f0accb1e45e€9.00€0.19matched
98capture01a1af49-7e57-7463-876d-f544348f5f1d€24.00€0.37matched
99capture01a1af49-9326-76ce-bd0a-e2a515bfd1af€15.00€0.26matched
100capture01a1af49-d388-731a-b84a-ee7bed664849€49.00€0.67matched
101refund01a1af49-dda1-7839-a8a2-b7e2dab96ca1-€5.00€0.00matched
102capture01a1af49-e159-7895-8b1d-431804929c9c€24.00€0.37matched
103capture01a1af49-e217-72a2-9854-fd9435564bce€49.00€0.67matched
104capture01a1af49-eb69-77b1-b35e-589067ba0115€15.00€0.26matched
105capture01a1af49-ff33-782d-b296-0277cc56b073€15.00€0.26matched
106capture01a1af4a-0875-7f15-8404-90cbf645e051€9.00€0.19matched
107capture01a1af4a-4719-7aae-aa82-7ac7ee06d3cf€49.00€0.67matched
108capture01a1af4a-57f4-7824-b057-d953bba5a6b6€35.00€0.50matched
109capture01a1af4a-739b-717d-9f38-45fd411cc210€9.00€0.19matched
110capture01a1af4a-807d-744f-bd02-c3d92442cc5c€9.00€0.19matched
111capture01a1af4a-8d36-744a-abbb-79a0b84af6e5€49.00€0.67matched
112capture01a1af4a-9333-7b67-96cd-ba0d9967b54d€49.00€0.67matched
113capture01a1af4a-9255-7a97-ae98-99a0ccac79d6€9.00€0.19matched
114capture01a1af4a-c358-75a5-9aa0-a942e905dd76€35.00€0.50matched
116capture01a1af4a-ed8f-7ff0-bfde-9ce19d2d1e97€35.00€0.50matched
117capture01a1af4a-f751-7236-8349-dd74300cf196€35.00€0.50matched
118capture01a1af4b-0854-7d18-8e4a-3d3b2de2886e€9.00€0.19matched
119capture01a1af4b-3dff-726e-b8bb-a78070c11202€49.00€0.67matched
120capture01a1af4b-489e-7c75-bb25-5f30f45775b3€9.00€0.19matched
121capture01a1af4b-48f8-75b9-88a1-0a50c061bbc9€49.00€0.67matched
122capture01a1af4b-4bdc-7569-854c-07086ae36e41€24.00€0.37matched
123capture01a1af4b-5655-7baa-aac3-dd40ac9758bf€9.00€0.19matched
124capture01a1af4b-583a-7365-8f6c-196997494495€49.00€0.67matched
125refund01a1af4b-5ede-7751-9274-d614e1e62ad8-€33.00€0.00matched
126capture01a1af4b-6b77-7d6a-a12b-a55befe6432c€35.00€0.50matched
127capture01a1af4b-71dd-7df3-a41b-067ef3646e7b€9.00€0.19matched
128capture01a1af4b-76ed-735e-8112-4999c677022a€35.00€0.50matched
129capture01a1af4b-77de-7a2a-856c-ef34bb9ab889€35.00€0.50matched
130capture01a1af4b-a812-74e7-a1d2-44b19a546516€9.00€0.19matched
131capture01a1af4b-bb97-7dc7-aafd-33d09f209c9b€35.00€0.50matched
132capture01a1af4b-bf79-7a72-ab63-398712c6ec99€15.00€0.26matched
133capture01a1af4b-ce7c-7d5e-b190-25112d91333e€9.00€0.19matched
134capture01a1af4b-d412-7dc2-a0bd-a7c8e275049d€15.00€0.26matched
135capture01a1af4b-d4cd-7b4f-a1e0-fdb6a2139996€15.00€0.26matched
136capture01a1af4c-07a0-778a-bad3-6551479cf87c€15.00€0.26matched
137capture01a1af4c-20b3-7aa5-a79d-ea526a24798a€9.00€0.19matched
138capture01a1af4c-2570-7b97-817c-f6e47c5d0424€35.00€0.50matched
139refund01a1af4c-340b-700f-91ec-c1f51ae969d9-€11.00€0.00matched
140capture01a1af4c-365f-7f52-ab86-21f3ba15bd82€9.00€0.19matched
141capture01a1af4c-44f7-7a4b-973c-340d1aca18b7€35.00€0.50matched
142capture01a1af4c-9677-73e2-a594-609e46097136€24.00€0.37matched