Tag: hosted quickbooks

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

Posted on

Where do we go from here? The SMB SaaS Migration

Where do we go from here?  The SMB SaaS Migration

Forests are a great renewable resource.  You may cut them down, but you can replant and grow new ones to cut down again later.  I suppose it’s sort of like that for software vendors who provide small business solutions.  While many small businesses fail and close every year, lots and lots of them start up and continue operating each year.  Since there’s a steady stream of new prospective customers coming up each year, maybe it is OK when some of them outgrow the product and leave (leaf?).

On the other hand, maybe it makes sense to understand where those customers who do grow up and flourish will go… to which products or solutions they will migrate, and how the company might actually retain a relationship with them through that process and beyond.  Some businesses will mature successfully, and will outgrow their small business solutions and leave their vendors, but it doesn’t necessarily have to be that way for all.  For some key software vendors, a fair question to ask themselves is where their customers will go from here… where “here” is the solution the customer is using now.

When this question is applied to the small business accounting market, it ends up centering on the QuickBooks product line.  Intuit is currently encouraging all QuickBooks customers to look at the QuickBooks Online solution, the fully SaaS-based offering which is different from the desktop editions.  The QuickBooks desktop editions, on the other hand, service small businesses very well.  The functionality improves and increases as users move up the product line from the Pro version through Premier and to Enterprise edition.  This line of solutions has done a great job of serving the needs of both small and larger businesses – all within the same product set.  But now Intuit wants users to experience the benefits of subscription-based service and an online working model.  Those are great benefits, but there’s a question that is left open for the asking.  Where are QuickBooks customers supposed to go from there, assuming that at least some of them might grow beyond the capability of the online product?  It’s a fair question, and here’s why I think so.

fall_from_cloudOnce a business has adopted a certain working model and the mentality that goes along with it, it is difficult to come in and tell them they have to change to a new model and find a way to adjust.  Change doesn’t come that easily for many individuals much less an entire organization, so this is a big deal and potentially very impactful to all aspects of the operation.  Yet this is exactly what is currently suggested with Intuit’s desire to have customers use the online edition.

It may be a great solution for now, but what’s the next step up from there?  Is it QuickBooks Enterprise on the desktop?  Kind of a weird message, don’t you think?  Let’s have customers adopt an anytime, anywhere subscription solution model, and then migrate them back to the desktop where the management and maintenance of the solution is higher due to number of users, and where there is no mobility, multi-location or remote access capability as there was with online.

The thought is that QuickBooks Online will eventually compete with the Netsuite and Intacct class of SaaS solutions, but right now it doesn’t and there are customers who must leave that product for something that handles their larger and deeper business needs (like the QuickBooks Premier and Enterprise solutions do).   There is a big gap between the entry level accounting products and those which are designed for the larger or midsize “small business”, and the QuickBooks desktop editions represent the only viable options in that very large space.  In fact, many businesses utilize line of business products that allow them to retain use of QuickBooks even as the enterprise scales far beyond the expectation that QuickBooks could handle the need.  But it often can, and it makes sense for businesses to leverage this ability if they are able.

The answer for these growing businesses  – the place they should go when they’ve outgrown the small business SaaS solution like QuickBooks Online (or Xero or Freshbooks or whatever) is to a hosted or remote-enabled QuickBooks model.  With the QuickBooks desktop editions hosted and managed by a cloud provider, businesses are able to retain the benefits of managed service, subscription pricing, and anytime/anywhere access while utilizing the products that are recognized as the industry standards for finance and accounting for growing businesses.

The hosted approach gives the businesses a clear path for the advancement of their systems in line with the growing needs of the business, and removes the need to shift working models from online to on-prem.  As needs increase and the complexity of systems grow through integration and scale, the service provider manages the platform and systems, enabling the business to not simply continue operating, but to grow and expand with the confidence that there is a plan to grow and expand the systems which support it.   The place to go is the cloud, and whether it is an entry-level SaaS solution or a hosted desktop and server approach, the service is there to handle the business.

jmbunnyfeetMake Sense?

J

Posted on

Justifying the IT Budget: the Cost of Not Spending

