GSTR-2B Reconciliation with Books: How to Find Missing and Mismatched Invoices

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

Your books or Purchase Register tell you:

“Which purchases have I recorded?”

GSTR-2B helps you check:

“Which supplier-reported documents have reached my GST statement?”

If both records match, your monthly GST working becomes much easier. But if an invoice is missing, the GSTIN is different, the invoice number does not match or the taxable value is different, that invoice needs attention.

This guide explains reconciliation of GSTR 2B with books in simple steps, including how to find missing invoices, mismatched amounts and GSTIN differences. We will also explain how CAWork Suite works as a GSTR 2B reconciliation tool for businesses, accountants and CAs handling large Purchase Registers.

Table of Contents

1. What is GSTR-2B reconciliation with books?

2. Why should you reconcile GSTR-2B with your Purchase Register?

3. Which files and fields are required?

4. How to match GSTR-2B with books manually

5. How to find missing invoices

6. How to find mismatched invoices

7. GSTIN and invoice-number differences

8. Amount and GST differences

9. GSTR-2B reconciliation with Tally

10. GSTR-2B reconciliation in Excel

11. Common reconciliation mistakes

12. How CAWork Suite helps

13. FAQs

What Is GSTR-2B Reconciliation with Books?

GSTR 2B reconciliation with books is an invoice-by-invoice comparison between GSTR-2B and your Purchase Register.

GSTR-2B is an auto-generated monthly statement containing input-tax-credit related details made available electronically through the GST Portal.

Your Purchase Register comes from your own accounting records, such as:

• Tally

• ERP software

• Accounting software

• Excel

• Another bookkeeping system

The basic reconciliation looks like this:

Purchase Register
        +
      GSTR-2B
        ↓
Match GSTIN + Invoice
        ↓
Compare Taxable Value & GST
        ↓
Matched / Mismatched / Missing
        ↓
Review ITC

The purpose is not only to compare two totals.

A proper GST reconciliation tool should help you identify the exact invoice responsible for a difference.

Why Is GSTR-2B Reconciliation with Books Important?

Suppose your Purchase Register contains:

500 purchase invoices

but your GSTR-2B contains only:

470 matching invoices

Simply knowing that 30 invoices are different is not enough.

You need to know:

• Which invoices are missing?

• Which supplier GSTIN is different?

• Which invoice number is different?

• Which taxable value does not match?

• Which GST amount is different?

• Are there invoices in GSTR-2B that are not recorded in your books?

For supplier invoices covered by the relevant ITC provisions, Section 16 requires invoice or debit-note details furnished by the supplier to be communicated to the recipient, along with other ITC conditions.

That is why regular reconciliation of GSTR 2B with books is an important part of monthly ITC review.

Important: An invoice matching GSTR-2B does not by itself guarantee final ITC eligibility. Other GST conditions still apply.

Which Files Are Required?

You normally need two files.

File 1: GSTR-2B

Download GSTR-2B for the required GSTIN and tax period from the GST Portal.

File 2: Purchase Register

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

Your Purchase Register should ideally contain:

• Supplier GSTIN

• Invoice Number

• Invoice Date

• Taxable Value

• IGST

• CGST

• SGST/UTGST

• Cess, if applicable

• Invoice Value

Now you can start matching:

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

Which Fields Should You Compare?

The most useful invoice-level fields are:

Do not start by comparing only the total Purchase Register amount with total GSTR-2B.

Two grand totals can look similar even when many individual invoices are wrong.

How to Match GSTR-2B with Books Manually

Step 1: Check GSTIN and Tax Period

Make sure both files belong to:

• Correct business GSTIN

• Correct month or period

This sounds simple, but comparing the wrong GST registration or period can create hundreds of false mismatches.

Step 2: Standardise Invoice Numbers

Invoice-number formatting is one of the most common causes of false mismatches.

For example:

INV-001
INV/001
inv001
INV 001

may represent the same invoice.

For manual reconciliation, you may normalise:

• Spaces

• /

• -

• Upper/lower case

• Unnecessary leading zeros

But always keep the original invoice number for reference.

Step 3: Match Supplier GSTIN + Invoice Number

Start with:

