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

Gross

€2,601.00

PSP fee

€40.79

Net to the bank

€2,560.21

Settlement journal

#362224

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a1b6-7d70-7693-9782-f2784ff3d0c8 is already settled by stl_EUR_2989524 line 23
  • fee differencethe fee is not the contract feethe fee is 41, the contract says 37
LineKindReferenceGrossFeeStatus
6capture01a1a1b5-dfdf-7cc3-9d0b-ccce93719b4f€24.00€0.41fee difference
24capture01a1a1b6-9e2e-74ad-9d25-c1a2f22518ad€35.00€0.50duplicate line
1capture01a1a1b3-fccb-74af-9730-0dee2686ff8c€15.00€0.26matched
2capture01a1a1b5-afa0-78a6-9839-a4fcc785c501€15.00€0.26matched
3capture01a1a1b5-b567-7d63-bd29-5008601855d5€15.00€0.26matched
4capture01a1a1b5-d876-7a71-bbd5-c08c66bc532a€9.00€0.19matched
5refund01a1a1b5-df43-74b2-9f6a-db46abd9e187-€8.00€0.00matched
7capture01a1a1b5-ea71-70e5-94c0-7294095472ce€24.00€0.37matched
8capture01a1a1b5-fc3e-7c2d-bdeb-0f4d1dd92347€15.00€0.26matched
9capture01a1a1b6-1534-7e1b-83f4-575d821d6068€9.00€0.19matched
10capture01a1a1b6-1a47-7207-b5e0-f031ad27545e€9.00€0.19matched
11capture01a1a1b6-1f8c-71b6-ae3b-d35578c4e87c€35.00€0.50matched
12capture01a1a1b6-1fe3-792c-8862-a722700d344f€49.00€0.67matched
13capture01a1a1b6-2c34-75a9-a3e6-2d09afff17c2€9.00€0.19matched
14capture01a1a1b6-4ba1-7225-a09c-ec9162c79331€9.00€0.19matched
15capture01a1a1b6-4d83-77d9-91e7-6fd015a6f37a€35.00€0.50matched
16capture01a1a1b6-624a-7938-b551-60cc7f643338€24.00€0.37matched
17capture01a1a1b6-60b9-770d-8448-42af4be0d540€15.00€0.26matched
18capture01a1a1b6-65cd-7e6e-a795-5ccaa8328d5c€24.00€0.37matched
19capture01a1a1b6-7433-7aaf-8c87-6187952ee950€35.00€0.50matched
20refund01a1a1b6-7f4a-77e9-8337-ac942272b84f-€8.00€0.00matched
21capture01a1a1b6-85f3-7e7b-b156-5af1e08ca9a9€24.00€0.37matched
22capture01a1a1b6-938a-76ee-b2fe-2d0d3e83fcdc€35.00€0.50matched
23capture01a1a1b6-9e2e-74ad-9d25-c1a2f22518ad€35.00€0.50matched
25capture01a1a1b6-a08e-7e75-bb69-bfcf72728b84€9.00€0.19matched
26capture01a1a1b6-a8bc-7514-94ef-83993e1ef2f1€49.00€0.67matched
27refund01a1a1b6-bd4d-75aa-95a1-fe7e2d8632cf-€13.00€0.00matched
28capture01a1a1b6-d23a-79ef-903e-7c1ec907ac9b€35.00€0.50matched
29capture01a1a1b6-dcca-749c-a919-6d8743095be9€24.00€0.37matched
30capture01a1a1b6-e52b-788a-8aa9-4b4496d071d4€49.00€0.67matched
31capture01a1a1b7-17d3-7870-90e6-628b56019cdf€24.00€0.37matched
32capture01a1a1b7-3a71-7ccb-a71c-a5a4707bc89f€35.00€0.50matched
33capture01a1a1b7-40e8-776f-9693-8a8cd19a5e11€35.00€0.50matched
34capture01a1a1b7-4654-7f3c-8da0-44a81971925c€49.00€0.67matched
35capture01a1a1b7-52e2-77e5-b5c6-9f542a8bc065€24.00€0.37matched
36capture01a1a1b7-5814-79a2-bb99-3927aad006d8€9.00€0.19matched
37capture01a1a1b7-64af-73cc-a962-ef5c3db4715d€35.00€0.50matched
38capture01a1a1b7-96b1-7768-b798-420beee99eaa€15.00€0.26matched
39capture01a1a1b7-a00d-7212-bff9-5765e9ee2a32€15.00€0.26matched
40capture01a1a1b7-daad-74b4-a01a-4fce00dbf79c€24.00€0.37matched
41capture01a1a1b7-f9b3-7061-b81e-e002f5f34228€24.00€0.37matched
42capture01a1a1b8-0ace-7dfb-997f-c4c0ca0b5c0b€35.00€0.50matched
43capture01a1a1b8-1d1c-755c-859a-0ced77513402€35.00€0.50matched
44capture01a1a1b8-317a-7810-9d7a-e86025fc4c28€15.00€0.26matched
45capture01a1a1b8-3c01-76b6-a349-cf33be8f2c44€9.00€0.19matched
46capture01a1a1b8-3e91-751f-8652-967fe34a725f€24.00€0.37matched
47capture01a1a1b8-5230-7956-acdf-16a5ae6d5596€49.00€0.67matched
48capture01a1a1b8-5834-7c83-b32e-f48a1129c34a€15.00€0.26matched
49refund01a1a1b8-5d1c-77ea-8b3f-b1f88cc9f626-€22.00€0.00matched
50refund01a1a1b8-6ed7-7904-8620-3344eb33f532-€7.00€0.00matched
51refund01a1a1b8-72bb-7fa6-be9b-0284b7c1db9c-€11.00€0.00matched
52capture01a1a1b8-a992-70bf-849c-7fbdf8948cbf€15.00€0.26matched
53capture01a1a1b8-bde2-7f14-86ad-1ab3b7fd38ba€9.00€0.19matched
54capture01a1a1b8-dd55-772f-98b1-f16598fadcb0€15.00€0.26matched
55capture01a1a1b8-f63a-7d03-9c8a-aaea668821ca€24.00€0.37matched
56capture01a1a1b9-1f95-712f-8e41-83a9686e3d39€35.00€0.50matched
57capture01a1a1b9-4c1b-72cb-87a6-f94eb521bb01€35.00€0.50matched
58capture01a1a1b9-593d-781b-b494-a704ebcc20c3€24.00€0.37matched
59capture01a1a1b9-6579-74b3-84ee-d454465eafbb€9.00€0.19matched
60capture01a1a1b9-6fd9-7190-bea6-8a547b9af4da€49.00€0.67matched
61capture01a1a1b9-a65c-7ea0-a3e2-18efc86bf5bd€15.00€0.26matched
62capture01a1a1b9-c628-7154-bd2d-645ed5f8e82b€15.00€0.26matched
63capture01a1a1b9-c90e-75f1-9963-96589b23fcaa€24.00€0.37matched
64capture01a1a1b9-e3f7-7f3d-9f48-d2d9408dbeac€49.00€0.67matched
65capture01a1a1b9-f844-7584-9a88-296cb30ce243€9.00€0.19matched
66capture01a1a1ba-0cf1-79b8-b004-8facf0ba6678€49.00€0.67matched
67capture01a1a1ba-3ee6-7ee0-8f5e-9a1e27d02500€35.00€0.50matched
68capture01a1a1ba-81b5-75a8-a683-80166486b0a6€24.00€0.37matched
69capture01a1a1ba-87c9-7a45-8241-059382e0f107€49.00€0.67matched
70capture01a1a1ba-94cf-7c42-a6b8-29136ff3e6b7€9.00€0.19matched
71capture01a1a1ba-ae76-774e-97d9-590759ed9075€24.00€0.37matched
72capture01a1a1ba-f6be-705b-ac29-9b2164dbcd98€49.00€0.67matched
73capture01a1a1ba-f86c-7f9b-99c4-f90ddb77c0f1€15.00€0.26matched
74capture01a1a1ba-fe81-718b-ac9b-fd9927160ea9€35.00€0.50matched
75capture01a1a1bb-72d8-7d67-9b14-99b2ad5fc3fb€49.00€0.67matched
76capture01a1a1bb-83cc-7f9c-9eb6-68b423e1ad14€15.00€0.26matched
77capture01a1a1bb-861d-7469-ae1b-9bd520431102€35.00€0.50matched
78capture01a1a1bb-96ba-7eae-9cf7-6110b1c115da€35.00€0.50matched
79capture01a1a1bb-97d5-7a1c-bb0d-6751f3d37fd1€9.00€0.19matched
80capture01a1a1bb-deb5-73c7-9877-d4e11430fac7€15.00€0.26matched
81capture01a1a1bc-0477-79d3-b048-2a4d56b10e3c€9.00€0.19matched
82capture01a1a1bc-3e2e-7aa6-9c4f-ae04624b6fa3€24.00€0.37matched
83capture01a1a1bc-3f70-7f21-866b-ce177e34b0ac€24.00€0.37matched
84capture01a1a1bc-4199-71f3-9989-457a0a702c56€24.00€0.37matched
85capture01a1a1bc-41f5-7d9f-99fb-0c4921c306fa€49.00€0.67matched
86capture01a1a1bc-4a46-7ca5-a61b-6be0b3671d5f€15.00€0.26matched
87refund01a1a1bc-58ff-7772-8f86-a6871c53490d-€4.00€0.00matched
88capture01a1a1bc-b8fc-77c2-b8fb-560173a411ad€49.00€0.67matched
89capture01a1a1bc-bb61-749c-b9fe-e4408d6c0c8a€15.00€0.26matched
90capture01a1a1bc-c95d-74af-81a4-aa3ca6e3f62a€49.00€0.67matched
91capture01a1a1bc-cbdf-7b93-a8a9-0c65bcfdd664€9.00€0.19matched
92capture01a1a1bc-de67-7daf-a3a7-f3e9a32f2e0c€35.00€0.50matched
93capture01a1a1bd-0c4f-791b-8e94-58506dc3be25€49.00€0.67matched
94capture01a1a1bd-0dff-78a0-aad5-a06d7fbe76b7€24.00€0.37matched
95capture01a1a1bd-24de-793a-9797-4ea7b2c5f3e1€24.00€0.37matched
96capture01a1a1bd-335c-7754-a5e7-db3a14bd5fc5€9.00€0.19matched
97capture01a1a1bd-447a-71ca-9d36-0501be0e9150€49.00€0.67matched
98capture01a1a1bd-4aa9-7f9f-97c9-f07c57c01fb6€24.00€0.37matched
99capture01a1a1bd-5471-7595-94bb-da16fb954043€35.00€0.50matched
100capture01a1a1bd-aa6c-77fe-852c-6d38966d544d€9.00€0.19matched
101capture01a1a1bd-af54-788b-add3-95734dba62a8€49.00€0.67matched
102capture01a1a1bd-b372-72c6-a69a-6cd73c582374€49.00€0.67matched
103capture01a1a1bd-c7c4-7931-87bf-2eb4015923ea€9.00€0.19matched
104capture01a1a1bd-e6f1-7b4d-9c7f-5319d38ee688€24.00€0.37matched
105capture01a1a1be-1ba4-7016-a9e7-3e0ae456e7f7€24.00€0.37matched
106capture01a1a1be-364e-7673-8716-be4403472a3c€15.00€0.26matched
107capture01a1a1be-380b-74fc-8b53-b52087750ea9€15.00€0.26matched
108capture01a1a1be-543c-7861-836e-ff333eaf394b€24.00€0.37matched
109capture01a1a1be-5466-7501-9e59-3f3930dc6a91€9.00€0.19matched
110capture01a1a1be-a57c-7082-931b-48fef895f6d4€24.00€0.37matched
111refund01a1a1be-ab64-7a94-b71c-bcfbb3611ad6-€18.00€0.00matched
112capture01a1a1be-cfd3-7b59-b47f-adc963119715€15.00€0.26matched