OCTA GST

Reports

GSTR-1

The GSTR-1 Report in Octa GST allows users to export data of GSTR-1 returns that have been filed on the government GST portal. This export can be done at both the GSTIN level (for a specific registration) and the PAN level (for all GSTINs under the same PAN), making it easy to review and analyse the filed returns efficiently.

Step by Step Export the DATA of GSTR 1

Step-1 GSTR-1 Filing Dashboard

First, navigate to the Filing Dashboard in Octa GST. To do this

  1. Log in and Select Company: Log in to Octa GST, select the company you want to work with, and open it.
  2. Navigate to GSTR-1 Tab: Go to the GSTR-1 tab. This will open the GSTR-1 filing dashboard for all periods.
  3. Check Return Status: Hover your mouse over any period to see whether the return has been filed or if data is available or not.
  • Filing Dashboard GSTR 1 Dashboard If the return has been filed and you want to upload the data into Octa GST for exporting the data into Excel, the next step is to download the JSON file, which will be used to import the data into Octa.

Step-2 Download JSON files

To download the JSON file follow the process

  1. Click the JSON Button: In the GSTR-1 dashboard, click the JSON button.
  2. Log In to the GST Portal: A login tab will open. Click the Login button and enter your GST Government Portal credentials (User ID and Password).
  3. Generate JSON: Once logged in, the screen for JSON generation will appear.
  4. Full-Year Download Option: Octa GST allows you to download the JSON file for the entire financial year. In this tab, Octa GST sends the generation request to the government portal.
  5. Refresh and Download: After a short time, once the JSON is generated, refresh the page. The Download option will appear. Click Download to save the JSON file.

Download GSTR1 JSON

Step-3 Adding JSON files

  1. Go to the GSTR-1 Dashboard: In Octa GST, open the company and navigate to the GSTR-1 tab to access the dashboard.

  2. Click the Import Button: On the dashboard, click the Import button.

  3. Select JSON Files: Click Select, then browse your computer and choose the JSON file(s) you want to import.

You can select multiple files at once.

add gstr1 JSON

  1. Open the Files: After selecting, click Open to confirm your selection.

  2. Continue to Import: Click the Continue button to start importing the data into Octa GST. To add data into Octa GST, go to the GSTR-1 dashboard and click the Import button. Then click Select and choose the JSON file(s) from your folder — multiple files can be selected at once. After selecting the file(s), click Open, and then click the Continue button to proceed with the import.

Pull data (using OTP)

Octa GST also provides a data pull option to fetch data directly from the government portal without using JSON. To use this feature, Octa GST must first be connected to the GST portal. To pull data, click the Pull button, select the desired period, and then click Continue. The system will retrieve data from the government portal for that period.

Step-4 Export GSTR-1

After uploading JSON into Octa GST or Pull Data, we can export it in Excel format. To do this, simply click the Export button, select the desired period, and click Continue. The file will be generated in the Robot tab, from where we can download the Excel file containing the data.

When we click on the Export button, the export window opens, showing the download formats. Octa GST provides GSTR-1 Data in three type of format:

  1. Octa Full Format – In the Octa Full Format, each invoice can contain multiple line items, and all these line items are displayed separately in the export. This ensures a detailed view of every transaction, making it ideal for thorough analysis and record-keeping.

  2. Octa Smart Format – Consolidates invoice-level entries into a single Excel file.

  3. Government Portal Format – Reflects the government portal structure, with multiple sheets for every section of the return. export gstr1 Download Report from Robot Robot

Export specific GSTIN and PAN Data

In Octa GST, if you want to export data for a specific customer, you can do so using the GSTIN or PAN of the client. When we click the Export button, the export window opens, and there is an option to enter the customer’s GSTIN or PAN. By providing this information, you can generate and export data specifically for that customer. export specific GSTIN data