Streamline Your Accounting: Add-Ons vs. Full Migration

Growing businesses have growing needs.  More customers, more products, more workers, more vendors. More of everything, and the need to keep track of it all comes along for the ride. With business accounting systems, one of the challenges of supporting more detailed or complex processes is the idea of changing over to an entirely different solution.

Instead of thinking in terms of migration, it is often better to preserve the knowledge, training, and data already invested in the current solution, and add on to that system to support the expanded processes or functionality.

This is a buying decision in the business lifecycle: enable new systems and processes versus a comprehensive solution migration.

In many cases, the add-on or extension for QuickBooks is a better answer than a migration to an entirely different – more expansive and more expensive – ERP solution. Part of the reason is the historical data. Another is learning.

The early years of a company are the formative years, where much learning is accomplished. Losing the fidelity of this data and the organizational knowledge that developed is losing a past that could be learned from. There is also tremendous value in the working knowledge of the team members who utilize the systems every day. Preserving any of these investments is of benefit to the organization.

Mendelson Consulting works with business owners and stakeholders who know they need to expand systems and capabilities but just aren’t sure where to begin.

Our QuickBooks Enterprise experts, ERP consultants and cloud specialists can help identify the gaps in information, processes and workflows, and identify the solutions to solve the problems and smooth the flows. From QuickBooks add-ons, extensions and sync solutions to other ERP options, we provide our clients what they need to do more and better business.

jm bunny feetMake sense?

J

Maximize QuickBooks Performance with Proper Data Maintenance

Millions of businesses around the globe use QuickBooks software for their accounting. With an estimated 84% of the small business accounting market making the buying decision to go with it, QuickBooks has enough product momentum and functionality to support small businesses through midmarket customers.

This is a broad base of customers for any accounting product, and the continued popularity of QuickBooks Enterprise is a testament not just to the application’s usefulness, but to the large gap that exists in the space where QuickBooks Enterprise desktop leaves off and the well-known enterprise ERP systems start. 

Initially, a business will implement their accounting system to keep track of customers, vendors, items, and cash. More detailed processes are then introduced as the business requirements grow, such as tracking more specific information on the costs of certain products, or drilling into customer purchases or item sales activity to see more details. This additional data provides a much more informed basis for business decision-making but also has impacts on systems and software as the volume of data to be managed grows.

Data growth can happen in many ways. Growth can occur in the number of products or services offered, growth in the number of transactions processed regularly, growth in the dollar value of transactions, or growth in the number of employees who need access to the system. Each impacts the ability of the system to continue to support the business requirements, but not necessarily in a way that isn’t manageable.

Given enough time, a certain “density of data” will eventually be reached, causing the system to lose efficiency in manipulating the file. The business process requirements may not have changed, just the size or condition of the file and data. The file opens slower, operations slow down and processes take longer, the system crashes frequently or has errors, and the usefulness of the product is severely diminished.

Keeping the QuickBooks data maintained and in good condition will improve performance and increase longevity of the application.

Too often, businesses assume they have outgrown their QuickBooks software because it is slower or has problems when they begin using additional features. Frustration sometimes even turns to looking at changing the accounting software entirely. Yet experience has shown that many of these situations are solved with some data file maintenance and repair, and sometimes a little re-training or setup work.

Regular file maintenance and a little housekeeping can keep a QuickBooks file in good working condition for a long time.  Regular backups with a complete verification and other routines will clean up the file and help the software manage the file more efficiently. But there are limits to how much data a single QB company file can hold, so it is wise to consider starting a new file every few years, just to keep the file manageable. This in no way means abandoning any data, as previous files can be retained and available to open and view at any time. How many years of data you can store in a QB Enterprise company file depends on a number of variables, and can range from a few to many.

While QuickBooks is very easy to use compared to most accounting products that service this small/medium enterprise market, this is both a benefit and a bit of a problem. Many users aren’t really trained in accounting, they are trained in how to operate QuickBooks. Moreover, the knowledge of how to make something work in QuickBooks doesn’t always translate to either proper use or to proper accounting. Even if it is simple to accomplish something in QuickBooks, it is always wise to get a little confirmation of the setup and training on proper use.

For a QuickBooks Enterprise desktop customer, the next step up in software is a big one no matter what, and it would come with drastic change, require data conversion (or abandonment), and incur high costs in licensing, implementation and training services. If there is a good business purpose to make such a change, then it makes sense. But bearing the significant costs of change may not make sense if the problems are centered on poor housekeeping or improper usage.

