Medicare denial tracking log
A downloadable CSV template for logging and working Medicare claim denials from receipt through resolution. It captures the claim reference, the responsible Medicare Administrative Contractor (MAC), the denial and remark codes reported on the remittance advice, the denial reason category, and the next action so that a billing team can track appeal deadlines and outcomes. This is a neutral educational worksheet: it does not reproduce CPT, HCPCS, ICD, or X12 code descriptor text, and it should be populated with non-identifying references only. Medicare appeal levels, timely-filing windows, and coverage rules vary by claim type, contractor, and program and change over time, so confirm specifics against current CMS guidance and the applicable MAC rather than relying on any figure entered here.
CSV · Reviewed 2026-07-18
Download and use
The download contains headings and blank rows only. The examples below use fictional operational references so you can see the intended structure without copying patient data.
Column guide
Claim reference
Internal claim or account number used to locate the claim in the billing system (non-PHI). Do not enter the beneficiary's name or Medicare Beneficiary Identifier (MBI).
Date of service
The service date on the claim, in a consistent format such as YYYY-MM-DD. Used to check the applicable Medicare timely-filing window, which is set by CMS and varies by claim type.
Claim type / part
Whether the denial is on a professional (CMS-1500) or institutional (UB-04) claim and the applicable Medicare part (for example, Part A, Part B, or a Medicare Advantage plan). Rules differ by type and part.
MAC or payer
The Medicare Administrative Contractor (MAC) or Medicare Advantage plan that adjudicated the claim. Enter a generic label if unknown; jurisdiction assignment is defined by CMS.
Denial date
The date the denial appeared on the remittance advice (ERA) or Medicare Summary Notice. Used as the reference point for calculating appeal timeframes, which vary by appeal level.
CARC / RARC codes
The claim adjustment reason code and remittance advice remark code identifiers reported on the remittance. Record the code identifiers only; do not paste the copyrighted descriptor text.
Denial reason category
A short internal classification of why the claim denied, such as medical necessity, coverage determination (NCD/LCD), timely filing, coordination of benefits / MSP, or enrollment. Helps identify patterns.
Billed amount
The charge amount on the denied line or claim, as an illustrative number. Allowed and paid amounts follow the applicable Medicare fee schedule and are not set by this log.
Appeal deadline
The internal target date to file the next appeal level or corrected claim. The actual deadline is governed by CMS rules for the relevant level; verify it rather than assuming a fixed number of days.
Status / next action
Current working status (for example, under review, corrected claim submitted, redetermination filed, resolved) and the specific next step and owner.
Fictional example
| Claim reference | Date of service | Claim type / part | MAC or payer | Denial date | CARC / RARC codes | Denial reason category | Billed amount | Appeal deadline | Status / next action |
|---|---|---|---|---|---|---|---|---|---|
| CLM-100482 | 2026-02-14 | Professional (CMS-1500), Part B | Example MAC jurisdiction | 2026-03-05 | CARC 50 / RARC N115 | Medical necessity (LCD) | 185.00 | 2026-08-01 | Under review — pull documentation for redetermination |
| CLM-100715 | 2026-01-27 | Institutional (UB-04), Part A | Example Medicare Advantage plan | 2026-02-19 | CARC 22 | Coordination of benefits / MSP | 1240.00 | 2026-05-20 | Corrected claim submitted with primary EOB — awaiting response |
Working instructions
- 1Populate one row per denied claim or denied line using internal reference numbers only; do not store patient names, the Medicare Beneficiary Identifier (MBI), or other PHI in this log, and do not keep an unsecured copy on a shared drive, email, or personal device.
- 2Record CARC and RARC identifiers exactly as they appear on the Medicare remittance advice (ERA), but enter only the code identifiers — not the descriptor text — and classify each denial into a reason category to reveal recurring patterns.
- 3Treat the appeal-deadline column as an internal reminder, not an authority: Medicare appeal levels and timely-filing windows are set by CMS and vary by claim type and contractor, so confirm the governing date against current CMS guidance and the responsible MAC before relying on it.
- 4Review the log regularly to prioritize claims by approaching deadline and dollar value, and update the status and next-action fields each time the claim is worked so ownership and progress stay clear.
Sources
Related Knowledge
- Common Medicare billing denials
Reference on the denial reasons Medicare claims most often trigger and how they are categorized.
- Appealing a denial
Overview of the appeal process and how denial documentation feeds it.
- Denial appeal tracking log
A companion template for tracking appeals across payers once a denial is being worked.