Skip to main content

Steps to Prepare GSTR-9 & 9C Statement via Offline Utility

How to Prepare GSTR-9 & 9C Statement Using Offline Utility

The Goods and Services Tax Network (GSTN) has made public use of an offline utility for forms GSTR-9 and GSTR-9C for the Fiscal Year 2022-23.

All registered taxpayers who were formerly normal taxpayers, including SEZ units and SEZ developers, need to file Form GSTR-9 once every fiscal year. In this return, taxpayers are required to include information about their purchases, sales, input tax credit, and any demands or refund claims.

The GSTR 9C reconciliation statement compares the details from the yearly returns filed under GSTR-9 for the relevant fiscal year with the details available in the taxpayer's audited annual financial statement. It includes information regarding the taxpayer's gross and taxable income as stated in its books of accounts, as well as the comparable values acquired by summing all of the GST returns submitted throughout the fiscal year.

How to Prepare GSTR-9 Form Using Offline Tool?

  1. First of all, kindly make sure you download the updated version of the GSTR-9 Offline Tool from the GST portal. https://www.gst.gov.in/download/returns
  2. Open the GSTR-9 Excel-based Offline Tool, a pop-up, asking you to open the saved version yes/no, would display and go to the worksheet named 'Home'
  3. By clicking on 'Yes', you will be able to access any previously saved data in the offline tool.
  4. By clicking on 'No', you will lose any previously saved data in the offline tool and you will not be able to recover the data
  5. Fill in your GSTIN  in the home sheet. Enter GSTIN in the right format as it will only validate that the GSTIN has the correct structure
  6. Choose the relevant Financial Year from the drop-down which is mandatory
  7. Choose the AATO option of the relevant Previous Year from the drop-down. It is also a mandatory field
  8. After login into the GST Portal, download the GSTR-9 JSON file from the 'Prepare Offline' section of the GSTR-9 file
  9. In the Offline tool, open the downloaded GSTR-9 JSON file. The Offline tool cannot generate a JSON file until the GSTR-9 JSON file downloaded from the portal is opened in the Offline tool
  10. Auto-drafted information must be filled in the relevant worksheet
  11. Enter essential information/edit auto-drafted details pertinent to various worksheets. It is not required to fill data in all worksheets. The worksheet for which no detail needs to be revealed can be left blank
  12. Click Validate Sheet to check the validation status. In case of validation failure; please check for cells where validation showing failed and correct errors following the help text
  13. In order to generate a JSON file to upload GSTR-9 return details prepared offline on the GST portal, click the 'Generate JSON File to Upload' button

Important Steps for Uploading GSTR-9 Form on the GST Portal

  • Select ‘Returns Dashboard’ after login to GST Portal
  • Choose the relevant Financial Year and then click on the option “Prepare Offline” in the “Annual Return” tile/Box
  • Upload the JSON prepared using the offline Tool by selecting the upload option in the return dashboard
  • The JSON file that was uploaded would be checked and then processed
  • If validation fails upon processing; errors if any would be displayed on the portal
  • Following the successful upload of data to the GST Portal, the taxpayer must preview the form and file GSTR-9 Return

Note: You can also download the records successfully processed on the GST portal anytime by navigating to ‘Services > Returns > Annual Return >  Financial Year > Search > Prepare Offline > Download’. In about 20 Mins, by clicking on download a JSON file you will be able to download it. The downloaded JSON file may be opened in Offline Tool using ‘Open Downloaded GSTR-9 JSON File’ to view/ edit/update details. Post update of details creates JSON to upload on GST portal.”

GSTR-9C Form Preparation Steps Using Offline Tool

  1. Kindly make sure you download the updated version of the GSTR-9C Offline Tool from the GST portal. https://www.gst.gov.in/download/returns
  2. Open the GSTR-9C Excel-based Offline Tool and go to the worksheet named ‘Home’
  3. In order to open the Offline tool with the previous details you filled in, you need to click on “Yes” when the dialogue box pops up displaying “Open Saved Version?”. If you click on “No” you will lose all the values available in the sheets as it will clear them
  4. Enter your and taxpayer’s GSTIN in the home sheet. Entered GSTIN would be validated only for the correct format
  5. Select the relevant Financial Year from the drop-down which is a mandatory area to fill
  6. Enter pertinent details in various worksheets. It is not required to fill data in all worksheets. The worksheet for which no details are required to be declared can be left blank. You may use GSTR 9C Tables derived from GSTR 9 (PDF), to fill values in worksheets regarding the GSTR-9. The PDF can be downloaded from the GST portal (Services> Annual Return> Initiate Filing)
  7. Click Validate Sheet to verify the validation status. If it fails to validate, please check for cells that have failed validation and correct errors following the help text
  8. Click on the option ‘Generate JSON File to Upload‘ in order to generate a JSON file and sign through DSC (Digital Signature Certificate)

