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 does not reconcile with your accounting, ERP, e-commerce, m-commerce, or POS application, learn the reports you need to use to adjust the amounts. For each section below, there are videos, user guides, and recorded webinars so you can choose how you want to learn.

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.

Overview

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:

PLAY-BLUE-30px.png

Reports and reconciliation overview

Calc_VideoThumb.png

 Reconciliation and filing overview (6:20)

With Returns 

Reconcile the Liability Worksheet

This section walks you through the steps to review and reconcile your tax liabilities with the totals in your accounting system. and to approve the tax liabilities for a state and month in your liability worksheet

01.png Run a Liability Worksheet Export Return Detail Report.GuidesNL-blue-xs.png
02.png Within your accounting system, run a report that details sales and purchase totals by jurisdiction.
03.png Compare the totals between the two reports to identify any discrepancies.
04.png If a transaction is in your accounting system but is missing in your Admin Console, you may need to import the missing transactions. Follow the steps in any of the links below:
 
 
  Approve the tax liability for a state in the liability worksheet.

Reconcile previous Returns records

Find copies of past returns that Avalara has filed on your behalf and compare with the totals in your accounting system.

01.png For an overview of this process, attend our Liability Worksheet webinar 
02.png Locate archived returns GuidesNL-blue-xs.png
03.png Run a Liability Worksheet Export Return Detail Report GuidesNL-blue-xs.png
04.png Within your accounting system, run a report that details sales and purchase totals for desired jurisdictions and date ranges.
  Compare the totals to identify any discrepancies.
  If there are any discrepancies, you may need to file an amended return GuidesNL-blue-xs.png

Without Returns

Reconcile jurisdiction sales totals

This section walks you through the steps to reconcile your jurisdiction sales totals with the totals in your accounting system.

01.png Run a Tax Return - Sales and Sellers Use Tax Summary Report GuidesNL-blue-xs.png
02.png Within your accounting system, run a report that details taxable and non-taxable sales by jurisdiction.
03.png Compare the totals between the two reports to identify any discrepancies.
04.png If a transaction is in your accounting system but is missing in your Admin Console, you may need to import the missing transactions. Follow the steps in any of the links below:
 
 

Reconcile jurisdiction purchase totals

This section walks you through the steps to reconcile your jurisdiction purchase totals with the totals in your accounting system.

01.png Run a Tax Return - Consumer Use Tax Summary Report GuidesNL-blue-xs.png
02.png Within your accounting system, run a report that details taxable and non-taxable purchases by jurisdiction.
03.png Compare the totals between the two reports to identify any discrepancies.
04.png If a transaction is in your accounting system but is missing in your Admin Console, you may need to import the missing transactions. Follow the steps in any of the links below:
 
 

Reconcile sales by a specific jurisdiction

This section walks you through the steps to reconcile your sales totals by a specific jurisdiction with the totals in your accounting system.

01.png Run a Tax Return Report - Sales and Sellers Use Jurisdiction Detail Report for desired jurisdiction GuidesNL-blue-xs.png
02.png Within your accounting system, run a report that details taxable and non-taxable purchases by jurisdiction.
03.png Compare the totals between the two reports to identify any discrepancies.
04.png If a transaction is in your accounting system but is missing in your Admin Console, you may need to import the missing transactions. Follow the steps in any of the links below:
 
 

Reconcile purchases by a specific jurisdiction

This section walks you through the steps to reconcile your purchase totals by a specific jurisdiction with the totals in your accounting system.

01.png Run a Consumer Use Tax - Jurisdiction Detail Report for desired jurisdiction GuidesNL-blue-xs.png
02.png Within your accounting system, run a report that details taxable and non-taxable purchases by jurisdiction.
03.png Compare the totals between the two reports to identify any discrepancies.
04.png If a transaction is in your accounting system but is missing in your Admin Console:If a transaction is in your accounting system, but is missing in your Admin Console, you may need to import the missing transactions. Follow the steps in any of the links below: