Tag: seamless integration

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

The Collaborative Online Model for Small Business Accounting Professionals

Accountants and bookkeepers serving small business clients are facing a growing problem – how to provide services that are valuable to the client in a way that makes it profitable for the provider.  Part of the problem is that small business, while they need quality accounting and bookkeeping services, have a hard time paying for it unless the person doing the work is sitting in the office producing tangible reports and paperwork all day long (and maybe answering the phone while they’re at it).  Accountants and bookkeepers working with a variety of small business clients can’t be profitable when they have to travel to client offices to do the work or pick up and deliver files and paperwork, and they certainly aren’t expecting to be the office receptionist while they’re there.

The solution for both is an online working model, where the outsourced professional and their client can both login together.  Each accesses the applications and data to get their work done, and is able to access when and where they need to.  Online accounting approaches help service providers increase their profitability at the same time they increase their level or range of service provided to clients.  With a collaborative online accounting model, professionals and their clients can work from anywhere at any time, giving both the freedom to focus on what needs to get done.

This doesn’t necessarily mean that the bookkeeping or accounting solution has to be an “online” service, per se.  Looking at the accounting product alone isn’t often the best way to solve the mobility and managed service problem for the client, which is really what “online” for the client is about.  The fact that their service providers (accountants, bookkeepers, etc.) can also work in the system is of secondary benefit to the client.  The worst thing an accounting pro can do is tell their client they have to switch accounting solutions just to make it easier for the accountant or bookkeeper.  It makes sense to improve that situation, but accounting/bookkeeping isn’t generally the entire IT requirement for the business client.

An online working model enables collaboration with team members and providers alike.  Reducing or eliminating the requirement for sophisticated technology solutions is the key element, providing everyone the ease-of-use and security of server-based computing.   The real benefits include centralization of business application management, protection data resources, and the ability to more fully streamline business processes.   For many businesses, the earned benefit is increasing the capacity to do business profitably simply by making the current working model much more efficient and effective.   The benefits are there for both the client is collaborators to experience, and this is where the focus should be – on the benefit to the small business.

Accounting professionals can also seamlessly increase their own opportunity and value by embracing a collaborative online working model.  Through the use of outsourced bookkeeping, payroll services and other providers, accountants can increase or expand the services they offer to clients by seamlessly incorporating them into the overall offering.  An online approach makes this possible, and can position these valuable services as the key to client business success. Working online together, professional service forms and their contractors or outsourcers can work closer than ever before, and the accounting professional is positioned to deliver far more value to the business client.

An online working model improves the profitability of the professional practice, too. The movement of information from one place to another, the restructuring of information from one form to another… these are processes that represent the cost and inefficiency in the professional accounting office.  By working online in client accounting solutions along with the client, firms can reduce or eliminate redundant and time-consuming work that is the bane of the practice. Bookkeeping, property tax compliance work, payroll, HR and benefits administration – these are areas where outsourcing may make the most sense for the practice while enabling accountants to increase the overall value of service provided.

Does your professional practice offer valuable business services like these for your clients? Profitably?

A collaborative online working model can enable your firm to deliver the range of services business clients need most while improving the bottom line for both.

Joanie Mann Bunny FeetMake Sense?

J

Posted on

Getting out of IT Jail

Getting out of IT Jail

I have a friend in the accounting/technology industry that spends way too much time on his business in-house IT.  He’s always futzing around with servers and workstations, fixing corrupted data files or PCs that won’t launch applications, and setting up remote access so he can work at home (which he never actually does because he’s at the office fixing IT issues).  More often than not, when I try to get time to chat with the guy, his response is “I’ll have to call you later; I’m in IT jail”.  As a side note, my friend is Doug Sleeter, a recognized leader in the world of small business accounting and among QuickBooks accountants, consultants and advisors.

My friend works a lot with different solutions and technologies designed to make it easier and more effective to get accounting and business information collected, processed, stored, and reported.  He reviews tons of different solutions each year, and looks for those he believes can truly make a positive impact in the life of a business owner.  My friend also, as he puts it, “eats his own dog food”, meaning that he actually puts into place many of the solutions which he finds to be beneficial so that he can experience their benefit in his own business.  His proven experiences then translate to support for the solution in the market.  People need to know that a solution will actually do what it is supposed to do, and many wait for someone else (someone they trust) to go first so they can use the customer feedback to help them make a decision.

