1.Enter details in the GSTR4 worksheet of GSTR4 Offline Tool

Please ensure that you download the latest version of GSTR4 Offline Tool from the GST portal. https://www.gst.gov.in/download/returns

1.Launch the GSTR4 Excel based Offline Tool and navigate to worksheets.

GSTR4 worksheet image

2.Click the Read Me. Read Me tab provides the Introduction to Excel Based GSTR4 Offline Tool in brief.

Readme tab image

3.Once you read details in Read Me tab, move to next tab Home.

4.In the GSTIN field, enter the GSTIN.

5.In the Financial Year and Tax Period field, enter the Financial Year and Tax Period from the drop-down list.

Financial year image

6.Add the details in sheet which is applicable.

Add new action column

Details of each tab is given below:

1) 4 – A&B(B2B) – Inward Supplies received from a registered supplier (attracting reverse charge)

4 - A&B(B2B)

2) 5A (B2BA) – Amendment of inward Supplies received from a registered supplier (Attracting reverse charge)

5A (B2BA)

3) 4C(B2BUR) – Inward Supplies received from an unregistered supplier subject to reverse charge

4C(B2BUR)

4) 4C(B2BURA – Amendment of Inward Supplies received from an unregistered supplier

4C(B2BURA

5) 4D (IMPS) – Import of Services subject to reverse charge

4D (IMPS)

6) 5A (IMPSA) – Amendment of Import Services

5A (IMPSA)

7) 5B(CDNR) – Debit Notes/Credit Notes (for registered)

5B(CDNR)

8) 5C(CDNRA) – Amendment of Debit Notes/Credit notes (For registered)

5C(CDNRA)

9) 5B(CDNUR) – Debit Notes/Credit Notes (for unregistered)

5B(CDNUR)

10) 5C (CDNURA) – Amendment of Debit Notes/Credit Notes (for Unregistered)

5C (CDNURA)

11) 6(TXOS) – Tax on outward supplies made (Net of advance and goods returned)

6(TXOS)

12) 7(TXOSA) – Amendment of Tax on outward supplies made under reverse charge

7(TXOSA)

13) 8A(AT) – Advance amount paid for reverse charge supplies in the tax period

8A(AT)

14) 8A-II (ATA) – Amendment of Advance amount paid for reverse charge supplies in thetax period

8A-II (ATA)

15) 8B(ATADJ) – Advance amount on which tax was paid in earlier period but invoice has been received in the current period

8B(ATADJ)

16) 8B-II(ATADJ) – Amendments of Advance Amount on which tax was paid in earlier period but invoice has been received in the current period.

8B-II(ATADJ)