The Walmart - NetSuite integration app's tax settings control how sales tax from Walmart orders comes into NetSuite: as Walmart's tax rates, as NetSuite's own calculation, or as a single tax line item. This article shows how to check your NetSuite tax setup, choose and configure the tax option, and import orders with zero sales tax for states where Walmart collects and remits the tax as a marketplace facilitator. It's for integrator.io users who set up the order flows.
Check your NetSuite tax setup
Some tax settings depend on whether NetSuite applies taxes at line level or body level.
- In NetSuite, go to Setup > Accounting > Taxes > Set Up Taxes.
- Check Per-line taxes on transactions. If it's selected, taxes apply at line level. If it's cleared, taxes apply at body level.
Choose how tax comes into NetSuite
The tax settings are under Settings > General > Tax. The option you select in How would you like to bring sales tax into NetSuite? decides which other settings appear.
Overwrite taxes with Walmart tax amounts
This is the recommended option for most sellers. The integration app overwrites the NetSuite tax rate with the tax rate from Walmart, and NetSuite calculates the order's tax amount from that rate. These settings appear:
- Per-line taxes on transaction enabled in NetSuite: Select this if Per-line taxes on transactions is selected in NetSuite, so tax amounts appear on each line item. Clear it if taxes apply at body level in NetSuite.
- Default tax code when no match is found in NetSuite: Required. NetSuite selects each order's tax code from the shipping address, and an order fails when there's no match. Enter the internal ID of a NetSuite tax code to use when no tax code matches. To find the ID, in NetSuite go to Setup > Accounting > Taxes > Tax Codes, and select View for the tax code; the internal ID is in the page URL. You can use an existing tax code or create one.
- Assign the default tax code to all orders: Select this to assign the default tax code to every order or line item from Walmart. It requires a value in Default tax code when no match is found in NetSuite.
NetSuite calculates taxes using its own tax engine
NetSuite calculates and applies taxes to the sales orders using its own tax rules. No other settings appear.
Add total tax against a single line item in NetSuite
Use this option if you don't want Walmart tax rates to override NetSuite's. The Walmart tax total is added to each sales order as a single line item. These settings appear:
- Per-line taxes on transaction enabled in NetSuite: As described for Overwrite taxes with Walmart tax amounts.
- NetSuite item to track Walmart tax amount as a line item: The NetSuite item that carries the Walmart tax total on the sales order. Create a non-inventory item in NetSuite for this. Clearing Can be Fulfilled/Received on that item record is recommended.
Import zero tax for marketplace facilitator states
Walmart calculates, collects, files, and remits sales tax for orders shipped to customers in these states: WA, MN, CT, IA, OK, PA, SD, NJ, AL, DC, NE, SC, NY, ID, AR, IN, KY, NM, ND, RI, VA, VT, WV, WY, OH, AZ, CA, CO, ME, MD, MA, NV, TX, UT, HI, WI, IL, MI, NC, and GA. Orders shipped to these states must be imported into NetSuite with zero sales tax. For Walmart's details, see Walmart sales tax collection.
To import these orders with zero tax, add mappings to the order flow that overwrite the tax calculation:
- In the integration app, go to Flows > Order, and select Mapping for Walmart order to NetSuite order Add.
- Add the mappings for your NetSuite tax setup, from Mappings for body-level taxes or Mappings for line-level taxes.
- Save the mappings.
The next time the flow runs, orders shipped to these states are imported with zero sales tax. To see the imported taxes, open the sales order in NetSuite and go to Etail > ETAIL TAX TOTAL VARIANCE.
Note: The expressions apply to every state except AK, DE, FL, KS, LA, MS, MO, MT, NH, OR, and TN. Change the list of states in the expressions to match the states you need.
Mappings for body-level taxes
Map this expression to istaxable:
{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}F{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}Map this expression to taxrate:
{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}0{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}Mappings for line-level taxes
Map this expression to item[*].taxrate1:
{{#if orderLines.orderLine[*].item.sku}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}0{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{else}}{{/if}}Map this expression to item[*].taxAmount:
{{#if orderLines.orderLine[*].item.sku}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}0{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{else}}{{/if}}Map this expression to shippingtax1rate:
{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'AK'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'DE'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'FL'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'KS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'LA'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MS'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MO'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'MT'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'NH'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'OR'}}{{#compare (uppercase shippingInfo.postalAddress.state) '!==' 'TN'}}0{{else}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}{{/compare}}