Category: business process improvement

Posted on

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

Posted on

Data at Work: Intelligent Automation is Your Business Robot

Imagine having a business where connected systems are free-flowing conduits for data to move intelligently into and out of with ease. 

Software and systems connecting to one another isn’t new at all. For many years, businesses have recognized the value of having information entered in one system available in another.  Entire ERP frameworks have been created based on this concept of entering data once and using it in many ways.

A single technology stack or framework may offer such a capability, but even the most robust system may need to rely on expert systems or add-ons to address aspects of the operation.

When two or more systems need to connect, the idea is to create that connection and enable the unattended and intelligent movement of data.  People shouldn’t have to get involved for the information to flow from one system to another… it should just go by itself.  Like a robot.

A simple example might be someone who owns a web store and does their bookkeeping with QuickBooks.  The webstore isn’t running QuickBooks. It is running an e-commerce solution or shopping cart system. This allows customers to buy things online.  However, the webstore does create sales orders and charge transactions and may even manage an inventory of salable items.

Business owners often take on the task of getting the information from the webstore to QuickBooks and vice versa. They either enter the information manually themselves or hire an employee to do it.  This manual re-entry of information introduces a large potential for errors in the data entered and is time-consuming and costly.

If it is problematic for a small retailer, imagine having the problem multiplied many times over. It is unimaginable for even small businesses with active and growing operations. As the volume of data grows, the time consumed and the data entry error costs stack up.

“It was just awful,” said David Clothier, treasurer of the Knoxville, Tenn., company, which operates more than 500 Pilot Flying J truck stops nationwide. “There were humans everywhere.” wsj.com/articles/the-new-bookkeeper-is-a-robot-1430776272

Rather than having a person re-type the information from one system into another, software-based integration programs are generally available to help users map the data and move it from one solution to the other.  This approach is faster and reduces the error rate, increasing the overall value and usefulness of the information.

Automation isn’t the only requirement that makes this all robot-like.  The additional requirement is intelligence.  If people still must get directly involved for something to happen, then all the happening is still based on human performance. No robots here.

Intelligent integration of information occurs when the systems at both ends can make decisions and act on them. 

For example, a business might use a solution that allows vendors to submit their invoices electronically.  Through a base of rules that match invoices to requests and approvals, the system can issue payment and record the transactions automatically and without human intervention, saving hugely on personnel and processing costs.  Robots (the automation solution) wouldn’t make up all the rules but could follow them repetitively and without question once established.

…software can help businesses operate more effectively. “If you think like a human, there are only certain things you can do. When you think like a robot, many things are possible.” wsj.com/articles/the-new-bookkeeper-is-a-robot-1430776272

It isn’t a new paradigm for improving business operations, this doing of things a bit smarter than before and leveraging technology to get more done in less time.

The difference is that the pace of change is increasing, giving businesses less time to address inefficient processes and outmoded working models. Mendelson Consulting and the Noobeh cloud services team recognize that intelligent automation and integration shouldn’t be a one-time setup. Instead, we partner with clients to find the best solution to not only address today’s needs but tomorrow’s new demands.

jm bunny feetMake Sense?

J

Posted on

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

Posted on

Write it Once – The Value of Integration

It’s amazing how much time and energy continues to be spent on duplicate data entry and re-keying information generated by one system into another.  Human-based data entry is prone to errors, takes time, and carries with it the burdens of employee costs and resources.  It is a problem that businesses of all types have battled for years even though enabling solutions have been around for a while. 

Methods of integrating applications and data have existed for quite some time, and in recent years these methods have expanded to include a wide variety of platforms and more open standards-based approaches.  Even in the small business world, business owners using traditionally limited software products can enjoy sophisticated extensions and integration of their applications and business data.

To provide a simple example of the problem: when an individual writes a check, that check must be recorded for several purposes including the recording of the cost or expense as well as the reduction of funds in the bank account.  When a product is sold to a customer, inventory is relieved, sales are increased, accounts receivable or cash is increased, costs of goods sold are experienced, and customer activity is captured.  All of this information must be recorded, and the activity accounted for throughout the financial and operational systems and can represent a tremendous burden if not automated. This also means that data exists in a variety of places, increasing the challenges of information collecting and reporting.

 Cloud-based integration and infrastructure services such as Microsoft Fabric and Azure enable seamless collection, transformation, aggregation and storage of business data. Whether linking accounting with sales CRM or pushing financial and operational data to an Azure data warehouse for analytics, Noobeh helps provide the data engine and the infrastructure to put it all together.

A small business owner’s situation offers a direct illustration. He sells computer parts through an ecommerce website.  Orders from this website are emailed to his order operators, who then turn around and re-key the orders into their accounting system where the inventory is also tracked.  Because of the increasing number of sales orders and product purchase orders to enter on a regular basis, there were three operators working in the department responsible for making sure website orders make it into the accounting system. Orders were frequently missed or misplaced, entry errors caused problems in accounting and product delivery, customer satisfaction went down, and the cost of handling web orders was increasing.

By implementing a single software solution, the company was able to not just address the current problem, but was set up to seamlessly increase business without increasing headcount. The solution was a system which takes transaction data from the ecommerce system and imports it into the accounting/ERP system. This single step allowed the business to reduce and redirect personnel costs, improve accuracy and timeliness of data entry, and increase customer satisfaction as well as overall business performance.

In even a small company, one piece of information may be used in a variety of ways and in a variety of systems. This complexity is found in simple business models as well as larger and more complex enterprises, revealing the value of integration solutions and automation tools at every level of operation.

Mendelson Consulting and Noobeh cloud services recognize that every business needs the right information at the right time to operate effectively. Our expert teams help businesses implement the solutions which bring business data together, empowering workers to be more productive and giving stakeholders the decision-support tools they need.

