How to Convert a PNC PDF Statement to CSV or Excel
PNC publishes one of the most detailed retention schedules of any US bank, and one of the vaguest export stories.
Four different answers to one question
"How far back do my statements go?" has a single answer at most banks. At PNC it has four, and the difference between the shortest and the longest is six years.
| Product | Statements online |
|---|---|
| Checking and savings, auto loans, unsecured installment loans | Up to 7 years |
| Mortgage and home equity loans | Up to 5 years |
| Credit cards | Up to 4 years |
| Investment accounts | Up to 10 years |
| Business deposit accounts | Up to 7 years |
| Business credit cards | Up to 48 months |
Two more published numbers sit alongside these and are easy to confuse with them. Check images are available for 24 months in transaction history. And on credit cards, PNC states you can view up to 13 months of posted transactions — which is searchable activity, not statements, and is a third of what the statement archive holds for the same card.
Closed accounts are the trap. PNC states that online statement history may not be available for accounts that have been closed. The retention figures above describe live accounts. Close one and the archive may go with it, with no warning and no way back.
Quick answer: find your product in the table, download the statements from Statements and Documents while they are still there, and convert them. If you are closing a PNC account, do it before you close.
The export story is much thinner
PNC publishes its retention schedule in detail and then goes quiet about getting data out.
The only PNC page naming file formats is small business: Data Export offering Excel, Microsoft Money, Quicken or QuickBooks. Notably, CSV is not named anywhere we could reach. The personal credit card page says you can export to your financial software without saying in what. The personal Quicken page names connection identifiers — PNC Bank Web Connect, PNC Bank QBDT EWC, PNC Bank — rather than formats.
No PNC page states an export date range at all.
You will find confident numbers elsewhere: that PNC only gives CSV for the past 90 days, or offers last 30, 60 or 90 days plus a custom range. Neither is supported by anything PNC publishes, and the first asserts a CSV export PNC never mentions. Check the dropdown in your own account rather than trusting either.
Converting the statements (4 steps)
- Find the right retention window
PNC keeps statements for different lengths depending on the product. Check the table on this page before assuming your period is available. - Open Statements and Documents
In Online Banking, go to Accounts, select the account, open Account Quick View, then Statements and Documents, and View PDF. - Download the months you need
One PDF per statement period. On mobile, use More, then Statements and Documents. - Convert them
Go to reconcileiq.com/bank-statement-converter, upload the statements, verify against the statement totals, and download the CSV.
Where to find things
Statements, desktop: Online Banking → Accounts → select the account → Account Quick View → Statements and Documents → View PDF.
Statements, mobile: bottom navigation More → Statements and Documents → choose Online statements, Account documents or Other documents → account → year.
Both routes work, which is worth noting because several US banks make statements desktop-only. PNC does not, and no PNC page states that its export is desktop-only either.
What comes out
PNC publishes an annotated credit card statement guide, but it is served only to browser clients and its text could not be extracted, and its own "how to read your statement" article turns out to be generic financial education citing third parties rather than a description of PNC's layout. So this page does not describe PNC's column structure.
The converter returns the same consistent shape either way: one normalised sortable date column, descriptions rejoined, one correctly signed amount column, and the running balance kept separate.
Convert Your PNC Statement
Upload the PDF, check it against the statement's own opening and closing balance, download clean CSV. Your first statement of up to 10 pages converts free on a new account.
Convert your PDF now for freeFrequently Asked Questions
It depends entirely on the product, and PNC publishes all four figures: up to 7 years for checking and savings accounts, auto loans and unsecured installment loans; up to 4 years for credit cards; up to 5 years for mortgage and home equity loans; and up to 10 years for investment accounts. Business is stated as up to 7 years on deposit accounts and up to 48 months on credit cards.
PNC does not name CSV as an export format on any page we could reach. Its small business Data Export page names Excel, Microsoft Money, Quicken and QuickBooks. Its personal credit card page says you can export to your financial software without naming formats. Rather than guess, check the format dropdown in your own account.
Not reliably. PNC states that online statement history may not be available for accounts that have been closed. If you are closing a PNC account, download every statement you might need first, because the archive may go with it.
PNC states you can view up to 13 months of posted transactions on a credit card, search by date, description or dollar amount, and export to your financial software. Statements for the same card run to four years, so anything between 13 months and 4 years exists as a statement but not as searchable activity.
Your first statement of up to 10 pages converts free on a new account. After that it runs on credits, with the cost shown before anything is processed. Files are uploaded and processed on our servers rather than in your browser, which is what allows scanned and photographed statements to work as well as native PDFs.