GSTR-1A Books Data Import Process

ExpressGST || Import of GSTR-1A Books Data

This document provides a detailed procedure for importing GSTR-1A Books Data into the ExpressGST application. Adhering to this process ensures accurate data upload and facilitates seamless return preparation and filing.

Step 1: Login and Client Selection
Log in to the ExpressGST application and select the relevant client for whom the GSTR-1A Books Data is to be imported.
Upon selection, the system will automatically redirect to the Return Summary page.

Step 2: Access Import Module
On the Return Summary page, all applicable GSTR return types will be displayed.
Navigate to the left-hand panel and click on Import Books Data to initiate the import wizard.

      

IdeaNote: The GSTR-1A return import feature is enabled only after the successful filing of GSTR-1 and remains available until the due date of GSTR-3B.


Step 3: Selection of Return Period and Data File
Navigate to: Sales → GSTR-1A
  1. Select the applicable Return Period (Month and Year) for which the data is to be imported (e.g., March 2026).
  2. Download the required Excel template, as applicable:
    1. GSTN Blank Template – Available under the GSTN Template option
    2. Consolidated Excel Template (KDK Template) – Available under the CA Plan for simplified and structured return preparation
Note: The KDK Template is a consolidated worksheet within the GSTR-1A Excel format that captures section-wise summary details of outward supplies, including:
  1. Taxable Value
  2. CGST
  3. SGST
  4. IGST
  5. Cess
The data is systematically derived from detailed transaction categories such as B2B, B2C, Exports, and Credit/Debit Notes, and consolidated into a single sheet to facilitate efficient data import.
  1. Click on the Browse button corresponding to the selected return period.
  2. Select the prepared Excel file from your system and click Open to upload the file.
Step 4: Initiate Import Process
Upon successful file selection, click on the Import button to initiate the data import process.

Step 5: Review Import Status
The system will display an import status message indicating whether the data has been successfully imported or if any discrepancies/errors are identified.

Step 6: Confirmation and Completion
Once the import process is successfully completed:
  1. Click OK to confirm the action.
  2. The imported GSTR-1A Books Data will be available for review, validation, and further processing within the application.
Important Notes
  1. Ensure that the Excel file strictly adheres to the prescribed template format.
  2. Verify that the correct return period is selected prior to import.
  3. In case of import errors, review the file structure and data format before re-attempting the upload.
Following the above standardized procedure ensures accurate and efficient import of GSTR-1A Books Data into ExpressGST, thereby enabling smooth return preparation and compliance with GST regulations.