{"id":75807,"date":"2025-08-01T18:34:27","date_gmt":"2025-08-01T13:04:27","guid":{"rendered":"https:\/\/piceapp.com\/blogs\/?p=75807"},"modified":"2025-08-01T18:34:32","modified_gmt":"2025-08-01T13:04:32","slug":"how-to-file-gstr-7-using-offline-utility","status":"publish","type":"post","link":"https:\/\/piceapp.com\/blogs\/how-to-file-gstr-7-using-offline-utility\/","title":{"rendered":"How to File GSTR 7 Using Offline Utility in 2025?"},"content":{"rendered":"\n
The GST regime in India has revolutionised the tax structure, nationwide. This system has introduced various crucial forms and procedures, the GSTR-7 being one of them. Registered taxpayers under the GST regime in India, who are required to deduct tax deducted at source (TDS) shall mandatorily file returns via Form GSTR-7. <\/p>\n\n\n\n
The form consists of essential information regarding the deducted TDS, refund of TDS as well as TDS liabilities, among others.<\/p>\n\n\n\n
This blog shall clarify how to file GSTR 7 using offline utility<\/strong> and other associated details.<\/p>\n\n\n\n The Excel-based offline tool for GSTR-7 facilitates the return preparation in the offline mode. The following categories of people use the GSTR-7 offline tool:<\/p>\n\n\n\n GST practitioners and TDS deductors resort to this offline utility tool to make note of the following information:<\/p>\n\n\n\n Here are the prerequisites that the taxpayer should meet to use the offline tool for GSTR-7:<\/p>\n\n\n\n Here are the steps you can follow to successfully download the offline tool for GSTR-7:<\/p>\n\n\n\n Step 1<\/strong>: Visit the GST portal online.<\/p>\n\n\n\n Step 2<\/strong>: Go to the \u2018Downloads\u2019 section, choose \u2018Offline Tools\u2019 followed by \u2018GSTR 7 Offline Utility\u2019.<\/p>\n\n\n\n Step 3<\/strong>: Click on the \u2018Download\u2019 link once the GSTR-7 returns page pops up.<\/p>\n\n\n\n Step 4<\/strong>: Note that a \u2018warning message\u2019 shall be displayed. Simply press the ‘Proceed’ button to continue. The zipped GSTR-7 offline utility folder shall be downloaded on your device.<\/p>\n\n\n\n Step 5<\/strong>: Next, you must extract the \u2018GSTR7_offline_utility\u2019 Excel file from said zipped folder. Right-click on it and choose \u2018Open\u2019.<\/p>\n\n\n\n Step 6<\/strong>: Navigate to the \u2018Enable Editing\u2019 button and click on it to proceed.<\/p>\n\n\n\n Next, select the ‘Enable Content’ button. Hover over to the ‘Read Me’ section. Make sure to go through the instructions before filling out the worksheets.<\/p>\n\n\n\n Here are the 5 worksheets in the GSTR-7 offline utility tool that you will be presented with:<\/p>\n\n\n\n Here is a step-by-step guide to filling the tables of GSTR-7 using the offline utility:<\/p>\n\n\n\n Step 1<\/strong>: Visit the home tab to fill in the table-wise detail prompts. Type in the GSTIN, tax period and the relevant financial year.<\/p>\n\n\n\n Step 2<\/strong>: Navigate to the \u2018Suppliers Master\u2019 tab and type in the:<\/p>\n\n\n\n Providing the necessary information in this section fuels easy data population across Tables 3 and 4. However, it is not compulsory to fill in the \u2018Suppliers Master\u2019 section.<\/p>\n\n\n\n The Column B, serial number shall also auto-populate. The taxpayer can choose \u2018Delete\u2019 under the column that reads \u2018Action\u2019, in order to remove a row from the master sheet.<\/p>\n\n\n\n Step 3<\/strong>: Click on \u2018Validate Sheet\u2019 for a text to pop up, which should state \u2018No Errors\u2019. Click on \u2018OK\u2019 to move forward.<\/p>\n\n\n\n Step 4<\/strong>: Next, go to the \u20183 TDS\u2019 tab. Here are the details you shall be required to provide:<\/p>\n\n\n\n Deductee\u2019s Column B GSTIN<\/strong>: A drop-down list in this column shall contain the GSTINs as were updated within the master tab of the suppliers. So, you can select the GSTIN from the master list or type it in manually. GSTINs may also be copied and pasted from a different sheet. <\/p>\n\n\n\n Simply click on the “Enable Suppliers\u2019 Master Drop-Down” tab. The button should then read, “Disable Suppliers\u2019 Master Drop-Down”. This can allow one to use the copy-and-paste facility.<\/p>\n\n\n\n Column C Amount as Paid to the Deductee (Tax is Deducted on it)<\/strong>: Type in the paid amount to the deductee. Do not type in any negative values; entering decimal values is permitted.<\/p>\n\n\n\n Column D<\/strong>: Type in the IGST (integrated tax) amount. It should ideally be 2% of the amount input in column C.<\/p>\n\n\n\n Column E<\/strong>: Type in the CGST (central tax) amount. It should ideally be 1% of the amount input in column C, and equal to the amount entered in column F.<\/p>\n\n\n\n Column F<\/strong>: Type in the SGST (state tax) amount. It should ideally be 1% of the amount input in column C, and equal to the amount entered in column E.<\/p>\n\n\n\n Column G<\/strong>: Column G features a drop-down list with the following 2 options:<\/p>\n\n\n\n Note<\/strong>: The compulsory columns in this tab are B, C, D, E and F.<\/p>\n\n\n\n Step 5<\/strong>: Click on the ‘Validate Sheet’ button. In case of successful validation, column H will be blank.<\/p>\n\n\n\n An error message will appear and column H will show the specific error for each affected row in case of an unsuccessful validation. The erroneous cells will be highlighted in red, with a yellow description box displaying the issue.<\/p>\n\n\n\n Review and correct any errors found. Then, click the ‘Validate Sheet’ button again. If all entries are error-free, a confirmation message will appear. Click ‘OK’ to move forward.<\/p>\n\n\n\n Step 6<\/strong>: Navigate to the 4 amend section, in case any alterations are required in the previous months returns. If there are no changes to be made, one may skip this tab.<\/p>\n\n\n\n Here are the details that must be entered in this tab:<\/p>\n\n\n\n Columns B & C<\/strong>: Choose the month as well as year from the drop-down list presented to you.<\/p>\n\n\n\n Column D & F<\/strong>: Choose the GSTINs from the options displayed in the drop-down list.<\/p>\n\n\n\n Column G<\/strong>: Choose between \u2018Yes\u2019 and \u2018No\u2019 from the said drop-down list in case the records are rejected by the concerned deductee.<\/p>\n\n\n\n Column H<\/strong>: Type in the value on which the tax is being deducted. The value may be in decimals; avoid entering negative values.<\/p>\n\n\n\n Column I, J, K<\/strong>: Type in the integrated tax, central tax as well as the state tax values. The sum of CGST and SGST\/IGST alone shall be 2% of the paid value (to the deductee).<\/p>\n\n\n\n Column L<\/strong>: If the records happen to get rejected by the deductee, specify the action initiated on those records.<\/p>\n\n\n\n Column M<\/strong>: It will display a drop-down list with 2 options to choose from:<\/p>\n\n\n\n Add<\/strong>: Choose \u2018Add\u2019 for every row containing TDS data.<\/p>\n\n\n\n Delete<\/strong>: Go for the \u2018Delete\u2019 option to use it for subsequent uploads; to delete the rows which are already uploaded on the portal.<\/p>\n\n\n\n The compulsory columns in this tab are B, C, D, F, H, I, J and K<\/p>\n\n\n\n Step 7<\/strong>: Generate the JSON file by going to the home tab and selecting the ‘Get Summary’ button.<\/p>\n\n\n\n Table 3 and Table 4 summaries containing all the details shall be displayed. Select the ‘Generate JSON File to Upload’ tab. Once a ‘Save As’ window pops up window, type in a file name. Click on \u2018Save\u2019.<\/p>\n\n\n\n Here are the steps you can follow to upload the generated JSON file of GSTR-7:<\/p>\n\n\n\n Step 1<\/strong>: Log in to the GST portal by providing your credentials.<\/p>\n\n\n\n Step 2<\/strong>: Go to the \u2018Services\u2019 section, then to \u2018Returns\u2019 and finally, to the \u2018Returns Dashboard\u2019 section.<\/p>\n\n\n\n Step 3<\/strong>: On the file returns page, choose the relevant financial year and the return filing period. Click on \u2018Search\u2019 to continue.<\/p>\n\n\n\n Step 4<\/strong>: Go to the ‘Prepare Offline’ section on the GSTR-7 tile and the upload section shall be displayed.<\/p>\n\n\n\n Step 5<\/strong>: Select \u2018Choose File\u2019 and browse through your generated JSON file which is ready for uploading. Proceed to click on \u2018Open\u2019.<\/p>\n\n\n\n Upon successful upload, expect to see a text message pop up in green. This shall confirm the upload.<\/p>\n\n\n\n Step 6<\/strong>: After successful validation, select the ‘Preview Draft GSTR-7’ button displayed on the returns page.<\/p>\n\n\n\n Step 7<\/strong>: A draft pdf shall appear with a watermark. Go through the information carefully.<\/p>\n\n\n\n Step 8<\/strong>: Select the ‘Proceed to File’ option to proceed with filing, using either EVC or DSC.<\/p>\n\n\n\n The following is a stepwise process you need for fixing errors in GSTR-7 form using an offline tool:<\/p>\n\n\n\n Part 1: Obtain the Error Report<\/strong><\/p>\n\n\n\n Step 1: During the time of upload of your generated JSON file, if any errors are detected, the upload history table will display the status as ‘Processed with Errors’.<\/p>\n\n\n\n Step 2: Click on the ‘Generate Error Report’ link. A confirmation message will appear and the status in the upload history table will update accordingly, reflecting the initiation of the error report generation.<\/p>\n\n\n\n Step 3: Once the error report has been generated, click on the ‘Download Error Report’ link to retrieve the zipped file containing the error report.<\/p>\n\n\n\n Step 4: Extract the contents of the zipped folder and save the JSON file to a preferred location on your system.<\/p>\n\n\n\n Part 2: View the Downloaded the GSTR-7 JSON File<\/strong><\/p>\n\n\n\n Step 5: Navigate to the \u2018Home\u2019 tab and click the \u2018Open Downloaded Error JSON File\u2019 button located in the Error File Handling section.<\/p>\n\n\n\n Step 6: A file dialog box will appear. Locate and select the downloaded error file from your system. Click \u2018OK\u2019 to continue.<\/p>\n\n\n\n Step 7: A confirmation pop-up will notify you of a successful import. Click \u2018OK\u2019 to proceed.<\/p>\n\n\n\n Step 8: Switch to Tab 3 (TDS) and Tab 4 (Amend). You will see the entries that failed the validation check. Review the remarks under the column titled ‘GST Portal Validation Errors’ and make the necessary corrections.<\/p>\n\n\n\n Step 9: After editing the data, click on the \u2018Validate Sheet\u2019 button again. If all entries are correct, a success message will appear. Click \u2018OK\u2019 to continue.<\/p>\n\n\n\n Using the offline utility for filing GSTR-7 can simplify the process for tax deductors. It allows them to accurately report tax deductions and stay compliant by preparing the return offline and uploading the generated JSON file to the GST portal. <\/p>\n\n\n\n The offline tools minimise the chances of errors. It also streamlines the entire filing process, simplifying GST obligations for taxpayers. We hope that this guide expanding on how to file GSTR 7 using offline utility <\/strong>will put things in perspective for you.<\/p>\n\n\n\n Moreover, updates at regular intervals and the continued support from GST authorities enhance the utility’s overall functionality, allowing for seamless GST compliance for all parties involved.<\/p>\n\n\n\nWho Can Use the Offline Tool for GSTR-7?<\/strong><\/h2>\n\n\n\n

\n
\n
Prerequisites to Use the Offline Tool for GSTR-7<\/strong><\/h3>\n\n\n\n
\n
Steps to Download the Offline Tool for GSTR-7<\/strong><\/h2>\n\n\n\n
\n
Steps to Fill Up the Tables of GSTR-7 on the Offline Utility<\/strong><\/h2>\n\n\n\n

\n
\n
How to Upload the Generated JSON File of GSTR-7?<\/strong><\/h2>\n\n\n\n

How to Fix Errors in GSTR-7 Using an Offline Tool?<\/strong><\/h2>\n\n\n\n

Conclusion<\/strong><\/h2>\n\n\n\n