Import GSTR-1 Books Data via EXCEL

ExpressGST || Import GSTR1 Books Data via EXCEL (Blank Template or Template with PAN Level)


What is GSTR-1 PAN Level ?

GSTR-1 PAN Level refers to a consolidated report that provides detailed information about outward supplies (sales) made by a taxpayer, organized at the PAN (Permanent Account Number) level. This report consolidates data from multiple GSTINs (Goods and Services Tax Identification Numbers) that are registered under the same PAN, streamlining GST filing for businesses with multiple registrations.


Process for Import GSTR-1 Books Data via EXCEL (Blank Template or Template with PAN Level)

To import GSTR-1 books data via an Excel sheet into Express GST, follow these steps:

Step 1 : Choose the client for whom you want to import GSTR-1 book data by clicking on the client’s name. This will take you to the Return Summary page.
Step 2 : On the Return Summary page, you will see a list of all types of GSTR filings. Locate the Import Books Data button on the left-hand side.

      

Step 3 : Select or Download Template:
  1. Click on the Import Books Data button to open a wizard.
      
  1. You can either select your GSTR-1 book data Excel file or Download a Blank template or Template with PAN-level if needed.
      
      

Notes
NOTE: We Support Govt. and All Accounting Software Templates.

Step 4 : Upload GSTR-1 Book Data File
  1. Under Sales GSTR-1, choose the relevant month and year (e.g., October 2024) for which you want to import data.
  2. Click the Browse button next to the selected month, and locate the GSTR-1 book data Excel file on your computer.
      
  1. Click Open to upload the file to the Express GST portal.
      

Step 5 : Once the file is uploaded, click the Import button to start the data import process.

      

Step 6 : A window will appear displaying the import status of the GSTR-1 book data.

      

Step 7 : Once the import is completed, click OK to finalize the process. The successfully imported GSTR-1 book data will now be visible in the Express GST portal.

By following these steps, you can efficiently import GSTR-1 book data into Express GST and ensure accurate filing of your GSTR-1 returns.
    • Related Articles

    • ExpressGST || Import GSTR2 Books Data via EXCEL (Blank Template or Template with PAN Level)

      To import GSTR-2 books data via an Excel sheet into Express GST, follow these steps: Step 1: Log in to ExpressGST Use your username and password to log in to the ExpressGST portal. Navigate to the Client Master page, where you can view all clients. ...
    • ExpressGST || Import GSTR2 Books Data via EXCEL

      Process for Importing GSTR-2 Book Data via Excel into Express GST Note: We Support Govt. and all Accounting Software Templates. Step 1: Select the Client Log in to Express GST and navigate to the Client List. Select the client for whom you wish to ...
    • ExpressGST || Process for Importing GSTR-9 Book Data via Tally

      Process for Importing GSTR-9 Book Data via Tally into Express GST The following steps provide a professional guide for importing GSTR-9 book data from Tally into Express GST: Step 1: Select the Client Log in to https://www.expressgst.com/ and ...
    • ExpressGST || Import GSTR1 Books Data

      Stepwise Process to Import GSTR-1 Books Data in Express GST Step 1: Log in to the Express GST portal. Choose the client for whom you want to import GSTR-1 book data by clicking on the client’s name. You will be redirected to the Return Summary page. ...
    • ExpressGST || Process to Reset and Re-upload Books Data

      Steps to Remove Data and Reimport Books Data If you need to remove GSTR-1 data (both Portal data and Software data) and reimport books data in ExpressGST, follow the steps below: Remove Portal Data via the GST Portal To remove data from the GST ...