Magento - Tax Excluding Total and Including Total the same

Magento - Tax Excluding Total and Including Total the same

August 5, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento - Tax Excluding Total and Including Total the same

Solving Magento Tax Calculation Issues: A Comprehensive Guide

Dear reader,

I understand your frustration as a business owner trying to configure tax settings in Magento. The platform can be complex, especially when it comes to tax calculation rules. In this post, I’ll guide you through the process of correctly setting up taxes in Magento and resolving the issue you’re facing.

Understanding Magento’s Tax Calculation Process

Magento calculates tax based on a series of configurable settings:

  1. Tax Rate: This is the percentage applied to eligible products.
  2. Product Tax Class: A way to group products with similar tax behavior.
  3. Customer Group: A way to categorize customers for pricing and tax purposes.
  4. Tax Zone: A geographical area where specific tax rates apply.

Your Current Configuration Analysis

You’ve done a great job setting up the basic configuration:

  • You have one Product Tax Class, one Customer Group, and one Tax Zone (UK @ 20%).
  • The Product Tax Class is applied to your product.
  • The Customer Group is applied to your customer account.
  • The Tax Zone correctly reflects the UK tax rate.

The Issue: Tax Calculation Mismatch

The problem lies in Magento’s default tax calculation settings. By default, Magento calculates taxes based on the product price including tax. However, you’ve specified that the product price is “excluding tax,” which means Magento should calculate taxes separately.

Steps to Resolve the Tax Calculation Error

1. Verify Your Product’s Price Type

Ensure your product has the correct price type set in the backend:

  • Go to Catalog > Products.
  • Select your product and click on the edit button (pencil icon).
  • In the General section, check that the “Price” field is set to “Excluding Tax.”
  • Save your changes.

2. Check Your Tax Calculation Settings

Ensure Magento’s tax calculation settings are configured correctly:

  • Go to Stores > Configuration > Sales > Tax.
  • Scroll down to the TAX CALCULATION SETTINGS section.
  • Set the following:
    • Tax Calculation Method Based On: Row Total
    • Shipping Tax Class: None
  • Click on Save Config.

3. Clear Cache and Re-index

You mentioned you’ve already cleared the cache and re-indexed, which is great! This step ensures that Magento uses the latest data for tax calculations.

Conclusion

Resolving this issue requires a careful review of your product’s price type setting and Magento’s global tax calculation settings. The key lies in ensuring consistency between these two configurations.

Remember, Magento is designed to be flexible but can sometimes behave unexpectedly if there are inconsistencies in the configuration. Always ensure that your product prices accurately reflect the tax status you’ve specified (including or excluding tax).

If you’re still facing issues after following these steps, I recommend reaching out to our support team at Laravel Company. We specialize in Magento development and can provide personalized assistance.

Happy selling!

Catalog Configuration Customers Pricing

Our network