GSTR-2B Reconciliation Troubles? Unlock Precision and Accuracy with LedgerVision !!! (101)

GSTR-2B Reconciliation is reconciliation of GSTR-2B data from GSTR Portal and Purchases or Expenses data in Tally. LedgerVision’s GSTR-2B Reconciliation Module reconciles GSTR-2B JSON files with Tally Data. Let’s look at how this reconciliation works in LedgerVision.

 

How LedgerVision Algorithm Works?

GSTN Numbers Required in Tally Ledger Master

LedgerVision checks Sundry Creditors and Sundry Debtors having Purchases / expenses entries are found against them.  For GSTR-2B Reconciliation to work, Sundry Creditors and Sundry Debtors should have GSTN numbers specified in Tally Ledger Master.

 

Invoice Matching Criteria 

LedgerVision checks Invoices against Tally Voucher Number, Supplier Reference Number or Bill Reference. Invoices that are present in Tally but not available in GSTR-2B JSON File and vice versa are also highlighted.

 

Partial / Probable Match

Many a times, complete invoice number is not entered in Tally while passing accounting entry. LedgerVision gives Probable Match report which can check number or text pattern in invoice numbers.

Patterns Searches available in LedgerVision are:

  • Exact Match
  • Contains Invoice Number
  • Ignore Special Characters
  • Ignore Spaces in Between
  • Match from Left Side
  • Match from Right Side

For e.g. Invoice Number in GSTR-2B 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.

 

Matches from Previous Month

If seller has not shown invoice in respective months return, then after late filing it will be reflected in subsequent months GSTR-2B. In this case match found or probable match found is shown as pertaining to previous month.

 

GSTR-2B Reconciliation Reports Generated

LedgerVision generates following reports which are can also be downloaded excel format:

1. GSTR-2B summary

This report shows reconciliation summary between GSTR-2B JSON and Tally data. GST Amount differences are summarized in following fields:

  • GST/PAN Not Found
  • Invoice Not Found
  • Mismatch In JSON
  • Mismatch In Tally
  • In Tally not in JSON
  • Match vs Probable Matches

 

2. Summary of JSON Reconciliation with Tally data

In this report, detailed Voucher / Invoice wise reconciliation is shown with following findings:

  • GST/PAN not Found
  • Invoice Not Found
  • Match Found
  • Match Found of Previous Month
  • Mismatch Found
  • Probable Match
  • Probable Match of Previous Month

 

3. Credit Availed in Tally not reflected in JSON

This report shows all Vouchers / Invoices claiming Input Credit in Tally which are not reflecting in GSTR-2B    report. User will have to follow up those parties for updating their returns