Back to blog
Jobs, stock and customers

Employee certification tracking: how to catch licenses before they expire

Employee certification tracking: an expiration date tracker sheet with a days-left formula and color rules, a 90-60-30 routine and what software costs.

Turn your spreadsheet into an app

Upload an Excel or CSV file. Free, no account needed.

Upload a spreadsheet
On this page

To track employee certifications and licenses, keep one expiration date per person for each certification, work out how many days are left, and color anything due within 90 days. Review the list every week. Book each renewal at 60 days and tell a manager at 30. A spreadsheet handles a small crew; software adds reminders.

This guide is for the office, safety or human resources (HR) manager at a trades, pest control or field service company with 10 to 100 people. It gives you an expiration date tracker to copy for Excel or Google Sheets, with a days-left formula and color rules. Then a renewal routine, what certification tracking software costs and how to build your own. If your list is already in a spreadsheet, our spreadsheet to app upload turns it into an app, with no account needed to try.

How we researched this: checked November 2026, from each vendor’s own pricing and product pages, and from the Occupational Safety and Health Administration (OSHA) rules in the Code of Federal Regulations (CFR) and the Environmental Protection Agency (EPA) on their own sites. Prices change often. This guide isn’t legal advice: your state, insurer and customers set many renewal dates, so the date on the card wins.

Which option fits depends on your crew:

If this sounds like youStart with
A small crew, and one person who looks every weekA spreadsheet. It’s free, and the sheet above is all it takes
A sheet nobody opens, or you want a portal for staffSoftware to track employee certifications and email reminders. Prices are below
Your own certifications, crews and rules about who sees whatAn app of your own, started from your spreadsheet

Which certifications and licenses should you track?

Track the dates that decide who is allowed to do which job. Most trades, pest control and field service companies track these:

CredentialWhere the date comes from
State or local trade, contractor or pest control licenseYour state agency, which says which classes count (EPA on applicators)
Driver’s license and Department of Transportation (DOT) medical cardThe card. Our vehicle inspection checklist covers daily checks
Forklift evaluationOSHA: at least every three years (29 CFR 1910.178(l)(4)(iii))
Respirator fit testOSHA: before first use and “at least annually thereafter” (29 CFR 1910.134(f)(2))
First aid and cardiopulmonary resuscitation (CPR)The card from the class provider
Vehicle registration and insuranceThe paper. Use the same sheet, with trucks in place of people
Anything a customer or insurer asks to seeThe contract or policy

For forklifts, OSHA also says the employer’s certification names the operator, the training and evaluation dates and who did them (29 CFR 1910.178(l)(6)). Check the standard that applies to your work. A tracker shows the date; it doesn’t make anyone compliant.

A job’s permit and inspection dates belong on the work order; see our electrical work order guide. For a monthly safety walk-through, see our OSHA inspection checklist.

For each one, keep five things:

  • The expiration date. The date printed on the card or license, not the day someone took the class.
  • Whether it applies. Write “n/a” where a job doesn’t need it. Leave a cell empty only when someone needs it and you have no date, because an empty cell is a hole you want to see.
  • Where the proof is, and who issued it. A folder, a scan or a photo of the card, and the agency or class provider.
  • Whether a renewal is booked, and for which class or exam date. If renewal needs class hours or a fee, note that too.
  • Who to tell. The person and their supervisor.

How do you track employee certification expiration dates in Excel or Google Sheets?

Give each person a row and each certification or license a column, and put the date it expires in the cell. The formulas work the same in Excel and Google Sheets, and the same layout works as a license tracking spreadsheet or a certification tracking spreadsheet.

  1. Paste the layout. Copy this into cell A1 of a new sheet, then replace the sample row with your people. Excel and Google Sheets both split the text at each tab. The columns are A Employee, B Role, C to H one certification each, I Next to expire, J Days left and K Notes.

    Employee	Role	State license	Driver's license	First aid and CPR	Respirator fit test	Forklift evaluation	DOT medical card	Next to expire	Days left	Notes
    Marcus Reed	Lead technician	6/30/2028	4/9/2029	1/22/2027	9/14/2027	n/a	n/a	=IF(COUNT(C2:H2)=0,"",MIN(C2:H2))	=IF(I2="","",I2-TODAY())	Class booked Dec 10, $85. Card in the HR folder.
  2. Check that the dates are real dates. A real date lines up on the right of its cell. Text lines up on the left and won’t count. Type n/a where someone doesn’t need a certification.

  3. Fill the two formulas down to your last person. Here they are on their own, in case you’d rather type them:

    Next to expire (cell I2)
    =IF(COUNT(C2:H2)=0,"",MIN(C2:H2))
    
    Days left (cell J2)
    =IF(I2="","",I2-TODAY())

    Next to expire picks the earliest date in the row and skips empty and n/a cells. Days left counts from today, so a negative number means it has already expired. If Next to expire shows a number like 46409, format that column as a date. If Days left shows a date, format it as a number.

  4. Add the color rules below to the date cells.

  5. Sort by Days left each week, fewest first, so the people who need attention are on top.