Mendelson Consulting’s team of QuickBooks Enterprise experts and ERP consultants can help your company get your data file and QuickBooks operations in the condition they need to be. With data file analysis tools and numerous methods for dealing with QuickBooks data and operations issues, Mendelson provides the services businesses need to continue success with QuickBooks. And, if we find that you have outgrown what a QuickBooks-based solution can do for your business, we’ll have that conversation, too.

jm bunny feetMake sense?

J

PowerBI, Data Warehouses and Combining QuickBooks Enterprise Data with Other Data

Businesses of all types are looking for ways to discover more useful information hidden in their systems. With a desire to implement business intelligence tools such as Microsoft PowerBI, companies need the ability to combine and analyze data coming from a variety of sources. The data can help businesses inform their conclusions rather than leaving it up to “gut”, supporting decision making in all areas of the company.

The tools for exposing and combining data are many. Enterprise ETL (Extract/Transform/Load) products have been available for many years. When it comes to SMBs and the applications they utilize, the options aren’t quite as prevalent nor as powerful. In most cases, businesses are left to working with data exports and a bunch of linked Excel worksheets.

Noobeh understands that businesses need their data available for integration, analysis and reporting. Noobeh are experts in deploying SMB applications such as QuickBooks Enterprise desktop, Acctivate Inventory, Sage ERP, MISys Manufacturing and more, all on the Microsoft Azure platform, positioning the applications and their data perfectly for use in business analytics and data warehouses.

Data warehouses and data lakes are growing in popularity because there is simply too much disparate data present in any growing business to effectively analyze it one data silo at a time. The number and variety of data sources in a single small business can be far larger than the company realizes until it attempts to capture and report on that data.

Any approach to data warehousing should consider the potential number and variety of data sources involved. This is among the reasons for Noobeh electing to work with Microsoft Azure and PowerBI. The Azure platform provides the infrastructure services and platform tools to enable data connections needed, powering the data warehouse and exposing the data to PowerBI and other reporting and analysis tools.

Even QuickBooks Enterprise desktop data can be extracted into its own standalone data warehouse, connected to a broader data warehouse and then combined with other business data. When businesses can combine data from their various solutions, even those which may still be desktop-bound, the power of the information and intelligence contained in it can be revealed.

Whether the purpose is process improvement, performance monitoring, management reporting or combined operational intelligence, collecting and storing the data is the first step. Noobeh is there to help make it happen.

jm bunny feetMake sense?

J

Deadline Approaching for QuickBooks Desktop Users

All QuickBooks Desktop Users Are Required to Upgrade to a Current Subscription Model by Sep 30. Yes, the time has come to buy in to the software subscription model or lose access to your books. But at least you get to keep using QuickBooks desktop software, which is worth a lot of you’re already invested in QuickBooks.

Effective Sep 30, 2024, all existing users of QuickBooks Desktop Pro, Premier, Mac, and Enterprise Solutions v21 (and earlier) must transition to the annual subscription model. For Pro and Premier users, this is a short reprieve. Previously Intuit had announced a July deadline for renewing Pro/Premier licenses. After the now-September deadline, there won’t be any new sales of Pro or Premier licenses. With some of the recent price increases it almost becomes a moot point, as QB Enterprise is now priced similarly (less?) than Premier.

Something notable in all of this is that versions sold under non-subscription one-time licenses will be discontinued entirely. That is just fine for many users, however, as the much older versions don’t “phone home” to authorize the license, so they can keep working. The downside to that is vulnerability. Outdated and unpatched software is more vulnerable to risk than software that is actively updated to protect against various exploits. Best practices demand keeping software updated and patched. Being out of support with your business financial and accounting software is not a position you want to find yourself in.

Starting Oct 1, 2024, QuickBooks Enterprise will be the only QuickBooks Desktop version available for new purchases. For very small businesses, this is going to be a challenge as QB Enterprise is not as affordable as Pro was. These businesses may find that QuickBooks Online works for them, but they will not only miss out on a great deal of QB Desktop functionality that is not present in Online, but they will also be locked into the QuickBooks Online service model of receiving product updates without announcement, not having a backup of your company data, getting bombarded with a revolving door of add-on apps, and having literally no control whatsoever of where your data lives and how Intuit and its companies are accessing it.

If you are using an older version of QuickBooks Desktop, upgrading to the subscription model before the deadline is crucial to avoid any interruption of services.

