Convert a Citi statement to QuickBooks (QBO)

To convert a Citi statement to QuickBooks (QBO), drop the PDF below. LedgerClip rebuilds the transaction table on your device and gives you a QuickBooks Web Connect file that imports into QuickBooks Desktop and QuickBooks Online through Banking, then Upload transactions. Nothing is uploaded.

Drop your Citi statement here

or choose a file — PDF, scan, or photo

Exports to CSV, Excel, QBO, OFX and QIF
On your device

Statements are read here in your browser. Nothing is sent to a server.

0bytes uploaded

QuickBooks file details

QuickBooks only accepts .qbo files that name a supported bank. Pick yours, or keep the default, which QuickBooks accepts for any account.

You've used your 3 free statements this month

Pro is $12/month or $79/year for unlimited statements. Cancel any time from the link in your receipt; there is no lock-in and no surprise renewal.

Already have a license key?

Statement format

Confirmed — Citi's downloaded statements are text PDFs that parse directly.

QuickBooks institution ID

Uses a QuickBooks-accepted default ID that works for any account.

Also exports

CSV, Excel

Getting the PDF from Citi

Go to Statements & Documents, pick the account and statement date, then Download as PDF. Citi statements downloaded this way are text PDFs and parse directly. A scan or photo also works, read on your device with OCR.

What you get

Each transaction becomes one row with the posting date, the description exactly as Citi printed it, the amount with the right sign, and the running balance. The opening and closing balances are checked against the total so an incomplete extraction is caught before import.

Other formats

Also available for Citi: CSV, Excel.

Questions

Can I use a Citi scan or photo, or does it have to be the downloaded PDF?
Both work. A Citi statement downloaded from online banking is read from its text and is the most reliable. A scan or a phone photo is read on your device with OCR and checked so the totals reconcile.
Is my Citi statement uploaded?
No. The file is opened by code running in your browser and never transmitted. The byte counter on the page shows zero throughout.
What does the QuickBooks (QBO) file contain?
An OFX 1.02 Web Connect file with a registered bank ID, a stable ID per transaction, and the closing balance, which is what QuickBooks expects.
How many statements are free?
Three a month, with every export format. Pro removes the limit.

Convert another bank

LedgerClip reads 24 banks. Convert a QuickBooks (QBO) from U.S. Bank, Capital One, PNC, Truist, or see every supported bank.

If a Citi statement does not parse, report it and the layout is added within days. Updated .