A certification tracking spreadsheet layout
Put each license, certificate, card or permit on its own row. If a credential has a separate card (for example a CPR card and the instructor certificate behind it), give each one a row, because they can expire on different dates.
| Column | What goes in it | Example |
|---|---|---|
| Credential | The name as it appears on the card | BLS Provider |
| Issuer | Board, agency or training body | American Heart Association |
| ID number | License or certificate number | BLS-48213 |
| Issued | Issue date, entered as a real date | 03/14 |
| Expires | Expiration date, entered as a real date | 03/31 |
| Days left | Formula (see below) | 41 |
| Start renewal by | Expires minus your lead time | 01/30 |
| Renewal needs | Course, exam, CE hours, fee, form | Skills check + online module |
| Renewal cost | Fees you expect to pay | 65.00 |
| Where the file is | Folder or photo of the card | Drive / Certs / BLS |
The dates in the example column are shown without the year to keep the table short. In your sheet, enter full dates so the formulas can work with them.
CertAlert keeps the same list on your phone: each credential's expiration date, a reminder set days before it, and a dashboard colored by how soon each one expires. Get it on Google Play
Formulas for days left and renewal start
Both Excel and Google Sheets treat dates as numbers, so subtracting today's date from the expiration date gives the days left. If the expiration date is in column E:
- Days left: =E2-TODAY()
- Start renewal by: =E2-60 (replace 60 with the lead time that credential needs)
- Status: =IF(E2="","No expiry",IF(E2<TODAY(),"Expired",IF(E2-TODAY()<=30,"Due soon",IF(E2-TODAY()<=90,"Plan","OK"))))
Format the Days left column as a plain number, not a date, or the sheet will show a strange date instead of a count. If a date was typed as text (for example "March 31" with no year), the formula returns an error. Re-enter it with the date picker or in your regional date format.
Color rules
Add conditional formatting to the Days left column so urgency shows at a glance:
- Select the Days left column.
- Add a rule: less than 0, red fill.
- Add a rule: between 0 and 30, orange fill.
- Add a rule: between 31 and 90, blue or yellow fill.
- Sort the whole sheet by the Expires column, earliest first.
How to keep track of certifications without missing one
A spreadsheet only tells you something when you open it. The weak point is rarely the formula; it is the month nobody opened the file. Three habits close that gap.
Pick a lead time per credential, not one for all
A first aid card may need a single class. A professional license can need continuing education, a background check and board processing time. Set the Start renewal by date from what the renewal actually involves, and check the issuer's site for its renewal window, since some boards only open renewal a set time before expiry.
Review on a fixed day each month
Choose one date, such as the first working day of the month, and put a repeating calendar event on it. Open the sheet, look at anything under 90 days, and do one concrete thing for each: book the class, order the transcript, pay the fee.
Update the row the day you renew
When the new card arrives, change the expiration date, attach a photo or scan of the new card, and note what you paid. An old date left in the sheet is how a renewed credential later looks expired, and how an expired one looks fine.
When a certification tracker template stops being enough
A template works well for a handful of credentials checked by one person. It gets harder when:
- You hold credentials with very different renewal cycles and lead times
- You need a reminder on your phone at a specific number of days before expiry, not only when you open a file
- You want the renewal history and the cost of each renewal in one place
- You switch between a laptop and a phone and the copies drift apart
At that point some people add calendar events for every Start renewal by date, and others move the list into a tool built for expiration reminders. Either way, keep the same fields: name, issuer, expiration date, what renewal needs and where the proof is.
Let the reminder find you
Add a credential to CertAlert with a name and expiration date, and it schedules a reminder ahead of the deadline. When you record a renewal, it suggests the next expiry date and moves the reminder.
Get it on Google PlayiPhone version coming soon
More guides
- 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.
- Continuing Education Tracker: Build a CE Log for AuditsBuild a continuing education tracker: the columns a CE log needs, how to total hours against your requirement, CEU vs contact hours, and what to keep in case of an audit.
Published by Zoranta, the developer of CertAlert.