Category: outsourced accounting

Posted on

Predicting Outcomes and Providing Guidance | Being Nostradamus| Proformative.com

I have a gripe with the accounting profession.  My gripe is with the fact that accounting information delivered to most business owners is old news.  Stuff happened, the professional properly recorded it and reported on it,  you paid your taxes, and that’s that.  Game over.

Once upon a time, accountants had to work with book ledgers, pen and pencil (mostly pen, putting that single line through incorrect entries), and stacks upon stacks of paper documents.  Just keeping up with the process of recording transaction information, adding it all up (and making sure the footing totals jibe), and then summarizing the information into usable form took all the time available, and the focus was on the accuracy of the work – not necessarily the timeliness of it.  With the advent of computers and computerized accounting systems, the process of creating and storing the data became easier, but the volume and nature of information increased and thus the complexity and time to process increased (the “everlasting gobstopper” problem.. it never really goes away).There isn’t any argument over the critical value and importance of that work.  Every business owner understands that not properly accounting for business activities can mean increases in tax burdens, penalties and interest, and more.  It’s good work… but what do you do with it?  My intent is not to try to diminish the value of today’s approach to accounting.  Rather, I’m trying to point out how the accounting profession could make a huge impact in today’s pathetic economy, help businesses get financially healthier, and help put the small/medium business market on a path to growth and success.  It involves seeing into the future.

These days, technologies exist which facilitate acquiring the information (even in paper form), converting that information into digital data, and then actually interpreting the data to arrive at a transaction.  Traditional software and cloud service providers alike are recognizing that mechanical data entry is passé, and do-it-yourself solutions for accounting and bookkeeping will rely upon “smart” engines which can read and properly understand what each scanned document means.

So – once the accurate data entry problem is solved… what’s the next logical step?  Analytics!  It’s only really possible now that online solutions have brought the business information to the accounting professional in real-time, and have allowed the accounting professional and the business owner to collaborate and share data faster than ever before.  If information is power, we have a lot of power in our hands… but do we really know it?  This is where BI (business intelligence) and analytics come in, and where the opportunity exists for the accounting profession to become a guiding force in rebuilding our economy.

What if an accountant could not only tell his client that the business lost money last year or last month, but that they’re going to lose money through this month and year if they don’t change their behavior?  And, what if the accountant could run a variety of scenarios which would help forecast the most positive business outcome based on certain choices which could be made, or certain activities which could be handled in different ways?  What if the accountant could help his client peer into the future, and get an inkling of what the business could look like if certain economic or business conditions continued… changed… ?

Maybe I’m a little overzealous when it comes to believing that the accounting profession could have recognized the economic trauma which was coming, or that they could have prepared their business clients for it.  But I don’t believe I’m very far off the mark in believing that not nearly enough “analysis” occurs in the typical public accounting engagement, and even when it does… is the suggested path the right one?  I would submit that BI is new enough to so many people that it may not be.  Learning what the numbers are telling you is one thing… staving off disaster is quite another.

I would encourage all BI and Data Analytics fanatics to check out an article on CFO.com on this subject:  That New Big Data Magic  http://www3.cfo.com/article/2011/8/analytics_that-new-big-data-magic

A few memorable takeaways from the article:

“you may be spot-on about a problem, but the solution doesn’t magically appear out of the data.”

“what you do with [data] is a people-based activity, a skill base you have to mature.  And it doesn’t come quickly.”

“CFOs have a gut sense that there’s money out there in all that data… The challenge is how to turn that data into new opportunities.” The good news.. is that new technologies are making it more economical to make sense of Big Data… The caveat is that those technologies will not provide those opportunities. That’s still up to the people who make business decisions.”

jmbunnyfeetMake Sense?

J

reblogged from Proformative.com  Being Nostradamus – Predicting Outcomes and Providing Guidance

Posted on

The Language of Accounting: Disconnect between Accountants and Bookkeepers

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?

J

read more…

Opinion:   I think that every QuickBooks training program should include taking the sample data file in QuickBooks, and translating that to a manual accounting system of book ledgers and reports.  Then, have the student process a years’ worth of transactions manually and from paper-based source materials (and also make them create and use a manual paper filing system for all that information, and come up with a means to travel to obtain all the documents necessary which aren’t mailed via USPS).  The requirement would include generating the bank reconciliations from printed bank statements and cancelled check copies, creating a trial balance from the general ledger and then creating the P&L and Balance Sheet.  I’ll bet you end up with a group of bookkeepers who better understand the fundamentals of the accounting process.  The other benefit is that these folks will have a much better understanding of the problems in the outsourced accounting model which can be directly addressed and solved by today’s cloud and connected solutions.

 

