Tag: quickbooks remote access

Posted on

Better QuickBooks Access, Management and Security – QuickBooks Licensing and Hosting Models

Whether hosted in-house or offsite, licensing models for hosting QuickBooks can be very confusing.

driving1-ANIMATIONThe demand for solutions to address user mobility, better collaboration and improved information security is increasing as connectivity improves and cloud services and threats evolve. Server-based computing models and application hosting are increasingly popular as businesses seek to embrace teleworking and telecommuting models for their entrenched applications and systems, creating a foundation for improved productivity and work/life balancing (or integration).  On the technical side, the benefits of centralizing applications and data include improved efficiency in managing, maintaining and securing systems. For many small businesses, this means centralizing the installation and maintenance of core business applications like Intuit QuickBooks Pro, Premier or Enterprise.

Whether it be offsite with a commercial hosting provider or on a co-located server somewhere, or an onsite installation on the in-house server, hosting Intuit QuickBooks licenses can be straightforward or complicated depending on what you are trying to do with them. Because QuickBooks was designed as a standalone single-user application, there are a number of challenges when it comes to preparing it for server-based use.  The primary issue is often simply understanding the QuickBooks licensing model, which is not particularly INTUITive (sorry).

Licensing hosted QuickBooks applications comes with two different sets of implementation issues: the technical implementation (the installation and setup) and the logical allocation of licenses to users (the licensing rules).

When it comes to the technical implementation, many an experienced engineer has beaten their head against the wall trying to get QuickBooks to work properly in a workspace or session-based system (e.g., terminal server), all because they expect the product to implement like a “normal” client/server application. While QuickBooks may use the Sybase database manager guts to handle multi-user access to QuickBooks data files (I think it is still Sybase), the architecture required to properly service a networked QuickBooks installation does not necessarily mimic what would be used with, for example, a .NET desktop client application with an MS SQL back-end.   First, the QuickBooks data files cannot be remote to the application, meaning that both the client and the database manager (which is actually working as an adjunct to the client) must exist on the local network; it will not work over a WAN connection, which is why so many folks get frustrated when they put their server “in the cloud” and attempt to connect from a local client using a VPN.  It just won’t work that way with QuickBooks; it all has to be on the local network – client, server, data… all of it.

It is notable that many businesses use Dropbox and other file sync solutions because they want to be able to get to their data from multiple locations, but the data they’re getting must be “local” to the apps that use it.  It doesn’t allow for simultaneous multi-user access, but it can be an effective way to share a file.  The caveat is that the file (at least in the case of a QuickBooks file, or Outlook PST file, etc.) should not actually be used from the sync folder.  Sync folder should contain copies of data files that users wish to sync or share with other devices.  But I digress…

With a server-based implementation of QuickBooks, technicians will install the QuickBooks desktop software on the server, and will determine whether or not that same machine will also handle the company data files.  The QuickBooks DB manager is part of the installation of QuickBooks, and the file system and drive where the QB files are to be managed must be recognized as a local drive on the server running the QBDB manager.  The overhead used by the database manager isn’t huge, but it can impact the performance of users on the server.  For this reason, some techs will decide to implement a separate file server to manage the QB data files, taking that load off the app server.

  • The QuickBooks software uses the database manager to “host” access to company files.  This simply means that a single server with the data on it is providing managed access to remote-desktop-sessionsQuickBooks application users.
  • When QuickBooks application software and data is installed and centrally managed on a server (instead of QuickBooks being installed on individual PCs), that means QuickBooks application is being “hosted” on that server.
  • When a 3rd party provider supplies the server, the QuickBooks installation, data storage, and your way of connecting to it all,  that provider is a “host” providing hosting services for your QuickBooks.

In a dedicated hosting environment, the data is often stored on the same server as the applications, whereas in a shared hosting environment, the data is often stored on central file servers which serve multiple customers. This is why, in some shared hosting situations, one bad data file can take down the database manager services for all the customers using that same file server.

