Citizens does hand you a QBO from Download Account Data, but only for an account that is still open and only for the activity still showing online. Prior years, closed accounts, and statements a client forwards as a PDF need a different path. Upload the Citizens PDF here and download a real QuickBooks Web Connect file. 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 Citizens PDF statement to BankXLSX and choose QBO as the download format. Citizens does offer a QBO through Download Account Data, alongside CSV, QBX, OFX, and QIF, but that download only exists for an open account and only covers the activity still visible online, and it dropped QFX for Quicken users. When you need a closed account, a prior year, or a statement a client emailed you, the PDF is what you have, and converting it produces the same Web Connect file QuickBooks imports.
Citizens Financial Group runs one of the larger US retail and commercial banks, and its export options look fine until the job in front of you is a cleanup rather than this month's bookkeeping.
Close a Citizens account and Download Account Data goes with it. The statement PDFs you saved are the only remaining record of that history.
The export reaches the activity Citizens still shows in online banking. A cleanup that starts two years ago runs out of data long before it runs out of months.
Quicken users report that QFX is no longer offered as a manual download format, and Citizens stopped signing up new Direct Connect customers back in June 2022.
Clients forward a statement, not a login. Without portal access there is no Download Account Data button to press, only the document in your inbox.
Citizens connections into QuickBooks Online have a long history of dropping, and a broken feed leaves the month unimported.
Desktop Web Connect imports .qbo and nothing else. Renaming the statement does not turn a document into a data file.
Upload the official statement and get back a valid Web Connect file QuickBooks accepts on the first try, whether the account is open, closed, or two years behind.
You get an actual .qbo file with the OFX structure QuickBooks expects, the only format QuickBooks Desktop Web Connect will import.
Citizens One Deposit Checking, Quest and Private Client statements, savings, and Citizens business checking all parse correctly.
A saved or requested PDF is enough. No login, no open account, and no working feed required.
Debits land negative and credits positive with the correct posting date, so the register reconciles to the statement balance without hand fixes.
The same upload writes the QFX for Quicken that Citizens no longer offers, plus OFX, CSV, and XLSX.
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.
In Citizens online banking, open the account and download the monthly statement from Documents. A statement a client forwarded works just as well. Drag it into the box above.
Tip: Several months in one upload 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: Transactions, Bank transactions, Upload from file. Desktop: File, Utilities, Import, Web Connect Files. Pick the account and review.
Tip: One Citizens account per file.
Citizens banks a large share of Northeast and Mid-Atlantic households and small businesses, and the people who convert its statements are almost always working on something the bank feed cannot reach: a prior year, a closed account, or a client file that arrived as a PDF.
Turn a forwarded Citizens statement into a QuickBooks import without asking the client for their online banking password.
Reconcile against the official Citizens statement during cleanups, reviews, and tax prep, including periods the download no longer covers.
Bring Citizens business checking activity into QuickBooks for a lender package or a year-end close.
Move Citizens rental income and expenses into QuickBooks for Schedule E without retyping a line.
Yes, and this page is honest about it. Sign in, open the account history, and Download Account Data offers CSV, QBO, QBX, OFX, and QIF. If your account is open and the transactions you need are still visible in online banking, use it, that is the fastest path and it is free. The gaps show up everywhere else: QFX has been dropped from the manual download list, Citizens stopped taking new Quicken Direct Connect customers in June 2022, a closed account has no download at all, and a bookkeeper who was emailed a statement never sees the button. In every one of those cases the PDF is the record you hold, and converting it produces the same QBO file.
| Citizens Download Account Data | BankXLSX PDF conversion | |
|---|---|---|
| QBO file | Yes, for open accounts | Yes, from any statement PDF |
| QFX for Quicken | No longer offered | Yes, from the same upload |
| History reach | Activity still visible online | Every statement PDF you hold or request |
| Closed accounts | No download | Works from saved or requested PDFs |
| Needs online banking access | Yes, you must be able to log in | No, the PDF is enough |
| Output formats | CSV, QBO, QBX, OFX, QIF | QBO, QFX, OFX, CSV, Excel from one upload |
Citizens closed Quicken Direct Connect to new customers on June 1, 2022, grandfathering the people who already had it, and QFX has since disappeared from the manual download choices. QuickBooks Online users have had a bumpier run still: the Citizens connection has repeatedly stopped updating, and each time it does, the workaround support offers is the same one you are reading about, a manual file upload. A converted statement does not care whether the feed is healthy. It is produced from a document that is already in your possession.
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 the account it maps to, and the Citizens transactions land in the For review tab ready to categorize. In QuickBooks Desktop, use File, Utilities, Import, Web Connect Files. Keep one Citizens account per file, since QuickBooks maps a single QBO to a single account, and keep each upload under 1,000 transactions and 350 KB, the caps QuickBooks Online enforces. Deactivate any live feed on that account first, in Bank Feed Settings, so the manual import and the feed do not duplicate each other.
All of them convert. Citizens One Deposit Checking, Quest and Private Client statements, savings, and business checking come out as clean QBO files with signed amounts intact. Prefer a spreadsheet? The Citizens statement to Excel converter produces XLSX and CSV from the same upload, and the general bank statement to QBO converter covers every other institution. Our guide to converting bank statements to QuickBooks QBO walks through both QuickBooks versions, and if the connection is the real problem, read what to do when the QuickBooks bank feed stops working. Before you upload a busy year, check how many transactions QuickBooks accepts at once.
If you already pulled the Citizens CSV and only need it in Web Connect form, a dedicated CSV to QBO converter does that one job. When statements from several institutions are headed into the same QuickBooks file, a purpose-built bank statement to QuickBooks converter runs the PDF to QBO workflow across all of them.
Yes. Citizens Download Account Data offers CSV, QBO, QBX, OFX, and QIF for accounts that are open and still showing activity online. It does not help with a closed account, a period that has aged off, or a statement a client forwarded to you. In those cases, convert the Citizens PDF statement to QBO instead.
Quicken users report QFX is no longer offered as a manual download format, and Citizens stopped enrolling new Direct Connect customers in June 2022. BankXLSX writes a QFX from the same statement upload that produces the QBO, so Quicken can import a real Web Connect file again.
Convert the Citizens PDF statement to a QBO file, then upload it in QuickBooks Online under Transactions, Bank transactions, Upload from file, or in QuickBooks Desktop under File, Utilities, Import, Web Connect Files. Map it to the right Citizens account and the transactions land in For review, ready to categorize.
Not from the online download, which disappears with the account. Statements you saved, or copies requested from Citizens, are the remaining record. Each PDF converts to a QBO file that imports into QuickBooks exactly like a bank download, which is how closed-account history gets rebuilt.
No. QuickBooks Desktop Web Connect accepts only .qbo files, and QuickBooks Online accepts QBO, QFX, OFX, and CSV on the upload path. A PDF is a document, not a data file. BankXLSX reads the Citizens PDF and writes the QBO file QuickBooks expects.
Aggregated connections break when a bank changes its login flow, adds a verification step, or updates its online banking platform, and the Citizens connection has done this more than once. While it is down, a manual QBO upload keeps the books moving, which is the same workaround Intuit support recommends.
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.
Every QuickBooks import path, and the limits on each.
Convert any bank statement to a QBO file.
The same Citizens statements as XLSX or CSV.
The QBO converter for M&T Bank.
The QBO converter for TD Bank.
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 |
