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

2 Nov, 23:10

Gross

€3,100.00

PSP fee

€49.57

Net to the bank

€3,050.43

Settlement journal

#351064

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19e8a-0a22-7277-a268-af999f59a337 is already settled by stl_EUR_2989435 line 50
  • fee differencethe fee is not the contract feethe fee is 28, the contract says 26
  • missing linein the books, not in the filerefund:01a19e8b-898b-77bc-a668-cedb773a35ac is in no file
LineKindReferenceGrossFeeStatus
51capture01a19e8a-0a38-7335-8bb2-90a5c7924d6d€49.00€0.67duplicate line
112capture01a19e8d-fcb1-7721-a14d-84ab8c79de4c€15.00€0.28fee difference
1capture01a19e80-de3d-7d31-bd9e-f5e0a2921609€24.00€0.37matched
2capture01a19e82-b114-7676-90e8-5fd0c78f8b56€15.00€0.26matched
3capture01a19e85-8cb6-73d3-864e-6c61bca63a61€15.00€0.26matched
4capture01a19e86-fb7f-79fd-b4d2-cd35fec9d5b2€49.00€0.67matched
5capture01a19e87-0bda-70b8-9486-d2ffbeea2fea€35.00€0.50matched
6capture01a19e87-0bff-7c02-b25c-a86996932607€9.00€0.19matched
7capture01a19e87-1cbf-78de-9a8b-16a4735a333a€9.00€0.19matched
8capture01a19e87-4434-7642-a564-c4df5d9a8aae€9.00€0.19matched
9capture01a19e87-711c-7857-9baf-8d4fac7849f3€49.00€0.67matched
10capture01a19e87-77f3-7b38-a7c9-45395c501112€9.00€0.19matched
11capture01a19e87-7af8-7fd3-a35c-07b4d15d27cf€9.00€0.19matched
12capture01a19e87-7efb-74b2-9559-3e4c9d8a367b€9.00€0.19matched
13capture01a19e87-80d6-76b3-b118-5db7d90eac2c€15.00€0.26matched
14capture01a19e87-8e20-7a75-83d3-2aef0adefe0a€49.00€0.67matched
15capture01a19e87-9016-7600-b4d4-400810403612€9.00€0.19matched
16capture01a19e87-9198-73aa-a541-f7b04deb908c€9.00€0.19matched
17capture01a19e87-9b06-7a50-89dd-f437dbc2a65b€49.00€0.67matched
18capture01a19e87-a71f-783c-a3dc-a64048d00d0b€9.00€0.19matched
19capture01a19e87-a8fc-780f-bb12-1d3f31b12b81€35.00€0.50matched
20capture01a19e87-f214-7a71-b236-d489d3e6f365€35.00€0.50matched
21capture01a19e88-0ac8-7996-9638-916dc8ebdc1c€49.00€0.67matched
22capture01a19e88-1742-7750-9d1f-34eef2991985€9.00€0.19matched
23capture01a19e88-2179-7d65-ab12-78644251d760€35.00€0.50matched
24capture01a19e88-4e82-7d61-8ac4-4431b35188fa€24.00€0.37matched
25capture01a19e88-7708-787f-ac74-90709c67d947€15.00€0.26matched
26capture01a19e88-7e6c-7690-8328-de96a38eb80a€24.00€0.37matched
27capture01a19e88-9e75-70ec-96e7-75aa18af7588€49.00€0.67matched
28capture01a19e88-a12c-758d-8c35-80f7deaf03b9€35.00€0.50matched
29capture01a19e88-ae4e-784c-81b6-122600cdd2be€24.00€0.37matched
30capture01a19e88-c3d8-771b-9d36-afc1fd9a701c€49.00€0.67matched
31capture01a19e88-ca5e-7ddb-917d-c5be7aff2fb8€9.00€0.19matched
32capture01a19e89-1851-7344-8185-4fff50f3dc9b€35.00€0.50matched
33capture01a19e89-4ba1-77a0-a067-8284828669d6€9.00€0.19matched
34capture01a19e89-50ed-74b2-8dda-f0dd582d3520€24.00€0.37matched
35capture01a19e89-52e1-726c-912b-98b7697a144d€9.00€0.19matched
36capture01a19e89-673d-74c7-a8fb-195eeabf70e2€35.00€0.50matched
37capture01a19e89-6f0f-7092-9bc2-de0a1496c4f5€15.00€0.26matched
38capture01a19e89-709d-73fe-93d2-73e36579c9f9€24.00€0.37matched
39refund01a19e89-7a6d-75eb-8383-fdead4994532-€6.00€0.00matched
40capture01a19e89-8c2b-770e-b53a-3e77c6b4260e€35.00€0.50matched
41capture01a19e89-90bb-75b3-ba3a-3465b1541498€35.00€0.50matched
42capture01a19e89-a5ed-72f8-9e0a-6c87d495d8a7€15.00€0.26matched
43capture01a19e89-a9fe-7062-8f6b-f661ebaed471€9.00€0.19matched
44capture01a19e89-bee3-70f8-b7e8-cb6febe93c63€24.00€0.37matched
45capture01a19e89-c114-72e3-bc5d-ee972496a34a€35.00€0.50matched
46capture01a19e89-d83c-7cd5-b41b-23e3136dccf5€9.00€0.19matched
47capture01a19e89-da7a-7f37-b55c-fbd826776e1d€49.00€0.67matched
48capture01a19e89-e036-7776-ac14-74088534d13e€15.00€0.26matched
49capture01a19e89-f5de-7b5a-a7cb-821dc80c982e€24.00€0.37matched
50capture01a19e8a-0a38-7335-8bb2-90a5c7924d6d€49.00€0.67matched
52capture01a19e8a-0c26-7e74-8a08-85ccaaa98c3a€9.00€0.19matched
53capture01a19e8a-5cf9-7f6c-bf64-7751aea25244€49.00€0.67matched
54capture01a19e8a-64e7-70f3-9f3d-f14635c9e274€15.00€0.26matched
55capture01a19e8a-728a-751f-920f-435fed5e61d2€24.00€0.37matched
56capture01a19e8a-75a0-7897-b787-573b3c5e4ab5€9.00€0.19matched
57capture01a19e8a-7602-705e-8a4f-e10646aec682€49.00€0.67matched
58capture01a19e8a-8c2c-7145-986c-3a3e820714f1€35.00€0.50matched
59capture01a19e8a-a2d2-7d48-a0ab-d244957c49b5€49.00€0.67matched
60capture01a19e8a-a5be-7849-8a14-c4b4656feb70€35.00€0.50matched
61capture01a19e8a-ba6a-79b4-8b66-4def32f07d80€9.00€0.19matched
62capture01a19e8a-e618-7d2d-9b9a-616546db07db€49.00€0.67matched
63capture01a19e8a-e9d1-7612-a35c-54b66da81d06€24.00€0.37matched
64capture01a19e8a-fa63-736f-a155-7fab5e966d73€15.00€0.26matched
65refund01a19e8b-0476-71d4-b614-f5f71f5c5757-€38.00€0.00matched
66capture01a19e8b-3c03-7f3a-a83f-d71a7e385ccd€15.00€0.26matched
67capture01a19e8b-41f7-7349-9654-076bdbd1c8e3€9.00€0.19matched
68capture01a19e8b-567a-7a99-a726-5622c1970d3e€15.00€0.26matched
69capture01a19e8b-5932-797a-975c-394ed0ead40c€49.00€0.67matched
70capture01a19e8b-5ce4-70cd-bf76-bbaaa194c80a€9.00€0.19matched
71capture01a19e8b-7ffb-74e4-80ee-1d7ef87892f6€9.00€0.19matched
72capture01a19e8b-8951-7ed5-adcc-bd4721b42e1d€35.00€0.50matched
73capture01a19e8b-9871-7417-85b2-ecde4f2eac24€24.00€0.37matched
74capture01a19e8b-aafa-7170-a1eb-1f57b989c65d€15.00€0.26matched
75capture01a19e8b-af9f-7fc3-aa65-3ef73950849d€49.00€0.67matched
76refund01a19e8b-c87a-7d5d-a202-8104dceb03df-€34.00€0.00matched
77capture01a19e8c-03bb-71a2-b626-08e38c5f61ac€49.00€0.67matched
78capture01a19e8c-1943-7b50-9877-0057b4619182€24.00€0.37matched
79capture01a19e8c-2952-7c6e-a123-268cdd09a4d7€35.00€0.50matched
80capture01a19e8c-4686-7cb4-abff-19e76ed7af05€35.00€0.50matched
81capture01a19e8c-5734-781d-bf4e-59e6a73503bd€15.00€0.26matched
82capture01a19e8c-72be-7c47-bfef-923495a05cd6€9.00€0.19matched
83capture01a19e8c-8006-74f0-a027-823a265f3411€9.00€0.19matched
84capture01a19e8c-8ba5-7a1d-9671-cff6c6c056ca€35.00€0.50matched
85capture01a19e8c-aad0-7a61-bc9a-792e01f28eb1€15.00€0.26matched
86capture01a19e8c-c611-754a-8f9f-04ff01c83ba4€9.00€0.19matched
87refund01a19e8c-cd88-78b6-8231-ce85c189f3ce-€18.00€0.00matched
88capture01a19e8c-e6fe-7abc-8918-6ac6354006cc€9.00€0.19matched
89capture01a19e8c-f21f-70c6-8511-b681aa9826d6€49.00€0.67matched
90capture01a19e8c-fcca-7680-8868-502f50d9f605€24.00€0.37matched
91capture01a19e8d-0832-79c0-9661-759da4fdfce6€24.00€0.37matched
92capture01a19e8d-1f63-7a54-a4df-057d9b207677€24.00€0.37matched
93capture01a19e8d-22df-7959-b76a-45fe7744a17f€15.00€0.26matched
94capture01a19e8d-2417-7ca6-bead-12e214b84ed6€9.00€0.19matched
95capture01a19e8d-2e8e-73e6-95ad-29dc15d1b9bc€9.00€0.19matched
96capture01a19e8d-2faf-7bea-a64d-a37fc2d08439€49.00€0.67matched
97capture01a19e8d-39c4-7f3f-b924-326a63fd38a4€15.00€0.26matched
98refund01a19e8d-535b-7cf5-a382-def780f64c8e-€11.00€0.00matched
99capture01a19e8d-5759-7eaa-ba2e-eb53b13db3b9€35.00€0.50matched
100refund01a19e8d-58d9-7197-9efd-838233a884dd-€3.00€0.00matched
101capture01a19e8d-666a-787d-9a92-df29c06606ae€49.00€0.67matched
102refund01a19e8d-6861-72ac-8225-37af41ed493f-€4.00€0.00matched
103capture01a19e8d-6c21-775b-a254-79fe5104fb0c€9.00€0.19matched
104capture01a19e8d-74d0-7a84-8c11-a8f4b38bbde3€15.00€0.26matched
105capture01a19e8d-8d30-7cf5-9c8a-f540e2663400€35.00€0.50matched
106capture01a19e8d-9f52-7b45-80bb-2190e71bda7c€49.00€0.67matched
107capture01a19e8d-a86a-7c36-b3c7-b9a31e057015€9.00€0.19matched
108capture01a19e8d-bdf0-7bbb-87dc-761f4606396d€49.00€0.67matched
109capture01a19e8d-be4d-7930-89ea-e5d2f9dd74e0€15.00€0.26matched
110capture01a19e8d-c23b-7111-acd8-40f2ada593b2€15.00€0.26matched
111refund01a19e8d-ffcd-7b9e-a419-61f976097b6f-€4.00€0.00matched
113capture01a19e8e-15bf-7f85-a162-55564292ec1c€35.00€0.50matched
114capture01a19e8e-3e07-78de-9736-533844ca8fc1€24.00€0.37matched
115capture01a19e8e-7d1e-7b91-bb58-454dc8fc856d€35.00€0.50matched
116capture01a19e8e-a522-73de-b1fd-b016a6ac0895€35.00€0.50matched
117capture01a19e8e-a76d-77a9-b128-ddbcb52b7c46€24.00€0.37matched
118capture01a19e8e-ae23-7c29-8498-fb6a6246add6€35.00€0.50matched
119capture01a19e8e-bf8f-7d48-9a26-110939362ce0€24.00€0.37matched
120capture01a19e8e-d0db-73cd-a496-8a66e23f79f0€35.00€0.50matched
121capture01a19e8e-dff5-7f66-939d-3be1e1a23674€24.00€0.37matched
122capture01a19e8e-e78d-76f2-bd88-5554d7649b2c€15.00€0.26matched
123capture01a19e8f-0fe6-7121-a272-2edacdead7cc€49.00€0.67matched
124capture01a19e8f-14f9-7261-8ec2-1e5de411d838€35.00€0.50matched
125capture01a19e8f-46ba-771c-8ed3-cc609766c665€9.00€0.19matched
126capture01a19e8f-72a6-7368-9152-89f8c564357d€24.00€0.37matched
127capture01a19e8f-801d-78a5-ab7a-4196d3d3d66b€49.00€0.67matched
128refund01a19e8f-896c-756f-b3a9-8aa6be1913e3-€12.00€0.00matched
129capture01a19e8f-8d24-7794-92e9-f9a8c9678155€15.00€0.26matched
130capture01a19e8f-98fd-76d9-939a-0c32083d5f20€49.00€0.67matched
131capture01a19e8f-a9ec-7506-bf2e-aa029c492614€49.00€0.67matched
132refund01a19e8f-bdf6-791f-a7d5-44c431d0b735-€36.00€0.00matched
133capture01a19e8f-c19b-7ba4-844f-d6e4480f246f€49.00€0.67matched
134capture01a19e8f-c1d3-7926-96d2-c5c10675e884€9.00€0.19matched
135refund01a19e8f-cf49-7277-8482-3577c89a47ce-€10.00€0.00matched
136capture01a19e8f-e1eb-7565-8b2e-1e0fb457719c€15.00€0.26matched
137capture01a19e8f-ea26-7e0e-af56-343c873cbe20€9.00€0.19matched