Free BBS hours tracking spreadsheet
A ready-to-use BBS hours tracker spreadsheet for California AMFTs, APCCs, and ASWs. Weekly log layout, A/B/C hour columns, supervision-ratio tracking, and running totals. Enter your email and pick your license to download.
What's inside
Each license version is set up with the correct BBS hour categories and caps for that track. Pick yours above — you can grab the others from the download screen.
LMFT / AMFT
- BBS A/B/C hour columns (A1 individual + A2 couples/family/children, B non-clinical, C total)
- Pre-degree vs post-degree sections with the 1,300-hour pre-degree note
- Individual and group supervision columns to track your weekly ratio
- Running totals toward 3,000 hours with the 1,250 non-clinical cap flagged
LPCC / APCC
- BBS A/B/C hour columns matching the LPCC Experience Verification form
- Weekly log layout, one row per week per supervisor and setting
- Individual and group supervision columns for ratio tracking
- Running totals toward 3,000 hours with the 1,250 non-clinical cap flagged
LCSW / ASW
- BBS hour categories aligned to the LCSW experience requirements
- Weekly log layout with direct, non-clinical, and supervision columns
- Individual and group supervision columns for ratio tracking
- Running totals toward 3,000 hours with the 1,000 non-clinical cap flagged
Spreadsheet vs. the app
Let's be honest: the spreadsheet is a genuinely useful, free way to start logging hours. For a single supervisor at a single site in your first few months, it's plenty.
What a spreadsheet can't do is check your hours. It won't flag a week where your supervision ratio falls out of compliance, it won't auto-classify your pre-degree vs post-degree hours, and it can't fill out the official BBS forms you submit at the end. That's where HourJourney comes in — it auto-validates BBS supervision ratios and exports the official BBS Experience Verification and Weekly Log forms pre-filled. The spreadsheet can't.
Want the full breakdown? Read BBS hours spreadsheet vs. tracking app or our guide on when to switch from a spreadsheet.
Frequently asked questions
Is the BBS hours spreadsheet really free?
Which version of the spreadsheet do I need?
How do I use the BBS hours spreadsheet?
What does the HourJourney app add over the spreadsheet?
HourJourney is not affiliated with, endorsed by, or sponsored by the California Board of Behavioral Sciences (BBS). This spreadsheet is a tracking aid, not legal or licensure advice. Always confirm current requirements directly with the BBS at bbs.ca.gov, as rules can change.