Reconcilation of GSTR3B,GSTR1 & Gstr2a

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
ARTICLESHIP 07 October 2026
Article assistant

S.K.Bajpai & Co.

Noida

B.Com

View Details
Company
ARTICLESHIP 07 October 2026
Article Assistant

Malhotra Rajesh & Associates

New Delhi

B.Com

View Details
Company
05 October 2026
Senior Accountant

Vision IT Peripherals Pvt Ltd

Mumbai

B.Com

View Details
Company
ARTICLESHIP 16 September 2026
CA Article Trainee

SR BAGAI & Co.

New Delhi

CA Inter

View Details
Company
12 October 2026
Finance

I-Genext Consulting Private Limited

New Delhi

CA

View Details
Company
ARTICLESHIP 01 October 2026
Articled Assistant

KPSN & Associates LLP

Chennai

CA Inter

View Details
Company
ARTICLESHIP 08 October 2026
ARTICLE TRAINEE

S.B.G. & CO. CHARTERED ACCOUNTANTS

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 15 September 2026
Freelance Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details