data management – Cooper Mann Consulting

January 3, 2014June 13, 2017

Degrees of Success: Improving Productivity and Performance through Process Automation

Few businesses use just one solution to get all their work done. In most cases, the business must at least communicate, produce information and account for financial activities – and each of these functions has a software product or service associated with delivering the required capability. While every business uses technology at some level, some businesses have more success than others in developing streamlined and efficient processes guiding the various tasks and activities performed throughout the day. Sometimes the problem stems from a lack of understanding of the importance of process automation, and sometimes it’s the software.

integrated

The success (or lack thereof) in streamlining a business process is often enabled by the tools supporting it, yet the truth of software and systems is that not everything is easily integrated and not all business workflows actually “flow” smoothly. In many cases it is left to the human user to connect the processes and keep the work flowing, creating the opportunity for missed deadlines, duplicated or erroneous data, and a greater dependency on individual worker knowledge than is good for the business.

The better alternative may be the adoption of workflow and automation tools to assist with bridging and scheduling of repetitive tasks, building the knowledgebase of process and task flow supporting business sustainability efforts and easing the burdens of training new employees. Process automation helps to improve productivity, it’s just that simple.

If the time is taken to really consider the variety and numbers of repetitive tasks employees perform throughout the day, the cost in time, lost productivity and data errors or omissions would likely add up to far more than initially expected. People tend to adapt to using the tools they are provided, and will find ways to get things done (whether it’s the most effective way or not). The end does not always justify the means, and many businesses ultimately find that it is here – where individual worker initiative and unguided action are most prevalent – that the operation fails to accomplish stated goals.

In order to create a sustainable operation with consistently high levels of production and performance, the business must establish a complete framework for process automation and support. Where existing application and software functionality is not able to meet the requirement, the business should implement specialized tools to bridge the gap and embed the process knowledge in the system.

Scheduled reporting, customer and product data synchronization, import/export routines, data maintenance routines – these are among the tasks and processes which represent the regularly-performed work that may be sucking the user productivity and performance out of the business. It’s a matter of degrees of success, and productivity improvements introduced through comprehensive process and task automation can make the difference between a little success and a lot.

Make Sense?

November 13, 2013

The Line in the Sand: Your RPO (Recovery Point Objective)

Businesses and individuals are increasingly more dependent upon the technology supporting their various activities, and the volume and velocity of information moving through these systems is increasing at astonishing rates. With the growing reliance on information technology and electronic business data, you’d think that more businesses were paying close attention to protecting these assets. I recognize that there is a broad understanding of responsibilities as they pertain to system security, and businesses of all sizes and types are increasing their awareness of the variety of threats facing their systems and are taking steps to address them. Yet there remains an aspect of business data protection that too few businesses are really zeroing in on, and that is the time and complexity of recovering or restoring business data in the event of an outage or loss – and the absolute line drawn in the sand which says that “here” is the tolerable loss we can experience: no more and no less.

This line in the sand is referred to as the RPO, or Recovery Point Objective. A recovery point objective is part of the business continuity plan (or should be!), and describes the maximum tolerable period of time for which data might be lost from a major IT service incident. The necessity to establish this time frame – the RPO – exists whether the business is small or large. In fact, small businesses have data protection needs quite similar to their enterprise counterparts. In an article in SmallBusinessComputing.com, Kieran Maloney of Quantum Corporation is quoted as saying that “from a data protection standpoint, smaller businesses face challenges that are similar to those of larger enterprises; the amount, and the value, of their data is growing significantly while their budgets are not”.

