Learn how to import your QuickBooks Desktop company file to QuickBooks Online.
No need to start over again—just move your desktop file to a QuickBooks Online company. Check out all the benefits you get when you move to QuickBooks Online.
If you're an accountant, learn how to set up your clients for success with their move to QuickBooks Online.
Watch or follow the steps to get it done:
To watch more how-to videos, visit our video section.
Find out how to move your QuickBooks for Mac file to QuickBooks Online.
Step 1: Get your desktop file ready
Note: You have 60 days from the time you create your QuickBooks Online account to move your data. If you’re not sure how old your company is, sign in to QuickBooks Online. Then, refresh this page for personalized info.
Important: Make sure QuickBooks is up-to-date
|
- Make sure your company file isn’t too big to export.
- Learn what does and doesn’t move to QuickBooks online.
- Make sure QuickBooks is up-to-date.
- To make sure your Total Targets is less than 750,000, press Ctrl + 1 on your keyboard.
Note: If the file exceeds the target limit (750,000) it can't be converted to QuickBooks Online. The only option is, you can only import lists and balances into QuickBooks Online or start fresh.
- Print a copy of your Sales Tax Liability report. You'll need it to enter adjustment entries after your move.
- Go to the Reports menu, then select Vendors & Payables. Select Sales Tax Liability.
- From the Dates▼ dropdown, select All.
- At the top, from the Print▼ dropdown, select Save as PDF.
- Choose the folder you want to save it in, name the file, and select Save.
Step 2: Move your QuickBooks Desktop file to QuickBooks Online
Note: If you're QuickBooks version is 2018 or older, you can the move your data to QuickBooks Online with an online tool.
QuickBooks Desktop Pro or Premier
- Sign in as an admin to the company file you need to import.
- Go to Company, then select Export Company File to QuickBooks Online.
- Select Start your export.
- Sign in as an admin to your QuickBooks Online company.
- Select Choose online company, and choose the QuickBooks Online company you want to replace with your company file.
- Select Continue.
- If you track inventory in QuickBooks Desktop:
- Select Yes to bring them over, then enter the as of date.
Note: Use the first day after your last tax filing period as your inventory start date.
- Select No if you want to set up new items later in QuickBooks Online.
- Select Yes to bring them over, then enter the as of date.
- Enter Agree in the text field, then select Replace.
- Select Yes, go ahead and replace the data, then select Replace.
QuickBooks Desktop Enterprise
Note: If you use advanced features (such as advanced reporting and advanced inventory), we recommend starting fresh because some of your data won't move to QuickBooks Online. If you want to keep using these features in Enterprise, learn about cloud-enabled QuickBooks Desktop Enterprise.
- Sign in as an admin to the desktop company file you want to move.
- On your keyboard, press Ctrl + 1 to open the Product Information window.
- Press Ctrl + B + Q, then select OK to display the export window.
- On the export window, select Get started.
- Sign in as an admin to your QuickBooks Online company.
- Select Choose online company, then select the QuickBooks Online company you want to replace with your company file.
- Select Continue.
- If you track inventory in QuickBooks Desktop:
- Select Yes to bring them over, then specify the as of date.
Note: Use the first day after your last tax filing period as your inventory start date.
- Select No if you want to set up new items later in QuickBooks Online.
- Select Yes to bring them over, then specify the as of date.
- Enter “Agree” in the text field, then select Replace.
- Select Yes, go ahead and replace the data, then select Replace.
Step 3: Get ready to use QuickBooks Online
Check out What to do after converting from QuickBooks Desktop for Windows or Mac to QuickBooks Online.
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.
- If you use payroll, check out this guide to set up and run your payroll in QuickBooks Online. Note: To view the guide, you'll need to sign in to QuickBooks Online.
You can also watch this webinar:
To watch more how-to videos, visit our video section.
- Connect your bank or credit card account.
- Create and send invoices to your customer.
- Track your bills and learn how to pay them in QuickBooks.
For more resources, check out our Getting Started guide.