Tag: cloud accounting

Posted on

Two Ways to Get QuickBooks in the Cloud

Get QuickBooks in the Cloud: Hosted QuickBooks Desktop or QuickBooks Online

cloud-computingRunning applications online, or “in the cloud” using today’s parlance, is top priority for a lot of businesses.  It’s not that these organizations have a burning desire to post their financials to the web, which is what a lot of folks thought was going to happen when we first suggested they use their financial applications online.  Rather, business owners and managers have begun to recognize and experience the benefits of connecting their various locations, remote and mobile workers with real time access to business applications and data.  Further, centralization of IT coupled with outsourced IT management and subscription service pricing has introduced financial and operational benefits which make businesses more cost-efficient as well as more agile.  From being the basis for foundational process and workflow improvements to allowing the repositioning of IT costs from capex to opex, online application services are proving their value in various ways every day.

The evident popularity of cloud solutions is clearly visible in one small corner of the global software marketplace: the small business accounting solution market. Intuit’s QuickBooks product, almost a default go-to with entrepreneurs and small business owners, is still the most prevalent accounting solution in use by US small businesses.  While there may be growing usage of other applications on the web, such as Xero or FreshBooks (both are awesome SaaS apps that do what they do quite well), there is equally strong growth in Intuit’s own SaaS version of QuickBooks.  The SaaS applications are easier to localize for different places in the world – different languages and currencies – so international use of these products is likely to continue to grow.  Even more to the point, these solutions address functionality and pricing levels which are acceptable to entirely different classes of users that previously wouldn’t even consider buying accounting software to do the books (like freelancers and solo/soho operators), so the overall size of the market of “businesses who use accounting or bookkeeping software” is actually growing.

Intuit’s QuickBooks Online edition is a true SaaS solution that is quite different from the desktop-based QuickBooks.  While QBO has gained tremendous popularity, it has yet to reach the user numbers the desktop products have.  The desktop solutions boast not just a particular range of functionality, but integrated applications and add-ons, and – perhaps most importantly – being a foundation for a wide variety of financial and business record keeping, bookkeeping, accounting, operationally oriented and reporting processes.  To sum it up: it’s embedded.  People know the software, the data is in a known format, and the product is simply part of how the business operates.

Once a solution is as entrenched as QuickBooks is – kind of like the entrenchment Microsoft Word and Excel have in the productivity area – it doesn’t go away very quickly and only when the value proposition is much greater… and maybe not even then.  Rather, folks find ways to make the solution they want work for them.  This is where hosting comes in and meets with the market’s demand for running applications (yes! even desktop applications!) online, as managed subscription service.

Running your QuickBooks desktop online via a hosting provider is how businesses take advantage of the best benefits of SaaS without actually converting to a SaaS application. They retain investments in training, process and integration yet introduce mobility, remote access and office connectivity, centralized information and predictable costs. QuickBooks-using businesses need to know about hosting their QuickBooks and the providers who can offer anything from standardized to extremely customized service.

As technology continues to evolve at ever-increasing rates, businesses will continue to be faced with new paradigms for doing business.  Some will adopt early and some will adopt later, and some simply won’t adopt.  Certainly the market as a whole doesn’t adopt as quickly as software companies would like, but then that’s always the way it is.  Customers will do what works for customers, and right now hosting is working for QuickBooks customers.

Joanie Mann Bunny FeetMake Sense

J

Posted on

QuickBooks Online vs QuickBooks Desktop: The Great Debate

QuickBooks users around the country are facing a dilemma like never before – they’re being forced to consider exchanging their beloved QuickBooks desktop editions with a subscription-based online application that seems like an entirely different product.  It not only seems like a different product, it is.  And this is where the debate begins.

For years businesses both large and small found Intuit’s QuickBooks software to be their solution for business bookkeeping and accounting.  Over the years the product line grew to support larger businesses, with the Enterprise edition scaling to 30 users and boasting a load of operational process support features.  Accounting professionals, too, grew to favor the QuickBooks products because there were features just for these “mechanics” who learned to make the software do what was necessary to support the business, even if the software wasn’t intentionally designed to be used in that manner.  After all, it is this “unintentional” activity which often results in really cool new features being introduced in the product – features that the designers didn’t think up but that users did and the news eventually got back to the developers.

