QuickBooks 2018 Updates and Enhancements

QuickBooks 2018: Changes You See and Updates You Can’t See

QuickBooks 2018 has been released, and there are a number of beneficial enhancements and changes to the application that many will find very useful.  Sometimes it is the little things – like a past-due stamp that can be printed on invoices when they are re-sent to a customer – that can make getting the work done just a bit easier. Being able to search the chart of accounts is another thing that doesn’t sound like a big deal, but becomes one when you just can’t remember the account number you’re looking for. Frequently having to scroll through the list of accounts is taking more of your time than you’d think it would.

For the most part, it looks like there are some nice and needed changes that come with QuickBooks 2018. These changes address some functionality and usability issues (like supporting multiple monitors) and are visible to the user.  There are also other important changes that come with QB 2018 editions that aren’t quite as visible.

All editions (Pro, Premier and Enterprise) in the US, Canada and UK got some common updates, including:

  • Multiple monitor support
  • Search in the Chart of Accounts
  • Cash/Accrual toggle on reports
  • Past Due Stamp
  • Keyboard shortcuts for copy/paste lines in transactions
  • Secure Webmail option

For folks using payroll, there are now useful reminders for payroll tax liabilities, and for accountant edition users there is now the ability to merge multiple vendor records.  An exciting feature for many users of QB Enterprise is improvement to the sales order fulfillment process, including support for mobile (un-tethered) barcode scanners.

The changes that remain less visible to the user are primarily component updates and security improvements.  Additional encryption for certain PII (personally identifiable information) fields, version updates of framework and database components, and reliance on Internet Explorer v11 are among the items addressed. While these are not visible changes that impact the program functionality directly, they are necessary to keep the product up to date with Windows platform and to modernize the security in the product. In particular, users should pay attention to the requirement for Internet Explorer v11.  While Microsoft continues to promote Edge as the power browser for Windows 10, it is Internet Explorer v11 that QuickBooks requires.

It is important to note that Intuit‘s support for 3rd party applications is sometimes impacted with QuickBooks updates, particularly when it comes to security, encryption and unattended access to QuickBooks data.  Changes made to how QuickBooks encrypts stored credentials (among other things) caused many 3rd party solutions to lose their ability to connect to and sync data with QuickBooks while unattended (like a middle of the night sync, when nobody else is working).  Many applications had to return to a user-attended sync process, where a user in QuickBooks had to manually initiate the sync which allows the application to connect to QuickBooks and run.  With the release of QuickBooks 2018 this issue remains, which means that you should check with your 3rd party software provider regarding any possible automation changes or additional configuration that might be required due to the update.

For those running QuickBooks in a server-based or hosted environment, there are a few additional considerations regarding some of the changes in QuickBooks 2018. Some of these items represent known technical limitations of working in a terminal server/RDS/hosted environment, and sometimes they’re limitations or restrictions based on the technology being used and how it is applied. It is in this area where the suggestion that hosted QuickBooks will work EXACTLY as the program does when locally installed is not entirely true.

Multiple monitor support, for example, may or may not be easily handled by your hosting provider or remote access solution.  In particular, if you access your hosted service as a Remote Desktop or Virtual Desktop, you may have only one actual Window (the remote desktop window) to work with.  Even if your hosted QuickBooks were to attempt to open multiple popup windows so you could move them to different monitors, you’ll still be limited to the dimensions of your remote desktop. If the remote desktop doesn’t span over multiple monitors, then the QuickBooks windows that open in the remote desktop window won’t either.

The option to keep a user logged in to QuickBooks is another item that may not be useful or workable in a hosted environment, and isn’t necessarily a great idea even if running QB on a local computer.  This option keeps the user logged in to the QB “instance” which can make working with lots of company files a bit faster and makes loading/unloading QB seem faster because it doesn’t really unload or shut down.  While it may be convenient to eliminate the wait times during these login processes, the offset in security risk and problematic application functionality may be higher.  Leaving a user connected to QB for a fast login means that an unattended PC becomes a vulnerability as someone could access the app and files without having to enter credentials every time.  In a hosted environment, the functionality tends to leave QuickBooks running in a user session, often causing the user to be unable to launch QuickBooks if they log off and back on to the host system (getting the message that QuickBooks is already running or the company file is already open).

