RELEASE 2012-3.4.1 PAGE 1 OF 4 ACCOUNTS RECEIVABLE DETAIL AGING
Accounts Receivable Detail Aging
Purpose of this Report
The Accounts Receivable Detail Aging report shows the unpaid/unapplied AR transactions. This report includes a balance forward from the beginning date
and detail of all unpaid/unapplied AR transactions for all transactions up to the ending date.
Permissions Required to Access this Report
For the security group the user is assigned to they must have View Permissions for these areas:
Practice under Functional Rights-Reports-Firm Library
Client Profile under Functional Rights-Administrations Manager-Client
Reports in Foundation that are Comparable
In Practice Management, there comparable report is AR Open Item Aging (Custom Library).
In Practice Advantage, the comparable report is AR Ledger (Detail and Summary Aging).
Report Options Available
The following report options and data selections are available to determine the report contents.
Options and Settings:
Select To Age Transactions Using…
List
Determines the date to use to age the AR transactions. The options are transaction date
and accounting period date.
Hide Details
Yes/No
Shows or hides the detail section of the report.
Include Clients With Transactions And AR
Balance of $0.00
Yes/No
Includes or excludes the transactions with 0.00 amounts.
Include Credit Balances
Yes/No
Includes or excludes the clients with credit balances.
Include Clients With A Minimum AR Balance
Of…
Amount
Includes or excludes clients that have a balance below the selected amount.
Calculate Aging For Undistributed Payments
Using…
List
Determines the date to use to calculate undistributed payments. The options are
undistributed transaction date and oldest unpaid invoice date.
Show Client AR Limit
Yes/No
Shows or hides the clients AR limit.
Show Client Last Payment Date And Amount
Yes/No
Shows or hides the last paid date and the last paid amount for the client.
Show Client Address
Yes/No
Shows or hides the client address.
Start Aging Period For Minimum AR Balance
At…
Number
The beginning period that the aging will start.
Set Number of Days For Aging Period 1
Number
The number of days for the first aging.
Set Number of Days For Aging Period 2
Number
The number of days for the second aging.
Set Number of Days For Aging Period 3
Number
The number of days for the third aging.
Set Number of Days For Aging Period 4
Number
The number of days for the fourth aging.
Set Number of Days For Aging Period 5
Number
The number of days for the fifth aging.
Set Number of Days For Aging Period 6
Number
The number of days for the sixth aging.
Set Number of Days For Aging Period 7
Number
The number of days for the seventh aging.
Hide Comma
Yes/No
Shows or hides the commas in numbers on the report.
RELEASE 2012-3.4.1 PAGE 2 OF 4 ACCOUNTS RECEIVABLE DETAIL AGING
Hide Penny
Yes/No
Shows or hides the pennies in amounts on the report.
Show Last Bill Date and Amount
Yes/No
Shows or hides the date and amount of the last bill.
Show Separate Finance Charge Totals
Yes/No
Shows or hides the finance charge total line.
Default Data Selections:
Transaction Date
Between
First Day of Current Month, Today
Optional Data Selections:
Accounting Period Date
Client ID.Sub ID
Financial Reporting Client Group
Client – Principal
Client Name
Manager
Client Bill Manager
Client Office
Posted Date
Client Billing Group
Client Region
Primary Partner
Client Business Unit
Client Sub ID
Transaction Date
Client ID
Client Type
Type
Note: Manager and Primary Partner are the default Client Responsible Staff. Any other Client Responsible Staff that are created will show up
in the data selection list as well.
Grouping:
Client – Principal
Client Name
Manager
Client Bill Manager
Client Office
Primary Partner
Client Billing Group
Client Region
Sort Name
Client Business Unit
Client Sub ID
Type
Client ID
Client Type
Client ID.Sub ID
Financial Reporting Client Group
Note: Manager and Primary Partner are the default Client Responsible Staff. Any other Client Responsible Staff that are created will show up
in the grouping list as well.
Sorting:
Amount
Client Name
Transaction Date
Client ID.Sub ID
Document #
Type
RELEASE 2012-3.4.1 PAGE 3 OF 4 ACCOUNTS RECEIVABLE DETAIL AGING
Fields that are displayed on this report:
Client ID Sub-ID
The client ID and sub-ID for the client. The format is Client ID.Sub-ID.
Client Name
The name for the client. The format is client name (client ID.sub-ID).
Balance Forward
The total of all unpaid/unapplied AR that is before the starting date of the report.
Type
The type of AR transaction.
Date
The date of the AR transaction.
Document #
The document number of the AR transition, such as the invoice number, finance charge number, or check
number.
Amount
The amount of the transaction.
Current
The amount for the first aging.
2
nd
Aging
The amount for the second aging.
3
rd
Aging
The amount for the third aging.
4
th
Aging
The amount for the fourth aging.
5
th
Aging
The amount for the fifth aging.
6
th
Aging
The amount for the sixth aging.
7
th
Aging
The amount for the seventh aging.
Days Old
The number of days old the AR transaction is.
RELEASE 2012-3.4.1 PAGE 4 OF 4 ACCOUNTS RECEIVABLE DETAIL AGING
