Skip to main content
Avalara Help Center

Reconcile Transactions

This article applies to:Avalara AvaTax

It is a best practice to reconcileHoverTT.png your transactional data each month to catch any discrepancies between your accounting system and AvaTax. Learn the reports you need to run for your different types of transactionsHoverTT.png. 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 1 hour after a document is committed in AvaTax. For more recent transaction activity, use the transactions list filter on the transactions tab.

Overview

The same basic concepts apply to the reconciliation process no matter which types of transactions you need to reconcile. 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)

Reconcile sales

Reconcile taxable and non-taxable sales

This section walks you through the steps to reconcile your taxable and non-taxable sales in the Admin Console with the totals in your accounting system.

01.png Run a Reconcile Document Summary Report for the desired country, region, or document range GuidesNL-blue-xs.png
02.png Within your accounting system, run a report that details taxable and non-taxable sales totals for the same country, region, or document range.
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 exempt sales

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

01.png Run a Tax Return Exemption Detail Report for the desired country or region GuidesNL-blue-xs.png
02.png Within your accounting system, run a report that details exempt sales totals for the same country or region.
03.png Compare the totals 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 customer

This section walks you through the steps to reconcile your sales for a specific customer in the Admin Console with the totals in your accounting system.

01.png Run a Reconcile Document Line Detail Report for a specific customer code GuidesNL-blue-xs.png
02.png Within your accounting system, access a customer account record or run a report that details taxable and non-taxable sales totals for the customer in question.
Compare the totals 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 location

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

01.png Run a Tax Return Sales and Sellers Use Tax Jurisdictional Detail Report for the desired location GuidesNL-blue-xs.png
02.png Within your accounting system, run a report that details exempt sales totals for the same location.
03.png Compare the totals 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 a specific sales transaction

This section walks you through the steps to reconcile a specific sales transaction or a specific range of transactions in the Admin Console with the totals in your accounting system.

01.png Run a Reconcile Document Line Detail Report for a specific transaction or a range of transactions
02.png Within your accounting system, access the transaction in question or run a report that details taxable and non-taxable sales totals for the same range of transactions.
03.png Compare the totals 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 tax code

This section walks you through the steps to reconcile your sales by a specific tax codeHoverTT.png in the Admin Console with the totals in your accounting system.

01.png Run a Tax Return Sales and Sellers Use Tax Jurisdictional Detail Report for the desired tax code GuidesNL-blue-xs.png
02.png Within your accounting system, run a report that details exempt sales totals for the same tax code.
03.png Compare the totals 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

Reconcile taxable and non-taxable purchases

This section walks you through the steps to reconcile your taxable and non-taxable purchases in the Admin Console with the totals in your accounting system.
01.png Run a Standard Consumer Use Tax - Reconcile Document Summary Report for the desired country, region, or document range GuidesNL-blue-xs.png
02.png Within your accounting system, run a report that details taxable and non-taxable purchase totals for the same country, region, or document range.
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 exempt purchases

This section walks you through the steps to reconcile your exempt purchases in the Admin Console with the totals in your accounting system.

01.png Run a Standard Consumer Use Tax - Tax Return Exemption Detail by Jurisdiction Report for the desired country, region, or document range GuidesNL-blue-xs.png
02.png Within your accounting system, run a report that details exempt purchase totals for the same country, region, or document range.
03.png Compare the totals between the two reports to identify any discrepancies.
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 customer

This section walks you through the steps to reconcile your purchases for a specific customer in the Admin Console with the totals in your accounting system.

01.png Run a Standard Consumer Use Tax - Reconcile Document Line Detail Report for a specific customer code GuidesNL-blue-xs.png
02.png Within your accounting system, run a report that details taxable and non-taxable purchase totals for the same customer in question.
03.png Compare the totals between the two reports to identify any discrepancies.
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 location

This section walks you through the steps to reconcile your purchases by a specific locationHoverTT.png in the Admin Console with the totals in your accounting system.

01.png Run a Consumer Use Tax - Tax Return Jurisdiction Detail Report for the desired location
02.png Within your accounting system, run a report that details taxable and non-taxable purchase totals for the same location.
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 a specific purchase transaction

This section walks you through the steps to reconcile a specific purchase transaction or a specific range of transactions in the Admin Console with the totals in your accounting system.

01.png Run a Consumer Use Tax - Reconcile Document Line Detail Report for the tax code in question GuidesNL-blue-xs.png
02.png Within your accounting system, access the transaction in question or run a report that details taxable and non-taxable purchase totals for the same range of transactions.
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 tax code

This section walks you through the steps to reconcile your purchases by a specific tax codeHoverTT.png in the Admin Console with the totals in your accounting system.

01.png Run a Consumer Use Tax - Tax Return Jurisdiction Detail Report for the tax code in question 
02.png Within your accounting system, run a report that details taxable and non-taxable purchase totals for the same tax code.
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: