All about using an filling Worksheet Tabs in Form GSTR-4 (Annual Return) Offline Utility

Guide to use the Worksheet Tabs in Form GSTR-4 (Annual Return) Offline Utility

All about Form GSTR-4 (Annual Return) Offline Utility. How to fill GSTR-4 Annual return form offline to online

There are 8 worksheet-tabs in Form GSTR-4 (Annual Return) Offline Utility. These are:

The Read Me sheet contains Introduction and help instructions for you to read and use them to easily fill up data in Form GSTR-4 (Annual Return) Offline Utility.

The Home sheet is the main page of the utility. It is used to perform following functions:

Enter mandatory details— GSTIN and Financial Year — Without entering these details, you will not be able to validate the data which you have entered in various worksheets and also you will not be able to import the JSON file into the offline utility.
Import and open JSON File downloaded from GST portal using Open Downloaded GSTR-4 JSON File button. (User has to first import the JSON file from portal for auto- computed values). However, this step is optional and user can skip this step and still generate JSON for upload.
Enter details in worksheet-tab
Generate JSON file, for upload of Form GSTR-4 (Annual Return) details prepared offline on GST portal, using Generate JSON File to upload button.
Import and open Error JSON File downloaded from GST portal using Open Downloaded Error JSON File button.

The 4A. B2B sheet contains Table 4A. It is used to perform following 3 functions:
Enter tax rate wise consolidated details of inward supplies received from a registered supplier (other than reverse charge).
Validate the entered details using the Validate Sheet button.
Navigate to the Home page by clicking on the Go Home button or navigate to the next sheet.

The 4A. B2BRC sheet contains Table 4B. It is used to perform following 3 functions:
Enter tax rate wise consolidated details of inward supplies received from a registered supplier (reverse charge).
Validate the entered details using the Validate Sheet button.
Navigate to the Home page by clicking on the Go Home button or navigate to the next sheet.

The 4C. URP sheet contains Table 4C. It is used to perform following 3 functions:
Enter tax rate wise consolidated details of inward supplies received from an unregistered supplier.
Validate the entered details using the Validate Sheet button.
Navigate to the Home page by clicking on the Go Home button or navigate to the next sheet.

The 4D. IMPS sheet contains Table 4D. It is used to perform following 3 functions:
Enter tax rate wise consolidated details of import of service.
Validate the entered details using the Validate Sheet button.
Navigate to the Home page by clicking on the Go Home button or navigate to the next sheet.

The 5. CMP-08 sheet contains Table 5. It is used to view auto-drafted details provided in filed Form CMP-08 for the financial year. Data can be imported and auto populated in this Table from the 'Open Downloaded GSTR-4 JSON File’, if the same has been downloaded from GST portal into the Offline Tool. Otherwise, these details will be populated in this Table after upload of JSON file on GST portal.

The 6. Inward Outward Supplies sheet contains Table 6. It is used to perform following 3 functions:
Enter the tax rate wise details of outward supplies during the financial year.(in Row 12 to 16)
In this table, the details of inward supplies shall be auto-drafted from table 4B, 4C and 4D for each tax rate wise on click of ‘Compute’ button.( in Row 1 to 11)
Validate the entered details using the Validate Sheet button.
Navigate to the Home page by clicking on the Go Home button or navigate to the next sheet.

The 7. TDS TCS Credit Received sheet contains Table7. It is used to view details related to TDS/TCS credit received during the year. Data can be imported and auto populated in this Table from the 'Open Downloaded GSTR-4 JSON File’, if the same has been downloaded from GST portal into the Offline Tool. Otherwise, these details will be populated in this Table after upload of JSON file on GST portal.