Into the Sunset with QuickBooks 2018

Every year when the new editions of QuickBooks desktop editions are released, Intuit discontinues services for certain older versions. This is referred to as the sunset of the version. In general, a QuickBooks desktop edition can live for up to 3 years. After that time, all bets are off. The software might continue to work, but connected services won’t, and there will certainly be no security or compatibility updates beyond that point. For businesses using QB 2018 and planning to continue using their QuickBooks software and data – you need to upgrade your QuickBooks software now.

Intuit generally notifies customers in various ways about the discontinuation of QB editions. Granted, there is a lot of other advertising about QuickBooks that users receive, so it isn’t unusual for these notices to be missed. But the software will also tell you, and those notifications shouldn’t be ignored.

May 31, 2021 marks the end of access to add-on services for QuickBooks Desktop 2018 (Windows).

This means that all Windows versions of QuickBooks Desktop, including Pro, Premier and Enterprise 18 will no longer be able to connect to add-on services like payroll or merchant services. For Pro and Premier users, the software will continue to run, but there won’t be any availability of add-on or connected services or live technical support.

From Intuit: “Your access to QuickBooks Desktop Payroll Services, Live Support, Online Backup, Online Banking, and other services through QuickBooks Desktop 2018 software will be discontinued after May 31, 2021. “

The discontinuation (sunset) also means that you’ll no longer get critical security updates for the QuickBooks 2018 software. With this being the case, and especially if you expect to continue using your QB 2018 software without connected services, make sure to install all security and other updates your software receives prior to June 1, 2021.

Here’s the list of products impacted by the discontinuation of services after May 31, 2021.

If your business uses any of these services and you want to continue using them, your option is to upgrade to the latest version of QuickBooks Desktop

  • QuickBooks Desktop Pro 2018
  • QuickBooks Desktop Premier 2018 (General Business, Contractor, Manufacturing & Wholesale, Nonprofit, Professional Services, and Retail)
  • QuickBooks Enterprise Solutions 18
  • QuickBooks Premier Accountant Edition 2018

Products for which services will be discontinued after April 27, 2021

QuickBooks Desktop Point of Sales 18.0 and 19.0 will lose access to QuickBooks Desktop Point of Sale 12 payments services

Products for which services will be discontinued after August 10, 2021

QuickBooks Desktop Point of Sales 18.0 will lose access to QuickBooks Desktop Point of Sale 18 payments services

Mendelson Consulting was the first and remains the best source for QuickBooks Enterprise and other QuickBooks software solutions and services.

If you know what you need and just want to get your updated QuickBooks software now, visit The QB Store now to buy online. It’s fast and easy and you’ll get your new software right away.

When you need a consultation regarding which editions of QuickBooks might be right for you, the team at Mendelson Consulting will help you select the right product. For data conversion, implementation, training, file repairs and any other services around the use of QuickBooks, Mendelson Consulting is the place to go.

The NOOBEH Cloud team, specializing in deploying QuickBooks on Azure, provides fully-managed hosting and cloud IT consulting to help your business implement a platform that delivers the resiliency and performance you need to keep things running smoothly.

Intuit Reduces Migration and Support Options For Moving From QuickBooks Online to QuickBooks Desktop

Mendelson Consulting Offers Cloud and Migration Options

Need to convert data in QuickBooks Desktop to QuickBooks Online? You can get help from Intuit with this. Need to go the other way and convert from QuickBooks Online to QuickBooks Desktop? Not so much… So please read on.

In a surprise (and very quiet) announcement to QuickBooks Solution Providers, Intuit recently announced that it no longer freely provides data export functionality that allows businesses to convert their data from QuickBooks Online to QuickBooks Desktop. As of 12/18/2020, if you want to move your data from QuickBooks Online to QuickBooks Desktop, you have different options for how to do it and will get less support from Intuit in the process.

It is no great surprise that Intuit made this move. Even prior to ending the service, exports from QuickBooks Online to 2021 versions of QuickBooks Desktop had become quite difficult anyway. Requiring users to login to their Intuit account to create a new company file interrupts the QuickBooks Online attempt to create a new file in QuickBooks Desktop during the conversion, so the entire process became broken. (Note: Our solution is to create the new QuickBooks Desktop file in an earlier version of QuickBooks that does not force the Intuit account login, for example 2019, and subsequently upgrade to the latest version 2021).

