Print This Post

Can QuickBooks Keep Up With Microsoft?

June 9, 2011 | By | 20 Replies More

If you work with QuickBooks (the desktop version) you know that it is intimately intertwined with Microsoft products. There are advantages to this, but also many disadvantages. I’m wondering how this is going to work out as our industry evolves over the next few years. Let’s take a look at some of these issues, and talk about a few upcoming changes that have been announced by both Intuit and Microsoft, including Windows 8.

QuickBooks and Microsoft

Microsoft Office and QuickBooks    QuickBooks and Microsoft Office

QuickBooks Desktop has many “hooks” with Microsoft products. For example:

  • Microsoft Word integration in the Invoice Letters feature.
  • Microsoft Excel integration for importing and exporting list information, and exporting reports.
  • Microsoft Outlook integration for emailing invoices (etc.).
  • Microsoft Internet Explorer integration for interaction with web based features such as Intuit PaymentNetwork, Intuit Payment Solutions, and many other features.

In most of these cases you have no alternative to Microsoft tools. You can’t substitute Open Office for Word or Excel. You can’t substitute Firefox for Internet Explorer. QuickBooks forces you to use the Microsoft tools (emailing is an exception to this).

Close integration of a Windows desktop application with Microsoft Office was a major emphasis of Microsoft in years past. They made it very easy, from a programming standpoint, to use Microsoft Office tools to perform many tasks, such as rich text editing (Word) or spreadsheets (Excel). If you were a software developer and you wanted a Microsoft Compatible logo on your application, you were pushed towards close integration. However, the software industry has moved beyond that approach to a more open form of collaboration. Unfortunately, the QuickBooks Desktop integration with Microsoft tools is woven tightly into the software, and it will be hard for them to break free.

Keeping Up To Date

As we have found over the past year or two, Intuit has had a hard time keeping up with changes in Microsoft technology.

How about Microsoft Office compatibility? Office 2010 was released to the public in June 2010, but to this day QuickBooks still has compatibility issues with it. Certainly, Intuit is working on making things better, but as we talked about in our article on QuickBooks 2011 and Office 2010 Compatibility, there are still issues. I’ll give Intuit a break on compatibility with 64 bit Microsoft Office – even Microsoft recommends that people use the 32 bit version if you don’t want compatibility problems with LOTS of software. However, even a year after the public release of Office 2010 we still see some compatibility issues.

How about Internet Explorer? As we talked about in our article on QuickBooks and Internet Explorer 9, the latest release of Internet Explorer creates some compatibility problems with some QuickBooks features such as the Loan Manager, which are hard to get around. Again, I’ll give Intuit a bit of a break on this, as I’ve found other issues with Internet Explorer 9 and other products.

QuickBooks and Internet Explorer 9

Even though I’ll cut Intuit some slack on the issues that Microsoft has created for compatibility, the fact remains that QuickBooks doesn’t allow you to use other options to get around these compatibility problems.

QuickBooks and Old Technology

QuickBooks desktop is an old product based on old technology. It is hard to move a large, complicated program like an accounting product forward as operating environments change (I know, ask me about my move from DOS to Windows with my former software company). Sure, there have been a number of improvements in recent years, but the core technology is still old.

In 2006 QuickBooks moved from an older database technology to something more up to date – but it is still a desktop database that they have locked down tightly.

In 2008 Intuit  introduced the Intuit Partner Platform (IPP) as a new web programming interface. Your data is replicated to a “cloud” data store. However, this method relies in part on a very old and antiquated programming interface that makes things slow and difficult, and that requires some older programming methods to access (internally – the IPP programmer doesn’t see this). This approach has taken a long time to become useful, and is still going through some growing pains. Have you worked with “Sync Manager” much? Do you have multiple “profiles” in the Intuit App Center? I’m still struggling with getting this to work right. Intuit is working on improving the situation, and they’ve come a long way since the initial releases, but there are still complicated issues here AND it is still relying on your old desktop application.

Although there are many new features being added that present themselves with newer interfaces, newer technology (web apps, mobile apps, etc.) – it all comes back to your QuickBooks desktop product and old technology from prior decades.

Microsoft is Moving Forward

We’ve seen how QuickBooks relies on Microsoft technology. We’ve seen how Microsoft advances have impacted QuickBooks. How about the future?

Have you seen Microsoft Office 365? They are beta testing this now. Office apps, but web based. If you move to this and use it instead of Office on your desktop, what will that mean for QuickBooks? So far, I’ve not been impressed by it, but then everyone knows that I’m a desktop guy. But if you buy into this approach, you still need a desktop copy of Microsoft Office  if you want to work with QuickBooks.

