PNC online banking exports activity to a file, but it now lets you pull only one month at a time and the feed backfills about 90 days. Upload any PNC PDF statement and BankXLSX writes a QuickBooks Web Connect file with the dates, descriptions, and signed amounts already mapped, however old the statement is. Start free, no credit card.
Last updated July 2026
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Upload the PNC PDF statement to BankXLSX and download it as a QBO file. The converter reads every transaction off the statement and writes a QuickBooks Web Connect file with dates, descriptions, and signed amounts mapped, so QuickBooks imports it like a real bank download. This works for any PNC personal, Virtual Wallet, business, or credit card statement, including months PNC will not export in one pass and accounts that have been closed.
PNC does let you export account activity, but the practical limits show up the moment you need more than the last few weeks in one file.
PNC recently restricted the activity export so you can only download one statement period per file. Pulling a full year means repeating the export twelve times and stitching the pieces together.
When you connect PNC to QuickBooks, the feed backfills roughly 90 days. Anything older never arrives on its own and has to come from statements.
Once a PNC account is closed, the online activity export goes away. What you keep are the PDF statements you saved, and QuickBooks cannot open those.
PNC keeps several years of Online Statements as PDFs, far more history than the activity export reaches. All of it is locked inside a document format.
Virtual Wallet groups Spend, Reserve, and Growth. Exporting each slice cleanly for one QuickBooks account adds steps the PDF statement already resolves.
Retyping a year of PNC business checking activity into the register burns days and invites transposed amounts that break the reconciliation.
Upload the statement and the converter reads it like a bookkeeper would, then writes a valid Web Connect file QuickBooks accepts on the first try.
You get an actual .qbo file with the OFX structure QuickBooks expects, not a CSV you have to remap column by column on every import.
Standard checking, Virtual Wallet, savings, PNC business checking, and PNC credit card statements all parse correctly, including multi-account combined statements.
Debits land negative and credits positive with the correct posting date, so the register reconciles to the statement balance without hand fixes.
OCR reads image-only and scanned PNC PDFs, which is what older saved statements and paper scans usually are.
The same upload also exports QFX for Quicken, OFX for other software, and CSV or XLSX when you want the raw rows.
256-bit encryption in transit, and you can delete your uploaded statements whenever you want.
No software to install and no credit card to start.
Drag the statement into the box above. Download it first from pnc.com under Online Statements if you have not already.
Tip: Several months in one file is fine.
Once the transactions are read, pick QBO as the download format. QFX, OFX, CSV, and Excel sit next to it.
Tip: Pick QFX if the target is Quicken.
QuickBooks Online: Transactions, Bank transactions, Upload from file. Desktop: File, Utilities, Import, Web Connect Files. Pick the account and review.
Tip: Match the account before you add.
PNC is one of the largest banks in the country, so bookkeeping cleanups, tax catch-ups, and QuickBooks migrations run into stacks of PNC PDFs constantly, especially since the export only releases a month at a time.
Import a year of a client's PNC business checking history without exporting twelve separate monthly files by hand.
Bring pre-conversion and closed-account PNC history into QuickBooks during cleanup and audit engagements.
Catch up months of PNC business banking activity before tax season without retyping a single line.
Load PNC history from before the bank feed was connected, so opening balances reconcile cleanly.
For recent activity, PNC has a native path: sign in at pnc.com, open the account, go to Account Activity, and use the download option. PNC offers several file types, including a QuickBooks (QBO) option, along with QFX for Quicken, OFX, and CSV for spreadsheets. Choose the period, download, and import. When the transactions you need sit inside the current period, use it, it is free and it comes straight from the bank.
The catch is that PNC now releases the activity export one month at a time, and the QuickBooks bank feed backfills only about 90 days. The moment the job involves last year, a closed account, or a statement someone emailed you as a PDF, the native download stalls. That is the gap this converter fills: it turns the PDF statement, which PNC keeps as an Online Statement for several years, into the same kind of QBO file, with the whole period in one pass.
| PNC activity download | BankXLSX PDF conversion | |
|---|---|---|
| History reach | One month per export; feed backfills about 90 days | Any statement PDF, several years available on pnc.com |
| Closed accounts | No online export | Works from saved or requested PDF statements |
| Files per year | Up to 12 separate exports to stitch | One upload, every transaction |
| Scanned or emailed PDFs | Not applicable | OCR reads scans and image statements |
| Output formats | QBO, QFX, OFX, CSV | QBO, QFX, OFX, CSV, Excel from one upload |
In QuickBooks Online, open Transactions, then Bank transactions, choose the account, and pick Upload from file under the Link account dropdown. Select the QBO file, confirm which QuickBooks account it belongs to, and the PNC transactions land in the For review tab ready to categorize. In QuickBooks Desktop, go to File, Utilities, Import, Web Connect Files, and choose the file. If the account already has an active PNC feed, deactivate it in Bank Feed Settings first so the two imports do not collide.
The converter reads all of them. A PNC business checking statement, a personal or Virtual Wallet statement, and a PNC Cash Rewards or Points card statement each come out as a clean QBO file with signed amounts. If you want the spreadsheet first, the PNC bank statement to Excel converter and the PNC credit card statement converter produce XLSX and CSV from the same upload, and the general bank statement to QBO converter covers every other bank. For the import walkthrough end to end, our guide on how to convert bank statements to QuickBooks (QBO) has screenshots of both QuickBooks versions, and if you hit the row cap, see how many transactions QuickBooks Online will import.
Already pulled a CSV out of PNC and just need it in Web Connect form? A dedicated CSV to QBO converter handles that step directly. And if statements from several banks are headed into the books, a purpose-built bank statement to QuickBooks converter runs the same PDF to QBO workflow across all of them.
Sign in at pnc.com, open the account, go to Account Activity, and use the download option. Choose the QuickBooks (QBO) file type for the current period. Because PNC releases the export one month at a time, download the PDF statement instead for older months and convert it to QBO with BankXLSX in a single pass.
QuickBooks never imports the statement document itself. Either connect PNC as a live bank feed, download the current period as a QBO file and upload it, or convert the PDF statement to QBO and import that. The PDF route is the only one that works for older months and closed accounts in one step.
The activity export now releases about one statement period at a time and the QuickBooks feed backfills roughly 90 days, while PNC keeps Online Statements as PDFs for several years. That gap is why long lookbacks, audits, and tax catch-ups usually run through statement conversion rather than the native download.
No. QuickBooks Online and Desktop accept QBO, QFX, and OFX in the bank feed, with CSV as a manual fallback. A PDF is a document, not a data file, so it has to be converted first. BankXLSX reads the PNC PDF and writes the QBO file QuickBooks expects.
Only about 90 days. When you connect PNC to QuickBooks, the feed pulls a limited amount of recent history and everything from that point forward. Older transactions never arrive on their own, which is why prior-year cleanups start from the PDF statements.
Yes. Virtual Wallet Spend, Reserve, and Growth activity converts the same way, with each transaction signed correctly. You get one clean QBO file per account instead of untangling the grouped online view.
QBO imports like a real bank download, with the account mapping and duplicate detection built in, so prefer it when QuickBooks is the destination. CSV makes sense when you want to review or edit rows in a spreadsheet first, and it also sidesteps the 1,000-row QBO-file concern for very large periods. BankXLSX exports both from the same conversion.
Uploads are encrypted in transit with 256-bit encryption, files can be deleted whenever you choose, and your data is never resold or shared. Nothing installs on your machine; the whole conversion runs in the browser.
Convert any bank statement to a QBO file.
The same PNC statements as XLSX or CSV.
The QBO converter for Chase.
The mapped-CSV route into QuickBooks.
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
