Billing Transaction Report (GB117)
The Billing Transaction report provides details for each transaction by claim.
Understanding the Report Filters
Use the report filters to control the data shown on the report. Two rules apply to how the filters are used:
-
Filter conditions are combined using AND logic, which means a transaction must meet every setting you select to be included.
For example, selecting Carrier payment recvd for the Transaction Type and Exam for the Item Type will generate a report that shows only carrier payments for Exam line items. Carrier payments made on frame line items will be excluded, as will patient payments for exams.
-
For all filters except for Transaction Type, selecting All will cause the filter to be ignored during generation.
Selecting Data to Include on the Report
Use the report filters to select the Offices, Transaction Types, Carriers, Carrier Types, Accounts, and Item Types to include on the report.
When you select an office, the report will print information for claims associated with that office.
If you select All Offices Selected, the report will not use Office to filter the report data.
The transaction types available when generating the report are the transactions in AcuityLogic Billing and are defined below.
- Net Current Billed
- Claim billed: The expected insurance receivable.
- Claim sent to direct billing: The expected patient receivable (Bill to patient).
- Manual claim deletion: The claim edits to delete a line item (Adjustment).
- Manual claim addition: The claim edits to add a line item (Adjustment).
- Manual claim update: Any changes to the patient or insurance receivable.
- System adjustment: The receivable changes based on internal rules such as billing rules. These adjustments are system-created transactions.
- Payment
- Carrier payment recvd: The payments against the insurance receivable.
- Patient payment recvd: The payments against the patient receivable.
- External claim adjustment: The amounts adjusted when a balance remains on a check with no existing claim. These adjustments are tracked by company instead of by office.
- Auto Adjustment
- Refund adjustment: Any refund against the insurance or patient receivable. For example, a returned frame would be an adjustment against the insurance receivable.
- Remake adjustment: Any difference in the patient or insurance receivable by line item.
If a line item is on hold when you issue a refund, the system creates a remake adjustment. If a line item is not on hold, the system creates a refund adjustment. - Write Off
- Carrier AR write off: The adjustments where all or a portion of the insurance receivable is written off.
- Patient AR write off: The adjustments where all or a portion of the patient receivable is written off.
- Post billing adjustment: The adjustments made in AcuityLogic Billing. Examples of these adjustments include Keep Overpayment, Receivable Adjustment, or Special Batch Adjustment.
- Claim sent to collections: The adjustments that occur when a claim is sent to collection in AcuityLogic Billing.
When you select an Carrier Name, the report will print information for claims for that carrier.
If you select All Carriers Selected, the report will not use Carrier Name to filter the report data.
Carrier Type is defined by whether the Prepaid Carrier check box is selected for the carrier in the Insurance Carrier setup window in Admin.
-
Third Party Insurance: Prints only carriers that do not have Prepaid Carrier selected.
-
Prepaid Insurance: Prints only carriers that have Prepaid Carrier selected.
-
All : The report will not use Carrier Type to filter the report data.
The accounts listed are the GL accounts configured in AcuityLogic Admin. If a Billing Month close has been performed and exported to GL, only transactions associated to the selected accounts will be printed on the report.
If you select All Accounts Selected, the report will not use Account to filter the report data.
When you select an item type, the report will print information for claim line items with that item type.
Select Dates
Select this option to enter date ranges to print.
- From Transaction Date/To Transaction Date: Filters transactions by the action date. For most actions, like adjustments, write offs, and line item edits on the claim, this is the date the action occurred.
For carrier payment, patient payment, and external claim adjustment transactions, this filter behaves differently, depending on whether or not Eyefinity has set your system up to use the deposit date for payments. To change your setting, contact your account manager or Eyefinity Customer Care.
If your system is set up to use the deposit date, the associated payment's deposit date is used to filter the data.
Example: A manual carrier payment transaction was made to a claim on September 20. The associated carrier payment’s deposit date is August 20. If you select a date range of September 1 through September 30, the payment will not be included on the report because the deposit date does not fall within this range. If you select a date range of August 1 through August 31, the transaction will be included
If your system is not set up to use the deposit date, the filter uses the transaction's transaction date for all transaction types.
Example: A manual carrier payment transaction was made to a claim on September 20. The associated carrier payment’s deposit date is August 20. If you select a date range of September 1 through September 30, the payment will be included on the report because the transaction date falls within this range. If you select a date range of August 1 through August 31, the transaction will not be included
For ERA transactions, the filter uses the date the associated ERA was posted as the transaction date, not the date the individual claim was reconciled.
Example: A claim was reconcilled in the ERA module on August 20. The remaining claims 3 were reconcilled and the Post button was clicked on September 5. All transactions will have a transaction date of September 5
-
From Service Date / To Service Date Filters by the claim’s service date. This includes external claim transactions. These are optional fields and if not entered will be ignored.
Billing Month
The way the Billing Month filter is applied depends on the available Month Close data that is available:
-
If Month Close data is available for both the selected month and the prior month, the range is set from the prior month's close date to the selected month's close date, and only transactions linked to the selected month’s close are included. The CloseId will be for the selected month.
Example: August is selected for Billing Month. July’s Month Close was run on August 2. August’s Month Close was run on September 2. The From Transaction Date will be set to August 2 and the To Transaction Date will be set to September 2. CloseId will be for August.
-
If either Month Close is missing, the range is set to the selected calendar month, and the CloseID is not considered.
Example: August is selected for Billing Month. No month close was run for August. From Transaction Date will be set to August 1 and the To Transaction Date will be set to August 31.
Report Layout
The report appears differently depending on the selected criteria, but the following columns remain consistent:
| Column | Description |
|---|---|
|
Trans ID |
The system created transaction ID number. |
|
Order ID |
The order number. |
|
Claim ID |
The claim number. |
|
Payment Number |
A payment number entered by the user. This is typically a check number. |
|
Patient Name |
The patient name on the claim or order. |
|
Adjustment Reason |
The adjustment reason selected in AcuityLogic Billing. |
|
Service Date |
The service date on the claim. |
|
Deposit Date |
The deposit date entered by the user for the check. |
|
Ins Amount |
The amount of the insurance receivable paid, written off, or adjusted. |
|
Pat Amount |
The amount of the patient receivable paid, written off, or adjusted. |