How to import a bank statement into TallyPrime

Which file formats does TallyPrime accept?

TallyPrime's Bank Statement import reads Excel, CSV and, for some banks, MT940 files in the layout each bank's portal produces. There is no column-mapping screen: Tally recognizes the format of a supported bank. Tally's help says plainly that you cannot import a PDF statement or a "CSV/Excel converted from PDF" (Import Bank Statements in TallyPrime).

For the largest Indian banks, Tally's list of supported banks shows these statement formats:

If your bank or its file format isn't supported, Tally asks you to write to support@tallysolutions.com so the format can be set up.

Connected Banking: statements without downloading files

For banks that support it, TallyPrime can fetch the statement itself. Connected Banking needs Release 6.0 or later and an active Tally Software Services (TSS) subscription; you get the statement from Alt+Z (Exchange) → All Banking Options → Get Statement, and it flows into the same reconciliation screens. If your bank supports it, this is the least work of all — no files to download or import.

Can I import a PDF bank statement into Tally?

No. TallyPrime doesn't read PDF statements, and its bank statement import rejects CSV or Excel files made from PDFs. So the first question is whether you really need the PDF: if the period is still available in net banking, download it there as Excel or CSV and use the import above.

PDFs are what you're left with for e-mailed statements, periods older than the portal lets you download, closed accounts, scanned copies and statements a client sends you. For those, the realistic route is to convert the PDF into a clean Excel file and record the entries in Tally from it.

PDF statements: convert to Excel, then post the vouchers

1. Unlock or upload the PDF. Many Indian banks send password-protected PDFs. Bank Statement Categorizer accepts the password directly (it's used once and never stored), or see how to remove the password from a bank statement PDF.
2. Check the conversion. Every statement is checked against its own balances — opening balance + deposits − withdrawals = closing balance, and the running balance on every row — so you know no line was missed.
3. Name categories after your ledgers. Rename the categories to match your Tally ledgers (Bank Charges, Rent, Salary, Sundry Debtors…) and add rules for regular payees, so each row already says which ledger it belongs to.
4. Export to Excel and sort by category: one Excel row becomes one voucher.
5. Enter the vouchers in TallyPrime: withdrawals as Payment (F5), deposits as Receipt (F6) and transfers between your own bank and cash accounts as Contra (F4), with the Payee or Description as narration.
6. Reconcile. Open the Bank Reconciliation report for the ledger (Alt+G → Bank Reconciliation) and set the bank date for each entry from the statement, or select it and press F9 (Set Status).

What about bulk import from Excel or Tally XML?

TallyPrime 4.0 added Import Data from Excel (Alt+O → Transactions) with mapping templates, for masters and vouchers such as sales invoices. For bank entries, though, Tally's own FAQ currently says that TallyPrime "does not support importing bank transactions via the Import Data from Excel feature", and bank statements are meant to go through Bank Statement import instead. Check the current import FAQ or ask your Tally partner before building a workflow around it, and test on a backup company first.

Bank Statement Categorizer doesn't export Tally XML or a Tally import template. What you get is a clean, balance-checked, categorized Excel or CSV file — the right input for checking and entering the transactions, not a file Tally imports by itself.

Tips for Indian bank statements

• Dates and amounts: most Indian statements use DD/MM/YYYY dates and separate withdrawal and deposit columns. In our Excel export, dates are real date cells and amounts are one signed number — negative for withdrawals — so sorting and SUMIF work immediately.
• Multiple accounts in one PDF: a statement with several accounts becomes one statement per account, so each maps to its own bank ledger.
• Cheque numbers and UPI references stay in the Description column, which helps when Tally shows a potential match.
• A whole year at once: upload twelve monthly PDFs and export them as one Excel file, optionally limited to the financial year's dates (1 April to 31 March).

Questions