The QuickBooks Online web-based service locks you into a subscription, delivering recurring revenue to Intuit. Logic follows that now it has become more difficult to get the data back out of QuickBooks Online in a useful way.

Intuit is still allowing businesses to migrate list data out of QuickBooks Online (think Customers, Vendors, Items lists only), but this is not a very clean process for migrating an entire company data set. Particularly since it involves exporting lists to Excel, manipulating or massaging the data and then importing into QuickBooks Desktop. You can see how this introduces a variety of ways to mess it up. And still this does not get the historical transaction data.

Another consideration is that QBO allows businesses to alter the screens and data stored in the product, and to use that data in ways that QuickBooks Desktop doesn’t necessarily understand. For example, simply adding a field called “job” to invoices in QBO does not mean that QuickBooks desktop would see that data and recognize it as a Customer:Job. That field in QBO doesn’t actually mean anything other than to the user so it isn’t something that could be automatically understood in a conversion. For any conversion of data to be done properly, there needs to be a clear understanding of what data is stored in QB Online, how it is used, and how that data needs to be translated to QB desktop.

Mendelson Consulting has a team of experts available to help with converting your QuickBooks Online information into useful QuickBooks desktop data, offering a thorough review of QBO is being used and mapping that information to how QuickBooks desktop should be set up and the data migrated. Better than a blindly automated process, this option for converting your QBO data to QBD provides a much greater assurance that the financial and other business data is migrated correctly and properly.

What about cloud? There is actually a better option than QBO for businesses that want to benefit from managed infrastructure and anytime/anywhere cloud models, and it does not require that the business lock itself and its future in a web-based application like QuickBooks Online. The better option is to have QuickBooks Desktop and other applications in a private cloud, as with NOOBEH’s QuickBooks on Azure service.

Our options for QuickBooks Desktop in the cloud offer far more than just QuickBooks. NOOBEH does not lock you in to any specific software application, version or working model. Rather, we provide businesses with the ability to run all their applications and manage their data in a familiar Windows environment, but not be tied to any hardware or physical location.

Running applications and data on private Microsoft Azure cloud servers lets even the smallest of businesses benefit from enterprise-class technology and IT platforms and get them affordably. The best part is that there is no vendor lock-in and no limitations on moving to other applications or services. If business needs change, NOOBEH can help the environment adjust to what the business needs, and not the other way around.

When the business needs more functionality, more application support, more process support and more flexibility to meet changing needs and conditions, then the business needs Mendelson Consulting and Noobeh.

jm bunny feetMake Sense?

J

Connecting Your Web Store to QuickBooks on Azure

If you sell products via the Internet using a web store or shopping cart application, then you are probably facing the problem of getting your order and sales activities into QuickBooks and then getting shipping and product information back into the web store. For some, the additional need is to mirror the products and pricing information between the inventory management or financial system and the web store. In many businesses, this is a big chore and requires literally hours of redundant data entry and updating.

As with any manual process, there are many opportunities for errors and mistakes which ultimately cost the business both time and money.

Online selling is a dynamic business, and the sale is made when the customer is ready and willing to buy and the seller has the item available at the right price. The web store (ecommerce system) exists to process this sale in order to meet the immediacy of customer demand. If the system is not up to date with current product or pricing information, then the customer may not find what they want, and the sale is lost.

This means that the connectivity between the online selling system and the inventory/accounting system is of paramount importance in the ability to do business.

Synchronizing inventory information between the web store and the inventory/accounting system ensures that product and quantity information is updated on the web as product is sold and shipped (or received in). At the same time, importing invoices and sales receipts into the accounting system helps to ensure proper and accurate recording of sales and payment information and improves tracking of accounts receivable, shipping charges, and sales taxes.

cloud-small-business

To make this connection between the Web store and the inventory/accounting software, an integration solution or connector is generally required. The connector gets installed on the same systems as the inventory/accounting solution (on the same systems as QuickBooks, in this case) and provides the mechanism to synchronize data between the web store and the accounting system.

