If you want, I can (choose one)
If you need a pre-configured sheet to save time, you can set up a basic automation layout using the columns and formulas listed above.
Alternatively, export your (Tally, Busy, Zoho, etc.) purchase register as Excel. gstr 2a and 3b reconciliation in excel format download
While Excel is powerful for up to 5,000 invoices per month, consider tools like:
While GSTR-2A is dynamic and changes whenever a supplier files late, GSTR-2B is a static monthly statement. Use GSTR-2B to freeze your ITC claims for a specific tax period, and use GSTR-2A for annual/quarterly vendor follow-ups. If you want, I can (choose one) If
(If using an older version of Excel, use =IFERROR(VLOOKUP(H2, GSTR_2A_Data!H:G, 5, FALSE), 0) )
(Assuming Column C contains the Invoice Number, and Columns F to H contain the tax amounts). Conditional Formatting for Discrepancies Highlight the column in your Summary tab. Use GSTR-2B to freeze your ITC claims for
=IF(Diff=0, "Matched", IF(Diff>0, "Supplier Pending", "Excess Claimed")) Categorizes the error automatically. Common Mismatches Explained
Supplier GSTIN,Invoice No.,Invoice Date,Taxable Value (GSTR-2A),IGST (GSTR-2A),CGST (GSTR-2A),SGST (GSTR-2A),Total Tax (GSTR-2A),Taxable Value (GSTR-3B),IGST (GSTR-3B),CGST (GSTR-3B),SGST (GSTR-3B),Total Tax (GSTR-3B),Match Status,Difference,Reason / Notes,Action Required,Reconciliation Category 27AAAAA0000A1Z5,INV001,2026-03-10,10000,0,900,900,1800,10000,0,900,900,1800,Match,0,,No action,Matched 27BBBBB1111B2Z6,INV002,2026-03-12,5000,450,0,0,450,5000,0,0,0,0,Mismatch,-450,Supplier filed late,Follow up supplier,Only in 2A 27CCCCC2222C3Z7,INV003,2026-03-15,0,0,0,0,0,2000,180,90,90,360,Only in 3B,360,Claimed but not in 2A,Check supplier filing,Only in 3B
The official GST portal provides a built-in comparison tool that can be exported to Excel: : Access the GST Portal with your credentials. Navigation Tax Liabilities and ITC Comparison : Select the relevant Financial Year Download Comparison Reports (Excel)
: Match invoice numbers between GSTR-2A and your purchase register to find missing entries.