ZorantaGuides
CertAlert

CertAlert › Guides

Continuing Education Tracker: Build a CE Log for Audits

A continuing education tracker is a log with one row per course and a running total compared with what your board requires for the current renewal period. Record the course, provider, completion date, hours and credit type as soon as you finish, save the certificate in a folder named for that renewal cycle, and check the total against the requirement a few months before your license expires.

Here is the layout, a worked example of the totals, and the details boards tend to ask about.

A document wallet with certificates and cards beside a phone photographing one

Continuing education tracker layout

Use a spreadsheet or a single document. Start a new tab or section for each renewal period, labeled with the start and end dates of that cycle, so hours from the last cycle don't get counted twice.

ColumnWhat to record
Course titleAs printed on the certificate
ProviderWho ran it, and the provider or approval number if there is one
Completion dateThe date on the certificate
HoursContact hours or CEUs, exactly as the certificate states
Credit typeGeneral, ethics, pain management, state law or another category your board names
FormatLive, online, self-study, conference
Certificate savedYes / no, and the file name
CostCourse fee, travel, materials

Credit type matters because many boards require a set number of hours in specific subjects, not only a total. A tracker that only adds up all hours can show you are done when a required subject is still missing.

CertAlert

CertAlert does not count CE hours. It tracks the license or certification itself: expiration date, a reminder set well ahead, notes on what renewal needs, and photos of documents. Get it on Google Play

Totaling hours against your requirement

Put the requirement at the top of each cycle's tab, broken down by category, then add a total for each category below the log. In a spreadsheet, SUMIF does the work: =SUMIF(E:E,"Ethics",D:D) adds the hours in column D for rows marked Ethics in column E.

Category (example)RequiredCompletedStill needed
General20146
Ethics202
State-specific topic220
Total24168

The numbers above are an example, not any board's actual requirement. Your board's rules page gives the totals, the categories, and limits such as how many hours can be self-study or carried over.

CEU vs contact hours

Certificates may list hours in contact hours or in CEUs. Under the IACET standard, one CEU equals ten contact hours, so a course listed as 0.3 CEU is three contact hours. Some boards count credits their own way, so check how your board wants hours reported before you convert.

CEU tracker template habits that make audits easy

Boards often audit a sample of licensees after renewal and ask for proof of the hours you attested to. If your log and certificates are in order, an audit is a matter of sending files.

  1. Log the course the day you finish it, while the certificate is in your inbox.
  2. Save the certificate as a PDF or photo with a consistent name: date, provider, course, hours.
  3. Keep certificates for at least as long as your board says it can audit, which may be longer than one cycle.
  4. Check whether your board requires courses from approved providers; note the approval on each row.
  5. Review the totals when you set your renewal reminder, not in the final week.
This is general information. CE requirements, approved providers and record-keeping rules are set by each licensing board and certifying body and can change. Check your board's official rules before relying on any total.

Continuing professional development tracker for several credentials

If you hold more than one credential, for example a state license and a national certification, each may have its own cycle, required hours and accepted courses. One course can sometimes count toward both. Add a column for each credential and mark which one a course applies to, so you can total each separately.

Keep the renewal dates of every credential at the top of the tracker. The CE deadline is effectively the renewal date minus the time the board or certifying body needs to process your application, and minus any time it takes a provider to issue the certificate.

CertAlert

Know when the CE deadline is coming

Add each license to CertAlert with its expiration date and a reminder months ahead, and use the notes to keep the CE hours your board asks for.

Get it on Google Play

iPhone version coming soon

More guides

All guides

Sources

Published by Zoranta, the developer of CertAlert.