What doesn’t seem to make sense is that businesses continue to view data backup as a necessary evil rather than a strategic element, and spending considerations for creating and meeting a realistic RPO remain low. An article in TheStreet.com on the subject quotes Terry Cunningham, president and manager of EVault, saying “When largely preventable data loss conservatively costs businesses hundreds of millions of dollars annually, it is time to rethink your priorities”. The author also writes that “while 95 percent of US IT decision makers said they have some type of disaster recovery plan in place, only 44 percent have remote, cloud-based recovery capabilities… More than twenty percent of IT organizations that manage between 2-7 TB of data suffered a data loss in the past year – in fact, more than half of this group suffered 2-3 data losses – each with an estimated average cost of 2-5 percent of total company revenues”.

Part of the continuity plan and a consideration in developing an approach which will meet the RPO timeframe should be the implementation of remote cloud based service, yet this has remained a low priority for many business owners. Reliance upon more traditional data protection approaches, including tape backups and on-premises HDD solutions provides IT managers with a false sense of security and often cannot even reasonably address recovery from data loss due to hardware outages, much less for potentially catastrophic failures including loss of the location.

When considering the RPO – the minimum acceptable point for data recovery (or maximum tolerable point for loss) – businesses must look at their data management and backup strategies in order to address recovery approaches for various types of outages. There are benefits and drawbacks associated with the different methods of backing up data, and the cost/benefit of employing any solution must factor in to the requirement to meet the stated RPO. Daily backups may be the standard procedure, but is a potential loss of 24 hours of data acceptable to the business? On the other hand, what is the potential cost of re-creating the data, if it can even be recreated? Consider also that the timeframe for data recovery is not the point at which the last backup was completed; it is the point when the last backup was started. This could result in a loss window greater than the established 24-hour boundary.

Many businesses would suggest that their tolerance for lost data – due to the cost of lost productivity and order activities – is far less than 24 hours, yet solutions employed to reduce the potential data losses often do not fully address the issue in any comprehensive manner. IT personnel working with separate products to handle incremental data backups, machine recovery (bare metal) and snapshots of disk arrays often have a tough time trying to piece together the various pieces of the puzzle and often simply hope for the best in terms of outcome.

The prudent move is to thoroughly consider the business disaster recovery and continuity plan, and establish the boundaries for tolerable loss. No business wants to expect to lose valuable data assets, but expecting technology to perform flawlessly is unrealistic, not to mention the unexpected impacts from acts of nature or other forces majeure. Architecting systems to withstand service outages and having a comprehensive plan for recovering from system outages in a timeframe survivable by the business is the essential element to making a continuity plan worthwhile. Draw the line in the sand, and then develop the system protection and recovery plan that will help make sure you never have to step over it.

Make Sense?

Here are a few data loss statistics for your reading pleasure… Enjoy 🙂

(stats drawn from summary on BostonComputing.net. They may be a bit dated, but the numbers have only increased since then.) http://www.bostoncomputing.net/consultation/databackup/statistics/

The following statistics were gathered from various sources:

6% of all PCs will suffer an episode of data loss in any given year. Given the number of PCs used in US businesses in 1998, that translates to approximately 4.6 million data loss episodes. At a conservative estimate, data loss cost US businesses $11.8 billion in 1998. (The Cost Of Lost Data, David M. Smith)
30% of all businesses that have a major fire go out of business within a year. 70% fail within five years. (Home Office Computing Magazine)
31% of PC users have lost all of their files due to events beyond their control.
34% of companies fail to test their tape backups, and of those that do, 77% have found tape back-up failures.
60% of companies that lose their data will shut down within 6 months of the disaster.
93% of companies that lost their data center for 10 days or more due to a disaster filed for bankruptcy within one year of the disaster. 50% of businesses that found themselves without data management for this same time period filed for bankruptcy immediately. (National Archives & Records Administration in Washington)
American business lost more than $7.6 billion as a result of viruses during first six months of 1999. (Research by Computer Economics)
Companies that aren’t able to resume operations within ten days (of a disaster hit) are not likely to survive. (Strategic Research Institute)
Every week 140,000 hard drives crash in the United States. (Mozy Online Backup)
Simple drive recovery can cost upwards of $7,500 and success is not guaranteed

