GSTR-2A Reconciliation Comprehensive way

  • LedgerVision’s GSTR2A Reconciliation Process

    Steps to Reconcile GSTR2A Data Using LedgerVision:

    1. Download JSON Files from GST Portal:
      • Visit the GST portal and download all required months’ GSTR2A JSON files.
    2. Pull Tally Data:
      • Import Tally data into LedgerVision, ensuring all GST input ledger mappings are configured correctly.
    3. Set Probable Match Criteria:
      • Enable the “Probable Match” feature for identifying invoice number discrepancies.
    4. Upload JSON Files:
      • Upload the GSTR2A JSON files into LedgerVision for processing.

    Reconciliation Process:

    1. Voucher Types:
      • LedgerVision considers all Tally voucher entries where GST input ledgers are used.
    2. Matching Criteria:
      • GST Number Match: Matches GST numbers between JSON and Tally data, identifying corresponding parties.
      • Invoice Number Match: Matches invoice numbers for the identified parties.
      • Fallback Matching: If GST numbers are unavailable in Tally, matches are based on:
        • Invoice number
        • Invoice date
        • Taxable amount
        • GST amount

    Reports Generated:

    1. Summary Report:
      • Provides an overview of the reconciliation status.
    2. JSON Reconciliation Report:
      • Details matches and mismatches between JSON and Tally data.
    3. In Tally Not in JSON Report:
      • Lists invoices present in Tally but missing in JSON.

    Reconciliation Categories:

    1. GSTN and Invoice Not Found:
      • Both GSTN and invoice details are missing.
    2. Invoice Not Found:
      • GSTN is found, but invoice details are missing.
    3. Mismatch Found:
      • Differences in GST amounts between Tally and JSON.
    4. Match Found:
      • Full match of GSTN, invoice details, and amounts.
    5. Probable Match Found:
      • Unique Feature: If an incomplete invoice number is entered in Tally, LedgerVision applies user-defined probable match criteria:
        • Compares invoice numbers partially.
        • Matches date and invoice amount for confirmation.
        • e.g. Invoice Number in GSTR-2A JSON is TRI/18-19/2186 but in tally Invoice Number is only 2186. LedgerVision will match last 4 digits and if invoice amount and GST amount matches, then it is termed as Probable Match. This reduces mismatch count to great extend.

    Additional Features:

    • Exportable Reports:
      • All reports can be downloaded in Excel format.
    • Update Tally Ledger Masters:
      • Users can directly update Tally ledger masters through LedgerVision.

    Conclusion:

    LedgerVision simplifies GSTR2A reconciliation with unmatched accuracy and user-friendly features like probable match criteria and Tally ledger master updates.

     

    Visit our Youtube Channel for GSTR2A Reconciliation Feature Video

    https://youtube.com/playlist?list=PLG6cWUXlTcXXCw-OXAjb_uxrnb_Ocpj3j