Unlock KPIs and Improve Reporting with QuickBooks

It is surprising how many businesses still keep boxes of 3×5 ledger cards with customer and vendor information on them. More likely than the card box, the business may be storing its essential customer billing and vendor product information in the accounting system because that is the system they have.

These growing businesses need a better system to capture more information that delivers greater detail for accounting and reporting purposes. Just as likely, the business has other information it should and possibly could be capturing but isn’t sure about what steps to take next.

When details that inform a process are not part of an integrated system, it creates greater potential for lost or inaccurate data. The larger the volume, the more difficult and error-prone managing the information becomes.  

Business needs more detailed information about… everything.

Businesses may need to track time for payroll or jobs or both, job tracking may be a requirement, inventory tracking or more detailed inventory management may all be areas for greater attention. Mendelson Consulting can help develop these capabilities by making sure the business is using the right software, and then enabling the functionality needed to support the workflow and capture more and better data.

No data means no KPIs.

More and better data means more information to fuel KPI reporting. Key performance indicators can reflect operational performance in a variety of areas and may help identify where improvements are required.

Using data from the accounting and operational systems, businesses of all sizes measure their effectiveness using KPIs to evaluate the successes – or failures – of their processes and activities.

Mendelson Consulting’s team of QuickBooks Enterprise Experts and ERP consultants provide guidance, implementation and training, and report development to get beyond bookkeeping to proper processes that result in good accounting data. Mendelson’s cloud services team – Noobeh – sets it all up on Microsoft Azure, where data connectors, data warehouses and Microsoft Fabric weave it all together.

Whether just starting out or an enterprise or franchise expanding at a national or global level, we help businesses do more with their systems and software. We understand each stage of business and how to help our clients reach their next best level.

jm bunny feetMake sense?

J

Mo Bigger Data

Losing valuable business data is a terrible thing. It is worse when it’s done on purpose. Every business faces changes in accounting or operational systems over the lifetime of the company and these changes more frequently than not include losing data of some type. And that means losing business intelligence.

The frustrations of changing business systems are compounded the further into the business life cycle the change comes. Much of the historic intelligence of the business is derived from the earlier days of operation. This is data which reflects the stages and activities of the business over time. When a business reaches a point where data volume or list sizes force a systems change, much of that early historic data is ultimately abandoned. There is so much data to load into a new system that the task often proves too daunting for the company, so valuable historic detail information is lost and summary information is loaded into the new system.

As a business matures, and for the business to mature in a healthy manner, specific and detailed information must be captured and analyzed. Software addressing a broad view of the business, offering only generalized functionality and basic process support, will not provide a growing business with the operational support and resultant business intelligence needed at this level.

For example, a manufacturing business needs to fully understand and manage the manufacturing processes and materials supply chain to ensure profitability and consistent product quality. A retailer needs to know which products sell in which markets to ensure product stock and availability to key customers. And all this information is time-critical if the business is to make necessary adjustments in time to benefit from them.

In the end, it is the demonstration of well-defined processes, deep insight into the business operational metrics and financial performance, and the ability to effectively and accurately report on this information that creates a basis for provable business value.

Mendelson Consulting understands how important it is to not just collect the right data to support various processes, but to use that data to better understand operational and financial performance. As operations grow, so does the need to collect data from a variety of possible sources, from phone systems to time clocks and more. Even getting data out of the accounting system can be a challenge, but there is tremendous value in having transparency of business data.

From data warehouses to data lakes, Power BI and data visualization, we help businesses access their information and develop reporting that not only informs but helps deliver greater insight which leads to improvements in performance and profitability.

When information is power, we help owners and stakeholders gain mo power by being mo better informed.

jm bunny feetMake sense?

J

Transform Your Business with M365’s Integrated Accounting Solution

The Best Alternative to QuickBooks May Be Part of a Fully Integrated Framework You Already Use

When looking at the business accounting and finance systems available in the market – particularly considering those which have earned a level of market share – there are visible gaps – big ones.

This is clearly reflected in the numbers, where Intuit QuickBooks leads in the small business market but has no reciprocal in the midrange or enterprise markets.

QuickBooks fits into that early space where the business is just starting out, but QuickBooks Enterprise can expand to keep more detailed customer, vendor and item information. Yet there often comes a point where a business has requirements that extend beyond the ability of the QuickBooks software.

Sometimes the mere thought of change is so terrible, usually based on a bad initial implementation experience, that the business uses the software far beyond what it was built to handle. In other cases, add-on solutions are adopted which offer more in-depth or complex capabilities to handle the growing business requirements. Both options may prove to be temporary solutions, meeting most functional demands as long as business needs don’t change.

If a change is in order, it makes sense to consider the benefits of using tools built on a familiar platform that is essentially a framework for designing exactly the system the business needs now, and which has flexibility and scalability enough to change as the business changes.

We understand that an integrated framework can provide much more scalability and support than a standalone solution.