it_spend“Competitive and ever-increasingly sophisticated in the marketplace”[1] describes a company positioned for long term business survival.  Complacency takes the business nowhere but into irrelevance-land, which I think we can all agree is not where most business owners wish to end up…  it makes selling the company slightly more challenging.  Even in markets which were once firmly held to be localized are now open to new – and new kinds of – competitors, due in most part to advancements the development of information technology (IT) as well as how it is applied.  These days, competition is globally facilitated rather than locally, and it’s becoming the standard approach.  Welcome to the cloud.

New paradigms in IT capability and use are spawning huge shifts in what were broadly recognized normal or traditional business approaches.  This realization has created the need for businesses to radically change their view of IT investment and the value of IT within the organization and operation.  Yet IT is rarely an area which gains a strategic focus for investment within most businesses, and is frequently considered to be like a pencil or a particular chair… something the business needs but which has little impact on the company’s ability to compete better.  Au Contraire, Mon Frère:  Information technology is at the heart of business competitiveness, but justifying the desired investment is the great challenge.  Maybe it’s because the focus is always on the great benefits to be achieved with the spend, rather than looking realistically at the impact of not doing it well or at all.  Especially with information technology, there is a large potential cost to be paid for not spending adequately.

While business operations are sustained through IT involvement, economic pressures continue to weigh down business interest in funding IT operations. (which is weird, as there is a lot of evidence that the good bet is on those who do just the opposite). This regular spending reduction and cost control plan has good intentions of reducing the overall cost of business operations. The unfortunate reality is that operations are less efficiently sustained and are even more frequently unable to create or manage any level of growth. Reducing all IT spending is only useful when profitability is also improved and quality is maintained, unless it is an effort to simply stay afloat as revenues decline (and it’s recognized that quality will decline as well). But reducing costs does not help the business seeking to remain competitive in a rapidly changing marketplace, and pulling the pins out of the department primarily responsible for at least keeping things currently in operation operating serves only to chip away at the once-solid foundation. It’s a real problem, this difficulty with increasing interest and justifying increased funding for business information technology. And it all stems from the inability of organizations to clearly and with tangible benefit cost justify the investment.

It is this justification – demonstrating IT investment as a strategic asset presenting an advantage over competitors and positioning the business for future success – which requires effort and analysis to fully describe. Information technology is not a set of servers and software, and it is not websites and portals. It’s not click thru rates or SEO scores. Well, it’s all of that, but it is none of that. There is so much to consider and incorporate, and there are many degrees of success which might be experienced along the way. Information technology is a fundamental requirement in each and every business, and dependency upon it is increasing at a startlingly rapid pace, yet we still can’t quite figure out how to put it all on paper with provable numbers.

It might be easier to forecast in little departmental or functional pieces, but that doesn’t provide a total picture of the enterprise. And it’s often really difficult to quantify the impact of not doing something, or doing it only OK rather than really well. When this data does present itself, it often comes too late and in the form of a comparison to the competition, revealing where the business just didn’t meet the mark as compared to others in the same space.

It all boils down to businesses coming to the realization that information technology investment must be made on a continuing basis. The justification for IT funding must be made, and that justification must necessarily be balanced against the potential implications and impacts of not implementing. This is the only formula which can ultimately describe the value of IT investment in the business.

Make Sense?

Read the entire article on LinkedIn

https://www.linkedin.com/today/post/article/20140624161243-633314-justifying-the-it-budget-the-cost-of-not-spending

 

[1] A model for investment justification in information
technology projects: A. Gunasekaran et al. / International Journal of Information Management 21 (2001) 349–364
Posted on

Good Habits for Healthy QuickBooks

Keeping_QuickBooks_HealthyUsing a QuickBooks desktop product is pretty simple – you install it and then you run it.  For many users, it’s just that easy and uncomplicated because they don’t need 3rd party integrated software, they don’t sync their files to other computers or services or try to share their QuickBooks data, and they remember to exit QuickBooks and back their files up each and every time they use them.  On the other hand, many QuickBooks users experience quite a lot of frustration with the product – frustration which may often be the result of a poor practice when using the software.  QuickBooks has been engineered over many years to be as simple to use as possible, but at the same time has grown to be a product with lots of features, add-ons and extensions.  Users have also found ways to make QuickBooks do things it wasn’t really designed to do, this truth being one of the good things and the bad things about the product.  When it works, it works great.  When it doesn’t work, it’s beyond frustrating.  It is a shame that a lot of the problems users have with solution may be rooted in the habits and behaviors of the QuickBooks users themselves.

