A GST state code is a 2-digit number that forms the first two digits of every GSTIN. There are 38 active codes, one for each state and union territory in India, ranging from 01 (Jammu & Kashmir) to 38 (Ladakh).…
The GST reverse calculation formula extracts the base price and tax amount from a total that already includes GST. The formula is: Base Price = GST Inclusive Amount × 100 ÷ (100 + GST Rate). What Is Reverse GST Calculation?…
To download the HSN Summary from the GST portal, log in, go to Services > Returns > Returns Dashboard, select the financial year and period, open your GSTR-1, and navigate to the HSN-wise Summary of Outward Supplies table. From there,…
To download GSTR-9 from the GST portal, log in, go to Services > Returns > Annual Return, select the financial year, and use the download options on the GSTR-9 tile. You can download the system-computed summary before filing, or the…
To download GSTR-3B from GST portal, log in, go to Services > Returns > Returns Dashboard, select the financial year and return period, and click the Download button on the GSTR-3B tile. You can also download it immediately after filing…
To download GSTR-2A from GST portal, log in, go to Services > Returns > Returns Dashboard, select the financial year and month, and click Download under the “Auto Drafted Details (For view only) GSTR-2A” section. Choose either Excel or JSON…
To download GSTR-1 from the GST portal, log in, go to Services > Returns > Returns Dashboard, select the financial year and period, and download the filed return in PDF or Excel format from the GSTR-1 tile. If you need…
GST return download means retrieving a copy of a return you’ve already filed (like GSTR-1, GSTR-3B, or GSTR-9) from the GST portal, usually in PDF or Excel format, for your records, audits, or reconciliation. The exact steps depend on which…
GST reconciliation in Excel means comparing your sales or purchase records against the data filed on the GST portal (GSTR-1, GSTR-2A, GSTR-2B, GSTR-3B) using formulas like XLOOKUP, SUMIFS, and IF to spot mismatches. The goal is to confirm that what…
To calculate GST percentage in Excel, multiply the base price by the GST rate using a simple formula like =A2*18%, then add that amount back to the base price to get the final total. If your price already includes GST,…