Magento v2 Troubleshooting

Rounding Issues in Magento v2 and Recommended Settings

Magento 2 contains many different options for calculating VAT on products. This can occasionally cause discrepancies between the values shown in Magento and the values calculated by your accounting system.

The simplest way to eliminate these discrepancies is to ensure that Magento is calculating tax amounts in the manner that most closely resembles the way your accounting system does. To that end, we advise using the following options within Magento 2.

All of the below can be found in the set up area of Magento 2, located within Stores > Configuration > Tax > Calculation Settings:

Magento 2 Tax Settings

Magento Setting	Option
Tax Calculation Method Based On	Row Total
Catalog Prices	Excluding Tax
Shipping Prices	Excluding Tax
Apply Customer Tax	After Discount
Apply Discount On Prices	Excluding Tax

Before making any changes to these settings, we recommend discussing the above with your accountant to make sure they are happy these comply with your processing methods as a business.