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, 13:30

Gross

€2,453.00

PSP fee

€39.83

Net to the bank

€2,413.17

Settlement journal

#361872

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a1a2-757f-73fd-8b1c-94f39d8033e2 is already settled by stl_EUR_2989521 line 99
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • missing linein the books, not in the filecapture:01a1a19b-7107-7cac-a0f8-f9c077450385 is in no file
LineKindReferenceGrossFeeStatus
7capture01a1a19b-056f-70a1-a6eb-adddd535f6b7€35.00€0.52fee difference
100capture01a1a1a2-76c1-7050-9eda-7c5b3a3efcca€35.00€0.50duplicate line
1capture01a1a198-564c-7341-bf84-f238be549272€35.00€0.50matched
2capture01a1a19a-5891-74f6-8856-8a9ba03a56bc€24.00€0.37matched
3capture01a1a19a-9f13-76d9-8a3c-aee53f9e24ee€9.00€0.19matched
4capture01a1a19a-a66d-7e52-845c-4daaeec6b8e1€35.00€0.50matched
5refund01a1a19a-e1fa-7264-b3bd-cd9a918df799-€6.00€0.00matched
6capture01a1a19a-fdf3-7250-b59f-e88520315922€49.00€0.67matched
8capture01a1a19b-0e25-7217-9b11-7f6fe4a75489€24.00€0.37matched
9capture01a1a19b-0ff4-79f5-a3dd-c567299360fd€9.00€0.19matched
10capture01a1a19b-19e8-78b8-83f6-5af9afdec034€24.00€0.37matched
11capture01a1a19b-2b52-73a5-b689-f23c7e780b35€15.00€0.26matched
12capture01a1a19b-333e-7338-9e89-54a0c7259bdb€49.00€0.67matched
13capture01a1a19b-378b-764b-8012-1a166d8b1247€15.00€0.26matched
14capture01a1a19b-4b73-7f9a-b54a-be5a3dae9afb€24.00€0.37matched
15refund01a1a19b-6b90-75ea-ac04-72a05ab50902-€5.00€0.00matched
16capture01a1a19b-72f3-760e-acc8-37915308c6d4€49.00€0.67matched
17capture01a1a19b-84c8-7d44-aff4-46ac62723645€35.00€0.50matched
18capture01a1a19b-a17f-7195-8c76-f59d7df9bbdd€15.00€0.26matched
19capture01a1a19b-a31c-78d5-9bd1-16f1510e574a€15.00€0.26matched
20capture01a1a19b-e494-7fd3-92f9-8e92d085170c€15.00€0.26matched
21refund01a1a19b-e641-7c2a-936e-559569929de0-€38.00€0.00matched
22capture01a1a19b-eb18-780b-8dd2-d31ac447fd7c€35.00€0.50matched
23capture01a1a19c-0537-70b7-a008-56d80cd53c49€35.00€0.50matched
24capture01a1a19c-21f9-7ef5-b76c-c5b385bb832f€35.00€0.50matched
25capture01a1a19c-24eb-7b1f-9945-f57c4f3c0417€15.00€0.26matched
26capture01a1a19c-6ab3-7685-a136-620015addd0c€9.00€0.19matched
27capture01a1a19c-6b4e-76c1-9070-fd135df9bbfb€9.00€0.19matched
28capture01a1a19c-8a97-73bb-8da9-2a076f216ba0€9.00€0.19matched
29capture01a1a19c-8b39-7de4-8b5a-d6ed480fafe5€49.00€0.67matched
30refund01a1a19c-8cdd-77d9-a21a-459251a7d961-€12.00€0.00matched
31capture01a1a19c-a132-735c-9e8e-824207f68059€49.00€0.67matched
32capture01a1a19c-a3d1-7c8d-99ca-fcb9dfa34e6b€15.00€0.26matched
33capture01a1a19c-b5b9-7e28-b7e3-17344ac6c037€35.00€0.50matched
34capture01a1a19c-b6b4-742c-8269-821fa71bacbd€35.00€0.50matched
35capture01a1a19c-c8de-7f56-a124-822d5891fb05€15.00€0.26matched
36capture01a1a19c-cf6a-7881-b9a6-c9227ed49f91€9.00€0.19matched
37capture01a1a19c-d74e-7189-b314-cedad501d1ff€15.00€0.26matched
38capture01a1a19c-daeb-7cd8-8319-42b92e20a368€9.00€0.19matched
39capture01a1a19c-ec6f-7f2c-a531-0caad781f280€49.00€0.67matched
40capture01a1a19c-f0e6-7977-bae2-f76b33604682€9.00€0.19matched
41capture01a1a19d-025f-7614-97eb-9571d00fc584€24.00€0.37matched
42capture01a1a19d-062e-7569-a3fe-c82747d510a1€9.00€0.19matched
43capture01a1a19d-0afc-7668-8a92-bd43446b2cad€24.00€0.37matched
44capture01a1a19d-3fea-7f74-b41f-2067d5d3d44f€49.00€0.67matched
45capture01a1a19d-549c-774e-9aa2-8fbf13c80a04€9.00€0.19matched
46capture01a1a19d-5c58-7541-8942-a898b7f7ae55€24.00€0.37matched
47capture01a1a19d-6579-7efa-a63e-99c27d149069€9.00€0.19matched
48capture01a1a19d-75bc-79fd-a941-5a9b4556685c€49.00€0.67matched
49capture01a1a19d-87e4-7112-9bd4-6d823841d3b6€9.00€0.19matched
50capture01a1a19d-98b2-7752-aa1a-d160fbe4e181€49.00€0.67matched
51refund01a1a19d-b54f-764b-8887-acb1021e2f94-€6.00€0.00matched
52capture01a1a19d-cda3-7bdf-b229-8d1105eb1695€9.00€0.19matched
53capture01a1a19d-d9ba-7f68-8f65-c872cbd04530€35.00€0.50matched
54capture01a1a19d-eec0-72ca-9167-a8b3c3e7b2fb€24.00€0.37matched
55refund01a1a19e-0b05-7526-878e-4e13f2b552a6-€7.00€0.00matched
56capture01a1a19e-0e89-739b-afd4-2b745d72dfbd€49.00€0.67matched
57capture01a1a19e-4c33-7900-a82d-906e2c0daf90€15.00€0.26matched
58refund01a1a19e-584f-7cef-849a-a7c96a5ccd23-€38.00€0.00matched
59capture01a1a19e-8dac-709c-b94e-5047611ad545€49.00€0.67matched
60refund01a1a19e-a862-70b7-905e-53ebf94ca3c0-€13.00€0.00matched
61capture01a1a19e-a87d-7d5a-be7d-ce3cb20a3876€15.00€0.26matched
62capture01a1a19e-acc7-7115-b19a-b86e886fc5cd€35.00€0.50matched
63capture01a1a19e-f43d-7f4e-bb47-281ad4492d66€24.00€0.37matched
64capture01a1a19f-02c6-773a-bc20-4e412dc1ae26€9.00€0.19matched
65refund01a1a19f-3d76-7494-bbad-aad25b220a11-€5.00€0.00matched
66capture01a1a19f-4c4b-792e-88e6-e241c37f32ae€15.00€0.26matched
67capture01a1a19f-5a19-7085-8a8d-750a9ce44a8f€24.00€0.37matched
68capture01a1a19f-770e-71ee-b036-b4d9aad47ef2€35.00€0.50matched
69capture01a1a19f-7a36-7f44-8bed-8e3746a3f36e€35.00€0.50matched
70refund01a1a19f-a83f-772d-8f7b-1f2205441836-€5.00€0.00matched
71capture01a1a19f-bd45-7339-91dc-d0987cd6d072€35.00€0.50matched
72capture01a1a1a0-03e6-7798-adfa-48e379b16df0€15.00€0.26matched
73capture01a1a1a0-1b64-746b-9235-da9d68a252b7€35.00€0.50matched
74capture01a1a1a0-6059-77df-9298-9cb27fc83ec8€49.00€0.67matched
75capture01a1a1a0-6187-7509-a0fd-4a1e1da848f3€49.00€0.67matched
76capture01a1a1a0-7191-765b-a69b-c00baea799e7€35.00€0.50matched
77capture01a1a1a0-8df6-733c-bc87-f36ff82ed192€9.00€0.19matched
78capture01a1a1a0-b8bb-799b-934b-28df8641e195€9.00€0.19matched
79capture01a1a1a0-bb37-7c91-b5ad-77634e50c253€49.00€0.67matched
80capture01a1a1a0-cc11-7192-8181-ff132f5f345d€9.00€0.19matched
81capture01a1a1a0-f8fe-7b68-88d7-6f4e32c17881€49.00€0.67matched
82refund01a1a1a1-16ba-7497-980b-d4f479904efe-€7.00€0.00matched
83capture01a1a1a1-17c8-7d8f-8f98-c6d121bb642d€9.00€0.19matched
84refund01a1a1a1-308a-70e0-817e-6abb0718df34-€18.00€0.00matched
85capture01a1a1a1-3526-7026-9744-7ae9ea083905€24.00€0.37matched
86capture01a1a1a1-6401-79ef-8293-880f878a3457€35.00€0.50matched
87capture01a1a1a1-776e-73a4-afa6-cebb5ab6488b€9.00€0.19matched
88capture01a1a1a1-972a-7ee6-b16a-bfc5ed494949€35.00€0.50matched
89capture01a1a1a1-9dc7-711e-ab52-9157d4ca32c8€35.00€0.50matched
90refund01a1a1a1-9f5b-7178-92b5-f30f26fc9218-€5.00€0.00matched
91capture01a1a1a1-c00b-79d7-988f-380f1d10e490€15.00€0.26matched
92capture01a1a1a1-e5c1-72fe-92f4-e30a5a03a9ae€15.00€0.26matched
93capture01a1a1a1-ee91-7cf6-b06f-dab819f021c4€49.00€0.67matched
94capture01a1a1a1-f544-7b49-b90f-92564f014d2e€49.00€0.67matched
95capture01a1a1a2-18fd-7123-ab49-6d56da435094€15.00€0.26matched
96refund01a1a1a2-1d3d-720c-95d9-9891878384f2-€15.00€0.00matched
97capture01a1a1a2-4401-708f-91d4-25816154342d€35.00€0.50matched
98capture01a1a1a2-5313-7134-90d8-c2afeac7db1a€15.00€0.26matched
99capture01a1a1a2-76c1-7050-9eda-7c5b3a3efcca€35.00€0.50matched
101capture01a1a1a2-7932-7731-a5c0-5a9133e511fe€24.00€0.37matched
102capture01a1a1a2-8356-7d6e-95f2-4f76749774f3€49.00€0.67matched
103capture01a1a1a2-8f5e-7365-8680-27bfd6cfac0d€24.00€0.37matched
104capture01a1a1a2-96b6-7861-a20e-9a0d8efb4c7e€49.00€0.67matched
105capture01a1a1a2-a453-7ee3-b272-f72f36241a0b€15.00€0.26matched
106refund01a1a1a2-a795-725a-8b87-040b0f4cbd25-€22.00€0.00matched
107capture01a1a1a2-b817-77e0-92ec-cf98c4cc9425€35.00€0.50matched
108capture01a1a1a2-b8fd-725a-9750-b12af2339c8c€49.00€0.67matched
109capture01a1a1a3-01c1-7d82-9223-696f75d9c96d€49.00€0.67matched
110capture01a1a1a3-0df8-7fd3-8edf-ae83fcecdf05€35.00€0.50matched
111capture01a1a1a3-1cc4-7911-a9ef-fcd42bc65e17€15.00€0.26matched
112capture01a1a1a3-413e-7224-a48d-fa686d1e9361€9.00€0.19matched
113capture01a1a1a3-4ce9-7b99-a3f3-5adfb961cb36€9.00€0.19matched