Guide · PNC
Convert PNC statements to Excel, CSV or QuickBooks®
Download your PNC statements, drop them into Pennyrow, and get every transaction as a clean spreadsheet, with a check that each statement adds up. Free. Your statements are read inside your browser; we never upload, receive, see or store them.
Step 1: download your statements from PNC
- Log in to PNC Online Banking and select Accounts.
- Select the account, then Account Quick View.
- Select Statements and Documents.
- Select View PDF.
- In the PNC Mobile app, tap More.
- Tap Statements and Documents.
- Choose Online statements, then the account.
- Pick the year and open the statement.
Checking and savings: up to 7 years. Credit cards: 4 years.
Transaction downloads
PNC also lets you download transactions as a file. Pennyrow reads CSV, OFX and QFX files:
- Quicken (QFX) or QuickBooks (QBO): Online Banking: export transactions and choose the format.
- Excel, Quicken or QuickBooks (credit cards): Credit card transactions in Online Banking > export. (up to 13 months)
PDF statements are usually the better choice for catching up a year: each one has opening and closing balances, so Pennyrow can check every month adds up.
Good to know
- Paperless statements are switched on account by account.
- Statements may not be available once an account is closed.
Checked October 13, 2026 against PNC's help pages: www.pnc.com/en/personal-banking/banking/online-and-mobile-banking/online-statements.html, www.pnc.com/en/personal-banking/banking/services/manage-credit-card-online.html, www.pnc.com/en/personal-banking/banking/online-and-mobile-banking/online-banking-with-quicken.html. Banks move menus around; if a step has changed, the help page has the current one.
Step 2: drop them into Pennyrow
- Open Pennyrow and choose your files, or drag them in. A whole year at once is fine, and you can mix PNC with your other banks and cards.
- Each statement gets a balance check: opening balance plus money in, minus money out, should equal the closing balance. You see "✓ Balanced", or which row is off and by how much.
- Catch-up checks look across all your files: missing months, statements that don't follow on from the last one, the same transaction in two files, and transfers between your own accounts (including card payments) so they aren't counted twice.
- Export: Excel (.xlsx), CSV, a QuickBooks Online bank CSV, a QuickBooks Desktop .iif file, or OFX.
If a PNC statement doesn't read right
- Pennyrow reads statement layouts with general rules, not a PNC-specific template, and it hasn't been tried on every PNC layout. The balance check is how you know: if a statement doesn't balance, Pennyrow shows the row that's off so you can fix it.
- Scanned or photographed statements can't be read (there's no OCR). Download the PDF from PNC's site instead of scanning a paper copy.
- Password-protected PDFs open with your own password, used only in that tab.
- If a layout keeps failing, tell @minsoesantun which PNC account type it was. Please don't send the statement itself.
Questions
Is it free?
Yes. Converting statements, the catch-up checks and every export are free.
Does my PNC statement get uploaded?
No. The converter page is locked so it can't make network requests, and it works with Wi-Fi off once it's open. Here's how to check that yourself.
Do I need to sign in to PNC through Pennyrow?
No, and you never should. You download the statements yourself; Pennyrow never asks for a bank login.
Does it make a .qbo (Web Connect) file?
Not yet. For QuickBooks Online use the bank CSV export; for QuickBooks Desktop use the .iif export.
Other banks and cards
Any bank or card with text PDF, CSV, OFX or QFX statements can work; these guides cover where to download them.