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

Gross

€3,115.00

PSP fee

€48.09

Net to the bank

€3,066.91

Settlement journal

#393078

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aa6f-2e86-73c0-a906-28b2149362e6 is already settled by stl_EUR_2989767 line 121
LineKindReferenceGrossFeeStatus
122capture01a1aa6f-2eaa-7de3-a7c0-826efe8b17cb€35.00€0.50duplicate line
1capture01a1aa62-8043-74bc-9ff3-ae591804251a€15.00€0.26matched
2capture01a1aa62-e042-7f5b-b98a-53defd59202e€9.00€0.19matched
3refund01a1aa66-7520-74bd-b37e-142664bd60d8-€5.00€0.00matched
4capture01a1aa66-bec7-79a3-9924-6666babd8865€9.00€0.19matched
5capture01a1aa66-d28c-79bf-8438-e6f4f7c58a59€35.00€0.50matched
6capture01a1aa66-f36e-707c-b4f3-390b7a361f2b€35.00€0.50matched
7capture01a1aa66-fbcc-713a-ba36-443c4740747c€35.00€0.50matched
8capture01a1aa67-07fb-72e5-ade2-1629c78cbb21€9.00€0.19matched
9capture01a1aa67-0f73-7cfa-824c-a4c5c241884f€35.00€0.50matched
10capture01a1aa67-12b9-7651-8ba8-ff589834d40f€35.00€0.50matched
11capture01a1aa67-2c19-7336-b098-d37722ded002€24.00€0.37matched
12capture01a1aa67-3349-785b-9d1b-0ce71f0b595c€35.00€0.50matched
13capture01a1aa67-4980-73ef-a5ac-e87615b70fbf€24.00€0.37matched
14capture01a1aa67-4fb7-7e76-9049-b99a8f61201a€49.00€0.67matched
15capture01a1aa67-5451-763a-8b24-830742933c44€24.00€0.37matched
16capture01a1aa67-78cd-7a01-aba0-5b41b104ea1c€24.00€0.37matched
17capture01a1aa68-018d-77af-8162-4d68a7da0aa7€35.00€0.50matched
18capture01a1aa68-0c40-7dda-9181-40bd9fced165€15.00€0.26matched
19capture01a1aa68-5c36-7251-986c-fefe36d903d9€49.00€0.67matched
20capture01a1aa68-6333-7f01-a839-dc1b069e0251€24.00€0.37matched
21capture01a1aa68-6b4f-7bb7-a4f4-0603139c742a€15.00€0.26matched
22capture01a1aa68-6c2a-724e-9ca1-83b4649d5064€35.00€0.50matched
23capture01a1aa68-6e14-7e54-9360-345f64762e38€49.00€0.67matched
24capture01a1aa68-7ab4-7955-bd24-443f624e4f2b€15.00€0.26matched
25capture01a1aa68-8f57-77ae-90b8-9c01c9c2cd38€24.00€0.37matched
26capture01a1aa68-9269-7bda-9da7-0e2594c820f0€49.00€0.67matched
27capture01a1aa68-966c-782d-b568-bf1a394fd5ba€49.00€0.67matched
28capture01a1aa68-9983-729c-b449-e41028af078c€49.00€0.67matched
29capture01a1aa68-a2d9-76dc-b8b4-2e192a25c217€15.00€0.26matched
30capture01a1aa68-b711-7f0a-8a2c-07d01cef57b7€15.00€0.26matched
31refund01a1aa68-c290-7758-af51-a82c6e89181a-€36.00€0.00matched
32capture01a1aa68-c5a8-726b-9032-68e2ade12750€9.00€0.19matched
33refund01a1aa68-f9dd-7a70-8ccf-9f60ea22f081-€12.00€0.00matched
34capture01a1aa69-03aa-721a-8587-ae3bafb560c0€24.00€0.37matched
35capture01a1aa69-19f4-7380-ad7c-180715c2af66€49.00€0.67matched
36capture01a1aa69-1f47-77a9-a685-1b76b0fe8c30€35.00€0.50matched
37capture01a1aa69-30cd-7138-b915-db30e6f5fd50€49.00€0.67matched
38capture01a1aa69-3b10-7ecd-a265-5433ccba2348€35.00€0.50matched
39capture01a1aa69-81c0-73a0-b856-eb5392fbd5ef€49.00€0.67matched
40capture01a1aa69-8f5c-726e-be75-e46d3cd51755€9.00€0.19matched
41capture01a1aa69-a00e-761c-a570-2fbeb9fc1ac8€9.00€0.19matched
42capture01a1aa69-a0e8-7d46-aa18-10437d2e48eb€49.00€0.67matched
43capture01a1aa69-aa42-7e04-a6e9-74427aef1132€24.00€0.37matched
44capture01a1aa69-b4ca-7564-b8e7-2755730356b7€49.00€0.67matched
45capture01a1aa69-bd6b-76d5-b672-b4944b097f10€9.00€0.19matched
46capture01a1aa69-d905-76fd-ac9a-9d7e0930fb32€9.00€0.19matched
47capture01a1aa69-d952-7bb5-a8c3-2007fb2c2ade€9.00€0.19matched
48capture01a1aa69-db19-7531-b1e0-c46eed78cb97€24.00€0.37matched
49capture01a1aa69-f8be-75e7-bb42-8dc596943655€15.00€0.26matched
50refund01a1aa69-fb67-78bc-bd70-9ff78ff43c10-€6.00€0.00matched
51capture01a1aa6a-3a7a-77e0-8e70-0b38ecf54e67€9.00€0.19matched
52capture01a1aa6a-5cab-78fe-bbe1-4fbc04692271€35.00€0.50matched
53capture01a1aa6a-6897-746f-a592-00397356ef3f€49.00€0.67matched
54capture01a1aa6a-6f15-7fb1-bf51-25da2599c848€9.00€0.19matched
55capture01a1aa6a-7916-7ead-9109-b40fb1c79bb2€35.00€0.50matched
56capture01a1aa6a-7931-7112-9e03-b4136ff7dc71€49.00€0.67matched
57capture01a1aa6a-94dd-7e9f-9205-f4105e999383€9.00€0.19matched
58capture01a1aa6a-afa4-7282-bef2-eb32ad7b3095€49.00€0.67matched
59capture01a1aa6a-b28b-7a54-b11c-86f1ee3ecaf9€15.00€0.26matched
60capture01a1aa6a-cc6e-7870-b1bd-5070d5e31519€15.00€0.26matched
61capture01a1aa6a-deef-7331-8235-52bfff8b301c€15.00€0.26matched
62capture01a1aa6a-e13b-7ce0-8d6c-e809daa0f3ed€49.00€0.67matched
63capture01a1aa6a-e993-72e9-81a9-c70085507603€9.00€0.19matched
64capture01a1aa6b-0dc4-7fb0-a1e5-9e292697bb92€49.00€0.67matched
65capture01a1aa6b-3cf8-76e7-a5d9-fd0017485721€15.00€0.26matched
66capture01a1aa6b-471f-7922-ad84-e1bffc4b2bce€24.00€0.37matched
67capture01a1aa6b-4bde-7639-8e9a-42bc8717efaf€49.00€0.67matched
68capture01a1aa6b-65e4-7513-8cb3-e87525606645€9.00€0.19matched
69capture01a1aa6b-6692-7929-a607-9996db28c71c€24.00€0.37matched
70capture01a1aa6b-6b71-75e6-be68-8c4200157b20€35.00€0.50matched
71refund01a1aa6b-9634-7ecf-a3d3-adf34e37cf57-€17.00€0.00matched
72capture01a1aa6b-c531-7326-aad3-86931fc02cc0€9.00€0.19matched
73capture01a1aa6c-154c-776a-a6f7-06f79b0e0eed€49.00€0.67matched
74capture01a1aa6c-47c8-7182-8649-e5afce717f44€35.00€0.50matched
75capture01a1aa6c-6dc5-7a34-8758-20886cf23822€9.00€0.19matched
76capture01a1aa6c-7322-745f-90bd-da39490fb9a5€35.00€0.50matched
77capture01a1aa6c-83fa-7675-9a65-8a9959f56169€9.00€0.19matched
78capture01a1aa6c-86f7-74fc-956f-a1dda71843c2€24.00€0.37matched
79capture01a1aa6c-95f7-7d66-b63e-de3ddcf895b4€9.00€0.19matched
80capture01a1aa6c-9cfe-753d-a29a-a96ebc8cecb9€24.00€0.37matched
81capture01a1aa6c-af39-7278-917c-60b33ade151c€49.00€0.67matched
82capture01a1aa6c-b740-757d-aec2-28f4974a8c2b€24.00€0.37matched
83capture01a1aa6c-cd04-7fe9-aaec-be8e5ba000cc€24.00€0.37matched
84capture01a1aa6c-f327-794c-b234-ac63d0147d97€35.00€0.50matched
85capture01a1aa6c-f696-752c-a6b6-930efa4d115c€24.00€0.37matched
86capture01a1aa6d-2745-78dc-945f-22aab3c14061€49.00€0.67matched
87capture01a1aa6d-2a49-71f8-908e-b8e7c77c5374€9.00€0.19matched
88capture01a1aa6d-558c-7bd8-9620-81737bf29ee1€35.00€0.50matched
89capture01a1aa6d-64b8-72fd-b393-0fe147e0fda8€49.00€0.67matched
90capture01a1aa6d-70d4-7139-b19c-e0bba380ec9d€35.00€0.50matched
91capture01a1aa6d-7958-744b-954a-db55b9dc1cba€49.00€0.67matched
92capture01a1aa6d-8805-7bf2-947d-8cf33a3dba90€9.00€0.19matched
93capture01a1aa6d-8dde-7612-bbe4-372af992fe4d€9.00€0.19matched
94capture01a1aa6d-94bf-7d59-83c3-e81c7d3a932a€9.00€0.19matched
95capture01a1aa6d-9a02-70ae-88f5-b0236cb348fe€24.00€0.37matched
96capture01a1aa6d-9ce4-73f3-b5a0-b4e509dbbc41€15.00€0.26matched
97capture01a1aa6d-b35a-7258-8883-b4b08bc3f5fd€24.00€0.37matched
98capture01a1aa6d-c81e-728a-8ff2-ed1ef57f3093€24.00€0.37matched
99capture01a1aa6d-c8ed-758e-8c82-f7c9d6c1f377€9.00€0.19matched
100capture01a1aa6d-df5e-7355-bd30-f4702c2f7253€24.00€0.37matched
101capture01a1aa6d-e70b-7361-a735-8a76fddc597d€15.00€0.26matched
102capture01a1aa6d-ff6c-7d83-b1e4-87e4d1767d51€24.00€0.37matched
103capture01a1aa6e-05ba-72aa-a265-160b11b98b67€9.00€0.19matched
104refund01a1aa6e-2e68-7782-9936-0bcdd11cd7f5-€8.00€0.00matched
105capture01a1aa6e-3886-761c-935a-2c68a1ee2501€15.00€0.26matched
106capture01a1aa6e-3928-792c-9846-217b61095806€35.00€0.50matched
107capture01a1aa6e-41f5-76c4-bd11-a823360c9a76€15.00€0.26matched
108capture01a1aa6e-492a-7260-b699-61c30db8ec0a€24.00€0.37matched
109capture01a1aa6e-5690-7fdf-8c5c-bdebceaa98c5€49.00€0.67matched
110capture01a1aa6e-61fd-7049-8f2c-94f0ce0e815a€49.00€0.67matched
111capture01a1aa6e-8319-7700-b9c1-ec1e6470c4ff€15.00€0.26matched
112capture01a1aa6e-8b6b-7fed-b9e7-0dc4eae6812f€24.00€0.37matched
113capture01a1aa6e-9443-7db4-a621-b6b1493da115€49.00€0.67matched
114refund01a1aa6e-ae89-7833-a7f2-9bf98c23ce96-€9.00€0.00matched
115capture01a1aa6e-b8d1-7645-8f82-01be3be01d69€9.00€0.19matched
116capture01a1aa6e-dcfe-7cd7-af09-1c3480b7ce1e€24.00€0.37matched
117capture01a1aa6e-f940-700e-a22f-e34749853c67€15.00€0.26matched
118capture01a1aa6f-1863-77cf-b12f-db0bd5817f4a€49.00€0.67matched
119capture01a1aa6f-219b-79fd-9dc7-b8165bb0cdc4€49.00€0.67matched
120capture01a1aa6f-2753-7f5a-8b3e-3ea7778646c9€35.00€0.50matched
121capture01a1aa6f-2eaa-7de3-a7c0-826efe8b17cb€35.00€0.50matched
123capture01a1aa6f-4b0c-7798-9319-acad3ed1b1d4€35.00€0.50matched
124capture01a1aa6f-5c07-7105-af34-e324e1ed7e73€15.00€0.26matched
125capture01a1aa6f-7713-7122-9bed-f0938ba08990€9.00€0.19matched