BBS Hours Spreadsheet vs Purpose-Built Tracking App: An Honest Comparison for California Associates

There is nothing wrong with starting in a spreadsheet. In fact, it makes perfect sense for most new trainees and associates. 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, spending even $5/month on a tracking tool feels hard to justify.

Many associates find BBS hour tracking templates on Etsy for $15-30, or download free versions shared by other clinicians on Reddit and Facebook groups. These templates mirror the column structure of the official BBS weekly log forms and provide a reasonable starting point for simple tracking situations.

The spreadsheet approach works because the BBS does not care how you track your hours. They care about the official forms you submit with your licensure application. Whether you tracked in Google Sheets, Excel, a paper notebook, or a purpose-built app, the BBS reviews the same Experience Verification forms and Weekly Logs. Your tracking method is an internal tool for accuracy, not a submission requirement.

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 real-time 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.

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.

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 weekly cap 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. That is five months of delayed licensure, five months of associate-level pay instead of licensed clinician pay, and five months of continued supervision costs. The financial impact of a $10-15K salary difference over five months dwarfs the $4.95-$7.95/month cost of a tracking app over your entire associate period.

And that is just one type of error. Supervision ratio violations can invalidate entire weeks of 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: a tracking app costs roughly $178-$286 over three years. A single spreadsheet error that delays licensure by even two months costs far more in lost income alone, not counting the emotional toll of extending an already long process.

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 not doing couples, families, or children work (no A1 tracking needed)
• 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 manually transferring all data onto official BBS Form 37A-525 or 37A-638 when it is time to apply

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).

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 cap becomes a real risk. A tracking app enforces this automatically.
• 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 real-time visibility into that gap. A tracking app alerts you before it becomes a problem.
• Want digital supervisor signatures: Chasing physical signatures every week is tedious. A tracking app lets you email a signature link to your supervisor.
• Want automatic form export: If the thought of manually copying 150+ weeks of data onto BBS forms makes you anxious, a one-click PDF export removes that entire risk.
• 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.

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 — every feature maps directly to a BBS requirement.

Pricing starts at $4.95/month for pre-degree trainees and $7.95/month for associates. Every plan includes a 30-day free trial with full access. Monthly billing, no lock-in — you can cancel anytime. To learn more about California hour requirements, see our California LMFT hours requirements guide.

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. For most associates, this takes less than 30 minutes for a year of data.

Here is the recommended approach:

1. 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.
2. Set up your sites and supervisors. Add every work setting and supervisor you have had, including past ones you are no longer working with.
3. Enter historical weeks in batches. Work through your spreadsheet chronologically. For each week, enter the supervisor, site, and hour totals. The app validates each entry as you save it.
4. Check the dashboard. Once your historical data is entered, the dashboard will show your progress, projections, and any compliance issues it detected in your existing data. This alone can surface errors you did not know you had.
5. 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.