Skip to main content
Avalara Help Center

Reconcile Tax Transactions

When you reconcile documents, you compare the total documents, the total document amount, and the total tax amount in Microsoft Dynamics GP and in AvaTax. For help troubleshooting reconciliation issues, see Troubleshoot Reconciliation Discrepancies.

To reconcile documents:

  1. In Microsoft Dynamics GP, click Tools > Utilities > Avalara AvaTax > Reconciliation.
  2. In the Reconciliation window, enter Start and End Dates in MM/DD/YY format, and then click Reconcile. The reconciliation utility reconciles the documents and displays documents, along with one of the following reconciliation statuses:
    Status Definition
    Reconciled The document is in both Microsoft Dynamics GP and AvaTax. You don't need to do anything.
    Missing in AvaTax The document is in Microsoft Dynamics GP but not in AvaTax. This happens if you post documents in Microsoft Dynamics GP on a computer that doesn't have AvaTax for Microsoft Dynamics GP installed. To reconcile these documents, post them to AvaTax on a computer that has AvaTax for Microsoft Dynamics GP installed.
    Missing in ERP The document is in AvaTax but not in Microsoft Dynamics GP. This happens if you import transactions to AvaTax that aren't in Microsoft Dynamics GP. To reconcile these documents, in Microsoft Dynamics GP, create documents that match the ones in AvaTax.
    Amount Mismatch The document is in both AvaTax and Microsoft Dynamics GP, but the amounts don't match.
    Tax Amount Mismatch  The document is in both AvaTax and Microsoft Dynamics GP, but the tax amounts don't match.