How Sarah Tracked 5 Years of CE Credits in 30 Minutes (Case Study)

A real therapist's migration story: turning 5 years of scattered PDFs, email confirmations, and spreadsheet rows into a clean, audit-ready system.

The Email That Changed Sarah's Afternoon

Sarah is a licensed marriage and family therapist in her eighth year of practice. She holds licenses in two states — Pennsylvania and New Jersey — runs a small private practice out of a converted carriage house, and has three kids under twelve. Like most therapists, continuing education has always been the thing she means to organize later.

In March, an email from the Pennsylvania State Board of Social Workers, Marriage and Family Therapists and Professional Counselors arrived in her inbox. It wasn't an audit notice. It was something almost worse: a routine renewal reminder, and the attached requirement list. 30 hours of CE. 3 hours of ethics. Deadline in 11 weeks.

Sarah's next response is one we hear often: a small panic followed by an opened Google Sheet that hadn't been updated in 18 months, a scroll through two years of Gmail, and a growing realization that she had no idea where she actually stood.

This is the story of what Sarah did next — and how she went from 5 years of scattered records to a fully organized system in a single afternoon. Her real name has been changed. Everything else is true.

The State of the System (or Lack of One)

When Sarah sat down to audit her records, here's what she found:

Google Sheet (primary system): Last updated 18 months ago. 14 courses logged between 2019 and 2023. Missing the course she took at the Psychotherapy Networker Symposium in 2024. Missing two PESI webinars from 2024. Missing her annual ethics course from 2025.

Email inbox: Gmail had 47 emails matching "CE certificate" — including three duplicates, two from providers she didn't remember using, and a handful that were actually renewal reminders, not certificates.

Desktop folder: A folder called "CE 2021" with 8 PDFs. A folder called "CE New" with 3 PDFs. A folder called "License Stuff" with a mix of licenses, CE certificates, liability insurance, and one unrelated W-9 from a supervisor she'd worked with.

Dropbox: A mysterious "Scans" folder from when her office scanner autoscanned everything. 23 files, named things like Scan_20220317_001.pdf. Some were CE certificates. Others were case notes she'd digitized and forgotten about.

Physical binder: Six certificates from in-person conferences. Three of them she'd also received digitally and filed elsewhere.

The total universe of possible CE credits: unclear. The total hours actually completed: unknown. The number of mandatory topics covered: not tracked. The number of courses that would actually verify with the board: terrifying question.

The Plan (30 Minutes, Not 30 Hours)

Sarah's first instinct was the same as most therapists: block off a full weekend, painfully reconstruct five years of records from scratch, and hope she remembered everything. This is the wrong approach. It's slow, emotionally brutal, and tends to generate more anxiety than clarity.

Instead, Sarah did something simpler. She opened HYR Growth Tracker (we'd offered her an extended trial for this case study), added her two licenses, and committed to 30 minutes of focused consolidation. Here's exactly what that 30 minutes looked like.

Minutes 0-5: Configuration. Sarah entered her LMFT license info for both states — credential numbers, expiration dates, renewal cycles. The system pulled up Pennsylvania's requirements (30 hours total, 3 ethics, 2 hours of child abuse recognition one-time) and New Jersey's requirements (40 hours total, 5 ethics). She confirmed the board contacts and saved.

Minutes 5-10: Certificate dump. Sarah opened the Gmail search for "CE certificate" and began forwarding each email to her tracker's upload address. She didn't categorize yet. She didn't worry about duplicates. She just moved every possible certificate into the system. Total forwarded: 47 emails.

Minutes 10-15: Desktop cleanup. Sarah opened each desktop folder and selected all PDFs. She uploaded them directly — 11 files total. The system began automatically extracting course titles, dates, and hour counts from the certificate text.

Minutes 15-20: Dropbox review. Sarah opened the mysterious Scans folder and quickly reviewed filenames and thumbnails. 12 of the 23 files were CE certificates. She uploaded those 12. The other 11 went into a separate personal archive folder.

Minutes 20-25: Physical binder digitization. Sarah grabbed her phone, opened the tracker's mobile app, and photographed the 6 physical certificates. The app auto-cropped and OCR'd each one. Three were duplicates of items she'd already uploaded digitally. Three were new additions.

Minutes 25-30: Review and verification. The system had auto-categorized most uploads. Sarah reviewed the results, confirmed or corrected the category for a handful, and flagged two certificates where the provider wasn't clearly approved in either state.

At the 30-minute mark, Sarah closed her laptop and looked at her dashboard.

What She Discovered

Her numbers told a different story than she'd expected:

Pennsylvania (current cycle, 22 months completed):

  • Total hours: 24 of 30 required. Gap: 6 hours.
  • Ethics: 3 of 3 required. Complete.
  • Child abuse recognition: 2 of 2 required (completed 2021). Complete.
  • Status: 6 elective hours needed before June 30.

New Jersey (current cycle, 18 months completed):

  • Total hours: 31 of 40 required. Gap: 9 hours.
  • Ethics: 5 of 5 required. Complete.
  • Status: 9 elective hours needed before September 30.

Two certificates were flagged as unverifiable — both from a now-defunct online provider who had let their NBCC approval lapse. Sarah would need to replace those 4 hours with alternatives.

Six certificates were duplicates (digital and physical copies of the same course). The system kept one and archived the others.

Before this exercise, Sarah had assumed she was "probably fine" on CE but anxious about the gaps. After 30 minutes, she had exact numbers, a defined path forward, and — critically — a system that would keep her numbers accurate from that moment on.

The Real Lesson

Sarah's story isn't unusual. The 5-years-of-scattered-records problem is the rule for therapists, not the exception. The reason it feels overwhelming is that therapists typically try to solve it by perfecting the past — painstakingly reconstructing every course, verifying every detail, producing a flawless historical record.

That's not the goal. The goal is clarity on current cycle status and a working system for going forward. Sarah's 5 years of records don't all need to be perfect. Only her current renewal cycle needs to be audit-ready. Everything older than her current cycle's retention requirement (typically 4-7 years depending on state) can be archived less rigorously.

Here's what Sarah's approach got right:

She gave herself a time limit. 30 minutes meant she had to prioritize upload volume over perfect categorization. That's the correct order of operations — the system can auto-categorize; only you can decide to open the email.

She didn't try to rebuild the spreadsheet. She moved to a new system and accepted that the spreadsheet was a historical artifact, not the foundation.

She uploaded first, verified later. Trying to verify each certificate before uploading would have doubled the time. Upload everything, then flag the questionable ones for follow-up.

She focused on the current cycle. Her 2019-2020 records were interesting but not urgent. Her 2024-2026 cycle was the one the board would audit. She made sure that was clean.

What Happened Next

Sarah completed her 6 Pennsylvania hours in two weeks using online courses from PESI and CE4Less — both NBCC-approved, both satisfying her state's unlimited online rule. She filed her renewal application 4 weeks before the deadline. Confirmation arrived 8 days later.

She completed her 9 New Jersey hours over the following two months, choosing courses that also double-counted for Pennsylvania's next cycle — building her buffer early.

Most importantly, she's now logging every CE credit as she completes it, not in batches during panic moments. The system that took 30 minutes to set up takes about 2 minutes per course to maintain. Over a 24-month cycle, that's less than an hour of total administrative overhead.

Sarah's old Google Sheet still exists. It hasn't been updated since March. She doesn't need it anymore.


Scattered CE records? Start clean in under an hour. HYR Growth Tracker works across unlimited states, stores every certificate, and tracks mandatory topics automatically. Start your free 14-day trial.