How to Import First Citizens Transactions into QuickBooks
Jul 16, 2026
Convert your bank statement to Excel now
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Short answer: First Citizens connects to QuickBooks through Express Web Connect (the automatic feed) and Web Connect (a manual .qbo file), and the bank's own Intuit guide routes the Web Connect download through Commercial Advantage, its commercial banking platform. If you do not bank on Commercial Advantage, or you are a bookkeeper working from a statement a client emailed you, there is no download screen to reach. In that case, convert the First Citizens PDF statement to a QBO Web Connect file and import it exactly like a bank download. Here is how each route works, including legacy CIT and Silicon Valley Bank statements.
Does First Citizens support QuickBooks?
Yes. First Citizens publishes conversion instructions for QuickBooks Online, QuickBooks Desktop for Windows and Mac, and Quicken, and every one of them uses either Express Web Connect or Web Connect. Express Web Connect is the automatic sync that runs inside QuickBooks with no file. Web Connect is the manual route, and for it the bank tells you to download a .qbo or .qfx file from Commercial Advantage, then import it. That works if Commercial Advantage is the platform you sign in to. If it is not, the file simply is not reachable from your login, and the statement PDF is the only artifact in your hands.
| Route | File or method | Works with | History reach |
|---|---|---|---|
| Express Web Connect | Automatic sync, no file | QuickBooks Online, Quicken | About 90 days on setup |
| Web Connect | .qbo from Commercial Advantage | QuickBooks Online and Desktop | Whatever the platform shows |
| Converted PDF | QBO from any statement | QuickBooks Online and Desktop | Any period you hold |
How to import First Citizens transactions into QuickBooks
If you have Commercial Advantage access, log in, download the .qbo Web Connect file for the account and date range, and import it. If you do not, convert the statement instead. Open your First Citizens PDF statement, upload it, choose QBO as the output, and download the Web Connect file. Then in QuickBooks Online go to Transactions, Bank transactions, and choose Upload from file under the Link account dropdown; in QuickBooks Desktop use File, Utilities, Import, Web Connect Files. Map the file to the right account, and the transactions land in the For review tab ready to categorize.
How do I import older First Citizens history into QuickBooks?
Convert the statements. A new QuickBooks feed backfills roughly 90 days, and online download windows are short, but First Citizens keeps monthly statement PDFs for years, including on closed accounts. Download each monthly PDF and convert it to QBO, or drop several months into one upload. Because each statement covers a fixed start and end date, you can import a full year without the overlap that creates duplicates on a live feed.
Do Silicon Valley Bank and CIT statements convert?
Yes. First Citizens acquired CIT and then Silicon Valley Bank, which now runs as a division of First Citizens Bank, so many businesses hold statements under one name and bank under another. A converter reads the statement document in front of it, not a bank feed identity, so legacy SVB and CIT layouts come out as clean QBO files with signed amounts intact. That matters for startups doing a historical cleanup across an account that changed hands mid-year.
Why am I getting duplicate First Citizens transactions?
Because a new download overlaps dates you already imported. First Citizens warns about this directly in its conversion instructions, since Intuit connections drop during platform changes and you then reconnect. Note the date of your last successful download before you reconnect. If the new pull overlaps it, select the extras in the For review tab and use Batch Actions, then Exclude Selected. Importing converted statements sidesteps the problem because each file is one fixed period with no overlap.
Import First Citizens transactions into QuickBooks, step by step
Keep one account per file. First, get the monthly PDF from First Citizens digital banking, or use one a client forwarded. Second, convert it to QBO. Third, in QuickBooks Online open Transactions, Bank transactions, Upload from file, pick the file, and confirm the account; in Desktop use File, Utilities, Import, Web Connect Files. Fourth, review the imported rows, categorize them, and match anything already on the books. Once the register is clean, an automatic expense categorizer can keep new spend sorted so month-end is faster next time.
The short version
First Citizens does support QuickBooks, but the Web Connect file sits behind Commercial Advantage and the feed only reaches recent activity. For an older period, a closed account, a legacy SVB or CIT statement, or a clean full year, convert the First Citizens statement to QBO and import it like a bank download. Prefer a spreadsheet? The PDF bank statement to Excel converter writes XLSX and CSV from the same upload. For the full walkthrough with screenshots of both QuickBooks versions, see how to convert bank statements to QuickBooks (QBO), and before a busy year check how many transactions QuickBooks accepts at once.
Ready to convert your bank statement?
Upload a PDF and get clean Excel or CSV in seconds. Works with statements from any bank.
Convert to Excel nowFree to try, no credit card required