GSTR-7 Filing

GSTR 7 Return Filling

Post by: Renu Suresh in GST

GSTR 7 Return Filling

GSTR 7 is a return need to be filed by the persons who are required to deduct Tax deducted at source (TDS) under GST. GSTR 7 return contains the details of TDS deducted, TDS liability payable and TDS refund claimed. To help taxpayers to prepare their GSTR 7 return offline, Goods and Service Tax Network (GSTN) provides an Excel-based GSTR 7 offline utility. Deductor or GST practitioners can prepare their GSTR 7 details offline by generating JSON file. Once the return is prepared using offline utility, it is to be uploaded on GST Portal for payment of liabilities, signing and filing. In this article, we look at the procedure to file GSTR 7 return using the offline utility in detail.

GSTR 7 Return at a Glance

Every registered person who is obligated under the GST law to deduct a prescribed percentage of Tax deducted at source (TDS) at the time of making payment or crediting to supplier would be needed to file GSTR 7 return in the form of GSTR 7. GSTR 7 need to be filed within ten days after the end of the month in which payment made or credited to the supplier.

The particulars to be filed in this return include details of TDS deducted, TDS liability (payable and paid), TDS refund claimed (if any), and the likes of it. Based on this return, the Tax Deduction Certificate will be made available to the deductee on the common portal in Form GSTR 7A.

Features of GSTR 7 Offline Utility

  • Using Offline Utility, Deductor or GST practitioners can able to prepare the GSTR 7 details of Table 4 and Table 3 in offline mode
  • Most of the business validations and data entry are inbuilt in the GSTR 7 offline utility, reducing errors upon upload to GST Portal.

Worksheet -Tabs in GSTR 7 Offline Utility

There are five worksheet-tabs in GSTR 7 Offline Utility:

  • Read Me
  • Home
  • 3 TDS
  • 4 Amend (maybe TDSA)
  • Suppliers Master

Read Me Worksheet Tab

The ReadMe tab contains Introduction and helps instructions for the taxpayer to fill data in GSTR 7 Offline Utility.

Home Worksheet Tab

The Home Worksheet Tab is the main page of the GSTR 7 offline utility tool. It is used to perform the following functions:

  • To enter mandatory details — GSTIN, Financial Year and Tax Period
  • Generate JSON file, for upload of GSTR 7 return details prepared offline on GST portal
  • Generate Summary of data provided in various worksheets
  • Import and open the error file downloaded from GST portal
  • Import and open data files downloaded from GST portal

3 TDS Worksheet Tab

The three TDS (Details of Tax Deducted at Source) sheet contains Table 3. It is used to perform the following three functions:

  • Enter Tax Deducted at Source details
  • Validate the entered TDS details
  • Navigate to the Homepage

4 Amend Worksheet Tab

  • Enter Amendments details related to previous tax periods or take action on auto-populated rejected details of TDS
  • Validate the entered amendments details
  • Navigate to the Homepage

Suppliers Master worksheet Tab

The Suppliers Master worksheet Tab contains GSTIN Master Sheet. It can be used to perform the following functions:

  • Provide details of the deductee or suppliers, which would be then readily available
  • To fill details in Table 3 and Table 4 of the worksheet
  • Validate the furnished further information using the Validate Sheet button
  • You can navigate to the home page using the Go Home button.

Basic System Configurations

To use GSTR 7 Offline Utility tool efficiently, ensure that your system has following basic configuration.

  • System Requirement: The GSTR 7 Offline Utility tool functions work best on Windows 7 and above, the GSTR 7   Offline Utility tool does not work on Linux and Mac.
  • MS Excel: Microsoft Excel 2007 and above is needed for running GSTR 7 Offline Utility tool. Alternatively, for any below version, the tool will open in a default browser.

Note: The offline tool cannot be used on mobile phones.

Download GSTR 7 Offline Utility from the GST Portal

Downloading the GSTR 7 Offline Utility tool is a one-time activity; however, it may require an update in future if the Tool is updated at the GST Portal.