Bad software use habits will cause problems whether the software is installed on the user PC or whether it’s being managed by a hosting service provider.  Certainly there are some issues that hosts may mitigate, but the following is a list of good habits for keeping the QuickBooks software and data healthy and working that should be standard operating procedure for any QuickBooks user, whether QuickBooks is being hosted or not.

Keep the company file in good condition.

I cannot stress enough the importance of keeping the file in good condition.  What’s the accounting and financial data worth, after all?  A little time spent taking care of the file can save on a lot of time and headaches trying to reinvent the information. A QuickBooks company file is really a database, and is a rather complicated framework for keeping track of all sorts of related information.  Anyone who has used QuickBooks desktop products for a while understands that the data file can get screwed up for a variety of reasons, and it is no fun.  Yet QuickBooks has utilities to verify and rebuild data files, so it makes sense to periodically use them to check for problems.  Like a check-up with the doctor, these utilities can help diagnose issues with the data file before they become really big issues.  Another good practice is to back up the company file to a “portable” once in a while, and to then restore it for use.  This process can not only validate the integrity of the file, it also helps condense and “condition” the file.  Particularly when using a hosting service, but also when just running local on the PC, conditioning the data file once in a while can help prevent data corruption and/or loss (of data, time, productivity, revenue).

Close the company file and exit QuickBooks once in a while, would ya?

Users who leave their computers on all the time are missing out on the fun of letting their machines reset and do a POST (power on self-test), which means the machine or operating system could have an issue and the user wouldn’t recognize it until the machine was powered off and then restarted.  For this same reason, programs and their data files should be closed when not being used – so they can run through their own startup and validation routines before you use them.  Also, leaving the program open means it is active on the computer, and leaving the data file open means that it’s available (read=vulnerable).  A random bypasser accessing the computer, a program crash, a machine crash… loss of power or a kitten running over the keyboard could all result in catastrophic damage to the application and/or data.  It’s just better for all involved if the files and programs are closed when not being used.  Maybe use a screensaver with a password, too.

Don’t try to use QuickBooks with a VPN (virtual private network) connection.

Just because a user can connect their remote PC to the office network doesn’t mean the PC will work like it’s in the office.  In the office, it’s a Local Area Network, and the speed is fine enough to allow multiple computers to share a QuickBooks company file in multi-user mode.  When there is a remote PC connected via a VPN, it’s usually a Wide Area Network connection, meaning that the network has been extended to include the remote computer, but that network connection IS NOT fast enough to allow the remote user to open QuickBooks along with others in the network.  QuickBooks multi-user access only works on a local network (where local means the machines are all “local” to each other – on the same LAN).  When QuickBooks is hosted by a service provider, the QuickBooks stations and the data files are all located inside the host’s network, making it all LAN stuff.  The only remote part of it is sending the input and output (display, printing, keyboard and mouse) information “over the wire”.  This is why a hosting model works when the app and data are hosted, but doesn’t work when only the data file is hosted.

Use Automatic Update, not Manual (but DO update).

Features change, new technologies must be supported, and user expectations adjust based on a wide variety of influences.  What this means is that software products will necessarily experience change over time and users will be expected to update them.  The first release of any new product is rarely flawless.  It’s during that first introduction to a volume of users where many issues are found, making the v1 release of a software product something many people try to avoid. Yet there are still lots of folks who just can’t wait to have the newest thing, even when it comes to something like software patches.  Regardless of how much they may put at risk, these folks want each and every patch and update as soon as it is available somewhere.  These are the users who end up debugging the software for the rest of us, so I guess we should thank them.

For most users, however, it makes sense to wait until the software has been out for a bit and those initial issues identified and corrected, perhaps bypassing v1 and going straight to v2.  If the product will allow, that is.  QuickBooks has this great (or annoying, depends on how you look at it) feature that can tell users when there is an update available.  This “automatic update” feature checks with Intuit to see if there are updates available for the product, and then tells the user they can download and install them.  Generally, Intuit pushes these updates out only when they’ve been debugged and are deemed ready for volumes of users.  If people want to get an update before Intuit pushes it out, they may be able to obtain it for manual installation.  This is not the recommended method of handling QuickBooks updates; for most users, waiting until the product tells them it’s time to update is best.

