Getting out of IT Jail

Getting out of IT Jail

I have a friend in the accounting/technology industry that spends way too much time on his business in-house IT.  He’s always futzing around with servers and workstations, fixing corrupted data files or PCs that won’t launch applications, and setting up remote access so he can work at home (which he never actually does because he’s at the office fixing IT issues).  More often than not, when I try to get time to chat with the guy, his response is “I’ll have to call you later; I’m in IT jail”.  As a side note, my friend is Doug Sleeter, a recognized leader in the world of small business accounting and among QuickBooks accountants, consultants and advisors.

My friend works a lot with different solutions and technologies designed to make it easier and more effective to get accounting and business information collected, processed, stored, and reported.  He reviews tons of different solutions each year, and looks for those he believes can truly make a positive impact in the life of a business owner.  My friend also, as he puts it, “eats his own dog food”, meaning that he actually puts into place many of the solutions which he finds to be beneficial so that he can experience their benefit in his own business.  His proven experiences then translate to support for the solution in the market.  People need to know that a solution will actually do what it is supposed to do, and many wait for someone else (someone they trust) to go first so they can use the customer feedback to help them make a decision.

My friend clearly recognized the growing value of cloud solutions and how implementing cloud-based services to solve specific business problems might be a more effective and affordable way to address growing business needs than with traditional ERP models or installed software approaches.  Using different tools that work together (his term for this is “chunkify” 🙂 ), even very small businesses could now affordably address the various operational and financial information management needs which exist at some level in all businesses.  Following along with his previous commitment to use and not just talk about these things, he began the process of selection and implementation of various cloud-based applications, tools and integrations for his desktop QuickBooks software.

No battle plan ever survives contact with the enemy.  thesis on Military Strategy, German Field Marshal Helmuth Karl Bernhard Graf von Moltke 

It was going great.  Application services subscribed to were working as expected, and all sorts of information was fairly seamlessly flowing to and from QuickBooks.  And then, it happened – his bookkeeper moved away and wasn’t able to work in the office where the accounting software and data were housed.  Take a deep breath. Okay, so back to the remote access thing, and more IT jail.

He worked diligently to create remote access for the now-remote bookkeeper, and remote desktop service worked OK, but it was “a pain to keep working, and it never could give the type of performance we were trying to give her”.  Go figure, the one piece of the puzzle left in the office was the one making everything else more difficult and costly.  He was in IT jail once again.

The final step was to get the QuickBooks software and company data out of the local network and in a safe and secure and fully-managed environment.  Particularly since QuickBooks is (in this case) the centerpiece of the business accounting system, it became essential to place it in an environment where it would be maintained, monitored, and protected by people who specialize in that sort of thing.  My friend, like most business owners, just didn’t have the time and resources to have the level of IT and management that an outsourced commercial service provider could offer.

See The Sleeter Group’s  QuickBooks and Beyond article Still Addicted to Desktop Software? Get it Hosted in the Cloud

Intuit even recognized that businesses needed a better way to run and manage their QuickBooks desktop software, so they created an accredited hosting program to allow service providers to offer application hosting and license management services to QuickBooks users.  My friend now uses one of these providers to host his QuickBooks and other desktop applications.  He still has all the integrations and features he had before, but isn’t required to spend time and productivity fixing hardware issues or software installation problems.  His software is installed, maintained, and actively supported by IT professionals who are focusing on nothing more than keeping his systems up and running.

In his own words, “the hosting move offloaded us from having to mess with providing access, and at the same time it improved performance and delegated the IT management”.

For a time my friend and his business went without a high level of IT management and support, but now he completely recognizes that he needs it and is finding it to be well worth the cost.   Now he’s got his own “get out of jail” card.

Make sense?

J

In case you didn’t know it, both Intuit and Sage have programs for service providers, providing authorization to host and deliver small business financial software products to direct customers.

Get information on Intuit’s Authorized Commercial Hosts for QuickBooks hereGet information on Sage hosting partners here.

If you need assistance deciding how to get your applications and business online, or selecting and implementing with a service provider, we can help.

Read more: Cloud Hold Out No More: QuickBooks Desktop Editions in the Cloud

Remote access to client bookkeeping comes in many forms because clients come in many forms

