AR Activity Summary

Overview

Purpose

This report analyzes accounts receivable activity by transaction type for a specified date range.

Summary

Accounting / Posted

CSV or Excel

How to Get Here?

From Portal:	From Back Office:
From the Reports tab, locate the AR Activity Summary report. Click Edit for the report. Enter/select filter criteria on the Criteria page. Click Run Report.	Open the Manage menu and select Reports. From the Reports page > Modern tab, select the AR Activity Summary report from the list of reports. Click Run (or press [Alt] + [R]). Enter/select the filter criteria from the Parameters window. Click Run (or press [Alt] + [R]).

(Click an image to enlarge)

Field	Description
Date	The accounting date/posted date for the AR activity, based on the Date Mode filter option selected.
Adj. Type	The classification (code) for the adjustment. Transaction Codes used include: SVCFE – Service Line Fee  RVFEE – Service Line Fee (Reversal)  IPYMT – Insurance Payment  GPYMT – Guarantor Payment  RVPAY – Payment Reversal  SDISTR – Suspense Distribution to Account  REFND – Refund  Adjustment codes include: CWOFF – Contractual Write-off WHOLD – Insurance Withholding MADJN – Miscellaneous Negative Adjustment MADJP – Miscellaneous Positive Adjustment RVADJ – Adjustment Reversals EXCOL – Transfer to External Collections EXTRF – Transfer from External Collections to AR
Description	Description of the transaction and adjustment codes used in the report.
Debit Amt.	The amount debited from the balance for the transaction code.
Credit Amt.	The amount credited to the balance for the transaction code.
Ending Balance - Net Activity	Last line of the report populated with a value based on the following: If the balance is greater than or equal to zero, value populated in Debit Amt. column If the balance is less than zero, value populated in the Credit Amt. column

Option	Type	Required	Description
Date Mode	Drop Down	Yes	Determines how the results are grouped and ordered: Accounting Date - Groups and orders by the Accounting Date of the transaction Posted Date - Groups and orders by the date the transaction was posted to the account.
Date	Drop Down	Yes	Filters transactions displayed by the selected time period. Options include: Custom Date Range, Last # of Days, Today, Previous Day, Current Month, Previous Month, Current Year, and Previous Year. If Custom Date Range is selected, the From and To fields are enabled to enter specific dates to run the query on. If Last # of Days is selected, the Last # of Days field is enabled to enter a specific number of days to run the query on. The maximum timespan for the report is 366 days.
Practices	List Selection	No	Filters by all practices or one or more practices. By default, this filter is set to All. Only active practices are returned in the search results.
Report Folder	Drop Down	Yes	Designates where to place or save the output from the executed report.