Posted on

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.

jmbunnyfeetMake Sense?

J

 

read the original posting at  The Progressive Accountant.

Posted on

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

cloud-computingWhen 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 FeetMake Sense?

J

 

Posted on

Technology and Tools for Accounting Professionals

Joanie Mann Bunny FeetTechnology and Tools for Accounting Professionals

old_school_ledgerThere was a time not so long ago when accounting professionals focused more on tabulation and summarizing of information than on analysis.  Accounting for businesses, in particular, required collecting myriad papers and receipts and other transaction documents, summarizing the information, translating it into journal entries, and finally posting those numbers to the big bound book which represented the business general ledger.  With the work required to gather and enter all of the information, professionals necessarily focused their efforts on making the process as efficient as possible by attempting to structure the workflow and manage the paper.

When those efforts are compared to today’s approach which involves digital documents, intelligent data collection tools, automated workflow solutions, online accounting and data analysis, it is clear that the processes for accounting for business activities have not really become simpler.  In fact, much of the enabling technology has served to complicate certain processes, which drives users to find even more “solutions” to address these new problems.  It (IT) is a bit like the Wonka Everlasting Gobstopper, which never gets finished and never gets smaller.  IT simply changes things – regularly and often.

Back then – before the Internet and digital imaging, or even Personal Computers – high technology wasn’t the focus because it didn’t exist in the realm of business in general.  I suppose you could call business solutions at that time “low” technology, where mainly mechanical solutions were introduced to address various business problems.

old_school_filecabinet

As an example, prior to the advent of digital imaging and electronic documents, one of the primary requirements of the business was to organize and store paper documents.  Over time, a wide variety of filing, foldering and labeling solutions have been developed, all oriented towards making the storage and later retrieval of paper documents easier.  For some businesses, letting go of the paper is a hard thing to do.  Years and years of training in keeping paper files has left many business owners and managers wary of working without physical paper documents.  Investments in office space, filing cabinets, storage folders and personnel to organize, file and retrieve all of the documents is only a partial measurement of the cost of managing paper, and large numbers of businesses continue to operate in this manner.

old_school_desk

The technology applied to processing the work has also changed, in many ways even more dramatically than the technology applied to collecting and storing the information.  Take the simple processes of tabulation (to arrange in tabular form; condense and list) and summing (adding up) information, for example.  Previous generations didn’t have computers and spreadsheet software to perform the work.  Rather, individuals would painstakingly handwrite each transaction entry into a ledger or on a columnar worksheet, and would then have to manually add each column and then cross check footer totals to ensure accuracy.  Back then, the machines used to perform the addition/subtraction were mechanical devices and could not perform multiplication or division.   These adding machines were first hand-cranked devices, later replaced with shiny new electrical ones (weighing approximately 20 lbs each).

old_school_telephone

Even voice communications have changed dramatically over the years.  Many people don’t remember a time when having multiple phone lines in the business meant having multiple telephones, and the concept of a PBX (Private Branch eXchange) didn’t exist.  Every phone would be hard-wired to an incoming line; if you wanted to answer a call, you had to use the right phone.  This became difficult in an office with many people, so solutions such as the “fabulous extendo-phone” was invented to allow anyone in the office to access the phone from their desk.

The technology available to businesses today is astounding, and offers amazing potential and benefit.  On the other hand, technology rarely (truly) makes things simple or easy – it more frequently serves to shelter certain users from the complexity while delivering new workloads and concerns to others.  It’s rather like energy – it isn’t created or destroyed, it just changes form [law of conservation of energy].  Business is like that, particularly where information technology is involved.  The underlying requirement doesn’t go away, just like a business’s requirement to account for financial transactions and activities,  and the need for the business to capture and retain documents isn’t changed.  How the process is managed, and which tools or mechanisms are applied to the task is what changes.

Make Sense?

J

onewrite-accountant_apparatusOne-Write System Revolutionizes Accounting.  These guys had the right idea, they just didn’t have the cloud.

Posted on

Cloud Computing and Online Accounting for All? Some Markets Are Still Waiting for Broadband

