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.