Table of Contents

 

File GSTR-9 on the Portal Using TallyPrime Data

Release 7.2 & later

Release 7.1 & earlier

GSTR-9 is a yearly return where you summarise all the GST you have reported during the year. It is mandatory if your annual turnover is more than ₹2 crore, and optional if your turnover is ₹2 crore or less.

TallyPrime helps you prepare for filing GSTR-9 with the GST Annual Computation report, a consolidated view of your annual GST data from books.

You can export GSTR-9 data (HSN/SAC Summary or all sections of GSTR-9) to the GSTR-9 Offline Tool. This helps you reduce manual data entry and compare your books data with the data auto-populated on the GST Portal.

Before you begain | Prerequisites

Ensure that:

  1. You have resolved all exceptions in your GST returns before referencing Annual Computation data.
  2. You have filed GSTR-1 and GSTR-3B for all months in the relevant financial year.
  3. You have downloaded the GSTR-9 Offline Tool from the GST Portal and kept it in the folder from which you want to export GSTR-9 data.
  4. You have configured GTSR-9 Offline Tool Excel file for uninterrupted GSTR-9 data export.
    1. Open Excel file and go to File > Options > Trust Center > Trust Center Settings > Privacy Options.
    2. Under Document-specified settings, clear the option Remove personal information from file properties on save.
  5. You are logged in to the GST portal.

Step 1: Review Your TallyPrime Data

  1. Press Alt+G (Go To) > type or select GST Annual Computation > press Enter.
  2. Press F2 (Period) and set it to the relevant financial year.
  3. Review annual data across the sections.

Step 2: Export GSTR-9 Data

  1. Press F2 (Period) to select the period for which you want to export GSTR-9 data.
  2. If you have created multiple registrations, press F3 (Company/Tax Registration) > select the company to include all GST registrations, or select a specific GST registration.
  3. Press Alt+E (Export) > Data for GSTR-9.
    Export GSTR-9 Data from TallyPrime
  4. On the Export Data for GSTR-9 screen, press C (Configure) and set the option as required.
    1. Sections to be exported, select All Sections or HSN/SAC Summary, as required.
    2. Specify the Template File Path where the downloaded GSTR-9 Offline Tool is available.
    3. The Template File Name is prefilled as GSTR-9 Offline Tool (v2.1).
    4. Specify the Folder Path where you want to generate the exported file.
    5. Press Ctrl+A to save the configurations.
  5. Press E (Export) and then press C (Continue) to confirm the export.
    Export GTSR-9 Data Confirmation Message

The GSTR-9 Utility file is exported in the specified folder with the selected GSTR-9 data. Use this file to compare your books data with the data auto-populated on the GST Portal.

Step 3: Reconcile Books Data with Portal Data

  1. Download the auto-populated GSTR-9 JSON from the GST Portal.
    1. On the GST Portal, go to Services > Returns > Returns Dashboard.
    2. Select the required financial year and return period, and download the auto-populated GSTR-9 JSON.
  2. Open a separate copy of the GSTR-9 Offline Tool and import the JSON downloaded from the GST Portal.
    1. Open the GSTR-9 Offline Tool, go to Home > Open Downloaded Form GSTR-9 JSON File.
    2. Select the JSON downloaded from the GST Portal.
  3. Compare the data in the GSTR-9 Utility file exported from TallyPrime with the data in the GSTR-9 Offline Tool containing the portal data.
  4. If there are any differences, make the required corrections in the GSTR-9 Offline Tool containing the portal data based on your books data.
  5. In the GSTR-9 Offline Tool containing the portal data, go to Home > Generate JSON File to upload.

Do not import the portal JSON into the GSTR-9 Utility file exported from TallyPrime, as it will replace the existing books data.

If you have exported only the HSN/SAC Summary from TallyPrime:

  1. Open a separate copy of the GSTR-9 Offline Tool and import the auto-populated GSTR-9 JSON downloaded from the GST Portal.
  2. Compare the HSN Outward and HSN Inward details in the GSTR-9 Utility file exported from TallyPrime with the corresponding details in the GSTR-9 Offline Tool containing the portal data.
  3. Update the HSN Outward and HSN Inward details in the GSTR-9 Offline Tool containing the portal data based on your books data.
  4. In the GSTR-9 Offline Tool containing the portal data, go to Home > Generate JSON File to upload.

Step 4: File GSTR-9 on the GST Portal

  1. Log in to the GST portal.
  2. Go to Services > Returns > Annual Return, select the financial year, and click Prepare Online on the GSTR-9 section.
  3. Upload the JSON file to the GST Portal, and proceed with filing.

To learn more about the different sections of GTSR-9 return form, refer to Form GSTR-9 – Annual Returns.

Is this information useful?
YesNo
TallyHelpwhatsAppbanner
Is this information useful?
YesNo
TARA