U.S. Tax Authority Details report

Purpose

This report shows U.S. transactions for each authority level by state, county, city, and district authority. It shows summarized audit amounts for each state and authority and the total tax for all selected tax types. It's the same as the summary report except that it also contains columns for county, city, district, UOM, and quantity.
note
This details report rounds the sum, not individual levels, so the total may be slightly different from the summary report.
Provides information needed for returns preparation and audit preparation, including state totals that don't match state totals in the business application.
Typically, you run this report once a month.

Audience

Tax preparation professionals who are responsible for U.S. indirect tax returns and compliance activities.

Parameters

Parameter
Required
Default
Description
Company Name(s)
Yes
None
Lists all companies in the database that are available to the current user. Select one or more company names.
Start Date
Yes
None
Enter the date or use the calendar to select the date. The date must be in YYYY-MM-DD format.
End Date
Yes
None
Enter the date or use the calendar to select the date. The date must be in YYYY-MM-DD format.
Date Type
Yes
Transaction
Identifies 1 of the following date types for transactions in the database:
  • Transaction - The date range is based on the date the tax calculation occurred for the document.
  • Document - The date range is based on document dates.
  • Fiscal - The date range is based on fiscal dates indicated by each transaction.
Tax Type(s)
No
None
Lists tax types defined in Determination that are available for the selected companies.


When filtering on this value, the report shows only the amounts associated with the select value(s). For example, if you filter to show only a particular country, the report shows only the amounts and details for that country - the reported amounts won't reflect the full document amount.

Taxable State(s)
No
None
Lists states where the selected company or companies have tax-relevant transactions.
Authority Type(s)
No
None
Lists authority types based on the selected company or companies. May include federal, state, county, and district jurisdictions.
Authority Name
No
None
Enter authority names to include in the report. Use wildcards to retrieve multiple names.
Document Number
No
None
Enter the document numbers to include in the report. Use wildcards to retrieve multiple document numbers.
Product Code
No
None
Enter the product codes to include in the report. Use wildcards to retrieve multiple product codes.
Commodity Code
No
None
Enter the commodity codes to include in the report. Use wildcards to retrieve multiple commodity codes.
Customer Number
No
None
Enter the customer numbers to include in the report. Use wildcards to retrieve multiple customer numbers.
Vendor Number
No
None
Enter the vendor numbers to include in the report. Use wildcards to retrieve multiple vendor numbers.
Line Gross Amount
No
None
Select an operator to filter results on the line gross amount you enter in the field. For example, select > then enter 100 to retrieve all line gross amounts greater than 100.
Tax Amount
No
None
Select an operator to filter results on the tax amount you enter in the field. For example, select >= and enter 50 to retrieve all tax amounts greater than or equal to 50.
Omit Fully Exempt Transactions
Yes
No
You can select to omit fully exempt tax lines or not to include them.
Attributes and Operators
No
None
Select 1 or more attributes to include as report filters or columns.

Related Content