< Back to Thought Leadership

Medicare Bad Debt Listing Template Finalized by CMS

This article has been updated on January 5, 2023.

Back in August 2022, CMS was proposing changes to the Medicare Bad Debt listing template that is filed with your organization’s cost report. The new template (Exhibit 2A) has recently been finalized by Medicare and is now required for cost reporting periods beginning on or after October 1, 2022. This means that it will begin on the first day of your fiscal year after 10/01/2022. Providers with a fiscal year of 10/01/2022-9/30/2023 will be the first to go into effect.

Blue & Co. is here to help answer any questions your organization might have about the new Medicare Bad Debt listing template. We understand that there is additional information being required to fill out the template and you will want to be sure you have plenty of time to prepare.

Exhibit 2A- Medicare Bad Debt Listing Template

For a link to the excel file template, please click here.

Exhibit 2A- Medicare Bad Debt Listing Instructions

Enter the provider name, CCN, subprovider CCN (if applicable), cost reporting period (CRP) beginning and ending dates, whether the listing represents Medicare bad debts for inpatient or outpatient services, the name of the preparer, the date prepared, the total of Medicare allowable bad debts (sum of column 24), and the total of dual-eligible Medicare bad debts (sum of amounts entered in column 24 where column 7 has an entry).

  • Columns 1, 2, 3, 4, 5, and 6: From the Medicare beneficiary’s bill, enter the beneficiary’s name, dates of service, patient account or identification number, and MBI or HICN, that correlate to the claimed bad debt. (See 42 CFR 413.89(f).)
  • Column 7: Enter the Medicare beneficiary’s Medicaid number if the beneficiary was dually eligible (eligible for Medicare and some category of Medicaid benefits).
  • Column 8: Enter “Y” for yes if the Medicare beneficiary was not eligible for Medicaid but the provider deemed them to be indigent; otherwise, enter “N” for no. (See 42 CFR 413.89(e)(2)(ii).)
  • Column 9: Enter the Medicare remittance advice date for the Medicare beneficiary information in columns 1 through 6.
  • Column 10: Enter the Medicaid remittance advice date or, when the provider does not receive a Medicaid remittance advice, enter “AD” for alternate documentation used to determine state liability (42 CFR 413.89(e)(2)(iii)(B)), that corresponds to the Medicare beneficiary information in columns 1 through 7.
  • Column 11: Enter the date a remittance advice was received from a secondary payer, if applicable.
  • Column 12: Enter the amount of coinsurance and deductible for which the Medicare beneficiary is responsible. If the beneficiary is a qualified Medicare beneficiary (QMB), enter “QMB.” For a Medicare beneficiary who is dually eligible for Medicaid (not a QMB), enter the amount the beneficiary is required to pay under the state cost sharing agreement (42 CFR 413.89(e)(2)(iii)). For a Medicare beneficiary deemed indigent by the provider (column 8 is “Y”), enter zero.
  • Column 13: Enter the date that the first bill was sent to the Medicare beneficiary. If the beneficiary is a QMB, enter “QMB.”

