Hospital Bad Debt Report

athenaOne for Hospitals & Health Systems

The Hospital Bad Debt report displays all transactions that have been written off to bad debt over a specified time period. You can filter the report by primary and secondary payer class to locate transactions that may qualify as Medicare bad debt.

To run the Hospital Bad Debt report

Display the Report Library: On the Main Menu, click Reports. Under General, click Report Library.
Click the Financial tab.
Click run next to Hospital Bad Debt Report in the Standard Reports section of the tab.
The Run Report: Hospital Bad Debt Report page appears.
Start Date / End Date — Enter the start and end dates for the report, or select a date range from the menu. Transactions that were written off to bad debt within this date range are included in the report.
Filter dates on — Select one or both of these filters.
- date collections efforts ceased — Report on transactions for which collection efforts have ceased — that is, transactions that have been written off to bad debt — during the specified date range.
- date sent to collections — Report on transactions that were sent to a collection agency during the specified date range.
Collections Custom Transaction Code — To display the collect custom transaction code column in the report, select Show Column. You can display specific collection custom transaction codes only, or you can display all the codes. By default, this column does not appear in the report.
Baddebt Custom Transaction Code — To display the bad debt custom transaction code column in the report, select Show Column. You can display specific bad debt custom transaction codes only, or you can display all the codes. By default, this column does not appear in the report.
Service Department — To display the service department column in the report, select Show Column (the column is labeled "department"). To display transactions for specific departments only, select the departments from the list. By default, this column does not appear in the report.
Tip: To display results for specific departments only, make sure to deselect the Show All option at the top of the department list.
Primary Financial Class — To report on transactions for specific primary insurance classes only, click Selected and then select the classes to include in the report (for example, Commercial, Workers Comp, or Medicare Advantage).
Note: If you specify both a Primary Financial Class and a Secondary Financial Class, the report displays only transactions that have the specified primary insurance class and the specified secondary insurance class (for example, transactions with Commercial selected as the primary financial class and Self Pay selected as the secondary financial class).
Secondary Financial Class — To report on transactions for specific secondary insurance classes only, click Selected and then select the classes to include in the report (for example, Veterans Administration, Medicaid, or Self Pay).
Report Format — Select the format for your report results.

HTML table — Display the report results on your screen.
Text (tab-delimited) — Export the report results to a .csv file in tab-delimited format.
Text (comma-delimited) — Export the report results to a .csv file in comma-delimited format.

Report Options — Select report options.

Suppress Column Headings — Select this option to remove column headings from the report results.
Suppress Report Name — Select this option to remove the report name from the report results.
Show Filter Criteria — Select this option to include your selected filter criteria in the report results.
Run Offline (will appear in your Report Inbox tomorrow morning) — Select this option for very long reports. Reports that are run offline appear in your Report Inbox the morning after the request.

Click Run Report.

Field Reference

