The Accounts Receivable Register report allows you to identify any errors before posting AR transactions or provides you with a permanent record of the transactions posted.
Permissions Required for this Report
In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:
- Security group profile > Functional rights > Reports > Shared Library > Shared Views
- Security group profile > Functional rights > Reports > Firm Library > Custom
- Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
- Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
- Security group profile > Functional rights > Reports > Firm Library > <report name>
- Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients
Reports in Foundation that are Comparable
In Practice Management, the comparable report is AR Register. In Practice Advantage, the comparable report is Payments and Adjustments.
Report Specifications
The following report options and filters are available to determine the report contents.
| Options and Settings | ||
|---|---|---|
| Option | Setting | Description |
| Include Deleted Clients | Yes/No | Includes or excludes deleted client information. |
| Default Filters | ||
|---|---|---|
| Field Name | Operator | Value |
|
Accounting Period Date |
= |
Today |
|
Transaction Status |
= |
Posted |
| Optional Filters | ||
|---|---|---|
| Available Fields | ||
|
Accounting Period Date |
Financial Reporting Client Group |
Project Office |
|
Amount |
Line of Business |
Project On Hold |
|
Applied To |
Manager |
Project On Hold as of Date |
|
Business Code |
Posted Date |
Project Original Planned Finish |
|
Check/Ref # |
Primary Partner |
Project Original Due Date |
|
Client |
Project |
Project Planned Finish |
|
Client – Principal |
Project Actual Finish |
Project Planned Start |
|
Client Bill Manager |
Project Actual Hours |
Project Priorities |
|
Client Billing Group |
Project Actual Start |
Project Prospective |
|
Client Business Unit |
Project Bill Manager |
Project Region |
|
Client ID |
Project Budget Hours |
Project Status |
|
Client ID.Sub ID |
Project Business Unit |
Project Team |
|
Client Name |
Project Complexity |
Project Template |
|
Client Office |
Project Delivery Method |
Project Type |
|
Client Primary Service Type |
Project Extension 1 Date |
Return Group |
|
Client Region |
Project Extension 2 Date |
Tax Type |
|
Client Sub ID |
Project Fileholder |
Transaction Status |
|
Client Type |
Project Frequency |
Type |
|
Deposit/Trans Date |
Project ID |
Works from the Pool |
|
Est. Percentage Complete Per Est. Hours |
Project Missed Dates |
|
|
Estimate Percentage Complete Per Budget |
Project Name |
|
| Grouping | ||
|---|---|---|
| Available Fields | ||
|
Business Code |
Client Sub ID |
Project Name |
|
Client |
Client Type |
Project Office |
|
Client – Principal |
Deposit/Trans Date |
Project Region |
|
Client Bill Manager |
Financial Reporting Client Group |
Project Status |
|
Client Billing Group |
Line of Business |
Project Team |
|
Client Business Unit |
Manager |
Project Template |
|
Client ID |
Primary Partner |
Project Type |
|
Client ID.Sub ID |
Project |
Return Group |
|
Client Name |
Project Business Unit |
Sort Name |
|
Client Office |
Project Fileholder |
Staff |
|
Client Primary Service Type |
Project Frequency |
Tax Type |
|
Client Region |
Project ID |
Type |
| Sorting | ||
|---|---|---|
| Available Fields | ||
|
Applied To |
Client Name |
Type |
|
Check/Ref # |
Deposit/Trans Date |
|
|
Client ID |
Staff |
|
Report Fields
The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.
| Report Fields | |
|---|---|
| Field | Description |
|
Deposit Date |
The deposit/transaction date of the reported record. |
|
Client Name |
The client name. |
|
Client ID |
The client ID and sub ID (Client ID.Sub ID). |
|
Staff |
The name of the staff that entered the transaction. |
|
Type |
The transaction type. Type values can be Credit Adjustment, Credit Memo, Debit Adjustment, Debit Memo, Finance Charge, GST Write-off, Handling Fee, Miscellaneous Charge, Payment, or Write-off. |
|
Check/Ref # |
The reference number for the transaction. |
|
Applied to |
The document number of the original transaction that the amount has been applied to. This report field shows 0 if the amount has not been applied. |
|
Amount |
The amount of the transaction that was applied to the invoice principal. |
|
Sales Tax |
The amount of the transaction that was applied to the sales tax for the referenced record. |
|
Charges |
The amount of the transaction that was applied to the misc. charge, handling fee, or finance charge for the referenced record. |
|
Total |
The total of applied amounts from Amount, Sales Tax, and Charges. |
Accounts Receivable Register Sample Report
