Convert a PNC statement to Excel, CSV or QuickBooks
PNC statements split the month into several activity tables rather than one. Reading them as a single list is where most PNC conversions go wrong.
Covers Virtual Wallet, Business Checking, Cash Rewards cards.
Drop a PDF bank statement here
Only pages with transactions count against this.
Review
Example statementHabib Bank Limited · 0441-79002251-03 · 2026-04-01 to 2026-04-30
- Row-by-row running balance
- Page subtotals
- Opening + movement = closing
- Printed credit / debit totals
- Printed credit / debit totals
- Transaction count
Arithmetic only. Verifies that amounts, balances and totals agree. Does not verify descriptions or dates, and cannot detect two errors that cancel out.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| Apr 02, 2026 | IBFT TRANSFER FROM ZAINAB TRADERS / INV-4471 | PKR 185,000.00 | PKR 1,247,350.00 | |
| Apr 03, 2026 | POS PURCHASE 4157 IMTIAZ SUPER MARKET KARACHI | PKR 12,480.00 | PKR 1,234,870.00 | |
| Apr 05, 2026 | UTILITY PAYMENT K-ELECTRIC ACCOUNT 04412297 | PKR 38,640.00 | PKR 1,196,230.00 | |
| Apr 08, 2026 | CHEQUE 000241 CLEARED — AL-NOOR PACKAGING | PKR 220,000.00 | PKR 976,230.00 | |
| Apr 11, 2026 | IBFT TRANSFER FROM MEHRAN ENTERPRISES / PO-8890 | PKR 342,500.00 | PKR 1,318,730.00 | |
| Apr 14, 2026 | SALARY DISBURSEMENT APRIL 2026 — 11 EMPLOYEES | PKR 685,000.00 | PKR 633,730.00 | |
| Apr 17, 2026 | BANK CHARGES — ONLINE TRANSFER FEE | PKR 1,150.00 | PKR 632,580.00 | |
| Apr 21, 2026 | IBFT TRANSFER FROM SIDDIQUI BROTHERS / INV-4488 | PKR 128,750.00 | PKR 761,330.00 | |
| Apr 24, 2026 | POS PURCHASE 9921 TOTAL PARCO FUEL STATION | PKR 18,900.00 | PKR 742,430.00 | |
| Apr 28, 2026 | PROFIT CREDITED — SAVINGS ACCOUNT | PKR 4,318.00 | PKR 746,748.00 | |
| Closing balance10 transactions | PKR 746,748.00 | |||
Export
Preview is free. Create a free account to download.
Guest plan · preview only, no downloads
The sign lives in the section heading, not in the number
PNC prints amounts as positive numbers throughout and tells you what they are by which table they are in. A withdrawal under "Banking machine withdrawals" is written 40.00, exactly as a deposit under "Deposits and other additions" is. Extract the tables without carrying the heading down onto the rows and every withdrawal arrives as money coming in — the totals stay plausible, the balance is spectacularly wrong, and the cause is invisible in the spreadsheet because the numbers are all correct. The heading is the sign, and it has to be read as data rather than as decoration.
How a PNC statement is laid out
Worth checking against the statement in front of you — PNC issues more than one layout, and which you have changes what to look for after converting.
| Date format | MM/DD |
|---|---|
| Running balance | Present, with a daily balance detail section as well |
| Sections | Deposits and other additions, cheques and substitute cheques, banking machine and card withdrawals, online and electronic banking deductions, other deductions |
| Amount columns | One amount column per section, with the sign implied by the section |
| Ordering | Chronological within each section, restarting at each |
Downloaded activity and statements are not the same thing
Every large US bank offers two different exports, and people reach for the wrong one constantly. Downloadable account activity — CSV, and often QFX or OFX — covers a recent window, typically a few months, and stops. Statements are PDFs, are issued per period, and go back years. If you need last March, the activity export will not have it and the statement will; converting the PDF is how that gap is closed.
CSV for PNC
CSV with one signed column makes the sign explicit and checkable at a glance, which on a PNC statement is the thing most worth checking.
Convert to CSVQuestions
- Every transaction came through as a deposit. Why?
- The section headings were not carried onto the rows. On a PNC statement the amount column is positive everywhere and the heading is what makes a withdrawal a withdrawal.
- Why are the dates not in order?
- Each section restarts chronologically. Sorting the combined rows by date fixes it — but only after the signs are right, or you will sort correct-looking rows that are still inverted.
- Does the daily balance detail get imported?
- It should not. It is a summary of closing balances, not a list of transactions, and counting it produces a second set of rows that all look genuine.