Reports in AvaTax

Last updated
Save as PDF

This article applies to:AvaTax

Avalara has reports to help you reconcile data, file returns, and otherwise use information from your transactions. Generate reports on your transaction history at any time.

AvaTax begins updating report data every 30 minutes, so you may need to wait to see your most recent transactions in your reports. Go to the Transactions page for up-to-the-minute activity.

If you want to use a report with certain criteria over and over again, save yourself some time by adding that report to your favorites. Here are a few things to remember about reports:

Each report category has a number of reports that can be further customized to provide you with the information you need.
Reports that you view in the Avalara platform have hyperlinks to other reports and transactional detail.
Reports that you export contain all available information included in transactions, depending on the filters you choose for the reports.

Transaction reports

Transaction reports display information about the transactions you've either sent from your business application or uploaded into AvaTax. Run transaction reports to reconcile transactions in AvaTax with transactions in your business application.

Sales tax document reports Consumer use tax document reports	Use these reports to identify differences between transaction data in AvaTax and data in your business application. Run reports filtered by customers, tax jurisdictions, addresses, and document detail. View committed (locked), uncommitted (unlocked), and voided transactions.
Sales tax document data export Consumer use tax document data export	Download worksheet versions of your sales and consumer use tax transactions. Create filters and reorganize data to make it easier to compare and reconcile with reports from your business application. View committed (locked), uncommitted (unlocked), and voided transactions. View line-level details, like item codes, addresses, and tax codes (filter by tax code to separate goods and services). These reports include tax override and tax variance amounts.
Reverse charge, VAT & all taxes data export	Review information about reverse charges from VAT fees in the EU and transactions involving some special kinds of tax. The EC Sales List (ECL) shows details of each customer in the EU and the value (in UK pounds sterling) of the supplies made to them in the period. This helps you fill out the UK EC Sales List (ESL) report. The All Taxes reports show information for taxes other than sales tax, such as lodging or landed cost. View committed (locked), uncommitted (unlocked), and voided transactions.

Liability & tax return reports

Liability and tax return reports display your tax liability. Run them to verify your returns in Returns or file your own returns.

Sales and sellers use tax return filing reports Consumer use tax return filing reports	Use these reports to fill out tax returns on your own. If you use Returns and Avalara files for you, use these reports to reconcile your returns. View liabilities for the current month, previous month, or any date range you choose. Filter your reports by location, tax code, and tax type. Show the rates, zip codes, freight, state assigned codes, and location codes associated with your liabilites. Find reports to help you fill out California and Colorado returns.
Liability worksheet reports	Returns customers use these reports to see your amount due for tax liability on the returns Avalara will file for you. Data is based on the information in the forms Avalara files and is not necessarily broken down by jurisdiction.
Excise and Canada HST reports	This information helps you with federal medical device excise tax forms and provincial sales tax in Canada.

Exemption reports

Use exemption reports to show you exemption exposures, exempt and non-taxable details for transactions, and information about exemptions stored in our platform.

Fill out the report details

These fields may require additional explanation. Not all fields appear in every report form.

Form field	Notes
Date to be used	Select the date type to use when applying a date range: Document date - The date the transaction occurred. Used for both tax calculation and reporting purposes. Tax date - The date used for tax calculation purposes. Usually the same as the document date, unless you calculate sales tax separately before committing the transaction to AvaTax. Payment date - The date the customer paid you to complete the transaction. This field might not be filled in on all transactions, because it's generally assumed to be the same as the document date, and isn't visible on transactions in AvaTax. Reporting date - The date the transaction was reported. In almost all cases this is the same as the document date, and isn't visible on transactions in AvaTax.
Company or Companies	To select more than one company from the Company or Companies list, press and hold Ctrl and click each company name.
Document Code From / Document Code To	The document code is typically the number of the document as assigned by your business application. In the Document Code From field, type the individual document code that you want to restrict the form to. To use a range of document codes, type another document code in the Document Code To field. Leave these fields blank to run a report for all document codes.

Form field

Notes

Date to be used

Select the date type to use when applying a date range:

Document date - The date the transaction occurred. Used for both tax calculation and reporting purposes.
Tax date - The date used for tax calculation purposes. Usually the same as the document date, unless you calculate sales tax separately before committing the transaction to AvaTax.
Payment date - The date the customer paid you to complete the transaction. This field might not be filled in on all transactions, because it's generally assumed to be the same as the document date, and isn't visible on transactions in AvaTax.
Reporting date - The date the transaction was reported. In almost all cases this is the same as the document date, and isn't visible on transactions in AvaTax.

Company or Companies

To select more than one company from the Company or Companies list, press and hold Ctrl and click each company name.

Document Code From / Document Code To

The document code is typically the number of the document as assigned by your business application. In the Document Code From field, type the individual document code that you want to restrict the form to. To use a range of document codes, type another document code in the Document Code To field. Leave these fields blank to run a report for all document codes.