Skip to main content
Avalara Help Center

Run a Reconcile Report

This article applies to:Avalara AvaTax

Use the reconcile reports to reconcileHoverTT.png AvaTax invoice data with the data in your accounting software.

To run a report, follow the steps below in Generate any report, and then customize your reconcile report based on the requirements of the specific report you choose. Variations of the reconcile report are described below. You can generate reports at any time; however, report data updates hourly. For more recent transaction activity, see the transactions list on the Transactions tab.

For more information about these and other report types, and to learn how to run these reports, read our report descriptions. Learn how these reports are linked to one another, or review the answers to our frequently asked questions about reports.

Generate any report

To generate any type of report:

  1. On the Reports tab, select a report category. When making your selection, be aware that the first section is for sales tax reports and the second section is for consumer use tax reports.
  2. From the the Company or Separate Reporting Entity list, select a company or reporting entity.
    AvaTaxCalc-Reports-SelectCoorSRE.png
  3. From the Select Report list, select a report. Fields specific to the report you select display.
    AvaTaxCalc-Reports-SelectReport.png
  4. Type or select values in the fields that display to determine what's included in the report. Remember:
    • The HTML file format isn't  recommended for displaying large reports.
    • The EXCEL file format is limited to the number of rows Microsoft Excel supports.
    • Large reports take time to generate. Don't cancel the report.
  5. Click Generate.

Generate a Top Line reconcile report

The Top Line reconcile report shows top line totals for your companies with transactions in AvaTax. This report captures a summary view of the country and/or region(s) selected for the document codesHoverTT.png. If no document codes are selected, all document codes for the country and/or region(s) selected are included in the report. In HTML format, click links within the report to view more details.

To generate a Top Line reconcile report:

  1. From the Company list, select the companyHoverTT.png from which to pull transactionsHoverTT.png for the report.
    1. To use transactions from all companies, select All.
    2. To select more than one company, hold Ctrl and click each company name.
  2. From the Country list, select the country in which the transactions occurred.
  3. From the State/Province list, select the state, province, or territory in which the transactions occurred.
  4. In the Document Code field, enter the individual document codeHoverTT.png to which the report should be restricted. To use a range of document codes, in the To field, type another document code. Typically, this is the number of the document as assigned by your accounting software.
  5. To show additional options to define the report, click Show Advanced Filter, and then:
    1. From the Report On Date list, select the date type to use when applying a date range.
    2. From the Document Status list, select the status of the documents for which to display results.
  6. To set the date range for transactions to include in the report, next to Select Date Range, select or enter the desired date range.
  7. From the File Format list, select the file format for the report.

Generate a Document Summary reconcile report

The Document Summary reconcile report shows totals for the documents in transactions you've entered in AvaTax. In HTML format, click links within the report to view more details.

To generate a Document Summary reconcile report:

  1. From the Company list, select the companyHoverTT.png from which to pull transactionsHoverTT.png for the report.
    1. To use transactions from all companies, select All.
    2. To select more than one company, hold Ctrl and click each company name.
  2. In the Customer ID field, enter the unique code referencing your customer. Typically, this is the same as the unique customer identifier you use in your accounting software.
  3. From the Country list, select the country in which the transactions occurred.
  4. From the State/Province list, select the state, province, or territory in which the transactions occurred.
  5. In the Document Code field, enter the individual document codeHoverTT.png to which the report should be restricted. To use a range of document codes, in the To field, type another document code.
  6. To show additional options to define the report, click Show Advanced Filter, and then:
    1. From the Report On Date list, select the date type to use when applying a date range.
    2. From the Document Status list, select the status of the documents for which to display results.
  7. To set the date range for transactions to include in the report, next to Select Date Range, select or enter the desired date range.
  8. From the Sort By list, select the primary sort criteria for the report.
  9. From the Then By list, select the secondary sort criteria for the report. This should be a different criteria than the one you chose from the Sort By list.
  10. From the File Format list, select the file format for the report.

Generate a Document Summary Listing reconcile report

The Document Summary Listing reconcile report shows totals, broken up by taxing jurisdictionHoverTT.png, for transactions you've entered in AvaTax. In HTML format, click links within the report to view more details.

To generate a Document Summary Listing reconcile report:

  1. From the Company list, select the companyHoverTT.png from which to pull transactionsHoverTT.png for the report.
    1. To use transactions from all companies, select All.
    2. To select more than one company, hold Ctrl and click each company name.
  2. In the Customer ID field, enter the unique code referencing your customer. Typically, this is the same as the unique customer identifier you use in your accounting software.
  3. From the Country list, select the country in which the transactions occurred.
  4. From the State/Province list, select the state, province, or territory in which the transactions occurred.
  5. From the Report Type list, select how the report is organized.
    • Listing By Taxing Jurisdiction (default) groups the transactions according to the state in which they were sourced.
    • Listing by Address groups the transactions according to the city in which they were sourced.
  6. From the Report Level list, select the level of transaction detail to include in the report. Options available vary based on the country you selected.
  7. In the Document Code field, enter the individual document codeHoverTT.png to which the report should be restricted. To use a range of document codes, in the To field, type another document code. Typically, this is the number of the document as assigned by your accounting software.
  8. To set the date range for transactions to include in the report, next to Select Date Range, select or enter the desired date range.
  9. From the File Format list, select the file format for the report.

