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

6 Nov, 03:40

Gross

€3,524.00

PSP fee

€55.69

Net to the bank

€3,468.31

Settlement journal

#409237

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

LineKindReferenceGrossFeeStatus
1capture01a1aee9-7b11-777d-818b-5247df193a26€35.00€0.50matched
2capture01a1aeef-ea72-7185-a9b6-42a921fa81cd€24.00€0.37matched
3capture01a1aef1-4dca-74ef-b984-a995e2b6a973€9.00€0.19matched
4capture01a1aef1-5c27-7ab2-bafe-d3a1d8ac2e10€24.00€0.37matched
5capture01a1aef1-80ac-7646-9494-c29e7d8c44d4€9.00€0.19matched
6capture01a1aef1-8d66-72a9-99b7-3c96306769f5€49.00€0.67matched
7capture01a1aef1-98aa-7a84-8956-01b3fb8d4abc€49.00€0.67matched
8capture01a1aef1-9c70-7d9e-8abb-e1fc67cae5f4€24.00€0.37matched
9capture01a1aef1-9f81-751b-a245-caedad505171€9.00€0.19matched
10capture01a1aef1-c0df-7e8b-96d3-3a5b3d9c9cbd€15.00€0.26matched
11refund01a1aef1-d8d2-733d-8af2-55f9244fcbae-€7.00€0.00matched
12capture01a1aef1-e40c-7232-9ed6-6962dd52d2da€9.00€0.19matched
13capture01a1aef1-fb5a-7241-bcb0-9e388e882096€24.00€0.37matched
14capture01a1aef1-ff1e-788e-ab11-4e67a42c4b5f€24.00€0.37matched
15capture01a1aef2-0c88-7931-9ed2-2b1377761529€49.00€0.67matched
16capture01a1aef2-263c-7fb3-91dc-e0cdf4a35f01€9.00€0.19matched
17capture01a1aef2-2c57-71b6-82b8-9a3cea9b5826€35.00€0.50matched
18capture01a1aef2-3189-792d-9ba6-1a951476224d€15.00€0.26matched
19capture01a1aef2-38ee-7e99-b0ec-7ccba6f68846€49.00€0.67matched
20capture01a1aef2-39b3-71e8-93a9-daa73bdb7e4d€49.00€0.67matched
21capture01a1aef2-5103-78a3-9d0d-43a938dfdc29€35.00€0.50matched
22capture01a1aef2-53b5-700e-97a6-1d9d051b6d4b€24.00€0.37matched
23capture01a1aef2-6210-71ef-9dd0-9bab556d2a8e€35.00€0.50matched
24capture01a1aef2-89d9-7a2c-bf7b-e4dd64c88a17€24.00€0.37matched
25capture01a1aef2-ccc9-7082-aa8e-27b523ac6ce8€15.00€0.26matched
26capture01a1aef2-ebd3-7abd-a9db-4656f948ea37€9.00€0.19matched
27capture01a1aef2-edfa-75cb-ba2d-4e9714dd6ad4€24.00€0.37matched
28capture01a1aef3-0553-7b99-b950-22e6388cb9fb€35.00€0.50matched
29capture01a1aef3-0c44-7db0-b693-6cb31b7b498f€24.00€0.37matched
30capture01a1aef3-1a07-71e6-b70c-39b978a431a3€9.00€0.19matched
31capture01a1aef3-4588-7bd6-84b0-2d03bcbd5f52€15.00€0.26matched
32capture01a1aef3-5053-7974-8f3a-6858dd673248€15.00€0.26matched
33capture01a1aef3-61cb-752c-bbbb-eea90c42ad4f€35.00€0.50matched
34capture01a1aef3-6460-70cd-8c61-d0c89673ed8f€9.00€0.19matched
35capture01a1aef3-6601-72a4-a91b-94e0560a4606€35.00€0.50matched
36capture01a1aef3-69a4-75fc-ac9d-2ed985263bb3€49.00€0.67matched
37capture01a1aef3-9a4a-7a48-8f32-1ea398fc87ef€9.00€0.19matched
38capture01a1aef3-b029-7f50-91a4-166bd7135071€24.00€0.37matched
39capture01a1aef3-bcc6-74f1-9ccc-35cca8176b5e€49.00€0.67matched
40capture01a1aef3-c8dd-7531-847c-41923ff88bb3€15.00€0.26matched
41capture01a1aef3-cfb1-7c1b-b5d7-9f4dc0474688€24.00€0.37matched
42capture01a1aef3-f58d-78fd-83af-876e48cd6fb6€15.00€0.26matched
43capture01a1aef3-f9b9-7ba4-b54c-c8813d48c80a€15.00€0.26matched
44capture01a1aef3-fa96-792d-975b-2eb1e6fe25c5€35.00€0.50matched
45refund01a1aef4-00c0-7159-b2c7-93516d1e5dff-€28.00€0.00matched
46capture01a1aef4-4d1a-7ab5-926b-b5220a8618cf€49.00€0.67matched
47capture01a1aef4-5282-7836-b002-8bc141c5cb2f€49.00€0.67matched
48capture01a1aef4-5f25-795a-bbbc-54e5a1fc3534€49.00€0.67matched
49capture01a1aef4-6ab2-7562-9869-bb0e11adc7fc€35.00€0.50matched
50capture01a1aef4-735d-72e0-b190-2308fe4d4999€9.00€0.19matched
51capture01a1aef4-784b-797b-b4b1-964b589a1f7f€49.00€0.67matched
52capture01a1aef4-9cf4-7b2c-8517-ba68ac734f6e€9.00€0.19matched
53capture01a1aef4-a5b2-7f14-9a90-798da709051a€49.00€0.67matched
54capture01a1aef4-b962-72b9-80b4-ed8a0f34e92f€24.00€0.37matched
55capture01a1aef4-cfad-72a2-b900-fff42c18fce8€24.00€0.37matched
56capture01a1aef4-e770-7f3c-970b-d29e677a959d€9.00€0.19matched
57refund01a1aef4-f344-7958-9f4a-eb1d4041ca36-€14.00€0.00matched
58capture01a1aef4-fd42-788e-93a3-16e179e6ec70€24.00€0.37matched
59capture01a1aef4-fe5b-727b-8abd-5651c66a2a54€35.00€0.50matched
60capture01a1aef5-04f3-7efc-862f-9ad75faf8173€35.00€0.50matched
61capture01a1aef5-0fe3-7e2f-94d8-3b877394c7d1€49.00€0.67matched
62capture01a1aef5-117d-748b-b297-8b77b8e654ba€9.00€0.19matched
63capture01a1aef5-14a2-761d-96ec-414bc9f52ccb€49.00€0.67matched
64capture01a1aef5-1930-7de9-b4e9-47c25c9f52d7€15.00€0.26matched
65capture01a1aef5-241f-75ac-aa2c-57bedf7b289c€24.00€0.37matched
66capture01a1aef5-492b-7954-b62c-f9e553d68204€9.00€0.19matched
67refund01a1aef5-532f-7d2b-98fd-92c7fadb5156-€12.00€0.00matched
68refund01a1aef5-5346-75db-94d7-ed73e0674bd4-€8.00€0.00matched
69capture01a1aef5-60ff-739c-94ee-b2e6fbe07c33€49.00€0.67matched
70capture01a1aef5-7671-7f54-925f-4e56c62e89cf€15.00€0.26matched
71capture01a1aef5-ad12-761c-91df-bb781637c218€9.00€0.19matched
72capture01a1aef5-f0cc-7fbc-9305-af1741107109€35.00€0.50matched
73capture01a1aef6-0524-75f4-8e61-620a93e4c45b€15.00€0.26matched
74capture01a1aef6-15dc-7c45-a4bc-784d528e6770€24.00€0.37matched
75refund01a1aef6-2089-70c7-a599-50df743189b5-€6.00€0.00matched
76capture01a1aef6-26e0-788d-835a-896e55aaa4fc€9.00€0.19matched
77capture01a1aef6-32ba-7470-b395-497b5ad1a81a€15.00€0.26matched
78capture01a1aef6-37aa-7921-9498-0a03b4a3f469€35.00€0.50matched
79capture01a1aef6-3d82-7eb9-b6c1-b1b9adbc2fe1€9.00€0.19matched
80capture01a1aef6-4245-7dd5-8882-aeab9b111b1d€15.00€0.26matched
81capture01a1aef6-4b98-733a-89f9-db4bbef7b427€9.00€0.19matched
82capture01a1aef6-5ceb-71b9-8b44-ba0fbfa9b514€24.00€0.37matched
83capture01a1aef6-680b-7418-a123-6a174cc67b7a€35.00€0.50matched
84capture01a1aef6-a696-7a9f-a304-6879ae6a2be0€15.00€0.26matched
85capture01a1aef6-aac7-78fc-8885-fecc430a21cc€49.00€0.67matched
86capture01a1aef6-cdce-7919-80a2-26e44a2cf7a2€35.00€0.50matched
87capture01a1aef6-dd76-7578-ab14-a68c066ff98e€24.00€0.37matched
88capture01a1aef6-dd96-7b9e-9323-c8683a020674€15.00€0.26matched
89capture01a1aef6-dd5a-7681-babe-6264bae42a41€49.00€0.67matched
90capture01a1aef6-e3aa-7a55-874c-d3c0392b1036€35.00€0.50matched
91capture01a1aef6-ef7c-7ed8-8a66-8e36006dced3€35.00€0.50matched
92capture01a1aef7-4e2a-7f58-b33a-66088ae3f3d1€35.00€0.50matched
93capture01a1aef7-6d8c-7a19-b5dc-31340b85bafe€24.00€0.37matched
94capture01a1aef7-73ac-7500-8dca-1ecba46e576c€35.00€0.50matched
95capture01a1aef7-83af-70ae-b7d6-5044290de627€9.00€0.19matched
96capture01a1aef7-b22c-7a4f-8b9e-8cf5b0847fc8€49.00€0.67matched
97capture01a1aef7-c4ac-7682-96d1-20787112ecb0€49.00€0.67matched
98capture01a1aef7-de34-7db1-b9b3-9fd20167a265€24.00€0.37matched
99capture01a1aef7-ea30-7dd8-b34a-582d8914e783€35.00€0.50matched
100capture01a1aef7-fb3a-7dfd-acd7-b200901d02b0€24.00€0.37matched
101capture01a1aef8-22c9-7f21-9fd1-29132fd5e242€35.00€0.50matched
102capture01a1aef8-2869-7118-bb58-8d4c7ec040d5€9.00€0.19matched
103capture01a1aef8-310b-7173-819e-58ecfa7b22f2€49.00€0.67matched
104capture01a1aef8-3731-70d0-8d73-ddb260ae8be2€49.00€0.67matched
105capture01a1aef8-3948-7ec8-ba12-05633a00f721€35.00€0.50matched
106capture01a1aef8-3ecb-75de-9e4a-cc7697bc98d6€24.00€0.37matched
107capture01a1aef8-43fe-7f8d-9d1e-d7659bad10bd€49.00€0.67matched
108capture01a1aef8-4ffd-75b5-844d-01b6e9dbe776€24.00€0.37matched
109capture01a1aef8-52b1-7843-9c98-77bf52fe7185€35.00€0.50matched
110capture01a1aef8-63c3-7486-977f-14e044461f03€49.00€0.67matched
111capture01a1aef8-6b95-7740-b8ca-0cd2a0969021€9.00€0.19matched
112capture01a1aef8-73b1-761a-8e3a-d07046fa12e0€9.00€0.19matched
113capture01a1aef8-7dbe-79f7-a909-e1e8c034080f€24.00€0.37matched
114capture01a1aef8-84f4-7ded-bdc4-c86152fd071d€24.00€0.37matched
115capture01a1aef8-8991-7b81-a196-fea2a77234bc€35.00€0.50matched
116refund01a1aef8-8a21-736a-97da-a254bd931d06-€20.00€0.00matched
117refund01a1aef8-8c6d-7a40-85ce-c05db9962c47-€30.00€0.00matched
118capture01a1aef8-9265-7e4f-9b17-e38c7ab956b5€9.00€0.19matched
119capture01a1aef8-a95e-791e-9ecd-4a4a5f8c8226€35.00€0.50matched
120capture01a1aef8-b942-712b-8a12-4b204d97fbc5€15.00€0.26matched
121capture01a1aef8-bb26-7db0-a31e-66a09de9ef6e€24.00€0.37matched
122capture01a1aef8-c5ad-7ef3-b237-9173a144dbce€49.00€0.67matched
123capture01a1aef8-c833-759e-af58-f715f440d7ad€35.00€0.50matched
124capture01a1aef8-dfd3-77b3-bb23-93cd101e8dd5€9.00€0.19matched
125capture01a1aef8-e7ad-76c0-8a8a-ded2288cfa0d€15.00€0.26matched
126capture01a1aef8-f2ab-7919-9c83-f96f558c1f14€9.00€0.19matched
127capture01a1aef8-f6df-78f6-8d3b-f39ce54cf50c€24.00€0.37matched
128capture01a1aef9-18f2-7589-a4de-1448d4f032ad€9.00€0.19matched
129capture01a1aef9-1993-7866-8acb-e730ac61005a€35.00€0.50matched
130capture01a1aef9-20c8-743f-8b87-7f1f8799beac€49.00€0.67matched
131refund01a1aef9-2a4e-78bb-a2b2-1f1f14b41b43-€13.00€0.00matched
132capture01a1aef9-2f4f-7cf5-9b0a-3c7b106bb911€49.00€0.67matched
133capture01a1aef9-34b1-79ac-94ff-877d40472794€15.00€0.26matched
134refund01a1aef9-35cb-7223-b575-618fc4b841c4-€9.00€0.00matched
135refund01a1aef9-6611-7266-b526-884dbe2f8cfe-€42.00€0.00matched
136capture01a1aef9-8602-796a-884f-d2b1a76209c8€35.00€0.50matched
137capture01a1aef9-8b2c-772d-898e-7607b02c172b€35.00€0.50matched
138capture01a1aef9-983f-7669-9d3e-668131502fe5€49.00€0.67matched
139capture01a1aef9-c4a3-7c8f-a57f-ecef8ba1a111€15.00€0.26matched
140capture01a1aef9-dcde-76ac-b1b5-a4bf453d3b9c€24.00€0.37matched
141capture01a1aef9-e643-7d01-ba34-7f6b9c88990f€9.00€0.19matched
142capture01a1aef9-eafa-7fe0-ba2d-8e13ee7beff8€9.00€0.19matched
143capture01a1aef9-edf9-7121-9fc2-38ee0ac23d4f€9.00€0.19matched
144capture01a1aef9-f2c8-7fdf-b8e8-d64607062081€9.00€0.19matched
145capture01a1aefa-0a93-7c31-b5ff-827c17c09488€35.00€0.50matched
146capture01a1aefa-1652-7230-8a7c-1364368cc6e7€49.00€0.67matched
147capture01a1aefa-27bb-7da4-86d4-f3a0ee66c101€49.00€0.67matched
148capture01a1aefa-391f-72dd-a9f6-1c454e9f0612€15.00€0.26matched