dt-v-online-great-debateWhen Intuit introduced QuickBooks Online, however, the tried-and-true solution known as “QuickBooks” became something very different at first glance, creating the need to educate the market about the continuing existence of desktop QuickBooks products as well as the newer online QuickBooks product.  Differentiation of the two is not really the “desktop” versus “online” moniker – Commercial Hosts for QuickBooks, who essentially turn the desktop products into online application service, pretty much eliminate the whole “any time, anywhere” debate, as hosted QuickBooks desktop editions are just as anytime/anywhere as the online edition is.  The benefit of Internet access and running on any device is now removed from the equation, so what’s left to compare other than functionality, benefits and features… and a proven track record?

We could, in the past, have a conversation about the features, benefits and functionality in QuickBooks and know that the flow-through of product use knowledge, stored data and integration with other business solutions would be fairly seamless and consistent.  QuickBooks Online has demonstrated none of this, fracturing the seamlessness and consistency users could previously expect as they move through the product line – as businesses will do as they grow larger and have more demands from their software solutions.

So now there’s a debate – which solution is best?  The answer really isn’t necessarily about which is best, but which addresses the business need now and, if the business intends to be around for a while, in the future.  Sometimes the argument is more about getting you where you need to be rather than simply supporting where you are now.  I know I’m not yet ready to place any hard bets on whether or not the QBO  model will truly deliver the goods for growing businesses long-term.

Joanie Mann Bunny FeetMake Sense?

J

Posted on

Everything Old is New Again: Big Fat Phones and Desktop QuickBooks in the Cloud

anywhere-anydeviceEvery year that passes leaves some reminder of the time – some person or occurrence which touches us and creates a lasting memory.  2014 delivered its share of memorable people and moments and proved again that social platforms such as Twitter and Instagram have become increasingly significant as people across the world organize, march or call for change.  Yet even as change is demanded from us and often forced upon us, it is wise to remember that the pendulum eventually swings both ways.  We want to have our cake and eat it, too, which is the ultimate no-win situation and causes us to constantly and consistently seek out the alternative.  Like the puppy chasing his tail, we end up going round in circles.  Harem pants and jeans torn from knee to thigh have come back in fashion, and even though they didn’t really work the first time, here they are again. It is inevitable.

Information technology trends follow similar patterns, and what was once in high fashion may now be considered as “legacy”.  Perhaps the better word is “classic”, as these legacy solutions often represent the standards by which new solutions will be measured.  Eventually, the properties of the classic or legacy solution wind up in the new breed, because this is what the market has come to expect and/or demand.  Even when entirely new standards are believed to be adopted, the truth is that years of learning and experience will often find the path previously traveled by others to be the right path.

It seems like so long ago when some said “the desktop is dead” and that all applications would be used by every device via the web, but not run on the device.  Well, there are quite a number of web-based applications and services delivered in just that manner, but there are also lots and lots of computers out there with software still installed on them, happily working away for their users (there’s an app for that, right?).  The desktop isn’t dead at all, it seems, and what’s more – there are trends to extend the capability and reach of the desktop to the web rather than replacing the desktop with the web.  Application integration, process integration, interoperability, functionality and modality – all these factors and more have become the underlying drivers for extension of and hosting for desktop applications, and are the areas where SaaS and web-based application service has not delivered as expected.

The idea of having no software on the computing device is kind of silly, when you think about it.  Computers continue to get more powerful and have more capability than ever.  Heck, even phones are getting fatter and bigger again.  The best phones these days are the ones that rival tablets and laptops in size and have lots of apps to run.

