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:40

Gross

€2,684.00

PSP fee

€43.54

Net to the bank

€2,640.46

Settlement journal

#362719

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a1e0-8978-7704-b9cf-fd2218146920 is already settled by stl_EUR_2989528 line 87
  • fee differencethe fee is not the contract feethe fee is 38, the contract says 37
LineKindReferenceGrossFeeStatus
88capture01a1a1e0-8a74-764b-8b70-4b2f1380b298€9.00€0.19duplicate line
92capture01a1a1e0-b8a7-7351-9ca2-a77d4f5b19fd€24.00€0.38fee difference
1capture01a1a1d6-2b9f-7e05-83c5-d51187bb9260€9.00€0.19matched
2capture01a1a1da-5104-73f7-b9ad-08dcdcb37c73€49.00€0.67matched
3capture01a1a1da-680f-7e7e-83cf-2d1121021876€49.00€0.67matched
4capture01a1a1da-a200-7ddf-823e-9c2d1329a115€35.00€0.50matched
5capture01a1a1da-b802-785d-aaed-f92c8a0d2736€24.00€0.37matched
6capture01a1a1da-d9a5-75d9-8a91-e7135d42403c€49.00€0.67matched
7capture01a1a1db-0c7a-700b-8a2b-8ce3df8be501€24.00€0.37matched
8capture01a1a1db-2113-7fe8-993b-698664250747€24.00€0.37matched
9capture01a1a1db-4805-7bff-a915-dc977fbb3448€24.00€0.37matched
10capture01a1a1db-4c1d-7e73-b65d-61f93311314c€9.00€0.19matched
11refund01a1a1db-81fa-7b88-9b9a-f815d8e6cf6f-€18.00€0.00matched
12refund01a1a1db-85bd-775b-94c7-ebd7404e5169-€6.00€0.00matched
13capture01a1a1db-a5dc-794f-9f40-0c0ec6b6d409€24.00€0.37matched
14capture01a1a1db-bb33-7db6-8f15-866e75321962€35.00€0.50matched
15capture01a1a1db-c201-724f-9b67-ec80300fb222€15.00€0.26matched
16capture01a1a1db-e059-78b4-bff4-286087f31751€35.00€0.50matched
17capture01a1a1db-e4cb-720d-bffa-c6f6b6b827d3€49.00€0.67matched
18refund01a1a1db-eec0-7769-a9da-19e5666f9379-€33.00€0.00matched
19capture01a1a1db-f8c0-79c1-a2ce-0e04a302bb5b€15.00€0.26matched
20capture01a1a1db-f94c-7370-9d0b-ef80c9715570€35.00€0.50matched
21capture01a1a1dc-0f20-79f2-a61f-7069cd0b63f1€24.00€0.37matched
22capture01a1a1dc-3a45-7522-8ae3-1012607bcc83€15.00€0.26matched
23capture01a1a1dc-3d7e-719e-b37e-0565e268502f€24.00€0.37matched
24capture01a1a1dc-420b-75b5-a720-5448df9d035a€49.00€0.67matched
25capture01a1a1dc-495b-7980-b491-8cdd72da953d€9.00€0.19matched
26capture01a1a1dc-729b-7843-8f49-4cc6ef61e3df€24.00€0.37matched
27capture01a1a1dc-87e0-7cf0-830b-c8e592d7a0a2€24.00€0.37matched
28capture01a1a1dc-8cc5-7588-8f70-4357767d13b7€35.00€0.50matched
29capture01a1a1dc-8f4b-7dfe-8615-0423c684771d€24.00€0.37matched
30capture01a1a1dc-827a-744c-8c42-09adf9e6a1d2€49.00€0.67matched
31capture01a1a1dc-ad1a-739f-9364-1d7c47bd504d€15.00€0.26matched
32capture01a1a1dc-c116-75b9-b431-419600dad2b0€15.00€0.26matched
33capture01a1a1dc-cb8b-7966-b7e5-341b85bf291c€15.00€0.26matched
34capture01a1a1dc-f36b-7968-8fc8-04e3552377fa€49.00€0.67matched
35capture01a1a1dd-1652-70ce-a593-f5c5a587b934€35.00€0.50matched
36capture01a1a1dd-3214-7000-bf78-20128c1026b7€35.00€0.50matched
37capture01a1a1dd-339c-7e2d-9b30-781b095d9840€35.00€0.50matched
38refund01a1a1dd-3674-700a-bf8a-683c52c12fde-€7.00€0.00matched
39capture01a1a1dd-4eec-7d69-ac05-b44f76002fb2€24.00€0.37matched
40capture01a1a1dd-62d5-7e23-a55f-04c80df9f991€24.00€0.37matched
41capture01a1a1dd-746f-76a6-abb5-4d5eb676051e€9.00€0.19matched
42capture01a1a1dd-7dbe-7e80-81dd-2409d9f984d4€24.00€0.37matched
43capture01a1a1dd-924a-7696-a4a0-5ae9e40faa68€24.00€0.37matched
44capture01a1a1dd-dd8e-7c67-a9be-19796340c907€15.00€0.26matched
45capture01a1a1de-1298-7069-aca7-7a26602086a6€35.00€0.50matched
46capture01a1a1de-2b83-7506-aba0-8e6c6765a2ef€15.00€0.26matched
47capture01a1a1de-2c89-75e1-90a2-d7b7b92f0a6e€9.00€0.19matched
48capture01a1a1de-3fb3-701d-b016-1d8ab6f751cc€35.00€0.50matched
49capture01a1a1de-4551-7695-b928-8ac5f5bfc447€15.00€0.26matched
50capture01a1a1de-551e-73b4-a77c-847a13c701ce€24.00€0.37matched
51capture01a1a1de-729b-7d85-9fa4-fec7c97bea50€35.00€0.50matched
52capture01a1a1de-7b0b-744a-abf6-d6e9cf8dc557€49.00€0.67matched
53capture01a1a1de-8ef1-7c97-ab2d-eaa74a63e14f€35.00€0.50matched
54capture01a1a1de-9014-7037-b244-cf0d9dc7d8fa€9.00€0.19matched
55capture01a1a1de-a8f4-7e45-b377-6614940cb4cd€9.00€0.19matched
56capture01a1a1de-adb8-7df1-99ca-2781e0283eda€9.00€0.19matched
57capture01a1a1de-bb02-71cb-9552-a8c6aec594f7€15.00€0.26matched
58refund01a1a1de-bf99-7269-8692-41fb72ffacc7-€36.00€0.00matched
59capture01a1a1de-c039-7ee4-b8f8-8984256d4649€24.00€0.37matched
60capture01a1a1de-ca20-79f4-91c8-c33b7b2bf0ba€9.00€0.19matched
61capture01a1a1de-ddbd-78cf-add7-feca8da26eb9€35.00€0.50matched
62capture01a1a1de-f81a-71a5-a05e-92cd19bd4e1b€9.00€0.19matched
63refund01a1a1df-0323-7456-bd5e-87494fe763ca-€24.00€0.00matched
64capture01a1a1df-0b55-7054-bb35-1191ae7c50a4€15.00€0.26matched
65capture01a1a1df-0fcb-7249-a51f-79a6e08ef052€35.00€0.50matched
66capture01a1a1df-15fd-7186-a4fa-d0239f198035€49.00€0.67matched
67capture01a1a1df-3718-763e-9f8d-2e3ee011fd76€35.00€0.50matched
68capture01a1a1df-50b8-7423-9b11-2f75d48ca6c2€24.00€0.37matched
69capture01a1a1df-5b52-7d19-8291-8668a1071d74€15.00€0.26matched
70capture01a1a1df-5c05-7f6c-aec0-843e6492bf69€49.00€0.67matched
71capture01a1a1df-6006-778b-a8c8-ede4e408f16b€15.00€0.26matched
72capture01a1a1df-744d-7dec-8ca8-d10246b6c4f5€9.00€0.19matched
73capture01a1a1df-9088-77eb-87d8-281aecb4dfb5€9.00€0.19matched
74capture01a1a1df-9142-7dc7-a866-433c3995b6e0€9.00€0.19matched
75capture01a1a1df-9ad9-782f-b907-6254fcbb5228€15.00€0.26matched
76capture01a1a1df-b8b3-77cb-9c07-fcd50d482972€49.00€0.67matched
77capture01a1a1df-be6a-7aac-9b3e-54a8ad17f01a€35.00€0.50matched
78capture01a1a1df-bf3b-7577-89a9-ff479ac53d3a€24.00€0.37matched
79capture01a1a1df-d61c-7655-af0d-5ddf4afb731e€15.00€0.26matched
80capture01a1a1df-ea4c-746d-a29e-d8a00bf933ee€15.00€0.26matched
81capture01a1a1df-ec1c-7be8-8d5c-04a87da65058€49.00€0.67matched
82capture01a1a1df-ec73-7dd4-aff2-8277bd8be3f2€49.00€0.67matched
83capture01a1a1e0-0952-7c61-be4f-3824ad5d2d9b€9.00€0.19matched
84capture01a1a1e0-0982-795e-ac5c-f8cde22f0c9f€24.00€0.37matched
85capture01a1a1e0-0e50-7372-91ea-ed2ba1ff7499€15.00€0.26matched
86capture01a1a1e0-7831-7d65-9284-d0022e568f09€35.00€0.50matched
87capture01a1a1e0-8a74-764b-8b70-4b2f1380b298€9.00€0.19matched
89capture01a1a1e0-9a75-7369-9820-623f7c77ce6d€24.00€0.37matched
90capture01a1a1e0-ac12-73da-b9ca-77569df5fb7f€9.00€0.19matched
91capture01a1a1e0-ae5a-7e00-93e0-9fc91307a5e4€49.00€0.67matched
93capture01a1a1e0-db4c-795c-829f-9807ff3682c8€9.00€0.19matched
94capture01a1a1e0-f4a2-7f6f-b61f-eb0b92cddd5e€35.00€0.50matched
95capture01a1a1e1-1091-788c-9e97-fce263967fb2€24.00€0.37matched
96capture01a1a1e1-313f-7895-8d81-a350fab41deb€35.00€0.50matched
97capture01a1a1e1-6890-7ed0-a780-bd52cb86e98d€9.00€0.19matched
98capture01a1a1e1-6ca8-77e8-b3a4-c3a6c47429df€35.00€0.50matched
99capture01a1a1e1-bfdd-7df1-82b9-199468b9e117€49.00€0.67matched
100capture01a1a1e1-c91b-7b0d-a7d9-da71f30a5e47€9.00€0.19matched
101capture01a1a1e1-d41c-706c-b79e-148761b23b8c€24.00€0.37matched
102capture01a1a1e1-d8a9-7540-96f9-98bae3da6f13€24.00€0.37matched
103refund01a1a1e1-f9d9-702d-83f4-3f4b6b131b36-€33.00€0.00matched
104capture01a1a1e2-0da1-74a6-a23d-17c458a3568c€49.00€0.67matched
105capture01a1a1e2-314d-7dc7-8db5-8e86534a643f€15.00€0.26matched
106capture01a1a1e2-3d9e-729f-9361-a3b9a5d3ff17€15.00€0.26matched
107capture01a1a1e2-4602-737d-8d81-f2a98f302cb5€9.00€0.19matched
108capture01a1a1e2-4eab-7935-94cd-d3585e14512c€15.00€0.26matched
109capture01a1a1e2-4efb-7521-8d63-efae5b0e0899€49.00€0.67matched
110capture01a1a1e2-71eb-7580-a157-20fec8bb83ac€35.00€0.50matched
111capture01a1a1e2-91a1-7efb-895c-b7ae71a90823€9.00€0.19matched
112capture01a1a1e2-9ac9-793c-b9d2-201f04746c6b€24.00€0.37matched
113capture01a1a1e2-a4d6-7f95-aec9-6c1810b57fbd€15.00€0.26matched
114capture01a1a1e2-b0d3-746d-9635-2b6a7e7f3f09€35.00€0.50matched
115capture01a1a1e2-e9c3-70e0-8299-c2a1fd2944e2€49.00€0.67matched
116capture01a1a1e2-f8e3-71a0-ae70-7735fea2d1fd€24.00€0.37matched
117capture01a1a1e3-06cd-7d29-8088-635273cc54a6€9.00€0.19matched
118capture01a1a1e3-07a2-703e-8955-98ad0baa769e€9.00€0.19matched
119capture01a1a1e3-183e-7ab5-a162-eb1846ad8d57€9.00€0.19matched
120capture01a1a1e3-19c4-715b-b573-658138fa63c0€9.00€0.19matched
121capture01a1a1e3-2744-77b9-b25e-6edd121ab754€9.00€0.19matched
122capture01a1a1e3-584d-7742-82bc-ddfb6c95123a€15.00€0.26matched
123refund01a1a1e3-650c-75af-902a-247a8a6a100b-€8.00€0.00matched