Tag: spreadsheet accounting

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

Posted on

Workflow is Essential in Document Driven Business

The popularity and proliferation of online applications and cloud computing solutions for business has transformed how organizations manage activities, people and resources.  The Internet-connected marketplace has introduced both opportunity and challenge for businesses of all sizes, and much of this focus has been placed on the management and control of digital documents and data.

Electronic document management has been commonly used in professional services business for many years, yet has not always been viewed as an essential technology to apply in the context of organizing and structuring the processing of the document.  As clients of these professional firms continue to generate and utilize a great deal of paper documentation and written information, firms continue their reliance upon paper files, shared drives, and other more traditional methods of organizing the work, and storing or controlling access to documents.  However, key trends in the industry are causing these approaches to be increasingly burdensome for professional service firms, including:

  • Need to support multiple offices, geographically disbursed team members, and mobile workers and devices
  • Increasing use of email as a primary tool for collaboration
  • Introduction of new risk elements accompanying new technologies
  • Increasing numbers of forms and document types coming from clients
  • Rising expectations of clients and increased market competition
  • Growing need for businesses to increase earnings and profitability with fewer resources
  • Increasing requirement for knowledge management supporting sustainability, creating the ability to retain and reuse best practices and work produced

Advances in the design and underlying technology supporting many document management solutions today have delivered great capability to firms adopting electronic document management approaches.

Benefits of implementation include the ability to create a centralized, searchable documents base which includes all client-related content, including email communications as well as documents and data files. Easy search, access, collaboration, and re-use of information are enabled, and complete audit trails may be retained. Electronic document solutions also reduce physical document storage needs, reducing costs associated with managing and storing paper files, and can better serve business disaster recovery and continuity initiatives.

While today’s electronic document management solutions may address many of the challenges involved in working with large volumes and varieties of documents and data, there are few solutions on the market which address fundamental issues relating to document processing workflows and how they are impacted by various business or data-driven events, or by the availability of people or resources to facilitate the process.

The growing problem facing businesses today is the volume and variety of information which must be organized, processed and archived. The market is sold on the idea that electronic communications and record keeping will simplify things, but the reality is proving otherwise. Businesses are hoarding information at unprecedented rates and with the ability to collect and generate increasing volumes of digital data, businesses have not simplified their information processing, they have only created a greater need.

Generating and collecting data is not the issue created, nor is ultimately the archival and storage of the information. Rather, the problem created is in organizing the work related to processing this ever-increasing volume of documents and data.

Businesses dealing with documents and transaction-based activities should not only attempt to structure workflows necessary to support the various processes, but must also seek to normalize as much as possible, developing a consistent and methodical approach to the work which results in predictable and consistently high quality service delivery.

The efficiency gained through this structuring and standardization of the work allows the professional services firm to achieve a greater level of profitability for outsourced processing engagements, which are often viewed as low-margin and low-profit activities.

Make Sense?

J

Read about Using Structured Workflow to Manage Offline Clients | Intuit Accountants News Central

Posted on

Using Structured Workflow to Manage Offline Clients | Intuit Accountants News Central

Using Structured Workflow to Manage Offline Clients | Intuit Accountants News Central

The demand today requires that accounting professionals be more attentive and, yes, aggressive, in terms of “attacking” a regular flow of processing client information rather than batching it at period end. This drives a great need to structure and organize the work, and workflow, so that the repetitive and regularly performed processes may be streamlined and made easier to manage on an ongoing regular basis. It is no longer good enough to wait for clients to deliver the information and request the resultant reports. We must proactively request and gather the required information for processing, especially with offline clients, in order to get the work done more frequently.

Read the entire article at Intuit Accountants News Central

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

Not Everybody’s Accounting Online: Outsourced Bookkeeping and Accounting for “Offline” Clients

Not Everybody’s Accounting Online: Outsourced Bookkeeping and Accounting for “Offline” Clients