For the colors, select C2:H500 so C2 is the top-left cell, then add a rule that uses a formula:

  • Excel: Home, Conditional Formatting, New Rule, then “Use a formula to determine which cells to format.”
  • Google Sheets: Format, Conditional formatting, then “Custom formula is.”

Add these four rules, one formula each:

Red: 30 days or less, or past
=AND(ISNUMBER(C2),C2-TODAY()<=30)

Red: empty for someone on the list
=AND($A2<>"",C2="")

Amber: 31 to 90 days
=AND(ISNUMBER(C2),C2-TODAY()<=90)

Green: more than 90 days
=ISNUMBER(C2)

Order matters, because where two rules are true the one higher in the list wins. Check that red sits on top, amber under it and green last. Excel puts each new rule on top, so add green first and red last (Microsoft). Google Sheets applies the first true rule in the order listed (Google).

Two more formulas worth having:

  • Only know the class date? =EDATE(C2,36) gives the date three years later. Use 12 for a year, 24 for two.
  • How many people are due? =COUNTIF(J2:J500,"<=30") counts the people with something due in 30 days or less, or already past.

Once the sheet has a dozen certifications or more, switch to one row per certification held: employee, certification, date. The same formulas work, but you lose the grid, and the grid is what shows who has a hole.

How far ahead should you renew? The 90, 60 and 30 day routine

Pick one routine and run it on the same day every week. Ten minutes on Monday is enough: sort by Days left and work down from the top. Software can send reminders at the same marks. HCSS, for one, gives 30, 60 or 90 days out as examples for its automatic notifications (HCSS).

  1. 90 days: plan it. Put the renewal on the calendar and find out what class or exam it takes.
  2. 60 days: book it. Book the class or exam. Tell the person and their supervisor the date.
  3. 30 days: escalate. Not booked? Tell the manager, who decides who covers the work.
  4. Expired: keep them off the job. Anyone with an expired card stays off any job that needs it until the new date is in the sheet.

Starting early leaves room for a missed class. For a state license, 90 days is also when to check continuing education hours: many licenses need them, and a state can take weeks to process a renewal.

When the renewal is done, type the new date over the old one and file the new card where your proof lives. Once a quarter, check the sheet against the cards in the drawer, and check each license against the issuer’s own lookup where it offers one.

A sheet changes color only when someone opens it, so give the Monday review an owner and a repeating calendar event. If it keeps slipping, look at tools that email for you.

What does certification tracking software cost?

Certification tracking software, sometimes called a certification tracking system, keeps each person’s licenses and certifications with their expiration dates, emails reminders before they run out and stores proof such as a scan of the card. Here is what each vendor’s own pages showed in November 2026. Five of the six publish a price. HCSS quotes on request.

OptionWhat it costsSuits
A spreadsheetFree in Excel or Google SheetsA small crew and one person who opens it weekly
RemindaxFree for 15 items, 3 contacts. $29 a month for 200 itemsVery small teams that want emailed reminders. $23 billed yearly
Expiration Reminder$49 a month for 150 items, $99 for 600Reminders, a staff portal and proof with each date. About 10% off yearly
CertTracker$49 a month up to 50 employees, $99 up to 200Priced by headcount, not items. 14-day free trial
Certemy$2.40 to $3.00 a user a month for its entry planPer-person pricing, contact sales. Lists field service among its industries
HCSS SafetyNo published price. Quote on requestConstruction contractors
TalentLMSFree for 5 users. $119 a month for up to 40, billed yearlyTeaching courses online, not tracking outside licenses
An app of your own (GoodTaco, our product)Free to start. Pro, with 10 users, is $49 a monthA tracker shaped like your company, from your sheet

