Bank Reconciliation is the process of matching the transactions recorded in Tally Prime with the transactions shown in your bank statement. It helps identify missing entries, incorrect amounts, duplicate transactions, and uncleared cheques, ensuring that your accounting records remain accurate.
Regular bank reconciliation is an essential accounting practice for businesses of all sizes.
What Is Bank Reconciliation?
Bank Reconciliation is the comparison of:
- Bank Ledger in Tally Prime
- Bank Statement issued by the bank
The objective is to ensure that both records match.
If differences exist, they should be identified and corrected.
Why Is Bank Reconciliation Important?
Bank reconciliation helps businesses:
- Verify bank balances
- Detect accounting errors
- Identify duplicate entries
- Track pending cheques
- Find missing transactions
- Improve financial accuracy
Monthly reconciliation is considered a best practice.
Common Reasons for Differences
Differences may occur due to:
- Cheques issued but not cleared
- Deposits not yet credited
- Bank charges
- Interest credited by the bank
- Direct bank payments
- Incorrect accounting entries
These differences should be reviewed carefully.
Steps to Perform Bank Reconciliation in Tally Prime
Step 1: Open Tally Prime
Launch Tally Prime and select the required company.
Step 2: Open Bank Reconciliation Report
Navigate to:
Display More Reports → Banking → Bank Reconciliation
The reconciliation report will appear.
Step 3: Select the Bank Ledger
Choose the bank account you want to reconcile.
Examples:
- HDFC Bank
- ICICI Bank
- SBI Current Account
The report displays all bank transactions.
Step 4: Compare with Bank Statement
Match each transaction with the bank statement.
Verify:
- Date
- Amount
- Voucher Number
- Transaction Reference
Ensure both records are consistent.
Step 5: Update Reconciliation Date
For matched transactions, enter the reconciliation date.
This marks the transaction as cleared.
Step 6: Review Unreconciled Entries
Check transactions that remain unmatched.
Examples:
- Uncleared Cheques
- Pending Deposits
- Missing Entries
Investigate and resolve these items.
Step 7: Save the Reconciliation
Press:
Ctrl + A
to save.
The bank reconciliation process is completed.
Example of Bank Reconciliation
Bank Ledger Balance:
₹5,20,000
Bank Statement Balance:
₹5,15,000
Difference:
₹5,000
Reason:
Cheque issued but not yet cleared.
After the cheque clears, both balances will match.
Common Unreconciled Transactions
Outstanding Cheques
Issued but not yet presented to the bank.
Deposits in Transit
Deposited but not yet credited by the bank.
Bank Charges
Deducted by the bank but not recorded in Tally Prime.
Interest Credits
Added by the bank but not yet entered in accounting records.
These items commonly cause reconciliation differences.
Reports Updated After Reconciliation
Bank reconciliation updates:
- Bank Reconciliation Report
- Bank Book
- Ledger Reports
- Financial Reports
These reports provide accurate banking information.
Benefits of Bank Reconciliation in Tally Prime
Accurate Bank Balances
Bank records remain reliable.
Better Fraud Detection
Unauthorized transactions can be identified quickly.
Improved Cash Flow Management
Businesses know the actual available funds.
Easier Financial Audits
Verified bank records support audit requirements.
Reduced Accounting Errors
Regular reconciliation improves accounting accuracy.
These benefits strengthen financial control.
Common Mistakes During Bank Reconciliation
Wrong Reconciliation Date
Transactions may appear pending incorrectly.
Ignoring Bank Charges
Ledger balances may remain inaccurate.
Duplicate Voucher Entries
Bank reports may become inconsistent.
Skipping Monthly Reconciliation
Differences may accumulate over time.
Always reconcile bank accounts regularly.
Best Practices for Bank Reconciliation
Follow these recommendations:
- Reconcile bank accounts every month
- Record bank charges promptly
- Verify transaction references carefully
- Review unreconciled items regularly
- Keep bank statements safely for future reference
These practices improve accounting reliability.
Difference Between Bank Book and Bank Reconciliation
Bank Book
Shows all bank transactions recorded in Tally Prime.
Bank Reconciliation
Compares the Bank Book with the actual bank statement to verify accuracy.
Both are essential for effective banking management.
Conclusion
Bank Reconciliation in Tally Prime helps businesses maintain accurate financial records by matching accounting entries with bank statements. Regular reconciliation identifies errors, tracks pending transactions, improves cash flow management, and supports reliable financial reporting. By performing bank reconciliation every month, businesses can strengthen financial control and ensure the accuracy of their accounting records.
