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 NAV and in AvaTax.  For help troubleshooting reconciliation issues, see Troubleshoot Reconciliation Discrepancies.
  1. In Microsoft Dynamics NAV, click Departments > AvaTax > Utilities.
  2. On the right pane under Administration, click Reconciliation.
  3. In the Reconciliation window, next to Start Date and End Date, type start and end dates in MM/DD/YY format, and on the toolbar, click Reconcile.

    NAV2013_Reconcile1.png
  4. The reconciliation utility reconciles the documents and displays documents along with the reconciliation status. For details of a specific document, click the Document No.. A summary is displayed in the Reconciliation Results section for documents with the following status:
    • Reconciled means that the document is in both Microsoft Dynamics NAV and AvaTax. You don't need to do anything.
    • Missing in AvaTax means that the document is in Microsoft Dynamics NAV but not in AvaTax. This happens if you post documents in Microsoft Dynamics NAV on a computer that doesn't have AvaTax for Microsoft Dynamics NAV installed. To reconcile these documents, post them to AvaTax on a computer that has AvaTax for Microsoft Dynamics NAV installed.
    • Missing in NAV means that the document is in AvaTax but not in Microsoft Dynamics NAV, which happens if you import transactions to the Admin Console that are not in Microsoft Dynamics NAV. To reconcile these documents, in Microsoft Dynamics NAV, create documents that match the ones in AvaTax.
    • Amount Mismatch means that the document is in both AvaTax and Microsoft Dynamics NAV but the amounts do not match.
    • Tax Amount Mismatch means that the document is in both AvaTax and Microsoft Dynamics NAV but the tax amounts do not match.

    NAV2013_Reconcile2.png
  5. Click OK.