Remindax and Expiration Reminder size their plans by “items,” and each counts them its own way. Expiration Reminder says an item “tracks a document with an expiration date” (its help page). A training system tracks the courses taken inside it: TalentLMS describes automations that reset and reassign a course when its certificate expires (TalentLMS), which helps with classes you teach and does nothing for a state license.

Start by checking whether the field service or payroll software you already pay for has a place for staff licenses. If it doesn’t, Remindax and Expiration Reminder are the two to look at first for a crew this size: they price by item, not by person, and both email reminders. For 40 people with five certifications each, the prices run from about $23 to $120 a month.

When does a certification tracking spreadsheet stop working?

A spreadsheet is a fine start, and for a small crew it can stay one. It starts to fail in five places:

  • Nobody opens it. The colors change only when someone looks. The sheet won’t email or text anyone.
  • Everyone sees everything, or only you do. Supervisors want their own crew’s dates, and nobody wants every driver’s license date passed around the office.
  • Someone types over a date and nobody notices.
  • The proof lives somewhere else. Cards sit in an email, a phone’s photos and a desk drawer.
  • The grid outgrows a screen. Past a dozen certifications or a hundred people, a page for each person beats a row. Our guide to database vs spreadsheet covers when that point comes.

So stay on a spreadsheet while a small crew has one owner who opens it weekly. Choose software when you want emails that go out without you, or a portal for staff. Build your own app when you want the tracker to match your company, such as your certifications and crews. You change it by chatting.

How do you build your own certification tracker?

With an AI app builder, you describe the tracker or start from the sheet you already keep, then change it by chatting. To plan yours:

  1. List the certifications that decide who can do which job. Start with the six columns in the sheet above and change them.
  2. Decide who sees what. Dates and license status are staff records. Supervisors who sign in are either part of your GoodTaco workspace or invited to a private app. Keep your app private.
  3. Start from what you have: your spreadsheet, or a description in plain words.
  4. Test with a real month. Put in this month’s real dates and check the list against the cards in the drawer.

Track certifications with GoodTaco

Marcus Reed’s first aid card runs out on January 22. Upload the sheet above and GoodTaco builds a tracker with its own built-in database, where he shows up as due, soonest first, with expired dates marked. A paying GoodTaco customer, a pest control company, built a dashboard for license compliance.

Start from what you have:

  • Upload your tracking sheet. No account is needed to try it. The dates go into the app’s own database. Ask for a list that puts expired and due-soon dates first.
  • Or describe it in plain words. Say who you track, which certifications, and what you want to see. GoodTaco builds the screens.
  • Or, to keep working in the sheet, connect your Google Sheet. With the Google Sheets app builder, the app reads and writes the sheet you already keep.

The tracker in this preview is an example of what asking can make, not a screen from a template:

Every version is saved, so you can roll back with one click. The app opens in any browser, including a phone’s. Want each person to see only their own dates? Ask GoodTaco to show each signed-in person only their own record.

To get a reminder email from a tracker on your connected Google Sheet, connect your Gmail account on GoodTaco’s Integrations page first. It gets permission to send from the account, not to read it. Then type this into the chat beside your app:

Every Monday morning, email me everyone whose certification expires in the next 90 days, soonest first.

The email comes from the Gmail account you connected. Ask for a different day, or for 60 or 30 days instead, in the same sentence.

No sheet yet? Start from the employee directory template. It’s a staff directory, with people search, an org chart and a phone list, that has room for your own date columns. Sign up free and you get your own copy. Its sample is a building supply company, so clear it first. Here is how it handles certifications:

  • A date column for each one. HR adds it, named so it says when it runs out, like “State license expires.” A column called just “State license” stays off the list until you switch on Show in Dates coming up. HR means you, as the app’s owner, and anyone you mark “Can edit the directory” on their record.
  • Dates coming up. On the Manage page, under Needs a look, HR sees dates that have passed or fall in the next 60 days, soonest first, with the past ones flagged.
  • Pasting your staff list. Put the column names on the first line, then choose “Keep as a new column, HR only” for each certification. A column becomes a date column when at least four in five of its filled cells are dates, so clear the n/a cells first. Columns named like a Social Security number, a bank account or a “license number” are left out on purpose, so keep those numbers in your proof folder.
  • Who sees it. Each column is HR only or open to everyone. The app shows nothing to anyone who isn’t signed in, and people can update their own details while HR changes everything else.
  • Proof. Add a Link column and paste the address of the scan in your shared folder. Type “forklift” in the search and you get everyone with a forklift date on file, and anyone whose job title or skills mention it.

