Window Cleaning Round Sheet

Who this is for

The whole round on one sheet. Each customer takes a line with the address, the interval, the price and two ticks — cleaned and paid — and the sheet totals what the round is worth, what you collected and what is still owed.

Window cleaners and other round-based trades who work through a list of addresses in a day and collect as they go or bill afterwards.

What this helps you track

• Every call on the round in the order you drive it
• The price for each customer, and the value of the round
• Who was cleaned and who was missed, with the reason
• What you collected on the day and what is still outstanding
• A running list you can carry, print weekly or keep in the workbook

How to use it

1. Name the round and the week, and write in the cleaner and the vehicle if more than one goes out.
2. List the customers in the order you call, with the address, how often they are done and the price you charge each.
3. Tick Done as you finish each one, and Paid when the money is in — cash, card or bank transfer, whichever you take.
4. Put a reason in the notes for anything you could not do: no access, gate locked, dog out, asked to skip.
5. Read the totals: the round value, what was collected and what is owed. Carry the unpaid lines onto next week's sheet.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

How does the collected total work?

The collected column multiplies the price by the paid tick, so a ticked line counts its own price and an unticked one counts nothing. The owed figure is the difference between the round value and the collected total.

Can I use it for a monthly or eight-weekly round?

Yes. The interval column takes whatever you write in it, and the sheet is a round rather than a calendar, so one sheet covers one run of the round however often that comes up.

What about customers who pay by standing order?

Tick paid when the payment lands and note the method. Alternatively keep them on the sheet for the cleaning record and reconcile the money against your bank in the invoice tracker instead.

Is it any use for other rounds?

Yes — gardening rounds, dog walking, mobile valeting and cleaning rounds all have the same shape. Change the interval and notes columns to suit what you do.