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

GSTR-2B reconciliation helps you compare purchase transactions recorded in your books with the invoices and credit notes reported by your suppliers on the GST portal. This guide explains how to download or import GSTR-2B data, review differences, and resolve common exceptions in TallyPrime.

What is GSTR-2B?

GSTR-2B is a static, system-generated statement of eligible and ineligible input tax credit based on supplier returns such as GSTR-1, GSTR-5, and GSTR-6. It is generated for a return period and should be compared with your purchase records before claiming input tax credit.

Always verify the applicable GST rules and eligibility with your tax professional. This article explains the TallyPrime workflow and is not a substitute for professional tax advice.

Before you start

• Keep your TallyPrime company data updated and take a backup.
• Confirm that the correct GST registration is configured in the company.
• Download the required GSTR-2B period from the GST portal, or keep the Excel/JSON file ready for import.
• Use a TallyPrime release that supports the GSTR-2B reconciliation features described below.

Step 1: Download GSTR-2B directly into TallyPrime

1. Press Alt+Z (Exchange) and select All GST Options > Download GST Returns.
2. Press C (Configure).
3. Set Return Type to GSTR-2B and select the return period.
4. Press D (Download). If required, sign in to the GST portal and complete the OTP step.
5. After download, open the GSTR-2B Reconciliation report.

Step 2: Import a GSTR-2B file manually

1. Press Alt+O (Import) > GST Returns.
2. Select the GST registration and set Return Type to GSTR-2B.
3. Select the downloaded Excel or JSON file.
4. Press Ctrl+A to accept and review the Import Summary.

Step 3: Open the GSTR-2B Reconciliation report

Press Alt+G (Go To), search for GSTR-2B Reconciliation, and open the report. TallyPrime groups transactions into useful sections such as Reconciled, Unreconciled, Mismatched, Available Only in Books, Available Only on Portal, Mismatch in Return Period, Excluded, and Uncertain Transactions.

Use F3 (Company/Tax Registration) when you need to switch between GST registrations. Use Ctrl+H (Change View) to switch between reconciliation statistics and voucher statistics.

Step 4: Resolve common differences

Invoice available only on the portal

Check whether the purchase invoice was missed in the books. Use the portal view to verify the supplier, invoice number, date, taxable value, and tax amount. Record the correct purchase transaction in TallyPrime, if applicable, and then review the reconciliation status.

Invoice available only in books

Check whether the supplier has filed the return for the relevant period. Verify the supplier GSTIN, invoice number, invoice date, and GST amounts in your books. Follow up with the supplier when the document is missing from GSTR-2B.

Mismatch in invoice number or document date

Small differences caused by prefixes, suffixes, spaces, or typing errors can create a mismatch. Review the portal document and correct the voucher details in the books. TallyPrime also provides options to copy the document number and date from the portal view where applicable.

Mismatch in return period

If the supplier reported the document in a different period, review the transaction and set the appropriate GST Return Effective Date after confirming the correct treatment.

Taxable value or tax amount mismatch

Compare the purchase voucher with the supplier document. Do not mark a transaction as reconciled merely to remove an exception. Correct the underlying voucher or investigate the supplier filing. For minor differences such as permitted rounding differences, use the reconciliation configuration only after reviewing the business and tax impact.

Incorrect GSTIN or section

Correct the party GSTIN/UIN or voucher classification when the mismatch is caused by a data-entry error. If the transaction is not related to your business, exclude it only after documenting why it should not be considered.

Step 5: Recompute GSTR-2B when required

You may need to recompute GSTR-2B after changes to IMS actions, purchase invoices, GST effective dates, or input tax credit availability. Use Alt+Z (Exchange) > All GST Options > Recompute GSTR-2B, select the GST registration and period, and choose R (Recompute). After the process completes, download the latest GSTR-2B data and review the reconciliation report again.

Best practices before claiming ITC

• Do not claim the same document twice.
• Investigate invoices that are missing from GSTR-2B or present only in the books.
• Review blocked or ineligible ITC separately.
• Keep supplier follow-up records for missing or incorrect invoices.
• Maintain a backup and an audit trail before making bulk corrections.

Related TallyPrime guides

For related workflows, read our TallyPrime bank reconciliation guide and our earlier guide on resolving GST voucher mismatches.

Conclusion

GSTR-2B reconciliation in TallyPrime is most effective when you review exceptions systematically: download the correct period, compare books with the portal, correct genuine errors, document supplier issues, and recompute the data when GST or IMS changes affect ITC availability.

Menu names and features can vary by TallyPrime release. Test changes on a backup company and confirm tax treatment with a qualified professional before filing returns.

Official TallyHelp reference: Reconcile GSTR-2B Data in TallyPrime

TallyPrime Bank Reconciliation: A Practical Step-by-Step Guide

Bank reconciliation is one of the simplest ways to catch missing entries, duplicate postings and timing differences before they become accounting problems. In TallyPrime, you can compare your book balance with the bank statement and investigate unmatched transactions in a structured way.

This guide explains a practical workflow for bank reconciliation in TallyPrime. Menu names can vary slightly by release and configuration, so use the equivalent Bank Reconciliation or Banking report available in your installation.

What is bank reconciliation?

