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.
QuickBooks (.qbo)Quicken (.qfx)What 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.
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.