Skip to main content
Avalara Help Center

Reconcile Tax Transactions

This article applies to:Avalara AvaTax for NetSuite

ReconcilingHoverTT.png tax transactionsHoverTT.png is a three-step process in NetSuite. First, create a batch of transactions to reconcile. Second, view the transaction data in NetSuite and compare it to what AvaTax Update shows. Third, correct any discrepancies between the transactions in NetSuite and AvaTax Update. AvaTax Update for NetSuite can reconcile up to 5,000 transactions at a time.

Create a batch of transactions to reconcile

  1. In NetSuite on the Avalara menu, point to Reconciliation and then click Create Batch.
  2. On the Create Reconciliation Batch page, select data in any of the following fields to find a batch of NetSuite transactions:
    • Starting Date and Ending Date
    • Subsidiary
  3. Next to Batch Name, type a name for the batch, and then at the upper left, slick Submit.

View and reconcile the transaction data

  1. In NetSuite on the Avalara menu, point to Reconciliation and then click View Results.
    NetSuite2014_Reconcile4.png
  2. On the Reconciliation Batches page, next to the batch that you created, click View Details.
    NetSuite2014_Reconcile5.png
  3. On the Reconciliation Results page, note the following fields and follow the appropriate steps:
    • Only AvaTax: These transactions are only in AvaTax Update and not in NetSuite or the Custom Record, a database that updates data in NetSuite to make AvaTax Update work. You might want to see if someone deleted the transaction in NetSuite. If the transaction in AvaTax Update is valid, the best practice is to void it in AvaTax Update. Then recreate the transaction in NetSuite and post it to AvaTax Update. That way, it'll be in AvaTax Update, NetSuite, and the Custom Record as it should be.
    • Only NetSuite: These transactions are only in NetSuite and not in AvaTax Update or the Custom Record. If this happens, open these transactions in NetSuite, calculate sales tax using AvaTax Update for NetSuite, and then save them.
    • Only Custom Record: These transactions are only in the Custom Record and not in NetSuite and not in AvaTax Update. This almost never happens, so you can safely ignore this field.
    • AvaTax and NetSuite: These transactions are in AvaTax Update and NetSuite but not the Custom Record. This might happen if you install a new NetSuite bundle, but it doesn't affect how AvaTax Update for NetSuite works, so you can safely ignore this field.
    • AvaTax and Custom Record: These transactions are in AvaTax Update and the Custom Record but not NetSuite. This almost never happens, so you can safely ignore this field.
    • NetSuite and Custom Record: These transactions are in NetSuite and the Custom Record but not AvaTax Update. This might happen if a transaction in AvaTax Update is deleted.
    • AvaTax, NetSuite, and Custom Record: These transactions are in all three places just as they should be, so you don't need to do anything with them.
    • Reconciled: These transactions are already reconciled, so you can safely ignore this field.
      NetSuiteOneWorld2014_Reconcile6.png
  4. To view any of these transactions, under SUBLIST CRITERIA, click a criteria, and in the Results pane, click a Document Code.
    NetSuiteOneWorld2014_Reconcile7.png
  5. If the transactions and total amounts in the Reconciliation Results pane are the same for AvaTax Update and NetSuite, go to the Liability Worksheet and approve and file your taxes.
  • Was this article helpful?