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

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 OnlineThe 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

QuickBooks and Dropbox? Yeah… no.

mobile cloud dataHaving your data available from anywhere is awesome.  Storing files in the cloud and being able to sync them with files on the computer is a great way to make sure the files are centrally available regardless of which machine you use to access them with.  Dropbox is among those favored solutions which provide users with the cloud drive storage and an ability to seamlessly sync those files to various computers.  It’s pretty cool, but let’s face it: not every type of file loves living in a Dropbox or sync folder.  Particularly for folks who want to be able to store and sync their QuickBooks and other business files to the cloud, there are a few things to be aware of when using these nifty sync solutions.

A file is not always just a file.  What do I mean by this?  Well, there are lots of different types of files an application might store and use, and not all of them work the same way.  For example, Word documents are files that only one person can actually work on at a time – there’s no actual “multi-user” functionality when it comes to a Word doc.  You either get the file in a state that allows you to make changes to it, or you get it in ready-only mode.  Document files like this – Word docs, Excel spreadsheets, PDFs and text files – work great with sync solutions. This is because the type of file being sync’d is designed to allow only one person at a time to have it open and editable.  You sync it to your computer, work on the file, and then sync it back.  It’s pretty straightforward.

The file that isn’t just a file is a database – a file or series of files that make up a complete data set, and which have some type of database manager or other framework keeping track of things.  It’s this type of solution that often has problems working in a sync folder or system.  An Outlook data file (a .PST file) is a type of file which fits into this category.  While the Outlook file isn’t generally viewed as a multi-user data file or a database file, it is being communicated with and written to by various processes while the application is running.  There is information being added to the file as emails are received, even while the user may be writing an email or entering a calendar appointment.  The point is that there are multiple types of data elements being updated all the time and by various processes.  This type of file is always in use and getting changes, so there really isn’t a point in time when it’s closed and available to make copies of, which is what has to happen for a proper sync.    And, because the sync solutions often try to sync incremental file changes, there is a big possibility of ending up with a damaged file because some changes were properly written where others might not be, ending up with file conflicts and corrupt data.

A QuickBooks company file is also a database file, so the same issues around syncing an Outlook data file exist with QuickBooks.  When the QuickBooks software is open and a company file is being worked on, the file may get incremental changes throughout the work session.  As each of these little changes happens, the sync program may attempt to copy those changes to the file in the cloud.  Because the QuickBooks file is constantly being updated, the attempt to incrementally sync updates to the file in the cloud can easily cause damage and corruption to the file.  Folks who have attempted to fake a sort of multi-user access to QuickBooks data files by using Dropbox or other sync services quickly find that the system isn’t going to work for them that way.  Further, they often find that the QuickBooks data files can get pretty screwed up trying to manage the live company file in this manner.

 

The only way to use QuickBooks, Outlook and similar types of data files with Dropbox is to recognize that the sync folders are only viable as a backup storage location for the files, not the place where the actual, working data files can be stored.  If using an application such as QuickBooks, businesses should store the “working copy” of the file in the documents area on the machine, and then backup or copy the data file to the sync folder periodically.  Placing the backup files or file copies in the sync folder allows them to sync to the cloud, storing them as offsite backups in case you need them, and allows the file to remain where it can be used by the application.

Businesses who need access to QuickBooks applications and data from different computers or locations may want to consider checking out hosting services as an alternative to a sync solution. Hosting solutions can help businesses get their software and data available anytime, anywhere either from their own PC or from a secure environment so they can access their QuickBooks applications and data from any Internet-connected device.

When a company wants to keep backup copies of their information in the cloud, a sync service might be an okay solution.  For folks who need to be able to access a live file and applications from a variety of locations, or if multi-user access is required (especially if those users are in different locations), then a full hosted solution might be the better answer.  Hosting the applications and data in the cloud is a great way to get the company connected, and it’s a far better alternative to pretending the system can be multi-user when it really can’t.

jmbunnyfeetMake Sense?

J