jm bunny feetMake Sense?

J

Posted on

Enhancing Business Insight: Noobeh Cloud Services and Azure-Based Solutions

Technology is evolving and so are our ways of using it. While the rules of accounting haven’t changed for years, the solutions we use to do the work have changed a lot. Yet there remain many businesses that haven’t yet embraced the idea of fully digital workflows, integrating and automating how data moves through the “system” to provide a comprehensive view of the business and how it is performing.

This is where accountants and bookkeepers can best serve their clients, by helping them implement the platforms and solutions which transform operations and provide greater insight into these areas.

Over 20 years ago, a technology model was developed which allowed businesses and the accounting professionals who serve them to work directly and collaboratively in the clients’ accounting system. By hosting QuickBooks and Sage desktop products on host servers, small business users and their accountants could both access the software and the data in real time.

This new approach was a boon for accountants, bookkeepers and others working with small business clients as it not only enabled closer work, but also provided those advisors an opportunity to do more – and more complex – work with the client. Yet many platforms and working models created barriers to broadening the scope of service or access to client systems, limiting to just basic accounting products like QuickBooks, and not effectively addressing the rest of the business need.

As technology has evolved, so have these transformations.

More accounting professionals understand the benefits as well as the necessity of moving from analog to digital workflows, removing manual entry and improving efficiency and accuracy of data. Yet this improvement doesn’t require changing accounting software and undoing years of learning and business knowledge. Rather, the platforms and connections must be the primary focus, replacing the manual with automation and smoothing out the bumps where data isn’t flowing at all. If the system isn’t in place to handle the complete flow of the data, there is a break. Like a pipe leaking water, this break results in data loss – which is also loss of business intelligence.

A key to all of this is the consideration of where the data ultimately resides. When business data exists in closed silos – whether web-based software or closed hosting platform – it takes a comprehensive approach to collection, storage and analysis. This is among the benefits to be derived from the modern cloud and Noobeh’s Azure-based hosting approach.

Noobeh’s hosting is not just about the desktop or the applications.

The cloud platform, and Azure in particular, also provides resources for data analysis and business intelligence, workflow and data flow automations, improved security and identity management, IoT and computing on the network edge.

For professionals looking to evolve their practices by helping clients go beyond basic recordkeeping and reporting, it’s time to delve into the operational details, data flows and development of real business intelligence and insight. Noobeh Cloud Services and Mendelson Consulting have the platforms and the supporting services to help bring it all together, improving profitability and performance of their clients through the intelligent application of technology.

jm bunny feetMake Sense?

J

Posted on

Taking a Hybrid Technology Approach is Most Advantageous for Many Small Businesses

When discussing technology and cloud, most IT resellers and MSPs serving small businesses equate “cloud” with web-based applications (SAAS) and web-based file sharing and assume that any talk of cloud desktops means desktop-as-a-service (DAAS). Unfortunately, web applications and file sharing services, and especially DAAS, are often NOT the best or most advantageous solutions available to the SMB/SME organization.

Rather than taking an “all or nothing” approach to cloud, small businesses benefit more from a strategic combination of cloud servers and desktop software, a hybrid model where the business gains the best of both worlds.

It is sometimes frustrating that small business IT personnel are the drivers behind migrating businesses from desktop applications to their web-based counterparts.

Most SMB software purchases are solely handled by IT, disregarding other important stakeholders.

Capterra’s 2023 SMB Software Buying Trends Survey

These non-business users pave the way for moving the business to cloud-based applications rather than modernizing the platform for existing applications to enable improved processes and workflows. This is especially challenging for accounting and finance operations where the businesses are being encouraged to migrate without first considering the underlying business processes or the accessibility of the impacted and associated data.

Businesses have developed an appreciation for the stability and predictability of desktop applications, along with the recognition of the challenges of transitioning from a system that is deeply integrated into existing workflows. Training users and adapting the work while migrating to cloud applications can be complex and costly without delivering significantly new or increased business benefits.

Data control and security are also large considerations. Most desktop applications allow businesses to retain direct access to and control over their data. Sensitive information remains within their reach rather than under the direct control of a 3rd party SAAS provider from whom they must gain permission and access to retrieve their data.

Rather than pushing the business towards web-based application services, a hybrid approach that modernizes the server and network platform as well as the user working environment may make more sense and provide the organization with greater advantage. This allows businesses to leverage their investments in desktop software, processes, training, and data and still make significant operational improvements and transformations.

Even more, some businesses rely on specialized software that isn’t easily replicated in a web-based environment. Existing desktop applications, especially industry-specific or custom-built tools, may not have cloud equivalents. Migrating these to the cloud server platform allows for uninterrupted productivity even as the business transitions from local to cloud-based platform and operations. Employees comfortable with existing software can maintain productivity without significant adjustments.

Using a cloud server to replace on-premises servers and user desktops, and keeping desktop and network applications working more securely, with improved access and management is the hybrid approach most advantageous for small and medium size businesses.

Noobeh works with Microsoft Azure, providing cloud servers that are scalable so small businesses can adjust their computing resources based on demand. Whether it’s expanding during peak seasons or downsizing during quieter periods, cloud servers offer flexibility that on-premises machines can’t.

Businesses can continue to use the critical desktop application tools they rely on and retain direct control over their data at the same time. Sensitive information remains within their cloud network, but users can access it from anywhere.

This hybrid model combines the benefits of cloud servers, including scalability, cost-effectiveness, agility, and security, with the benefits of keeping existing desktop software, including functionality, stability, data investment and control.

A hybrid approach to modernization allows small businesses to leverage the advantages of both cloud servers and desktop software, tailoring their technology stack to the unique needs of their businesses and in a way that is most advantageous to the business.

jm bunny feetMake Sense?

J