How to Reconcile GSTR-2B with Tally Purchase Register

If your business records purchases in Tally, you should regularly reconcile GSTR 2B with Tally before finalising your monthly Input Tax Credit (ITC) working.

Your Tally Purchase Register tells you which purchase invoices are recorded in your books.

GSTR-2B tells you which supplier-reported documents have reached your GST statement for the relevant period.

The purpose of reconciliation is simple:

Does the purchase invoice recorded in Tally correctly match the invoice available in GSTR-2B?

A proper GSTR 2B reconciliation checks invoices one by one instead of comparing only the total Purchase Register value with total GSTR-2B.

In this guide, we will explain how to manually reconcile GSTR 2B with Tally, how to find missing and mismatched invoices, and how CAWork Suite can automate this repetitive work using its GSTR 2B reconciliation tool.

Table of Contents

1. What does GSTR-2B reconciliation with Tally mean?

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

3. Which files are required?

4. Which Tally fields should you compare?

5. How to reconcile GSTR-2B with Tally step by step

6. How to identify missing invoices

7. How to identify GSTIN and amount differences

8. GSTR-2B reconciliation in Excel

9. Common reconciliation mistakes

10. How CAWork Suite helps

11. FAQs

What Does GSTR-2B Reconciliation with Tally Mean?

To reconcile GSTR 2B with Tally means comparing purchase invoices recorded in Tally with the corresponding documents available in GSTR-2B.

The basic process is:

Tally Purchase Register
        +
      GSTR-2B
        ↓
Match Supplier GSTIN
        ↓
Match Invoice Number
        ↓
Compare Taxable Value
        ↓
Compare CGST / SGST / IGST
        ↓
Find Missing & Mismatched Invoices
        ↓
Review ITC

This is also a form of GSTR 2B reconciliation with books, because your Tally Purchase Register represents the purchases recorded in your accounting books.

Under Section 16 of the CGST Act, ITC eligibility includes several conditions. For applicable invoices or debit notes, supplier-furnished document details must also be communicated to the recipient. A successful reconciliation is therefore an important review step, although a match alone does not guarantee final ITC eligibility.

Why Reconcile GSTR-2B with Tally?

Suppose your Tally Purchase Register contains:

1,200 purchase invoices

but after comparing with GSTR-2B you find:

• 1,050 matched

• 60 missing from GSTR-2B

• 25 amount differences

• 10 possible GSTIN differences

• 55 records requiring other review

If you only compare the grand totals, you will not know which invoices caused the difference.

Invoice-level reconciliation of GSTR 2B with books helps you answer questions such as:

• Is a supplier invoice missing from GSTR-2B?

• Is the supplier GSTIN different?

• Is the invoice number different?

• Does taxable value match?

• Does IGST match?

• Do CGST and SGST match?

• Is a document in GSTR-2B but missing from Tally?

• Which invoices need review before finalising ITC?

This is why accountants handling hundreds or thousands of invoices often look for GST reconciliation software instead of manually checking every row.

Which Files Are Required?

You normally need two files.

File 1: GSTR-2B

Download the required GSTR-2B file for the correct GSTIN and return period from the GST Portal.

Keep the original file unchanged.

File 2: Tally Purchase Register

Export the Purchase Register from Tally for the same period.

TallyPrime supports exporting reports and company data in formats including Excel, JSON, XML and other supported formats.

For reconciliation, an Excel or supported structured Purchase Register export is usually easier to work with.

Your working becomes:

GSTR-2B
   +
Tally Purchase Register
   ↓
Reconciliation

Which Fields Should You Compare?

Your Tally Purchase Register should ideally provide these invoice-level details:

Do not use only:

Total Purchase Register vs Total GSTR-2B

The totals may look close while individual invoices still contain important differences.

How to Reconcile GSTR-2B with Tally Step by Step

Step 1: Export the Correct Purchase Register

First select the GSTIN and period you want to reconcile.

For example:

GST Period: July 2026

Export the corresponding Purchase Register from Tally.

Make sure you do not accidentally include transactions from another GSTIN or another period.

TallyPrime allows reports and transactions to be exported, with configurable period and output settings.

Step 2: Download GSTR-2B for the Same Period

Download GSTR-2B for:

• The same GSTIN

• The corresponding reconciliation period

Do not compare one GST registration with another GST registration's Tally data.

Step 3: Clean Supplier GSTIN

Compare the GSTIN in both datasets.

For example:

