How Do I Export To QuickBooks Online?

Exporting moves your company’s financial data from a locally installed QuickBooks Desktop file into a cloud-based QuickBooks Online company.

Think of it like moving your entire accounting system to a new, online home. You're transferring lists, transactions, and settings from Desktop into either a fresh Online company or an existing one. The built-in export tool handles most of the heavy lifting, but inventory items, payroll settings, and multi-user permissions need special attention—otherwise you might end up with orphaned records or wonky inventory quantities.

Intuit ended online banking feeds for QuickBooks Desktop 2018 and earlier, so migrating to Online is the only way to restore automated bank connections as of 2026.

Here’s the harsh truth: if you're still clinging to QuickBooks Desktop 2018 or older, Intuit cut off online banking feeds back in 2021. Come 2026, those feeds will be dead in the water unless you migrate to QuickBooks Online. Honestly, this is the best way to future-proof your bookkeeping and keep those automatic bank downloads alive.

The simplest way is to log in as an admin to both Desktop and Online, then choose Company → Export Company File to QuickBooks Online → Start your export.

If you're using a supported version of QuickBooks Desktop, the built-in export tool is your quickest ticket to the cloud. The system walks you through each step. Now, if you're tracking inventory, don’t even think about closing either program until the progress bar hits 100% and you see that confirmation dialog. Walk away early, and you risk losing data or corrupting your inventory records.

You must be signed in as the Admin user and create a backup before starting the export.

First things first: make sure you're logged in as the Admin user. Then, before you do anything else, create a full backup by going to File → Back Up Company → Create Local Backup and save that .QBB file somewhere safe—like an external drive or cloud storage. Also run File → Utilities → Verify Data to check for errors. Keep running it until you see "OK." No shortcuts here—skipping this step is like playing Russian roulette with your data.

Yes — update QuickBooks Desktop to version 2026.1.4 or later before exporting.

Before you even think about exporting, update QuickBooks Desktop to version 2026.1.4 or later. Go to Help → Update QuickBooks Desktop and install every available update. Once it’s done, restart the program and log back in as Admin. Running the latest version isn’t just about new features—it ensures the export process doesn’t throw a fit halfway through.

Start the export by choosing Company → Export Company File to QuickBooks Online, then click Start your export and enter your QuickBooks Online admin credentials.

Ready to make the jump? In QuickBooks Desktop, go to Company → Export Company File to QuickBooks Online. Click Start your export and enter your QuickBooks Online admin email and password when prompted. If you're using inventory, don’t close either program until the progress bar hits 100% and you see the confirmation dialog. Walk away too soon, and you’ll regret it.

After the export finishes, sign in to QuickBooks Online as the same Admin, check your subscription tier, and verify your data by running Reports → Transaction List by Date.

Once the export finishes, log in to QuickBooks Online using the same Admin account you used for the export. Head to Settings ⚙ → Account and Settings → Billing & Subscription to confirm your subscription tier can handle the data volume you just moved. Finally, run Reports → Transaction List by Date for the most recent month and compare the row counts against your Desktop file. If the numbers don’t match, something went wrong.

First try the export again; if it still fails, manually export lists as CSV or use IIF imports for transactions.

Don’t panic if the export fails the first time. Try running it again—sometimes a temporary glitch is all it takes. If that doesn’t work, you’ve got backup options. For non-inventory lists, you can manually export them as CSV files from Desktop’s Reports → List → Item List (or Customer List), then import them in Online via Settings ⚙ → Import Data → Products and Services. It’s not as smooth as the built-in export, but it gets the job done.

Use the IIF import method: in Desktop go to File → Utilities → Export → IIF Files, then in Online go to Settings ⚙ → Import Data → From QuickBooks Desktop (IIF).

If the standard export tool throws a tantrum, fall back to the IIF import method. In Desktop, go to File → Utilities → Export → IIF Files and select your transaction type (like Journal Entries). Then, in Online, log in as Admin and go to Settings ⚙ → Import Data → From QuickBooks Desktop (IIF) to upload your .IIF file. It’s a bit more hands-on, but it’s reliable when the automated export fails.

