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

3 Nov, 18:00

Gross

€2,856.00

PSP fee

€45.72

Net to the bank

€2,810.28

Settlement journal

#365317

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a295-5012-7374-905d-95f16f04c795 is already settled by stl_EUR_2989548 line 52
LineKindReferenceGrossFeeStatus
53capture01a1a295-5063-7804-b14f-b71753308ebd€35.00€0.50duplicate line
1capture01a1a28b-2410-73ff-9963-bb1dd6a9e96d€24.00€0.37matched
2capture01a1a28c-45b3-762f-9518-f34b25593288€49.00€0.67matched
3capture01a1a28c-cf7b-7f00-9668-a05b8ae6fcb4€9.00€0.19matched
4capture01a1a28e-1b23-79de-949c-bf1e1b91de99€49.00€0.67matched
5capture01a1a291-870c-7f25-b41e-2c79131b0e40€49.00€0.67matched
6capture01a1a291-9145-753b-933d-42fb878e9d0a€35.00€0.50matched
7capture01a1a291-acb7-7b6d-8337-d6f53098a442€9.00€0.19matched
8capture01a1a291-bb7d-72b6-bef9-8c2c49fc0c73€9.00€0.19matched
9capture01a1a291-c79b-7671-a407-e4f42d9de592€35.00€0.50matched
10capture01a1a291-c923-7799-a3bf-3c39c9484983€9.00€0.19matched
11capture01a1a291-e2b1-7ede-b10f-e008bca84fc7€9.00€0.19matched
12capture01a1a291-ee86-729c-b867-329a7aec5367€9.00€0.19matched
13capture01a1a291-fc29-7a5c-8c5e-2037efb3f27d€9.00€0.19matched
14capture01a1a292-20f6-7edf-8111-91d9aac3baf1€24.00€0.37matched
15capture01a1a292-610c-74c3-beec-6bad669af0fa€9.00€0.19matched
16capture01a1a292-6256-733c-8129-56a14a6b2bd9€24.00€0.37matched
17capture01a1a292-8818-7026-bcee-b3d745f915e2€35.00€0.50matched
18capture01a1a292-9827-73bf-9718-af95cd0d2ba8€9.00€0.19matched
19capture01a1a292-a589-7c8a-9704-544913d5191f€49.00€0.67matched
20capture01a1a292-ace6-70cb-b38d-ecfa53a8be02€35.00€0.50matched
21capture01a1a292-b911-795f-87e0-af14ec208767€24.00€0.37matched
22capture01a1a292-d063-76cf-8a8e-1571468007f4€15.00€0.26matched
23capture01a1a292-d38a-7231-99f7-b5443a05ea77€35.00€0.50matched
24capture01a1a292-d8d0-7606-a785-037d66968afa€49.00€0.67matched
25capture01a1a292-f51e-73ae-9afc-d1cc632dd7f1€49.00€0.67matched
26capture01a1a292-f995-7ef3-80ad-93719665c86a€24.00€0.37matched
27capture01a1a293-0dbc-7a4d-bc95-738526c8f8f7€9.00€0.19matched
28capture01a1a293-1189-759c-b2f3-b17b4b089be3€9.00€0.19matched
29capture01a1a293-2638-706c-ac84-d8615c61863c€35.00€0.50matched
30capture01a1a293-4118-7d25-9154-84e01d997d64€35.00€0.50matched
31capture01a1a293-464b-7d39-afea-2938a20a136b€15.00€0.26matched
32capture01a1a293-4742-7ab3-bfa0-46880b688615€24.00€0.37matched
33capture01a1a293-6b45-79a3-be9a-7e9d119b89e0€35.00€0.50matched
34capture01a1a293-6dcf-7e9f-939b-a65072c30fa4€35.00€0.50matched
35capture01a1a293-929a-785a-8b8b-4960372c856a€49.00€0.67matched
36capture01a1a293-d383-7631-8e01-c86dfc8db9ed€24.00€0.37matched
37capture01a1a293-db2f-70ed-a515-db47edbd0f39€35.00€0.50matched
38capture01a1a293-e104-7645-8c3a-48594342bcd1€35.00€0.50matched
39capture01a1a293-fc48-7727-af13-9547258dec99€35.00€0.50matched
40capture01a1a293-fde7-76c9-bda2-18ad26a7ba5b€15.00€0.26matched
41capture01a1a294-038d-7faf-962a-5a63a3e1eb3f€9.00€0.19matched
42capture01a1a294-20b5-739f-8c3c-7cf6ea8530ce€15.00€0.26matched
43capture01a1a294-2a4f-701e-9f6f-4831734880cd€9.00€0.19matched
44capture01a1a294-3302-761a-8b42-0ef3047927b9€15.00€0.26matched
45capture01a1a294-4cb5-7ab1-a79b-75a29a085827€9.00€0.19matched
46refund01a1a294-718f-713a-9407-dcc6c856976b-€8.00€0.00matched
47capture01a1a294-86f5-73ec-9705-6edbcac8950d€15.00€0.26matched
48capture01a1a294-9ce4-7b44-94ac-12a5351b808e€15.00€0.26matched
49capture01a1a294-9e3b-7d8d-88b6-941b34a16437€15.00€0.26matched
50refund01a1a294-fb03-740e-8ac8-dc4c0357d78d-€11.00€0.00matched
51capture01a1a295-3867-7485-b31b-13febda5d4ac€15.00€0.26matched
52capture01a1a295-5063-7804-b14f-b71753308ebd€35.00€0.50matched
54capture01a1a295-968f-714d-914f-b1655d6b62fb€49.00€0.67matched
55capture01a1a295-a129-7f41-b6aa-e1f8c844318c€35.00€0.50matched
56capture01a1a295-af2a-79a8-b485-ef771aec37a8€24.00€0.37matched
57capture01a1a295-b078-780e-b0ad-2984f1769f71€49.00€0.67matched
58capture01a1a295-b5c4-7220-b7aa-04bdbe18c5de€15.00€0.26matched
59capture01a1a295-d572-7fbc-ab33-278894824f91€15.00€0.26matched
60capture01a1a295-e0ff-7440-91ee-d5f05295db16€35.00€0.50matched
61capture01a1a295-e3b1-706b-8b98-a9c76ff88500€9.00€0.19matched
62capture01a1a295-f8c1-7eaa-a50d-af5329242fbd€15.00€0.26matched
63capture01a1a296-026d-7ca6-b205-ab49f14413b0€24.00€0.37matched
64capture01a1a296-13d3-7caa-933b-97b869e6de24€24.00€0.37matched
65refund01a1a296-160e-7350-8b72-061f016f9a72-€17.00€0.00matched
66capture01a1a296-2062-7862-8714-1d4e5db1aa50€24.00€0.37matched
67capture01a1a296-21a7-7cee-86bb-a8c6caf409a3€9.00€0.19matched
68capture01a1a296-2786-70a5-82f6-e560548cc386€24.00€0.37matched
69capture01a1a296-2daa-7d16-b3e7-129d2402b3cc€24.00€0.37matched
70refund01a1a296-3835-7546-9dbe-728116e33f6b-€30.00€0.00matched
71capture01a1a296-6470-77f6-b064-75b60af7b23c€24.00€0.37matched
72capture01a1a296-711f-7fe2-a7c0-52d23459c05c€24.00€0.37matched
73capture01a1a296-7ab1-7440-b341-f4d7415303b5€9.00€0.19matched
74capture01a1a296-9ee4-74e7-b362-49dbc1e28a8e€35.00€0.50matched
75capture01a1a296-a34b-7446-a29c-3f74ba870df8€35.00€0.50matched
76capture01a1a296-ce51-7923-ad75-2d387111393c€9.00€0.19matched
77refund01a1a296-cef6-7b5a-a91d-04046527327b-€12.00€0.00matched
78capture01a1a296-ee95-7c36-b97f-6aee97e6f2d3€35.00€0.50matched
79capture01a1a296-f87f-7fa1-8104-6cca8fa69e1d€49.00€0.67matched
80capture01a1a297-47fd-7d92-8f73-9b69c6e90196€24.00€0.37matched
81capture01a1a297-4423-76d1-8fcf-1b7255e568fc€49.00€0.67matched
82capture01a1a297-49da-722f-b0f2-605f7c672fcd€9.00€0.19matched
83capture01a1a297-5a77-7fd5-9284-4daaf40b5fac€49.00€0.67matched
84capture01a1a297-5af3-72c9-b146-15de0a1f2e46€35.00€0.50matched
85capture01a1a297-5cef-736c-802f-c09af75c5a2b€9.00€0.19matched
86capture01a1a297-7f5e-78ec-ae66-cd75a3561fe4€49.00€0.67matched
87refund01a1a297-86c6-75e2-ac50-468ee57a093f-€17.00€0.00matched
88capture01a1a297-b1cc-70a6-902a-f0370ce08a75€24.00€0.37matched
89capture01a1a297-b378-7c10-948b-33e10bdfaa2f€24.00€0.37matched
90capture01a1a297-b5d1-7309-b154-92f410647292€9.00€0.19matched
91refund01a1a297-be61-7ef4-9135-638ac3991cf9-€39.00€0.00matched
92capture01a1a297-d158-7b62-98b5-82da9aab33ce€24.00€0.37matched
93capture01a1a297-d59d-7c21-8dbf-16d17576cf16€9.00€0.19matched
94capture01a1a297-d84a-7a98-9046-4b3fc02febd8€35.00€0.50matched
95capture01a1a297-dc5c-7874-be20-0d499cc22dc8€24.00€0.37matched
96capture01a1a297-dcad-786b-8571-d5e9dffc8e6c€49.00€0.67matched
97capture01a1a297-ea6a-7d56-8495-9a19de2b6f44€24.00€0.37matched
98capture01a1a297-edc4-7393-9b8c-17a6e4b0014e€24.00€0.37matched
99capture01a1a297-fe37-7372-a708-1da2505da13e€15.00€0.26matched
100capture01a1a298-6210-7d2f-bd6d-5c1b4d783ffa€49.00€0.67matched
101capture01a1a298-6883-7b85-94e7-7a8712d85b31€24.00€0.37matched
102capture01a1a298-8e96-79e6-9fb3-3c3756fe2fec€24.00€0.37matched
103capture01a1a298-c07e-7fb5-b98f-09bb73bd92c4€49.00€0.67matched
104capture01a1a298-c6a6-7e7f-bb48-cafca6746708€15.00€0.26matched
105capture01a1a298-f8f8-7a69-bda3-d75acdae08e7€35.00€0.50matched
106capture01a1a298-ff06-7938-822d-d79d62919b01€49.00€0.67matched
107capture01a1a298-ffdc-7e2f-99a0-bef45bd2feb5€15.00€0.26matched
108capture01a1a299-0ede-78d1-9dbf-1e4ab572188c€15.00€0.26matched
109capture01a1a299-1865-7d1f-8313-f3688a45e334€49.00€0.67matched
110capture01a1a299-2500-7348-bc3b-3612cd013872€49.00€0.67matched
111capture01a1a299-3344-768d-8a6f-32bbba01e83f€15.00€0.26matched
112refund01a1a299-5fab-7e91-ba41-82830e937f13-€35.00€0.00matched
113capture01a1a299-90c9-7e9b-820e-41c8e3af8c37€35.00€0.50matched
114capture01a1a299-b6d9-7279-be7b-cb7e8266820d€35.00€0.50matched
115capture01a1a299-ce9d-775c-9684-ac60af20fb56€9.00€0.19matched
116capture01a1a299-f9eb-7854-b36e-6ff708613601€35.00€0.50matched
117capture01a1a29a-1182-7859-b6e9-972c0acfa49b€24.00€0.37matched
118capture01a1a29a-1d51-72ef-bfb1-a5ce282c954f€15.00€0.26matched
119capture01a1a29a-427c-75f9-8929-b3e2f5bda5f3€15.00€0.26matched
120capture01a1a29a-4802-7263-b070-677c83424d86€24.00€0.37matched
121capture01a1a29a-6710-7855-838c-9c177900b43e€24.00€0.37matched
122capture01a1a29a-7206-70b8-816d-095bf68d1d0b€15.00€0.26matched
123capture01a1a29a-7c6a-737c-8ad6-732a089c88f9€15.00€0.26matched
124capture01a1a29a-819f-79ee-8189-5e778a333a8f€49.00€0.67matched