Home/Spreadsheets/Practice & Clinic Tools/Clinical Hours Tracker
Clinical Hours Tracker
A clinical hours tracker for LPC, LCSW and LMFT associates: log direct and non-direct hours and supervision against your own board's requirements, and see what counts, what is missing and when you will finish. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is yours to reuse as often as you like.
What you get
- Requirements you type from your board: total hours, direct contact, couple and family hours, supervision, group limit, ratio, minimum months and weekly cap
- Hours Log and Supervision Log, where you choose which categories count as direct contact and which formats count as individual
- Dashboard: hours that count, direct hours, supervision, percent complete and a projected finish date at your pace over the last 8 weeks
- Progress against every requirement: met, hours to go, short supervision months, too much group supervision or hours over a weekly cap
- Charts of hours that count by month against your target, and the last 12 months of direct, non-direct and supervision hours
- Opens in Excel and in Google Sheets
$7.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription
What it does
- Requirements you type from your board: total hours, direct contact, couple and family hours, supervision, group limit, ratio, minimum months and weekly cap
- Hours Log and Supervision Log, where you choose which categories count as direct contact and which formats count as individual
- Dashboard: hours that count, direct hours, supervision, percent complete and a projected finish date at your pace over the last 8 weeks
- Progress against every requirement: met, hours to go, short supervision months, too much group supervision or hours over a weekly cap
- Charts of hours that count by month against your target, and the last 12 months of direct, non-direct and supervision hours
- Supervisor approval dates, supervision hours per supervisor and every entry still waiting for a signature
What it looks like
Every tab in the workbook
These are the actual sheet names in the file, not a feature list.
- Dashboard
- Dashboard
- Hours Log
Works in
- Google Sheets, free, in any browser (a Make a copy link is included)
- Microsoft Excel 2019 or later and Microsoft 365, Windows or Mac
- No macros, no add-ons
Honest scope
This tracks what you enter about your own licences. Renewal requirements vary by state and by board and they change; the authority on yours is your licensing board, not this file.
Others in Practice & Clinic Tools
- Therapist Referral and Client Intake Pipeline TrackerResponse time to conversion, measured. The file records enquiry date and first-response…$12.99View →
- Home Health Visit Note GeneratorThe categories ARE the required elements of a defensible skilled visit note, so you…$24.99View →
- Therapist Practice Management SpreadsheetA practice management spreadsheet for private practice: log each session once and fees…$24.99View →
- Outpatient Therapy Authorization TrackerAn authorization tracker for outpatient PT, OT and SLP clinics: see how many visits are…$19.99View →