Note: You need to check the version of the GSTR 7 Offline Utility tool used by you with the one available for download on the GST Portal at regular intervals.

Follow the steps by step guidelines given here to download and install GSTR 7 Offline Utility tool in your computer:

Note: The taxpayer can download the GSTR 7 Offline Utility from the GST Portal without login to the Portal.

Step 1: Access the home page of Goods and Service Tax (GST) web portal.

Step 2: You need to select the Downloads option from the GST portal home page. From the list of offline tools, select the GSTR 7 Offline Utility.

Image 1 GSTR 7 Return Filling
Image 1 GSTR 7 Return Filling

Step 3: The GSTR 7 Offline Utility tool page will be displayed. Click on the Download option to download the file.

Image 2 GSTR 7 Return Filling
Image 2 GSTR 7 Return Filling

Step 4: A confirmation message will be displayed. Click on the PROCEED button to download the GSTR 7 Offline Utility from the GST Portal.

Image 3 GSTR 7 Return Filling
Image 3 GSTR 7 Return Filling

Step 5: The GSTR 7 Offline Tool will be downloaded in the Downloads folder.

Image 4 3GSTR 7 Return Filling
Image 4 3GSTR 7 Return Filling

GSTR 7 Offline Utility Installation Procedure

Once the GSTR 7 Offline Utility is downloaded, you need to unzip these downloaded files prepare return offline. The procedure to install the GSTR 7 Offline Utility is explained in detail below:

Step 1: Unzip the downloaded files and extract the files from the downloaded zip folder GSTR GSTR_7_Offline_Utility folder.

Step 2: Once the folder is unzipped, you can see GSTR7_Offline_Utility excel file. Right-click on the excel file to open. The excel file will be opened.

Image 5 GSTR 7 Return Filling
Image 5 GSTR 7 Return Filling

Step 3: You need to click on the Enable Editing and enable content button in the excel sheet.

Image 6 GSTR 7 Return Filling
Image 6 GSTR 7 Return Filling
Image 7 GSTR 7 Return Filling
Image 7 GSTR 7 Return Filling

Procedure to Prepare GSTR 7 Return Utility

The procedure to prepare GSTR 7 return utility is explained in detail below: You need to perform following steps to prepare GSTR 7 return utility

  • Add table-wise details in the Worksheet
  • Generate JSON File to upload
  • Upload the generated GSTR 7 JSON File on GST Portal
  • Preview Form GSTR-7 on the GST Portal
  • Payment of tax
  • File Form GSTR-7 with DSC/EVC
  • View debit details/entries in electronic cash ledger for tax payment
  • Download Filed Return

Add Table-Wise details in the Worksheet

Step 1: Launch GSTR 7 Excel based Offline, A pop-up window will appear, it will ask you to open saved version Yes/No.

  • By clicking on No, GSTR 7 excel based offline will open with no saved data
  • By clicking on yes, GSTR 7 excel based offline will open with data saved in the last session

Step 2: Once the GSTR 7 Excel based Offline Utility is launched and navigate to worksheet GSTR 7.

Note: The Worksheet comprises five tabs— Read Me, Home, 3 TDS, 4 Amend and Suppliers Master.

Step 3: Click on Read Me tab. Read Me tab furnishes the Introduction to Excel Based GSTR 7 Offline Tool in brief. Once you have read details in Reading Me tab, you can now proceed to enter TDS details in the worksheet.

Image 8 GSTR 7 Return Filling
Image 8 GSTR 7 Return Filling

Step 4: Select the applicable Financial Year from the Year drop-down list for which the GSTR 6 need to prepare. Select the tax period from the drop-down menu.

Image 9 GSTR 7 Return Filling
Image 9 GSTR 7 Return Filling

Step 5: After selecting the financial year and tax period, select the suppliers master tab and provide GSTIN and other details of the deductee or suppliers. This will help you easily populate data in Table 3 and Table 4 of GSTR 7.

