Hi RoseMaejorieA

I exactly did what you mentioned below. The fact that the data file is on OneDrive folder, what is giving me error message which translating to Firewall and Antivirus issues. I whitelisted the directories which has the the QuickBooks executable files per instructions "Set up multi-user network". Still giving error messages. At this point, I'm basically back to square 1. Any other options, would be great!!! This has become almost like pulling rabbit out of a hat, except the rabbit isn't in the hat anymore somehow.

Thanks for keeping me updated about the steps that you've tried, @mitalivasa.

I'd like to provide some clarifications about this concern.

Once a file is stored on any cloud-based storage such as OneDrive, opening a file through a multi-user network set up isn't applicable. This happens because QuickBooks is meant to be stored locally on a server or a desktop.

To have a second person access the data file on the OneDrive folder, you can reach out to your IT expert for further assistance about doing a self-hosting. You also have the option to subscribe to the Intuit Hosting Program. This allows you to run your QuickBooks Desktop and store your data files on a service provider's servers and use it securely anytime. 

To give you more information about the hosting procedure, please see these references:

• What hosting providers are authorized by Intuit?
• Intuit Hosting Program.

This should get you going today, mitalivasa.

Fill me in if you have further questions with this matter. I'll be around to answer them. Take care! 

Could someone answer this with definitive yes or no as it is not clear through out this. As @Bookkeeper8 stated it seems like that one drive would not work if you are using QB in multi user mode and expect to have more than one QB instance running and accessing the Company file however if you are only going to have one instance of QB running at a time you can use one drive to store your company file. 

All of the discussion about the DB and not updated in a timely fashion makes sense when multiple instances of QB is connecting to the company file via one drive but it does not make sense as to why one drive wouldnt work when you only have one instance of QB accessing that file at a time.

I am a one-man operation and use QuickBooks 2018 single user on a single computer.  All I wanted out of OneDrive was backup in case of hardware crash or theft.  However, I've been having problems with QuickBooks losing months of data (it looks like I haven't entered or reconciled anything in several months), forcing me to re-enter all my work.  Additionally, I try to open the local file in My Documents folder on my C: drive but it seems like it reverts back to the back up copy on the OneDrive folder.  It's very frustrating and I'm tempted to get rid of OneDrive altogether.  Help!

Hello there, txdot002.

I’ll do my best with helping you retrieve your files.

There are a lot of possibilities why the program lost the data. It can be it was deleted or it was missing. To verify this, you can run the Audit Trail report. First, click the Reports menu. Next, select Accountant & Taxes then, Audit Trail. Then, filter the date range and other necessary details.

To retrieve the lost transactions, we can do a wildcard search. I’ll show you how:

1. Click the Start or Windows menu.
2. In the Search programs and files field, look for these files:

• *.qbw (Working Files)
• *.qbb (Back-Up Files)
• *.qba (Accountants Copy Files)
• *.qbx (Accountants Transfer Files)
• *.qby (Accountants Change Files)

Afterward, open the latest and working back-up copy of your company file, and restore the data. The transactions that need to be restored are those that are not present in your OneDrive file.

Please let me know how this troubleshooting step works on your end. Thank you.

I agree 100%. I’ve used QB on Dropbox over 3 years now with now problem, (I actually like how Dropbox box updates the best). i don’t have any luck with Google drive file stream. It will damage the QB file no matter how I tried it (if someone have solution here please post). About Dropbox; I do agree about QB cannot be used at the same time from different computers, however if that happens on accident, Dropbox will create a conflicted WB file that can be used if more valuable information saved there. I had to do it many times, although it could be somewhat headache you always have a backup. It is similar with one drive, 

So if QuickBooks data file is hosted on a NAS drive(example Synology) on the LAN, it should work based on the definition you just gave. Would it still be an issue if the user is trying to access the data file using a latop via WiFi? What if the user is at an offsite location trying to access the NAS drive via a VPN? Would that still be an issue?

This seems to be working for us:

We have Quickbooks (2018 multi-user) hosted on a PC.  The QB file(s) is local (within a documents folder on C) We OneDrive set to backup/sync the entire Documents folder.  I turned OFF the option to have "Files On-Demand" so that the files stay local and also backup to Onedrive.

