GST Calculation Guide: Inclusive vs Exclusive Tax Formulas

What is Goods and Services Tax (GST)?

The Goods and Services Tax (GST) is a comprehensive, multi-stage, destination-based indirect tax levied on the manufacturing, sale, and consumption of goods and services across numerous countries (such as India, Australia, Canada, New Zealand, and Singapore).

In day-to-day commercial invoicing and retail pricing, businesses routinely perform two distinct mathematical operations: adding GST to a net base price (GST Exclusive) and extracting the tax amount from a final retail price (GST Inclusive).

1. How to Calculate GST Exclusive (Adding Tax)

When quoting net prices to business clients (B2B), the quoted rate typically excludes tax. To determine the tax amount and total gross price:

Example: Suppose you provide web consulting services valued at $2,000 net, subject to an 18% GST rate:

• GST Amount = ($2,000 x 18) / 100 = $360
• Total Invoice Payable = $2,000 + $360 = $2,360

2. How to Calculate GST Inclusive (Reverse Tax Extraction)

In consumer-facing retail (B2C), product prices displayed on shelves or e-commerce stores are legally mandated to be "all-inclusive". When accounting for sales revenue, a business must extract the base revenue from the collected tax:

Example: Suppose you sell a digital product for $118 all-inclusive at an 18% GST rate:

• Net Base Price = $118 x (100 / 118) = $100
• Extracted GST Amount = $118 - $100 = $18

Common GST Accounting Pitfalls

• Applying Simple Percentages to Inclusive Prices: A frequent mistake is calculating 18% of $118 ($21.24) and subtracting it. This results in mathematical accounting errors because the 18% must apply to the base price, not the total.
• Input Tax Credit (ITC) Reconciliation: Small businesses should always preserve vendor GST invoices so that tax paid on purchases can offset tax collected on outbound sales.