IN
Upload a Punjab National Bank statement PDF and every transaction comes back as clean rows — date, narration, instrument number, withdrawal, deposit and balance — checked so the closing figure ties out. Export to Excel, CSV, or a Tally-ready XML for your accountant.
PNB is one of India's big public-sector banks, and its accounts tend to run the full range — old-fashioned cheques and cash alongside the UPI and NEFT that everything moves on now. That mix is what a statement has to capture, and it's what makes a plain copy-paste come apart.
What a PNB statement looks like
A PNB account statement uses these columns:
Column | What's in it |
|---|---|
Date | The transaction (and often value) date |
Narration | The payment detail and reference |
Instrument / Cheque No | The cheque or reference number |
Withdrawal | Amounts debited |
Deposit | Amounts credited |
Balance | The balance after each entry |
Two things stand out on a public-sector statement like PNB's. The Instrument / Cheque No column still matters — cheques and demand drafts are common, and each needs its number kept with its amount rather than merged into the next row. And the Narration carries the modern detail: a UPI handle and reference, a NEFT or IMPS beneficiary, a standing instruction. Both run long and wrap across lines, and a rough export splits them into stray rows. The converter keeps each entry whole — cheque number and narration on the one transaction it belongs to.
Where to download your PNB statement
- Internet Banking: sign in at netpnb.com, open Account Statement, choose the account and period, and download the PDF.
- PNB ONE app: open the account, select Statement, set the period and save or email the PDF.
A PNB e-statement PDF is usually password-protected — open it with the password the bank sets (shown on the download page). Once open, the text is selectable and the conversion is exact. A scanned passbook or printout works too, through OCR.
Getting the numbers where you need them
- Excel or Google Sheets — a clean `.xlsx` or CSV, one row per transaction, ready to total, filter and pivot.
- Tally — a Tally-ready XML so the entries import as vouchers rather than being keyed in by hand.
- Zoho Books, QuickBooks and others — the same data in each one's format.
Before download, the maths is checked: opening balance, plus deposits, minus withdrawals, has to reach the closing balance. On a statement mixing cheques with UPI and NEFT, that check is what catches a single entry dropped between pages.
Common snags with PNB statements
- Cheque and instrument numbers. Each stays tied to its amount rather than merging into the next row.
- Long narrations wrap. UPI and NEFT detail is kept on one row instead of being split.
- Password-protected PDF. Open it with the PNB password first, then convert the opened file.
Frequently asked questions
Can I convert a PNB statement to Excel for free?keyboard_arrow_down
Yes. Upload the PDF and get a clean Excel or CSV back free to start, with the closing balance checked so it reconciles.
Are cheque numbers kept on my PNB statement?keyboard_arrow_down
Yes. PNB accounts still see plenty of cheques and drafts, and the converter keeps each instrument number tied to its amount so you can match it to your records.
Can I import a PNB statement into Tally?keyboard_arrow_down
Yes. Export a Tally-ready XML and the transactions import as vouchers, so your accountant doesn't have to key a month of entries by hand.
Does it keep the value date as well as the transaction date?keyboard_arrow_down
Yes. PNB statements often show a value date alongside the transaction date, and the converter preserves both — so reconciliation to the day stays accurate when a cheque clears a day after it was entered.
My PNB PDF is password-protected — will it still convert?keyboard_arrow_down
Yes, once you open it. Enter the password PNB provides, and the converter then reads the opened statement's narration, instrument numbers and amounts.
