How to Track Crew Certifications and Rotations Without Losing Your Mind

Certificate expirations, rotation schedules, and STCW records are easy to lose track of on a spreadsheet. Here's a system that scales from one boat to a full fleet.

Crew paperwork is one of those things that's invisible until it isn't. A certification lapses, a rotation gets miscounted, or a new hire's documents never made it into the shared drive — and now it's a problem during a flag-state inspection or right before a charter. Most of this comes down to a system that doesn't scale past a handful of crew.

Why spreadsheets break down

A spreadsheet works fine for one vessel with three or four crew. It stops working once you have multiple vessels, seasonal crew changes, or more than one person who needs to update records. Someone forgets to update the master copy, two people edit conflicting versions, or the expiration-date formula silently breaks after a column gets inserted. None of this is a spreadsheet failure exactly — it's a process failure that spreadsheets don't prevent.

What a real crew tracking system needs

• Per-crew-member records — not just a row in a table, but a full profile: certifications, contact info, documents, and history, attached to the person, not the vessel.
• Expiration alerts — certifications should surface automatically as they approach renewal, not rely on someone remembering to check.
• Rotation schedules — on/off dates visible alongside the crew list, so you can see coverage gaps before they happen.
• Exportable records — for flag-state inspections, insurance, or when a crew member transfers to another vessel in the fleet.
• Role-based access — a chief stew or bosun shouldn't need full admin access just to update their own department's records.

Rotations specifically

Rotation tracking gets messy fast when it's mixed in with certifications on the same sheet. Keep the two concerns separate but linked: a crew member's certification status shouldn't depend on which rotation they're currently on, and rotation planning shouldn't require cross-referencing a different document to check who's actually qualified to be aboard.

A simple audit habit

Once a month, review upcoming certification expirations for the next 90 days and confirm renewal is scheduled — not just noted. A 90-day window gives enough runway to book courses or renewals before they become urgent.