Mark IT Solutions

Bank Reconciliation in TallyPrime: BRS Steps

· Updated October 13, 2026
•
12 min read
•
Mark IT Solutions Team
Bank Reconciliation in TallyPrime: Step-by-Step Guide

A bank balance that looks right does not prove every transaction is recorded correctly. Month-end reconciliation is where you check which payments cleared, which receipts reached the bank, and which entries still need attention. This guide follows the current TallyPrime Banking Activities workflow and separates statement import, manual reconciliation, and Connected Banking.

What is Bank Reconciliation (BRS)?

A Bank Reconciliation Statement explains differences between your company’s bank ledger and the bank statement. Common causes include cheques awaiting clearance, deposits in transit, bank charges missing from the books, duplicate entries, and amounts posted to the wrong account.

Work through those differences rather than forcing every entry to reconciled status. A cheque that has genuinely not cleared can remain unreconciled; a missing bank charge needs an appropriate book entry. The purpose is an explained balance and a defensible transaction trail.

Bank reconciliation in TallyPrime: step-by-step workflow

Start with the bank account you actually want to reconcile. These seven steps take you from Banking Activities to the reconciliation report:

  1. Open Banking Activities: Press Alt+G > Banking Activities. Alternatively, use Gateway of Tally > Banking > Banking Activities. Select the relevant bank ledger.
  2. Open the summary and report: Press Enter on the transaction count under Bank Reconciliation to open Bank Reconciliation Summary, then drill down on Unreconciled Transactions to open the Bank Reconciliation report.
  3. Check the starting point: Confirm the bank ledger configuration, Reconciliation Beginning Date, and any Opening BRS entries before importing a statement.
  4. Import a supported statement: Use Alt+O (Import) > Bank Statement. Select the bank ledger, file path, supported file type, and CSV or Excel file. Preview the statement before completing the import. PDF statements and PDF files converted to CSV or Excel cannot be imported.
  5. Review matches: Check exact match, potential match, partial match, and unreconciled entries against the statement. Use F8 (Reconcile) for transactions that need reconciliation; confirm the corresponding entries before accepting the match.
  6. Use manual reconciliation when needed: From the Bank Reconciliation report, press Alt+R (Manual Recon). Enter the Bank Date from the statement against the relevant book transaction, then press Ctrl+A to accept the screen.
  7. Review balances and exceptions: Return to Bank Reconciliation Summary. Check Expected Bank Balance, Balance as per Bank Statement, and Difference; investigate missing entries and document legitimate timing differences.

The current report path is documented in TallyHelp’s bank reconciliation reports guide. Banking Activities gives the overview; Bank Reconciliation Summary shows balances and pending transactions; the bank-specific report is where you act on individual entries.

Before your first import: bank ledger and Opening BRS

In bank ledger creation or alteration, set Set/Alter Bank configuration to Yes, then open Set/Alter Auto Reconciliation configuration. Review the choices for identifying exact matches while importing statements or saving vouchers, and whether to reconcile exact matches automatically. Press Ctrl+A to save the configuration.

Confirm the Reconciliation Beginning Date and add earlier pending transactions as Opening BRS where needed. If you are switching from manual to auto-reconciliation, first reconcile transactions up to an agreed starting date. See TallyHelp’s setup instructions before changing an existing company’s configuration.

Statement import and auto-reconciliation

Download the statement from your bank in a supported CSV or Excel format. Support depends on the bank and statement format; a file extension alone is not enough. PDF statements and PDF files converted to CSV or Excel cannot be imported. A PDF can still be a reference for manual comparison.

Use Alt+O (Import) > Bank Statement. Select the bank ledger, specify the file path, choose File Type: Supported, select the file, and set Show Preview: Yes. Ensure the file is closed and the folder has write permission. Press Ctrl+A; in Bank Statement Preview, check the entries and press I (Import) to complete the import. Review the Summary of Imported Statement before continuing to reconciliation.

If the bank format is unavailable, use a supported download from the bank or contact Tally support about that format. Do not treat PDF conversion or arbitrary column changes as a supported import method. Refer to TallyHelp’s statement-import requirements.

  • Exact match: The bank and book entries meet the configured matching criteria. Exact matches can reconcile automatically when that configuration is enabled; check the outcome.
  • Potential match: TallyPrime proposes entries that need your review. Select the entry and use F8 (Reconcile) to check the corresponding transactions before confirming.
  • Partial match: The linked amounts do not fully settle the transaction. Review the remaining amount and relevant entries before completing reconciliation.
  • Unreconciled: No completed match exists yet. Investigate transactions available only in books or only in bank instead of accepting an unrelated match.

