Balancing Reports

Report	Balances To
Daily Adjustments	Adjustments column in Transaction Summary Transaction Detail, if you select all the Adjustments Transaction Codes
Daily Charges	Charge column in Service Item Summary with Extended Amount Charge column in Transaction Summary
Daily Payments	Payments column in Transaction Summary Transaction Detail, if you select all the Payment Transaction Codes
Daily Refunds	Refunds column in Transaction Summary Transaction Detail, if you select all the Refund Transaction Codes
Insurance Aging Analysis	Aging Analysis by Encounter, Aging Analysis (Categories) by Line Item, Insurance Aging Analysis – Age Responsible Balances Only Report
Monthly Charges in A/R	Daily Charges, Transaction Summary, Service Item Summary, Provider Productivity by RVU
Service Item Summary with Extended Amount	Charge column to Daily Charges Charge column to charge column of the Transaction Summary
Transaction Detail	Final total should balance to the sum of Daily Adjustments, Payments, and Refunds Final total should balance to the sum of the transaction columns in the Transaction Summary report. Select specific Transaction codes and balance to the corresponding column from the Transactions Summary report. Or, balance to the daily transaction reports.
Aging Analysis by Encounter	Aging Analysis by Line Item, Account Summary, Insurance Detail, Insurance Summary. Monthly Changes in AR All statuses on filter 1 should be included.

Help Guide for NextGen® Enterprise PM 8

Balancing through Reports

You can balance reports to each other when you use the same filter criteria. If using dates, you must use: The same type of dates (for example, charge posting vs. charge create), and The same date ranges. Report Balances To Daily Adjustments Adjustments column in Transaction Summary Transaction Detail, if you select out all the Adjustments Transaction Codes Daily Charges Charge column in Service Item Summary with Extended Amount Charge column in Transaction Summary Daily Payments Payments column in Transaction Summary Transaction Detail, if you select out all the Payment Transaction Codes Daily Refunds Refunds column in Transaction Summary Transaction Detail, if you select out all the Refund Transaction Codes Service Item Summary with Extended Amount Charge column to Daily Charges Charge column to charge column of the Transaction Summary Transaction Detail Final total should balance to the sum of Daily Adjustments, Payments and Refunds Final total should balance to the sum of the trans

Help Guide for NextGen® Enterprise PM 8

Troubleshooting Reports

At times, after running a report, you realize that you did not generate the information you expected to see. Or sometimes, the report displays no information whatsoever. This could mean that there is no information to display or it could mean that you are having trouble setting up and running your reports. The following are some tips to help you troubleshoot reports. Try... Because... Running Data Maintenance Reports If there is information in these reports, log a support call to have it corrected. Encounter Level Reports versus Line Item Level Reports When trying to balance reports, make certain that all the reports calculate consistently by running either encounter or line item level reports. It is possible for the line item and encounter level reports to contain different data since they are pulling from separate sources. Encounter versus Invoices Charges entered at the encounter and invoice levels report differently in different reports. To ensure that encounter and invoices displa

Help Guide for NextGen® Enterprise PM 8

Troubleshooting Balancing Issues

If your reports do not balance, there are several steps you should take to troubleshoot the possible causes. Run the System Data Maintenance Reports: Certain errors found on this report specifically state, “This affects reporting” and should be forwarded to NextGen Healthcare client support for assistance in resolving the error. Encounter vs. Invoice: Charges entered on Encounters and charges entered on Invoices report differently on various reports. Check that both Encounters and Invoices are included on each report. Date Filtering: When balancing multiple reports, make sure the date filter on the Filter1 tab is consistent on each report. For example: Create Date, Service Date, Process Date, Transaction Date, Post Date. Charge Process Date and Batch Process Date Override: If users have security to override the Process Date on charges and/or transactions, it is possible that dates were overridden inadvertently. Auto-Adjustments (from Contracts and Sliding Fee Schedules): Auto-adjustmen

Help Guide for NextGen® Enterprise PM 8

Monthly Reports

The Monthly reports provide summarized data to the lowest common denominator. Selecting fewer columns provides a shorter, more summarized report. These reports do not have “drill-down” functionality that enables you to double-click on a record to view or edit its details. The monthly Transaction Summary and Transaction Summary with Transaction Code reports can be generated By Encounter or By Line Item. These options relate to how the Financial Class and Payer information logic works on the reports. By Encounter: Charges and transactions are attributed to the primary payer on the encounter. For example, if a patient has Medicare primary and Blue Cross secondary, then charges are reported as Medicare, and all transactions posted against those charges are also reported as Medicare. By Line Item: Charges are attributed to the primary payer on the encounter, and transactions are attributed to the actual payer. For example, if a patient has Medicare primary and Blue Cross secondary, then cha

Help Guide for NextGen® Enterprise PM 8

Reports with Info Button

An Info button is available on the Report Filter window for the following reports in NextGen® Enterprise PM: General Reports Patient Chart Demographics Accounts Receivable Reports Aging Analysis > By Encounter Aging Analysis > By Line Item Billed Encounters Contractual Analysis Receivable Analysis > By Age Receivable Analysis > By Month Receivable Analysis > By Type Unapplied Amounts by Account, Invoice and Encounter Collections > Account Summary Collections > Insurance Aging Analysis Collections > Insurance Aging Analysis - Age Responsible Balances Only Collections > Insurance Detail Collections > Insurance Summary Unbilled Encounters Scheduling Reports Appointment Listing Daily Reports Activity Detail By Line Item > Adjustments / Payments / Refunds By Transaction > Adjustments / Payments / Refunds By Encounter > Adjustments / Payments / Refunds Charges Charges By Current User Encounters Monthly Reports Change in Accounts Receivable > By Encounter Change in Accounts Receivable By Line

Help Guide for NextGen® Enterprise PM 8

Daily Charges Report

The Daily Charges report is a line item report of daily charges by service item. This report is sorted based on location name, Encounter/Invoice number, and service item. Totals are for charge amount, with a subtotal for each location, and grand total of all locations. You can total the Count column of the Daily Charges report using the Totals tab on the Report Filter. Since the Count column is the Quantity of SIMS per charge, this gives you the total number of units for all charges. This sum can then be compared and matched to the sum of all charges on the Monthly Provider Productivity by RVU, the Service Item Summary with Extended Amount and Transactions, and the Transaction Summary reports. NextGen Healthcare recommends that you only choose one of the Filter 1 date ranges (create date, process date, or service date) to generate a meaningful report. To show the process date, be sure to specify the Process Date rather than the create date on the Filter 1 tab. The Charge report should

Balancing Reports

Recommendations

Balancing through Reports

Troubleshooting Reports

Troubleshooting Balancing Issues

Monthly Reports

Reports with Info Button

Daily Charges Report

Balancing through Reports

Troubleshooting Reports

Troubleshooting Balancing Issues

Monthly Reports

Reports with Info Button

Daily Charges Report