Bank reconciliation is the process of comparing the bank balance recorded in your company books with the balance shown by the bank. The two balances may differ because of cheques in transit, direct bank charges, deposits not yet credited, bank interest, or entries that have not been recorded in TallyPrime.

A regular reconciliation helps you:

• find missing receipts and payments;
• identify duplicate or wrongly dated vouchers;
• separate genuine timing differences from accounting errors;
• keep cash-flow reports more reliable; and
• prepare cleaner records for month-end review.

Before you begin

Keep the following ready:

• the latest bank statement in PDF, Excel or another format supported by your process;
• the correct bank ledger in TallyPrime;
• the statement period and closing balance; and
• details of pending cheques, deposits and bank charges.

Take a backup of the company data before making a large batch of corrections. If multiple users work in the same company, coordinate the reconciliation period so that new vouchers do not make the report confusing while you are reviewing it.

Step-by-step bank reconciliation in TallyPrime

1. Open the bank reconciliation report

Open the relevant company and go to the Banking or Display reports area. Select the bank ledger and open the Bank Reconciliation report. In some releases, you can reach the report from the ledger or from the Banking menu.

2. Select the correct bank ledger and period

Choose the exact ledger linked to the bank account you want to review. Set the date range to match the bank statement. Working one month at a time is usually easier than trying to reconcile a full year in a single pass.

3. Enter or import the bank statement details

Depending on your TallyPrime release and bank setup, you may be able to import statement data or enter the relevant transaction details in the reconciliation view. Check the date, amount, transaction type and reference before accepting a match.

Do not match a transaction only because the amount is identical. Confirm the date range, narration, cheque number, reference number or other identifying detail as well.

4. Match cleared transactions

Mark the transactions that have cleared the bank. Receipts deposited into the bank and payments made by cheque should be matched only when they appear in the statement. A voucher can be recorded in the books before the bank processes it, so the book date and clearance date may be different.

5. Review unmatched transactions

Group the unmatched items into practical categories:

• cheques issued but not yet presented;
• deposits recorded in books but not yet credited;
• bank charges or interest missing from TallyPrime;
• direct credits or debits made by the bank;
• wrong dates, amounts or bank references; and
• entries that belong to another bank account or company.

6. Record genuine missing entries

If the bank statement contains a legitimate charge, interest entry or direct debit that is missing from the books, record the appropriate voucher after checking the supporting document. Use the correct expense, income or party ledger and add a clear narration.

For corrections, avoid deleting a voucher just to force the report to match. Reverse or alter it according to your internal accounting policy, retain the audit trail, and document the reason for the change.

7. Verify the reconciled balance

After matching and recording missing entries, compare the reconciled balance with the bank statement closing balance. Investigate any remaining difference instead of carrying it forward without an explanation.

Common reasons for a difference

Difference	Likely reason	What to check
Payment in books, absent in statement	Cheque or transfer is pending	Cheque number, bank date and outstanding list
Credit in statement, absent in books	Direct receipt or bank transfer	Bank reference, customer and remittance advice
Small unexplained debit	Bank charge or tax on charge	Statement narration and bank advice
Same amount appears twice	Duplicate voucher or duplicate import	Voucher number, date and reference
Balance differs after matching	Opening balance, date or amount error	Previous reconciliation and ledger entries

Practical tips for faster reconciliation

1. Reconcile weekly for high-volume bank accounts and at least monthly for other accounts.
2. Use a consistent narration format, such as bank reference plus party name.
3. Keep a short pending-items list with an owner and expected clearance date.
4. Review old unreconciled cheques instead of allowing them to remain indefinitely.
5. Restrict back-dated edits after month-end review and record approved exceptions.
6. Reconcile each bank ledger separately; do not combine accounts just to make the balance appear correct.

Tally.ERP 9 and TallyPrime: what changes?

The exact screens and banking features differ between Tally.ERP 9 and TallyPrime. The accounting principle remains the same: compare the book entry with the bank evidence, record legitimate missing transactions, and explain timing differences. If you are upgrading an older company, confirm that bank ledgers, opening balances and prior reconciliation information have migrated correctly before starting a new period.

Frequently asked questions

Can I reconcile a bank account without importing a statement?

Yes. You can review the bank ledger and mark or enter reconciliation details manually when your release or bank workflow does not support statement import.

Why is a cheque still unreconciled even though it was entered?

Entering a cheque voucher records it in the books. It becomes reconciled only after it clears the bank or after you enter the correct clearance information.

Should I change the voucher date to match the bank date?

Not automatically. The voucher date should reflect the underlying transaction and your accounting policy. Use the reconciliation or clearance details for timing differences, and change a voucher date only when it is genuinely incorrect and the change is properly approved.

Final checklist

• Correct company and bank ledger selected
• Statement period matches the report period
• Opening and closing balances checked
• Cleared transactions matched using references
• Bank charges and direct credits recorded
• Old unreconciled items reviewed
• Backup and review completed

Conclusion: Bank reconciliation works best as a routine control, not as a year-end emergency. A short weekly or monthly review in TallyPrime can reveal errors early and give you a more dependable view of available cash.

Note: This article is for general software and bookkeeping guidance. Always verify the workflow with your accountant and the documentation for your installed Tally release.