Skip to main content
Avalara Help Center

Report Reconciliation Troubleshooting Guide

Use this guide to help identify issues when reconciling a bill cycle.

  • Check your date range to make sure that you aren't including more transactions than expected or to ensure you aren't excluding transactions.
    • If you are using a specific date range rather than a month, try setting the From date back a day or the To date ahead a day to account for the conversion between local time and UTC.
  • Use the Transaction Detail report to view the transactional data.
    1. In Communications Customer Portal, go to Reporting > Explorer.
    2. Set the template to Transaction Detail.
    3. Select your reporting options.
      • Select the correct date range for the reconciliation.  This may be an entire month, a week, or a single day.
      • Don't include No Tax transactions checkbox - only transactions returning taxes are returned on the Compliance report.
      • View only committed transactions - only committed transactions are returned on the Compliance report.
    4. Adjust the columns for your report and set filters.
      • Include only the columns that you need to reconcile and remove any other columns that may cause distractions.  It may be helpful to limit the Transaction Detail Report columns to those of the Compliance report columns.
      • Filter the data as needed.  For example, include a filter for a specific Company Identifier or Bill Cycle Reference.
    5. Execute and download the report.
  • Reconcile the Transaction Detail report to the Compliance report.
    • Filter and sort by identifying columns, such as jurisdiction, tax type, or tax level.
    • Review by tax type or jurisdiction to break the reconciliation into smaller chunks.
    • Aggregate columns such as Tax Amount to identify discrepancies quickly.
  • Review the non-billable (NBA) taxes (reporting column Billable = false).
    • Depending on your RequestConfig settings, non-billable taxes may not be returned in the detailed tax results (non-billable taxes are never returned in the summarized tax results, regardless of your configuration settings).  However, non-billable taxes are included in the report by default.
    • Non-billable taxes are not included on the Compliance report.
  • Review the non-compliance (NCA) taxes (reporting column Compliance = false).
    • Non-compliance taxes are not reported to the jurisdiction.
  • Review your expected variance to ensure that differences are not based on an incorrect variance.
  • Filter and sort by identifying columns, such as jurisdiction, tax type, or tax level.
  • Review by tax type or jurisdiction to break the reconciliation into smaller chunks.
  • Aggregate columns such as Tax Amount to identify discrepancies quickly.

​​Reporting Columns

  • Was this article helpful?