How to Reconcile GSTR-2B in TallyPrime: Step-by-Step Guide

Learn how to reconcile GSTR-2B in TallyPrime, identify missing invoices, fix GST mismatches, and verify eligible ITC before filing GSTR-3B.

 

How to Reconcile GSTR-2B in TallyPrime: Step-by-Step Guide

    Learn how to reconcile GSTR-2B in TallyPrime with this step-by-step guide. Understand invoice matching, missing purchase entries, GST mismatches, ITC verification, and reconciliation best practices before filing GSTR-3B.

How to Reconcile GSTR-2B in TallyPrime: Step-by-Step GST Reconciliation Guide

Managing GST returns becomes much easier when your purchase records match the details available on the GST portal. However, businesses often face differences between their purchase register and GSTR-2B. Some supplier invoices may be missing, GST amounts may not match, or certain transactions may appear in the wrong tax period.

This is where GSTR-2B reconciliation in TallyPrime becomes important.

GSTR-2B reconciliation helps you compare your purchase transactions recorded in TallyPrime with the Input Tax Credit (ITC) details reported by your suppliers on the GST portal. By identifying mismatches before filing GSTR-3B, you can reduce errors and avoid claiming incorrect ITC.

In this guide, you will learn how to reconcile GSTR-2B in TallyPrime, identify missing invoices, resolve GST mismatches, and maintain accurate purchase records.

What Is GSTR-2B Reconciliation?

GSTR-2B reconciliation is the process of comparing your business's purchase register with the GSTR-2B statement generated on the GST portal.

GSTR-2B is a monthly, auto-drafted ITC statement that contains information about eligible and ineligible input tax credit based on details reported by suppliers and other relevant records.

For example, suppose your business purchases goods worth ₹50,000 from a supplier and pays 18% GST.

Your purchase invoice contains:

ParticularsAmount
Taxable value₹50,000
CGST at 9%₹4,500
SGST at 9%₹4,500
Total invoice value₹59,000

If the supplier correctly uploads the invoice, the corresponding details should generally appear in your GSTR-2B.

If the invoice is missing or the GST amount is different, you need to investigate the difference before deciding whether the ITC can be claimed.

Why Is GSTR-2B Reconciliation Important?

Reconciliation is not just an accounting activity. It helps businesses maintain accurate GST records and avoid unnecessary tax complications.

Here are the main benefits:

  • Avoid incorrect ITC claims: Identify invoices that are missing from GSTR-2B before claiming credit.

  • Find supplier mistakes: Detect incorrect GSTINs, invoice numbers, taxable values, or tax amounts.

  • Identify missing purchase entries: Find invoices available in GSTR-2B but not recorded in TallyPrime.

  • Reduce GST filing errors: Prepare more accurate GSTR-3B returns.

  • Improve supplier communication: Share invoice mismatches with suppliers so they can investigate and correct reporting errors where permitted.

  • Maintain proper records: Keep reconciliation reports for future reference and GST verification.

Regular reconciliation also makes it easier to understand why your purchase register and available ITC figures do not match.

What You Need Before Starting GSTR-2B Reconciliation

Before beginning the reconciliation process in TallyPrime, keep the following information ready:

Required InformationPurpose
GSTR-2B JSON or Excel dataContains GST portal purchase and ITC information
TallyPrime purchase registerContains recorded purchase invoices
Supplier GSTINHelps identify the correct supplier
Invoice numberHelps match individual invoices
Invoice dateHelps verify transaction periods
Taxable valueHelps compare purchase amounts
CGST, SGST and IGSTHelps identify tax differences

Make sure your TallyPrime company has the correct GST registration details and that purchase vouchers contain accurate supplier and tax information.

How to Download GSTR-2B from the GST Portal

The first step is to download your GSTR-2B statement from the official GST portal.

Follow these steps:

Step 1: Open the GST Portal

Visit the official GST website:

https://www.gst.gov.in/

Log in using your GSTIN credentials.

Step 2: Open the Returns Dashboard

After logging in:

  1. Select Services.

  2. Go to Returns.

  3. Click Returns Dashboard.

  4. Select the relevant financial year.

  5. Choose the required return period.

Step 3: Open the GSTR-2B Statement

Find the GSTR-2B section for the selected month.

Open the statement and check the available ITC details.

Step 4: Download GSTR-2B Data

Download the available statement in the appropriate format, such as JSON or Excel, depending on the available portal options and the reconciliation method supported by your TallyPrime version.

Save the downloaded file in an easily accessible folder on your computer.

For example:

Documents/GST/GSTR-2B/November-2026

Keep separate files for each tax period to avoid confusion.

How to Reconcile GSTR-2B in TallyPrime

TallyPrime provides GST-related reporting and reconciliation facilities. The exact menu names and available import options may vary depending on your TallyPrime release and configuration.

Follow the general workflow below.

Step 1: Open Your Company in TallyPrime

Launch TallyPrime and select the company for which you want to reconcile GST records.

Make sure you have selected the correct GST registration.

Step 2: Open the GST Reports

Navigate to the GST reports section.

Depending on your TallyPrime version, you can access GST-related reports through:

  • Display More Reports

  • GST Reports

  • Returns and reconciliation reports

Look for the GSTR-2B reconciliation or related GST reconciliation option available in your release.

Step 3: Select the Reconciliation Period

Choose the month for which you want to reconcile purchase transactions.

For example:

  • October 2026

  • November 2026

  • December 2026

Always select the same tax period for your TallyPrime purchase register and downloaded GSTR-2B data.

Step 4: Import or Load GSTR-2B Data

If your TallyPrime release supports importing GSTR-2B data directly, select the appropriate import option and browse to the downloaded file.

Choose the correct file and complete the import process according to the on-screen instructions.

If direct import is not supported in your version, use the available supported reconciliation workflow or an appropriate spreadsheet-based comparison.

Step 5: Compare Purchase Records

Once the relevant data is available, compare your purchase register with the GSTR-2B statement.

Pay particular attention to:

  • Supplier GSTIN

  • Supplier name

  • Invoice number

  • Invoice date

  • Taxable amount

  • CGST amount

  • SGST amount

  • IGST amount

The purpose is to identify invoices that match completely and transactions that need further investigation.

Step 6: Review Reconciliation Differences

Check the reconciliation report for differences between your books and GSTR-2B.

Do not immediately change accounting entries just to make the figures match. First, identify the actual reason for each difference.

Step 7: Correct Errors Where Required

If you find an incorrect purchase entry, open the relevant voucher in TallyPrime and make the necessary correction after verifying the original invoice.

If the supplier has reported incorrect information, contact them and request appropriate correction through the GST return process.

Step 8: Generate the Final Reconciliation Report

After reviewing the differences, generate or save the reconciliation report.

Keep a copy for your GST records and use the verified figures when preparing your GSTR-3B return.

Common GSTR-2B Reconciliation Differences and Their Solutions

During reconciliation, you may find several types of mismatches. Understanding them helps you resolve problems faster.

DifferencePossible ReasonRecommended Action
Invoice missing in GSTR-2BSupplier has not reported the invoice or reporting is delayedContact the supplier and verify the reporting status
Invoice missing in TallyPrimePurchase voucher was not enteredVerify the invoice and record the transaction
GST amount mismatchIncorrect tax rate or calculationCheck the original invoice and voucher
Invoice number mismatchTyping error or different numbering formatVerify the invoice and correct the record if necessary
GSTIN mismatchIncorrect supplier GSTINVerify the supplier's GST registration details
Duplicate invoiceInvoice entered or reported more than onceCheck the original invoice and duplicate records
Different taxable valueData entry error, discount, or reporting differenceCompare the invoice and supplier's reported details

Remember that every mismatch does not automatically mean an accounting error. Some differences may arise because of reporting periods, amendments, credit notes, or other transaction-related adjustments.

Practical Example of GSTR-2B Reconciliation in TallyPrime

Let's understand the process with a simple business example.

Suppose ABC Traders purchases goods from three suppliers during November 2026.

Its purchase register contains the following entries:

SupplierTaxable ValueGSTTotal
Supplier A₹40,000₹7,200₹47,200
Supplier B₹30,000₹5,400₹35,400
Supplier C₹20,000₹3,600₹23,600
Total₹90,000₹16,200₹1,06,200

However, after checking GSTR-2B, the business finds that Supplier C's invoice is missing.

The comparison looks like this:

ParticularsPurchase RegisterGSTR-2B
Total taxable value₹90,000₹70,000
Total GST₹16,200₹12,600
Difference in taxable value—₹20,000
Difference in GST—₹3,600

In this situation, ABC Traders should:

  1. Verify whether Supplier C has uploaded the invoice correctly.

  2. Contact Supplier C to confirm the GST return reporting status.

  3. Check whether the invoice appears in a subsequent GSTR-2B or has been reported under another period.

  4. Review the applicable ITC conditions before claiming the credit.

The business should not claim the missing ₹3,600 of ITC merely because the purchase invoice is available in its accounting records.

This simple comparison demonstrates why monthly reconciliation is important.

How to Identify Missing Invoices in GSTR-2B

Missing invoices are among the most common reconciliation problems.

