PNC CSV to QBO Converter: Convert PNC CSV to QuickBooks

Sign on at pnc.com, open the account, and download the activity as a comma-delimited (CSV) spreadsheet for the date range you need. Upload that CSV to the converter at the top of this page. It detects the date, description, and amount columns, checks the parsed total against your file, and hands back a .qbo you import into QuickBooks. QuickBooks Online reads the .qbo directly, and QuickBooks Desktop imports it through Bank Feeds, so the same file works in either version.

On pnc.com, open the account and use the activity download to save a comma-delimited (CSV) file rather than the Quicken or QuickBooks option. The quick activity export only reaches back about 90 days, so for a longer history go to My Account, click Activity, open the Online Statements link, choose Activity Detail, set the date range, and export. That path lets you pull well over a year of PNC transactions in one CSV.

PNC's standard activity download is capped at roughly the last 90 days, which is not enough when you are catching up several months of bookkeeping. The workaround is the Online Statements, Activity Detail export, which reaches back much further. Once you have that longer CSV, convert it to a .qbo here so the whole history imports into QuickBooks as one clean bank feed instead of a dozen 90-day pieces.

PNC bank feeds stall regularly, and in early 2026 many accounts stopped downloading with no error shown at all, usually traced to expired access tokens on PNC's side. Reconnecting sometimes fixes it, but transactions can silently stop while your books look up to date. Downloading a PNC CSV and converting it to a .qbo gets every transaction into QuickBooks without waiting for the feed to be repaired.

No, QuickBooks Desktop cannot import bank transactions from a raw CSV file. Desktop only imports a Web Connect .qbo through Banking, then Bank Feeds, then Import Web Connect Files. That is why converting your PNC CSV to a .qbo first is the reliable route for Desktop users, since it produces the one file format Desktop actually accepts.

No. After the FirstBank accounts moved onto the PNC platform in mid 2026, the old FirstBank connections stopped updating and you have to set up a fresh PNC connection. While you rebuild that link, or if it fails, download your PNC CSV and convert it to a .qbo so bookkeeping keeps moving. The converted file imports the same way regardless of which connection your account used before.

QuickBooks Online accepts a CSV with three columns (Date, Description, Amount) or four columns (Date, Description, Credit, Debit), in English, under 350 KB, with one consistent date format and plain numbers. PNC exports rarely match that exactly, and the sign on debits often trips the import. The converter reads the PNC layout as-is and outputs a .qbo, so you never have to reshape the columns or fix the signs by hand.

QuickBooks caps a single upload at 350 KB, which is roughly 1,000 transactions, so a long PNC Activity Detail export can fail when uploaded as a CSV. Converting to a .qbo and, where needed, splitting by month keeps each file inside that limit. The converter checks every batch against your file total, so nothing is dropped when you split a long PNC history across several files.

The .qbo carries each transaction's date, description, and amount, which is what QuickBooks uses to build your register. PNC CSV exports do not always include a running balance column, and QuickBooks recalculates the balance from the imported transactions anyway. As long as every transaction comes through, your QuickBooks balance reconciles to your PNC statement.

Yes. PNC business and consumer credit card activity downloads as a CSV the same way checking activity does, and the converter handles card exports, including split debit and credit columns. You get a .qbo that imports into the matching QuickBooks credit card account, so card charges and payments land in the right register.