Skip to content

How to Import PNC Transactions into QuickBooks (Bank Feed, QBO, PINACLE)

By ConvertQBO Team ·

PNC supports QuickBooks Online and QuickBooks Desktop with no service fees for the standard connections, and online banking offers a .qbo download for checking, savings and money market accounts. Commercial PINACLE users are the exception. Here are the options.

Option 1: connect PNC (bank feed)

PNC lists these connection names:

Software Search for
QuickBooks Online PNC Bank
QuickBooks Desktop PNC Bank QBDT EWC

QuickBooks Online: Banking → Connect account, search PNC Bank, sign in and map each account.

QuickBooks Desktop: Banking → Bank Feeds → Set Up Bank Feed for an Account, search for PNC Bank QBDT EWC and sign in with your online banking credentials.

PNC also offers Direct Connect for business customers (downloads plus transfers, with or without bill pay). It needs QuickBooks 2019 or later, you enroll on a paper form, and PNC says there’s a fee — check its business fee schedule.

When the QuickBooks Online feed keeps failing: users in the QuickBooks Community reported repeated PNC connection failures in 2024 and early 2025 with no clear fix from either side. Their workaround was to upload a file instead (Option 2) until the connection recovered.

Option 2: download a QuickBooks (.qbo) file

For checking, savings and money market accounts, PNC online banking exports .QBO (QuickBooks Web Connect) and .QFX (Quicken) files. For credit cards, PNC lists Quicken, QuickBooks and Excel downloads, with 13 months of history online.

  1. Sign in to PNC online banking on a computer and open the account’s activity.
  2. Choose the export/download option, the date range and QuickBooks (.qbo).
  3. Import it:
    • QuickBooks Desktop: File → Utilities → Import → Web Connect Files, then review in the Bank Feeds Center.
    • QuickBooks Online: Banking → Link account ▾ → Upload from file.

Start each download the day after the last transaction already in QuickBooks, so nothing is imported twice.

Option 3: PINACLE, Excel or QFX to QBO

PNC PINACLE (treasury management) exports BAI, CSV, XLS, PDF, RTF and XML but no QuickBooks file, and users report PINACLE accounts can’t be linked in QuickBooks Online. To get PINACLE activity into QuickBooks:

  1. Export the account activity as CSV or XLS.
  2. Convert it with CSV to QBO or Excel to QBO. Check the preview: money out negative, money in positive.
  3. Import the .qbo file as in Option 2.

Have a .qfx file instead? QFX to QBO keeps the transaction IDs, so QuickBooks can still detect duplicates.

FirstBank customers moved to PNC

If you came to PNC from FirstBank in 2026, your QuickBooks connection didn’t carry over. PNC’s dates: the last FirstBank update was June 18, 2026, PNC connections opened June 22, and FirstBank history could be downloaded until July 31, 2026. Connect the accounts to PNC as in Option 1, linking each to the existing QuickBooks account, with a start date after your last FirstBank transaction.

Tips

  • Import each account separately and check the file goes to the right QuickBooks account.
  • Don’t import the same dates through both the bank feed and a file.
  • On QuickBooks Desktop 2023 or older, bank downloads stopped after May 31, 2026: Desktop bank feeds not working.
  • Connection errors: QuickBooks bank feed errors.

Sources

Read November 4, 2026: PNC online banking with Quicken and QuickBooks, manage your credit card online, business Direct Connect enrollment form (PDF), PINACLE information reporting (PDF); QuickBooks Community: connection to PNC, PINACLE linking error.

Report a problem

Something does not convert or looks wrong? Tell us — we read every report. Please don’t paste real bank data.