GSTR-2A and GSTR-2B Reconciliation

YouTube: How to Perform GSTR-2A and GSTR-2B Reconciliation in LOGIC ERP?

How to Perform GSTR-2A and GSTR-2B Reconciliation in LOGIC ERP?

This tutorial explains how to reconcile GSTR 2A and GSTR 2B using Logic ERP, ensuring accurate Input Tax Credit (ITC) validation and compliance.


Access GST Return Reports

  • Navigate to Reports & Queries.

  • Go to Sales Registers and Click "GST Returns Reports".

  • A list of GST return types will appear.


Reconciliation of GSTR 2A

  • Select GSTR 2A.

  • Choose the date range.

  • Click on Generate.

You’ll now see a summary of purchases and inward supplies reported by suppliers (item-wise). This helps validate ITC claims.


Enable Reconciliation Mode

  • Tick the Reconciliation checkbox.

  • Select the reconciliation format:

    • JSON / ZIP file (download from GST portal)

    • Excel file (downloaded from GST portal)

    • Online API (requires GST API activation)


Upload Excel File & Reconcile

  • Browse and upload the Excel file.

  • Click on Reconcile.

A success message will confirm the reconciliation.


Review Reconciliation Results

  • Navigate to the B2B Tab for invoice-wise reconciliation.

  • Color-coded flags indicate status:

  • Under the CDN Tab, view matched/mismatched Credit/Debit Notes.


Create Reconciled Documents

  • Click Generate Reconcile Document.

  • Enter the Document Number, then Save.

  • Repeat for Debit Notes if applicable.


Reconciliation of GSTR 2B

  • Select GSTR 2B from the report list.

  • Click Generate to view monthly invoice-wise data, including:

    • Registered/Unregistered Suppliers

    • Credit/Debit Notes


Reconcile GSTR 2B

  • Enable Reconciliation.

  • Choose Excel File and browse for the file.

  • Click Reconcile.

A success message confirms reconciliation is complete.


Generate Reconciled Documents

  • Under Purchase Register, select Generate Reconcile Document.

  • Enter the Document Number and Save.

  • Repeat under CDN Tab for Credit/Debit Notes.


Optional Features

  • Party Filter: Select specific suppliers before generating the report.

  • Previous Month Documents: Add reconciled entries from earlier periods.

  • Customized Configurations:

    • Go to GST Returns Module.

    • Open GSTR 2A/2B Reconciliation Report.

    • Use filters to customize and generate new configurations.


View Reconciliation Report

  • Navigate to the GSTR 2A or 2B Reconciliation Report.

  • Select the document using filters.

  • Click to Create Report.

It shows all documents marked as:

  • Matched

  • Mismatched

  • Missing

  • Extra


Conclusion

Reconciliation in Logic ERP helps maintain GST compliance by:

  • Validating ITC claims.

  • Identifying discrepancies between internal records and GST portal data.

  • Keeping a clean audit trail.

Last updated