Lifeguard Certification Tracking Spreadsheet: What to Include

A lifeguard certification tracking spreadsheet should have one row per certificate. Each row shows the course, the issuing body, the verified expiry date, any depth limits, who checked it, and the next renewal step. Check it before every schedule. Don't assume everyone on last month's schedule is still qualified.

Which qualifications should you track?

Start with what the pool and the job require. Under the CDC's 2024 Model Aquatic Health Code (MAHC 6.2.1; check what your state adopted), a qualified lifeguard:

• Passed a lifeguard course the health department recognizes.
• Holds a current certificate for it.
• Finished the site's pre-service training.
• Takes part in the site's in-service training.

Track CPR/AED and first aid as separate rows, even if one course covered them. The MAHC caps lifeguarding and first aid certificates at 2 years and CPR/AED at 1 year (6.2.1.3.5). The Red Cross says its lifeguarding certificates are valid up to 2 years. Under MAHC rules, that means checking CPR/AED dates every year.

What columns belong in the spreadsheet?

One row per certificate keeps separate expiry dates from hiding in one cell. The MAHC says a certificate should show the trainee's name, level of training, expiry date, any depth limits, the instructor and the agency (6.2.1.3.6). That makes a good column list:

Field	What it helps you check
Staff member	Whose record you are reviewing
Exact course name	What training the document covers
Issuing body	Where to verify it
Certificate reference	Which document or lookup result supports the entry
Issue and expiry dates	The dates shown in the official record
Depth or other limits	For example shallow water only, up to a set depth
Checked by and checked on	Who verified the entry and when
Renewal action	What needs to happen next and who follows up
Review status	Verified, awaiting review, or expired

Depth limits matter. Under the MAHC, a guard certified for shallow water may not be assigned to water deeper than their certificate covers (6.3.4.3.3).

Keep documents where the responsible managers can reach them, and limit access to personal information. A shared shift schedule does not need certificate numbers.

How do you verify a certificate?

Use the issuing body's official process. The American Red Cross has a Find My Certificate tool. You can search by certificate ID, by the email used at the time of training, or by name and course completion date. Other agencies have their own lookup or contact process.

Match the official result to the staff member and the course you need. Record the dates exactly as shown. If the document and lookup disagree, mark the entry as awaiting review and contact the issuing body.

Keep verification separate from receiving a document. A file on record means you got it, not that anyone checked it.

How can you make expiry dates easy to review?

Use one date format throughout the sheet. Sort by expiry date and keep blank dates visible. A missing date needs follow-up.

Keep the expiry date and your follow-up date in separate columns. The expiry comes from the official record. The follow-up date is your team's reminder, set early enough to find a class before the season.

A simple status rule, with written labels and not just colors:

Status	When	Action
Verified	Checked, and not expiring before the schedule ends	None
Renew soon	Expires within your follow-up window	Named owner books a renewal class
Not verified	Missing date or lookup not done	Do not schedule until checked
Expired	Past the expiry date	Do not schedule. Follow the agency's renewal rules

What should happen when renewal is due?

Renewal windows are short, and they differ by source:

• The American Red Cross lifeguard recertification page says its recertification course needs a current Red Cross lifeguarding certificate, or one expired by no more than 30 days. Past that, the person takes the full course. Passing renews the certificate for two years.
• The MAHC says a certificate expired more than 45 days means retaking the course. At 45 days or less, the guard retakes it or completes a challenge program (6.2.1.3.7).

Expired is expired for scheduling, whatever the renewal window. Keep booking, attendance, passing and verification as separate steps. Do not mark a row verified because a class is on the calendar.

After renewal, check the new official record and update the row. The MAHC asks facilities to keep records at least 3 years (6.4.1.2.1), including in-service training records (6.3.3.4.1).

How should the record connect to scheduling?

Check qualifications before approving shifts and replacements. Review dates across the scheduled work period, including any expiry that falls during it. Our weekly lifeguard schedule guide explains how to keep assignment checks visible.

Check replacements the same way when someone calls out. Our call-out procedure guide covers that step.

Poolean shows shifts, clock-ins, callouts and coverage requests with recorded manager approvals, and keeps staff evaluations and feedback on each guard's record, so the certificate check sits right next to the staffing decision. See the staffing features or book a 30-minute call.

The short version

• One row per certificate, with exact course name, dates and depth limits.
• Verify each one through the issuing body's lookup.
• Track CPR/AED on its own; the MAHC caps it at 1 year.
• Book renewals early: the Red Cross recertification window closes 30 days after expiry.
• Check the sheet before approving any shift or swap.