GST Compliance – GSTR-9A Offline Utility

Filing FORM GSTR-9A using the Offline Utility (Annual Return for Composition Taxpayers)

Edition: September 2025
Disclaimer: This manual is prepared for educational and compliance facilitation purposes. It does not substitute the provisions of law, notifications, or circulars issued by the Government. Readers are advised to refer to the original statutory provisions wherever required.

✍️ Preface

FORM GSTR-9A is the annual return for composition taxpayers. It consolidates outward supplies, inward supplies, taxes paid, demands, refunds, and ITC reversals/availment for the financial year.

To support small taxpayers under composition, GSTN provides the GSTR-9A Offline Utility (Excel-based). It allows preparation of data (Tables 6–16), validation, and generation of JSON file for upload to GST Portal.

This manual integrates the law, purpose, filing steps, FAQs with statutory basis, and a compliance checklist for practitioners.

📑 Table of Contents

1. The Law Governing GSTR-9A

2. Purpose of the Offline Utility

3. System Requirements

4. Step-by-Step Filing Process (How Do I)

5. FAQs (with Basis)

6. Compliance Checklist (Fillable Format)

⚖️ 1. The Law Governing GSTR-9A

• Section 44, CGST Act, 2017 – Annual return by registered persons.

• Rule 80(1), CGST Rules, 2017 – Prescribes GSTR-9A for composition taxpayers.

• Due Date: 31st December following the FY (unless extended).

• Late Fee & Interest: Sec. 47 (late fee), Sec. 50 (interest).

📝 2. Purpose of the Offline Utility

• To prepare data for Tables 6–16 of GSTR-9A offline.

• To reduce portal errors with built-in validations.

• To import JSON from portal (system-computed based on filed GSTR-4).

• To ease compliance for composition taxpayers with poor internet access.

💻 3. System Requirements

• OS: Windows 7 & above.

• Software: MS Excel 2007+ or equivalent.

• Disk Space: 200 MB free.

• Internet: Needed only for JSON download/upload.

• Not Mobile Compatible.

🛠️ 4. How Do I – Stepwise Filing Process

Step 1: Download Utility

• From GST Portal → Downloads → Offline Tools → GSTR-9A Offline Tool.

Step 2: Open Utility

• Extract .zip → open Excel file → Enable Editing & Content.

• Home tab → Enter GSTIN & FY.

Step 3: Import JSON

• Login GST Portal → Services > Returns > Annual Return → select FY → Prepare Offline → Generate & Download JSON.

• Import JSON into tool → system-computed values auto-populated (Table 9 non-editable).

Step 4: Enter Table-Wise Data

• Pt II (Tables 6–8): Outward & inward supplies.

• Pt III (Table 9): Tax paid (non-editable, system-computed).

• Pt IV (Tables 10–14): Amendments, differential tax.

• Pt V (Tables 15–16): Demands, refunds, ITC reversed/availed.

Step 5: Validate Sheets

• Click Validate Sheet tab-wise.

• Errors highlighted in red; hover for description.

Step 6: Generate JSON

• Home tab → Generate JSON File to Upload → save file.

Step 7: Upload JSON

• Portal → Services > Returns > Annual Return → Prepare Offline → Upload JSON.

Step 8: Handle Errors

• If “Processed with Error”: download Error JSON → import in tool → correct → regenerate → re-upload.

Step 9: Preview & File

• Portal → Preview return → pay dues/late fees → File with DSC/EVC.

• ARN generated.

❓ 5. FAQs (with Basis)

Q1. Can GSTR-9A be filed offline?
No. Only preparation offline; filing must be online. (Rule 80)

Q2. Which tables can be filled offline?
Tables 6–16. (Manual)

Q3. Is Table 9 editable?
No, prefilled from filed GSTR-4. (Manual)

Q4. How many worksheet tabs?
Five: Read Me, Home, Pt II, Pt III, Pt IV, Pt V. (Manual)

Q5. Can Nil JSON be generated?
No. (FAQ 28)

Q6. Are negative/decimal values allowed?
Yes. (FAQ 20)

Q7. What validations offline?
GSTIN structure, tax type; rest validated on portal. (FAQ 21–23)

Q8. What if JSON uploaded again?
New entries added, earlier ones updated. (FAQ 27)

Q9. What is Error JSON?
Contains only failed entries. (FAQ 29–30)

Q10. Do’s & Don’ts?
Do: validate sheets, enter correct GSTIN, copy-paste data.
Don’t: cut-paste, leave blanks, change JSON extension. (FAQ 32)

✅ 6. Compliance Checklist (Fillable Format)