Before filing your GSTR-9 annual return, you can download a draft in Excel from the GST portal to review the auto-populated figures offline. This guide shows how to download the GSTR-9 draft, what to check in the auto-filled tables, and how to reconcile it with your books and GSTR-2B before you file – because GSTR-9 cannot be revised.
The GST portal allows registered taxpayers to download a draft of their GSTR-9 annual return in Excel format before filing. This preview step helps verify data accuracy, prevent errors, and avoid penalties. This guide covers the draft structure, the importance of review, and the step-by-step download process.
What Is the GSTR-9 Draft?
The GSTR-9 draft is an Excel-based preview of the annual return available on the GST portal. It consolidates all data from monthly and quarterly returns filed during the financial year, providing a comprehensive view before final submission. This utility helps taxpayers cross-verify figures against their accounting records and identify discrepancies that could trigger penalties or scrutiny from tax authorities.
The draft is auto-populated from data already filed in GSTR-1 and GSTR-3B throughout the year. Taxpayers should treat it as a reconciliation tool rather than a final document, since the auto-populated figures may need manual adjustment against the actual books of account. Starting the review at least two weeks before the filing deadline is advisable for businesses with high transaction volumes.
Structure of the GSTR-9 Excel Draft
| Section | Content |
| Section 1 | Basic taxpayer identification (GSTIN, legal name, trade name, registration status) |
| Section 2 | All incoming and outgoing supplies during the financial year |
| Section 3 | Input Tax Credit details declared in returns during the fiscal year. |
| Section 4 | Tax paid details as reported in returns over the financial year |
| Section 5 | Prior-year transactions disclosed in returns filed from April to September of the current year |
| Section 6 | Demands, refunds, late fees, HSN summary, deemed supplies, and other details |
Why Review the GSTR-9 Draft Before Filing?
Reviewing the draft is essential for three critical reasons. First, discrepancies can lead to late fees of Rs. 100 per day per Act (CGST and SGST), capped at 0.25% of turnover in the state or union territory. Second, incorrect or missing information can trigger a detailed examination by tax authorities. Third, mismatches between GSTR-1, GSTR-3B, and GSTR-2A/2B data are the most common source of annual return errors.
Once GSTR-9 is filed, it cannot be revised. Any errors become permanent on record and can only be addressed through subsequent correspondence with tax authorities. The draft review step is the last opportunity to ensure accuracy before the data is locked. Businesses should compare the draft against their sales register, purchase register, and ITC ledger to confirm every figure before filing.
Step-by-Step Guide to Download the GSTR-9 Draft
Step 1: Log In to the GST Portal
Navigate to www.gst.gov.in and log in with your registered username and password.
Step 2: Open the Annual Return Dashboard
Go to the dashboard and select the Annual Return tab. This presents an overview of your filing options for the selected period.
Step 3: Select the Financial Year
Choose the relevant financial year (for example, FY 2024-25) to align with the correct accounting period.
Step 4: Prepare GSTR-9 Online
Click the Prepare Online tab for GSTR-9 to begin preparing your annual return digitally.
Step 5: Handle the Nil Return Option
Select Yes or No for the Nil Return option depending on whether you have transactions to report, then click Next.
Step 6: Access the Excel Preview
Locate the Preview Draft GSTR 9 Excel tab, typically found in the footer section of the page. Click on it to initiate the draft generation.
Step 7: Download the Draft File
Click the link titled “Click here to download Excel File 1” in the footer—the file will download to your device. Open the Excel file and cross-check all figures against your books of accounts, GSTR-1, GSTR-3B, and GSTR-2A/2B statements before final submission.
Common GSTR-9 Errors to Avoid
Taxpayers frequently make the following errors in their annual return. Discrepancies between GSTR-1, GSTR-3B, and GSTR-2A/2B data arise from missed invoices or incorrect period allocation. Incorrect reporting of Input Tax Credit availed or reversed during the year is another common issue. Misclassification of supplies as taxable, exempt, nil-rated, or non-GST creates reporting problems. Missing details of amendments made during the financial year and failure to reconcile outward supply figures with the buyer’s purchase records also cause errors.
Each of these mistakes can trigger notices from tax authorities and may result in additional tax liability, interest, or penalties. The draft review process specifically targets these common issues and provides the opportunity to correct them before finalisation.
Reconciliation Best Practices
Before filing GSTR-9, complete the following reconciliation steps. Compare your sales register with the GSTR-1 data filed to identify any unreported or incorrectly reported outward supplies. Match your purchase register with GSTR-2B statements to verify all eligible ITC claims. Cross-check tax payment challans with the Electronic Cash Ledger to ensure all deposits are correctly recorded. For businesses with multiple GST registrations across states, consolidate data at the PAN level to identify inter-state supply mismatches. Maintain a reconciliation workpaper documenting each adjustment as an audit trail.
| Common Mismatch | How to Resolve |
| GSTR-1 vs GSTR-3B output tax difference | Compare invoice-level data; file amendments in the next GSTR-1 |
| GSTR-2B vs ITC claimed in GSTR-3B | Reconcile with the purchase register; reverse excess ITC. |
| Tax paid vs Electronic Cash Ledger balance | Verify all challans are correctly credited on the portal. |
| HSN-wise summary vs sales register | Match HSN codes at the invoice level before filing. |
Key Terms
• GSTR-9: Annual return consolidating all monthly/quarterly GST return data for a financial year
• GSTR-2B: Static monthly ITC statement generated on the 14th of each month from supplier filings
• HSN Summary: Classification of goods supplied using Harmonised System of Nomenclature codes
• Electronic Credit Ledger: Digital ledger on the GST portal reflecting available ITC balance
• Nil Return: A return filed when no business transactions occurred during the reporting period
| Disclaimer: This article is for informational purposes only and does not constitute legal or tax advice. Consult a qualified tax professional for advice specific to your situation. |
Ready to Simplify Your Annual Return Filing?
WFYI provides comprehensive tools and resources to help businesses manage GSTR-9 filing, ITC reconciliation, and GST compliance. Explore GST Tools on WFYI
Frequently Asked Questions
Q1: What is GSTR-9?
GSTR-9 is the annual return filed by all registered GST taxpayers. It consolidates outward and inward supply details from monthly/quarterly returns, along with ITC availed and taxes paid.
Q2: Who must file GSTR-9?
All GST-registered taxpayers except Input Service Distributors, non-resident taxable persons, those under the composition scheme (Section 10), and TDS deductors (Section 51).
Q3: What is the late fee for delayed GSTR-9 filing?
Rs. 100 per day per Act (CGST and SGST), up to a maximum of 0.25% of turnover in the state or union territory.
Q4: Can GSTR-9 be revised after filing?
No. Once filed, GSTR-9 cannot be revised. A thorough review using the Excel draft before submission is essential.
Q5: What errors should I check for in the GSTR-9 draft?
Check for discrepancies between GSTR-1, GSTR-3B, and GSTR-2A/2B data, incorrect ITC reporting, misclassification of supplies, and missing amendment details.
Frequently Asked Questions
Can I download GSTR-9 as an Excel draft?
Yes, the portal lets you download a draft of GSTR-9 in Excel to review before filing.
Why review the GSTR-9 draft first?
Because GSTR-9 cannot be revised once filed, so you want to catch errors at the draft stage.
What should I reconcile in the draft?
The auto-filled tables against your books, GSTR-1, GSTR-3B and GSTR-2B.
Is GSTR-9 mandatory?
It is mandatory above the turnover threshold (currently Rs 2 crore) and optional below it.
