data integration – Page 4 – Cooper Mann Consulting

January 7, 2015October 9, 2017

Everything Old is New Again: Big Fat Phones and Desktop QuickBooks in the Cloud

Every year that passes leaves some reminder of the time – some person or occurrence which touches us and creates a lasting memory. 2014 delivered its share of memorable people and moments and proved again that social platforms such as Twitter and Instagram have become increasingly significant as people across the world organize, march or call for change. Yet even as change is demanded from us and often forced upon us, it is wise to remember that the pendulum eventually swings both ways. We want to have our cake and eat it, too, which is the ultimate no-win situation and causes us to constantly and consistently seek out the alternative. Like the puppy chasing his tail, we end up going round in circles. Harem pants and jeans torn from knee to thigh have come back in fashion, and even though they didn’t really work the first time, here they are again. It is inevitable.

Information technology trends follow similar patterns, and what was once in high fashion may now be considered as “legacy”. Perhaps the better word is “classic”, as these legacy solutions often represent the standards by which new solutions will be measured. Eventually, the properties of the classic or legacy solution wind up in the new breed, because this is what the market has come to expect and/or demand. Even when entirely new standards are believed to be adopted, the truth is that years of learning and experience will often find the path previously traveled by others to be the right path.

It seems like so long ago when some said “the desktop is dead” and that all applications would be used by every device via the web, but not run on the device. Well, there are quite a number of web-based applications and services delivered in just that manner, but there are also lots and lots of computers out there with software still installed on them, happily working away for their users (there’s an app for that, right?). The desktop isn’t dead at all, it seems, and what’s more – there are trends to extend the capability and reach of the desktop to the web rather than replacing the desktop with the web. Application integration, process integration, interoperability, functionality and modality – all these factors and more have become the underlying drivers for extension of and hosting for desktop applications, and are the areas where SaaS and web-based application service has not delivered as expected.

The idea of having no software on the computing device is kind of silly, when you think about it. Computers continue to get more powerful and have more capability than ever. Heck, even phones are getting fatter and bigger again. The best phones these days are the ones that rival tablets and laptops in size and have lots of apps to run.

Microsoft Office, too, hasn’t gone anywhere, really. It’s still firmly attached to most workstations whether they’re iPads or Macs or Windows systems. Web-based productivity tools are certainly gaining in use, but not nearly as widely as some would believe. Office productivity continues to live on the desktop, and ties many users to desktop computing for that very reason. Use CRM in the cloud? I’ll bet you still export data to Excel or Word on the PC. Use accounting in the cloud? A lot of reporting still goes through Excel, trial balance systems and the like. The universe of web-based and SaaS apps is getting larger, but it hasn’t yet become the center of the universe for most established businesses. Net-new customers and smaller businesses are adopting SaaS due largely to cost and to the success of the marketing message, but use and direct experience with the product applied in the business setting often demonstrates that adoption of a more flexible (malleable) or functionally rich solution is indicated. The business likes the mobility, remote access and managed service, but not the actual SaaS application. So, hosting becomes the better alternative and the business is able to use the software that works for the business, and use it in a manner that allows the business to take advantage of remote and mobile capability, subscription service, and more.

I really have no gripes with web-based and SaaS solutions. In fact, some of my best friends use SaaS 🙂 The message I’m trying to convey is simply that, regardless of what the media and marketing may tell you, things don’t always change as quickly as it seems. Yes, there is a movement towards cloud solutions and online working models. Yes, there is change in how information technology is obtained and used. And equally true is the reality that only a portion of the market has adopted these changes and new philosophies. By the time there is “complete” adoption, there will be a new standard or approach being marketed and we will be in this place once again. Is there wide recognition of the benefit for mobility and remote capability? Sure there is, but it is also accompanied by the understanding that tried and true solutions will continue to deliver the functionality and capability businesses rely upon, even as new models for delivering them come about.

Make Sense?

Here are some of the most popular articles from CooperMann.com in 2014. Surprisingly enough, the most popular were articles about QuickBooks and the Cloud, a subject I’ve been writing about for many years. In fact, some of the most popular of my QuickBooks/cloud articles are from 2013 and they remain among the most frequently viewed even today. Search and view metrics indicate that the topic’s popularity is not likely to diminish soon, so plan to hear more about how businesses are using QuickBooks (and other desktop and network applications) in the cloud, but aren’t using Online editions to make it work really well.

The concert hall at the Sydney Opera House holds 2,700 people. CooperMann.com blog was viewed about 19,000 times in 2014. If it were a concert at Sydney Opera House, it would take about 7 sold-out performances for that many people to see it.