Microsoft Office, too, hasn’t gone anywhere, really.  It’s still firmly attached to most workstations whether they’re iPads or Macs or Windows systems.  Web-based productivity tools are certainly gaining in use, but not nearly as widely as some would believe.  Office productivity continues to live on the desktop, and ties many users to desktop computing for that very reason.  Use CRM in the cloud?  I’ll bet you still export data to Excel or Word on the PC.  Use accounting in the cloud?  A lot of reporting still goes through Excel, trial balance systems and the like.  The universe of web-based and SaaS apps is getting larger, but it hasn’t yet become the center of the universe for most established businesses.  Net-new customers and smaller businesses are adopting SaaS due largely to cost and to the success of the marketing message, but use and direct experience with the product applied in the business setting often demonstrates that adoption of a more flexible (malleable) or functionally rich solution is indicated. The business likes the mobility, remote access and managed service, but not the actual SaaS application.  So, hosting becomes the better alternative and the business is able to use the software that works for the business, and use it in a manner that allows the business to take advantage of remote and mobile capability, subscription service, and more.

I really have no gripes with web-based and SaaS solutions.  In fact, some of my best friends use SaaS  🙂  The message I’m trying to convey is simply that, regardless of what the media and marketing may tell you, things don’t always change as quickly as it seems.  Yes, there is a movement towards cloud solutions and online working models.  Yes, there is change in how information technology is obtained and used.  And equally true is the reality that only a portion of the market has adopted these changes and new philosophies.  By the time there is “complete” adoption, there will be a new standard or approach being marketed and we will be in this place once again.  Is there wide recognition of the benefit for mobility and remote capability? Sure there is, but it is also accompanied by the understanding that tried and true solutions will continue to deliver the functionality and capability businesses rely upon, even as new models for delivering them come about.

jmbunnyfeetMake Sense?

J

Here are some of the most popular articles from CooperMann.com in 2014.  Surprisingly enough, the most popular were articles about QuickBooks and the Cloud, a subject I’ve been writing about for many years.  In fact, some of the most popular of my QuickBooks/cloud articles are from 2013 and they remain among the most frequently viewed even today. Search and view metrics indicate that the topic’s popularity is not likely to diminish soon, so plan to hear more about how businesses are using QuickBooks (and other desktop and network applications) in the cloud, but aren’t using Online editions to make it work really well.

 The concert hall at the Sydney Opera House holds 2,700 people. CooperMann.com blog was viewed about 19,000 times in 2014. If it were a concert at Sydney Opera House, it would take about 7 sold-out performances for that many people to see it.

  1. The 2 Most Popular Models for Working with QuickBooks Desktop Editions and the Cloud
  2. Hosted QuickBooks and Office 365 a Complicated Technical and Licensing Model (until now)
  3. Intuit Introduces Changes to Authorized Commercial Host for QuickBooks Program, Introduces QuickBooks Enterprise Rental Licensing
  4. Managed Applications, Cloudpaging, and a New Flavor of Hosted QuickBooks
  5. QuickBooks and Dropbox? Yeah… no.
  6. Intuit Ends QuickBooks Remote Access Service: The Time to Host is Now

 

Posted on

Following the Rules: Users and Licensing for Hosted QuickBooks

Following the Rules: Users and Licensing for Hosted QuickBooks

I have said many times before that the licensing for QuickBooks desktop editions appears to be a bit complicated, and a lot of that may have to do with the fact that so many people use QuickBooks in so many different ways.  With a solution like QuickBooks (or Microsoft Office or other really popular and widely used software products) there is a tendency for folks to want the flexibility of accessing their software regardless of what computer they are using.  Also, especially in businesses, there is the habit of installing software on a computer and then allowing anyone sitting at the computer to use the software.  In some cases these approaches are okay with the software vendors, but in most cases they’re not.  Yet too often, the small business owner doesn’t find out what the actual rules of using the product are until they try to deploy the software with a hosting service provider (because nobody ever actually reads the EULA, do they?).  If the provider has any credibility at all, they will enforce the licensing rules of the software, but that doesn’t always sit well with the customer.

picture-hostedQBThis situation rears its ugly head quite frequently in the QuickBooks hosting world.  Perhaps it is because there are a lot of possible working models involving QuickBooks users, or maybe it’s simply a matter of people not seeing the value of paying for what they want to accomplish.  Either way, service providers find themselves being challenged every day in trying to explain to a customer why they need to have more than one license for QuickBooks and more than one service account if they want more than one person to access the hosted solution.

Different people at different times: The Concurrent User approach

