What parameters are CFOs
focusing on to avoid GST scrutiny?
What parameters are CFOs focusing on to avoid GST scrutiny?
Book a demo to find out!

GSTR-3B Offline Tool : How to file Form GSTR-3B offline?

Updated on: Jun 29th, 2021


8 min read

Form GSTR-3B is a monthly return in which the summarised net GST liability is declared and paid. All persons who are required to file Form GSTR-1 are also required to file Form GSTR-3B. This would include all registered persons (including a casual taxable person) but excluding the following persons:

  • Input Service Distributor
  • Non-Resident taxable person
  • Composition taxpayer
  • A person authorised to deduct tax under section 51
  • A person authorised to collect tax under section 52
  • Supplier of Online Information Database Access and Retrieval (OIDAR) services

The filing of this return can only be done online. However, the offline tool can help input the required data and prepare a JSON file for uploading on the GST portal.

Steps to download and open the offline tool for GSTR-3B

Step 1: Visit the GST portal.

Step 2: Navigate to Downloads > Offline Tools > GSTR-3B Offline Utility.

Step 3: Click on ‘Download’ and then ‘Proceed’.

Step 4: Extract the contents of the zip file downloaded above. Navigate to the location of the extracted files and open the excel utility.

Note: Always ensure that the latest version of the utility is used.

Steps to prepare Form GSTR-3B using the offline tool

Step 1: Click on the ‘Enable Editing’ button followed by the ‘Enable Content’ button to ensure that the macros are enabled. The ‘Clear All’ button may be used to make sure that the utility is blank before filling in the details.

Step 2: Navigate to the ‘GSTR-3B’ worksheet. This worksheet contains all the relevant tables of Form GSTR-3B where data can be entered.

Step 3: Enter the relevant taxpayer details such as GSTIN, year, legal name of the registered person (optional field) and month for which the return is being filed.

Step 4: The relevant data will have to be filled into the following tables:

  • Table 3.1 Details of outward supplies and inward supplies liable to reverse charge: Enter the details as applicable. Upon entering amounts under ‘CGST’, the ‘SGST’ values are auto-populated with an equal amount. However, if the SGST values are not equal to the CGST values, they can be changed on the portal.
  • Table 3.2 Of the supplies shown in 3.1(a) above, details of inter-state supplies made to unregistered persons, composition taxable persons and UIN holders: Enter the details as applicable. The amounts entered here cannot be greater than the corresponding amounts entered in 3.1(a). The relevant state/Union Territory can be selected from the drop-down list in the ‘Place of Supply’ column.
  • Table 4 Eligible ITC: This table will require the user to enter the tax-wise details of ITC availed and ITC to be reversed. The utility will then auto-populate the net eligible ITC row.
  • Table 5 Values of exempt, nil-rated and non-GST inward supplies: This table requires the taxpayer to enter the tax-wise details of inward supplies on which GST was not levied, namely, supplies received from composition dealers, exempt inward supplies and non-GST inward supplies.
  • Table 5.1 Interest & late fee payable: Here only interest amount will need to be entered.

Step 5: Click on the ‘Validate’ button after entering the details. In case of successful validation, the following message will be displayed: ‘Sheet validated. Please proceed to generate JSON file.’ Further, the sheet status will be displayed as ‘Validation Successful’.

In case of unsuccessful validation, the relevant error message will be displayed and the sheet status will be displayed as ‘Validation Failed’.

Check the cells with validation errors as given in the help text. To find such cells, go to the review tab and select the ‘Show All Comments’ option. Click on the ‘Valid Sheet’ button after making all the corrections.

Step 6: Once the sheet status displays ‘Validation Successful’, click on the ‘Generate File’ button. This creates a JSON file for uploading on the GST portal. Click on ‘OK’ after the confirmation message is displayed.

You will notice that a new folder named ‘GSTR’ has been created on your desktop within which the JSON file can be found.

How to upload the generated JSON file of Form GSTR-3B?

Step 1: Log in to the GST portal.

Step 2: Navigate to Services > Returns > Returns Dashboard. Select the relevant financial year and return filing period and click on ‘Search’.

Step 3: On the GSTR-3B tile, click on the ‘Prepare Offline’ button.

Step 4: On the upload page, click on the ‘Choose File’ button. Navigate to the location of the JSON file generated earlier and click on the ‘Open’ button. The uploaded JSON file will be validated and processed. The status of the same will be displayed.

In case multiple files are uploaded, the previously uploaded data will be overwritten and the portal will only consider the latest submitted data.

Step 5: Once the JSON file is processed, navigate back to the returns dashboard page. On the GSTR-3B tile, click on the ‘Prepare Online’ button. Verify the details uploaded.

If everything is in order, click on the ‘Submit’ button and follow from the step 8 mentioned here.

Frequently Asked Questions (FAQs) on the offline tool for Form GSTR-3B

What are the recommended system configurations to use the offline tool?

The required system configuration is Windows 7 or above Operating System with Internet Explorer 10+ and MS Excel 2007 onwards.

Is it possible to sign and file returns using the offline tool?

No, the offline tool is only for entering data into the Form GSTR-3B. The form will ultimately have to be signed and filed on the GST common portal itself.

Can the offline utility run on mobile?

No. At present, the offline utility is not compatible with mobile devices.

inline CTA
India’s Fastest and Most Advanced 2B Matching
Maximise ITC claims, use smart validations to correct your data and complete 2B matching in <1 minute

Public Discussion

Get involved!

Share your thoughts!


Quick Summary

Form GSTR-3B is a monthly return filed online by registered persons excluding certain categories. Offline tool can generate JSON for uploading. Steps include downloading tool, entering data in relevant tables, validating, and generating JSON file. JSON file uploading steps involve preparing offline/online and submitting on GST portal.

Was this summary helpful?

Clear offers taxation & financial solutions to individuals, businesses, organizations & chartered accountants in India. Clear serves 1.5+ Million happy customers, 20000+ CAs & tax experts & 10000+ businesses across India.

Efiling Income Tax Returns(ITR) is made easy with Clear platform. Just upload your form 16, claim your deductions and get your acknowledgment number online. You can efile income tax return on your income from salary, house property, capital gains, business & profession and income from other sources. Further you can also file TDS returns, generate Form-16, use our Tax Calculator software, claim HRA, check refund status and generate rent receipts for Income Tax Filing.

CAs, experts and businesses can get GST ready with Clear GST software & certification course. Our GST Software helps CAs, tax experts & business to manage returns & invoices in an easy manner. Our Goods & Services Tax course includes tutorial videos, guides and expert assistance to help you in mastering Goods and Services Tax. Clear can also help you in getting your business registered for Goods & Services Tax Law.

Save taxes with Clear by investing in tax saving mutual funds (ELSS) online. Our experts suggest the best funds and you can get high returns by investing directly or through SIP. Download Black by ClearTax App to file returns from your mobile phone.

Cleartax is a product by Defmacro Software Pvt. Ltd.

Company PolicyTerms of use


ISO 27001

Data Center


SSL Certified Site

128-bit encryption