We also recognize that, in today’s modern business, creating workflow efficiency and enabling user productivity are paramount.

While many products calling themselves ERP systems offer a broad range of functionality, integration, and data management capability, they often dictate more to the business how it must operate rather than revealing how it might operate.

Instead, we believe every business should have the opportunity to adapt their business software to make it easier for users to accomplish their work effectively while delivering the data and insight to guide the operation forward.

The need is for an entire tech stack and framework, not simply an application.

Competing ERP systems on the market typically address more and increasingly complex business processes while scaling to support larger business sizes. But the cost and complexity of these products, coupled with poor or too-expensive implementation services, is often the barrier to their adoption and retention.

In most cases, there is no small business version of the big business software, so the upgrade path is unclear and problematic.

Given the huge gap between the “typical” small business system and the upper-levels in the enterprise applications catalogue – the transition from very small to very large software is not likely to be made in a single step. Yet businesses can reduce the number of migration steps in the lifecycle of the company by moving to a flexible platform that can adapt and scale with the operation.

There are three things every business does: communicate, produce information, and keep score.

Microsoft places at the top with the first two, providing email and other communication tools used by businesses of all sizes around the globe, and creating the Microsoft Office family of productivity tools recognized and used by just about everyone.

In the third spot, keeping score, Intuit QuickBooks remains the clear winner. But when the business needs something beyond QuickBooks, or desires to have a solution that fits better, and maybe even integrates into their current M365 working environment, we can introduce the stakeholders to M365 Dynamics Business Central.

Business Central is part of the Microsoft 365 family of products.

Business Central is part of the Microsoft 365 family of products and is integrated with Microsoft Outlook directly, as well as the rest of the family of applications.

It is all able to be connected to the Microsoft Fabric, which weaves together the solutions and services that drive business operations around the globe.

Microsoft has the framework to provide the entire stack of applications, services and technologies working seamlessly together to deliver functionality and process support to fit the business and how it works.

When a siloed financial solution no longer supports the business requirement, or as operations become unworkable due to software that no longer fits the needs, connect with the experts at Mendelson Consulting to see what options are available.

There is never just one way to solve a problem, but there is usually a best way.

jm bunny feetMake sense?

J

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

Preparing Your Business for Technology Outages

There is a lot of discussion today about how our children are growing up in a world where high technology is simply part of life and lifestyle.  I even read an article about how people are evolving because of the availability of information; evolving to the point where we no longer store and retrieve information, but store information on how to get information.  The article cited an example of someone who couldn’t recall the name of an actress in a movie they had seen, so the immediate response was to search for the answer on Google.  In the past, people relied upon memory and found various ways to mentally associate and store information so it was able to be recalled.  Now, there’s an app for that.

Are we losing our ability to effectively store and recall information?  Are we forgetting how to do things before we had technology to help us?  It might even make one wonder about how technology-dependent society has become. Consider the ruins of past civilizations where seemingly impossible structures are found. These structures cause questions about the technology available at the time as we wonder how they came to be.  The knowledge was there at some point but is now lost to time.

Is your business at risk from a similar fate?  Loss of business institutional knowledge and operational intelligence is often a problem, especially as a business grows. Too many companies fail to consider critical issues such as knowledge management and sustainability.  Finding ways to capture business knowledge and protect it is essential in every organization, whether small business or large enterprise.

Small businesses are often centered on an owner who started the operation, and who just knows how things are done.  The primary goal in this situation is to capture that knowledge and turn it into process.   Only through this approach may a business begin to reduce its reliance upon a single individual, a critical step in creating both sustainability and continuity in the business. In larger enterprises, process and structure are essential to keep the various parts and participants moving in the same general direction and toward the common goal.

Once those processes are established, generally using technology to support or facilitate them, is that the end of the task? 

Many businesses believe that establishing software-supported workflows and standard processes is sufficient to keep the company operating. If a major system or technology failure occurs, workers are left standing around unable to get their jobs done.  In the worst cases, there isn’t anyone in the business who really understands how to pull things back together or there is no longer access to electronically stored information necessary to continue operations. 

How would you handle things if your systems – your computers and software and systems – were no longer available to you?

While GPS and autopilot systems can bring tremendous efficiencies to the process of flying, they also can give a false sense of security that encourages complacency. If something goes wrong, the autopilot will adjust and the computer will tell you where to go, won’t it?

Here is where technology has the ability to distract pilots–and entrepreneurs–from asking themselves if they’re both focused on and capable of solving the right problems. inc.com

Every business must consider how they would address a severe information technology outage and should take steps to protect and preserve business knowledge so that there is some hope of recovery from such an event. 

Mendelson Consulting and the Noobeh cloud services teams help businesses implement efficient workflows, consistent and effective processes, and technology to secure, support and maintain operational readiness. No matter how redundant the tech is or how thorough the planning is, there is always a possibility of an outage. Owners and managers should understand how to continue operations and handle business in the event the technology fails unexpectedly.

jm bunny feetMake Sense?

J