October 7, 2013

Marketing and Sales Needs System and Process Automation

Running a business means finding and keeping customers who will buy from you. This isn’t necessarily easy, particularly with the number and variety of “impressions” people get throughout their day. It used to be that simply locating a business in the right place would generate drive-by traffic, with location being the key to generating impressions and causing people to actually stop and shop. Impressions – yes, those brief instances where your brand or service is viewed – count.

The entire lifecycle of the customer relationship starts with the first impression, so it needs to be a good one. Marketing impressions expose your business and products to prospective customers, with efforts oriented towards the generation of sales leads. A lead is a business or individual that may ultimately develop into a sales or business opportunity. Rather than attempting to engage with businesses or individuals one at a time, businesses use marketing to target large groups in hopes of earning the permission to engage group members in more focused or individualized sales activities. When the business earns the ability to communicate directly with a prospective buyer, a sales lead is generated, and the business now has a prospective customer and the potential to make a sale.

Sales leads don’t stop becoming leads just because they purchase from you. Every customer remains an ongoing opportunity to generate new business directly or indirectly via referrals or recommendations. The best case scenario for your business is when you know when and why your customer buys from you, when the customer wants more, and that they will refer their friends or business associates to you.

Part of the problem with marketing and sales is that there are often too few people and/or resources to apply to the task. Most businesses aren’t in the position of simply throwing money at a problem (which rarely actually solves the problem), so it becomes essential that you find a way to get the job done with the same or fewer people and resources. The keys to solving this problem are systems and processes (automation). Automation doesn’t always mean that there is an “automatic system” somewhere which performs all of the tasks for you. In most cases, it simply means that the process is structured, efficient, and is able to be effectively repeated without significant deviation or loss. Structured systems and processes, along with a strong commitment to capturing activity data and measuring results, is the foundation which will support growth.

Marketing Automation Explained (Infographic) | The automation of business function is set to be the new trend in 2014. There are already dozens of sales, marketing and finance automation options, and for good reason: The quantifiable returns they provide are undeniable. Here is a look at marketing automation and how it works.

http://www.entrepreneur.com/article/227923#ixzz2ghHq9Qpn

From the very first impression through the conclusion of the sale and ongoing, it is essential to capture the data which describes the activities and events around doing business with your customers. It is important to track unsuccessful efforts as well as those which are successful. By understanding what does not work, you develop valuable insight which helps refine the process and the approach, resulting in fewer wasted efforts. The accumulated data tells the story of how you earn new business and how you create a customer relationship, which helps you understand how and where you are successful in earning new business and why you are able to retain loyal customers.

Joanie Mann Bunny Feet Make Sense?

September 25, 2013September 25, 2013

Enterprise Functionality for Small Business | Relating to Customer Data

handshake

Many small business owners are under the impression that most powerful business process management solutions are just for big businesses. A common misconception, for example, is that robust CRM products with turn-key functionality are too complicated and expensive. This misconception leaves most small business owners to frequently turn to inexpensive online solutions or to their favorite email client in order to store and manage customer information. In today’s competitive business environment, the intelligent and innovative use of technology and business information is often the determining factor between success and failure. Now more than ever, small businesses must leverage tools with the same capabilities as their enterprise counterparts in order to help the business perform at levels necessary to drive growth and maintain profitability.

The data developed within the solutions supporting various business processes is the key which unlocks business intelligence. This data may only be captured and used if the systems and tools in place allow for it. With far too many small business CRM solutions, the assumption is that simplicity of use is the equivalent of less functionality. Approaching the problem from the standpoint of what most small business owners KNOW they need to know, developers have sometimes failed in delivering the capability (and resultant data) small business owners didn’t know they needed or would benefit from. What business owners need to know about is the customer.

