Home › Guides › License tracking spreadsheet

Free medical license tracking spreadsheet template

One Excel file for everything a clinician has to keep current: state licenses, DEA and state registrations, board certifications, life-support cards and malpractice. Built for a clinic manager tracking a group, or a clinician with several licenses. Days left and status fill in by themselves.

What is in the file

Six tabs. Each has a header row that stays put while you scroll, a filter on every column, and three grey example rows marked “Example: Dr. Sample” that you delete.

• Licenses: one row per state license.
• DEA and registrations: DEA plus any state controlled-substance registration.
• Board certifications: the next deadline and what is due by then.
• Life-support cards: BLS, ACLS, PALS and others.
• Malpractice: carrier, policy type, dates, and whether you have the certificate.
• How to use: six lines, start here.

The columns on the Licenses tab

• Clinician, Profession: who holds it (MD, DO, NP, PA, CRNA, CAA).
• State, License type: where, and full, temporary or other.
• License number: copied from the license itself.
• Issued, Expires: dates from the document, not from memory.
• Days left: calculated from Expires and today.
• Renewal fee: for budgeting.
• CME hours required, CME hours done: the gap is what is left to earn this cycle.
• Status: Current, Due within 60 days (amber) or Overdue (red).
• Notes: anything the board wants that is not CME.

The other tabs follow the same pattern: an Expires date drives Days left and Status.

Three tips for keeping it current

1. Give it one owner and one date. Pick the person who updates it and a fixed day each month. A tracker nobody opens warns nobody.
2. Update the row the day the new document arrives. Overwrite Expires from the new license or card, then file the PDF where the Notes column says.
3. Sort by Expires every time you open it. Work every amber row first. Amber means you still have time; red means you are already late.

When a spreadsheet stops working

A spreadsheet is fine for a few licenses and one careful owner. It starts to fail in three places.

• Missed renewals. The file only warns the person who opens it. The Interstate Medicine Ledger sends renewal alerts at 120, 60, 30 and 7 days by default, and alerts you when a board changes its rules.
• CME topics per state. A total of hours does not tell you whether you have each state’s required topics. The Ledger tracks every state license against that board’s rules, and one CME credit counts toward every state requirement it satisfies.
• Chasing documents. The file holds dates, not proof, so someone still emails for copies. In the Ledger you drop a document in or forward the email; AI reads it and you confirm.

Running this for a group? The Interstate Medicine Roster gives you one Due list of everything due in the next 90 days across every clinician. You can import your roster spreadsheet, which brings in name, email, NPI and specialty. License numbers and dates come from the documents you add, which are read by AI and confirmed, not from the spreadsheet.

Common questions

Is the template really free?

Yes. No account and no email address. Download it, edit it, share it with your team.

Can I import this spreadsheet into Interstate Medicine?

The Roster imports the name, email, NPI and specialty columns from any Excel or CSV roster. It does not import license numbers or expiration dates from a spreadsheet. Those come from the documents you add, which are read by AI and confirmed.

Why does a date show as a number, or Days left stay blank?

Days left stays blank until Expires has a date. If you typed the date as text, retype it as yyyy-mm-dd so the spreadsheet reads it as a date.

Related: Credential renewal cycles · Locum tenens credentialing checklist · License and CME trackers compared · CME requirements by state