Step-by-Step Guide for Full GST Reconciliation

Here is a step-by-Step Guide for Full GST Reconciliation as under:

1.  Purchase (Input Side) Reconciliation

Download GSTR-2A & 2B:

GST Portal → Services → Returns → View GSTR-2A / 2B → Download Excel.

Export Purchase Register:

From Tally/SAP/Zoho → Keep Columns: Supplier GSTIN | Invoice No. | Invoice Date | Taxable Value | GST Amount.

How to Compare:
VLOOKUP / XLOOKUP → Match Invoice No. + Supplier GSTIN.
Highlight Mismatches → Use Conditional Formatting for easy view.

Issues to Identify:
Missing Invoice in GSTR-2B
Value Mismatch
GSTIN Error
Ineligible ITC (Blocked under Sec 17(5))

Make a Clear Summary:
Eligible ITC | ✗Ineligible ITC | ✎Follow-up Pending

2. Sales (Output Side) Reconciliation

Download GSTR-1:
Portal → Services → Returns → View GSTR-1 → Download Excel.

Export Sales Register:

From ERP → Columns: Invoice No. | Buyer GSTIN | Invoice Date | Taxable Value | GST Amount.

How to Compare:
VLOOKUP / XLOOKUP → Match Invoice No. + Buyer GSTIN.
Mismatch Highlight → Identify missing/incorrect invoices quickly.

Actionable Step:
Missing/wrong invoices → Amend in next GSTR-1 filing.

3. GSTR-1 vs GSTR-3B (Tax Payable Reconciliation)

Compare Monthly Totals:
Total taxable value & GST payable in GSTR-1 = GSTR-3B.

Mismatch Check:
Under-reporting → Pay extra tax.
Over-reporting → Claim refund or adjust next month.

4. GSTR-2B vs GSTR-3B (ITC Claim Reconciliation)

Match ITC Figures:
ITC claimed in GSTR-3B = Eligible ITC in GSTR-2B.

Formula Tip:
Supplier-wise ITC using SUMIFS (Supplier GSTIN wise).

Adjustment:
Excess ITC? → Reverse with Interest.
Short ITC? → Claim in next valid month.

5. Books vs GST Returns Final Validation

Summary from Books:
Outward Supplies | Inward Supplies | GST Payable | ITC Availed.

Cross Verification:
Match books vs GSTR-1, GSTR-3B, GSTR-9/9C.
Identify unreported invoices, ITC not claimed, errors.