IndiaFilings / Learn / GST / Export To Excel Feature In Returns Offline Tool
Export to Excel Feature in Return Offline Tool - IndiaFilings

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 Return

Use 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.
Know more about  Error Files in Returns Offline Tool

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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.
RENU SURESH
RENU SURESH Expert
Updated on: March 12th, 2019

Popular Post

Download ePAN Card – Get ePan from NSDL & UTIITSL
80 Small Business Ideas

Starting a small business can be a transformative venture, offering the exciting opportunity...

Nadakacheri – Income Caste Certificate Download Online in Karnataka
TDS Rate Chart for Financial Year 2025-2026 (Assessment Year 2026-2027)

Tax deduction at source, shortly and popularly known as TDS, was introduced by the Income Tax...

Divorce Rules in India: Everything You Need to Know
How To Download GST Registration Certificate Online?

Goods & Services Tax Certificate is issued to people who are registered under GST...

PAN Card Cancellation Online
Find Complete Details of GST Registration Procedure

GST registration applies to all individuals and entities supplying goods or services in India. GST...

Check Your PF Claim Status Online Using PF Tracking ID
Gift Tax in India: Applicability, Exemptions and Rules

Gift tax in India is applied when the value of the received gift exceeds ₹50,000 in the...

Check Your PF Claim Status Online Using PF Tracking ID
Old Regime vs New Regime 2025: Which Tax Regime is Better for You?

The Union Budget 2025 has brought significant changes to India’s personal income tax structure, raising the...

Check Your PF Claim Status Online Using PF Tracking ID
What is the minimum turnover for GST?

The Goods and Services Tax (GST) is an indirect tax system introduced in India in 2017. It functions...

Check Your PF Claim Status Online Using PF Tracking ID
How can I check if a trademark is registered?

A trademark search is simply checking if another person or organization does not already own the...

Check Your PF Claim Status Online Using PF Tracking ID
Section 194H of the Income Tax Act: TDS on Commission & Brokerage

Section 194H of the Income Tax Act in India mandates the deduction of Tax at Source (TDS) on commission or brokerage...

Check Your PF Claim Status Online Using PF Tracking ID
Section 80G Deduction - Income Tax Act

Section 80G Deduction is a facility available in the Income Tax Act which allows taxpayers to...

Check Your PF Claim Status Online Using PF Tracking ID
Crypto Tax in India: Taxation On Cryptocurrency

The Income Tax Department (ITD) has not provided specific guidance on crypto taxes for Indian investors. However...

Check Your PF Claim Status Online Using PF Tracking ID
Internal Audit Applicability Under Companies Act, 2013

Internal audit applicability is a critical concept for companies in India, impacting various...

Check Your PF Claim Status Online Using PF Tracking ID
Difference between Private and Public Company

In the business world, two main types of companies exist: private company and public company...

Check Your PF Claim Status Online Using PF Tracking ID
New GST Rules for Rent

Ministry of Finance vide a Notification No 05/2022- Central Tax (Rate) dated 13.7.2022 has issued...

Check Your PF Claim Status Online Using PF Tracking ID
GSTR-1 and GSTR-3B Due Date Extension - New Due Dates For January 2025

The Central Board of Indirect Taxes and Customs (CBIC) has recently announced an extension...

Check Your PF Claim Status Online Using PF Tracking ID
Different Depreciation Rates under Companies & Income Tax Act

Depreciation is a key concept in finance and accounting. It helps us manage how the value of...

Check Your PF Claim Status Online Using PF Tracking ID
Form 10IA - Section 80DD Deduction

Form 10IA of the Income Tax Department must be filed by taxpayers claiming income tax deduction...

Check Your PF Claim Status Online Using PF Tracking ID
GST on Used Cars: New 18% Tax Rate Explained

The Goods and Services Tax (GST) system in India has been a significant reform in the country's...

Check Your PF Claim Status Online Using PF Tracking ID
MSME Registration - Udyam Registration

India's Gross Domestic Product (GDP) benefits significantly from the substantial...

Check Your PF Claim Status Online Using PF Tracking ID
Section 43B(h) - New MSME 45 Days Payment Rule

The Finance Act, 2023 introduced the MSME 45-day payment rule under Section 43B(h) of the Income Tax Act...

Check Your PF Claim Status Online Using PF Tracking ID
Direct Tax Vivad Se Vishwas (DTVSV) Scheme, 2024

The Direct Tax Vivad Se Vishwas (DTVSV) Scheme, 2024, was announced by Union Finance Minister...