GSTR-2B Reconciliation: Complete Guide to Match GSTR-2B with Purchase Register

GSTR 2B reconciliation means comparing the purchase invoices recorded in your books with the invoices available in your GSTR-2B on the GST Portal.

In simple words, your Purchase Register tells you what you purchased, while GSTR-2B tells you which supplier-reported documents have reached your GST records for the relevant period.

If an invoice is in your books but missing from GSTR-2B, has the wrong GSTIN, wrong invoice number or different taxable value or GST amount, it needs to be checked before taking Input Tax Credit (ITC).

This guide explains GSTR-2B reconciliation with books in very simple language, including how to do it manually in Excel and how a GSTR 2B reconciliation tool such as CAWork Suite can reduce repetitive matching work.

Table of Contents

1. What is GSTR-2B reconciliation?

2. Why should you match GSTR-2B with the Purchase Register?

3. GSTR-2A, GSTR-2B and Purchase Register difference

4. Files required for reconciliation

5. How to do GSTR-2B reconciliation manually

6. Different types of matches and mismatches

7. GSTR-2B reconciliation in Excel

8. How to reconcile GSTR-2B with Tally

9. Common reconciliation mistakes

10. How CAWork Suite automates GSTR-2B reconciliation

11. FAQs

What Is GSTR-2B Reconciliation?

GSTR-2B reconciliation is the process of matching supplier invoices available in GSTR-2B with purchase invoices recorded in your accounting books or Purchase Register.

For most businesses, the Purchase Register may come from:

• Tally

• ERP software

• Accounting software

• Excel

• Another bookkeeping system

The idea is simple:

Purchase Register
        ↕
      GSTR-2B
        ↓
Matched / Mismatched / Missing
        ↓
Review ITC

Under Section 16(2)(aa) of the CGST Act, for invoices or debit notes covered by the provision, supplier-furnished details must be communicated to the recipient as one of the conditions for ITC. Other conditions under Section 16 also continue to apply.

This means a simple invoice match is an important compliance check, but matching alone does not automatically prove final ITC eligibility.

What Is GSTR-2B Reconciliation?

GSTR-2B reconciliation is the process of matching supplier invoices available in GSTR-2B with purchase invoices recorded in your accounting books or Purchase Register.

For most businesses, the Purchase Register may come from:

• Tally

• ERP software

• Accounting software

• Excel

• Another bookkeeping system

The idea is simple:

Purchase Register
        ↕
      GSTR-2B
        ↓
Matched / Mismatched / Missing
        ↓
Review ITC

Under Section 16(2)(aa) of the CGST Act, for invoices or debit notes covered by the provision, supplier-furnished details must be communicated to the recipient as one of the conditions for ITC. Other conditions under Section 16 also continue to apply.

This means a simple invoice match is an important compliance check, but matching alone does not automatically prove final ITC eligibility.

GSTR-2A vs GSTR-2B vs Purchase Register

These three records serve different purposes.

From FY 2023-24 onwards, the GST Portal also uses GSTR-2B document details for Table 8A of GSTR-9, showing the importance of GSTR-2B data in later GST reconciliation as well.

For normal monthly working, GSTR-2B vs Purchase Register is usually the most important comparison.

How to Do GSTR-2B Reconciliation Manually

Step 1: Download GSTR-2B

Download the relevant GSTR-2B file from the GST Portal for the GSTIN and tax period you want to reconcile.

Keep the downloaded file unchanged.

Step 2: Export the Purchase Register

Export the Purchase Register from Tally, ERP or your accounting software.

Ideally, it should contain:

• Supplier GSTIN

• Invoice Number

• Invoice Date

• Taxable Value

• IGST

• CGST

• SGST/UTGST

• Cess, where applicable

• Total invoice value

Now you have:

File 1 → GSTR-2B
File 2 → Purchase Register

Step 3: Clean Invoice Numbers

One of the biggest problems in reconciliation is invoice-number formatting.

For example:

INV-001
INV/001
inv001
INV 001
000INV001

These may refer to the same invoice depending on the source data.

