AR Sales Tax

The AR Sales Tax report reviews sales tax amounts by client and sales tax authority. This report includes the sales tax amounts and sales tax authority associated with billing, AR transactions, or both.

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 and Practice Advantage, there are no comparable reports. This is a new standard report.

Report Specifications

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

Options and Settings
Option	Setting	Description
Hide Details	Yes/No	Includes or excludes details of each transaction. If excluded, only the headers and footers for each group with amounts only for the grand total display in the report. To view a summary amount for each group, select to subtotal the group.
Hide Penny	Yes/No	Includes or excludes pennies in amounts.
Hide Comma	Yes/No	Includes or excludes commas in numbers.
Include Deleted Clients	Yes/No	Includes or excludes deleted client information.

Default Filters
Field Name	Operator	Value
Transaction Date	Between	First Day of Current Fiscal Year, Last Day of Current Fiscal Year
Transaction Type	=	All
Transaction Status	=	Posted

Optional Filters
Available Fields
Accounting Period Date	Client Office	Primary Partner
Applied To	Client Primary Service Type	Return Group
Business Code	Client Region	Sales Tax
Client	Client Sub ID	Tax Authority
Client – Principal	Client Type	Tax Type
Client Bill Manager	Document #	Transaction Date
Client Business Unit	Financial Reporting Client Group	Transaction Status
Client ID	Line of Business	Transaction Type
Client ID.Sub ID	Manager
Client Name	Posted Date

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 Name	Line of Business
Client	Client Office	Manager
Client – Principal	Client Primary Service Type	Primary Partner
Client Bill Manager	Client Region	Sort Name
Client Business Unit	Client Sub ID	Tax Authority
Client ID	Client Type
Client ID.Sub ID	Financial Reporting Client Group

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
Accounting Period Date	Document #	Transaction Date
Applied To	Sales Tax	Transaction Status
Client	Tax Authority	Transaction 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
Transaction Date	The date the transaction was entered.
Accounting Period Date	The date of the accounting period to which the transaction was entered.
Type	The transaction type. The options include Invoice, Payment, Credit Memo, Credit Adjustment, GST Write-off, Write-off, Debit Memo, Debit Adjustment, Miscellaneous Charge, Handling Fee, and Finance Charge.
Document #	The invoice or the reference number of the AR transaction.
Applied To	Typically, the invoice number of the transaction.
Status	The transaction status. The options are Posted and Unposted.
Sales Tax	The sales tax amount. The report displays sales tax from invoice and debits as positive and displays sales tax applied amounts from payment and credits as negative.
Tax Authority	The sales tax authority of the transaction.

AR Sales Tax Sample Report