Export to Excel Feature in Returns Offline Tool
The GSTR 2 return file can be downloaded from the GST portal and viewed in the GST Returns offline tool to modify the invoice details uploaded earlier on GST Portal. The taxpayer can export these records to excel file and take action such as edit, reject, keep pending, add and delete. After making necessary changes, the excel file can be imported back to Returns Offline tool. After preparing the JSON file, the Taxpayer can furnish the JSON file on the GST portal. The JSON file can be validated again and will be taken in by the GSTN after the due validations. In this article, we will look at Export to Excel feature in Return Offline Tool in details. Know more about Modifying GSTR 2 ReturnUse Excel for Modifying GSTR 2 Return
- The downloaded data form GST portal can be exported using the Export to Excel button provided in the summary page of returns offline tool.
- The auto-populated invoice details will have the status of either saved or submitted in the exported excel.
- Invoices will have submitted status when the counterparty supplier has submitted its GSTR 1 return.
- When the status is changed to submitted, actions of accept, reject, modify, keep, pending can be selected from action column drop-down menu.
- Invoices will have saved flag when the counterparty supplier has uploaded all invoice details but not submitted its GSTR 1.
- If the status is as saved, the actions of accept, reject, modify, keep pending should not be selected from action column drop down menu. For such cases, invoices can only be added as missing invoices in GSTR 2 return by selecting add from Action column drop down menu.
- New invoices and other details can be added using Add option from action column drop down menu. Action has to be essentially taken on all submitted invoices
- It is mandatory to take a similar effect on all rate wise details of an invoice. Partial or different action for an invoice is not allowed.
- The taxpayer cannot add invoices available with submitted status in the GSTR 2 as missing invoices.
- After making necessary changes in the exported excel, that excel can be imported into an offline tool to generate the JSON to upload to GST portal.
Procedure to use “Export to Excel” Feature in Offline Tool
The Procedure to use Export to Excel feature in Offline Tool to modify GSTR 2 return is explained in detail below: Step 1: From the Open downloaded GST return file from GST portal option, click on the Open button. [caption id="attachment_66377" align="aligncenter" width="555"]
Image 1 Export to Excel Feature in Return Offline Tool
Step 2: Browse and select the downloaded GST return file (zip format) and click on the Open button.
[caption id="attachment_66378" align="aligncenter" width="636"]
Image 2 Export to Excel Feature in Return Offline Tool
Step 3: Details of the file which have downloaded from the GST Portal will be displayed. Click on the proceed button.
[caption id="attachment_66379" align="aligncenter" width="637"]
Image 3 Export to Excel Feature in Return Offline Tool
Step 4: The summary page will be displayed, select the link for the desired section name to view the details.
[caption id="attachment_66380" align="aligncenter" width="631"]
Image 4 Export to Excel Feature in Return Offline Tool
Step 5: Click on the Export to Excel option and then save the file.
[caption id="attachment_66381" align="aligncenter" width="648"]
Image 5 Export to Excel Feature in Return Offline Tool
Step 6: Once the file is saved on the system, you can open the file. Once the excel file is opened, you can take action on all the invoices.
[caption id="attachment_66382" align="aligncenter" width="645"]
Image 6 Export to Excel Feature in Return Offline Tool
[caption id="attachment_66383" align="aligncenter" width="424"]
Image 7 Export to Excel Feature in Return Offline Tool
Step 7: Go to column Action in excel and select the appropriate action from the drop-down menu and Save the excel sheet.
[caption id="attachment_66385" align="aligncenter" width="655"]
Image 8 Export to Excel Feature in Return Offline Tool
[caption id="attachment_66386" align="aligncenter" width="638"]
Image 9 Export to Excel Feature in Return Offline Tool
Step 8: Once the action is completed, click on Import Files from GST Offline tool.
[caption id="attachment_66387" align="aligncenter" width="639"]
Image 10 Export to Excel Feature in Return Offline Tool
Step 9: In the new window, you have to select the import excel file option.
[caption id="attachment_66388" align="aligncenter" width="640"]
Image 11 Export to Excel Feature in Return Offline Tool
Step 10: A small window will be displayed, Select the file and open in GST returns Offline tool.
Know more about GST Returns Offline Tool Installation Procedure
[caption id="attachment_66389" align="aligncenter" width="496"]
Image 12 Export to Excel Feature in Return Offline Tool
Step 11: Warning message will be displayed in a small window. Select the YES option to proceed.
[caption id="attachment_66390" align="aligncenter" width="633"]
Image 13 Export to Excel Feature in Return Offline Tool
Step 12: The status will be updated against each invoice data as depicted in the image:
[caption id="attachment_66391" align="aligncenter" width="634"]
Image 14 Export to Excel Feature in Return Offline Tool
Note:
- For submitted invoices, you can take actions like Accept, Reject, Modify and Pending.
- For New records added, update the action using Add option
- While adding new records, Columns Saved or Submitted and Invoice Action status should be left blank.
- Invoices added by the taxpayer can also be deleted in the Excel sheet. In this case, update the action as delete.
- If an earlier uploaded file is downloaded and then exported as an excel file the invoice action status column would show the earlier action taken.
Related Guides
Popular Post
Starting a small business can be a transformative venture, offering the exciting opportunity...
Tax deduction at source, shortly and popularly known as TDS, was introduced by the Income Tax...
Goods & Services Tax Certificate is issued to people who are registered under GST...
GST registration applies to all individuals and entities supplying goods or services in India. GST...
Gift tax in India is applied when the value of the received gift exceeds ₹50,000 in the...
The Union Budget 2025 has brought significant changes to India’s personal income tax structure, raising the...
The Goods and Services Tax (GST) is an indirect tax system introduced in India in 2017. It functions...
A trademark search is simply checking if another person or organization does not already own the...
Section 194H of the Income Tax Act in India mandates the deduction of Tax at Source (TDS) on commission or brokerage...
Section 80G Deduction is a facility available in the Income Tax Act which allows taxpayers to...
The Income Tax Department (ITD) has not provided specific guidance on crypto taxes for Indian investors. However...
Internal audit applicability is a critical concept for companies in India, impacting various...
In the business world, two main types of companies exist: private company and public company...
Ministry of Finance vide a Notification No 05/2022- Central Tax (Rate) dated 13.7.2022 has issued...
The Central Board of Indirect Taxes and Customs (CBIC) has recently announced an extension...
Depreciation is a key concept in finance and accounting. It helps us manage how the value of...
Form 10IA of the Income Tax Department must be filed by taxpayers claiming income tax deduction...
The Goods and Services Tax (GST) system in India has been a significant reform in the country's...
India's Gross Domestic Product (GDP) benefits significantly from the substantial...
The Finance Act, 2023 introduced the MSME 45-day payment rule under Section 43B(h) of the Income Tax Act...
The Direct Tax Vivad Se Vishwas (DTVSV) Scheme, 2024, was announced by Union Finance Minister...