tax at a time with this three-step process.
- In NetSuite, create a batch of transactions to reconcile
- View the transaction data in NetSuite and compare it to the data from the Admin Console
- Correct any discrepancies between the transactions in NetSuite and AvaTax
In NetSuite, the Custom Record saves the transaction details like the transaction ID, calculated sales tax, total taxable amount, total amount, etc. The Custom Record is useful during reconciliation, especially when a transaction is deleted.
For help troubleshooting reconciliation issues, see Troubleshoot Reconciliation Discrepancies.
Create a batch of transactions to reconcile
- In NetSuite, go to Avalara > Reconciliation > Create Batch.
- On the Create Reconciliation Batch page, use the fields to narrow down the transactions you'd like to include in the batch.
- Choose a Batch Name, and then click Submit.
View and reconcile transaction data
- In NetSuite, go to Avalara > Reconciliation > View Results.
- On the Reconciliation Batches page, next to the batch that you created, click View Details.
- On the Reconciliation Results page, use the Sublist Criteria dropdown to view specific groups of transactions:
- Only AvaTax: These transactions are only in the Admin Console and not in NetSuite or the Custom Record. The transaction may have been deleted from 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, the transaction appears 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 or the Admin Console. This rarely happens.
- 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 they're not NetSuite. This rarely happens.
- NetSuite and Custom Record: These transactions are in NetSuite and the Custom Record, but they're 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.
- Once you've made a selection from the SUBLIST CRITERIA dropdown, in the Results pane, click the Document Code to view the transaction of your choice.
- Once the 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.