Convert a PNB bank statement PDF to Excel, CSV & Tally XML,
without uploading it anywhere

Drop your Punjab National Bank e-statement below and export it as .xlsx, CSV or Tally Prime vouchers. Parsing runs inside your own browser tab — the PDF is never sent to a server — and every row is checked against the statement's running balance before you export.

Drop your bank statement PDF here

or click to choose a file · SBI, HDFC, Kotak, Axis, ICICI, Federal e-statements

Which PNB statements work

Two layouts are handled: the netbanking statement and the branch/CBS print. Both are supported — you do not need to know which one you have.

verified Verified against a real statement with a full balance-chain pass, across both PNB layouts.

Scanned or photographed statements are not supported for any bank yet — they are images and need OCR. Native e-statements downloaded from netbanking are also more accurate, because the text is already in the file rather than being guessed from pixels.

How to download your PNB statement as PDF

  1. Sign in to PNB retail internet banking or PNB ONE.
  2. Open the account and select the statement period.
  3. Download the statement as PDF.
  4. Drop it into TieOut and enter the password if prompted.

Menu labels move around as banks redesign their portals. If yours does not match, look for “statement”, “e-statement” or “account statement” and choose PDF rather than Excel or CSV — the PDF is the authoritative document, and TieOut validates against the balances printed on it.

What TieOut does with PNB's layout

A PDF has no table in it. It stores text fragments at x/y coordinates, and the neat columns you see on screen are visual alignment. Rebuilding rows means knowing what this particular bank does — and PNB does the following.

  • The netbanking layout uses a single amount column plus a separate DR/CR type column, rather than separate withdrawal and deposit columns. The sign of every transaction comes from that one letter, so misreading it inverts the entry.
  • PNB netbanking statements can be ordered newest first. The running balance then runs backwards down the page, and a validator that assumes chronological order reports every row as broken. TieOut detects the ordering and restores chronology before checking the chain.
  • On the branch/CBS print the narration is the last column, not the second — the reverse of nearly every other Indian statement — and balances carry a trailing “ Cr.” suffix with no thousands separators.

PNB statement columns

ColumnsNetbanking: Date | Instrument ID | Amount (INR) | Type (DR/CR) | Balance | Remarks · Branch/CBS: Date | Withdrawal | Deposit | Balance | Alpha | CHQ. NO. | Narration
Date formatDD-MM-YYYY

How the PNB conversion is checked

Every extracted row must satisfy balance = previous balance + credit − debit, and the last balance must equal the closing balance printed on your statement. Rows that break the chain are flagged rather than dropped, so a fully green table is provable evidence that no transaction was missed. That is running-balance validation, and it runs on your file rather than on someone else's test set.

Import a PNB statement into Tally Prime

Export as Tally XML, create the bank ledger in Tally under the same name you exported with, then go to Gateway of Tally → Import → Vouchers and select the file. Rows arrive as Receipt and Payment vouchers with stable IDs, so re-importing the same statement updates rather than duplicates. The full path, including the two things that usually go wrong, is in how to import a bank statement into Tally Prime.

Is it safe to convert a PNB statement online?

It depends entirely on where the file goes. Almost every online converter uploads your PDF to its server, which puts your account number, balances and every transaction into someone else's storage under their retention policy. TieOut does not upload the file at all — and you can prove it in ten seconds by switching off your Wi-Fi and converting anyway. More on what different converters actually do with your statement.

Punjab National Bank conversion FAQs

Does TieOut support PNB bank statements?

Yes. Both PNB layouts are supported — the netbanking format, which uses a single amount column with a DR/CR type flag, and the branch/CBS print, which puts the narration in the last column. TieOut picks the right one from the file, and every row is checked against the running balance so you can see the extraction is complete.

How do I convert a PNB bank statement PDF to Excel?

Download the statement as a PDF from PNB internet banking or PNB ONE, drop it into TieOut and export as .xlsx or CSV. The file is parsed in your browser rather than uploaded, and it is free with no account needed.

Why does my PNB statement show transactions newest first?

PNB netbanking statements are sometimes ordered newest first, which makes the running balance descend down the page. That is the statement, not the conversion. TieOut detects the ordering and restores chronology before checking the balance chain, rather than flagging every row as broken.

Other banks