Customer Relationship Management (CRM) solutions help businesses identify, acquire and retain customers. Almost any business relationship or interaction represents a customer opportunity. Present customers are customers now, past customers are not just past customers but prospects and everyone else is a prospective future customer. Consider that vendors or resellers are different types of customers, too. Even employees and coworkers can be seen as “internal” customers. Keeping useful and relevant information about these various “customers” and documenting how the business interacts with them is essential to understanding the entire relationship lifecycle, which is a step towards understanding the business better.

When a small business elects to use a software solution to handle the various interactions with customers, it is often approach in pieces rather than in a comprehensive manner. Traditionally, Contact Management solutions are applied to sales efforts, providing tools for communicating with leads and prospects as well as current customers. However, related information is also often stored in accounting systems, which handle billing and payment processes involving customers (clients, suppliers, employees, etc.). Some businesses also may use other systems for time management, service or work order management, project management and to archive related documents and emails at various levels of the relationship, where customer information is used and data is created. With segmented pieces of information in numerous databases, it is hard to achieve true Business Intelligence and a comprehensive view of the entire operation. Smaller companies can easily miss out on the benefits that their enterprise counterparts possess.

It’s not really unusual for businesses to store some of the same information in several systems, generally in order to support specific job functions for workers in those areas, and delivering data on the equivalent of a “need to know” basis. For most small businesses, though, an integrated Business Management system that provides CRM as a component of its overall offering could be the answer to providing a single comprehensive solution for all departments. An integrated solution of this sort would seamlessly integrate with the accounting, email, and document management products Small Businesses use every day. Examples of such solutions include, but are not limited to, Results CRM, Method CRM and LeGrand CRM.

Beware, however, that not all integrated CRM solutions are created equally. If your organization delivers billable services, make sure that the integrated CRM system that you select can take a billable appointment that was scheduled in the CRM system and automatically place that on an invoice for you – without duplicate data entry and manual tracking of timesheets – so you’re not leaving money on the table. If you manage projects, make sure that the CRM system has the cohesiveness to include project and resource management functionality so that the full business relationship – from sales to the delivery of services to billing – can be managed and tracked in one system without duplicated data entry.

When systems are not tightly and intelligently integrated, sharing data between them becomes very problematic. Without the ability to check for duplicate records or properly map data points and related fields between systems, there is a great potential for errors in or duplication of data. The result could be a large amount of unrelated and unusable information, which is often what happens when list or transaction data is simply copied between applications without the necessary logic to understand changes in various records, record types, or record states.

There’s a reason why “legacy” integrated software solutions made sense for businesses, and why many enterprises continue to hold on to their solutions – they include the wide variety of tightly integrated functionality and logical data sharing that has been a benefit to the business for years. As organizations seek to start up or reassess their software and systems, they would be wise to keep in mind that generating “big” data with a bunch of loosely connected applications isn’t enough. The data must be intelligently related – just like the business and the customer.

A tightly integrated and well-managed CRM and Business Management solution, whether in-the-cloud or on premises, is not out of financial reach for small business. While a solution of this type is not free, the reasonable investment in a quality solution will provide the Business Intelligence necessary to build and maintain a competitive advantage.

Joanie Mann Bunny Feet Make Sense?

August 7, 2013March 2, 2017

Bookkeeping Needs Better Reporting Tools

There are many articles and papers available which discuss the rapidly increasing “volume and velocity” of electronic information moving through businesses these days. The focus of the discussion in most cases is on how businesses need to adopt tools and solutions to help them with the management of this electronic data flow. What isn’t being discussed at length is the visceral business intelligence which is lost due to less direct interaction with the raw data.

By manually working through each item, the person regularly processing the information would often develop somewhat of a picture of the business simply through a level of intuition, a gut reaction to the information. This is a rapidly declining model, thanks to intelligent technologies and direct system integrations.

With the plethora of electronic information sources, data collection tools, and transaction download facilities, many bookkeepers and business owners are finding that their gut instinct and business intuition is being lost in the shuffle of managing and matching up all this electronic data.

