PNB statement PDF to Excel

How to download your PNB statement as a PDF

1. Log in to PNB Internet Banking or the PNB ONE app.
2. Open the account and choose its account statement option (in PNB ONE it sits under mPassbook). Menu names change from time to time.
3. Pick the period, download the statement as a PDF and save it. A statement PNB emailed you works too.

Then drop the PDF in the box above, or click it to choose the file.

What you get

PNB statements come in a few layouts. A common one prints Txn Date, Description, Cheque No., Dr Amount, Cr Amount, Balance and Value Date, with dates such as 02/09/2026 and balances such as 46,365.00 Cr. The converter finds the debit, credit and balance columns by their headings (Dr Amount, Withdrawal, Debit and the like), reads a balance marked Dr as negative, keeps a cheque number in the description and skips the value date. Every row is checked against the printed balance, so a misread row shows up highlighted. Oriental Bank of Commerce and United Bank of India accounts moved to PNB in April 2020, so their statements now come in PNB's layout. A PDF the old bank printed before the move looks different: try it, and the balance check shows whether every row was read.

If PNB's own download gives you the period you need as an Excel file, use it. The converter is for the PDF statements: emailed ones, older periods, or one someone sent you for a loan or visa file.

How it works, and what it can't do

OfflineStatement is a general reader for text-based PDF statements: it finds the transaction table by its column headings and turns each dated row into a spreadsheet row. It was not built with or tested by PNB, and statement layouts change, so check the result against the PDF. Where the statement prints a running balance, every row is checked against it and rows that don't add up are highlighted. Scanned or photographed statements (images, not text) are not supported. Password-protected PDFs work: you type the password and it stays on your device.

Open the CSV in Excel, Google Sheets or QuickBooks

Excel: double-click the CSV, or use Data > From Text/CSV. Google Sheets: File > Import > Upload, then choose the CSV. QuickBooks Online: the bank-upload CSV needs Date, Description and Amount; Pro exports exactly that format (see PDF to QuickBooks), or you can trim the free CSV to those columns.

Open the converter

Other bank guides: Chase · Bank of America · Wells Fargo · Capital One · American Express · Citi · U.S. Bank · PNC · TD Bank · Discover · Apple Card · Truist · Navy Federal · HSBC UK · Barclays · Lloyds · NatWest · Santander UK · Monzo · Halifax · Nationwide · Starling · TSB · first direct · RBC Royal Bank · TD Canada Trust · Scotiabank · CommBank · Westpac · ANZ · NAB · BMO · CIBC · SBI · HDFC Bank · ICICI Bank · Axis Bank · Kotak · Bank of Baroda · Canara Bank · Union Bank of India · IDFC FIRST Bank · Yes Bank · Indian Bank · IDBI Bank · UCO Bank · Bank of Maharashtra · South Indian Bank · Bandhan Bank · IndusInd Bank · Federal Bank · Bank of India · Central Bank of India · FNB · Capitec · Absa · Standard Bank · Bank of Ireland · AIB · Maybank · DBS / POSB · OCBC · UOB · Any bank

PNB and the other bank names on this site are trademarks of their respective owners. OfflineStatement is an independent tool by Tofu Labs and is not affiliated with, endorsed by or sponsored by any bank.