GST Filing from Excel — GSTR-1 & GSTR-3B Made Easy

Ankeshan's GST module turns your Excel sales and purchase records into GSTR-1 and GSTR-3B-ready data, reconciles your Input Tax Credit against GSTR-2B, and exports portal-ready JSON — all on your own PC. Instead of retyping figures into the GST portal or a separate app, you file from the same workbook where your invoices already live, with the 2026 rules built in.

Ankeshan adds this inside the Excel you already use — nothing new to learn, nothing leaves your PC.

What it does

Prepares a full GSTR-1 — B2B invoices, B2C Large, B2C Small, exports, credit/debit notes, advances, the documents-issued summary, and the HSN-wise summary that is mandatory in 2026.
Prepares GSTR-3B, auto-populated from your GSTR-1 data, with a clear workings sheet showing every calculation.
Reconciles GSTR-1 against GSTR-3B internally before you file, so mismatches — a known trigger for GSTIN suspension — are caught early.
Reconciles GSTR-2B — import the 2B JSON and Ankeshan matches it to your purchase register, flagging missing or mismatched ITC.
Enforces the 2026 ₹1-variance rule. Rounding is handled strictly at invoice level so paisa differences don't silently block your Input Tax Credit.
Computes tax correctly — CGST + SGST for intra-state, IGST for inter-state, based on place of supply — and handles Reverse Charge (RCM).
Includes an HSN/SAC library with default rates per code, and produces the HSN-wise report.
Generates offline e-invoice (INV-01) JSON for businesses over the threshold, ready to upload to the IRP, plus e-way bill JSON for inter-state consignments over ₹50,000.
Calculates late fees and interest automatically — ₹50/day (₹20 for nil), and 18% per annum on overdue tax.
Supports multiple GSTINs for multi-state operations and the Composition scheme (CMP-08).
Exports GSTN-portal-ready JSON for GSTR-1 and GSTR-3B, plus a PDF preview to review before filing.

How it works in Excel

Your sales sheet carries the fields GST needs — invoice number and date, customer GSTIN and state, HSN, taxable value, and the tax breakup. Ankeshan reads those rows and assembles the return. It groups B2B and B2C, builds the HSN summary, applies the correct current slab, and lays out a workings sheet you can check line by line. When you're satisfied, it exports the JSON you upload to the portal, or a PDF to review first.

Because the module reads your live invoice data, GSTR-1 and GSTR-3B are built from the same source and reconciled against each other automatically. GST rates change several times a year, so Ankeshan fetches an updated rate table from the server — the current slabs are Nil, 5%, 18%, and 40% (the old 12% and 28% slabs were abolished on 22 September 2025) — without you reinstalling anything.

Who it's for

This module is for GST-registered businesses that file their own returns, and for accountants filing on behalf of clients. It suits regular and composition taxpayers, single- or multi-GSTIN operations, and anyone who currently spends hours reconciling sales registers against the portal or worrying about a GSTR-1 vs 3B mismatch.

Good to know

You still file on the portal. Ankeshan prepares and validates your return and exports the JSON; the actual submission happens on the GST portal, so you stay in control.
E-invoice is offline in v1. Ankeshan generates valid INV-01 JSON for you to upload via the IRP tool and import the returned IRN and QR. One-click live IRN is a planned phased add-on.
Rates come from the server. Slabs update automatically, but you should always confirm the exact rate for your HSN code before invoicing.
Offline reconciliation. 2B matching runs on your PC against your own purchase register.

Learn more

Launching soon

Pricing is announced at launch. Join the waitlist and file your next GST return the easy way.