What does this mean?

  1. Service Discontinuation:
    Failure to upgrade will result in the discontinuation of services such as QuickBooks Desktop Payroll, Payments, Online Backup, online banking, system updates, security patches, and live support. This could potentially disrupt your business operations.
  2. Immediate Action Needed:
    To ensure uninterrupted business operations, we strongly recommend planning your upgrade without delay.
  3. Advantages of Upgrading:
    Intuit encourages existing Desktop subscribers to upgrade to the current version (Desktop 2024) to benefit from the latest features, improvements, security updates, and bug fixes. Updated software also improves compatibility with current versions of Windows, Microsoft Office applications, Gmail services and other solutions that use modern methods of account protection and authentication.

At that time, you may also want to consider your alternatives to how and where you run your QuickBooks Desktop software.

Intuit offers “cloud access” with their QuickBooks Enterprise licensing, but this option is not your only or best option for running your QuickBooks Desktop/Enterprise software in the cloud.

With the bad guys (hackers) and malware being as prevalent as they are, businesses must be vigilant in securing their business and financial information. Shared hosting platforms where service providers allow many users from many businesses to operate on the same servers simply cannot provide the level of security or protection most businesses need.

Noobeh QBonAzure offers some limited shared hosting, but only for customers that have limited requirements and only for a few users. When a company needs more than just “vanilla” hosting for their valuable financial data, we strongly recommend going the private route and having your own cloud server.

Not just a “dedicated” server in a service provider’s network, Noobeh works only in the private Microsoft account of each customer, ensuring that there is absolutely no sharing of any resources with other customers. This allows us to build a system that works specifically for your business, with all the applications and services needed to support all aspects of operation. There aren’t different levels of service or service packages; each system is built and sized for the customer’s unique requirements, and we don’t charge per-application or silly things like that. You need what you need to run your business, and we host that.

Connect with us if you have any questions or need assistance during this transition. We will help you navigate the changes and understand how best to proceed for your business and circumstances, engaging with the right products and services to ensure continuity and set you up for greater future success.

jm bunny feetMake Sense?

J

QuickBooks Desktop Enterprise 2024 Security Improvements: Now with 256-bit encryption

Intuit’s release of QuickBooks Enterprise and other desktop editions for 2024 have a variety of new features, and among them is an improved level of security for your business data. Upgrading from 128-bit encryption, QuickBooks Desktop 2024 now has AES 256-bit encryption.

256-bit encryption is the strongest and most robust encryption standard commercially available. It’s widely used because it’s virtually impenetrable to brute-force attacks. 256-bit encryption is an encryption technique that uses a 256-bit key to encrypt and decrypt data. Plain text is converted to a cipher, and the encryption key is required to decrypt the data and return it to readable plain text.

256-bit encryption is used in most modern encryption algorithms, protocols, and technologies, including AES in wireless security, processor security, file encryption, and SSL/TLS.

According to Intuit, “You can be confident your data is protected with our enhanced security using industry-leading AES 256-bit encryption. QuickBooks safeguards your reputation by protecting critical customer and vendor data, such as business financials, banking information, and credit card details.

This means we translate your information into a code that only we can read to make sure only you and Intuit have access to your information. The type of encryption we use is called AES-256 (Advanced Encryption Standard with 256-bit keys) and it ensures the highest level of cryptographic security.”

With a series of robust security steps and a complex 256-bit decryption key, AES 256-bit standard is nearly impossible to break using brute-force methods and has been approved for the handling of confidential data by the U.S. Government.

A brute force attack is when a hacker tries different combinations until they arrive at the correct combination – the key. The larger the key size, the more difficult it becomes to break the encryption. We’re talking about 256-bit keys. There are 984,665,640,564,039,457,584,007,913,129,639,936 (that’s 78 digits) possible combinations. Even if you use Tianhe-2 (MilkyWay-2), which was the 4th fastest supercomputer in the world in 2022, it will take millions of years to crack 256-bit AES encryption.

In case you’re interested: The fastest supercomputer in the world, ranked in June 2023, is Frontier, an HPE Cray EX system run by the US Department of Energy, Frontier incorporates 3rd Gen AMD EPYC™ CPUs representing 8,730,112 cores that have been optimized for high-performance computing (HPC) and AI with AMD Instinct™ 250X accelerators and Slingshot-11 interconnects. Its HPL benchmark was 1.194EFLOPS (EXA – 1 quintillion – floating point operations per second). (via networkworld.com). Frontier is faster than Tianhe-2, so breaking the key could take a little less time.

Breaking encryption with no known flaws is kind of like guessing a password. If you make enough guesses, you might eventually get the password right. With strong encryption, this can take a long time. AES-256 is the most secure version of AES and is virtually unbreakable by brute force based on current computing power. It’s also considered quantum-resistant, which means that quantum computers aren’t expected to crack the cipher.

