27 October 2017
Hi All,
The GST Department released new GSTR Offline Utility updated version 2.1
GSTR offline Utility V 2.1
We can export B2B data in excel
We can Accept, Reject, Modify, Keep pending, Add invoices or Delete invoices in the Excel itself.
Retweeted GST Tech (@askGSTech):
Offline Tool V2.1 with option to export data in Excel feature is now available on GST Portal for creation and submission of GSTR-2.
27 July 2024
The new GSTR Offline Utility Version 2.1, released by the GST Department, brings several enhancements that can streamline the process of filing GSTR-2 returns. Here’s a summary of the key features and how you can utilize them:
### **Features of GSTR Offline Utility Version 2.1**
1. **Export to Excel**: - **Functionality**: You can now export B2B data to Excel. This allows you to work with your data in a familiar spreadsheet format, making it easier to manage and review. - **Usage**: Use this feature to analyze or edit your GSTR-2 data in Excel before re-importing it into the offline utility.
2. **Edit and Manage Invoices in Excel**: - **Accept, Reject, Modify**: You can update invoice details directly within the Excel file. This includes accepting, rejecting, or modifying invoice entries as needed. - **Keep Pending**: You can mark certain invoices as pending if they are not yet finalized. - **Add or Delete Invoices**: The utility allows you to add new invoices or delete existing ones directly in the Excel sheet.
### **How to Use the GSTR Offline Utility Version 2.1**
1. **Download and Install**: Ensure you have the latest version of the GSTR Offline Utility Version 2.1 installed on your system. You can download it from the GST portal.
2. **Export Data**: - Open the offline utility. - Navigate to the option for exporting data. - Select the B2B data and export it to an Excel file.
3. **Work with Excel File**: - Open the exported Excel file. - Make necessary changes to the data, such as accepting or rejecting invoices, modifying details, or adding/deleting invoices. - Save the changes in the Excel file.
4. **Import Data**: - Return to the offline utility. - Import the updated Excel file back into the offline utility. - Review the imported data to ensure all changes are correctly reflected.
5. **Generate JSON File**: - After finalizing the data in the offline utility, generate the JSON file for GSTR-2. - Validate the JSON file to ensure there are no errors.
6. **Upload to GST Portal**: - Log in to the GST portal. - Navigate to the GSTR-2 filing section. - Upload the JSON file generated from the offline utility. - Submit the return after verifying all details.
### **Benefits of Version 2.1**
- **Efficiency**: Allows bulk editing and management of data, reducing manual entry errors and saving time. - **Flexibility**: Offers the ability to work offline and make changes in a familiar Excel environment. - **Accuracy**: Helps ensure that data corrections and updates are accurately reflected in your GSTR-2 return.
### **Troubleshooting**
- **File Compatibility**: Ensure that the Excel file format is compatible with the offline utility. - **Validation Errors**: Double-check for any validation errors after importing the Excel file back into the offline utility. - **Technical Support**: If you encounter issues, consult the GST helpdesk or refer to the detailed user manual provided with the offline utility.
This new feature should make the process of filing GSTR-2 more manageable and less prone to errors, especially for large volumes of data.