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

5 Nov, 03:20

Gross

€2,572.00

PSP fee

€41.01

Net to the bank

€2,530.99

Settlement journal

#390701

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a9b8-9e0f-76c4-81d9-59ff543f80c8 is already settled by stl_EUR_2989748 line 5
  • fee differencethe fee is not the contract feethe fee is 41, the contract says 37
LineKindReferenceGrossFeeStatus
6capture01a1a9b8-9e82-7ff6-ad57-c2b4d6d184f6€9.00€0.19duplicate line
99capture01a1a9c0-1e30-70e0-97f6-704737fa1256€24.00€0.41fee difference
1capture01a1a9b0-13e0-70f8-a116-53babda3c57e€49.00€0.67matched
2capture01a1a9b3-1de4-786d-86ce-04d5f866a961€9.00€0.19matched
3capture01a1a9b3-2933-7b44-b5ca-5f6bb62220eb€35.00€0.50matched
4capture01a1a9b8-2bc2-78d7-9a3f-20953ee9d5db€35.00€0.50matched
5capture01a1a9b8-9e82-7ff6-ad57-c2b4d6d184f6€9.00€0.19matched
7capture01a1a9b8-a2a3-70be-b595-5b88b185b592€49.00€0.67matched
8refund01a1a9b8-c9e8-7a9f-ae79-3c76ae216b90-€5.00€0.00matched
9capture01a1a9b8-e69a-7c40-80d7-4852e65d4593€24.00€0.37matched
10capture01a1a9b9-2dfd-7e11-a08b-52d11ccc2bd2€15.00€0.26matched
11capture01a1a9b9-51d6-7928-adc5-0fee45a4e43b€9.00€0.19matched
12capture01a1a9b9-6ba3-7203-93e5-97e6da0d0619€15.00€0.26matched
13capture01a1a9b9-75d6-7a10-b3a0-b164daae5aa9€49.00€0.67matched
14capture01a1a9b9-8ffd-7fd9-89d1-3766b9016ecd€49.00€0.67matched
15capture01a1a9b9-99ab-7432-aa6f-152f14d5b8cc€49.00€0.67matched
16capture01a1a9b9-c523-7d0f-b49c-f5ab6065d556€35.00€0.50matched
17capture01a1a9b9-cf9e-7623-afc0-cfaa1b7bcd2f€49.00€0.67matched
18capture01a1a9b9-d651-7df7-ac7c-f4396584126f€49.00€0.67matched
19capture01a1a9b9-e115-7e81-8119-2276ec4b2ded€24.00€0.37matched
20capture01a1a9b9-f3d4-71cc-a15c-790ac96a5a0d€9.00€0.19matched
21capture01a1a9b9-f86f-7a97-8b4e-c6e07adaa00d€35.00€0.50matched
22capture01a1a9ba-1593-7eae-8bd4-b747f29f13cf€15.00€0.26matched
23capture01a1a9ba-3788-7c0f-a471-d0567a96663e€24.00€0.37matched
24capture01a1a9ba-385a-7070-a455-450ffd241a1f€15.00€0.26matched
25capture01a1a9ba-6044-7a25-94d1-05301ad78699€24.00€0.37matched
26capture01a1a9ba-7990-7935-a782-84b5a17889c2€49.00€0.67matched
27capture01a1a9ba-7dab-7a5a-9100-18e70a135042€49.00€0.67matched
28capture01a1a9ba-9fdb-75f5-9338-9c9b064a890d€24.00€0.37matched
29capture01a1a9ba-a05c-76e2-b904-77153fe796e9€24.00€0.37matched
30capture01a1a9ba-a3e0-71cc-b135-3dbdb0363a81€35.00€0.50matched
31capture01a1a9ba-a9f3-7084-a8b3-15fdb82fde9a€49.00€0.67matched
32capture01a1a9ba-de21-7ce8-b0db-fe55d1f1cd04€24.00€0.37matched
33capture01a1a9ba-f750-782e-8524-d96a1a105de1€35.00€0.50matched
34capture01a1a9bb-185b-742f-b129-5d5f5ebcc10d€49.00€0.67matched
35capture01a1a9bb-2bee-7a9c-8960-3a6566ae8676€9.00€0.19matched
36capture01a1a9bb-496e-71d6-bd86-b07f9afde862€15.00€0.26matched
37capture01a1a9bb-5297-7140-90f8-9c8f23810c86€35.00€0.50matched
38capture01a1a9bb-8344-7316-a74d-e24f72fb47f2€9.00€0.19matched
39capture01a1a9bb-bf88-78db-92b4-11c270f0c0c0€49.00€0.67matched
40capture01a1a9bb-ce80-7412-8b59-6d323e8d8ca7€24.00€0.37matched
41capture01a1a9bb-e052-7843-804e-a2621c1935d6€9.00€0.19matched
42capture01a1a9bb-e627-7755-8b35-4fbc04d932aa€24.00€0.37matched
43capture01a1a9bb-eea6-7e0c-86ed-7ad311543e24€15.00€0.26matched
44capture01a1a9bb-f012-73ca-8d95-ac051613f0f9€49.00€0.67matched
45capture01a1a9bb-fbe1-7e15-a29f-a700ae7f7d4f€35.00€0.50matched
46capture01a1a9bc-0b0c-73cf-b6d2-97f8d68527b2€35.00€0.50matched
47capture01a1a9bc-13b5-7608-8662-ec20c2c82e47€9.00€0.19matched
48capture01a1a9bc-173c-75bf-a9a4-9f0669bc27df€15.00€0.26matched
49capture01a1a9bc-449c-79cc-8c12-9ed33389c0f8€24.00€0.37matched
50capture01a1a9bc-6298-76b1-aa1a-e4a84a901aa7€24.00€0.37matched
51capture01a1a9bc-6d71-7ba5-90e4-7c158c0ff0cb€9.00€0.19matched
52capture01a1a9bc-71a6-774e-806f-ee89bd647d99€49.00€0.67matched
53capture01a1a9bc-76e6-779f-b012-b22455c27286€35.00€0.50matched
54capture01a1a9bc-82be-73f0-9eb6-614011e4903d€15.00€0.26matched
55capture01a1a9bc-955f-7730-953a-96b50c83901c€35.00€0.50matched
56refund01a1a9bc-ac52-7895-b913-439a32709b9f-€8.00€0.00matched
57capture01a1a9bc-b610-7c77-8184-ff9ed9fd249b€49.00€0.67matched
58capture01a1a9bc-c251-78ec-8a09-26482b595a84€24.00€0.37matched
59capture01a1a9bd-0352-782f-b50e-3085ad25d262€35.00€0.50matched
60capture01a1a9bd-0f7d-77b2-a872-5de976cf4e1d€24.00€0.37matched
61refund01a1a9bd-104c-7a74-a5aa-c2ab33a22ba8-€48.00€0.00matched
62capture01a1a9bd-2f20-74b5-a0b2-fca4cc4a172f€15.00€0.26matched
63capture01a1a9bd-3618-7532-adf5-35d7dfc637ac€9.00€0.19matched
64capture01a1a9bd-4beb-7428-944d-61039255dda8€15.00€0.26matched
65refund01a1a9bd-78e2-729a-94b7-9dae78318fe7-€14.00€0.00matched
66capture01a1a9bd-7973-71d9-a4fe-4fa34bf5b6cc€15.00€0.26matched
67capture01a1a9bd-869f-748b-b9cc-1fe11bf06e98€15.00€0.26matched
68capture01a1a9bd-9d86-7ecc-a59a-b424b81a8131€9.00€0.19matched
69capture01a1a9bd-ae48-7326-aacc-500119a81017€15.00€0.26matched
70capture01a1a9bd-b47a-7315-8b32-47b28b957438€24.00€0.37matched
71capture01a1a9bd-ce17-76da-858d-3f10948b021a€9.00€0.19matched
72capture01a1a9bd-ce52-79dd-8900-4189827dbda1€15.00€0.26matched
73capture01a1a9bd-d87c-7c66-b816-3a682101d817€24.00€0.37matched
74capture01a1a9bd-e2ed-73e1-9d5c-25b6f4faa0f9€15.00€0.26matched
75refund01a1a9bd-e937-7fd5-ab8f-ac1415de97fe-€21.00€0.00matched
76capture01a1a9bd-efe1-7629-bdc9-c808c23df2fc€35.00€0.50matched
77capture01a1a9bd-f0cd-7ee1-a04c-9d85e9eb2eab€15.00€0.26matched
78capture01a1a9bd-f871-74cc-b226-2e4744a7a7a2€9.00€0.19matched
79capture01a1a9be-0612-7bb0-96bf-e862a74f3ee5€9.00€0.19matched
80refund01a1a9be-1494-70f6-b776-908a9e59c660-€3.00€0.00matched
81capture01a1a9be-2092-7996-b0eb-547a7288c5b8€24.00€0.37matched
82capture01a1a9be-388b-7660-a301-911c3fdb1b8f€49.00€0.67matched
83capture01a1a9be-4484-7d48-9c81-47434b292503€24.00€0.37matched
84capture01a1a9be-7d24-7394-98f9-43c3fbd291d7€15.00€0.26matched
85capture01a1a9be-be54-75b1-bae2-acff92880cd6€49.00€0.67matched
86capture01a1a9be-d030-72ac-a1fc-bdcd6f612fb7€49.00€0.67matched
87capture01a1a9be-fbab-716a-b6a5-2d869a874019€15.00€0.26matched
88refund01a1a9be-fe9b-7168-bcd8-5df0f28bceda-€10.00€0.00matched
89capture01a1a9bf-2386-7608-a1e4-54840673293a€15.00€0.26matched
90capture01a1a9bf-6cc1-73a9-92d6-28d79b30777f€9.00€0.19matched
91capture01a1a9bf-84bd-7dd2-b28c-66a16e755df7€49.00€0.67matched
92capture01a1a9bf-9b9b-7e72-aa3d-959e58d37c19€15.00€0.26matched
93capture01a1a9bf-b3ca-7642-9550-eeb4c2b67fb3€24.00€0.37matched
94capture01a1a9bf-d22c-7a9c-8fae-3ed558ab975a€49.00€0.67matched
95capture01a1a9bf-ee55-7488-97da-cd1ac1f9d7cf€49.00€0.67matched
96refund01a1a9c0-03cc-7b73-9319-ee58c32d648b-€5.00€0.00matched
97capture01a1a9c0-0b6a-7d3a-9ed5-e93f50f960e5€35.00€0.50matched
98capture01a1a9c0-217e-78cb-aa0f-7dcf58bc002c€49.00€0.67matched
100capture01a1a9c0-419b-7a21-8acd-dfb07ddac47b€24.00€0.37matched
101capture01a1a9c0-8526-7f8c-8ba9-2d92569e58a7€24.00€0.37matched
102capture01a1a9c0-bd37-79cc-bf1f-1da5a6fb7df7€9.00€0.19matched
103capture01a1a9c0-be61-715c-b69d-9a6aa61d11e9€24.00€0.37matched
104capture01a1a9c0-d03a-745e-b3f8-b942abc72b7f€9.00€0.19matched
105capture01a1a9c0-e30e-70a1-a530-c050e62af253€15.00€0.26matched
106capture01a1a9c0-efa8-751e-ac13-42be3b0a77cf€35.00€0.50matched
107capture01a1a9c0-f2a5-7a67-b801-87410c2db5e1€35.00€0.50matched
108capture01a1a9c1-01ca-7fd7-9991-3e7e314f9b1f€35.00€0.50matched
109capture01a1a9c1-1b89-7e10-a080-5e7255130db8€15.00€0.26matched
110capture01a1a9c1-1d81-7a78-acf6-3e8ba7c08c82€9.00€0.19matched
111refund01a1a9c1-3d7c-7018-b344-c90430a971b4-€31.00€0.00matched
112capture01a1a9c1-3e5c-788e-8820-54900790585c€15.00€0.26matched