<< Click to Display Table of Contents >> Navigation:  Charity Care and Collections > Medicare Bad Debt > Medicare Bad Debt Report > Description and Usage

This report is used to adhere to the Medicare Bad Debt Requirements set forth by CMS for Medicare Bad Debt Cost Reporting. For a Medicare account to pull to this report, it must have the following:

•Discharge Date

•Primary Medicare financial class on the Guarantor/Ins tab on the Registration and ADT screen.

•No A/R Balance

•Date in the Medicare Write Off Date field in the Charity Care and Collections screen.

 

The report will read the date in the Medicare Write Off Date field in the Charity Care and Collections screen to determine which accounts will pull to the report.

 

NOTE: The Medicare Write Off Date field may auto populate when the Medicare collect code is added to the account or it may be manually entered. Either way, as long as there is a date in the field, it will pull to this report.

 

 

Medicare Bad Debt - Report Writer

 

 

 

Below is the order of the columns along with explanations of the information pulling to each column.

 

•Column 1: Beneficiary Last Name (beneficiary_last_name): The patient's last name.

 

•Column 2: Beneficiary First Name (benficiary_first_name): The patient's first name.

 

•Column 3: MBI or HICN (medicare_number): The Medicare number pulls from the Contract Number field in the Policy Information screen on the primary Medicare claim.

 

•Column 4: Pat Account Number (patient_account_number): The patient's account number.

 

•Column 5: Date of Service From (service_from): The beginning date of the patient's date of service on the insurance claim.

 

•Column 6: Date of Service To (service_to): The ending date of the patient's date of service on the insurance claim.

 

•Column 7: Medicaid Number (medicaid_number): If the patient is dually eligible, the Medicaid number pulls from the Contract Number field in the Policy Information screen on the secondary Medicaid claim.

 

•Column 8: Deemed Indigent Y/N (deemed_indigent): A Y will display if the patient has a Y in the Indigent field on the Guarantor Insurance tab on the visit.

 

•Column 9: Remittance Advice Date Medicare (medicare_remit_date): The remittance date of the first Medicare payment.

 

•Column 10: Remittance Advice Date Medicaid (medicaid_remit_date): The remittance date of the secondary Medicaid payment.

 

•Column 11: Secondary Payer Remittance Advice Received Date (secondary_remit_date): The remittance date of the secondary insurance payment if the secondary is not Medicaid.

 

•Column 12: Beneficiary Responsible Amount (beneficiary_resp_amt): The amount on the first statement sent to the patient after insurance paid, but before being written off to bad debt.

 

•Column 13: Date First Bill Sent to Beneficiary (first_stmt_date): The date of the first statement sent to the patient after insurance has paid.

 

•Column 14: AR Write-Off Date (ar_write_off_date): The AR date of when the account was written off to bad debt. This will look to the Write Off charge item number in the patient's Account Detail.

 

•Column 15: Collection Agency Info Sent Y/N (collection_agency_info_sent): A Y will display in this column when there is a collect code in the Collection Agency field on the Charity Care and Collections screen.

 

•Column 16: Collection Agency Info Return Date (collection_agency_returned_date): The date loaded in the Returned from Collections field in the Charity Care and Collections screen.

 

•Column 17: Collections Effective Ceased Date (collections_ceased_date): The date loaded in the Collections Ceased field in the Charity Care and Collections screen.

 

•Column 18: Medicare Write Off Date (medicare_write_off_date): The date the collect code changed when the account was written off to bad debt. This may be found in the patient's Account Detail.

 

•Column 19: Recoveries only Amount Received (total_recoveries): The total amount of payments received on the account after it was written off to bad debt or a prior cost reporting year.

 

•Column 20: Recoveries only MCR FYE Date (recovery_fiscal_year_end): This column will look at the individual payments that make up the Recoveries only Amount Received column (column 19) to see the date of when the collect code was changed and what the Fiscal Year End Date was on that entry. It will then use that Fiscal Year End Date in this column.

 

•Column 21: Medicare Deductible & Coinsurance Amounts Deductible (medicare_deductible_amt): The deductible amount entered during receipting.

 

•Column 22: Medicare Deductible & Coinsurance Amounts Coinsurance (medicare_coinsurance_amt): The co-insurance amount entered during receipting.

 

•Column 23: Current Year Payments Received Amount (current_year_payments): The total payment amounts received based on the date parameters entered/cost reporting period before the account was written off for any amounts reported in the Medicare Deductible & Coinsurance Amount columns (columns 21 and 22).

 

•Column 24: Current Year Payments Received Source (current_year_payment_source): The name of the payee or insurance company.

 

•Column 25: Allowable Bad Debts (total_bad_debt_amt): The total allowable Medicare bad debt amount. This column must be less than or equal to the Medicare Deductible & Coinsurance Amount columns (columns 21 and 22) and less any payments in the Recoveries only Amount Received and Recoveries only MCR FYE Date columns (columns 19 and 20).

 

•Column 26: Comments (comments): Any information that has been added to the Comments field in the Charity Care and Collections screen. This column is for informational purposes and may be used as needed.