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

Gross

€3,408.00

PSP fee

€53.73

Net to the bank

€3,354.27

Settlement journal

#352232

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

LineKindReferenceGrossFeeStatus
1capture01a19ed2-2c15-7ab5-b1bf-9b1e48797eb1€49.00€0.67matched
2capture01a19ed4-5821-70a1-9062-af962c19e427€49.00€0.67matched
3capture01a19ed6-7fa7-74c6-8337-526729ed85d1€35.00€0.50matched
4capture01a19ed9-59ff-703b-9f4c-6c683013eb0a€9.00€0.19matched
5capture01a19ed9-5a17-7380-92c8-045b9a610960€15.00€0.26matched
6capture01a19ed9-5a53-7e6b-b8d3-009dc85f17f7€35.00€0.50matched
7capture01a19ed9-70bc-77e1-bad7-027df7cca6d3€24.00€0.37matched
8capture01a19ed9-8425-7823-b7e8-369fe01dd3f4€35.00€0.50matched
9capture01a19ed9-8cbc-7db2-aa3f-08aef05a801a€24.00€0.37matched
10capture01a19ed9-9dfe-70b0-9f8a-f391883bea58€24.00€0.37matched
11capture01a19ed9-a3e4-7496-9f76-efa0975e8bcd€9.00€0.19matched
12capture01a19ed9-b51f-76c7-9b7d-2386aaacad5f€15.00€0.26matched
13capture01a19ed9-c4ec-77bc-8d9f-e4ff8258faef€9.00€0.19matched
14capture01a19ed9-c530-76e8-8fb4-d9c1ea82e08e€35.00€0.50matched
15capture01a19ed9-c863-70c3-80ae-f06bbb724b89€24.00€0.37matched
16capture01a19ed9-c8f8-77b6-a724-32729fbd7091€9.00€0.19matched
17capture01a19ed9-e130-757a-bb7e-ea3140b2166e€24.00€0.37matched
18refund01a19ed9-f734-7560-8679-5f3ea0d9fcbe-€22.00€0.00matched
19capture01a19ed9-faa0-77e5-87b6-d1da8c7c408c€35.00€0.50matched
20capture01a19eda-139e-7c61-bf70-560b164231b4€15.00€0.26matched
21capture01a19eda-1eea-7ef5-8dc2-90c0dfc92d57€35.00€0.50matched
22capture01a19eda-32cb-70ff-8aab-f376501ee29b€35.00€0.50matched
23capture01a19eda-38f1-704e-bffe-20a440b17dc1€49.00€0.67matched
24capture01a19eda-3d39-75f1-babd-1b74cd265913€15.00€0.26matched
25capture01a19eda-61b3-7a58-84ed-cd894e4ff166€35.00€0.50matched
26capture01a19eda-71c9-7e39-b5a6-d4fcc06d3eaa€15.00€0.26matched
27capture01a19eda-830f-71dd-854d-c392c7159431€35.00€0.50matched
28capture01a19eda-8332-7a46-83d2-a88fa12573d9€9.00€0.19matched
29capture01a19eda-9299-74fb-a9ce-fdf05a5ab60d€24.00€0.37matched
30capture01a19eda-9ec3-76e8-88cb-de72f6e6377b€9.00€0.19matched
31capture01a19eda-b5b0-7d00-aa77-06c4d94ed3d8€24.00€0.37matched
32capture01a19eda-b876-7b50-9f8b-e08994a8c676€15.00€0.26matched
33capture01a19eda-bf90-75b4-a291-fcca7fcc17b2€9.00€0.19matched
34capture01a19eda-cb7b-7073-a707-b0d652f18a0c€15.00€0.26matched
35capture01a19eda-cdf1-7c6e-adf7-aef7d3c6b6eb€9.00€0.19matched
36refund01a19eda-cfab-78a9-b47a-b49e533187f4-€20.00€0.00matched
37capture01a19eda-e29b-7463-97ac-1b20e0c6a55b€24.00€0.37matched
38capture01a19eda-f0ac-761a-bf27-8cf7646bb5fc€35.00€0.50matched
39refund01a19eda-f973-78ca-8a24-a081ffed2860-€23.00€0.00matched
40capture01a19edb-0b41-7a04-afb3-1575f1175fb9€24.00€0.37matched
41capture01a19edb-1d6f-77ac-8bf7-10b51f36eac2€49.00€0.67matched
42capture01a19edb-3c8c-7f2f-bf8c-ce6e6d434fac€35.00€0.50matched
43capture01a19edb-8a22-7a89-ae3b-c0fc5d6aa20c€35.00€0.50matched
44capture01a19edb-8dbd-728f-8ff2-fa30668988af€24.00€0.37matched
45capture01a19edb-ae65-7dfd-8fa9-947782333fbf€35.00€0.50matched
46capture01a19edb-dfb3-74e1-9481-4e376e1fdbb9€24.00€0.37matched
47capture01a19edb-fb85-7e44-8a7d-19dee8672c9d€24.00€0.37matched
48capture01a19edc-25f9-75b9-a414-a93d454f748f€24.00€0.37matched
49capture01a19edc-4497-7d11-9bbe-751ed1de8441€9.00€0.19matched
50capture01a19edc-6531-7b68-b417-d76beb8d605b€9.00€0.19matched
51capture01a19edc-6537-7a80-92c4-41dec784335f€9.00€0.19matched
52refund01a19edc-7dab-714e-a531-7b8fc976eae7-€8.00€0.00matched
53capture01a19edc-88ae-77dc-9a6e-ae0cd9206a85€49.00€0.67matched
54capture01a19edc-8f4a-75d5-b193-29209245512f€9.00€0.19matched
55capture01a19edc-9e7d-70b1-b748-b204a91f7f3a€15.00€0.26matched
56capture01a19edc-a214-7850-bdbe-6a42813ddeb2€24.00€0.37matched
57capture01a19edc-a359-73e5-ba2b-92dbbfd1c11c€49.00€0.67matched
58capture01a19edc-b7c7-74d6-9452-456c2a176812€35.00€0.50matched
59capture01a19edc-d744-7276-87c5-b282040a9b1c€9.00€0.19matched
60capture01a19edc-f0a0-7b8b-962c-fa22c4725eb5€35.00€0.50matched
61capture01a19edd-030c-7b75-98d8-d22019b15feb€35.00€0.50matched
62capture01a19edd-0fdf-7d78-8553-3a5212b20df7€35.00€0.50matched
63capture01a19edd-1cf5-706c-9084-0939395dfdab€15.00€0.26matched
64capture01a19edd-1e7f-74ee-a2ec-0c93f70d92a3€35.00€0.50matched
65capture01a19edd-2239-756a-b8cb-3f42e5c7fa8e€24.00€0.37matched
66capture01a19edd-42ba-7d9d-bd72-d806af9749d4€9.00€0.19matched
67refund01a19edd-49cc-7d06-a84e-274ceea90972-€20.00€0.00matched
68capture01a19edd-5658-7183-8825-50878bca21e4€9.00€0.19matched
69capture01a19edd-5ad2-770b-b728-fd3310b82787€24.00€0.37matched
70capture01a19edd-67de-7600-8b3e-acaf4a5afb1d€15.00€0.26matched
71capture01a19edd-6bb6-7e72-b346-e41d04fb3a72€49.00€0.67matched
72capture01a19edd-6d3a-757d-aad0-969bdf48c3a6€24.00€0.37matched
73capture01a19edd-8ef7-780d-bc04-6dfc5036cab1€24.00€0.37matched
74capture01a19edd-99aa-7cb4-bfe4-5fe077c806cd€49.00€0.67matched
75refund01a19edd-a948-7294-ab4f-a5e0e394c5e2-€12.00€0.00matched
76capture01a19edd-b621-70f8-be15-27e100ebe4d9€35.00€0.50matched
77refund01a19edd-cb97-776a-adff-c7514aa861a2-€18.00€0.00matched
78capture01a19edd-e76c-7213-accb-5e40534b41ec€49.00€0.67matched
79capture01a19edd-f414-7fe1-a1b5-55118b15bf3c€35.00€0.50matched
80capture01a19ede-11b9-791a-a454-7eb8485582f3€35.00€0.50matched
81capture01a19ede-5888-7f31-a080-0f08af5d7e17€49.00€0.67matched
82capture01a19ede-666e-74a9-b84a-86f64576fa86€15.00€0.26matched
83capture01a19ede-6a35-710c-b2f5-ff93a1a3f36f€35.00€0.50matched
84capture01a19ede-6a4d-7d86-a8b3-5c257e631e1b€15.00€0.26matched
85capture01a19ede-6db9-79af-837f-55607ffd6fae€9.00€0.19matched
86capture01a19ede-cb12-7384-8a57-2e53fd83d4bf€24.00€0.37matched
87capture01a19ede-dad1-7de1-b89b-cc94261a9d5b€35.00€0.50matched
88capture01a19ede-ebba-7006-b20d-9d4090f6a29d€15.00€0.26matched
89capture01a19ede-eecc-7605-82c4-d1a460e7e6d9€9.00€0.19matched
90capture01a19edf-0342-7285-9691-a0d7fddec225€35.00€0.50matched
91capture01a19edf-177f-7650-93aa-cf0a5774405c€24.00€0.37matched
92capture01a19edf-32e7-73b0-8130-1ffd82401e1a€35.00€0.50matched
93capture01a19edf-3adf-72a9-92fd-05b758bf8997€24.00€0.37matched
94capture01a19edf-3dcc-7674-b9fe-5ad2738972be€15.00€0.26matched
95capture01a19edf-4258-7e2c-8731-2853feb14057€35.00€0.50matched
96capture01a19edf-a65b-7c7f-8deb-116ae2dcd182€35.00€0.50matched
97capture01a19edf-ad78-7b8b-bb25-6c00c4cd591a€49.00€0.67matched
98capture01a19edf-c482-7c20-8aca-d8c3fa4adfd7€15.00€0.26matched
99capture01a19edf-c8d8-760a-99bb-f725d1e8edc8€9.00€0.19matched
100capture01a19edf-dbcf-7c9a-9b93-c63dbb29cdb8€49.00€0.67matched
101capture01a19edf-eaba-7dc0-b310-b9fd2b8fa326€9.00€0.19matched
102capture01a19edf-fbb4-7041-92cf-a705020faefd€15.00€0.26matched
103capture01a19edf-fbb4-717f-8ee9-7453bbea2dde€35.00€0.50matched
104capture01a19edf-feb2-7ece-949d-b5225e07568b€15.00€0.26matched
105capture01a19ee0-1fcb-7386-8727-29ac67ae9bb9€15.00€0.26matched
106capture01a19ee0-24ae-73d6-9a5e-b59bb2af8522€9.00€0.19matched
107capture01a19ee0-256e-784a-be0c-9cfcb7e7a7bb€24.00€0.37matched
108capture01a19ee0-2781-7757-8900-f861e924d1dd€49.00€0.67matched
109capture01a19ee0-2829-7d0f-9e06-fd1ae9ace845€35.00€0.50matched
110capture01a19ee0-2e31-74f4-864d-ffc8d667a644€9.00€0.19matched
111capture01a19ee0-3054-735f-aa7b-bd3dadadb135€9.00€0.19matched
112capture01a19ee0-4a02-7517-9fe9-e21ff9344ac3€15.00€0.26matched
113capture01a19ee0-5252-7a47-911d-48a64d258dc9€49.00€0.67matched
114capture01a19ee0-6bed-7183-bb09-3f628de03d96€24.00€0.37matched
115capture01a19ee0-7d3e-7881-b8e6-2c0997256a59€15.00€0.26matched
116refund01a19ee0-8186-7855-9d83-65099655aff4-€6.00€0.00matched
117capture01a19ee0-cab4-71e0-bfe4-f0ebc5a89618€49.00€0.67matched
118capture01a19ee0-cda0-73eb-95be-a9757cedc7fd€49.00€0.67matched
119capture01a19ee0-db8a-7561-8ad4-ecd381a03927€35.00€0.50matched
120capture01a19ee0-e75c-778b-9319-e7bf5b5ecda4€24.00€0.37matched
121capture01a19ee0-ebd0-7925-8c07-c4d2f785631f€15.00€0.26matched
122capture01a19ee0-ed41-71d0-8c00-c287fcd05fad€35.00€0.50matched
123capture01a19ee0-ef93-7e60-b158-462fd2e346ab€24.00€0.37matched
124capture01a19ee0-f6b6-7f68-96ed-1a251059c0f1€15.00€0.26matched
125capture01a19ee1-0745-7eee-b637-16c0f496faae€24.00€0.37matched
126refund01a19ee1-0989-7c24-b383-276d730c0e99-€19.00€0.00matched
127capture01a19ee1-0c5b-7171-8501-448846aa22df€15.00€0.26matched
128capture01a19ee1-0cc6-7392-83b1-25fceabe57f4€49.00€0.67matched
129capture01a19ee1-186c-74a5-8522-9da054ffb0b9€49.00€0.67matched
130capture01a19ee1-3842-7d40-b589-e858faa8ccdc€35.00€0.50matched
131capture01a19ee1-3f2b-709b-a2c5-0e6c716d205c€9.00€0.19matched
132capture01a19ee1-4013-7a9d-b5ef-74ed00f60efd€24.00€0.37matched
133capture01a19ee1-4224-7d2b-843f-e5c26ff34fd2€35.00€0.50matched
134capture01a19ee1-49db-7599-9107-000ade1050bc€9.00€0.19matched
135refund01a19ee1-6700-7f77-9360-ab6f1758056e-€9.00€0.00matched
136capture01a19ee1-7364-780c-a473-2cb75ebafed3€35.00€0.50matched
137capture01a19ee1-9952-7cb3-b614-82f9b783b942€35.00€0.50matched
138capture01a19ee1-a939-7d5e-af85-a233a4e837d4€24.00€0.37matched
139capture01a19ee1-c50b-74e8-b10d-ef3cc5ebdb3f€24.00€0.37matched
140capture01a19ee1-d5a2-7c78-a7b7-d948fe1fe426€24.00€0.37matched
141capture01a19ee1-ed7f-7f37-a6f5-ad1ceb6cf01f€35.00€0.50matched
142capture01a19ee2-04d3-743a-807d-9a4c19576267€35.00€0.50matched
143capture01a19ee2-09a8-713c-b089-2857e1198daa€49.00€0.67matched
144capture01a19ee2-338c-7786-9512-6bfb8f024e4e€9.00€0.19matched
145capture01a19ee2-45cf-7748-8890-cca054db85b8€49.00€0.67matched