Gstr 2a And 3b Reconciliation In Excel Format Download

You can instantly download a GSTR-2A and GSTR-3B reconciliation Excel format by creating the structure above and saving as .xlsx. Many tax portals and forums offer free templates with formulas pre-installed. Look for a template with:

✅ Pro Tip: Always keep a master copy of the blank reconciliation format. Every month, paste fresh GSTR-2A and GSTR-3B data into the respective tabs – all formulas will auto-update.

“Input tax credit to be availed by a registered person in respect of invoices or debit notes, the details of which have not been furnished by the supplier under section 37(1), shall not exceed 5% of the eligible credit available in GSTR-2A/2B.” gstr 2a and 3b reconciliation in excel format download

Excel formula to check compliance:

=IF(Total_ITC_Claimed > (Total_ITC_in_2A * 1.05), "Excess Claim - Disallowed", "Within Limit")

| Particulars | Excel Formula | |-------------|----------------| | Total ITC as per 2A (eligible) | =SUM(Reconciliation_Report!E:E) | | Total ITC claimed in 3B | =Sheet2!B5 (assuming cell B5 has total ITC) | | Variance | =B1-B2 | | Action | =IF(B3>0,"You claimed more than 2A – risk","You can claim more ITC") | You can instantly download a GSTR-2A and GSTR-3B

| Sheet Name | Source | Key Columns | |------------|--------|--------------| | GSTR-2A_Excel | GST Portal download | GSTIN of supplier, Invoice No., Invoice Date, Taxable Value, CGST, SGST, IGST, Cess | | Purchase_Register | Your books (or GSTR-3B Table 4) | Same fields + ITC claimed in 3B |

| Month | Total ITC as per 2A | ITC Claimed in 3B | Difference | Action | |-------|--------------------|-------------------|------------|--------| | Oct 24| ₹1,00,000 | ₹95,000 | -₹5,000 | Short claim | | Nov 24| ₹80,000 | ₹85,000 | +₹5,000 | Excess claim | ✅ Pro Tip: Always keep a master copy

| Columns | Description | |---------|-------------| | GSTIN of Supplier | | | Invoice No. | | | Invoice Date | | | Taxable Value | | | CGST Claimed | | | SGST Claimed | | | IGST Claimed | | | Total ITC Claimed | | | Month | |