My friend clearly recognized the growing value of cloud solutions and how implementing cloud-based services to solve specific business problems might be a more effective and affordable way to address growing business needs than with traditional ERP models or installed software approaches.  Using different tools that work together (his term for this is “chunkify” 🙂 ), even very small businesses could now affordably address the various operational and financial information management needs which exist at some level in all businesses.  Following along with his previous commitment to use and not just talk about these things, he began the process of selection and implementation of various cloud-based applications, tools and integrations for his desktop QuickBooks software.

No battle plan ever survives contact with the enemy.  thesis on Military Strategy, German Field Marshal Helmuth Karl Bernhard Graf von Moltke 

It was going great.  Application services subscribed to were working as expected, and all sorts of information was fairly seamlessly flowing to and from QuickBooks.  And then, it happened – his bookkeeper moved away and wasn’t able to work in the office where the accounting software and data were housed.  Take a deep breath. Okay, so back to the remote access thing, and more IT jail.

He worked diligently to create remote access for the now-remote bookkeeper, and remote desktop service worked OK, but it was “a pain to keep working, and it never could give the type of performance we were trying to give her”.  Go figure, the one piece of the puzzle left in the office was the one making everything else more difficult and costly.  He was in IT jail once again.

The final step was to get the QuickBooks software and company data out of the local network and in a safe and secure and fully-managed environment.  Particularly since QuickBooks is (in this case) the centerpiece of the business accounting system, it became essential to place it in an environment where it would be maintained, monitored, and protected by people who specialize in that sort of thing.  My friend, like most business owners, just didn’t have the time and resources to have the level of IT and management that an outsourced commercial service provider could offer.

See The Sleeter Group’s  QuickBooks and Beyond article Still Addicted to Desktop Software? Get it Hosted in the Cloud

Intuit even recognized that businesses needed a better way to run and manage their QuickBooks desktop software, so they created an accredited hosting program to allow service providers to offer application hosting and license management services to QuickBooks users.  My friend now uses one of these providers to host his QuickBooks and other desktop applications.  He still has all the integrations and features he had before, but isn’t required to spend time and productivity fixing hardware issues or software installation problems.  His software is installed, maintained, and actively supported by IT professionals who are focusing on nothing more than keeping his systems up and running.

In his own words, “the hosting move offloaded us from having to mess with providing access, and at the same time it improved performance and delegated the IT management”.

For a time my friend and his business went without a high level of IT management and support, but now he completely recognizes that he needs it and is finding it to be well worth the cost.   Now he’s got his own “get out of jail” card.

Make sense?

J

In case you didn’t know it, both Intuit and Sage have programs for service providers, providing authorization to host and deliver small business financial software products to direct customers.

Get information on Intuit’s Authorized Commercial Hosts for QuickBooks here, Get information on Sage hosting partners here.

If you need assistance deciding how to get your applications and business online, or selecting and implementing with a service provider, we can help.

Read more: Cloud Hold Out No More: QuickBooks Desktop Editions in the Cloud

Posted on

Simultaneous Syncing Sinks Solution: Extend Access but Control Integrations

Simultaneous Syncing Sinks Solution: Extend Access but Control Integrations

Accounts and ProAdvisors: Make sure you “enable” only those who need it

In this wonderfully interconnected world of hosted and online applications and the integrations which complement them, it is important to not let the excitement of connectivity and collaboration replace reasonable control.  While there is much conversation on this topic when it involves file sharing and similar services, the discussion of data synchronization and data integration doesn’t often come up.  However, it has been my experience that there is usually a misunderstanding in how, exactly, a particular sync or integration should be applied and who should have access to the functionality when it is deployed as an extension of the QuickBooks desktop financial software.

An example of the problem might be seen when QuickBooks desktop editions are set to integrate or sync data with a web-based solution such as Method Integration or Santrio Open for Business Order Bridge.  Solutions like these, which extend the functionality of QuickBooks through extending access and integrating data, rely upon QuickBooks integration functionality move data between their solutions and the QuickBooks database.  These solutions are quite beneficial for businesses because they can affordably deliver support for various business functions via a true web application and incorporate QuickBooks data in those application views.  Additionally, this type of solution is able to push information from the web application to QuickBooks, allowing for complete integration of financial and other relevant data.

While having this type of integrated service is beneficial, there are a lot of businesses who don’t fully understand how to appropriately implement the solution and end up creating a great deal of difficulty for themselves.  One of the most frequent failures I have seen when implementing this type of solution is where the customer doesn’t really understand who should or should not have the integration.

When a web-based solution exchanges data or syncs with QuickBooks, a path is created to communicate between the two systems – the web solution and the QuickBooks application and data file.  This path must be open, and both sides of the communication identified, in order for data to sync.  The most important thing to remember is that there should be only one controlling entity on each side handling the integration.   What this means for QuickBooks users is that only one installation – one PC accessing QuickBooks – should be configured to facilitate the primary integration with the QuickBooks company file.

To illustrate, consider an implementation of Method Integration and QuickBooks that was done for a business some time ago.  This business used Method-based applications for a variety of business functions, and those applications used data sync’d from QuickBooks desktop.  Just after implementation, it was discovered that system sync’s were not happening as they should, and sometimes when they went to sync data, it would take a huge amount of time (which was not supposed to be normal behavior).  In short, the system proved to be problematic and, at times, unusable.  But the problem didn’t have anything to do with the Method Integration system, nor the technology.

The problem was that all workstations in the office were set up to sync data between QuickBooks and Method.  QuickBooks was installed on all the PC’s, even though most of the users did not use QuickBooks (they used the Method Integration system to do their jobs), and each PC had the Method Integration sync engine installed and set up to run.  This caused the system to be frequently overloaded with sync requests and caused QuickBooks to behave erratically or crash.  In addition, users who did not need (and should not have had) access to QuickBooks financial information were starting up QuickBooks and opening the company file every day because they thought it was required to allow them to access or use QuickBooks data in the Method Integration system.

The benefits of using web applications which can connect to and integrate data with QuickBooks is that a business can give users functionality and data access required to get the job done, but not expose those users to more software or data than they need.  In most cases, if not all, QuickBooks is not necessary for users of the web application (saving you the cost of purchasing and installing QuickBooks for these users).  Further, to ensure proper functionality and to remove any possible conflict or confusion in the sync process, only one workstation with QuickBooks should be set up to sync data to/from the web solution.  While it makes sense to have a “backup” PC setup with the ability, syncing should remain inactive on this machine unless the primary “sync machine” is out of service.  The key element to remember here is that the data coming from the web application is being added to the QuickBooks company file.  Once the data is in QuickBooks, QuickBooks users may access the data from QuickBooks and do not need the connection to the web application.

When deploying this combination of solutions with a hosting service provider, the same rules will apply.  Only users who need the sync capability require service with both QuickBooks and the integration installed.  In some cases, this may make selection of host services more affordable, as only those who need the “additional application” (being the sync solution or integration tool) require customized service, and the rest of the QuickBooks-only users need standard QuickBooks service.  *It might also be worth noting that many hosting providers do not support “persistent” connections – sync connections which continue to run even when you are not logged in), so syncing of data would only be able to occur if the primary user was logged in to QuickBooks and had the sync integration active on the host solution.

Accounting professionals, QuickBooks ProAdvisors, and small business consultants can help their clients understand the value and potential of extending QuickBooks desktop editions with connected web-based solutions.  The additional value these professionals bring to the conversation is the understanding of the need for structure and control of the data flowing into and out of the financial systems, offering their expertise to ensure that the accountability and appropriate treatment of the information exists throughout the business.

Make Sense?

J

Read more …

There’s a lot of legacy ERP out there, and it’s not going anywhere any time soon

https://coopermann.wordpress.com/2012/05/29/theres-a-lot-of-legacy-erp-out-there-and-its-not-going-anywhere-any-time-soon/

Compliance in the Cloud – their system, your responsibility

https://coopermann.wordpress.com/2012/05/23/compliance-in-the-cloud-their-system-your-responsibility/

Beyond Bookkeeping to Total Business

https://coopermann.wordpress.com/2012/05/25/beyond-bookkeeping-to-total-business/

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