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