📎 This article includes 1 downloadable practice file ↓
In this article
Your books and the bank statement rarely match on any given day: cheques not yet cleared, bank charges you haven’t recorded, receipts you don’t know about. Bank reconciliation explains the difference.
Why they differ
- Cheques issued but not presented; deposits not yet credited.
- Bank charges, interest and direct credits not yet in the books.
- Errors (wrong amount, wrong bank ledger).
Reconcile in TallyPrime
- Open the bank ledger and choose Reconcile (Banking menu).
- For each entry that appears on the statement, enter the bank date.
- Record missing items (charges, interest, direct receipts) as vouchers.
- The bottom shows balance as per company books, amounts not reflected in bank, and balance as per bank, which should equal the statement.
TallyPrime can import bank statements (Excel/CSV/MT940 formats depending on bank) and auto-match entries.
More: bank reconciliation in Tally.
Menus follow TallyPrime (current versions); older Tally ERP 9 menus differ. GST rates and rules shown are examples; confirm current rules before filing.
Practice
Follow the checklist with a made-up statement.
📎 Practice files for this article
- 📄Lesson 6 checklistStep-by-step exercises for this lesson.⬇ TXT · 355 B
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
Stuck on a step? Ask a question and the AI answers using this article.