How about Microsoft Windows 8? I’m still just getting used to Windows 7 myself. We probably won’t see that THIS year, but it is reasonable to assume that we will see this in 2012. Microsoft talks about a two to three year cycle on these things, and Windows 7 was a 2009 release. Here is an article with a video that shows some prototypes using Windows 8 – sure starting to look a lot like what I’m seeing on my iPad and other devices. If you watch this you’ll see that they still have allowances for the “old” way of running things – so QuickBooks should still be covered. However, as we saw when we moved from Windows XP to Windows Vista, compatibility with older programs is not guaranteed.

Will Intuit be able to keep up with these kinds of changes? The longer that they rely on the “legacy code” of the current QuickBooks desktop product, the harder it is going to get.

Intuit is Moving Forward

I don’t want to paint a picture that is all doom and gloom. Intuit isn’t sitting still – there are a lot of great innovations coming out that we’ll talk about soon.

Intuit clearly has a focus on “mobile” applications and taking advantage of the current shift in programming technologies and access methods (or “platforms”, if you like) that we are seeing. I’ve written about managing Intuit payroll from your iPad, for example. I’ll have an article on some new developments in Intuit GoPayment as soon as I can get the card reader working (my problem, not theirs). There are a lot of wonderful apps being developed that can leverage your QuickBooks desktop product and bring you into the new world of mobile accessibility.

We do have their IPP initiative, to bring your desktop financial database out to the Cloud. I’ve been fairly critical of the IPP initiative in the past, but things are starting to move forward and issues are being resolved. It has taken some time, but with the announcement of Intuit Anywhere (Note 8/2013: Intuit has dropped this name and the website for the announcement). For those of you who aren’t really familiar with the IPP interface, or programming, it might be a bit difficult to determine what exactly this announcement is about. Let me make it very simple – Intuit is learning that the IPP programming interface was complicated to use by developers, and so they are coming out with a newer way to let web programmers easily access your QuickBooks desktop data. It is still IPP, but they are making the programming task easier. I like the concept, we’ll see how well it works. This is still a beta product and we won’t start seeing anything using this until later in the year, possibly the Fall or even later.

We Still May Suffer

I’m afraid that as long as we are using the QuickBooks desktop product, when Microsoft makes big changes we’ll suffer through further incompatibility issues. QuickBooks desktop is tightly connected to older Microsoft technologies. QuickBooks Online isn’t a full featured product with all the support that you see for the desktop product. All the Mobile and Web products are still relying on a connection to your desktop product. I believe that until Intuit makes a clean break from the QuickBooks desktop product, something like what Xero does, we’ll continue to suffer when Microsoft makes changes.

That doesn’t mean that I’m ready to get rid of QuickBooks Desktop, though! No online product has the breadth of support that QuickBooks has. Books, blogs, webinars, add-on products, college classes and support groups are all well developed. Online and cloud based apps may be the future, but they have a ways to go before they completely replace the desktop.

Tags: , , ,

Category: Technology/Trends, Working with QuickBooks, Xero

About the Author ()

Charlie Russell is the founder of CCRSoftware. He's been involved with the small business software industry since the mid 70's, and remembers releasing his first commercial accounting software product when you had a one-floppy disk drive system, loading the program from one floppy and then replacing that with the other floppy to hold the data. He has a special interest in inventory and manufacturing software for small businesses. Charlie is a Certified Advanced QuickBooks ProAdvisor with additional certifications for QuickBooks Online and QuickBooks Enterprise. He also is a Xero Certified Partner. Visit his CCRSoftware web site for information about his QuickBooks add-on products. Charlie can be reached at [email protected] He is also the author of the California Wildflower Hikes blog Connect with Charlie at Google

Comments (20)

Trackback URL | Comments RSS Feed

  1. Fran Reed says:

    Charlie,
    Great and thoughtful article.. The “early” adopters and vsionaires are certainly pushing most cloud technology… its great because of connectivitiy and I love what web technology can bring. but my sense is that local ‘desktop’ apps will still thrive for many years, but in a very different way.. One way that allows sync’ng but you still have control over product and are not liable if net goes down or do not have acces to it.. And Intuit needs to find that way.

    • Thank you, Fran. Of course, a mixture will make sense for lots of products, such as QuickBooks Desktop. And Intuit is going that direction. I’m just not sure I like the actual mechanisms they are using.

  2. Steve Gill says:

    Charlie,
    Couldn’t agree with you more. But hasn’t this historically been the case with any software provider who builds apps for Windows? Over the years I have suffered from numerous issues of existing apps not yet adapted for compatibility with the latest Windows or Explorer releases. This is just another indicator of the “snobbish” approach Microsoft has always taken toward the user. It would be great, though, if Intuit were a little more open to other options such as the 100% Google shop, instead of relying so much on Microsoft, which is after all only one player in the game. Thanks as always for the insightful post.

    • Steve, yes, any softtware developer in the Windows environment has had to deal with these issues. However, part of my point is that Intuit has more of an issue than many programs. The strong ties to Internet Explorer and Office have caused problems that should be avoided.

  3. Mary Longacre says:

    Charlie, this issue has been on my mind as well. Thanks for addressing it! One more question I have is how able will the various hosting platforms (Insynq, Right Networks, etc.) be to handle keeping QuickBooks functional and user data separate it as Intuit adds more web-based hooks into QuickBooks? I’m especially thinking about the “Plus” subscriptions where Intuit upgrades the software automatically – I assume that’s a non-starter for hosting?

    • Thank you, Mary.

      Plus is an interesting option. On the surface, I wouldn’t think that this would work for the hosted solutions as well as regular desktop versions. However, I’ll say that I’m not entirely thrilled about some aspects of Plus anyways. I like more control over what updates I’m getting, and I want them tested in more detail.

      Hosted solutions have better control over their environment, so you don’t run into all of the issues. You won’t find one of your users installing IE9 without you knowing it, for example…

  4. Joyce Beck says:

    The the other ‘hook’ that annoys me is Adobe Reader. QuickBooks can’t launch whatever program is designated to open pdf files, oh no, it has to be Adobe Reader. Even if you have Adobe Pro, which is really annoying.

  5. April Hooper says:

    Charlie, thanks for another great article. I’m especially interested in finding out more about Intuit Anywhere since Method CRM is one of the six applications on the beta version.

    • April, it could be very interesting. I have a LOT of questions about Method and this – as in the past, Method has not used the IPP interface, they’ve made their OWN cloud storage for data. I’m guessing that the Method integration with this won’t be available until later this summer, and I’m hoping to be able to write more about that when I’m allowed to.

  6. Fred Blauer says:

    If you are concerned about relying on proprietary platforms like Microsoft, why are you not concerned about relying on Intuit? There are good free and open source alternative like xtuple postbooks, which allow you to avoid being locked into any vendor, and they work very well. Most people don’t know that these alternatives exist because the developers don’t spend tons of $ on marketing, which you end up paying for.

    • Thanks for the comment, Fred. There are a lot of alternatives out there. We’ve talked (briefly) about Xero, for example. But, that is a different discussion.

      If the client comes to you and says “I use QuickBooks, I want to stick with QuickBooks because I’ve used it forever, help me get it to work”, you have to work with them or they’ll find someone else who will. So, we have to learn how to manage QuickBooks. That is what we are talking about here.

      We’ll be expanding our coverage of other professional level accounting systems in other articles, as time goes on.

  7. There is indeed dependency of Intuit QuickBooks on Microsoft Products. A way out I can see is for QuickBooks to make their applications web based even if it’s installed locally. The software will run a local database, but the interface will be via a browser. All exports should be made as cvs files which will allow them to be imported into other applications of a user’s preference (e.g., OpenOffice). It will also be great to be able to designate what application to use when I try to export information from QuickBooks. Having QuickBooks web based will also make it easy to integrate into remote servers.

  8. Mindy says:

    I have clients still on Windows 2000 and some on Windows 7, and then everything in between. Most still have XP with Word 2003, which seems to be the most stable combo.

    • Mindy, I am pretty happy with Windows 7 for current versions of QuickBooks, and Office 2007. I use VMWare Workstation for older products. I will be writing about that in the near future, I hope.

  9. AC says:

    Hopefully there are more options for Mac users like myself. It seems that we get a scaled down version of QuickBooks.

  10. RC says:

    How about QB actually make a stable product for once and stop blaming Microsoft.

    • RC, I’ll say that there are problems on both sides. To be honest, I have more trouble with Microsoft products than I do with Intuit products as far as stability, but I may be in the minority there. Intuit has work to do to upgrade their product, which uses some very old technology. Microsoft keeps introducing new instabilities in their products.

Leave a Reply