Tag: quickbooks

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

Virtual CFO Services and Partnering with Bookkeepers

Virtual CFO Services and Partnering with Bookkeepers

Many accounting professionals seek to become more involved with their business clients, helping to institute the controls and establish the processes which support sustainability and higher levels of business performance and value.  Acting as the Virtual CFO to the business, these professionals use historical financial information and detailed operational data to guide their clients towards stated goals.

While this move to engage clients are deeper operational levels is a worthy effort, there is often a disconnection in the supply chain for these services.  In too many cases, there is discord or a lack of understanding and trust between the CPA and the bookkeeper supporting the daily processing of the business information.

The business bookkeeper is the person “in the trenches”, getting daily information organized and processed, reconciling accounts, and generally tasked with recording transactions resulting from business activities.  Because the bookkeeper operates very closely with the business, they are perhaps in the best position to provide insight into how operational tasks and various business functions are performed and “accounted” for.  While the bookkeeper may not have the skill or experience to design change in these systems, they are a particularly powerful source of current process information and, in some cases, represent the barrier to change.

Years ago, as CPAs removed themselves from daily bookkeeping services to focus on “higher level” work, the opportunity was created for outsourced bookkeeping services to fill the gap in providing daily book and record keeping tasks for small businesses.  Small business owners in particular need help with the management of their bookkeeping and accounting, and without the availability (or affordability) of getting this service from the accounting professional, businesses turned to the bookkeepers who stepped in to fill the gap.  Yet every year, businesses turn over their bookkeeping and documentation to CPAs who simply re-create the bookkeeping in the form of “write-up”, trusting only their own work when it comes to tax and financial statement preparation.

It would seem that there would be a naturally occurring desire of CPAs to partner with professional bookkeepers in order to provide a full service capability to business clients and eliminate the need to reinvent and write-up the information, but this is often not the case and may be partly due to the reality that CPAs are trained on accounting principles while many bookkeepers are really only trained on the use of a software product.  Too often, bookkeepers gain their education primarily based on using QuickBooks software, and “speak” the language of QuickBooks rather than “accounting” resulting with a minimized view of the bookkeeper value by the CPA.

The CPA is thinking in terms of AR and AP subledgers, while QuickBooks bookkeepers think in terms of customers, invoices, and bills to pay.  While the language of QuickBooks has been designed to be meaningful to the non-accountant user, it is this very language and presentation which has made QuickBooks both a popular small business accounting solution as well as a foundational solution for an outsourced bookkeeping offering.

Working more closely with the bookkeepers, CPAs could help their clients not only achieve a more accurate and timely accounting of activities, they could also influence areas where necessary controls should be implemented, or where inefficient processes might be improved.  Providing not just information but also direction and actionable ability, these accounting professionals are now positioned more directly to provide the CFO services businesses need.

CPAs must find a way to get past their prejudices in working with business bookkeepers, and recognize that these operators “in the trenches” could be their most useful resource – and their most powerful ally – in the supply of Virtual CFO services to the client.

Make Sense?

J

read more…

 

Posted on

Remote Access to QuickBooks – a free report from the author of Radically Simple Accounting

Remote Access to QuickBooks – a free report from the author of Radically Simple Accounting

Radically Simple Accounting

Madeline Bailey, author of the book Radically Simple Accounting, is offering a free report on Remote Access Options for QuickBooks.

The free report provides details and simple explanations to help every QuickBooks user or consultant understand how best to leverage the Internet to work when, where, and how they need to.

Cloud computing and the Internet have introduced both challenges and opportunity for QuickBooks users and those who support them.  Madeline’s report provides real-world information, links to live services, pricing, and personal evaluations that anyone looking at remote access options will find useful.

Everyone’s talking about remote access and QuickBooks, but the options are so plentiful and confusing that only a few have made the move.  For those still wondering what solutions will work best for them, this report may clear things up a bit.

Joanie Mann Bunny Feet

Make Sense?

J

Posted on

Accounting Professionals: Is Your Value Tied Up in The Accounting Software?

Accounting Professionals: Is Your Value Tied Up in The Accounting Software?

Subtitle: when all you have is a hammer…

There was a time, not so many years ago, when it made sense for an accounting firm to take the position that all clients must use the firm’s preferred accounting software product or they would not be clients.  For these firms, the concept of standardizing transaction entry and data processing across the client base made sense, and provided a means to create maximum efficiency in handling the bookkeeping and accounting processes.  Typically, firms handling small business clients would select Intuit QuickBooks for client use, and offered QuickBooks training, QuickBooks transaction processing, and use of QuickBooks add-ons to support the model.  With Intuit QuickBooks “owning” the small business market for accounting software, it made sense for accounting professionals to leverage the popularity of the solution to the benefit of the practice.

As cloud-based solutions and online application services have emerged (including QuickBooks Online Edition and Intuit Partner Platform – IPP – integrations), many accounting professionals have simply continued with the philosophy of applying QuickBooks (the hammer) to every client engagement.  These firms focus on the software as a basis for delivering what they believe is value in the engagement.  In short, these professionals focus their value in the use of the product (licensing, installation, training and support), and in their data entry skills (efficiency in entering and reviewing transactions in the product), rather than in the greater value of business intelligence, insight and actionable advice.

The new challenge facing many professionals – the reality of the current market – is that there are myriad solutions and approaches available to address client bookkeeping and process needs which work really well, and it is not always a good idea to try to turn a client using one of them into a “nail” just so you can hit it with your favorite hammer – QuickBooks.   With Freshbooks, Wave Accounting, Xero and other solutions which handle various business accounting or bookkeeping requirements quite well and for an attractive price, small business owners are more frequently electing to implement applications outside of the QuickBooks product line even as their accounting professionals are continuing to promote QuickBooks for everyone.  The reason business owners are electing to use these other tools is simple: they work for them.

In reality, this issue has existed in some form for a very long time, and was perceived to be primarily in markets where technology adoption and use is low for various reasons.  The truth is that a lot of small business owners find ways to accommodate their information management and record keeping needs, and they use whatever approach works for them and what they want to accomplish.  Sometimes the approach involves Internet solutions and online applications, and sometimes it does not (Excel spreadsheets with stapled piles of receipts are still quite popular and in widespread use by SMBs and Entrepreneurs).  When that small business elects to engage the help of an accounting professional, the last thing they want to be told is that they have to make a big change to how they get things done.  It’s fine for the accountant to provide guidelines for when information will be made available to support getting the accounting work processed, but it is not necessarily okay to dictate immediate changes in software and systems supporting the business daily operations.  In a lot of cases, the accounting professional simply has no real basis for the requirement to change, other than to support their own efficiency (which is the wrong basis for making a client change their systems).   It’s that silly cost-benefit thing. If it costs the client a lot (change always = cost), and the client does not perceive or experience an expected benefit, then it makes no sense for them to make the change.

Consider a professional accounting firm in Los Angeles, California.  This firm serves small businesses, and has a pretty significant market available to sell to.  LA is a market where technology adoption is high and broadband Internet is cheap and reliable, so this firm has elected to use a product-based focus (e.g., the QuickBooks approach) in qualifying clients and crafting engagements.  Clients must conform to the solution set and the workflow in order to participate with the firm.

Now, consider a professional accounting firm in Elkton, Oregon.  This firm serves just about every business in town (population 195) as well as businesses from a few nearby towns.  Broadband Internet service is sketchy at times, and provider options are few.  This rural area of Oregon is not known for being particularly “high tech”, and computers and software and online application services are not among the things many of these business owners focus on or even care about.  The accounting firm serving this market is not focused on what accounting solution the client uses (or not), and they aren’t pushing to have all their clients purchase and install the same accounting software so that the firm’s processes can be more efficient.  Interestingly enough, this firm is likely doing better work and probably developed a closer and more intimate relationship with their client than those who have fully “standardized” the client base.  The reason is that the firm, whether out of necessity or out of desire, recognizes that each of their clients may have unique needs, and it is up to the firm alone to create maximum efficiency in meeting them.  Further, delivering personal service and useful insight instead of simply providing the work product has allowed the professional to more fully reveal their value to the client.

The truth of the small business accounting market is that there are more businesses like those in Elkton than in LA. Accounting professionals should consider whether they are in a position to “filter” their client opportunities based on use of certain software products and online solutions, or if they will accept that business clients come in all sizes and shapes – with various needs and wants and self-developed methods of getting things done – and that the firm is willing to embrace them as they are and work with them.

Make Sense?

J

Posted on

Simultaneous Syncing Sinks Solution: Extend Access but Control Integrations

Simultaneous Syncing Sinks Solution: Extend Access but Control Integrations

Accounts and ProAdvisors: Make sure you “enable” only those who need it

In this wonderfully interconnected world of hosted and online applications and the integrations which complement them, it is important to not let the excitement of connectivity and collaboration replace reasonable control.  While there is much conversation on this topic when it involves file sharing and similar services, the discussion of data synchronization and data integration doesn’t often come up.  However, it has been my experience that there is usually a misunderstanding in how, exactly, a particular sync or integration should be applied and who should have access to the functionality when it is deployed as an extension of the QuickBooks desktop financial software.

An example of the problem might be seen when QuickBooks desktop editions are set to integrate or sync data with a web-based solution such as Method Integration or Santrio Open for Business Order Bridge.  Solutions like these, which extend the functionality of QuickBooks through extending access and integrating data, rely upon QuickBooks integration functionality move data between their solutions and the QuickBooks database.  These solutions are quite beneficial for businesses because they can affordably deliver support for various business functions via a true web application and incorporate QuickBooks data in those application views.  Additionally, this type of solution is able to push information from the web application to QuickBooks, allowing for complete integration of financial and other relevant data.

While having this type of integrated service is beneficial, there are a lot of businesses who don’t fully understand how to appropriately implement the solution and end up creating a great deal of difficulty for themselves.  One of the most frequent failures I have seen when implementing this type of solution is where the customer doesn’t really understand who should or should not have the integration.

When a web-based solution exchanges data or syncs with QuickBooks, a path is created to communicate between the two systems – the web solution and the QuickBooks application and data file.  This path must be open, and both sides of the communication identified, in order for data to sync.  The most important thing to remember is that there should be only one controlling entity on each side handling the integration.   What this means for QuickBooks users is that only one installation – one PC accessing QuickBooks – should be configured to facilitate the primary integration with the QuickBooks company file.

To illustrate, consider an implementation of Method Integration and QuickBooks that was done for a business some time ago.  This business used Method-based applications for a variety of business functions, and those applications used data sync’d from QuickBooks desktop.  Just after implementation, it was discovered that system sync’s were not happening as they should, and sometimes when they went to sync data, it would take a huge amount of time (which was not supposed to be normal behavior).  In short, the system proved to be problematic and, at times, unusable.  But the problem didn’t have anything to do with the Method Integration system, nor the technology.

The problem was that all workstations in the office were set up to sync data between QuickBooks and Method.  QuickBooks was installed on all the PC’s, even though most of the users did not use QuickBooks (they used the Method Integration system to do their jobs), and each PC had the Method Integration sync engine installed and set up to run.  This caused the system to be frequently overloaded with sync requests and caused QuickBooks to behave erratically or crash.  In addition, users who did not need (and should not have had) access to QuickBooks financial information were starting up QuickBooks and opening the company file every day because they thought it was required to allow them to access or use QuickBooks data in the Method Integration system.

The benefits of using web applications which can connect to and integrate data with QuickBooks is that a business can give users functionality and data access required to get the job done, but not expose those users to more software or data than they need.  In most cases, if not all, QuickBooks is not necessary for users of the web application (saving you the cost of purchasing and installing QuickBooks for these users).  Further, to ensure proper functionality and to remove any possible conflict or confusion in the sync process, only one workstation with QuickBooks should be set up to sync data to/from the web solution.  While it makes sense to have a “backup” PC setup with the ability, syncing should remain inactive on this machine unless the primary “sync machine” is out of service.  The key element to remember here is that the data coming from the web application is being added to the QuickBooks company file.  Once the data is in QuickBooks, QuickBooks users may access the data from QuickBooks and do not need the connection to the web application.

When deploying this combination of solutions with a hosting service provider, the same rules will apply.  Only users who need the sync capability require service with both QuickBooks and the integration installed.  In some cases, this may make selection of host services more affordable, as only those who need the “additional application” (being the sync solution or integration tool) require customized service, and the rest of the QuickBooks-only users need standard QuickBooks service.  *It might also be worth noting that many hosting providers do not support “persistent” connections – sync connections which continue to run even when you are not logged in), so syncing of data would only be able to occur if the primary user was logged in to QuickBooks and had the sync integration active on the host solution.

Accounting professionals, QuickBooks ProAdvisors, and small business consultants can help their clients understand the value and potential of extending QuickBooks desktop editions with connected web-based solutions.  The additional value these professionals bring to the conversation is the understanding of the need for structure and control of the data flowing into and out of the financial systems, offering their expertise to ensure that the accountability and appropriate treatment of the information exists throughout the business.

Make Sense?

J

Read more …

There’s a lot of legacy ERP out there, and it’s not going anywhere any time soon

https://coopermann.wordpress.com/2012/05/29/theres-a-lot-of-legacy-erp-out-there-and-its-not-going-anywhere-any-time-soon/

Compliance in the Cloud – their system, your responsibility

https://coopermann.wordpress.com/2012/05/23/compliance-in-the-cloud-their-system-your-responsibility/

Beyond Bookkeeping to Total Business

https://coopermann.wordpress.com/2012/05/25/beyond-bookkeeping-to-total-business/

Posted on

Accountants and Small Manufacturers

rollingballGetting in Front of the Ball

There’s a lot more to accountability in a manufacturing or inventory-based business than simply keeping track of money in and money out.  Particularly in an economy when nobody can afford to build or stock products too far ahead of demand, it is essential that these businesses have a means to not only track and manage purchasing, manufacturing, distribution and stocking activities, but to understand conditions or trends which impact the flow of materials and cash through the business.  Further, this understanding must come in a timely manner in order for the business owner to make decisions and take action when it matters most.  Unfortunately, many business owners find themselves “behind the ball”, constantly pushing to make forward strides, and often due to not having the information they need to make business decisions that matter now, today.

Why is it so critical for these businesses to have more and better information to help them make strategic decisions and answer daily operational questions?  In a word: connectedness.  The Internet has truly made the world smaller when it comes to participation with even the smallest of local businesses.  Globalization of markets has impacted manufacturers in significant ways, and these businesses (like so many others) must now be prepared to address the realities of global supply chains, outsourcing, and a remote or mobile workforce and market.  While many of the software solutions addressing the functional business requirements of manufacturing and inventory or warehouse management are “locally implemented” solutions, extending and integrating these solutions to address the new global and mobile paradigm may represent a significant expenditure in time and resources for the small enterprise.

Application hosting and web-based solutions have emerged to help businesses address the need to “modernize” legacy applications and enable greater levels of system management and access.  Introducing the applications into a centralized and remotely accessible environment allows the business to immediately deliver the necessary support for remote work and mobile access, and positions the system to facilitate collaboration within the business and with outside participants, such as outsourced bookkeepers, accounting and finance professionals.

These professionals can be instrumental in assisting their clients manage the change to new collaborative computing paradigms.  Where accounting was previously viewed as an after-the-fact process, accountability through detailed activity tracking and reporting is now a focus which begins at the front end of the business, and accounting professionals are finding far greater value in helping structure and manage this daily activity in order to deliver greater operational information and insight.  Rather than being the last people to know what is happening in the business, accounting professionals are recognizing that their ability to positively impact business performance requires getting “in front of the ball”, initiating process structure, data control and collection which ultimately results in better and more informed decision-making through better and more timely access to more meaningful information.

Businesses at all levels are realizing that new computing paradigms can ease the burdens of collecting and sharing information, yet most small companies need help in determining exactly how to approach this “enabling” of the business and systems.  While accountants are also experiencing dramatic change in how they do business, it makes sense for them to embrace the opportunity and recognize that enabling client systems will ultimately allow the accounting professional to work more closely and to deliver more tangible value to their client on an ongoing basis.  Online accounting approaches are no longer a fad but are the new reality supporting how many bookkeepers and accountants work with their business clients.  Extending access beyond accounting and bookkeeping systems, and incorporating support for operational and line-of-business solutions, is the next step which will bring the accountant closer to the client business, and position both to benefit from deeper collaboration and useful insight.

Make Sense?

J