Cloud Computing and Online Accounting for All? Some Markets Are Still Waiting on Broadband

As the information technology industry espouses the benefits of the “paradigm shift” in computing and the move to cloud computing platforms and models, there are folks out there in the world who just aren’t seeing it happen like that.  Not everybody’s working online. For many, the Internet and online working models simply haven’t intruded into their lives and businesses as it has for others.  While this may be partially rooted in conservative mentalities and beliefs which are resistant to change, the more likely reality is that options for high-quality and affordable broadband service is simply not available to them.  Without choices for affordable and useful connectivity to the Internet, online just doesn’t have the attraction it does for those who are “connected”.

When businesses look at cloud solutions and the Internet dependency that comes along with them, having more than one connection to the outside world becomes the imperative rather than a luxury.  Unfortunately, some markets are still waiting for broadband (or have very limited options for service), rendering the cloud nearly unreachable.

It may come as a surprise to some, particularly to those in East and West coastal regions, that high speed broadband just isn’t as available in other zones.  In fact, the *National Broadband Map clearly reveals limited availability and choice in numerous regions of the US.  Broadband Internet access is a necessity to support the IT industry’s shift from localized IT to “cloud” IT.  But the shift is only evident to those who are involved in it or who have that option.  For those who the industry is beginning to refer to as the technology “have-nots”, this lack of available and affordable access will ultimately create more than simply an inability to participate in broadband-reliant IT solutions.  The fast pace of innovation and evolution in IT almost guarantees that the technology have-nots will fall even further behind, possibly to the point of not being able to catch up.

 “A Growing Gap Between IT Haves, Have-Nots. There will be a growing gap between the IT haves and have-nots in 2013. The latter will fall behind the former on a wide range of business technology fronts such as mobile, cloud, social, virtualization, and analytics…” 7 SMB Technology Predictions for 2013 | InformationWeek.com

As business (and personal) technology models continue to evolve, and as new solutions and services begin to displace the old, those who remain disconnected will begin to directly experience much more impact.

Consider something as simple as using QuickBooks desktop software for small business bookkeeping.  As Intuit continues to remove elements from the installed software product, turning them into web services instead, customers with limited or no broadband access will find themselves without the features and functionality they need in the software.  And the only possibly comparable alternatives to QuickBooks desktop accounting products are Internet-based alternatives, making them not really alternative options at all.

It is also likely that lack of sufficient broadband is one of the factors motivating many solution providers to seek clients in other markets – outside of the United States, and in regions where broadband availability is more prevalent and service speed and quality is higher.  Yes, it’s true.  The United States is not the leader in broadband availability, or even in quality.

“For many people, their broadband connections are their lifelines. So what is the state of broadband in the U.S.? Well, when it comes to speed and price and adoption, we’re certainly not a leader — “middling” is a better way to describe our position.

Currently 119 million people that live in the U.S. don’t have broadband connections (for many reasons, including not wanting it or not being able to afford it) while 19 million don’t even have the option to get it. Our rate of broadband adoption (62 percent) lags behind countries such as South Korea, the U.K.,and Germany, according this year’s Federal Communication Commission report. (We’re closer to the penetration rates to Japan, Finland, and Canada.) These numbers are not likely to change soon, given that broadband growth is slowing and providers are moving away from wireline infrastructure. “ GIGAOM:The state of broadband in the U.S. [infographic]

Accountants and other professional service providers serving clients in regions lacking sufficient choices for access must recognize that their approaches to doing business will not necessarily match their peers in more fully connected areas.  Certainly, accounting and legal professionals are dealing with this reality as practice coaches and industry leaders push for IT- and cloud-enabled models for improving practice performance and creating differentiation, even as their proven applications and business solutions morph into or are replaced with SaaS applications and online service.

The take away from this is that there are still large numbers of businesses and individuals doing things with legacy tools, managing spreadsheets on standalone PCs, or writing with pens and using paper – even in areas where broadband access is plentiful.  Regardless of how forward moving the rest of the world may be there remains a need to provide service and support these IT have-nots.  Perhaps this becomes a means for differentiation, finding ways to work with businesses who are connected and those who are not, and leveraging the firm’s access and capability to deliver what the client cannot obtain directly.

Make Sense?

J

*The National Broadband Map is a tool to search, analyze and map broadband availability across the United States