Dog Walker & Pet Sitter Business Spreadsheet 2026/27 (Excel & Google Sheets)
Run your dog walking or pet sitting business from one spreadsheet. Keep every client and pet in one place, log walks and visits in seconds, make invoices in a minute, see who owes you, and know what to set aside for tax for the 2026/27 tax year. Works in Excel and Google Sheets.
Built for UK dog walkers, pet sitters, cat sitters, home boarders and doggy day care - whether you're just starting out or walking a full van every day.
WHAT IT DOES FOR YOU
- Pick the client and service and the price fills in. Group walks are priced per dog, boarding per night
- Late cancellation fees, free trial walks and extras like a bath are all handled
- Invoice tab: pick a client and dates and every walk, visit and night fills in - print it or save it as a PDF
- Shows what each client has been charged, what they've paid and what they owe you
- Client and pet book: pets, breed, vet, emergency contact, key held, notes and vaccination or booster dates
- Flags any dog booked for boarding or day care whose booster has run out
- Price checker: what each walk really earns per hour once pick-up and travel time are counted, and which services are below your target rate
- Van mileage at 55p a mile, expenses matched to HMRC's boxes, and an Income Tax and NI estimate
WHAT'S INSIDE (16 tabs + an example file)
- Visits: 2,500 rows for walks, visits, nights and days, with a Check column that flags mistakes
- Payments: every payment in, with card or app fees worked out
- Invoice: a ready-to-send invoice for any client and dates
- Clients & Pets: 200 households with visits, money owed, last visit and booster status
- Services: 40 services with earns per visit, earns per hour and times booked
- Dashboard: money received, owed to you, profit, tax set aside, tax bill, visits, dogs walked, boosters overdue and who owes you most
- Expenses and Mileage: insurance, leads, crates, treats, licence, DBS, first aid courses and your van miles
- Tax Estimate and Annual Summary: Income Tax, Class 4 NI, the £1,000 trading allowance check, payments on account and the figures for your tax return
- Plus Start Here guide, Settings, Monthly Summary, Key Dates (insurance, licence and DBS renewals), What Goes Where and Rates (with GOV.UK sources)
YOU'LL RECEIVE
- Blank Excel spreadsheet (.xlsx)
- Example Excel spreadsheet filled with a sample London dog walker
- PDF with your Google Sheets links (click "Make a copy")
WORKS WITH
Microsoft Excel 2016 or newer (Windows and Mac) and Google Sheets with a free Google account. Set up on a computer; after that you can log walks on your phone.
PLEASE NOTE
- Digital download only. No physical item will be sent.
- This is not a booking app and it doesn't send invoices or reminders for you. It keeps your records and works out your figures. It doesn't send anything to HMRC.
- Home boarding and day care need a council licence in England. Check licensing and insurance rules with your council and insurer.
- Client details are personal data. Keep your copy private and only record what you need.
- It's a record-keeping tool, not tax or financial advice.
- Built for self-employed sole traders. Limited companies, VAT-registered businesses and staff payroll aren't covered.
- Uses 2026/27 rates for England, Wales and Northern Ireland. Scottish income tax bands are different, so the estimate won't be exact in Scotland.
- Designed by me with the help of AI tools, then checked and tested by hand.
- For your own use only. Please don't share or resell.
Questions or stuck? Use the Contact link at the top of my store and I'll reply within 24 hours.