As a secondary, we perform a daily QB Backup to Google Drive (MyDrive) folder.

Is there any update on this?   (This answer was from 3 years ago.)   I have looked at using Quickbooks Online to get my company books on The Cloud, but it seems that you can only transfer data going back two years.  I have about 15 years of data I would want to transfer.  Is there any function in the latest versions of QB Desktop that facilitate Cloud storage?  

Hello there, @kmd2.

Let me share some information on how you can manage your QuickBooks company file.

When creating a backup copy of your QuickBooks Desktop company file you'd want to take into consideration the size of your data. By doing this, ensure that your QB data remains available wherever you go without any device restriction.

You can subscribe to the Intuit Data Protect service. It has 100 GB of backup capacity. While the limit on Onedrive or Google drive is 5GB which is enough to keep at least 3 to 4 months of QuickBooks data depending on the size. 

Lastly, you can visit the QuickBooks Desktop App center and check for any available third-party applications that offer cloud storage services. Here's how:

1. Go to Apps for QuickBooks Desktop.
2. Enter Cloud Storage in the Search field.
3. Check any available application.

Stay in touch with us here if you have other questions about creating a backup of your company file. I'm always here to help.

...

My file was backed up to OneDrive and I am not able to restore it. Any suggestions?

I can help you with restoring your company file, @Bmurph.

When restoring a company file, it must be a backup company file (.qbb) to create a new company file (.qbw). Also, the option to restore a backup file directly from OneDrive is currently unavailable. You can save it on your desktop first before restoring it to QuickBooks instead.

Refer to this article on how to move company file to local hard drive: Move your company files to another computer.

After moving the backup company file to your desktop, you can follow the steps below on how to restore it.

Here's how:

1. Go to the File menu and select Open or Restore Company.
2. Click on Restore a backup copy and then Next.
3. Choose Local Backup and then Next.
4. Browse your computer for your backup company file.
5. Select a folder to decide where to save your restored company file. Then select Open.
6. When you're finished, click Save. If you receive any warnings about potentially overwriting your data, choose the one that best suits your needs. Don't overwrite anything until you're very sure you want to.

Check this article for more information about restoring a backup company file.

In case you've encountered errors when restoring a backup company file, see this article on how to resolve it: Fix backup company file issues in QuickBooks Desktop.

I'm always here if you need further help restoring your company file. Let me know by leaving a reply below. Keep safe and have a wonderful day!

I know this is marked as 'solved' but not sure it really is. I have used OneDrive to sync my QuickBooks Desktop between multiple computers for 3 years. I sync the entire folder that has the company file and all associated files and it works great...until yesterday. For some reason is stopped sync'ing. OneDrive support was no help. This thread was of very little help. 

I solved the issue by opening my OneDrive online account in a web browser. Then I dragged and dropped the latest QB files that were not sync'ing from my PC into the appropriate folder on the web browser.  Fixed the issue. Now QB is sync'ing as it always did. 

When connected to the internet one drive constantly loads up my recycle bin with .cds, .cds and other backups and then suddenly reboots my computer. Sometime a full reboot where I loose everything I been doing and sometimes just shutting down and starting over with the ACER logo and returning where I was. !!?? When I disconnect from online it works perfectly. 

I appreciate your workaround to sort out your concern with your One Drive, @CarCzar. I'll lay down some details about this.

We have hosting providers authorized by Intuit that allow you to store your data files. If you're working fine with QuickBooks Desktop with One Drive, I recommend reaching out to their customer care support team. 

If you don't want to disable One Drive, it is best to reach out to an IT professional. They know the best process to fix this issue. 

I'll add a bunch of these articles for good practices for backing up your accounting data: 

• Restore a backup of your company file
• Create a backup of the QuickBooks Desktop company file

If you'd like me to clarify more details about managing your files, please let me know the details below. I'll ensure your needs are taken care of.

.CDS is not a quicken extension.   You may have a few problems here, but this is unrelated to Quicken or the backup solution.