Punjab National Bank PDF
Statement to Excel Free
Upload your Punjab National Bank PDF statement and get a clean Excel or CSV file — date, narration, debit, credit, balance — in seconds. Runs entirely in your browser. Nothing is ever uploaded.
Independent tool. Not affiliated with or endorsed by any bank.
What makes PNB statements hard to convert — and how we solve it.
Punjab National Bank statements carry a leading Sl. No. column, a mandatory 16-digit account number password, and three distinct format variants inherited from the 2020 merger with OBC and United Bank. Each of those details breaks generic converters. Here is exactly how StatementHub handles them.
Sl. No. Column Handled Without Shifting
PNB places a serial number (Sl. No.) as the very first column in every statement. Generic PDF parsers treat it as data, pushing every subsequent column one position to the right — Narration lands in the Debit cell, Debit in Credit, and so on. StatementHub maps all seven PNB columns correctly from the start.
Chq./Ref. No. Field Preserved for Audit Trails
PNB includes a Chq./Ref. No. column specifically for cheque numbers and NEFT/RTGS reference codes. This field is critical for government salary reconciliation, NACH mandate tracking, and LIC premium verification. StatementHub retains it alongside Narration so your audit trail remains intact.
Post-2020 OBC and United Bank Legacy Formats
In April 2020, PNB merged with Oriental Bank of Commerce and United Bank of India to become India's second-largest public sector bank. Older statements from those two entities use different column structures. StatementHub detects which format variant you uploaded and applies the correct parsing logic.
Government Salary & PFMS Narration Support
PNB carries salary accounts for central and state government employees, defence personnel, and post office account holders. PFMS disbursement codes, Pay & Accounts Office credits, and inter-bank NEFT narrations are parsed in full — not truncated — so every line traces back to its source.
Password Prompt for 16-Digit Account Number
PNB protects its statement PDFs with a password equal to the customer's full 16-digit account number. Some branches issue statements locked with the date of birth in DDMMYYYY format instead. StatementHub tells you which format to try so you can unlock the file before conversion.
PNB ONE App and netpnb.com PDFs Both Accepted
Statements downloaded from the PNB ONE mobile app and those exported via the netpnb.com Account Services portal share the same 7-column format but differ in header layout. StatementHub recognises both source variants and processes every page without requiring you to split or manually clean the file first.
From PNB ONE or netpnb.com to a clean spreadsheet in four steps.
Export from PNB ONE or netpnb.com
On the PNB ONE app, tap Account then Statement and choose Download. On the internet banking portal at netpnb.com, go to Account Services then Account Statement, set your date range, and save the PDF. When prompted for a password, enter your full 16-digit PNB account number.
Upload the PDF to StatementHub
Drag your PNB statement PDF onto the converter above or click to select it. The file is processed entirely within your browser session — it is not transmitted to any external server or stored anywhere after the tab is closed.
Parser maps all 7 PNB columns
StatementHub identifies PNB's seven-column layout — Sl. No., Date, Narration/Particulars, Chq./Ref. No., Debit, Credit, Balance — and maps each one to the correct spreadsheet column, eliminating the shift error that occurs when generic tools encounter the leading Sl. No. field.
Download as Excel or CSV
Preview your transactions, verify totals, then download as .xlsx for Excel or Google Sheets, or as .csv for direct import into Tally Prime, PFMS, or government accounting software. Chq./Ref. No. is included as a separate column.
Supported PNB statement sources — and one format that cannot be converted
Digital text-based PDFs from the PNB ONE app and the netpnb.com portal convert correctly. Statements inherited from OBC and United Bank pre-merger accounts are also supported in most cases. The only format StatementHub cannot process is a scanned or photographed passbook page, since those produce image-only files with no extractable text.
You upload
PNB PDF formats accepted
AI converts
You download
Clean structured output
Excel (.xlsx)
Opens in Microsoft Excel, Google Sheets, LibreOffice
CSV (.csv)
Direct import into Tally, Zoho Books, QuickBooks, Busy
Columns in every file
PNB's 2020 merger: how it affects your statement format
In April 2020, Punjab National Bank merged with Oriental Bank of Commerce (OBC) and United Bank of India — creating India's second-largest public sector bank. If your account was originally with OBC or United Bank, your statement format may differ from standard PNB.
Recommendation: If you have a post-2020 PNB account (any account opened or migrated after April 2020), download your statement from netpnb.com — it will generate the standard 7-column PNB format that StatementHub handles correctly.
Four reasons your PNB statement fails to convert — with exact fixes for each
Most PNB conversion failures trace back to one of four causes: the 16-digit account number password, an image-based PDF from the PNB ONE app, the Sl. No. column-shift that corrupts output in generic tools, or a pre-2020 statement from OBC or United Bank. Each has a specific resolution documented below.
Why PNB account holders need a bank-specific statement converter
Punjab National Bank is India's second-largest public sector bank, serving over 180 million customers across government salary accounts, defence pay accounts, post office-linked savings accounts, and NACH-mandated insurance premium accounts. Its statement PDF is designed to be printed at a branch counter — the Sl. No. serial column, the mandatory 16-digit account number password, and the merged-bank format variants all exist for operational reasons that make the file hostile to standard data extraction.
How the Sl. No. column corrupts your data
PNB prints a serial number in the leftmost column of every statement row. When a generic PDF-to-Excel tool reads the file, it counts seven columns and assigns the first to Sl. No. — but does not understand that Sl. No. is metadata, not a financial field. The result is that Narration shifts into the Sl. No. column, Debit into Narration, Credit into Debit, and Balance into Credit. Every amount you see in the output is wrong. StatementHub strips Sl. No. from the data map before writing to Excel.
Who converts PNB statements most often?
Central and state government employees verifying monthly salary, DA, and HRA credits. Defence and paramilitary personnel reconciling PNB pay accounts. Post office savings account holders linked to PNB. LIC policyholders tracking NACH premium debits. Chartered accountants preparing ITR documents for clients with PNB salary accounts across Punjab, Haryana, Uttar Pradesh, and Delhi NCR.
Every field PNB carries — extracted accurately
StatementHub outputs Date in DD/MM/YYYY format, the full Narration/Particulars string including PFMS disbursement reference IDs and Pay & Accounts Office codes, the Chq./Ref. No. field for cheque and NEFT/RTGS tracing, separate Debit and Credit amount columns, and the running Balance. PNB's complete seven-field row structure lands in clean, named Excel columns.
Use cases at a glance
- Central govt salary & DA credit verification
- Defence PNB pay account reconciliation
- PFMS disbursement reference tracking
- LIC & insurance NACH debit audit
- ITR filing for PNB salary account holders
- Post office savings account statement analysis
- Tally Prime import for North India traders
- CA bulk PNB statement processing for ITR season
Export formats
Excel (.xlsx) — preserves column types and date formatting for Excel & Google Sheets.
CSV (.csv) — standard format for Tally, PFMS, and any accounting software.
Common questions about PNB statement conversion.
Convert statements from any bank.
If you also hold accounts with SBI, HDFC Bank, Canara Bank, or Axis Bank, each converter below is calibrated for that institution's specific PDF column layout — not a one-size-fits-all parser applied to every bank the same way.
Got a statement ready?
Drop in the PDF, get a clean spreadsheet back. Free, unlimited, and nothing is ever uploaded.
Convert a statement