No fixed auto-match percentage is promised. References, amounts, missing vouchers, and the ledger configuration affect what can be matched. Use TallyHelp’s auto-reconciliation instructions for the match type you are reviewing.

Manual reconciliation: enter the Bank Date

From the Bank Reconciliation report, press Alt+R (Manual Recon). In Bank Reconciliation (Manual), compare each book transaction with your printed or PDF statement and enter the corresponding Bank Date. Press Ctrl+A to accept the screen. You are reconciling book transactions by bank date, rather than importing the PDF.

Check the account, amount, and reference before entering a date. Leave a transaction pending when the statement does not establish that it cleared. See TallyHelp’s manual reconciliation guide.

Connected Banking: eligibility and supported banks

Connected Banking lets eligible users get bank balances and statements from a connected account within TallyPrime. The current TallyHelp overview documents direct connectivity for Axis Bank, SBI (State Bank of India), and Kotak Mahindra Bank. Check the supported account/platform type for your bank before setup.

You need TallyPrime Release 6.0 or later, valid TSS, an active license, Tally.NET credentials, an internet connection, and a valid mobile number linked to your Tally.NET ID for OTP. Enable the connection and authenticate the bank account according to the bank’s flow.

Statement-import coverage is separate from direct bank connectivity. A bank may have a supported CSV/Excel statement format without offering a direct connection through Connected Banking. Getting a statement also does not remove the need to review matches and exceptions.

Use the official Connected Banking requirements and our Connected Banking guide. Our Tally support specialists can help check eligibility and configure reconciliation for your account.

Reviewing matching rules

Review the bank ledger’s auto-reconciliation configuration before relying on automatic exact matches. Keep transaction references and amounts accurate in the books. When several entries relate to one bank transaction, review all proposed links and any remaining amount in the matching screen. A potential or partial match still needs a decision; it is not proof that the transaction is fully reconciled.

Change the bank date, undo reconciliation, or remove a wrong match

Use F9 (Set Status) on the relevant book transaction in the Bank Reconciliation report to review its status and update the Bank Date from the statement. If a transaction was incorrectly marked reconciled through Set Status, choose System Inferred and accept the screen so TallyPrime can infer its status again. You can then reconcile it correctly.

A wrong linked bank entry requires a different action: open Modify Match for the reconciled transaction, select the corresponding bank transaction, and use F10 (Remove) to unlink it. Review and add the correct transaction before confirming the revised match. Removing the link does not delete the book voucher.

Check TallyHelp’s Set Status and Modify Match instructions before changing a completed reconciliation. Keep a record of why the bank date or match was corrected.

Auto vs manual reconciliation: which should you use?

TaskStatement-based auto-reconciliationManual reconciliation
InputSupported bank CSV/Excel statement, or a statement obtained through an eligible connectionStatement used as a reference to enter Bank Dates
ActionReview exact, potential, partial, and unreconciled entriesAlt+R (Manual Recon), compare entries, enter dates, and accept
Checks still neededValidate linked transactions and investigate missing entriesValidate dates and investigate missing entries

Our recommendation: Use supported statement import when it fits your bank’s format and your reconciliation setup. Use manual reconciliation when you need to enter dates from a statement. Choose on that basis rather than an arbitrary monthly transaction threshold.

Monthly bank reconciliation routine

  1. Confirm the bank ledger and statement period before you begin.
  2. Import the supported statement or obtain it through an eligible Connected Banking account.
  3. Review exact matches and check potential or partial matches before reconciling them.
  4. Investigate transactions available only in bank: identify legitimate charges or receipts and record the appropriate missing vouchers.
  5. Investigate transactions available only in books: check clearance, duplicates, ledger selection, and genuine timing differences.
  6. Review the summary balances and explain outstanding differences. Pending cheques do not need a fictitious clearing date.
  7. Save the reconciliation report and supporting statement with your month-end records. See our audit trail guide for related recordkeeping.

Current keyboard shortcuts for BRS

These actions depend on the screen you are in. For other tasks, see our TallyPrime shortcut guide.

  • Alt+G > Banking Activities: Open the banking overview.
  • Alt+O (Import) > Bank Statement: Start statement import.
  • F8 (Reconcile): Review and reconcile transactions where this action is offered.
  • Alt+R (Manual Recon): Open manual reconciliation from the Bank Reconciliation report.
  • F9 (Set Status): Set the status and Bank Date of the selected book transaction; use System Inferred to undo an incorrectly set reconciled status.
  • F10 (Remove): Unlink the selected bank transaction in Modify Match.
  • Ctrl+A: Accept the manual reconciliation screen or save the relevant configuration.

Check your reconciliation setup before an upgrade

If you are moving an existing company to a newer TallyPrime installation, review the bank ledger configuration, Opening BRS, and Reconciliation Beginning Date before continuing. Do not assume a change of release reconciles old pending entries. Our TallyPrime upgrade options and version history cover broader upgrade questions; this guide follows the current reconciliation workflow.

How to read the Bank Reconciliation Summary

Compare Expected Bank Balance with Balance as per Bank Statement and review the Difference. Also check transactions available only in books, available only in bank, and entries reconciled in a subsequent period. Make sure the statement date and report period are appropriate before treating a balance as final.

Missing Opening BRS entries or transactions before the configured beginning date can affect the summary. Review the setup and report settings first. For related reporting, see business reports in TallyPrime.

Common BRS errors and what to check

  • Opening balance difference: Check prior pending entries, Opening BRS, and the reconciliation beginning date, especially after data migration or import.
  • Suspected duplicate voucher: Trace the entry and verify the source document before making any correction. Our Edit Log guide explains the related change history.
  • Wrong bank ledger: Check the account used in the voucher and the statement selected for reconciliation.
  • Missing charge or receipt: Confirm the statement entry, record the appropriate voucher, and then match it.
  • Partial or wrong match: Check the linked entries and remaining amount; use Modify Match for an incorrect link.
  • Statement will not import: Confirm the bank’s supported CSV/Excel format, close the file, and check folder permission. PDF conversion is not a supported fix.

Related concepts: bank reconciliation, bank book, and daybook. For ongoing month-end help, see our Tally AMC plans. You can also read about payment integration and TallyPrime 7.0 features.

Last verified: 2026-10-13 against the linked TallyHelp setup, statement-import, reconciliation-report, manual, auto, and Connected Banking documentation. Author: Mark IT Solutions Team, 5-Star Certified Tally Partner based in Mumbai.

Frequently Asked Questions

What is BRS in TallyPrime?

BRS (Bank Reconciliation Statement) compares transactions in your bank ledger with your bank statement. Open Alt+G > Banking Activities, drill down to Bank Reconciliation Summary, and select the relevant bank ledger/report to review matches and differences.

How to import bank statement in TallyPrime?

Use Alt+O (Import) > Bank Statement. Select the bank ledger and a CSV or Excel statement in a supported bank format, preview it, and complete the import. PDF statements and PDF files converted to CSV or Excel cannot be imported.

What is the shortcut key for bank reconciliation in TallyPrime?

Use Alt+G > Banking Activities to start. From Banking Activities, open Bank Reconciliation Summary and the required bank report. F8 (Reconcile) acts on transactions needing reconciliation; Alt+R (Manual Recon) opens manual reconciliation from the Bank Reconciliation report.

How do I change the bank date or undo reconciliation?

Select the relevant transaction in the Bank Reconciliation report and use F9 (Set Status) to review or update its Bank Date. To undo an incorrectly set reconciled status, choose System Inferred and accept the screen. For a wrong linked match, open Modify Match and use F10 (Remove) to unlink the selected bank transaction, then review the correct match.

Which banks support Connected Banking in TallyPrime?

TallyHelp documents direct connectivity for Axis Bank, SBI (State Bank of India), and Kotak Mahindra Bank. Connected Banking requires TallyPrime Release 6.0 or later, valid TSS, an active license, Tally.NET credentials, internet access, and a mobile number for OTP. Statement-import coverage is separate from direct bank connectivity.

Can I reconcile multiple bank accounts?

Yes. Select the relevant bank ledger in Banking Activities or the reconciliation reports and reconcile each account against its own statement. Check supported statement formats and Connected Banking eligibility separately for each bank account.

What happens to unreconciled transactions in data split?

TallyHelp describes unreconciled transactions from books and bank as Opening BRS in the company created after the split date. Review the Opening BRS entries and Reconciliation Beginning Date before continuing reconciliation in the new company.

What is the difference between auto and manual bank reconciliation?

Auto-reconciliation compares supported imported bank statement entries with book transactions and identifies matches for review. Manual reconciliation uses Alt+R (Manual Recon) from the Bank Reconciliation report so you can enter Bank Dates against book transactions from your statement. Both methods require you to investigate remaining differences.

Need Connected Banking Setup?

Want Mark IT's team to set up Connected Banking and auto-reconciliation for your business? We handle the entire configuration -- call 022 6199 2222.

Contact Us
Mark IT Solutions Team

About Mark IT Solutions Team

With over 20 years of experience, Mark IT Solutions is a certified 5-star Tally partner in Mumbai. We specialize in TallyPrime implementation, customization, training, and support for businesses across India.

Share this article

Need help choosing the right Tally setup?

If you are evaluating plans, renewal, cloud migration, or support, use these quick decision pages: