Skip to main content

GSTR 2B: Advanced Reconciliation Rules

Advanced reconciliation rules help you clear invoices that basic reconciliation could not match, without checking them one by one. You choose the rules before you submit a reconciliation request, as described in the article “GSTR 2B: Perform Reconciliation”. There are two groups of rules: rules for missing invoices, and rules for mismatched invoices.

Analyse Missing Invoices

These rules look for comparable invoices among those left in Purchaser Only and Supplier Only after basic reconciliation. You can run them alone or together.

RuleUse it when
1. Across Financial YearThe same invoice is reported in different financial years on the two sides. The invoice date decides the year.
2. Fuzzy Logic on Invoice NumbersThe invoice numbers share a key part but differ in format, such as INV1005 and MH/INV1005/2024. Both invoices must fall in the same month and year.
2.1 Acceptable % for Invoice Number MatchingThe invoice numbers are similar but not identical. The system compares them using AI learning, where 100% means identical numbers. The default is 85%, and you can enter 85 to 100. A tolerance on total tax amount applies when several invoices match one invoice.
2.2 Invoice Series MatchingThe invoice numbers differ in how the series is written, such as A1001/24-25 and A1001/2024-2025. You enter a tolerance on the total tax amount.
3. Ignore Invoice No., exact amountsThe invoice numbers cannot be matched, but the invoice value, taxable value and tax amounts are identical in the same month and year. Sub-option 3.1 also ignores the invoice value, and 3.2 ignores the taxable value too.
4. Ignore Invoice No., within toleranceThe same as Rule 3, but the amounts only need to be within a tolerance that you set, up and down. The Tolerance is mandatory, and the Taxable Value Tolerance is optional. Sub-options 4.1 and 4.2 ignore the invoice value, and then the taxable value.
5. Reconcile Amended Supplier Only Invoices with Original Purchaser Invoices (shown only when you select the B2BA or CDNA section)The supplier amended an invoice (B2BA, CDNA) that you booked as the original. The supplier’s original moves to Original SO Amended.
Ignore Document Financial Year (numbered 6 on screen, or 7 when Rule 5 is shown)Use it together with Rule 1 to match invoices with the same number and value across financial years.
Ignore Month (numbered 5 on screen, or 6 when Rule 5 is shown)The same invoice carries different document months on the two sides. Run it together with other rules.

Some rules tick the rules they depend on: 3.1 ticks 3; 3.2 ticks 3 and 3.1; Rule 4 ticks 3; 4.1 ticks 4, 3 and 3.1; and 4.2 ticks 4, 4.1 and all of Rule 3. If you untick one of these sub-rules, the screen clears both Rule 3 and Rule 4, so tick them again. Rule 5 applies only to the B2BA and CDNA sections. When a purchaser invoice has several possible matches, it gets the Match Type Probable Match, and you pick the right invoice from a drop-down list in Purchaser Only or Supplier Only.

Perform Reconciliation based on 2B: Analyse Missing Invoices rules, including Fuzzy Logic, Acceptable % and Invoice Series Matching
Perform Reconciliation: Analyse Missing Invoices, with the rule options.

Analyse Mismatched Invoices

These rules move near-matches from Value Mismatch and Invoice Mismatch into Deemed Match. They are useful when small differences are not worth chasing, but the moved invoices are treated as matches from then on, so check the mismatches first.

  1. Move from Value Mismatch within tolerance. Set Define Tolerance (Purchaser – Supplier) with a MIN (a negative number or 0) and a MAX (a positive number or 0). MIN and MAX cannot both be 0. Then apply it to Invoice Value, Taxable Value or Tax Value. A positive tolerance means that your value is higher than the supplier’s.
  2. Move from Invoice Mismatch within tolerance for Invoice Value. The same MIN and MAX fields apply.

For each rule you can choose to ignore mismatches in POS, Reverse Charge, Invoice Type or Tax Head, and choose the action to apply, such as Accept Supplier or Accept Purchaser.