Integrating an always-on web store with an on-site accounting solution can be a challenge, even for the most tech savvy business owner.

Creating seamless processes for exchanging data between these remote systems requires that both solutions be operating in a secure and accessible platform. While the web store is accessible via the Internet, getting to data in accounting and other systems residing on local PCs or networks is more problematic.

An option that many successful online businesses have adopted is NOOBEH‘s QuickBooks on Azure service, which provides centralized hosting and management for the QuickBooks desktop and any connected inventory or warehouse management applications as well as the integration to the web store.

Enabling the accounting and operational systems to be online and always on, like the web store, allows them to exchange data when and where it is required.

Connecting services in a secure and managed environment introduces new efficiencies and eliminates risk due to data entry errors or lost transactions. The QuickBooks on Azure cloud hosting service provides the system management, platform security and uptime required to ensure that the inventory and accounting systems supporting the always-on web store are also always on.

jm bunny feetMake Sense?

J

Where in The World is Your Data?

Where in the World is Your Data? Even better.. where would you like it to be? In a datacenter near you? In a datacenter far away from you? Maybe you’d like your production system nearby, but backups stored on the other side of the country. Or perhaps you want redundant systems on each coast as well as something somewhere in the middle.
With Microsoft Azure as your platform, you have all the choices in the world, literally.

Microsoft Azure is the platform of choice for businesses of all sizes, offering virtualized infrastructure and services that can be tailored and tuned to meet the unique needs of any organization. No longer tied to on-premises infrastructure, companies find that they can implement better and more comprehensive solutions because they have the agility to adapt systems to immediate needs while retaining the ability to adjust as conditions change.

With Microsoft Azure and Microsoft 365 Services, NOOBEH enables businesses to focus on transformation and improving efficiency, not the IT that supports it.

NOOBEH cloud services, part of the Mendelson Consulting team, sets up Azure infrastructure and manages it for their clients. Business users focus on getting their work done, not on the IT supporting it. NOOBEH QuickBooks on Azure services give small and medium size businesses the most flexible and resilient infrastructure available to run all their desktop and network applications.

Because QuickBooks is rarely a standalone solution, NOOBEH QuickBooks on Azure services have no limitations on what add-ons, extensions, integrations or other applications the business may need to use. All the software a business needs can be deployed on the platform, allowing the company to keep its information systems and assets secure, fully-managed and available when and where they are needed.

While NOOBEH uses Azure platform and Microsoft 365 services to continue to deliver new capability for private sector users, Microsoft is advancing innovation in the delivery of connected services and computing power for private and government sector users wherever it is needed. Azure Modular Datacenters represent a partnership that delivers computing and communications capacity anywhere in the world… and beyond.

Microsoft Azure Modular Datacenters and SpaceX

The Azure modular datacenter is basically a “data center in a box”. It comes with everything needed to deliver computing capacity anywhere in the world.

“We designed the Azure Modular Datacenter (MDC) for customers who need cloud computing capabilities in hybrid or challenging environments, including remote areas. This announcement is complemented by our Azure Space offerings and partnerships that can extend satellite connectivity anywhere in the world. Scenarios range from mobile command centers, humanitarian assistance, military mission needs, mineral exploration, and other use cases requiring high intensity, secure computing on Azure.”

https://azure.microsoft.com/en-us/blog/introducing-the-microsoft-azure-modular-datacenter/

It has power and everything else it needs, and now it also has the connectivity needed, even when there is no (zip, zero) infrastructure. Microsoft has partnered with SpaceX, using SES satellites to bring Internet connectivity to remote areas.

“We can connect via satellite links any element on the Earth to another point on the Earth..”

https://arstechnica.com/information-technology/2020/10/microsofts-new-data-center-in-a-box-will-use-spacex-starlink-broadband/

They’re calling it part of “a multi-orbit, multi-band, multi-vendor” approach to connectivity. That’s pretty cool, if you ask me.

It takes the whole bookkeeping in bunny slippers philosophy of “work when and where it works for you” to an entirely new level.

Make Sense?

jm bunny feet

J

