{"id":22105,"date":"2024-10-15T07:51:34","date_gmt":"2024-10-15T02:21:34","guid":{"rendered":"https:\/\/piceapp.com\/blogs\/?p=22105"},"modified":"2024-12-26T12:46:56","modified_gmt":"2024-12-26T07:16:56","slug":"how-to-prepare-gstr-9c-offline","status":"publish","type":"post","link":"https:\/\/piceapp.com\/blogs\/how-to-prepare-gstr-9c-offline\/","title":{"rendered":"How to Prepare GSTR 9C Offline?"},"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\">Key Takeaways<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Prerequisites<\/strong>: Ensure you have a laptop (Windows 7+), Excel 2010+, GSTIN credentials, and audited accounts with over \u20b92 crore turnover.<\/li>\n\n\n\n<li><strong>Downloading the Tool<\/strong>: Download the GSTR-9C offline tool from the GST portal, extract it, and follow setup instructions.<\/li>\n\n\n\n<li><strong>Filling GSTR-9C<\/strong>: Fill in key sections, such as turnover reconciliation, tax liability, and ITC, based on audited financial statements.<\/li>\n\n\n\n<li><strong>JSON Generation<\/strong>: Generate the JSON file using the offline tool, sign with emSigner, and upload it to the GST portal for submission.<\/li>\n\n\n\n<li><strong>Error Correction<\/strong>: Use the tool to fix validation errors and re-upload the corrected JSON for successful GSTR-9C filing.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p>Taxpayers often have queries regarding <strong>how to prepare GSTR-9C offline<\/strong>. The process includes certain factors, such as JSON generation and filing, followed by the use of a <a href=\"https:\/\/www.mca.gov.in\/MinistryV2\/digitalsignaturecertificate.html\" target=\"_blank\" rel=\"noopener\">digital signature certificate<\/a> or electronic verification code. It further requires the extraction of data from GSTR-9 for accurate filing.<\/p>\n\n\n\n<p>In this blog, we will learn about form GSTR-9C statement offline preparation and how auditors generate JSON and send it to the taxpayers for GSTR-9C filing. This blog additionally elaborates on the parts of the GSTR-9C form that you need to fill in to file offline GSTR-9C.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Prerequisites for Using the Offline Tool for GSTR-9C<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"506\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/Prerequisites-for-Using-the-Offline-Tool-for-GSTR-9C.png\" alt=\"Prerequisites for Using the Offline Tool for GSTR-9C\" class=\"wp-image-22217\" style=\"aspect-ratio:16\/9;object-fit:cover\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/Prerequisites-for-Using-the-Offline-Tool-for-GSTR-9C.png 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/Prerequisites-for-Using-the-Offline-Tool-for-GSTR-9C-300x169.png 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/Prerequisites-for-Using-the-Offline-Tool-for-GSTR-9C-768x432.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>The pre &#8211; requisites or pre &#8211; conditions for using the GSTR-9C offline utility tool are as follows:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Users need to have a laptop or a desktop<\/li>\n\n\n\n<li>Availability of Windows 7 and above<\/li>\n\n\n\n<li>Use of Microsoft Excel 2010 and above<\/li>\n\n\n\n<li>The user needs to be a GST-registered taxpayer having a valid GSTIN.<\/li>\n\n\n\n<li>He\/she needs to have valid <a href=\"https:\/\/www.passcamp.com\/blog\/what-are-login-credentials\/\" target=\"_blank\" rel=\"noopener\">login credentials<\/a> like user ID and password.<\/li>\n\n\n\n<li>Users should have filed GSTR-9 in that financial year with relevant documents.<\/li>\n\n\n\n<li>The aggregate turnover of the taxable person needs to be over \u20b92 crore.<\/li>\n\n\n\n<li>He\/she should have the accounts audited with mandatory documents for business compliance.<\/li>\n\n\n\n<li>The user should have the latest version of the offline utility downloaded from the GST portal.<\/li>\n\n\n\n<li>Users must have generated GSTR-9C JSON\/PDF\/Excel files by downloading them from the GST portal.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Steps to Download and Open the Offline Tool for GSTR-9C<\/strong><\/h2>\n\n\n\n<p>Here are the steps to download and open the offline tool for GSTR-9C:<\/p>\n\n\n\n<p><strong>Step 1:<\/strong> Visit the official unified GST portal and select \u2018Downloads\u2019.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>Click on \u2018Offline Tools\u2019 and then \u2018GSTR-9C Offline Tool\u2019.<\/p>\n\n\n\n<p><strong>Step 3: <\/strong>Select the download link on the GSTR-9C offline utility page.<\/p>\n\n\n\n<p><strong>Step 4: <\/strong>Click on the confirmation pop-up message \u2018Proceed\u2019.<\/p>\n\n\n\n<p><strong>Step 5: <\/strong>You will find the downloaded ZIP file. Extract it to use it in Excel format. You can right-click on &#8216;Open&#8217; to use the file.<\/p>\n\n\n\n<p>Apart from the utility, you will find the following files:<\/p>\n\n\n\n<p><strong>Readme:<\/strong> This file contains installation instructions and prerequisites for installation. You can read through the instructions before installing them to ensure accuracy.<\/p>\n\n\n\n<p><strong>Release Notes: <\/strong>Enhancement details made to the GSTR-9C offline tool are available in this file.<\/p>\n\n\n\n<p><strong>Wsweb HTML File: <\/strong>You need to save the utility file and the HTML in the same folder for generating JSON.<\/p>\n\n\n\n<p><strong>Step 6: <\/strong>Select \u2018Enable Editing\u2019 and \u2018Enable Content\u2019 on the GSTR-9C offline utility page.<\/p>\n\n\n\n<p><strong>Step 7:<\/strong> Ensure you visit the &#8216;Readme&#8217; option to read the installation instructions.<\/p>\n\n\n\n<p><strong>Step 8: <\/strong>Visit the GST home tab and enter details such as GSTIN, legal and trade name, the name of the Act under which your organisation is being audited and choose the financial year from the drop-down list.<\/p>\n\n\n\n<p><strong>Step 9: <\/strong>You can proceed to fill in Part A of the form. However, if you save the data and close the utility page, you will receive a pop-up message &#8216;Open Saved Version?&#8217; which you need to choose to avoid filling in the details again.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Steps to Prepare GSTR-9C Using the Offline Tool<\/strong><\/h2>\n\n\n\n<p>The details in Part A need to be filled in by an auditor. Here are the steps to fill in important sub-parts of Part A:<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Filing Form GSTR-9C Offline\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/WTZ45Hqb7AE?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>PT II(5)- Reconciliation of Gross Turnover<\/strong><\/h4>\n\n\n\n<p>Here are the steps to fill in this part:<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Navigate to PT II (5) and enter the amounts in the designated column. Further, fill in the following details:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>5A turnover details in accordance with the <a href=\"https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/audited-financial-statements\/\" target=\"_blank\" rel=\"noopener\">audited financial statements<\/a> for the state or union territory<\/li>\n\n\n\n<li>5B\/5H unbilled revenue of the financial year beginning\/ending<\/li>\n\n\n\n<li>5C\/5I deemed supply according to Schedule 1<\/li>\n\n\n\n<li>5E credit notes mentioned in GSTR-9, however, were issued after the financial year-end<\/li>\n\n\n\n<li>5F trade discounts according to audited financial statements, however, not eligible under GST<\/li>\n\n\n\n<li>5G turnover from April to June 2017<\/li>\n\n\n\n<li>5J credit notes according to audited financial statements, however, not eligible for GST<\/li>\n\n\n\n<li>5K adjustments due to goods supply by special economic zone units to domestic traffic area units<\/li>\n\n\n\n<li>5M, 5N, 5O adjustments in turnover according to Section 15, foreign exchange fluctuations, reasons not listed in the above-mentioned respective tables<\/li>\n\n\n\n<li>5P annual turnover after adjustments as above<\/li>\n\n\n\n<li>5Q turnover as declared in form GSTR-9<\/li>\n\n\n\n<li>5R unreconciled turnover which is a difference of Q &amp; P above<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 2: <\/strong>Once updating the requirements is complete, click on \u2018Validate Sheet\u2019. If it is validated, you will see a success message pop-up: \u2018Sheet Successfully Validated\u2019. However, if it is not validated, you will see an error message pop-up: \u2018There Are Validation Errors in the Sheet. Correct them to Proceed\u2019. In the latter case, you will have to rectify the errors before you proceed to validation again.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>PT II(8)- Reasons for Un-reconciled Difference in Taxable Turnover<\/strong><\/h4>\n\n\n\n<p>Visit tab PT II (8) and follow the steps similar to PT II(6)- reasons.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>PT III(9)- Reconciliation of Rate-wise Liability and the Amount Payable Thereon<\/strong><\/h4>\n\n\n\n<p>Here are the steps for this part:<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Navigate to the PT III (9) tab and fill in the taxable value and <a href=\"https:\/\/www.investopedia.com\/terms\/i\/incometaxpayable.asp\" target=\"_blank\" rel=\"noopener\">tax payable columns<\/a>. Here are the details you need to fill in:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>9A to 9O update details of tax rates, penalties, interest, late fees and others<\/li>\n\n\n\n<li>9P fill in the total payable amount<\/li>\n\n\n\n<li>9Q mentions the total amount paid according to GSTR-9<\/li>\n\n\n\n<li>9R total unreconciled payment<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 2: <\/strong>After filling in click on \u2018Validate Sheet\u2019 to complete the process. If there is an error file or unsuccessful validation, correct the errors and upload again.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>PT III(10)- Reasons for Unreconciled Payment of Tax<\/strong><\/h4>\n\n\n\n<p>Navigate to PT III (10) and follow the steps in PT II (6).<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>PT III(11)- Additional Amount Payable but Not Yet Paid<\/strong><\/h4>\n\n\n\n<p>Here are the steps for this part:<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Navigate to PT III (11) and fill in the taxable value and tax paid in the cash columns.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>On completion, click on \u2018Validate Sheet\u2019 and rectify if there are errors.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>PT IV(12)- Reconciliation of Net ITC<\/strong><\/h4>\n\n\n\n<p>These are the steps for this part:<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Navigate to PT IV (12) and enter the following details:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>12A fill in the ITC (input tax credit) availed according to audited financial statements for the state or union territory<\/li>\n\n\n\n<li>12B fills in the ITC amount booked in previous financial years, however, claimed in the current financial year<\/li>\n\n\n\n<li>12C fills in the ITC amount booked in the current financial year, however is yet to be claimed in the forthcoming financial years<\/li>\n\n\n\n<li>12D fill in the ITC amount availed according to the audited financial statements<\/li>\n\n\n\n<li>12E fill in the ITC amount claimed according to GSTR-9<\/li>\n\n\n\n<li>12F mention reasons for unreconciled ITC<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 2: <\/strong>Once you have updated the details, click on \u2018Validate Sheet\u2019 to complete the procedure. Rectify any error if validation fails.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>PT IV(13)- Reasons for Unreconciled Difference in ITC<\/strong><\/h4>\n\n\n\n<p>Visit the tab PT IV (13) and follow the steps highlighted in PT II (6).<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>PT IV(14)- Reconciliation of ITC as Declared in GSTR-9 with ITC Availed on Expenses as per Audited Financial Statements or Books of Accounts<\/strong><\/h4>\n\n\n\n<p>Follow the steps below to fill in this part:<\/p>\n\n\n\n<p><strong>Step 1:<\/strong> Navigate to the PT IV (14) tab and fill in the total ITC amount and eligible ITC claims. Here is how to fill in the columns in this part:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>14A to 14Q fill in the expense sub-heads<\/li>\n\n\n\n<li>14R mentions the total eligible ITC availed<\/li>\n\n\n\n<li>14S mention the ITC claimed in GDSTR-9<\/li>\n\n\n\n<li>14T mentions the reasons for unreconciled ITC<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 2: <\/strong>After filling in the details, click on \u2018Validate Sheet\u2019 and correct errors if necessary.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>PT IV(15)- Reasons for Unreconciled Difference in ITC<\/strong><\/h4>\n\n\n\n<p>Follow the steps mentioned in PT II (6) to fill in this part.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>PT IV(16)- Tax Payable on the Unreconciled Difference in ITC<\/strong><\/h4>\n\n\n\n<p>Navigate to PT IV (16) and fill in the amount payable details.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>PT V Additional Liability Due to Non-reconciliation<\/strong><\/h4>\n\n\n\n<p>Follow the steps below to fill in this part of the un-reconciled payment presenting a recommendation on additional liability:<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Navigate to PT V and fill in the tax to be paid and other values.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>Once completed, select the \u2018Validate Sheet\u2019 option for verification details. If there are errors, the screen will display a message and you need to rectify the corrupt files.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Download the Filed Form GSTR-9 for Preparing Form GSTR-9C?<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"506\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/How-to-Download-the-Filed-Form-GSTR-9-for-Preparing-Form-GSTR-9C.png\" alt=\"How to Download the Filed Form GSTR-9 for Preparing Form GSTR-9C\" class=\"wp-image-22219\" style=\"aspect-ratio:16\/9;object-fit:cover\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/How-to-Download-the-Filed-Form-GSTR-9-for-Preparing-Form-GSTR-9C.png 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/How-to-Download-the-Filed-Form-GSTR-9-for-Preparing-Form-GSTR-9C-300x169.png 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/How-to-Download-the-Filed-Form-GSTR-9-for-Preparing-Form-GSTR-9C-768x432.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>Here is the process to download filed GSTR-9 for preparing GSTR-9C:<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Visit the official GST portal and log in using the user credentials.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>Click on the \u2018Services\u2019 option and choose \u2018Returns\u2019 and then \u2018<a href=\"https:\/\/www.investopedia.com\/terms\/a\/annual-return.asp\" target=\"_blank\" rel=\"noopener\">Annual Returns\u2019.<\/a><\/p>\n\n\n\n<p><strong>Step 3: <\/strong>Choose the financial year and click on \u2018Search\u2019 on the annual return tiles.<\/p>\n\n\n\n<p><strong>Step 4: <\/strong>You will find two options \u2018Annual Return GSTR9\u2019 and \u2018Reconciliation Statement GSTR-9C\u2019. Click on \u2018Download GSTR-9 tile\u2019 on the first option.<\/p>\n\n\n\n<p><strong>Step 5: <\/strong>The screen will display the offline download for the GSTR-9 page. Click on the convenient option to download the filed form in Excel or system-generated PDF format.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Download Form GSTR-9C Tables Derived from Form GSTR-9?<\/strong><\/h2>\n\n\n\n<p>Follow the steps below to download GSTR-9C tables derived from form GSTR-9:<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Navigate to the official unified portal of GST and log in using valid credentials.<\/p>\n\n\n\n<p><strong>Step 2:<\/strong> Click on \u2018Services\u2019, \u2018Returns\u2019 and then \u2018Annual Return\u2019.<\/p>\n\n\n\n<p><strong>Step 3: <\/strong>Choose the financial year and click on the \u2018Search\u2019 button.<\/p>\n\n\n\n<p><strong>Step 4: <\/strong>Click on the &#8216;Initiate Filing&#8217; option to download reports associated with the GSTR-9C tile.<\/p>\n\n\n\n<p><strong>Step 5: <\/strong>Select \u2018Download GSTR-9C Tables Derived From GSTR-9 (PDF)\u2019 to download the PDF file.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Generate the JSON File for Upload and Affix the DSC?<\/strong><\/h2>\n\n\n\n<p>To generate the processed GSTR-9C JSON file, you need to install emSigner in your system. Further, you need to enter the PAN in your PT V tab same as that used for DSC (digital signature certificate) to avoid discrepancies in the JSON generation process.<\/p>\n\n\n\n<p>Here are the detailed steps to generate the JSON file:<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>On the GST Home tab, click \u2018Generate JSON File to Upload GSTR-9C details on GST Portal\u2019.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>Click on &#8216;Save&#8217; on the &#8216;Save As&#8217; dialogue box. You will receive a pop-up message on the screen. Click on the &#8216;Allow Blocked Content&#8217; of ActiveX pop-up in Internet Explorer.<\/p>\n\n\n\n<p><strong>Step 3:<\/strong> Click on \u2018Initiate Signing\u2019. The screen will display a pop-up message \u2018Ready to Sign-up\u2019. Click on \u2018Ok\u2019.<\/p>\n\n\n\n<p><strong>Step 4: <\/strong>Click on \u2018Open emSigner\u2019, choose the certificate and sign.<\/p>\n\n\n\n<p><strong>Step 5: <\/strong>Click \u2018Ok\u2019 on the pop-up message displayed. The message indicates that the JSON file is signed.<\/p>\n\n\n\n<p><strong>Step 6: <\/strong>Click on the next pop-up message \u2018Ok\u2019 to complete the process.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Upload the Generated JSON File of GSTR-9C?<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"506\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/How-to-Upload-the-Generated-JSON-File-of-GSTR-9C.png\" alt=\"How to Upload the Generated JSON File of GSTR-9C?\" class=\"wp-image-22222\" style=\"aspect-ratio:16\/9;object-fit:cover\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/How-to-Upload-the-Generated-JSON-File-of-GSTR-9C.png 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/How-to-Upload-the-Generated-JSON-File-of-GSTR-9C-300x169.png 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/How-to-Upload-the-Generated-JSON-File-of-GSTR-9C-768x432.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>Once the auditor sends the generated zipped processed GSTR-9C JSON file to a normal taxpayer, the below-mentioned steps need to be followed:<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Log in to the unified GST portal using login credentials.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>Click on \u2018Services\u2019, \u2018Returns\u2019 and then \u2018Annual Return\u2019.<\/p>\n\n\n\n<p><strong>Step 3: <\/strong>Ensure to choose the financial year before clicking \u2018Search\u2019 on the \u2018File Annual Returns\u2019 page. Further, click on \u2018Prepare Offline\u2019 on the \u2018Reconciliation Statement GSTR-9C\u2019 tile to proceed with reconciliation statement details.<\/p>\n\n\n\n<p><strong>Step 4: <\/strong>Browse the file by clicking &#8216;Choose File&#8217; to upload format. Ensure you choose the JSON file for upload. On successful validation, the screen will display a message indicating a successful upload.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Initiate the Filing of Form GSTR-9C?<\/strong><\/h2>\n\n\n\n<p>Here are the steps to initiate the filing of form GSTR-9C:<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Visit the official GST portal.<\/p>\n\n\n\n<p><strong>Step 2:<\/strong> Select \u2018Services\u2019, \u2018Returns\u2019 and \u2018Annual Return\u2019 in sequential order.<\/p>\n\n\n\n<p><strong>Step 3: <\/strong>Select the correct financial year and click \u2018Search\u2019.<\/p>\n\n\n\n<p><strong>Step 4: <\/strong>Click on \u2018Initiate filing\u2019.<\/p>\n\n\n\n<p><strong>Step 5:<\/strong> On the displayed page, ensure you undertake the following activities:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on &#8216;DRC-03&#8217; to make an additional liability payment.<\/li>\n\n\n\n<li>Ensure you upload the balance sheet, profit and loss statement\/ income and expenditure statement. You can upload two files with 5MB size for each in JPEG or PDF format.<\/li>\n\n\n\n<li>Click &#8216;Save&#8217; and then &#8216;Proceed to file&#8217;. Saving the file helps you for future reference.<\/li>\n\n\n\n<li>To preview PDF file before uploading, you can click on &#8216;Preview Draft GSTR-9C&#8217;.<\/li>\n\n\n\n<li>After you scrutinise the draft GSTR-9C, click \u2018Proceed to File\u2019.<\/li>\n\n\n\n<li>Choose the declaration checkbox and authorised signatory before you click on \u2018File GSTR-9C\u2019.<\/li>\n\n\n\n<li>The screen will display a pop-up message where you need to click on \u2018Yes\u2019 to proceed and file with DSC or EVC.<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 6:<\/strong> On successful filing completion, the screen will display a message indicating the same.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Fix Errors Using the Offline Tool for GSTR-9?<\/strong><\/h2>\n\n\n\n<p>Once you extract the JSON file to a convenient location on your laptop or desktop, follow the steps below to fix errors:<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Open the offline utility and go to the \u2018GST Home\u2019 tab.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>Click &#8216;Open Downloaded Error JSON Files&#8217;, go to the location where you have saved it and click &#8216;Ok&#8217;. Ensure you select both files from the unzipped folder prior to clicking &#8216;Ok&#8217;. The screen will display a message &#8216;Error Files Successfully Opened&#8217;.<\/p>\n\n\n\n<p><strong>Step 3: <\/strong>On each of the sheets, go to \u2018GST Portal Validation Errors\u2019 to find out the nature of the error. Rectify the errors and click on \u2018Validate Sheet\u2019.<\/p>\n\n\n\n<p><strong>Step 4: <\/strong>Visit the \u2018Home\u2019 sheet again and click on \u2018Generate JSON File to Upload\u2019.<\/p>\n\n\n\n<p><strong>Step 5: <\/strong>The window will display a \u2018Save As\u2019 pop-up message for you to choose the location. Once complete, click on \u2018Save\u2019. The screen will display a message, asking you to upload the file on the unified portal.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Steps to Prepare GSTR-9 Using the Offline Tool<\/strong><\/h2>\n\n\n\n<p>Here are the steps that you need to follow to prepare GSTR-9 using the offline tool. You need to start by entering the following table-wise details in the sheet as given below.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"506\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/Steps-to-Prepare-GSTR-9-Using-the-Offline-Tool.png\" alt=\"Steps to Prepare GSTR-9 Using the Offline Tool\" class=\"wp-image-22224\" style=\"aspect-ratio:16\/9;object-fit:cover\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/Steps-to-Prepare-GSTR-9-Using-the-Offline-Tool.png 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/Steps-to-Prepare-GSTR-9-Using-the-Offline-Tool-300x169.png 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2024\/10\/Steps-to-Prepare-GSTR-9-Using-the-Offline-Tool-768x432.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Table 4 Outward:<\/strong> Summarises the outward\/inward supplies undertaken during a financial year<\/li>\n\n\n\n<li><strong>Table 5 Outward:<\/strong> Summarises non-taxable outward supplies during a fiscal year<\/li>\n\n\n\n<li><strong>Table 6 ITC availed:<\/strong> Summarises the amount of ITC availed during a financial year<\/li>\n\n\n\n<li><strong>Table 7 ITC Rev<\/strong>: Summarises the amount of ITC reversed for the fiscal year<\/li>\n\n\n\n<li><strong>Table 8 Other ITC: <\/strong>Summarises ITC availed during a financial year<\/li>\n\n\n\n<li><strong>Table 9 Tax Paid: <\/strong>Details of tax paid during a fiscal year like interest, late fee, penalty and others<\/li>\n\n\n\n<li><strong>Table 10 PY Trans in Current FY:<\/strong> Summarises transactions reported in the following financial year.<\/li>\n\n\n\n<li><strong>Table 14 Differential Tax: <\/strong>Summarises the total tax paid on transactions reported in the following financial year.<\/li>\n\n\n\n<li><strong>Table 15 Demands and Refunds:<\/strong> Summary of demands and refunds during a fiscal year.<\/li>\n\n\n\n<li><strong>Table 16 Comp DS and Goods Sent on Appr:<\/strong> Summarises suppliers received from composition taxpayers, deemed supply by job workers and goods sent based on approvals.<\/li>\n\n\n\n<li><strong>Table 17 HSN Outward: <\/strong>Summarises outward supplies HSN-wise during a financial year.<\/li>\n\n\n\n<li><strong>Table 18 HSN Inward: <\/strong>Summarises inward supplies HSN-wise during a financial year.<\/li>\n<\/ul>\n\n\n\n<p>To validate the data and generate the JSON file, follow the given below steps:&nbsp;<\/p>\n\n\n\n<p><strong>Step 1:<\/strong> Once you complete filling in the data, click \u2018Validate\u2019 and wait for the success message. If there are incorrect entries, the screen will display a message indicating the same.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>Once completed, go to the \u2018Home\u2019 tab and click \u2018Generate JSON File to Upload\u2019.<\/p>\n\n\n\n<p><strong>Step 3:<\/strong> The screen will display a \u2018Save As\u2019 pop-up window where you can choose the location to save the file. Click \u2018Save\u2019 after selecting the location to complete the process.<\/p>\n\n\n\n<p>A message will confirm that the details have been saved successfully, following which you can upload the file on the GST portal.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Conclusion<\/strong><\/h2>\n\n\n\n<p>To answer <strong>how to prepare GSTR-9C offline<\/strong>, you need to understand the generation and filing of JSON. Additionally, understanding the process of extracting data from the annual return form GSTR-9 is crucial for a seamless GSTR-9C filing of return and maintaining a connected <a href=\"https:\/\/www.investopedia.com\/terms\/b\/business-ecosystem.asp\" target=\"_blank\" rel=\"noopener\">finance ecosystem. <\/a><\/p>\n\n\n\n<p>By following the steps of every sub-process mentioned above, you can conveniently prepare GSTR-9C offline.<\/p>\n\n\n\n<p class=\"has-ast-global-color-4-background-color has-background\">\ud83d\udca1If you want to streamline your payment and make GST payments, 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\">FAQs<\/h3>\n\n\n<div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1728558065461\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>What is GSTR-9C, and who needs to file it?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>GSTR-9C is a reconciliation statement that must be filed by taxpayers with an annual turnover of over \u20b92 crore. It compares the financial statements and GSTR-9 returns. Filing is mandatory along with the submission of audited financial statements, ensuring that the details reported to the GST authorities match the audited data.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1728558075816\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>How do I download and install the GSTR-9C offline tool?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>You need a laptop or desktop with Windows 7 or above, Microsoft Excel 2010 or later, valid GSTIN login credentials, and a filed GSTR-9 for the financial year. Additionally, you must have the GSTR-9C offline utility downloaded from the GST portal and the audited financial statements ready for reference.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1728558102856\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>How can I generate the JSON file for GSTR-9C submission?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Visit the GST portal, select &#8220;Downloads,&#8221; and navigate to &#8220;Offline Tools&#8221; to download the GSTR-9C tool. Extract the ZIP file and follow the instructions in the Readme file to install the tool. Ensure the utility files and HTML file are in the same folder for generating JSON files.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1728558109508\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>What should I do if there are errors in the GSTR-9C JSON file?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>The PICE App helps streamline vendor payments and simplify the invoice management process. By automating tasks and offering easy tracking of payments, it reduces the likelihood of errors in GST compliance and ensures a smoother financial workflow for businesses.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Key Takeaways Taxpayers often have queries regarding how to prepare GSTR-9C offline. The process includes certain factors, such as JSON generation and filing, followed by the use of a digital signature certificate or electronic verification code. It further requires the extraction of data from GSTR-9 for accurate filing. In this blog, we will learn about [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":22215,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-22105","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\/22105","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\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/comments?post=22105"}],"version-history":[{"count":1,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/22105\/revisions"}],"predecessor-version":[{"id":57094,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/22105\/revisions\/57094"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/media\/22215"}],"wp:attachment":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/media?parent=22105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/categories?post=22105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/tags?post=22105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}