Note · private practice

Most trackers begin as a tidy list of names and turn into a second, worse copy of the chart. Here is the structure that holds up.

The 4 questions the tracker has to answer

Every field has to serve one of these, or it is decoration.

• Who is on my caseload right now? Active, paused, waitlist, or closed.
• Who owes me money, and for which session?
• Whose authorized visits are running out, and which authorization expires within 30 days?
• Who is waiting for a slot, and when did I last contact them?

If a column answers none of those, it belongs in the chart or nowhere.

Two tables, not one wide sheet

The failure mode is a spreadsheet with a column for every week. By week 6 it is unreadable, and nobody updates it twice.

Use two tables instead, related by a client ID. Clients holds one row per person and changes rarely: status, paperwork dates, payer details, referral source. Sessions holds one row per session and changes every week: date, type, length, fee, payment, attendance.

The session table is the one that makes money visible. You can sum it, filter it, and answer "what is outstanding" in one click, which is impossible in a grid of weekly columns.

The client fields that earn their place

• Client ID and a contact method. If the file ever leaves your device, use the ID, not the name. A name in a spreadsheet is the easiest way to leak protected health information.
• Status (active, waitlist, paused, closed) with the date of the last change. The date tells you how long someone has been waiting without being told.
• Referral source and the date of first contact. After 20 clients this column becomes your marketing report, and you stop guessing which directory sends people who stay.
• Intake complete date and consent signature date, so you can confirm paperwork without opening the chart.
• Payer: self-pay, or payer name with the authorization number, authorized visits, visits used, and the authorization end date.
• Fee agreement: the rate you agreed to, which is often lower than the rate on your website.
• Emergency contact on file: a yes or no, so you can see at a glance whose file has a gap.

The session fields that earn their place

• Date, start time, length, and session type (individual, couples, family, group, intake).
• Procedure code and the amount charged for that session.
• Amount paid, date paid, and payment method. Card, cash, check, or insurance, because reconciliation starts here.
• Attendance: attended, late cancel (inside 24 hours), or no-show, plus whether a fee was charged and whether it was collected. A no-show fee that was never collected is a different problem from one that was.
• Note status: written or open. A tracker that shows which notes are outstanding on Friday saves more time than the money column does.

The 10 minute Monday check

Four filters, run once a week. This is the entire maintenance cost of the system.

• Unpaid sessions older than 30 days.
• Authorizations ending in the next 30 days, or clients within 2 visits of their limit.
• Anyone with 2 or more no-shows or late cancels in the last 90 days. That is a conversation about the schedule, and often about a card on file.
• Waitlist entries with no contact in 14 days.

What to leave out

• Session by session clinical content. Two records of the same conversation are two things to reconcile in a records request. The tracker holds logistics; the chart holds the work.
• Diagnoses on any sheet you share with a biller, an accountant, or a virtual assistant.
• A column per week. Use rows.
• A tool you cannot export from. If the data does not come out as a CSV, the tool owns your practice instead of the other way around.

Privacy: the part that is easy to get wrong

A tracker is a business record about clients, so it carries the same duty of care as the rest of the file, even the columns that hold no clinical detail.

Consumer cloud storage is the common trap. Client data in a general consumer drive account, with no business associate agreement, is a documented problem area in enforcement actions. If you use a hosted tool, confirm that it signs a business associate agreement. A spreadsheet on an encrypted machine keeps that question closed.

Retention is the other one. HIPAA sets a 6 year floor for the records it covers, and many states require 7 to 10 years, so build the tracker to be archived and handed over, never quietly deleted.

The specifics vary by state, by payer, and by record type. Confirm your own setup with a professional who knows your state before you move client data into a new tool. This note is about structure, not legal advice.

Where to keep it

• A single spreadsheet. Free, exports in one click, and the two-table layout above works in Google Sheets or Excel without formulas.
• A database tool such as Notion or Airtable, where the client and session tables relate and filters stay saved. Better for a caseload above roughly 30.
• The practice management system you already pay for, if it shows a running balance without 6 clicks. If it does not, the spreadsheet wins.

The bottom line

A client tracker earns its place when it answers 4 questions in under a minute: who is on the caseload, who owes money, whose authorization is expiring, and who is waiting. One row per session, a status column you actually update, and a 10 minute Monday check beat any dashboard you will not open.

← All notes