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

    • 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 || PAN-Level (with E-Invoice) for GSTR-1 (Sales Data) and E-Invoice Data Import

      PAN-Level (with E-Invoice) for GSTR-1(Sales Data) and E-Invoice Data Import Introducing a Unified Template With the new PAN-Level with E-Invoice template, users can now seamlessly manage GSTR-1 (Sales Data) and E-Invoice Data Import using a single ...

    • ExpressGST || Import GSTR1 Books Data

      This document outlines the standard procedure to import GSTR-1 Books data into the ExpressGST application. The process supports both JSON and Excel-based imports, enabling efficient data integration for return preparation and filing. Step 1: Login ...