Category: legacy application modernization

Posted on

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

Posted on

The True Cost of the Cloud

The True Cost of the Cloud

Excerpt from article on Intuit Accountants News Central: The True Cost of the Cloud

“Accounting professionals are strongly encouraged to adopt cloud computing models in their practices, and there can be little argument that mobility and access are driving the need. In concert with the messages supporting mobile access to business information – and the value of anytime, anywhere access – cloud service providers are strongly suggesting that the overall cost of purchasing and maintaining information technology (IT) in the business is much lower when a cloud computing approach is used.

Arguments over the total cost of IT and related services become somewhat subjective. Many business owners and managers fail to consider the value of their own time spent dealing with business technology issues, much less the time spent by in-house employees and remote workers. To further complicate the issue, dramatic changes in process support and delivery, connected service and cloud computing approaches are impacting business productivity and profitability in new and dramatic ways. As a result, every business should consider the costs and the benefits of this new connected and collaborative working model.

At the core, cloud computing is really just an outsourced IT service that addresses the various levels of application and computing infrastructure. From IaaS (infrastructure as a service) to SaaS (software as a service) and all things in between, a viable cloud computing approach for a business may encompass little more than co-location of physical server and network resources with a third-infrastructure provider to something much larger scale, such as offloading virtually every aspect of application management and delivery to a SaaS solution.

Because there is no single, correct definition of what makes up a “cloud” service model, attempting to compare costs directly to a more traditional IT approach is quite complicated.”

Read the entire article at Intuit Accountants News Central

http://blog.accountants.intuit.com/ways-to-grow-your-business/the-true-cost-of-the-cloud/

Posted on

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 

Posted on

Accountants and Small Manufacturers

rollingballGetting in Front of the Ball

There’s a lot more to accountability in a manufacturing or inventory-based business than simply keeping track of money in and money out.  Particularly in an economy when nobody can afford to build or stock products too far ahead of demand, it is essential that these businesses have a means to not only track and manage purchasing, manufacturing, distribution and stocking activities, but to understand conditions or trends which impact the flow of materials and cash through the business.  Further, this understanding must come in a timely manner in order for the business owner to make decisions and take action when it matters most.  Unfortunately, many business owners find themselves “behind the ball”, constantly pushing to make forward strides, and often due to not having the information they need to make business decisions that matter now, today.

Why is it so critical for these businesses to have more and better information to help them make strategic decisions and answer daily operational questions?  In a word: connectedness.  The Internet has truly made the world smaller when it comes to participation with even the smallest of local businesses.  Globalization of markets has impacted manufacturers in significant ways, and these businesses (like so many others) must now be prepared to address the realities of global supply chains, outsourcing, and a remote or mobile workforce and market.  While many of the software solutions addressing the functional business requirements of manufacturing and inventory or warehouse management are “locally implemented” solutions, extending and integrating these solutions to address the new global and mobile paradigm may represent a significant expenditure in time and resources for the small enterprise.

Application hosting and web-based solutions have emerged to help businesses address the need to “modernize” legacy applications and enable greater levels of system management and access.  Introducing the applications into a centralized and remotely accessible environment allows the business to immediately deliver the necessary support for remote work and mobile access, and positions the system to facilitate collaboration within the business and with outside participants, such as outsourced bookkeepers, accounting and finance professionals.

These professionals can be instrumental in assisting their clients manage the change to new collaborative computing paradigms.  Where accounting was previously viewed as an after-the-fact process, accountability through detailed activity tracking and reporting is now a focus which begins at the front end of the business, and accounting professionals are finding far greater value in helping structure and manage this daily activity in order to deliver greater operational information and insight.  Rather than being the last people to know what is happening in the business, accounting professionals are recognizing that their ability to positively impact business performance requires getting “in front of the ball”, initiating process structure, data control and collection which ultimately results in better and more informed decision-making through better and more timely access to more meaningful information.

Businesses at all levels are realizing that new computing paradigms can ease the burdens of collecting and sharing information, yet most small companies need help in determining exactly how to approach this “enabling” of the business and systems.  While accountants are also experiencing dramatic change in how they do business, it makes sense for them to embrace the opportunity and recognize that enabling client systems will ultimately allow the accounting professional to work more closely and to deliver more tangible value to their client on an ongoing basis.  Online accounting approaches are no longer a fad but are the new reality supporting how many bookkeepers and accountants work with their business clients.  Extending access beyond accounting and bookkeeping systems, and incorporating support for operational and line-of-business solutions, is the next step which will bring the accountant closer to the client business, and position both to benefit from deeper collaboration and useful insight.

Make Sense?

J

Posted on

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

Posted on

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