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


This query is : Resolved 

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.

(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!

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 (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.

Manish (Expert)
08 October 2026 Share screenshots to better understand the situation. Or contact Tally Solutions directly.

03 November 2026 Root Cause: Imported Excel entries are treated purely as book entries without proper bank reconciliation linkage flags.

Action: Adjust the BRS period filter (F2) or re-import the file using Tally's native bank e-statement utility (Alt + O) to correctly sync them with the reconciliation screen.


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details