Support for 3rd party integrations varies in hosting environments, too, but the granting of administrative permissions to users is largely consistent: users do not get administrative permissions. This means that some applications which require Windows administrator permissions to run cannot be easily handled in a hosted delivery.  Additionally, applications that run as services on the computer, and particularly those with controls accessible via the task manager, are difficult to manage in a hosted environment because users are generally not able to access the task manager on the machine to start or stop running services.

Among the most challenging items to support in a hosted environment are mobile and handheld scanning devices.  Mobile scanning devices have become essential tools for inventory and product management, providing users with the ability to rapidly access item information by simply scanning a barcode.  Manually keying in data increases the potential for errors, but also requires a machine with a keyboard be nearby. With mobile scanners, workers are able to input item information regardless of whether they have a computer nearby or not (which is often the case in a warehouse or out on the shop or store floor). The software sees the barcode scanner input as though the data were typed in, which eliminates input errors and failed lookups by ensuring the item number is correctly entered every time.

Where the challenge with a hosted solution comes to play is in communicating between the hosted software (QuickBooks in this case) and the scanner device.  Usually, a scanner must be able to “see” the computer running QuickBooks on the local network.  The scanning device, like a networked printer, is able to communicate directly with the PC on the network so it is able to work with the software running on the PC.  When the QuickBooks software is running on the hosting provider’s computers, the mobile scanners in your business location aren’t able to “see” the host computers on the local network so they may not be able to communicate.

The time for software upgrades is also the time to take a look at how you’re implementing the software to ensure that your business has the most effective and easy to manage system possible. Rather than simply installing the new version on top of the old, consider whether your systems and software might be handled in a more cost efficient and useful manner.

If you’re installing the new QuickBooks editions in-house, maybe it makes sense to take a look at doing a server-based approach, which reduces the number of software installs required, centralizes the access and applications which makes managing the system easier, and creates a single system to back up and administer.

If you’re looking to eliminate the burdens of installing and maintaining your software, backing up your systems and dealing with hardware issues, moving to a managed hosting solution may be the right answer.

Software upgrade time is the right time to explore these options, giving your business the opportunity to test out new delivery models and services without impacting the production system.  There is always some element of risk in updating applications, so it is important to make sure things are ready before starting the process. Make sure all systems are fully backed up, and make sure you have the tools necessary to re-install the old versions of your applications just in case there are changes you can’t work with or problems you didn’t expect. If you’re not sure the best way to approach upgrading your QuickBooks system, contact me and we’ll find the right answer together.

Make Sense?

J

Focusing on Transformation

Focusing on Transformation

In January of 2007, Network World published an article stating that “user satisfaction with software as a service (SaaS) is starting to slip, but customer interest in this method of outsourcing IT functions is continuing to grow“, and says that recent survey results clearly demonstrate SaaS being “a dominant force going forward”.  That was 10 years ago, yet the same message is being played out today as managed services and hosting continues to grow in popularity. IT outsourcing makes sense for thousands of businesses, whether the software is part of the package or not. Today, outsourcing IT is almost an imperative if the business is to keep up a competitive pace.

Users need and demand mobility and will get their anytime/anywhere access to applications and data however they can get it. Businesses require agility in their technology, which is difficult when significant investments in hardware and infrastructure must be earned out prior to any new investment. Making systems accessible from outside the firewall, securing them in a reasonable manner and keeping them up and running all the time so users can access at any time is not a job for part-time IT.  Keeping the systems on and available at all hours requires full-time IT management, and this is in part what fuels the popularity of outsourcing it all.

SaaS (Software-as-a-Service) goes a long way toward helping businesses manage their IT costs in that the systems are part of the service.  The hardware running the application, the storage of the data and the support accompanying the solution are all part of the package.  Unfortunately, the SaaS solutions is not generally the only thing in use by the business, so continued reliance upon PCs, desktop software and locally stored data causes IT management costs to persist.  One size does not fit all, even with online application services.  Although customizations and add-ons can help a single app become a broader solution framework, there is usually something left behind that ends up anchoring a process or function to the desktop, device or local network, and requiring IT management and administration to go along with.

