Reconciliation Process

ExpressGST || Reconciliation Process: Books vs 2A/2B (DIY)


Reconciliation Process: Books vs 2A/2B

Step 1: Import GSTR-2 Data
  1. Start by importing the GSTR-2 data into the software.
  2. You can either upload an Excel file or directly import data from Tally, if applicable.
Step 2: Navigate to the "Books vs 2A/2B Annual" Section
  1. Once the data is imported, go to the Books vs 2A/2B Annual section in the software.
      
  1. This is where the reconciliation process takes place.
Step 3: Click on the "Supplier Wise Reco" Option
  1. Under the Books vs 2A/2B Annual section, select Supplier Wise Reco.
      
  1. This option allows you to reconcile data on a supplier-by-supplier basis.
Step 4: Click on the "Invoice Wise Reco" Option
  1. For detailed reconciliation, select Invoice Wise Reco.
      
  1. This option provides reconciliation at the invoice level, ensuring each invoice is compared between your books and the GSTR-2A/2B data.
Step 5: View Matched, Partially Matched, and Unmatched Entries
  1. After selecting Invoice Wise Reco, the software will display a list of invoices. These are categorized based on reconciliation status:
    1. Matched: Invoices that match completely between your books and GSTR-2A/2B data.
    2. Partially Matched in Books Only: Invoices with some data (e.g., taxable value, GSTIN) matching, but discrepancies in your books.
    3. Partially Matched in 2A/2B Only: Invoices with some data matching in GSTR-2A/2B but discrepancies in your books.
    4. In Books Only: Invoices recorded in your books but not found in GSTR-2A/2B.
    5. In Portal Only: Invoices available on the portal (GSTR-2A/2B) but missing in your books.
      

Step 6: Set or Modify Tolerance for Taxable Value
  1. Adjust the tolerance for taxable value if required.
      
  1. This setting allows you to define a threshold for acceptable discrepancies, such as minor differences in amounts.
  2. Modify the tolerance as per your business rules or GST guidelines.
By following these steps, you can ensure accurate reconciliation of GSTR-2 data with your books. This process helps you identify discrepancies and take corrective actions where necessary.
    • Related Articles

    • ExpressGST || Reconciliation Process: Books vs 2A/2B

      Reconciliation Process: Books vs 2A/2B Step 1: Import GSTR-2 Data Start by importing the GSTR-2 data into the software. You can do this by either uploading an Excel file or directly importing data from Tally (if your data is stored there). Step 2: ...
    • 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 || Delete GSTR2 Books Data in ExpressGST (DIY)

      How to Delete GSTR-2 Books Data in ExpressGST To delete GSTR-2 books data in ExpressGST, follow these steps to ensure accurate and complete removal: Step 1: Access the Reconciliation Section Begin by navigating to the Reconciliation section on the ...
    • 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 || Delete GSTR2 Books Data in ExpressGST

      How to Delete GSTR-2 Books Data in ExpressGST To delete GSTR-2 books data in ExpressGST, follow these steps to ensure accurate and complete removal: Step 1: Access the Reconciliation Section Begin by navigating to the Reconciliation section on the ...