Users open the QuickBooks application on the server instead of having the application installed on individual PCs.  The single server-based installation of the software is able to be used concurrently by all users logging in to that computer. With the database manager running, the file is essentially “hosted” on that machine, and the file may then be opened in multi-user mode.  OK so far.  The problem generally comes about when a second user on the same computer/server wants to open the same QB data file as the first user.

Because the QB database manager is looking at the license of the client application accessing the data file, it will recognize when two different users/sessions with the same license key attempt to open the company data file.  If that license key is a single-user key, then the database manager knows it should allow only 1 concurrent user in the file.  QuickBooks doesn’t get installed for each user on a computer or server; it is installed one time on the machine and each user on that machine runs from that single shared installation. Any particular version of the QuickBooks application may be installed only once on a single computer, but it is possible to install multiple editions, year versions, and “flavors” of QuickBooks on a single machine (cannot be more than one installation of each unique product). There will be more than a few annoyances when running a variety of QBs on the same computer, but it is technically possible.

In order to allow multiple users to simultaneously access the same data file from a central installation of QuickBooks, the license key installed on the computer must be a multi-user key.  QuickBooks Pro, for example, can be keyed to 3 concurrent users, meaning that the license will allow up to 3 users with that same license key to simultaneously access the same company file.  Technically (but not lawfully) this installation of QuickBooks on the machine could allow a virtually unlimited number of users to launch the QuickBooks application simultaneously, limited only by machine resources.  This is where the logical allocation of licensing comes in.. the rule of licensing QuickBooks.

The logical allocation of unique licenses for each QuickBooks user is a little easier to understand than the technical implementation.  The rule is simply that each user of QuickBooks is required to have a valid registered/activated license. That valid license is a license purchased and activated for that business.

total-businessMaking QuickBooks desktop editions more useful by adding secure remote access and centralized management makes a lot of sense.  For companies who rely on the functionality and features of the desktop products (QuickBooks Pro, Premier and Enterprise), a hosted approach is the only way to really address mobility and multi-location requirements.  Remember that hosting doesn’t necessarily mean offsite, although that could make sense for the business, too.

Centrally-managing QuickBooks applications and data creates greater efficiency and improves overall IT management capability for the business.  At the same time, a centralized model introduces a better strategy for mobilizing the workforce and connecting remote users and offices. The struggles of understanding and implementing proper QuickBooks licensing begin to seem very small when compared to the benefits of deploying a centralized system that’s easier to access, manage and secure.

Make sense?

J

Posted on

Focus on the Finance Department: QuickBooks in the Cloud

Focus on the Finance Department: QuickBooks in the Cloud

Vendors and IT solution providers are all buzzing about their cloud services and solutions available via the Web.  This buzz often includes statements about lower cost of IT acquisition and service management and how mobility and remote access benefits the business.  These statements are proving true for many businesses, yet there are still vast numbers of small business operating on local computers and unmanaged service.  The reasons which hold back these business from adopting cloud computing models are as many and varied as the businesses themselves, but there is a consistent thread to be found in these reasons, and it has to do with a lack of understanding of what certain applications really mean to the business.  In this case, the discussion is about the focus on strictly operational or administrative areas of the business and not on the finance department which, in so many small businesses, uses QuickBooks.

Cloud solution providers are in business to make money, and hosting companies in particular are looking for the right applications which will drive usage and revenues on their platforms.  When these providers look at the small business market, they’re trying to identify the applications and services that small business owners will adopt in volume.  Identification of these opportunities to serve a large customer base is essential to the provider’s economy of scale and profit model.  It makes sense that hosts would want to offer the applications which drive the highest degree of usage in their environments, so they tend to focus on the applications used by the greatest number of users within the customer organization.  In the small business market, these applications are email and productivity tools – solutions which are used broadly throughout the business and which serve a horizontal rather than vertical industry orientation.  Those are the two easy picks; finding the next most valuable solution represents a bigger challenge for the provider.