NOTE FOR COLUMNS 14 THROUGH 17: The dates reported in column 14 (the date that the Medicare beneficiary’s liability was written off of the provider’s accounts receivable), column 15 (the date that the collection agency ceased collection effort), column 16 (the date that all collection efforts ceased), and column 17 (the date that deductible and coinsurance amounts were written off as a Medicare bad debt), may be the same date.

  • Column 14: Enter the date the Medicare beneficiary’s liability was written off of the accounts receivable (A/R) in the provider’s financial accounting system. The date entered in this column may be the same as, or earlier than, the date the account was deemed worthless (written off as a Medicare bad debt).
  • Columns 15A and 15: In column 15A, enter “Y” for yes if the account was sent to a collection agency; otherwise, enter “N” for no. If column 15A, is “Y”, in column 15, enter the date the collection agency returned the account (i.e., the date that the collection agency ceased collection effort on the account).
  • Column 16: Enter the date all collection efforts ceased, both internal and external, including efforts to collect from Medicaid and/or from a state for its cost sharing liability.
  • Column 17: Enter the date the deductible and coinsurance amounts were written off as a Medicare bad debt, i.e., the amount must have been written off as a bad debt against the A/R in the provider’s financial accounting system; all collection effort, internal and external, against the Medicare beneficiary and/or other third parties ceased; and a Medicaid remittance advice was received from the state for Medicaid patients or alternate documentation exists as permitted under 42 CFR 413.89(e)(2)(iii)(B).
  • Column 18: Enter the amount of recoveries for amounts previously written off as an allowable Medicare bad debt in this or a prior cost reporting period. The amount reported in this column includes any payments received on an account after the account was written off as a bad debt, including payments received in the same year the account was written off when the payment was received after the date of the write off. (See 42 CFR 413.89(f).)
  • Column 19: If an amount is reported in column 18, enter the fiscal year end of the cost reporting period in which the Medicare bad debt (to which the recovery applies) was claimed and reimbursed. This column is optional; however, the date assists in identifying recovery amounts that must be offset. The fiscal year end entered in this column is a prior cost reporting period unless the write-off and recovery both occurred during this cost reporting period.
  • Column 20: Enter the Medicare deductible from the Medicare remittance advice (before any payments received from any party).
  • Column 21: Enter the Medicare coinsurance amount from the Medicare remittance advice (before any payments received from any party).
  • Column 22: Enter the amount of any payments received from the Medicare beneficiary, their estate, third party insurance, etc., during this cost reporting period, before the account was written off, for any amounts reported in column 20 and/or column 21. For example, when a beneficiary has a liability for a deductible $2,500 and makes a payment of $1,500, the payment is reported in column 22, leaving the remaining $1,000 eligible as an allowable bad debt.
  • Column 23: If an amount is reported in column 22, enter the payment source, or sources if multiple payers, e.g., Medicare beneficiary, estate, third party insurance, etc.. Do not create separate lines to enter each payment source.
  • Column 24: Enter the allowable Medicare bad debt amount. This amount must be less than or equal to the sum of the amounts in columns 20 and 21, less any payments in columns 18 and 22. If the fiscal year end in column 19 is prior to this cost reporting period, enter the recovery amount (reported in column 18) as a negative amount in this column. For each CCN, the sum of the amounts entered in this column on each listing, (inpatient and outpatient), as applicable, must equal the bad debts claimed for that CCN on the Medicare cost report. For example, CCN ##-0001, an inpatient acute care hospital, reported bad debts of $24,000 on the Exhibit 2A for inpatient and indicated that $12,000 on the Exhibit 2A for Medicaid eligible. The amount reported on Worksheet E, Part A, line 64, must equal $24,000. The amount reported on Worksheet E, Part A, line 66, must equal $12,000 (dual eligible).
  • Column 25: This column is for informational purposes. Enter any comments or additional information as needed.

Contact Us

For more information about how Blue & Co. can help your organization with the Medicare Bad Debt listing template, please contact a member of our Medicare Bad Debt team or reach out to your local Blue & Co. Advisor.

Dan Rice, Director

Michelle Trowell, Director

Rebecca Meredith, Senior Manager

Shawn Wise, Senior Manager

Stephanie Bernhardt, Manager

woman using a quickbooks point of sale system

Blue & Co. Offers Expertise to Not-For-Profits Affected by QuickBooks Point of Sale Discontinuation

By Nancy Orben, CPA, Senior Manager, Laura Philpot, Senior Accountant, Business Services, and Lisa Totten, Senior Accounting Specialist at Blue & Co. Attention all not-for-profit organizations! Are you currently using QuickBooks Point of Sale in your gift shops, ticket sales, or day-to-day business? If so, you may have heard the recent news that Intuit will […]

Learn More

Contract Services: Impact on Wage Index

In the past several years, hospitals have continued to feel the impact of increased utilization of contract nursing and other contract services. Although these services have developed into a major expense line item, it is important for hospitals understand how expenses related to contracted services can impact the wage index factor for Medicare reimbursement. Contract […]

Learn More
shamrocks not-for-profit tips

3 Lucky Tips for Not-For-Profits to Avoid Bank Fraud

Trusted Insights from The National Bank of Indianapolis Nonprofit Services Team Not-for-profit organizations are increasingly falling victim to fraud, with a rising number of incidents and an ever-growing amount of money being lost. Fraudsters find it easy to target not-for-profits, as their publicly available 990s provide valuable information. Protecting your organization from such fraudulent activities […]

Learn More