Hosting Intuit QuickBooks Desktop Editions Delivers Big Benefits for Small Business

Big Benefits with Hosted QuickBooks

diagram_self_hosting-500_289Everyone, it seems, is adopting outsourced IT and cloud computing models yet one size does not fit all when it comes to serving business – whether it’s the software or infrastructure under discussion. Cloud, mobile and online application models deliver big benefits for small businesses, but it is important to know the options available before investing in something that’s hard to get out of later. Initially, a hosted application model might be the best approach, allowing the business to achieve the mobility and on-demand service they desire but without an investment in SaaS solutions that are much more difficult to change out of or grow with later.

When “QuickBooks” and “cloud” are mentioned in the same sentence, most people are likely to think about the QuickBooks Online Edition, which is Intuit’s version of QuickBooks accounting software that was developed specifically for the web.  But QuickBooks Online isn’t the only QuickBooks “flavor” finding success in the cloud.  QuickBooks desktop editions have made their way into online and hosted deliveries, giving customers the ability to run the business and grow the organization with the software they’ve already invested in, but running the apps in the cloud.

QuickBooks Online lacks the features and functionality present in the desktop product lines, and the range of 3rd party applications which integrate or work in conjunction with QuickBooks desktop is huge and continues to grow.  Developers with SaaS products often find that their target customers prefer the desktop editions of QuickBooks, even though there may be connections to QBO available.  All of these connected software products can be hosted with or connected to hosted QuickBooks, providing businesses with mobile and remote access for all their business applications, not just the web-based ones. *Note: not all QuickBooks hosting companies will also host whatever 3rd party integrations a business needs, so make sure to verify before you buy! What sounds like a great hosting deal now could turn into something you need to change later.  The good thing is, you can change…. unlike with QBO.

The popularity of desktop application hosting continues to grow because users have investments in software, data and business processes. Adding remote access and mobility doesn’t require an entire change of software, but it does introduce new benefits that can have a big positive impact on work quality, productivity and efficiency. QuickBooks hosting models and application hosting in general gives business owners a basis for helping employees balance (or integrate) work and life time and activities, and addresses the issues of data security and mobility by keeping information securely stored on the host.

Better information security, work/life balance, mobility, making the most of your existing investments and creating sustainability in the business so you can grow. These and more are benefits of hosting QuickBooks software for your business.

jmbunnyfeet Make Sense?

J

 

Better QuickBooks Access, Management and Security – QuickBooks Licensing and Hosting Models

Whether hosted in-house or offsite, licensing models for hosting QuickBooks can be very confusing.

driving1-ANIMATIONThe demand for solutions to address user mobility, better collaboration and improved information security is increasing as connectivity improves and cloud services and threats evolve. Server-based computing models and application hosting are increasingly popular as businesses seek to embrace teleworking and telecommuting models for their entrenched applications and systems, creating a foundation for improved productivity and work/life balancing (or integration).  On the technical side, the benefits of centralizing applications and data include improved efficiency in managing, maintaining and securing systems. For many small businesses, this means centralizing the installation and maintenance of core business applications like Intuit QuickBooks Pro, Premier or Enterprise.

Whether it be offsite with a commercial hosting provider or on a co-located server somewhere, or an onsite installation on the in-house server, hosting Intuit QuickBooks licenses can be straightforward or complicated depending on what you are trying to do with them. Because QuickBooks was designed as a standalone single-user application, there are a number of challenges when it comes to preparing it for server-based use.  The primary issue is often simply understanding the QuickBooks licensing model, which is not particularly INTUITive (sorry).

Licensing hosted QuickBooks applications comes with two different sets of implementation issues: the technical implementation (the installation and setup) and the logical allocation of licenses to users (the licensing rules).

