Gstr 2a And 3b Reconciliation In Excel Format Download [updated] Review

| GSTIN of Supplier | Invoice Number | Invoice Date | Taxable Value | CGST | SGST/UTGST | IGST | Cess | Total ITC Available | |------------------|----------------|--------------|----------------|------|------------|------|------|----------------------|

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

This will instantly highlight invoices present in your books but missing in GSTR-2A, as well as mismatches in tax values.

To begin your reconciliation process in Excel, you must first gather your data sheets from the official government portal. 1. Download GSTR-2A in Excel Format gstr 2a and 3b reconciliation in excel format download

[Insert download link or attachment]

If you want to build a robust yourself, include these features:

Follow up with the supplier to upload it in their next GSTR 1. | GSTIN of Supplier | Invoice Number |

Claiming ITC that is not reflected in your GSTR-2A (due to vendor default or reporting errors) is a high-risk area. If a supplier fails to file GSTR-3B, the department may treat the recipient's ITC as ineligible, even if the invoice appears in the statement. Timely reconciliation ensures you only claim credit for compliant purchases.

is a dynamic, auto-drafted, read-only statement. It displays the ITC available to you based on the data uploaded by your suppliers in their GSTR 1.

In your Purchase Register tab, create a new column named "Matched IGST". Use this formula to pull data from the GSTR 2A tab: To begin your reconciliation process in Excel, you

— Just because an invoice appears in GSTR‑2A does not automatically make ITC eligible. Blocked credits include motor vehicles (in certain cases), personal consumption expenses, and construction‑related expenses.

. This process matches the ITC declared in your self-summary return (3B) with the invoices uploaded by your suppliers (2A). Importance of Reconciliation

Make a clear summary categorising entries as: