Skip to main content
Avalara Help Center

Why do the transactions on my import template not match the imported transactions in the Admin Console?

Overview

You have imported transactions to the Admin Console. To make sure you entered the transactions correctly, you total the Line Amount and Tax from the import template and compare it to the totals from the Liability Worksheet or Transactions tab. You find the totals do not match and would like to know why?

Environment

Avalara AvaTax

Resolution

  • Discrepancies between the import template and the Transactions tab or Document Summary report can happen if you use negative Quantities and negative Amounts on the import template
    • For example: QTY: -2 , Amount: -48
    • Since AvaTax is not an inventory management system, the service does not see the negative quantity as a return to inventory.
  • To determine tax, the following calculation is done: (Amount/Quantity)*Tax Rate
    • In our example:
      • QTY: -2 , Amount: -48 , Tax Rate: 6%
      • (Amount/Quantity)*Tax Rate
      • (-48/-2)0.06 = (24)0.06 
        • Tax = 1.44
        • Total per item = 24+1.44 = 25.44
        • Total per line = 25.44*2 = 50.88
      • The service will then break out the amount for display on the Admin Console: 
        • Line total = 50.88
        • Tax total per line = 2.88
        • Line amount = 48  (found by taking the line total and subtracting the total tax 50.88 - 2.88 = 48)
    • Due to this function above, the transactions are being imported with positive line amounts, even though you entered the line amounts on the import as negative.
  • You can also run into issues where line amounts entered on the import as positive line amounts are displayed in the Admin Console as negative amounts.
    • This can occur if you list a negative Quantity and a positive line Amount, for example:
      • QTY: -2 , Amount: 48 , Tax Rate: 6%
      • (Amount/Quantity)*Tax Rate
      • (48/-2)0.06 = (-24)0.06
        • Tax = -1.44
        • Total per item = -24 + -1.44 = -25.44
        • Total per line = -25.44*2 = -50.88
      • The service will then break out the amount for display on the Admin Console: 
        • Line total = -50.88
        • Tax total per line = -2.88
        • Line amount = -48  (found by taking the line total and subtracting the total tax (-50.88) - (- 2.88) = -48)