NextGen Knowledge Center

Transactions by Line Item Summary Report

The Transactions be Line Item Summary report breaks each rendering provider's transaction into adjustments, payments, and refunds. It also shows the extended charge amount for each provider. It is sorted by practice, location name, and rendering provider. Totals are for count (how many of each) of each transaction type (adjustment, payment, refund), and total dollars for each transaction type, with a subtotal for each rendering provider, subtotal for each location and grand total of all locations for each practice.

NextGen Healthcare recommends that you only choose one of the Filter 1 charge date ranges (create date, process date, or service date), and only one (if any) transaction-type date to generate a meaningful report.

The counts and totals for adjustments, payments and refunds in the Transaction Summary report should balance to the Transaction Summary With Transaction Code report.

In addition, each transaction column should balance to the corresponding Daily report, provided the same filters (date range, etc.) are used. The extended charge amount column should balance to the charge amount column in the Monthly Service Item Summary with Extended Amount and Transactions and the Daily Charges reports.

To access the report in NextGen® Enterprise PM, select the Reports menu and select Monthly, then select Transactions, then select By Line Item, and then select Summary.

From the Report Filter window, select the Info button to view the following information about the report:

Logic:
  • Charges display under the primary payer/financial class on the encounter. Transactions display under the actual payer/financial class from the transaction.
  • Charges are reported based on the dates specified in Filter 1.
  • Transactions are reported based on the dates specified in Filter 1, regardless of when the associated charge was processed.
  • If no line item data is selected in the columns tab, the report will ‘roll up’ to the highest level. In other words, If only the Financial Class and Charge Amount columns are selected, all charges for each Financial Class will appear on a single line without all the detail.
Filtering Info:
  • Charge Create Date is hard-coded and stamped by the system when the charge is entered.
  • Charge Process Date is set as the system date, but can be overridden (with security) at charge entry by the user.
  • Charge Service Date is entered during charge entry by the user.
  • Trans Post Date is hard-coded and stamped by the system when the transaction batch is posted.
  • Trans Process Date is derived from the Batch Header when the batch is created. If this is left blank, the system will populate the process date with the posting date.
  • Trans Transaction Date can be set at the Batch Header or overridden in transaction entry by the user.
Common Uses:
  • Review all financial activity for a specific period by the actual payer.
Balances to the Following Reports:
  • When the same filtering criteria is used, this report balances to:
    • Daily Charges
    • Daily Adjustments/Payments/Refunds
    • Monthly Change in A/R