Tally: Imported bank entries do not show up in manual reconciliation

Save Share

This query is : Open

Quick Summary

Users are encountering an issue in Tally where imported bank entries, though appearing in ledgers, are not showing up on the bank reconciliation screen. This prevents manual reconciliation. The problem seems to stem from Tally recognising these entries as internal 'in books' vouchers rather than direct bank transactions. Solutions involve either manually entering the bank date or using Tally's official e-statement import function.

Rajesh

Rajesh (Querist)

11 September 2026 1) prepared an Excel bank entries template
2) created all required ledger accounts in Tally
3) created Tally mapping template in Tally
4) imported all bank entries into Tally successfully
5) when Alt+R is pressed unreconciled bank entries should be seen. but they are not seen.
6) therefore, manual bank reconciliation cannot be done
7) Tally shows them a "Available only in books"

Kindly suggest a solution to this issue. Thanks!

Aashok Kumar Sharma online

Aashok Kumar Sharma

(Expert)

12 September 2026 Imported Excel entries in Tally are recognized as internal ledger vouchers ("in books"), requiring either manual entry of the Bank Date in the BRS screen (F2 date range properly set) or importing the bank's official e-statement file via Import Bank Statement (Alt + O) to clear the "Available only in books" status.

Rajesh

Rajesh (Querist)

12 September 2026 Thank Aashok for reply. But for reconciling bank entries in Tally, entries should show up on reconciliation screen. Entries appear in bank book, day-book and each ledger account. But they do not appear on bank reconciliation screen for entering bank date i..e bank reconciliation date. I need to know why those entries do not appear on bank reconciliation screen & what needs to be done so that they appear on that screen.