Convert PNC statement PDFs to Excel, QuickBooks and CSV.
QuickBooks Online, Excel files from the PDF.
PNC does not password-protect statement PDFs. PNC has two exports and they do not overlap well.
Drop your PNC statement here
PDF, scan or photo. Up to 12 files at a time.
Not ready to upload your own? See a sample result
5 pages free, no account. Amounts stay in USD.
Last updated
How to download a PNC statement as a PDF
- Sign on to PNC Online Banking and select Accounts.
- Open the account, then "Account Quick View".
- Select "Statements and Documents" from the Quick View options.
- Click "View PDF" beside the statement you want and save it.
- PNC Mobile app: from the bottom bar choose More, then "Statements and Documents", then "Online statements", then the account and year.
Then drop the file above; several months of PNC statements at once come back as one workbook.
Is the PNC PDF password-protected?
PNC does not password-protect statement PDFs. The file you download is the file you upload.
What PNC statements look like
Activity detail split into Deposits, Banking/Debit Card Withdrawals, Online and Electronic Banking Deductions and Checks, plus a Daily Balance Detail table.
The transaction pages are headed "Activity Detail" and broken into "Deposits and Other Additions", "Checks and Substitute Checks", "Banking/Debit Card Withdrawals and Purchases" and "Online and Electronic Banking Deductions", each with a count and a total that ties back to the "Balance Summary" on page one. The checks block is a multi-column grid of check number, date and amount, with an asterisk marking a gap in the sequence. A "Daily Balance Detail" table follows the activity, and that is where the running balance lives; rows do not carry one. Dates are MM/DD. Virtual Wallet statements put Spend, Reserve and Growth on one PDF with a section for each, and each section has its own balance summary. Personal statements are four to eight pages; business checking with many checks runs longer.
Why not use PNC's own export?
PNC has two exports and they do not overlap well. The Export button on account activity produces QFX or QBO through Web Connect, but users consistently report it only carries about 90 days no matter what date range the site shows. Older activity is available as CSV under Online Statements then Activity Detail, exported separately for deposits and withdrawals and, by most accounts, one month at a time. Rebuilding a year that way is 24 downloads with no running balance. PNC keeps 7 years of statements online for checking and savings (4 years for cards, 5 for mortgages), so past 90 days the PDF is quicker and carries the daily balances the CSV does not.
Where PNC statements trip up converters
- Four or more debit sections; a converter that only reads the first misses most of the month. We read all of them and prove the total against the printed closing balance.
Which software PNC customers import into
PNC customers most often import into QuickBooks Online, Excel.
- Tally XML. TallyPrime XML export: Receipt and Payment vouchers for Alt+O import, alongside Excel, CSV, QuickBooks and Xero.
- Non-expiring pack. $19 buys 100 pages that never expire, and no statement is charged more than 15 pages.
- API and email-in. REST API and email-in on every plan, including the free one.
- Your file. Deletion of your file starts when processing ends; results are kept 7 days with an account, 1 day without.
- Balance check. There is no per-bank template: every row is added up against the opening and closing balances printed on the statement, and a misread is flagged, not hidden. How the balance check works
PNC questions
My PNC QFX only imports 90 days into Quicken. Is that fixable?
Not from the QFX side; that is what PNC puts in the file. For older months download the PDF statements and convert those. You get one chronological list per statement, with deposits and withdrawals together and the daily balances checked, which is exactly what the Activity Detail CSV route makes you rebuild by hand.
Do Virtual Wallet statements convert as one account or three?
Three, once you split the PDF. Spend, Reserve and Growth each have their own Balance Summary and Activity Detail on the statement, so print each account's pages to its own PDF and upload the three together; each is then checked against its own balances. If you only book the Spend account, upload just those pages.
What does the asterisk next to some check numbers mean?
PNC marks a break in check sequence, meaning a check number between this one and the previous one has not cleared yet. It is informational and we drop it from the check number so the number imports cleanly.
How do I convert a PNC statement PDF to Excel?
Download it from PNC using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.
How many PNC statements can I convert at once?
Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.