24ABCDE1234F1Z5

should be compared against the corresponding supplier GSTIN in GSTR-2B.

Remove accidental:

• Spaces

• Formatting differences

• Lower/uppercase differences

But do not modify the actual GSTIN.

Step 4: Normalise Invoice Numbers

Invoice numbers are one of the biggest causes of false mismatches.

Your Tally Purchase Register may contain:

INV-001

while GSTR-2B contains:

INV001

Or:

ABC/2026/015

versus:

ABC2026015

Depending on the actual document, these may represent the same invoice.

A reconciliation process may therefore normalise common formatting differences such as:

• Spaces

• /

• -

• Upper/lower case

• Leading zeros

Always retain the original invoice number for audit/reference.

Step 5: Match GSTIN + Invoice Number

The first strong matching combination is:

Supplier GSTIN
+
Invoice Number

Example

Tally 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, this is likely the same transaction.

Step 6: Compare Taxable Value

Once the invoice is identified, compare the taxable value.

Example 1 — Match

Tally:

₹25,000

GSTR-2B:

₹25,000

Result:

Matched

Example 2 — Difference

Tally:

₹25,000

GSTR-2B:

₹28,000

Difference:

₹3,000

Result:

Amount Difference — Review Required

Do not ignore a material difference just because the GSTIN and invoice number match.

Step 7: Compare GST Amount

Now compare:

• IGST

• CGST

• SGST

• Cess, where applicable

Example:

Even though taxable value matches, the GST amount does not.

The invoice should be reviewed.

How to Find Missing Invoices

There are two important types of missing records.

1. Invoice in Tally but Missing from GSTR-2B

Example:

Tally Purchase Register:

Supplier: ABC Traders
Invoice: AT-250
Taxable Value: ₹30,000
GST: ₹5,400

GSTR-2B:

Not Found

Possible reasons include:

• Supplier reporting issue

• Incorrect recipient GSTIN

• Invoice-number difference

• Period difference

• Supplier amendment

• Incorrect entry in books

Do not immediately assume the supplier has not filed the invoice.

First check:

GSTIN
Invoice Number
Invoice Date
Tax Period
Taxable Value
GST

For applicable invoices, supplier furnishing and communication of invoice/debit-note details is one of the statutory ITC conditions.

2. Invoice in GSTR-2B but Missing from Tally

This is equally important.

Suppose GSTR-2B contains:

Supplier: XYZ Pvt Ltd
Invoice: XYZ-501
Taxable Value: ₹40,000

But there is no corresponding entry in the Tally Purchase Register.

Check whether:

• Purchase was not recorded

• Invoice belongs to another branch

• Supplier used an incorrect GSTIN

• Invoice is duplicate

• Invoice does not belong to your business

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

How to Find a GSTIN Difference

Sometimes the invoice number looks correct but the supplier GSTIN differs.

Example:

Tally

24ABCDE1234F1Z5
Invoice: INV100

GSTR-2B

24ABCDE1234F2Z4
Invoice: INV100

This could indicate:

• Incorrect GSTIN in Tally

• Supplier reporting issue

• Different registration/branch

• Incorrect matching

The invoice should be manually verified.

A good GSTR 2B matching tool should show this separately instead of simply saying:

“Invoice Not Found.”

GSTR-2B Reconciliation in Excel Using Tally Data

You can also perform GSTR 2B reconciliation in Excel after exporting your Tally Purchase Register.

A typical manual workflow is:

Tally Purchase Register
        +
GSTR-2B Excel
        ↓
Clean GSTIN
        ↓
Clean Invoice Number
        ↓
Create Match Key
        ↓
XLOOKUP / VLOOKUP
        ↓
Compare Amount
        ↓
Compare GST
        ↓
Filter Missing Records

A match key can be:

Supplier GSTIN
+
Normalised Invoice Number

Then use:

• XLOOKUP

• VLOOKUP

• INDEX-MATCH

• Power Query

to find corresponding invoices.

This method is manageable for smaller datasets.

But for thousands of invoices every month, maintaining formulas becomes repetitive.

That is why users searching reconcile GSTR 2B with Tally often also search for:

• GSTR 2B reconciliation tool

• GSTR 2B matching tool

• GSTR 2B reconciliation software

• GST reconciliation software

• GST reconciliation tool

Common Mistakes When Reconciling GSTR-2B with Tally

Avoid these common errors:

• Comparing only total Purchase Register and GSTR-2B

