Masters India

How to Fill Worksheets Using GSTR-4 Offline Tool

Sakshi Jain
Sakshi Jain at March 14, 2023

GSTN has launched an excel based GSTR-4 offline utility, which will assist the tax payers to prepare their GSTR-04 return offline. The below step by step process will familiarize you with it:

  1. The appropriate details are to be filled in the downloaded excel file [except inward supplies from registered tax payers and amendments tables].
  2. Confirm the entered details by clicking on the Validate tab on each worksheet.
  3. Should there be some errors in the columns and the system does not accept it, it would get highlighted in red and a pop up error message would also be visible in the column Sheet Validation Error.
  4. The system would not move ahead and will not upload until the validation error is rectified. When all the sheets are properly validated and updated, click on Get Summary to update the summary on the home tab.
  5. When the summary matches with the accounting records, you will get an icon Generate JSON File to upload to create a JSON file to be uploaded later on the GST portal [ ]
  6. You can also save the JSON file for your records.

Should you still be confused about any intricacies involving filing of GSTR-04 and want to consult an expert, the proficient team at Masters India, a GST Suvidha Provider is here to help. autoTax from Masters India, a GST Suvidha Provider is a fully automated GST software, which along with other numerous functionalities also ensures that you always stay on top of it and be in the good books of the government by maintaining a high GST compliance rating.

Click here for more articles on GST – deeply technical and gst news updates.

To explore, how can you put your GST Return Filing on auto-pilot, please connect with Masters India at  | 1800 212 6141.

Rate your experience
4.38 / 5. Vote count: 169
GST Billing Software
GST Software: Pay GST to only compliant Vendors!

Check out other Similar Posts

No Data found
No Blogs to show

Table of Contents

    Automate your GST Compliances with Masters India

    Request Callback
    Need Help in Getting Started?
    Make smart decision to replace your manual work with modern solution and improve your business output
    Request Callback
    Continue Browsing
    Subscribe Now!
    Receive GST, E way bill, e-Invoice, Accounts payable and OCR updates from our experts.
    Chat with us

    😄Hello. Welcome to Masters India! I'm here to answer any questions you might have about Masters India Products & APIs. What brings you to our website today?

    Looking for

    GST Software

    E-Way Bill Software

    E-Invoice Software

    BOE TO Excel Conversion

    Accounts Payable Software

    Invoice OCR Software/APIs


    GST Verification API

    E-Way Bill API

    E-Invoicing API

    KSA E-Invoice APIs

    Vehicle tracking

    Vendor Verification API

    Other Requirement