To identify them, compare your purchase register with the GSTR-2B statement using these details:

  • Supplier GSTIN

  • Invoice number

  • Invoice date

  • Taxable value

  • GST amount

For example, if your TallyPrime purchase register contains 100 invoices but only 92 corresponding invoices are found in GSTR-2B, investigate the remaining eight invoices.

Possible reasons include:

  • Suppliers have not filed their applicable returns.

  • Suppliers have uploaded invoices in a different tax period.

  • Invoice details contain errors.

  • The invoice has been reported under an incorrect GSTIN.

  • The transaction is not covered by the relevant GSTR-2B section.

Maintain a separate list of missing invoices and follow up with the respective suppliers.

How to Handle GST Amount Mismatches

Sometimes an invoice appears in both TallyPrime and GSTR-2B, but the GST amount does not match.

For example:

ParticularsTallyPrimeGSTR-2B
Taxable value₹25,000₹25,000
CGST₹2,250₹2,250
SGST₹2,250₹1,800
Total GST₹4,500₹4,050

Here, the SGST difference is ₹450.

Possible reasons include:

  • Incorrect tax calculation in the purchase voucher.

  • Supplier reporting error.

  • Incorrect GST rate.

  • Amendment to the original invoice.

  • Differences in the transaction details reported by the supplier.

Check the original tax invoice first. If your accounting entry is incorrect, correct the voucher. If the supplier's reporting is incorrect, request the supplier to review it.

Never adjust tax figures without supporting documents.

How to Check Eligible ITC Before Filing GSTR-3B

After completing reconciliation, review the ITC information carefully.

Not every amount appearing in GSTR-2B is automatically available for claiming.

Before claiming ITC, check:

  • Whether the purchase is related to business activities.

  • Whether you have a valid tax invoice or other prescribed document.

  • Whether the applicable conditions under Section 16 of the CGST Act are satisfied.

  • Whether the goods or services have been received, where applicable.

  • Whether the credit is blocked under Section 17(5).

  • Whether the supplier has reported the relevant invoice or document.

  • Whether the ITC has already been claimed or reversed.

  • Whether any applicable time limit or other statutory restriction applies.

Also review credit notes, debit notes, amendments, reverse charge transactions and other relevant sections separately.

Use the latest applicable GST rules and official instructions when determining the amount of ITC eligible for GSTR-3B.

Best Practices for Accurate GSTR-2B Reconciliation

Following a consistent monthly process can save considerable time and reduce accounting errors.

Reconcile Every Month

Do not wait until the end of the financial year. Reconcile GSTR-2B every month after the statement becomes available.

Enter Purchase Invoices Regularly

Record purchase transactions in TallyPrime as soon as the invoices are received.

Verify Supplier GSTINs

Check supplier GSTIN details before creating ledgers and entering purchase vouchers.

Follow Up on Missing Invoices

Maintain a supplier-wise list of missing invoices and contact suppliers regularly.

Maintain a Reconciliation Sheet

Keep records of matched invoices, missing invoices, mismatches and corrections.

Keep Original Invoices Safe

Store purchase invoices and supporting documents properly. They help resolve differences during GST verification.

Review ITC Before Filing Returns

Reconciliation should be completed before finalising GSTR-3B, with proper consideration of applicable ITC eligibility rules.

Conclusion

GSTR-2B reconciliation in TallyPrime is an important part of maintaining accurate GST accounts. It helps businesses compare purchase records with supplier-reported information, identify missing invoices, resolve tax differences and review Input Tax Credit before filing GSTR-3B.

The best approach is to perform reconciliation every month instead of waiting until the return filing deadline. Maintain proper purchase records, communicate with suppliers about missing invoices and verify every mismatch before making corrections.

With a consistent reconciliation process, managing GST records becomes more organised, accurate and less stressful.

Frequently Asked Questions (FAQs)

1. What is GSTR-2B reconciliation in TallyPrime?

It is the process of comparing purchase transactions recorded in TallyPrime with the ITC information available in GSTR-2B.

2. Can I import GSTR-2B JSON into TallyPrime?

Import options depend on your TallyPrime release and supported reconciliation features. Check the available GST import options in your version.

3. What should I do if an invoice is missing in GSTR-2B?

Contact the supplier, verify the invoice reporting status and check subsequent statements. Review ITC eligibility before claiming credit.

4. Why does GSTR-2B show a different GST amount?

Differences may occur due to incorrect tax rates, supplier reporting errors, amendments or data entry mistakes.

5. Should I reconcile GSTR-2B before filing GSTR-3B?

Yes. Reconciliation helps identify differences and review eligible ITC before filing GSTR-3B. However, ITC must always be claimed according to applicable GST provisions.

COMMENTS

Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content