Create a new QuickBooks Online company with the same name, then contact Intuit Support to request a data restoration from your .QBB backup.

This method works best when you need to restore a complete backup. First, create a new QuickBooks Online company with the same name as your Desktop file. Then contact Intuit QuickBooks Support and request a "data restoration" from your .QBB backup—don’t forget to include your subscription ID. It’s a bit of a hassle, but it’s the surest way to recover everything if the export goes sideways.

Back up before every export using File → Back Up Company → Create Local Backup with Complete verification, and store three copies on separate media.

Never skip the backup step. Before every export, back up your company file using File → Back Up Company → Create Local Backup with "Complete verification" enabled. Store three copies on separate media—like an external drive, a cloud backup, and a USB stick. That way, if one backup fails, you’ve always got a fallback. Once a quarter, run a dry test by exporting a copy of your Desktop company file to confirm your lists and balances match.

Keep QuickBooks Desktop updated to version 2025 or 2026, set automatic updates, and reconcile all accounts before migrating.

Keep your Desktop version current! QuickBooks Desktop 2025 and 2026 get security patches through December 2026, so set up automatic updates via Help → Update QuickBooks Desktop → Options → Yes, automatically download updates. Also, make it a habit to reconcile before migrating—run Reports → Accountant Reports → Trial Balance and reconcile all bank and credit-card accounts to the last cleared statement. Skipping this step is like driving with your eyes closed.

The most common mistake is closing QuickBooks Desktop or Online too early during the export process, especially when tracking inventory.

By far, the biggest mistake people make is closing QuickBooks Desktop or Online too early during the export process. If you're tracking inventory, you absolutely must leave both programs open until the progress bar hits 100% and you see the confirmation dialog. Close them too soon, and you risk corrupting your inventory data or losing transactions entirely. Don’t rush it—patience pays off here.

After migrating, check your subscription tier, run Transaction List by Date, and verify that bank feeds have reconnected.

After migrating, don’t just assume everything worked perfectly. Double-check your subscription tier in Settings ⚙ → Account and Settings → Billing & Subscription to ensure it matches your data volume. Then run key reports like Transaction List by Date and compare them to your Desktop reports. Also, verify that your bank feeds reconnected properly in Online. If they haven’t, you’ll need to relink them manually.

Manually recreate payroll items in Online and check Lists → Payroll Item List; for historical data, use IIF import or contact support.

Payroll exports can be messy because they involve both lists and historical data. If your payroll items didn’t transfer properly, you might need to manually recreate them in Online. Check your Lists → Payroll Item List in Desktop against what appears in Online. For historical payroll data, you may need to use the IIF import method or contact support for help with complex payroll migrations. Honestly, this is the most frustrating part of the process, so be prepared for some extra work.

Intuit QuickBooks Support

QuickBooks Online Help Center

QuickBooks Desktop Support

How do I export my company file to QuickBooks Online?

1. First, log out of your QuickBooks Online account.
2. Then open QuickBooks Desktop.
3. Go to the Help menu and select QuickBooks Update to ensure you're on the latest version.
4. After the update finishes, click the Company menu and choose Export Company File to QuickBooks Online.
5. Finally, click Start your export and follow the prompts.

Can you export QuickBooks Online data?

That said, here’s how it works: QuickBooks Online lets you export data directly to Excel, which is handy if you need to move information between QBO accounts or just want a backup. You can export client details, shared documents, team member data, projects, and tasks from Your Practice, or pull data from Your Books. It’s not as seamless as the Desktop export tool, but it gets the job done.

What are the 3 primary ways to migrate client data to QuickBooks Online?

1. Use the Import Data tool in QuickBooks Online to bring in lists and transactions from a supported file format.
2. Convert data directly from an existing QuickBooks Desktop file using the built-in export tool.
3. Enter data manually into QuickBooks Online forms and registers if you only have a small amount of data to move.

How do I import data into QuickBooks Online?

1. Sign in to QuickBooks Online as an admin.
2. Select Settings ⚙ in the top-right corner.
3. Choose Import Data from the menu.
4. Select the type of data you want to import, like Products and Services.
5. Click Browse to upload the file from your computer, or connect to Google Sheets by selecting Connect and signing in.
6. Follow the prompts to map your data fields.
7. Once mapping is complete, select Next to finalize the import.

Is QuickBooks phasing out desktop?

Starting June 1, 2021, Intuit stopped providing access to add-on services for Windows versions of QuickBooks Desktop 2018 and earlier. While the desktop software itself still works, you won’t get updates, security patches, or support. If you’re running an older version, it’s time to consider migrating to QuickBooks Online or upgrading to a newer desktop version.

What are 3 of the steps that should be taken before converting a QuickBooks Desktop company file to QuickBooks Online?

1. Back up your company file using File → Back Up Company → Create Local Backup to avoid losing data during the conversion.
2. Update QuickBooks Desktop to the latest version to ensure compatibility with the export tool.
3. Run a Trial Balance report to confirm your accounts are balanced before migrating.
4. Save a copy of your Sales Tax Liability report for reference after the migration.
5. Export key reports and lists (like customer and vendor lists) as CSV files in case you need them later.
6. Create a QuickBooks Online account and make sure it’s ready to receive your data.

Can you export raw data from QuickBooks?

If you don’t have Microsoft Excel included in your hosting package, but Excel is installed on your local computer, you can export your QuickBooks data to a CSV file. Once exported, you can open the file in Excel on your local machine and work with it there. It’s a simple way to get your data out of QuickBooks and into a format you can analyze or share.

What can I export from QuickBooks?

QuickBooks lets you export a variety of data depending on your needs. From Your Practice, you can pull client notes, shared documents, team member details, projects, and tasks. From Your Books, you can export financial data like transactions, lists, and reports. It’s a flexible way to back up or share information outside the platform.

How do I export data from QBO to QuickBooks desktop?

1. First, export your files from QuickBooks Online to QuickBooks Desktop for Windows.
2. Make sure the company file is open in QuickBooks Desktop for Windows.
3. If needed, re-sort your lists to match the order you prefer.
4. Run a Verify Data check via File → Utilities → Verify Data to catch any errors.
5. In the top menu bar, go to File → Utilities → Copy Company File for QuickBooks Desktop for Mac.
6. Save the file in your preferred location and transfer it to your Mac if needed.

Can you spot two features QuickBooks Online Advanced?

QuickBooks Online Advanced packs some serious power. It includes everything in QuickBooks Online Plus, plus extras like class tracking for better expense categorization. It also offers batch invoice import, which saves hours when you need to upload multiple invoices at once. On top of that, you get advanced reporting powered by Fathom and custom user permissions to control who sees what. Honestly, this tier is worth it if you need more control and automation.

What are 2 ways to add a customer to QuickBooks Online?

1. Go to the Sales menu and select the Customers tab.
2. Click New customer and fill in the customer details in the Customer Information window.
3. Save the entry to add the customer to your list.
4. Alternatively, import a list of customers using the Import Data tool under Settings ⚙.

How do I import data into QuickBooks desktop?

1. Sign in to your company file as the Admin user.
2. Switch to Single User mode to avoid conflicts during the import.
3. From the QuickBooks File menu, select Utilities → Import → IIF Files.
4. Locate your .IIF file and select Open.
5. A confirmation message will appear once the data is imported—click OK to finish.

How do I import Excel data into QuickBooks Online?

1. Go to the File menu and select Utilities → Import → Excel Files.
2. If the Add/Edit Multiple List Entries window pops up, click No to skip it.
3. Follow the import wizard to select the type of data you’re importing.
4. QuickBooks will open a formatted Excel spreadsheet to guide you through the process.

How do I import data into QuickBooks?

1. Log in to your new QuickBooks Online subscription as an admin.
2. Click the Gear icon in the top-right corner.
3. Choose Export data from the menu.
4. Toggle the types of data you want to export to On.
5. Click the Export to Excel button to download the file.