Reconcilation of GSTR3B,GSTR1 & Gstr2a

151 views 1 replies
how to do reconciliation any format please forward
Replies (1)

Reconciling GSTR-1, GSTR-3B, and GSTR-2A is a critical compliance process to ensure your tax liability is correctly reported and your Input Tax Credit (ITC) is accurate. Below is a structured guide to performing this reconciliation.

1. GSTR-1 vs. GSTR-3B (Outward Supplies & Liability)

The objective is to ensure that the sales and tax liability reported in your detailed sales return (GSTR-1) match the summary figures declared in your payment return (GSTR-3B).

  • Step 1: Download both GSTR-1 and GSTR-3B for the same period from the GST portal.

  • Step 2: Compare the Total Taxable Value and Total Tax Liability (CGST, SGST, IGST, and Cess).

  • Step 3: Identify discrepancies. Common causes include:

    • Amendments made in one return but not the other.

    • Timing differences (reporting an invoice in one month's GSTR-1 but paying tax in another month's GSTR-3B).

    • Data entry errors or misclassification (B2B vs. B2C).

  • Step 4: Correct any underpayment by filing a voluntary payment via Form DRC-03 or adjusting in subsequent returns.

2. GSTR-3B vs. GSTR-2A/2B (Input Tax Credit)

This ensures you are only claiming ITC for which your suppliers have actually paid the tax and filed their returns.

  • Step 1: Download your GSTR-2A (or the more recent GSTR-2B, which provides a static view of eligible ITC) and your GSTR-3B data for the period.

  • Step 2: Compare the ITC claimed in Table 4 of GSTR-3B with the credit reflected in GSTR-2A/2B.

  • Step 3: Categorize mismatches:

    • Matched: Invoices present in both your books and the portal.

    • Missing in GSTR-2A: Your supplier has not filed their GSTR-1. Contact them to ensure compliance.

    • Missing in your data: Invoices reflected in the portal that you may have missed recording in your books.

    • Value Mismatches: Differences in tax amounts, often due to clerical errors.

  • Step 4: Reverse any excess ITC claimed (along with applicable interest) if the invoices are not reflected in GSTR-2A/2B, or follow up with vendors to get their returns filed/amended.

Recommended Reconciliation Format

When building your reconciliation worksheet (Excel), include the following columns to track progress:

Field Name Descripttion
GSTIN Supplier's or Customer's GST identification number
Invoice Number/Date Unique identifiers for matching
Taxable Value Net value of the supply
Tax Amount IGST, CGST, SGST as per books
Amount as per Portal Corresponding tax amount in GSTR-2A or GSTR-1
Variance Calculated difference (Books vs. Portal)
Remarks/Action Notes on why a difference exists (e.g., "Pending Supplier Filing")

Best Practices

  • Perform Monthly: Do not wait until the year-end (Annual Return/GSTR-9). Monthly reconciliation makes it easier to catch errors and fix them within the permissible time limit (usually by the September return of the following financial year).

  • Use Automation: For high volumes of transactions, use accounting software or GST compliance tools that offer "fuzzy matching" to identify invoices with minor discrepancies in invoice numbers or dates.

  • Document Everything: Keep a record of communication with vendors regarding missing invoices; this is essential during department audits.


GST Reconciliation Guide

This video provides a practical walkthrough of reconciling your books with GSTR-1 and GSTR-3B to help you avoid tax notices.


Summary: Reconciling these forms involves comparing your outward supply (GSTR-1 vs. 3B) to ensure accurate tax payment and your inward supply (GSTR-2A/2B vs. 3B) to ensure valid ITC claims; this should be done monthly to avoid penalties and interest.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
29 June 2026
Accountant (Finance & Compliance)

TRIEYEZ

Kolkata

CA

View Details
Company
ARTICLESHIP 17 July 2026
Article Assistant and B.com pass

BANSAL YOGESH AND CO

Gautam Budh Nagar

B.Com

View Details
Company
ARTICLESHIP 30 June 2026
2 posts Article assistant and Articleship completed students

Chirag N Shah & Associates

Mumbai

CA Inter

View Details
Company
06 July 2026
Chartered Accountant (Indirect Taxation)

Gowra Ventures Pvt Ltd

Hyderabad

CA

View Details
Company
23 July 2026
Senior Accountant

Felicity Adobe LLP

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 11 July 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 07 July 2026
Articleship

Jawahar and Associates Chartered Accountants

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 30 June 2026
Article Assistant or Paid Assistant

VIKAS VERMA & CO

New Delhi

Others

View Details