• Using the wrong GSTIN

• Comparing different return periods

• Matching invoice number without supplier GSTIN

• Ignoring invoice-number formatting

• Treating every small formatting difference as a missing invoice

• Ignoring material taxable-value differences

• Ignoring GST differences

• Checking only records missing from GSTR-2B

• Ignoring records missing from Tally

• Ignoring credit/debit notes

• Treating every matched invoice as automatically eligible ITC

• Changing original GST data before reconciliation

Good GSTR 2B reconciliation with books should first show the difference clearly. The accountant can then review the source documents and take the appropriate action.

How CAWork Suite Helps You Reconcile GSTR-2B with Tally

Stop Creating the Same Excel Formulas Every Month

Manual Tally reconciliation means:

Export Purchase Register
        ↓
Download GSTR-2B
        ↓
Clean Invoice Numbers
        ↓
Create XLOOKUP / VLOOKUP
        ↓
Match GSTIN
        ↓
Compare Taxable Value
        ↓
Compare GST
        ↓
Find Missing Invoices
        ↓
Review One by One

CAWork Suite simplifies this process through its dedicated GSTR 2B and purchase data reconciliation tool.

Step 1: Select GSTR-2B vs Purchase Register

For normal Tally reconciliation, select:

GSTR-2B vs Purchase Register

CAWork Suite also supports:

• GSTR-2A vs Purchase Register

• GSTR-2B vs GSTR-2A

But for this workflow, the standard option is:

GSTR-2B vs Purchase Register

Step 2: Upload Your Files

Upload the supported:

File 1: GSTR-2B JSON or Excel downloaded from GST Portal

File 2: Purchase Register exported from Tally/ERP

CAWork Suite currently uses manual file upload.

It does not connect directly to GSTN through an API.

Step 3: Automatic File Validation

The system validates supported GST files before reconciliation.

For example, it checks that a supposed GSTR-2B JSON is actually a supported GSTR-2B file instead of another GST return format.

The data is then converted into a common structure containing information such as:

• GSTIN

• Invoice number

• Invoice date

• Taxable value

• CGST

• SGST

• IGST

How CAWork Suite Matches Tally Purchase Invoices

CAWork Suite currently uses multiple matching passes.

Pass 1 — Exact Match

The first comparison checks:

Same GSTIN + Same Normalised Invoice Number

Common invoice formatting is normalised.

For example:

INV-001
INV/001
inv001

can be compared intelligently.

The current matching logic allows up to a ₹2 amount difference as an internal reconciliation tolerance.

If the amount difference exceeds the configured tolerance, the record is shown as:

Amount Difference

Important

The ₹2 tolerance is a CAWork Suite matching rule designed to handle small rounding differences.

It is not a GST-law tolerance and does not independently determine ITC eligibility.

Pass 2 — GSTIN Difference Check

If the normalised invoice number is the same but the GSTIN differs, CAWork Suite performs another check.

The taxable amount must remain within the tool's configured 2% tolerance.

When appropriate, this is shown as:

GSTIN Difference

This helps you investigate a likely GSTIN issue instead of manually searching for the invoice.

Again:

2% is a CAWork Suite reconciliation tolerance, not a statutory GST rule.

Pass 3 — Missing Records

If no suitable match is found, CAWork Suite categorises the applicable invoice as missing.

Records left unmatched on the other side are shown separately.

This helps identify:

• Matched invoices

• Amount differences

• GSTIN differences

• Missing records

• Extra/unmatched records

Review Reconciliation Results in One Dashboard

After processing, CAWork Suite displays reconciliation results with:

• Matched records

• ITC-related summary

• ITC at-risk indicator

• Reconciliation status tabs

• Searchable invoice table

• Sortable results

• Plain-English guidance

Supported reports can also be exported as:

• Excel

• PDF

This is particularly useful for CA firms and accountants reconciling multiple businesses every month.

CAWork Suite's ITC figures are reconciliation indicators based on uploaded data. Final ITC eligibility still needs to satisfy applicable GST conditions.

Uploaded Files Are Retained for 7 Days

Completed reconciliation jobs and uploaded files are currently retained for 7 days.

They are then automatically removed through the system's scheduled cleanup process.

Download any reconciliation report you want to keep before the retention period ends.

What CAWork Suite Does Not Do

CAWork Suite currently focuses on reconciliation:

Upload → Match → Identify Differences → Review → Export

It does not currently:

• Modify your Tally data