qbcloudWith Intuit QuickBooks desktop editions boasting the lion’s share of the small business accounting market, it seems that hosting QuickBooks products would be the next natural selection by hosting providers already serving their small business clients with email and productivity solutions.  However, because these service providers do not fully understand the essential functions QuickBooks serves in the small business, the assumption is that the usage of the solution is so nominal that it doesn’t make sense to develop the capability to offer it.  It is a misunderstanding that many providers have, and is the result of a lack of historic participation in the product.  QuickBooks, you see, is a direct to consumer product rather than a channel product, and most IT service providers and hosting companies recognize the product name but not really what it does or how it operates.  And these hosts are often large companies and therefore have no direct experience using the product, so there is no frame of reference for them to work from.  These service providers are simply overlooking the important role that QuickBooks solutions play in many small businesses, where it is used to handle various operational aspects of the business as well as being the product of choice for bookkeeping and accounting.  Particularly with the QuickBooks Premier and Enterprise editions offering additional functionality and industry-specific features, the products are used widely by small businesses and not just for accounting and finance.

The point of the discussion is that hosting companies and “cloud server” providers should look at the mixture of applications used by their small business customers, and they are likely to find that QuickBooks products are pretty high on the list.  Even if there are only a few people in the accounting department, and the usage by these individuals is not representative of the entire hosting opportunity, hosts should recognize that those few individuals and the software they use are not only essential, but are probably processing payroll for all those other users on the system and are paying the bills for products and services purchased.  After all, if you’re going to make anybody in the company happy, make sure to focus on the finance department and help them get their QuickBooks in the Cloud, as they’re the ones that will be paying the bill for the service.

Joanie Mann Bunny Feet

Make Sense?

J

 

 
Google+

Posted on

Cloud Computing for Small Business: It’s All About 3 Apps

Every business uses technology at some level, and every business has certain fundamental needs which are most frequently met through the use of computing technology.  Regardless of business type or size and independent of industry orientation, there are 3 fundamental things which every business does which means that there are 3 fundamental application types or solutions which every business will buy at some point.  These 3 application types, which could be distilled down to just “applications”, have become so broadly used in business and so widely recognized as the standards that their names are often used instead of the term representing the functionality they provide.  When it comes to cloud computing for small business, it’s all about these 3 applications.

In what are now referred to as “legacy” or “traditional” models, these products would generally be purchased as software and associated hardware to run it, and would be installed and managed on the local premises.  With cloud computing models, the solutions may be purchased or subscribed as managed infrastructure and application licenses, or as a full service subscription (SaaS).  Regardless of the service model, the applications are the key to the customer win.  While cloud computing may be challenging how IT products and services are sold and delivered to customers, it is not fully impacting which solutions customers are actually looking for.  Over the past 16 years this has been the reality, and it may take another decade before these products are unseated from their top positions simply due to the inertia of the installed bases they’ve already developed.  Service providers have found (or will find) a way to deliver these applications in cloud computing style, or small businesses will simply not move everything to the cloud very quickly.  It is really just that simple, and I’ll explain why.

QuickBooks-Hosting-WordCloudThe three things that each and every business does, and which they generally purchase computers and software to facilitate, are communicating, producing information, and keeping score.

1. Communicating is an essential need for every business.  Whether it is communication via phone, fax, email or otherwise, businesses will communicate and they will purchase products which help them do it better.  The standard for business email communications has become Microsoft Exchange, which is now available as a highly affordable subscription service from Microsoft or from a wide variety of commercial MS Exchange hosting providers.  Certainly the popularity and growth of hosted Exchange supports the argument that not only is MS Exchange mail very widely used in businesses of all sizes, but that it is also highly acceptable as a hosted solution because users retain desired functionality and are able to benefit from a variety of add-ons and additional services from their hosted Exchange email provider.  The other thing about hosted Exchange is that the user can still use MS Outlook on their desktop to get their mail.  Now we’re back to the desktop application again.  Regardless of what mail server and service the user has, they are often more attached to using Outlook than they are to the mail service.  In fact, when you ask a fairly non-technical user what they use for email, they’ll often say they use Outlook (the desktop client, not Outlook.com).

2. Producing Information is another essential need for every business.  Whether the information is produced for internal or external use, there is a lot of information created to inform various people about the business.  Documents, spreadsheets and presentations are used in every business, and productivity applications help people create them.  The standard in this area is Microsoft’s Office suite of products which includes Word, Excel and Powerpoint.  It isn’t unusual to have someone suggest “making a powerpoint to get the message across”, rather than using the word “presentation”, and does anyone expect to get a document not in .doc format?  When users ask for productivity products, they usually ask for Office software and they usually mean Microsoft Office suite products.

The broad use and proven suitability of these products has well established them as the standards for use in business.  While these applications are now available as limited-functionality web-based applications, most businesses continue to rely on the desktop products which resulted in myriad file sharing and “collaboration” tools which work with the Office products.  Microsoft recognized the value of having the feature-rich productivity applications available in hosted and managed service models (as hosted applications rather than true web-based apps), and made the products available for licensing and distribution via their Service Provider License Agreement (SPLA). Microsoft (direct and via partners) also offers Office 365, which provides licensing for Office desktop applications and/or hosted Exchange email services.

Hosts with cloud servers and managed infrastructure and VDI solutions are all facing this truth: their services are useful when there are applications running on them, and among the most frequently requested applications are the Office apps.  This is why so many providers offer not only cloud servers and virtual desktop solutions, they add value to their service by also offering the Microsoft Office products.  At least in the case of MS Office, service providers have recognized that certain fundamental applications must be present in order for the server or desktop to have value for the SMB customer.  After all, “moving the server to the cloud” doesn’t solve the problem if all the apps remain on the local PCs.

And then we come to the final application – the last fundamental small business application for service providers to focus on.  It is with this application that hosting companies will make real impact in moving their small business customers from local to hosted applications, virtual desktops, and the world of cloud servers and managed hosting.

3. Keeping score, or accounting, is the final absolute and fundamental business function which exists in every business regardless of size, type or industry.  This is another area where service providers are focusing, realizing that within the realm of small business accounting there is a single standard product line which serves the exact profile of the target SMB/SME customer: Intuit QuickBooks desktop products.

When challenged to find a single application solution which addresses a fundamental business need, is not oriented towards a particular industry segment, and which is likely to drive increased usage simply due to existing market penetration and sales – there is only one name that answers, and it is QuickBooks, most specifically the Pro, Premier and Enterprise desktop editions.

Looking further into the problem reveals that there may be more options for small business accounting emerging in the SaaS market, but this doesn’t help the hosting companies looking to increase usage on their own platforms.  Additionally, while new and emerging solutions may be introducing options for very small business, the activity actually serves to increase awareness of and usage of computerized accounting solutions, resulting in increased share of the market looking for and purchasing these solutions – increasing the overall market for SMB accounting products and providing an opportunity to sell QuickBooks solutions to those new users. Further, Intuit QuickBooks remains the dominant choice once the business has needs beyond simple invoicing and bill payment, and continues to see growth in product sales and distribution for this reason.

It’s also true that, once a business has itself “invested” in an accounting product, change is not something considered easily.  In many (most?) cases, the business is more closely tied to their financial systems than they are to their service provider.  If the provider can’t work with the software, the business is likely to seek services from another provider.

Moving everything but finance to the cloud is not an option for most businesses, either. Particularly with small business/small enterprise, there are generally systems which serve a broad business need and not a single function.  QuickBooks is not just a back-office accounting product.  It also provides some front-office functionality, such as storing general customer information, handling invoicing, inventory management, job costing and other functions.  It is essential that service providers not minimize the importance of this solution in their target client operation.

The financial system is not an island and is often integrated with or connected to other applications and data.  Even though the QuickBooks desktop products are designed to suit businesses up to 250 employees, it is unlikely that a business will have all 250 people running QuickBooks.  Rather, the product may be used by 2 or 3 people in the accounting department, or possibly by up to 30+ users in an Enterprise deployment where the product serves more operationally oriented functions.  The rest of the company is likely using MS Office and email as suggested earlier, and perhaps some other operational or business specific product which may integrate with QuickBooks.  The point is that it’s unwise for service providers to minimize the importance of the financial software and systems, even if those solutions are used by only a very few of the total number of users within the organization. 

More evidence suggesting that the name QuickBooks has become almost synonymous with  small business bookkeeping is visible within the accounting and bookkeeping industry, where bookkeeper training programs focus as much on the QuickBooks product (if not more so) than on actual accounting fundamentals.  Businesses hiring bookkeepers don’t ask for bookkeeping experience, they ask for QuickBooks experience.  If a small business owner asks his accountant what product to use, it’s a good bet that the accountant will recommend, and possibly even set up, QuickBooks for the client.  There is momentum there which cannot be argued with, and it represents significant opportunity for those who have platforms to run the stuff.  Weirdly, QuickBooks desktop editions and other desktop-based financial products available in a cloud hosted model represent a last and final element which is driving broad adoption of cloud servers and hosted desktops within the SMB markets.

It is all about the apps, but not just any apps.  It’s about the apps small businesses need, want, know, and currently use.  Service providers who can offer their customers these applications as cloud service – as managed applications on a cloud server or VDI platform – are in a position to serve the broadest base of SMB/SME customers. Talk about addressable market… at that point, it becomes a simple function of exposure as the value proposition is undeniable (and barrier-free).

Joanie Mann Bunny FeetMake Sense?

J

Posted on

What Small Businesses Need To Know about QuickBooks and the Cloud

With all the talk of cloud computing and having remote access to business applications and data, many small business owners are finding themselves searching for the answer to cloud-ifying their tried-and-true QuickBooks desktop software.  At first view, most business owners get the impression that their only viable choices are to either move up or down the product line – downgrading to QuickBooks Online Edition, which lacks the features and functionality they’ve come to expect from QuickBooks, or upgrading to QuickBooks Enterprise Edition, the only version Intuit visibly supports on terminal servers and which is far more expensive than the Pro or Premier editions.

It is surprising how many accounting or even IT  professionals don’t understand the real options available to their small business customers wanting to move entirely to a cloud-based IT strategy, particularly when it comes to QuickBooks.  This is no fault of the IT guy or accountant – unless they’re specializing with QuickBooks, there are some options they are simply not being made aware of because it isn’t where Intuit is focusing its marketing efforts.  Intuit wants businesses to buy QuickBooks Online.  The market, on the other hand, likes the QuickBooks desktop products and wants them in the cloud.  The well-kept secret is that businesses can have their QuickBooks desktop editions in the cloud and it works the same way as it does on the desktop.

Hosted QuickBooks isn’t rocket science; it’s simply a method of installing QuickBooks desktop software on servers and making the solution available to users via the Internet.  Many business offices are already doing this type of thing without really recognizing it – accessing the office PC via a Remote Desktop connection so they can work on their QuickBooks or other applications from home.

A QuickBooks hosting solution is essentially the same thing: QuickBooks software and the company data exist on a computer in a data center, and the user connects to that computing environment, application and data via a remote connection.  Most providers use the same underlying technology (Remote Desktop) to deliver their hosting services that users deploy in their own offices – they just use “bigger” versions of it and sometimes a little extra technology with it to help out.  The point is that Remote Desktops and hosted applications are not new or bleeding edge technologies; they are a proven means to effectively and efficiently deliver seamless remote access to computing resources (environment, apps, data, etc.).

Perhaps the weirdness surrounding the QuickBooks licensing is part of the problem; I’ve seen this confusion prevent businesses from running their QuickBooks on remote systems simply because they could not figure out the right way to do it and still conform to licensing rules.  Consider that QuickBooks is essentially a single-user application, and it’s the database manager that really allows concurrent multi-user access to a data file.  The program was not designed to have multiple users of the PROGRAM all running from one computer concurrently (which wasn’t a problem when only one person at a time used a computer).

But these days, with terminal servers and remote desktop capabilities, a single computer is essentially turned into a box containing a bunch of user environments (call them desktops, sessions… whatever).  Each of these user environments (desktops/sessions) are running at the same time and on the same computer.  So, when a user goes to launch QuickBooks and then open a QuickBooks company file, the database manager looks at the computer running the QuickBooks license and says “ok, you have a license to allow QB to access a data file with one user”.  When the next user launches QuickBooks from that machine it will allow them to open the program, but if they try to connect to the same data file as the first user, guess what?  QuickBooks database manager looks at the computer and license and sees the same single-user license number coming from the same computer.

A single-user license means only 1 user can access the company file concurrently (at the same time).  So, if two or more people are on the same terminal server (remote desktop server), and are trying to access the same company data file concurrently, the QuickBooks license on their terminal server must be at a level that allows all of them to access the company file at the same time, e.g., a 2- or 3-user license.  This is not intuitive.

Another issue relating to QuickBooks licensing on a terminal server or remote desktop setup is the fact that it’s a really awesome method of giving more users access to QuickBooks than you legally should.  This is an unfortunate technical reality of the product, and is possibly an issue which influences Intuit’s lack of support of the product in this type of environment.  While the licensing language and the operation of the database manager indicate that each user running QuickBooks should have a license, the technical reality is a bit different.

The technical reality is that a single QuickBooks license installed on a terminal server could possibly be actively used by any number of people on that server – all at the same time – as long as those users don’t try to open the same company file at the same time.  Of course, this is in direct violation of the license agreement and is essentially a situation where a single QuickBooks license is being unlawfully accessed by more users than it is licensed for.  Intuit does not approve of this model as it falls into the category of software piracy, but I sure see a lot of accounting firms applying it for client QuickBooks access. (It’s often a statement about how, as a ProAdvisor, the accountant gets their license each year, installs it on the terminal server, and magically all clients now have access to the new edition!).  **Note to self: if your service provider or accountant gives you “free and automatic” upgrades to QuickBooks each year, you may want to look a bit further into whether or not the licensing is actually legitimate; the risk to your business books isn’t worth avoiding a $249 investment**

Another thing that often prevents businesses and their IT people from moving QuickBooks to a hosted solution is the lack of available support.  While Intuit says that they support QuickBooks Enterprise in a terminal server environment, there is no such offering for the Pro and Premier editions.  In reality, this doesn’t mean that the solutions won’t work, because they will.  It simply means that Intuit won’t support the installation directly.  Perhaps this is the best and most evident reason to work with an authorized QuickBooks hosting provider.  Particularly when it comes to your business accounting and financial data, it makes sense to make sure it is running in a supported environment.  There are few things as frustrating and potentially damaging to business than losing customer, vendor and accounting information.  Let us still be realistic about this, though.  QuickBooks was not designed to run on a terminal server, and its behavior and performance may not be flawless.  In most cases, however, any tradeoffs are easily weighted towards the benefits of mobility, security and IT management.  You get glitches with QuickBooks even on a local PC, so occasionally experiencing them with QuickBooks in the cloud should be expected.

Small businesses need help with their information technology, particularly as even simple to use solutions like QuickBooks continue to get more technically complex (simple to use often means there’s a lot going on behind the scenes).  And small businesses want worry-free IT, so they can focus on running the business and not on running computers.  For these reasons and more, the small business owner and the IT person serving small business should take a close look at hosting their QuickBooks desktop software – along with their other business applications – with a trusted cloud hosting provider.  Yes, you can have your QuickBooks in the cloud.  Today.

Make sense?

J

Posted on

Remote Access to QuickBooks – a free report from the author of Radically Simple Accounting

Remote Access to QuickBooks – a free report from the author of Radically Simple Accounting

Radically Simple Accounting

Madeline Bailey, author of the book Radically Simple Accounting, is offering a free report on Remote Access Options for QuickBooks.

The free report provides details and simple explanations to help every QuickBooks user or consultant understand how best to leverage the Internet to work when, where, and how they need to.

Cloud computing and the Internet have introduced both challenges and opportunity for QuickBooks users and those who support them.  Madeline’s report provides real-world information, links to live services, pricing, and personal evaluations that anyone looking at remote access options will find useful.

Everyone’s talking about remote access and QuickBooks, but the options are so plentiful and confusing that only a few have made the move.  For those still wondering what solutions will work best for them, this report may clear things up a bit.

Joanie Mann Bunny Feet

Make Sense?

J