Supplier GSTIN
+
Invoice Number

Example:

Purchase Register

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

GSTR-2B

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

After normalising the invoice number, these records are likely the same transaction.

Step 4: Compare Amounts

After finding the invoice, compare:

Taxable Value
+
IGST / CGST / SGST
+
Cess, where applicable

If everything agrees, mark it:

Matched

If the invoice matches but values differ, mark it for review.

How to Find Missing Invoices

There are two important missing-invoice situations.

1. Invoice Is in Books but Missing from GSTR-2B

Example:

Purchase Register:

Supplier: ABC Traders
Invoice: AT-205
Taxable Value: ₹25,000
GST: ₹4,500

GSTR-2B:

No matching invoice found

This should be reviewed before ITC working is finalised.

Possible reasons include:

• Supplier has not correctly reported the invoice

• Recipient GSTIN was entered incorrectly

• Invoice number is different

• Invoice appears in another tax period

• Supplier amended the document

• Purchase Register contains an incorrect entry

For invoices to which the relevant Rule 36 requirements apply, supplier reporting and communication of the invoice/debit-note details in GSTR-2B is specifically required.

Do not immediately assume the supplier has done something wrong. First verify GSTIN, invoice number, invoice date and period.

2. Invoice Is in GSTR-2B but Missing from Books

This is the opposite situation.

Example:

GSTR-2B contains:

Supplier: XYZ Pvt Ltd
Invoice: XYZ-551
Taxable Value: ₹18,000
GST: ₹3,240

but your Purchase Register has no matching entry.

Possible reasons:

• Purchase was not entered in books

• Invoice belongs to another branch

• Supplier reported the wrong recipient GSTIN

• Document is duplicate

• Document does not belong to your business

Do not automatically book or claim an invoice only because it appears in GSTR-2B.

Verify the actual transaction first.

How to Find Mismatched Invoices

Not every problem is a completely missing invoice.

Many invoices appear in both files but contain different details.

A good GSTR 2B matching tool should separate these differences clearly.

1. GSTIN Difference

Example:

Books:

GSTIN: 24ABCDE1234F1Z5
Invoice: INV100

GSTR-2B:

GSTIN: 24ABCDE1234F2Z4
Invoice: INV100

The invoice number may be the same, but the supplier GSTIN is different.

This requires review.

2. Invoice Number Difference

Example:

Books:

INV-000123

GSTR-2B:

INV123

This may be only a formatting difference.

A good reconciliation process should distinguish formatting differences from genuinely different invoice numbers.

3. Taxable Value Difference

Example:

Purchase Register:

₹50,000

GSTR-2B:

₹52,000

Difference:

₹2,000

This should not be treated as a simple rounding issue.

Check the original invoice and supplier filing.

4. GST Amount Difference

The taxable value may match while tax differs.

For example:

The invoice needs review because GST differs by ₹100.

Simple Reconciliation Status Table

This is more useful than a single total difference.

GSTR-2B Reconciliation with Tally

If your accounting books are maintained in Tally, export your Purchase Register first.

Then compare:

• Supplier GSTIN

• Invoice number

• Invoice date

• Taxable value

• CGST

• SGST

• IGST

The process looks like:

Tally Purchase Register
        +
      GSTR-2B
        ↓
Normalise Invoice Numbers
        ↓
Match GSTIN + Invoice
        ↓
Compare Taxable Value & GST
        ↓
Find Missing / Mismatched Invoices

This is the basic process for users looking to reconcile GSTR 2B with Tally.

If you have hundreds or thousands of monthly invoices, manually doing this for every vendor can become time-consuming.

That is where a GSTR 2B and purchase data reconciliation tool becomes useful.

GSTR-2B Reconciliation in Excel

You can also perform GSTR 2B reconciliation in Excel.

Common Excel methods include:

• XLOOKUP

• VLOOKUP

• INDEX-MATCH

• Power Query

• Helper columns

• Matching keys

A simple matching key could be:

Supplier GSTIN
+
Normalised Invoice Number

Then use Excel to compare:

Books Taxable Value
vs
GSTR-2B Taxable Value

and:

Books GST
vs
GSTR-2B GST

