Margin & VAT Calculator

Margin is computed from the selling price: (selling price - cost) / selling price. The problem is that listed retail prices usually already include VAT, while your costs exclude tax, so the formula compares unlike quantities. Example: cost Rp100,000, price Rp150,000 including 12% VAT. The ex-VAT price = Rp150,000 / 1.12 = Rp133,928.57, so the true margin = (Rp133,928.57 - Rp100,000) / Rp133,928.57 = 25.33%. If you wrongly use the inc-VAT price, the margin looks like (Rp150,000 - Rp100,000) / Rp150,000 = 33.33%: it looks 8.00 points bigger. VAT is money held for the government, not your revenue, so it must be removed first before computing margin.

The formula is: ex-VAT price = inc-VAT price / (1 + rate / 100), then VAT = inc-VAT price - ex-VAT price. Example at a 12% rate: Rp150,000 / 1.12 = Rp133,928.57, so the included VAT = Rp150,000 - Rp133,928.57 = Rp16,071.43. Note: the VAT is not 12% of the inc-VAT price (Rp18,000); that is wrong, because the rate applies to the ex-VAT price, not to the tax-inclusive price.

Use the ex-VAT price for margin and profit analysis: costs and selling prices must both exclude tax to be comparable. Use the inc-VAT price for what consumers pay: shelf prices, receipts, and the checkout. Mixing the two in one margin formula is the most common mistake: comparing an ex-VAT cost against an inc-VAT price makes the margin look bigger than it really is.

A gross margin calculator computes the pure margin from sales and COGS without a VAT correction: the right choice when your selling price is genuinely ex-VAT. This calculator adds one layer: it extracts VAT from the inc-VAT price first, then computes the true margin. If your price excludes tax, use a gross margin calculator; if the listed price includes tax, use this calculator.

A GST calculator handles the tax itself: adding or removing GST from a price and splitting it into CGST, SGST, or IGST components. This calculator handles business margin when the selling price already includes tax: the question is not 'how much is the tax' but 'what is my true margin after the tax is removed'. They complement each other: GST for tax matters, this calculator for margin matters.

Indonesia's VAT rate is 12% since 1 January 2025 under the HPP Law. Previously it was 10% until 31 March 2022, then 11% from 1 April 2022 until 31 December 2024. Rates can change and may differ for certain goods or services, so check the latest rules before using them for business decisions. This calculator accepts any rate from 0% to 100%, so it stays useful even if the rate changes.

Use Solver mode: minimum ex-VAT price = cost / (1 - target margin), then inc-VAT price = ex-VAT price x (1 + rate). Example: cost Rp100,000, target margin 25%, 12% VAT: ex-VAT price = Rp100,000 / 0.75 = Rp133,333.33, so the inc-VAT selling price = Rp133,333.33 x 1.12 = Rp149,333.33. Solver mode can also work backward: the maximum VAT rate that still lets you hit the target margin at a given inc-VAT price.

Margin = (price - cost) / price: profit as a share of the selling price. Markup = (price - cost) / cost: profit as a share of the cost. On a Rp100 cost sold at Rp133.33 ex-VAT, the margin is 25% but the markup is 33.33%. Convert with: markup = margin / (1 - margin); margin = markup / (1 + markup).

Use markup = margin / (1 - margin). A 25% margin converts to 0.25 / 0.75 = 33.33% markup. The reverse: margin = markup / (1 + markup), so 25% markup = 0.25 / 1.25 = 20% margin. Margin can never exceed 100%, but markup can.

It varies enormously by industry: grocery retail runs 1-3% net margins, restaurants 3-9%, and software 70%+ gross margins. Compare against your own industry's benchmarks, not a universal number. What matters is whether the margin covers your operating costs and leaves the return you need.

Always after removing tax. Compute margin on ex-VAT prices for both cost and selling price so the ratio reflects your economics, not the tax collector's. Consumer-facing price lists show inc-VAT prices, but every internal margin report should use ex-VAT figures.

Gross margin = (revenue - cost of goods sold) / revenue: production profitability only. Net margin = net profit / revenue: after operating expenses, interest, and taxes. This calculator's 'true margin' is a gross-margin concept with the VAT layer stripped out; subtract your operating costs to approach net margin.

Apply the discount to the inc-VAT shelf price first, then strip VAT from the discounted price before computing margin. Example: Rp150,000 with 10% off = Rp135,000; ex-VAT = 135,000 / 1.12 = Rp120,535.71; margin on Rp100,000 cost = (120,535.71 - 100,000) / 120,535.71 = 17.04%. Discounts eat margin fast: verify with the calculator.

Convert both to the same basis before comparing: strip VAT from your selling price (divide by 1 + rate/100) and compare directly against the ex-VAT supplier quote. Never compare an ex-VAT cost against an inc-VAT price; the margin will look better than it is by roughly the VAT rate.

No. Margin = profit / selling price, and profit can never exceed the selling price itself, so margin tops out just under 100%. Markup = profit / cost has no such ceiling: selling at triple the cost is a 200% markup. If someone quotes a '150% margin', they mean markup.