Image 10 GSTR 7 Return Filling
Image 10 GSTR 7 Return Filling

Note: Entering details in the Suppliers Master sheet is not mandatory. You can update the details in Table 3 and four without updating the details in suppliers Master.

Step 6: After providing details in the supplier’s master sheet, click on the Validate Sheet button. A small window with no errors will appear. Click on OK.

Image 11 GSTR 7 Return Filling
Image 11 GSTR 7 Return Filling

Step 7: Once the validation is successful, go to 3 TDS tab and provide data in Columns B, C, D, E, F and G.

  • You need to provide GSTIN of deductee in Column B
  • Details of Amount paid to deductee on which tax is deducted need to be provided in Column C
  • Column D – Integrated Tax
  • Column E – Central Tax
  • Column F – State/UT Tax
  • When you go to Column G, a drop-down list with two options: Add and Delete will be displayed. Select Add for each row with TDS data.
Image 12 GSTR 7 Return Filling
Image 12 GSTR 7 Return Filling

Step 8: Once you have provided all the TDS details, click on the Validate Sheet button.

Image 13 GSTR 7 Return Filling
Image 13 GSTR 7 Return Filling

Step 9: In case of successful validation, Column H of this sheet will be empty, and you can directly proceed further

Step 10: In case of unsuccessful validation, error-intimation popup will appear, and the cells of the Column H will show “Error found in a row”. Close the popup by clicking OK.

Step 11: Select the red-highlighted cells to read the error description. A yellow description box will appear. Correct the errors as described in the description box.

Image 15 GSTR 7 Return Filling
Image 15 GSTR 7 Return Filling

Step 12: After correcting the errors, again click on the Validate Sheet button. In case no errors were found, Column H of this sheet will be empty and a No errors popup will appear. Click on OK button.

Image 16 GSTR 7 Return Filling
Image 16 GSTR 7 Return Filling

Step 11: If you have to make any amendments related to the previous month(s), go to the 4 Amend tab. Otherwise, you can Generate JSON File to upload.

Image 17 GSTR 7 Return Filling
Image 17 GSTR 7 Return Filling

Generate JSON File to Upload

To generate JSON File of GSTR 7 return to upload on GST Portal, perform following steps:

Step 1: Upon successful validation, you need to click on the Go Home button to navigate to the home page.

Image 18 GSTR 7 Return Filling
Image 18 GSTR 7 Return Filling

Step 2: On the Home tab, scroll down and select the Get Summary option.

Image 19 GSTR 7 Return Filling
Image 19 GSTR 7 Return Filling

Step 3: Summary of all the data filled in 3 TDS and 4 Amend sheets will be displayed.

Image 20 GSTR 7 Return Filling
Image 20 GSTR 7 Return Filling

Step 4: Scroll up and click on the Generate JSON File to upload button.

Image 21 GSTR 7 Return Filling
Image 21 GSTR 7 Return Filling

Step 5: A Save As pop-up window will appear. Select the location where you need to save the JSON file, enter the file name and click on the SAVE button.

Image 22 GSTR 7 Return Filling
Image 22 GSTR 7 Return Filling

Step 6: A window pop-up will appear with a message that the file has been generated and saved at the desired location and it can be uploaded on the portal. Click on OK.

Image 23 GSTR 7 Return Filling
Image 23 GSTR 7 Return Filling

Upload the generated JSON File on GST Portal

Step 1: To upload Generated JSON file on GST web portal, you need to access the Goods and Service Tax (GST) home page.

Step 2: From the main page, click on Service option and then click on Returns option. Now, you need to select the Returns dashboard command.

Step 3: The File Returns page will be displayed. From the Financial Year drop-down menu, select the financial year for which the GSTR 7 return has to be uploaded.

Image 24 GSTR 7 Return Filling
Image 24 GSTR 7 Return Filling

Step 4: Select the return filing period for which the GSTR 7 return has to be uploaded from the return filing period drop-down list.

