GST in Excel: The Complete Guide for Indian Small Businesses (2026)

Last updated: 27 June 2026 · Built around the GST 2.0 rate structure (Nil / 5% / 18% / 40%) and the 2026 return rules.

You can run almost your entire GST workflow in Excel — calculating CGST, SGST and IGST, raising tax invoices with auto-numbering, looking up HSN codes and rates, building GSTR-1 summaries, and reconciling GSTR-2B against your purchase register. Excel is offline, free of monthly fees, and already on your computer — which is why most Indian small businesses still keep their books there. This guide shows the formulas and templates for each task, then how Ankeshan automates them inside the same Excel you already use.

Key takeaways

Excel handles the full GST cycle: tax calculation, invoicing, HSN lookup, return summaries, and reconciliation — no subscription required.
Tax split rule: same-state sales use CGST + SGST (half each); inter-state sales use IGST (the full rate). One formula decides which, based on place of supply.
Current rates are Nil / 5% / 18% / 40% — the old 12% and 28% slabs were abolished on 22 September 2025. Keep your rate table updated.
Reconciliation is where Excel shines: VLOOKUP/XLOOKUP and MATCH let you match GSTR-2B against your purchase register to protect Input Tax Credit (ITC).
An Excel-prepared invoice is legally valid if it carries every field required by CGST Rule 46 — Excel is a tool, not a barrier.
The weak point is manual re-keying. Updating rates, renumbering invoices, and copy-pasting between sheets is where errors and mismatches creep in.

Fact box. India's GST runs on four main slabs — Nil, 5%, 18% and 40% — after the GST 2.0 reform effective 22 September 2025. The earlier 12% and 28% slabs no longer exist. (Source: 56th GST Council; CBIC rate notifications, September 2025.)

Can you really do GST in Excel?

Yes. Excel can calculate tax, generate compliant invoices, maintain ledgers, and prepare data in the exact format the GST portal expects. What Excel cannot do is file on your behalf or talk to the GST portal — you still upload the data (or a generated JSON/Excel file) to the government portal or use an offline utility. For a small business under the e-invoicing threshold, this gap is small and entirely manageable.

The honest trade-off: Excel is powerful and cheap, but it does not update GST rates for you, does not flag a GSTR-1 vs GSTR-3B mismatch automatically, and will happily let you type the wrong GSTIN. Discipline and good templates close most of that gap.

Fact box. GST law is technology-neutral. Nothing in the CGST Act or Rules requires a specific accounting software — an invoice prepared in Excel is valid as long as it contains all particulars required under Rule 46. (Source: CGST Rules, Rule 46.)

How do I calculate CGST, SGST and IGST in Excel?

Decide the split by place of supply, then apply the rate. For an intra-state (same-state) sale, GST is split equally into CGST and SGST. For an inter-state sale, the whole rate is charged as IGST.

If B2 holds the taxable value and C2 holds the GST rate (e.g. 18 for 18%):

CGST = =B2 * (C2/2) / 100
SGST = =B2 * (C2/2) / 100
IGST = =B2 * C2 / 100

Use a single IF to pick the right path automatically based on whether the buyer's state matches yours. The full method, including a place-of-supply formula and a free workbook, is in How to auto-calculate CGST/SGST/IGST in Excel.

How do I make a GST invoice in Excel?

Build a template with a fixed header (your GSTIN, address, logo), an items table that computes tax per line, and a totals block. Add auto-numbering so each invoice gets a unique, sequential serial — a Rule 46 requirement. A VLOOKUP against an HSN master fills in description and rate automatically.

See the step-by-step build, with auto-numbering and a rounding rule, in GST Invoice Format in Excel (Auto-Numbering + Tax). To confirm an Excel invoice meets the law, read Is an Excel GST invoice legally valid?.

How do I look up HSN codes and rates in Excel?

Keep a master sheet of your HSN/SAC codes with their descriptions and GST rates, then pull the rate into your invoice or register with VLOOKUP or XLOOKUP. This stops you from typing a stale rate and keeps Table 12 of GSTR-1 consistent.

The lookup formulas (and why XLOOKUP beats VLOOKUP here) are in VLOOKUP HSN Codes & GST Rates in Excel. If you don't know your code yet, start with the HSN & SAC Code Finder for Common Indian Trades.

How do I prepare GST returns from Excel?

Most returns start as a summary of data you already keep. The two you build most often:

