“Check the bank statement in Tally” means two different jobs, and people usually want both. The first is simply seeing your bank transactions inside Tally — the entries as your books hold them. The second is checking those entries against what the bank itself says happened. Tally has a separate report for each, and mixing them up is why the numbers seem to disagree when they do not.
This guide covers both, with the exact navigation, and then the part nobody enjoys: what to do when the two do not match.
Where your bank transactions live in Tally
Inside Tally, your bank account is a ledger, and the report that shows it as a statement is the Cash/Bank Book. Two ways in:
- Press Alt+G (Go To), type Cash/Bank Book, press Enter.
- Or from Gateway of Tally > Display More Reports > Account Books > Cash/Bank Book(s).
The Cash/Bank Summary appears, listing every cash and bank ledger in the company with its balance. Select the bank you want and press Enter.
You are now on the Ledger Monthly Summary for that bank: one row per month, with debit and credit totals and the closing balance. Press Alt+F2 to change the period if the months you want are not on screen.
This is the level most people stop at, and it is the wrong level for checking anything. A month with the right closing balance can still have two wrong entries inside it that cancel each other out.
Getting down to individual transactions
Press Enter on any month and Tally opens the Ledger Vouchers report — the transaction list, in date order, which is the closest thing in Tally to the statement your bank sends you. Date, particulars, voucher type, voucher number, debit, credit.
Two keys worth knowing on these screens:
- Ctrl+F6 shows the Daily Breakup of the ledger, useful when you are hunting for a single day rather than reading a month.
- F12 configures what the report displays, including whether the closing balance is shown alongside.
Press Enter on any line to open the voucher itself. That is where you see the narration, the ledger the other side of the entry went to, and whether somebody posted it as a Payment when it should have been a Contra. If you are unsure which voucher type a line should have used, our guide on entering a bank statement in Tally works through each one.
Checking Tally against the bank’s own statement
Everything above shows you what your books say. Reconciliation is where you find out whether your books and the bank agree, and it is a different report. Our guide to the bank reconciliation statement in TallyPrime covers setting it up and doing it manually or by import.
Press Alt+G and go to Banking Activities. Press Enter on the count of transactions shown under the Bank Reconciliation column, and the Bank Reconciliation Summary opens. Three figures on it matter:
- Balance as per Company Books — what Tally holds as of the report date.
- Balance as per Bank Statement — the balance from the statement you imported.
- Difference — between the expected bank balance and the balance the statement states.
Press Enter on the unreconciled transactions to get the list of entries that have not been matched. Useful keys on that screen: F4 selects a different bank ledger, F5 switches between the amount view and the reconciled view, F8 modifies a match, F9 sets a reconciliation status by hand, and Alt+F8 unlinks a transaction that was matched wrongly. If you need to go back and reconcile a month or year that has already passed, see back-dated bank reconciliation in TallyPrime.
Note what this report needs: a bank statement Tally can read. That is where most of the friction sits, and it is covered further down.
What the difference is usually telling you
A difference is not automatically an error. Several causes are perfectly normal and simply mean timing:
- Cheques issued but not presented. You have recorded the payment, the payee has not banked it yet.
- Deposits in transit. A cheque you banked that has not cleared.
- Bank charges, interest and taxes. The bank has debited them, nobody has entered them in Tally. These are the commonest genuine gap.
The rest are errors, and they have a pattern worth knowing:
- An amount typed wrongly. Two digits swapped — 45,900 keyed as 49,500 — is the classic. The difference will be divisible by nine, which is a quick way to recognise one.
- An entry recorded twice, usually because a statement was part-entered, abandoned, and started again.
- An entry on the wrong side, a receipt keyed as a payment. The difference will be exactly twice the transaction amount.
- An entry against the wrong bank, common where a firm runs several accounts and the ledgers have similar names.
- A missing row, most often the first or last line of a page, or a row that wrapped across a page break in the statement.
Work the difference rather than the list. If it is divisible by nine, hunt for transposed digits. If it is exactly twice a round figure, look for a wrong-side entry. If it matches a single line on the bank statement, that line was never entered.
The check that comes before all of this
Everything above assumes the entries in Tally are the entries that were on the statement. Reconciliation is very good at telling you the totals disagree. It is much weaker at telling you why, and it cannot tell you at all when a figure was read off the statement incorrectly and then entered faithfully.
That gap matters most where the statement arrives as a PDF, because nothing in that route checks the figures. Somebody reads them and types them, or a converter reads them and produces a spreadsheet, and TallyPrime will not accept that spreadsheet anyway — Tally’s own documentation states its Bank Statement import cannot take a PDF, or a CSV or Excel file converted from one. There is more on that in what TallyPrime will and will not import.
The stronger check is one the statement itself makes possible. Every bank statement prints a running balance, and that column is a proof: the previous balance, plus the deposit, minus the withdrawal, must equal the balance printed on that row. Run that arithmetic down the whole statement and a misread figure has nowhere to hide — the chain breaks at exactly the row that is wrong.
That is the check SmartXtract runs on every statement before anything reaches Tally, on bank statement PDFs and on scanned statements, where a misread digit is the commonest failure of all. Entries reach Tally through Tally Connector as receipt, payment and contra vouchers, after you approve them. It does not replace reconciliation. It removes the class of difference that is hardest to find during one.
Try it on one statement free — 20 pages, no card — and compare what comes out against your own PDF.
A monthly routine that works
If you are checking bank statements for several clients, a fixed order saves more time than any single trick:
- Open the Cash/Bank Book and check the closing balance against the last line of the bank statement. If they agree, the month is probably clean.
- If they do not, open Banking Activities and read the Difference before opening a single voucher.
- Test the difference: divisible by nine points at transposed digits, exactly double a figure points at a wrong-side entry, matching a statement line points at a missing entry.
- Only then go into Ledger Vouchers and look at transactions.
- Enter the bank charges and interest last, in one go, rather than as you meet them.
Most people do this in the opposite order, opening vouchers first, and it is why checking a statement takes an afternoon instead of ten minutes.
Frequently asked questions
How do I see a bank statement in Tally?
Press Alt+G, type Cash/Bank Book and press Enter, or go to Gateway of Tally > Display More Reports > Account Books > Cash/Bank Book(s). Select your bank ledger, then press Enter on a month to open the Ledger Vouchers report, which lists the individual transactions in date order.
What is the difference between the Bank Book and bank reconciliation in Tally?
The Bank Book shows what your books say about the bank account. Bank reconciliation compares that against what the bank’s own statement says and shows the difference between the two. The Bank Book always works; reconciliation needs a bank statement Tally can read.
How do I check the bank balance in Tally?
The Cash/Bank Summary shows the closing balance for every bank ledger in the company. For the balance on a particular date, open the ledger and press Alt+F2 to set the period. The Bank Reconciliation Summary shows it beside the balance as per the bank statement, which is the comparison you usually want.
Why does my Tally bank balance not match the bank statement?
Usually one of three timing differences — cheques issued but not presented, deposits not yet cleared, or bank charges and interest the bank has applied and nobody has entered. Beyond those it is an error: a transposed amount, an entry made twice, an entry on the wrong side, or a row that was never entered at all.
Can I open the bank statement PDF inside Tally?
No. Tally has no PDF viewer, and its Bank Statement import does not accept a PDF either. Tally’s documentation is explicit that it will not take a PDF, nor a CSV or Excel file converted from one, because that import expects each bank’s own file layout.
How do I check whether a particular transaction is in Tally?
Open the bank ledger’s Ledger Vouchers report for the period and look on the date. If you are searching across ledgers, the Day Book is faster. Press Enter on the line to open the voucher and check the amount, the voucher type and the ledger on the other side.
How often should a bank statement be checked in Tally?
Monthly at the very least, because that is the cycle the statement arrives on. Weekly is better where the volume is high — a difference found within a week is usually one transaction, while a difference found at year end is usually several tangled together, and the people who could explain them have forgotten.