Remote access to client bookkeeping comes in many forms because clients come in many forms

There are a lot of conversations in LinkedIn and other groups, where bookkeepers and accountants are discussing their various methods of accessing client QuickBooks data and applications remotely.  While these conversations are quite helpful for some folks, there are others out there that simply get confused due to all of the possibilities.  There are many ways to work remotely with QuickBooks clients, and there are a lot of different situations where one approach may work better than others.

The key to remember here is that REMOTE ACCESS MATTERS.  Time and distance is the enemy when it comes to outsourced bookkeeping, and whether you like visiting your clients or not, having remote access to their data can be the key element in providing the highest level of service and value possible.  Remember when PCanywhere became available, and we were all excited because now we could use a modem to dial directly in to the client PC?  OK, maybe I’m talking to a crowd that’s too new to remember that excitement, but believe me, remote access is something all outsourced accountants and bookkeepers have been looking for.  Now that really good options are available (a lot of options), it makes sense to get a better understanding of what you can and can’t do with various remote access approaches.

First, when you’re looking at any true SaaS solution (true being a relative term, but here we mean an app service that was built for the web and is offered as a subscription model), consider that the solution exists only on the web, and that when a business subscribes they are generally subscribing to a single company data set.  Unlike QuickBooks desktop, for example, where you can have numerous company data files, QuickBooks Online and other SaaS solutions generally build a single company data file associated with the subscription.  When you want to access different companies, you may have to log in as a user of the company you’re accessing.

If you’re an accounting professional, there may be an edition or approach that allows you to connect to multiple client accounts, but then again, there may not be.  So be prepared to have to log in as each individual client to access their data.  When this becomes the situation, what’s the difference between one client having QB Online and one using Xero, Wave, FreshBooks or Kashoo?  None, really, other than the fact that you need to get to know all of the solutions a bit.  As a bookkeeper or accounting professional, this shouldn’t be so much of an issue, as debits and credits and basic accounting theory doesn’t change with the accounting software (basic “accounting theory” isn’t really available for redefinition).

The other thing to recognize about these solutions is that the data belongs on the web with the app, so it’s not like you’ll be copying the data file to your PC to work on.  You might export the data to another solution, but you won’t be using the SaaS solution offline.

If the client isn’t using a SaaS solution, then it is likely a desktop solution, where the application is installed on their local PC.  This type of solution – QuickBooks desktop editions being the most popular and easiest example to work with – gets installed and runs from the PC.  Data may be stored on the PC or on a network hard drive, but the program is running locally on the user’s computer, and is using resources on the local computer (memory, processor, etc.).  There are only a few ways to make this type of application into something you can access remotely, and one of them is by using a remote control approach.

Remote control is where one computer connects to and controls certain aspects of another.  This is like the old dial-up approach, using PCanywhere-type applications to control one computer from another.  These days, the Internet rather than a dial-up phone connection is the preferred method, and there are web service providers which “broker” the connection and communication between computers, providing added features and layers of security.  Using a remote control solution (examples are LogMeIn or GoToMyPC) simply allows the user on one computer to control the keyboard and mouse, and view the display, of a remote computer.  It doesn’t matter what is running on the remote, so a bookkeeper could use this approach to access a client PC and QuickBooks desktop applications and data, or even to connect with the client so they can log in to QuickBooks Online or Xero together.

Some bookkeepers work with their clients, showing them how to do things and connecting to client resources in order to get work accomplished.  Others connect using their own resources or accounts, and work concurrently with the client.  Still others may export data from the client solution into their product of choice, not even working within the client application at all except to make adjustments and data exports.  It all depends on the collaboration model you and the client have going, and it is unlikely that any single model or approach will work for the entire client base.

QuickBooks hosting introduces a bit of a wrinkle in the concept, but not much of one.  Really, hosted QuickBooks desktop editions should be viewed to be not less and not significantly more than a QuickBooks Online or other SaaS approach.  If the client would benefit from working online (most client would), then having them host their QuickBooks desktop applications and data with a hosting provider makes sense.  However, just because the client is hosting their QuickBooks doesn’t mean that you should immediately assume that you’ll have access to their applications or data.  Like with a SaaS solution, you’ll likely have to have an account to log in with, and that account could be a separate login allowing you to work at the same time as the client, or the account could be one that is shared with the client and where only one of you can log in at the same time.

Since a hosted solution is accessed online just like a SaaS solution is, you don’t have to have the software installed on your own PC, and you only need an Internet connection to access the application and data at any time.  A major difference of working with a hosted solution is that you could possibly have the application installed on your PC, and could copy the data from the host and work on it offline.