Focusing on small business bookkeeping, the processes are now being oriented more towards matching up electronic transaction data points than on entering the information from the raw source. Where bookkeepers were once perceived as “mechanics” in terms of performing the bookkeeping data entry, the activities of these professionals is becoming even more mechanical in nature as the primary requirement shifts from entering the information to importing it and then matching it to source documentation.

Even decisions regarding categorization of the transaction are often made by software solutions, eliminating more involvement by the bookkeeping or accounting pro. At the same time that bookkeepers and accountants find themselves having difficulties communicating the value of the service they deliver, technology trends in the industry are weighing even more heavily on that value proposition by providing users with do-it-yourself tools and self-service solutions.

The answer to the challenge of demonstrating value in the bookkeeping and accounting processes is for accountants, bookkeepers and business owners is to focus on the result of the work rather than focusing on the work directly.

Small business owners will challenge their accountants and bookkeepers to explain why processing a limited number of transactions per period would cost much, and the professional ends up fighting a battle which cannot be won; there is far more value in the work they perform than simply entering the data. It’s this explanation of WHY bookkeeping and accounting takes skill and has value which become arguable to the business owner, and is a discussion which the accountant or bookkeeper is more likely to win if they were to in a position to provide their client with proof of this value.

Too often, accounting and bookkeeping service providers attempt to prove their worth to the client by espousing the quality, accuracy, and timeliness of their services and say too little about the value of the result they will deliver. Additionally, many professionals introduce their clients directly to the accounting software and try to engage the client to work cooperatively with the bookkeeping, as there is a perception that the client may see more value in the work if they can a) see it being done in real time and b) see how complicated it could really be.

Unfortunately the accounting and bookkeeping solutions often implemented by small businesses actually look pretty easy to use and are intuitive, which serves to even further diminish the value proposition as the client perceives that they could likely operate the software just as well as the bookkeeper.

In order to deliver the proof to the client that the bookkeeping work has value, the result becomes the focus of the effort. Rather than providing balance sheets, profit and loss statements and bank reconciliations, those involved in the bookkeeping and accounting process for the small business should also focus on reports which demonstrate the value of PROPER bookkeeping and accurately reflecting business activities.

Would the client know the real difference between cost of goods sold and a regular business expense? Reflection of that single transaction with two different treatments could be the trigger to get the light bulb to light up. How best to demonstrate the variation? Not in pure written report form, that’s for sure. Numbers alone don’t generally trigger real understanding, but painting a picture might.

Today’s dashboard and reporting tools – solutions which use information from the accounting system to reflect visual trends and representations of business performance – can deliver far more meaning and easier understanding than a columnar report with numbers and percentages. Further, these tools can address the task of revealing critical insight into business value, demonstrating (for example) the difference between cash flow and profitability, or identifying trends which indicate patterns in how the business is causing or reacting to change.

As small business owners feel continued pressure to improve performance and profitability, and as lending sources for business credit remain difficult and costly to engage, the necessity for quality bookkeeping and accounting services does not diminish, it increases. The challenge is in finding ways to read the data and discover the insight and meaning it reveals.

The value of bookkeeping and processing accounting data for businesses is ever-increasing in these days of global markets and global competition, and the forward-thinking professional will recognize that deeper insight into the business – insight enabled through the use of realtime reporting and analysis tools – delivers an ongoing opportunity to work closer with the client in addressing challenges identified and presented, and allows the accounting professional, bookkeeper and business owner to be guided by real information rather than emotion or intuition.

jmbunnyfeet Make Sense?

read the original posting at The Progressive Accountant.

May 23, 2012November 20, 2017

Compliance in the Cloud – Their System; Your Responsibility

Can you outsource compliance to the cloud?

