Sparta LabsHow do I keep track of a therapy waitlist in private practice?
Keep one row per person waiting, by ID code, with the date they joined, what they're looking for (payer, times, in-person or telehealth) and the date you last contacted them. Sort by how long they've waited and how long since you last reached out. When a slot opens, you know who fits and who's gone quiet, without digging through email.
How to set it up
- Use an ID code, not a name, and keep contact details wherever you already store client information securely.
- Record the date they joined the list and what they need: payer or self-pay, preferred days and times, and in-person or telehealth.
- Log every contact attempt with the date. Days since last contact is the number that keeps a waitlist from going stale.
- Check in with anyone who's waited a long time without hearing from you. A short note asking if they still want a spot clears out people who found care elsewhere.
- Give each row a status, such as waiting, offered, scheduled or removed, instead of deleting rows. That shows how many inquiries turn into clients.
- When a slot opens, filter by fit first (payer, time, format), then by who has waited longest.
Waitlist records can still be protected information. Keep names and contact details in a secure system, and follow your licensing board's and your own practice's rules on record-keeping and privacy.
A template that does this
Our Therapist Caseload & Insurance Authorization Tracker ($24, Excel and Google Sheets) includes a waitlist that shows days since last contact for each person, next to insurance authorizations, no-show and late-cancel fees and balance aging. Everyone is entered by ID code only. If you just want to try the layout, the free Lite version below covers a small caseload.
Start with the free Lite version.
Lite holds up to 5 clients, 60 sessions and 3 insurance authorizations in Excel or Google Sheets. The full tracker raises those limits to 200 clients, 1,000 sessions and 200 authorizations.
Common follow-up questions
How long should someone stay on my waitlist?
That's your call. Many clinicians check in at set intervals and remove people who don't reply. Writing down your rule keeps it consistent.
Should I refer people out instead of waitlisting them?
If your wait is long, offering referrals alongside the waitlist is common practice. You can note on the row that a referral was given.
Can I track this in my EHR?
Some EHRs have a waitlist or lead feature. If yours does and you use it, stick with it. A spreadsheet suits practices whose EHR doesn't, or who want it next to their caseload and fees.
Related questions
- How do I track no-show and late-cancel fees in private practice?
- How do I track how many insurance authorization visits a client has left?
Sparta Labs templates are spreadsheets for organizing your practice. They aren't an EHR, billing or clinical advice, or a HIPAA compliance solution.