data integration – Page 9 – Cooper Mann Consulting

March 10, 2015

EMV and Retail – Your Trusted Advisor Should Be Advising You about This

EMVChipCard There is ‘big change a comin’ for retailers, merchants and any business that accepts credit cards for payments, and there are a great many businesses that are completely unprepared for it. The change, what is being referred to as the “Payment Networks’ Liability Shift”, goes in to effect in October 2015 and places the burden of liability for fraud squarely on the shoulders of the merchants and card issuers who are not compliant with certain payment system security standards. Accounting professionals and Trusted Advisors – here’s one of those things you should be helping your clients with. Help them get informed, trained, and prepared. Help them to understand the risk and decide on a course of action. This is part of what makes a trusted advisor: they got your back.

The way things generally work in the US today, a fraudulent charge on a credit card is likely to end up being covered by the credit card company (the issuer). Starting in October, retailers are supposed to be able to accept payment cards with EMV chips (named for the founders of the standard: Europay, MasterCard and Visa), and must process those cards using the compliant technology that takes advantage of what the chip processing and security offers. If these conditions aren’t met – like having a POS or payment terminal not capable of reading the EMV chip – the merchant is on the hook for the fraudulent transaction. Given the volume of credit card and payments fraud in the country you’d think that most merchants would already be ready for this, but replacing all the POS and terminal equipment could be pretty costly. It may take a bit of analysis to understand the real risk and compare that to the cost of compliance. Certainly it makes sense to always be in compliance, but there are always factors which influence how quickly (or how completely) compliance may be met.

The liability shift is part of the influence being leveraged to get businesses to adopt newer and more secure models of electronic payment acceptance and processing. It is simply the case that the magnetic strip on a credit card isn’t good enough any longer. The new EMV Chip reading payment terminals require that the card be inserted and processed by the terminal rather than simply swiping the magstrip across a reader. Over 40 years of using the magstrip approach has helped to earn the United States a top spot on the leaderboard for credit card and financial fraud, and we seem to be lagging behind in adoption and implementation of the EMV technology even though it has been shown to seriously curtail fraud even as payment card usage increases. The EMV chip process, which encrypts information about the card so that even the local POS system doesn’t get access to it, is far more secure and is being widely adopted and used in Europe, Canada, Latin America and the Asia/Pacific regions. Now the clock is ticking for US businesses to get ready to either update their systems or accept the liability for not doing so.

The shift in how payment cards are made and processed is simply one of many changes which will continue to occur as technology and human ingenuity continue to be applied in both good and not-so-good ways. Recognizing that the pace of change is increasing, businesses must find ways to remain informed and prepare for those changes which will impact the business operation and sustainability. This is among the essential roles the trusted advisor plays, and the current imperative simply underscores the growing need for such advisors by business large and small.

jmbunnyfeet Make Sense?

February 24, 2015

Trusted Advisor is About the Work, Not the Title

Many accounting professionals believe they are THE trusted advisor the client comes to for advice and guidance on business financial matters. Having fully bought into the messaging about the value of the accounting and tax work, these professionals are feeling pretty relaxed about their client engagements. They believe the client will come to them with questions and provide the opportunity to deliver advice or work. And each year many clients return to get their taxes prepared or financial statements produced, and even new clients may appear. But the work remains largely the same – financial statements and tax returns, and addressing additional needs only when the client brings it up, which isn’t all that frequently.

happy_client On the other hand, there are professionals who recognize that a proactive approach to helping clients results in better and richer client engagements and better-performing client businesses. These professionals are truly the business advisors to the client – the trusted partners who understand the variety of conditions which impact business performance and care to make sure they are properly addressed. This advisor not only reports but makes recommendations and provides guidance on certain situations or processes which are essential in the business model. These professionals recognize that the bookkeeping and operational information collection is not simply a means to an end; these professionals understand that these foundational processes and the information they encompass are the important details which reflect the true performance of the business… details which no summary report can fully describe.

Having more direct participation in clients’ financial systems is a highly successful component of practice building, helping the firm to mine opportunities that may be hidden in current or new client engagements. This does not mean that the accounting professional becomes part of client operations or workflows. Rather, it suggests that the accounting professional understand these aspects of client operations and assist in the development of necessary controls and processes involving data collection or validation. It may include the implementation of KPI and benchmarking solutions to help identify problems and map improvements, or it may involve the installation of a solution to improve the importing of orders and other transactions into the system, improving the efficiency in processing the information while at the same time reducing the potential for manual data input errors.

