Getting a pet business off spreadsheets without losing a month

Most pet businesses don’t run on a system. They run on a diary, a card machine, a stock sheet somebody updates when they remember, a WhatsApp group for the rota, and an accountant who receives a carrier bag in April.

That works to a point, and the point is usually the second service line or the second location. Then it stops working quite suddenly.

Here’s how to move without losing a month of trading.

First: what not to move

The instinct is to bring everything. Don’t. A migration that tries to preserve eleven years of history takes three months and stalls.

Move:

• Customers who have been in within about 24 months. Name, phone, email, address.
• Pets attached to those customers. Name, species, breed, date of birth, and any allergy or behaviour note that matters.
• Vaccination dates where you have them. This is the highest-value data you own, because it drives recalls from day one.
• Products you currently stock, with prices, barcodes and current quantities.
• Suppliers and what you owe them.
• Services and prices. Not really a migration, more a decision, and a good chance to fix pricing you’ve been meaning to fix.
• Outstanding balances. Who owes you money.

Leave behind:

• Customers who haven’t been in for two years. Archive the file, don’t import it.
• Historical transactions. Your accountant has them. Bringing five years of invoices into a new system buys you almost nothing and costs a fortnight.
• Old appointments. Yesterday’s diary is not an asset.
• Products you no longer stock. This is a free stock clear-out; take it.

A useful rule: if it doesn’t help you serve a customer next Tuesday or file your next tax return, don’t move it.

The order that works

Weeks 1–2: decide, don’t type

Before anyone imports anything, settle the things everyone will otherwise argue about in month three:

• Your service list and prices, written down, final.
• What you actually call things. If the diary says “FG”, “full groom” and “groom out” for the same job, pick one now.
• Your tax setup.
• Who gets a login and what they should be able to see.
• Your branches, if you have more than one.

This is the step people skip and the one that decides whether the whole thing works. Nothing downstream is fixable if your service list is a mess.

Week 2: clean the customer list

Export whatever you have. Then, in a spreadsheet, one last time:

• Delete anyone with no phone number and no email. They aren’t a customer, they’re a row.
• De-duplicate. Same phone number, two spellings of the name. There will be more than you expect.
• Fix the phone format. One country code, one format, no spaces or brackets. This matters because it’s what WhatsApp reminders key off.
• Put pets in their own sheet, with a column pointing at the owner’s phone number.

Budget an afternoon. It will take a day. Everyone underestimates this and it is the single biggest determinant of whether the first month feels good or awful.

Week 3: import and configure

Load customers, pets, products, suppliers and stock. Configure tax, branding, branches, roles and users. Get your logo on the invoice template.

Then check twenty records by hand. Not a spot check of two. Twenty, chosen at random, compared against the source. Import problems are systematic, so if twenty are right, forty thousand are right.

Week 4: run both, but only just

Parallel running is where migrations die. Two systems means double entry, double entry means mistakes, and after ten days everybody quietly goes back to the old way.

Keep the overlap to one week, one area. Take bookings in the new system only, and keep the paper diary as a read-only reference for anything already booked. Don’t write in both.

Week 5: switch the till

Do the counter last, because it’s the highest-stakes thing in the building, and do it on your quietest day, not a Monday and never a Saturday.

Have somebody who knows the system standing at the counter for the first two days. Not on the phone. Standing there.

Week 6 onwards: turn on the clever bits

Only once the basics are boring:

• Reminder rules for vaccinations and rebooking
• The customer portal
• Commission tracking
• The reports you’ll run monthly

Turning these on in week one is how people end up overwhelmed and convinced the software is complicated. It isn’t. There was just too much of it at once.

Train by role, not by system

The single most common training mistake is putting everyone in a room and demonstrating the whole thing.

Your groomer does not need to know how purchase orders work. Showing them is not thoroughness, it’s noise, and it teaches them that the software is big and confusing.

Train each person on the four or five screens they’ll touch:

• Front desk: book, check in, take payment, close the till.
• Groomers: their day, their tickets, before-and-after photos.
• Boarding: reservations, check-in, daily logs.
• Vet: consults, scripts, vaccinations.
• You: all of it, but over a few weeks, not one afternoon.

Half an hour each, on their own screens, beats a two-hour group session every time.

What will go wrong

Not “might”. Will. Plan for these three and the month feels fine:

Someone will keep using the old way. Usually your longest-serving person. Not sabotage, just habit under pressure. Fix it by removing the old thing physically. If the paper diary is on the counter, it will get used.

Your product prices will be wrong somewhere. They were wrong before too, you just couldn’t see it. Fix as you go rather than trying to audit everything up front.

Week two will feel slower than the old way. Because it is. People are learning. Tell your team this in advance and it’s expected; let it surprise them and it’s evidence the software is bad.

What good looks like at 90 days

• Nobody has opened the paper diary in a month
• You know what you took yesterday without asking anyone
• Vaccination reminders are going out and you’re not sending them
• Month-end took an hour instead of a weekend
• A new starter can work the desk on their second shift

If you’re not there at 90 days, it’s usually one of two things: the service list was never properly agreed, or one team never really moved across.

A note on doing this with us

We do the week-three part for you. Setup covers configuring services, prices, tax, branches, roles and branding, and importing your customers, pets, products and stock, so you go live with your real business rather than an empty screen. Training is role by role, and someone stays close through your first busy Saturday, your first till close and your first month-end.

If you want to see what that looks like against your own shop, book twenty minutes.

The short version

1. Decide your services, prices and vocabulary before you touch any data.
2. Move active customers, their pets, vaccination dates, live stock and open balances. Leave history behind.
3. Clean the customer list properly. It takes a day.
4. Import, then hand-check twenty records.
5. One week of overlap, one area, never double entry.
6. Switch the till last, on your quietest day, with help standing there.
7. Turn on reminders, the portal and commission in month two, not week one.
8. Train by role, half an hour each.