Cloud for Small Business: Gain Hardware Independence

Small businesses tend to approach their business IT in terms of the tangibles.. the hardware and software they can see and touch.

The desktop PCs where the programs are installed, the server in the back room where the files are stored, and the backup that goes offsite (tapes? discs? usb drives?) is the stuff most small business owners think of when asked about the computing technology they use. This view isn’t very comprehensive when it comes to considering the costs of purchasing and maintaining IT in the business, yet it identifies a major problem with the typical small business IT approach.

The problem is the dependency on the hardware and the reliance of the small business on the operation of individual computers.

The solution to this reliance on on-premises hardware? The cloud.

The solution to the problem isn’t centered on using web-based applications. The real solution to this small business IT problem is cloud platform, like Microsoft Azure. When businesses deploy a private cloud server they get solution that allows them to run all their desktop and network applications and store their data on a virtual platform that isn’t tied to any particular piece of hardware in the office.

Microsoft Azure offers virtual computing resources, managed and secured on Microsoft’s hardware in Microsoft datacenters. Rather than purchasing and maintaining hardware on-premises, business can deploy virtual networks and servers on the Azure platform. This makes the systems far more versatile and resilient than would be affordable to do otherwise. Surprise server hardware failures become a thing of the past, and buying ahead for possible future needs is no longer required because the systems can be upgraded on demand.

Businesses still need desktops where users access their programs and data, but the “desktop” can be a cloud desktop rather than the local PC desktop.

Remote desktops on the cloud server keeps software licensing and business information securely stored on the cloud server rather than being resident on user computers where it is more easily compromised. Users may still browse the internet and do other things with the local PC desktop, but using the cloud desktop for business applications and data means that just about any PC could safely be used for work.

When applications and data are managed on-premises, it makes changing servers or workstations a big deal. 

Changing desktops or servers means that software must be uninstalled and reinstalled, data must be migrated and user profiles and permissions may need to be recreated. When the cloud server is where users get their desktops, computer workstations become interchangeable because nothing is really installed on them other than the connection to the cloud desktop. This is also why traveling laptops and home computers become more secure for business use, because the applications and data are really running on the cloud server and not on the local device.

The cloud platform provides what the business needs without the lock-in to on-premises hardware or SaaS/Web-based software.

Rebuilding servers due to hardware failures, upgrading systems to handle future growth or replacing aging hardware all contribute to the unpredictable cost of managing and maintaining on-premises computer systems. SaaS and web-based software solutions lock-in data and lock-out many future options, yet they don’t address user desktops and the rest of the applications and data the business needs.

Rather than risking outages and lost productivity, businesses are finding that running their systems on a managed cloud platform provides more stability and consistent performance for a reasonable and more predictable cost. Desktop and server software licensing is able to service multiple locations when installed on a cloud server, and workers at home can access the tools to be just as productive as they are in the office (maybe more).

Make Sense?

J

For Accounting Professionals: Private Hosted Solutions and Helping Clients Cope with the New Normal

Accounting professionals have an opportunity right now to help their business clients through the difficulties presented by the COVID-19 pandemic. With work-from-home mandates and increasingly fluid reporting requirements to support grants, loans and loan forgiveness, business owners need all the support and good advice they can get.

The global pandemic is changing the landscape of business worldwide. Many small businesses in the US have either closed or are on the brink, looking for ways to keep the doors open and employees paid. Supply chains are strained, distribution has slowed, and workers are being asked to work from home if possible.

These are challenging times, but the guidance and support you can provide to your business clients can be just what they need to help keep the doors open and workers producing. Remote access, cloud hosted applications and data, and real-time accounting support and management reporting are the weapons you and your clients will use to fight the conditions that are currently working against you both.

Help your clients deploy cloud hosting services for their entire business.

Running applications and storing data on an in-house network increases the cost and complexity of supporting a remote or mobile workforce, for you and for your clients.

Remote access and supporting work from home requires that users have the means to communicate with each other and to collaborate on the work. Tools to support communication and collaboration are critical when the workforce is distributed, operating from a variety of locations and with whatever device is available. Yet business owners, operators and managers may find that collaboration apps and other online tools don’t provide access to the applications and data required to do all their work.

