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

2 Nov, 09:00

Gross

€3,462.00

PSP fee

€54.09

Net to the bank

€3,407.91

Settlement journal

#340152

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

LineKindReferenceGrossFeeStatus
1capture01a19b75-b4e2-71b6-8ce2-2e5b03afca92€9.00€0.19matched
2capture01a19b7c-2c43-7680-8087-d83141e9bed1€15.00€0.26matched
3capture01a19b7c-b33a-7e40-8c1d-6a1d47ba4da3€49.00€0.67matched
4capture01a19b7c-b73a-7062-9a32-db7808ea9f0a€49.00€0.67matched
5capture01a19b7c-b769-72cb-8505-35dcf30b4221€9.00€0.19matched
6capture01a19b7c-c775-7f6d-a1b4-f18e758d3628€24.00€0.37matched
7capture01a19b7c-c84c-7b4e-a24a-df052f51d5a0€49.00€0.67matched
8capture01a19b7c-c8bb-7f79-a934-7ae10054ca3b€49.00€0.67matched
9capture01a19b7c-d1e1-7f57-97c7-4fb5fd0fc8b2€24.00€0.37matched
10capture01a19b7c-d2ca-76a4-84d4-b6f9a044db9c€24.00€0.37matched
11refund01a19b7c-d925-7e16-bc24-533f685a2640-€7.00€0.00matched
12capture01a19b7c-e795-7b18-b6f4-9827334fc4ab€24.00€0.37matched
13capture01a19b7d-1a21-70b5-bcdd-733414adfd39€15.00€0.26matched
14capture01a19b7d-2b25-7091-b43f-29e8dddb8fb9€9.00€0.19matched
15capture01a19b7d-56f4-7411-abf0-4ea494cbd1c7€15.00€0.26matched
16capture01a19b7d-5d24-7270-b685-ea4c57d36ca5€15.00€0.26matched
17capture01a19b7d-6c09-7a33-a135-262198078776€9.00€0.19matched
18capture01a19b7d-6ccb-7eae-9580-3a792e9706ed€9.00€0.19matched
19capture01a19b7d-6fc9-736c-8061-bf8ad8c30bcb€9.00€0.19matched
20capture01a19b7d-7079-7ffd-89ad-216d16557e29€24.00€0.37matched
21capture01a19b7d-7efd-7841-8a5f-1094796e3aca€35.00€0.50matched
22capture01a19b7d-9c34-77ee-a390-c495afbd1cfd€15.00€0.26matched
23refund01a19b7d-a083-7e3b-a550-2e99b0b75396-€14.00€0.00matched
24capture01a19b7d-b6e5-707d-8b97-118e3e44b69a€24.00€0.37matched
25capture01a19b7d-e1d9-7754-b89a-a24b9b515dd0€15.00€0.26matched
26capture01a19b7e-10c7-7529-8ac4-e9e0c6646e78€35.00€0.50matched
27capture01a19b7e-4d3b-7ccf-bdbb-4bdd82515da8€49.00€0.67matched
28capture01a19b7e-6cec-7d4b-ac43-ba0e5008c44d€24.00€0.37matched
29capture01a19b7e-6d30-7794-aa00-eac9ba1da71f€49.00€0.67matched
30capture01a19b7e-66ae-7f2e-84a8-088db6b5cd88€35.00€0.50matched
31capture01a19b7e-81b5-7e60-860f-ebebd42fe5a3€49.00€0.67matched
32capture01a19b7e-8d6b-70e3-ac0d-6eff254befbf€35.00€0.50matched
33capture01a19b7e-b52f-716e-a7ac-e4740d84e6fe€35.00€0.50matched
34refund01a19b7e-e03e-733f-ad1d-07e9e7f2c27e-€25.00€0.00matched
35capture01a19b7f-1131-7d19-8100-f0192572fc6f€9.00€0.19matched
36capture01a19b7f-1aee-7bf2-acd3-73043ca4258a€24.00€0.37matched
37capture01a19b7f-2667-726c-850f-c4bfe42c530f€15.00€0.26matched
38capture01a19b7f-398c-7fd3-bd57-136110441d98€24.00€0.37matched
39capture01a19b7f-4978-73e6-8cca-bb15b00d7e9c€35.00€0.50matched
40capture01a19b7f-4dbd-7413-9731-cfb075299ec1€35.00€0.50matched
41capture01a19b7f-5399-7071-adb9-ebc304c77c3d€24.00€0.37matched
42capture01a19b7f-6638-7673-b606-4defa8957353€35.00€0.50matched
43capture01a19b7f-7fac-7319-b5f9-355ec9979c5c€49.00€0.67matched
44refund01a19b7f-817a-738d-a450-194914705adc-€9.00€0.00matched
45capture01a19b7f-973c-7eb8-9f24-5689132f985a€9.00€0.19matched
46capture01a19b7f-9c69-7383-b5be-19cab5e24624€35.00€0.50matched
47refund01a19b7f-c219-7ab7-b8e5-68b16d93aff9-€12.00€0.00matched
48capture01a19b7f-d4dc-7180-b1ee-7500930b23dc€35.00€0.50matched
49capture01a19b7f-f9fc-7666-b477-000dc826f62d€35.00€0.50matched
50capture01a19b7f-fcfb-7701-95ac-d47d54c66ccf€15.00€0.26matched
51capture01a19b80-0d43-7529-8720-c6527d78e9fa€49.00€0.67matched
52capture01a19b80-1419-7197-a478-cd67085931dc€49.00€0.67matched
53capture01a19b80-1d9f-7850-848c-6189f710719d€35.00€0.50matched
54capture01a19b80-2b62-72c6-8eb6-e4db1d65af03€49.00€0.67matched
55capture01a19b80-2ccc-73fa-9a8f-4c175f588e3d€24.00€0.37matched
56capture01a19b80-4525-74c1-85d5-96322e79a14e€49.00€0.67matched
57refund01a19b80-528e-72fa-9a81-67fea20be50f-€21.00€0.00matched
58capture01a19b80-5ae8-78dc-a920-0e5daa586ec3€35.00€0.50matched
59capture01a19b80-5dda-7fd2-aca9-f16dee0c5253€35.00€0.50matched
60capture01a19b80-6052-7765-991b-49026b261780€9.00€0.19matched
61capture01a19b80-6e86-7b4d-bd13-805594c36137€15.00€0.26matched
62capture01a19b80-8bc3-7e2b-9650-6275720b5182€49.00€0.67matched
63capture01a19b80-93d5-7491-8978-5fd031af5d0f€49.00€0.67matched
64capture01a19b80-aae7-73f6-aa14-ea1202dbf6cb€15.00€0.26matched
65refund01a19b80-d882-789b-adb7-50c4501bee73-€37.00€0.00matched
66capture01a19b80-dd1e-734f-ab45-e677800e28ae€35.00€0.50matched
67capture01a19b80-f448-7c99-bee8-fa3e9bec68fe€35.00€0.50matched
68capture01a19b81-2658-7fae-8238-fafa56d57021€15.00€0.26matched
69capture01a19b81-34a5-7359-87b0-b03eb11c2309€35.00€0.50matched
70capture01a19b81-3a78-7e16-9a32-c9723a8d3a11€49.00€0.67matched
71capture01a19b81-6774-7928-9213-a8cb5b72bc15€49.00€0.67matched
72capture01a19b81-885c-743f-b401-9378c2ca650d€49.00€0.67matched
73capture01a19b81-924e-7359-b70d-b883c935e8fd€49.00€0.67matched
74capture01a19b81-995b-7fb7-a2be-9ac0fccb0d69€49.00€0.67matched
75capture01a19b81-9f1c-7403-9841-43a85f214439€24.00€0.37matched
76capture01a19b81-a251-7723-9c7e-0e95b65215f9€24.00€0.37matched
77capture01a19b81-b630-7e89-a4c1-e8ae8dc367d2€35.00€0.50matched
78capture01a19b81-cc61-7678-bc4d-58ce078517ef€35.00€0.50matched
79capture01a19b81-ec18-7e0e-9e66-f5f3e001c369€49.00€0.67matched
80capture01a19b81-fcd0-7dbe-8dc8-28b0f29466b7€24.00€0.37matched
81capture01a19b82-09f4-74ab-82a3-9d2251672d30€24.00€0.37matched
82capture01a19b82-1eab-75ef-a07d-4aecf2a31232€15.00€0.26matched
83capture01a19b82-40d0-78e4-8239-eb908b532eaf€9.00€0.19matched
84capture01a19b82-5439-782b-8d74-e85cb99aaaa7€9.00€0.19matched
85capture01a19b82-6518-77b4-881d-f630d420cc83€24.00€0.37matched
86capture01a19b82-6be0-7c3b-a873-7dddabec65f3€15.00€0.26matched
87capture01a19b82-713b-779b-a688-ac7a51f8c9b4€9.00€0.19matched
88refund01a19b82-7dc7-7d28-963d-9cd63d28a15a-€5.00€0.00matched
89capture01a19b82-b460-7559-ba58-f84144129624€49.00€0.67matched
90capture01a19b83-0312-79b7-879c-ff9bfaca979c€35.00€0.50matched
91capture01a19b83-05fb-7044-88d4-9939b2048d35€15.00€0.26matched
92capture01a19b83-2878-73c4-a7d9-a1e31ce0a1e0€49.00€0.67matched
93capture01a19b83-3ef8-7db1-b548-4534d973271a€24.00€0.37matched
94capture01a19b83-48c1-763d-9660-5d694d6580af€49.00€0.67matched
95capture01a19b83-5130-7c0b-817c-2c7d7f3a558f€35.00€0.50matched
96capture01a19b83-5285-711c-97ea-8b502bb21972€9.00€0.19matched
97capture01a19b83-594c-7524-ae2f-4c6cb38a0635€24.00€0.37matched
98capture01a19b83-60a9-7d3f-a9b8-0738d62759a5€24.00€0.37matched
99capture01a19b83-7a20-7983-a911-dc3cb2107b15€49.00€0.67matched
100capture01a19b83-7d15-7679-b14f-1f18bdca20c5€24.00€0.37matched
101capture01a19b83-7d66-7413-8b30-91054a9bac88€24.00€0.37matched
102capture01a19b83-83dd-7b6f-a098-8621bf1b7420€15.00€0.26matched
103capture01a19b83-9311-76e2-84ef-017b2c32a62e€24.00€0.37matched
104capture01a19b83-a605-7fc7-8cfc-19b18818b057€49.00€0.67matched
105capture01a19b83-ad60-788e-ba65-c41e80bbce33€15.00€0.26matched
106refund01a19b83-adb0-7789-a583-cc861c3bd3a5-€15.00€0.00matched
107capture01a19b83-b662-7a94-a57f-10b0a2df8faf€24.00€0.37matched
108capture01a19b83-bdae-7514-a774-f78f3b3458dd€24.00€0.37matched
109capture01a19b83-d41d-7665-9a47-c6702c564e9a€35.00€0.50matched
110capture01a19b83-d5f8-76ac-81f4-248afd7cc268€15.00€0.26matched
111capture01a19b83-e084-713f-8d63-5e0e15f07b3f€49.00€0.67matched
112capture01a19b83-e0fe-7e5b-88df-f38e57545b69€35.00€0.50matched
113capture01a19b83-edd9-7812-919b-f04e3ea2f872€35.00€0.50matched
114capture01a19b83-f94f-76b8-be3e-fb531632c76a€9.00€0.19matched
115capture01a19b83-fa0f-72e7-b58e-c7d3d2d68e8b€35.00€0.50matched
116capture01a19b84-0934-7708-81e7-51672729c1a5€49.00€0.67matched
117capture01a19b84-0f95-70f0-a5ef-d4f56ab0e2f5€24.00€0.37matched
118refund01a19b84-1694-77a0-9109-fa292b6987b0-€21.00€0.00matched
119capture01a19b84-3a00-7878-933f-0351685111cc€9.00€0.19matched
120capture01a19b84-5788-720b-a16a-d91875e2d8b8€15.00€0.26matched
121capture01a19b84-5fd0-79b4-a02e-894237b03742€9.00€0.19matched
122capture01a19b84-6950-7e72-bc9c-2f87e09bedb6€9.00€0.19matched
123capture01a19b84-708f-7768-acf8-832cbbbe939d€15.00€0.26matched
124capture01a19b84-7eaa-733e-9464-cf04befa7527€15.00€0.26matched
125capture01a19b84-8b74-7048-af42-97fde37ea600€9.00€0.19matched
126capture01a19b84-a16a-7249-b3ca-b79021b27473€49.00€0.67matched
127capture01a19b84-cb0c-73ce-9736-83591525f319€24.00€0.37matched
128capture01a19b84-e07b-7623-a97a-94aa928986f0€24.00€0.37matched
129capture01a19b85-16e2-7593-9c14-d03e3999f224€24.00€0.37matched
130refund01a19b85-1a55-7168-8c81-eea4d2206ad5-€6.00€0.00matched
131capture01a19b85-39d4-7fe3-b27e-e0a9e23424b1€15.00€0.26matched
132capture01a19b85-4ae7-7f16-838b-0003c0471eca€24.00€0.37matched
133capture01a19b85-552a-7e7d-959b-dd0fe8fac10e€49.00€0.67matched
134capture01a19b85-7165-7823-b634-4aee5593002a€9.00€0.19matched
135capture01a19b85-750a-7fc0-b9ba-9d49afeb4fe0€9.00€0.19matched
136capture01a19b85-79d7-7c7f-8091-49b075759906€24.00€0.37matched
137capture01a19b85-a695-7b7c-92c7-0bde6faff565€15.00€0.26matched
138capture01a19b85-a987-7492-8404-3e73d7715f7e€49.00€0.67matched
139capture01a19b85-c00d-7e6e-afbd-ddec64ab60b2€24.00€0.37matched
140capture01a19b85-c25b-7037-970b-7f955685ca1c€35.00€0.50matched