Category: Business Process Automation

Posted on

More Than Expenses: Manage the Purchase Process

For many business owners, just hearing the term “expense management” brings about visions of traveling employees with piles of receipts and vouchers to be organized, accounted and reimbursed for. The images are often fleeting, however – gone out of mind with no lingering thought because these business owners don’t have personnel who travel frequently, and they don’t have to deal with volumes of expense reports from employees. Expense management solutions aren’t anything these business owners are looking for.

Yet, what does happen every day is that equipment, materials, supplies and services are purchased to keep the business operation going. Calls are made to vendors; price quotes are developed, and purchase requests are typed up in Excel spreadsheets and piled on the owner’s desk for approval. The business owner rifles through the various requests and brings in the bookkeeper to help work through the decision of which items to authorize based on current cash availability.

Because the availability of working capital changes frequently with billings being sent out and receipts being deposited daily, the owner and the bookkeeper spend much of their time together figuring out which purchases to make and when. It is a continual and ongoing process, taking a lot of time and attention away from other important business matters.

Too often, thoughts of managing these efforts with more structure addresses only half of the issue – the purchase. Perhaps there are systems for planning for materials requirements and predicting when parts or supplies will be needed, but that is still just one side of the problem. The other side is paying for it. Factoring those purchasing plans into the cash requirements of the business and having a meaningful and effective way to monitor current cash and expected receipts as well as purchase requirements is essential. Resource and materials planning takes purchase planning, and purchase planning takes visibility into receivables, cash flow and cash availability.

Expense and purchase management processes generally involve three main steps: planning, tracking, and reporting.

As the process involves planning, it suggests a proactive rather than a reactive approach to cash management and purchasing activities. By bringing together all the critical data which describes inflows and outflows, the business owner can have the information necessary to not only forecast (plan) cash requirements but to also understand the availability of working capital.

Knowing ahead of time that traditionally slow paying contracts aren’t factored into immediately available cash is important and being able to adjust purchase schedules based on availability of funds is essential.

Where expense management may not be a big part of the business, managing cash flow and purchasing goods and services is, even in the smallest of enterprises. Make sure the business has the tools in place to help bring an additional level of intelligence to purchasing activities, and that those tools deliver the benefits of a structured (but not time consuming) purchasing approvals and proactive cash flow management process.

This aspect of business – expense management and purchasing processes – is an area where accounting professionals can be of great service to their business clients.  Providing high-value solutions that increase cash efficiency and facilitate cash and purchase planning helps the business function even as conditions change.

Make Sense?

J

Posted on

Are You Prepared for SQL Server 2008 End of Support?

 

Everything gets old eventually, and now it is official for SQL Server 2008.

03-2012sean-phone-328-e1377042261105On July 9, 2019, support for SQL Server 2008 and 2008 R2 will end. That means the end of regular security updates and general support for the product. Are you ready?

It took more than 10 years for Microsoft to end support for our beloved SQL 2005 and version 2008 has enjoyed a similarly long reign. But it’s over and you need to get used to the idea. Even more, you need to get upgraded to a new version of SQL so your systems can still be patched, updated and supported. With all the nasty exploits out there, letting your software get out of date is more of a business risk than ever.

With cyberattacks becoming more sophisticated and frequent, running apps and data on unsupported versions can create significant security and compliance risks. The 2008 family of products was great for its time, but we highly recommend upgrading to the most current versions for better performance, efficiency, and regular security updates.

Now is a Good Time to Consider Azure

Microsoft is giving a present to businesses that want to migrate their workloads to Azure. For those customers that elect to take this as an opportunity to move to the Azure cloud, extended security updates will be available for free in Azure for 2008 and 2008 R2 versions of SQL Server and Windows Server to help secure workloads for three more years after the end of support deadline. Moving existing systems to the Azure cloud is a natural step in modernizing the business infrastructure and makes the next step of upgrading to managed database services and/or migrating to new Azure servers a lot easier.

Upgrading isn’t simply a matter of maintaining status quo, either.

Moving to new versions can be a foundation for new strategic capability and increasing overall business potential, powering new decision-making processes fueled by analytics and business intelligence.

