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 import the GSTR-2 book data.
• This will take you to the Return Summary page for the selected client.

Step 2: Access the Import Books Data Feature

• On the Return Summary page, locate the Import Books Data button on the left-hand side of the screen.
• Click the Import Books Data button to open the import wizard.
  

      

1. In the wizard, select GSTR-2 and then click on the Excel option.

      

Step 3: Download the Template (Optional)

• If you don’t have the template for the GSTR-2 book data, click the Blank Template option to download the required Excel file.
  

      

• Fill out the template with the necessary purchase details.
  

      

Step 4: Import the Prepared Excel File

• Once your Excel sheet is prepared, return to the wizard and use the Browse button to select and upload the GSTR-2 book data Excel file.
  

      

Step 5: Verify the Imported Data

• After the file is imported, navigate to the Books vs 2A/2B Annual section.
  

      

• In this section, verify and reconcile the imported book data against the portal's purchase data, focusing on an invoice-wise comparison to ensure accuracy.
  

      

By following these steps, you can successfully import and reconcile your GSTR-2 Books data with the portal's purchase data in the Express GST system. This ensures that all relevant purchase information is captured accurately, streamlining your GST filing and reconciliation process.

• Related Articles

• 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 ...

• 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 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 || Import GSTR2 Data from Tally to Express GST

  ExpressGST | Importing GSTR-2 Data from Tally The following steps and prerequisites are essential for accurately importing GSTR-2 data from Tally into ExpressGST. Meeting these criteria ensures precise mapping and successful data import. ...

• ExpressGST || Comparison of GSTR1, GSTR-3B and Books Data

  View Comparison of GSTR1, GSTR-3B and Books To review the comparison between GSTR-1, GSTR-3B and Books in ExpressGST, follow these steps: Step 1: Access GSTR-9 Status Navigate to the Return Summary section. Click on the GSTR-9 Status option to ...