Skip to main content
Avalara Help Center

Why does the report data not match my liability worksheet totals?

Overview

The transaction detail in reports does not match what is showing on the liability worksheet.

Environment

Avalara AvaTax

Resolution

  • This is generally caused by tax types not matching from the transactions to the type of tax being filed on your return.
    • A simple way to verify would be to run the Sales and Sellers Use Tax Summary report to see what tax type the transactions are calculating.
    • Compare this with the tax type listed on your registration and filing calendar with the jurisdiction.
      • Each jurisdiction will have your company registered for a specific tax type to collect and remit.
    • You can also check the tax type listed in Nexus.
  • Check to make sure if any carry-over credits were applied or excluded.
  • Review your liabilities for any transaction discounts.
  • Vendor discounts will not appear on reports other than the Liability Worksheet exports.
    • Prior period discounts will reduce the Remit to Avalara amounts.
    • Current period discounts will reduce the Return Remittance amounts.
  • Jurisdictional adjustments will not appear on reports other than the Liability Worksheet exports.
    • Adjustments specific to jurisdictions such as the WA Business and Occupation (B&O) tax are not calculated on transactions.
  • Prepayments and prior payments will not appear on reports other than the Liability Worksheet exports.
    • Prepayments are accelerated payments for future periods that are added on top of the tax liability.
    • Prior payments are payments that have already been made to the jurisdiction and reduce the amount due.
  • Check the return filing frequency.
    • If it is the middle of the cycle, you will see tax liability but nothing due.
  • If the period is locked, check the status date of the transactions.
    • Transactions posted to AvaTax after the worksheet has been approved or approved on behalf will not be included on the return.
    • These amounts will show on the summary line of the state on the liability worksheet.
  • Check to see when the reports last updated.
    • Reports update every hour.
    • If changes have been made since the last update, they will be displayed on the liability worksheet but not on reports.
    • You can export your transactions from the transactions tab and use Excel to total up the sales and tax amounts to match with the liability worksheet.
  • If the tax types are matching, try to rebuild the liability worksheet.
  • If nothing changes, please contact support.

Internal Notes Section: