Citibank Statement to QuickBooks: Convert a Citibank PDF Statement to QBO

Convert a Citibank statement to QuickBooks. Upload the PDF and get a .QBO file that imports into QuickBooks Online or Desktop, balanced to the original.

Totals reconcile to the original QuickBooks Online and Desktop
csv / xls / xlsx → .qbo
No file handy?

No account needed for your first conversions. We never store your bank login.

There are two ways to get Citibank transactions into QuickBooks, and they solve different problems. A live bank feed links Citibank to QuickBooks and pulls recent activity in for you. Converting a Citibank PDF statement covers what the feed misses: older months, closed accounts, the period before you connected, or any stretch where the connection dropped or duplicated transactions. The converter at the top of this page handles that second job.

Upload a Citibank PDF statement and you get back a .qbo Web Connect file that imports into QuickBooks Online or QuickBooks Desktop, plus matching Excel and CSV copies. Every transaction keeps its date, description, and amount, and the converter checks its running total against the statement before you export. Here is when to convert, when to connect the feed, and how to do each with Citibank.

A real .qbo file QuickBooks accepts

Built for the CSV and Excel exports US banks and cards actually send, checked before it exports.

Reconciliation

Every total checked against your file

The converter adds up the transactions it parsed and matches that to your file total before you export, so nothing is silently dropped.

Web Connect

A genuine .qbo, not a renamed CSV

Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.

Column mapping

Your columns mapped automatically

Date, description, and amount are detected for you, so you skip QuickBooks' strict 3-column and 4-column CSV layout.

Volume

A year of CSV files in one batch

Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.

Dates and amounts

Dates and amounts fixed for you

Mixed date formats, currency symbols, and stray commas that break a raw CSV import are cleaned up before the .qbo is built.

Exports

Excel and CSV in the same download

One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.

How to convert your CSV to QuickBooks

Three steps. No column-mapping wizard.

1

Upload your CSV or Excel file

Drag in a CSV, XLS, or XLSX export from your bank, credit card, or accounting tool. Any column order is fine.

2

Review the reconciled rows

Every transaction is parsed and checked against your file total. You see the rows before exporting.

3

Import into QuickBooks

Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.

Questions worth answering

The specifics that decide whether the import is clean. If your case is not here, message us in chat.

Does Citibank work with QuickBooks?

Yes, Citibank works with QuickBooks. Citi connects to QuickBooks Online through bank feeds, and CitiBusiness Online can export activity directly in QuickBooks Web Connect (.qbo) and Quicken (.qfx) formats. The limit is history. Citibank shows the last 24 months of statements for immediate online viewing and a fresh bank feed usually imports only about 90 days. For anything older, closed accounts, or any period the feed skipped, you download the Citibank PDF statement and convert it.

How do I download Citibank transactions to QuickBooks?

For recent activity, CitiBusiness Online lets you download transactions as a Web Connect .qbo file you import straight into QuickBooks. One quirk to know: CitiBusiness appends an account-type tag (CKG for checking, SAV for savings, MMA for money market) after the account number, so confirm you are importing into the right QuickBooks account. For statements older than the download window, you convert the Citibank PDF to a .qbo file with the converter above and import it the same way.

Why is Citibank not connecting to QuickBooks?

Citi feeds break for a handful of common reasons: Citibank security or login changes, an expired online banking password, a multi-factor prompt QuickBooks cannot pass, or a temporary outage on either side. While the feed is down, your bookkeeping does not have to wait. Download the Citibank PDF statement for the affected period, convert it to a .qbo file here, and import that into QuickBooks so the account stays current until the connection comes back. This also fills any gap the broken feed left behind.

How do I download a Citibank statement as a PDF?

Sign in at citi.com, choose the account, and open Statements (you may need to activate online statements first). Citibank keeps the past 24 months immediately available and statements stay online for up to seven years, so you can download whichever months you need as PDFs. There is also a transaction export for recent activity, but for older periods, or when you want the figures exactly as printed, the PDF statement is what you convert from.

How do I import a Citibank statement into QuickBooks?

Convert the Citibank PDF to a .qbo file with the converter above, then import that file. In QuickBooks Online, go to Transactions, Bank transactions, then Upload from file, and pick the .qbo. In QuickBooks Desktop, go to File, Utilities, Import, Web Connect Files. QuickBooks asks which account the transactions belong to, then drops them into the banking review queue for matching and categorizing, the same as a downloaded feed would.

What a Citibank statement looks like to the converter

Citibank statements follow a steady layout that converts cleanly. Checking and savings statements list transactions in date order with a description and amount, separating deposits and credits from debits, checks, and withdrawals, with balance figures alongside. Citi often bundles linked checking, savings, and money market accounts into one combined statement, so when you convert one that spans several accounts, confirm which account each transaction set belongs to before importing. Citi credit card statements convert the same way, with dated charges, payments, and credits parsed into clean rows. The converter strips out the summary boxes, fee tables, and inserts Citi adds, so only real transactions reach your .qbo file.

How far back can I get Citibank statements?

Citibank keeps the last 24 months of statements immediately available online and stores statements for up to seven years, far beyond the roughly 90-day window a fresh bank feed imports. That gap is why converting matters. You can pull a Citibank statement from two or three years ago, convert it to QBO, and bring those transactions into QuickBooks even though the live feed would never reach them. For records older than the online window, you can request archived statements from Citibank and convert those PDFs the same way.

When to convert versus connect the feed

Connect the Citibank feed for transactions going forward, because it keeps QuickBooks current with little effort. Convert the PDF statement when you need history the feed missed: opening balances for a new QuickBooks file, a catch-up period before the connection existed, a closed Citibank account, or any month where the feed dropped or duplicated transactions. Most real Citibank cleanups use both methods together, the feed for new activity and converted statements to backfill the rest.

How accurate is the converted Citibank file?

Accuracy is the part that matters most, because a converter that quietly drops or misreads a Citibank transaction costs you far more time than it saves. The error usually surfaces during reconciliation, sometimes weeks later, when you are chasing a few dollars across a long register. This converter totals the transactions it parsed and checks that figure against the statement total before it lets you export, so the .qbo you import reflects every line Citibank printed. You review the parsed rows in the preview first, then export when the numbers tie out.

Convert your first file free.

Upload a CSV or Excel export, get a QuickBooks-ready .qbo back in seconds. No card to try it.

Related guides

Start by uploading a Citibank statement in the converter above. You can also see how the underlying PDF to QBO converter works, follow the full steps to import bank statements into QuickBooks Online, handle Desktop with our QuickBooks Desktop conversion guide, learn what a QBO file is, or convert any bank statement to QuickBooks from the home page.