One of the arguments people make for not having licenses for all of their users is that they don’t actually need everyone in the system at the same time.  The belief is that there should be licenses enough only for the number of concurrent, or simultaneous, users that will access the system, yet each individual human being/user should have a login to the system with the software available (for convenience, of course).  A QuickBooks 3-user license, they believe, should be able to be used by any number of business users as long as no more than 3 of them are in QuickBooks at any given time.

While the customer may be making a reasonable argument, it all falls down when you consider the license agreement for QuickBooks.  Each user of the product is supposed to have a specific license.  A business with a 3-user license (or 3 single-user licenses) for QuickBooks has the rights to allow 3 people (unique human beings) to use the software, not any combination of people as long as they number no more than 3 at a time.   There is to be no sharing of licenses, and there is no “concurrent” licensing model: each person/user/human being is supposed to have their own license for the product no matter how often they access it.

Look but don’t touch: The Read-Only User approach

Another of the arguments people make for not licensing all of their users is that there is somehow a belief that if you don’t actually enter information, then you aren’t really using the software.  This often comes up in situations where an accounting professional works with their client, or when business owners want to occasionally see what’s going on in the company.  The approach centers on the concept of what a “user” is and suggests that users are the people entering or changing the data, and people only viewing that information aren’t really “users” at all.  When the bookkeeper opens QuickBooks and enters an invoice, the bookkeeper is recognized to be a user.  But when the business owner opens QuickBooks to view the financial statement or see the bank account balance, isn’t the business owner also a user?  Yup, they sure are. Any person that actually opens the program on the computer is a user, regardless of what they do when the program is open.  Just looking around at the data still requires that the program be open, and opening the program requires a license.

Two Fer: But the other hosting company lets me…

Just because you can do something doesn’t mean that you should.  So, just because a different hosting provider might let you get away with things that aren’t right (but perhaps are convenient or cost saving in the short-term) doesn’t mean you should expect a different host to allow the same thing.  If your current host says things like “as long as you don’t tell us…”, you should be concerned.  This often comes up in a hosting scenario where there is an outside accounting or outsourced back-office professional working with a hosted client business.  The outsourcer will want to access the client books, so they will want to have a login and access to QuickBooks software on the host system.

The trouble starts when the outsource professional doesn’t want to have to pay for their own service or licensing, yet they want to be able to login to the system and run QB just like the client does.  Falling sometimes under that attempt to leverage a concurrent user approach (see above), these outsourcers just aren’t realizing that the benefits of accessing their client information and working in real-time with that data is often valuable enough to support the cost of a hosted account and license.  Instead, they want their access to be free of charge and not be bound by silly rules of licensing, often because their client won’t want to pay for the accountant service in addition to their own.

This is when the “if you don’t tell us” stuff comes in – where the service provider may suggest to the accountant or outsourcer that they can simply login as the client and nobody would be the wiser.  I’ll fess up and say I have even entertained this idea with clients a few times but always shy away from discussing it in-depth.  While it is basically true that the service provider doesn’t generally know which exact human being is sitting at the other end of that remote desktop connection, that doesn’t mean that it is okay to leverage it into an abuse of services or licensing.

Two or more people sharing a single login just isn’t good ju ju, and it’s usually against a whole bunch of licensing rules and rights of use.  The funny thing is that many customers who initially leverage their service in this manner end up finding it was a really bad idea.  I saw a scenario a few years ago where a business allowed their outside auditors to share the logins of regular employees in the finance department.  When an employee tried to login to their remote desktop, they opened the session the auditor had open – exposing the employee to a lot of data that was not theirs to see but which the auditor user in QB had access to.  The company called it a security breach and it was on their part – and it was allowed to happen because they shared their remote desktops with the auditors rather than giving the auditors their own accounts with their own security profiles.  What seemed like a good, cheap approach on one day rapidly turned into a big issue the next, and the service provider had no power to prevent it from happening.

The moral of this story is simply that following the rules is the right thing to do and most reputable hosting service providers will try, even if they don’t end up doing it really well.  There are always going to be those who figure that the risks don’t measure up to the potential rewards, so they will do what they choose to do.  I’m always left wondering about those guys; if they have no problems breaking these rules, I wonder what other rules (or confidences) they are willing to break.  Hmmm.

Make sense?

J

 

Posted on

Avoid the Aftertaste| QuickBooks Desktop Hosting Comes in Many Flavors

Avoid the Aftertaste| QuickBooks Desktop Hosting Comes in Many Flavors

There is a lot of activity and interest around the hosting of desktop applications in the cloud, and it is no wonder that a great deal of the effort centers on the use of Intuit QuickBooks desktop editions.  QuickBooks is among the most popular software products used by small businesses, so it makes sense that service providers and hosting companies are taking advantage of that market share to reach prospective hosting customers.  After all, a hosting platform may be kind of neat, but it is not all that valuable unless there are applications and data living on it.

For the average small business, the applications of choice include Microsoft Office and QuickBooks.  Yes, there is an online edition of the QuickBooks product (called QuickBooks Online, of course).  However, the market share Intuit earned for QuickBooks wasn’t accomplished with an online application, it was done with the desktop applications which still own market share today.  Hosting service providers recognize this truth, and are taking steps to bring those QuickBooks desktop solutions into the cloud.  Now we have the ability to get QuickBooks Desktop editions online – which is not the name of a service but a description of what it offers – available from a variety of authorized hosting providers (and from many unauthorized ones).

I’ve said before that there is a fine art to hosting QuickBooks desktop for lots of users.  There are a great many different considerations and possible use cases, and not all providers will be able to meet every requirement.  There are also lots of different technology models and methodologies which may be applied to the hosting model, and each has some benefit or barrier depending on the specific need of the client.  Hosting companies may throw around terms like “cloud server” or “published application” or “remote desktop”, but at the end of the day, the systems are still Windows computers running QuickBooks software.  How those systems are wrapped up, how you connect to them, and how you operate with them often becomes the real difference in the service experience.

The specific technology a hosting provider applies to the service does not necessarily describe exactly how the service works.  Just because a provider may use Citrix doesn’t mean they have more capability to provide quality service than a provider using other technologies, or a host using VMWare is not necessarily creating better cloud servers than a host using Hyper-V or Parallels or some other virtualization strategy.  The technology may impact how the infrastructure is operated and can impress upon the customer experience, but the real differences in delivery often come down to the provider’s understanding of the software product, the customer need, and their ability to meet the need directly.

Does the experience of connecting to and using the service work for the users, and are people able to get their jobs done quickly using the service without a lot of support or frustration?  (**Please note that hosting services aren’t a solution for bad software and poor working processes.  If the software or processes aren’t workable now, they’re likely not going to become magically more workable if hosted).  Does the hosting service address issues like making the right data available to only the users who need it, and giving access to applications only when a user is permitted to use them?  What about “external” users like contractors or client businesses… does the host offer a way for them to also participate in the solution?

It’s important to consider all of the aspects of how the service will be used, and by whom and under what circumstances, to ensure that the delivery offered is the solution needed. The point of all this is to encourage users to concern themselves a little less with exactly what technology the host is using to deliver QuickBooks applications, and to evaluate the actual solution.  It won’t typically matter to an end-user what specific technology is being used to provide them with service as long as the service works well for them.

While some people do adopt a fondness for a particular “flavor” of technology or approach, the reality is that a quality user experience coupled with a useful and reliable system means much more to the business.  And knowing that there are future options for growing, expanding or simply changing the service is essential.  It’s not so much the flavor of technology users should be concerned with when shopping for QuickBooks hosting services, it’s avoiding that icky aftertaste that comes with selecting a QuickBooks hosting approach that just doesn’t meet the business need.

Make sense?

J

Posted on

Accounting for Point of Sale

Accounting for Point of Sale

There are a lot of solutions available to help retail businesses get business done.  From touch screen technology to mobile credit card and payment processing, retailers have many choices when it comes to selecting the right technology for the establishment.  But even the best point of sale system can lack the critical element that makes it truly valuable for the business.  This critical element is integration to a trusted accounting and finance solution.  While the POS system may include a level of basic accounting functionality, the reality is that a dedicated financial application will perform better in the long run.

