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