December 11, 2014September 25, 2018

Audit or Advice? Small Accounting Firm Practitioners and Small Business Clients

When a small business owner needs advice about running the business or strategizing on financial matters, one would think that the business owner would engage their accountant in the discussion. Following along with that logic, many small firm practitioners believe that their small business clients will ultimately engage with them for this advisory work and move beyond statutory audit and compliance work. For a great many firms, however, there remains a struggle to achieve more work and greater opportunity from client engagements; the firm remains relegated to performing mechanical functions of accounting and reporting and fails to gain the additional work which is truly desirable. There are a number of elements which present themselves in this discussion – considerations that the small firm practitioner may not be addressing – and which are likely contributing to the firm losing the opportunity to deliver more and deeper services to the client.

First, let’s consider why small business owners initially engage with their accounting professionals. More than with larger businesses, smaller businesses tend to rely more heavily upon the involvement of outsourced accounting professionals simply because the business isn’t able to justify the cost of staffing the position full-time. Needing office managers and bookkeepers or data entry operators is often a more evident need to the business owner, where assistance with daily operational and information management processes are more urgently required. Functions considered to be “accounting” could effectively be outsourced to a 3^rd party and handled in more of an after-the-fact basis. For many small business owners, accounting is something which can be performed after all the real work is done, and presents the information necessary for payment of taxes, processing of payroll reports and the like. The accounting professional is typically engaged because the business owner knows this work must be done by somebody, and believes the selected practitioner to be competent and trustworthy, and they’re also probably local.

With the convergence of market environment changes, regulatory and jurisdiction conditions, as well as changes in behaviors (cultural, sociological, technological), a new level of demand has been created for business and financial advisory services. Yet small business owners often remain reticent to approach their local small firm practitioner for the service. Why is it that the client doesn’t often approach their small firm practitioner with requests for advice and advisory services?

Part of the problem is perception. Small business owners often believe that their needs require specialized knowledge and experience to address, and that the skill and experience can only be derived from a larger firm. Particularly if the smaller firm is not presenting itself in a manner that suggests that business advisory services are not only offered but are a specialty, the firm may simply lose to competitors who communicate the ability more effectively (something larger and more established firms are able to do via referral and reputation as well as through marketing).

A possible way to address the competency and perception issue is partnering, where firms join to collectively deliver solutions to the client. Where one firm may specialize in an aspect of the engagement and the other firm addresses other areas, the delivery of full service to the client is ultimately the goal, and sharing the work and the revenue is often a more agreeable approach than losing out on the engagement altogether.

Another factor presenting itself in the equation is the “entrepreneurial spirit” from which many small businesses are fueled. A small business owner is often somewhat of a superman, taking on multiple roles and performing a variety of functions in the business. It is this DIY (do-it-yourself) attitude that contributes to the business growth and success, but it is also sometimes the barrier to achieving a higher degree of success. Believing more in the personal power of critical thinking than in the reliance on the professional’s education, experience and insight, the business owner simply refrains from asking for advice because they don’t think they need it.

Frugality is another factor playing into the small firm/small business relationship. Small business owners may want advice, but they don’t want to have to pay for it. Anyone selling products or services to small business recognizes that there is a certain amount of consulting and advice that accompanies most sales. For some, this is simply a part of the sales process; helping the customer determine that this is the best choice and they should buy it. It’s not so simple with accounting and finance, however. There’s a big difference – and perhaps large risk associations – in giving advice versus performing accounting and compliance work. Certainly, advisory services aren’t something the firm would elect to give away, so it becomes essential that the value of the advisory service be expressed in a way that the client can understand and believe.

I once heard a financial planner address this same argument, where a prospective client suggested that they couldn’t really afford to pay for the advice. The financial planner countered with the argument that a good financial plan will increase the return, which then recoups the cost of the advice. If you pay $100 for the advice, and you earn $500 more than you would have without the advice, then it kind of feels like you’re getting paid to get advice because you gain more than you spend. It’s the same with accounting, finance and business advisory services: sound advice should improve the rate of return, which would more than compensate for the cost of the advice. The trick is getting the client to view the service as something real and valuable and not as snake oil, and to make a commitment to following the advice. Real value must be communicated and tangible results measured and delivered, not smoke and mirrors. Otherwise, the client return isn’t there, and the advice proved valueless.

As regulatory requirements increase – and become increasingly complex – the demand by small business for outside help also increases. It is this ever-expanding demand which represents opportunity for small firm practitioners to capture more (more interesting and more profitable) work from their small business clients. But competition is also growing from new providers and systems delivering advice, forcing adjustments to how the small firm must present its offerings and services, as well as change how they deliver and support those offerings.Whether through partnering and referral models, the development of new competencies and capabilities, creation of new workflows and methods, or some/all of the above, small firm practitioners must adapt in order to get that opportunity.

While the small firm practitioner may recognize that the small business client is greatly in need of advisory services, what they may not recognize is that the traditional approach has turned around, and it has become more likely that the client will seek advice first and statutory audit work second. For small firm practitioners, it is time to recognize that relationships are changing and how business is done must evolve to meet and advance that change.

jmbunnyfeet Make Sense?

September 30, 2014

Revenue Recognition and closing the reporting GAAP

One company earns what the other company spends. This is business, and it seems like it would be pretty straightforward, accounting for the money coming in and the money going out. But it is really not that simple when it comes to business finances and accounting for revenue. With investor pressure to improve share prices and market pressures forcing greater competition, businesses have always sought out ways to make the performance look as good as possible – on paper even if not in reality. It is this requirement to make the business look better than it may actually be that drives “innovation” in financial reporting, and encourages some companies to use whatever rules are available to mislead investors or paint a rosy picture for stakeholders. When the balance is lost and financial reporting standards become so oblique as to allow regular and gross misrepresentation, it is time to change the standards.

There are numerous instances of fraud and scandal reported from the finance departments of big businesses, but instances of improper or misleading revenue recognition can happen in even the smallest of companies, and not necessarily on purpose. It is important to understand that properly and accurately reporting business revenue and earnings isn’t done just for investor satisfaction, it is an essential part of describing business performance that any owner or manager must be able to rely on.

Generally Accepted Accounting Principles (GAAP) provide investors and business owners with some consistency in the financial statements they use to analyze company performance, but only minimally. This is partly due to the fact that GAAP is based not only on some standards established by policy boards (the authoritative standards) but also on “generally accepted” standards, which are often not really standards at all but simply past practice that was found to be accepted. Especially in the global economy where fewer businesses operate solely within traditional territorial boundaries – and where accepted reporting methods vary widely – having a single financial reporting standard has become more important than ever.

Make it so, Number One.

Now there are new rules from FASB (Financial Accounting Standards Board) and IASB (International Accounting Standards Board) which provide clear and detailed guidance for how businesses recognize revenues. These rules are based on a consistently applied set of principles, no matter what sort of business is involved and regardless of where the business is located.

A focus of the new rules of revenue recognition centers on customer contracts, delving into the details of how earnings from those agreements should be recorded. Consider that many businesses combine multiple products and services into a single agreement, even though there may be several deliverables or milestones included. This method of booking customer contracts allowed companies to report revenues they were not yet due as part of a total agreement, often resulting with inflated earnings reports. Stakeholders would perceive that the company had reached one earning threshold, but the reality was something quite different and performance expectations were unmet.

“FASB and the International Accounting Standards Board (IASB) issued converged guidance on recognizing revenue in contracts with customers. The new guidance is a major achievement in the Boards’ joint efforts to improve this important area of financial reporting.” http://www.fasb.org/jsp/FASB/Page/BridgePage&cid=1351027207987

The new rules force an additional level of discussion, including a full set of disclosure requirements that will provide more information about contracts with customers. Businesses must identify each promised deliverable and attached revenue or earning component, which helps to better understand how the revenue may be earned (and recognized) as the business performs on the various obligations to the customer.

Just take a look at some big ERP companies and the lawsuits generated from problems and failures in delivery – problems that might have been more clearly identified to investors and stakeholders if the tie between product sales and services to be performed were more clearly described. In many cases, these situations exemplify the revenue recognition reporting problem, where large customer contracts and license sales were fully booked and recognized even though implementation services milestones attached to those license sales remained undelivered.

“2010 – JDA Software (i2) – Dillard’s, Inc.: Dillard’s had alleged i2 failed to meet obligations regarding two software-license agreements for which the department-store operator had paid $8 million.” http://www.zdnet.com/blog/projectfailures/erp-train-wrecks-failures-and-lawsuits/12055

For private companies, reporting periods beginning after December 15, 2017 must follow the new guidance. It may seem like a long period of time – from the decision to apply the new rules to the effective date – but the number of businesses the new rules will impact is large. The FASB made a decision to delay the effective date because of the broad scope of organizations affected and “the potentially significant effect that a change in revenue recognition has on other financial statement line items.”

