How do I import a PDF bank statement into Tally?

Tally does not read a bank statement PDF directly — its Bank Reconciliation import expects an Excel/CSV file, not a PDF. CAs handle this one of two ways: convert the PDF to Excel first (manually, or with a converter shared on forums like CAclubindia) and then use Tally's own import, or use a tool built to read the PDF itself — Vyapar TaxOne, for example, OCRs the PDF (including a scanned one) and pushes an importable file into Tally.

Route 1: convert the PDF to Excel, then use Tally's import

This is the manual route CAs share on forums. A CAclubindia shared-files listing offers exactly this: a utility to "convert any PDF Bank Statement to Excel Format and then directly import in Tally Prime, Tally 9, Tally 7.2," describing it as needing no XML or TDL changes — it's a PDF-to-Excel conversion step followed by Tally's ordinary Bank Reconciliation import.

Convert the PDF statement to Excel/CSV, by hand or with a conversion tool.
Clean the result to one plain sheet — no merged cells or blank rows, dates as DD/MM/YYYY, no currency symbols (see the "NOT A VALID FORMAT" guide if the import rejects it).
Import via Gateway of Tally > Banking > Bank Reconciliation > select the bank ledger > B: Import.

Route 2: a tool that reads the PDF directly

Vyapar TaxOne's own help page describes accepting the original PDF statement — including a scanned PDF — without a manual conversion step first. Files are uploaded under Data Entry Automation > Bulk Upload > Banking, and the platform reads and maps the transactions itself: an Excel sheet is processed in "up to 30 minutes," an original PDF "up to 1 hour," and a scanned PDF "up to 12 hours," after which the mapped transactions are pushed through to Tally.

How Charter AI does this

Charter AI reads the bank statement PDF directly — no conversion step, scanned or not — and maps each transaction to a ledger for you to review before anything is posted. A transaction only goes through once it passes deterministic checks (voucher balance, GSTIN on the counterparty, duplicates), and the reviewed set exports as a Tally Import XML file you bring in through Tally's Import option.

Start free 7-day trial

FAQs

Can Tally read a scanned bank statement PDF?

No — Tally's own import tools expect a structured spreadsheet file, not a scanned image. A scanned statement needs OCR (from a converter tool or a platform built for it) before it can reach Tally's importer.

Is a PDF-to-Excel converter safe to use for statements with hundreds of transactions?

It works, but check the output carefully before importing — PDF conversions commonly introduce blank rows, merged cells or wrong date formats that trigger Tally's "NOT A VALID FORMAT" error, so a manual review pass matters more as the row count grows.

Do I still need to reconcile after the import, whichever route I use?

Yes — an import (by either route) brings the transactions in as bank entries; matching them against your books in Bank Reconciliation is still a separate step.

Related guides

Sources checked

Last reviewed 2026-09-23

Tally, Vyapar and other product names are trademarks of their respective owners. Charter AI is not affiliated with them.