Learn how to import your QuickBooks Desktop company file to QuickBooks Online.
No need to start over again—just convert your desktop file to a QuickBooks Online company. Watch our video tutorial or follow the steps below to get it done:
Moving from QuickBooks for Mac instead? Learn how to move your QuickBooks for Mac file to QuickBooks Online.
Step 1: Get your desktop file ready
Note:
|
Step 2: Import your desktop file to QuickBooks Online
| Note: You need to use a trial version to convert your file if you’re using a version older than 2018. |
QuickBooks Desktop Pro or Premier
- Sign in as an admin to the company file you need to import.
- Go to the Company menu, then select Export Company File to QuickBooks Online.
- Select Start your export.
- Sign in as an admin to your QuickBooks Online company.
- If you track inventory in QuickBooks Desktop:
- Select Yes to bring them over, then specify the as of date.
- Select No if you want to set up new items later in QuickBooks Online.
Note: Only QuickBooks Online Plus and Advanced can track inventory. Both plans use the FIFO method. - Select the Choose online company▼ dropdown, and choose the QuickBooks Online company you want to be replaced by your company file.
- Select Continue.
- Enter “Agree” in the text field, then select Replace.
- Select Yes, go ahead and replace the data, then select Replace.
QuickBooks Desktop Enterprise
| Do you use Enterprise's advanced features?
If you use advanced features (such as advanced reporting and advanced inventory), we recommend starting fresh because some of your data won't be converted. If you want to keep using these features in Enterprise, learn about cloud-enabled QuickBooks Desktop Enterprise. Or switch to QuickBooks Online Advanced instead, which has powerful tools like smart reporting and accelerated invoicing. Deep dive into QuickBooks Online Advanced features using our test company. |
- Sign in as an admin to the company file you want to import.
- On your keyboard, press Ctrl + 1 to open the Product Information window.
- Press Ctrl + B + Q, then select OK.
- On the export window, select Start your export.
- Sign in as an admin to your QuickBooks Online company.
- If you track inventory in QuickBooks Desktop:
- Select Yes to bring them over, then specify the as of date.
- Select No if you want to set up new items later in QuickBooks Online.
Note: Only QuickBooks Online Plus and Advanced can track inventory. Both plans use the FIFO method.
- Select the Choose online company▼ dropdown, then select the QuickBooks Online company you want to be replaced by your company file.
- Select Continue.
- Enter “Agree” in the text field, then select Replace.
- Select Yes, go ahead and replace the data, then select Replace.
Did you get an error? Check out how you can fix them so you can get back to moving to QuickBooks Online.
Step 3: Make sure your books match
You can run one of your financial reports to check if your import is successful.
- Run a report, such as profit and loss, on accrual basis in QuickBooks Desktop.
- Run the same report on accrual basis in QuickBooks Online.
If your reports match, you can get started with QuickBooks Online. If your reports don’t match:
- You can check this guide again to know what happened to your data when you moved from QuickBooks Desktop to Online.
- If your reports still have issues, contact us. We can help you reach out to our Data Services team to fix report discrepancies.
What's next?
With your company all set up, let's get you started with QuickBooks Online.
- Connect your bank or credit card account.
- Create and send invoices to your customer.
Note: If you track sales tax, set up location-based sales tax in QuickBooks first. - Track your bills and learn how to pay them in QuickBooks.
For more resources, check out our Getting Started guide.