Convert a Punjab National Bank (PNB) Statement to Excel

PNB statements carry heavy transaction-code prefixes and a summary block that reads like data. How to convert one to a clean Excel file.

Punjab National Bank statements are readable but noisy. The transactions extract reliably; the work is in separating the real data from everything printed around it.

Transaction code prefixes

PNB prefixes most narrations with an internal transaction code — a short alphanumeric string identifying the channel and instrument type. It is genuinely useful for categorising later, but left inline it makes the description column hard to scan and hard to group.

Splitting the code into its own column gives you both: a readable description, and a code you can pivot on to see how much moved by NEFT versus UPI versus cash.

The summary block problem

PNB prints a period summary — opening balance, total debits, total credits, closing balance — in the same column positions as the transaction table. Converters that identify transactions by pattern-matching rows containing amounts pull all four lines in as transactions.

The result is four phantom rows, inflated totals, and a balance chain that fails immediately. Those lines belong in the verification data, where they are genuinely valuable, not in the transaction list.

Date format

PNB uses DD/MM/YYYY. A tool that defaults to US conventions reads 05/03/2026 as 3 May instead of 5 March, and roughly 40% of the rows in any month are ambiguous enough to be silently reordered. Inferring the convention from the whole file — if any date has a first component above 12, the format is settled — avoids the entire problem.

Using the transaction codes

Once the code is in its own column, it answers questions the description cannot. Grouping by code shows how much moved by NEFT versus UPI versus cash in a period, which is genuinely useful for a business account under scrutiny.

Cash transactions in particular are worth isolating. For any account being reviewed by a lender or an auditor, the cash-versus-electronic split is one of the first things looked at.

Verifying a PNB conversion

Check for rows with no date Any row carrying an amount but no date is a summary line that should not be in the transaction list.
Compare debit and credit totals Against the printed period figures.
Walk the balance chain From opening balance to closing balance.
Confirm the dates are inside the period Which catches a DD/MM misreading immediately.

Frequently asked questions

Does this work with PNB passbook printouts?

Scanned passbook pages need OCR and convert less accurately than an e-statement. Download the PDF from PNB internet banking if the account is still active.

How much of my turnover was cash?

Group by transaction code and filter to the cash codes. It is one pivot once you have moved the code into its own column.

Are the transaction codes preserved?

Yes, exactly where PNB prints them: at the start of the narration. Nothing is split out, so a LEFT or TEXTBEFORE formula moves the code into a column of its own when you want to pivot on it.

Can I convert several years of PNB statements?

Yes. Convert each period separately. Each export keeps PNB's own columns, so periods printed in the same layout append cleanly.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.