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.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your Punjab National Bank statement into Excel
-
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.
-
Upload it here
Scans and phone photos work too.
-
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.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-01-02 Salary - Example Employer Ltd | Salary - Example Employer Ltd | 2,500.00 | 3,500.00 | |
| 2026-01-05 Card payment - Sample Grocery Co | Card payment - Sample Grocery Co | 120.00 | 3,380.00 | |
| 2026-01-09 Rent - Placeholder Properties | Rent - Placeholder Properties | 1,200.00 | 2,180.00 | |
| 2026-01-14 Transfer from savings | Transfer from savings | 300.00 | 2,480.00 | |
| 2026-01-20 Utility bill - Demo Energy Co | Utility bill - Demo Energy Co | 80.00 | 2,400.00 | |
| 2026-01-27 Card payment - Fictional Coffee Co | 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.
-
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?
Does PNB charge for monthly email statements?
Can I convert the statement from PNB ONE's mPassbook?
Can I import converted Punjab National Bank rows into QuickBooks or Xero?
Convert your Punjab National Bank statement to Excel
Page 1 free, no sign-up to see it; just an email to download.
More Bank Statement Converters
pdf2text is independent and not affiliated with or endorsed by Punjab National Bank.