--> Skip to main content
Avalara Help Center

Reconcile Returns Data

This article applies to:Avalara AvaTax
This article applies to:Avalara Returns

It's a best practice to reconcile your returns data each month to identify any differences between your returns and the transactions in your Admin Console, and to catch any discrepancies between your accounting system and AvaTax. If you identify a state and form with an amount that doesn't reconcile with your accounting software, learn the reports you need to use to adjust the amounts. 

You can generate reports at any time. However, transaction history is available for reporting 6 hours after a document is committed in AvaTax. For more recent transaction activity, use the transactions list filter on the transactions tab.

Depending on whether you use Returns, different reports are available to you; however, the same basic concepts apply to the reconciliation process no matter which products you use. These videos provide a general overview of the process:

With Returns

Step What report to run in AvaTax What report to run in your accounting software If you find discrepancies

1. Reconcile previous Returns records

Run a Liability Worksheet Export Return Detail Report Run a report that details sales and purchase totals You may need to file an amended return

2. Reconcile the liability worksheet

Run a Liability Worksheet Export Return Detail Report Run a report that details sales and purchase totals

Without Returns

Step What report to run in AvaTax What report to run in your accounting software If you find discrepancies

1. Reconcile jurisdiction sales totals

Run a Tax Return - Sales and Sellers Use Tax Summary Report Run a report that details taxable and non-taxable sales by jurisdiction

2. Reconcile the liability worksheet

Run a Liability Worksheet Export Return Detail Report Run a report that details sales and purchase totals
3. Reconcile jurisdiction purchase totals Run a Tax Return - Consumer Use Tax Summary Report Run a report that details taxable and non-taxable purchases by jurisdiction.
4. Reconcile sales by a specific jurisdiction Run a Tax Return Report - Sales and Sellers Use Jurisdiction Detail Report for desired jurisdiction Run a report that details taxable and non-taxable purchases by jurisdiction.
5. Reconcile purchases by a specific jurisdiction Run a Consumer Use Tax - Jurisdiction Detail Report for desired jurisdiction Run a report that details taxable and non-taxable purchases by jurisdiction