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, 22:40

Gross

€3,523.00

PSP fee

€54.37

Net to the bank

€3,468.63

Settlement journal

#368798

Every line paired with the books, and every capture and refund of the day is in the file.

LineKindReferenceGrossFeeStatus
1capture01a1a38c-bf11-7e9d-aea9-159ebb50acb2€49.00€0.67matched
2capture01a1a38e-fde7-7134-8e2e-0cff46d2990d€35.00€0.50matched
3capture01a1a38f-1bb6-7d68-a3e4-faba5f2cafbf€9.00€0.19matched
4capture01a1a391-eaad-7c2e-b556-d312790d3b90€49.00€0.67matched
5capture01a1a391-f199-78d3-992b-c352db95478a€49.00€0.67matched
6capture01a1a392-06c8-7d73-9598-03e2ce76429e€9.00€0.19matched
7capture01a1a392-0766-738c-935d-f4b3a32a3c6b€24.00€0.37matched
8capture01a1a392-31ca-7141-ab10-38fd90442327€24.00€0.37matched
9capture01a1a392-356d-7d47-9dd1-29bced3368c2€24.00€0.37matched
10capture01a1a392-3caf-7d93-b0aa-da30acb7581b€15.00€0.26matched
11refund01a1a392-6835-715b-ba1c-aac07d7831e5-€3.00€0.00matched
12capture01a1a392-68a1-739a-9fa4-54fe27a90caf€15.00€0.26matched
13capture01a1a392-7872-7c65-b188-32dcc38f1513€24.00€0.37matched
14capture01a1a392-9c18-7f9c-8455-cbf5b0d1b681€24.00€0.37matched
15capture01a1a392-b1cf-7013-8bee-21b5ce6489f1€15.00€0.26matched
16capture01a1a392-bf32-7389-9598-754ea9924970€15.00€0.26matched
17capture01a1a392-c9d1-75cb-9f76-e89c92671b25€24.00€0.37matched
18capture01a1a392-cbf4-75d4-a886-786ea37b0d86€24.00€0.37matched
19capture01a1a392-de66-7a73-a0c9-a4814ec12682€9.00€0.19matched
20capture01a1a392-e421-7f91-aac0-fa62823fb7c2€9.00€0.19matched
21capture01a1a392-efb5-77aa-8d1c-6e4a0e78eae3€15.00€0.26matched
22capture01a1a392-f1f7-7943-a939-3fb65e28eca3€49.00€0.67matched
23capture01a1a392-fa4c-764c-bfc1-5a5cc4b44ebe€15.00€0.26matched
24capture01a1a393-04a2-7d68-8555-b7f956df7863€15.00€0.26matched
25capture01a1a393-13b6-766f-a33b-b3fec394d61f€24.00€0.37matched
26capture01a1a393-1434-7928-b6b4-838b0ca1085d€15.00€0.26matched
27capture01a1a393-2214-71b8-ab42-98bfce0a870e€49.00€0.67matched
28capture01a1a393-266b-7bd5-bd1c-580f0323bc97€35.00€0.50matched
29capture01a1a393-2a9d-76be-bd18-9d23ac99b0ce€24.00€0.37matched
30capture01a1a393-3fab-7790-ac1d-08e280836489€15.00€0.26matched
31capture01a1a393-51da-7011-891a-eb3c0aae1b3c€49.00€0.67matched
32capture01a1a393-59c5-7059-879e-2e44c4067413€15.00€0.26matched
33capture01a1a393-5dd0-738d-bb32-82e237e306c3€49.00€0.67matched
34refund01a1a393-7345-78d2-9b3c-c6d2c4c156c4-€10.00€0.00matched
35capture01a1a393-8035-78ab-908c-b7a3a13b87f5€9.00€0.19matched
36capture01a1a393-85f4-7536-8fb8-7791aa97ff3a€35.00€0.50matched
37capture01a1a393-9bb6-77c7-b1dd-a98a2c6c8432€49.00€0.67matched
38capture01a1a393-c085-7d92-ad26-7d378f0f8e32€35.00€0.50matched
39capture01a1a393-c24c-7cd4-b4d8-747daa672591€15.00€0.26matched
40refund01a1a393-c301-7402-900a-1c4c9976243f-€3.00€0.00matched
41capture01a1a394-0293-7a44-84c8-d745760ceb79€15.00€0.26matched
42capture01a1a394-03fe-78ca-bc72-a72f8b414ec5€49.00€0.67matched
43capture01a1a394-0d7c-7852-b420-fc85ce94f8de€9.00€0.19matched
44capture01a1a394-1702-719c-a704-a953a3cae157€15.00€0.26matched
45capture01a1a394-24d8-72c1-8050-3369f00e33ed€24.00€0.37matched
46capture01a1a394-482d-753a-a220-45c1a06734ee€24.00€0.37matched
47capture01a1a394-4d8e-7645-ac1e-a5b846210b2f€24.00€0.37matched
48capture01a1a394-5fb6-747e-8db0-680ae1ba9466€35.00€0.50matched
49capture01a1a394-6958-7cf2-ba22-6cc37871cdb7€49.00€0.67matched
50capture01a1a394-8b24-7a48-8ea6-454a7353e6cb€24.00€0.37matched
51capture01a1a394-8bb4-74c5-a1e8-f371fd367a41€24.00€0.37matched
52capture01a1a394-8bcf-792f-a1f7-adeb07dc96c2€35.00€0.50matched
53capture01a1a394-8ee5-76eb-8b92-9fe1cd2ce691€35.00€0.50matched
54capture01a1a394-b655-7cd7-94f3-f2011521db50€49.00€0.67matched
55capture01a1a394-b6a9-71c7-91cd-f834a52b0a4c€24.00€0.37matched
56capture01a1a394-d061-7563-871e-a467143da505€24.00€0.37matched
57capture01a1a394-e413-708c-9716-bbf74f2ef7d7€49.00€0.67matched
58capture01a1a395-0874-7646-88cf-50bf7fd69a44€24.00€0.37matched
59capture01a1a395-108e-7c50-ab88-c39113a5ffff€15.00€0.26matched
60capture01a1a395-219d-73c9-9cce-71c04ba15b8e€15.00€0.26matched
61capture01a1a395-2b1b-7dd5-b93c-a331fbfe5a37€9.00€0.19matched
62capture01a1a395-2e8c-771d-8fb2-f10ef5918b9d€24.00€0.37matched
63capture01a1a395-2f45-73ad-b712-3c8073b76f8a€35.00€0.50matched
64capture01a1a395-336e-724e-9bb1-c8c36c0ec2b4€35.00€0.50matched
65refund01a1a395-3e5e-71c1-bd0f-31b2274f6e57-€10.00€0.00matched
66capture01a1a395-6661-780b-9542-3f3233082f84€24.00€0.37matched
67capture01a1a395-6dc0-727a-8f3b-0eccc45dcf2a€24.00€0.37matched
68refund01a1a395-81c0-7701-8efa-db9522f12475-€17.00€0.00matched
69capture01a1a395-a724-7f9a-82dd-b05fb9f58799€24.00€0.37matched
70capture01a1a395-a9a5-7799-8740-5381cba1a5c5€24.00€0.37matched
71capture01a1a395-d498-72c3-a35b-3d0c8b8a5f59€9.00€0.19matched
72capture01a1a395-d64d-7a01-acad-c47744a4f503€24.00€0.37matched
73capture01a1a395-e3d4-74b5-a486-7f4cbaed6c7f€49.00€0.67matched
74capture01a1a395-f2da-7032-b58f-1a14c36b004d€35.00€0.50matched
75capture01a1a395-f9fa-7e76-9c11-5fc45c6d61f8€49.00€0.67matched
76capture01a1a396-2df5-71fd-be0e-086375f87c58€15.00€0.26matched
77capture01a1a396-3db8-7291-a112-09c9b38e9588€9.00€0.19matched
78capture01a1a396-4023-70e7-b6d0-b35740d0d2dc€9.00€0.19matched
79capture01a1a396-5e7e-756e-a427-03a77c8cf2d6€35.00€0.50matched
80capture01a1a396-7d1f-70ec-82cc-64f32eff4592€49.00€0.67matched
81capture01a1a396-8599-7df8-b5a5-d3a0715bebd7€35.00€0.50matched
82capture01a1a396-ab9d-7c46-8a6c-1e75ef6b0523€15.00€0.26matched
83capture01a1a396-c2ba-7c69-8cba-846ddb5ce18f€49.00€0.67matched
84capture01a1a396-c6e8-7de3-813c-6b8086ccac09€35.00€0.50matched
85capture01a1a396-cdcf-7c08-b19b-64422f1e46ac€35.00€0.50matched
86capture01a1a396-cfb5-7904-b0fc-66b6037b730a€35.00€0.50matched
87refund01a1a396-db69-7758-9f71-dfd4ce21ce25-€26.00€0.00matched
88capture01a1a397-0c62-7b87-8178-17d0084a30ed€35.00€0.50matched
89capture01a1a397-265c-72d8-b23a-e280a47371c5€15.00€0.26matched
90capture01a1a397-4874-7f44-b71d-b118d043cef0€49.00€0.67matched
91capture01a1a397-4942-79da-bca2-a83b3af48ca8€24.00€0.37matched
92capture01a1a397-4de8-715e-b6a0-58edb9eb28fc€24.00€0.37matched
93capture01a1a397-5b9e-7a7e-8f87-d5441b309aee€9.00€0.19matched
94capture01a1a397-64ad-70f3-a77a-983666d38112€9.00€0.19matched
95capture01a1a397-8105-781d-8ea3-4cf3469fa385€15.00€0.26matched
96capture01a1a397-87e3-7b37-967a-eacc7a8b1fd1€49.00€0.67matched
97capture01a1a397-88e0-78a1-9af9-1bce21737ace€9.00€0.19matched
98capture01a1a397-a0e2-7efa-89a5-b87c26216527€9.00€0.19matched
99capture01a1a397-a2a8-7642-b769-70733c01fa6d€35.00€0.50matched
100refund01a1a397-ab92-7e96-ad09-204f535d9746-€45.00€0.00matched
101capture01a1a397-c4f0-75e5-b5fe-f737dd2f5d57€24.00€0.37matched
102capture01a1a397-c762-7e20-9442-24b6cbefe7fd€49.00€0.67matched
103capture01a1a397-ce38-7049-9dee-c9492e7af856€24.00€0.37matched
104capture01a1a397-ceee-735a-b6f0-a5327ec4e401€35.00€0.50matched
105capture01a1a398-01f9-7246-8f2a-deb741103b0a€24.00€0.37matched
106capture01a1a398-304d-7642-8a46-fe6eb0da5438€49.00€0.67matched
107capture01a1a398-475f-7989-9f92-44a8ae8ec2f4€49.00€0.67matched
108capture01a1a398-4cfe-7f32-b47a-72fac862a758€9.00€0.19matched
109capture01a1a398-9fe9-795f-a1bf-8566fff8a2f5€15.00€0.26matched
110capture01a1a398-addc-7f3d-aee8-bbc8a171518a€15.00€0.26matched
111capture01a1a398-cd9f-7d42-a8fd-28b65491d542€15.00€0.26matched
112capture01a1a398-e1dd-741a-8ecc-71a9e9116db8€49.00€0.67matched
113capture01a1a398-ed63-7605-a1bc-72927682b7ea€35.00€0.50matched
114capture01a1a398-f520-7a24-a8a3-d72f94e9b373€35.00€0.50matched
115capture01a1a399-0682-7a20-a825-93f41c99d1d2€35.00€0.50matched
116capture01a1a399-1209-79ea-9454-2d997c59d5d2€35.00€0.50matched
117refund01a1a399-34f6-7100-beda-e60b8359ed0e-€21.00€0.00matched
118capture01a1a399-3c7e-7276-b072-923dcac11e13€49.00€0.67matched
119capture01a1a399-4e95-714b-a6e3-c4a2b9667565€24.00€0.37matched
120capture01a1a399-6585-7fad-8c10-d7d914835b84€35.00€0.50matched
121capture01a1a399-c01f-753e-83de-a1ea9d57a8b0€35.00€0.50matched
122capture01a1a399-c9ab-7a74-8e56-ebc031a656a0€15.00€0.26matched
123capture01a1a399-ce7b-7b45-9358-0318171e5ed2€35.00€0.50matched
124capture01a1a399-f938-7d37-852e-8445154060db€9.00€0.19matched
125capture01a1a39a-0cb7-7d3a-801e-8005a44d96a3€9.00€0.19matched
126capture01a1a39a-1d19-71d7-9e54-cbffea669b85€24.00€0.37matched
127capture01a1a39a-2b34-7011-9d47-13c2f674b62b€24.00€0.37matched
128capture01a1a39a-3122-7444-8e0e-8caf0f8e083e€49.00€0.67matched
129capture01a1a39a-3858-737d-b2b6-81756b8af320€35.00€0.50matched
130capture01a1a39a-3fa6-7612-a418-c3de896aa02d€35.00€0.50matched
131capture01a1a39a-55a5-7a9d-8a74-9f41df8bc311€49.00€0.67matched
132capture01a1a39a-85b9-7542-8aaf-47acc5680d49€49.00€0.67matched
133capture01a1a39a-81c5-7e9d-99b9-016650878492€15.00€0.26matched
134capture01a1a39a-92d9-7a51-85b2-6a78fd63668e€49.00€0.67matched
135capture01a1a39a-9b66-706c-ad55-95cf7e38a225€35.00€0.50matched
136capture01a1a39a-9ec3-7386-8a25-1f5505435b06€49.00€0.67matched
137capture01a1a39a-d4b1-7eaf-a735-f477031859b0€49.00€0.67matched