In TallyPrime you do not draw up a bank reconciliation statement by hand. It is a report Tally keeps for each bank ledger: press Alt+G, open Banking Activities, and press Enter on the count under the Bank Reconciliation column. What you do is fill it in, and there are two ways to do that. In manual reconciliation you type the bank date against each entry in your books. In auto reconciliation you import the bank’s own statement file and TallyPrime matches it to your books for you.
This guide covers both, from the one-time ledger setup to reading the finished statement. It also covers the case most ranking guides skip: what to do when the bank has only given you a PDF.
Manual or auto bank reconciliation: which one fits?
Choose by what the bank gives you, not by preference. Auto reconciliation is faster, but it only works with a file TallyPrime can read.
| What you have | Method | Why |
|---|---|---|
| An Excel or CSV statement downloaded from the bank’s net banking, for a bank on Tally’s supported list | Auto | TallyPrime reads the file and matches most entries itself |
| A bank that is set up for Connected Banking in TallyPrime | Auto | The statement is fetched for you instead of imported |
| A PDF statement, a scanned copy, or a passbook | Manual | TallyPrime’s import does not accept a PDF |
| An Excel or CSV you made from a PDF | Manual | Tally’s help lists “CSV/Excel converted from PDF” as a format it cannot import |
| A bank that is not on Tally’s supported list | Manual | Tally has no layout for that bank’s file |
| A handful of entries, such as a small current account | Either | Typing ten bank dates takes less time than downloading and importing a file |
Tally’s Import Bank Statements page (updated 1 September 2026) gives the supported-bank figure as 145+ and links to the full list. Check your bank there before you plan around auto reconciliation.
Before you start: set up the bank ledger
Both methods depend on the bank ledger being set up properly. This is a one-time job per bank account.
- The ledger sits under Bank Accounts. Open it with Alt+G > Alter Master > Ledger. A bank account created under a general group never appears in Banking Activities, so there is nothing to reconcile.
- Set the Reconciliation Beginning Date. TallyPrime reconciles the ledger only from this date. Set it to the first day of the period you want to reconcile.
- For auto reconciliation only: in the same ledger, set Set/Alter Bank configuration to Yes. In the Bank Configuration screen that opens, set Set/Alter Auto Reconciliation configuration to Yes.
- Carry forward last year’s uncleared items. Cheques that were issued or deposited before the beginning date and still had not cleared go into Opening BRS (Alt+H from Banking Activities). If you skip this, the first month’s statement will never agree. To reconcile a month or year that has already passed, see back-dated bank reconciliation in TallyPrime.
These field names are from Tally’s bank reconciliation setup page, last updated 14 August 2026.
How to do manual bank reconciliation in TallyPrime
Keep the bank statement, PDF or paper, open beside Tally. You work down it one line at a time.
- Open the Bank Reconciliation Summary: Alt+G > Banking Activities > Enter on the count under Bank Reconciliation. Press F4 if you need a different bank ledger.
- Press Alt+R (Manual Recon). The Bank Reconciliation (Manual) screen lists every entry in your books that is not yet reconciled.
- For each entry that appears on the bank statement, enter the date it cleared at the bank. Leave the date blank for entries the bank has not shown yet, such as a cheque the supplier has not presented.
- Press Ctrl+A to accept. Every entry with a bank date is now reconciled.
- Enter whatever the bank shows that your books do not, usually bank charges, interest, TDS on interest and direct debits. Pass these as payment or receipt vouchers in the usual way, then give them a bank date too.
Two keys help on the manual screen. Ctrl+B (Basis of Values) shows only deposits or only withdrawals, which is easier when you are ticking off one column of the statement at a time. Ctrl+H (Change View) > View Reconciled shows what you have already done.
If you give an entry the wrong bank date, open the summary, press F5 (View Reconciled), select the entry under Manually Reconciled, press F9 (Set Status) and set it to System Inferred. It goes back to unreconciled. Source: Tally’s manual bank reconciliation page, updated 14 August 2026.
How to do auto bank reconciliation in TallyPrime
Import the statement
- Download the statement from net banking as Excel or CSV. Do not change the file: no deleted header rows, no renamed columns. TallyPrime recognises the bank by its original layout.
- From Gateway of Tally, press Alt+O (Import) > Bank Statement.
- Select the bank ledger, enter the file path, set File Type to Supported, and select the file.
- Set Show Preview to Yes and press Ctrl+A. Check the preview, then press I to import. The Summary of Imported Statement shows how many entries came in and how many matched exactly. Press S to go to the Bank Reconciliation Summary.
If the Bank Statement option is missing from the import menu, or the ledger you need is not in the list, see our guide to bank statement import not showing in TallyPrime. It covers each cause.
Work through the matches
After the import, every entry falls into one of these groups in the Bank Reconciliation report.
| Group | What it means | What you do |
|---|---|---|
| Exact Match | A book entry and a bank entry that agree | Select them and press F8 (Reconcile) |
| Potential Match | Suggested from instrument date, amount and party, but not certain | Press Alt+S to see them, check each set, then F8 |
| Partially Reconciled | Linked, but the amounts differ | Correct the voucher if the bank figure is right, or add the missing entry to the match |
| Available Only in Books | In your books, not on the statement | Usually cheques not yet presented or deposits not yet cleared. Leave them |
| Available Only in Bank | On the statement, not in your books | Usually charges, interest and direct debits. Select, press F8, then F7 (Create Vch) to pass the voucher from there |
Potential matches look within 30 days of the transaction by default. You can change that, and tell Tally to ignore leading zeroes or special characters in references, from Alt+S inside the Potential Match screen. These details are from Tally’s auto bank reconciliation page, updated 14 August 2026.
One trap when you switch from manual to auto. If you reconciled entries by hand and then import a statement covering the same period, the summary can show a difference that was not there before. TallyPrime treats the imported bank entries as new and unreconciled. Tally’s setup page gives two fixes: set those hand-reconciled book entries back to unreconciled (F9 > System Inferred) and link them to the imported bank entries, or reconcile the bank entries by entering the bank date.
Reading the bank reconciliation statement in TallyPrime
The Bank Reconciliation Summary is your BRS. Tally’s reports page lists these rows:
| Row in TallyPrime | What it holds |
|---|---|
| Balance as per Company Books | The bank ledger’s balance in Tally on the report date |
| Unreconciled Transactions | Split into Available Only in Books and Available Only in Bank |
| Reconciled in Subsequent Period | Entries that cleared at the bank after the report date |
| Expected Bank Balance | What the bank should show, given your books and the unreconciled items |
| Balance as per Bank Statement | The closing balance on the bank’s statement |
| Difference | The gap between the two. A finished reconciliation shows zero |
If Balance as per Bank Statement is not shown, turn it on with F12 > Show Balance as per Bank Statement.
A worked example
Here is the arithmetic behind those rows for one month. The figures are an illustration, not taken from a real client.
| Item | Amount (₹) |
|---|---|
| Balance as per company books, 31 October | 1,84,500 |
| Add: cheque issued to a supplier, not yet presented | 42,000 |
| Less: customer cheque deposited on 30 October, not yet cleared | (15,000) |
| Less: bank charges with GST, not yet entered in books | (354) |
| Add: interest credited by the bank, not yet entered in books | 1,120 |
| Balance as per bank statement | 2,12,266 |
The first two adjustments are timing. They are correct in your books and will clear on their own next month, so you leave them. The last two are entries your books are missing. Pass them (F7 from the bank side in auto reconciliation, or ordinary vouchers in manual), and they leave the statement. If the difference is still not zero after that, something in the books is wrong. Our guide on checking a bank statement in Tally shows how to read the leftover figure: a difference divisible by nine usually means two digits were swapped, and exactly twice an amount means an entry on the wrong side.
When TallyPrime will not take your bank statement
This is where most firms actually get stuck. Many clients send a PDF. Your client’s bank may not be on Tally’s list. Some statements arrive as a scan of a printout. In all of these cases TallyPrime’s import cannot help, and Tally’s own help says a CSV or Excel made from the PDF will not work either.
That leaves you two honest routes:
- Manual reconciliation, with the PDF beside you. It works for any bank and any format. It costs time in proportion to the number of lines, and it relies on you reading every figure right.
- Get the entries into Tally first, then reconcile. Most of the work on a PDF statement is not reconciling. It is that many of the bank’s lines (UPI receipts, charges, NEFT payments) were never entered in the books. Once they are entered, manual reconciliation of what is left goes quickly.
SmartXtract handles the second route. You upload the PDF, scanned or digital, and it reads every transaction, suggests a Tally ledger for each one, and checks each row against the statement’s own running balance, so a misread figure is caught before it reaches your books. You approve the entries, and Tally Connector, a free Windows app on the same PC as TallyPrime, posts them as receipt, payment and contra vouchers. It does not replace the Bank Reconciliation report. It gets the missing entries into your books so that the report has only true timing items left. The bank PDF to Tally page shows the full flow, or try it on one statement free: 20 pages, no card.
Mistakes that leave a difference on the BRS
- The beginning date is wrong. Entries before the Reconciliation Beginning Date never show up for reconciliation, so a statement that starts earlier can never agree.
- Last year’s uncleared cheques were not carried into Opening BRS. The first month is out by exactly their total.
- A voucher is dated on the day it was keyed, not the day of the transaction. Tally opens on the current date, and entries keyed in a hurry pick it up. Our guide to entering a bank statement in Tally covers the voucher date and type for each kind of line.
- The statement file was edited before import. Deleting the bank’s header rows or saving it in a different layout makes TallyPrime reject it or read it wrongly.
- A potential match was accepted without checking. Two payments of the same amount to the same party in one month are easy to cross-link. To undo a wrong match, select it, press F8 (Modify Match) and then F10 (Remove).
Frequently asked questions
How do I open the bank reconciliation statement in TallyPrime?
Press Alt+G, open Banking Activities, and press Enter on the count of transactions under the Bank Reconciliation column. The Bank Reconciliation Summary opens, which is the BRS. Press Enter on Unreconciled Transactions to see the individual entries, and F4 to switch to another bank ledger.
What is the difference between manual and auto bank reconciliation in TallyPrime?
In manual reconciliation you type the date each entry cleared at the bank, reading from the bank statement. In auto reconciliation you import the bank’s own Excel or CSV statement, or fetch it through Connected Banking, and TallyPrime matches the bank’s entries to your books for you. Auto needs a supported bank and an unedited file. Manual works with any statement, including a PDF.
Can I import a PDF bank statement into TallyPrime for reconciliation?
No. Tally’s Import Bank Statements help page lists PDF, and CSV or Excel converted from PDF, as formats it cannot import. With a PDF you either reconcile manually by entering bank dates, or get the transactions into your books another way and then reconcile what is left.
Why does my BRS in TallyPrime show a difference?
Usually because the bank has entries your books do not, most often charges, interest and direct debits, or because a voucher has the wrong amount, date or side. Cheques not yet presented and deposits not yet cleared are timing items, not errors. Check that the Reconciliation Beginning Date and Opening BRS are right before hunting for individual entries.
How do I undo a reconciled entry in TallyPrime?
Open the Bank Reconciliation Summary, press F5 (View Reconciled), select the entry, press F9 (Set Status) and set it to System Inferred. The entry goes back to unreconciled. For a wrong match made during auto reconciliation, select it, press F8 (Modify Match) and then F10 (Remove).
How do I enter bank charges that appear only on the statement?
In auto reconciliation they appear under Available Only in Bank. Select the line, press F8, and in the Modify Matches screen press F7 (Create Vch). The voucher is created and added to that bank line. In manual reconciliation pass a payment voucher against your bank charges ledger, then give it a bank date.
Which banks does TallyPrime support for auto bank reconciliation?
Tally’s Import Bank Statements page says 145+ banks and links to the current list. Tally’s own pages do not all give the same figure, so check your specific bank on that list rather than relying on a number.
Where to start
Set up the bank ledger once: the beginning date, Opening BRS, and the auto reconciliation setting if your bank is supported. Then reconcile monthly. Import the bank’s file when Tally can read it, enter bank dates when it cannot, and pass the bank-only entries before you start hunting for errors. If PDFs are what your clients send you, getting their transactions into Tally is the slow part, and that is the part worth fixing first.