Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →
A finance executive using TallyPrime is unsure whether to keep entering Bank Dates manually or move to auto reconciliation, and what work auto mode leaves behind.
Manual mode suits low volumes and unsupported banks. Auto mode suits supported banks and higher volumes: Tally links exact matches, suggests potential matches on instrument date, amount and party within a day window, and leaves one-sided lines for review.
Bank ledger with auto reconciliation enabled, a supported bank, statements imported monthly, potential matches reviewed before acceptance, and leftovers cleared before month-end sign-off.
Most lines are matched with little typing, and the leftover list is short, explained and cleared each month.
In TallyPrime’s manual mode you type a Bank Date against each book entry. In auto mode you import the bank statement, Tally links the exact matches, offers potential matches for you to accept, and whatever stays Available Only in Books or Available Only in Bank is yours to fix. Auto mode saves typing; it does not remove the need to review.
What is an exact match versus a potential match?
- Exact match: Tally finds a book entry and a bank line that clearly agree and links them.
- Potential match: Tally suggests a pairing it is less sure of. Tally’s help says these suggestions use instrument date, amount and party within a day window. The default window is 30 days; you can set it to 0 if matches must have the same date. You can also allow small amount differences within a limit, and ignore leading zeros or special characters in instrument numbers.
To work a leftover line, select it, press F8 to Find Matches, choose a suggestion, add it with F9 and reconcile.
If you reconcile despite an amount mismatch, the entry goes to Partially Reconciled. Finish it by correcting the voucher or adding a transaction for the difference.
How do manual and auto compare?
| Manual | Auto | |
|---|---|---|
| Who matches | You, by typing Bank Dates | Tally links exact matches; you review potential matches |
| What you need | Any statement, even a PDF to read from | Auto reconciliation enabled on the ledger, a supported bank, an imported or fetched statement |
| Best for | A few dozen lines a month, unsupported banks | Supported banks with regular volume |
| Main risk | Typing errors in dates | Accepting a suggested match without checking |
| Test in your own data | Not applicable | Part payments; one credit covering several invoices; several equal amounts from different parties |
The last row matters. Before relying on auto mode, take one past month and check how it handles the awkward cases your business actually has.
A worked example
A distributor imports 120 statement lines for April.
| Result | Lines |
|---|---|
| Exact matches linked by Tally | 96 |
| Potential matches reviewed and accepted | 14 |
| Left unmatched | 10 |
| Total | 120 |
The 10 leftover lines are worth ₹3,47,200. Here is what they turned out to be:
| Leftover type | Lines | Amount | Fix |
|---|---|---|---|
| UPI and NEFT credits where the sender name differs from the ledger name | 5 | ₹1,26,400 | Match to the right customer and note the alternate name |
| One customer payment covering three invoices (₹30,000 + ₹28,500 + ₹37,500) | 1 | ₹96,000 | Match one bank line to three invoices |
| Bank charges (₹2,000 plus 18% GST of ₹360) | 1 | ₹2,360 | Book a payment voucher |
| Interest credited | 1 | ₹4,840 | Book a receipt voucher |
| A cheque deposit split differently by the bank | 1 | ₹58,600 | Match manually |
| A supplier payment recorded under the wrong party | 1 | ₹59,000 | Correct the party, then match |
| Total | 10 | ₹3,47,200 |
Check the total: ₹1,26,400 + ₹96,000 + ₹2,360 + ₹4,840 + ₹58,600 + ₹59,000 = ₹3,47,200.
The automatic part took minutes. The 10 lines are where the accountant’s time goes, and where errors happen if they are rushed.
Can you switch from manual to auto mid-year?
Yes. Enable auto reconciliation in the bank ledger, then import a statement. Tally’s help covers the prerequisites for those switching from manual. Watch for one thing: an entry you already reconciled manually can appear as a new bank line when you import a statement that contains it. Tally’s setup help says to either reconcile it manually by entering the bank date or mark the book entry unreconciled and link it to the imported line. Do not book it again.
A clean way to switch is at the start of a month, after the previous month is fully reconciled and signed off.
Which should you choose?
Use manual if your bank is not supported, or you have very few transactions. Use auto if your bank is supported and you have more than a few dozen lines a month. Either way, the job is not done until the Difference line in the summary reads nil. If it does not, see why the reconciliation shows a difference.
What to read next
- Next step: Automating reconciliation in TallyPrime
- Reconciliation in SAP, Oracle and Tally
- Tally bank reconciliation
When the leftovers grow each month, TransactIG matches bank statement lines to your Tally books and puts the hard cases into an exception queue, with audit-ready exports.