Filing FORM GSTR-10 using the Offline Utility (Final Return)
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-10 is the Final Return to be filed when a taxpayer’s GST registration is cancelled or surrendered. It reports details of inputs held in stock, semi-finished/finished goods, and capital goods on which ITC reversal is required.
To simplify compliance, GSTN provides the GSTR-10 Offline Utility (Excel-based), which enables taxpayers to prepare and validate stock & ITC reversal details offline before generating a JSON file for upload to the GST Portal.
This manual consolidates the statutory framework, offline filing steps, FAQs with legal basis, and a compliance checklist for practitioners.
📑 Table of Contents
-
The Law Governing GSTR-10
-
Purpose of the Offline Utility
-
System Requirements
-
Step-by-Step Filing Process (How Do I)
-
FAQs (with Basis)
-
Compliance Checklist (Fillable Format)
⚖️ 1. The Law Governing GSTR-10
-
Section 45, CGST Act, 2017 – Every registered person whose registration is cancelled shall file a final return in prescribed form.
-
Rule 81, CGST Rules, 2017 – Prescribes FORM GSTR-10.
-
Due Date: Within 3 months of cancellation date or cancellation order, whichever is later.
-
Late Fee & Interest: Sec. 47 (late fee), Sec. 50 (interest).
📝 2. Purpose of the Offline Utility
-
To allow taxpayers to prepare Table 8A–8D (ITC reversal details) offline.
-
To enable bulk entry (up to 10,000 rows/sheet).
-
To validate GSTIN, invoice details, and ITC reversals before upload.
-
To handle amendments by re-uploading JSON with “Add”/“Delete” action.
💻 3. System Requirements
-
OS: Windows 7 & above.
-
Software: MS Excel 2007+ or equivalent.
-
Disk Space: 200 MB free.
-
Internet: Required only for JSON upload/download.
-
Not Mobile Compatible.
🛠️ 4. How Do I – Stepwise Filing Process
Step 1: Download Utility
-
From GST Portal → Downloads → Offline Tools → GSTR-10 Offline Tool.
Step 2: Open Tool
-
Extract
.zip→ open Excel → Enable Editing & Content. -
Enter GSTIN, Effective Date of Cancellation, Cancellation Order No. & Date.
Step 3: Enter Data Table-Wise
-
Invoice_Available (8A–8C): Details of stock/capital goods where supplier invoice is available.
-
Inv_Not_Avail (with GSTIN) (8D): Details where invoice not available but GSTIN exists.
-
Inv_Not_Avail (without GSTIN) (8D): Details where neither invoice nor GSTIN is available.
-
Validate each sheet until error-free.
Step 4: Generate JSON
-
Home tab → Get Summary → Generate JSON File → Save locally.
Step 5: Upload JSON on Portal
-
Login GST Portal → Services > Returns > Final Return → GSTR-10 tile → Prepare Offline → Upload JSON.
Step 6: Error Handling
-
If “Processed with Error” → download Error JSON → import into utility → correct errors → regenerate JSON → re-upload.
Step 7: Preview & File
-
Preview GSTR-10 draft on portal → Pay liability if any → File with DSC/EVC.
-
ARN generated; acknowledgement downloadable.
❓ 5. FAQs (with Basis)
Q1. Can GSTR-10 be filed fully offline?
No. Filing must be done online. Offline utility prepares only Tables 8A–8D. (Rule 81)
Q2. Who must file GSTR-10?
All taxpayers on cancellation except ISD, NRTP, TDS/TCS deductors, and composition taxpayers. (Sec. 45)
Q3. What worksheet tabs are available?
Five: Read Me, Home, Invoice_Available, Inv_Not_Avail (with GSTIN), Inv_Not_Avail (without GSTIN). (Manual)
Q4. How many rows allowed per sheet?
Up to 10,000. (FAQ 15)
Q5. Can taxpayer name auto-populate from GSTIN?
No. Must be entered manually. (FAQ 14)
Q6. Are negative values allowed?
No. Decimals allowed up to 2 places. (FAQ 17)
Q7. What if JSON uploaded again?
New entries added, existing updated. (FAQ 25)
Q8. What is Action column use?
Add = new/overwrite; Delete = remove invoice. (FAQ 23–24)
Q9. What if Error JSON downloaded?
Contains only failed entries. (FAQ 21)
Q10. What are key Do’s & Don’ts?
Do: validate each sheet, enter valid GSTIN, copy-paste allowed. Don’t: cut-paste, use wrong “O/0”, alter .json extension. (FAQ 26)
✅ 6. Compliance Checklist (Fillable Format)
| Step | Particulars | Status (✔) |
|---|---|---|
| 1 | Download GSTR-10 Offline Utility | ⬜ |
| 2 | Enter GSTIN, cancellation details | ⬜ |
| 3 | Enter Table 8A–8D data (invoice available/not available) | ⬜ |
| 4 | Validate each worksheet | ⬜ |
| 5 | Generate JSON file | ⬜ |
| 6 | Upload JSON on GST Portal | ⬜ |
| 7 | Correct errors using Error JSON | ⬜ |
| 8 | Preview return on portal | ⬜ |
| 9 | Submit & File with DSC/EVC | ⬜ |
| 10 | Save ARN & acknowledgement | ⬜ |




