Key takeaways
- Link every animal to an owner with a phone number.
- Bill the visit from its charge lines, not from memory.
- Next due date = date given plus the vaccine's interval.
- Work the Due Soon and Overdue rows every week.
A vet clinic loses money quietly. An owner who was supposed to come back in three weeks does not, nobody notices, and the animal misses a booster. A visit is billed at the counter from a scrap of paper, and half of it is forgotten. A vial reaches its expiry date on the shelf. VetDesk PH ties the visit, the vaccination, the medicine batch, and the payment together so a weekly pass through the sheets shows all three problems before they cost anything.
Register owners and animals once
An owner is entered with a phone number, and each animal is linked to that owner with species, breed, sex, birth date, and weight. Every later record points at the animal ID.
Because the phone number lives with the owner rather than on a slip, the recall list can print a call sheet without anyone searching for a contact.
Bill the visit by its lines
A consultation opens with the date, animal, owner, and reason. Each service, vaccine, or medicine used is added as a charge line with a quantity and a unit fee, and the visit charges are the sum of those lines.
Payments are recorded against the visit ID, so the balance is charges less payments, and an owner who pays part today still shows what remains.
Let the interval set the next due date
Each vaccine carries its own interval in days, whether that is a three-week booster or a yearly anti-rabies shot. When a vaccination is recorded, the next due date is the date given plus that interval.
Due status then reads Scheduled, Due Soon within thirty days, or Overdue once the date has passed, without anyone counting on a calendar.
Call from the recall list
RECALL LIST pulls the animal, the owner, the phone number, the vaccine, the next due date, and the status onto one sheet. Filtering it to Due Soon and Overdue gives the week's call list.
Medicine and vaccine batches carry their own expiry dates and show Expiring Soon within ninety days, so the oldest vial is used first instead of being discovered too late.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
VetDesk PH Google Sheets Edition is designed for use with a Google account and current desktop Google Sheets.
No veterinary, clinical, or medical advice, diagnosis, prescription validation, pet insurance or PhilHealth claim filing, veterinary licensing or regulatory compliance, automatic owner reminders, official receipts, or tax filing.
Frequently asked questions
What if a vaccine has a different interval for puppies and adults?
Add it as two vaccine rows with different intervals, such as a booster series row and a yearly row, and pick the right one when recording.
Does the sheet send reminders to owners?
No. It produces the recall list with names, animals, and phone numbers. The calling or messaging is done by your staff.
Can I track which batch a shot came from?
Yes. The vaccination row carries a batch ID, and the stock movement records the clinic use against the same batch.
Does this replace official records?
No. No veterinary, clinical, or medical advice, diagnosis, prescription validation, pet insurance or PhilHealth claim filing, veterinary licensing or regulatory compliance, automatic owner reminders, official receipts, or tax filing.