Regardless of the depth of direct involvement in client systems, professionals can more fully benefit from every client engagement by providing some level of training, consulting or supporting service in addition to compliance and reporting work. Services may be aligned toward helping clients set up or support their own in-house bookkeeping and controllership responsibilities, or they may be more suited to providing real-time guidance and review of client business performance data. Either way, the quality of the financial information derived is generally far better and requires less work to adjust and report on.

The key is recognizing that the work involved – whether it is through training, regular process and data reviews, or more direct participation – is not intended to simply streamline reporting on outcomes. The work the trusted advisor performs is intended to help the client save money and improve business and financial performance, and the practice is rewarded with higher value billable services and a much increased opportunity to engage the clientele in other efforts.

jmbunnyfeet Make Sense?

January 22, 2015

State of the Union: The Irrelevance of Good Accounting?

finance I’m a little concerned, and any professional in accounting and finance who works with small businesses should be just a little concerned, too. Why? Because there is a belief out there that some nifty software and Internet Of Things (IoT) approach to finance will ultimately eliminate the need for a small business to work with skilled, trained accounting professionals. Remember the marketing slogan introduced by Intuit with QuickBooks – the one that suggested that, “if you can write a check, you can do your own books”? Most accountants will tell you that it is not true, and the ability to operate a product like QuickBooks does not magically turn poor accounting and bookkeeping information into good business data. In fact, it most frequently enables bad information to turn into bad business decisions – quickly.

DIY bookkeeping solutions have been around for a while, so why the distress about it now? Up until this point, it hadn’t been so overtly stated to small business owners that having less-than-great accounting data is very much OK, and that the role accounting professionals play in small business finances is more of a burden than benefit. Consider the statement made by President Obama in his recent State of the Union address:

“Let’s simplify the system and let a small business owner file based on her actual bank statement, instead of the number of accountants she can afford”

If I’m an accounting professional, I am pretty steamed up about that statement because I know how screwy business accounting data gets when the work is done by folks without the proper training. Incorrect or improper accounting treatment can make a big difference when it comes to filing those taxes mentioned…. and not in a good way. That transaction on the bank statement… Is it a cost of goods sold or a regular business expense? Is it an asset or supply item? Is it a reimbursement or revenue? Is the payroll deduction before or after taxes? Is that even a viable payroll deduction item? These questions and more arise frequently in a small business, and the treatment for these items is improper as often as not.

There is a big value in what a trained accounting professional can offer a small business owner, and the value often translates to eliminating unnecessary tax burdens and the delivery of accurate reporting – both of which are really important when it comes to actually trying to grow a healthy and sustainable business.

Small businesses are often considered to be the fuel powering our economy. Doesn’t it make sense for us all to recognize that smarter businesses are likely to be more successful, and that more successful small businesses means growth in the economy? The importance of good fiscal and financial management and reporting – in business and in government – is not something to minimize, and suggesting that it takes no intervention or skill to do the job properly reflects poorly not only on the person saying it, but on the entire establishment.

jmbunnyfeet Make Sense?

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.

November 4, 2014

Retaining Productivity while Empowering the Remote and Mobile Workforce

http://wp.me/p2hGOJ-J7

A lot of the marketing and discussion around why businesses should use the cloud for IT service is focusing on creating anytime, anywhere access to business data and improving overall IT performance. By deploying applications to remote desktops and hosted systems, business owners are recognizing the benefits of outsourcing IT service management to professionals who can spend their time actually managing IT. Focus is able to remain on the business operation and not the technology supporting it; the main office and remote locations are able to work with the same systems and information, and users are able to access information while at home or on the road. Bringing workers together with the same applications and data means new levels of productivity can be achieved regardless of where the work gets done.

Yet the perceived value of “working in the cloud” and the reality remain somewhat disconnected for many mobile business users. The confusion and frustration many users experience with connected, online working models has quite a lot to do with the realization that they don’t simply need remote access or virtual office solutions to bring them together. Users want solutions that help them get their work done even when they aren’t working on a traditional computer. When a computer is available, that’s great. But users want to be able to work from their tablets and smartphones, too. Have you ever tried to login to a remote desktop from your phone, or to see a full screen of data when the keyboard takes up more than half of the view? It may technically function, but there’s no way to get anything useful done with that little teeny weeny screen, and that’s a problem.

