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

Gross

€2,680.00

PSP fee

€42.70

Net to the bank

€2,637.30

Settlement journal

#378020

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a62f-2f1e-7c2c-a9d1-db7624bdded8 is already settled by stl_EUR_2989649 line 16
  • fee differencethe fee is not the contract feethe fee is 69, the contract says 67
  • missing linein the books, not in the filecapture:01a1a633-9815-77a4-b05c-9c4880890eae is in no file
LineKindReferenceGrossFeeStatus
17capture01a1a62f-2f5f-7772-9b3a-5596e0a1bf90€35.00€0.50duplicate line
100capture01a1a636-14ef-7029-b7c0-b3925870a7a0€49.00€0.69fee difference
1capture01a1a626-b763-7784-b608-b2e4a384be78€9.00€0.19matched
2capture01a1a62e-23d5-76a0-b587-d7aed9568dab€35.00€0.50matched
3capture01a1a62e-2808-77b0-84e5-6b19b40225b3€24.00€0.37matched
4capture01a1a62e-2b06-7a7c-b010-1ce5c7a4123b€9.00€0.19matched
5refund01a1a62e-2c75-7077-9f55-fb0b91644f99-€31.00€0.00matched
6capture01a1a62e-3f36-70fe-a244-f21b4b174126€24.00€0.37matched
7refund01a1a62e-5497-791a-b504-e35d03645570-€15.00€0.00matched
8capture01a1a62e-5d9f-765b-91da-7c997c43d03a€15.00€0.26matched
9capture01a1a62e-8caa-7207-936f-3fbfabbd662a€49.00€0.67matched
10capture01a1a62e-9048-73e0-be78-f90b1e54d471€35.00€0.50matched
11capture01a1a62e-9f06-710f-8d14-420f82162cb7€9.00€0.19matched
12capture01a1a62e-c7cb-7959-90db-4509db27f5b0€24.00€0.37matched
13capture01a1a62e-ed08-7f63-9ad4-4e55401d818e€15.00€0.26matched
14capture01a1a62f-0efb-778f-a35f-05b292b74bab€49.00€0.67matched
15capture01a1a62f-201a-72fe-bf24-94769a3b6f0a€49.00€0.67matched
16capture01a1a62f-2f5f-7772-9b3a-5596e0a1bf90€35.00€0.50matched
18capture01a1a62f-37d8-7964-ae03-031b6d2ec635€35.00€0.50matched
19capture01a1a62f-9ea6-78b7-8d05-14bf43540239€49.00€0.67matched
20capture01a1a62f-a1a5-7a12-9b6e-c214e9e16a1f€9.00€0.19matched
21capture01a1a62f-a620-798d-9bc8-ab272e01bfa6€15.00€0.26matched
22capture01a1a62f-b011-7304-b3c8-4f2ccf3dc7bb€15.00€0.26matched
23capture01a1a62f-be83-7921-9c19-1e76838d7409€9.00€0.19matched
24capture01a1a62f-da73-79be-973b-a1e3b5c821fe€35.00€0.50matched
25capture01a1a62f-e804-7f19-a4d9-6f07263f1892€49.00€0.67matched
26capture01a1a62f-f6fb-7034-bb36-7ba8bbe1f31e€9.00€0.19matched
27capture01a1a62f-fbf0-7480-81f2-83f36f6e01ea€35.00€0.50matched
28capture01a1a630-1d74-7821-9530-24e6d30f9721€24.00€0.37matched
29capture01a1a630-302d-7d0d-b1cc-90138c19606f€35.00€0.50matched
30refund01a1a630-3c3e-7692-af92-b19b3945bdc6-€29.00€0.00matched
31capture01a1a630-3ed0-79eb-9737-8f0bcdbbde1e€49.00€0.67matched
32capture01a1a630-3fd1-74ca-af6b-bd443d04f430€49.00€0.67matched
33capture01a1a630-4b45-7b9f-b9cc-649f49f20747€49.00€0.67matched
34capture01a1a630-57ac-72bc-a8e9-3119e03ed93f€15.00€0.26matched
35capture01a1a630-5b09-73dd-a483-40dadb048cb7€49.00€0.67matched
36capture01a1a630-6816-7d1b-a9a4-2334da2a5e8b€49.00€0.67matched
37capture01a1a630-8e08-7d0b-bb99-8dc9d7ff1b3d€24.00€0.37matched
38capture01a1a630-b223-76fc-b1b5-094cf62b7b47€49.00€0.67matched
39capture01a1a630-b9af-75eb-85b8-0bf69ef33a6a€24.00€0.37matched
40capture01a1a630-ddbe-7c94-ab3b-a67223f61afa€49.00€0.67matched
41capture01a1a630-e816-7fbc-b834-5ed98095fcca€9.00€0.19matched
42capture01a1a631-1e06-7315-aad0-456a286b3e32€9.00€0.19matched
43refund01a1a631-2eca-7d7d-913a-8f8761e04881-€6.00€0.00matched
44capture01a1a631-3836-7fe6-8a4c-cd7a5e05afc3€24.00€0.37matched
45capture01a1a631-480b-70b0-8989-7628e5e76aee€49.00€0.67matched
46capture01a1a631-77f4-7895-81e1-42462f9e6892€24.00€0.37matched
47capture01a1a631-d2e3-79fc-8cb9-8ca976f42c1f€9.00€0.19matched
48capture01a1a631-e67e-70d9-a132-4cbbc816d565€49.00€0.67matched
49capture01a1a631-e929-759c-933f-5f60f9f12943€24.00€0.37matched
50capture01a1a632-00a4-7dcc-a77b-213c40619553€49.00€0.67matched
51capture01a1a632-203a-757b-9b98-55c17dc9c2cf€35.00€0.50matched
52capture01a1a632-20ec-7899-8bdd-1b0cb5c0aec9€15.00€0.26matched
53capture01a1a632-5e96-717c-8fad-a09f2d4559f7€49.00€0.67matched
54refund01a1a632-6ed7-7be3-905c-ee9813eb9e0c-€24.00€0.00matched
55capture01a1a632-72bd-74a0-973b-a872d6ca9129€9.00€0.19matched
56capture01a1a632-77d4-7a08-8640-5ccaa2e2cd30€49.00€0.67matched
57capture01a1a632-894f-735c-9977-29a9ee8529c3€49.00€0.67matched
58capture01a1a632-8e96-73ae-b9e5-c71a88a7cc98€49.00€0.67matched
59capture01a1a632-9eb4-7450-93c7-510132db989a€9.00€0.19matched
60capture01a1a632-cf81-7125-befe-eeab8e16673a€24.00€0.37matched
61capture01a1a632-d10d-7455-9095-0b09d5614af2€15.00€0.26matched
62capture01a1a632-de58-7ea3-b6bf-ff508f2ef82d€24.00€0.37matched
63capture01a1a632-e9ef-7d9d-a8a8-412e69155c00€49.00€0.67matched
64capture01a1a632-ecac-7cca-b4df-f0a7b6d8c7de€35.00€0.50matched
65refund01a1a632-fad6-7507-86af-86bf7f7b2ab6-€4.00€0.00matched
66capture01a1a633-0461-71a9-9fb6-9b863a262fe7€9.00€0.19matched
67capture01a1a633-0ba5-75dd-b679-1f0728ab9e92€49.00€0.67matched
68capture01a1a633-66e5-79fc-aca5-cd8dc519fb44€15.00€0.26matched
69capture01a1a633-8d58-7551-83a1-45803796fe07€35.00€0.50matched
70capture01a1a633-900a-760d-ada7-04fa5c1d68a1€15.00€0.26matched
71capture01a1a633-99b2-7989-8b44-15dc993b60be€24.00€0.37matched
72capture01a1a633-a412-7d9d-ae0a-81ed5d8db4a0€49.00€0.67matched
73capture01a1a633-eede-75bd-afe4-50554ef52ea2€35.00€0.50matched
74capture01a1a633-fc74-737a-8687-211a2f537fa2€49.00€0.67matched
75capture01a1a634-22e7-701f-acbf-d8334bfbcffb€9.00€0.19matched
76capture01a1a634-64b4-7077-b48a-106f0b721c87€24.00€0.37matched
77capture01a1a634-8aa4-7705-b7e8-e5609b1f3b7b€35.00€0.50matched
78refund01a1a634-98a7-74a4-8699-64c1e1ec9235-€7.00€0.00matched
79capture01a1a634-a41e-72ce-9c29-0118be981270€15.00€0.26matched
80capture01a1a634-aeb7-7a40-af14-c88f27d110b1€49.00€0.67matched
81capture01a1a634-bde6-7c39-84d1-1cce64acbd06€35.00€0.50matched
82capture01a1a634-be81-7947-bf90-c50025d584ed€35.00€0.50matched
83capture01a1a634-cff9-7184-9b41-4a4bae1e75a5€9.00€0.19matched
84capture01a1a634-d767-7a7f-bb51-086c1faaafe6€49.00€0.67matched
85capture01a1a634-dedc-7f5e-83b4-4432a8338077€35.00€0.50matched
86capture01a1a635-07e5-7413-8f32-302e08c66b91€35.00€0.50matched
87capture01a1a635-155c-7906-a7d2-27fe37bd6093€24.00€0.37matched
88capture01a1a635-1e28-7931-ad4a-b91d506658a7€15.00€0.26matched
89capture01a1a635-31db-7210-bcfe-d1178d1139dd€9.00€0.19matched
90capture01a1a635-6a5e-7f59-913f-14ddca9416bf€24.00€0.37matched
91capture01a1a635-5cb4-7487-900d-8e671e22b9ec€24.00€0.37matched
92refund01a1a635-8888-73da-b207-7a728f2ad755-€8.00€0.00matched
93capture01a1a635-9c82-71f2-a993-f7bf8b8bbcec€15.00€0.26matched
94capture01a1a635-cb4f-7987-8ead-19e4dca0b5ac€9.00€0.19matched
95capture01a1a636-018e-727e-9d6d-92205fe30c31€15.00€0.26matched
96capture01a1a636-01b4-7822-898c-3675fe595fe4€49.00€0.67matched
97capture01a1a636-0409-7d38-b9aa-09a48e1f9e03€15.00€0.26matched
98capture01a1a636-05fc-7749-becc-d770aa594fd4€9.00€0.19matched
99capture01a1a636-0cc8-7990-8b7e-a94468b696b9€9.00€0.19matched
101capture01a1a636-2094-7048-b7c2-2e21e310ae05€9.00€0.19matched
102refund01a1a636-4d54-7475-8aa5-95a1cb270d8c-€24.00€0.00matched
103capture01a1a636-6bb8-73a8-aeb3-7ea592869717€24.00€0.37matched
104capture01a1a636-9dea-725e-ac69-f0f22b7780df€9.00€0.19matched
105capture01a1a636-b10d-7154-96d2-4016f7a139d7€35.00€0.50matched
106capture01a1a636-bf40-72ad-81cd-b530b9b257aa€49.00€0.67matched
107capture01a1a636-c1d0-7b7c-b198-7056eff200ae€15.00€0.26matched
108capture01a1a636-c2cd-79c9-b8ff-7d07259706b6€24.00€0.37matched
109capture01a1a636-d1c8-7776-80ab-d8c3953f09b8€24.00€0.37matched
110capture01a1a636-eb2c-78a6-9bab-39ea7ec24329€9.00€0.19matched
111refund01a1a637-1942-7fad-b04e-d19147ff497f-€44.00€0.00matched