ANS-1668 · SUITETAX & TAX MANAGEMENT
How to Display ES-IE VAT Codes in NetSuite’s Return of Trading Details Report?
Ensure accurate reporting of EC sales and purchases in the Ireland Return of Trading Details by configuring specific preferences and the ES-IE tax code.
Short answer
To include ES-IE VAT codes in the NetSuite Return of Trading Details report, verify 'Report by Period' is 'All Reports', configure the 'Supplementary Tax Calculation' plug-in, and ensure the ES-IE tax code has specific properties like 0% Tax Rate, 'EC Code' as 'yes', and 'Notional Rate' set to 'Standard Rate', while unchecking Export and Import boxes. This solution is not applicable if SuiteTax is enabled.
Scenario
Users generating the Return of Trading Details report in NetSuite may find that certain VAT codes, specifically ES-IE (used for EC sales/purchases within EU countries), are not appearing in the report. This omission prevents a complete breakdown of sales tax incurred based on VAT code categories, impacting compliance for Irish trading returns.
Solution
To ensure the ES-IE VAT code is correctly displayed in the Return of Trading Details report, follow these configuration steps. This solution is applicable only if the 'SuiteTax' feature is NOT enabled in your NetSuite account, as the 'Supplementary Tax Calculation SuiteApp' is incompatible with 'SuiteTax'.
Verify the following preferences for correct setup:
- Navigate to Home > Set Preferences > Analytics Tab
- Confirm 'Report by Period' preference is set to 'All Reports'.
- Go to Customization > Plug-ins > Plug-in Implementations
- Click 'view' for 'Supplementary Tax Calculation'.
- Click 'Configure'.
- Check if "Asynchronous" = T.
- On the Manage Plug-In Implementations page, check if "Supplementary Tax Calculation" = T.
Edit the ES-IE tax code with the following properties:
- Tax Rate = 0%
- EC Code = yes
- Notional Rate = choose the Standard Rate
- Available On - Both Purchases/Sales
- Tax Type/ Tax AgencyUncheck the Export and Import boxes, as these are exclusively used for trades outside EU Countries.After completing these steps, refresh the report. The amounts of transactions associated with the ES-IE tax code will then appear in box D4 on the Ireland trading return.
Expert NetSuite Support
Need help with this NetSuite issue?
SuiteTax & Tax Management consulting and configuration support