How to Import Citi Transactions into QuickBooks

Short answer: Citi connects to QuickBooks one clean way, a live bank feed, and it does not offer a QBO or QFX download at all. Its manual export is a CSV that reaches only about the last 90 days and rarely includes pending charges, and the live Citi feed is a recurring source of missing-transaction complaints. Older history lives only in the PDF statements Citi keeps online for about seven years. To load an older period, a closed account, QuickBooks Desktop, or a clean full year, convert the PDF statement to a QBO Web Connect file and import it like a bank download. Here is how each route works.

Can you import Citi transactions into QuickBooks?

Yes, but the options are narrower than at many banks. A live bank feed connects Citi to QuickBooks Online and refreshes automatically, though it drops transactions often enough that many bookkeepers do not rely on it alone. The manual export is a CSV, not a QBO, and reaches only about the last 90 days. A converted PDF statement produces a real Web Connect QBO for any period, which is why it is the dependable route for anything beyond the last quarter.

Does Citi have a QBO file?

No. Unlike Chase or Wells Fargo, Citi does not offer a QuickBooks Web Connect (QBO) or Quicken (QFX) download. The only manual export is a CSV, and it covers roughly the last 90 days of a date range you choose, often without the pending charges that have not posted yet. A CSV is not a bank feed file, so QuickBooks makes you map its columns to Date, Description, and Amount by hand on every import, and it carries no duplicate detection. The full walkthrough of the export is in how to export Citi transactions to CSV or Excel.

How do I import older Citi history into QuickBooks?

Through the PDF statement. Citi keeps monthly statements under Statements for about seven years, far past the 90-day export window, and the statement is the only record left once an account is closed. Convert the PDF with the Citi statement to QBO converter, choose QBO, and you get a Web Connect file you import exactly like a bank download, for any month Citi still shows. It works on Citibank checking and savings statements and on Citi credit card statements, from the Double Cash and Custom Cash to the Costco Anywhere Visa and CitiBusiness cards, and it gives QuickBooks Desktop users a file to import that the CSV export never provided.

How to import a Citi statement into QuickBooks step by step

1. Find the statement. On citi.com or citibank.com open Statements and download the PDF for the period you need.
2. Convert it to QBO. Drop the PDF into the converter and pick QBO. QFX, OFX, CSV, and Excel sit next to it if a different target needs them.
3. Import it. QuickBooks Online: Transactions, Bank transactions, Upload from file, then choose the Citi account. Desktop: File, Utilities, Import, Web Connect Files.
4. Review and categorize. The transactions land in the For Review queue so your bank rules run and nothing posts blind. Clean, reconciled books are what a lender or partner expects to see when they turn the bookkeeping into a formal financial statement.

Why does QuickBooks keep missing Citi transactions?

The Citi live feed is one of the more frequently reported connections for transactions that stop importing or arrive incomplete, on top of the standard rule that a new feed backfills only about 90 days. That backfill is a QuickBooks limit, not a Citi one, and it is why a year-end catch-up often starts with most of the year missing. When the feed is dropping data or the months you need are older than 90 days, the fix is the same: convert the statements and upload them behind the feed. There is more on the backfill rule in why QuickBooks only imports 90 days of transactions.

Does Citi charge for QuickBooks?

No. Citi does not bill for the QuickBooks Online bank feed or for the CSV export, and because it offers no Direct Connect feed there is no monthly connection fee to worry about either. The cost is not money, it is the missing QBO format and the short 90-day window, which is what pushes most Citi bookkeeping through statement conversion once the period runs past a quarter.

Avoiding duplicate Citi transactions

Duplicates appear when a live feed and an uploaded file overlap. Open the account register, find the oldest transaction the feed brought in, and end your uploaded file the day before it. Load history behind the feed, never on top of it. If you are rebuilding a heavy year, remember a QuickBooks Online upload caps at 1,000 lines and 350 KB per file, so split the year into date ranges under that ceiling. The details are in how many transactions QuickBooks accepts at once.

The short version

Citi gives you a live feed and a 90-day CSV, but no QBO file, and the feed is not always reliable. For anything older than a quarter, a closed account, or QuickBooks Desktop, convert the PDF statement to a QBO and import it like a bank download. It handles both Citibank accounts and Citi credit cards. You can also take the same statement as a spreadsheet with the Citibank statement to Excel converter, and the general case for any institution is the bank statement to QBO converter.