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:
- Open Banking Activities: Press Alt+G > Banking Activities. Alternatively, use Gateway of Tally > Banking > Banking Activities. Select the relevant bank ledger.
- 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.
- Check the starting point: Confirm the bank ledger configuration, Reconciliation Beginning Date, and any Opening BRS entries before importing a statement.
- 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.
- 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.
- 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.
- 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?
| Task | Statement-based auto-reconciliation | Manual reconciliation |
|---|---|---|
| Input | Supported bank CSV/Excel statement, or a statement obtained through an eligible connection | Statement used as a reference to enter Bank Dates |
| Action | Review exact, potential, partial, and unreconciled entries | Alt+R (Manual Recon), compare entries, enter dates, and accept |
| Checks still needed | Validate linked transactions and investigate missing entries | Validate 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
- Confirm the bank ledger and statement period before you begin.
- Import the supported statement or obtain it through an eligible Connected Banking account.
- Review exact matches and check potential or partial matches before reconciling them.
- Investigate transactions available only in bank: identify legitimate charges or receipts and record the appropriate missing vouchers.
- Investigate transactions available only in books: check clearance, duplicates, ledger selection, and genuine timing differences.
- Review the summary balances and explain outstanding differences. Pending cheques do not need a fictitious clearing date.
- 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.