Medicare Missed-Revenue Kit 2026: Coding Guide + Excel Self-Audit

WHAT YOU GET

A plain-English CY2026 Medicare coding guide and an Excel self-audit workbook that estimates how much billable preventive and care-management work a small practice may be missing. You enter counts only, never patient data.

FILES

- Medicare-Missed-Revenue-Kit-2026.pdf: 15-page guide, US Letter

- Medicare-Missed-Revenue-Self-Audit-2026.xlsx: Excel self-audit workbook (no macros)

- free-one-pager-7-missed-medicare-codes-2026.pdf: 1-page quick reference

PAGE COUNT

15-page guide + 1-page quick reference + Excel workbook

FORMAT

US Letter (8.5 x 11 in) PDFs and an Excel .xlsx workbook (no macros; works in Excel, Google Sheets and LibreOffice). Delivered as one .zip file.

Instant digital download: your download link appears right after checkout and is emailed to you. No physical item is shipped.

HOW TO EDIT

There are no Word files in this listing. Download it from the link in your receipt. Unzip, then open the .xlsx workbook in Excel, Google Sheets (File > Import) or free LibreOffice. Type your counts into the yellow cells on the Inputs tab and read the Dashboard. Every rate cell can be edited for your MAC locality. No macros. Never enter patient names or other PHI.

WHAT'S INSIDE

- Who qualifies, how often, what to document, which modifier, and common denials for each service

- Covers AWV (G0438/G0439) and IPPE, advance care planning (99497/99498, modifier 33), the redefined 2026 G0136, screening and counseling codes, G2211, CCM, PCM, APCM, RPM (including 2026 codes 99445 and 99470), TCM and 99483

- One-page quick-reference table with 2026 national rates calculated from the CMS CY2026 PFS RVU file

- Common-denials table, 30-day action checklist, 2027 watch list and a full CMS sources page

- Excel workbook: enter de-identified counts (for example "800 Medicare patients, 260 AWVs billed") to estimate annual missed revenue for 17 services, with a dashboard and chart

- Every rate cell is editable for your MAC locality; switch between facility and non-facility rates

- Works in Excel, Google Sheets and LibreOffice

LICENSE

For use by one practice (all staff at one tax ID). Please do not resell or redistribute the files.

PLEASE NOTE

Educational reference only. Not legal, coding, billing or compliance advice and does not guarantee payment. Dollar amounts are 2026 national, unadjusted Medicare Physician Fee Schedule amounts calculated from the CMS RVU file; actual payment depends on locality, payer, documentation and medical necessity. Verify all rules with your MAC before billing. No protected health information is collected or required. Not affiliated with or endorsed by CMS, HHS or the AMA. CPT(R) is a registered trademark of the American Medical Association; code descriptions are paraphrased.

AI DISCLOSURE: I wrote this with the help of AI tools and checked it against the official sources listed in the file.

(c) 2026 Plainchart Guides