GST Guides & Resources
Step-by-step articles and formula guides to help you navigate GST across different jurisdictions.
How to Calculate GST in Excel
Master GST calculations in spreadsheets with our Excel formula guide, including the manual GST formula and magic divisor reference.
Automate your tax accounting. Learn how to set up professional GST templates in Excel and Google Sheets, with the underlying GST calculation formula and quick divisors for every rate.
Need a Calculation?
Our specialized tools can help you with specific GST scenarios instantly.
View All ToolsGST Guides FAQ
Q1.Where do I start if I'm new to GST?
Start with GST Basics for Beginners on this page, then try the Simple GST Calculator on the home page. For the exact formulas and Excel implementation, read 'How to Calculate GST in Excel'.
Q2.Which guide covers adding or removing GST in Excel?
The guide 'How to Calculate GST in Excel' covers formulas for both exclusive (add tax) and inclusive (extract tax) in Excel and Google Sheets, with step-by-step examples and a magic divisor table for every rate.
Q3.How do I choose the right calculator for my task?
Use the Tools Directory: quick totals (Simple or Professional), extract tax from a total (Inclusive/Reverse), add tax to a price (Exclusive), or compliance (ITC, interest, late fee). Each tool page explains when to use it.
Q4.Are these guides applicable outside India?
Yes. The math (inclusive vs exclusive, formulas) is the same for GST, VAT, and consumption tax globally. Rates and rules differ by country; the guides focus on the calculation logic that works everywhere.
Q5.Do you have a formula reference for manual calculation?
Yes. The Excel guide includes the standard GST formula (Net × Rate for exclusive; Total ÷ (1 + Rate) for inclusive), plus a magic-divisor table for 5%, 10%, 15%, 18%, 20%, and 28% rates.