Almost everyone tracks supervised hours in a spreadsheet, and almost everyone's spreadsheet has a quiet error in it. Usually the same handful of errors, discovered late, when reconstructing eighteen months of Tuesdays from a calendar and a vague sense of what happened.
Here's what tends to go wrong, what the rules are actually counting, and what a log needs to do to survive scrutiny.
Requirements differ by state, board, and track, and they change. The California figures below are quoted from the Business and Professions Code as it read on September 1, 2026, and are here to show the shape of the problem. They don't override your board's current handbook, the current statute, or your supervisor's guidance. Read the primary sources yourself and check them with the people responsible for signing your paperwork.
The four failure modes
Categories collapse. Hours aren't one number. Boards distinguish direct client contact from supervision, individual supervision from group, and clinical work from non-clinical activity, and each has its own minimum, its own cap, or both. A single "hours" column can't answer the question the board is actually asking.
Caps get discovered at the end. Many categories are capped: only so many hours of a given type will count, no matter how many you log. If you're tracking raw totals, you find out about the cap when you submit, and a chunk of real work turns out not to count. The number you need visible is creditable hours, which is the smaller of what you did and what's allowed.
Pre-degree and post-degree get mixed. Practicum hours earned before your degree and hours earned after are governed by different rules and often different limits. Once they're combined in one column, separating them means going back through the dates.
The log stops matching reality. Sessions get cancelled, a placement ends early, a supervisor changes. If the ledger is a spreadsheet updated on Sundays when you remember, the gap between it and what happened widens quietly for months.
What California actually counts
California is a useful worked example, because the LMFT rules are unusually explicit about their ceilings. Business and Professions Code §4980.43(c) sets out, among other things:
- A minimum of 3,000 hours completed during a period of at least 104 weeks. Two numbers, not one. You can't compress the calendar by working harder.
- A minimum of 1,750 hours of direct clinical counseling, which must include not less than 500 hours of experience diagnosing and treating couples, families, and children.
- A maximum of 1,300 hours obtained before the award date of the qualifying degree, and within that, a maximum of 750 hours of counseling and direct supervisor contact before the award date.
- A maximum of 1,250 hours of nonclinical practice, a category that bundles direct supervisor contact, administering and evaluating tests, writing clinical reports, writing progress or process notes, client-centered advocacy, and workshops, seminars, training sessions, or conferences.
- A maximum of 1,200 hours gained under the supervision of a licensed educational psychologist.
- A six-year window: hours "shall not have been gained more than six years prior to the date the application for licensure was received by the board," with a limited exception for up to 500 hours from a required practicum.
Read that list as a set of interacting constraints rather than a checklist, because that's how it behaves.
The week is the unit of accounting
This is the part spreadsheets are worst at, and it causes the most retroactive damage.
Supervision in California is credited by week and by work setting, not as a running total. §4980.43.2(a) requires "at least one hour of direct supervisor contact in each week for which experience is credited in each work setting." A week without its supervision hour is a week whose experience isn't credited, and no amount of supervision next month repairs it.
Two further rules sit on top of that, and they are not the same rule:
- For trainees, paragraph (2): "an average of at least one hour of direct supervisor contact for every five hours of direct clinical counseling performed each week in each setting."
- For associates, paragraph (3): anyone "who performs more than 10 hours of direct clinical counseling in a week in any setting shall receive at least one additional hour of direct supervisor contact for that setting."
Those get conflated constantly, including by websites that summarize them. They apply to different people and they do different arithmetic. If you're an associate, the trigger is a threshold. Cross ten direct hours in a setting in a week and you owe a second unit for that setting. If you're a trainee, it's a ratio, averaged.
Both paragraphs carry the same ceiling: for experience gained on or after January 1, 2009, "no more than six hours of supervision, whether individual, triadic, or group, shall be credited during any single week." A heavy supervision week doesn't bank credit toward a thin one.
The practical consequence is that a log organized by session cannot answer the question the board asks. The board asks a question about weeks. If your records are a list of appointments, every weekly determination is something you reconstruct later, from a calendar, under time pressure, about a period you no longer remember clearly.
Three ways the arithmetic bites
A category can be full while a requirement is unmet. Nonclinical practice is capped at 1,250 hours, and that cap covers a wide range of real work: report writing, progress notes, advocacy, training. Direct supervisor contact also lives inside it. So supervision hours consume a budget that your note-writing and your workshops are also drawing down, while the 1,750-hour direct counseling minimum is untouched by any of it.
Hours can be earned, uncreditable toward one thing, and creditable toward another, all at once. A pre-degree hour past the 750-hour counseling-and-supervision sub-limit is still an hour you worked, may still count inside the broader 1,300-hour pre-degree allowance depending on what it was, and is not going to move your direct-counseling number. Summing a column cannot produce that answer. Only encoding the actual rules can.
Hours expire. The six-year window is the failure mode people don't see coming, because nothing about it is visible in a running total. A log that shows "2,940 of 3,000" while several hundred of those hours are aging out of eligibility is worse than no log, because it is confidently wrong. Any ledger worth keeping should be able to tell you how many of your hours are still inside the window, and when the oldest ones leave it.
What a defensible log has
- Every entry categorized at the time it's created, not sorted out later.
- A weekly view, per setting, because that is the unit the rules are written in.
- Both raw and creditable totals, so you can see when a cap is biting.
- Pre-degree and post-degree kept structurally separate.
- Supervisor and site attached to each entry. You will be asked, and remembering which supervisor signed which stretch two years later is genuinely hard.
- An expiry view, so the six-year window is a number you watch rather than a surprise.
- An export your board will accept, itemized rather than summarized.
- Progress against the requirement, not just an accumulating number. "412 hours" means nothing on its own; "412 of 1,750, with individual supervision at 78% of its minimum" is a status you can act on.
That last one is the difference between a record and a tool. A log that only accumulates tells you what you did. A log that measures against the requirement tells you what to do next month.
How Flowers handles it
Flowers tracks hours toward licensure as a first-class feature rather than an add-on. California BBS requirements are built in for the LMFT track with the categories, caps, and deadlines encoded. The pre-degree and nonclinical ceilings are applied to creditable totals rather than left as a raw sum, and the six-year window is tracked as its own number, including hours that are approaching it rather than only ones that have already aged out. For the LCSW and LPCC tracks, or any other state, generic tracking gives you a clean itemized ledger plus custom targets you define to match your board's handbook.
Because the rules are written in weeks, the export is too: it generates weekly rows and the experience-verification form, one per supervisor, as a PDF you can take to be signed.
It's free for up to 15 active clients, which covers most practicum caseloads, and it runs entirely on your own Mac. That matters more than usual when the records in question belong to a placement site with its own rules about where client data may live.