Dog Boarding Spreadsheet, Kennel Manager with Booking Calendar and Vaccine Tracker for a Pet Boarding Business, Google Sheets Excel
A dog boarding planner for home boarders and boarding kennels: every run, every dog with its vaccines and care, every stay priced and checked, a two-week run calendar and tonight's care sheet, in one file.
🔗 TRY THE LIVE DEMO before you buy (view only, nothing to install): https://docs.google.com/spreadsheets/d/1rPPHur_AtWfMaC-T82bLkwbgwYeJtnHBd37Rw1o0b0U/edit?gid=829328930
Type each dog once and each stay on one line. Nights, the total, the vaccine check, any double booking and what the owner still owes follow by themselves.
📊 WHAT IT DOES
✓ Runs: every run, suite or kennel with its nightly rate, who sleeps there tonight, this month's occupancy and what it earned.
✓ Dogs: every dog once, with owner and phone, size, temperament, feeding and meds, the vet and the rabies, DHPP and bordetella dates.
✓ Bookings: one line per stay with the dog, check-in, check-out and run. Nights and the total follow, with a rate of its own and add-ons.
✓ Vaccines checked on every stay: a date that runs out before pickup, or is missing, turns the stay red.
✓ One dog per run: a second dog in the same run on the same night is flagged on Bookings, Runs and Calendar.
✓ Calendar: every run, night by night, for this week and next, with free runs at the bottom.
✓ Care: tonight's care sheet with the run, feeding and meds, temperament, the owner's phone and the vet.
✓ Payments: deposits, stays paid at pickup, add-ons and refunds, tied to each stay, with what is left on it.
✓ Requests: everyone who asks, the dates and the source, with how many runs are free and a waitlist.
✓ Home: check-ins, dogs going home, vaccines to check, balances late and this month's occupancy.
📂 WHAT'S INSIDE: 12 TABS AND 31 CHARTS
✓ Set up first: Start here, Runs, Dogs
✓ Every day: Home, Bookings, Calendar
✓ Guests and money: Care, Payments, Requests
✓ Totals and settings: Income, Expenses, Settings
📝 HOW IT WORKS
- Open the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.
- On Runs, type your runs and rates. On Dogs, add each dog once with its vaccine dates.
- Add each stay on Bookings and each payment on Payments.
- Open Care every evening and Calendar for free runs. Home shows what is next.
📥 WHAT YOU GET
✓ Google Sheets version (the link is in the PDF)
✓ Excel version (.xlsx) for desktop Excel 2016 or newer and Microsoft 365, on Windows or Mac
✓ A filled example to look around, and a blank copy for your own business
✓ A PDF guide: a picture of every tab and your first five minutes, step by step
✓ A video guide for this planner (the link is in the PDF)
💻 GOOD TO KNOW
✓ Works with a free Google account. Nothing to install, no subscription.
✓ Formulas are protected, so you can't break anything by accident.
✓ It records only what you type. It does not take online bookings or connect to a website, calendar or bank.
✓ Not veterinary, legal or tax advice: vaccine fields record the dates you type. Follow your vet and your local licensing rules.
✓ Room for 12 runs, 60 dogs, 300 stays, 400 payments and 100 requests.
✓ Set it up on a computer in a few minutes. After that, the Google Sheets app works for the care sheet and adding a stay on your phone.
✓ The photos show Google Sheets. The Excel file has the same tabs and formulas.
✓ Free updates for life.
This is a digital download, so nothing is shipped. If anything is unclear after you buy, message me and I'll help you set it up.