Punjab National Bank Statement PDF to Excel

Punjab National Bank emails a statement every month once you register, and stops posting paper copies when you do. Savings, current, overdraft and cash credit accounts all qualify, free of cost. So a year of PNB records is usually twelve emailed PDFs. Upload them here to get one consistent table per statement, ready for Excel, CSV or JSON, with dates written as YYYY-MM-DD.

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.

Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your Punjab National Bank statement into Excel

  1. Download the PDF statement from Punjab National Bank online banking

    • Log in to PNB Internet Banking or the PNB ONE app.
    • Open the account statement: PNB lists 'Statement of a/c' among its Internet Banking features, and PNB ONE's mPassbook offers a detailed view and download of the account statement.
    • Choose the statement period and download the statement.
    • Save the statement for the period you need as a PDF.
    Go to Punjab National Bank Online Banking
  2. Upload it here

    Scans and phone photos work too.

  3. Download Excel, CSV, or QuickBooks and Xero CSV

    Check the rows against the statement, then export.

Sample result

Your Punjab National Bank statement in Excel

Made-up sample rows, not a real statement.

sample-statement-2026-01.xlsx Jan 2026 · INR
Sample bank statement rows with made-up data, amounts in INR
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 Card payment - Fictional Coffee Co 15.00 2,385.00

Statement notes

What to know about Punjab National Bank statements

Overdraft and cash credit balances run negative

On OD and CC accounts the balance is often a debit, which statements may mark with Dr. Because every transaction is kept as a signed amount, the running-balance arithmetic works either side of zero, and the opening-to-closing check catches a row whose sign was read the wrong way.

Registration by SMS or Internet Banking

PNB takes e-statement registration through Internet Banking service requests, at a branch, through its contact centre, or by SMS from your registered mobile: ESTMT, the last four digits of the account, and your email ID. After that the monthly PDFs arrive without further requests.

Twelve PDFs make a year

Monthly statements turn a financial year into twelve uploads. They're compared as a set, so a month that never arrived or a statement saved twice shows up before you start totalling. If a month is missing, PNB issues duplicates at the branch.

Output and review

From Punjab National Bank PDF to your books

Accounting tip

TallyPrime's statement import is meant for the Excel or CSV files PNB's portal produces, not converted PDFs. For emailed months, open the converted sheet beside Tally's manual bank reconciliation and enter the bank date against each voucher that matches.

  • Checked before export

    Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.

  • Export formats

    Excel, CSV, JSON, or QuickBooks and Xero CSV.

    Files for QuickBooks Online

    Files for Xero

  • Private workspace

    HTTPS uploads, kept private until you ask support to delete them.

FAQ

Punjab National Bank statement questions

I registered for PNB e-statements. Can I still get a printed one?
PNB discontinues physical statements after email registration. If you need a printed copy of a particular month, the branch can issue a duplicate. For bookkeeping the emailed PDF is enough: convert it here and keep the original with your records.
Does PNB charge for monthly email statements?
PNB's e-statement page says savings, current, overdraft and cash credit account holders may receive statements every month on their registered email free of cost. Converting them here is separate: you can try a document's first page free, then pay per document or subscribe.
Can I convert the statement from PNB ONE's mPassbook?
PNB ONE's mPassbook gives a detailed view of the account and lets you download the statement. Once you have that file as a PDF, upload it here like any emailed statement; the rows come out in the same columns, with withdrawals as negative amounts.
Can I import converted Punjab National Bank rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your Punjab National Bank statement to Excel

Page 1 free, no sign-up to see it; just an email to download.

pdf2text is independent and not affiliated with or endorsed by Punjab National Bank.