Convert QuickBooks Online to Desktop with Intuit's migration tool, see exactly what does not transfer, and import bank transactions to Desktop as .qbo files.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF · Max 50MB
Uploading...
Yes, you can convert QuickBooks Online to Desktop. Intuit publishes a migration tool inside QuickBooks Online that exports your company as a QBXML file, which you then import from the No Company Open screen in QuickBooks Desktop. The catch is banking: the export moves your ledger, not your bank connection, and QuickBooks Desktop accepts bank transactions in exactly one format, a .qbo Web Connect file. Anything the export leaves behind has to come back in as .qbo, which is what this page is about.
Last updated August 2026. Export routes and file formats checked against Intuit's own QuickBooks Online export and QuickBooks Desktop import documentation in August 2026, plus current QuickBooks Desktop discontinuation dates.
There are two different official ways out of QuickBooks Online, and people mix them up constantly. One moves your transactions. The other moves only names and balances. Picking the wrong one is the single most common reason a conversion has to be redone from scratch.
| Route out of QuickBooks Online | What it actually moves | File you end up with |
|---|---|---|
| The QuickBooks Desktop migration tool, reached from the Export Overview page in QuickBooks Online | Your financial data, with an option for all financial data or all financial data without transactions. This is the route to use if you want history, not just a shell. | A QBXML file you import from the No Company Open screen in QuickBooks Desktop |
| Move lists and balances to QuickBooks Desktop | Customers, vendors, the chart of accounts and current open balances only. No transaction detail behind those balances. | List and balance files, imported into a fresh Desktop company |
| Plain report and list exports from QuickBooks Online | Individual reports and lists as Excel or CSV. Useful for reference, not a conversion. | Spreadsheets, which QuickBooks Desktop will not accept as bank transactions |
Before you start, back up. An import into QuickBooks Desktop cannot be undone, so run it into a brand new company file rather than one you already have work in. Install and open QuickBooks Desktop first and leave it sitting on the No Company Open screen, because the migration tool looks for a running copy of Desktop and will not proceed without one.
Now the part that decides how much cleanup you are in for. Some things simply do not survive the trip, and none of them throw a warning at you.
| What you have in QuickBooks Online | Does it land in QuickBooks Desktop? | What to do about it |
|---|---|---|
| Chart of accounts, customers, vendors, products and services | Yes, these are the reliable part of the export. | Spot check account types after import. Detail types in QuickBooks Online do not map one to one onto Desktop account types. |
| Invoices, bills, payments and other posted transactions | Yes, if you choose the option that includes transactions, and only as far back as the export reaches. | Run a profit and loss and a balance sheet in both systems for the same date range and compare totals before you trust it. |
| Bank and credit card feed connections | No. Connections do not transfer at all. | Set up Bank Feeds again in Desktop, or import a .qbo file. See the banking table below. |
| Attachments and documents | No. | Download them from QuickBooks Online while the subscription is still active. Once it lapses you lose the ability to pull them. |
| Audit log | No. | Export or screenshot anything you need for an audit trail before you cancel. |
| Recurring transactions and templates | No. | Rebuild them as memorized transactions in Desktop. |
| Payroll setup and history | Not in a usable form. | Treat payroll as a separate project and plan year to date entries. |
| Multicurrency settings | Not cleanly. | If you use multicurrency, get a specialist involved. Turning it on in either product is irreversible. |
| Bank reconciliation history | No, reconciliations do not carry over. | Your first Desktop reconciliation starts from the imported balances, not from a prior reconciled state. |
How far back the transaction export reaches is the question everyone asks and the one with the least reliable public answer. Third party migration guides commonly quote a window of roughly the last 18 months, with anything older arriving as opening balances rather than individual transactions. Intuit does not publish that number in the places we can verify, so treat it as a planning assumption rather than a promise, and check what your own Export Overview page offers before you cancel anything. What matters practically is the shape of the problem: at some point in the past, detail stops and a balance starts.
That is exactly where a converter earns its keep. If you need real transaction detail for a period the export flattened into an opening balance, the statements are the source of truth, and QuickBooks Desktop will take them in one format only.
| Getting bank transactions into QuickBooks Desktop | Works? | How far back it goes |
|---|---|---|
| Direct Connect | Yes, if your bank offers it and you enroll on the bank's side. | Whatever the bank chooses to serve, typically a short recent window, and it stops working on an out of support Desktop version. |
| Web Connect, downloading a .qbo file from your bank's website | Yes. | Whatever periods your bank still publishes for download, often 12 to 24 months and shrinking for closed accounts. |
| A .qbo file you create from the statement PDF | Yes. | Any period you have a statement for. There is no date limit on importing a .qbo file, which is why this is the standard fix for backdated work. |
| CSV or Excel of bank transactions | No. QuickBooks Desktop has no CSV route for bank transactions at all. | Not applicable. The Import Excel and CSV Toolkit covers lists only, never bank activity. |
| Typing them into the register | Yes. | Any period, at roughly a minute per transaction. |
That third row is the whole reason this site exists. Upload the statement PDF above, get a .qbo file back, and open it in QuickBooks Desktop through File then Utilities then Import then Web Connect Files. It does not care that the statement is from 2023. Our PDF to QBO converter reads scanned and text statements, reconciles the running balance so the totals match the paper, and writes the Web Connect file Desktop expects.
One more thing worth knowing before you commit to the move. QuickBooks Desktop 2023 lost support on May 31, 2026, and QuickBooks Desktop 2024 loses it on September 30, 2027. Enterprise is still sold and has no announced end date. An out of support version does not stop opening, and your file stays readable, but anything that talks to Intuit's servers goes quiet, and that includes bank feeds. If you are converting onto a version that is already past its date, plan on statement conversion being your permanent banking workflow rather than a stopgap.
Built for the statements US banks actually send, checked before it exports.
The converter adds up the transactions it parsed and matches that to the statement total before you export, so nothing is silently dropped.
Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.
OCR runs before parsing, so a scanned or photographed paper statement comes out the same as a digital PDF.
Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.
Enter the password on upload. Multi-column and multi-page statement layouts are parsed too.
One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.
Three steps. No column-mapping wizard.
Drag in a PDF, a scan, or a phone photo. Password-protected and multi-page files are fine.
Every transaction is extracted and checked against the statement total. You see the parsed rows before exporting.
Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.
The specifics that decide whether the import is clean. If your case is not here, email [email protected].
Yes. Intuit provides a migration tool inside QuickBooks Online that exports your company data as a QBXML file, which QuickBooks Desktop imports from the No Company Open screen. It is a supported path, not a workaround. What it does not move is your bank and credit card connections, your attachments, your audit log or your reconciliation history, so budget time for rebuilding those after the data lands.
Install and open QuickBooks Desktop and leave it on the No Company Open screen. In QuickBooks Online, go to the Export Overview page, select Get Started, and download the migration tool. Choose whether to export all financial data or all financial data without transactions, enter your name and email, and wait for the confirmation email. Then open the migration tool, browse to the QBXML file, and import it.
The export itself happens from the Export Overview page in QuickBooks Online, not from QuickBooks Desktop. You request the export, Intuit prepares it, and you receive a QBXML file. Large company files can take hours to prepare, so start the export before you plan the import rather than trying to do both in one sitting.
You need a currently installed US edition of QuickBooks Desktop, opened and sitting at the No Company Open screen, before the migration tool will run. Intuit does not publish a clean public matrix of which years and editions the importer accepts, and community reports cover Pro, Premier and Enterprise on recent versions. Confirm against your specific version before you buy a license purely for a conversion.
Not as far as most people expect. Migration guides commonly describe a window of around the last 18 months of transaction detail, with older activity arriving as opening balances instead of individual entries. That figure is not something Intuit publishes where it can be verified, so confirm it on your own Export Overview page. Whatever the cutoff turns out to be, any period that flattens into a balance has to be rebuilt from statements if you need the detail.
QuickBooks Desktop imports bank transactions through Web Connect, which means a .qbo file. You can download one from your bank if it offers QuickBooks downloads, set up Direct Connect if your bank supports it, or convert the statement PDF into a .qbo file yourself. The conversion route is the only one with no date restriction, so it is what people use for older periods and closed accounts.
No. QuickBooks Desktop has never accepted a CSV of bank transactions. QuickBooks Online does accept a CSV bank upload, but Desktop does not, and the free QuickBooks Import Excel and CSV Toolkit does not change that, because it covers lists such as customers, vendors, items and the chart of accounts only. If your data is in a spreadsheet, it has to become a .qbo file first.
No. Reconciliation history does not come across, which means your first reconciliation in Desktop starts from the imported balances rather than from a prior reconciled state. Pull and save your QuickBooks Online reconciliation reports as PDFs before you cancel the subscription. Once the subscription lapses you cannot get them back.
QuickBooks Desktop 2024 is the last non Enterprise version and it loses support on September 30, 2027. You can convert into it today, but you are converting onto a product with a known end date for connected services. If banking matters to you, assume bank feeds will stop on that date and that statement conversion to .qbo will be how transactions get in afterward.
The export request itself is quick, but preparation on Intuit's side ranges from minutes to several hours depending on file size, and you are notified by email. The import into Desktop is usually the fast part. The real time cost is afterward: rebuilding bank connections, recurring transactions, attachments and payroll, then reconciling the opening balances against statements.
Stay online if you need multiple users in different locations, live bank feeds and app integrations, and you are comfortable with a subscription. Convert to Desktop if you want a one time license, local data, and job costing or inventory behavior that Desktop still does better. Be honest about the banking tradeoff: Desktop's connected services are on a published sunset schedule, and converting statements to .qbo is the durable way to keep bank data flowing into a Desktop file.
Upload a PDF, see every transaction extracted in seconds. No card to try it.
Still comparing tools? See our bank statement to QuickBooks converter comparison.
Intuit's migration tool itself is free. Your costs are the QuickBooks Desktop license, any specialist help if you run multicurrency or payroll, and the cleanup labor. If you need historical bank detail rebuilt, a converter is the other line item. Our Plus plan at $149 a month, or $74 a month billed annually, is the tier that includes .qbo export and bulk conversion, and the first three statements are free with no card.
Once the conversion is done, the practical question becomes how you keep feeding the Desktop file. Converting each month's statement is a five minute job, and it produces the same Web Connect file a bank download would, so nothing about your workflow inside QuickBooks changes.
If you are moving the other direction, or you have not decided yet, the comparison is worth reading before you commit either way.
Related pages: convert QuickBooks Desktop to Online, convert a bank statement to QuickBooks Desktop, QBO converter, what a .qbo file is and Direct Connect compared with Web Connect.
Same converter, tuned for the layout each bank uses. Find yours:
For one bookkeeper running monthly close.
USD
per month
per month
$288 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
For an accounting firm or finance team with steady volume. Adds QuickBooks .qbo export and bulk conversion.
USD
per month
per month
$888 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
For lenders, audit firms and analysts running thousands of statements a month.
USD
per month
per month
$ charged today
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
