Skip to content

How to Import Citi Transactions into QuickBooks (CitiBusiness, Citi Cards, CSV)

By ConvertQBO Team ·

Citi is one of the trickier banks to bring into QuickBooks: business cards connect under names you wouldn’t guess, and CitiBusiness Online’s QuickBooks file doesn’t cover credit accounts. Here’s what works for each case.

Option 1: connect Citi (bank feed)

QuickBooks Online: Banking → Connect account. For Citi business cards, Intuit says Citi changed how some accounts connect, and you have to search for the connection name, not the card name:

Your card Search QuickBooks for
CitiBusiness ThankYou, Platinum Select, World, AT&T Universal Business AT&T Universal Business / CitiBusiness Cards
CitiChairman Citi Chairman AmEx Cards

For personal Citi accounts and cards, search for Citi and pick the listing that matches the account.

QuickBooks Desktop: Banking → Bank Feeds → Set Up Bank Feed for an Account, search for Citi and choose the listing for your account type.

Desktop: Citi Cards stopped connecting (OLSU-1011)

Since September 2024, many QuickBooks Desktop users have seen Citi Cards fail with OLSU-1011. What fixed it for users in the QuickBooks Community:

  1. Install the latest QuickBooks Desktop update (an October 2024 update resolved it for many).
  2. Sign in to Citi in a browser and approve QuickBooks: Profile → More Settings → Security → Manage Desktop Apps → Add Access. Remove old entries for QuickBooks versions you no longer use.
  3. Try the bank feed update again, re-entering your Citi password when asked.

If it still fails, use a file (Option 2 or 3) while you wait, starting the day after the last transaction already in QuickBooks.

Option 2: CitiBusiness Online downloads

CitiBusiness Online has a real QuickBooks download for checking and savings:

  1. Main Menu → Balance and Information Reporting → Recent Account Activity.
  2. Choose Download Activity, the accounts and the date range (up to the last 180 days).
  3. Pick the format: QBO (QuickBooks Web Connect), QFX, QIF, CSV, CSX or BAI.
  4. Import: QuickBooks Desktop File → Utilities → Import → Web Connect Files; QuickBooks Online Banking → Link account ▾ → Upload from file.

Citi notes that:

  • credit account activity can’t be downloaded as QBO or QFX — use CSV for business cards and convert it (Option 3);
  • Web Connect works with the current QuickBooks version and the two before it;
  • if a large import locks up QuickBooks, download a shorter date range or fewer accounts at a time.

Option 3: Citi card CSV to QBO

Personal Citi card download options vary by card and sometimes only CSV is available. Either way:

  1. Download the card’s transactions as CSV (or Quicken (.qfx), if offered).
  2. CSV: drop it into CSV to QBO, choose Credit card as the account type and check the preview: purchases negative, payments positive. Use Reverse signs if they’re flipped. A Quicken file goes into QFX to QBO instead.
  3. Download the .qbo file and import it into the card’s credit card account in QuickBooks.

Older months

CitiBusiness Online keeps 24 months of statements online, and older ones on request. For personal accounts, Citi offers past statements as PDF (and Quicken or Microsoft Money files) for the last 12 months. For a PDF, see PDF bank statement to Excel, then convert the spreadsheet to QBO and reconcile each month to the statement.

Tips

Sources

Read November 4, 2026: Intuit problems connecting a Citibank account; CitiBusiness Online information reporting help and FAQ; QuickBooks Community: Citi Cards since Sept 2 (OLSU-1011), fix via Manage Desktop Apps, fix after the October update.

Report a problem

Something does not convert or looks wrong? Tell us — we read every report. Please don’t paste real bank data.