When it comes to the technical implementation, many an experienced engineer has beaten their head against the wall trying to get QuickBooks to work properly in a workspace or session-based system (e.g., terminal server), all because they expect the product to implement like a “normal” client/server application. While QuickBooks may use the Sybase database manager guts to handle multi-user access to QuickBooks data files (I think it is still Sybase), the architecture required to properly service a networked QuickBooks installation does not necessarily mimic what would be used with, for example, a .NET desktop client application with an MS SQL back-end.   First, the QuickBooks data files cannot be remote to the application, meaning that both the client and the database manager (which is actually working as an adjunct to the client) must exist on the local network; it will not work over a WAN connection, which is why so many folks get frustrated when they put their server “in the cloud” and attempt to connect from a local client using a VPN.  It just won’t work that way with QuickBooks; it all has to be on the local network – client, server, data… all of it.

It is notable that many businesses use Dropbox and other file sync solutions because they want to be able to get to their data from multiple locations, but the data they’re getting must be “local” to the apps that use it.  It doesn’t allow for simultaneous multi-user access, but it can be an effective way to share a file.  The caveat is that the file (at least in the case of a QuickBooks file, or Outlook PST file, etc.) should not actually be used from the sync folder.  Sync folder should contain copies of data files that users wish to sync or share with other devices.  But I digress…

With a server-based implementation of QuickBooks, technicians will install the QuickBooks desktop software on the server, and will determine whether or not that same machine will also handle the company data files.  The QuickBooks DB manager is part of the installation of QuickBooks, and the file system and drive where the QB files are to be managed must be recognized as a local drive on the server running the QBDB manager.  The overhead used by the database manager isn’t huge, but it can impact the performance of users on the server.  For this reason, some techs will decide to implement a separate file server to manage the QB data files, taking that load off the app server.

  • The QuickBooks software uses the database manager to “host” access to company files.  This simply means that a single server with the data on it is providing managed access to remote-desktop-sessionsQuickBooks application users.
  • When QuickBooks application software and data is installed and centrally managed on a server (instead of QuickBooks being installed on individual PCs), that means QuickBooks application is being “hosted” on that server.
  • When a 3rd party provider supplies the server, the QuickBooks installation, data storage, and your way of connecting to it all,  that provider is a “host” providing hosting services for your QuickBooks.

In a dedicated hosting environment, the data is often stored on the same server as the applications, whereas in a shared hosting environment, the data is often stored on central file servers which serve multiple customers. This is why, in some shared hosting situations, one bad data file can take down the database manager services for all the customers using that same file server.

Users open the QuickBooks application on the server instead of having the application installed on individual PCs.  The single server-based installation of the software is able to be used concurrently by all users logging in to that computer. With the database manager running, the file is essentially “hosted” on that machine, and the file may then be opened in multi-user mode.  OK so far.  The problem generally comes about when a second user on the same computer/server wants to open the same QB data file as the first user.

Because the QB database manager is looking at the license of the client application accessing the data file, it will recognize when two different users/sessions with the same license key attempt to open the company data file.  If that license key is a single-user key, then the database manager knows it should allow only 1 concurrent user in the file.  QuickBooks doesn’t get installed for each user on a computer or server; it is installed one time on the machine and each user on that machine runs from that single shared installation. Any particular version of the QuickBooks application may be installed only once on a single computer, but it is possible to install multiple editions, year versions, and “flavors” of QuickBooks on a single machine (cannot be more than one installation of each unique product). There will be more than a few annoyances when running a variety of QBs on the same computer, but it is technically possible.

In order to allow multiple users to simultaneously access the same data file from a central installation of QuickBooks, the license key installed on the computer must be a multi-user key.  QuickBooks Pro, for example, can be keyed to 3 concurrent users, meaning that the license will allow up to 3 users with that same license key to simultaneously access the same company file.  Technically (but not lawfully) this installation of QuickBooks on the machine could allow a virtually unlimited number of users to launch the QuickBooks application simultaneously, limited only by machine resources.  This is where the logical allocation of licensing comes in.. the rule of licensing QuickBooks.

The logical allocation of unique licenses for each QuickBooks user is a little easier to understand than the technical implementation.  The rule is simply that each user of QuickBooks is required to have a valid registered/activated license. That valid license is a license purchased and activated for that business.

