Financial & Tax Utilities

Freelance Invoice Guide: How to Calculate Inclusive vs Exclusive GST, VAT, and Line Discounts

Learn the exact mathematical formulas for tax-exclusive vs tax-inclusive invoicing, pre-tax trade discounts, CGST/SGST vs IGST splits, and essential invoice fields.

By Cometflow Financial Tools Desk • Updated 2026-10-19

Rounding errors and incorrect tax-extraction formulas are the #1 reason corporate accounts-payable departments reject freelancer and agency invoices. Whether you are billing under 18% GST, 20% UK/EU VAT, or state sales tax, your invoice must clearly distinguish between Tax-Exclusive and Tax-Inclusive line items.

1. Exact Tax Formulas (Exclusive vs. Inclusive)

// 1. TAX-EXCLUSIVE (Adding 18% tax on top of a $1,000 net fee):
Tax_Amount  = Net_Price * (Tax_Rate / 100)       // $1,000 * 0.18 = $180.00
Gross_Total = Net_Price + Tax_Amount             // $1,180.00

// 2. TAX-INCLUSIVE (Extracting 18% tax from a fixed $1,000 gross quote):
Net_Price   = Gross_Total / (1 + Tax_Rate / 100) // $1,000 / 1.18 = $847.46
Tax_Amount  = Gross_Total - Net_Price            // $1,000 - $847.46 = $152.54

2. Mandatory Fields on a Compliant Commercial Invoice

  • Unique Sequential Invoice Number: e.g., INV-2026-0042 (never reuse numbers across clients).
  • Supplier & Buyer Tax Identifiers: GSTIN, VAT Registration Number, or EIN, along with full registered billing addresses.
  • Itemized Description, Quantity, and Unit Rate: Clear breakdown before tax, plus explicit tax rate percentage and currency code.

Create and print itemized invoices with automatic tax-inclusive or tax-exclusive math using our free Invoice & Receipt Generator.

Frequently Asked Questions

Why can I not just subtract 18% from a tax-inclusive total to find the pre-tax price?

Because the 18% tax was calculated on the net base amount, not the gross total. To extract 18% tax from a $1,180 gross total, divide by 1.18 ($1,180 / 1.18 = $1,000 net base, $180 tax). Subtracting 18% directly would wrongly give $967.60.

Should a discount be applied before or after calculating GST/VAT?

Standard commercial trade discounts are deducted from the gross subtotal before calculating GST or VAT, so tax is charged only on the actual net consideration payable.