Application hosting services compete somewhat with SaaS in that the systems and management of them is included in the hosting service subscription fee.  While the business user retains licensing of applications and the flexibility of using the software already embedded in the operation, the organization is enabled to focus on operational improvements and not on the underlying systems supporting them.  By reducing or eliminating the requirement to directly manage and maintain servers, complex networks and user working environments, businesses are able to focus their in-house technical energies towards innovation and improvement. The centralized nature of the system facilitates new collaborative capabilities while allowing the business to build on the knowledge and base of information already invested software and processes.

Outsourcing IT service provisioning and management is just a baby step towards improving the business agility and positioning the organization for growth. Real digital business transformation begins with a change in the business mindset: not simply a focus on operational processes and improvements, a new strategy should evolve where the enterprise is situated to interact with its market seamlessly, at any time and all the time.  Businesses that wish to compete at this level must consider whether or not purchasing and maintaining their IT infrastructure is where they wish to focus their energies or if they’d rather invest their technical talent towards market building and transformational objectives.

Make Sense?

J

Should You Take Your Practice To The Cloud?

I’ve seen a lot of articles lately (and written more than a few myself) directed towards accounting professionals and “taking your practice online” or “taking your practice to the cloud”.  At this point, when a professional asks me the question “should I take my practice to the cloud”, my response generally comes in the form of two return questions.

The first is “what leads you to believe you have a choice?”

The second is “what makes you think you haven’t already?”

There are a few realities about doing business today that can’t be ignored and cloud computing is at the top of the list.  Professionals can recognize these realities and work with them or fight the changing tide and lose out to more relevant providers.

To address the question of choice, let’s consider the fact that many of today’s entrepreneurs and small business owners have been exposed to Internet services and online technologies for quite a long time.  Use of these services has become an ingrained element in daily life.  Not using online technologies seems “old school” to these folks and is often perceived to be due to some deficiency in the ability to understand or use new tools.  If professional service providers aren’t able to leverage online tools to provide the access, collaboration, and higher level of service which business owners demand, they won’t work with those business owners for very long.

In addressing the “what makes you think you aren’t already?” question, let’s consider the fact that almost all of the accounting software offered today has incorporated cloud-service or Internet-based functionality in some manner.  Even the tried and true desktop editions of QuickBooks financial software  have quite a lot of web service functionality designed in to the product.  Where credit card processing was once an offline (or telephonic) process, it’s now an instantaneous service delivered via the net.  Payroll?  Tax tables aren’t just downloaded to the software where you perform the processing and calculations.  Payroll is a service, delivered via Internet connectivity to Intuit’s payroll service bureaus (or ADP, Paychex, etc.).  Even banking is less traveling to the establishment and more Internet access and data exchange.   We don’t think twice about downloading transactions from the bank computers instead of working from the paper bank statement.

Internet/web/cloud service and functionality has become a pervasive element to almost every aspect of software and computerized business support systems, and it’s a pretty good bet that your firm is already using it. So, let’s not spend our time asking a silly question about whether or not it makes sense to “take the practice to the cloud”.  The obvious answer is yes.

Make Sense?

J

 

Original article: Should You Take Your Practice To The Cloud? You’re Still Asking?

Cloud and Digital are Driving Change in Professional Practice

Accounting and Finance Professionals: Cloud and Digital are Driving Change in Professional Practice

Accountants and financial consultants working in public practice are experiencing a revolutionary change, evolving from documents and paper-based processes with after-the-fact reporting to real-time business management and providing services which support daily decision-making.  The underlying cause for this evolution in business accounting is the technology: cloud and collaborative computing models are enabling much closer and regular interaction between accounting professionals and the businesses they serve. Even more, technology is taking its proper place in automating once tedious activities, allowing professionals to focus on causes and results rather than on transactions.

What is the real impact this is having on the accounting profession?  It’s forcing a new focus and attention on change management within the practice, and is causing professionals to recognize the requirement for standardization of processes and development of controls which are the foundations for creating sustainability in a business.  The goal now is placing reliance on process rather than people, which establishes the basis for intelligent automation.  Standardization of processes does not require that the firm lose its personality.  Rather, the mission at hand is to imbue the organization with its unique flavor and approach and to use process automation to develop and support consistency in the functions performed.