Excel can work well for smaller datasets.

But as invoice volume increases, you may need to manage:

• Multiple formulas

• Duplicate invoices

• Invoice-number formatting

• Missing records

• Amount differences

• GSTIN differences

• Manual filters

• Repeated monthly working

This is why businesses and accountants often look for GST reconciliation software, a GST reconciliation tool or dedicated GSTR 2B reconciliation software.

Common Mistakes in GSTR-2B Reconciliation with Books

Avoid these common mistakes:

• Comparing only grand totals

• Matching invoice number without supplier GSTIN

• Ignoring invoice formatting differences

• Treating every small difference as a completely different invoice

• Ignoring material amount differences

• Checking only invoices missing from GSTR-2B

• Ignoring invoices missing from books

• Ignoring credit notes or debit notes

• Using the wrong tax period

• Mixing multiple GSTINs

• Assuming every GSTR-2B invoice belongs in books

• Assuming every matched record automatically qualifies for ITC

Good reconciliation of GSTR 2B with books should identify the difference first and allow the accountant to decide the correct action after reviewing the supporting documents.

How CAWork Suite Helps with GSTR-2B Reconciliation with Books

Stop Matching Hundreds of Invoices One by One

Manual reconciliation normally means:

Export Files
→ Clean Invoice Numbers
→ Create Excel Formulas
→ Match GSTIN
→ Match Invoice
→ Compare Amounts
→ Find Missing Records
→ Review One by One

CAWork Suite simplifies this through its GSTR 2B reconciliation tool.

CAWork Suite Supports Three Reconciliation Modes

1. GSTR-2B vs Purchase Register

This is the standard monthly GSTR 2B reconciliation with books workflow.

2. GSTR-2A vs Purchase Register

Compare your Purchase Register against GSTR-2A.

3. GSTR-2B vs GSTR-2A

Compare the two GST statement datasets for diagnostic review.

Step 1: Select the Reconciliation Type

Choose:

GSTR-2B vs Purchase Register

for normal monthly reconciliation with books.

Step 2: Upload Both Files

Upload:

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

• Purchase Register exported from Tally/ERP

CAWork Suite does not directly connect to the GST Portal through GSTN API.

You download the files yourself and upload them for processing.

Step 3: Automatic Data Normalisation

CAWork Suite converts supported records into a common invoice structure containing information such as:

• GSTIN

• Invoice number

• Invoice date

• Taxable amount

• CGST

• SGST

• IGST

The matching process also normalises common invoice-number formatting.

For example:

INV-001
INV/001
inv001

can be compared more intelligently instead of automatically becoming three separate invoices.

Step 4: Automatic Matching

CAWork Suite currently uses multiple matching passes.

Exact Match

It first checks:

Same GSTIN + Same normalised invoice number

For the current tool logic, an amount difference of up to ₹2 is allowed as a reconciliation tolerance.

If the difference exceeds the configured tolerance, the invoice is shown as an:

Amount Difference

GSTIN Difference Detection

If the invoice number matches but GSTIN differs, CAWork Suite performs another check where taxable amount must remain within its configured 2% tolerance.

This helps identify possible GSTIN differences instead of simply showing the invoice as missing.

Important: ₹2 and 2% are CAWork Suite matching tolerances. They are not GST-law tolerances or automatic ITC eligibility rules.

Missing Records

If no suitable match is found, CAWork Suite identifies the applicable missing record.

It can therefore help separate:

• Matched

• Amount Difference

• GSTIN Difference

• Missing invoices

• Extra/unmatched records

Step 5: Review ITC and Mismatches

After processing, the dashboard provides summary information including:

• Matched records

• ITC-related amount summary

• ITC at-risk indicator

• Amount differences

• GSTIN differences

• Missing records

• Searchable and sortable results

• Plain-English guidance

You can also export the supported reconciliation report in:

• Excel

• PDF

CAWork Suite's ITC amounts are reconciliation indicators calculated from uploaded data.

They should not be treated as an unconditional legal determination of ITC eligibility.

Files Are Automatically Removed After 7 Days

Completed reconciliation jobs and their uploaded files are currently retained for 7 days and then automatically deleted.

