Free · Excel & Google Sheets
Free CNA Certification Tracker Template (Excel & Google Sheets)
A free spreadsheet for nursing homes, assisted living and staffing teams: one row per aide per state registry with the registry expiry, the last day of paid nursing work, a 24-month cut-off worked out with EDATE, the next deadline, in-service hours still needed and CPR card status, all color-coded, with a dashboard and a printable field guide.
In the file
5 sheets · 359 KB · opens in Excel, Google Sheets and LibreOffice
- Start here
- Aides
- Dashboard
- Import to ExpiryEdge
- Lists
Prefer a plain list? The CSV (1 KB) has the same columns and example rows, without formulas or colors.
Preview
The tracker sheet, with example rows
This is the color logic the spreadsheet uses. Move the date to see which rows turn amber or red next.
cna-certification-tracker-us.xlsx
| Aide | Registry state | Next deadline | Act-by date | Days left | Status |
|---|---|---|---|---|---|
| Example – Alex Sample | CA | Nov 30, 2026 | Oct 1, 2026 | 63 | Due ≤90 days |
| Example – Jo Placeholder | IL | Dec 15, 2026 | Nov 15, 2026 | 78 | Due ≤90 days |
| Example – Chris Demo | FL | May 31, 2027 | Mar 2, 2027 | 245 | OK |
| Example – Sam Example | NY | Oct 31, 2026 | Oct 1, 2026 | 33 | Due ≤90 days |
| Example – Pat Placeholder | PA | Sep 30, 2026 | Aug 1, 2026 | 2 | Due ≤30 days |
| Example – Robin Sample | WI | Mar 31, 2028 | Jan 31, 2028 | 550 | OK |
1 due ≤30 days, 3 due ≤90 days, 2 OK. The example dates are fixed, so as real time passes more of them turn amber and red: that is the formula working.
How to use it in 3 steps
Add each aide once per state
Copy the registry expiry and number from the state registry lookup, not from a wallet card. An aide listed in two states gets two rows.
Record the last paid nursing work
Enter the last documented day of paid nursing or nursing-related work. The sheet adds 24 months and uses whichever comes first: that date or the registry expiry. Keep it current for PRN and on-leave aides.
Check the Dashboard every Monday
It counts what has expired or is due within 30 and 90 days, lists the next 10 deadlines, and flags CPR cards and aides short of in-service hours.
What’s inside
- Start here
- How to use it in three steps, the colour key, what every column means and the official sources.
- Aides
- CNA certification tracker (one row per aide per state registry). Filters, dropdowns, frozen header and status colours, with formulas filled down 500 rows.
- Dashboard
- Counts by status, the next 10 dates and extra counts per item, as of today.
- Import to ExpiryEdge
- One row per dated item in the ExpiryEdge bulk-import columns, filled by formula.
- Lists
- The options behind every dropdown. Add your own.
Open it in Google Sheets
There is no shared Google copy to request access to. You import the same file, so you own your copy from the start.
Download the .xlsx
Use the button above. It saves straight to your computer.
Import it into a blank Google Sheet
Open Google Sheets, create a blank spreadsheet, then choose File › Import › Upload and pick the file. Select "Replace spreadsheet".
Check the dates
Formulas, dropdowns and status colors carry over. If your Google account uses a different locale, dates show in that format, which is fine: they are real dates underneath.
Columns explained
Type in the input columns. Calculated columns fill themselves. Columns marked required are the ones the import sheet needs.
| Column | What to enter | Type |
|---|---|---|
| Aide | Full name as it appears on the state registry. One row per aide per state registry. | Input · required |
| Role | CNA, medication aide or other. Edit the list on the Lists sheet. | Input |
| Registry state | Two-letter state code. If the aide is listed in more than one state, add a row for each. | Input |
| Registry / cert no. | Number shown on the registry lookup. | Input |
| Hire date | Start date with you. The in-service year is counted from this date, not the calendar year. | Input |
| Registry expiry | Expiry or renewal date shown on the state registry. Leave blank if your state does not set one (Illinois, for example): the 24-month cut-off is used instead. | Input |
| Last paid nursing work | Last documented day of paid nursing or nursing-related work, here or elsewhere. Update it for PRN and on-leave aides. | Input · required |
| 24-month cut-off | Calculated. Last paid nursing work + 24 months (EDATE). After 24 consecutive months with no paid nursing work, federal rules require new training or a new competency evaluation. | Calculated |
| Next deadline | Calculated. The earlier of registry expiry and the 24-month cut-off. Blank-safe: uses whichever date exists. Shows "Check date" if either date was typed as text. | Calculated |
| Driven by | Calculated. Which date sets the next deadline. | Calculated |
| Lead time (days) | How many days before the date you want to start acting. Leave blank for 30. | Input |
| Act-by date | Calculated. Next deadline minus the lead time: start the renewal, or schedule a paid shift, before this. | Calculated |
| Days left | Calculated. Days until the next deadline; negative once it has passed. | Calculated |
| Status | Calculated. Expired, Due ≤30 days, Due ≤90 days or OK, from the next deadline. | Calculated |
| In-service year ends | Calculated. Next anniversary of the hire date: the end of the current in-service year. | Calculated |
| In-service hrs this year | Hours of in-service training completed since the start of the current in-service year. | Input |
| In-service target (hrs) | Hours required per year. Blank = 12, the federal minimum for nurse aides in certified nursing facilities (42 CFR 483.95(g)). Your state or setting may require more or count differently. | Input |
| Hours still needed | Calculated. Target minus hours done. Red when hours are short and the in-service year ends within 30 days; amber within 90. | Calculated |
| CPR / First Aid expiry | Expiry date on the card, if your facility requires one. Colored by its own date. | Input |
| CPR days left | Calculated. Days until the CPR / First Aid card expires. | Calculated |
| Owner | Who chases this aide's renewal (HR, staff development, DON). | Input |
| Owner email | Who should be reminded. Becomes notification_email on import. | Input |
| Registry lookup link | Link to the state registry verification page, or to the saved printout of the lookup. | Input |
| Notes | Anything the next person needs to know. | Input |
When a spreadsheet stops being enough
For a handful of dates and one careful owner, this template is all you need. These are the signs it has become the wrong tool.
Sign 1
More than one person owns the dates
When several people add rows, dates get typed as text, copies drift apart and nobody is sure which file is current.
Sign 2
Reminders depend on someone opening the file
The status turns red whether or not anyone is looking. If the person who checks it is on leave, the date passes quietly.
Sign 3
You need to prove what happened
An audit, insurer or inspector may ask who was told, when, and where the certificate is. A spreadsheet does not keep that history.
When you would rather not remember
What this looks like when it runs itself
The same row, tracked for you: an owner, reminders at 90, 60, 30 and 7 days by email, SMS, WhatsApp, Slack or Teams, the document on file and a log of who did what. The "Import to ExpiryEdge" sheet in this template is already laid out for Bulk Import, so moving across is one upload.
Try it with your own dates, free for 14 days, no cardExpiryEdge · Tracked item
CNA certification (CA) · A. Sample
ValidOwner
Staff development
Expires
Nov 30, 2028
Reminders before expiry
90d
60d
30d
7d
Due
CNA certification tracker: questions, answered
Because the registry date is not the only deadline. Under the federal rule for certified nursing facilities, an aide who goes 24 consecutive months without paid nursing or nursing-related work must complete a new training and competency evaluation program or a new competency evaluation program (42 CFR 483.35(d)(6)). The sheet adds 24 months to the last paid work date and shows whichever date comes first.
Twelve hours a year is the federal minimum for nurse aides in certified nursing facilities (42 CFR 483.95(g)), and CMS surveyor guidance counts the year from each aide’s employment date rather than the calendar year (State Operations Manual, Appendix PP, F730). Some states and settings set different hours or a two-year cycle, so the target column is editable.
Leave "Registry expiry" blank and the next deadline falls back to the 24-month cut-off. Illinois, for example, does not issue CNA certificates; the Illinois Department of Public Health ties status to paid work instead. Our CNA renewal guide links to the official registry page for each state it covers.
CPR / First Aid has its own column, colored by its own date and counted on the Dashboard. For anything else, add a column or use the Notes column. If you track many certificates per person, the staff training matrix template is built for that.
Yes. Open a blank Google Sheet, choose File › Import › Upload, pick the .xlsx and select "Replace spreadsheet". The formulas use only functions that Google Sheets, Excel and LibreOffice all support (no FILTER, SORT or XLOOKUP), so the status colours, dropdowns and dashboard carry over. The Excel table styling becomes a plain range with filters.
No. A spreadsheet only changes when someone opens it, so the colours are only as good as your habit of checking. Put a weekly calendar slot on it, or move the aides into a tool that sends the reminders for you.
It lists every dated item (the registry deadline, the CPR card and the in-service year end) as its own row in the ExpiryEdge bulk-import columns, filled in by formula. You can ignore it. If you ever move the list into ExpiryEdge, upload the file in Bulk Import and pick that sheet. Nothing is sent anywhere by the file itself.
A free template, not legal advice. It tracks the dates you enter; it does not decide which licenses apply to you. Check requirements against the official source for your situation.