While cloud computing models allow accounting and finance professionals to work closer with their business clients, it is important that the practice look at those client interactions and develop standards for processes supporting frequently performed functions.  These operations generally represent the activities within the firm which generate the highest levels of profitability due to the consistency in approach and repetition of tasks, and are the activities to apply intelligent automation to first.  Those activities or engagements which represent the “one-offs” are often the most costly for the firm to perform, and therefore may not be the most profitable of activities and are certainly the most challenging to support with any significant level of automation.  It is in this area where AI will find useful value in the practice, where a more informed answer than simple process automation is required.

The surprising finding when looking at many professional practices with more than one partner/professional involved is that these firms often fail to develop even the most basic of standard processes which apply throughout the firm.  Rather, each partner or professional has “their way” of handling things, which challenges the supporting personnel as they try to deal with multiple working methods. The result is a lack of consistency in the service delivery to the clientele and reduced productivity and profitability for the firm.

The thing that these firms are failing to recognize – the light bulb over their heads that just isn’t lighting up – is that cloud computing and collaborative working models aren’t designed just to enable and facilitate a closer working relationship with clients.  They’re also able to be applied inside the professional practice, enabling a more productive and efficient workflow which addresses the strengths and capabilities of the entire organization. And it doesn’t stop there.  Businesses are relying upon their accounting professionals to provide guidance and develop controls and standards to support the client transformation from paper-based to digital operations, and embracing the entire realm of data and interactions associating with the business. Digital transformation in a client business demands transformation in those firms who serve it.

As professionals learn to go deeper in client operations they would do well to look internally, too, exploring how increased attention to process automation and consideration for the firm’s own “digital transformation” might lead to great profitability through market differentiation and improved performance.

Make Sense?

J

Centralize and Secure Business Applications and Data

laptop drawingThe portable computer is an essential business tool for day’s mobile workforce, having the power and portability to meet the demands of executives and professionals working away from the office.  While executives and mobile professionals get the applications and data they need to keep productivity high, carrying business data on devices outside the network introduces significant business risk.

There are studies which estimate that as much as 80% of the data a small business owns (data like customer files, contracts, product information and financial data) is copied to or stored on portable computers.  When valuable business data is lost or stolen, the business can be exposed to a variety of problems – loss of revenue being just one. Losing track of business data can create legal issues, too. Customer privacy may be compromised, sensitive information could be exposed, or confidential plans might be made public if a business doesn’t take the right steps to secure its data.

It isn’t just the possibility of loss or theft which increases risk when data is copied to portable computers – the increased vulnerability of the information sits with the likelihood that the user will access unsecured networks, launch non-corporate applications, access private email accounts and perform other non-business related tasks with the computer because they have more access than with a fully secured corporate in-office desktop.  User behavior is often what puts corporate data and assets at risk, regardless of the policies that might define correct and acceptable procedures. It is very easy for workers to unknowingly lose and leak data, and when the data is present on the portable computer it gets even easier.

A 2014 study commissioned by Cisco Systems found that employees around the world continue to engage in “risky” behaviors that put business and personal information at risk:

  • The majority (70%) of surveyed IT pros believe that as many as half of their data loss incidents are due to authorized program installations
  • 44% of employees share work devices with others without supervision
  • 39% of IT professionals have dealt with employees trying to access unauthorized parts of the company’s network
  • Almost half of the employees admitted to copying data between work and personal computers when working from home
  • 18% (up to 25% in some regions) of employees shared passwords with their co-workers

Companies must not only protect their data for their financial well-being, but must recognize their legal obligation to protect much of the information, as well.  The risk extends beyond the walls of the enterprise, to vendors and customers and consumers whose information may be stored in the company data. Additionally, portable computers exposed to malware and virus attacks are likely to pass the bad code to other systems they come in contact with, introducing not just risk for the recipient but liability for the infected laptop owner.