• Modify GST Portal records

• Automatically file GST returns

• Accept or reject GST records on the portal

• Automatically contact suppliers

• Track supplier corrections until resolution

The accountant reviews the result and takes the appropriate action outside the reconciliation tool.

Why Use GST Reconciliation Software with Tally?

Manual reconciliation can work when you have:

20 invoices

But suppose you have:

2,000 invoices every month.

Now you repeatedly need to:

• Clean invoice numbers

• Create Excel formulas

• Match GSTINs

• Compare taxable values

• Compare tax

• Find missing invoices

• Sort mismatches

• Prepare a report

Using GST reconciliation software can make the same monthly process much more organised.

CAWork Suite workflow:

Select GSTR-2B vs Purchase Register → Upload GSTR-2B + Tally Purchase Register → Automatic Matching → Review Differences → Export Report

Related GST & Tally Guides

For deeper learning, link this article naturally to dedicated guides for:

• GSTR 2B reconciliation

• GSTR 2B reconciliation in Excel

• GSTR 2B reconciliation with books

• Reconciliation of GSTR 2B with books

• GSTR 2B matching tool

• GSTR 2B reconciliation software

• GST reconciliation software

• GST reconciliation tool

• GSTR 2B and purchase data reconciliation tool

CAWork Suite can also have separate accounting guides for:

• 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 software

• GSTR-1 filing software

• GSTR-1 for ecommerce sellers

These should remain separate pages with contextual internal links instead of forcing unrelated search keywords repeatedly into this article.

Frequently Asked Questions

1. How do I reconcile GSTR-2B with Tally?
Export your Tally Purchase Register, download GSTR-2B for the same GSTIN and period, then compare supplier GSTIN, invoice number, taxable value and GST amounts invoice by invoice.

2. Which Tally fields are important for GSTR-2B reconciliation?
Use supplier GSTIN, invoice number, invoice date, taxable value, IGST, CGST, SGST/UTGST, cess where applicable and invoice value.

3. Can I export a Purchase Register from TallyPrime?
TallyPrime supports configurable export of reports and data, including Excel and other supported formats.

4. Can I reconcile GSTR-2B with Tally in Excel?
Yes. Export your Purchase Register and use XLOOKUP, VLOOKUP, Power Query or matching keys to compare it with GSTR-2B.

5. What if an invoice exists in Tally but not in GSTR-2B?
Check the GSTIN, invoice number, date and return period. Also investigate whether supplier reporting or amendments caused the difference. For relevant invoices, supplier-furnished details communicated to the recipient form part of the statutory ITC conditions.

6. What if GSTR-2B contains an invoice missing from Tally?
Check whether the purchase was not booked, belongs to another branch, was reported using your GSTIN incorrectly or is otherwise not relevant to your books.

7. What is a GSTR-2B reconciliation tool?
It is software that compares GSTR-2B against Purchase Register data and helps identify matched, missing and mismatched invoices.

8. Does CAWork Suite connect directly to Tally?
The current reconciliation workflow uses a Purchase Register exported from Tally/ERP and uploaded to CAWork Suite. It does not directly modify your Tally data.

9. Does CAWork Suite connect directly to GSTN?
No. Users manually download the supported GSTR-2A/2B file from GST Portal and upload it for reconciliation.

10. Does a matched invoice guarantee ITC?
No. Matching confirms that the compared records agree. Final ITC eligibility remains subject to all applicable GST conditions under Section 16 and other relevant provisions.

Conclusion

To properly reconcile GSTR 2B with Tally, do not compare only grand totals.

Compare the invoices individually.

Start with:

Supplier GSTIN + Invoice Number

Then compare:

• Invoice date

• Taxable value

• IGST

• CGST

• SGST

• Other applicable tax details

Finally, identify:

• Matched invoices

• Missing invoices

• GSTIN differences

• Amount differences

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

You can perform this GSTR 2B reconciliation with books manually using Excel. However, for businesses and CA firms handling hundreds or thousands of purchase invoices, repeated formulas and manual checking can take significant time.

CAWork Suite provides a dedicated GSTR 2B reconciliation tool where you upload GSTR-2B and your Tally Purchase Register, automatically compare supported records, review missing and mismatched invoices and export the reconciliation report.

Disclaimer: GST information in this guide was reviewed in August 2026. This article is for educational purposes and is not tax or legal advice. GST rules and ITC conditions may change. Review material mismatches and applicable ITC conditions before claiming credit.