Gstr 2a And 3b Reconciliation In Excel Format Download |link| May 2026
exact column headers, formulas, and layout
Since I cannot attach an actual .xlsx file, I have provided the below. You can copy this into Excel in 2 minutes.
This pulls total ITC from GSTR-2A for each invoice in GSTR-3B. gstr 2a and 3b reconciliation in excel format download
- Open Excel → New Workbook
- Create 3 sheets as named above
- Add headers and sample data
- Insert formulas in Sheet3
- Save as
GSTR_Reconciliation_Tool.xlsx
- Total GSTR-2A Tax = SUM(H:H)
- Total GSTR-3B Tax = SUM(M:M)
- Total Difference = SUM(O:O)
- Count Matched = COUNTIF(N:N,"Match")
- Count Mismatch = COUNTIF(N:N,"Mismatch")
Option B (Make your own in 2 minutes)
– Copy the table below into Excel: