Tag: spreadsheet reporting

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

Lean and Mean – Improving Sales and Distribution Performance

Lean and Mean – Improving Sales and Distribution Performance

It is surprising that, even in this world of Internet marketing and online commerce, many businesses are operating at levels far below their potential.  Reliant upon people rather than information and process, these businesses are weighted down by their legacy approach to getting things done.  They throw money and personnel at the problem, adding more “fat” to the business and making sustainability just that much harder to achieve.  The right approach, and the mantra of all manufacturers and distributors, should be to work “lean and mean”, applying technology and business principles which support agility and improved process efficiency.

The center of lean business is in operations, and includes all aspects of the “order” processing and support systems.  From the point where an order is sought, to the point of order entry, and through to delivery and service – all aspects of the operation must be addressed for the business to achieve maximum success.  Innovating in operational areas, such as in order management and distribution, can help the business rise above others in the market and create a significant competitive advantage.

What becomes challenging for many businesses is the fact that years of working in established “silos” often makes it difficult to introduce the cross-functionality necessary to support lean operations.  It is not sufficient to simply suggest that the organization work collaboratively to streamline processes from order through to service and support.  Work groups and team members must work together and adapt to delivering process improvements, following through with the actions necessary to turn the philosophy into bottom line results.  Good support is required to keep customers, and a good product is necessary to support increased sales.  No aspect of the operation stands alone, so each is necessary to participate in making end-to-end improvement.  Additionally, back-office processes must be aligned to work collaboratively where required, supporting efficient operations rather than creating unnecessary bottlenecks or delays.

The key to developing a lean and mean, high performance operation is applying the technology and principles which translate into improved profitability and customer retention.  In many cases, the same solutions which create customer “self-help” capabilities are also solutions which can address similar needs for internal business users. Ultimately, the goals are elimination of redundant or error-prone processes, establishing the sharing and secure collaboration of information throughout the organization, implementing integrated systems which allow users to efficiently perform their particular tasks, and working cooperatively with others in the supply chain to maximize the real-time capability and efficiency.

Rather than continuing to utilize basic record keeping solutions, or accounting products which aren’t prepared to address the specific operational aspects of the business, owners and managers should be looking to the tools and solutions which will help them develop the framework to support improving operational performance, turning people knowledge into sustainable business profitability.

Make Sense?

J

Accountants and Small Manufacturers: Getting 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.  Read more…

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

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

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