Import and Update the Sales Tax Tables in Your NetSuite Account

NetSuite enables you to import up-to-date sales tax codes for each state. Each month, NetSuite updates its database table that stores the tax rates for all U.S. states. The Version field on the State Tax Import page indicates the effective date of the tax rate change.

NetSuite receives the tax table updates from Avalara. To keep your state sales tax tables up-to-date, you must reimport tax rates when tax rates change. The availability of tax table updates does not always coincide with the effective dates of tax rate changes. For example, an updated tax table may be already available but the rate change will take effect at a later date. Consult your tax agency to ascertain the dates when the changes to the tax rates take effect. Then, reimport the updated tax table at the appropriate time.

Be aware: NetSuite tax rates for U.S. are determined by zip codes.

Before doing any updates on the Sales tax tables, I would suggest coordinating with all the departments: Retail, Web, others, to confirm that this update/import is not going to impact any of the tax codes/groups they are using. The update will inactivate the tax groups/codes that are no longer valid and create new ones.

To import sales tax tables:

Tax TipandTrick Img 1

After the import, NetSuite sends a confirmation message to the email address on the Company Information page. To view the tax codes, you imported, go to Setup > Accounting > Taxes > Tax Codes.

Important:

 

To edit a sales tax code:

Tax TipandTrick Img 2