Bank Reconciliation in Tally

Bank reconciliation in Tally means matching your bank ledger in Tally with the actual bank statement, so both balances agree. You open the bank ledger, choose Reconcile, and enter the date each transaction was cleared by the bank. Any difference between the two balances points to an entry that hasn't cleared yet, or one that's missing from your books. Doing this regularly, usually monthly, is a core accounting task and a favourite interview question, because it proves your records match reality.

Why the two balances differ

Your Tally bank balance and the bank's statement rarely match on any given day, and that's normal. The reasons:

• Timing. You record a cheque the day you write it, but the bank clears it days later. Until then, your books show it but the bank doesn't.
• Bank charges and interest. The bank deducts charges or adds interest that you haven't recorded yet.
• Direct credits/debits. A customer transfers money straight into your account, or an auto-debit happens, and you learn about it only from the statement.
• Errors. A wrong amount or a missed entry on either side.

Reconciliation is the process of explaining every difference so the two match. It's not about forcing them equal; it's about accounting for each gap.

What you need

• Your bank ledger in Tally, with all payments and receipts recorded.
• The bank statement (from the passbook, net banking, or a downloaded file) for the same period.

Step by step: reconcile in Tally

1. Gateway of Tally ▸ Banking ▸ Bank Reconciliation (or open the bank ledger and choose Reconcile; press F5 in the ledger).
2. Tally shows every transaction in your bank ledger with a Bank Date column (blank at first).
3. For each entry that appears in the bank statement, enter the date it was cleared (the date on the statement) in the Bank Date column.
4. Leave the Bank Date blank for entries the bank hasn't cleared yet (uncleared cheques).
5. As you fill in dates, Tally updates the reconciled balance. When your cleared entries match the statement, the balances agree.
6. Add any missing entries (bank charges, interest, direct credits) as fresh vouchers, then reconcile those too.

Reading the reconciliation

At the bottom, Tally shows:

• Balance as per company books (your Tally figure).
• Amounts not reflected in bank (entries you recorded but the bank hasn't cleared).
• Balance as per bank (what the statement should show).

When you've dated every cleared entry and recorded any bank-only items, the "balance as per bank" should equal the statement. That's a successful reconciliation.

Worked example

Your Tally bank balance on 31 March is ₹1,00,000. The bank statement shows ₹92,000. You reconcile:

• A ₹10,000 cheque you issued to a supplier hasn't cleared yet (still with the supplier). This explains ₹10,000 of the gap.
• The bank charged ₹200 in fees, which you hadn't recorded. You add a Payment entry for bank charges.
• The bank added ₹2,000 interest you hadn't recorded. You add a Receipt for interest.

After adjusting: your books become ₹1,00,000 − ₹200 + ₹2,000 = ₹1,01,800, minus the ₹10,000 uncleared cheque leaves ₹91,800 expected at the bank... you then re-check the statement figure and the uncleared items until every rupee is explained. The discipline is: no unexplained difference is allowed to remain.

Real-world scenario (why employers test BRS)

At month end, an accountant must be able to say, with confidence, "our books match the bank." If they don't, it could mean a missed entry, a duplicate, a fraud, or simply uncleared cheques, and you can't tell which until you reconcile. A business that never reconciles can carry errors for months. That's why "Can you do a BRS?" is one of the most common questions in an accounts interview. Being able to open Tally, reconcile a bank ledger, and explain each difference marks you as a real accountant rather than just a data-entry operator.

Pro tips

• Reconcile monthly, right after the statement is available, so differences are small and easy to trace.
• Record bank charges and interest as you spot them on the statement, then reconcile those entries.
• Uncleared cheques are normal; just leave their Bank Date blank until they clear.
• In TallyPrime you can import the bank statement to auto-match entries, which speeds things up for busy accounts.

Common mistakes

• Forcing the balance. Never add a fake entry to "make it match". Explain each difference with a real reason.
• Ignoring bank charges/interest. These are common causes of small differences; record them.
• Reconciling too late. Waiting months makes differences pile up and hard to trace.
• Confusing uncleared cheques with errors. An uncleared cheque is normal timing, not a mistake.

Key takeaways

• Bank reconciliation matches your Tally bank ledger with the bank statement.
• Open the bank ledger ▸ Reconcile, and enter each entry's clearing (bank) date.
• Differences come from timing, bank charges/interest, direct credits and errors.
• Explain every difference; never force the balance. Reconcile monthly.

Practice task

In your practice company, record a few bank payments and receipts, then open the bank ledger and go to Reconcile. Enter clearing dates for some entries and leave others blank. Add a bank-charges entry, and watch how the reconciled balance changes.

Master month-end tasks like BRS, GST and reports in the ADFA program at HCI.