Where mobile computing brings huge advantages to today’s business, owners would do well to consider the benefits of enabling mobility through the use of server-based and hosted computing models. Rather than installing software and copying data to PCs and mobile devices, workers should be able to access a central system where the applications actually run. IT management is more efficient and security is easier to enforce when applications and resources are contained exclusively within the corporate boundary, even if they are accessible from without.

Virtual desktop and remote application solutions offer features that address a variety of potential risk factors as well as enabling improved management and security of IT assets.  Centralizing and securing applications and data resources at the server allows businesses to deliver the mobility and functionality users need while enabling the information security and management the business demands. This is a foundation upon which remote desktop and remote application technologies were built, allowing users to have the real-time access to applications and data with full functionality and desktop modality, but without the requirement to install, manage and secure applications and data on the individual devices.

Make Sense?

J

Remote applications, virtual desktops and hosted QuickBooks

Cloud computing and SaaS applications are all the rage, and businesses are finding tremendous benefits with the mobility and managed service these models provide.  On the other hand, there also continues to be huge reliance on the desktop computer and the software running on it. From basic productivity tools to more advanced business solutions, desktop-based software and locally installed applications remain in favor for the vast majority of businesses around the country.  Adoption of web-based solutions is certainly increasing, but the need for tried-and-true business applications that were traditionally installed and managed directly on the PC or local network doesn’t seem to be going away. At least part of the reason for this is the functionality and performance these applications deliver.  Another factor is that hosting and remote access solutions have matured to the point where hosting applications is just as “mainstream” (and often more useful to the business) as using a SaaS solution. Managed application hosting models have made solutions like Microsoft Office and QuickBooks desktop editions available anytime, anywhere and using just about any device. I call hosting the best “tweener” solution available, because users can have the functionality they need and still get fully managed, on-demand service.

Back when a few businesses started operating as Application Service Providers (ASPs), there were a limited number of realistic approaches available for building the platform to deliver desktop applications.  Many application hosting offerings grew somewhat like a fungus from the internal Citrix Metaframe and terminal service set ups performed by IT service companies.   A lot of these companies didn’t start out to provide application hosting services; they simply found it to be more efficient and profitable than trying to manage all that hardware and software at the client site.

Over the years, a variety of solutions have been introduced to ease the burdens of implementation and management of desktop applications on centralized platforms, but most of them were designed more for enterprise deployment rather than as the basis for a generalized service offering.  Microsoft’s Remote App and Remote Desktop services, Microsoft and Citrix and Dell (Quest) app virtualization/management/publishing, even streaming and “containerized” applications… there are quite a few options out there and, in some circumstances, they can work pretty well.   What has kept them from working out REALLY well, however, is the cost and complexity of deploying these solutions.  From printing problems to user device support to simply allowing a user to gracefully reset their connection when it gets stuck…  application and desktop delivery platforms can be very difficult to set up and manage.

My team works with a number of solutions which address these aspects of application and desktop delivery, bringing the functionality to a level where small businesses and their IT service providers can easily set up secure remote access and hosting environments that actually work.  This includes addressing the printing facilities, user management, app and desktop publishing, workspaces administration, and connection management that makes a remote desktop or app deployment useful. For IT folks, the fact that no special firewall configurations are required and that a static IP address is not needed means that our solution for on-prem can work where many VPNs and web portals can’t.

Remote Desktop services (Terminal services) is the most widely recognized approach for creating “virtual” desktop or hosted application services.  It solves many of the problems involved in centralizing the management and administration of computing resources and applications for broad bases of users, and it’s pretty much the only game in town when it comes to putting traditional desktop applications online (or putting the desktop online).  This approach, which is essentially packing all of the computing requirement into a centralized infrastructure, is the most effective method of addressing the total business requirement (e.g., hosting all the business applications with associated data, administering user security and access, and managing the entire system) at any significant scale.  Each of these methods of providing managed applications require that the entire realm of solutions – the main applications, all integrations, drivers for devices to be supported, and all associated data – exist on the service provider servers and under the service provider’s control.

Our services deliver a simple and straightforward set up so you begin using the platform right away; seamless and affordable.

Joanie Mann Bunny FeetMake Sense?

J