Business owners and their accounting professionals need to make sure that financial systems and processes are up to the task and can track and produce the detailed reporting these new rules require. For investors and analysts, the new reporting rules and detailed information they generate will go a long way towards minimizing the impact of innovative revenue reporting practices, and will hopefully bring a new level of believability and usefulness to business financial reports.

Make Sense?

April 29, 2014December 7, 2017

The CPA for Small Business: Proactive, Responsive, and Helps Paint a Beautiful Picture

I once read an article written by Doug Sleeter which describing the findings of a published report titled What SMBs Want from Their CPA. The report was a summary of results from a study conducted by The Sleeter Group, and was intended to help accounting professionals understand the factors in the market which influence business use of professional accounting services. While adoption and use of technology was not named as the top item on the list, capabilities which can be rendered only if such adoption occurs were. In short, it’s not the technology that clients demand, but the level of service that professionals can only deliver by embracing advancements in technology and applying them to the client engagement.

The report and article placed a specific focus on trends relating to technology adoption and use in the professional practice, and establishes a foundation for firms to understand why technology is and always has been a key factor in the success of the CPA-client relationship. It’s not that the accounting professional must become a skilled technologist and promote high technology to the client. Rather, the success factor rests with the firm’s motivation to implement technologies and tools which will improve their ability to deliver more (and more valuable) service to the client in a more direct and timely manner.

The survey’s two critical questions posed to small business owners who use the services of a CPA were 1. What factors played a role in your decision to leave your former CPA?, and 2. What types of services would you like to receive from your CPA? Both questions are pretty straightforward, and the top responses from surveyed SMBs were equally unambiguous.

To the first question (factors playing into a decision to leave former CPA), the top two answers indicated that reactive and/or unresponsive are the problems which ultimately cause a small business owner to change accounting professionals. The top response was “Former CPA didn’t give proactive advice, only reactive”. The close second response was “Former CPA had poor responsiveness”.

Unfortunately, these responses more than accurately describe many professional firms and their approach to client service. These firms are perfectly content with waiting for clients to deliver after-the-fact information, delivering reports long after their relevance has past, and providing no sense of urgency in helping clients address business issues facing them here and now. These firms are content to work with their write-up and trial balance solutions, depreciation and amortization and tax products – and give little consideration to how they could adjust their operation to a better, more relevant and rapid delivery of service and insight to the client.

The second question, “What services do SMBs want from their CPAs?”, was met with the same responses professionals have been hearing for years; small business owners need help with business planning and business strategy and they wish the help would come from their CPA. It is surprising how many accounting professionals list business planning and strategy among the services they promote on their websites, and then just sit back and wait for clients to ask. Communication with clients remains relegated to annual reminders for tax information, or maybe slightly more frequent notes about other tax or compliance work to be done. It may be a bit unfair to place all the blame on the professional. Regulatory and reporting impacts on business are increasing and are increasingly complicated. Many professionals find it challenging enough simply to keep up with changes relating to the services they currently and regularly provide.

This is where practitioners should seriously take notice, and accept that the ability to meet changing market and customer demands is by intelligently leveraging technology to accomplish what people and process cannot do alone.

It takes information technology to speed up the bookkeeping, accounting and reporting processes; technology is required to help turn information into useful and relevant data;
technology facilitates the faster collection of information from and the delivery of information to clients;
technology is applied to reflecting numbers as pictures and helping users visualize the meaning of the data, and
technology enables the collection and analysis of “big data”, which leads to AI advancements and greater intelligence delivered through the applications businesses use.

The Sleeter Group report clearly demonstrated that small business owners continue to need and want more than just tax returns and post-facto reports from their accounting professionals, and that the lack of attention in these areas pose a direct threat to the small business/CPA relationship. Professionals can remove the threat by working closer with their small business clients, applying technology and process controls to get better information in a more timely manner, and returning the result with greater insight. Be proactive and be responsive, and apply the necessary technologies and business philosophy to get there before the client base looks for satisfaction elsewhere.

I’ve said before that small business owners don’t care about the numbers, they care about the picture the numbers paint, and they care about getting to a place where the picture is absolutely beautiful. With the right tools in place, their CPA can help guide them there.

jmbunnyfeet Make Sense?

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?

October 17, 2013

Accounting Professional Value is Insight and Advice, Not Just a Hosted Server

