cancel
Showing results for 
Search instead for 
Did you mean: 
ReymondO
QuickBooks Team

Export Quickbooks Online to Desktop

Thank you for joining in the thread, @point506.

We're unable to suggest a specific app to export the TXF files directly from QuickBooks to TurboTax. I'd recommend searching for it on the internet or seek out your accountant for suggestions. This way, we can ensure that the app is integrated with QuickBooks. 

 

Once you're able to find the app, you can search for it in the Apps center and check if it was integrated with the product. Here's how:

 

  1. From the left menu, select Apps.
  2. Go to the Find apps tab.
  3. Enter the app name in the search bar or select the Browse category ▼ drop-down menu to check out different apps.

 

To get more details on what data you can export from QuickBooks Online (QBO), please check out this article: How to Export Data out of QBO.

 

Let me know if you need further assistance with this. I'm always around to provide answers and clarifications to your questions. Have a great day ahead and take care.

Fiat Lux - ASIA
Level 15

Export Quickbooks Online to Desktop

@point506 

Check your PM.

 

Hope it helps.

Teffan
Level 1

Export Quickbooks Online to Desktop

Quickbooks has removed the option to export data from Quickbooks online to a backup copy to import into Quickbooks Desktop. They suggested you upgrade to Online Advanced for $150 per month which has a backup feature option

Fiat Lux - ASIA
Level 15

Export Quickbooks Online to Desktop

@Teffan 

You can still convert data from QBO US to QBD US.

https://quickbooks.intuit.com/learn-support/en-us/import-or-export-data-files/export-and-convert-you...

 

If you are using QBO Plus or a lower plan, utilize a 3rd party backup restore app

https://rewindio.grsm.io/quickbooks

 

eyang1
Level 2

Export Quickbooks Online to Desktop

QBO stops providing export data service for QBO to QBDT conversion purpose. Need to use 3rd party app to export/import data from QBO to QBDT. 

 

For QBO backup, you can either upgrade to QBO advance for the backup function or use 3rd party app, such Rewind, but again those backup are stored in cloud not in your local drive. 

 

Hope this helps. 

 

 

eyang1
Level 2

Export Quickbooks Online to Desktop

FYI, QBO does not support the export data to convert data from QBO to QBDT anymore. This is confirmed by QBO customer service rep. The article is useless. 

AB-68
Level 1

Export Quickbooks Online to Desktop

QB desktop for mac says it cannot allow the import because my GL account types do not match.  I have literally been on the phone with payroll core and QB desktop for 4 1/2 hours.  Everyone transfers to the other.  Never had a problem with the old payroll.

Mich_S
QuickBooks Team

Export Quickbooks Online to Desktop

I'll help you get back to business, @AB-68.

 

Let's make sure the accounts or fields are mapped correctly. You can make changes if need be. This way, you can import the transactions seamlessly.

 

