Bank reconciliation problems occur when your bank statement and Tally records do not match.

This may lead to:

✔ Incorrect bank balance
✔ Missing transactions
✔ Wrong cash flow reports
✔ Confusion during audits

The good news: Most mismatches are easy to identify and fix.

What Is Bank Reconciliation? (Simple Meaning)

Bank reconciliation means:

? Comparing your bank statement with Tally entries

Goal:

✔ Ensure every deposit & payment matches
✔ Identify missing or incorrect entries

Common Problems Users Notice

• Bank balance not matching

• Extra entries in bank statement

• Missing entries in Tally

• Duplicate transactions

• Incorrect cheque status

• Wrong cash flow figures

Why Do Reconciliation Mismatches Happen?

Think of it like comparing two lists.

If something is missing or different → mismatch appears.

Most common reasons:

✔ Transactions not entered in Tally
✔ Wrong amount entered
✔ Duplicate voucher entries
✔ Bank charges not recorded
✔ Cheques not cleared
✔ Wrong transaction date
✔ Reconciliation done very late

✅ Step-by-Step Solutions

1️⃣ Compare Balances First

Start simple.

✔ Check bank balance in Tally
✔ Compare with bank statement closing balance

? Difference = Something needs review

2️⃣ Look for Missing Transactions

✔ Check bank statement
✔ Identify entries not present in Tally

Common missing items:

• Bank charges

• Interest entries

• Direct deposits

• Auto debits (EMI, fees, etc.)

✔ Enter missing vouchers

3️⃣ Check Incorrect Amount Entries

✔ Compare transaction values
✔ Look for typing mistakes

✔ Example mistakes:

• ₹10,000 entered as ₹1,000

• ₹5,450 entered as ₹5,405

4️⃣ Check Duplicate Entries

✔ Same payment entered twice
✔ Same deposit recorded twice

✔ Remove incorrect entry

5️⃣ Review Cheque Status

4

✔ Issued but not cleared → Temporary mismatch
✔ Cleared later → Balance adjusts

✔ Update cheque status properly

6️⃣ Verify Transaction Dates

Wrong dates cause confusion.

✔ Statement date vs Tally date mismatch

✔ Correct voucher date if needed

7️⃣ Record Bank Charges & Fees

Very common oversight.

✔ ATM charges
✔ Maintenance charges
✔ Online transaction fees

✔ Enter expense vouchers

⚠ Common Mismatch Situations & Easy Fix

? Important Precautions

✔ Never ignore reconciliation differences
✔ Avoid bulk adjustments without checking
✔ Always verify statement carefully

✔ MOST IMPORTANT:

? Backup data before corrections

✅ Best Practices for Smooth Reconciliation

✔ Reconcile Regularly (Highly Recommended)

✔ Weekly or Monthly
✔ Prevents large mismatches

✔ Enter Bank Transactions Promptly

✔ Avoid backlog
✔ Easier tracking

✔ Monitor Auto Bank Entries

✔ EMI deductions
✔ Bank charges
✔ Interest credits

✔ Avoid Guesswork Adjustments

✔ Always verify with statement

✔ Maintain Clean Records

✔ No duplicate vouchers
✔ Correct dates & amounts

Short Conclusion

Most bank reconciliation mismatches occur due to:

✔ Missing entries
✔ Wrong amounts
✔ Uncleared cheques

Regular reconciliation = Accurate bank balance & reports

If unsure → Consult accountant or Tally expert.