Download any report you want to retain before that period ends.

What CAWork Suite Does — and Does Not Do

CAWork Suite currently helps with:

Upload → Match → Find Differences → Review → Export

It does not currently:

• Edit GST Portal data

• File your GST return automatically

• Accept/reject GST documents on the portal

• Automatically contact suppliers

• Track supplier corrections until resolution

You review the report and take the required action outside the tool.

Why Use a GSTR-2B Reconciliation Tool Instead of Manual Excel?

For 20 invoices, manual checking may be manageable.

For 2,000 invoices, the same process becomes very different.

You have to repeatedly:

• Clean invoice numbers

• Check GSTIN

• Compare taxable values

• Compare GST

• Find missing records

• Sort mismatches

• Prepare reports

A dedicated GST reconciliation software can make this repeated monthly work much more organised.

CAWork Suite's workflow is:

Select GSTR-2B vs Purchase Register → Upload Files → Automatic Matching → Review Missing & Mismatched Invoices → Export

Related GST & Accounting Guides

You can also explore:

• GSTR 2B reconciliation

• GSTR 2B reconciliation in Excel

• GSTR 2B matching tool

• GSTR 2B reconciliation software

• GST reconciliation software

• GST reconciliation tool

• Reconciliation of GSTR 2B with books

• GSTR 2B and purchase data reconciliation tool

• Reconcile GSTR 2B with Tally

For other accounting workflows, dedicated CAWork Suite guides can cover:

• 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 separate pages should link together naturally rather than forcing unrelated keywords into the main GSTR-2B article.

Frequently Asked Questions

1. What is GSTR-2B reconciliation with books?
It is the process of comparing GSTR-2B invoices with purchase invoices recorded in your accounting books or Purchase Register.

2. Why is reconciliation of GSTR-2B with books required?
It helps identify missing invoices, GSTIN differences, invoice-number differences, taxable-value differences and GST mismatches before finalising ITC working.

3. What if an invoice is in books but missing from GSTR-2B?
Check the supplier GSTIN, invoice number, invoice date, filing period and supplier reporting. For relevant supplier invoices, GST rules require supplier-furnished document details to be communicated in GSTR-2B for ITC purposes.

4. What if an invoice is in GSTR-2B but missing from books?
Check whether the purchase was not recorded, belongs to another branch, is duplicate or was reported against your GSTIN incorrectly.

5. Can I do GSTR-2B reconciliation with books in Excel?
Yes. You can use XLOOKUP, VLOOKUP, Power Query or other Excel methods to compare the two datasets.

6. Can I reconcile GSTR-2B with Tally?
Yes. Export your Tally Purchase Register and compare it with GSTR-2B using GSTIN, invoice number and tax values.

7. What is a GSTR-2B matching tool?
A GSTR-2B matching tool automates invoice comparison and helps identify matched, missing and mismatched records.

8. Does CAWork Suite connect directly to GSTN?
No. Users manually download their GSTR-2A/2B data and upload supported files to CAWork Suite.

9. Does a matched invoice guarantee ITC eligibility?
No. Matching confirms that the compared records agree. Other statutory ITC conditions under Section 16 and applicable rules still need to be satisfied.

10. How does CAWork Suite help?
CAWork Suite automatically compares supported GSTR-2B and Purchase Register files, identifies matches and differences, provides reconciliation summaries and allows supported Excel/PDF report export.

Conclusion

GSTR 2B reconciliation with books is much more than comparing two totals.

The right approach is to match each purchase invoice with GSTR-2B using supplier GSTIN and invoice number, then compare taxable value and GST.

This helps you identify:

• Missing invoices

• GSTIN differences

• Invoice-number differences

• Amount differences

• GST differences

• Records available in GSTR-2B but missing from books

You can perform reconciliation of GSTR 2B with books manually using Excel or Tally exports. But when invoice volume increases, the process can become repetitive.

CAWork Suite provides a dedicated GSTR 2B reconciliation tool where you upload the supported GSTR-2B and Purchase Register files, automatically match invoices, review missing and mismatched records, and export the reconciliation 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 applicable GST law and the facts of each transaction. Review important mismatches and supporting documents before taking ITC.