BBS Hours Guide

BBS hours spreadsheet vs tracking app

Many California AMFTs, APCCs, and ASWs start with a spreadsheet. Here's when that works, when it doesn't, and what the real risks are over 3,000 hours.

Why spreadsheets are the default

Spreadsheets are free, familiar, and flexible. When you're starting out as a new trainee or associate and money is tight, a Google Sheet or Excel template seems like the obvious choice. Etsy sells California-specific LMFT and LCSW hour tracking templates for $15-30, and several therapists have shared free versions on Reddit.

For the first few months, a spreadsheet works fine. You have one supervisor, one work setting, and the math is simple. But BBS supervised experience requirements get complicated fast — especially once you cross 1,000 hours or add a second site.

Where spreadsheets break down

Supervision ratio violations go undetected

The BBS requires 1 additional unit of supervision for any week you log more than 10 direct clinical hours in a setting. A spreadsheet won't flag this — you'd need a formula checking every row against the supervision column. Most templates don't have this, and a single missed violation can invalidate an entire week's hours.

A/B/C category miscounting

BBS hours fall into specific categories: direct clinical (A), non-clinical (B), and total (C). Each has its own minimum or cap — and they differ by license type. LMFT allows 1,250 non-clinical hours; LCSW allows only 1,000. A miscategorized hour in week 5 won't be caught until you're submitting 3,000 hours to the BBS.

Pre-degree vs post-degree confusion (LMFT only)

LMFT trainees can count up to 1,300 pre-degree hours (750 direct). If your degree award date changes or you misclassify a week, every subsequent total is wrong. Dedicated trackers auto-classify based on your degree date.

Multi-supervisor tracking

The BBS requires separate weekly logs per supervisor per work setting. With two supervisors across two sites, you need four separate tracking streams with independent supervision ratio checks. Spreadsheet complexity scales linearly with settings; app complexity doesn't.

BBS form generation

When it's time to submit, you need to transfer all your data onto official BBS forms (37A-525 for LMFT, 37A-638 for LPCC). This manual transfer is where most errors happen — transposed numbers, wrong row totals, or missed weeks. A tracking app fills these forms automatically.

When a spreadsheet is fine

A spreadsheet can work if:

  • You have a single supervisor in a single work setting
  • You're in the first few months and logging under 500 total hours
  • You're comfortable manually checking supervision ratios every week
  • You don't mind manually transferring data to BBS forms at the end
  • You're an APCC or ASW (no pre-degree hours to track)

If this describes you, a free spreadsheet is a reasonable starting point. But set a reminder to reassess when you hit 1,000 hours or add a second supervisor.

Quick comparison

CapabilitySpreadsheetTracking App
CostFree - $30$4.95 - $8.33/mo
BBS rule validationManualAutomatic
Supervision ratio checkingNoReal-time
Pre/post-degree classificationManualAutomatic
BBS form generationManual copyAuto-filled PDF
Multi-site trackingComplex formulasBuilt-in
Error risk at 3,000 hoursHighLow
Learning curveLowLow

The bottom line

A spreadsheet is fine for getting started. But the BBS doesn't give you a second chance on hour submission — if your totals are wrong or your supervision ratios don't check out, you're resubmitting and potentially losing months. For $4.95/month, a purpose-built tracker eliminates the most common compliance errors and auto-fills the forms you'll submit to the BBS.

HourJourney was built for exactly this. It tracks A/B/C hour categories, validates supervision ratios in real time, auto-classifies pre and post-degree hours, and generates official BBS forms when you're ready to submit.

Frequently asked questions

Can I use a spreadsheet to track my BBS supervised hours?
Yes. The BBS does not require any specific tracking software. Many trainees and associates use Google Sheets or Excel to log hours. However, spreadsheets don't validate BBS supervision ratios, don't auto-classify pre/post-degree hours, and can't auto-fill official BBS forms — so errors are more likely the closer you get to 3,000 hours.
What are the risks of tracking BBS hours in a spreadsheet?
The main risks are: (1) miscounting A/B/C hour categories leading to rejected hours at submission, (2) not catching supervision ratio violations (>10 direct hours without additional supervision), (3) accidentally exceeding the non-clinical cap (1,250 for LMFT/LPCC, 1,000 for LCSW), and (4) misclassifying pre-degree vs post-degree hours for LMFT trainees.
Does the BBS accept hours tracked in a spreadsheet?
The BBS does not review your tracking method — they review the official Experience Verification forms and Weekly Logs you submit with your licensure application. Whether you tracked hours in a spreadsheet or an app, the BBS cares about the final submitted forms being accurate and properly signed.
When should I switch from a spreadsheet to a tracking app?
Consider switching when: you have multiple supervisors or work settings (spreadsheet formulas get complex), you're past 1,000 hours and the stakes of a mistake are higher, you need to generate official BBS forms for submission, or you want real-time validation that your supervision ratios are compliant.
How much does a BBS hours tracking app cost?
Prices range from free (limited) to $200 for 3 years. HourJourney starts at $4.95/month for pre-degree trainees. Over a typical 3-year associate period, that's roughly $178-$286 total — comparable to a single BBS application fee.

Ready to upgrade from your spreadsheet?

Start your free 30-day trial. Import your existing hours and see the difference.

Start free trialTry the free calculator