Cooper Mann Consulting

August 12, 2013August 14, 2013

The Language of Accounting: Disconnect between Accountants and Bookkeepers

There are a tremendous number of bookkeeper training programs developed over the years which propose to deliver the essential bookkeeping knowledge (e.g., double entry accounting) required in order to properly service business bookkeeping requirements. Particularly as the CPA profession stepped away from traditional bookkeeping in favor of performing “higher level” and more profitable work, there was and continues to be a great need for skilled and experienced bookkeepers. While it seems that accountants and bookkeepers would be a natural fit for partnering to serve small business client needs, there is often a disconnect between the two which causes the working relationship to not always prove as beneficial as it could. What is the cause of this disconnect? In many cases, it is due to the fact that the bookkeeper training educated the operator on the use of a software product, and not on the fundamentals of accounting and bookkeeping.

Over the past few years, I have had the opportunity to look through a lot of bookkeeper training programs, and the thing that stands out is that many of these programs aren’t really training bookkeepers on accounting principles. More frequently, the training is focused on teaching users how to use software (usually QuickBooks). With the number of users of the QuickBooks product, it is obvious that there is a need to educate users on the solution because people need to know how to use their software properly. But it happened at some point in time that a majority of the industry came to believe that learning QuickBooks (or Xero or Freshbooks or Kashoo or whatever) was somehow synonymous with learning bookkeeping.

When I first started working with my father in his accounting practice, I had to use a manual general ledger, check register, etc. It was all manual – computers didn’t come along for a while (yes, I am that old). It was time-consuming, but it taught me the fundamentals. I know what a subledger is. In consumer-friendly software like QuickBooks, you don’t work in the AR subledger; you push the button that says “customers” or maybe “invoices”. QuickBooks, in many ways, doesn’t speak accounting. It speaks record keeping. And this is where the disconnect begins.

An old school accountant will recall the green eye shade days and working with book ledgers and 13-column pads, but even “new” school accounting professionals know that the fundamentals of accounting aren’t available for re-invention. A debit is still a debit and a credit is a credit. Yes, there are intimacies involved which speak to specific treatment of items for reporting and tax purposes, etc., but the essentials of double entry and other basic accounting principles are consistent and unchanging.

The “language of accounting” includes certain precise terms with specific meaning, and this precision in the use of terms simply doesn’t exist in many bookkeeper training programs. Rather than focusing on the fundamental accounting training bookkeepers truly need in order to be of maximum value to the business, these programs focus on helping users become experts in using the software product, or even to become experts at teaching others how to use the solution. While this software expertise may be beneficial in terms of helping accountants work with their clients who use the software, it doesn’t add enough value to the relationship to warrant partnering. What accounting professionals need are bookkeepers who understand bookkeeping and who can apply basic accounting principles to the task. Which software they operate is secondary to that purpose.

Professional bookkeepers, accountants, and the business client are all in a position to benefit tremendously when the service providers team up to provide comprehensive service. The key to making these connections lies with the professional bookkeeper who must not only understand basic accounting principles, but must also be able to speak to the accounting professional in their native language.

Make Sense?

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.

August 6, 2013April 25, 2019

The Most Popular Models for Working with QuickBooks Desktop Editions and the Cloud

cloud-computing When Intuit created the Authorized Commercial Host for QuickBooks program, a variety of providers were enabled to offer not only managed application hosting services for QuickBooks desktop products, they were also permitted to provide QuickBooks desktop product licenses for rent. By allowing these hosting providers to also license the QuickBooks products on a subscription basis, the entire solution – the hosting of the QuickBooks, the management of the company data files, and the licensing of the software – was able to be packaged together and offered as an equivalent of the SaaS solution. The benefits of running tried-and-true business applications on the business network had already been proven, and creating the ability to access this resource at any time and from anywhere (mobility!) became the feature which encouraged a wide variety of large and small business to move to “cloud” and online working models.

While the complete hosted application model – where the business desktop applications and associated data are installed and managed on the service provider servers – addresses a broad requirement for many companies, there remains a large community of users who have needs which do not extend to “cloud server” or remotely hosted desktops and complete managed application services. For these users, having access to the data file from anywhere is the primary goal (maybe even multi-user access for just a couple of users), and management of the software and license across multiple computers is not their first consideration.

Here are the most popular models for working with QuickBooks desktop editions in/with the cloud. Each of these approaches solves a different business problem, so it is important to understand which problems need to be solved before shopping for the solution.

