Clinical Hours Ledger | Supervised Hours Log for LPC, LMFT, LCSW (Google Sheets)

Form to sheet: log it in-the-moment on a Google Form on your phone, and the entry lands organized in your Google Sheet. No app, no re-typing. That's how every Ledger & Light tool works.

Every clinical day between your degree and your license becomes part of one record.

After each day with clients, open the form on your phone and log it in-the-moment: the site, your supervisor, direct client hours, indirect hours, and any individual or group supervision. Type 1.5 or 1:30 — both work. Your Clinical Hours Ledger adds each day to the running record of your supervised experience, across every year it takes.

Pick your board's rules on the Setup tab — California LMFT, LPCC or LCSW, or Texas LPC, LMFT or LCSW — and the sheet sets out each requirement as a target: total hours, direct hours, the caps on what counts, supervision each week or month, and the time limits. Each preset shows the statute or rule it came from and the date it was checked, and every target is a cell you can change. Licensed somewhere else? Choose Custom and type your own board's numbers.

✓ KEY FEATURES:
• Hours entered as 1.5 or 1:30 from a phone form, logged in-the-moment
• California and Texas board-rule presets, each with its source and check date — every target editable
• A Custom rule set for any other board
• A requirement ladder with a status for each one: Met, On pace, Behind or Check
• A pace line: at your last-8-weeks pace, the month you reach your total, beside your deadline
• Supervision by week, with any week short of your rule set's minimum marked
• Hours over a maximum shown, and kept out of your counted total
• A Board Summary by supervisor and site, for any date range — plus a week-by-week view to copy onto your board's own verification form
• A "Reviewed with supervisor" date on every day you log
• No client fields at all — a record of hours, never of clients
• Works on any device with a free Google account

✓ WHAT YOU GET:
• Your Clinical Hours Ledger for Google Sheets — your private access link arrives in your instant download
• Setup instruction PDF — delivered with your Etsy download
• A mobile-friendly "Log Hours" form (opens in any browser, no app required)
• Email tips sequence: short setup guides delivered after you complete setup

✓ HOW IT WORKS:
1. Purchase — download your instruction PDF from Etsy right after checkout
2. Open your Clinical Hours Ledger (link in the PDF) and click Make a Copy into your Drive
3. Pick your board's rules and your start date on Setup, then log each clinical day in-the-moment

✓ MADE FOR:
• Associate marriage and family therapists, associate professional clinical counselors and associate clinical social workers in California
• LPC Associates, LMFT Associates and LMSWs working toward an LCSW in Texas
• Any post-degree clinician keeping the record their license application is built from

Your instruction PDF is available immediately after purchase.

Your Clinical Hours Ledger keeps your own record of your supervised hours. It does not verify, certify or submit hours, and it is not affiliated with any licensing board. Licensing requirements change and differ by state and license; the targets in this sheet were checked against official board sources on the date shown and you can edit them. Confirm your requirements with your board before relying on any total. Your board and your supervisor decide what counts.

The spreadsheet system and formulas are my own original design; AI tools assisted with the decorative illustrations.