Before matching manually, standardise:

• Upper/lower case

• Spaces

• Hyphens

• Slashes

• Unnecessary leading zeros

Be careful not to change the real document identity while cleaning the format.

Step 4: Match Supplier GSTIN and Invoice Number

Start with:

Supplier GSTIN
+
Invoice Number

If both match, compare the financial values.

Example

Purchase Register:

Supplier GSTIN: 24XXXXXXXXXXXXX
Invoice: INV-105
Taxable Value: ₹10,000
IGST: ₹1,800

GSTR-2B:

Supplier GSTIN: 24XXXXXXXXXXXXX
Invoice: INV105
Taxable Value: ₹10,000
IGST: ₹1,800

After normalising the invoice number, this is likely the same transaction.

Step 5: Compare Taxable Value and GST

Once the invoice is identified, compare:

Taxable Value
CGST
SGST
IGST
Cess

Example:

Purchase Register taxable value = ₹10,000
GSTR-2B taxable value = ₹10,001

A very small difference may only be rounding.

But:

Purchase Register = ₹10,000
GSTR-2B = ₹12,000

This requires investigation.

Step 6: Separate Results into Categories

A useful GST reconciliation tool should make the result easy to understand.

Typical categories are:

Matched

Invoice is available in both files and key values agree.

Amount Difference

GSTIN and invoice match, but taxable value or GST differs materially.

GSTIN Difference

Invoice number appears similar, but supplier GSTIN differs.

Missing in GSTR-2B

Purchase is recorded in books, but the corresponding document is not found in GSTR-2B.

Possible reasons can include supplier reporting delay, incorrect GSTIN, incorrect invoice details or period difference.

Missing in Purchase Register

Invoice appears in GSTR-2B but is not found in your books.

Check whether:

• Purchase was not entered

• It belongs to another branch

• Supplier used the wrong GSTIN

• Invoice is duplicate

• The invoice does not belong to the business

Simple GSTR-2B Reconciliation Example

This simple classification makes GSTR 2B reconciliation with books much easier than comparing only grand totals.

How to Do GSTR-2B Reconciliation in Excel

Many accountants start with GSTR 2B reconciliation in Excel.

The basic manual process is:

1. Import GSTR-2B data.

2. Import the Purchase Register.

3. Clean GSTIN and invoice numbers.

4. Create a matching key.

5. Use XLOOKUP, VLOOKUP, INDEX-MATCH or Power Query.

6. Compare taxable value and GST.

7. Filter unmatched invoices.

8. Review differences one by one.

A common matching key could be:

Supplier GSTIN
+
Normalised Invoice Number

Then compare:

Purchase Register Taxable Value
vs
GSTR-2B Taxable Value

and:

Purchase Register GST
vs
GSTR-2B GST

Excel works for smaller datasets, but when you have thousands of invoices, formulas, duplicate checks and manual investigation can become difficult.

That is where GSTR 2B reconciliation software or a dedicated GSTR 2B matching tool becomes useful.

How to Reconcile GSTR-2B with Tally

If your Purchase Register is maintained in Tally, export the required purchase data first.

Then compare it with GSTR-2B using:

• Supplier GSTIN

• Invoice number

• Invoice date

• Taxable value

• IGST

• CGST

• SGST

The manual process looks like:

Tally Purchase Register
        +
GSTR-2B
        ↓
Clean Data
        ↓
Match GSTIN + Invoice
        ↓
Compare Amounts
        ↓
Review Missing / Mismatched Records

For businesses searching reconcile GSTR 2B with Tally or a GSTR 2B and purchase data reconciliation tool, the main objective is the same: identify differences before finalising ITC working.

Important: “Matched” Does Not Automatically Mean Final ITC Eligibility

A reconciliation system can tell you whether two uploaded records agree.

But ITC entitlement depends on GST law conditions.

Section 16 includes conditions such as possession of the prescribed document, receipt of goods/services, supplier reporting/communication where applicable, tax-related conditions and filing of the required return.

Therefore:

Matched in reconciliation = records agree.

