Maintaining accurate financial records is essential for business managers, accountants, and finance professionals across India. A common challenge in daily accounting is matching the bank balances recorded in your books with the actual bank passbook statement. Learning bank reconciliation statement (brs) step by step in tally prime allows accountants to quickly identify missing entries, track uncleared cheques, catch unauthorized transactions, and maintain audit-ready ledgers.
As businesses expand across economic hubs such as Delhi-NCR, Mumbai, Bengaluru, Mohali, and Chandigarh, automating routine financial tasks using robust software like Tally Prime becomes critical. Accounting Sikho brings you this comprehensive, practical tutorial to help you streamline bank reconciliations seamlessly using auto-reconciliation and manual matching features.
What is a Bank Reconciliation Statement (BRS) and Why is it Necessary?
A Bank Reconciliation Statement (BRS) is an accounting report that explains the difference between the bank balance shown in an organization’s cash book (bank ledger) and the balance shown in the bank passbook.
Differences usually arise due to timing discrepancies, bank charges, direct deposits by customers, or uncollected cheques.
┌────────────────────────────────────────────────────────────────────────┐
│ PRIMARY CAUSES OF BRS DIFFERENCES │
├───────────────────┬───────────────────┬────────────────────────────────┤
│ Cheques Issued │ Cheques Deposited │ Direct Debits & Bank Charges │
│ (Not yet cleared) │ (Not yet credited)│ (Processed directly by bank) │
└───────────────────┴───────────────────┴────────────────────────────────┘
Mastering bank reconciliation statement (brs) step by step in tally prime gives accounting professionals at Accounting Sikho three key operational benefits:
Error Prevention: Spots double entries, missing transaction vouchers, and transposition errors immediately.
Fraud Control: Detects unauthorized bank charges, unrecorded withdrawals, or suspicious transactions before monthly closing.
Optimized Cash Flow Visibility: Provides real-time insights into actual available bank balances versus expected Uncleared Funds.
Key Reconciling Features Built Into Tally Prime
Tally Prime simplifies traditional manual reconciliation with smart, automated utilities designed for modern commerce.
| Tally Prime Feature | Functionality | Primary Advantage |
| Auto Bank Reconciliation | Imports electronic bank statements (e-Statements) directly into Tally Prime | Reconciles hundreds of transactions in seconds with automated matching algorithms |
| Manual Reconciliation | Allows manual input of bank dates alongside ledger voucher dates | Offers complete control when handling un-supported bank formats |
| Reconciliation Analysis Screen | Filters un-reconciled, reconciled, or all transactions on demand | Simplifies monthly audit readiness and reporting |
| Re-link Vouchers | Matches imported bank entries directly to existing un-posted vouchers | Prevents duplicate voucher creation during high-volume periods |
Performing Bank Reconciliation Statement (BRS) Step by Step in Tally Prime
Follow this clear, structured workflow designed by the expert instructors at Accounting Sikho to reconcile your bank ledger accurately.
Common Reasons for Differences During BRS in Tally Prime
Even after completing bank reconciliation statement (brs) step by step in tally prime, small discrepancies may persist. Accounting Sikho recommends checking for these standard issues:
Cheques Issued but Not Presented: Cheques written to vendors that haven’t been cashed yet.
Cheques Deposited but Not Cleared: Customer cheques deposited into your account that remain in clearing.
Direct Bank Charges & Interest: Nominal fees deducted or interest credited by the bank without prior voucher entries.
Incorrect Instrument Numbers: Typos in cheque numbers or UTR reference numbers that prevent Auto BRS from matching entries automatically.
┌──────────────────────────────┐
│ ACCOUNTING SIKHO BRS FLOW │
└──────────────┬───────────────┘
│
┌────────────────────────┼────────────────────────┐
▼ ▼ ▼
Fetch Bank Ledger Input / Import Passbook Adjust Differences
(Tally Prime Workspace) (Manual / Auto-BRS) (Post Bank Charges)
Advanced Shortcuts and Best Practices from Accounting Sikho
To boost your productivity and ensure flawless financial books, implement these practical tips during your daily work:
Daily or Weekly Reconciliation: Avoid leaving BRS until the end of the month or quarter. Reconciling weekly keeps your cash flow reports reliable.
Keyboard Shortcuts: Use
F12on the BRS screen to configure options such as showing detailed vouchers, displaying narration, or filtering cleared transactions.Audit Trail Integration: Always maintain digitized backup copies of your bank statements alongside reconciled Tally data to ensure quick audit sign-offs.
Boost Your Accounting Career with Accounting Sikho
Mastering modern tools like Tally Prime gives finance professionals a competitive edge in today’s job market. Accounting Sikho is dedicated to bringing practical, industry-standard accounting tutorials to students, freelancers, and working accountants across India. By adopting structured approaches to bank reconciliations, GST management, and payroll accounting, you ensure your business ledgers remain accurate, reliable, and audit-ready at all times.
Frequently Asked Questions (FAQs)
What is the shortcut key to access Bank Reconciliation in Tally Prime?
You can access Bank Reconciliation by going to Gateway of Tally > Banking > Bank Reconciliation, or by pressing Alt + G (Go To), typing Bank Reconciliation, and selecting your specific bank ledger.
How does auto bank reconciliation work in Tally Prime?
Auto bank reconciliation lets you import electronic bank statements (e-Statements in Excel, CSV, or MT940 format) directly into Tally Prime. The software automatically matches transaction amounts and instrument numbers with your posted vouchers, saving significant manual entry time.
Why does my bank balance in Tally Prime not match my passbook balance?
Discrepancies usually happen due to uncleared cheques (issued or deposited), unrecorded bank charges, direct customer deposits, or incorrect instrument numbers entered during voucher creation. Performing bank reconciliation statement (brs) step by step in tally prime helps clear these differences.
Can I create missing vouchers directly from the BRS screen in Tally Prime?
Yes! If you spot unrecorded transactions like bank charges or interest credited while reviewing your bank statement, press Alt + J (Create Voucher) directly from the BRS screen to post the missing entry immediately.