Top Tips for Switching from QuickBooks Desktop to QuickBooks Online

Thousands of small-business owners rely on Intuit’s QuickBooks desktop software to track sales and expenses, create invoices, send purchase orders, and get organized at tax time. Many also want the flexibility of accessing their information anywhere and anytime — hence the appeal of QuickBooks Online.

Questions about how to transfer data from QuickBooks to QuickBooks Online are among the most frequently asked by customers who call the free QuickBooks help line in Tucson, Ariz. Curious how sales and support consultants answer these queries? The Intuit Small Business Blog asked Dustin Bowers and Marie Francis-Moullier, who each field up to 30 calls a day, to share their top tips for switching from QuickBooks to QuickBooks Online.

How to Migrate Data
“Sometimes migrating all your information from desktop to online can seem intimidating,” Bowers says. “To keep it simple, I like to break it up into three manageable steps. You have the option of transferring All Data or just your Lists.”

  1. Create a copy of the data you want to transfer to QuickBooks Online by clicking on File > Utilities > Copy Company File for QuickBooks Online and then Save that to your Desktop. Be sure to give the file a name that you can recognize easily.
  2. Login to QuickBooks Online using Internet Explorer and go to the Company Tab > More > Import QuickBooks Desktop Data. Follow the easy instructions that appear onscreen.
  3. Click the Browse button and choose the file that you saved to your desktop. You will receive an email when the data is ready to view. (This usually takes an hour or two.)

Francis-Moullier, who works with Bowers covering the QuickBooks Online social media channel, offers some additional advice.

Know What Transfers
Customers may import lists, all posting accounting transactions, and the chart of accounts, as well as invoices, payments, checks, credit card transactions, and bills to a new QuickBooks Online account. However, non-posting transactions, such as estimates and purchase orders, do not transfer.

If they need that data, they should be converted to posting transactions before migrating, or you can manually re-enter them into QuickBooks Online. Similarly, any customized form templates will need to be set up again online. Learn more about importing here.

Use Internet Explorer
For the transfer to succeed, customers must use version 7 or 8 of the Internet Explorer browser (if you’re using IE9, read this) when you upload your data. (In tech speak, this is because an ActiveX control required for the transfer only works in IE.)

“For QuickBooks for Mac users, this can be a pain point,” says Francis-Moullier. “If a customer can’t get access to a Windows PC, even temporarily, there are some workarounds that our support team may be able to provide to them which they can use to convert their file to the correct format for upload.”

Know Your Limit
Customers who want to transfer all of their information, including transactions, should note that the file created for uploading has some size restrictions. If it’s over that limit, you may only import your lists (customer list, vendor list, chart of accounts, etc.) and not your transactions. It’s not common, but if you are over your limit, Intuit can send instructions on how to shrink your files, or its full-service import team can assist.

Payroll Pain Points
“Questions about payroll are tricky because the boundaries between QBO issues and payroll issues are not always clear,” says Francis-Moullier. “We have a lot of success with conference calls between our support department and payroll support, which also provides phone and chat assistance.”

“For more complicated issues we have agents who are cross-trained to support QBO and payroll,” she adds, noting how satisfying it is to help small-business owners get back to work. “It’s personally meaningful to me, because my mother has been a small-business owner for 25 years, and I’ve seen firsthand the way that time is such a valuable resource to her. That’s why it’s great to be part of a team where everyone is focused on solving customers’ problems.”

For more information, call 1-800-286-6800, or visit these sites:
QuickBooks Online Support
Intuit Community
Intuit Online Payroll

About Kristin Ewald

Kristin Ewald, a former Time Inc. editor based in California, has written frequently for the SMB audience. She is also a small business owner who helps companies write and produce user-friendly websites.
This entry was posted in Intuit Products, Money and tagged , . Bookmark the permalink.
Post comment as twitter logo facebook logo
Sort: Newest | Oldest

further to MontanaKarl's post - we have a desktop version of QB and would like to move to Online - can Intuit tell us why the UK version won't support a desktop data import?  Surely not having this option pretty much makes QBO pointless?  I note you have kept MontanaKarl waiting for a month without any answer - I hope you an answer this one (and cover his too!).

 

I will keep my fingers crossed to see if there is any response - otherwise I think we will have to try another solution and move away from Intuit products.  Such a shame.

Pretty confusing...

I just signed up for a 30 day demo of the UK edition because my company needs multicurrency support, and the US edition of QBO does not support multiple currencies...

BUT...the UK QBO does not offer the "Import QB Desktop data" option - only the option to import lists in Excel format.  Why can't there be one global edition with both features - multicurrency AND desktop data import?

 

Second - the article says that there is a size limit on the file and if it is too large, only lists get imported.  What is this size limit?  Not having all data is not an option.

nsparks 5 pts

Please disregard my question. I don't have a pc or access to one and am not going to buy a copy of windows just to convert my data.  If intuit wanted mac users to convert to online then they would make it easier. I tried to sign up for their mobile credit card system last month and was promised multiple call backs, none of which ever happened.  POOR CUSTOMER SERVICE!

nsparks 5 pts

the mac version doesn't have a save a copy for quick books online

what do you do to create the file to upload

 

Sajid_Qureshi 5 pts

Hi,

I cannot see any option in Company->More as "Import QuickBooks Desktop Data". There is simply Import Data and Export Data. Can I only import Lists or company file also from Quickbooks desktop to Quickbooks online?

 

Regards,

 

Sajid

Hi - Is there a way to import data from 2 QB Desktop databases (on two different computers) to QB Online Plus? I've already imported data from one computer, but when I tried to import the other database it said it would replace the data already imported.

 

Any suggestions would be helpful.

 

Thank you.

Cayenne 5 pts

Dear Amy,

When switching from quickbooks desktop to quickbooks online, should you reconcile the desktop version first?

Cayenne 5 pts

When switching from quickbooks desktop to quickbooks online, should you reconcile the desktop version first?

I need to transfer quickbooks file from one vpn to another vpn.  How do I do this?

shafichithari 5 pts

Dear Amy

would you please answer my doubts.

1. How can I backup in desktop

2. How can I migrate Data from QBO to QB Desktop

3. Is there any possibilities to Data Synchronisation

Thanking you

Is there a way to keep QB desktop and have it sync with QBO?

Amy Kalm 5 pts

Hi Mark. When you convert a file from QB desktop to QBO it becomes completely cloud based. This changes the database structure so significantly that you would not be able to sync the two. Make sure if you're considering this, that you understand what you have with the desktop version that is critical to your business so you can evaluate whether or not QBO can meet those needs in the same way.

 

I hope this helps but please follow up if you have other questions!

Rheymann 5 pts

If my boss has Quickbooks for Mac and I have PC. Can we use QBO?

Amy Kalm 5 pts

 Rheymann Hi Rheymann! Because QBO is browser based and not OS based, you could use it on either a Mac or a PC. If the file is on QuickBooks for Mac, the file would need to be converted to the Online version. I hope this answers your question!

IramAtIntuit 5 pts

Great Info on Switching from QB to QBO

aniruddhpal 5 pts

Cost per Company ???????????????????????

Amy Kalm 5 pts

Here is a link to the different options and pricing. http://quickbooksonline.intuit.com/

I hope this helps! aniruddhpal