The Microsoft Lifecycle Policy offers 10 years of support (5 years of regular support and another 5 years of extended support) for the 2008 and 2008 R2 versions of SQL Server and Windows Server. When the extended support period ends, there will be no patches or security updates, which always creates security risk.

If your business is going to remain competitive, you can’t rely on outdated systems.

Your business is tough enough to manage without having your systems work against you.  Software that prevents you from keeping up with demand, creates risk in compliance and security, and reduces operational performance is not what you need. Collecting, storing and rationalizing data takes power and speed, and securing your growing information warehouse requires vigilance in security and update management.

Use this opportunity to review your platforms and applications, and consider moving your on-premises or co-located systems to the cloud. The upcoming milestone is a great opportunity to transform applications and infrastructure to take advantage of cloud computing and the latest versions of SQL Server and Windows Server.

jmbunnyfeetMake Sense?

J

Posted on

4 Rules of Thumb for Getting Business Benefit From EDI

The First Step in Transformation is to Stop Doing Things Twice

Double-entry is dumb. Entering data once introduces the possibility of making an error, and entering the data again only increases the chances for a mistake. Typing information into the computer also takes time and the more manual entry is done the greater the potential is for input errors which take even more time to find and correct. Manual entry of information may be required when starting with a paper-based process, but double-entry of information doesn’t make any business sense. In this age of computers, the internet and electronic commerce, reducing manual entry to increase performance and accuracy is more important than ever. Thankfully, manual data entry is being eliminated and EDI is the foundation that helps make it happen.

tall-tower-vancouver“… the key is the unattended and intelligent movement of data from one system to another.  People don’t have to get involved in order for the information to flow from one system to another… it just goes by itself.  Like a robot.”

Robots are just automation you didn’t know you needed

Electronic Data Interchange (EDI) is the use of computer and telecommunication technology to move data between or within organizations. EDI uses strictly structured information that can be transferred from one program to another without human intervention. EDI is one of the most important subsets of e-commerce, being the technology that helps two parties exchange information around a commercial transaction. One of the fundamental first steps in business transformation is the automation of business processes, and this is the main goal of EDI.

EDI addresses and solves problems inherent in paper-based processes. For many, EDI is the basis for reengineering processes and giving manual workflows an automation overhaul.

4-rules-of-thumbHere are 4 Rules of Thumb regarding implementing EDI in the business and where it can deliver the biggest benefits

Rule 1: Go paperless and reduce or eliminate paper-based processes

Delays in activity performance and access to information are often due to paper-based processes, where transportation, storage and retrieval of documents cost valuable time. Labor costs are also higher when paper-based processes reign, increasing overhead costs for document processing and handling. Non-EDI systems also tend to be more error-prone because information is keyed multiple times, and because documents are transported, stored and retrieved by humans.

Rule 2: Reduce operational costs by increasing the speed of business and decreasing processing times and errors

Cutting costs is a top benefit of implementing EDI in the business, centered on doing away with the use of paper while automating key business transactions, saving both time and money in the core process as well as in error correction and problem resolution. Increased productivity is an expected result of employing paperless solutions and technologies. By reducing paper-based processes and embracing electronic transaction processing, businesses can handle more operational activities with the same (or fewer) human resources.

Rule 3: Re-Structure workflows to improve activities that make customers happy

Using EDI in the business helps to structure information and workflows, increasing efficiency and process performance in a variety of areas.

EDI also improves performance because processing time can be reduced to seconds, enabling greater efficiency in services delivery and a level of responsiveness that makes customers happier. Because EDI permits access to a potentially vast amount of detailed transaction data, the information can now be used to automate other processes and stored for analysis.

Rule 4: Get better data and more insight

EDI solutions help to minimize errors in the data, creating a basis for better reporting and analysis. Mistakes in data entry or order taking can be significantly reduced (if not eliminated), and well-structured data removes the need for “interpretation” of the information. Replacing paper documents with electronic ones can also make it easier to keep track of the status of an item, which is why EDI solutions ensure traceability of transactions that paper-based tracking can’t readily provide. All this serves to help the business gain the insight necessary to respond more quickly to changing market conditions and customer demands.

Integrating EDI into the business processes is key to improving business performance in a wide variety of areas. Like moving from phone to fax orders, or from fax to online, EDI represents a big change in how transaction processing takes place. By enabling EDI transactions with current and new suppliers and channels, the business also enables more efficient, seamless communications between all participants in the supply chain. Removing the need to re-key data and reducing the need to rely on human manual processes, EDI systems connect orders and invoices and shipping and returns… and all the trading partners along the way.

 

jmbunnyfeet

Make Sense?
J

 

cropped-logo_mc_w_short-1Cooper Mann works closely with the experts at Mendelson Consulting, experts at QuickBooks and EDI.
Posted on

4 Rules of Thumb for Better Inventory Management

Do you know where your stuff is? I’m talking about your inventory, and whether or not you know exactly where it is. Surprisingly enough, many small business owners don’t know where their stock is (and isn’t) or when it will get to where it is supposed to be. Whether the items are in-stock or on-order, staged or stored, shipping or standing, managing inventory can be complicated.

Some inventory problems may be easy to identify but there are so many other issues that may be more difficult to track down.

4-rules-of-thumb

The challenges of inventory management are too numerous to count, but these four rules of thumb can help reduce much of the frustration for small businesses and midsize companies alike.

Rule 1: Get real-time inventory status information

To manage your inventory well, you have to know where each item is and what its status is. When you don’t have up-to-date information on product stock you will end up increasing your costs. It costs more when you are rushing the shipment of items in, overstocking products, transferring stock from the location that really has the product to the location that thought they had it, increasing losses due to spoilage or losing productivity by not getting materials to the site when the workers need it. Shipping, overtime labor and other related costs go up simply due to not knowing the status of every item, and customer satisfaction and loyalty goes down.

Getting real-time information on inventoried items requires that item status be tracked throughout the inventory lifecycle. From purchasing to sales, inventory item and stock tracking will allow you to more effectively manage your products and avoid the troubles and additional costs that come with not knowing whether you’ve got it or not. Centralize the information in a software system which has the functionality to support end-to-end inventory management functions and keep that information up to date as activities occur. This is the key to knowing exactly the status of your stuff.

Rule 2: Don’t rely on manual processes

Manual Processes are dumb, m’kay? Really, though, they’re inefficient and take a lot of time and generally result in too many errors. Spreadsheets are hard to manage and time-consuming to update, and manually updating anything makes it prone to errors. When information is managed through manual processes it makes collaboration and sharing of that information far more difficult, which often impedes the performance of those who rely on the data. Perhaps the worst thing about manual processes is that they do not lend themselves to analysis or history tracking, making it difficult to identify historic trends or areas of possible improvement. And manual processes just don’t scale well.

Using software to manage your inventory introduces not just efficiency, but provides the information required to make informed decisions about purchasing and stocking items. Inventory management software delivers a level of automation in recordkeeping for inventoried items that reduces errors and makes the data more useful. When the inventory management software is combined with barcodes and scanning, manual entry of data is further reduced which increases the accuracy even more while also stepping up productivity.

Rule 3: Everyone should get access to the information they need to perform their work

Workers throughout the business need information to perform their jobs, but not every worker needs the same information. Buyers may focus on which products are in demand so they can negotiate the best deal with a supplier, but finance likes to see that purchased stock isn’t languishing in warehouses or on store shelves. While all users may work with the same product inventory, not all users should be able to view or change data that is outside of the scope of their work. A change made inadvertently by one user could become a costly issue to track down and correct.

Getting access to the information necessary to perform the work is a challenge when the systems or software aren’t geared to fully support all the business processes. On the other hand, workers shouldn’t have access to information outside of their area or which is not relevant to their jobs. The key is in providing the right functionality and information for each worker, enabling them to perform their tasks efficiently but not exposing them to other information or processes that may complicate or interfere, or simply take focus away from the task at hand.

Another aspect of information access is making the solution available to workers regardless of where they work from. Warehouse locations and sales offices or retail stores are often separate, so any central system should also address remote office or mobile worker access. Cloud deployment of desktop and network software solutions enables anytime/anywhere access and allows remote offices and warehouse locations to work seamlessly together.

Rule 4: Just know that you can’t scale a manual inventory system

Keeping track of inventory may be do-able when there are just a few items and a single location, but increasing the numbers turns manual inventory unmanageable. More items mean a greater likelihood that products will be missed or miscounted, and more locations increases the complexities of stock management and logistics. Without detailed item and location tracking a business won’t be able to recognize costs or losses per location. The business is more likely to lose or misdirect product, in part because issues with missing product due to worker theft are more difficult to identify because of the manual system.