total-businessMaking QuickBooks desktop editions more useful by adding secure remote access and centralized management makes a lot of sense.  For companies who rely on the functionality and features of the desktop products (QuickBooks Pro, Premier and Enterprise), a hosted approach is the only way to really address mobility and multi-location requirements.  Remember that hosting doesn’t necessarily mean offsite, although that could make sense for the business, too.

Centrally-managing QuickBooks applications and data creates greater efficiency and improves overall IT management capability for the business.  At the same time, a centralized model introduces a better strategy for mobilizing the workforce and connecting remote users and offices. The struggles of understanding and implementing proper QuickBooks licensing begin to seem very small when compared to the benefits of deploying a centralized system that’s easier to access, manage and secure.

Make sense?

J

Intuit QuickBooks 2014: Another Move Towards Unification of Features and Software as Service

Intuit QuickBooks 2014: Another Move Towards Unification of Features and Software as Service

qb2014Intuit QuickBooks is the recognized standard for small business accounting, and the introduction of the QuickBooks Online Edition was a testament to Intuit’s understanding that users are looking for SaaS solutions as well as traditional desktop products.  While it may seem that the entire market is moving to online applications and everything-as-a-service, the Intuit desktop products remain the leading business computerized accounting tools.  Intuit does seem to recognize that many things can be done better with a “software-as-service” model , and that the number of businesses seeking purely web-based solutions is growing, and this is evidenced by the fact that many features and presentation elements in the Online edition are making it into the desktop editions.  Creating consistency throughout the product line makes sense for users, and leveraging the benefits of shared service makes sense for Intuit.

In a previous blog article entitled Changing How We See Software: QuickBooks 2013 interface frustrates power users, I had suggested that many of the interface changes introduced with the 2013 QuickBooks desktop editions were a step towards unification of interfaces (to the degree possible) between desktop and Online editions.  Additionally, integrations with various connected services, Intuit payroll and payment solutions, and other online service elements clearly demonstrate that certain functionality and service offerings will be provided consistently through either solution set.  Another new “unified” feature announced for QuickBooks desktop is the Income Tracker, a feature that originated with the QB Online edition.

The Income Tracker provides you with a fast way to see the status of your unbilled and unpaid transactions, and provides you with features to improve billing/collections as well as perform a number of batch procedures… This feature was first developed in QuickBooks Online, and this year Intuit has brought it into QuickBooks Desktop

http://www.sleeter.com/blog/2013/09/quickbooks-2014-income-tracker/

The introduction of a purely subscription licensing model for the desktop products is yet another move towards enabling the pay-as-you-go subscription model for purchasing software.  Businesses are able to purchase “plus” subscriptions, which provide not only perpetual most current version software but also deliver support for the life of the subscription.  This is another change from the more traditional boxed software approach, where the product was a one-time purchase and came with short-term or limited support.

It seems that many of the changes introduced with 2014 indicate that online service and subscription pricing models will continue to introduce themselves into the QuickBooks desktop products, and users who change from one solution to another in the product family will find more familiarity and consistency in the attached Intuit services they also use.

Many independent software vendors and developers of business applications are recognizing the value of subscription service models and the benefits of leveraging web-based applications and shared services within their solutions.  For software companies, turning a one-time sale into a recurring revenue stream is highly desirable.  From a development perspective, one project could service the entire product line, rather than efforts being divided among multiple products.  From an operational perspective, infrastructure and personnel are able to centrally service the functional requirement, providing the same benefits of shared service that users of SaaS solutions experience (it may simply be internal rather than external customers being served).

The point of the discussion is that, while QuickBooks desktop editions may not be going away any time soon, there is wisdom (and business necessity) which is likely to drive even more subscription model SaaS inclusions in those products that were once purely and firmly planted on the desktop.  Even good old QuickBooks must change, and for the most part, users are seeing benefit in those changes.

Make Sense?

J