Bank Reconciled with Tally

Описание: FAQ: TallyPrime 7.0 Bank Reconciliation - Manual Entries to Connected Services
SECTION 2: THE RECONCILIATION PROCESS
Q5: What's the difference between 'Cleared' and 'Uncleared' in Tally?
A: This is the core concept.
Uncleared: A transaction you have entered in Tally (e.g., a cheque issued) that does NOT yet appear on your official bank statement. It is pending bank processing.
Q6: When I press F5 (Reconcile), Tally doesn't show my manual voucher as a match option. Why?
A: Common reasons:
Date Range Mismatch: Your manual voucher is outside the period you've set in the BRS screen (F2: Period).
Posted to Wrong Ledger: You may have accidentally posted the transaction to a "Cash" or "Suspense" account instead of the specific Bank Ledger.
Q7: How do I handle a cheque that I recorded in Tally but the bank cleared for a DIFFERENT amount?
A: Do NOT force a match. This is a critical discrepancy.
Identify the error: Was your entry wrong, or did the bank/recipient make an error?
Correct the original voucher: If you made the mistake, alter the payment voucher in Tally to the correct cleared amount (Gateway of Tally Display Account Books Ledger find the voucher and alter it).
Then reconcile: Now the amounts match, and you can use F5 to link them.
Q8: I see a transaction in the bank feed for "ATM WDL" that I don't remember entering. What should I do?
A: This is a classic "Missing in Books" item.
In the BRS screen, place the cursor on that bank transaction.
Press F5: Reconcile.
Since no match will be found, Tally will prompt you to create a voucher.
Create the payment voucher directly from there. It will be posted to your bank ledger and marked as reconciled simultaneously. Q9: What if I issued a cheque 6 months ago, entered it then, and it's still not showing in the bank feed?
A: This is a long-outstanding "uncleared" transaction.
It will remain in your uncleared list indefinitely until it clears or you action it.
Action: Contact the payee to see if the cheque was lost. If it will never be cashed, you need to reverse it in your books.
To reverse: Create a Journal Voucher crediting your bank account and debiting the original expense account This increases your bank balance in Tally and removes the uncleared item. Important: Once reversed, if the old cheque is ever cashed, it will appear as an unaccounted bank debit that you must then handle.
SECTION 3: POST-RECONCILIATION & ONGOING MANAGEMENT
Q10: After reconciling a period, can I edit or undo it?
A: Yes. Reconciliation is not locked forever.
Go back to the BRS screen for that period
You will see the reconciled transactions. You can un-reconcile a specific transaction by placing the cursor on it
After making changes, reconcile it again.
Q11: Should I delete my old manual entries and only rely on the bank feed?
A: No, do not delete historical manual entries. They are your original accounting record. The goal is to match and reconcile them, not replace them. For future transactions, you can shift your workflow: let the bank feed come in and create vouchers from it, minimizing manual data entry.
Q12: How often should I reconcile?
A: Weekly or Bi-weekly is ideal. Daily if you have high transaction volume. Never wait for the month-end. Frequent, small reconciliations are quick, easy, and prevent a backlog of problems. Set a calendar reminder.
Q13: The 'Auto-Reconcile' button didn't match everything. Is it broken?
A: No. Auto-reconcile uses algorithms (amount, date proximity) to suggest matches. It is conservative by design to avoid errors. It will not match transactions where:
Amounts differ (even slightly).
Dates are far apart.
Narrations are completely dissimilar.
It finds multiple possible matches (needs human judgment). Consider auto-reconcile as a helpful first pass, not a complete solution.
SECTION 4: TROUBLESHOOTING & ADVANCED
Q16: I think I reconciled the same transaction twice (a duplicate). How do I fix this?
A: Identify the duplicate voucher.
Go to the Bank Ledger and look for two similar transactions around the same date/amount.
One will likely be the original manual entry, and the other might be a voucher you created from the bank feed.
Delete the unnecessary one: If the voucher is not locked in a closed period, you can simply alter and delete it. Ensure you are deleting the extra one, not the one tied to your original invoice or support document.
Q17: Can I reconcile cash transactions this way?
A: No. Bank Connected Services and the formal BRS are specifically for bank accounts. Cash reconciliation is a separate, manual process of counting physical cash and matching it to your "Cash Ledger" balance in Tally.