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.
| Column | What to record |
|---|---|
| Course title | As printed on the certificate |
| Provider | Who ran it, and the provider or approval number if there is one |
| Completion date | The date on the certificate |
| Hours | Contact hours or CEUs, exactly as the certificate states |
| Credit type | General, ethics, pain management, state law or another category your board names |
| Format | Live, online, self-study, conference |
| Certificate saved | Yes / no, and the file name |
| Cost | Course 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 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) | Required | Completed | Still needed |
|---|---|---|---|
| General | 20 | 14 | 6 |
| Ethics | 2 | 0 | 2 |
| State-specific topic | 2 | 2 | 0 |
| Total | 24 | 16 | 8 |
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.
- Log the course the day you finish it, while the certificate is in your inbox.
- Save the certificate as a PDF or photo with a consistent name: date, provider, course, hours.
- Keep certificates for at least as long as your board says it can audit, which may be longer than one cycle.
- Check whether your board requires courses from approved providers; note the approval on each row.
- Review the totals when you set your renewal reminder, not in the final week.
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.
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 PlayiPhone version coming soon
More guides
- Certification Tracking Spreadsheet: Columns and FormulasSet up a certification tracking spreadsheet that flags what expires next: the columns to use, a days-left formula, color rules and a monthly check routine.
- DOT Medical Card Renewal: Steps, Timing and Expiration DateHow DOT medical card renewal works: when to book the exam, finding an examiner, what to bring, getting the card to your state, and why a grace period is a bad bet.
- When to Renew Your Passport Before It ExpiresWhen to renew a US passport: why six-month validity rules matter more than the expiry date, how to count back from a trip, and who can renew by mail or online.
- Expired Nursing License: Grace Periods and ReinstatementWhat to do if your nursing license has expired: stop work, check your board's late renewal and reinstatement rules, what boards ask for, and how compact licenses fit in.
Published by Zoranta, the developer of CertAlert.