Image 25 GSTR 7 Return Filling
Image 25 GSTR 7 Return Filling

Step 5: After providing details, click on the Search button.

Step 6: Applicable returns of the selected tax period will be displayed. From the GSTR 7 tile, you need to click on the PREPARE OFFLINE option.

Image 26 GSTR 7 Return Filling
Image 26 GSTR 7 Return Filling

Step 7: Click on the Choose File button to choose the JSON file prepared using the GSTR 7 Offline utility tool.

Image 27 GSTR 7 Return Filling
Image 27 GSTR 7 Return Filling

Step 8: Browse and navigate to JSON file to be uploaded from the system. Click on the Open button.

Image 28 GSTR 7 Return Filling
Image 28 GSTR 7 Return Filling

Step 9: The Upload section page will be displayed. A green message will appear confirming successful upload and asking you to wait while the GST system validates the uploaded data.

Image 29 GSTR 7 Return Filling
Image 29 GSTR 7 Return Filling

Step 10: Once the validation is completed, one of the following two instances can occur:

If no error were found, the upload history table would show the Status as “Processed” and Error Report as “NA”.

Image 30 GSTR 7 Return Filling
Image 30 GSTR 7 Return Filling
  • You can download the uploaded details under ‘Download’ section. Click on the generate file button. A message will be displayed confirming your request and asking you to wait for 20 minutes
Image 31 GSTR 7 Return Filling
Image 31 GSTR 7 Return Filling
  • After 20 minutes, a link will be displayed. Click on that to download your validated zipped file.
  • Unzip and save the JSON File in the system.
Image 32 GSTR 7 Return Filling
Image 32 GSTR 7 Return Filling

In case, any error was found, the upload history table will show the Status as Processed with Errors and Error Report as Generate error report.

Image 33 GSTR 7 Return Filling
Image 33 GSTR 7 Return Filling
  • Click on Generate error report hyperlink. A confirmation message will be displayed, and Columns Status and Error Report change as shown.
Image 34 GSTR 7 Return Filling
Image 34 GSTR 7 Return Filling
  • Once the error report is generated, download error report link will be displayed in the Column Error Report. Click on the Download error report link to download the zipped error report.
Image 35 GSTR 7 Return Filling
Image 35 GSTR 7 Return Filling

Preview Form GSTR 7 on the GST Portal

Step 1: To preview for GSTR 7 on GST portal, you need to access the home page of Goods and Service Tax (GST).

Image 36 GSTR 7 Return Filling
Image 36 GSTR 7 Return Filling

Step 2: From the main page, click on Service option and then click on Returns option. Now, you need to select the Returns dashboard command.

Image 37 GSTR 7 Return Filling
Image 37 GSTR 7 Return Filling

Step 3: The File Returns page will be displayed. Select the Financial Year and Return Filing Period (Month) for which you want to file the return from the drop-down list.

Step 5: After providing details, click on the Search button.

Step 6: The GSTR-7 box will be displayed, with an Important Message box on the right. In the GSTR-7 box, click on the PREPARE ONLINE button.

Image 38 GSTR 7 Return Filling
Image 38 GSTR 7 Return Filling

Step 7: The details you had uploaded on the portal using the GSTR 7 Offline Utility will be displayed in boxes 3 and 4. Click on the PREVIEW button. The draft Summary page of Form GSTR 7 will be downloaded.

Image 39 3GSTR 7 Return Filling
Image 39 3GSTR 7 Return Filling

Note: It is recommended that to review the summary of entries made in different sections carefully.

Other Related Guides

 GSTR 6 Return Filing GSTR 6 Return Filing GSTR 6 is a monthly return that needs to be filed by an Input Service Distributor.  To help taxpayers prepare their GSTR 6 retur...

Post by Renu Suresh

Renu is experience content writer specialised in compliances and company rules.

Tags: GSTR 6 filing offline GSTR 6 Return GSTR 6 Return offline tool GSTR 6 Return offline Utility
0