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 the Admin Console shows. Third, correct any discrepancies between the transactions in NetSuite and AvaTax. AvaTax 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 the Admin Console and not in NetSuite or the Custom Record, a database that updates data in NetSuite to make AvaTax work. You might want to see if someone deleted the transaction in NetSuite. If the transaction in the Admin Console is valid, the best practice is to void it in the Admin Console. Then recreate the transaction in NetSuite and post it to the Admin Console. That way, it'll be in AvaTax, NetSuite, and the Custom Record as it should be.
    • Only NetSuite: These transactions are only in NetSuite and not in the Admin Console or the Custom Record. If this happens, open these transactions in NetSuite, calculate sales tax using AvaTax for NetSuite, and then save them.
    • Only Custom Record: These transactions are only in the Custom Record and not in NetSuite and not in the Admin Console. This almost never happens, so you can safely ignore this field.
    • AvaTax and NetSuite: These transactions are in the Admin Console and NetSuite but not the Custom Record. This might happen if you install a new NetSuite bundle, but it doesn't affect how AvaTax for NetSuite works, so you can safely ignore this field.
    • AvaTax and Custom Record: These transactions are in the Admin Console 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 the Admin Console. This might happen if a transaction on the Admin Console 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 and NetSuite, go to the Liability Worksheet and approve and file your taxes.