How long would it take to crack 128-bit encryption using a brute force attack? Most security professionals would answer “1 billion years”, but that’s just an estimate. A machine that can crack a DES key in a second would take about 149 trillion years to crack a 128-bit AES key. According to researchers, with the right quantum computer, AES-128 would take about 2.6110^12 years to crack, while AES-256 would take 2.2910^32 years. For reference, the universe is currently about 1.38×10^10 years old, so cracking even an AES-128 encryption with a quantum computer could take hundreds of times longer than the universe is believed to have existed.

While Intuit is improving the security of the information it stores and transmits between its systems, your company should be equally concerned with the security and protection of all your business applications and data. Using strong password policies, multi-factor authentication, and SSL for secure web app access, Noobeh’s QBonAzure services provide layers of protection on top of the $20Bn in security investments made by Microsoft.

We take data security seriously, providing solutions to address access, security, privacy and protection for business applications and data. When your QuickBooks Enterprise deployment needs a solid foundation that offers agility and performance as well as strong platform security, we have that.

Visit MendelsonConsulting.com/cloud to learn more.

jm bunny feetMake Sense?

J

When a Business Outgrows QuickBooks Enterprise

Small and midsized businesses use QuickBooks software to manage finance and operations. Since growing past 90% market share in 2008, Intuit QuickBooks proved over the years that businesses adopt accounting and finance software if it is affordable and easy to use. While Intuit’s focus today may be on gaining market share with the web-browser-based QuickBooks Online edition, QuickBooks Desktop Enterprise continues to serve the needs of companies requiring more robust functionality than QuickBooks Desktop Pro/Premier or QuickBooks Online editions offer.

Over the years the QuickBooks product line has grown to support larger businesses, with the Enterprise edition scaling to 40 users and boasting a load of features that fully support operational processes. Inventory management, order processing workflows, construction management, and other features give encouragement to businesses needing support for more complex processes. QuickBooks Enterprise allows the flow-through of product use knowledge, stored data and integration with other business solutions to be seamless and consistent when moving up from QuickBooks Desktop Pro or Premier editions.

When a business finds that it may be outgrowing the capabilities of QuickBooks, it does not necessarily have to abandon the product line in lieu of a larger framework such as with alternative ERP systems. While the larger web-based systems may boast greater capabilities, they often come with much greater cost of service and implementation.

For businesses invested in QuickBooks Enterprise, it makes sense to look at alternative technical or platform solutions to address certain operational needs rather than shifting to different finance and operations software. The cost and complexity of an entirely new ERP software implementation is often more burdensome and costly than is needed to meet the real business demand. Also, the value found in business data can be lost when converting from one solution to another, and the cost of change is often so burdensome that many businesses simply abandon their projects if they even get started.

When using QuickBooks, at times it is the platform — the local network, computers and server — that is not geared to handle more users, processes and applications working with QuickBooks and a more robust and agile situation is required. Businesses should also explore integrations or extensions that can address the functional requirements, supporting advanced and complex workflows with greater agility while retaining the full value of the historic data.

Some challenges with QuickBooks may indicate a business needs a more robust and scalable solution, but that does not necessarily indicate that the business has truly outgrown QuickBooks. Instead, it may be a situation best handled by extending QuickBooks through application integration with a more robust subsystem to address specific business needs, to add scalability, and to build on the existing history and business intelligence previously developed in the enterprise.

Large transaction volume, extensive inventory management, or performance issues can easily create the impression that a business has outgrown QuickBooks Enterprise. In most cases, these conditions are overcome by extending QuickBooks with solutions geared specifically to handle the complexities and volume of heavy inventory management processes. These solutions not only address the in-depth functionality required, but also tend to utilize more agile and robust database structures that can scale far beyond the capacity of any QuickBooks edition alone.

Some businesses wishing to provide more advanced reporting and analytics, along with delivering realtime insights, may initially consider QuickBooks reporting to be insufficient for their needs. Yet there are integrations available which make QuickBooks financial and operations data as accessible and usable as the most robust enterprise applications. Satisfying the need for highly customized reporting and analytics far beyond QuickBooks standard reporting, these solutions create visibility and give meaning to QuickBooks data in ways that cannot be accomplished within the application alone.

Mendelson Consulting understands how businesses can outgrow the core functionality of QuickBooks and provides the tools and solutions to address growth in practical ways that do not diminish the value of data, training and operational intelligence that has been so costly for the business to acquire. We help businesses expand their capabilities and improve efficiency without losing their investment in QuickBooks, addressing the needs of growing and complex businesses without forcing the change to more extensive and expensive solutions.

jm bunny feetMake Sense?

J