Reconciliation format for filing gstr 9 and 9c

The reconciliation of GSTR-9 (Annual Return) and GSTR-9C (Reconciliation Statement) is a crucial compliance requirement under the GST law. While there is no single "standardized" official government Excel template, the process involves a specific structural format defined in the law.

1. Understanding the Difference

• GSTR-9: This is your annual return—a summary of all monthly/quarterly returns (GSTR-1 and GSTR-3B) filed during the financial year.

• GSTR-9C: This is a reconciliation statement that bridges the gap between your audited financial statements (books of accounts) and your annual return (GSTR-9). It is mandatory for taxpayers with an aggregate annual turnover exceeding ₹5 Crore.

2. Structure of GSTR-9C (Reconciliation Statement)

The format is divided into five main parts:

• Part I: Basic Details: Financial Year, GSTIN, Legal/Trade Name, and audit status.

• Part II: Reconciliation of Gross Turnover: Compares turnover as per audited financial statements with the turnover declared in GSTR-9. It accounts for adjustments like unbilled revenue, unadjusted advances, and deemed supplies.

• Part III: Reconciliation of Tax Paid: Reconciles the tax liability declared in the reconciliation statement with the actual tax paid as per GSTR-9.

• Part IV: Reconciliation of Input Tax Credit (ITC): Compares ITC availed in GSTR-9 with ITC on expenses recorded in your books of accounts.

• Part V: Additional Liability: Reports any tax/ITC shortfalls discovered during the reconciliation process that need to be paid via Form DRC-03.

3. How to Perform the Reconciliation

Most professionals use customized Excel workbooks to handle this, as the data volume can be high. You can build your own by mapping:

• Books vs. GSTR-9 (Turnover): Identify differences due to timing (e.g., credit notes issued after year-end, revenue recognition policies) and accounting classification.

• Books vs. GSTR-9 (ITC): Segregate ITC by expense head (e.g., freight, power, rent, salaries) as per your audited Profit & Loss statement and match it with the total ITC claimed in GSTR-9.

• Documentation: Maintain a "Reasons for Non-Reconciliation" document for any remaining differences to support your filing.

4. Important Notes

• Threshold: Mandatory for turnover > ₹5 Cr.

• Self-Certification: Since recent amendments, GSTR-9C is now self-certified by the taxpayer rather than requiring a mandatory signature from a Chartered Accountant or Cost Accountant.

• Due Date: Generally 31st December following the end of the financial year.

For detailed instructions on the specific tables, you can refer to the official GSTR-9C instructions or check professional guides from ClearTax or Zoho Books.

Summary: GSTR-9 is your annual summary return, while GSTR-9C (required if turnover exceeds ₹5 Crore) is a mandatory reconciliation statement between your audited books and your GSTR-9. You should prepare this by systematically mapping your turnover, tax liability, and ITC across both sets of records and documenting any discrepancies.

Reconciliation Tutorial

This video provides a practical walkthrough on how to set up an Excel sheet for reconciling GSTR-9 and 9C data.