Bank Statement to Tally: Convert PDF Statements to Excel for TallyPrime

Typing a month of bank entries into Tally by hand is slow and error-prone. Convert the PDF statement into a clean, balance-checked Excel file and bring it into TallyPrime or your reconciliation.

How do I import a PDF bank statement into Tally?

Tally doesn't read PDF statements, so convert the PDF to Excel first: upload it here and download a sheet with date, narration, reference, amount and balance. Rearrange the columns into the Excel template your TallyPrime release or import utility expects (withdrawal and deposit in separate columns), then import it and review the entries before saving.

From PDF statement to Tally in four steps

  1. 1

    Convert the PDF to Excel

    Upload the statement below — SBI, HDFC, ICICI, Axis or any other bank, digital or scanned. Every row is checked against the running balance.

  2. 2

    Match the template

    Rearrange the columns into the layout your import expects — typically Date, Narration, Cheque/Ref No., Withdrawal, Deposit, Balance. Split the signed Amount with the formulas below.

  3. 3

    Import into TallyPrime

    Use the bank statement import option in TallyPrime's bank reconciliation, the Excel import available in recent TallyPrime releases, or your Tally partner's import utility.

  4. 4

    Review and reconcile

    Check the ledger mapping and vouchers before saving, then reconcile the bank ledger against the statement closing balance.

Convert your statement to Excel for Tally

Drop PDF here or click to upload

Max 20 MB · Text-based or scanned PDF

How the pieces fit together

Bank Statement Parser does one job: it turns the PDF statement into structured, verified rows in Excel or CSV. There is no direct Tally integration — the import itself happens inside TallyPrime or through a Tally import utility, and the exact menus and templates depend on your TallyPrime release and setup.

What we remove is the slowest, most error-prone part: reading hundreds of lines off a PDF. Because each row is reconciled against the statement's running balance, you know the Excel file matches the bank before it ever reaches your books.

Typical Excel layout for a Tally bank import

DateNarrationCheque/Ref No.WithdrawalDepositBalance
2026-09-01NEFT-ACME TRADERS-INV 2231N24567891248,500.001,12,640.00
2026-09-02UPI/OFFICE SUPPLIES/PAYTM4267891234561,240.001,11,400.00
2026-09-05CHQ PAID-RENT SEP00021435,000.0076,400.00

Your template may name or order the columns differently — always follow the one your TallyPrime release or utility provides.

Split the amount into Withdrawal and Deposit

Our Excel has one signed Amount column (negative = money out). With Amount in column E:

Withdrawal

=IF(E2<0,-E2,"")

Deposit

=IF(E2>0,E2,"")

Paste the results as values before importing, and make sure dates are real Excel dates in the format your template expects.

Practical tips for Indian bank statements

  • Password-protected PDFs: most Indian banks lock e-statements (often with part of your name and date of birth). Open the PDF and save or print an unlocked copy before uploading.
  • Long narrations: UPI, NEFT, IMPS and RTGS descriptions are kept in full, so you can map ledgers by payee name or reference.
  • Scanned passbook pages and older statements are read with OCR and still balance-checked.
  • Big files: convert month by month if your import utility struggles with very large sheets.
  • Keep the Balance column for checking even if you don't import it — the last row should equal the statement closing balance.

Frequently asked questions

Can Tally import a PDF bank statement directly?

Not as a PDF — Tally works with structured data. Convert the statement to Excel first, then import it with TallyPrime's own options or a Tally import utility.

Is there a direct Tally integration?

No. We produce the Excel or CSV file; the import happens in TallyPrime or a third-party utility you already use. Menu names and templates vary by TallyPrime release, so check Tally's help for your version.

Which banks are supported?

Any bank. SBI, HDFC, ICICI, Axis, Kotak, PNB, Bank of Baroda and others all work, and you don't need to pick the bank — the layout is detected automatically.

My statement is password protected. What should I do?

Open it with the password and save or print an unlocked copy as PDF, then upload that copy.

Can I use it for bank reconciliation in Tally?

Yes. A verified Excel copy of the statement makes it quick to match entries and confirm the closing balance. Our free bank reconciliation template also helps.

Are the amounts accurate?

Each row is checked against the statement's running balance, and the response reports how many rows were verified, so mistakes are caught before they reach Tally.

How much does it cost?

The first 50 pages every month are free with no credit card. Paid plans start at $25/month for 500 pages.

Related tools and guides

Bank statement PDF to ExcelConvert any bank's PDF statement to Excel.Bank statement to CSVConvert a PDF statement to a clean CSV for any import.Bank statement analyzerExtract verified rows, then see income, expenses and cash flow.Bank reconciliation templateFree Excel template with formulas and a worked example.Bank-specific convertersStep-by-step guides for your bank's statement.

50 pages free every month

Create a free account — no credit card. Need more? See the plans.

Create free account See pricing