Make sense?

J

Posted on

QuickBooks online, or QuickBooks Online? Use Software on the web without using Web-based software

cloud-computingThere is a trend among software makers these days to more fully leverage the “power of the web”, and why wouldn’t they?  The Internet has become the way businesses and users get and stay connected, and has become a foundation for how business gets done.   Remote and mobile access to information and applications has become an expectation of users, as social computing models have encouraged them to remain connected on all of their devices and from any location.  Online describes a working model that many businesses strive for, and software makers are seeking to capitalize on the trend.

The belief that software should no longer be installed and run from a local device has been adopted by some of the largest software vendors in the market, which would lead many users to expect that this is the important trend to follow.  Being encouraged to ditch their desktop software products and transition to using the web-based or SaaS alternative, users who have grown to trust their software products are now facing new buying decisions.  Any time a customer is forced to make a buying decision – like moving from a desktop product to a SaaS solution – there is a potential that the customer will go with a different vendor and leave the product line altogether.   Yet this is exactly what is happening with small business applications, and specifically with the tried-and true QuickBooks products – the solutions which had become the cornerstone of small business finance.

Where QuickBooks Pro, Premier and Enterprise desktop editions were the favored and trusted small business accounting solutions, Intuit is now on a wholesale push to get users transitioned to the QuickBooks Online edition.  In doing so, they’ve opened up the door for new competitors, because they’re forcing their QuickBooks users to make a new buying decision.   Assuming that customers will adopt the QuickBooks Online solution simply because it’s “QuickBooks” was perhaps a poor assumption on the part of Intuit.  Particularly by naming the product “QuickBooks”, Intuit invested the trust and long-standing recognition of the brand and product line into the online edition, and the user base and market has not been amused.  “It may be called QuickBooks, but it’s not the QuickBooks I want” says one customer.  Apparently, the QuickBooks Online edition is not what many experienced QuickBooks desktop users are looking for in a new version of the product.

Desktop QuickBooks users don’t have to move to the Online edition just to get the benefits of the cloud with their beloved QB.  The hosting and cloud service providers I work with help businesses run the QuickBooks desktop products as online service.  We deliver fully managed applications and data, allowing users to access their QuickBooks desktop products online and from a variety of devices just as if they were web-based.  Gaining the benefits of anytime/anywhere access with the added advantage of not changing software is a direction many users are electing to go.  While the price of a hosted solution may not be as low as a QuickBooks Online subscription, it is generally far less than a subscription to Salesforce.com, for example.  Isn’t the business financial data at least as valuable as CRM? The price isn’t unreasonable, and the benefits of online/remote access, managed IT, protected data, and an ability to take your ball and go home if you like are huge.  Grab your data file, install QuickBooks on your PC, and you’re back in action.  Can’t do that with most SaaS solutions, can you?  It’s only do-able with desktop software, which you can run in the cloud with a hosting provider or run on your own PC.

Assuming that all software will ultimately run online could be a big a mistake.  As technology advances and new capabilities introduce new complexities, the “heavy lifting” shifts from the center to the end points and back again.  While there may be a trend towards SaaS and leveraging the power of a remote system, the reality is that our devices – desktops and laptops, tablets and phablets and phones – are all getting more powerful.   Many SaaS applications and remote access technologies rely upon (and find ways to push more resource utilization to) the local device.  Video processes more quickly, input and output devices are more easily recognized, and the storage on the device is faster and easier to access.  A lot of work happens on the local device, and it will continue to be this way as the devices continue to get smarter and more powerful.  “There’s an app for that” for a reason: apps on the device work well and give users the functionality necessary to get things done efficiently.

SaaS is not all that’s out there – much of the software businesses know and love is still available the way they want it.  QuickBooks users need to know they can get their QuickBooks online without having to use QuickBooks Online.  The desktop is not dead, and it won’t be for a long time.  Desktop software isn’t dead either; it’s just being pushed to the background as software companies attempt to wrap their arms firmly, with subscription based business models, around their respective customer bases.

Make sense?

J

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