--> Skip to main content
Avalara Help Center

Reconcile Transactions

This article applies to:Avalara AvaTax

It's a best practice to reconcileHoverTT.png your transactional data each month to catch any discrepancies between your accounting software and AvaTax. Learn the reports you need to run for your different types of transactionsHoverTT.png.  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.

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:

Reconcile sales

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

1. Reconcile taxable and non-taxable sales

Run a Reconcile Document Summary Report Run a report that details taxable and non-taxable sales totals

2. Reconcile exempt sales

Run a Tax Return Exemption Detail Report Run a report that details exempt sales totals
3. Reconcile sales by customer Run a Reconcile Document Line Detail Report for a specific customer code Run a report that details taxable and non-taxable sales totals for the customer in question.
4. Reconcile sales by location Run a Tax Return Sales and Sellers Use Tax Jurisdictional Detail Report for the desired location Run a report that details sales totals for the same location.

5. Reconcile a specific sales transaction

Run a Reconcile Document Line Detail Report for a specific transaction Access the transaction in question
6. Reconcile sales by a tax code Run a Tax Return Sales and Sellers Use Tax Jurisdictional Detail Report for the desired tax code Run a report that details exempt sales totals for the same tax code

Reconcile purchases

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

1. Reconcile taxable and non-taxable purchases

Run a Standard Consumer Use Tax - Reconcile Document Summary Report Run a report that details taxable and non-taxable purchase totals
2. Reconcile exempt purchases Run a Standard Consumer Use Tax - Tax Return Exemption Detail by Jurisdiction Report Run a report that details exempt purchase totals
3. Reconcile purchases by customer Run a Standard Consumer Use Tax - Reconcile Document Line Detail Report for a specific customer code Run a report that details taxable and non-taxable purchase totals for the same customer in question
4. Reconcile purchases by a specific location Run a Consumer Use Tax - Tax Return Jurisdiction Detail Report for the desired location Run a report that details taxable and non-taxable purchase totals for the same location
5. Reconcile a specific purchase transaction Run a Consumer Use Tax - Reconcile Document Line Detail Report for the transaction in question Access the transaction in question
6. Reconcile purchases by a tax code Run a Consumer Use Tax - Tax Return Jurisdiction Detail Report for the tax code in question  Run a report that details taxable and non-taxable purchase totals for the same tax code