Home Services About Contact

GST Reconciliation Login

How to Use the GST Reconciliation Tool

The GST Reconciliation Tool is designed to help you easily compare and match your GST data from GSTR-2B and GSTR-3B. This guide will walk you through the process step by step.

Watch Tutorial Video

Check out our step-by-step tutorial video on YouTube to learn how to use the GST Reconciliation Tool effectively:

Click Here

Step-by-Step Guide

  1. Log in: Use your username and password to access the tool.
  2. Download Sample File: Click on "Download Sample Excel File" to get a template for your data.
  3. Prepare Your Data: Enter your GSTR-2B data in GST Portal sheet and GSTR-3B or books in client data sheet according to the sample file.
  4. Upload File: Upload your prepared Excel file using the "Upload GST Data File" option.
  5. Set Difference Allowed: Adjust the tolerance for differences in amounts (default is 1).
  6. Enable Detailed Reconciliation: Check this box for detailed reconciliation or leave unchecked for a simple reconciliation.
  7. Enable Filters (Optional): Use filters to sort or search through your data.
  8. Reconcile Data: Click "Reconcile" to process and match your data.
  9. Review Results: Check the GSTR-2B, GSTR-3B, and Summary tables for matched data.
  10. Edit Data (If Needed): Make direct edits in the tables and reconcile again.
  11. Download Output: Click "Download Reconciled Data" to save the results.

Feature Descriptions

  • Login System: Secure access with username and password. Subscription status is verified upon login.
  • Sample File Download: Provides a template to ensure your data is correctly formatted.
  • File Upload: Upload your GST data in Excel (.xlsx) format.
  • Difference Allowed: Set the acceptable difference in taxable value, IGST, CGST, and SGST for matching (default: 1).
  • Detailed Reconciliation: When enabled, shows detailed match criteria; when disabled, shows a simplified "Match" or "Unmatch".
  • Enable Filters: Adds dropdown filters to table columns for easy data sorting and searching.
  • Reconcile Button: Processes the data and updates the tables with match results.
  • Reset Data Button: Clears all uploaded data and resets the tool.
  • Editable Tables: Directly edit data in the tables; changes are reflected upon reconciling again.
  • Download Reconciled Data: Generates an Excel file with matched data, including color-coded rows for clarity.

Understanding Match Criteria

When Detailed Reconciliation is enabled, the tool uses the following criteria:

  • Match - GSTN, Invoice No., Date: Exact match on GSTN, invoice number, and date.
  • Match - GSTN, Invoice No.: Match on GSTN and invoice number, with possible date differences.
  • Match - GSTN, Date: Match on GSTN and date, with possible invoice number differences.
  • Match - GSTN: Match only on GSTN, with differences in invoice number and date.
  • Unmatch - GSTN Not Exist: GSTN from one sheet is not found in the other.
  • Unmatch - Amt Diff: GSTN and Invoice Number match, but amounts (Taxable Value, IGST, CGST, SGST) differ by more than the allowed difference.
  • Unmatch: Data does not meet any match criteria, generally due to extra invoices in either GSTR-2B or GSTR-3B/Books

When Detailed Reconciliation is disabled, the criteria are simplified:

  • Match: Data matches based on any of the detailed criteria above.
  • Unmatch - GSTN Not Exist: GSTN from one sheet is not found in the other.
  • Unmatch - Amt Diff: GSTN and Invoice Number match, but amounts (Taxable Value, IGST, CGST, SGST) differ by more than the allowed difference.
  • Unmatch: Data does not meet any match criteria, generally due to extra invoices in either GSTR-2B or GSTR-3B/Books