PNC bank statement to Excel
Drop a PNC Bank PDF below and get a spreadsheet with the columns split the way the statement prints them. The file stays in your browser.
Drop your PNC PDF statement here
or click to choose a file · nothing is uploaded
Import straight into accounting software
A CSV leaves you at the door of QuickBooks or Quicken; these formats walk in, with each transaction carrying an id so a re-import can't duplicate it. The plain .ofx is the same file without the Intuit tag, for GnuCash, Moneydance and anything else that reads a bank feed.
QuickBooks (.qbo)Quicken (.qfx)Plain .ofxWhat a PNC statement looks like
| Columns | Date · Amount · Description |
|---|---|
| Amounts | money in and money out sit in separate columns |
| Date format | MM/DD |
PNC puts the amount before the description, which is the reverse of most banks. Column order comes from the statement itself rather than a fixed assumption, so the output keeps the bank's own layout.
How PNC writes its transaction lines
PNC prints the amount before the description, which is the reverse of every other bank on this site. Nothing else about the layout is unusual, but that one inversion breaks any spreadsheet template written against a normal statement.
What to check afterwards
Amount before description is unusual enough that it trips up spreadsheet templates written for other banks. If you are pasting into an existing workbook, reorder the columns first rather than assuming the usual layout.
How the conversion works, why scans are refused, and how to confirm for yourself that nothing is uploaded: read the details.
Where to download your PNC statement PDF
The Statements tab in PNC online banking. Virtual Wallet customers see Spend, Reserve and Growth listed separately, which trips people up: those are three accounts with three statement sets, not three views of one.
Got several cycles to combine? Merge the converted files into one sheet, then check for duplicate rows where the cycles overlap.
PNC statement questions
Why is the amount column before the description?
That is how PNC prints it. The converter keeps the statement's own column order rather than forcing a standard layout, so what you get matches what you are reading. Reorder the columns yourself if you are pasting into an existing workbook.
Which Virtual Wallet account should I convert?
Whichever one the transactions you need are in. Spend is the checking account and holds most day to day activity. Reserve and Growth have their own statements and converting the wrong one is the most common reason a PNC conversion looks empty.