Upper Menu

Using QBO to convert QuickBooks Enterprise to Premier or Pro

Share Button

Have you been running QuickBooks Enterprise, and recently discovered that it’s overkill for your needs? If you’re only using the basic functions, you may only need QuickBooks Premier or even Pro. With the new QuickBooks Enterprise (QBES) subscription model, it may have become too expensive to just keep going that way, since it costs at least $85/month. It may be time to  convert QuickBooks Enterprise to Premier or Pro.

QBES doesn’t have any way of converting to Pro or Premier. Until now, you couldn’t downgrade.

I just learned a slick, creative way of using QuickBooks Online (QBO) as a pass-through conversion tool, that can be used in simple circumstances. It involves importing your QBES data into QBO, and then exporting it back out to a Desktop version (QBDT) of your choice.

This isn’t easy to do. If you want help, there are conversion services available who can safely do it for you. Two referrals are given at the end of this article.

Here are the instructions provided by Intuit [with commentary by Alicia in brackets] :

Importing QBES into QBO

Before you get started:

  • Your QuickBooks file must be under 350,000 targets (file size does not matter). To trim it down, see Trimming your QuickBooks Windows file for import. [If you are over 350,000, you should probably stay in Enterprise, since it’s built for large files. Condensing your QB file removes your history and can cause corruption.]
  • You will need to create a QuickBooks Online free trial account at http://qbo.intuit.com.
  • You can only import QuickBooks Desktop data within the first 60 days of your QuickBooks Online company start date. If imported, your QuickBooks Desktop file will also replace your entire QuickBooks Online file and overwrite any existing information.
  • You must be an Administrator level user on your Quickbooks Online account.
  • You must be logged in as the Admin user in your Desktop file.
  • You must use Internet Explorer in Windows. Other browsers won’t work.
  • If you receive any errors regarding the file you’re importing, see Errors Importing to QuickBooks Online
  • To understand key differences and unsupported features prior to moving, see What’s not imported when you move from desktop to online.


Important notice for Enterprise users:

Intuit does not officially support moving data from QuickBooks Enterprise to QuickBooks online and data loss may occur. 

As an Enterprise user, you have access to many advanced features not available in QuickBooks or QuickBooks online. In some cases you may have found yourself in Enterprise on accident, or only using the bare essentials, in which case moving will likely not be a problem. In all other cases however, you should strongly consider if QuickBooks online is right for your business by looking at Intuit’s import limitations above and testing out needed features first through a test drive.

[If you are running inventory, be aware that your calculations will change. QB Enterprise typically uses Average Cost to calculate COGS, while QBO changes it to FIFO (“first in, first out”). When you round trip back to Pro or Premier, you’re back to Average Cost. After your conversion, your Inventory Assets and COGS may be different than they were before. Please check with your accountant, as this might require filing a form with the IRS.]

[If you are running Intuit Payroll, you will need to set up your Payroll subscription from scratch in the new file. Call Intuit Desktop Payroll Support at (866) 223-5562 and talk to them before starting.]


When you’re ready:QuickBooks Enterprise Home Screen

  1. Subscribe to QuickBooks Online.
  2. Make a backup of your Enterprise file. Restore the backup to create a second copy, and work off of this second copy. That way, if anything goes wrong your original file is untouched.
  3. Open QuickBooks Enterprise Solutions to the Home screen.
  4. Press Ctrl+1 to open the Product Information window

QuickBooks Product Information window







  1. Sign into QuickBooks OnlineOnce opened, press Ctrl+b followed by Ctrl+q.
  2. Click OK to close the Product information window.
  3. The screen below should automatically come up. If you don’t see this screen, attempt Step 2 one more time.
  4. Enter your QuickBooks Online login info, agree to the Terms of Service, and click Submit.
  5. Pick the online company you want to import your data into.

Pick your QBO Company






  1. Note: You may only have the option to import list and balances if your company file is too large to import. If you don’t see this screen, continue to the next step below.

What would you like to import?







If QuickBooks is freezing or unresponsive during the import:

First, open Internet Explorer (Non 64-bit if you have two), then follow the guide to disable/enable the appropriate settings:

  • Press and hold ALT+T to get to the Tools Menu. From here go to Internet Options at the bottom, then go to the Security tab at the top and uncheck the Enable Protected Mode box.
  • On this same page, click on Sites and add one at a time, https://qbo.intuit.com and https://lvdc.qbo.intuit.com to the Trusted Sites, then click Close.
  • Still on the Security tab, click on the Zone with an image of a globe called Internet. Drag the slider for security level to Low or Medium. Also, uncheck Enable Protected Mode.
  • Click Apply, then OK. Now close and re-open Internet Explorer before attempting to re-do the import.


11. After following all the above steps, try the import again. During the import flow you will likely get a pop-up asking you to be redirected to qbo.intuit.com, and if you trust this site? Please click Yes to continue.

12. Click OK, Got it. Look for an email from Intuit when your data is done converting and you can log back into QBO.

13. Compare the Profit and Loss and Balance Sheet standard reports for All Dates in QBO and in QuickBooks Enterprise to ensure that your data transferred correctly.


Exporting from QBO to QBDT Premier or Pro

Once your file is up and running in QBO, use Internet Explorer to Export your QBO file into a backup for Desktop.Click on the Gear and choose Tools: Export Data.

  1. Follow the prompts to make sure ActiveX Controls are installed. Click Continue.
  2. Choose All Financial Data to convert your entire file. If you want to start fresh, choose All financial data without transactions, which will bring over balances but not the history. You can always refer to your old QBES file if needed.Export all financial data
  3. Once the file has been exported, the next step is to Convert it.
  4. Open QBDT to the screen where you pick a company to open.
  5. In QBO, click the button to Convert the file from QBO. Follow the prompts – sometimes the window appears behind other windows, so look for it!
  6. Once you’re done, don’t forget cancel your QBO trial subscription…although you may want to poke around. A lot of people love QBO more than Desktop.
  7. Once the import has finished, you will want to restore your browser to its default setting. Do this by opening up Internet Explorer and following these steps:
  • Press and hold ALT+T to get to the Tools Menu. From here go to Internet Options at the bottom, then go to the Security tab at the top.
  • Click Reset all zones to default level, then click Apply, OK, and close Internet Explorer.


Get Help

Because this technique is complex, and only to be used in very specific circumstances, I recommend you contact one of these two professionals instead of doing it yourself:


But for all of you on QuickBooks Enterprise who know you’re not using any Enterprise-specific features, and have wished there was a way to simplify, use this workaround to import your file into QuickBooks Online and then export it back out again, solving your problem.


36 Responses to Using QBO to convert QuickBooks Enterprise to Premier or Pro

  1. William "Murph" Murphy June 6, 2016 at 2:22 pm #

    People are always trying to figure-out one way, or another, how to get around limitations, or to do things the ‘cheap’ way.

    In my opinion, you are doing your readers an injustice by even printing this topic, which has been a known ‘trick’ for years. But that is just the thing….’it is a trick’, an ‘illusion’ at best.

    The vast majority of QB Enterprise files exceed the ‘targets limitation’ of converting a file to QBO, one reason they migrated to Enterprise in the first place was probably due to file, list and target size to begin with.

    In such cases, in order to migrate the file up, Intuit will tell you to ‘condense the file’, a known source of ‘permanent data corruption’. (And by definition a condensed file means you are NOT getting the same file as you had before, you will not have all your history, which is most likely one of the things you wanted to keep rather than simply starting a new Pro/Premier file.)

    Most files migrated up, especially those with Inventory will have serious ‘cost factors’ changing from Average Cost to FIFO resulting in out-of-balance situations between the desktop and online data. Then you turn around and try to download the same file from QBO back into QBDT and even if that goes perfect (which it rarely does), you will again end up with even more Inventory related cost irregularities.

    The combined results are a file that is NOT what you started with, even though it may now be in Pro/Premier.

    One factual aspect of this write-up is where it says….”Intuit does not officially support moving data from QuickBooks Enterprise to QuickBooks online and data loss may occur.”

    Why risk your data, or waste hours and hours of time, attempting to accomplish what a professional file service can do for you (with guaranteed satisfaction) for a reasonable fee normally within 1-day turnaround time.

    I’m sorry, but the old saying “you get what you pay for” applies in this case.

    • Alicia Katz Pollock June 6, 2016 at 2:29 pm #

      Hi Murph,

      Thanks so much for your comments! I have found this conversion pat useful when my client has been sold Enterprise when in fact it was overkill for their needs, and in that circumstance I still think it’s a viable option. But your Inventory consideration is a great point, and I will edit the article accordingly to address your comments. Thanks! Alicia

    • Frank Hermes October 28, 2016 at 3:21 pm #


      Gotta disagree with your position and heartily thanks Alicia for the tip on converting.

      My company used to be around 80-100 people doing $5-8M per year. Our chief vendor decided to give our territory to their proprietary, company-owned store – long story short, I decided to get rid of what I could and semi-retire. I work out of the house now and just do some services related work. I am the only employee.

      We used QB Enterprise for many years and loved it. At my latest renewal prompt from Intuit, I was told I had to go to the subscription service and it would be $1,000/yr., please, and, my Enterprise edition would stop working once I reached the renewal date! A $1000 is too much for me any more – no employees, little inventory, just invoices and accounting for the tax man.

      However, QB Online just does not do all I need just yet, so I wanted to move from Enterprise to Pro. I called support at Intuit and asked about converting the Enterprise data to work with Pro or Premier – they said it couldn’t be done.

      I searched a bit and found Alicia’s notes. Without Alicia’s tutorial, I doubt I could have figured it all out and would have had to build a new company instance and ultimately would have lost all my history if Enterprise quits working as the threatened.

      I went through the process yesterday and today, and though there were a few conversion issues, I was able to get it done and now have a working company in Pro with all my history, balances, etc.

      Alicia – thank you very much.

      Murph – poo on you.

    • Ivo Paseta June 6, 2017 at 2:41 pm #


      Totally disagree with you.

      When we first bought QB we told the rep what we needed and she “sold us” on Enterprise. No doubt a much higher commision on a $1,000 product over a $300 product

      We were forced to upgrade recently becuase the 2014 product was reaching the end of its life cycle.

      We contacted Intuit and they said for our needs Premier would work and we purchased it. Then to our surprise, we get an error that the file is not compatible.

      I appreciate when people like this article help out people in dier need because Intuit flat out said, after hours on technical support, that theres NO WAY to convert the data.

      So as been said before:

      Alicia – thank you very much.

      Murph – poo on you.

      • Alicia Katz Pollock June 13, 2017 at 8:30 am #

        Hi Ivo, I’m delighted that this worked for you, but you don’t get to poo on my Murph! He’s a wealth of knowledge and technical QuickBooks expertise. His .02 is valuable and welcome here. QB Conversions can be problematic! ~Alicia

  2. John CPA August 15, 2016 at 5:19 pm #

    Online Quickbooks (or any online Accounting software) is a joke. I have yet to see any benefits however I see numerous problems. They start with signing up. What customers fail to realize (once they grasp how nonsensical cloud computing is) is that there is a big catch 22. QBO uses enterprise and they don’t mention there is no downgrade path when you finally realize what rubbish it is. i.e you stuck with Enterprise unless you want to start a file from scratch.
    Look at it this way. Before the Cloud the single biggest show stopper was electricity. The Cloud has now introduced a second show stopper for no real benefit. A network connection. BTW with Windows 10 you can easily connect to your own server directly anywhere in the world with no need for the Cloud at all. (Could do it before then but slightly more complicated)

    • Alicia Katz Pollock August 15, 2016 at 5:30 pm #

      Hi John, while I agree that not having an internet connection is a show-stopper for using QBO, I respectfully disagree with your critique. When signing up for QBO, the website lists the three levels, comparing the features of each. When signing up, it gives you a chance to select the one that’s right for you. While you can’t downgrade with the click of a button, it takes about 20 minutes to download the QBO data and then reimport it to a more basic package. I, or another QuickBooks ProAdvisor, would be more than happy to help you or your clients with this. ~Alicia

  3. Denny Khav September 21, 2016 at 9:21 am #

    Did any of you actually get this to work? I have a client who accidentally fell for enterprise who really didn’t need it. I try to export the file out of QBO and it just says a problem occurred. I contacted support and they said they couldn’t help!

    • Alicia Katz Pollock September 27, 2016 at 11:49 am #

      Hi Denny,

      Yes, it works, but if they were using any of the Enterprise features at all, that information will be lost.


  4. MW November 8, 2016 at 2:28 pm #

    Hi Alicia,

    I cannot get it to work. Step #2a is where things go sideways. I click OK to close the Product information window per step 2b, but the screen indicated in step 3 does not appear.

    I just created the Quickbooks online account today, so I’m within the required 60 day period. Any suggestions?


    • Alicia Katz Pollock November 10, 2016 at 10:44 am #

      Hi MW,

      Look under the File menu > Utilities > Copy Company File for QuickBooks Online.

      It’s a different route to the same end, and should also work.

      If you’re stuck, give me a call and we can walk through it together – 971-235-7119.

      Alicia 🙂

  5. AJ December 6, 2016 at 10:29 am #


    I have a client who wants to move from Enterprise to Online – but they handle a ton of transactions. 2016 alone has over 900,000 targets.

    Do you know of any clients who use online that are experiencing slowness issues? My concern is that if they move to online they will have too many transactions for online to handle.


    • Alicia Katz Pollock December 6, 2016 at 11:10 am #

      Hi AJ, Your are correct. Your client is not a good fit for QBO. They have too many transactions. The recommendation is 350,000 targets maximum to be eligible. Enterprise is the best fit for sheer file size, although Premier may possibly work. ~Alicia

      • AJ December 6, 2016 at 11:25 am #

        Thanks for your quick replay Alicia. Have ever seen a situation where someone has switched to online only to find that their file size is too big? Have they experienced slowness?

        I am trying to prove to this client that moving to online is not a good fit but I am trouble finding real examples to give them.


      • Alicia Katz Pollock December 6, 2016 at 12:04 pm #

        Yes, because it’s web-based, every time they pull up a report that has a lot of transactions they will have to wait for it to generate. That includes the Customer list and the Vendor list. Even summary reports will need to be calculated each time.

        I have a retail customer with over 2000 products. One of their sales reports takes several minutes to come up on screen.

        Even deleted names and items stay in the system and are filtered out.

        Here’s an article with more information: https://community.intuit.com/articles/1145940-quickbooks-online-file-size-and-feature-limits.

        I’m a QBO evangelist, but in this case my experience says to stay with Enterprise.

  6. AJ December 6, 2016 at 12:09 pm #

    Thanks for the information Alicia, very helpful!

  7. DBZ December 6, 2016 at 3:08 pm #

    Hey Alicia,

    Thank you SO much for posting this! I, for one, found it very useful AND necessary!

    I have moved over everything to QBO and was checking to make sure that all the data is there and it looks pretty good. The only thing I noticed did NOT transfer over was my reconciliation history. Is there a way to get this data to transfer?

    • Alicia Katz Pollock December 6, 2016 at 10:52 pm #

      Hi Dafna, You can just repeat your most recent reconciliation and select the entire history. If your reconciliations were good, and you had cleaned up all the extraneous transactions, it should all square up cleanly. For example, if your last reconciliation was October 31, use that date and ending balance again, then mark all previously reconciled transactions again. The difference will be zero again.

  8. Neil B. December 24, 2016 at 5:51 pm #

    Hi Alicia,

    Thanks for posting. It is very detailed. And I really love the recommendations. What do you think about this Quickbooks Enterprise to Pro Conversion?

    Thanks in advance!

    • Chonie September 5, 2017 at 1:22 pm #

      Did you try this out Neil?

  9. C Martin January 7, 2017 at 3:35 pm #

    I can’t thank you enough for this article!! This worked PERFECTLY for three different companies and literally saved me hundreds of dollars. My companies are very small, and just like you said, enterprise was overkill. I have been running all three on Premier for 1+ month and everything is working perfectly with no data lost. Again, THANK YOU!!

  10. Chris Munger January 9, 2017 at 4:12 pm #

    Alicia, thanks a million for providing this solution that is sadly not provided by Intuit. Sad when the drive for profits means short-changing a segment of customers that would be well served by this approach.

    Although we received the email from Intuit indicating our exported file was ready to be downloaded, once we log back into QBO, we see no “To Do” list or task list from which we can access the file. Has Intuit pulled this from the QBO trial version? Or is there a semi-obvious step that I’m missing?

    Thanks again for providing this information. Very much appreciated.

    • Alicia Katz Pollock January 10, 2017 at 2:24 pm #

      Hi Chris, Simply go back into the Export Data, and follow all the prompts again as if you were starting from scratch. At some point it will indicated that an export already exists, and do you want to download it? Then you’ll pick up where you left off in the process.

  11. Leila February 21, 2017 at 8:02 pm #

    Hi Alicia. Thank you so much for posting this and helping out! It is really appreciated!

    I seem to be getting stuck at step “Step 8: Pick the online company you want to import your data into.”
    I cannot get to step 9 (“Note: You may only have the option to import list and balances if your company file is too large to import. If you don’t see this screen, continue to the next step below.”) because once I do Step 8, Quickbooks just stalls at the screen that says “Preparing… This process may take up to 30 minutes.”

    I tried disabling/enabling security settings in Internet Explorer, but that also did not help.
    When I did that, i got to step 11 (“After following all the above steps, try the import again. During the import flow you will likely get a pop-up asking you to be redirected to qbo.intuit.com, and if you trust this site? Please click Yes to continue.”), but then that same screen that says “Preparing… This process may take up to 30 minutes” just continues to show up and nothing after it.

    Any chance you have a solution?
    I have been at this for 6 hours and I’m all out of solutions and I really need for this to work.
    Thank you in advance for your help!

    • Alicia Katz Pollock February 26, 2017 at 9:43 pm #

      I can think of a few things. Your Enterprise file may be using features that aren’t in QBO, so it can’t be imported. The file may also be too large – did you follow the step to confirm the number of targets? And, it really may be taking a very long time if your file is large or complex.

  12. Jack March 24, 2017 at 12:44 pm #

    It seemed like a God’s sent gift. Went trough the process. got to upload, download convert and create the file. However when i tried to open the newly created file it say ” It can only be opened in QBEnterprise….

    Followed the instruction to a T but no cookies for me. I did it all on another computer that had installed only QB Pro 2016.

    • Alicia Katz Pollock March 25, 2017 at 9:06 am #

      Hi Jack, Something went wrong or got skipped in your process. If you would like me to give it a try, give me a call at 971-235-7119. ~Alicia

  13. Alex April 4, 2017 at 7:38 pm #


    Thanks for the post. When trying to download the file using internet explorer, my explorer keeps crashing. Do you have any tips on settings or a way around this? I didn’t have a problem with any of the stages up until now!


    • Alicia Katz Pollock May 9, 2017 at 9:30 pm #

      Alex, it’s hard to say. Completely depends on your computer setup. I assume you tried restarting your computer?

  14. Susanna April 16, 2017 at 4:32 pm #

    I thought of this process on my own, and was so proud of myself. I got it all to work, however payroll was NOT able to be started again !!!
    I was told they could push the payroll into the Premier file, but now that I did all the work, the payroll department says they can NOT push the payroll and turn the service back on. It got turned off during the conversion.

    So I am at a loss.

    So disapointed with QB’s for this. $1,000 a year MANDATORY fee is ridiculous !!!

    • Alicia Katz Pollock May 9, 2017 at 9:35 pm #

      Hi Susanna, Yes, Payroll is attached to the file itself. So because you’re creating a new file, you need to set up Payroll from scratch. It’s the same for ANY new file, not specific to Enterprise downgrades. I will amend the article to mention this.

  15. Shane May 10, 2017 at 4:23 pm #

    Not sure if this was asked. What if your enterprise license has expired so you cannot export the data? Are you able to convert the company file or backup to Pro without Enterprise?

    • Alicia Katz Pollock May 16, 2017 at 1:35 pm #

      Hi Shane, Yes, you have to have a functioning copy of Enterprise to do the export. You’ll have to find someone who has a copy. I can perform that service if needed…give me a call!

  16. Pardeep Kumar June 27, 2017 at 12:59 pm #

    . Thanks a lot for sharing with us your blog. Alicia, very helpful!

  17. Vijay Wijesundera October 24, 2017 at 2:33 pm #

    My small organization’s QB files (3837 Targets in last fiscal year; 32519 Targets in 8 years) had been converted from QB Premier to QB Enterprise by our outsourced bookkeeping contractors. They in turn have an outside IT consultant managing their servers, so it was a struggle to ask a reluctant third party to follow the conversion steps, so that we could get our files back in QBP format. One of the error messages that I got while their server computer didn’t have IE 11 (only IE 10) was that at the Export to QuickBooks Online pop-up window, it was saying “Oops! You’re not an Admin”.

    I resolved the difficulty by downloading a 30-day free trial copy of QB Enterprise v18 from https://enterprisesuite.intuit.com/campaigns/dr/qbes-trial.jsp
    to my home computer, on which I had IE v11, and running the conversion process from there. I had also subscribed to QB Online Plus a week ago in a vain attempt to import the “OE” format file that I had exported from QBE using File -> Utilities – > Copy Company File for QuickBooks Online; Intuit apparently no longer supports that path (of exporting OE format file from QBE, and later importing just that file in to QBO).

    In my case, I had to follow to the letter all the steps in Alicia’s another article
    in order to download from QBO to desktop. Also, since now I had both QBE and QBP on my desktop, I had to close QBE and manually start QBP to a blank screen before I could successfully download the correctly Converted (Premier) file back from QBO.

    I don’t think I would have been able to do this conversion without Alicia’s articles; so many thanks again!

Leave a Reply