Dog Walking Round and Billing Sheet

Who this is for

A week of a dog walking round on one sheet. The upper table is a line per walk, with how long it was, what it costs and whether it has been paid for, adding up to the week's takings and the week's unpaid; the lower table is the round itself — each dog, the owner, where the key is and what that owner is charged.

Dog walkers running a round of several dogs a day, walkers covering someone else's round for a week, and small walking businesses that invoice at the end of the week.

What this helps you track

• Which dogs are on the round, whose they are and how to get in
• Every walk you did, with the date, the length and where you went
• What each walk is charged at, by dog rather than by memory
• What the week comes to, and how much of it is still unpaid
• Anything that happened on a walk, written down the same day

How to use it

1. Write your name, the round and the week beginning at the top.
2. Fill the round table at the foot in once: dog, owner and phone, the address and how you get in, and your own price for that dog's walk.
3. After each walk, add a line to the upper table: date, dog, the time you started, how long it was in minutes, where you went and the price.
4. Tick paid when the money arrives. The unpaid column and the totals work themselves out in the browser and the workbook.
5. Use the notes for anything the owner needs to know — a limp, a scrap, a dropped lead, a gate left open by someone else.
6. Print a sheet a week, or fill it in online and save it in your own browser, then invoice from the totals.

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 long should a dog be walked for?

That is between you and the owner, and it depends on the dog. The minutes column records what you actually did; no length is suggested here.

What should I charge?

Your own rate. The sheet multiplies and totals whatever you enter and has no prices of its own.

How does the unpaid figure work?

Every walk with the paid box unticked is added up. Tick the box as the money arrives and the figure falls to zero.

Can I run group walks on it?

Yes. Give each dog its own line for the same walk, so the price and the paid tick stay per client, and put the group in the notes.

Does it replace an invoice?

No, but it gives you the lines to write one from. The invoice generator will turn them into a numbered invoice.