Outsourcing IT to a cloud service provider can be tremendously beneficial for a business. The model allows an organization to offload not just IT infrastructure costs, but also the costs associated with developing and maintaining all of the practices and processes involved in managing and maintaining the infrastructure and systems. There is tremendous responsibility in handling everything from platforms and infrastructure to creating best practices for maintenance, management of scalability and growth, forecasting bandwidth requirements, implementing and monitoring security compliance, creating effective and comprehensive disaster recovery plans, and more.

The question which begs to be asked is whether or not HIPAA, PCI/DSS or any other compliance requirements, and the complexities, risk and legalities that come along with them, can also be outsourced to the CSP. For that matter, can any real level of responsibility be fully outsourced, where the liability for non-performance or noncompliance is also fully shifted?

Ummm. No. It is still your problem.

What too many companies really don’t understand is that they aren’t eliminating risk by moving to the cloud, and the requirement to meet various compliance requirements really can’t be outsourced. Particularly in this area, businesses need to recognize that outsourcing certain functions doesn’t reduce or eliminate responsibility or liability. Just the converse, it could make things a bit more difficult if you don’t keep close tabs on how the provider implements and is involved with your solution. Even beyond that, what is the impact to the business operation when requirements are not met? Cost recovery from the provider may be one option, but how does that help the business remain operating in the meantime?

“Gramm-Leach-Bliley (GLB) Act Requires financial organizations to enter into contracts with third parties that they share their customer information with (including cloud vendors) to ensure that the third-party handles that information securely. Executives of those financial organizations can be held personally liable for failure to do so.

Sarbanes-Oxley Act (SOX) Defines specific security mandates and requirements for financial reporting to protect shareholders and the public from accounting errors and fraudulent practices. SOX dictates which records are to be stored and for how long and requires the data owner to know the location of the data in the cloud and to maintain control of it. Failure to comply can result in fines and/or imprisonment.”

source: CIO.com

This discussion Isn’t limited just to compliance with regulations (at least it shouldn’t be)

In this conversation we need to also address what a business should do in terms of protecting and preserving its information assets (data!) even beyond what the CSP offers. Keeping confidential and private information secure and protecting the data of the business (and clients or patients or other entities) is essential, even when the CSP fails in its obligations or abilities. This aspect of disaster recovery and continuity planning is not often considered by the CSP yet remains critical to the business customer. The sales pitch, however, never really delves into this area, because it represents an aspect of service coverage that the provider simply can’t provide.

Illustrating this particularly difficult aspect of outsourcing to the cloud is the hard lesson learned by customers of a QuickBooks hosting provider who experienced a severe outage due to a ransomware attack. The hosting service provider promised customers it backed up their data and it did, but the backup archives were also compromised. In order to restore service, customers were expected to have their own backups of the cloud-hosted data.

While there may have been items in the service agreement which address these issues, I can say – based on a great deal of experience in just this area – the service providers rarely make this point very clear to customers, and more frequently tell customers backing up their data is no longer something they need to really worry about. It’s like that really tiny type at the bottom of a contract that nobody notices until it is too late.

“..restoration proved more difficult in Texas. Lezama explained that for the Texas clients, the backups had been compromised as well, because their backup data had synchronized with corrupt files. But Cloudnine clients are obligated backup their own data as well, as a sort of third-level security measure..”

source: AccountingToday

With compliance in the cloud, it’s their system, but your responsibility.

Outsourcing IT to a cloud service provider in no way eliminates or reduces the obligations of the business to manage certain aspects of information systems and data. What outsourcing can do is deliver a greater operational capacity and agility more affordably.

The responsibilities to establish information and systems management practices and processes remain firmly with the business, and actually represent a strategic component of the business that is unwise to outsource anyway. Resilience in a business and its ability to conform to regulatory and other requirements are the foundations of sustainability. Remember that cloud providers and services can be leveraged to improve certain cost and system performance metrics, but it remains solely with the business customer to find ways to reduce risk and create a greater assurance of continued operational capability.

Make Sense?