BBS Hours Spreadsheet vs Purpose-Built Tracking App: An Honest Comparison for California Associates
Should you track BBS supervised experience in a spreadsheet? Here is an honest look at when that works, where it breaks down, and what a tracking error can cost over 3,000 hours.
Last Updated: October 2026
Quick Reference Comparison
| Capability | Spreadsheet | Tracking App |
|---|---|---|
| Track raw hours | Yes (free) | Yes ($7.95/mo or $79/yr for associates) |
| 40-hour limit in any 7 days | Manual formula | Stops you saving a week over 40 hours |
| Track 104 supervised weeks | Manual count | Automatic |
| Track A1 CFC subset | Manual formula | Shown on the dashboard |
| Multi-site combined cap | Cross-sheet formulas | Automatic |
| Export Form 37A-525 / 638 | Manual copy-paste | PDF export |
| Supervisor signatures | Print / scan / email | Plus can email the form to your supervisor |
| Pre/post-degree classification | Manual labeling | Automatic by date |
| BBS rule updates | Manual research | Updated in product |
| Error discovery | At licensure application | Flagged when you log the week |
Why Start with a Spreadsheet
There is nothing wrong with starting in a spreadsheet for your running totals. Spreadsheets are free, they are familiar, and they give you full control over your data. When money is tight and you are just beginning to accumulate hours, paying for a tracking tool can feel hard to justify.
Free and paid templates exist. Check any template against the BBS weekly log for your registration type.
The BBS requires a weekly log that your supervisor signs each week, and you keep it. What you send with your Application for Licensure is the Experience Verification form. You can keep running totals anywhere, but the signed weekly log has to be on the BBS form.
What Spreadsheets Do Well
Spreadsheets excel at raw data entry. You can log your hours exactly the way you want, create custom columns for notes or reminders, and share the file with your supervisor for review. Google Sheets in particular offers live collaboration, which makes it easy to share access with a supervisor who wants to review your weekly entries.
The flexibility of spreadsheets also means you can adapt them as your situation changes. Need an extra column for a new site? Add it. Want a pivot table summarizing hours by month? Build one. Want conditional formatting to highlight weeks where you logged more than 40 hours? Set it up. This level of customization is genuinely useful, especially if you enjoy working with data.
For associates with a single supervisor at a single site who are not yet doing couples or family work, a well-maintained spreadsheet can serve you through hundreds of hours with minimal risk. The math is straightforward: direct hours go in Column A, non-clinical hours go in Column B, and Column C is the sum.
Where Spreadsheets Fail in the BBS Context
The BBS hour tracking requirements contain several interdependent rules that spreadsheets handle poorly. Not because the math is hard, but because the failures are silent. Every issue listed below will not announce itself until you are sitting in front of your licensure application wondering why your totals do not match.
The 40-hour limit is invisible across sites
The BBS credits at most 40 hours of experience in any seven consecutive days across all work settings combined. If you log 25 hours at Site A and 20 hours at Site B in the same week, only 40 count. In a spreadsheet, each site typically has its own tab or row block. There is no automatic cross-sheet check that flags the 5-hour overage. Those excess hours accumulate silently week after week.
104 supervised weeks tracked separately from hours
The BBS requires at least 104 weeks of supervised experience, with at least 52 of those weeks with individual or triadic supervision. This is a count of qualifying weeks, not hours. In a spreadsheet, you would need a separate counter that increments only when a week includes both logged hours and supervision, and counting qualifying weeks by hand over years is error-prone.
A1 couples/families/children subset runs in parallel
Within Column A (direct counseling hours), the BBS tracks a subset called A1: hours working with couples, families, and children. LMFT candidates need at least 500 of their 1,750 direct hours to be A1 work. This is a running parallel requirement that needs its own cumulative tracker. In a spreadsheet, this means an extra column, an extra running total, and a manual check that the A1 pace matches your overall direct hours pace.
Pre-degree vs post-degree classification is manual
LMFT trainees can count up to 1,300 pre-degree hours (with a 750-hour sub-cap on counseling and direct supervisor contact). The classification depends on your degree awarded date, and a single date change reclassifies every log entry before or after it. In a spreadsheet, changing your degree date means manually relabeling potentially dozens of rows and recalculating sub-totals. A tracking app does this automatically based on the date you enter.
BBS form export is entirely manual
When you apply, the Experience Verification forms need your hour totals from every supervisor. Copying totals by hand from a spreadsheet is a place to make mistakes: transposed digits, wrong row totals, or missed weeks.
The common thread across all of these: spreadsheet errors are silent. There is no alert, no red flag, no warning. You find out when you submit your application to the BBS and something does not add up.
The Real Cost of a Spreadsheet Error
Here is the math that makes spreadsheet tracking risky over the long term. Suppose you work at two sites and consistently log 5 hours over the 40-hour limit without noticing. Over two years (roughly 100 working weeks), that is 500 hours you counted but the BBS will not accept.
Five hundred hours at an average pace of 25 hours/week represents 20 additional weeks of work, nearly five extra months, to make up the difference. Five extra months is five more months of associate pay and supervision costs.
And that is just one type of error. Weeks short on supervision can cost you hours. Misclassified pre-degree hours can blow past the 1,300-hour cap. An incorrectly calculated A1 subset can mean you are 100 hours short of the couples/families/children requirement when you thought you were done.
The fundamental problem is asymmetric risk: over 36 months the app costs $286 at the associate price on monthly billing, or $237 on annual billing. A spreadsheet error that delays licensure by even two months adds two more months of the associate period.
When a Spreadsheet Is Fine
Despite the risks above, a spreadsheet is a perfectly reasonable choice if all of the following are true:
- You work at one site with one supervisor
- You are tracking toward LPCC or LCSW (no couples, families, and children line)
- You are an APCC or ASW (no pre-degree hours to classify) or you are a post-degree associate who does not need to worry about the pre-degree cap
- You are willing to manually check your supervision ratios every week and maintain a separate supervised-weeks count
- You are comfortable filling in the BBS weekly log (such as Form 37A-525 or 37A-638) each week and copying totals onto the Experience Verification forms
If that describes your situation, save the money and use a free template. But set a calendar reminder to reassess when you hit 1,000 hours or when your clinical situation changes (new site, new supervisor, or beginning CFC work).
When You Should Switch to a Purpose-Built App
Certain milestones and situations make the switch from a spreadsheet to a tracking app worth the cost:
- Multiple work settings: Once you have two or more sites, the 40-hour cross-site limit becomes a real risk. A tracking app will not save a week over 40 hours.
- Approaching your hour caps: When you are past 1,000 total hours, the stakes of an error are much higher. You have more data to lose and more formulas that could be wrong.
- Behind on CFC (A1) hours: If your couples/families/children pace is lagging behind your direct hours pace, you need to see that gap. The dashboard shows your couples, families, and children total against the 500-hour minimum.
- Want help getting forms to your supervisor: Chasing physical signatures every week is tedious. With Plus, HourJourney can email the form to your supervisor.
- Want automatic form export: If the thought of manually copying 104+ weeks of data onto BBS forms makes you anxious, an auto-filled PDF export removes that step.
- Pre-degree hours to manage: If you are tracking pre-degree experience as an LMFT trainee, the automatic date-based classification alone is worth the cost.
For more details on what to track and how, see our step-by-step guide to tracking LMFT supervised hours.
How HourJourney Compares
HourJourney was built specifically for California pre-licensed therapists pursuing LMFT, LPCC, or LCSW licensure. It is not a generic time tracker adapted for clinical hours; it is built around California BBS requirements.
| BBS Requirement | HourJourney Feature |
|---|---|
| Weekly log hour categories | Built-in category structure matching BBS forms |
| Supervision ratio check (1:10 rule) | Flags a week short on supervision when you save it |
| 40 hours in any 7 days across sites | Will not save a week over 40 hours |
| A1 CFC subset tracking (500 hrs for LMFT) | Running total on the dashboard |
| Pre-degree vs post-degree classification | Automatic by degree awarded date |
| 104 supervised weeks / 52 individual or triadic | Automatic week counting |
| Non-clinical hours cap (1,250 LMFT / 1,000 LCSW) | Automatic cap tracking |
| Form 37A-525 / 37A-638 generation | Auto-filled PDF export |
| Weekly supervisor signatures | Plus can email the form to your supervisor |
| Audit trail for hour changes | Edits to an entry are recorded |
Plans are $7.95/month (or $79/year, save 17%) for associates and $4.95/month (or $49/year) for MFT trainees. Every plan includes a 30-day free trial with full access, and no card is required to start. To learn more about California hour requirements, see our California LMFT hours requirements guide.
Making the Switch from a Spreadsheet
If you have been tracking in a spreadsheet and want to switch, the process is straightforward. There is no automated import: you enter your historical weekly totals manually.
Here is the recommended approach:
- Start your free trial first. Explore the interface and make sure it fits how you work before investing time in data entry. You have 30 days.
- Set up your sites and supervisors. Add every work setting and supervisor you have had, including past ones you are no longer working with.
- Enter historical weeks in batches. Work through your spreadsheet chronologically. For each week, enter the supervisor, site, and hour totals. The app checks each week's supervision ratio as you save it.
- Check the dashboard. Once your historical data is entered, the dashboard will show your progress and projections, and any weeks flagged short on supervision. This can surface errors you did not know you had.
- Keep your spreadsheet as a backup. There is no reason to delete it. Keep it as a secondary record alongside the app.
For LCSW candidates, see our guide to tracking LCSW hours in California for license-specific details on the data entry process.
Frequently Asked Questions
Can I use a spreadsheet to track LMFT hours in California?
What are the risks of using a spreadsheet for BBS hour tracking?
What is the best app to track AMFT hours in California?
How do I transfer my spreadsheet hours to a BBS tracking app?
Does a BBS hours tracking app automatically generate Form 37A-525?
Is HourJourney free?
What does a BBS hours tracking app cost per month?
Can my supervisor sign my logs digitally?
Ready to upgrade from your spreadsheet?
Start your free 30-day trial. Enter your existing weekly totals by hand and see your weeks checked against the BBS supervision ratio.
Licensing in Texas instead? Our guide to Supervised Experience Documentation form explains why a spreadsheet cannot be the submission in Texas either: BHEC's upgrade checklist says supervision logs will not be accepted.
Related Guides
California LMFT Hours Requirements (2026)
Complete breakdown of the 3,000 hours you need for LMFT licensure.
How to Track LMFT Supervised Hours
Step-by-step guide to logging BBS hours correctly.
BBS Form 37A-525 Guide
How to fill out the AMFT Weekly Log of Experience Hours, column by column.
How to Track LCSW Hours in California
LCSW-specific tracking requirements and tips.
Disclaimer: This guide is for informational purposes only and does not constitute legal or professional advice. HourJourney is not affiliated with, endorsed by, or officially connected to the California Board of Behavioral Sciences (BBS). BBS rules and requirements may change without notice. Always verify current requirements directly with the BBS website or by contacting the BBS directly. The comparisons and cost estimates on this page are approximate and based on publicly available information as of April 2026.