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

2 Nov, 08:20

Gross

€2,949.00

PSP fee

€49.21

Net to the bank

€2,899.79

Settlement journal

#339647

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a19b59-54c7-7e2d-9256-f80f8f729bc3 is already settled by stl_EUR_2989346 line 28
  • duplicate linethe file lists it twicecapture:01a19b5d-018f-7d53-8aa0-06924d84df07 is already settled by stl_EUR_2989346 line 84
  • duplicate linethe file lists it twicecapture:01a19b60-59c9-7fcf-a0ac-08103e0580be is already settled by stl_EUR_2989346 line 129
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
LineKindReferenceGrossFeeStatus
19capture01a19b59-0530-7a45-8875-a619a265f357€35.00€0.55fee difference
29refund01a19b59-54ca-741d-a5e8-046073780066-€5.00€0.00duplicate line
85capture01a19b5d-01ea-7783-9496-ff8c9bc21f4c€15.00€0.26duplicate line
130capture01a19b60-5af6-7c59-9e98-3d8f5f447365€35.00€0.50duplicate line
1capture01a19b57-3940-7006-a155-51d523aeb008€49.00€0.67matched
2capture01a19b57-c263-71bc-93ae-2b7abd52b702€15.00€0.26matched
3capture01a19b58-0e12-78f3-92cf-59e0de2cf078€24.00€0.37matched
4capture01a19b58-4971-7d09-9c92-c0c4c4d24d31€9.00€0.19matched
5capture01a19b58-4d87-7c66-8fa6-62e213aaae6e€15.00€0.26matched
6capture01a19b58-4e21-7c8e-b172-c94cac3fb852€35.00€0.50matched
7capture01a19b58-600c-7f57-807d-4b09f0275d61€49.00€0.67matched
8capture01a19b58-8f59-7fa6-9baf-2f11a490b626€9.00€0.19matched
9refund01a19b58-8fdf-71f5-9962-8ef15432d856-€12.00€0.00matched
10capture01a19b58-a17b-7bb9-8676-463363c5867d€9.00€0.19matched
11capture01a19b58-a656-77a6-af3d-e04b03047a5c€49.00€0.67matched
12capture01a19b58-b110-7cd4-b29c-a5709314d598€9.00€0.19matched
13capture01a19b58-cf00-7394-8cba-a73055d18917€24.00€0.37matched
14refund01a19b58-d1c6-7343-8cbc-74793d1424f8-€3.00€0.00matched
15capture01a19b58-dceb-7422-b110-92ba59d0fe33€35.00€0.50matched
16capture01a19b58-f912-71c7-a3c5-811096abe601€49.00€0.67matched
17capture01a19b58-f642-7ca0-872d-4e3cfaa0c653€49.00€0.67matched
18capture01a19b58-fdec-7ef7-8725-180638699e17€49.00€0.67matched
20capture01a19b59-0d88-708b-8d12-163e172244cb€15.00€0.26matched
21capture01a19b59-12f1-73b5-b767-ebd2b110596b€9.00€0.19matched
22capture01a19b59-21cc-7e88-9659-9b3605360d37€15.00€0.26matched
23capture01a19b59-323e-7139-93c2-5356228a5dce€15.00€0.26matched
24capture01a19b59-38af-790d-a354-aae21b91a1de€24.00€0.37matched
25capture01a19b59-4457-77c2-bb90-2ac10ab06f78€24.00€0.37matched
26capture01a19b59-4c7a-75b6-bd42-01b273e44a23€9.00€0.19matched
27capture01a19b59-4d99-7c2d-9677-3a33eaee0317€49.00€0.67matched
28refund01a19b59-54ca-741d-a5e8-046073780066-€5.00€0.00matched
30capture01a19b59-5b7c-7ee9-9e91-c207e84819b1€35.00€0.50matched
31capture01a19b59-601b-7416-aed0-8da2a749e930€49.00€0.67matched
32refund01a19b59-6b60-7195-8bea-5daa81f53558-€5.00€0.00matched
33capture01a19b59-6e59-7cff-9003-f4fce5adf909€15.00€0.26matched
34capture01a19b59-8520-7035-ad5b-d1a65f96dc9f€9.00€0.19matched
35refund01a19b59-89c6-7107-911c-76c1ffd1e431-€20.00€0.00matched
36refund01a19b59-95e7-7d88-a753-7d2c805dcfdd-€5.00€0.00matched
37capture01a19b59-c9d0-7c7c-89f9-dfb4afc9e6a4€49.00€0.67matched
38capture01a19b59-cc6e-7632-a76b-937e2a2493a2€24.00€0.37matched
39capture01a19b59-ceb2-7aaf-82f5-ce15a1ad52cc€9.00€0.19matched
40capture01a19b59-eace-7ecd-a928-246964182e5a€9.00€0.19matched
41capture01a19b59-fffb-77ef-af80-5f8cd6d31ba7€9.00€0.19matched
42capture01a19b5a-0853-767a-89f1-65caf5f2a03e€9.00€0.19matched
43capture01a19b5a-1153-7122-a647-3711d8040c9e€9.00€0.19matched
44capture01a19b5a-12a7-74db-9a26-fde434a3405b€15.00€0.26matched
45capture01a19b5a-1771-7943-b6c0-77f4c5a8f731€35.00€0.50matched
46capture01a19b5a-1b90-712c-8a31-08a7b7a487c3€9.00€0.19matched
47capture01a19b5a-2a84-79c8-9951-19519d3adce3€9.00€0.19matched
48capture01a19b5a-36c0-78b4-974d-889d4be55bee€24.00€0.37matched
49capture01a19b5a-50b1-79be-9ab8-362d8328cb2a€9.00€0.19matched
50capture01a19b5a-5b51-7f3c-9036-0d52961f4b1e€9.00€0.19matched
51refund01a19b5a-622e-7653-98b2-f803ea506964-€3.00€0.00matched
52capture01a19b5a-6a9e-77d1-81d5-56f70cf63a85€15.00€0.26matched
53capture01a19b5a-7220-7975-98bd-6e5e3059778f€15.00€0.26matched
54refund01a19b5a-8597-7d34-9b91-287ff85b0905-€16.00€0.00matched
55capture01a19b5a-86b1-7aa5-bc43-2f6cb9a15ecc€9.00€0.19matched
56capture01a19b5a-8dc7-7f4e-944e-99770985e767€35.00€0.50matched
57refund01a19b5a-a628-7b82-b76b-ed48895f04e6-€3.00€0.00matched
58capture01a19b5a-ba48-7c5f-8069-e6efe4fe89d2€35.00€0.50matched
59capture01a19b5a-d38f-794c-8532-f12acbddace0€35.00€0.50matched
60capture01a19b5a-df1a-772d-9951-8c90c318de8a€35.00€0.50matched
61capture01a19b5a-eaac-7ba3-a1c2-6e58b8570a04€35.00€0.50matched
62capture01a19b5a-f76c-74ae-9a01-fbae7d3404fe€35.00€0.50matched
63capture01a19b5b-2795-7e51-98d5-cfa895aa4484€15.00€0.26matched
64capture01a19b5b-2dfb-78a2-bd08-0068ae748cac€15.00€0.26matched
65capture01a19b5b-31d7-78c6-9211-00a80cf52c7c€49.00€0.67matched
66capture01a19b5b-2e65-77da-a607-07b1150d2420€24.00€0.37matched
67capture01a19b5b-383a-7cf0-b4d7-6ec165c0a045€15.00€0.26matched
68capture01a19b5b-46fb-7613-b8ae-cd31c35d387e€9.00€0.19matched
69capture01a19b5b-6af8-748e-9d20-76edbc112aa6€35.00€0.50matched
70capture01a19b5b-7ead-7d21-938d-ffa8099f10c2€9.00€0.19matched
71refund01a19b5b-a487-74b3-91e6-c97683821739-€7.00€0.00matched
72capture01a19b5b-b601-7357-9684-7880936cad71€49.00€0.67matched
73capture01a19b5b-c388-7a55-a26c-9f3c24ae9559€49.00€0.67matched
74capture01a19b5c-1044-7f2c-83d3-25e66bee08f3€15.00€0.26matched
75capture01a19b5c-1439-7dc7-974c-c353b10385b5€9.00€0.19matched
76refund01a19b5c-2fab-7628-b515-404f550e11a5-€47.00€0.00matched
77capture01a19b5c-3631-745b-8d32-4cde1c1e9fd5€9.00€0.19matched
78capture01a19b5c-42e0-7abd-bcd4-91ff7bcec3db€24.00€0.37matched
79capture01a19b5c-4fa2-7a68-acef-ecf21d9c83ff€35.00€0.50matched
80capture01a19b5c-818c-7813-95e4-ab0dda7137d1€24.00€0.37matched
81refund01a19b5c-ab8d-7f99-9eab-c8fc37ce5422-€18.00€0.00matched
82capture01a19b5c-bc71-78d7-870b-1a73219e05b4€15.00€0.26matched
83refund01a19b5c-cbf6-725b-8c4d-05ab1e939332-€14.00€0.00matched
84capture01a19b5d-01ea-7783-9496-ff8c9bc21f4c€15.00€0.26matched
86capture01a19b5d-05de-7176-ba99-63a49ac55e35€15.00€0.26matched
87capture01a19b5d-030b-784f-8674-600b8732a748€49.00€0.67matched
88capture01a19b5d-2ba7-7a70-8908-b7df003468e9€24.00€0.37matched
89capture01a19b5d-33e9-7212-b11a-cc397ed14201€49.00€0.67matched
90capture01a19b5d-51ee-716a-b15c-4e89da43147e€49.00€0.67matched
91capture01a19b5d-5b62-77de-b0e5-d58dc3fa6e42€24.00€0.37matched
92capture01a19b5d-6868-76ea-a243-1e7802cc1431€24.00€0.37matched
93capture01a19b5d-7c3e-7db6-a959-306a51472cea€24.00€0.37matched
94capture01a19b5d-a0d7-7a27-8a79-da144727112c€15.00€0.26matched
95capture01a19b5d-ab99-756b-abb4-04dccc3aa159€9.00€0.19matched
96refund01a19b5d-9fdf-7c3b-8f58-e8adbe4b4543-€49.00€0.00matched
97refund01a19b5d-affd-7aa9-978a-5aac1b5d0d69-€18.00€0.00matched
98capture01a19b5d-c758-78c4-a63b-935c06d8c7df€49.00€0.67matched
99capture01a19b5d-f061-7634-b588-260a87f012c5€15.00€0.26matched
100capture01a19b5e-1e29-715a-818e-c8b36ed010dc€24.00€0.37matched
101capture01a19b5e-1f4c-739e-9a4c-9e281e6843e6€24.00€0.37matched
102capture01a19b5e-27b4-7087-bb10-269f715f4fd5€24.00€0.37matched
103capture01a19b5e-1354-7801-bba7-5d587ea168d4€15.00€0.26matched
104capture01a19b5e-361e-75ca-87b8-df74bfad6611€35.00€0.50matched
105capture01a19b5e-399e-7f65-91cb-b3034016de92€49.00€0.67matched
106capture01a19b5e-540b-7038-8d8b-40e60fcf6c8c€9.00€0.19matched
107capture01a19b5e-8d33-76ac-b6a7-d41a21150077€35.00€0.50matched
108capture01a19b5e-cf54-72f5-b4d6-9a5f0506d697€24.00€0.37matched
109capture01a19b5e-e08a-7fcb-9f32-ac0043d4980b€15.00€0.26matched
110capture01a19b5e-eb83-76f9-942a-c729097cbc11€35.00€0.50matched
111capture01a19b5e-f647-77ea-8fd9-8975ead5c25b€9.00€0.19matched
112refund01a19b5f-1d91-71b8-94fc-abc5bee57ac0-€24.00€0.00matched
113capture01a19b5f-245a-717e-ad85-17ed705d8b18€35.00€0.50matched
114capture01a19b5f-36f9-7f5e-af9b-827f9d949e8d€35.00€0.50matched
115capture01a19b5f-3c41-74b3-87d1-df7f2acd15ec€35.00€0.50matched
116capture01a19b5f-720e-7988-8f9b-251f38fae46c€35.00€0.50matched
117capture01a19b5f-738f-7bb5-a6d0-b9977084ee62€24.00€0.37matched
118capture01a19b5f-a5b6-73ca-8649-1baea0d98c09€35.00€0.50matched
119capture01a19b5f-d0de-774b-b889-97d5278f99a3€35.00€0.50matched
120capture01a19b5f-e089-7399-9bb2-81d33c2ad0c4€15.00€0.26matched
121capture01a19b5f-f990-7d66-991f-812500ab13d8€49.00€0.67matched
122capture01a19b5f-fbab-7721-ae2a-7dd517f24016€24.00€0.37matched
123capture01a19b60-01c8-7f93-9231-c1302b3ee5a8€49.00€0.67matched
124capture01a19b60-14f9-7a67-bb76-f445308edf4d€15.00€0.26matched
125capture01a19b60-2abe-770b-aa41-b8463e89914a€15.00€0.26matched
126refund01a19b60-30db-7d19-8673-333af6f93bc8-€12.00€0.00matched
127capture01a19b60-5386-79c9-972c-74031f6f4c01€24.00€0.37matched
128capture01a19b60-5a4e-76fd-9eb8-5267324d12b7€15.00€0.26matched
129capture01a19b60-5af6-7c59-9e98-3d8f5f447365€35.00€0.50matched
131capture01a19b60-5b40-7337-ba7e-764efe4316f5€9.00€0.19matched
132capture01a19b60-63e0-74da-8faa-5ef0be3cc5ba€49.00€0.67matched
133capture01a19b60-68f0-7677-903c-5224e661ec6d€24.00€0.37matched
134capture01a19b60-7275-7f87-b91f-8bb84bb2de4f€9.00€0.19matched
135capture01a19b60-8ea8-74d0-ae42-881b569f32fb€35.00€0.50matched
136capture01a19b60-b3f7-7e90-99ab-d1075f12b7bd€15.00€0.26matched
137refund01a19b60-bb8b-7220-9a8c-ec45712bcdad-€16.00€0.00matched
138capture01a19b60-bfc4-7cbf-a66e-2d6f73386878€9.00€0.19matched
139capture01a19b60-d550-71c1-b776-2463d01b8f80€9.00€0.19matched
140capture01a19b60-de4e-732f-bea2-1614a2f34f56€49.00€0.67matched
141capture01a19b60-eb9a-7dbd-a636-5e1077d92fb4€15.00€0.26matched
142capture01a19b60-f080-714a-88f3-74fa159b26a1€15.00€0.26matched
143capture01a19b60-f172-7626-87b7-29c12d703002€49.00€0.67matched
144capture01a19b61-0280-77b9-9149-bde13f0177a7€9.00€0.19matched
145capture01a19b61-0626-7a1e-897e-f6bbff042332€9.00€0.19matched
146capture01a19b61-0a13-7fa1-9275-a8e121df1f86€49.00€0.67matched
147capture01a19b61-18f8-7c26-9870-1b3bfccc600e€35.00€0.50matched