TallyPrime GST Reconciliation: How to Match Books with GSTR-2B

Matching purchase records with GST portal data is an important part of regular accounting. Businesses need to review supplier invoices, purchase entries and available Input Tax Credit (ITC) information before preparing their GST returns.

TallyPrime GSTR-2B Reconciliation helps businesses compare transactions recorded in their books with the data available in GSTR-2B. It can help identify missing entries, mismatched details and transactions that need further review.

In this guide, we will explain what GSTR-2B reconciliation means, how to work with the reconciliation report in TallyPrime, and what businesses in Ludhiana can include in their regular GST review process.

What Is GSTR-2B?

GSTR-2B is an auto-drafted Input Tax Credit statement generated using information furnished by suppliers and other applicable sources. It provides document-level information that helps a registered taxpayer review ITC-related details for a tax period.

GSTR-2B is a read-only statement and is not a return that taxpayers need to file. Businesses should compare it with their own books and review ITC eligibility under the applicable GST provisions.

Why Is GSTR-2B Reconciliation Important?

Purchase entries in accounting books and information reflected in GSTR-2B may not always match. Differences can arise because of timing, data-entry errors, missing invoices or supplier reporting.

Reconciliation can help businesses to:

• Identify purchase invoices recorded in books but not appearing in the portal data.
• Find portal transactions that are not recorded in the books.
• Review differences in invoice number, date, taxable value or tax amount.
• Identify transactions appearing in different return periods.
• Maintain a record of transactions that need correction or follow-up.
• Support the review of ITC information before return preparation.

Before You Start GSTR-2B Reconciliation

Before opening the reconciliation report in TallyPrime, make sure the relevant company and GST details are available.

• Open the correct company in TallyPrime.
• Check the GST registration selected for reconciliation.
• Confirm that purchase vouchers for the relevant period are recorded.
• Keep the GSTR-2B data for the same registration and period ready.
• Check supplier ledgers, GSTIN/UIN details and invoice information.
• Keep supporting invoices and debit or credit notes available for review.

How to Reconcile GSTR-2B in TallyPrime

TallyPrime supports downloading GSTR-2B data from the GST portal or importing a downloaded data file. Once the data is available, you can open the GSTR-2B Reconciliation report and review the status of transactions.

Step 1: Download or Import GSTR-2B Data

To download data through TallyPrime, open Alt+Z (Exchange) > All GST Options > Download GST Returns. Configure the return type as GSTR-2B, select the required return period and proceed with the download.

If you have already downloaded the data from the GST portal, you can use the GST Returns import option in TallyPrime and select the applicable registration, return type and file.

Step 2: Open the GSTR-2B Reconciliation Report

Press Alt+G (Go To), search for GSTR-2B Reconciliation and open the report. Select the relevant GST registration and review period, if required.

Step 3: Review the Reconciliation Status

The report groups transactions by their reconciliation status. Depending on the data and report configuration, you may see categories such as:

• Reconciled: Transactions matched between books and portal data.
• Unreconciled: Transactions that still need review.
• Mismatched: Transactions where one or more details differ.
• Available Only in Books: Entries recorded in your books but not found in portal data.
• Available Only on Portal: Portal transactions not found in your books.
• Mismatch in Return Period: Transactions appearing under different periods.

Step 4: Check Mismatched Transactions

Open the mismatched section and review the differences shown for each transaction. Check invoice number, date, party GSTIN, taxable value and tax amount against the original purchase document.

If the difference is caused by an entry mistake, correct the underlying voucher or master after checking the supporting documents. Then review the reconciliation report again.

Step 5: Review Transactions Available Only on the Portal

These transactions appear in the portal data but are not found in your books. Check whether the invoice belongs to your business and whether it has been missed during purchase entry.

If the transaction is relevant, verify the invoice and record the appropriate entry in your books. If it is not relevant or appears to have been reported incorrectly, investigate it with the supplier and your tax professional before taking any action.

Step 6: Review Transactions Available Only in Books

A purchase entry may appear in your books but not in the downloaded GSTR-2B data. Check the supplier's reporting status, invoice details and applicable return period. Follow up with the supplier where necessary and keep a note of pending items.

Step 7: Review Return Period Differences

Sometimes an invoice recorded in one period may appear in portal data in another period. Compare the invoice date, accounting entry and supplier reporting period before updating any effective date or reconciliation status.

Step 8: Complete the Review and Keep Records

After reviewing each difference, maintain supporting notes and documents for corrections, supplier follow-ups and pending items. Reconciliation status should reflect the actual review performed; do not mark a transaction as reconciled only to clear a pending item from the report.

Common GSTR-2B Mismatches and What to Check

• Invoice number mismatch: Compare prefixes, suffixes, spaces, special characters and the number shown on the supplier invoice.
• GSTIN mismatch: Verify the supplier GSTIN in the invoice and party ledger.
• Taxable value difference: Compare the invoice value, taxable amount, discounts and accounting entries.
• Tax amount difference: Review the tax rate, tax type, rounding and voucher details.
• Invoice missing in books: Check whether the purchase document was received and entered.
• Invoice missing in GSTR-2B: Check supplier reporting and follow up with the supplier.
• Different return period: Compare the invoice date and period in which the supplier reported it.

Practical Monthly GSTR-2B Reconciliation Checklist

Businesses can use this checklist as part of their monthly accounting routine:

1. Confirm the GST registration and return period.
2. Record and review purchase vouchers for the period.
3. Download or import the relevant GSTR-2B data.
4. Open the GSTR-2B Reconciliation report in TallyPrime.
5. Review mismatched and unreconciled transactions.
6. Check invoices available only in books or only on the portal.
7. Follow up with suppliers for missing or incorrect details.
8. Review ITC eligibility separately under applicable GST rules.
9. Maintain supporting documents and a record of pending differences.

Important Checks Before Considering ITC

A transaction appearing in GSTR-2B does not, by itself, mean that ITC can automatically be claimed. Businesses should review the applicable GST conditions, restrictions and documentation for their specific transaction.

Also check that ITC is not claimed more than once, that any required reversal is considered, and that reverse charge liabilities are reviewed separately where applicable. Consult a qualified tax professional for transaction-specific decisions.

Frequently Asked Questions

Official References

• TallyHelp: Reconcile GSTR-2B Data in TallyPrime
• GST Portal: FAQs on Form GSTR-2B