It is this new multi-mode working environment which is testing the boundaries of usability for software developers and service providers alike. No longer may the assumption be that users will perform their job functions using a desktop or laptop computer, just as it is no longer assumed that a mobile phone will be used just for phone calls. Users want (and sometimes need) to be able to get their work done using their smartphones, iPads, Kindles, or other types of tablet, pad or surface computers. Applications designed to run on full size screens and desktop computers often don’t work well for users accessing them with other types of devices, even when the device is connecting to a remote desktop service.

Mobile device users are starting to face these usability barriers somewhat less frequently when visiting various websites. If you look at many reasonably modern business websites, you’ll find there is a “mobile” counterpart. The mobile website is often somewhat less functional than the full website, providing only essential information for the mobile viewer rather than the expanded content and functionality available on the full site. Yet the mobile site delivers a more pleasant and usable resource for the mobile device user, encouraging the user to visit the site more often.

Application software development can be approached in a similar manner, where essential functionality is presented for mobile users in a format usable by mobile devices, and where the full functionality and rich feature set might be available only in the full application interface. Even where legacy applications are concerned – those firmly tied to the desktop and network – there are likely options for extending some manner of functionality and access to remote and mobile devices, perhaps by using 3rd party integrated or connected solutions.

Many commercial software developers are successfully viewing this “web and mobile enabled” approach as a means to capture Software-as-a-Service buyers by providing some web-based and mobile functionality with attachments back to the data and applications residing on the LAN or hosting platform. This hybrid approach may actually present better and more options for businesses, as it embraces the concepts of mobility and device independence while at the same time retaining the features, functionality and productivity-enhancing working mode that only desktop applications have to-date fully proven… and the businesses can keep their own data to take with them and not be relegated to list-only extractions if they wish to change solutions.

This idea is not really new – the idea of providing users with the specific functionality they need (and not more) to accomplish their tasks and get their jobs done. The concept of Service Oriented Architecture has always spoken to this philosophy, advocating that the right approach to software is the one which orients the application, functionality and view specifically and directly towards the user and their role.

The new twist on SOA is that the orientation of the application should be based not only on roles and functionality. Modern business applications must also address device and modality, not assuming a particular form factor or platform of access, and having an understanding of the particular mode in which the solution exists or is experienced by the user. Mobile users want a useful experience on their mobile devices, and remote and local desktop users want the features, functionality and performance of desktop applications.

Website designers have figured out that visitors may access the website using any variety of computing devices, including smartphones, tablets, laptops and desktops. Understanding that each device has a different capability in terms of displaying and interacting with content, site developers have begun to include mobile site designs as a standard offering with business website services. Users accessing the site with smartphones and tablets are able to effectively navigate and view information on the site because it’s been formatted to fit the screen, and navigation and other action options are accessible from smart menus that are sized and placed for touch screen access. This approach is now finding its way in many business applications now that the applications are also “living” on the web.

The growing number of web and SaaS products on the market clearly demonstrate that mobility is a big consideration in modern application design. Unfortunately, productivity losses due to sluggish interfaces or complicated operating processes often offset the benefits of the solution, even though it may be both desktop and mobile “friendly”. Software companies rolling out new SaaS models to their existing desktop product user bases are finding that the desirability of the subscription model web-based solution may be somewhat less than expected. This may be attributed to the fact that users have become not simply accustomed to how they can make the desktop software work for them – they’ve become reliant upon that ability. Initial experiences with transitioning from desktop applications to SaaS has left many businesses with frustrations founded in overall productivity loss. I’ve even heard the term “productivity-sucking”, which I don’t think describes either a feature or a benefit.

There must be a balance found, where productivity is enhanced for both desktop and mobile users and where critical functionality is not sacrificed in order to facilitate a mobile capability. The goal is to empower the remote and mobile user to be as productive as the non-mobile user, and to do it without forcing changes which may impede rather than improve productivity of the overall organization.

Make Sense?

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?

EMV and Retail – Your Trusted Advisor Should Be Advising You about This

Share this:

Trusted Advisor is About the Work, Not the Title

Share this:

State of the Union: The Irrelevance of Good Accounting?

Share this:

Share this:

Retaining Productivity while Empowering the Remote and Mobile Workforce

Share this:

Revenue Recognition and closing the reporting GAAP

Share this: