What bank reconciliation in Tally Prime actually is
Bank reconciliation is usually the first job businesses hand over when they start with Tally automation, and for good reason. It is repetitive, it happens every month, and getting it wrong shows up in everything else: cash position, receivables, GST input credit, and the audit.
A bank reconciliation statement (BRS) compares two records of the same money. Your books say the HDFC current account closed March at ₹18,42,300. The bank statement says ₹19,06,150. Bank reconciliation in Tally Prime is the process of marking which entries the bank has cleared, finding the ones it has not, and booking the ones your books are missing, until the difference is fully explained.
TallyPrime gives you two ways to do it: the manual BRS screen that has existed for years, and statement import with auto reconciliation from Release 6.0 onwards. Most accounts teams use a mix of both.
Before you start: set up the bank ledger
Bank reconciliation only works on ledgers created under the Bank Accounts or Bank OD A/c group. Check three things before the first reconciliation:
- The opening BRS is entered. If cheques were outstanding when you started using Tally, enter them through the Opening BRS option (Alt+H in the reconciliation report) so the first month does not start with a false difference.
- Auto reconciliation is switched on (for statement import). Alter the bank ledger, set Enable Auto Bank Reconciliation to Yes, and set the Reconciliation Beginning Date.
- Instrument numbers are recorded. Cheque and UTR numbers on payment and receipt vouchers are what TallyPrime uses to find exact matches. Vouchers without them fall into potential matches or stay unmatched.
Method 1 - Manual BRS in Tally Prime
Manual bank reconciliation works on every TallyPrime release and is still the quickest option when the month has only a handful of transactions.
- Open the Bank Reconciliation report for the bank ledger (from Banking in Gateway of Tally, or by drilling into the ledger).
- Press Alt+R (Manual Recon) to open the Bank Reconciliation (Manual) screen.
- For every transaction that appears on the bank statement, enter the Bank Date shown on the statement.
- Press Ctrl+A to accept. Reconciled entries move out of the list (press F5 to view them again).
- Read the bottom of the screen: balance as per company books, amounts not reflected in the bank, and balance as per bank. When the last figure equals the statement closing balance, the BRS is done.
The limitation is obvious once the bank account has 300 or 400 lines a month. Typing a date against every row takes hours, and anything missing from your books is still invisible until someone compares the statement line by line.
Method 2 - Import the bank statement and auto reconcile
From TallyPrime Release 6.0, you can import the statement and let Tally do the matching. Release 7.0 tightened this into an almost one-click flow. The steps below follow Tally's own guide.
- Download the statement from net banking in Excel, CSV, or MT940 format. Tally reads statement formats from hundreds of Indian banks.
- Open the Bank Reconciliation report and press Alt+O to import the statement. Duplicate lines are detected automatically.
- Review the Exact Match section, where amount, date, and instrument number all agree, and press F8 to reconcile them.
- Press Alt+S to see potential matches suggested on instrument date, amount, and party. Confirm the right pairs with F8. A partial match is allowed when the amounts differ.
- For bank lines with no voucher in your books, press F7 to create a voucher from the line, or Alt+F7 to combine several lines (for example a month of SMS charges) into one entry.
Banks with connected banking in TallyPrime can also fetch statements directly, which needs an active Tally Software Services subscription. Read the auto bank reconciliation help page for the exact screens on your release. Our answer on how to import a bank statement into Tally Prime covers file preparation and the common import errors.
Why some lines never match, and how to fix each one
Even with auto reconciliation, a typical month leaves 1 to 3 percent of lines unmatched. These are the usual reasons, what they look like on the statement, and the fix.
| Reason | How it looks | Fix in Tally |
|---|---|---|
| Bank charges and fees | Small debit with narration like CHGS, SMS CHG, or GST ON CHGS | Book a payment entry to Bank Charges (and input GST where applicable) |
| Interest credited or debited | Credit marked INT or a quarterly interest debit on an OD account | Book a receipt to Interest Received or a payment to Interest Paid |
| Customer paid, receipt not recorded | NEFT or UPI credit with a party name your books do not show yet | Book the receipt against the party and the right bills |
| Cheque issued, not yet presented | Payment in your books, nothing on the statement | Leave it unreconciled; it clears when the vendor deposits it |
| Cheque deposited, not yet cleared | Receipt in your books, credit missing on the statement | Leave it; follow up if it is still missing after 3 to 4 working days |
| Amount or date mismatch | Same party, slightly different amount or a different value date | Correct the voucher, or reconcile partially if a TDS or charge explains it |
Uncleared cheques are timing differences: leave them in the BRS and they clear on their own. Everything else is a missing or wrong entry that has to be booked or corrected before the books are closed.
Tally automation with AI for the lines Tally cannot explain
TallyPrime is very good at the easy part: lines that already have a matching voucher. What it does not do is tell you why a line is unmatched or what to post for it. That is where an accountant spends the afternoon, opening the statement narration, searching the party, checking bills, and deciding the ledger.
Tally automation with AI means software that reads the unmatched lines the way an experienced accountant would and prepares the entry for you to approve. With KolossusAI, a March statement for an HDFC current account looks like this:
- 409 of 412 lines matched against existing entries in Tally.
- ₹1,180 bank charges on 14 Mar - suggested entry: payment to Bank Charges with input GST.
- ₹2.4 lakh NEFT from Mehta Steels - no receipt in Tally; suggested entry: receipt against their open bill dated 2 Mar.
- ₹65,000 cheque deposited on 29 Mar - not yet cleared; flagged to check again after 3 working days.
Nothing is posted until someone with posting permission approves it, and every posted voucher is logged. The accountant reviews three suggestions instead of hunting through 412 lines.
A month-end routine that keeps BRS under an hour
- Weekly: import the statement for each bank account and reconcile the exact matches. Small weekly batches keep the unmatched list short.
- Weekly: book customer receipts that arrived by UPI or NEFT without an advice. These are the lines that most often stay unmatched.
- Month end: clear charges and interest in one consolidated entry per bank (Alt+F7 in Tally, or one approval in an AI tool).
- Month end: review the list of uncleared cheques. Anything older than 30 days needs a call to the party.
- Before GST filing: confirm bank charges with GST are booked, so input credit is not left on the table.
Conclusion
Bank reconciliation in Tally Prime has improved a lot. Statement import and auto reconciliation in Release 6.0 and 7.x handle most lines that already have an entry. The remaining work, explaining unmatched lines and booking what is missing, is what still eats the first week of the month.
That last mile is exactly what Tally automation is built for. KolossusAI explains each unmatched line, prepares the entry, and posts it when you approve, alongside bulk bill import, one-click entries, and chat with your Tally. It is ₹10,000 a year for web and mobile, with a 14-day free trial on your own Tally. See how it works for Tally Prime users.