Bank reconciliation in TallyPrime, step by step, and how an AI agent does it

Short answer: To reconcile a bank account in TallyPrime, import the bank statement as Excel, accept the matches Tally offers, fix entries that are a rupee or two off, pass vouchers for bank-only lines such as charges, EMIs and UPI receipts, and confirm the two balances agree. An AI agent can do the matching and draft the BRS for your review.

Bank reconciliation is the first job of every month-end, and in a busy firm it is also the one most often pushed to the 10th. TallyPrime 7 made it faster with automatic matching, but someone still has to work through the lines it can't match.

Below is the manual method, based on a recent TallyPrime tutorial, followed by a real run where an AI agent did the same reconciliation from one Slack message.

The tutorial this is based on

1 Click Auto Bank Reconciliation in Tally Prime 7.0 | New Feature by Accounts Advice (Diya Patel), published 18 June 2026 (in Hindi). It walks through TallyPrime's automatic matching, including the cases it cannot match on its own.

How do you do bank reconciliation in TallyPrime by hand?

  1. Open the bank ledger in Alter mode and turn on the bank reconciliation settings. Check that the opening balance agrees with last month's closing balance.
  2. Download the month's bank statement in Excel, with date, narration, withdrawal, deposit and balance columns.
  3. Go to Banking > Import Bank Statement and choose the bank, the file and its format.
  4. Open the bank reconciliation summary. Book entries and bank lines for the unreconciled period are shown together.
  5. Accept the matches Tally proposes. For near-misses, such as a payment entered as 9,215 that the bank shows as 9,216, correct the voucher so it matches.
  6. Pass vouchers for lines that are only in the bank: one consolidated receipt for small UPI collections, and single vouchers for charges, EMIs and receipts from parties you don't recognise.
  7. Reconcile, then compare the balance as per books with the balance as per bank. If a gap remains, go back to the opening balance or the previous month.

Where it usually goes wrong

How an AI agent does it from Slack

We gave an agent two Excel files for a made-up company, Meera Organics: October's bank statement (55 lines) and the bank book exported from Tally (47 vouchers). We planted the usual problems: a duplicate payment, a one-rupee difference, UPI receipts, a loan EMI, bank charges and a receipt from an unknown party. Every company, name, tax number and amount in these files is made up. The agent works in Slack, where it shows up as Mnemio AI, because Accountant AI is built on Mnemio AI.

The message in SlackMeera Organics: reconcile the current account for October. Bank statement and the Tally bank book are attached. Give me the BRS and the entries we need to pass. Don't change anything yet.
Slack message asking the AI agent to reconcile October's bank account, with the bank statement and Tally bank book attached, and the agent's progress as it reads both files
The request in Slack with both files attached, and the agent working through them.

What the agent did

  1. Read both files and checked that the opening balance (₹4,12,560.40) is the same on both sides.
  2. Matched 42 lines one to one by date, amount and cheque or reference number.
  3. Flagged the near-misses: a receipt booked as ₹18,100 that the bank shows as ₹11,800, and a payment that is ₹1 off.
  4. Found that payment voucher PMT-2300 repeats PMT-2218 (Om Sai Transport, ₹68,340).
  5. Listed the bank-only lines: charges, the NACH loan EMI, eight PhonePe settlements and a ₹2,36,000 NEFT receipt from a party not in the books.
  6. Built the BRS in a workbook and listed the entries to pass, without changing anything.
The agent's reply in Slack: closing balance per Tally and per bank, an unreconciled difference of zero, and the start of the bank reconciliation statement
The reply: both closing balances, the bank reconciliation statement and a difference of ₹0.00.

What it found

What the agent found in the October bank reconciliation
ItemAmount (₹)What to do
Cheque issued, not yet presented48,000.00Nothing to pass; it should clear next month
Deposit in transit on 31 October75,000.00Nothing to pass; check that it clears
Bank charges with GST590.00Pass a bank charges entry
Loan EMI debited by NACH32,450.00Pass it, splitting principal and interest from the loan schedule
Eight PhonePe UPI settlements11,395.00One consolidated receipt
NEFT receipt from an unknown party2,36,000.00Park in suspense and ask the client who paid
Receipt booked as 18,100; bank shows 11,8006,300.00Correct the voucher
Duplicate payment PMT-230068,340.00Delete the duplicate
Payment off by one rupee1.00Correct the voucher to 9,216

What you still check

Questions accountants ask

Can TallyPrime import a PDF bank statement?

In the tutorial, the statement had to be in Excel. Most banks let you download Excel or CSV from net banking. If you only have a PDF, an agent can read it and turn it into a clean Excel file first.

Does the agent post the entries in Tally?

No. It prepares the BRS and the list of entries, and asks before anything is changed. Tally works through Excel or XML imports, so once you approve, the entries can be prepared as an import file.

What if the opening balance doesn't match?

Fix last month first. A wrong opening balance makes every later month look unreconciled, which is why the agent checks it before matching anything.

Can it reconcile several bank accounts at once?

Yes. Give it one statement and one bank book per account, or put them in a shared folder, and it works through them one by one. It can also run on a schedule, for example on the 2nd of every month.

Hand this job to an agent

Bring one of your own files to a 30-minute call and watch an agent do it.

Book a 30-min demo