Export Quickbooks Online to Desktop

@JoanC 

Another reference

https://quickbooks.intuit.com/learn-support/en-us/account-management/trying-to-export-online-back-to...

Thanks so much @GlinetteC ! It works great and is a major improvement from the Internet Explorer export.

Thanks @Fiat Lux - ASIA !

What do we do if we have a Mac ? I have been on the phone with quickbooks for 12+ hours over the last two months trying to get it switched from online to desktop on my Mac and I am about to pull my hair out. The extraction tool does not work for Mac. 

Welcome to the Community, alefever35. I'd be delighted to guide you through moving your data from QuickBooks Online (QBO) to QuickBooks Desktop (QBDT) for Mac.
 

You'll initially need to convert the information from QBO to QBDT for Windows.
 

Before getting started, there's a few things you'll want to be aware of:

• A Windows computer with Internet Explorer 11 or higher will be required.
• QBDT for Windows will need to be the same version as your QBDT for Mac product, or earlier. You can refer to our Download a trial for QBDT resource to obtain a 30-day trial copy that can be used for this process.
• Your QBDT for Windows must be updated to its latest release before converting the file to QBDT for Mac.

Once you're prepared, you can begin your data migration.
 

Here's how:

1. Export your files from QBO to QBDT for Windows.
2. Make sure the company file's open in QBDT for Windows.
3. Re-sort lists if necessary.
4. Perform a Verify Data. This identifies most known issues within files and informs users if their Rebuild Data tool needs to be utilized afterwards.
5. In the top menu bar, go to File, Utilities, then Copy Company File for QuickBooks Desktop for Mac. This creates a MAC.qbb file that can be restored in QBDT for Mac.
6. Save your file in a preferred location. I'd recommend creating a backup copy as well.
7. Restore the data in QBDT for Mac.
          a. On your No Company Open window, click Browse.
          b. Locate the file you'd like to open.
          c. If your QBDT for Windows company file is stored in an external drive, it's recommended that you move it to a local area on the computer you're working with. This helps avoid data corruption.
          d. Once you see a prompt asking if you want to restore a QBDT for Windows file, hit OK.
          e. Enter an appropriate name for your restored file, then select Save.

Now your details from QBO will be imported into QBDT for Mac.

You'll additionally be able to find many useful resources about using QuickBooks in our help article archives.

I'll be here to assist if there's any questions. Have a wonderful day!

I called into quickbooks and talked to a manager and they said that the file transfer from online to desktop is no longer supported. I have already been sent these instructions that include the windows transfer in between and they did not work. Now today I have talked to 3 different people. 1 who said to include windows still, 1 who said to not include the windows step, and 1 who said it is no longer possible to do this transfer at all. I have spent over 12 hours on the phone and requested someone to login to my computers remotely and fix this but all I keep getting is how to article links that do not work. 

@alefever35 

You may need a 3rd party conversion service.

In March of 2021, I went through the headache of the export and import with all the tools. Here is the article for those steps, but it still is difficult understanding their steps: 
https://quickbooks.intuit.com/learn-support/en-us/import-or-export-data-files/export-and-convert-you...

I'm here to guide you to make this process smooth and fast, @Shawn-Urns.

The article you've shared is the perfect one to export QuickBooks Online (QBO) company file to QuickBooks Desktop (QBDT). I'd like to know where you left off so that I can guide you on the next steps. 

You can also contact our QuickBooks Care Team if you want to get live assistance about the conversion process of your company data. Here's how to contact them through the QBDT:

1. Open the QBDT program.
2. Select the Help menu and choose QuickBooks Desktop Help or press F1.
3. Click on the Contact us button at the bottom of the window.
4. Input your concern in the box such as "Convert QBO to QBDT", or "Please help me convert my data file from QBO to QBDT."
5. Click the Search button.
6. Select Start a Message.
7. Enter your Customer Account Management Portal (CAMPS) details in the pop-up window and submit. This is how it looks like:

Our Support hours during weekdays starts from 6:00 A.M. to 6:00 P.M. PT. While on Saturdays, we operate from 6:00 A.M. until 3:00 P.M. PT.

I've added this article to know more about managing your company data: Limitations when you convert from QuickBooks Online to QuickBooks Desktop.

Please know that we're here if you need help with anything else. Don't hesitate to reach out. Thanks for coming by and take care.

Well, I did the steps to export from Online to Desktop and finally got it to finalize someone okay. Now the reason we are doing this is to use Turbotax for the only reason we chose TurboTax over another tax software.  TurboTax is not accepting it still.

Reading in the forum, this is an issue and has been an issue. To keep me from wasting more time I am wanting to "return" TurboTax and move back to the software I had been using for years.

@Shawn-Urns 

Utilize the trial version of a bookkeeping app to integrate your QBO account and export the TXF file for TurboTax. You don't need to convert data to QB Desktop file.

Can you give me a link to the app you are referring to? 

check your PM. Hope it helps.

I cancelled the online subscription for one company and have a year to export to Quickbooks desktop.  I have followed the directions but it doesn't work.  Here's where I have the problem with this instruction: Highlight the URL and replace anything after /app/ with exportqbodatatoqbdt.  The URL should say https://cxx.qbo.intuit.com/app/exportqbodatatoqbdt. XX  in the URL is a number, (don't edit the number) and select Enter on your keyboard. 

There is no number in the XX part of the URL.  When I open the company, the URL is https://app.qbo.intuit.com/app/homepage.  When I first sign on, there are two companies - the one still active and the cancelled one.  The URL shows this before I pick one of the companies:  https://c28.qbo.intuit.com/c28/v1954.170/0/companysel.  Once I select either company, the URL changes to: https://app.qbo.intuit.com/app/homepage.

Thank you for reaching out to us, @CDorsey.

I'll be glad to help you with your export concern.

I would just like to know when was the online subscription for one company canceled.

When you cancel your account, you'll have read-only access to your data for a year.

If you would like to talk to someone over the phone, you can contact QuickBooks Support.

Here's how: 

1. Select Help inside QuickBooks Online.
2. Click Contact Us.
3. Provide your concern in the description field, then click Let's talk option.
4. Choose either Start an email or Get a callback. 

You can also check the limitations when you convert for more information about export.

We're always here in the Community to help if you have other questions related to QuickBooks. Stay safe!

The subscription was cancelled in February 2021.  There is supposed to be a one-year period of access to run reports and export to Quickbooks desktop.  When I contacted Intuit, they would not give me any help unless we paid hundreds of dollars for support for a period of time. 

---

@CDorsey wrote:

When I contacted Intuit, they would not give me any help unless we paid hundreds of dollars for support for a period of time. 

---

@CDorsey 

How did you contact them? Which number did you dial?

[removed]

@CDorsey 

I am not sure it was a legit support.

You're right, as I just googled that number.  I was sure I had contacted Intuit support through a legit number that I found online. 

I have communicated with QBO and QBDT for the past couple months to get ready for the migration. On Monday, I was going to do the QBO data export for the migration and following the steps in this article (Export and convert your QuickBooks Online data to ... (intuit.com)), but the URL at step 2 (to export view) stops working. Then, I have contacted several OBO CSR, and they told me they have stopped providing the data export for QBO to QBDT migration since last December. Is this true? 

Then why both QBO and QBDT instructed me to follow the steps in the article to do the migration in Feb 2021, and also spent so much time to communicate with me about my concerns about the self-migration in the past couple months and even last Friday? It is wasting both our time for nothing! It is very disappointing!  

What third party app was used for bookkeeping app to integrate your QBO account and export the TXF file for TurboTax?? thanks!

Can you tell me what app you used for conversion?