With all of the options available, accountants and bookkeepers have realized that the selection of client collaboration approaches depends on a number of factors, and that professionals may end up applying an unlikely combination of solutions in order to address meeting various client preferences as well as their accounting needs.

Make sense?

J

Read more about hosted QuickBooks desktop editions

Read about the race to find the secret sauce of hosted application services for small businesses

QuickBooks SDK Integrations, Cloud Hosting, and the Customer Relationship

QuickBooks SDK Integrations, Cloud Hosting, and the Customer Relationship

Intuit QuickBooks desktop editions are the most popular small business accounting software products on the market, boasting somewhere in the neighborhood of 3.5M users.  In contrast to the QuickBooks Online Edition, which has approximately 300,000, desktop QuickBooks still reigns supreme with small business.

While QuickBooks satisfies most of the general business functionality required from a general accounting product, it doesn’t address much else.  For this reason, numerous software developers have created the software products – the extensions, integrations, widgets, and tools – that make QuickBooks more useful to the business.

The sheer popularity of the QuickBooks product line has supported the creation of a very large and diverse community of developers who make things that work with QuickBooks.  However, as with any attempt to bring like-minded people together, the QuickBooks developer “community” is not all-inclusive, and there are lots of ISVs (independent software developers) out there who aren’t communicating with Intuit frequently, and who aren’t necessarily exposing their solutions through the Intuit marketplace and other Intuit-branded venues.  In many cases, these are developers who have line-of-business solutions that represent the operational priority for their business clients, and where the integration to QuickBooks financial is somewhat of an after-thought.  In many cases, these solutions rely on QuickBooks only for general back-office account functions, where the GL, AR and AP are all that really matter.  The “tough stuff” is done in the line-of-business application.

Most of these types of solutions, as well as many with more complicated functionality or data integration requirements,   utilize a method of communicating with QuickBooks developed using the QuickBooks SDK, or software development kit.  This SDK was originally introduced as a means to replace the clumsy IIF import facility, an early way to get data into QuickBooks from other systems.  The SDK is really a tool kit designed to facilitate desktop application integrations, which is why so many developers use this method.  Particularly when an application is intended to be used on the desktop in conjunction with QuickBooks, it makes sense for developers to use an integration method that will allow them to produce the rich experience and seamless re-use of data that the desktop environment allows.  The SDK requires that the QuickBooks program be present, and QuickBooks controls access to the data file rather than allowing the 3rd party application to have direct data access.

The new method for integrating with a QuickBooks application is by using the IPP (Intuit Partner Platform) method, which is essentially an API (application programming interface) which simplifies the creation of data streams to and from the QuickBooks database.  This method of integration is intended to be serviced by the Intuit Sync Manager (included with QuickBooks), where your data first syncs to Intuit servers, and then connected apps sync from that source.  In this case, Intuit acts as the intermediary, hosting the synchronized data and controlling the sync with the QuickBooks database.  While this may be much easier in terms of offering stricter standards for QuickBooks data integration, it is not a method which addresses the needs of those solutions requiring an integrated experience involving QuickBooks programs and data, or which have more complex data integration requirements than may be served through the IPP.

Because the QuickBooks SDK has been around for many years, it allowed for very stable QuickBooks-integrated solutions to be developed.  In comparison, the IPP is pretty new and has taken Intuit a few tries to get working.  For this reason, there is a limited catalogue of solutions available in the Intuit App Center, which is where IPP solutions are promoted.  Moving forward, Intuit has stated that the focus will remain on the IPP, with the SDK no longer being a preferred (or supported) method.

The method of integrating with QuickBooks desktop editions matters, especially if you’re looking to bring your business applications to the cloud.  Application hosting services is the way to “cloud-enable” desktop solutions, yet not all hosting providers recognize or understand the differences in how applications might integrate with QuickBooks, and what that means to the technical and user environments.  Not all applications are created equal, and not all QuickBooks integrations are, either.  Some integrations sound simple enough to implement, yet have hidden requirements that make deployment with a host or outsourced infrastructure provider an interesting endeavor to say the least.

Developers using SDK integrations with QuickBooks should make certain that they have thoroughly discussed their solution requirements prior to deploying their applications with any host, particularly with a client-selected provider.  Companies experienced in hosting QuickBooks are not necessarily adept at understanding the nuances of SDK-developed integrations, and may minimize the technical requirement to the point of leaving your company and your customer with a bad feeling about hosting.  In worst-case scenarios, the software developer loses their customer altogether due to a poor experience with the solution in a hosted environment.


Cooper Mann Consulting
 is working to help developers and commercial ISVs with QuickBooks-connected solutions get their products to the cloud, and in a way that they can influence and help control the all-important customer experience.  Rather than being just one of a few hundred hosted products customers can select from the provider menu of offerings, we believe your solution should be delivered with your values, your message, and your unique service approach.   Doing so allows you to keep your arms firmly wrapped around your customers and users, working closely with them as you develop your solutions towards a true SaaS or cloud application model, and easing the transition from desktop to web application delivery and subscription service.

Intuit believes they own the relationship to all QuickBooks customers, and they’re right to the extent that the user relies on QuickBooks for some business functionality.  Hosting service providers think they own the customer relationship because they have significant influence over the products accessed from their servers.

Operational support solutions go deeper into the business than any high-level accounting product, and the method of deploying the solution (locally installed or hosted) is an IT issue and nothing more.  As a developer or provider of essential solutions which address specific vertical industry or line-of-business needs, and as the company who understands the business of your customer and supplies those solutions that help them perform, don’t you really think you should own that customer relationship?  We do.

Make Sense?

J

Want to know more about how Intuit is changing their approach to QuickBooks integration?  Read Charlie Russell’s rant: Is Intuit Abandoning QuickBooks SDK Developers?

Read more about QuickBooks cloud hosting: Cloud Hold-Out No More: QuickBooks Desktop Editions in the Cloud

Read more about cloud development: Lessons Learned (or Not): Development and the Cloud

Read more about legacy application modernization, and why IT and back-office outsourcing makes sense for a lot of reasons 

QuickBooks Hosting Services and Accounting Professionals

The value of applying an application hosting model for your clients

The concept of application hosting is not at all new.  In fact, there are literally millions of business users accessing hosted applications and similar services every day, and adoption didn’t reach those numbers overnight.  For several years now, Intuit (the makers of QuickBooks financial software, among other things) has even had an “Authorized Commercial Host for QuickBooks” program.  If Intuit recognizes the value of a hosted application service model, then there must be something to it, because Intuit rarely does anything unless it’s big.

The value of application hosting services, such as QuickBooks hosting, may differ from business to business, but the underlying benefits are there for all to achieve.  For some, the main value is in being able to access business information and data while traveling.  Using mobile devices, business users are able to get information on customers, orders, payments, and other valuable data – from anywhere they choose to work.  Being able to keep tabs on the business even when they aren’t there is very important to some business owners.

For others, the value of application hosting services is the collaboration that it enables.  With public accounting in particular, the client business and the accounting professional do not work at the same place at the same time.  Being able to work on the same software and data, and doing that work at the same or different times (it doesn’t matter when or where they work) allows business owners and their accounting and bookkeeping professionals to work seamlessly together in support of the business.  This online model allows the business owner to benefit from better financial data in real-time, rather than waiting for the work to be done after the fact, at the end of the month or year.

The underlying benefit that all parties get from a hosted application and online working model is better information technology management and greater predictability in IT service costs and capabilities.  Businesses need to be able to focus on their business and not on the IT which supports it, and outsource professionals such as accountants and bookkeepers need to be able to work with clients efficiently without having to invest in expensive tools and services to make it happen.  A hosted application approach, when applied to the client business, delivers many benefits to the business owners while at the same time providing tangible benefits in efficiency through more effective time management and improved access to information for the professionals who support those businesses.

When developing a working model for outsourced bookkeeping, accounting, or virtual CFO services, it is essential to recognize that businesses need technology to support their operations, and there may be “line of business” solutions in use as well as accounting or financial software.  Too often, outsource bookkeeping and accounting professionals focus only on the accounting or financial systems, and fail to consider the critical aspects of the operational level applications which support the various functions of the business.   With a hosted application approach, the business solutions in use can be “enabled” – from operational solutions to accounting and finance supporting applications – so that accounting professionals may gain access to the complete realm of business data, putting them in a far better position to ensure that the information resulting in the accounting system is of high quality and may be trusted.

Make sense?

J

Read more about Accountants and Bookkeepers Working With QuickBooks Clients: App Hosting Approaches That Work

Accountants and Bookkeepers Working With QuickBooks Clients: App Hosting Approaches That Work

Accountants and Bookkeepers Working With QuickBooks Clients: App Hosting Approaches That Work

Ever since the first application service providers began offering hosting services for Intuit QuickBooks desktop products, the idea of running desktop editions of QuickBooks in the cloud has created both intrigue and confusion among accounting professionals and their clients alike.  Part of the problem is the term “cloud”, which seems to equate the hosted QuickBooks desktop editions with the true cloud app QuickBooks Online Edition.  But hosted QuickBooks isn’t QBOE, it’s a service model developed around the actual desktop versions of QuickBooks: Pro, Premier and Enterprise.

While it is true that both solutions – hosted QuickBooks and QuickBooks Online Edition – offer centrally managed and accessible online accounting functionality, the underlying services are very different and operate under completely different “rules”.  One of the rules, or conditions, which differs between the two solutions is that with hosted QuickBooks service, you may also be able to run other business applications and manage other business data, not just QB apps and data.  This is an essential capability when you consider that QuickBooks desktop software integrates with and takes advantage of functionality found in other popular business solutions, such as Microsoft Office.

In many QuickBooks hosting services, the inclusion of Office app hosting is typical due to the reliance upon functionality in those solutions (Excel reporting, Word letter-writing, and Outlook emailing).  When it comes to other tools or application integrations, however, customized hosting service becomes necessary.   When the need for additional applications or integrations arises, consideration should be given to the best way to orient and implement those add-ons.

For example, if a client business has a heavy reliance upon a solution which integrates with QuickBooks, and uses the solution to handle daily tasks in the business, then it makes a lot of sense to create a hosting environment specifically for that client.  The client would be able to access their unique set of solutions, and the accounting/bookkeeping professionals can be invited to participate in that system.  This keeps the data in one place, managed and controlled, yet allows all parties who need access to get access.

In other situations, there may be a tool or utility necessary to help get data from one place to another, and this tool or utility is not something the client uses in their daily work.  In this type of scenario, it may make sense for the accountant/bookkeeper to have a customized environment which allows them to use the tools and solutions which assist in data integration, organization, validation or review.  In many cases, the accountant or bookkeeper may perform these data integrations or sync operations directly in the client data file, so that the client (using “generic” service with just QuickBooks hosted) is able to then access and view the integrated data.  In this scenario, only the accounting professional has the additional tools necessary, allowing the cost of hosting for the client to remain lower.  Approaching a hosting environment in this manner might allow the accounting professional to develop a niche or customized approach to serving a specific type of client, incorporating behind-the-scenes data aggregation or integration and other types of process support as part of the overall service delivered.

The key to developing the right application hosting and outsourced accounting service model is to focus on how the practice will use the hosting solutions to improve service and process efficiency, serve client needs better and more fully, and differentiate themselves from their competitors in the market.  By applying the hosting service and online solution properly, business clients and the accounting professionals who support them will both benefit by getting the information and the application functionality they need, when they need it.

Make sense?

J

read more about the confusion over hosted licensing on The Progressive Accountant http://www.theprogressiveaccountant.com/tech-tips/confusion-over-hosted-licensing.html

Knowing Your Options: Hosting QuickBooks for Shared and Remote Access

Intuit’s QuickBooks financial applications, the desktop editions in particular, are the most popular small business accounting solutions on the market.  The QuickBooks Online Edition, Intuit’s cloud-based contender, is not quite as accepted among accountants and advisors for a variety of reasons.  Being in the cloud isn’t necessarily one of those reasons, if you consider the growing demand for access to multi-user cloud-hosted QuickBooks desktop editions.  Mostly it comes down to functionality and how the application operates.  QBO just isn’t like good old desktop QuickBooks and isn’t the preferred solution for many financial professionals or their clients.  Yet these users still want and need remote access and mobility.  This is where hosting comes in.

QuickBooks hosting and creating the ability to access QuickBooks applications and data remotely is something that a lot of businesses can benefit from.  Whether it’s to outsource the management and maintenance of servers and systems to a 3rd party, or to create the ability for remote workers or contractors to collaborate with real-time applications and data, there may be a need for a hosted application approach.  Business owners and IT managers need to give consideration to the level of service and support they and their users will need before selecting their provider.  Knowing what the provider will handle and what the subscribers are responsible for might make all the difference in determining the right approach.

In-House DIY Hosting

Local networks and PCs allow users in the same location to share resources, like printers and data storage locations.  Typically, desktop computers have application software installed on them, and use the network to access shared data.  When users work outside of the network, getting access to applications and data might not be so easy.  Even extending the network via VPN access doesn’t solve the problem when the desktop applications are not designed to access data over remote connections (desktop applications like QuickBooks).  It used to be that the only reasonable way to allow remote users to access and run QuickBooks as if they were inside the LAN was to set up remote desktop or application servers (terminal servers).  MyQuickCloud is a product that addresses this need very gracefully, providing in-house personnel with the tools necessary to establish a secure cloud for QuickBooks access directly from existing on-premises systems.

