Track Medicare revalidation dates without a stale spreadsheet.
Download a practical roster template, check every NPI against the official CMS list, and preserve the source date, owner, and next action that a bare due-date column leaves out.
Download the Medicare revalidation tracker.
The CSV includes source, ownership, follow-up, and status-boundary fields plus formulas for days until due, an internal 180-day review date, and a basic attention flag. Open it in Excel, Numbers, or Google Sheets and duplicate the formula row for the roster.
A date is useful only when its source and next owner travel with it.
Keep the NPI beside the legal name, location, state, enrollment type, and responsible owner.
Record the public due date or TBD, the day you checked it, and the CMS source revision.
Track a review-by date, submission target, actual submission date, application ID, and last verification.
Use a next-check date and plain-language notes so a handoff does not depend on someone’s memory.
Turn the tracker into a repeatable, source-dated check.
The public repository is a GitHub template with a ready workflow. Its default preview checks two disclosed demonstration NPIs, summarizes the current CMS result, and saves a JSON artifact without an account, token, Apify run, or charge.
- Copy the repository and run the preview from the Actions tab
- Keep a source-dated JSON artifact for each completed check
- Use your own Apify token only when checking a real 1–100 NPI roster
- Invalid NPIs and an insufficient hard charge cap fail before a paid run starts
Five steps keep the sheet from becoming false reassurance.
- 01Start with known NPIs
Use the organization’s controlled provider or supplier roster. Do not use this sheet to store patient information, passwords, or enrollment credentials.
- 02Check the official CMS list
Search each NPI in the CMS tool or use the free bulk lookup. Keep every enrollment row when an NPI has more than one result.
- 03Save the source date
A due date copied without the check date and source revision becomes untraceable. Record both every time the roster is refreshed.
- 04Separate deadline from status
The public list reports a revalidation due date or TBD. It does not prove that a revalidation was submitted, received, approved, or completed.
- 05Assign the next check
Give every row an owner and next-check date. If nobody reliably owns that recurring step, use automatic monitoring instead of a shared sheet.
The public list answers “when is it due?”—not “where is the application?”
NPI, enrollment rows, due date or TBD, enrollment type, location, specialty, the source refresh, and when your team checked it.
Submission, receipt, development requests, approval, rejection, deactivation, live processing stage, or why an enrollment record changed.
Choose by who should own the next source check.
The one-time dashboard keeps the workflow with your team. Roster Watch performs the recurring public-source check and sends changes by email. Neither option is live PECOS application status.
Refresh from CMS, then keep the receipt.
- CMS Medicare Revalidation List lookup
- CMS Revalidation Due Date List dataset and refresh information
- CMS PECOS enrollment management and contractor guidance
ActableSite is not CMS or a Medicare Administrative Contractor. The template does not submit an enrollment application, verify a live case, or replace official instructions.
Use the sheet as a control, not as the source of truth.
How often is the CMS Revalidation Due Date List updated?
CMS currently labels the dataset as monthly and shows its latest and next refresh dates on the official lookup. Record the source date rather than assuming a sheet is current.
What does TBD mean in the Medicare revalidation spreadsheet?
TBD means the current public list does not show an established due date for that enrollment. It does not mean overdue, complete, or safe to ignore.
Can this spreadsheet track PECOS application status?
It can hold a status someone verified elsewhere, but the public due-date list is not a live PECOS status source. Use PECOS or the responsible enrollment contractor for submission and processing status.
When is automatic monitoring a better fit?
Use automatic monitoring when a small known roster needs repeated public-source checks and the team cannot reliably refresh, compare, and reassign the spreadsheet every month.