Can Tally Prime natively import bank statement PDFs?

No, Tally Prime does not natively support importing PDF files. It only supports Excel (.xlsx) and CSV (.csv) formats for importing bank statement details via the Bank Reconciliation Statement (BRS) module.

What is the best way to handle password-protected bank statement PDFs?

You must remove the password protection from the bank statement PDF before parsing it. The simplest method is to open the PDF in Google Chrome with the password, then use Ctrl+P to print it as a new PDF without a password.

How do I reconcile bank PDF transactions in Tally?

To reconcile transactions from a bank PDF, extract the transaction rows into Excel/CSV format using a PDF-to-Excel converter, then map them to your Tally ledgers using the Bank Reconciliation utility (Banking → Bank Reconciliation → Auto Reconciliation).

Which banks provide Excel downloads for direct Tally import?

HDFC, ICICI, SBI, Axis, and Kotak banks all provide downloadable Excel/CSV statement formats from their Net Banking portals. These can be directly imported into TallyPrime's BRS module after column mapping, without requiring PDF conversion.

How to Import PDF Bank Statements into TallyPrime

Bank Reconciliation Statement (BRS) is one of the most fundamental and legally essential accounting tasks. Every business with a current account must verify at least monthly that the bank balance in their Tally Prime books exactly matches the closing balance on their bank statement. When these two numbers differ, it indicates unrecorded transactions, timing differences, or accounting errors.

Most banks deliver monthly statements in PDF format via email, which creates a challenge for accountants: TallyPrime does not natively read PDF files. This guide provides the complete workflow to bridge this gap — from decrypting password-protected PDFs to importing transaction data into Tally's BRS module.

Why Tally Prime Cannot Import PDFs Directly

TallyPrime's import engine is designed for structured data. It accepts Excel (.xlsx), CSV (.csv), and XML formats because these formats have clearly defined column positions for date, description, debit, and credit values.

PDF files, on the other hand, store content as positioned text elements — not as structured tables with column headers. The same bank's PDF statement format can differ between months, making it impossible for Tally to parse PDFs natively without an external parsing layer.

Step 1: Unlock Password-Protected Bank Statement PDFs

Most banks encrypt their email-delivered PDF statements with a password. Before you can process the PDF, you must remove this encryption. The easiest method uses only your web browser:

Right-click the PDF file and select Open With → Google Chrome.
Enter your bank statement password when prompted.
Press Ctrl+P to open the print dialog.
Set the destination to Save as PDF.
Click Save. The new PDF will have no password protection.

Common bank statement password formats:

HDFC: First 4 letters of name + Date of Birth (DDMMYYYY)
SBI: First 5 letters of name + Last 5 digits of account number
ICICI: Full account number (no spaces)
Axis: Customer ID (found on debit card or passbook)

Step 2: Convert PDF to Excel Format

Once unlocked, convert the PDF statement to Excel using one of these methods:

Adobe Acrobat: Open the PDF → File → Export To → Spreadsheet → Microsoft Excel Workbook.
Online converter: Tools like Smallpdf, IlovePDF, or PDF2Excel can convert PDF tables to Excel. Use only for non-sensitive statements.
Download directly from Net Banking: For HDFC, ICICI, SBI, Axis, and Kotak, you can download statements in Excel/CSV format directly from Net Banking, bypassing the PDF entirely.

Step 3: Map Columns for TallyPrime BRS Import

TallyPrime's Bank Reconciliation module requires specific columns in your Excel file. The standard required columns are:

Tally Required Field	Typical Bank Statement Column
Transaction Date	Date, Txn Date, Value Date
Narration / Description	Description, Particulars, Remarks
Debit Amount	Debit, Withdrawal, Dr
Credit Amount	Credit, Deposit, Cr
Running Balance	Balance, Closing Balance

In TallyPrime, navigate to Banking → Bank Reconciliation → Auto Reconciliation → Import Bank Statement. Map each Excel column to the corresponding Tally field and save the configuration for future use.

Step 4: Auto-Reconcile Transactions in TallyPrime

After importing, TallyPrime's auto-reconciliation module compares each bank statement row against your existing ledger entries by:

Matching the transaction amount exactly.
Comparing the transaction date (within a configurable window).
Matching keywords in the narration/description field.

Matched transactions are marked as "Reconciled." Unmatched entries appear in a pending queue for manual review. For each unmatched entry, you must either:

Create a new contra/receipt/payment voucher in Tally for the missing transaction, or
Mark the entry as "In Transit" (for cheques issued but not yet cleared), or
Flag it as an error for investigation.

TrulyInvoice: Purchase-Side Bank Reconciliation

While the BRS module handles bank reconciliation, a large portion of bank debits consist of vendor payments — payments made for purchase invoices. For accurate BRS, each bank debit for a vendor payment must be matched to the corresponding purchase voucher in your books.

TrulyInvoice closes this loop by reading your vendor PDF invoices using OCR and creating matching F9 purchase vouchers in Tally Prime. When your bank statement shows a payment to "Apex Supplies Pvt Ltd" for ₹47,200, TrulyInvoice ensures there is a corresponding purchase voucher against the same vendor in your books — making BRS matching instant and error-free. TrulyInvoice operates on a monthly subscription of plans starting at ₹399/month for 2,000 pages per month.