1. Storing the QuickBooks file in a file sync solution

Solves: gives access to the data file from various locations (not at the same time)

Doesn’t solve: no multi-user access in real time, still have to purchase QuickBooks licenses, install and manage applications, and secure and backup data

The popularity of Dropbox and similar file sync solutions clearly demonstrates the value of giving users the ability to store, sync and share files securely via the Web. Further, these services allow people at different locations to access files in a relatively collaborative manner, giving otherwise disconnected users the ability to sort of work like they’re on the same network and using the files in near-realtime. While this approach works awesomely well for Word documents, PDFs and other files, it doesn’t work as well for QuickBooks company data files. It’s pretty much an automated approach to using a file storage solution (like any web drive, file share service or such). To clarify, users can store copies of QuickBooks company files in a Dropbox or sync folder to have that file sync’d to the host and to other permitted computers, but a “live” QuickBooks data file doesn’t like living in this type of folder. The sync or file sharing method of applying a cloud solution to QuickBooks allows for only one person to be in the “real” file at a time, and each user still has to purchase, install and manage the QuickBooks software on their PC. Oh, and bandwidth will become an issue when files must be sync’d frequently and when the files are fairly large (which QB files tend to be).

2. Using secure remote access to QuickBooks, remote desktop or remote app solution (like hosting, but the host just happens to be an on-premises computer already in place)

Solves: gives access to the file and applications from various locations, allows for multi-user access to company file, allows access to just QuickBooks or any combination of applications on the host computer; low-cost solution providing mobility and device independence just like commercial hosting but at a fraction of the cost

Doesn’t solve: have to purchase QuickBooks licenses, install and manage applications on the host, and backup data

Secure remote access solutions like MyQuickCloud allow users to connect to applications that are installed on existing workstations or servers. This approach provides users with access to QuickBooks and other software installed on the in-house computer. The problem with this model is that the bandwidth and the in-house computer need to be sufficient to support remote users, and the activities of the user sitting at the in-house computer will take priority over the remote user requests.

3. Using a hosting provider and/or platforms for QuickBooks, remote desktop or remote app type of solution

Solves: gives access to the file and applications from various locations, allows for multi-user access to company file, may allow for rental licensing of QuickBooks software, files are backed up by service provider

Doesn’t solve: commercial hosting is not a very low-cost solution for those who only need file sharing

Application hosting models allow users to connect to servers where the applications are installed and managed by the service provider and delivered to customers as subscription service. This approach provides customers with flexible options for accessing QuickBooks software installed and maintained on the host’s servers, and to have the multi-user capabilities of the product just as it would function on a local network. Application hosting models are generally offered as standardized service or as custom service, with variable pricing and features associated with each.

Because these hosting models require that all components of the delivery be combined to deliver the service – from networks to servers to desktop virtualization to application virtualization, application licensing, data management… it’s a big list of things – the cost of service may seem a bit high for a single user or very small business to bear. This is among the reasons for continued popularity of do-it-yourself remote access solutions that deliver mobility but fail to address any sort of system management benefit.

When business users ask about using their QuickBooks desktop editions in the cloud, it makes sense to drill down into the details of what they’re really looking for. In many cases, the QB user simply doesn’t know how to ask for what they want, using popular terms without real understanding of what they mean. This is something which frequently happens when a prospective customer contacts a QuickBooks hosting provider, and the sales department of the hosting provider isn’t generally in a position to offer consultation – they are there to sell their solution to the prospect. The result is that the customer doesn’t really get what they want, and the provider gets a bad review.

The problem isn’t necessarily with the provider or service (I wish more sales teams were able to offer more consultative approaches, but that’s an entirely different conversation); the problem occurs largely due to the variety of services being offered around “cloud QuickBooks” and the ambiguity which exists in much of the marketing language around them. Maybe this information will help businesses as they look to find solutions to the variety of problems with “enabling” their desktop QuickBooks to work with the cloud.

Joanie Mann Bunny Feet Make Sense?

August 5, 2013

How low-paid workers at ‘click farms’ create appearance of online popularity | Technology | The Guardian

How much do you like courgettes? According to one Facebook page devoted to them, hundreds of people find them delightful enough to click the “like” button – even with dozens of other pages about courgettes to choose from.

There’s just one problem: the liking was fake, done by a team of low-paid workers in Dhaka, Bangladesh, whose boss demanded just $15 per thousand “likes” at his “click farm”. Workers punching the keys might be on a three-shift system, and be paid as little as $120 a year.

