55 thoughts on “Advice for using Dropbox, SugarSync or Box.net with QuickBooks (or Quicken) files”

1. Michelle Long Post author10/29/2018 at 2:42 PM

   Any of these may cause problems working with QuickBooks desktop data files. I’d recommend converting to QuickBooks Online where everyone can access and work with the same data without any problems. Otherwise, if you’re still using Desktop, consider QBox (https://www.qboxplus.com/) or use a hosting provider.
2. Polly Ostgaard 10/21/2018 at 9:28 AM

   Does this apply to Hightail file sharing also?
3. Lloyd Sigler 03/26/2014 at 11:33 PM

   The issues with using Dropbox and other similar products aren’t the result of these services. These issues (conflicted files, etc.) are the result of Quickbooks not recognizing when a file is already open or locked. From a programming standpoint it is very easy for them to add the code to test if a file is locked or already open and put up an alert notifying the user that the file is already in use, and then exiting. Too bad they don’t add this simple fix to allow their users the convenience of always having their latest data available on office, laptop and home computers without the ongoing subscription costs of a dedicated ‘cloud’ version of QB.
4. T S Srinivasan 06/08/2013 at 11:06 AM

   Qbox supports Windows now. Support for MAC is expected later this year.

   TS
5. T S Srinivasan 06/08/2013 at 10:23 AM

   Please take a look at https://qbox.coraltreetech.com.

   Qbox can be used to share QuickBooks files with any number of users. The file has to be locked by a user before changes can be synced. Only one user can lock the file at a time. Other users can view the file on their desktops simultaneously, but any changes they make will not be synced. Also Qbox syncs only the required QuickBooks files, so syncing is efficient.

   TS
6. Cheryl 06/06/2013 at 2:36 PM

   “You don’t want a QuickBooks file that’s open and being worked on to be sync’d onto the Dropbox cloud folder” — that sounds like exactly what I want, isn’t it? I am a single user, two computers (one desktop and one for travel or for whenever I don’t feel like being cooped up inside) and think the perfect way to sync QB files is to save the live file in my Google Drive Folder — which syncs it to Google Drive so that I can open it there from any computer. So I’m having a hard time figuring out what exactly the problem is — is it just a dropbox thing and maybe this article hasn’t been updates somewhere to discuss the new Google Drive formats? Let me know if there is another link — thank you!! 🙂
7. rswc90 01/22/2013 at 9:15 AM

   I have used Dropbox successfully with QB for years — but recently, with the latest upgrade to QB2013 Mac, it takes maybe 10 seconds for windows to open. Everything seems to be running VERY SLOWLY.

   I have QB2013 STORED in DB — it is loaded on each of my computers as well. I start the program FROM MY COMPUTER’s SAVED and it seems to go to DB (I am assuming) to load the latest data saved. I keep my backups in DB. I do not get duplicated or conflicted files unless I try to open in from 1 computer while the company is already open on another computer – (single user mode).
8. Michelle Long Post author12/14/2012 at 1:23 PM

   Jack — As you discovered, that won’t work. Now, you need to identify which file is the most current and which transactions are missing and you will need to re-enter them.
9. Jack 12/12/2012 at 3:55 PM

   Is there any hope for recovery if we had multiple users accessing the QB file on dropbox at the same time? We use QB server and had the multiuser mode enabled, but it appears that the file only recorded the first user’s entries.

   So much for using Dropbox w/ QB — I found this thread when searching for solution.
10. Michelle Long Post author11/25/2012 at 11:03 AM

    When you backup the QuickBooks file, save it to the dropbox folder.
11. david 11/25/2012 at 11:01 AM

    Hi MIchelle. We stopped accessing our qb files from dropbox but just realized through reading above that I am not backing up the files then as we still use dropbox as our back up service. How can I have the files back up in dropbox with out it being the location for the file to open in quickbooks. Thanks.
12. Gina@ABO 08/25/2012 at 11:25 AM

    This was a great article and great discussion of information–thanks Michelle!
13. Rob 08/16/2012 at 6:05 AM

    We use DropBox and QB2012 successfully, On a MAC.

    As software developers we are aware of the pitfalls and potential issues but we only use it for Single User Access, and take plenty of backups (as has always been required of QB).

    To get rid of the Conflict copies remove the quickbooks startup shortcut. This starts quickbooks with a /silent command line argument when windows starts, and causes files to be opened, unknown to the user.

    Deselect the “Keep Quickbooks Running for quick startups” option in Preferences/General.

    Anyone wanting to dig deeper could look at the .ND file which is updated with a “FileConnectionGUID” when the database file is opened, this file is synced with dropbox while the database is opened as it is not locked or left open by QB. This would allow other users to check the ND file content and NOT open QB if a GUID was present. If you automate this feature (allow for DBox update lag), let me know, afraid I don’t have the time.
14. Michelle Long Post author06/27/2012 at 4:07 PM

    Amy — you may want to have QuickBooks hosted so users can login and access it from anywhere. There are several Intuit authorized hosting companies — here’s the list:

    Intuit-Authorized Commercial Hosting companies

    Right Networks. Telephone: (888) 417 4448
    InsynQ, Inc. Telephone: (866) 206 1781
    Uni-Data & Communications, Inc. Telephone: (718) 445-5600 x3180
    Xcentric Telephone: (678) 297-0190
    Cloud9 Real Time Telephone: (888) 869-0076
    Coaxis International, Inc. Telephone: (850) 391-1022
    myownasp. Telephone: (800) 521-7322
    NovelAspect.com. Telephone: (888) 228-0143
    Swizznet. Telephone: (888) 794-9948
    Qutera. Telephone: (800) 969-9524
    Real Time Data Services. Telephone: (888) 408-6044
    nGenx. Telephone: (888)-696-4369 x4
    Harborcloud. Telephone: (877)-294-2909
    Proxios. Telephone: (804)-342-1200
    WY Technology. Telephone: (858)-748-1600, ext 333
    Infinity Virtual. Telephone: (866) 257-8455
15. Amy 06/27/2012 at 4:03 PM

    We have been using Dropbox for Quickbooks for a few years now and continually experience the error messages and conflicted copies, even when we try to communicate amongst multiple users so that we are not in the same file at the same time. As such. I am now looking in to other options for where to store these Quickbooks files so they can be accessed by multiple users simultaneously and from a variety of locations (PC, tablet, phone, etc.).

    There has been a lot written about not using Dropbox for the Quickbooks working files (QBW), but are there now any other file sharing services (Wuala?) that can avoid these problems?

    If not, what other solutions are there besides putting this information on a server? I think QB Online sounds like an option, but we just recently purchased QB Enterprise as we want the consolidation capabilities that package has, so I’m not sure QB Online will work for us. And from what I’ve read, it doesn’t sound like Quickbooks will have any sort of cloud solution (ShareBooks) any time soon, if ever at all.
16. Larry Fine, Esq. 03/14/2012 at 10:20 AM

    Great information. Exactly what I was looking for regarding QB and DropBox. Thanks for saving me from a potentially big headache. My QB files are being backed up via conventional methods, including off-site storage through Amazon S3. I’m just gonna leave things the way they are.
17. John 02/17/2012 at 3:50 PM

    Some of the paid-for versions of DropBox are secure in that they encrypt the transmission of data and passwords between computers and their servers. Also, they claim that the data is encrypted *on* their servers too. However, there have been reports implying that the in-storage encryption is more in theory than in practice: http://www.tuaw.com/2011/04/19/dropbox-under-fire-for-security-concerns/.

    On the QuickBooks issue, we tried several times to get it working but gave up. The problem is QB is such a badly behaved program when it comes to touching its files. It creates network related files even when the application is closed, and merely opening a file to look at it causes the file to appear to be changed from the point of view of DropBox. So we reverted to the less intuitive but safer TortoiseSVN (for which non-geeks will probably need some help).
18. Michelle Long Post author02/10/2012 at 10:49 AM

    That’s a good question Christi. I haven’t investigated the security of Dropbox in detail. If there are SSNs, bank account #s, etc. in a file, I’m not sure I’d use Dropbox. Plus, there are some states with laws regarding the security and protection of sensitive financial data of client records. ShareFile and LeapFile are affordable, secure client portals. I’m a member of The Sleeter Group so we get a ShareFile subscription with our membership.
19. Christi Millo 02/06/2012 at 10:51 AM

    Is dropbox secure for sharing other files (not Quickbooks files)? Do you trust the encryption, etc. when using just the free version?
20. Portland business bookkeeeping 01/29/2012 at 5:25 AM

    Drop box works great. I use it often. However, a word of caution: only save QBB files in drop box its the safest, surest way form getting a damaged QB file. The way I do it is save the QBB file in DBox and download it to my lab top when I am going to use it. After I am done I back it up both to drop box and another off site location just to be safe. Great article will link to it and share with the Portland bookkeeping community.
21. Michelle Long Post author01/21/2012 at 10:58 AM

    I’d suggest you move the QBW file out of the Dropbox folder. Open it in QuickBooks and review the work you entered this week. It should be ok. Usually you will see Conflicted by the file name in the Dropbox folder if there are problems.

    It’s a good idea to backup QuickBooks to the Dropbox folder. Then, you have an offsite backup for free. 🙂
22. Matt 01/20/2012 at 11:45 AM

    Here’s a question – I have been able to work successfully with a QBW in DropBox for a week or so. Now that I have “seen the light” of the dangers of the DropBox/QBW combination, should I scrap the roughly 20 hours of work I put into the file and revert to the pre-Dropbox QuickBooks Backup (.QBB) file?

    How do I verify if that file is still good, and not damaged by being in DropBox? Is that even possible?
23. David Carroll 01/11/2012 at 8:56 AM

    This seems like a simple solution to get around using lock files. Just write a batch file that will check for a lockfile, and if it finds one then it throws a message and exits. If it doesn’t then it creates a lock file in the dropbox folder when you open quickbooks. When you close quickbooks the lock file will be deleted. No new instances of quickbooks.

    Also you may want to have a timer when program exits that waits for 10 minutes before clearing the lock file. That way there is time for the new file to propogate to the shared folder.

    My only concern would be that the QBW service would keep the file open for some reason and it woudln’t get uploaded.

    It’s not like these problems haven’t been encountered and overcome before, you just have to use your noodle.
24. Ted 12/28/2011 at 12:01 PM

    I’ve been using QB with Dropbox for about 6 months. We were concerned about a few of the glitches we were having and my CPA looked it up. Anyway, I can verify it’s glitchy in terms of making duplicate files. I once had to go find which file had saved all of the checks I had last wrote, and it was named “Company File (Conflicted Copy from 12-01-11)”. Sometimes we have permission errors trying to open files. Nothing catastrophic, but we’re going to stop using it now.
25. Joe 12/10/2011 at 10:40 AM

    I’m using SugarSync since a few month and can only recommend it to you
    guys. It’s fast and supports multiple OS like Windows, Mac, iOS and
    android.

    You get 5 gb for free and when you use the b.m. Link you will get 5,5
    Gb for free. If you go for a premium membership (starts at 30 Gb) each
    of you will get additional 10 Gb for free.

    Check this out and get a 5,5 Gb account for free.

    https://www.sugarsync.com/referral?rf=fgtgw30dr45gt&utm_source=txemail&utm_medium=email&utm_campaign=referral
26. Peter 12/02/2011 at 12:25 PM

    I’m using SugarSync since a few month and can only recommend it to you
    guys. It’s fast and supports multiple OS like Windows, Mac, iOS and
    android.

    You get 5 gb for free and when you use the b.m. Link you will get 5,5
    Gb for free. If you go for a premium membership (starts at 30 Gb) each
    of you will get additional 10 Gb for free.

    Check this out and get a 5,5 Gb account for free.

    https://www.sugarsync.com/referral?rf=fc0dmqb8y4oz&utm_source=txemail&utm_medium=email&utm_campaign=referral
27. Carl Gauthier 09/27/2011 at 9:11 PM

    Interesting tips. I use Dropbox to store backups of my clients files which allows my clients and I have access to the backups outside of their offices plus giving my clients an offsite backup of their data. My clients and I also utilize TeamView or LogMeIn to remotely access their systems at their office for any real-time data requirements.
28. Lois Brower 09/27/2011 at 1:08 PM

    Thanks for this tip on Dropbox. I use it to keep track of my hours for clients at their location. Then I can access it on my computer in my office to invoice them. I had not thought of using it with QB and now I’m glad I didn’t.
29. Scott 09/27/2011 at 12:18 PM

    The tips on the FTP sites was very useful and I have added the SugarSync as a tool.
30. Michelle Long Post author09/27/2011 at 11:17 AM

    Marie — ShareBooks is not available yet.
31. Marie Dupree EA 09/27/2011 at 10:42 AM

    Thanks for your valuable suggestion. I, too, have had issues with Dropbox! Is QB ShareBooks up and running yet?

    marie
32. Jefferson Kane 09/24/2011 at 9:00 PM

    I would feel much safer using Right Networks than Dropbox.
33. Karen 09/21/2011 at 9:27 PM

    Thank you for the information on Dropbox.
34. Karen 09/21/2011 at 9:26 PM

    Thanks for the information.
35. Hal Rosen 09/21/2011 at 10:56 AM

    I’ve had my Quicken files in my Dropbox folder for more than 18 months without any issues. I’m the only one who accesses the files.
36. Dave 09/21/2011 at 7:00 AM

    I tried QBReflex which is quiet good to get QuickBooks report in mobile
37. Michelle Long Post author09/08/2011 at 7:15 PM

    Dropbox won’t automatically import all your files — you have to put the files in the Dropbox folder

    I’m not familiar with that error code — go to http://www.quickbooks.com/support and search for it or Google it.

    Also in QuickBooks go to File > Open > Previous and make sure you are in the right file.
38. Ashleigh 09/08/2011 at 6:53 PM

    Hi Michelle,

    I was wondering if you’ve ever heard of error code 80070057? I keep getting this error when I try to open quickbooks no.I installed Dropbox on my computer (not realizing that it was going to import all my files) and now when I go to my Quickbooks, it’s like Im starting out a new company. I thought that the files would stay on my computer, not get completely transferred to Dropbox. Do you know of a way to revert my Quickbooks Payroll back from DropBox to my computer?

    Thanks, I’d really appreciate any help, as Payroll is due & I can’t access anything!
39. Michelle Long Post author06/12/2011 at 10:19 AM

    Thanks for your comments. SugarSync does start with 5GB of free storage space and there’s apps for the iPhone and iPad (just like with Dropbox). You can also use my link: https://www.sugarsync.com/referral?rf=ehs9e9akhc63v to sign up for SugarSync and get 500 MB extra space free. 🙂 I use both Dropbox and SugarSync to get more storage space and keep different things on each.
40. w0qj 06/10/2011 at 11:06 PM

    Good review – there are a few recent changes as of June 2011: (for SugarSync)
    You get 5GB of space with the FREE version, but now there is no restriction to the number of computers you can sync/backup (up from 2).
    It gives you the ability to upload and sync any folder on your computer.
    It is the only service that offers such a broad device and OS support with apps for BlackBerry, Android, iPhone/iPad, Symbian, not to mention your computer!

    Also if you use the below referral code you get a bonus 500MB extra on top of your Free 5GB!

    https://www.sugarsync.com/referral?rf=tbtp0asbw9pt

    Hope it helps someone.
41. Michelle Long Post author06/10/2011 at 11:11 AM

    Mike — You can’t just upload the estimate for the accountant to save into her file. If you are using QuickBooks 2011, I would suggest you check into QuickBooks Connect. It would allow you to enter Estimates remotely (via a computer, iPhone or iPad) and they would sync with the accountant’s data file. You can learn more here: http://workplace.intuit.com/quickbooksconnect Otherwise, there are 3rd party tools to import transactions — check out http://www.q2q.us or others
42. Mike Barcelos 06/10/2011 at 10:30 AM

    @ Michelle

    After skimming through all of these posts, I understand the reasons as to why it is not recommended to share live quickbook files between users/computers via Dropbox.

    I work for a landscape contracting company and type up estimates on quickbooks every day on my computer, and need a way to transfer the estimate to our accountant’s computer. The estimate has no linked files or finances associated. Is it safe to upload the estimate to Dropbox and have my accountant pull up the estimate and save it to her records to add it into the financial database?
43. Michelle Long Post author06/08/2011 at 10:48 AM

    Thanks — I’m glad it helped you! 🙂
44. Manu Handa 06/08/2011 at 12:12 AM

    @- Michelle.

    Thanks for these tips Michelle. Few of the resources I found on the web helped me alot and so is your information in this blog. I was able to provide better solution to clients who were using the sugarsyn and other apps in their working environment.

45. Pingback: Quick Tips to Increase Your Website Traffic : QuickBooks and Beyond

46. Michelle Long Post author05/17/2011 at 5:19 PM

    Joe —

    I’m not an Intuit employee and the post clearly indicated that I’m working with Intuit as a consultant. I do not tell people not to use Dropbox, et al but just not with the working company file (QBW).

    I’m not using ‘scare tactics’ but I’m sharing information that I have learned from a variety of sources — including 2 consultants whom I consider to be experts in working with QuickBook data files and they are NOT Intuit employees.

    I have seen clients and other people having problems with conflicted files, etc. and SugarSync even says do NOT use the QBW (QuickBooks working company) file, so I’m trying to help people learn more so they can avoid problems with their data files.

    You can use Dropbox et al for the backup or portable files, but it is not recommended for the working company file — as acknowledged by Sugarsync on their website.

    I’m trying to provide accurate information from a variety of sources so people can make an informed decision.
47. Joe Deasy 05/17/2011 at 2:46 PM

    Thank you Brad,

    My only concern with using Dropbox to sync the company file is not knowing how & when Intuit will undermine it in the future. Once their own $ync tool is ready, future QB releases will surely be coded to sabotage any competition to QB$hared. Such has always been Intuit’s MO.

    Michelle,
    As you say on the other page:
    “I’m working with the Product Manager Howard Shen and the development team as part of the ‘Accountant Posse’ on QuickBooks SharedBooks”….
    “I cannot provide many details (I’m under NDA).”

    it is dishonest not disclose your conflict of interest on this topic here & on the other sites where you have been using scare tactics to discourage people from using the services of potential Intuit competitors.
48. Arlee 04/26/2011 at 4:14 PM

    Michelle.
    We stopped using 3rd party Dropbox, Smartvault, Savefile etc.
    We have our own upload and download section on our own website for client files. back end FTP server etc.
    (client logs in user /password – to their own portal) .
    Lucky you. In Canada we do not have a cost effective solution by Quickbooks.
    Plus what they said was disturbing.. As Proadvisors we would have to pay for each Company file we open.
    So the math looks like this.
    Quickbooks fee for virtual server multiple user access on quickbooks system.
    1- file. 85.00
    100 files 100×85 = 8500.00

    On my system swizznet I pay one fee. (cloud FTP Server technology)
    Annual amount of 75.00 x 12 = 900.00 Limit of 10 concurrent users. Meaning only 10 people could be logged in at the same time.
    I can open all 100 files (of course 1 at a time in a month)
    100 clients can open their file.. No extra fees.
    I told quick books that their pricing model is NOT Condusive in the Open Market .
    The price difference was too much.
    8500.00 vs 900.00

    So in my mind, even though I am a Quickbooks ProAdvisor here in Canada, My response to the quickbooks pricing for the service at this point …. NOT ACCEPTABLE, & Unrealistic.
    To be clear the QBW file is online, and has 100 GIG of storage for client supporting documents. Extra storage if needed is 10.00 per extra 100 GB of storage.
49. Michelle Long Post author04/04/2011 at 1:12 PM

    I’m glad that is working for you Cynthia! Just remember when you restore the QuickBooks company file (QBW) to save it somewhere other than the Dropbox folder.
50. Cynthia 04/04/2011 at 7:27 AM

    Glad to see this article Michelle. I’ve just installed Drop Box and am using it with my assistant. However, I was concerned about having the actual “live” file and suggested only putting the backup files and any necessary documents there. I didn’t give thought to the sync part…. my concern was someone hacking into the data file…. even though it is password protected.

    When she works on the data file, she makes a back up and then puts it in Drop Box for me to restore review and do what I need. I then remove the backup and have an empty drop box for the next time I need to do a backup and send to her.

    Works like a charm, and I have no fear about “mucking up” the live data file.
51. Michelle Long Post author04/04/2011 at 6:36 AM

    Brad – you are right that Dropbox does not create the backup file. You need to be in QuickBooks to create the backup or portable file and save it to the Dropbox folder. Then,, Dropbox would sync the file.

    You’re correct that Doug, Mario, etc. indicate that it should not be used for the QuickBooks company file for multiple users or even a single user. The QuickBooks company file (QBW) shouldn’t be used with Dropbox (or the others) at all.

    Thanks for your comments!
52. brad 04/04/2011 at 5:42 AM

    i have not found this articles ideas to be accurate, at least in the case of dropbox. the simple fact is, dropbox CANNOT and does not copy or backup open files. If you have a QuickBooks or Quicken file open, it will wait until you close it to make a backup copy of it to the server and any additional machines you have shared the folder with. the simple proof is in the tray area – hover over dropbox status icon when you have a QuickBooks file open – it will show you that it is waiting for you to close the file before it can make a backup copy of it. i presume sugarsync and box.net have similar features or at least options, but have not used those. i would not suggest dropbox for multiple users however, unless it is a one way share, where one person uses it and the others only view the file or make copies of it, because conflicts can arise, and perhaps this is what doug and the others are concerned about, and i agree with that.

    brad
53. Michelle Long Post author04/03/2011 at 8:15 PM

    Thanks Sandy!

    Jo Ellen — I’m not aware of any safe file sharing sevice for the QuickBooks Company file (QBW) at this point. The other option would be to have QuickBooks hosted or login remotely using TeamViewer (free for personal use), Logmein Free or another remote access service.
54. Sandy Lenner 04/03/2011 at 8:09 PM

    Michelle and Mario

    Very insightful

    Sandy
55. Jo Ellen Peters 04/03/2011 at 7:58 PM

    Michelle,

    I have followed these discussions before about not using Drop Box for a live QuickBooks file. And if QuickBooks Shared Books is not available yet, is there a file sharing program that is safe to use with a live QuickBooks file?