Gstr 2a And 3b Reconciliation In Excel Format Download ((install)) Guide

Need a ready-made template? Copy the column headers provided in this article into a new Excel sheet, add VLOOKUPs, and you have your own GSTR-2A vs GSTR-3B reconciliation tool – completely free.

Are you reconciling for the or a previous period? AI responses may include mistakes. Learn more

— Do not wait for a tax notice to discover that a key supplier has not filed returns for six months. Share monthly mismatch reports with suppliers and follow up persistently.

| Rule | Explanation | |-------|-------------| | | Reconcile monthly before filing 3B (20th of next month) | | ITC eligibility | Only invoices where 2A shows "Eligible" or "Provisional" (not "Ineligible") | | Table-4 mismatch | If 3B claim > 2A available, reverse excess with interest (18%) | | Uninvoiced advances | These appear in 2A but not in 3B – adjust separately |

Comprehensive Guide to GSTR 2A and 3B Reconciliation (With Excel Template Guide) gstr 2a and 3b reconciliation in excel format download

Invoice numbers are often entered differently by suppliers and your internal team (e.g., "INV-01" vs "INV/01"). To bypass this, create a helper column called in Column H of both sheets.

: Provides a structured layout for monthly inward supply reconciliation against the electronic credit ledger. ⚡ Key Features to Look For

=IFERROR(VLOOKUP(A2,'GSTR-2A'!A:G,7,0),0)

Calculate the variance by subtracting the GSTR-2A tax value from your Purchase Register tax value. Filter the results into these common categories: Need a ready-made template

Download GSTR-2A Excel → copy all invoice rows into Sheet1 Step 2: Create Sheet2 with your GSTR-3B claimed ITC entries (you may need to manually enter if not available digitally) Step 3: Sheet3, cell A2: =IFERROR(INDEX(Sheet2!B:B, MATCH(Sheet1!B2, Sheet2!B:B, 0)), "Not in 3B") Step 4: Use SUMIFS to aggregate multiple invoices with same number across tax heads Step 5: Create pivot table on Sheet4 to see unmatched invoices by supplier Step 6: Adjust GSTR-3B (if not yet filed) to match allowed ITC – else reverse excess in next month’s return.

Create a status column to highlight variances automatically. =IF(PR_IGST = GSTR2A_IGST, "Matched", "Mismatch") Use code with caution. SUMIF / SUMIFS

Paste your GSTR-3B Table-4 data:

: Do not leave reconciliation for the end of the financial year. AI responses may include mistakes

For any business registered under the Goods and Services Tax (GST) regime in India, timely and accurate reconciliation is not just a best practice — it is a regulatory necessity. At the heart of this compliance process lies the reconciliation of (an auto-generated statement of purchases) with GSTR-3B (the monthly self-declared summary return). Mismatches between these two forms have become one of the most common triggers for tax notices, ITC disallowance, and penalties.

— Use Chrome extensions for bulk downloads, Excel Power Query for automated data compilation, or free online tools for smart matching. Accountants spend four to twelve hours every month downloading GSTR‑2A, exporting JSON from Tally, reconciling in Excel, and uploading to the GST portal — automation reduces this dramatically.

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.