It should not be read as an unconditional legal guarantee that ITC can be claimed.

This is important whether you use Excel, a GST reconciliation software, or any other GST reconciliation tool.

Common GSTR-2B Reconciliation Mistakes

Avoid these common errors:

• Comparing only total Purchase Register vs total GSTR-2B

• Matching only invoice number without GSTIN

• Ignoring spaces, /, - and leading zeros in invoice numbers

• Treating a ₹1 or ₹2 rounding difference as a major mismatch

• Allowing a large mismatch as rounding

• Ignoring credit notes and debit notes

• Claiming an invoice only because it exists in books

• Ignoring invoices available in GSTR-2B but missing from books

• Using the wrong GSTIN or return period

• Treating every matched invoice as automatically eligible ITC

• Not keeping a reconciliation report for review

How CAWork Suite Automates GSTR-2B Reconciliation

Why Spend Hours Matching Thousands of Invoices Manually?

Manual GSTR-2B reconciliation means cleaning invoice numbers, creating Excel formulas, checking GSTINs, comparing taxable values and finding missing invoices one by one.

CAWork Suite simplifies this through an organised GSTR 2B reconciliation tool.

Three Reconciliation Modes

CAWork Suite currently supports:

1. GSTR-2B vs Purchase Register
The standard monthly reconciliation.

2. GSTR-2A vs Purchase Register
Useful when you want to compare Purchase Register data with GSTR-2A.

3. GSTR-2B vs GSTR-2A
A portal-data comparison used for diagnostic review.

Step 1: Select Reconciliation Type

Choose the comparison you want to perform.

Step 2: Upload Both Files

Upload the supported:

• GSTR-2A or GSTR-2B JSON/Excel downloaded from GST Portal

• Purchase Register exported from Tally/ERP

CAWork Suite does not connect directly to GSTN through an API.

You remain in control: download the files yourself and upload them for reconciliation.

Step 3: CAWork Suite Validates and Processes the Files

The system checks whether the uploaded GST file is in the supported format.

It then converts invoice data into a common structure containing fields such as:

• Supplier GSTIN

• Invoice number

• Invoice date

• Taxable amount

• CGST

• SGST

• IGST

Step 4: Automatic Invoice Matching

CAWork Suite uses multiple matching passes.

Exact Matching

It checks the GSTIN and normalised invoice number.

Invoice numbers are cleaned for common formatting differences such as:

• Spaces

• -

• /

• Case differences

• Leading zeros

So formatting differences such as:

INV-001
inv/001
INV001

can be compared more intelligently.

For the tool's current matching logic, amount differences of up to ₹2 are treated as tolerance for rounding.

GSTIN Difference Check

If the invoice number matches but the GSTIN differs, the system performs another comparison where the taxable value must remain within the tool's configured 2% tolerance.

This helps surface possible GSTIN differences instead of simply marking the invoice as completely missing.

Missing Records

If no suitable match is found, the invoice is shown in the applicable missing category.

Invoices left unmatched on the opposite file are also shown separately.

Step 5: Review the Reconciliation Dashboard

After processing, CAWork Suite shows:

• Matched records

• Amount differences

• GSTIN differences

• Missing records

• ITC-related summary

• Searchable and sortable invoice table

• Plain-language guidance for each result

You can also export the reconciliation report in supported Excel and PDF formats.

CAWork Suite's ITC figures are reconciliation indicators based on the uploaded files. Final ITC eligibility should still be reviewed under applicable GST law.

Your Files Are Automatically Removed After 7 Days

Completed reconciliation jobs and uploaded files are currently retained for 7 days and then automatically deleted through the system's scheduled cleanup process.

This provides enough time to review or export the report without treating the tool as permanent document storage.

CAWork Suite Is a Reconciliation Report Tool

CAWork Suite currently helps you:

Upload → Match → Identify Differences → Review → Export

It does not currently:

• Change GST Portal records

• Accept/reject invoices on GST Portal for you

• Contact suppliers automatically

• Track supplier corrections to completion

After reviewing a mismatch, the accountant or business takes the required action outside the reconciliation tool.

