Reconciling tax transactions 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 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
- In NetSuite on the Avalara menu, point to Reconciliation and then click Create Batch.
- 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
- Next to Batch Name, type a name for the batch, and then at the upper left, slick Submit.
View and reconcile transaction data
- In NetSuite on the Avalara menu, point to Reconciliation and then click View Results.
- On the Reconciliation Batches page, next to the batch that you created, click View Details.
- On the Reconciliation Results page, note the following fields and follow the appropriate steps:
- Only AvaTax: These transactions are only in AvaTax 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 AvaTax is valid, the best practice is to void it in AvaTax. Then recreate the transaction in NetSuite and post it to AvaTax. 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 AvaTax 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 AvaTax. This almost never happens, so you can safely ignore this field.
- AvaTax and NetSuite: These transactions are in AvaTax and NetSuite but not the Custom Record. This might happen if you install a new NetSuite bundle, but it doesn't affect how Connector for NetSuite works, so you can safely ignore this field.
- AvaTax and Custom Record: These transactions are in AvaTax 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. This might happen if a transaction in AvaTax 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.
- To view any of these transactions, under SUBLIST CRITERIA, click a criteria, and in the Results pane, click a Document Code.
- If the transactions and total amounts in the Reconciliation Results pane are the same for AvaTax and NetSuite, go to Schedule and Approve Returns in AvaTax and approve and file your taxes.