Let me show you how:

  1. Go to the File menu. Choose Import, then choose Items.
  2. Select the item ty[pe you want to copy.
  3. Open the item spreadsheet and compare the columns with columns in the QuickBooks spreadsheet.
  4. Make changes, if applicable.
  5. In QuickBooks, set up Income Accounts. If you'll be tracking inventory in QuickBooks, set up COGS Accounts and Asset Accounts too.

Check out the remaining steps to completely import data: Import data into QuickBooks for Mac.

 

You're always welcome to post in the Community. Take care!

JackD1
Level 1

Export Quickbooks Online to Desktop

I've been using Intuit Online Payroll (IOP) for years along with QBDT.  I created paychecks and tax payments and was prompted to create an export file.  Which was easily imported to QBDT.  Now IOP has been moved to QBO.  I recently created  paychecks and was prompted to export the transactions.  Worked fine.  This was just about two weeks ago.  Today, I created tax payments and there are no options to export.  I went through FIVE chats and FOUR phone calls only to be shuffled around.  Help??

Kristine Mae
Moderator

Export Quickbooks Online to Desktop

Let me provide the information regarding exporting of paychecks, JackD1.

 

If you're using the Standalone Payroll Product, you can export payroll transactions to QuickBooks Desktop. Once you're subscribed to one, you'll have to set up the export preferences first. Then, you can export the payroll transactions or paychecks. You can check this article to guide you better: Export into QuickBooks Online or Desktop from Core, Premium, or Elite Standalone Payroll.

 

However, if you're using the QuickBooks Online Enhanced Payroll or Core, you're unable to export the paychecks alone. You'll have to export the whole data to QuickBooks Desktop. 

 

If you have more questions, don't hesitate to get in touch with us. We're right here to help you. Keep safe!

socius
Level 1

Export Quickbooks Online to Desktop

Where do we find the download migration tool?  the link doesnt work.

 

And in the Export Overview, it doesnt show anything.

 

All i see is "You can also export reports to Excel to get data out of QuickBooks Online EasyStart"

 

 

ShiellaGraceA
QuickBooks Team

Export Quickbooks Online to Desktop

Thanks for joining us here, @socius.

 

I'll share the steps on how you can export your QuickBooks Online data to QuickBooks Desktop. The migration process will take effect when you replace the URL of the browser with exportqbodatatoqbdt. In order to download the tool make sure you're using the supported browser. Please note that Internet Explorer and older versions of Safari are no longer supported.

 

 

Let me guide you how.

 

  1. Sign in to the QuickBooks Online account you want to convert using a supported web browser.  
  2. Highlight the URL and replace anything after /app/ with exportqbodatatoqbdt.  The URL should say https://cxx.qbo.intuit.com/app/exportqbodatatoqbdtXX  in the URL is a number, (don't edit the number), and select Enter on your keyboard.  Other support task links won't work during this process.
  3. You'll see an Export Overview Window.  Read the Export Overview. You can print it if you'd like. Tap Get Started.
  4. Tap the Download tool to download the QuickBooks Desktop migration tool.
  5. Once you download the tool, launch the tool to install it and select Next.
  6. Accept the terms in the license agreement and then Next,
  7. Choose Complete as the type of setup,  select Next and then Install.
  8. Click Finish

 

Details on the process are found in this guide: Export and convert your QuickBooks Online data to QuickBooks Desktop.

 

Also, check out this article to learn about: Limitations when you convert from QuickBooks Online to QuickBooks Desktop.

 

Drop your reply anytime below if you have other questions or concerns with the migration process. I'm always here to help. Have a good one.

Fiat Lux - ASIA
Level 15

Export Quickbooks Online to Desktop

@socius 

Are you using QBO CA version (i.e EasyStart)? The tool only converts data from QBO US version to QBD US version. You will need extra effort or cost to migrate data from QBO CA version or other regions.

Sherall0
Level 2

Export Quickbooks Online to Desktop

I have run the quickbooks export and used the migration tool.  It all went along smoothly and I opened the account in QB desktop - however, when comparing - P&L reports they do not match at all - also looked at chart of accounts and they don't match up either.  Something is woefully off about this import.

Candice C
QuickBooks Team

Export Quickbooks Online to Desktop

Hey there, @Sherall0

 

Thanks for giving the Community details on importing your data. Allow me to point you in the right direction. 

 

Since the your reports are not matching up, I recommend contacting our Customer Support Team to see why this is happening. Here's how in your QuickBooks Online (QBO) account: 

 

  1. Go to the Help icon in the top right-hand corner. 
  2. Press the Contact Us button. 
  3. Give a brief description of the problem and tap Let's talk
  4. Scroll down and select to Get a callback

 

Let me know how the phone call goes. I want to ensure that you're able to get back to your business. Bye for now! 

RB2021now
Level 1

Export Quickbooks Online to Desktop

Where is this migration tool? It is no where to be found. I need to transfer from Quickbooks Online to Desktop Pro Plus.

ZackE
Moderator

Export Quickbooks Online to Desktop

Hi there, RB2021now. Thanks for reaching out to the Community.

 

You'll be able to download a copy of our QuickBooks Desktop migration tool after signing in to QuickBooks Online with a supported web browser, highlighting the URL in your address bar, and replacing anything after "/app/" with "exportqbodatatoqbdt".

 

The URL should look like this: https://cxx.qbo.intuit.com/app/exportqbodatatoqbdt

 

Once you search for that web address, you'll see an Export Overview window. From here, click Get Started, then select Download tool. Afterwards, it will begin downloading. When it finishes, run it to install it on your computer. Be sure to accept our license agreement and choose Complete as its type of setup.

 

You'll be able to find the steps for using your utility in our Export and convert your QuickBooks Online data to QuickBooks Desktop article.

 

Please feel welcome to send a reply if there's any questions. Have a wonderful day!

socius
Level 1

Export Quickbooks Online to Desktop

Thank you, yes QBO Ca.  so thats why its not working.

 

thats very unfortunate.

 

lisa009
Level 1

Export Quickbooks Online to Desktop

If I download a clients information to the desktop version (From online), this process will not damage their online file? Having a hard time making sense of some of their entires, and I am better versed with desktop quickbooks.

 

thanks Lisa

MJoy_D
Moderator

Export Quickbooks Online to Desktop

I can share with you some details on what happens when you download or convert customer data in QuickBooks Desktop (QBDT), Lisa.

 

It will not damage your customer's online files if you convert their data to QBDT. However, there are certain exceptions. 

 

Take a look at the following items:

 

  • The length of display names is restricted to 31 characters.
  • Both the full name and the company name are limited to 41 characters.
  • Each line of the Billing and Shipping Address is restricted to 41 characters.
  • The length of an e-mail address is limited to 81 characters.
  • Customers who have been deleted are changed to inactive customers.
  • Default terms for sub-customers are adjusted to reflect the default terms for their parents.
  • Due to PCI compliance, customer credit card information does not export.
  • Customer notespreferred delivery methodmobile numberpager number, and is taxable status are not exported.

 

Refer to this article for further information on how your data converts from QBO to QBDT, aside from your clients' information: Limitations when you convert from QuickBooks Online to QuickBooks Desktop

 

To ensure your books match and the information is exported correctly, I suggest running the Profit and Loss report in QuickBooks Online. Then, compare it to the same report in QBDT on accrual basis. For more information, see Step 5 in this article: Export and convert your QuickBooks Online data to QuickBooks Desktop.

 

Post a reply below if you have any further queries regarding downloading your clients' information or anything else. I'm always willing to assist. Have a fantastic day!

Rtw6676
Level 1

Export Quickbooks Online to Desktop

I am having this same problem right now and am very unhappy. I was told I could export to desktop because online has too many flukes. I have now been holding checks for weeks because the online version has so many issues and this is horrible for my business. I am also paying for desktop and online and an IT company to try to fix this

I have used desktop for years and this is truly a nightmare. No one can seem to help

SOMEONE PLEASE HELP ME!!!

Rose-A
Moderator

Export Quickbooks Online to Desktop

I appreciate you joining in this thread, Rtw6676 . I'm here to help and ensure that your questions are addressed accordingly.


For me to be able to provide you with the right issue resolution, could you please tell me what help do you need with your checks?

 

Any information that will elaborate on the problem will help me sort things out.

 

In the meantime, you might want to visit the links below. These will help guide you in managing your checks in both QuickBooks Desktop and the online version:

 

Create, modify, and print checks.

Create and record checks in QuickBooks Online.

 

I hope you can respond to me on this thread so we can work with your concern together. Please know I'm ready to assist further. Have a good one.

Rtw6676
Level 1

Export Quickbooks Online to Desktop

I have given up on Quickbooks online. I need someone to explain to me why no one can seem to help export the data to desktop. I would like to know how to get in touch with someone who can help. I'm paying for both versions. Paying IT company to try to fix the issue and I am 8 months pregnant so I need resolution 

The file continually gets stuck at 74%. The issues with online are too numerous to have to figure out work around solutions 

Adrian_A
Moderator

Export Quickbooks Online to Desktop

It isn't the kind of experience that we want you to come across, Rtw6676.

 

For us to verify why the system get stuck when exporting data, I'd recommend reaching out to our Phone Support team.

 

You can contact them through this link: QuickBooks Online Support.

 

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

 

I'll be around if ever help is needed. Keep safe!

Fiat Lux - ASIA
Level 15

Export Quickbooks Online to Desktop

@Rtw6676  

Do you need to convert data from QB Online US version to QB Desktop US version? You may have 3 ways:

1. The converter tool

2. A 3rd party migration tool (i.e TPExporter for Online, TPmporter for Desktop)

https://transactionpro.grsm.io/qbo

3. A 3rd party migration service.

 

 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us