If you searched for an LCSW hour tracking spreadsheet or a BBS hours template, you're doing the responsible thing. A spreadsheet is free, familiar, and entirely yours. For recording sessions and adding them up, it works, and associates have carried one all the way to licensure.

So this is not an argument that spreadsheets are useless. It is a map of exactly where they stop working, because the California BBS does not grade your total. It grades your hours against rules that operate on weeks, categories, and dates, and every one of those rules fails silently in a grid of cells.

What a spreadsheet records

Dates, durations, categories, and a running total. Honest arithmetic on whatever you type into it.

What the BBS checks

Whether each week was properly supervised, whether hours landed inside category floors and ceilings, and whether the dates fall inside the windows that make hours creditable.

Four rules a formula never checks

The 10-hour tier rule

Any week with more than 10 hours of direct clinical work requires two supervision units instead of one. A unit is one hour of individual or triadic supervision, or two hours of group. Catching this means comparing your weekly clinical total against your supervision log, every single week, and no cell formula is watching. Miss the second unit in a busy week and that week's clinical hours are vulnerable at review.

Weekly credit caps

The BBS credits at most 40 hours of experience and 6 hours of supervisor contact in any single week. Log a 48-hour week and your spreadsheet total rises by 48, but the board counts 40. Nothing flags the overage, so your running total quietly drifts above what will actually credit, and the gap surfaces at application review, when it costs the most. The same 40-hour cap is why the licensure timeline has a hard floor.

Category floors and ceilings

The LCSW's 3,000 hours are not one bucket. At least 2,000 must be clinical, at least 750 of those must be face-to-face psychotherapy, and no more than 1,000 non-clinical hours count. A totals column can read 3,000 and look finished while a category underneath sits hundreds of hours short. The full set of floors and caps, with citations, is in our California LCSW requirements guide.

The date rules

Hours worked between your degree award and your registration being issued count only if the BBS received your registration application within 90 days of the degree. And hours must generally be earned within the six years before the board receives your licensure application, so old hours fall out of your total. A spreadsheet stores dates. It never evaluates them.

These failures share a shape: the spreadsheet keeps agreeing with you while a rule you are not looking at removes hours from your total. You find out when the BBS reviews your application, which is the most expensive possible moment to learn it.

What validation looks like instead

Licentio checks every hour you log against the BBS rules for your license type: category floors and caps are enforced automatically, weekly credit caps and supervision cadence are tracked in real time, and your supervisor's credential is checked at the time of service. When an entry does not qualify, you get instant feedback and a clear explanation, not a surprise months later. See the features page for the full picture.

If you keep the spreadsheet

A spreadsheet plus discipline can work. But be clear-eyed about what the discipline is, because it is the part the template never mentions.

Every week, compare your direct clinical total against your supervision log for the tier rule. Every week, confirm you stayed inside the 40-hour and 6-hour caps, and discount anything over. Every month or so, reconcile each category against its floor or ceiling, not only the grand total. And keep one eye on the calendar for the 90-day window at the start of your hours and the six-year window at the end. That is the real job, and it is why hour tracking matters more than it first appears. The arithmetic was never the hard part.

Key takeaway

A spreadsheet records what you did. It cannot tell you whether it counts. The rules that decide (weekly supervision tiers, credit caps, category floors, and date windows) all fail silently in a grid of cells. Pick a method that checks the rules on every entry, or commit to checking them yourself every week.