Scaling a business needs the support of good software and systems to ensure that productivity and performance aren’t stifled even as business requirements expand. Manual systems or low-tech approaches to managing products and inventory may seem usable when there are few products and limited sales activity, but when the activity and volume cranks up, so does the need for a robust system that can keep up. With more orders, products, locations and workers involved a business also increases the chances for loss due to logistical issues, theft or purchasing mismanagement.

Among the considerations when implementing an inventory management solution should be the ability of the system to adjust to changing business needs through customization of processes or by integration with other solutions which extend and expand functionality. Additionally, training workers to use the software should be straightforward and not unnecessarily complicated by other unrelated processes, making it easier to expand use of the solution in the business.

How do you set yourself up for successful inventory management?

Get better software. It isn’t as complicated as you might think and it is really important.

The expense is worth it because the business will end up being more efficient, which drives profitability. The challenge is that there are many software products to choose from and they all seem big and expensive. Inventory management and stock control isn’t a simple endeavor, but the right solution will deliver business benefit quickly rather than requiring extensive training and complicated configuration that eliminates a near-term return.

Connect with us to find the inventory management and control solutions that meet the needs of growing businesses like yours. Our team understands the intricacies of single- and multi-location inventory management, just in time inventory and purchasing for stock, and we also know that small businesses can’t be overburdened by their software else there is no business benefit.

jmbunnyfeet

Make Sense?
J

 

cropped-logo_mc_w_short-1Cooper Mann works closely with the experts at Mendelson Consulting, the best in QuickBooks inventory management implementation.
Posted on

Next Generation Accountants and Businesses

Understanding the value and application of information technology is the cornerstone of building a successful “next generation” accounting or consulting practice. Professionals are finding that new opportunities to engage with new and existing clients comes from closer involvement with client financial and operational systems. Collecting and analyzing data, integrating applications and automating data exchanges, and leveraging cloud platforms and services is rapidly becoming the next level of “standardized” service offered by many professionals.

The pace of change is increasing, which makes it increasingly important for business owners to wisely select their technology partners and solutions. While many accounting professionals consider themselves to be the business owner’s trusted advisor, their clients often seek advice on increasing efficiency and reducing costs from software and IT consultants instead.

Yet conditions will change and could force the client business to make adjustments that impact the applications and services supporting the operation. Do the solutions in place have the agility necessary to meet changing business needs, being adaptable enough to meet new conditions or orientations? This is where accounting professionals can help their business clients make the right choices to address current and potential future needs.

Even as information management paradigms continue to shift, accounting professionals can help their business clients achieve better business performance and profitability through innovating workflows and increasing process efficiency. Whether or not the existing systems lend themselves to these efforts remains the question, and represents an area where the professional could provide great value.

Accounting professionals should look at services they can provide to clients that have direct and meaningful impact on operational efficiency and resultant profitability.  These areas represent not simply cost and efficiency improvements, but speak to quality of service and sustainability as well, creating better and repeatable outcomes that can support the operation even as operating conditions may change.

Improving data collection and analysis provides the foundation for understanding more about the operation, and delivers the insight required to identify areas where performance might be improved and then to prove the outcome.

Automating data exchanges and imports, eliminating redundant entry and the potential for manual errors, establishes structure in processes which can then be streamlined to deliver consistent and predictable results.

Utilizing cloud platforms and services allows the business to utilize the infrastructure required to support operations while providing a level of affordable scalability that doesn’t push the business beyond its reasonable boundaries.

What this discussion touches on is the subject of digital transformation and what that really means for small businesses and the accounting professionals who support them.

Rather than performing the accounting and financial work as after-the-fact participants, accounting professionals should help their business clients take a new view of processes and activities performed throughout the business, identifying areas where new approaches can be applied to increase efficiency as well as agility, developing a stronger foundation for growth and profitability. 

From the adoption of paperless and electronic workflows to merging social media with marketing and support activities, digital transformation represents an ongoing effort within a business to fundamentally shift from manual processes to electronic exchange, and expanding considerations beyond physical boundaries to include the virtual, as well.

