QuickBooks Online to Desktop: lists and balances move, transactions stay behind
Switching from QuickBooks Online to Desktop takes an Excel export and import that carries lists and open balances but leaves transaction history behind.
QuickBooks Online customers who decide to move back to QuickBooks Desktop are discovering that the switch has no single-button option. The accepted solution on this issue lays out a manual path built on Excel exports and imports, and it draws a hard line that catches many people off guard. Customer, supplier, account, and item lists make the journey, along with current open balances. Transaction history does not.
The pattern is easy to picture. A company cancels its Online subscription, opens its new Desktop file, and finds empty lists where years of customers and suppliers should be. The remedy is not a support call. It is a structured migration that the accepted answer splits into two tracks: one for lists and balances, and a separate one for products and services.
Lists and balances move, but history does not
The scope is the first thing to understand. Exporting the account, customer, and supplier lists carries over names, contact details, and each record’s current open balance in QuickBooks Online. It does not carry the invoices, bills, and payments tied to those records. Switchers who need the full transaction history have to export all of their data separately. For transactions such as invoices, estimates, and bills, the accepted answer points to apps built for that job.
The accepted route, list by list
The work starts in the report centre of QuickBooks Online. Users open the Account List, Customer Contact List, or Supplier Contact List report, then customize it before exporting. The customization step matters. Each report has a specified set of columns in a specified order, and the field mapping during import depends on that sequence.
Account lists take the account name, type, detail type, and balance, in that order. Customer and supplier lists follow longer sequences covering company, email, phone, and the full address, through to province, postal code, and country. The Canadian edition’s column names reflect that format. Once the columns are set and applied, the report is exported to Excel and saved somewhere easy to reach.
Open balances come from a second file
Contact lists alone do not show what customers and suppliers owe. A second export fills the gap. From the customer and supplier hubs in QuickBooks Online, users export a file that contains an Open Balance column, then copy that column into the spreadsheet built in the first step. A few header rows from the export are dropped before the paste. With the balances in place, the columns are mapped to the matching QuickBooks fields, and the import brings the lists into Desktop.
Products and services take a separate pass
Inventory does not ride along with the customer and supplier work. The accepted answer treats items as their own project with its own sequence. The products and services report is exported to Excel first. Businesses that use variants can add sub-items at this stage.
Two Desktop settings come next, and both have to be in place before the import will behave. Inventory preferences must be turned on, and inventory tracking accounts must be set up. Only then does the item import run. The final step is an adjustment that sets each item’s value and quantity so Desktop’s inventory figures line up with what the Online books showed.
Back up first, and mind the one-year window
Before any of this, the accepted answer presses a single precaution: back up the data. The migration touches lists that everything else depends on, and a bad import is far easier to shrug off with a backup in hand.
The timing question comes up often from switchers who have already cancelled QuickBooks Online. Cancelling does not shut the door right away. Data stays available for a year after cancellation, which the accepted answer treats as ample time to move everything a business needs.
The takeaway for switchers
Moving from QuickBooks Online to Desktop is a project, not a click. Lists, contacts, items, and open balances arrive through careful Excel work in a set column order. History needs its own export or a dedicated app. Inventory needs preferences and tracking accounts switched on before items land. And the backup comes before all of it. Switchers who follow the sequence in order end up with a Desktop file that knows who their customers are, what those customers owe, and what is on the shelf.