How to Import Citi Transactions into QuickBooks (CitiBusiness, Citi Cards, CSV)
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:
- Install the latest QuickBooks Desktop update (an October 2024 update resolved it for many).
- 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.
- 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:
- Main Menu → Balance and Information Reporting → Recent Account Activity.
- Choose Download Activity, the accounts and the date range (up to the last 180 days).
- Pick the format: QBO (QuickBooks Web Connect), QFX, QIF, CSV, CSX or BAI.
- 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:
- Download the card’s transactions as CSV (or Quicken (.qfx), if offered).
- 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.
- Download the
.qbofile 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
- Don’t import the same dates through both the bank feed and a file.
- On QuickBooks Desktop 2023 or older, bank downloads stopped after May 31, 2026: Desktop bank feeds not working.
- Other connection errors: QuickBooks bank feed errors.
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.