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 basis.
      
  1. 📌 To view the summary, click on Books vs 2B - Reco Status.
      
  1. Books vs 2B - Reco Status Report provides a summary of :
    1. ✅ Matched Entries
    2. 🔄 Partially Matched Entries
    3. ❌ Unmatched Entries (In Books Only / In 2B Only)
    4. 📊 Total Reco Overview
      

Step 4: Click on the "Invoice Wise Reco" Option
  1. For detailed reconciliation, select Invoice Wise Reco.
      
  1. This ensures reconciliation at the invoice level, comparing each invoice between your books and GSTR-2A/2B data.
  2. 📌 To view the summary, click on Books vs 2B - Reco Status Report.
      
  1. 📊 You can also access the Books vs 2B - Reco Status Report from Invoice Wise Reco.
      

Step 5: Apply Filters to Review Discrepancies

After selecting Invoice Wise Reco, the software categorizes invoices based on their reconciliation status. Use the filters below to analyze and resolve discrepancies:

      
      

✅ Matched Entries:
  1. ✔ Perfect Matched – Invoices that exactly match between your books and GSTR-2A/2B.
  2. ✔ Manually Matched (Single/Multi Linked) – Invoices reconciled manually; review their status.
  3. ✔ Doc. Date Different – Invoices with mismatched document dates.
  4. ✔ Books and 2B Period Differ – Invoices where the reporting periods differ.
  5. ✔ RCM Differ – Identify invoices with Reverse Charge Mechanism (RCM) status differences.
  6. ✔ POS Differ – Highlight mismatches in the Place of Supply (POS).
🔄 Partially Matched Entries:
  1. ✔ Only Doc. No. Mismatch – Invoices with mismatched document numbers.
  2. ✔ Taxable Value Mismatch – Entries where taxable values differ.
  3. ✔ Tax Mismatch – Invoices with discrepancies in tax amounts.
  4. ✔ RCM Differ – Entries with RCM status differences while other details match.
  5. ✔ POS Differ – Entries with mismatched Place of Supply (POS) but otherwise consistent data.
  6. ✔ Other Partially Matched – Captures other partial matches not covered above.
❌ Unmatched Entries:
  1. 🚨 In Books Only : Invoices present in your books but missing in GSTR-2A/2B.
  2. 🚨 In 2B Only : Invoices present in GSTR-2B but missing in your books.
📌 RCM Filter:
  1. Yes: View invoices where RCM status is marked as "Yes."
  2. No: View invoices where RCM status is marked as "No."

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 || Annual Return (GSTR-9) Filing Process

      How to Prepare Annual Return (GSTR-9) in ExpressGST Software Preparing the GSTR-9 return in ExpressGST software requires following a series of structured steps to ensure accurate reporting of your annual GST data. Here’s a concise guide to help you ...

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