sit amet. Aut praesentium molestiae sit amet consectetur id consequuntur velit ×

GSTR-9C Excel Format: How to View GSTR-9 Draft in Excel Format on GST Portal

avatar of saurabh agrawal
By Saurabh Agrawal
3 min read

GSTR-9C Excel Format: How to View GSTR-9 Draft in Excel Format on GST Portal

Key Takeaways

  • Mandatory Filing: GSTR-9C is required annually for businesses with turnover above ₹2 Crore to comply with GST.
  • Reconciliation Tool: It reconciles the taxpayer’s GSTR-9 with audited financial statements.
  • Utility Features: The Excel format includes tools for JSON generation, error checking, and data validation.
  • Easy Download: The GSTR-9C tool can be downloaded from the GST portal in ZIP format.
  • Detailed Sections: The form covers turnover, tax paid, ITC reconciliation, and any additional liabilities.

GSTR 9C format in Excel helps taxpayers or entities view and download the form for annual return filing purposes. Entities with high turnover during a financial year need to file this return to align with the tax norms in India. Learn the process to view and download this form here for seamless annual return filing.

What Is GSTR-9C?

what is gstr-9c??

GSTR 9C is an annual audit form under the Goods and Services Tax (GST) regime which needs to be filed annually. It applies to businesses with turnover exceeding ₹2 Crore annually. In other words, it is a reconciliation statement that helps reconcile values of annual GSTR-9 and audited financial statements of a taxpayer.

Multiple Features in the GSTR 9C Offline Utility

Here are the features of the GSTR-9C format in Excel:

  • You can find the GSTR-9C JSON file after downloading it from the GST portal.
  • The GSTR-9C error file is further available after you download it from the GST portal.
  • You can generate the GSTR-9C JSON file for upload on the GSTIN portal.
  • As a taxpayer, you can preview the draft GSTR-9C form by generating a PDF.
  • The data entered, validates the data in the sheet.

Steps to Download GSTR 9C Offline Utility in Excel

How To File GSTR9C Annual Return  2022-23 | filing of GSTR9C for fy 2022-23 | GSTR9C filing

Here are the steps to download GSTR-9C format in Excel:

Step 1: Visit the official unified GST portal and click on the ‘Download’ option on the main menu.

Step 2: Select ‘Offline Tools’ and click on ‘GSTR-9C Offline Tool’.

Step 3: You will be redirected to a new page containing the download link. Click on the link to download the ZIP format of the document.

What Are the Sections to Be Filled in Form GSTR-9C?

what are the sections to be filled in form gstr-9c?

GSTR-9C has the following parts that need to be filled in:

Download GSTR-9C in Excel Format: 

Part A: Reconciliation Statement

The reconciliation statement has 5 parts as mentioned below:

Must Read  Understanding the GST Composition Scheme

Part I: Basic details

This part consists of the financial year, GSTIN, legal and trade name. In this part, the taxpayer needs to declare if he/she is under audit under any law.

Part II: Reconciliation of Turnover Declared in Audited Financial Statements and the One Declared in Annual Return

This part mandates a declaration of gross and net taxable turnover in the annual return, similar to the audited financial statements.

Part III: Reconciliation of Tax Paid

This section mandates reporting of tax liability in the order of GST rate in accordance with GSTR-9. Additionally, taxpayers need to mention other liabilities due to unreconciled differences identified during reconciliation in the tables of this part.

Part IV: Reconciliation of ITC (input tax credit)

This part mandates reconciliation of ITC that taxpayers avail or utilise, in accordance with GSTR-9 and the Audited Financial Statement.

Part V: Additional Liability Due to Non-reconciliation

This section requires declaring additional liabilities from turnover or ITC discrepancies, any amounts not covered in the annual return but paid for supplies, incorrect refund claims, and outstanding demands that need to be settled.

Filling in all the parts helps taxpayers complete the GSTR-9C filing process, thereby aligning with the tax norms during an assessment year.

Conclusion

GSTR 9C format in Excel can be viewed seamlessly on the official unified GST portal. As a taxpayer, you can further download the form in ZIP format to view it. Viewing the form will help you understand whether the details entered in the form are correct thereby proceeding to file annual returns.

💡If you want to pay your GST with Credit Card, then download Pice Business Payment App. Pice is the one stop app for paying all your business expenses.

FAQs

What is GSTR-9C, and who needs to file it?

GSTR-9C is an annual audit form required for businesses with an annual turnover exceeding ₹2 Crore. It reconciles the figures reported in GSTR-9 with the audited financial statements. Filing GSTR-9C ensures that the taxpayer’s financials align with GST returns, making it mandatory for larger businesses to comply with GST laws.

How can I download the GSTR-9C format in Excel?

You can download the GSTR-9C format by visiting the official GST portal. Navigate to ‘Downloads’ > ‘Offline Tools’ > ‘GSTR-9C Offline Tool’ and download the ZIP file. Extract the file to access the Excel utility, which allows you to prepare and validate the GSTR-9C form offline.

Must Read  What is IGST on Credit Card?

What are the main parts of the GSTR-9C form?

GSTR-9C consists of two primary sections: Part A, the Reconciliation Statement, and Part B, the Certification. Part A includes details like turnover reconciliation, tax paid, and ITC reconciliation, while Part B is the certification section, signed by the auditor to confirm the accuracy of the reconciliation.

What is the purpose of the reconciliation statement in GSTR-9C?

The reconciliation statement in GSTR-9C compares the turnover, tax paid, and input tax credit (ITC) as per the GSTR-9 with those reported in the audited financial statements. Its purpose is to identify and explain any discrepancies, ensuring accurate reporting and compliance with GST regulations.

Can I preview the GSTR-9C form before filing?

Yes, you can preview the GSTR-9C form by generating a draft PDF using the offline Excel utility. This feature allows you to review the entered data for accuracy and completeness before uploading the final JSON file to the GST portal, ensuring a smooth filing process.

Scroll to Top