There are a lot of conversations in LinkedIn and other groups, where bookkeepers and accountants are discussing their various methods of accessing client QuickBooks data and applications remotely.  While these conversations are quite helpful for some folks, there are others out there that simply get confused due to all of the possibilities.  There are many ways to work remotely with QuickBooks clients, and there are a lot of different situations where one approach may work better than others.

The key to remember here is that REMOTE ACCESS MATTERS.  Time and distance is the enemy when it comes to outsourced bookkeeping, and whether you like visiting your clients or not, having remote access to their data can be the key element in providing the highest level of service and value possible.  Remember when PCanywhere became available, and we were all excited because now we could use a modem to dial directly in to the client PC?  OK, maybe I’m talking to a crowd that’s too new to remember that excitement, but believe me, remote access is something all outsourced accountants and bookkeepers have been looking for.  Now that really good options are available (a lot of options), it makes sense to get a better understanding of what you can and can’t do with various remote access approaches.

First, when you’re looking at any true SaaS solution (true being a relative term, but here we mean an app service that was built for the web and is offered as a subscription model), consider that the solution exists only on the web, and that when a business subscribes they are generally subscribing to a single company data set.  Unlike QuickBooks desktop, for example, where you can have numerous company data files, QuickBooks Online and other SaaS solutions generally build a single company data file associated with the subscription.  When you want to access different companies, you may have to log in as a user of the company you’re accessing.

If you’re an accounting professional, there may be an edition or approach that allows you to connect to multiple client accounts, but then again, there may not be.  So be prepared to have to log in as each individual client to access their data.  When this becomes the situation, what’s the difference between one client having QB Online and one using Xero, Wave, FreshBooks or Kashoo?  None, really, other than the fact that you need to get to know all of the solutions a bit.  As a bookkeeper or accounting professional, this shouldn’t be so much of an issue, as debits and credits and basic accounting theory doesn’t change with the accounting software (basic “accounting theory” isn’t really available for redefinition).

The other thing to recognize about these solutions is that the data belongs on the web with the app, so it’s not like you’ll be copying the data file to your PC to work on.  You might export the data to another solution, but you won’t be using the SaaS solution offline.

If the client isn’t using a SaaS solution, then it is likely a desktop solution, where the application is installed on their local PC.  This type of solution – QuickBooks desktop editions being the most popular and easiest example to work with – gets installed and runs from the PC.  Data may be stored on the PC or on a network hard drive, but the program is running locally on the user’s computer, and is using resources on the local computer (memory, processor, etc.).  There are only a few ways to make this type of application into something you can access remotely, and one of them is by using a remote control approach.

Remote control is where one computer connects to and controls certain aspects of another.  This is like the old dial-up approach, using PCanywhere-type applications to control one computer from another.  These days, the Internet rather than a dial-up phone connection is the preferred method, and there are web service providers which “broker” the connection and communication between computers, providing added features and layers of security.  Using a remote control solution (examples are LogMeIn or GoToMyPC) simply allows the user on one computer to control the keyboard and mouse, and view the display, of a remote computer.  It doesn’t matter what is running on the remote, so a bookkeeper could use this approach to access a client PC and QuickBooks desktop applications and data, or even to connect with the client so they can log in to QuickBooks Online or Xero together.

Some bookkeepers work with their clients, showing them how to do things and connecting to client resources in order to get work accomplished.  Others connect using their own resources or accounts, and work concurrently with the client.  Still others may export data from the client solution into their product of choice, not even working within the client application at all except to make adjustments and data exports.  It all depends on the collaboration model you and the client have going, and it is unlikely that any single model or approach will work for the entire client base.

QuickBooks hosting introduces a bit of a wrinkle in the concept, but not much of one.  Really, hosted QuickBooks desktop editions should be viewed to be not less and not significantly more than a QuickBooks Online or other SaaS approach.  If the client would benefit from working online (most client would), then having them host their QuickBooks desktop applications and data with a hosting provider makes sense.  However, just because the client is hosting their QuickBooks doesn’t mean that you should immediately assume that you’ll have access to their applications or data.  Like with a SaaS solution, you’ll likely have to have an account to log in with, and that account could be a separate login allowing you to work at the same time as the client, or the account could be one that is shared with the client and where only one of you can log in at the same time.