Back in the late 90’s, when the application service provider model was first established, a number of providers recognized how beneficial it would be for public accountants to use hosted applications to work more closely with their accounting and bookkeeping clients. Seeking markets which would rapidly adopt a hosted application model, these providers focused on hosting small business accounting solutions such as Intuit QuickBooks desktop products, and then sought participation by the largest addressable communities of users working with those products – QuickBooks ProAdvisors, bookkeepers and accountants. The idea was that the community of QuickBooks professionals would benefit by bringing their clients onto the hosting platform, and service providers could sell to one professional and gain a bunch of small business users. It made sense, too, as it allowed the professional to have a single service and login that allowed them to access all their client QuickBooks company files. The client could log in to the system, too, delivering remote access and managed service benefits to the client, as well. But there was a catch, and it didn’t fully reveal itself until recently as cloud-based applications and true SaaS applications began to gain market adoption.

The problem actually started to reveal itself as more businesses elected to adopt hosting services. There’s a saying amongst the QuickBooks hosting providers that “nobody uses just QuickBooks”. Saying “nobody” uses just QuickBooks is a bit of a stretch, but the reality is that numerous businesses use other applications and software solutions in addition to their QuickBooks product. Sometimes these products integrate with QuickBooks and sometimes they don’t, but it is not often that a business utilizes just the one software solution. At minimum, there are likely email or productivity tools in use, too. The point is that the QuickBooks hosting providers – those hosts focusing on providing service to QuickBooks accountants and small business clients – realized that the number and variety of applications desired by their customers would grow very quickly, as would the variety of needed implementation models. The unfortunate solution of the time was to just put it all on the same environment.

The original selling message to the QuickBooks consultant and accountant markets was that they should get all their clients on to the hosting service, and then the accountant could benefit from an “economy of scale”, making the cost of the overall delivery lower. Further, by grouping the firm and the clients into a single hosting environment, it would make application and data sharing easier. Both of these messages are true, but putting the firm and its clients into a single environment – with the firm as the “sponsor” and front line promoter of the service – began to have impacts which were not clearly foreseen.

Accounting professionals and consultants changed the nature of their relationship with the client, going from trusted advisors to technology and solution vendors.
Client business technology needs were placed as secondary to “enabling” the working relationship between the accountant and the small business client.
Attempts to fully satisfy client technology requirements overburdened and impacted the environment, reducing overall service quality and satisfaction and diminishing the value of the scale economy (as well as the clients’ perception of their accounting professional).
Firms structured their processes to support a single technology and operating model, and found difficulties in adopting new strategies or solutions.

In concept, having accounting professionals and their clients all working seamlessly together in the same systems sounds great. For some firms, a cloud server packed with all the firm and client applications and data enables an entirely new business and service model, which is very cool and it actually works (for some firms and their clients). But the problem – a problem which may not be fully revealed in the short term – is that the various businesses involved, from the accounting practice to each and every client, has different business needs and operates as a unique organization. While there may be fundamental similarities, “the devil is in the details” as they say, and a single platform or hosting solution is unlikely to really work well for all. Even more potentially damaging, the perception of the trusted advisor who is now viewed as a vendor of IT services or software erodes the value of the client engagement and the potential for the firm to deliver greater benefit through their core offerings. A business owner is more likely to change vendors of IT service than they are their trusted accounting or finance professional. And they’re also more likely to change IT service providers if the provider cannot deliver exactly the application or service desired. When the accounting professional is perceived to be the IT service provider, the lines are blurred and the client ends up attaching their loyalty to a software product or business solution instead of the accountant advisor OR the IT provider.

With SaaS and native web-based applications being broadly adopted by small businesses, the opportunity for firms to engage with clients in different ways and with different solutions started to break the one-size-fits-all hosting approach. Professionals found that empowering their clients by supporting properly fitted solutions which work for the client business delivered the opportunity to become more operationally and strategically involved with the client business. Deeper operational and strategic involvement with the client became the means to drive increased value in the engagement and services offered and delivered. The client business was able to benefit from the involvement of their trusted advisor, regardless of what platforms or systems might be in place.

Accountants and bookkeepers are recognizing that the previous model of aligning the practice with a particular software product or delivery system may not be the best approach to building and retaining the customer base. With new business accounting and bookkeeping solutions emerging regularly – and gaining broad market adoption – and as more and more varied cloud based services and solutions are applied to various business problems – professionals will further recognize that their value is not tied to a cloud server, a single small business accounting solution, or to any particular technology. The value of the accounting professional is not in the software they support or the server it runs on. The value of the accounting professional is in the insight gathered and advice provided – services offered which help support better business management, growth and profitability.

Make Sense?

Share this:

Share this:

Revenue Recognition and closing the reporting GAAP

Share this:

Share this:

Degrees of Success: Improving Productivity and Performance through Process Automation

Share this:

Accounting Professional Value is Insight and Advice, Not Just a Hosted Server

Share this: