Import GSTR2 Books Data (PAN Level)

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.
  • Select the client for whom you want to import the GSTR-2 PAN Level data.
      

Step 2: Access Return Summary

  • After selecting the client, the Return Summary page will open.
  • This page will show various GSTR filings, including GSTR-1, GSTR-3B, GSTR-9, and GSTR-9C.

Step 3: Initiate the Import

  • Click on "Import Books Data".
      
  • This will open the Import Book Data window, where you can upload the GSTR-2 PAN Level Excel file.
      
      
  • If you don’t have the template, click on "BLANK Template" or "Template with PAN Level" to download the required file.
      

Step 4: Prepare the Excel Template

  • Fill in the necessary data in the downloaded GSTR-2 Blank Template or GSTR-2 PAN Level template.
      
      
  • Once completed, click the "Browse" button to select the filled file, and then click "Open".

Step 5: Start the Import

  • After selecting the file, click "Import" to start the import process.
      

Step 6: Review Import Status

  • An Import Status window will pop up, allowing you to review the data that was imported from the Excel file.
  • Ensure that all data has been accurately reflected.

Step 7: Confirm the Import

  • Click "Okay" to confirm and finalize the import.
      

Step 8: Verify the Data

  • Navigate to the Books vs 2A/2B Annual section.
      
  • Select the month and year for which the GSTR-2 data was imported, then click "View".
  • The imported GSTR-2 PAN Level book data will now be visible for review and reconciliation.
      
  1. Click on the 'Invoice Wise Reco' option to reconcile books versus portal invoices, focusing on an invoice-wise comparison.
      

By following these steps, you’ll successfully import your GSTR-2 PAN Level purchase data into the ExpressGST portal. This ensures that all relevant purchase details are captured accurately for GST filing and reconciliation, streamlining the filing 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

      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 || 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 || Books Vs R1 Comparison (DIY)

      Books vs GSTR-1 Comparison Tool Looking for efficient GSTR-1 comparison software? The ExpressGST Comparison Tool offers seamless matching of sales invoices with GSTR-1 data from the GST portal. With support for uploads from Excel and Tally, the ...

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