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

Gross

€3,475.00

PSP fee

€55.12

Net to the bank

€3,419.88

Settlement journal

#406634

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ae3d-612c-7893-bf29-916853b3fbfc is already settled by stl_EUR_2989874 line 53
  • fee differencethe fee is not the contract feethe fee is 71, the contract says 67
  • missing linein the books, not in the filecapture:01a1ae3f-b3ef-70e5-8d92-2e38921e1779 is in no file
LineKindReferenceGrossFeeStatus
54capture01a1ae3d-614d-7095-acc0-345ee93f56f1€24.00€0.37duplicate line
127capture01a1ae42-478c-7987-8910-384ad576dbdb€49.00€0.71fee difference
1refund01a1ae33-9da1-72ed-9986-3187de098f14-€23.00€0.00matched
2capture01a1ae34-368d-711b-b988-b50acb316c98€49.00€0.67matched
3capture01a1ae34-bcfa-7710-9d38-cba7440f956e€49.00€0.67matched
4capture01a1ae34-c2be-751c-918c-ace62de11f9d€49.00€0.67matched
5capture01a1ae3a-0782-761c-b1cc-1baa7549bf06€49.00€0.67matched
6capture01a1ae3a-0789-77da-b386-1a20a6f70d2b€24.00€0.37matched
7capture01a1ae3a-0a89-76ce-b309-7d53b33186f7€24.00€0.37matched
8capture01a1ae3a-197d-7cc1-a5ef-95dac1f82474€15.00€0.26matched
9capture01a1ae3a-29a7-7ee0-a917-7b3bdd65e6d9€49.00€0.67matched
10capture01a1ae3a-3198-7f07-9871-0ba2be67dbd1€15.00€0.26matched
11capture01a1ae3a-5f07-7e1b-9ea7-17634a7707e1€35.00€0.50matched
12capture01a1ae3a-6d8f-788a-b1d3-4fba546f9105€15.00€0.26matched
13capture01a1ae3a-8dfb-706c-b398-9e94d3dff172€9.00€0.19matched
14capture01a1ae3a-98e4-7540-a17c-4f3eac9b4107€35.00€0.50matched
15capture01a1ae3a-9a61-7d60-ae7b-ac8ca8094df1€49.00€0.67matched
16capture01a1ae3a-9ec5-71fe-b329-479903f71e1d€15.00€0.26matched
17capture01a1ae3a-b755-706e-b378-559bdedb86b2€24.00€0.37matched
18capture01a1ae3a-b781-70ce-8938-2f00246a2235€35.00€0.50matched
19capture01a1ae3a-be83-7320-86ed-04b55f5a3911€35.00€0.50matched
20capture01a1ae3a-cc71-79d3-893e-15a6b5743ffc€24.00€0.37matched
21capture01a1ae3a-cdd9-7a8a-a394-a45fffc25b64€9.00€0.19matched
22capture01a1ae3a-c9ec-7609-91fb-451ebca4d718€35.00€0.50matched
23capture01a1ae3a-d8ce-7516-82ae-a5f627c318c1€15.00€0.26matched
24capture01a1ae3a-e45d-71ca-8844-ead70251614b€35.00€0.50matched
25capture01a1ae3b-1c0d-7353-9407-17a2ee5e8dd2€49.00€0.67matched
26refund01a1ae3b-4ba9-7fd8-b3df-c03b39f45344-€16.00€0.00matched
27capture01a1ae3b-5615-76d6-88ef-e4b07012c703€15.00€0.26matched
28capture01a1ae3b-58cc-73ff-98a5-a1d9f36e356c€15.00€0.26matched
29capture01a1ae3b-9e1d-7669-9c19-6d91f642ab39€9.00€0.19matched
30capture01a1ae3b-b003-705d-bd50-48ef755ae992€24.00€0.37matched
31capture01a1ae3b-c48f-774d-b430-b4312198ac1c€35.00€0.50matched
32capture01a1ae3b-cad8-729c-a729-f33b0901b28b€35.00€0.50matched
33capture01a1ae3b-ce35-7c2a-93d2-e92b349b0085€24.00€0.37matched
34capture01a1ae3b-eb3b-7d4e-a6fb-68be75aafa15€24.00€0.37matched
35capture01a1ae3b-eeb4-7fb1-a929-2ae349be3948€15.00€0.26matched
36refund01a1ae3b-f955-7275-a0b9-3def3afb9d29-€10.00€0.00matched
37capture01a1ae3b-fb76-722d-acff-f76845512182€49.00€0.67matched
38refund01a1ae3b-fd6f-794f-a865-3adbe0bb9807-€27.00€0.00matched
39capture01a1ae3c-5cce-7ead-b194-b4c60807dfce€49.00€0.67matched
40capture01a1ae3c-80a1-7264-b164-4f6e8ca7bf09€35.00€0.50matched
41capture01a1ae3c-8f96-7529-9a54-227f4246407b€35.00€0.50matched
42capture01a1ae3c-96a7-7fca-9f02-ef6e3266f5e0€15.00€0.26matched
43capture01a1ae3c-b2ca-7bfa-a9a8-9da731272ef2€49.00€0.67matched
44capture01a1ae3c-bd3a-71a0-8a70-c1e6de316d3c€9.00€0.19matched
45capture01a1ae3c-bd66-7929-a8c4-7a38321d17c8€9.00€0.19matched
46capture01a1ae3c-ca86-791c-922e-ba648b531958€15.00€0.26matched
47capture01a1ae3c-e108-7831-b4fe-646801bad4d5€9.00€0.19matched
48refund01a1ae3c-f736-79fe-8d57-06eb688fd9af-€14.00€0.00matched
49refund01a1ae3c-ffa9-7ec2-9425-893431ece196-€46.00€0.00matched
50capture01a1ae3d-1c33-724b-886f-f169937f7c3b€9.00€0.19matched
51capture01a1ae3d-3c0c-7fd7-8b77-bdbcf8e70b02€24.00€0.37matched
52capture01a1ae3d-4066-7c2c-8302-ee9798387442€35.00€0.50matched
53capture01a1ae3d-614d-7095-acc0-345ee93f56f1€24.00€0.37matched
55capture01a1ae3d-669e-7a0e-ae8d-fed642209888€24.00€0.37matched
56capture01a1ae3d-b06a-7b40-b88b-3dfea005b011€9.00€0.19matched
57capture01a1ae3d-b868-7711-9311-07e08286ff05€24.00€0.37matched
58capture01a1ae3d-bbd3-7a3f-b17c-13145108a74a€15.00€0.26matched
59refund01a1ae3d-ce2d-7270-bf90-8dbc92905b29-€19.00€0.00matched
60capture01a1ae3d-e05f-75fc-92cb-7ab8666d7ae8€24.00€0.37matched
61capture01a1ae3d-e4a3-73db-a3a6-d3a5ee9faf97€9.00€0.19matched
62capture01a1ae3d-ef72-7716-a035-1c24bdf7ec0c€49.00€0.67matched
63capture01a1ae3d-f957-7bce-bbff-eaa064e6fa15€24.00€0.37matched
64capture01a1ae3e-1ab8-71e2-a6ab-50f9400a3788€15.00€0.26matched
65capture01a1ae3e-263d-7198-a138-18152f335196€49.00€0.67matched
66capture01a1ae3e-554f-72dc-8c84-8571b42e693f€24.00€0.37matched
67capture01a1ae3e-5c00-7762-ac1e-bbf27852fc4d€35.00€0.50matched
68capture01a1ae3e-797b-732b-b729-ee8a3aa68df9€35.00€0.50matched
69capture01a1ae3e-a13a-721a-aa26-3710c2577ebb€24.00€0.37matched
70capture01a1ae3e-acc1-7274-85d0-e9ff69f1bb23€15.00€0.26matched
71capture01a1ae3e-aff3-71b4-a140-35e05e919004€35.00€0.50matched
72capture01a1ae3e-b9be-7e35-96d5-d65f5551ebaa€49.00€0.67matched
73capture01a1ae3e-c0bb-7ffd-b588-e619a9d49a93€15.00€0.26matched
74capture01a1ae3e-caef-7dd9-b0a5-c815e7c65d88€35.00€0.50matched
75capture01a1ae3e-d423-7e6b-a324-6bb37d4b770e€9.00€0.19matched
76capture01a1ae3e-db70-7304-9187-fc80b350a65b€24.00€0.37matched
77capture01a1ae3e-ee44-7d11-9b0f-e277e15156f5€35.00€0.50matched
78capture01a1ae3e-fca0-7886-be3e-3a958072c9cd€15.00€0.26matched
79capture01a1ae3f-0436-7e54-9f71-2b65c75fcb3c€49.00€0.67matched
80capture01a1ae3f-0f13-70f3-a13f-796b4b96d015€49.00€0.67matched
81capture01a1ae3f-296e-7d25-8483-f4ac8d831649€49.00€0.67matched
82capture01a1ae3f-29a2-7fe5-928c-dc0dd031a339€9.00€0.19matched
83capture01a1ae3f-4ff4-7497-a92c-3c369e2934a7€24.00€0.37matched
84capture01a1ae3f-681a-7b62-ac60-69e68ead43e9€15.00€0.26matched
85capture01a1ae3f-a62b-71ba-a8f1-f5075578e68e€9.00€0.19matched
86capture01a1ae3f-bbbc-75fe-bf4d-9496deb9c29f€35.00€0.50matched
87capture01a1ae3f-e58f-767c-9abe-2ed75303f289€24.00€0.37matched
88refund01a1ae3f-fd9e-7898-8b16-fb4901e8670e-€10.00€0.00matched
89capture01a1ae40-01e9-7163-a2aa-75f952922500€49.00€0.67matched
90capture01a1ae40-0ca7-706d-90e6-c119acfe8ee1€35.00€0.50matched
91capture01a1ae40-100d-754b-9443-6dddaf0394e0€15.00€0.26matched
92capture01a1ae40-14f3-7677-9eb7-b4da172c1910€49.00€0.67matched
93capture01a1ae40-2810-7ea4-aea6-6271ea84dd27€24.00€0.37matched
94capture01a1ae40-2859-71cd-959e-2b461a80c97a€15.00€0.26matched
95capture01a1ae40-29ad-726a-adfd-83b546fda4a3€49.00€0.67matched
96capture01a1ae40-2f6c-7c49-be4b-8ad45107a6a1€35.00€0.50matched
97capture01a1ae40-5cbe-7ff8-9a19-a8f00c390882€9.00€0.19matched
98capture01a1ae40-7e46-7a27-89de-0b289c64e502€35.00€0.50matched
99capture01a1ae40-81c2-7dc0-8329-99e7b21e09d8€15.00€0.26matched
100capture01a1ae40-8aca-750c-ba74-5c92fb7689fe€15.00€0.26matched
101capture01a1ae40-9730-7b4b-8136-8c9495143bee€9.00€0.19matched
102capture01a1ae40-9851-7f74-8178-7e23fe24bd47€15.00€0.26matched
103capture01a1ae40-b4ec-704f-973f-26fbe32bf8b0€24.00€0.37matched
104capture01a1ae40-bd87-77ff-944c-1a310d58e79c€49.00€0.67matched
105capture01a1ae40-dd90-7697-91e2-b6057480bb21€9.00€0.19matched
106capture01a1ae40-e4f4-75d4-b20d-8d66b21446de€24.00€0.37matched
107capture01a1ae40-fe5c-7d43-85ab-e193e0de1ce6€9.00€0.19matched
108capture01a1ae41-0810-78e2-98cf-5e9580d748ba€9.00€0.19matched
109capture01a1ae41-159f-7745-a220-59faf0d6ec9e€35.00€0.50matched
110capture01a1ae41-2050-7548-9aff-84e512e209ec€15.00€0.26matched
111capture01a1ae41-2c10-7edc-a2dd-dd61584d9a3b€49.00€0.67matched
112capture01a1ae41-45d6-7563-b9b9-5f946aa6d442€9.00€0.19matched
113capture01a1ae41-66cf-736d-9115-a7b7c70e26dc€49.00€0.67matched
114capture01a1ae41-6766-77ae-bab9-1723b3491a10€35.00€0.50matched
115capture01a1ae41-7194-76e1-91ca-72ae0ae1d30a€15.00€0.26matched
116refund01a1ae41-721e-7f49-974a-cd883a9e08a3-€14.00€0.00matched
117capture01a1ae41-833a-71a4-a66e-96114aff1769€49.00€0.67matched
118capture01a1ae41-a4e1-7ca8-918c-94814293a8cd€15.00€0.26matched
119refund01a1ae41-b522-79e4-b030-9596c21e16ac-€8.00€0.00matched
120capture01a1ae41-ccbe-7ddd-a818-fc818a41723c€49.00€0.67matched
121capture01a1ae41-e7dd-79b6-bd36-37539202206b€49.00€0.67matched
122capture01a1ae42-128e-763f-b393-4c14b8a0fa05€35.00€0.50matched
123capture01a1ae42-23fc-774c-8695-464975ea82ad€24.00€0.37matched
124capture01a1ae42-2839-7511-9175-f45299348630€24.00€0.37matched
125capture01a1ae42-372c-769f-9628-6629edccdc4d€9.00€0.19matched
126capture01a1ae42-3b07-7db5-b461-fa23c82cd59a€35.00€0.50matched
128capture01a1ae42-5c90-7155-a077-f49a25b871ee€35.00€0.50matched
129refund01a1ae42-66a5-7b98-8bcf-e351f393a82f-€9.00€0.00matched
130capture01a1ae42-670b-74c7-8604-3a993771cfdc€15.00€0.26matched
131capture01a1ae42-6a66-74b8-b70d-05ffb1f1d3e5€35.00€0.50matched
132capture01a1ae42-7b60-7f62-86ca-1362cfb2b99c€15.00€0.26matched
133capture01a1ae42-8f09-73f6-a945-e6a16fa4f556€9.00€0.19matched
134capture01a1ae42-90e5-7610-838f-a570da1dc56f€24.00€0.37matched
135capture01a1ae42-aabf-7e01-93b7-6c2cd0d45dac€35.00€0.50matched
136capture01a1ae42-b111-7d92-94a5-7d541f55a2da€15.00€0.26matched
137capture01a1ae42-bded-7d76-9bd8-40eb38f66810€15.00€0.26matched
138capture01a1ae42-c50f-77f7-9695-e685d5570a7f€49.00€0.67matched
139capture01a1ae42-cc58-7e7e-9282-ea8539d5e957€15.00€0.26matched
140capture01a1ae42-cfe1-7d7b-a626-96dd5ca0fea0€15.00€0.26matched
141capture01a1ae42-d02f-70d7-a0b5-03ca88f121ab€35.00€0.50matched
142capture01a1ae42-d102-7d70-8e1b-ccf867a6eee9€9.00€0.19matched
143capture01a1ae42-e953-7e28-a4a0-922e38c5d2b0€15.00€0.26matched
144capture01a1ae42-f393-735b-8c50-64a269847537€35.00€0.50matched
145capture01a1ae43-005f-704d-8abd-43b0435cbf0f€15.00€0.26matched
146capture01a1ae43-206e-712c-9038-73efd2162d10€49.00€0.67matched
147capture01a1ae43-2abb-7e53-95bc-10f3eacb8cf1€15.00€0.26matched