To address the problem of working on client data, some accountants may install the client software and copy the data to their own in-house networks. This creates a situation where the accountant is paying for computing resources, space and management of client applications and data in addition to their own. This increases the cost of internal operations for the accounting firm and can impact internal system performance while also reducing overall productivity.

More to the point, this model only supports doing after-the-fact work for the client, which results in the data and reporting being outdated and far less useful to the client in supporting daily decision-making. This model also does nothing to help the firm with their own possible work-from-home needs even as IT support and on-site service becomes more limited.

Accounting professionals wanting to provide services to clients proactively rather than reactively must have real time access to the same applications and data that the client uses. The old fallback to remote control solutions is one approach, yet it is not really an optimum solution to the problem.

Remote control, like PCAnywhere, GoToMyPC or LogMeIn expose the professional to more of the client computing environment than is necessary, introducing risk and the potential for blame if something goes wrong. And remote-control solutions are single user, reducing productivity because the client can’t use their system while the accountant controls the computer. RC solutions also rely on the availability and function of the on-premises systems. If the on-prem systems aren’t turned on, up and running and accessible, then the remote user can’t connect.

It may be that online or web-based applications are an option, but for many businesses they aren’t really a viable solution. QuickBooks Online is simplified software and is not appropriate or usable for many businesses. The QBO subscription model is per-company, limiting options and reducing cost-efficiency for businesses with multiple entities. And QBO doesn’t address other business needs, such as working with documents and reports, and it can’t provide any access or support for other business applications. Even the ability to backup and preserve data is very limited without specialized services and tools.

Shared hosting service might be closer to the right answer, yet shared hosting is generally only useful for very small organizations and supports only core QuickBooks functions, so it can be as restrictive QBO. Shared infrastructure used by the shared hosting platforms can also introduce significant risk to every business on the platform because ransomware and malware can easily move through connected file systems and servers.

Compare shared services to a public pool where it is very easy to transmit from one person to another; in these networks an intrusion can end up spreading malware to the entire network and platform, resulting in days or even weeks of outages. Unfortunately, disaster recovery is often limited to recovery of the provider hosting platform and does not always include recovery of all customer data.

The best solution for business is private, managed cloud hosting service delivered on a trusted and proven platform like Microsoft Azure.

Hosting service that takes advantage of the Microsoft Azure cloud  platform allows the business to centralize access to all their important applications and data, making it possible to provide complete application functionality for all users no matter where they are located.

Using the Azure platforms means that security, fault tolerance, scalability and agility are designed into the solution rather than being extras from the hosting provider. Microsoft-managed datacenters and Microsoft-managed hardware means the experts in systems and security are handling the big stuff while the service provider focuses on what the client needs.

The virtualization technology enables the agility to meet changing business needs, scaling systems up or down if necessary. Massively scalable platform allows services to be right sized now without concern for future resource requirements (no buying ahead based on possible future needs). There are no arbitrary limitations placed on the applications or services the business needs to run on the cloud platform, and no fees for running more apps.

Making all the applications and data available to workers, when and where they need them, is the key to promoting higher levels of productivity while delivering the data management needs to support daily decision-making.

Now that you have access, provide pro-active support and help business owners and managers make the right decisions.

Better data and reporting to support business and finance management is more important than ever, especially when having the right information can mean the difference between keeping the doors open and closing shop for good. Whether the goal is to shore up finances to keep employees on staff or to create a cushion to help weather supply chain disruptions, businesses owners need quality financial and performance data in order to make the right decisions for the company.

Once the accounting professional has real-time access to client systems, they can work cooperatively in the data to ensure that the right information is available when it is needed. As business owners seek to take advantage of grants and loan programs available due to the pandemic, the financial and other performance data becomes even more essential in terms of developing qualification and eventually forgivability of the loan.

With timely access, proper reporting tools and regular support and oversight, business owners benefit from a closer working relationship with their accounting professionals. The additional support and proactive service is more necessary now than ever. For the accounting pro, an elevated relationship with client is being developed, where the services provided become more meaningful and the value of those services more evident.

Make sense?

J