Stop Doing GSTR-2B Reconciliation Manually

Instead of maintaining VLOOKUPs, XLOOKUPs and multiple Excel sheets every month, use CAWork Suite as your GST reconciliation software.

The workflow is simple:

Select Reconciliation Type → Upload GSTR-2A/2B + Purchase Register → Automatic Matching → Review ITC & Mismatches → Export Report

For businesses, accountants and CA firms handling large Purchase Registers, this creates a repeatable monthly reconciliation process.

Related CAWork Suite Workflows

If you also manage other accounting work, explore dedicated CAWork Suite guides for:

• GSTR 2B reconciliation in Excel

• GSTR 2B reconciliation with books

• GSTR 2B matching tool

• GSTR 2B reconciliation software

• Reconciliation of GSTR 2B with books

• Reconcile GSTR 2B with Tally

• Bank statement to Tally

• Bank statement import in Tally Prime

• Import bank statement in Tally

• Tally Prime bank statement import

• Bank statement PDF to Tally import

• Tally for ecommerce

• GSTR-1 for ecommerce sellers

These should ideally link to their own dedicated guides so this page remains strongly focused on GSTR-2B reconciliation.

Frequently Asked Questions

1. What is GSTR-2B reconciliation?

GSTR-2B reconciliation means matching purchase invoices recorded in your books with documents available in GSTR-2B to identify matched, missing or mismatched transactions.

2. Why should I reconcile GSTR-2B with my Purchase Register?

It helps identify invoices missing from GSTR-2B, incorrect GSTINs, invoice-number differences, amount differences and invoices appearing in GST data but not in books.

3. Can I do GSTR-2B reconciliation in Excel?

Yes. You can use XLOOKUP, VLOOKUP, Power Query or similar methods, but large datasets can require considerable cleaning and manual review.

4. What if an invoice is in Purchase Register but not in GSTR-2B?

Investigate the supplier's reporting, GSTIN, invoice number and filing period. For invoices covered by Section 16(2)(aa), supplier furnishing and communication of the document is one of the ITC conditions.

5. What if an invoice is in GSTR-2B but not in my books?

Check whether the purchase was missed in accounting, belongs to another branch, is duplicate or was reported against your GSTIN incorrectly.

6. Can I reconcile GSTR-2B with Tally?

Yes. Export your Purchase Register from Tally and compare it with the downloaded GSTR-2B using GSTIN, invoice number and tax values.

7. Does CAWork Suite connect directly to the GST Portal?

No. CAWork Suite currently uses manually uploaded GST Portal files and does not use a GSTN API.

8. What does CAWork Suite match?

The tool compares fields such as GSTIN, normalised invoice number and taxable/tax amounts and identifies matched, amount-difference, GSTIN-difference and missing records.

9. Does a matched invoice guarantee ITC?

No. A match confirms agreement between uploaded records. Final ITC entitlement remains subject to all applicable GST conditions.

10. What is the difference between GSTR-2A and GSTR-2B reconciliation?

GSTR-2A comparison is useful for supplier/document tracking, while GSTR-2B is generally the main monthly ITC reconciliation reference. GST Portal data shows supplier-filed documents flow into recipient statements based on filing activity.

Conclusion

GSTR-2B reconciliation should not mean comparing only two grand totals.

Good reconciliation works invoice by invoice.

Match the supplier GSTIN and invoice number, compare taxable value and GST, identify missing invoices, find incorrect GSTINs and review invoices available in GSTR-2B but missing from your books.

You can perform GSTR 2B reconciliation in Excel, but large Purchase Registers can make manual formulas and checking time-consuming.

CAWork Suite provides a simpler GSTR 2B reconciliation tool for businesses, accountants and CA firms: upload your GSTR-2A/2B and Purchase Register, let the system match the records, review mismatches and export your report.

Disclaimer: GST information was reviewed in August 2026. This article is for educational purposes and is not tax or legal advice. ITC eligibility depends on the applicable GST law and facts of each transaction. Always review material mismatches before filing or claiming ITC.