{"id":75846,"date":"2025-08-01T18:34:19","date_gmt":"2025-08-01T13:04:19","guid":{"rendered":"https:\/\/piceapp.com\/blogs\/?p=75846"},"modified":"2025-08-01T18:34:23","modified_gmt":"2025-08-01T13:04:23","slug":"how-to-file-gstr-6-using-offline-utility","status":"publish","type":"post","link":"https:\/\/piceapp.com\/blogs\/how-to-file-gstr-6-using-offline-utility\/","title":{"rendered":"How to File GSTR 6 Using Offline Utility in 2025?"},"content":{"rendered":"\n<div class=\"wp-block-group has-background\" style=\"background-color:#f2f5f9\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<h3 class=\"wp-block-heading\"><strong>Key Takeaways<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The GSTR-6 offline utility allows Input Service Distributors (ISDs) to prepare and validate returns offline before uploading to the GST portal.<\/li>\n\n\n\n<li>The tool includes multiple worksheets for ITC received, debit\/credit notes, and distribution details, each requiring separate validation.<\/li>\n\n\n\n<li>A validated JSON file must be generated and uploaded to the GST portal, where multiple uploads are allowed until final submission.<\/li>\n\n\n\n<li>Error JSON files can be downloaded, corrected within the utility, and re-uploaded for a successful filing.<\/li>\n\n\n\n<li>Previewing and generating the final GSTR-6 summary on the GST portal ensures accuracy before submission using DSC or EVC.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p>Input Service Distributors (ISDs) need to file GSTR-6 monthly return. This helps them furnish input service details of distribution and ISD credit follwed by invoices for tax compliance on applicable returns. <\/p>\n\n\n\n<p>Knowing how to file GSTR-6 using an offline utility can help you experience a smooth and hassle-free process while filing the same. Learn the process here to avoid errors and mistakes.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Steps to File GSTR-6 Using an Offline Utility<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"600\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/Steps-to-File-GSTR-6-Using-an-Offline-Utility.jpg\" alt=\"Steps to File GSTR-6 Using an Offline Utility\" class=\"wp-image-75953\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/Steps-to-File-GSTR-6-Using-an-Offline-Utility.jpg 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/Steps-to-File-GSTR-6-Using-an-Offline-Utility-300x200.jpg 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/Steps-to-File-GSTR-6-Using-an-Offline-Utility-150x100.jpg 150w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/Steps-to-File-GSTR-6-Using-an-Offline-Utility-768x512.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>The stepwise process of filing GSTR-6 using the offline utility is divided into 8 stages, from downloading the GSTR-6 Offline Tool to previewing the return on the GST Portal. Let us walk through each stage in detail:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Stage 1: Process to Download and Open the Offline GSTR-6 Tool<\/h3>\n\n\n\n<p>To proceed with the filing procedure, you need to first download and open the offline tool. Here&#8217;s how to do so:<\/p>\n\n\n\n<p>Step 1: Navigate to the online portal on GST Home and click on the search button.<\/p>\n\n\n\n<p>Step 2: Go to the \u2018Downloads\u2019 section, then \u2018Offline Tool\u2019 and \u2018GSTR-6 Offline Tool\u2019. Notably, you do not need to choose the online button.<\/p>\n\n\n\n<p>Step 3: You will find the complete Form GSTR-6 details of offline tool in the &#8216;Downloads Folder&#8217;. It takes around 2-3 minutes to download, depending on the speed of your internet connection. Connection to internet and internet speed are crucial factors in the download process.<\/p>\n\n\n\n<p>Ensure you check that the file is not corrupted before you unzip it. To check the same, you can match the values in the file with the values provided under downloads of GSTR-6. An exact match indicates the file is not corrupted.<\/p>\n\n\n\n<p>In order to get the values in your downloaded file, follow the outlined steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open Windows PowerShell via the Start menu search.<\/li>\n\n\n\n<li>In PowerShell, enter the command, Get-FileHash &lt;&gt; Algorithm &lt;&gt;.<\/li>\n\n\n\n<li>Match the hash value shown with the one on the GSTR-6 download page.<\/li>\n\n\n\n<li>Extract the zip file in case the hash value matches.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Stage 2: Process to Install the GSTR-6 Offline Tool<\/strong><\/h3>\n\n\n\n<p>The following are the steps you need to follow in order to install the GSTR-6 Offline Tool:<\/p>\n\n\n\n<p>Step 4<strong>: <\/strong>Once the GSTR-6 Offline Tool is downloaded, extract the contents of the zip folder on your system by clicking on the extract button.<\/p>\n\n\n\n<p>Step 5: Open the file named GSTR-6_WithAmendment_20180925_v3.4.<\/p>\n\n\n\n<p>Step 6: Double-click the file.<\/p>\n\n\n\n<p>Step 7: Click on &#8216;Enable Editing&#8217; (the Edit button will help you make changes)<\/p>\n\n\n\n<p>Step 8: Click on &#8216;Enable Content&#8217; to proceed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Stage 3: Prepare GSTR6 Return Through Offline Tool<\/strong><\/h3>\n\n\n\n<p>Here&#8217;s how you can prepare the GSTR-6 Return using the offline tool:<\/p>\n\n\n\n<p>Step 9: Open the GSTR-6 Excel-based Offline Utility. A pop-up will appear asking if you want to load the saved version.<\/p>\n\n\n\n<p>Click &#8216;No&#8217; to open a blank form. Or else, click &#8216;Yes&#8217; to restore data from your last session. To start fresh and discard previous changes, also click &#8216;Yes&#8217;.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Stage 4: Process to Add Table-wise Details in the Worksheet<\/h3>\n\n\n\n<p>Here are the different worksheets in GSTR-6 Offline Utility Tool for modification:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Read Me: As a taxpayer, you can fill in the worksheets pertaining to details in utility following the introduction and instructions in this section.<\/li>\n\n\n\n<li>Home: You need to incorporate details like GSTIN and choose tax period and financial year from the drop-down list in this option. Ensure you navigate to the financial year drop-down list followed by return filing period drop-down list. It further includes options like \u2018Generate JSON File to upload\u2019, \u2018Open Downloaded Error JSON File\u2019, \u2018Get Summary\u2019, and \u2018Open Downloaded GSTR-6 JSON File\u2019.<\/li>\n\n\n\n<li>3 &#8211; B2B: This worksheet includes details of inward supplies from a registered dealer. Notably, a taxpayer cannot edit the \u2018Status of GSTR\u2019 and \u2018Invoice Status\u2019.<\/li>\n\n\n\n<li>6B &#8211; CDN: This section includes details of debit and credit notes received from supplier of services or goods. Notably, no taxpayer can amend the &#8216;Status of GSTR&#8217; and &#8216;Debit\/ Credit Note Status&#8217;.<\/li>\n\n\n\n<li>6A &#8211; ITC Received (B2BA): This worksheet includes details pertaining to the amendment of inward supplies from registered dealers.<\/li>\n\n\n\n<li>6C &#8211; CDNA: This section contains amended debit\/credit note details. A taxpayer can amend these details, if necessary.<\/li>\n\n\n\n<li>5, 8- Distribution of ITC: The ITC (Input Tax Credit) distribution details in invoices and credit notes are included in this section.<\/li>\n\n\n\n<li>9 &#8211; Amendment of Distribution of ITC: This section includes amended details of ITC distribution which taxpayers can amend if required.<\/li>\n<\/ul>\n\n\n\n<p>Notably, under the \u2018Action\u2019 column, you can add or delete details as applicable. If you delete any detail, it will not be available in the validated sheet. If you choose &#8216;Add&#8217;, the GST Portal will treat that row as a new entry and add it to the database. If the details already exist from the previous upload, they\u2019ll be updated with the latest data. Ensure you check the database after upload, and amendments after subsequent uploads. Checking the data at the time of upload helps prevent erroneous entries and duplicate entries. Check the decimal values accurately to avoid errors in Excel utility.<\/p>\n\n\n\n<p>Step 10: After entering all details in the worksheet, click on the Validate Sheet button to check for errors. Note: You must validate each sheet individually for business validations as each sheet includes limited validations<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In Case of Successful Validation: If your validation is successful, a pop-up message will appear and your screen will display &#8216;No Errors Found&#8217;. As a taxpayer, you can proceed to click &#8216;Ok&#8217; to generate a JSON file.<\/li>\n\n\n\n<li>In Case of Unsuccessful Validation: If your validation is unsuccessful, the screen will pop up with an error message or fields with errors, &#8216;Sheet Validation Errors&#8217;. Identify and correct the highlighted red cells based on the help text. To view error comments, go to the Review tab and click &#8216;Show All Comments&#8217;.You need to rectify the issues and click &#8216;Ok&#8217; to proceed. Once you have rectified all the issues, you need to click on &#8216;Validate Sheet&#8217; before you go to the home screen displaying a popup message about successful validation. Proceed by clicking &#8216;Ok&#8217;.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Stage 5: Process to Generate JSON File for Upload<\/h3>\n\n\n\n<p>Here are the steps to generate the JSON file:<\/p>\n\n\n\n<p>Step 11: Once your validation is successful, on the home screen click on \u2018Generate JSON File to Upload\u2019.<\/p>\n\n\n\n<p>Step 12: Browse the location to save your JSON file.<\/p>\n\n\n\n<p>Step 13: Your screen will display a confirmation message through a pop-up. Click &#8216;Ok&#8217; to complete the process.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Stage 6: Process to Upload Generated JSON File of GSTR-6<\/h2>\n\n\n\n<p>You can follow the steps mentioned below to upload the generated JSON file:<\/p>\n\n\n\n<p>Step 14: Go to the official GST portal.<\/p>\n\n\n\n<p>Step 15: Select \u2018Services\u2019, then \u2018Returns\u2019 and \u2018Returns Dashboard\u2019.<\/p>\n\n\n\n<p>Step 16: You will land on the File Returns page. Select the financial year from the drop-down list and the tax period for filing a return.<\/p>\n\n\n\n<p>Step 17: Under the GSTR-6 tab, click on \u2018Prepare Offline\u2019 using the offline button.<\/p>\n\n\n\n<p>Step 18: On the \u2018Choose File\u2019 option, browse the JSON file ready for upload on the GST portal.<\/p>\n\n\n\n<p>Step 19: You will notice the JSON file being validated. Once validation is complete, the details will be updated in the respective tables.<\/p>\n\n\n\n<p>In case of validation failure, you will be notified on the official unified portal. You can download the error report to check the issues.<\/p>\n\n\n\n<p>Note: You can upload the JSON file multiple times on the GST portal before submission, but each new upload will overwrite the previous data. The tables and preview will show only the latest uploaded details. To access processed records, go to: Returns Dashboard &gt; Financial Year &gt; Return Period &gt; GSTR-6 Prepare Offline &gt; Download.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Stage 7: Process to Download the Error JSON File and Upload the Corrected Generated JSON on the GST Portal<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"600\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/Stage-7-Process-to-Download-the-Error-JSON-File-and-Upload-the-Corrected-Generated-JSON-on-the-GST-Portal.jpg\" alt=\"Stage 7 Process to Download the Error JSON File and Upload the Corrected Generated JSON on the GST Portal\" class=\"wp-image-75955\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/Stage-7-Process-to-Download-the-Error-JSON-File-and-Upload-the-Corrected-Generated-JSON-on-the-GST-Portal.jpg 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/Stage-7-Process-to-Download-the-Error-JSON-File-and-Upload-the-Corrected-Generated-JSON-on-the-GST-Portal-300x200.jpg 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/Stage-7-Process-to-Download-the-Error-JSON-File-and-Upload-the-Corrected-Generated-JSON-on-the-GST-Portal-150x100.jpg 150w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/08\/Stage-7-Process-to-Download-the-Error-JSON-File-and-Upload-the-Corrected-Generated-JSON-on-the-GST-Portal-768x512.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>You need to download the error JSON file the following way to check the issues:<\/p>\n\n\n\n<p>Step 20: In case of validation failure after uploading the JSON file on the GST portal, the status will show as \u2018Processed with Error\u2019.<\/p>\n\n\n\n<p>Step 21: To download the report, click on \u2018Generate Error Report\u2019. Report generation may take some time.<\/p>\n\n\n\n<p>Step 22: Click on the \u2018Download Error Report\u2019 link after the report is generated.<\/p>\n\n\n\n<p>Step 23: The error report will be downloaded as a .zip file. Save it to your system for future review. To extract the downloaded JSON file, ensure you unzip it from the zip folder.<\/p>\n\n\n\n<p>Right-click the downloaded .zip file and choose &#8216;Extract All&#8217; to begin unzipping. Select your desired folder location and hit &#8216;Extract&#8217;. Once extracted, the folder will include the error report in JSON format.<\/p>\n\n\n\n<p>Step 24: Open the GSTR-6 tool and navigate to the home tab. Click on \u2018Open Downloaded Error JSON files\u2019 under the section &#8216;Error File Handling&#8217; using the files button.<\/p>\n\n\n\n<p>Step 25: On the file dialogue box, navigate to the extracted error folder. Select both the files and click on \u2018Open\u2019.<\/p>\n\n\n\n<p>Step 26: You will see a success message on the screen before you click \u2018Ok\u2019.<\/p>\n\n\n\n<p>Step 27: Ensure you rectify the errors shown on \u2018GST Portal Validation Errors\u2019 in each column.<\/p>\n\n\n\n<p>Step 28: Once you complete rectifications, click on \u2018Validate Sheet&#8217; before you click \u2018Get Summary\u2019 after successful validation.<\/p>\n\n\n\n<p>Step 29: Click \u2018Generate JSON File to upload\u2019 to create the JSON (.json) file for uploading the offline-prepared GSTR-6 return details to the GST Portal.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Stage 8: Preview Form GSTR-6 on the GST Portal<\/strong><\/h3>\n\n\n\n<p>To preview Form GSTR-6 on the GST Portal, follow these steps:<\/p>\n\n\n\n<p>Step 30: Visit the GST portal. The home page will appear.<\/p>\n\n\n\n<p>Step 31: Log in using your valid credentials.<\/p>\n\n\n\n<p>Step 32: Navigate to Services &gt; Returns &gt; Returns Dashboard. Alternatively, you can click the &#8216;Returns Dashboard&#8217; link on the main dashboard.<\/p>\n\n\n\n<p>Step 33: On the &#8216;File Returns&#8217; page, select the relevant Financial Year and Return Filing Period (Month) from the drop-down list.<\/p>\n\n\n\n<p>Step 34: Click the &#8216;Search&#8217; button.<\/p>\n\n\n\n<p>Step 35: The page will display the return filing due dates via separate tiles. Locate the GSTR-6 tile and click &#8216;PREPARE ONLINE&#8217;.<\/p>\n\n\n\n<p>Step 36: Scroll to the bottom of the &#8216;Form GSTR-6 \u2013 Return for Input Service Distributor&#8217; page and select &#8216;GENERATE GSTR-6 SUMMARY&#8217;.<\/p>\n\n\n\n<p>Step 37: A confirmation message will appear at the top. You can check the status after some time.<\/p>\n\n\n\n<p>Step 38: After entering all required details, click the PREVIEW button.<\/p>\n\n\n\n<p>The form\u2019s PDF will download automatically.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>To answer how to file GSTR-6 using an offline utility, it needs to be mentioned that you should follow the steps mentioned above in the correct sequence. Following the steps will help you avoid issues and errors wherein you can enjoy a seamless journey.<\/p>\n\n\n\n<p>Ensure you rectify the errors in the JSON file to proceed and file GSTR-6 accurately. If you find an error message, you need to address it and rectify it to complete the filing process.<\/p>\n\n\n\n<p>\ud83d\udca1If you want to streamline your invoices and make payments via credit or debit card or UPI, consider using\u00a0<a href=\"https:\/\/piceapp.com\/\">the PICE App<\/a>. Explore the PICE App today and take your business to new heights.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>FAQs<\/strong><\/h3>\n\n\n<div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1753944525974\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">What is the GSTR-6 offline utility tool and who should use it?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>The GSTR-6 offline utility is an Excel-based tool provided by the GST portal for Input Service Distributors (ISDs) to prepare their monthly GSTR-6 return offline. It allows them to enter invoice-wise ITC details, amendments, and ITC distribution efficiently. This tool is particularly useful when handling bulk data or working with limited internet connectivity. After validation, users can generate a JSON file and upload it online.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1753944634755\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">How do I validate data in the GSTR-6 offline utility?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>After entering details in the respective worksheets (e.g., B2B, CDN, ITC Distribution), click on the \u201cValidate Sheet\u201d button to check for errors. If validation is successful, you\u2019ll see a &#8220;No Errors Found&#8221; message. If errors are present, affected cells turn red with comments explaining the issue. You must rectify all errors before generating the JSON file. Each sheet requires separate validation.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1753944640651\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>What shou<\/strong>l<strong>d I do if my JSON file upload fails on the GST portal?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>If your uploaded JSON file is marked as \u201cProcessed with Errors\u201d, click on \u201cGenerate Error Report\u201d from the upload history section. Once downloaded, extract the zipped error file and open it using the \u2018Open Downloaded Error JSON File\u2019 option in the offline tool. The tool will highlight issues under \u2018GST Portal Validation Errors\u2019, which you can correct before revalidating and re-uploading the updated file.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1753944647027\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Can I upload the GSTR-6 JSON file multiple times before final submission?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Yes, the GST portal allows multiple uploads of the JSON file before submission. Each new upload overwrites the previous one, so only the latest validated data is retained. This ensures you can make corrections or updates anytime before final filing. It\u2019s important to review the updated tables after each upload for accuracy, especially if amendments or additions were made.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1753944655868\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">How do I preview and finalize the GSTR-6 return after uploading?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>After uploading a valid JSON file, log in to the GST portal, navigate to Returns Dashboard, and select the relevant tax period. Click on \u2018Prepare Online\u2019 under the GSTR-6 section, then click \u2018Generate GSTR-6 Summary\u2019. After a few minutes, click on \u2018Preview\u2019 to download a draft PDF of the return. Once verified, proceed to file using DSC or EVC for final submission.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Key Takeaways Input Service Distributors (ISDs) need to file GSTR-6 monthly return. This helps them furnish input service details of distribution and ISD credit follwed by invoices for tax compliance on applicable returns. Knowing how to file GSTR-6 using an offline utility can help you experience a smooth and hassle-free process while filing the same. [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":75951,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-75846","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gst"],"_links":{"self":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/75846","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/comments?post=75846"}],"version-history":[{"count":2,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/75846\/revisions"}],"predecessor-version":[{"id":75957,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/75846\/revisions\/75957"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/media\/75951"}],"wp:attachment":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/media?parent=75846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/categories?post=75846"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/tags?post=75846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}