The Accounts Receivable Balance Listing report assists in reconciling other reports that have an invoice/deposit date and accounting period date in different accounting periods. The report can also be used to view only the sales tax generated for each client and view each client's detailed AR activity or sales tax for the date range entered.
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 Balance Listing. In Practice Advantage, there are no comparable reports.
Report Specifications
The following report options and filters are available to determine the report contents.
| Options and Settings | ||
|---|---|---|
| Option | Setting | Description |
|
Show Sales Tax Only |
Yes/No |
Includes only sales tax items or includes all items. |
|
Include Clients with Transactions and AR Balance of $0.00 |
Yes/No |
Includes or excludes clients who have AR activity that sums to 0.00. The report does not include clients with a 0.00 AR balance unless they have AR activity. |
|
Include Deleted Clients |
Yes/No |
Includes or excludes deleted client information. |
| Default Filters | ||
|---|---|---|
| Field Name | Operator | Value |
| Accounting Period Date | Between | First day of current fiscal year, last day of current fiscal year |
| Optional Filters | ||
|---|---|---|
| Available Fields | ||
|
Accounting Period Date |
Client ID |
Financial Reporting Client Group |
|
Amount |
Client ID.Sub ID |
Line of Business |
|
Applied To |
Client Name |
Manager |
|
Business Code |
Client Office |
Posted Date |
|
Client |
Client Primary Service Type |
Primary Partner |
|
Client – Principal |
Client Region |
Return Group |
|
Client Bill Manager |
Client Sub ID |
Tax Type |
|
Client Billing Group |
Client Type |
Transaction Date |
|
Client Business Unit |
Document # |
Type |
| Grouping | ||
|---|---|---|
| Available Fields | ||
|
Business Code |
Client Name |
Manager |
|
Client |
Client Office |
Primary Partner |
|
Client – Principal |
Client Primary Service Type |
Return Group |
|
Client Bill Manager |
Client Region |
Sort Name |
|
Client Billing Group |
Client Sub ID |
Tax Type |
|
Client Business Unit |
Client Type |
Type |
|
Client ID |
Financial Reporting Client Group |
|
|
Client ID.Sub ID |
Line of Business |
|
| Sorting | ||
|---|---|---|
| Available Fields | ||
|
Accounting Period Date |
Balance |
Document # |
|
Amount |
Client ID.Sub ID |
Transaction Date |
|
Applied To |
Client Name |
Type |
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 |
|
Client ID |
The client ID and sub-ID (Client ID.Sub-ID). |
|
Client Name |
The client sort name. |
|
Transaction Date |
The transaction date. |
|
Accounting Period Date |
The posted date. |
|
Type |
The type of entry, such as payment or finance charge. |
|
Document # |
The invoice number, reference number, or finance charge number. |
|
Applied to |
The invoice number, reference number, or finance charge number that the transaction was applied to. |
|
Amount |
The amount of the transaction. |
|
AR Balance |
The sum of all AR transactions. |
AR Balance Listing Sample Report