Generate a Document Line Detail reconcile report

The Document Line Detail reconcile report shows totals of each document line within the documents in transactions you've entered in AvaTax. In HTML format, click links within the report to view more details.

To generate a Document Line Detail reconcile report:

  1. From the Company list, select the companyHoverTT.png from which to pull transactionsHoverTT.png for the report.
    1. To use transactions from all companies, select All.
    2. To select more than one company, hold Ctrl and click each company name.
  2. In the Customer ID field, enter the unique code referencing your customer. Typically, this is the same as the unique customer identifier you use in your accounting software.
  3. From the Country list, select the country in which the transactions occurred.
  4. From the State/Province list, select the state, province, or territory in which the transactions occurred.
  5. In the Document Code field, enter the individual document codeHoverTT.png to which the report should be restricted. To use a range of document codes, in the To field, type another document code. Typically, this is the number of the document as assigned by your accounting software.
  6. To show additional options to define the report, click Show Advanced Filter, and then:
    1. From the Report On Date list, select the date type to use when applying a date range.
    2. From the Document Status list, select the status of the documents for which to display results.
  7. To set the date range for transactions to include in the report, next to Select Date Range, select or enter the desired date range.
  8. From the Sort By list, select the primary sort criteria for the report.
  9. From the Then By list, select the secondary sort criteria for the report. This should be a different criteria than the one you chose from the Sort By list.
  10. From the File Format list, select the file format for the report.

Generate a Document Line Tax Detail reconcile report

The Document Line Tax Detail reconcile report shows details for a selected document, showing each taxing jurisdictionHoverTT.png within a document line. In HTML format, click links within the report to view more details.

To generate a Document Line Tax Detail reconcile report:

  1. From the Company list, select the companyHoverTT.png from which to pull transactionsHoverTT.png for the report.
    1. To use transactions from all companies, select All.
    2. To select more than one company, hold Ctrl and click each company name.
  2. In the Document Code field, enter the individual document codeHoverTT.png to which the report should be restricted. To use a range of document codes, in the To field, type another document code. Typically, this is the number of the document as assigned by your accounting software.
  3. To show additional options to define the report, click Show Advanced Filter, and then:
    1. From the Report On Date list, select the date type to use when applying a date range.
    2. From the Document Status list, select the status of the documents for which to display results.
  4. From the File Format list, select the file format for the report.

Generate an ECMS Exemption Exposure reconcile report

The ECMS Exemption Exposure reconcile report shows the total exempt exposure by company. These are exempt transactions that don't have exemption certificate entries applied. Use the drill-down ability to look at the exposure summarized by customer or at a document level.

Generate a partially complete exemption certificate entries template for import, based on the results of the ECMS Exemption Exposure Report. Complete this template and import it to update exemption certificate entries.

To generate an ECMS Exemption Exposure reconcile report:

  1. From the Company list, select the companyHoverTT.png from which to pull transactionsHoverTT.png for the report.
    1. To use transactions from all companies, select All.
    2. To select more than one company, hold Ctrl and click each company name.
  2. From the Issuing Country list, select the country that issued the exemption certificateHoverTT.png.
  3. To select the issuing region from which to include transactions, next to Select Region Listing, select a region.
    • All US States includes all states and territories available for selection in the issuing region field.
    • SST States Only
      • Show all exempt exposures: Includes SST state's exemption exposures using the selected date range for the report. This option doesn't take into account the customer SST effective membership date or the SST state's effective date in the SST program.
      • Show SST exempt exposures only: Includes SST state's exemption exposure using the selected date range for the report. This option takes into account both the customer SST effective membership date and the SST state's effective date in the SST program.
  4. From the Issuing Region list, select the region (state, province, or territory) that issued the exemption certificate based on the issuing country.
  5. To set the date range for transactions to include in the report, next to Select Date Range, select or enter the desired date range.
  6. From the File Format list, select the file format for the report.

Generate an ECMS Exemption Exposure Aging reconcile report

The ECMS Exemption Exposure Aging reconcile report shows groups of exemption exposure documents by company. These are exempt transactions that don't have exemption certificate entries applied. Exposures display in four groups: current, greater than 30 days, greater than 60 days, greater than 90 days.

To generate an ECMS Exemption Exposure Aging reconcile report:

  1. From the Company list, select the companyHoverTT.png from which to pull transactionsHoverTT.png for the report.
    1. To use transactions from all companies, select All.
    2. To select more than one company, hold Ctrl and click each company name.
  2. From the Issuing Country list, select the country that issued the exemption certificateHoverTT.png.
  3. To select the issuing region from which to include transactions, next to Select Region Listing, select a region.
    • All US States includes all states and territories available for selection in the issuing region field.
    • SST States Only
      • Show all exempt exposures: Includes SST state's exemption exposures using the selected date range for the report. This option doesn't take into account the customer SST effective membership date or the SST state's effective date in the SST program.
      • Show SST exempt exposures only: Includes SST state's exemption exposure using the selected date range for the report. This option takes into account both the customer SST effective membership date and the SST state's effective date in the SST program.
  4. From the Issuing Region list, select the region (state, province, or territory) that issued the exemption certificate based on the issuing country.
  5. From the File Format list, select the file format for the report.