With all the focus on online technology, solutions that help you work smarter and not harder, and having mobile access to information at any time and from anywhere, you’d think that the entire world had adopted an entirely mobile and high-tech approach to life and business.   The popularity of software-as-a-service models and apps for just about everything are certainly a testament to the movement toward a more connected and mobile lifestyle and business environment.  However, not every business has adopted a comprehensive paperless, mobile-accessed, virtual working world – not by a long shot.  In fact, more folks than you may realize are still using actual paper, writing things by hand (things like checks and invoices), filing piles of paperwork in stand-up filing cabinets, and generally doing things the long, slow, painful way and then recording it on PC-based spreadsheets.  You know – the way we did things before the Internet showed up.

While paperless offices and technology-enabled approaches to collaborative business are gaining popularity and adopting users every day, there is a community of business users out there who are not as laser-focused on the high-tech approach to online accounting and working closer with their outsourced accountant or bookkeeper.  These business people are just getting the job done, and have found ways to handle their information and processes that work for them.  It is this business user that accounting professionals should not forget as they seek to adopt new and innovative cloud approaches to service delivery, and for a couple of reasons.  First, this type of client is likely to be in need of process support and additional service as the business grows, and the accounting professional is in a great position to help with those needs.  Second, this type of client exists in great number.

Consider the following scenario; a discussion I discovered when perusing a small business forum recently.  The interesting thing is that this is a discussion I see pretty frequently with small business owners and entrepreneurs – the discussion about the value of actual accounting or bookkeeping solutions versus a simple spreadsheet approach to record keeping.

I am the owner of a brand new small business. It has only been up and running for a short time. My accountant is pressuring me to use the online version of QuickBooks, but I am doubtful as to whether this is the right software for me.

I know that QuickBooks has a lot of different features, but I really only need it to track spending and customer payments, and since it’s still early on, I don’t have a lot of either. I would only need the very basics, and would probably only check it every two weeks at most.  The fees they want for the software would add up pretty quickly for something I’m not really going to use much.  My business is very small (just me) and service-based (tour guide), without much potential for repeat customers. I don’t need the payroll, invoicing, or other advanced features.

I honestly think that the easiest thing for me would be some sort of spreadsheet or really basic software that I could put directly on my computer instead of accessing online.

The truth of the matter is that spreadsheets often provide the common ground between small business owners and their accountants.  For a business owner, spreadsheets offer a simple and intuitive way to organize and record information because the column layout makes it easy to understand where to enter which data.  For the accountant, a spreadsheet can fairly quickly be sorted, filtered and prepared as accounting or tax return data.  While working with clients in a fully online, collaborative model may be the “best case scenario” in terms of delivering high levels of service in the most efficient manner, understanding how best to work with those clients in other scenarios is also necessary.  Getting the spreadsheet from this type of client is generally not terribly difficult – they are often more than willing to email it.  As long as the professional has a good document management solution to capture and manage these files, and introduce them into the firm workflow, then working with this type of offline client doesn’t have to be a huge impact to internal firm efficiency.

For accounting and bookkeeping professionals working with small business owners around the country, this type of client likely fits into the “normal” category more than those with a strong motivation to use cloud computing and having a great desire to use the Internet and connected services for everything they can (eventually the “new”normal?).  I believe the reality is that only a small fraction of smaller companies – solo, soho, and small/medium business – are actively managing the majority of their business process and information online.  In fact, Intuit (makers of QuickBooks) and other entry-level accounting and bookkeeping solution providers continue to heavily target small business users who are still tracking their finances using spreadsheets and other methods.  This simplified and after-the-fact approach to spreadsheet record keeping is being further facilitated by the banks and credit card companies providing customers with a greater ability to classify and categorize transaction information, and then quickly download it into said spreadsheet.

Yes, the dichotomy is clear: many small business owners resist (or are, at least, unimpressed with) cloud accounting approaches, yet these very same individuals are likely utilizing cloud services from banks and other financial institutions to support their spreadsheet and checkbook record keeping, as well as accessing email and other services via the web for various reasons.  It makes some sense, though, when you look at it from the business owner perspective.  Their way sounds easier, is less overwhelming, and meets the need – for now.

J

Learn more about Working Online With Clients: How to leverage the internet and cloud computing to work closer with your clients

Read more about Online Accountants and Their Clients: Working Smarter, or just Closer?

Read more about Data Warriors: Accountants in the Cloud

Read more about using the cloud to extend “connectedness” beyond traditional boundaries