Accounts Receivable Reconciliation

The Accounts Receivable Reconciliation report lists the AR activity for a given time period, showing a beginning AR balance for each client as of the start date of the report and detailed AR activity for the period entered. The report includes activity types for each client. This report can be used to reconcile accounts receivable activity for the period.

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 Reconciliation. In Practice Advantage, the comparable report is AR Reconciliation.

Report Specifications

The following report options and filters are available to determine the report contents.

Options and Settings
There are no options and settings for this report.

Default Filters
Field Name	Operator	Value
Transaction Date	Between	First Day of Current Fiscal Year, Last Day of Current Fiscal Year

Optional Filters
Available Fields
Accounting Period Date	Client Name	Manager
Adjustments	Client Office	Payments
Business Code	Client Primary Service Type	Posted Date
Charges	Client Region	Primary Partner
Client	Client Sub ID	Return Group
Client – Principal	Client Type	Sales Tax
Client Bill Manager	Credit Memos	Tax Type
Client Billing Group	Debit Memos	Transaction Date
Client Business Unit	Financial Reporting Client Group	Write Offs
Client ID	Invoice Amount
Client ID.Sub ID	Line of Business

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Grouping
Available Fields
Business Code	Client ID.Sub ID	Financial Reporting Client Group
Client	Client Name	Line of Business
Client – Principal	Client Office	Manager
Client Bill Manager	Client Primary Service Type	Primary partner
Client Billing Group	Client Region	Return Group
Client Business Unit	Client Sub ID	Sort Name
Client ID	Client Type	Tax Type

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Sorting
Available Fields
Adjustments	Client Name	Payments
Beginning Balance	Credit Memos	Sales Tax
Charges	Debit Memos	Write Offs
Client ID.Sub ID	Invoice Amount

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 name.
Beginning Balance	The client's AR beginning balance for the date range selected.
Invoice	The billed WIP + write-up/down + progress billed – progress applied.
Sales Tax	The total sales tax billed.
Payments	The total payments received.
Credit Memos	The total credit memos.
Debit Memos	The total debit memos.
Adjustments	The net of credit and debit adjustments.
Write-offs	The total AR write-off amounts.
Charges	The total misc. charges, handling fees, or finance charges for the referenced record.
Ending Balance	The beginning balance + invoice + sales tax - payments – credit memos + debit memos +/- net of adjustments – write-offs + charges.

Accounts Receivable Reconciliation Sample Report