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, 10:10

Gross

€3,031.00

PSP fee

€47.88

Net to the bank

€2,983.12

Settlement journal

#395829

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ab30-1de3-71c2-abd3-13bbfc078540 is already settled by stl_EUR_2989789 line 8
  • duplicate linethe file lists it twicecapture:01a1ab38-6583-7c70-9e42-fc3829386024 is already settled by stl_EUR_2989789 line 119
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
LineKindReferenceGrossFeeStatus
9capture01a1ab30-1e1b-70d2-bb13-ab38b645c354€15.00€0.26duplicate line
54capture01a1ab33-8d25-7934-8891-ca8b20b83dfe€9.00€0.20fee difference
89capture01a1ab35-374f-767d-aa87-84d6d0857c1d€49.00€0.68fee difference
120capture01a1ab38-659c-7896-acbc-8e1870776ee1€35.00€0.50duplicate line
1capture01a1ab2f-e781-7233-8d29-2442549ff0f7€24.00€0.37matched
2capture01a1ab2f-f180-783c-b571-4927fbb13c3b€35.00€0.50matched
3capture01a1ab30-0d6c-7547-a41a-47623a074862€49.00€0.67matched
4capture01a1ab30-0fc2-76d7-a049-c16ab02fb8e5€35.00€0.50matched
5capture01a1ab30-1022-7d39-b758-7eb5afd3a830€15.00€0.26matched
6capture01a1ab30-11d2-7dab-9ee2-a2d4c2e55deb€35.00€0.50matched
7capture01a1ab30-1bfa-7c2e-8982-ffbc82b02890€24.00€0.37matched
8capture01a1ab30-1e1b-70d2-bb13-ab38b645c354€15.00€0.26matched
10capture01a1ab30-287c-7e93-a163-d0f6fad1c3b2€35.00€0.50matched
11capture01a1ab30-2bbf-7547-b44d-80ae5e9e0d9d€9.00€0.19matched
12capture01a1ab30-3770-784c-b4e4-7c2b2de7e9e0€9.00€0.19matched
13capture01a1ab30-3e41-70d5-b457-6aac7b62f8f2€35.00€0.50matched
14capture01a1ab30-890e-7284-8440-0de6f8c7b58f€49.00€0.67matched
15capture01a1ab30-ab5d-78cf-b3bc-2895ab05a288€49.00€0.67matched
16refund01a1ab30-b3bf-7071-a649-cf0900c4c104-€27.00€0.00matched
17capture01a1ab30-bb58-72ba-8e52-69a64472c580€9.00€0.19matched
18capture01a1ab31-00b0-7126-a3ed-d94a4d7ea518€15.00€0.26matched
19capture01a1ab31-04d6-7544-af92-6429ce48e2d6€49.00€0.67matched
20capture01a1ab31-0536-725d-a55b-742b68c896dd€24.00€0.37matched
21refund01a1ab31-2576-70ba-933c-6e578d384766-€2.00€0.00matched
22capture01a1ab31-4c54-76aa-9d78-7ffd4227978c€49.00€0.67matched
23capture01a1ab31-53f9-79da-a522-f0523bddd2ed€24.00€0.37matched
24capture01a1ab31-55ca-7f74-9960-1ffb27e8ef20€15.00€0.26matched
25capture01a1ab31-5a32-70c7-9b8d-69b35198c340€49.00€0.67matched
26capture01a1ab31-687f-7c32-914a-e20fdbc29fb8€49.00€0.67matched
27capture01a1ab31-80c3-78b6-bb6a-86bd75d85103€35.00€0.50matched
28capture01a1ab31-9c40-7e11-9713-3ad93ecf340c€35.00€0.50matched
29capture01a1ab31-9c64-7f4d-ace0-47ae28f6ed09€24.00€0.37matched
30refund01a1ab31-b856-7fa4-b70b-f9d33e8b55a7-€16.00€0.00matched
31capture01a1ab31-db9e-7858-b1c6-7e01463de764€24.00€0.37matched
32capture01a1ab32-0267-7b51-9cb0-a27ea0771592€9.00€0.19matched
33capture01a1ab32-0f3d-7f11-8fd2-3d429110d78b€24.00€0.37matched
34capture01a1ab32-1412-701d-9444-32241c015721€9.00€0.19matched
35capture01a1ab32-1a13-782f-8de2-cfc7f760061f€24.00€0.37matched
36capture01a1ab32-3466-7129-bd24-90bce820fa9e€35.00€0.50matched
37capture01a1ab32-480f-768c-af80-ed1ad8daa248€35.00€0.50matched
38capture01a1ab32-803b-7dd3-8f4e-0fc3e8b49b1e€49.00€0.67matched
39capture01a1ab32-81bc-7744-ba6f-2c4e63ec306a€24.00€0.37matched
40refund01a1ab32-84fe-70d6-b14b-2884c6b7334b-€25.00€0.00matched
41capture01a1ab32-8aa7-7340-9ef6-5e610968ed02€9.00€0.19matched
42capture01a1ab32-927e-7051-9faa-6c6faa5ed027€49.00€0.67matched
43capture01a1ab32-a5de-7d11-8cea-cef6e43e215a€35.00€0.50matched
44capture01a1ab32-b29c-75e9-91aa-ee47e3ac1673€24.00€0.37matched
45capture01a1ab32-b6a4-711d-ba65-35c4624ef4c2€24.00€0.37matched
46capture01a1ab32-d84e-7e89-9840-79b7bd4e7216€15.00€0.26matched
47capture01a1ab32-f2fd-7471-9e2b-7fdc8e7c80b1€49.00€0.67matched
48capture01a1ab32-fb67-7fbf-976e-f3da4d8afa1b€15.00€0.26matched
49capture01a1ab33-3808-7024-b574-648d2cf3065f€15.00€0.26matched
50capture01a1ab33-5042-71a3-b7fd-ab0830002157€15.00€0.26matched
51capture01a1ab33-5fc8-774b-9a3a-e44006192f6c€9.00€0.19matched
52capture01a1ab33-648c-7854-b17d-a21b1582b234€15.00€0.26matched
53capture01a1ab33-66f3-78e1-90ac-0b2d7199db67€35.00€0.50matched
55capture01a1ab33-92b1-7b7d-9467-6aa1d585aed9€15.00€0.26matched
56capture01a1ab33-8d8d-774a-a120-1f9ebce22b8f€24.00€0.37matched
57capture01a1ab33-a58f-788a-9635-a4eaaa826f8a€15.00€0.26matched
58capture01a1ab33-ab3e-736d-81c2-560a91c2adae€49.00€0.67matched
59capture01a1ab33-bff4-7159-b671-a9a24a4682bd€24.00€0.37matched
60capture01a1ab33-db93-716e-bb7e-bb4e3aef0f59€9.00€0.19matched
61capture01a1ab33-ebfb-717a-a258-60efec0eaa5a€24.00€0.37matched
62capture01a1ab33-f10f-7349-a561-d47659b08ebc€24.00€0.37matched
63capture01a1ab34-066f-75e0-bd78-8a516d8ce562€35.00€0.50matched
64capture01a1ab34-111f-7cb5-9998-43c3e841aab9€24.00€0.37matched
65refund01a1ab34-1f1c-732d-9888-8757249ddf60-€10.00€0.00matched
66capture01a1ab34-2fd3-7dc9-a90b-5d9a126f3414€15.00€0.26matched
67capture01a1ab34-39df-7381-98e7-771a54dd3039€24.00€0.37matched
68capture01a1ab34-3e2a-779c-b897-ac13aea3e8cd€15.00€0.26matched
69capture01a1ab34-4109-7d21-b261-2e6148532ea7€9.00€0.19matched
70capture01a1ab34-47f5-7cf8-8fff-51e4da246c8f€9.00€0.19matched
71capture01a1ab34-519a-7860-bef3-184cf1d8eecb€24.00€0.37matched
72capture01a1ab34-6f0c-7bad-a9eb-f7e1d8984222€15.00€0.26matched
73capture01a1ab34-92f2-750c-bc65-3d5663541ebf€35.00€0.50matched
74capture01a1ab34-9fb6-78db-868d-3b0445d4e574€9.00€0.19matched
75capture01a1ab34-a6b1-746a-9813-8ac287bfe251€24.00€0.37matched
76capture01a1ab34-a8af-7b6f-b573-a3df928a5790€49.00€0.67matched
77capture01a1ab34-afb0-7a91-9f90-6e1e7ae3acbf€49.00€0.67matched
78capture01a1ab34-bc85-7f8d-8900-1064a8e82e1b€24.00€0.37matched
79capture01a1ab34-c8e0-7085-b5a2-9ad5cb4053a6€35.00€0.50matched
80capture01a1ab34-f7f5-7ce7-8b8c-b207b39601fa€9.00€0.19matched
81capture01a1ab34-fa47-708c-b136-adcbc7196b46€24.00€0.37matched
82capture01a1ab34-fbb0-7e98-adaa-e51cea855dc5€35.00€0.50matched
83capture01a1ab35-042d-7007-ab65-d45e7ae0c488€49.00€0.67matched
84capture01a1ab35-1547-7ec2-94b1-ada6da861656€49.00€0.67matched
85capture01a1ab35-1801-78e0-9e01-e0b8119f20df€35.00€0.50matched
86capture01a1ab35-2144-7df1-8953-cf9b572cb47b€9.00€0.19matched
87refund01a1ab35-317e-706f-b914-09f959333034-€8.00€0.00matched
88capture01a1ab35-3350-7022-b8bc-6b42081d025d€15.00€0.26matched
90capture01a1ab35-7020-70e9-89e4-f2c089df1922€9.00€0.19matched
91capture01a1ab35-851c-7863-9bce-d7b3ae727a1f€24.00€0.37matched
92refund01a1ab35-9342-7351-b858-7ae1955bb3d7-€43.00€0.00matched
93capture01a1ab35-b4f4-73aa-a485-079036bf3378€9.00€0.19matched
94capture01a1ab35-b8f5-764b-a935-bc9007f34d99€24.00€0.37matched
95capture01a1ab35-cb9c-7db7-80a0-5765e26d50c3€9.00€0.19matched
96capture01a1ab35-d0af-7f6c-aeb1-af3a61f702bc€9.00€0.19matched
97refund01a1ab35-e0e6-7f49-b924-41fc933645c0-€5.00€0.00matched
98capture01a1ab35-e342-7a76-b832-595f5ab8453b€49.00€0.67matched
99capture01a1ab36-01e8-7182-b6a6-e8b47609ae4a€35.00€0.50matched
100capture01a1ab36-8605-779d-b2cd-fbc6d25c15ba€15.00€0.26matched
101capture01a1ab36-902c-7787-9791-cdf10cd2de13€49.00€0.67matched
102capture01a1ab36-b9af-70e1-a8b4-79eef71141c7€15.00€0.26matched
103capture01a1ab36-c1c7-76ec-be38-9b95d5d3e6ec€9.00€0.19matched
104capture01a1ab36-db23-7067-b44e-d41cb777ccae€9.00€0.19matched
105capture01a1ab36-dcbb-760d-a6a0-de2df3d01164€9.00€0.19matched
106capture01a1ab37-174a-7672-983d-6cbfefc7859a€49.00€0.67matched
107capture01a1ab37-41ef-7c6a-9ef3-3b317493ddd8€15.00€0.26matched
108capture01a1ab37-4bc5-7ef8-be09-d353b42afbd8€49.00€0.67matched
109capture01a1ab37-57e1-7cf7-b8f7-7a5db4b2c6cf€9.00€0.19matched
110capture01a1ab37-884c-7136-bb61-e1498c62b10e€15.00€0.26matched
111capture01a1ab37-983f-7143-a459-01144b02ea10€15.00€0.26matched
112capture01a1ab37-a519-7f0b-8a39-06f08348fa7d€15.00€0.26matched
113capture01a1ab37-e1a8-7c1e-a9f5-f89f91777607€49.00€0.67matched
114capture01a1ab37-fcab-7781-a1c0-e2808fa5d865€35.00€0.50matched
115capture01a1ab38-2d2c-7e2a-ad0c-a54cd480c418€24.00€0.37matched
116capture01a1ab38-3ba9-7206-bea3-ac46db3bd894€15.00€0.26matched
117capture01a1ab38-41c6-7032-86e9-5a2490b33a5e€24.00€0.37matched
118refund01a1ab38-481c-7fef-8ea7-161d20cef03d-€9.00€0.00matched
119capture01a1ab38-659c-7896-acbc-8e1870776ee1€35.00€0.50matched
121capture01a1ab38-6abe-72a5-842b-c1eb95e68f30€15.00€0.26matched
122capture01a1ab38-7a75-7f80-9981-9d2ac4845275€49.00€0.67matched
123capture01a1ab38-7aa6-7582-85ac-7a95ec25498e€24.00€0.37matched
124capture01a1ab38-929a-766a-a888-a4a3c90a08d7€49.00€0.67matched
125capture01a1ab38-9a65-785f-b144-48d1ba7828eb€49.00€0.67matched
126capture01a1ab38-ae8f-7ee7-a254-e0f9ed07b224€24.00€0.37matched
127capture01a1ab38-b409-7828-ad74-d05aad5abe95€35.00€0.50matched
128capture01a1ab38-cb51-7e59-bc0c-f965780dbf71€24.00€0.37matched
129capture01a1ab38-ec09-7015-90e7-ce42d28d1a26€35.00€0.50matched