Citibank CSV to QuickBooks: Convert and Import Transactions
No account needed for your first conversions. We never store your bank login.
Short answer: Download your Citibank activity as a CSV, then convert that CSV to a .qbo Web Connect file and import it into QuickBooks. QuickBooks Online can read a plain CSV with the right columns, but QuickBooks Desktop has no native CSV transaction import, so a .qbo file is the one format both versions accept. Converting first also fixes the date and sign problems behind most failed Citibank imports.
Citibank is a frequent business and credit card connection in QuickBooks, and on many accounts CSV is the only export Citi offers. CitiBusiness Online does provide QuickBooks Web Connect files on linked accounts, but the consumer and card side often limits you to a comma separated download. You also reach for a CSV when you need transactions older than the 90-day feed window, when the Citibank connection in QuickBooks stops syncing, or when a direct download imports in the wrong direction. This guide covers how to pull the file from Citi, the format QuickBooks expects, and the fastest way to book those transactions.
How do I export a CSV from Citibank?
Sign in to Citibank or CitiBusiness Online on the full website, open the account, and use the download option above the transaction list. Choose your date range and the CSV (comma separated value) format, then download. CitiBusiness Online keeps about 180 days of activity available for download, and on business accounts you can also pick QuickBooks Web Connect (.qbo) or Quicken (.qfx). When only CSV is offered, that file still carries every line you need to convert and import.
Can QuickBooks import a Citibank CSV directly?
QuickBooks Online can import a Citibank CSV through Transactions, then Bank transactions, then the Link account dropdown and Upload from file. The file needs a clear Date, Description, and Amount layout (or a separate Credit and Debit split), must stay under 1,000 rows and 350 KB, and must use one consistent date format. QuickBooks Desktop cannot import a CSV of transactions at all, which is why converting to .qbo is the more reliable route for most users.
Why convert a Citibank CSV to a .qbo file?
A .qbo file is the Web Connect format QuickBooks builds internally from a live bank feed, so it imports with no column mapping and no date guessing. Converting your Citibank CSV to .qbo gives you a file that QuickBooks Online and QuickBooks Desktop both read the same way, posts charges and payments in the right direction, and keeps a clean description on every line. It removes the back-and-forth of mapping columns by hand on every upload.
How to convert a Citibank CSV to QBO
Convert it in three steps. First, download the activity from Citibank as a CSV. Second, upload that CSV to the converter at the top of this page, which reads the Date, Description, and Amount columns and builds a valid .qbo Web Connect file. Third, import the .qbo into QuickBooks: in QuickBooks Online use Upload from file, and in QuickBooks Desktop use File, then Utilities, then Import, then Web Connect Files. The transactions land ready to review and match.
| Method | Works in QBO | Works in Desktop | Effort |
|---|---|---|---|
| Live Citibank bank feed | Yes | Yes | Low, but only reaches ~90 days and can drop |
| Upload raw CSV | Yes, with column mapping | No native CSV import | Medium, manual mapping each time |
| Convert CSV to .qbo, then import | Yes | Yes | Low, no mapping, both versions read it |
Does Citibank work with QuickBooks?
Yes. Citibank supports QuickBooks through a live bank feed, and CitiBusiness Online accounts can also download QuickBooks Web Connect (.qbo) files directly. The live feed handles current months, but it only reaches about 90 days of history and occasionally stops updating, which is a known issue across Citi connections. For older transactions or when the feed fails, exporting a CSV and converting it to .qbo gives you full control over what posts.
Why won't my Citibank transactions download into QuickBooks?
Citibank imports break for a few common reasons: a security or password change the connection has not refreshed, multi-factor prompts the feed cannot pass, a temporary outage on the bank side, or a card account that only offers a CSV download. The cleanest fix is to download the plain CSV and convert that CSV to a fresh .qbo Web Connect file, which sidesteps the broken connection entirely and imports directly into both QuickBooks Online and Desktop.
How do I import old Citibank transactions into QuickBooks?
The live feed only pulls roughly the last 90 days, so for older history use the Citibank download, which on CitiBusiness Online reaches about 180 days, save each batch as a CSV, convert it to a .qbo file, and import it. Because the .qbo carries real dates and descriptions, QuickBooks places each transaction in the correct period instead of dumping everything into the current month.
What columns does the Citibank CSV need for QuickBooks?
QuickBooks needs a Date column, a Description column, and an Amount column, or a Date and Description with separate Credit and Debit columns. Citibank CSV exports usually include date, description, and amount already, but the date format and the way debits are signed can trip up a direct upload. Converting to .qbo standardizes all of that so you never have to map columns by hand.
Is it safe to convert a Citibank CSV to QBO?
Yes. A CSV holds only the transaction rows you exported: dates, descriptions, and amounts. It does not contain your online banking password or full account access. The converter reads those rows and writes a .qbo file in the same Web Connect structure QuickBooks expects, so nothing about your Citibank login is exposed in the process.
Does this work for Citibank business and credit card accounts?
Yes. The same flow works for Citibank business checking, personal checking, and Citi credit card activity, including the card accounts that only let you download a CSV. Export the CSV for whichever account you need, convert it to .qbo, and import it into the matching account in QuickBooks. For card accounts the converter keeps charges and payments on the correct side so your balance reconciles.
Can I batch several Citibank CSV files at once?
On a free try you convert one file at a time, which covers most monthly bookkeeping. If you handle multiple accounts or many clients, the paid plans support bulk conversion so you can turn a stack of Citibank CSV exports into .qbo files together. Bookkeeping firms running Citi statements for several businesses usually want this batch workflow.
Once your file is converted, learn the exact import path in our guides on CSV to QuickBooks Online and CSV to QuickBooks Desktop, handle several accounts in importing multiple CSV files into QuickBooks, and pick the right tool in our roundup of the best CSV to QBO converter. For the full walkthrough see how to convert CSV to QBO and how to import a .qbo file into QuickBooks. If a feed keeps failing, our guide on QuickBooks bank feed not working walks through the manual fix. If your statement is a PDF, first turn it into a clean spreadsheet with bankxlsx or a QBO file with pdfqbo, and when you apply for financing, lenders run those statements through lenderanalyzer.