Bank reconciliation is one of the simplest ways to catch missing entries, duplicate postings and timing differences before they become accounting problems. In TallyPrime, you can compare your book balance with the bank statement and investigate unmatched transactions in a structured way.
This guide explains a practical workflow for bank reconciliation in TallyPrime. Menu names can vary slightly by release and configuration, so use the equivalent Bank Reconciliation or Banking report available in your installation.
What is bank reconciliation?
Bank reconciliation is the process of comparing the bank balance recorded in your company books with the balance shown by the bank. The two balances may differ because of cheques in transit, direct bank charges, deposits not yet credited, bank interest, or entries that have not been recorded in TallyPrime.
A regular reconciliation helps you:
- find missing receipts and payments;
- identify duplicate or wrongly dated vouchers;
- separate genuine timing differences from accounting errors;
- keep cash-flow reports more reliable; and
- prepare cleaner records for month-end review.
Before you begin
Keep the following ready:
- the latest bank statement in PDF, Excel or another format supported by your process;
- the correct bank ledger in TallyPrime;
- the statement period and closing balance; and
- details of pending cheques, deposits and bank charges.
Take a backup of the company data before making a large batch of corrections. If multiple users work in the same company, coordinate the reconciliation period so that new vouchers do not make the report confusing while you are reviewing it.
Step-by-step bank reconciliation in TallyPrime
1. Open the bank reconciliation report
Open the relevant company and go to the Banking or Display reports area. Select the bank ledger and open the Bank Reconciliation report. In some releases, you can reach the report from the ledger or from the Banking menu.
2. Select the correct bank ledger and period
Choose the exact ledger linked to the bank account you want to review. Set the date range to match the bank statement. Working one month at a time is usually easier than trying to reconcile a full year in a single pass.
3. Enter or import the bank statement details
Depending on your TallyPrime release and bank setup, you may be able to import statement data or enter the relevant transaction details in the reconciliation view. Check the date, amount, transaction type and reference before accepting a match.
Do not match a transaction only because the amount is identical. Confirm the date range, narration, cheque number, reference number or other identifying detail as well.
4. Match cleared transactions
Mark the transactions that have cleared the bank. Receipts deposited into the bank and payments made by cheque should be matched only when they appear in the statement. A voucher can be recorded in the books before the bank processes it, so the book date and clearance date may be different.
5. Review unmatched transactions
Group the unmatched items into practical categories:
- cheques issued but not yet presented;
- deposits recorded in books but not yet credited;
- bank charges or interest missing from TallyPrime;
- direct credits or debits made by the bank;
- wrong dates, amounts or bank references; and
- entries that belong to another bank account or company.
6. Record genuine missing entries
If the bank statement contains a legitimate charge, interest entry or direct debit that is missing from the books, record the appropriate voucher after checking the supporting document. Use the correct expense, income or party ledger and add a clear narration.
For corrections, avoid deleting a voucher just to force the report to match. Reverse or alter it according to your internal accounting policy, retain the audit trail, and document the reason for the change.
7. Verify the reconciled balance
After matching and recording missing entries, compare the reconciled balance with the bank statement closing balance. Investigate any remaining difference instead of carrying it forward without an explanation.
Common reasons for a difference
| Difference | Likely reason | What to check |
|---|---|---|
| Payment in books, absent in statement | Cheque or transfer is pending | Cheque number, bank date and outstanding list |
| Credit in statement, absent in books | Direct receipt or bank transfer | Bank reference, customer and remittance advice |
| Small unexplained debit | Bank charge or tax on charge | Statement narration and bank advice |
| Same amount appears twice | Duplicate voucher or duplicate import | Voucher number, date and reference |
| Balance differs after matching | Opening balance, date or amount error | Previous reconciliation and ledger entries |
Practical tips for faster reconciliation
- Reconcile weekly for high-volume bank accounts and at least monthly for other accounts.
- Use a consistent narration format, such as bank reference plus party name.
- Keep a short pending-items list with an owner and expected clearance date.
- Review old unreconciled cheques instead of allowing them to remain indefinitely.
- Restrict back-dated edits after month-end review and record approved exceptions.
- Reconcile each bank ledger separately; do not combine accounts just to make the balance appear correct.
Tally.ERP 9 and TallyPrime: what changes?
The exact screens and banking features differ between Tally.ERP 9 and TallyPrime. The accounting principle remains the same: compare the book entry with the bank evidence, record legitimate missing transactions, and explain timing differences. If you are upgrading an older company, confirm that bank ledgers, opening balances and prior reconciliation information have migrated correctly before starting a new period.
Frequently asked questions
Can I reconcile a bank account without importing a statement?
Yes. You can review the bank ledger and mark or enter reconciliation details manually when your release or bank workflow does not support statement import.
Why is a cheque still unreconciled even though it was entered?
Entering a cheque voucher records it in the books. It becomes reconciled only after it clears the bank or after you enter the correct clearance information.
Should I change the voucher date to match the bank date?
Not automatically. The voucher date should reflect the underlying transaction and your accounting policy. Use the reconciliation or clearance details for timing differences, and change a voucher date only when it is genuinely incorrect and the change is properly approved.
Final checklist
- Correct company and bank ledger selected
- Statement period matches the report period
- Opening and closing balances checked
- Cleared transactions matched using references
- Bank charges and direct credits recorded
- Old unreconciled items reviewed
- Backup and review completed
Conclusion: Bank reconciliation works best as a routine control, not as a year-end emergency. A short weekly or monthly review in TallyPrime can reveal errors early and give you a more dependable view of available cash.
Note: This article is for general software and bookkeeping guidance. Always verify the workflow with your accountant and the documentation for your installed Tally release.