Ask GoodTaco for a green, amber and red grid and a 90-day window.

GoodTaco is free to start. Paid plans start at $9 a month, and Pro at $49 a month includes 10 users; bigger teams talk to us about Enterprise.

See every renewal coming before the date passes. Start free, no credit card needed.

Frequently asked questions

What is the best way to track employee certifications?

Keep one expiration date per person for each certification, work out the days left, and color anything due in 90 days or less. Review the list every week, book renewals at 60 days and tell a manager at 30. A spreadsheet works for a small crew. Software or an app of your own adds reminders and a place to keep proof.

How do you track employee certification expiration dates in Excel or Google Sheets?

Give each person a row and each certification a column, with the date it expires in each cell. Add a Days left column that subtracts today's date from the earliest date in the row, then add color rules: red at 30 days or less, red for an empty cell someone needs, amber at 90 days or less and green after that. The same formulas work in Excel and Google Sheets.

Which certifications and licenses should you track?

Track the dates that decide who may do which job: state and local licenses, driver's licenses and DOT medical cards, forklift evaluations, respirator fit tests, first aid and CPR, and anything a customer or insurer asks to see. For each one, keep the expiration date, whether it applies, where the proof is and who issued it, whether a renewal is booked, and who to tell.

How much does certification tracking software cost?

In November 2026, Remindax was free for 15 items and 3 contacts, then $29 a month for 200 items. Expiration Reminder started at $49 a month for 150 items. CertTracker started at $49 a month for up to 50 employees. Certemy listed $2.40 to $3.00 per user per month for its entry plan and asked buyers to contact it. HCSS Safety publishes no price. TalentLMS, a training system, charged $119 a month billed yearly for up to 40 users on its first paid plan.

Is there free certification tracking software?

A little. Remindax has a free plan for 15 tracked items and 3 contacts, TalentLMS has one for 5 users and 10 courses, and Excel or Google Sheets cost nothing if you already have them. GoodTaco is free to start, and you can try turning your tracking spreadsheet into an app without an account.

How far ahead should you renew certifications?

A simple routine is 90, 60 and 30 days. At 90 days, put the renewal on the calendar. At 60, book the class or exam. At 30, tell a manager if it isn't booked. HCSS gives the same 30, 60 or 90 day marks as examples for its alerts. Your state, insurer or customer may set its own deadline, so check the rule that applies to the job.

Can I build my own certification tracker?

Yes. With an AI app builder such as GoodTaco, you upload your tracking spreadsheet or describe the tracker in plain words, then change it by chatting. You can also start from the employee directory template, which lists dates that have passed or fall in the next 60 days. With a connected Google Sheet, ask GoodTaco to email you what is coming due each week from your connected Gmail.

Free · no account needed

Turn your spreadsheet into an app

Upload an Excel or CSV file and we’ll build an app around your records, with its own database. Free, no account needed.

Upload a spreadsheet

No file handy? Start from a template

Keep exploring

Related guides and templates

View all articles

Industry

Build PTO Tracking Software From Your Spreadsheet

Build PTO tracking software, an employee onboarding system, and leave tracking from the spreadsheets your HR team already runs. No onboarding. No setup fee.

Guide

How to track expenses for a small business: receipts to apps

How to track expenses for a small business at each stage: receipts, a spreadsheet, then an expense tracking app with approvals your team can use.

Template

Google Sheets timesheet template with hours and approvals

A Google Sheets timesheet template for daily hours and manager approvals. Connect your sheet and GoodTaco turns it into a time tracking app for your team.

Guide

PTO tracker: a free spreadsheet with formulas that add it up

A PTO tracker for 8 to 40 people: sheets to paste, accrual, carryover and sick-time formulas, a who's-out view, and when payroll software pays off.