The ease with which a humble vegetable could win approval calls into question the basis on which many modern companies measure success online – through Facebook likes, YouTube video views and Twitter followers.

How low-paid workers at ‘click farms’ create appearance of online popularity | Technology | The Guardian

I’ve seen a lot of this type of activity on blog articles, as well… folks hoping that the additional traffic improves their search rankings. The thing is, when we see these comments, are we more likely to actually read the article?

August 1, 2013

IT Security and Engaging Users to Reduce Vulnerability

There is a lot of discussion going on about security in the cloud. With numerous advancements in technologies of various sorts intended to secure our information and identities on the Web, how is it that security continues to be a growing problem? The answer is in the Big Data the Web collects (read about the Internet of Things – IoT), the large silos of data now handily available in the cloud, and users who continue to provide access for all sorts of bad guys and malicious attackers simply due to not understanding that they – the users – remain as the biggest vulnerability of all. It is educating this user and finding a way to get them to recognize their potential as a critical element in enhancing system security and reducing vulnerability that has become the larger challenge.

People are nothing more than another operating system, says Lance Spitzner, training director for the Securing The Human Program at SANS Institute. “Computers store, process and transfer information, and people store, process and transfer information,” How Hackers Fool Your Employees

Social engineering and finding ways to earn user trust has become a widely recognized means for gaining access to systems and information. Any experienced computer security consultant recognizes that Microsoft Outlook is among the best applications to place in front of users to test system security, as emails with malicious attachments (spearphishing) represent a majority of targeted attacks. And hackers aren’t resting on their laurels while users figure out that opening email from unfamiliar sources isn’t a good idea. Nope, not for a minute. Today’s flavor is “conversational” phishing, where it is made to appear as though a real person is at the other end of the conversation. Hackers are patient, and they are willing to take the time to find a way in. Users, on the other hand, still tend to be somewhat complacent when it comes to security, and often operate under the belief that the IT security products and the IT department have it all under control. And no matter how many times they’re told to not click on strange email attachments, to change passwords frequently, not to reuse passwords, and to make passwords hard to guess… getting users to comply continues to challenge system administrators.

Communicating with users about the importance of adhering to password management and other security standards often falls on deaf ears for two reasons: users believe that system security is the job of the IT department, and users are made to feel stupid by being chastised and punished by the IT department that’s supposed to be helping them. Rather than helping to educate users and find innovative ways to get users to participate in helping to improve system security, IT administrators and security teams generally view users as part of the problem rather than part of the system of solving it.

It’s a heated debate that can upset people on opposing sides. For instance, one RSA conference presenter conducted a class on “how to patch stupidity,” Spitzner says. “He explained why people are stupid, how they’re stupid and how to fix stupid. It was a very emotional talk for me, because how can you sit there and insult the very people who can end up helping us?… How Hackers Fool Your Employees

In order to build strong security which is better-suited to protect businesses from today’s variety of threats, IT security professionals and system administrators should engage in positive internal marketing for better system security, deliver improved education to build awareness with users, and actually engage users in the process of threat identification and detection. These users don’t have to be geeks or IT people; they can be average users who simply keep their eyes open to things that just don’t seem right. “People can become a detection system to improve organizational resilience.”

jmbunnyfeet Make Sense?

July 31, 2013March 28, 2014

The Small Business Borrower | Biz2Credit

In order for regulation and legislation to work in favor of small businesses, it becomes essential that accurate and complete information be available for analysis. Too often there are details not recognized in the information used by various agencies to help guide policy and action, and particularly in the world of privately held small business, the quality of data is often in question. This is where structured accounting software and the public accountant come in to play, and where a difference can be made not only with the individual client, but at a higher level by facilitating more accurate data production to support various research initiatives, such as those sponsored through the SBA and the Fed.

Overall, these research studies highlight two things: the important role that financial institutions play in lending to small business owners, and the value of quality data sets in ascertaining financing issues faced by small businesses and their owners.

Charles Ou, Ph.D. | Senior Economist | Office of Advocacy | July 2009

With the availability of highly useful tools for monitoring various key performance indicators and metrics in the business (with analysis of cash flow being an essential part), business owners and their accounting professionals alike are able to use real business data to reveal not simply the trends in business performance, but to identify areas where direct action could improve results in one aspect or another. By paying closer attention to managing business finances and analyzing key aspects of business performance, the “discouraged” or “denied” business borrower may become a successful or (even more valuable) a non-borrower.

via The Small Business Borrower at Biz2Credit.com.