Since a hosted solution is accessed online just like a SaaS solution is, you don’t have to have the software installed on your own PC, and you only need an Internet connection to access the application and data at any time.  A major difference of working with a hosted solution is that you could possibly have the application installed on your PC, and could copy the data from the host and work on it offline.

With all of the options available, accountants and bookkeepers have realized that the selection of client collaboration approaches depends on a number of factors, and that professionals may end up applying an unlikely combination of solutions in order to address meeting various client preferences as well as their accounting needs.

Make sense?

J

Read more about hosted QuickBooks desktop editions

Read about the race to find the secret sauce of hosted application services for small businesses

QuickBooks Accountant Niche Practice Specialties: Tools for Accountants Working With Contractors

QuickBooks Niche Practice Specialties:

Tools for Accountants Working With Contractors

For accounting and bookkeeping in a small business, Intuit QuickBooks is still the “go to” solution.  QuickBooks has functionality needed by most businesses, and some editions of QuickBooks offer more in-depth process support for specific industries and business types.  Accountants and bookkeepers working with QuickBooks may rely on essential bookkeeping and reporting features to get basic accounting done, but supporting the processes and offering the functionality business owners and managers need – processes and functions which are specific to the business type and how it operates – is essential to developing a solid business management and reporting system.

Accounting and bookkeeping professionals can be instrumental in developing these systems for their clients, and can use the data collected within these solutions to provide more detailed reporting and actionable advice relating to business activities and trends.  Creating a niche practice and specialty means knowing how to address the needs of the niche client and having the tools to make it happen, so accounting professionals working with QuickBooks clients should seek to leverage the Intuit partner network of developers and QuickBooks-connected solutions and extensions to orient their services to the needs of specific industries and client business types.

The most obvious example of applying an industry-specific orientation of QuickBooks is to use the Premier Industry offering of QuickBooks desktop edition.  With the Premier Industry editions, additional functionality and reporting for specific industries is addressed directly within the application.  Industry editions exist for non-profit, manufacturing, and contractors, among others.  A lot of practitioners have met the additional needs of their business clients by using these industry-specific editions.

With QuickBooks Premier Contractor edition, for example, businesses can go beyond general accounting and address specific needs of a contractor or construction business, including tracking and reporting on job costs and profitability, handling estimates and change orders, and billing clients by time and materials, job phase, or percentage completion.  Accountants and bookkeepers working with construction businesses can help their clients more accurately and efficiently address the unique requirements of this type of business by offering the user functionality which is relevant to their daily tasks, such as making deposits, entering and tracking bills, and reporting on the progress and status of jobs.

Contractors may also have unique payroll reporting requirements, most of which are not adequately addressed within the QuickBooks solution directly.  It is in this area of compliance and complex reporting where the accounting professional may be of particular value, ensuring that these additional business requirements are met and that the data is complete, accurate and timely.

By utilizing the Intuit partner-developed application from Sunburst Software Solutions to extend the functionality of QuickBooks, contractors and the accountants who support them are able to create comprehensive and accurate prevailing wage payroll reports, including the most frequently required WH-347 Payroll Certification Form and the WH-348 Statement of Compliance Form.  Further, the solution also provides reporting for nearly all municipal, state, and federal paper forms required in each state. The solution even includes electronic certified payroll submission, compatible with LCPtracker, Hill International {formerly TRS Consultants}, Elation Systems, and other agencies.

QuickBooks has the framework for holding information about customers and jobs, tracks estimates, progress invoicing from current accounts receivable and work complete, and a means to accurately record and track retainage payable and/or receivable.  To complete the requirement for AIA billing and other construction business-specific needs, Sunburst CAPS application for QuickBooks holds additional project information, architect information, retainage method data, and billing forms to print in linked records.  CAPS also provides a mechanism for percentage of completion calculations with full accounting for stored materials.  The information is then merged together from both programs to generate the final billings – ready for signature, notarization, and mailing.

Addressing this additional level of complexity and compliance for contractors is a critical element, and an essential benefit, of working with accounting professionals who understand the needs of construction businesses and employ the tools and applications to meet those needs well.  It is through specialization, and knowing how to address the unique requirements of (and to capitalize on the opportunities presented in) the client industry and business, that accountants and bookkeepers will demonstrate and retain their value in today’s challenging economy.

Make Sense?

J

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

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

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