Run Report: Hospital Bad Debt Report
Start Date / End Date	Enter the start and end dates for the report, or select a date range from the menu. Transactions that were written off to bad debt within this date range are included in the report.
Filter dates on	Select one or both of these filters. date collections efforts ceased — Report on transactions for which collection efforts have ceased — that is, transactions that have been written off to bad debt — during the specified date range. date sent to collections — Report on transactions that were sent to a collection agency during the specified date range.
Collections Custom Transaction Code	To display the collect custom transaction code column in the report, select Show Column. You can display specific collection custom transaction codes only, or you can display all the codes. Note: By default, this column does not appear in the report.
Baddebt Custom Transaction Code	To display the bad debt custom transaction code column in the report, select Show Column. You can display specific bad debt custom transaction codes only, or you can display all the codes. Note: By default, this column does not appear in the report.
Service Department	To display the service department column in the report, select Show Column (the column is labeled "department"). By default, this column does not appear in the report. To display transactions for specific departments only, select the departments from the list. Tip: To display results for specific departments only, make sure to deselect the Show All option at the top of the department list.
Primary Financial Class	To report on transactions for specific primary insurance classes only, click Selected and then select the classes to include in the report (for example, Commercial, Workers Comp, or Medicare Advantage). Note: If you specify both a Primary Financial Class and a Secondary Financial Class, the report displays only transactions that have the specified primary insurance class and the specified secondary insurance class (for example, transactions with Commercial selected as the primary financial class and Self Pay selected as the secondary financial class).
Secondary Financial Class	To report on transactions for specific secondary insurance classes only, click Selected and then select the classes to include in the report (for example, Veterans Administration, Medicaid, or Self Pay). Note: If you specify both a Primary Financial Class and a Secondary Financial Class, the report displays only transactions that have the specified primary insurance class and the specified secondary insurance class (for example, transactions with Commercial selected as the primary financial class and Self Pay selected as the secondary financial class).
Report Format	Select the format for your report results. HTML table — Display the report results on your screen. Text (tab-delimited) — Export the report results to a .csv file in tab-delimited format. Text (comma-delimited) — Export the report results to a .csv file in comma-delimited format.
Report Options	Select other options for your report results. Suppress Column Headings — Select this option to remove column headings from the report results. Suppress Report Name — Select this option to remove the report name from the report results. Show Filter Criteria — Select this option to include your selected filter criteria in the report results. Run Offline (will appear in your Report Inbox tomorrow morning) — Select this option for very long reports. Reports that are run offline appear in your Report Inbox the morning after the request.
Column Headings
provider group	Rendering provider group associated with this transaction.
department	Service department associated with this transaction. Note: This column appears only if you select Show Column in the Service Department filter field.
PROVIDER	Name of the provider associated with this transaction.
claim id	athenaOne ID of the claim associated with this transaction.
patient id	athenaOne ID of the patient associated with this transaction.
patient name	Name of the patient associated with this transaction.
bad debt custom transaction code	Custom code associated with this transaction (for more information, see Custom Transaction Codes).
collect custom transaction code	Custom code associated with the collection agency for this transaction (for more information, see Custom Transaction Codes).
charge posted by	athenaOne username of the person who posted this charge in athenaOne. (ATHENA indicates an automated posting.)
sent to beneficiary	Date that the first bill was sent to the beneficiary.
sent to collections	Date that the bill was sent to a collection agency.
collection effort ceased	Date that collection efforts ceased for this transaction.
ADMITDATE	Date that the patient was admitted.
DISCHARGEDATE	Date that the patient was discharged.
primary hic. no. / mcaid no	Medicare Beneficiary Identifier (MBI, formerly HIC) or Medicaid number, if the patient's primary insurance is Medicare or Medicaid.
secondary hic. no. / mcaid no	Medicare Beneficiary Identifier (MBI, formerly HIC) or Medicaid number, if the patient's secondary insurance is Medicare or Medicaid.
total sent to collections	Total amount sent to a collection agency for this claim.
bad debt amount from deductible p1	Amount written off to bad debt for this claim attributable to the deductible of the patient's primary insurance.
bad debt amount from deductible p2	Amount written off to bad debt for this claim attributable to the deductible of the patient's secondary insurance.
bad debt amount from co-insurance p1	Amount written off to bad debt for this claim attributable to coinsurance for the patient's primary insurance.
bad debt amount from co-insurance p2	Amount written off to bad debt for this claim attributable to coinsurance for the patient's secondary insurance.
bad debt CoIns and Deductible Tot p1	Total amount written off to bad debt for this claim attributable to the coinsurance and deductible for the patient's primary insurance.
bad debt CoIns and Deductible Tot p2	Total amount written off to bad debt for this claim attributable to the coinsurance and deductible for the patient's secondary insurance.
total bad debt	Total amount written off to bad debt for this claim.
primary insurance package	Patient's primary insurance package.
PRIMARYFINANCIALCLASS	Financial class of the patient's primary insurance package.
secondary insurance package	Patient's secondary insurance package.
SECONDARYFINANCIALCLASS	Financial class of the patient's secondary insurance package.
Prim Ins Remit Advice Date	Date that the ERA/EOB was received from the patient's primary insurer.
Second Ins Remit Advice Date	Date that the ERA/EOB was received from the patient's secondary insurer.