Personal Citi accounts stopped offering a QBO or OFX download, and CitiBusiness only reports about 180 days of activity, so most Citi history never reaches QuickBooks through the bank. Upload any Citibank PDF statement and BankXLSX writes a QuickBooks Web Connect file with every transaction dated, described, and signed correctly. Start free, no credit card.
Last updated July 2026
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Upload the Citibank PDF statement to BankXLSX and download the result as a QBO file. The converter reads each transaction, keeps the posting date and description, signs debits negative and credits positive, and writes a QuickBooks Web Connect file the bank feed accepts. This matters for Citi because personal accounts no longer offer a QBO download at all, and CitiBusiness reporting reaches back only about 180 days, so the PDF statement is the record that carries your full history.
Citi is the bank where the native path breaks down the most. Personal accounts lost the QBO download, business reporting is time-boxed, and Direct Connect has been going away.
On the consumer side, Citi export is CSV only. There is no QBO or QFX file to hand QuickBooks, so the mapped-file path most banks offer simply does not exist here.
CitiBusiness Online supports QBO and QFX Web Connect files, but its activity reporting covers roughly the last 180 days. Older business history has to come from statements.
Users report Citi discontinuing OFX and Direct Connect links to Quicken and QuickBooks, leaving CSV and the statement PDF as the dependable records.
Once a Citi account closes, online download disappears. The saved PDF statements are all that is left, and QuickBooks cannot read a PDF.
Even where CSV is offered, you remap columns by hand on every import and lose the account ID that drives QuickBooks duplicate detection.
Retyping a year of Citi checking or Costco card activity into the register burns days and invites transposed amounts that break the reconciliation.
Upload the statement and the converter reads it like a bookkeeper would, then writes a valid Web Connect file QuickBooks accepts on the first try, the file Citi itself no longer gives personal customers.
You get an actual .qbo file with the OFX structure QuickBooks expects, not a CSV you have to remap column by column on every import.
Personal checking and savings, Citigold, CitiBusiness, and Citi card statements all parse correctly, including the Costco Anywhere Visa.
Debits land negative and credits positive with the correct posting date, so the register reconciles to the statement balance without hand fixes.
OCR reads image-only and scanned Citi PDFs, which is what older saved statements and paper scans usually are.
The same upload also exports QFX for Quicken, OFX for other software, and CSV or XLSX when you want the raw rows.
256-bit encryption in transit, and you can delete your uploaded statements whenever you want.
No software to install and no credit card to start.
Drag the statement into the box above. Download it first from citi.com under Statements if you have not already.
Tip: Several months in one file is fine.
Once the transactions are read, pick QBO as the download format. QFX, OFX, CSV, and Excel sit next to it.
Tip: Pick QFX if the target is Quicken.
QuickBooks Online: Banking, then Upload from file. Desktop: File, Utilities, Import, Web Connect Files. Pick the account and review.
Tip: Match the account before you add.
Because personal Citi lost its QBO download and CitiBusiness reporting is short, almost anyone keeping Citi books in QuickBooks ends up converting statements.
Import a client's Citi history into QuickBooks when the account gives nothing but CSV and a stack of PDFs.
Bring pre-conversion and closed-account Citi history into QuickBooks during cleanup and audit engagements.
Catch up months of CitiBusiness activity that fell outside the 180-day reporting window before tax season.
Load a full year of Costco Anywhere Visa activity into the books without retyping every line.
It depends which side of Citi you are on. Personal Citi accounts do not offer a QBO or QFX download anymore, only CSV, so there is no bank-made Web Connect file to import. CitiBusiness Online is different: it does support QBO and QFX Web Connect files, but its balance and activity reporting reaches back only about 180 days. Either way, the moment you need older history, a closed account, or a personal account with no QBO option, the native download comes up short.
That is the gap this converter fills. Citi keeps your statements available as PDFs long after the download window closes, and BankXLSX turns any of those PDFs into the same kind of QBO file QuickBooks imports from a normal bank feed, personal or business, current or years old.
| Citi native download | BankXLSX PDF conversion | |
|---|---|---|
| Personal accounts | CSV only, no QBO or QFX | QBO from any personal Citi PDF |
| Business reach | CitiBusiness reporting about 180 days | Any statement PDF, years of history |
| Closed accounts | No online export | Works from saved or requested PDF statements |
| Scanned or emailed PDFs | Not applicable | OCR reads scans and image statements |
| Output formats | CSV, plus QBO/QFX on CitiBusiness | QBO, QFX, OFX, CSV, Excel from one upload |
In QuickBooks Online, open Transactions, then Bank transactions, choose the account, and pick Upload from file under the Link account dropdown. Select the QBO file, confirm which QuickBooks account it belongs to, and the Citi transactions land in the For review tab ready to categorize. In QuickBooks Desktop, go to File, Utilities, Import, Web Connect Files, and choose the file. If the account already has an active Citi feed, deactivate it in Bank Feed Settings first so the two imports do not collide.
The converter reads all of them. A CitiBusiness checking statement, a personal Citi checking statement, and a Citi or Costco Anywhere Visa card statement each come out as a clean QBO file with signed amounts. If you want the spreadsheet first, the Citibank statement to Excel converter and the Citi credit card statement converter produce XLSX and CSV from the same upload, and the general bank statement to QBO converter covers every other bank. For the import walkthrough end to end, our guide on how to convert bank statements to QuickBooks (QBO) has screenshots of both QuickBooks versions.
Already pulled a CSV out of Citi and just need it in Web Connect form? A dedicated CSV to QBO converter handles that step directly. And if statements from several banks are headed into the books, a purpose-built bank statement to QuickBooks converter runs the same PDF to QBO workflow across all of them.
Only from CitiBusiness Online, which supports QBO and QFX Web Connect files for roughly the last 180 days of activity. Personal Citi accounts export CSV only, with no QBO option. For anything older or for personal accounts, convert the Citi PDF statement to QBO with BankXLSX.
QuickBooks never imports the statement document itself. On CitiBusiness you can pull a QBO file for recent activity and upload it. For personal accounts, older months, or closed accounts, convert the PDF statement to QBO and import that, since it is the only route Citi leaves open.
No. Citi retired Direct Connect and OFX downloads for personal accounts, leaving CSV as the only native export. That is why converting the PDF statement to a QBO file is usually the fastest way to get personal Citi activity into QuickBooks.
CitiBusiness reporting covers about 180 days, and personal CSV export is similarly limited. PDF statements stay available for years, which is why prior-year bookkeeping and audits run through statement conversion rather than the native download.
No. QuickBooks Online and Desktop accept QBO, QFX, and OFX in the bank feed, with CSV as a manual fallback. A PDF is a document, not a data file, so it has to be converted first. BankXLSX reads the Citi PDF and writes the QBO file QuickBooks expects.
Yes. Citi cards and the Costco Anywhere Visa convert the same way, with purchases, payments, credits, and fees signed correctly. That covers a full year of card activity the native tools rarely reach in one pull.
QBO imports like a real bank download, with the account mapping and duplicate detection built in, so prefer it when QuickBooks is the destination. CSV makes sense when you want to review or edit rows in a spreadsheet first. BankXLSX exports both from the same conversion.
Uploads are encrypted in transit with 256-bit encryption, files can be deleted whenever you choose, and your data is never resold or shared. Nothing installs on your machine; the whole conversion runs in the browser.
Convert any bank statement to a QBO file.
The same Citi statements as XLSX or CSV.
The QBO converter for Capital One.
The mapped-CSV route into QuickBooks.
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
