Bank Reconciliation (BRS) is the process of comparing the transactions recorded in Tally Prime with the transactions shown in the bank statement. It helps identify unmatched transactions and ensures that the bank balance is accurate.
Lesson Objective
Learn how to perform Bank Reconciliation in Tally Prime, identify differences between the Cash Book and Bank Statement, reconcile transactions, and generate reconciliation reports.
1. What is Bank Reconciliation?
Bank Reconciliation is the process of matching the transactions recorded in the company's books with the transactions appearing in the bank statement.
Book Balance
Bank Statement
Transactions recorded in Tally.
Transactions processed by the bank.
Updated immediately after voucher entry.
Updated after bank processing.
May contain pending entries.
Shows cleared transactions.
Bank Reconciliation ensures that both balances agree after accounting for timing differences and corrections.
2. Why is Bank Reconciliation Important?
Detects missing transactions.
Identifies bank charges and interest.
Finds duplicate entries.
Tracks outstanding cheques.
Verifies deposits in transit.
Improves financial accuracy.
Supports auditing.
Maintains correct bank balances.
Regular Bank Reconciliation helps prevent accounting errors and improves financial control.
3. Common Reasons for Differences
Reason
Explanation
Outstanding Cheque
Cheque issued but not yet presented to the bank.
Deposit in Transit
Deposit recorded in books but not yet credited by the bank.
Bank Charges
Charges deducted by the bank but not yet recorded.
Interest Credited
Interest added by the bank but not yet recorded.
Data Entry Error
Incorrect amount or duplicate entry in books.
Most reconciliation differences are due to timing differences or unrecorded bank transactions.
4. Benefits of Bank Reconciliation
Maintains accurate bank balances.
Improves fraud detection.
Helps identify accounting mistakes.
Ensures reliable financial statements.
Supports month-end and year-end closing.
Improves cash management.
Simplifies auditing.
Builds confidence in financial reports.
Businesses should reconcile their bank accounts regularly—weekly or monthly, depending on transaction volume.
5. Bank Reconciliation Workflow
Create and maintain a Bank Ledger.
Record all bank transactions.
Collect the bank statement.
Open the Bank Reconciliation report.
Match each transaction.
Record any missing entries such as bank charges or interest.
Verify that balances agree.
Save the reconciliation.
A disciplined reconciliation process helps keep accounting records complete and accurate.
6. Steps to Perform Bank Reconciliation in Tally Prime
Bank Reconciliation in Tally Prime allows you to match transactions recorded in your books with those appearing in the bank statement by updating the bank date for each transaction.
Steps
Open Tally Prime.
Go to Display More Reports → Banking → Bank Reconciliation.
Select the required Bank Ledger.
Choose the reconciliation period.
Compare each voucher with the bank statement.
Enter the Bank Date for cleared transactions.
Leave uncleared transactions blank.
Verify that the reconciled balance matches the bank statement.
Press Ctrl + A to save.
Example
Voucher No.
Book Date
Bank Date
Status
RV-001
05-04-2026
06-04-2026
Cleared
PV-015
08-04-2026
-
Pending
Only enter the Bank Date after confirming that the transaction appears in the official bank statement.
7. Outstanding Cheques & Deposits in Transit
Outstanding transactions are the most common reason for differences between the Cash Book and the Bank Statement.
Item
Description
Outstanding Cheque
Cheque issued but not yet presented to the bank.
Deposit in Transit
Cash or cheque deposited but not yet credited by the bank.
Pending NEFT/RTGS
Electronic transfer initiated but not yet processed.
Pending UPI Receipt
Receipt recorded but settlement is pending.
Example
Transaction
Book
Bank
Cheque Issued ₹25,000
Recorded
Not Cleared
Cash Deposit ₹40,000
Recorded
Pending Credit
Outstanding transactions should remain unreconciled until they appear in the bank statement.
8. Recording Bank Charges & Interest
Banks may debit charges or credit interest directly to the account. These entries must also be recorded in Tally Prime.
Transaction
Accounting Treatment
Bank Charges
Debit Bank Charges Account, Credit Bank Ledger.
Interest Received
Debit Bank Ledger, Credit Interest Income Account.
Interest Paid
Debit Interest Expense Account, Credit Bank Ledger.
SMS/Service Charges
Record as Bank Charges.
Example
Bank Statement Entry
Amount
Bank Charges
₹250
Interest Credit
₹1,500
Always record bank-generated transactions before completing the reconciliation process.
9. Bank Reconciliation Report & Verification
The Bank Reconciliation Report helps verify whether all bank transactions have been matched correctly.
Report Section
Purpose
Reconciled Transactions
Shows cleared entries.
Unreconciled Transactions
Shows pending entries.
Book Balance
Balance as per Tally.
Bank Balance
Balance as per Bank Statement.
Difference
Shows unreconciled amount.
Verification Checklist
Verify every receipt.
Verify every payment.
Check cheque clearance dates.
Record bank charges.
Record bank interest.
Review pending transactions.
The reconciliation is considered complete when all valid transactions have been reviewed and the remaining differences are explained by legitimate outstanding items.
10. Common Bank Reconciliation Mistakes
Common Mistake
Correct Practice
Wrong Bank Date entered.
Use the actual clearing date from the bank statement.
Ignoring bank charges.
Record all charges immediately.
Ignoring interest entries.
Record interest income or expense promptly.
Duplicate voucher entry.
Review vouchers before saving.
Reconciling without bank statement.
Always reconcile using the official statement.
Incorrect amount entered.
Compare voucher with bank records carefully.
Ignoring pending cheques.
Leave them unreconciled until cleared.
Not reviewing the reconciliation report.
Verify all matched and unmatched entries before closing.
A careful reconciliation process improves financial accuracy, detects errors early and strengthens internal financial control.
11. Real Business Case Studies
Let's understand how Bank Reconciliation is used in different businesses to ensure that accounting records match the bank statement.
Business
Reconciliation Activity
Purpose
Retail Shop
Daily Cash Deposits
Verify that daily deposits are credited by the bank.
Manufacturing Company
Supplier Payments
Track cheque clearance and bank transfers.
School / College
Student Fee Collection
Match online fee receipts with the bank statement.
Hospital
Patient Payments
Verify UPI, cheque and bank transfer collections.
Software Company
Salary & Vendor Payments
Confirm salary transfers and vendor payments.
Wholesale Distributor
Customer Collections
Track NEFT, RTGS and cheque realizations.
Regular Bank Reconciliation improves financial accuracy, detects missing transactions and strengthens internal controls.
12. Complete Bank Reconciliation Checklist
Checklist Item
Status
Bank Statement Collected
✔
Receipt Vouchers Verified
✔
Payment Vouchers Verified
✔
Outstanding Cheques Reviewed
✔
Deposits in Transit Verified
✔
Bank Charges Recorded
✔
Interest Entries Recorded
✔
Duplicate Entries Checked
✔
Bank Dates Updated
✔
Reconciliation Report Reviewed
✔
Book Balance Matched
✔
Bank Balance Confirmed
✔
Complete this checklist every month before closing your books to maintain accurate bank records.
13. Professional Bank Reconciliation Best Practices
Perform Bank Reconciliation at least once every month.
For businesses with many transactions, reconcile weekly or daily.
Record bank charges and interest immediately after receiving the statement.
Use the actual clearing date while updating the Bank Date.
Review all pending cheques regularly.
Investigate unmatched transactions immediately.
Keep supporting documents such as bank statements and deposit slips.
Use proper narrations in all bank vouchers.
Review the Bank Book before reconciliation.
Take regular backups of Tally Prime data.
Professional accountants perform Bank Reconciliation regularly because it improves cash management, strengthens internal controls and reduces accounting errors.
14. Practical Exercise & Interview Questions
Practical Exercise
Create a Bank Ledger.
Record one Bank Receipt Voucher.
Record one Bank Payment Voucher.
Open the Bank Reconciliation Report.
Update the Bank Date for cleared transactions.
Record bank charges from the bank statement.
Record interest credited by the bank.
Complete the reconciliation and verify the balance.
Interview Questions
What is Bank Reconciliation?
Why is Bank Reconciliation important?
How do you open the Bank Reconciliation Report in Tally Prime?
What is the purpose of the Bank Date?
What is an Outstanding Cheque?
What is a Deposit in Transit?
Why do differences arise between the Cash Book and Bank Statement?
How are bank charges recorded?
How is bank interest recorded?
When should the Bank Date be entered?
Can reconciliation be done without a bank statement?
What reports should be checked before reconciliation?
How do you identify duplicate transactions?
How often should Bank Reconciliation be performed?
What happens if reconciliation is not done regularly?
Why should pending transactions be reviewed?
How does Bank Reconciliation help during audits?
How does Tally Prime simplify reconciliation?
What precautions should be taken before saving reconciliation?
Why is Bank Reconciliation important for accountants?
15. Lesson Summary
Learned the concept of Bank Reconciliation (BRS).
Understood why differences occur between books and bank statements.
Performed Bank Reconciliation in Tally Prime.
Reviewed Outstanding Cheques and Deposits in Transit.
Recorded Bank Charges and Interest.
Verified the Bank Reconciliation Report.
Studied real business examples.
Completed practical exercises.
Prepared for banking and accounting interviews.
Built a strong foundation for Bank Reconciliation.
Congratulations!
You can now confidently perform Bank Reconciliation (BRS) in Tally Prime, identify differences between book and bank balances, record missing bank transactions and maintain accurate financial records.
🧠 Quick Quiz
Which date is entered in the Bank Reconciliation screen after a transaction appears in the bank statement?