Leaving QuickBooks Desktop with your data intact
Export while you can still write to the file. Intuit's own page on ending a subscription says it plainly: it recommends exporting your data before you cancel. After the subscription ends, QuickBooks Desktop for Windows 2023 R3 and later, and QuickBooks for Mac Plus 2024 and later, drop into a view-only mode that lasts, in Intuit's words, one year after your subscription ends, where you can view reports but cannot create any transactions, and cannot open attachments linked to transactions. That last one catches people who filed receipts in QuickBooks. So the order is: back up the company file, export every report you will ever want as Excel or CSV, pull the attachments out of the folder they live in, and only then cancel anything.
Two different deadlines that get confused
They are not the same thing and the advice differs.
Your subscription ending is about your licence. Per Intuit's page, view-only access remains for one year after the subscription ends, it covers Pro Plus, Premier Plus and Enterprise, and within it you can view reports but not create transactions. It also lists what goes immediately: third-party apps, Advanced Inventory and Advanced Pricing, and the ability to view attachments linked to transactions. After that year, Intuit says you renew to see your data.
Service discontinuation is about a version's age, and happens whether you are paying or not. Intuit's policy page states: "After May 31, 2026, QuickBooks Desktop 2023 software will be discontinued." That covers Pro Plus 2023, Premier Plus 2023, Enterprise Solutions 23.0, the Accountant editions and Mac Plus 2023. What stops is live technical support plus the connected services: Desktop Payroll, Desktop Payments, bank feeds, payroll tax forms, card and cheque processing, email from inside the program, multicurrency and accountant copy transfers.
What that page does not say is that the software stops opening. If you are relying on a discontinued version still opening your file, test it rather than trusting me or a forum post, and keep a backup elsewhere.
The export list, in the order I would do it
- Back up the company file. File, then Back Up Company, then Create Local Backup. This is the one thing that contains everything, and the one thing only QuickBooks can read. Do it first anyway.
- Export the reports you will actually need. This is where your transactions come out. See the next section.
- Export your lists. File, Utilities, Export, Lists to IIF Files. Customers, vendors, items, chart of accounts, employees.
- Get the attachments out. Attached documents live in a folder alongside the company file, usually named after it with Attach in the name. Copy that whole folder now, because view-only mode specifically cannot open attachments.
- Payroll, if you run it. Export the payroll reports and the employee details while the service is still live, because payroll is among the first things to stop.
- Anything with a legal or tax tail. Whatever your jurisdiction requires you to keep, and for however long. I cannot advise on that and you should not take a retention period from a converter's website.
Do all of this while you can still write to the file. Several of these routes need more than read access.
Transactions come out through reports, not through IIF
This surprises people, and it is worth knowing before you waste an evening on the Export menu. Intuit's help page on IIF files states the limit directly: "You can import transactions but you can't export them from QuickBooks." Only lists come out that way.
The route that works is reports. Open a report, set the date range wide, then use the Excel button or export as CSV. The ones worth taking:
- A general ledger or transaction detail report for every year you want to keep, one file per year so the files stay openable.
- Profit and loss, and balance sheet, per financial year.
- Trial balance per year end, which is what an accountant asks for first when you move.
- Accounts receivable and payable detail as at the switchover date, since those become your opening balances.
- Transaction lists by customer and by vendor, the history you will miss most once it is gone.
Set every report's date range manually. Leaving it on a preset such as This Fiscal Year quietly exports a fraction of what you meant to keep.
What the exported files are like to work with
Report exports are built for reading, not importing. Expect a title row, a blank row, merged header cells, subtotals mixed in with data rows, and an account name sitting on its own line above the transactions that belong to it rather than in a column on each row.
Cleaning that into a flat table is the real work of a migration. Delete the decorative rows, unmerge, fill the account name down into a proper column, and check that the date column holds dates rather than text that looks like dates. Do it once per year of data rather than in one enormous file.
Where the data can go next
Checked against each vendor's own documentation on 12 September 2026. All of it varies by country and product tier, so confirm with the destination first.
- QuickBooks Online imports lists and transactions from CSV and spreadsheets, and its bank upload accepts QBO, QFX, CSV and OFX. It does not read IIF.
- Xero imports bank statements as CSV, and has its own help articles for QIF and for OFX style files. Contacts and opening balances come in separately.
- GnuCash reads OFX and QFX through one menu item, and its CSV importer has a date format selector that its manual warns does not follow your locale by default.
- A spreadsheet, which is underrated. If the business is closing rather than moving, a folder of clean per-year xlsx files beats a company file no current software opens.
One decision to make deliberately: migrating history, or starting fresh with opening balances. Migrating years of detail is expensive in time and usually a specialist job. Starting fresh at a clean date and keeping the old data as exported files is cheaper and loses nothing, as long as the exports are complete. Which is right depends on your books and on advice I am not qualified to give.
If the subscription has already lapsed
You have more room than it feels like, for a year.
View-only mode still runs reports, and reports still export, so most of the list above is still open to you: open each report, set the range, export to Excel or CSV. What you cannot do is create or edit transactions, reach third-party apps, or open attachments. If receipts were stored in QuickBooks, copy the attachments folder from beside the company file at the operating system level, since that does not depend on the program.
If the year has passed, Intuit's stated position is that you renew to see your data. Renewing for one billing period, exporting properly, then cancelling is a legitimate and common plan.
Two routes worth checking before you pay. An old perpetual licence from before the Plus subscriptions generally still opens a file, with services and support gone. And an accountant holding an accountant's copy or an old backup may already have what you are trying to reach.
Keep the backup even though nothing else reads it
A .qbb backup only opens in QuickBooks, which makes it feel worthless the moment you leave. Keep it anyway, in two places, with the version number in the filename.
Exports lose things: links between an invoice and the payment that settled it, memorised transactions, custom fields, audit history. If a question comes up in three years that the exports cannot answer, a backup plus one month of a subscription is a route back. Without it there is none.
If you end up holding a transaction IIF from a payroll provider or an add-on, this reads it by its header line rather than by fixed column positions and gives you a CSV and a typed xlsx, with the date reading shown in the free preview.
Open IIF to CSV →