FirstBank QuickBooks Import After the Move to PNC

Short answer: FirstBank accounts in Colorado and Arizona converted to PNC on June 22, 2026. The last FirstBank transactions to update through an existing Quicken or QuickBooks connection came through on June 18, and FirstBank Online Banking closed on July 31. If you saved your FirstBank activity as CSV files before that date, or you're now exporting from PNC, convert each CSV to a QuickBooks Web Connect (.qbo) file with the converter above and import it into the account you linked to PNC. That fills the gap without waiting on a bank feed.

Former FirstBank business clients tend to be in one of three spots. The feed reconnected to PNC but the weeks around the conversion are missing. Or the feed never reconnected and they're months behind. Or their bookkeeper downloaded spreadsheets before July 31 like PNC suggested and now has a folder of CSVs that QuickBooks Desktop won't read. All three end the same way: a clean file per account, imported once, checked against the statement.

What changed for QuickBooks when FirstBank became PNC?

The old FirstBank connection in QuickBooks is finished, and every account has to be connected again under PNC. PNC's FirstBank transition page gives the dates and the connection names to pick:

The "link to existing account" step matters more than it looks. If you let QuickBooks create a new bank account during the reconnect, the PNC activity lands in a fresh register and the FirstBank history sits in the old one, so your reconciliation starts over at zero. Link to the existing account and the history stays in one place.

Why are my FirstBank transactions missing in QuickBooks after the PNC conversion?

Because there's a built-in gap. Updates through the old connection stopped on June 18 and the new PNC connection could only start on June 22, so anything that posted between those dates, and anything from before you reconnected, has to come in some other way. A new bank feed usually pulls only about 90 days back, so if you reconnected late in the summer the missing stretch can be longer than the four-day window.

Feeds also fail on their own. QuickBooks community threads from PNC customers describe connections that show as linked but download nothing, and Intuit's own replies point people to Web Connect imports while the connection is sorted out. A file import works regardless of the feed's status.

How do I import old FirstBank transactions into QuickBooks?

Use the CSV files you saved from FirstBank Online Banking before July 31, or export the 90 days of FirstBank history PNC carries in its own Online Banking. Then:

1. Upload one CSV to the converter at the top of this page. It reads the date, description and amount columns (or split debit and credit columns), shows you every parsed row and the row count, and builds a .qbo with a unique transaction ID on each line.
2. In QuickBooks Online, go to the bank transactions screen, choose Upload from file, pick the .qbo and map it to the account you linked to PNC.
3. In QuickBooks Desktop, use File, Utilities, Import, Web Connect Files, and point it at the existing account.
4. Accept or match the rows in the review screen, then reconcile against the FirstBank statement for that month.

Do it one account and one period at a time. The converter takes one file per conversion, and keeping each file to a single statement month makes the reconciliation step quick.

Can QuickBooks Desktop import a FirstBank CSV file?

No. QuickBooks Desktop has no bank-transaction CSV import in any version. It reads .qbo Web Connect files (and IIF, which posts entries directly with no review step). That's why a folder of FirstBank CSVs is a dead end for a Desktop user until each file is turned into a .qbo. Our CSV to QuickBooks Desktop converter page covers the Desktop import screens in more detail.

Will importing the gap create duplicate transactions?

It can if the date ranges overlap. QuickBooks skips a downloaded transaction when it has already seen the same transaction ID for that account, but there's no reason to expect an ID issued by FirstBank's old platform to match one issued by PNC's. So the same deposit coming in once from the old feed and once from a PNC file looks like two different transactions. The fix is simple: before you convert, trim each CSV so it starts the day after the last transaction already in QuickBooks and ends the day before the PNC feed's first transaction. If something does get in twice, our guide to deleting imported bank transactions in QuickBooks walks through undoing it.

Should I reconnect the PNC feed or switch to file imports?

If the PNC connection works for your accounts, use it for day-to-day activity. It's free, and a working feed beats any manual step. Files make sense where the feed can't help:

One honest note: PNC Online Banking also offers a direct .qbo download for current activity. If that download works for the account and range you need, take it. The converter earns its place on the FirstBank CSVs you already saved, on edited spreadsheets, and on the days the direct download or the feed doesn't cooperate. Our PNC CSV to QBO converter page covers PNC's export screens and column layout.

What about Direct Connect for FirstBank accounts?

PNC says Direct Connect users must re-enroll and reset their accounts after the conversion. Keep the bigger timeline in mind too: Direct Connect is being retired across the industry on October 30, 2026, and new enrollments already ended in April. Re-enrolling a FirstBank account into Direct Connect now buys a few weeks at most. If your Desktop workflow depended on it, plan for the EWC connection or for .qbo file imports now. Our list of banks discontinuing Direct Connect for QuickBooks tracks the dates.

What if I only have PDF statements for older months?

PNC keeps FirstBank statements with up to 5 years of history, but those are PDF statements, not data. This converter takes CSV, TXT and Excel files only. If a month exists only as a PDF, you'll need a PDF statement to QuickBooks converter for that month, and you can keep using CSV files for everything you saved in spreadsheet form.

How much does it cost to convert FirstBank CSV files to QBO?

You can try it without an account: three conversions with no card (up to 25 rows, watermarked), then three more with a free account (up to 100 rows). Clearing a real backlog needs a paid plan. Starter is $49 a month, or $24.50 a month billed yearly, and covers 100 conversions a month with automatic column mapping, opening and closing balances and split debit and credit columns. Plus ($149 a month, or $74.50 billed yearly) adds 500 conversions, conversion history and exports to QFX, OFX, QIF and IIF. A business with three or four FirstBank accounts and six months to catch up uses about 20 to 25 conversions, so one month of Starter usually covers the whole cleanup. Accountants converting for several former FirstBank clients should look at the plans with the higher monthly allowance.

Who this is for

Colorado and Arizona business owners, bookkeepers and accountants whose QuickBooks books still have a hole from the FirstBank conversion. If you've already reconnected and the feed is clean, you don't need us. If you have saved FirstBank CSVs, a Desktop file that can't read them, or a client who sends spreadsheets, the converter gets those months into QuickBooks today. Former Cadence clients in the same position after their move to Huntington can read our Cadence Bank QuickBooks import guide.

Convert your FirstBank or PNC export now

Drop the first saved FirstBank CSV, or a fresh PNC export, into the converter at the top of this page. Check the parsed rows and the row count against the statement, download the .qbo, and import it into the account you linked to PNC. Once the gap is closed, reconcile each month to the statement balance.