Note: To generate the JSON, make sure the HTML file names ‘wsweb’ and ‘GSTR_9C_Offline_Utility’ should be in the same folder.

Steps for uploading GSTR-9C Form on GST Portal

  • This signed GSTR 9C JSON file shall be passed to the taxpayer for upload by the auditor
  • Then taxpayers are required to login to GST Portal and select ‘Returns Dashboard’
  • Choose the relevant Financial Year and Tax-period. Then click on ‘Prepare Offline’
  • Upload the JSON prepared using an Offline Tool using the upload option
  • The uploaded JSON file would then be validated and processed further
  • If it fails to validate one or more details in the uploaded JSON, an error file (returns_<Date>_R9C_error Report.json) would be created with the status of the uploaded JSON file as  ‘Processed with Error’
  • The error file shall be shared with the auditor by the taxpayer to make the correction in the error and resign the same
  • The auditor should open the error file in the offline tool by selecting 'Open GSTR-9C JSON Error file downloaded from GST Portal'. All records containing errors should be filled in the relevant worksheets. For each record with errors, the column 'GST Portal Validation error(s)' should be filled with appropriate error descriptions. After correcting the errors, proceed to sign the statement using the Digital Signature Certificate (DSC). Once the statement is signed, generate the JSON file and then sent it back to the taxpayer to upload it on the GST portal to complete the filing process
  • After uploading the data successfully on the GST portal, the taxpayer should check the form and file GSTR-9C


Comments

Popular posts from this blog

A Full Guide to GST E-Way Bill 2 for Faster Compliance

  Have you encountered any challenges while trying to create a GST E-way bill using the government portal? If yes, SAG Infotech is here to provide some important solutions for you. NIC has launched the GST E-Way Bill 2 Portal. Designed to Offer GST E-way Bill Services with High Availability Using the e-way bill site, taxpayers and logistics operators can log in with their current account and password. Data from the GST E-way Bill2 site will be verified, combined, and available on the main GST E-way Bill portal for all business and analytical objectives. To guarantee that e-invoice generation is unaffected, this portal is integrated with another e-invoice portal for e-way bill generation. Users can freely create and amend E-Way Bills using the GST E-Way Bill2 Portal. The seamless integration and merging of the e-Waybill1 and e-Waybill2 systems will lessen reliance on the e-Waybill1 system in emergencies. E-way bill details are synchronised with the main portal in only a few seconds

Gen Online Payroll Software for Small Business in India

In today's digital world, every person and businessperson works very hard to manage data manually, which can be a time-consuming and labour-intensive task, particularly when information needs to be constantly updated and verified. Likewise, managing large volumes of employee-related data can be a challenging and overwhelming task for HR professionals. Therefore, to address the workload and complexity of these tasks, the IT sector has developed Payroll software. In recent years, we have seen a huge growth in the number of Payroll software options. Yes, there are many types of HR Payroll software available in the Indian market at present. If you're looking for a reliable and popular payroll software option, you can choose Gen Online Payroll software, brought to you by SAG Infotech. Whether the business is medium or small, Gen Payroll software can make managing numerous important tasks of a human resources manager hassle-free. The Online Payroll software assigns a unique

GST Collection of August 2024 Reaches INR 1.75 Lakh Crore

Concerning the financial front, gross GST collections for August 2024 show a strong 10% growth, reaching approximately ₹1.75 lakh crore.  This surge, driven by robust domestic consumption, led to a 9.2% increase in GST revenues from domestic transactions to approximately ₹1.25 lakh crore. Revenue from imported goods also saw a substantial rise of 12.1%, totalling ₹49,976 crores.  Despite the overall growth, there was a slight decrease from the ₹1.82 lakh crore collected in July 2024 when compared month-on-month. However, industry experts remain optimistic.  They point out that the 10% year-on-year increase at the commencement of the festive season is a strong indicator of sustained and potentially growing consumption in the upcoming months. The government's ongoing efforts to simplify the GST process, especially through measures such as adjusting rates to lower working capital expenses, have been positively acknowledged.  This dedication is also evident in the ₹24,460 crore in