GSTR-1 (outward supplies) — a rate-wise and B2B/B2C summary of your sales, due the 11th for monthly filers. Build it with SUMIFS over your sales register: Build a GSTR-1 Summary Sheet in Excel.
GSTR-3B (summary + tax payment) — due the 20th. Its totals must agree with your GSTR-1. When they don't, fix it with the GSTR-1 vs GSTR-3B mismatch method.

Fact box. For monthly filers, GSTR-1 is due on the 11th and GSTR-3B on the 20th of the following month. QRMP (turnover up to ₹5 crore) filers file quarterly and pay tax monthly via PMT-06 by the 25th. (Source: GSTN / CBIC return calendar.)

How do I reconcile ITC in Excel?

Reconciliation is matching what your suppliers reported (in GSTR-2B) against what you recorded (your purchase register) so you claim only eligible Input Tax Credit. This is the single highest-value job Excel does for a GST-registered business, because mismatches block ITC and invite notices.

Match GSTR-2B to your purchases with lookups and a status column: GSTR-2B vs Purchase Register Reconciliation in Excel.
Run a full ITC ledger and eligibility check: ITC Reconciliation Template in Excel.

What about special cases — RCM, composition, e-invoice and e-way bill?

Excel covers these too:

Reverse Charge (RCM): record the tax you must pay on certain inward supplies in a dedicated ledger — Reverse Charge (RCM) Entries in an Excel Ledger.
Composition scheme: issue a Bill of Supply (no tax charged) and track turnover — Composition Scheme Billing in Excel.
E-invoice (₹5 crore+ turnover): turn invoice rows into the IRP's JSON schema — E-Invoice JSON from Excel: Step by Step.
E-way bill (consignments over ₹50,000): prepare bulk uploads from a sheet — E-Way Bill Bulk Generation from Excel.

How do I track late fees and due dates in Excel?

A simple sheet with the period, due date and filing date can compute days late, then the ₹50/day late fee (₹20/day for nil returns) plus 18% annual interest on unpaid tax. Build it with the GST Late Fee & Interest Calculator in Excel, and keep the GST rate slabs handy so your invoices stay current.

How Ankeshan helps: Ankeshan does all of this inside Excel — auto-updating rates, numbering invoices, building return summaries, and flagging GSTR-2B mismatches — so you stop re-keying between sheets. It's launching soon; join the waitlist for the free Excel templates.

The GST-in-Excel toolkit (every guide in this cluster)

Task	Guide
Calculate tax	Auto-calculate CGST/SGST/IGST
Raise invoices	GST invoice format (auto-numbering)
Look up rates	VLOOKUP HSN codes & rates · HSN & SAC finder
File GSTR-1	GSTR-1 summary sheet
Reconcile	GSTR-2B reconciliation · ITC reconciliation
Fix mismatches	GSTR-1 vs GSTR-3B
Special cases	RCM ledger · Composition billing
E-compliance	E-invoice JSON · E-way bill bulk
Late fees	Late fee & interest calculator
Legal validity	Is an Excel invoice valid?
Rates reference	GST rates 2026 (5/18/40)

Frequently asked questions

Is Excel good enough for GST in a small business? Yes, for most businesses below the e-invoicing threshold. Excel calculates tax, raises compliant invoices and prepares return data. You still upload to the GST portal yourself, and you must keep your rate table and formulas current.

Can Excel file my GST returns directly? No. Excel prepares the data; filing happens on the GST portal or through an offline utility/JSON upload. Excel gets your numbers into the right shape so the upload is clean.

Which GST rates do I use in 2026? Nil, 5%, 18% or 40%, depending on the item's HSN/SAC. The 12% and 28% slabs were abolished on 22 September 2025. Always confirm the exact rate by HSN code.

Is a GST invoice made in Excel legal? Yes, provided it contains every field required by CGST Rule 46 (GSTIN, sequential serial number, HSN, taxable value, rate-wise tax, etc.). The software used does not affect validity.

What is the hardest GST task to do in Excel? GSTR-2B reconciliation, because supplier data and your own records rarely match line-for-line. Lookups help, but volume and edge cases make it tedious — which is exactly where automation pays off.

Sources

56th GST Council decisions (3 September 2025); CBIC rate notifications effective 22 September 2025.
GSTN / CBIC: return types and due dates — gst.gov.in, cbic-gst.gov.in.
CGST Rules, Rule 46 (tax invoice particulars).

General information, not professional advice. Verify on the official portal for your case. Reviewed by a Chartered Accountant; last updated 27 June 2026.