Free Appointment Log: Client Visit Log, No-Show Tracker and Medical Appointment Record (PDF, Word, Excel)

What is on the page

Fee, paid and balance

On the client log: the price of the service, what the client paid and what is left. Excel works out each balance and the totals.

Payment method

Card, cash, HSA or FSA card, gift certificate, invoice. Useful at end of day when matching the card terminal and the cash drawer.

Type and notice

On the no-show tracker: no-show or late cancellation, and how much notice was given.

Slot value, refilled, fee and lost revenue

What the appointment was worth, how much was recovered by refilling the slot or charging a fee, and what was actually lost. Excel totals it and works out the no-show rate.

Medical details

Doctor, reason, what was said, tests and referrals, medication changes and the follow-up date, in one place for every appointment.

Keeping a client visit log

A visit log is the simplest record a service business can keep: one line per appointment, written straight after it. At the end of the day the fee and paid columns should match what went into the card terminal and the cash drawer, and the balance column shows anyone who still owes money. Over a few months the log answers useful questions: which services sell which clients come back and how often, which days are busy. If clients pay by invoice, copy the balances to the client billing tracker; if they need a receipt, the receipt template has a two-per-page version.

What no-shows really cost

Most small service businesses underestimate no-shows because each one feels small. Writing them down changes that. In the sample, six missed or late-canceled appointments in a month were worth $680 in slot value; refilling two and charging fees on three recovered a good part of it. A no-show rate above about 5% is usually worth acting on. The common fixes are a reminder the day before, a clear cancellation policy given at booking, a card on file or a deposit for long or first-time appointments, and a waitlist to refill short-notice cancellations. Track it for three months before and after a policy change to see whether it worked.

A medical appointment log for patients and carers

Appointments with several doctors are hard to keep straight, especially for someone caring for a parent or managing a long-term condition. A log kept by the patient, with the date, who was seen, what was said, what was ordered and what changed, makes each new appointment more productive: bring it along, and the doctor can see what the other specialists said and changed. Write the follow-up date on the line before leaving the room. Keep current medications on the medication schedule and bring that too.

Privacy

Client logs and especially medical logs contain personal information. Keep paper logs in a locked drawer and digital copies in a password-protected location, and don't leave them on a shared reception desk. Health care providers are covered by HIPAA and should use their practice management system for clinical records; the medical log here is designed for patients and family carers keeping their own notes.

Editing the files

The Excel client log calculates balances and totals fees, payments and balances. The no-show tracker calculates lost revenue per appointment, totals and the no-show rate. Rename the columns to suit your business, and keep one sheet per week or month. Every design is a fillable PDF.

Questions

What is an appointment log?

A record of appointments after they happen: who came, what was done, what was charged and paid, and any follow-up. It complements the appointment book, which shows what is booked.

How do I calculate the cost of no-shows?

Add up the value of each missed slot, subtract anything recovered by refilling the slot or charging a fee, and divide the number of missed appointments by the total booked for the no-show rate. The Excel tracker does this.

What is a normal no-show rate?

It varies by industry, but many service businesses aim to keep no-shows and late cancellations under about 5% of bookings.

What should I write in a medical appointment log?

The date, doctor or clinic, reason for the visit, what was said or diagnosed, tests or referrals, medication changes and the follow-up date.

Does the PDF total the fees?

No. The fillable PDF is for typing. The Excel and ODS versions calculate balances, totals, lost revenue and the no-show rate.