Just as specialized line of business applications are used to handle operational functions, the financial application should be considered to be the “line of business” solution for the accounting and finance department (even if it is a department of one). This system not only services essential processes like receivables management, bill payments and bank account reconciliation, it serves as the basis for payroll, financial, tax, performance and other reporting. Further, the financial systems are often the first and primary source of analytical data, illuminating KPIs and cash flows and ultimately the business value.

The point of sale application generally handles the selling of and payment processing for goods and services sold by the business.  Whether it is composed of registers and terminals connected to a host system, PCs running POS software, or mobile phones and tablets running mobile payment processing apps like Square or GoPayment, point of sale addresses the retailers need to capture and record sales and payment information, sometimes customer information, and often inventory information.

The data from the POS solution must make it to accounting in some manner, yet point of sale applications are too-often approached as a standalone business requirement, somehow disconnected from other aspects of the business including the back-office.  Sales and items may be recorded in the POS system, yet only summary sales data ends up being re-keyed into the accounting system.  Centralized inventory management is all but nonexistent in these cases, and gross sales total are often recorded rather than individual transactions and receipts being transmitted to the accounting system.  The process of re-keying information from the POS to accounting systems is not only an efficiency-killer, it is also introduces a great potential for errors.  When the business elects to conserve on data entry and post only summary information to the accounting system, valuable detailed sales and transaction data may be lost.

The right approach to bringing point of sale together with accounting is to automate the process of integrating POS data with accounting on a regular basis – with AUTOMATION being the key.  Rather than establishing a process that requires manual entry of information from either system, a data integration solution is the best approach, with an import/export solution running second. The point is the elimination of manual re-entry of information.

There are numerous tools available that can take formatted POS data and import it into products like QuickBooks, for example, where it can be properly accounted for.  While QuickBooks Point of Sale integrates with QuickBooks desktop products, other POS solutions can also connect with QuickBooks if the right integration tool is selected, and there are quite a few available.  Check with the POS vendor and ask about a direct integration with QuickBooks desktop or whatever financial system you use. If there isn’t a packaged integration solution available, then check out products like Transaction Pro Importer, which can automate a variety of data import processes and ease the burdens moving external data into QuickBooks.pointofsale

The other factor in getting point of sale data to accounting is actually getting it there… transporting the data from the POS location to where the accounting system lives.  In many situations it is not desirable to keep the accounting system on the same computers as the point of sale systems, and in some cases it isn’t even possible.  But there is generally a way to get the information in a form that makes it possible to transmit it in some manner.  Among the most popular approaches to solving the “getting the POS data from here to there” problem is to use a data sync solution like Dropbox.

If the point of sale data can be exported or output to a file on a PC hard drive, then it may be able to be stored in a Dropbox folder on that PC.  At the home office where the accounting system resides, the operator would access the sync’d files from the local PC Dropbox folder and import the data to QuickBooks.   For QuickBooks Point of Sale there is an option to create a “mailbag” of sorts from the POS data of a remote store, which QuickBooks POS at the home office would pick up from the Dropbox folder and push to the QuickBooks financial application.

For businesses using POS systems like Micros or POSitouch and others, there is likely a service or application that will produce the POS data for import to QuickBooks or other financial system, pulling POS data files placed in the Dropbox folders by the POS app or performing the function as a web service or SaaS integration.

While I am a big fan of application hosting services and running QuickBooks desktop editions in the cloud, I’m also a realist and recognize that many POS solutions either can’t or shouldn’t be hosted.  There are situations where a hosted point-of-sale makes a lot of sense, and then there are cases where no bandwidth or proprietary hardware-based solutions make hosting not even an option. That doesn’t mean that the financial systems shouldn’t be hosted, though, and there are numerous ways to get the sync’d POS exports to the hosted QuickBooks environment, for example.

The key for retailers is to make sure there is a solid process for getting detailed and accurate POS information into the accounting system on a regular basis.  Manual entry is never the best answer.  With all of the technology and tools available, manually re-entering sales information is a waste of time and is likely to produce errors.  The better answer is to use an approach that automates the regular collection of point-of-sale data from all sources, delivering the data in a regular and consistent manner to accounting, and providing the basis for end-to-end automation supporting the integration of the point of sale system data with the rest of the business accounting.

jmbunnyfeetMake Sense?

J