First Citizens CSV to QBO Converter: Convert a First Citizens CSV to QuickBooks

Because the .qbo First Citizens hands you is not fully compliant with the OFX standard QuickBooks requires. The most reported cause is the transaction-type coding: the bank writes values QuickBooks does not accept, such as spelling out DEPOSIT where QuickBooks expects the short code DEP, and stray invalid characters in the file. QuickBooks then refuses the import and returns Error OL-222. Some users hand-edit the bank file in a text editor to fix it, but building a clean .qbo from your CSV avoids the malformed download entirely.

It can, but the connection has been unreliable through the recent platform conversions. Business customers report connection errors such as Banking error 102 and downloaded Web Connect files that fail on import. First Citizens itself tells customers to disconnect their old bank feed before reconnecting to the First Citizens platform, which is a sign of how disruptive the conversion is. When the feed or download will not cooperate, exporting a CSV and importing a converted .qbo keeps your books moving.

Export your First Citizens checking, savings, or credit card activity as a CSV, then upload it in the converter at the top of this page. The tool detects the date, description, and amount columns, normalizes the dates, strips dollar signs and commas, and writes each transaction type using the short codes QuickBooks accepts, so the OL-222 problem never appears. It totals the parsed rows against your file before it writes the .qbo. Download the .qbo and import it into the matching First Citizens account.

Sign in to First Citizens Digital Banking, open the account you want, and go to its transaction history. Choose a date range or a specific statement period, then select the download or export option and pick the CSV or spreadsheet format. If a view only offers a PDF statement, download that and turn it into a spreadsheet first, then convert that file here. Pull each period you still need, since the on-screen history only reaches back so far.

Given that the bank .qbo has been triggering OL-222, a converted .qbo built from your CSV is the most reliable file. This table compares the options for a First Citizens account and what each means for your import.

Yes. First Citizens business checking, business savings, and credit card accounts all export activity as a CSV, and accounts moved over from CIT Bank or the former Silicon Valley Bank export the same way once they are on the First Citizens platform. Convert the exported CSV to a .qbo and import it into the matching account in QuickBooks. For a credit card, set the account up as a Credit Card type so purchases and payments carry the right signs.

Add the account with the correct type before importing: checking and savings as Bank accounts, and any First Citizens card as a Credit Card account. In QuickBooks Online, open the Chart of Accounts, add a new account, choose the type, and name it for the First Citizens account. Then import the converted .qbo into that account. Setting the type first keeps the running balance matching your statement and prevents sign errors during reconciliation.

In QuickBooks Online, open Transactions, then Bank transactions, select the matching First Citizens account, and upload the .qbo file. In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files, and choose the .qbo. Because the converter writes compliant transaction types and clean characters, the file imports without the OL-222 error the bank download produces, and the transactions post straight to the register.

QuickBooks Online caps a raw CSV upload at 350 KB, roughly a thousand rows, so a long history has to be split into several files. A .qbo import is not held to that limit, so converting lets you bring a full year of First Citizens activity into QuickBooks in one file. To process several statements at once, the bulk CSV to QBO converter handles them in a single batch.

Yes. Before the .qbo downloads, the converter totals every transaction it parsed and compares that against your First Citizens file, so a missing or misread row shows up in the preview rather than during reconciliation. The tool only reads the transaction rows, date, description, and amount, to build the file, and never asks for your First Citizens login.