Import of Taxes: Manual Tax Setup
If you plan to use only MYOB Acumatica (without a dedicated tax calculation provider) for tax calculation and reporting, you perform the following general steps:
- Configure manual tax calculation rules in the Shopify store. For information, see General set-up steps and tax reports in the Shopify documentation.
- Implement the tax functionality by configuring a tax agency, tax zones, tax categories,
and sales taxes.
For detailed information about configuring sales taxes in MYOB Acumatica, see Implementing Taxes.
Important:The manual tax configuration should match in the Shopify store and in MYOB Acumatica, otherwise issues might occur during the synchronization of entities. Tax categories and taxes in MYOB Acumatica should be configured in the same way as tax rates and exemptions in Shopify. If you use different names for a tax or an exemption in both systems, you should map tax IDs in the substitution list specified in the Tax List box and tax categories in the substitution list specified in the Tax Category List box on the Order Settings tab of the Shopify Stores (BC201010) form. If during the import of a sales order, the system cannot find the tax ID or tax category specified in the order, it will check to see if there is a mapping defined for the tax ID or tax category in these substitution lists.
Taxes that have the same name in the Shopify store and MYOB Acumatica (or that have been mapped via the substitution list) should be defined with exactly the same rates. Although an order for which the taxes have different rates will be imported successfully, when an invoice is prepared for this imported sales order, the taxes are recalculated based on the tax settings configured in MYOB Acumatica. If the tax rates differ, there will be a discrepancy between the amount of the invoice created in MYOB Acumatica and the amount of the order created in the Shopify store.
- Specify the tax synchronization settings on the Order Settings
tab of the Shopify Stores (BC201010) form as follows:
- Tax Synchronization: Selected
- Default Tax Zone: The tax zone that the system will assign to the order if no tax zone has been identified during the order import.
- Use as Primary Tax Zone: Cleared
Determination of the Tax Zone
During the import of an order, the system searches for the tax zone that should be used for tax calculation as follows, stopping the search when it finds a qualifying tax zone:
- The system searches for the primary tax zone.
- The system searches for the tax zone of the customer location.
- The system tries to determine the tax zone based on the zip code of the shipping address.
- The system searches for the default tax zone.
This process is illustrated in the following diagram.