Gstr 2a And 3b Reconciliation In Excel Format Download ((hot)) Jun 2026

| Column | Formula / Logic | |--------|----------------| | Supplier GSTIN | Match from both sheets | | Invoice No. | Match | | Taxable Value (2A) | VLOOKUP | | Taxable Value (3B) | VLOOKUP | | Difference (Value) | =3B_value - 2A_value | | ITC as per 2A | Sum of taxes | | ITC Claimed (3B) | | | ITC Difference | =3B_ITC - 2A_ITC | | Status | IF(Difference=0,"Matched","Mismatch/Not in 2A") |

Paste the raw data downloaded from the government portal here. Essential columns must include: Supplier GSTIN Supplier Trade/Legal Name Invoice Number Invoice Date Taxable Value Integrated Tax (IGST) Amount Central Tax (CGST) Amount State/UT Tax (SGST) Amount Sheet 2: Data from GSTR-3B (Books Data) gstr 2a and 3b reconciliation in excel format download

Whether you prefer your template to use traditional or the newer, more flexible XLOOKUP formulas? | Column | Formula / Logic | |--------|----------------|

To save time, consider using third-party automated verification platforms like ClearTax GST Solutions, GSTZen Reconciliation Tool, or the Vyapar Offline Accounting Tool. These utilities feature built-in fuzzy logic rules that auto-match human entry errors (like dates or slashes) instantly. To save time

: Standard reconciliation templates typically include sheets for:

(Your books/claimed ITC)