Convert Citibank CSV to QuickBooks (.QBO)
Works with Citibank CSV and Excel exports Nothing uploaded
Citibank (Citi) lets you export transactions from the Activity page as a CSV/Excel file, and for many accounts that CSV is the only download you'll get, Citi does not reliably offer a QuickBooks Web Connect (.QBO) file the way some big banks do. So if you bank or carry a card with Citi, the path into QuickBooks almost always runs through the CSV.
The wrinkle is Citi's column layout. Instead of one signed amount, Citi commonly splits money in and money out into separate Debit and Credit columns, alongside Date, Description, and (on some accounts) Status. QuickBooks Online can technically read a four-column Date/Description/Credit/Debit file, but the mapping step is fiddly and Citi's status rows or split columns frequently cause amounts to import on the wrong side.
QBO Maker reads Citi's two-column debit/credit structure, merges it into a correctly signed amount, and outputs a clean, valid .QBO (OFX) file QuickBooks imports without guesswork. It all happens in your browser, nothing is uploaded anywhere. Convert your Citibank CSV now.
.QBO QuickBooks accepts. For Citibank, its dates are usually MM/DD/YYYY, and amounts arrive as a separate Debit and Credit columns, both detected automatically.A typical Citibank export has columns like Status, Date, Description, Debit, Credit and uses MM/DD/YYYY dates. QBO Maker auto-detects these, just confirm the mapping.
How to import Citibank statements into QuickBooks
- Export your transactions from Citibank online banking as CSV or Excel.
- Open the QBO Maker converter and drop the file in.
- Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
- Choose .QBO as the output and click download.
- In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.
Citibank-specific things to watch for
- Split Debit/Credit columns. Citi puts money out in
Debitand money inCreditrather than one signed column, a frequent cause of amounts importing on the wrong side. QBO Maker merges them into a single signed amount. - No native .QBO. Citi generally doesn't offer a QuickBooks Web Connect download, so CSV is usually the only route into QuickBooks.
- Pending/Status rows. A leading
Statuscolumn may include pending entries; the converter focuses on posted transactions to avoid duplicates. - Card vs. checking layout. Citi credit-card exports and checking exports can differ slightly in column order, QBO Maker detects both.
QuickBooks Online vs Desktop
QuickBooks Online: Transactions → Bank transactions → Upload from file → choose your .QBO. QuickBooks Desktop: Banking → Bank Feeds → Import Web Connect File. Desktop is stricter about the bank ID, Citibank's routing number is often 021000089, which we prefill when you open the converter from this page.
Frequently asked questions
Does Citibank offer a QuickBooks (.QBO) download?
Not reliably. Unlike some banks, Citi typically only exposes CSV/Excel export, so the dependable way into QuickBooks is to download the CSV and convert it. QBO Maker produces a valid .QBO from your Citi CSV in seconds.
Why do my Citi amounts import on the wrong side in QuickBooks?
Because Citi uses separate Debit and Credit columns instead of one signed amount. If the mapping is off by one column, deposits look like charges and vice versa. QBO Maker combines the two columns into a correctly signed amount so each transaction lands right.
Can I convert a Citi credit-card CSV as well as checking?
Yes. Citi card and checking CSVs differ slightly in column order, but QBO Maker recognizes both and outputs a .QBO either way. See how to import it into QuickBooks Online.
Is my Citibank data sent to a server?
No. Everything runs in your browser. Your Citibank transactions never leave your computer, and QBO Maker stores nothing. You can validate the .QBO before importing.
Convert your Citibank statement now
Free, in your browser, nothing uploaded. We will prefill the Citibank routing number for you.
Open the converter