Dog Walker Business Spreadsheet UK 2026/27, Pet Sitter Client Tracker, Invoice and Tax Template, 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? Send me a message, I reply within 24 hours.