{"id":75713,"date":"2025-07-29T19:54:56","date_gmt":"2025-07-29T14:24:56","guid":{"rendered":"https:\/\/piceapp.com\/blogs\/?p=75713"},"modified":"2025-07-29T19:55:00","modified_gmt":"2025-07-29T14:25:00","slug":"how-to-file-gstr-10-return-using-offline-utility","status":"publish","type":"post","link":"https:\/\/piceapp.com\/blogs\/how-to-file-gstr-10-return-using-offline-utility\/","title":{"rendered":"How to File GSTR 10 Return Using Offline Utility?"},"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>GSTR-10 is the final return that must be filed within 3 months after GST registration cancellation.<\/li>\n\n\n\n<li>The offline tool is mandatory for taxpayers with over 500 records in their GSTR-10 return.<\/li>\n\n\n\n<li>Users must fill table-wise ITC reversal details across specific Excel tabs like Invoice_Available and Inv_Not_Avail.<\/li>\n\n\n\n<li>After validation, a JSON file must be generated and uploaded on the GST portal for final submission.<\/li>\n\n\n\n<li>Errors can be reviewed and fixed using the Error JSON file before regenerating and uploading the corrected file.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p>GSTR-10 is a final return that must be filed by taxpayers whose GST registration has been cancelled. It is mandatory to submit this return within three months of the cancellation date. While the return is filed online, the GST portal also offers an offline utility to enter details. If you need to input over 500 records, using the offline tool becomes mandatory.<\/p>\n\n\n\n<p>Continue reading this blog to learn about how to file GSTR 10 returns using the offline utility. This blog will take you through each step of the process from downloading offline utility tools to uploading information to the GST portal. Let\u2019s go through this guide one step at a time and file your final return without any stress.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Steps to Download and Open the Offline Tool for GSTR-10<\/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\/07\/Steps-to-Download-and-Open-the-Offline-Tool-for-GSTR-10.jpg\" alt=\"Steps to Download and Open the Offline Tool for GSTR-10\" class=\"wp-image-75746\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/07\/Steps-to-Download-and-Open-the-Offline-Tool-for-GSTR-10.jpg 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/07\/Steps-to-Download-and-Open-the-Offline-Tool-for-GSTR-10-300x200.jpg 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/07\/Steps-to-Download-and-Open-the-Offline-Tool-for-GSTR-10-150x100.jpg 150w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/07\/Steps-to-Download-and-Open-the-Offline-Tool-for-GSTR-10-768x512.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>The offline tool application for GSTR-10 offers a simple way to prepare your return without needing continuous internet access. Follow these steps to download and open the GSTR-10 offline tool:<\/p>\n\n\n\n<p>1.\u00a0Go to the <a href=\"https:\/\/www.gst.gov.in\/\" target=\"_blank\" rel=\"noopener\">official GST portal<\/a>.<\/p>\n\n\n\n<p>2.\u00a0Navigate to Downloads>Offline Tools>GSTR-10 Offline Tool.<\/p>\n\n\n\n<p>3.\u00a0Choose \u2018Download\u2019 and then click on the \u2018Proceed\u2019 button.<\/p>\n\n\n\n<p>4.\u00a0Extract contents as provided in the downloaded zip file. Visit the convenient location of the extracted file and then open the Excel file.<\/p>\n\n\n\n<p>5.\u00a0Click on the button titled \u2018Enable Editing\u2019 followed by the button of \u2018Enable Content\u2019 to make sure that the macros are being enabled.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>How to Add Table-Wise Details in the Worksheet?<\/strong><\/h3>\n\n\n\n<p>Here is a detailed step-by-step guide to follow for adding table-wise details in the respective worksheet:<\/p>\n\n\n\n<p>Step 1: Go to the &#8216;Home&#8217; worksheet tab and then proceed to fill out with personal details that include:<\/p>\n\n\n\n<p>1. GSTIN<\/p>\n\n\n\n<p>2. Date of cancellation of registration form<\/p>\n\n\n\n<p>3. Reference number of order subject to cancellation<\/p>\n\n\n\n<p>4. Date of cancellation order following tax period. Make sure to enter the dates in DD-MM-YYYY format<\/p>\n\n\n\n<p>Step 2: This step entails details for the table as required by the workbook which is summarized as follows:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>\u2018Invoice_Available&#8217; worksheet tab :<\/strong><\/h4>\n\n\n\n<p>In Form GSTR-10, respective tables 8A, 8B and 8C need to be filled out. Detailed overview of ITC reversal where there is availability of respective suppliers should be reported for the following:<\/p>\n\n\n\n<p>1. Semi-finished or finished goods held in stock<\/p>\n\n\n\n<p>2.\u00a0Inputs held in stock<\/p>\n\n\n\n<p>3. Finished goods kept in stock<\/p>\n\n\n\n<p>4.\u00a0Machinery and details of capital goods or plant<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>\u2018Inv_Not_Avail (with \u2019 worksheet-tab\u2019:<\/strong><\/h4>\n\n\n\n<p>Detailed information of Table 8D as mentioned in Form GSTR-10 should be mentioned in a table. Similar to details as prescribed for ITC reversal where there is non-availability of issue of invoice but GSTIN of suppliers are kept on record.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>\u2018Inv_Not_Avail (without \u2019 worksheet-tab\u2019:<\/strong><\/h4>\n\n\n\n<p>This tab comprises fields for Table 8D as mentioned in Form GSTR-10 for ITC reversal. However, no bulk invoices are available for respective suppliers of CX\/GSTIN\/VAT.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Generate a JSON File for Upload?<\/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\/07\/How-to-Generate-a-JSON-File-for-Upload.jpg\" alt=\"How to Generate a JSON File for Upload\" class=\"wp-image-75750\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/07\/How-to-Generate-a-JSON-File-for-Upload.jpg 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/07\/How-to-Generate-a-JSON-File-for-Upload-300x200.jpg 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/07\/How-to-Generate-a-JSON-File-for-Upload-150x100.jpg 150w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/07\/How-to-Generate-a-JSON-File-for-Upload-768x512.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>Following the steps below will enable you to generate a JSON file for uploading:<\/p>\n\n\n\n<p>1. Visit the \u2018Home\u2019 sheet which you can navigate from the \u2018Go Home\u2019 button.<\/p>\n\n\n\n<p>2. Scroll down further and then click on the \u2018Get Summary\u2019 button. This will display a detailed summary based on data provided in separate sheets.<\/p>\n\n\n\n<p>3.\u00a0Again, scroll up to the top of the page and click the \u2018Generate JSON File to Upload\u2019 button. When the \u2018Save As\u2019 window appears, choose your desired location and click \u2018Save\u2019.<\/p>\n\n\n\n<p>A pop-up message will appear confirming that the file has been saved and is ready for upload on the common portal. Click \u2018OK\u2019 to continue.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Upload the Generated JSON File of GSTR-10?<\/strong><\/h2>\n\n\n\n<p>Once you complete filling out GSTR-10 details, the next step is to continue uploading the generated JSON file on the GST portal. Here are the quick steps to follow to experience a smooth uploading process:<\/p>\n\n\n\n<p>1. Navigate to the official GST portal.<\/p>\n\n\n\n<p>2.\u00a0Go to Services>Return>Final Return.<\/p>\n\n\n\n<p>3.\u00a0Locate the GSTR-10 title and further tap on the \u2018Prepare Offline\u2019 button.<\/p>\n\n\n\n<p>4.\u00a0Within the \u2018Upload\u2019 section, click the \u2018Choose File\u2019 button, locate your saved JSON file on your device and then select \u2018Open\u2019 to proceed.<\/p>\n\n\n\n<p>5.\u00a0You will see a green message appear on the top with confirmation of uploading successfully. The user, however, might need to wait for 15 minutes while the file is being processed and verified further by the portal.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Download the Error JSON File?<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"599\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/07\/How-to-Download-the-Error-JSON-File.jpg\" alt=\"How to Download the Error JSON File?\" class=\"wp-image-75752\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/07\/How-to-Download-the-Error-JSON-File.jpg 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/07\/How-to-Download-the-Error-JSON-File-300x200.jpg 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/07\/How-to-Download-the-Error-JSON-File-150x100.jpg 150w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/07\/How-to-Download-the-Error-JSON-File-768x511.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>Downloading the error JSON file is quick and hassle-free. Follow these easy steps to get the file:<\/p>\n\n\n\n<p>1.\u00a0Once you complete the validation process, you will receive a link to download the error report. To download this report, click on the link titled &#8216;Generate Error Report&#8217;. A confirmation message will appear, and the error report column will indicate that the error generation report has been successfully requested.<\/p>\n\n\n\n<p>2. The error generation report may take some time to be generated. Once it is ready, a link will appear in the error report column labelled \u2018Download Error Report.\u2019 Click on this link to proceed.<\/p>\n\n\n\n<p>Following these steps, the error GSTR-10 JSON file will be easy to download on your device.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Fix Errors Using Offline Tool for GSTR-10?<\/strong><\/h2>\n\n\n\n<p>As mentioned previously, after extracting the error GSTR-10 JSON file to any suitable location in your computer, follow the instructions below:<\/p>\n\n\n\n<p>1.\u00a0Open the GSTR-10 offline utility and visit the \u2018Home\u2019 tab.<\/p>\n\n\n\n<p>2.\u00a0Visit the &#8216;Error Handling Section&#8217; and then further click on the &#8216;Open Downloaded Error JSON file&#8217;. Further, go to the desired location where you store the error JSON file and then click on &#8216;OK&#8217;.<\/p>\n\n\n\n<p>3.\u00a0Visit each sheet and then go through the column mentioning &#8216;GST Portal Validation Errors&#8217;. A text will appear in this column letting know the user about the nature of the chances of error. Make the necessary corrections and then choose the &#8216;Validate Sheet&#8217; button located on each sheet.<\/p>\n\n\n\n<p>4.\u00a0Navigate to the \u2018Home\u2019 tab and select the \u2018Generate JSON File to Upload\u2019 option.<\/p>\n\n\n\n<p>5. A pop-up window appears and you need to select the location where you want your JSON file to save. Further, click on the \u2018Save\u2019 button.<\/p>\n\n\n\n<p>Soon the screen will display a message requesting the user to upload the required file on the official GST portal.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Conclusion<\/strong><\/h2>\n\n\n\n<p>By now, you know how to file GSTR-10 returns with offline utility. This will help you file your final GST return with greater confidence. Using the offline tool enables you to work without the need for a continuous internet connection, giving you the flexibility to take your time, review your manual data entry and minimise filing errors.<\/p>\n\n\n\n<p>Once you complete filling out and validating the GST form, submitting the return is as easy as uploading the JSON file format on the GST portal.<\/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-1753790726569\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Who needs to file GSTR-10 and when?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>GSTR-10 is a final GST return that must be filed by taxpayers whose GST registration has been cancelled or surrendered. This return must be submitted within three months from the date of cancellation or the date of the cancellation order, whichever is later. Filing GSTR-10 ensures proper closure of the taxpayer&#8217;s liabilities. It is mandatory under GST law to avoid penalties or notices from the department.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1753790791458\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Why should I use the GSTR-10 offline utility tool?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>The offline utility is especially useful for users entering a large volume of data, particularly if there are more than 500 records. It allows preparation of the return without internet connectivity, helping avoid portal lags or session timeouts. The Excel-based tool supports macros and validation checks, ensuring accuracy before upload. It simplifies the process with clear tab-wise data entry and JSON file generation.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1753790802836\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">What are the key worksheet tabs in the GSTR-10 offline tool?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>The main tabs include:<br \/>\u2018Home\u2019 tab: For entering GSTIN and cancellation details.<br \/>\u2018Invoice_Available\u2019 tab: For Table 8A\u20138C (ITC reversal with invoice).<br \/>\u2018Inv_Not_Avail (with)\u2019 tab: For Table 8D (no invoice but supplier GSTIN available).<br \/>\u2018Inv_Not_Avail (without)\u2019 tab: For Table 8D (no invoice and no supplier GSTIN).<br \/>Each tab corresponds to a specific ITC category in the GSTR-10 return.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1753790819475\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">How do I generate and upload the JSON file for GSTR-10?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>After filling in all required details and validating the sheets in the offline tool, go to the \u2018Home\u2019 tab and click \u2018Get Summary\u2019 to review. Then click on \u2018Generate JSON File to Upload\u2019, choose your save location, and save the file. Log into the GST portal, navigate to Services &gt; Return &gt; Final Return, and under GSTR-10, select \u2018Prepare Offline\u2019. Upload your JSON file and wait for validation.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1753790842282\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">What should I do if my uploaded JSON file has errors?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>If errors are found during the upload, click on \u2018Generate Error Report\u2019 on the portal. Once ready, download the error JSON file, open it using the offline tool via the \u2018Open Downloaded Error JSON File\u2019 option. Check the \u2018GST Portal Validation Errors\u2019 column in each sheet to identify mistakes. Make the corrections, validate the sheets again, regenerate the JSON file, and re-upload it to the GST portal.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Key Takeaways GSTR-10 is a final return that must be filed by taxpayers whose GST registration has been cancelled. It is mandatory to submit this return within three months of the cancellation date. While the return is filed online, the GST portal also offers an offline utility to enter details. If you need to input [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":75744,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-75713","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\/75713","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/comments?post=75713"}],"version-history":[{"count":3,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/75713\/revisions"}],"predecessor-version":[{"id":75773,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/75713\/revisions\/75773"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/media\/75744"}],"wp:attachment":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/media?parent=75713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/categories?post=75713"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/tags?post=75713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}