Co-location and Outsourced Infrastructure (IaaS)

Instead of setting up remote access solutions in the office, many IT departments find that co-location with a 3rd party addresses a number of issues.  Leasing equipment, operating system and virtualization tools may be more cost-efficient than purchasing them directly, and the security and redundancy in most hosting facilities far exceeds what most businesses are able to afford to implement by themselves.  Co-location provides managed service for infrastructure elements, but doesn’t necessarily address business needs in terms of user security or application and data management.  These elements are traditionally left up to the subscriber; installing and configuring software applications, establishing user and application permissions, and managing updates and software upgrades.  For this reason, co-location may be a good option for a business with internal IT staff, but not necessarily for businesses seeking “full service” application hosting.

Application Service Providers (ASP) and Managed Application Hosting

Application hosting service providers handle software installation and management, user and security administration, and ongoing technical support as part of the subscription service.  Customers need only to provide their software licenses, name users and upload data in order to use the service.  The service provider does the software installation and configuration, sets up the users and establishes permissions, and connects users and applications to managed data storage.  This model allows businesses to enjoy many of the benefits of a cloud-based or SaaS solution model while also allowing them to continue to use software solutions they are already invested in, in terms of both software licensing and process development.  On the other hand, these models can be extremely restrictive in terms of the applications or integrations they will support, and can be quite costly as the number of users or applications hosted increase.

Whether you roll your own (DIY hosting) or work with a full service QuickBooks host, accessing business applications and data from anywhere is an option every business can take advantage of.

Make sense?

J

Read about the race to find the secret sauce of hosted application services for small businesses

Cloud Hold-Out No More: QuickBooks Desktop Editions in the Cloud

When most people hear the words “QuickBooks” and “online” together, they think of the web-based solution from Intuit called QuickBooks Online Edition.  And why wouldn’t they?  With the media, industry talking heads, and everyone in information technology discussing cloud this and cloud that, all the attention is going to web-based applications, Software-as-a-Service models, and cloud platforms.  While these approaches to business software distribution and delivery are working for a lot of software vendors and their customers, there are a few hold-outs that may be keeping a lot of folks from considering that move to running their businesses “in the cloud”.  Intuit QuickBooks desktop editions used to be among this list of applications securely anchored to your local PC, but not anymore.

The desire to have remote and mobile access to business applications and data goes beyond simply getting email or syncing contacts to a mobile phone these days.   Business people in all industries are seeing the benefits of using wireless and mobile laptops, tablet computers and smartphones to handle tasks in real-time rather than accumulating paperwork, spending a bunch of time organizing and keying in data, and then submitting the information for batch-processing after the fact.  And, with services being seamlessly connected and information being shared and integrated for a variety of reasons, internet connectivity has become almost as essential to most businesses as telephone service. (Actually, in many cases, telephone service IS delivered via the IP network, so maybe that statement doesn’t make as much sense as it used to.)  Payroll isn’t calculated in the software, it’s calculated by a service online and delivered through your software.  Same with banking, accepting payments, and paying bills – many are processes handled through the software but perhaps not actually happening WITHIN the software on your PC.

As users have begun to realize that, whether they mean to or not, they are essentially “on line” with their business applications and data at some level, the consideration for outsourcing more of their IT operations and working more fully in an online model might not be so bad as long as they don’t have to give up the functionality, usability, and cost-efficiency they have come to expect with their beloved business applications – like QuickBooks.

Service providers recognized this opportunity and developed business models which would give users their desired desktop applications (like QuickBooks!), but in way that seems more like a cloud service.  As platform and virtualization technologies have evolved, businesses are finding that there are numerous options, and numerous providers, for getting their desktop and network applications installed in the “cloud”, and delivered back to them as a managed subscription service.  It is a model which is growing in popularity and demand, and it makes sense.

Small businesses in particular are moving to the cloud not because they are generally dissatisfied with the products they currently have (there’s a reason Intuit has market share with QuickBooks; there are a LOT of QuickBooks desktop lovers out there).  Small businesses are making the move to online and “cloud” models because of the business benefits of getting information when and where they need it.  Mobility is driving the cloud, and the cloud is driving software makers to change how they do things.

It will be a while before all the investments are made and man-hours are spent to rewrite or redevelop applications to run on these new platforms and in this new cloud-based service model.   In the meantime, ISVs will look to hosting providers of various sorts to help breathe longevity into their solutions while securely embracing their customers and market in preparation for a cloud-based service delivery, and customers will engage with service providers who can supply them with the legacy application hosting and management they require to achieve the level of freedom, access, and mobility they demand.

Make sense?

J