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

– Paste the raw data downloaded from the government portal here.

Disclaimer: GST rules and portal features change frequently. Always refer to the latest GST Act and circulars.

: Login to the GST Portal, go to Services > Returns > Returns Dashboard , select the period, and click Download under the GSTR-2A tile to generate an Excel file. gstr 2a and 3b reconciliation in excel format download

Paste the data downloaded from the GST portal here.

| Required Column | Purpose | |---|---| | Supplier GSTIN | To match the supplier identity | | Invoice Number | Primary matching key | | Invoice Date | To verify period alignment | | Taxable Value | To verify amounts | | IGST / CGST / SGST Amount | To verify tax figures | – Paste the raw data downloaded from the

Doing this regularly ensures you do not lose out on tax credits or face severe penalties from the GST department due to mismatches. Why GSTR-2A and GSTR-3B Reconciliation Matters

Supplier filed the invoice as a retail sale instead of a business sale. : Login to the GST Portal, go to

: A dynamic, system-generated statement. It reflects all inward supplies (purchases) based on the data uploaded by your suppliers in their GSTR-1.

Make a clear summary categorising entries as: