How to Track California Harassment Prevention Training Without an HR Department

You do not need a full HR department to manage California harassment prevention training. You need a reliable employee-level system.

For covered employers, California generally requires training every two years: at least one hour for nonsupervisory employees and at least two hours for supervisors. New nonsupervisory employees generally train within six months of hire, and new supervisors within six months of assuming a supervisory position. California Government Code §12950.1 establishes the core rules, and CRD's current employer guidance summarizes the timing.

The small-company challenge is tracking who needs which course, each employee's due date and completion, reminders, evidence, and retraining.

The smallest useful compliance system is an accurate roster plus reliable follow-through.

Start with one authoritative employee roster

Do not begin with the course. Begin with the people. A practical roster might include:

California does not prescribe this spreadsheet format. These are operational fields designed to make the legal requirements manageable. Use one source of truth.

If hire dates live in payroll, supervisor status in someone's memory, deadlines in a calendar, and certificates across inboxes, nobody can see the whole workflow.

Track work location separately from company location

Company headquarters does not identify which employees belong in the California workflow. CRD says employers must train California-based employees if they have five or more employees anywhere, even when employees work in different locations or outside California. CRD explains that distinction.

• Out-of-state employees can count toward the employer threshold.
• California-based employees are the population CRD identifies for training.
• Employee location can change after hire.

A move into or out of California should trigger a review. See the remote-employee guide.

Make supervisor status an explicit field

Covered nonsupervisory employees generally need at least one hour; supervisory employees generally need at least two. Section 12950.1(a) establishes those minimums. CRD describes supervisors by actual authority, such as authority to hire, fire, assign, transfer, discipline, reward, or effectively recommend actions using independent judgment. CRD summarizes the standard.

Record “Supervisor: Yes / No” instead of inferring it from titles such as Lead, Manager, Head of, Founding Engineer, or Team Lead. The legal classification may be fact-specific, but the system should record the classification the employer uses and update it when facts change.

See the supervisor requirements guide.

Calculate due dates at the employee level

California has multiple timing rules: recurring training every two years; six months after hire for new nonsupervisory employees; six months after assuming supervision for new supervisors; and, for certain workers hired for less than six months, 30 calendar days after hire or 100 hours worked, whichever comes first. Section 12950.1 contains these rules.

CRD's October 2025 guidance identifies January 1, 2027 as the next general deadline but says it may not extend an earlier new-employee deadline. CRD states both points.

Track a real employee-level “Due date,” not merely “Training year: 2027.” See the deadlines guide.

Do not use “completed” as the only training field

A generic checkbox does not show whether the employee took supervisor or nonsupervisor training, when it happened, who provided it, whether evidence exists, or when training is due again.

At minimum, keep the training type, completion date, evidence, and next due date.

“Completed” is a status. A completion record is evidence plus a date.

Use California's free training if it fits your workflow

CRD provides free online supervisor and nonsupervisor courses and says they satisfy Government Code §12950.1. CRD provides the courses here. A small employer therefore does not necessarily need to purchase training content.

Training layer

The employee takes a compliant course.

Administration layer

The employer manages assignment, due date, reminders, completion, evidence, and retraining.

CRD solves the first layer. Your process still owns the second. See what employers still need to manage.

Decide on a reminder cadence before anyone is late

California requires training by the applicable deadline but does not prescribe a reminder schedule. A lightweight process might use an assignment notice, reminders 14, 7, and 1 day before the deadline, and recurring overdue follow-up.

Those intervals are operational choices, not California requirements. The purpose is to establish a repeatable process before the due date. A spreadsheet can store September 1, but it cannot make anyone inspect the row on August 20.

Collect the certificate immediately

CRD tells trainees to save, print, screenshot, or photograph the certificate at the end of its course and warns that it cannot email a replacement. CRD's training instructions state this directly. CRD also says it does not store or track certificates or completion for employers. CRD's employer FAQ explains that limitation.

Do not make “we'll ask later” the recordkeeping strategy. Instead:

1. The employee finishes training.
2. The employee saves the certificate.
3. The employee sends or uploads it immediately.
4. The employer associates it with the employee record.
5. The employer records the completion date.
6. The employer sets the next due date.

Keep the required records for at least two years

CRD says employers must retain training documentation for at least two years, including employee names, dates, sign-in sheets if used, certificates if issued, training type, written or recorded materials, and provider name. CRD summarizes the requirement.

A certificate is not necessarily the entire record. You should be able to retrieve what Employee A completed, when, and the evidence without reconstructing history from email. See the recordkeeping guide.

Handle prior training at onboarding

Section 12950.1 permits certain employees with compliant training from a current, prior, alternate, or joint employer within the prior two years to follow a two-year schedule based on that training, subject to statutory conditions. The current employer bears the burden of establishing compliance. See §12950.1(m).

If relying on prior training, collect completion evidence, date, training type, and provider information during onboarding. “Already trained” is not enough; the prior completion date can determine the next due date.

Build training into three employee events

Event 1: Hire

• Record work location, supervisor status, and hire date.
• Ask about prior qualifying training.
• Determine assignment and due date.

Event 2: Role or location change

• Update relevant fields.
• Revisit the training requirement.
• Recalculate the next action if needed.

Event 3: Completion

• Collect evidence.
• Record completion date, type, and provider.
• Set the next due date.

This makes training administration part of employee lifecycle management instead of a separate project remembered once every two years.

When a spreadsheet is enough

A spreadsheet can work. For a small company with low turnover, a maintained sheet plus calendar reminders may be reasonable when one person owns the process, changes are infrequent, deadlines are reviewed, certificates are stored consistently, reminders are sent, and next due dates are recorded.

California does not require dedicated harassment prevention training software. A spreadsheet is not the problem if someone reliably operates it.

When the spreadsheet starts becoming the problem

Manual systems become fragile as moving pieces increase. Warning signs include multiple roster maintainers, frequent hiring, interstate moves, promotions, manual reminders, emailed certificates, conflicting spreadsheet copies, separated dates and evidence, late discovery of overdue employees, and manually created future calendar events.

The issue is not that spreadsheets are inherently bad; it is that the process has too many handoffs. A dedicated workflow can keep assignments, status, deadlines, reminders, and evidence connected to each employee.

A minimal manual system

One spreadsheet

Track employee, location, supervisor status, hire date, training type, assignment date, due date, status, completion date, evidence link, and next due date.

One evidence folder

Use a predictable naming convention such as lastname-firstname-trainingtype-YYYY-MM-DD.pdf. This is an operational recommendation, not a California requirement.

One reminder system

Create reminders early enough to follow up before the deadline.

One owner

Someone should know they are responsible for keeping the system current. Ambiguous ownership eventually produces an ambiguous spreadsheet.

Practical checklist

1. Create one authoritative roster.
2. Track actual employee work location.
3. Record supervisor status explicitly.
4. Capture hire and supervisor-start dates.
5. Ask about prior qualifying training during onboarding.
6. Record the correct training assignment.
7. Calculate an employee-specific due date.
8. Choose a reminder cadence before the deadline.
9. Keep incomplete and overdue assignments visible.
10. Collect completion evidence immediately.
11. Record the actual completion date.
12. Keep required documentation for at least two years.
13. Set the next due date.
14. Revisit status after promotions or location changes.
15. Give one person clear ownership.

How Beamly can help

A spreadsheet can represent the workflow. Beamly is designed to operate it.

Beamly helps employers organize assignments, track employee-specific progress and due dates, manage reminders, retain completion evidence and compliance records, review status, and maintain audit-oriented records.

That gives small employers a dedicated administrative layer around California's free training instead of splitting the process across spreadsheets, calendars, inboxes, and certificate folders.

Beamly does not provide legal advice, determine legal coverage, guarantee compliance, or replace legal counsel.