All of this represents new opportunity and enhanced value for the accounting professionals ready to help their clients become “next generation” businesses.

Make Sense?

J

Posted on

Model Your Dreams, Not Your Workflows

Jurassic Park: “Are those heavy? Then they’re expensive, put them back..”

Process modeling, process improvement, workflow design and quality management all sound like big, complicated things that larger companies do. Analyzing and re-engineering processes and developing highly structured workflows is often work performed within an enterprise; heavy and complicated and expensive work that’s required to keep large or distributed organizations operating as a single unit. But structure isn’t just for big business operations; it’s a big deal for small business, too.

The truth is that modeling business processes and workflows isn’t necessarily difficult or expensive, and the benefits to be gained apply as directly to small businesses as they do to large enterprises – perhaps even more because smaller businesses can change their trajectory early on, before things are too fully entrenched.  Ongoing, the development of workflows to guide process activities and the regular evaluation and testing of the outcomes may reveal wondrous opportunities to increase performance and profits. It’s all about drawing that picture of what you want the business to be, and then finding the best way to make it be like that.

While business owners and managers may be familiar with projecting financial performance under different scenarios, how often do they look at the actual processes supporting business operations and “project” performance based on changes to processes, worker activities or operational workflows?  It just isn’t something you hear much about in the small business world.  When I reached out to Ben Boomer of ParkPro to have a discussion about this type of stuff, I had no idea that the conversation would turn into a real example of how one single software solution could be the foundation for incredibly beneficial change in the organization, the business performance, and the satisfaction of workers and customers alike. The software is from the Dutch company Exact, and the product is Synergy Enterprise.

ParkPro has been operating for just about 40 years, providing an array of services and solutions ranging from auto gates and access controls to parking revenue management and camera solutions, and even anti-terrorism solutions.  Their deliverables are mostly project-based and there is a very large installation and maintenance services aspect to the business. What all this means is that there are a lot of moving parts, lots of scheduling, projects and recurring activities, and lots of possible product and service combinations. There’s also a lot of inertia behind the processes and methods that have been standard business practice for a long time.

“Making any change to how the business operates is akin to changing tires on a moving vehicle” says Boomer. “You still have to get the work done and move forward”.  With Synergy Enterprise, ParkPro’s system is agile enough to allow them to use the software and at the same time configure and tweak it to meet the needs of the business and not the other way around. He suggests that this is the problem with systems that lack of the flexibility of Synergy Enterprise; businesses must adjust to the way the software works rather than making the software really work for the business. Ben discussed an example and the good advice he received from Jeff Sachs when the company wanted to implement barcodes and thought they could use whatever came in a “canned” solution. Jeff’s suggestion was that “if the process doesn’t work, then this will simply make it not work… faster”.

Greater efficiency and performance are always important, but what it also comes down to is configuring accountability into the system.  The very act of formalizing the processes and the workflow forces ParkPro to think about and define the processes as they really are.  The system that helps them set up work requests and structure activities also helps establish accountability along the way. This has allowed the company to benefit in ways they couldn’t even imagine.

Synergy allows them to make copies of their system where they can pose questions and model the answers and outcomes.  “Do we really need to do this step, or is it just because it’s written down?” he asks. “We can pose questions and then find efficiencies in answering those questions”.  Just as with financial modeling and forecasting, workflow modeling informs on the potential result of the adjustment, allowing businesses to make better decisions and avoid missteps.

The ability to adapt Synergy Enterprise to the requirements of the business has been central to the company’s success in creating new efficiencies and improving overall performance, and the effects are felt throughout the company.  Boomer says that the changes they’ve made in their processes and the workflows which connect them has even resulted in restructuring the organization and management hierarchy to be more reflective of how things are in Synergy because its more efficient.

Reliant upon the “open” nature of Synergy Enterprise and its ability to flex with the needs of the company, Ben knows the solution will continue to support beneficial change in the operation.  In Ben’s own words, “Synergy allows us to project our future dreams and know the software can keep up”.

Make Sense?

J

 

  • Series Introduction:  Fringe to Foundation: Aligning Business Goals and Lifting Business Performance through Digital Workflows
  • Article 1: Every Business Deserves a Chance to be Better
  • Article 2: Improve Processes and Profit More
  • Article 3: Workflow Has 3 E’s