How to Import Bank Statement PDF & Excel into Tally Prime

Bank reconciliation is a cornerstone of accurate auditing. While Tally Prime allows you to perform Bank Reconciliation (BRS) manually or import select bank e-statements, it does not support uploading raw PDF bank statements. To get these transactions into your ledgers, you must map them to vouchers.

Understanding BRS vs. Transaction Import in Tally

Before starting, understand the difference between these two accounting operations:

Bank Reconciliation (BRS): Used when the vouchers (payments/receipts) already exist in Tally. You import the statement or enter dates to match Tally's voucher date with the bank's clearing date.
Voucher Import: Used when the vouchers do not exist in Tally. You import the transactions as new Payment, Receipt, or Contra entries in your books.

Method 1: Native Bank Reconciliation (BRS) in Tally Prime

To perform BRS using supported bank Excel/CSV statements:

Go to Gateway of Tally > Banking > Bank Reconciliation. Select your Bank Ledger.
Press Alt+O (Import) > Bank Statement.
Browse and select the statement Excel/CSV file downloaded from your net banking portal.
Tally matches transactions based on amount and instrument number. Press Ctrl+A to accept matched entries.

Method 2: Importing Transactions as Vouchers via TallyXML

To import raw bank rows as new accounting vouchers, Tally requires the data in its native XML structure:

Convert your Excel bank statement into a valid Tally XML file.
Go to Gateway of Tally > Import > Transactions.
Select the XML file and confirm. If ledgers match, Tally creates the vouchers (debiting/crediting the correct accounts).

Method 3: Direct Sync using TrulyInvoice (Best for PDFs)

Converting statements to XML manually is complicated. TrulyInvoice automates the translation:

PDF Parser: Upload your Axis, HDFC, SBI, or ICICI statement PDF (scanned or digital).
Auto-Ledger matching: TrulyInvoice scans transaction narrations and maps them to your Tally ledger names.
Direct Vouchers: Debits map to Payments (F5) or Contras (F4), credits map to Receipts (F6) or Contras.
Direct Push: Vouchers are pushed straight into your open Tally company via our secure Port 9000 connector.

Troubleshooting Common Import Errors

Error Message / Symptom	Common Cause	How to Fix
Port 9000 Not Responding	ODBC server is not enabled in Tally	Press F12 > Connectivity. Set "Act as Client/Server" to Server and set port to 9000. Restart Tally.
Ledger does not exist	Mismatch between statement party name and Tally ledger	Verify spelling in Tally or use TrulyInvoice's mapping suggestion tool to link them.
Company Not Open	Tally is running but no active company is loaded	Open your target company in Tally before starting the sync.

Frequently Asked Questions

Q: Can I import statements downloaded as PDF files natively?

A: No. Tally Prime does not read PDF files. You must convert them to Excel (requiring manual mapping templates) or use a direct integration client like TrulyInvoice.

Q: Does TrulyInvoice charge per transaction?

A: No. TrulyInvoice charges a flat rate of plans starting at ₹399/month for Lite (1,000 pages) and ₹599/month for Plus (2,000 pages), enabling automated data entry directly to Tally Prime.

Q: What happens if I import duplicate statement files?

A: Tally does not always detect duplicates on its own. TrulyInvoice features a pre-import validator that checks for overlapping dates and amount hashes to block duplicates.

Sync Invoices and Statements Directly to Tally Prime

Eliminate complex BRS PDF formats. Upload HDFC, SBI, ICICI, or other statement PDFs directly to TrulyInvoice, match entries with the auto-suggest engine, and sync with Tally at flat plans starting at ₹399/month.

Start Free Trial

How to Import Bank Statement in Tally Prime: Step-by-Step