accounting software – Cooper Mann Consulting

December 7, 2017

‘Tis the (Filing) Season – Time for W2s and 1099 Reporting

Every year-end brings with it not just the holiday spirit, but also the underlying dread felt by small business owners – a creepy and back-of-your-neck hair-raising feeling associated with annual business tax reporting and filing. That old saying about “death and taxes” has a lot of validity to it; sometimes they feel like the same thing to a small business owner. And this is the filing season. Ho ho ho.

The reporting requirements for small businesses seem to be growing at a rapid pace, and business owners are struggling to find the information and tools that ease the adjustment to increasingly burdensome reporting and compliance. The IRS has implemented a number of measures to increase tax revenues and enforce compliance, including stricter 1099 reporting requirements. With information provided at both ends of the “transaction” it is easier to identify those discrepancies which trigger audits. With this type of business intelligence, the IRS has developed a fairly strong weapon to combat non-compliance, so small business owners need to really pay attention (the IRS is). If the feds are tooling up, then business owners should, too.

Just to add to the seasonal festivities, make sure you upgrade your accounting software in time to benefit from the right rules and forms. If you run a small business and keep most of your information on spreadsheets (still? really?), that’s OK because there are solutions available which draw the information from spreadsheets, eliminating the need to re-enter data. Seriously, though, you should consider using actual bookkeeping or accounting software.

It is also important to remember that payroll tax filing dates for W-2s and 1099 forms were changed for 2016 taxes, and these changes continue for 2017. The filing deadline for 2017 W-2s and 1099 forms (including Form 1099-MISC) is January 31, 2018, which is a month earlier than the pre-2017 filing date. Thankfully, the deadline for providing W-2 forms to employees and 1099-MISC forms to other workers for 2017 has not changed. This deadline is still January 31, 2018.

Using a cloud-based service to file 1099s online should be something your business considers doing if it isn’t already. Because most services include form and feature updates, users don’t have to go looking for the right documents or worry that they are using an outdated form. In an online or hosted solution, users benefit from updates without downloads and get stricter security around their data than would likely be present on their own PC. As it relates to your accounting software, make sure it has the capabilities you need in this area and don’t settle for limited functionality.

Here are some features you’ll want to look for in your e-filing solution this year:

The ability to print and/or mail forms to recipients as well as e-filing forms directly with the IRS or SSA
Have Form 1096 or W-3 automatically calculated and transmitted electronically with the detail forms
Upload volumes of data with Excel templates or import from your accounting software (saves time and reduces input errors)
Store data securely and provide full access to filed forms for multiple years
Maintain payer and recipient records securely for use year after year.
Encrypt data upon submission and keep it encrypted throughout the entire process
Supports 1099 Corrections (should allow filing of corrected forms regardless of how the original form was filed)
Accountants, Bookkeepers and Tax Preparers should be able to set up multiple payers and file on behalf of many clients from a single account, even filing for all clients at once or via batch submission

Year-end tax filing, especially dealing with 1099s and W2s, is an arduous task for most small businesses and their professional service providers, yet it is one of those things that simply can’t be put off. Where there is a single income tax return there could be literally hundreds of associated 1099s or W2s to file. 1099 filing in particular has become more of a focus as authorities crack down on contractor versus employer classifications and seek to develop easier identification of audit candidates (something every business owner wants to avoid).

The point of the discussion is that there are cloud-based tools which are highly useful, feature rich, and very affordable… and business owners and their accountants or bookkeepers would be wise to take a look rather than assuming that the general accounting software will do the trick this year and the next. Remember that tax filing season is an annual event, and being able to rely on a consistently useful solution can make the season a bit merrier (or at least a little less stressful) for all.

Make Sense?

Hi! I was looking for the Frangos.

January 26, 2016February 3, 2016

No REST for QuickBooks Desktop Integration Developers

Intuit, the maker of QuickBooks small business accounting software (among other things), is discontinuing service for the REST API and the Sync Manager on March 1, 2016 [1]. Developers with applications which integrate with the desktop editions of QuickBooks using this method must change their approach right away or risk having their integrations simply stop functioning. It’s not that Intuit will DO something on March 1^st. Rather, they’ll stop doing something – like handling Sync Manager integrations.

There are a lot of different types of businesses in the world, and each of them produces and consumes a lot of information. From sales to human resources; from operations to finance – every business generates and manages information to support the various processes which make up the business activities. Computer systems and software represent the tools businesses use to develop and manage information, and often become foundations for structuring the information which flows through the organization. Just as there may be different people in the business, each with their own responsibilities and job functions, there are likely software applications which are similarly oriented to support different processes within the business. Integrating or connecting different applications and processes within the business helps the organization be more efficient with information usage, generally increasing the quality of access and reporting throughout the business while at the same time reducing or eliminating redundant data entry and the potential for errors. Software integrations are a big thing to many businesses, which is why the discontinuation of Intuit’s Sync Manager for QuickBooks Desktop editions is a big deal.

Intuit’s Sync Manager was the big thing just a few short years ago. Providing developers with a seamless method for accessing QuickBooks company data and passing it to/from web-based and other applications was a boon to the online application model and paved the way for many disk-based integrated solutions to migrate to SaaS offerings instead. Developers who saw success operating in Intuit’s QuickBooks marketplace as recognized add-ons were encouraged to use Sync Manager so that they would be able to seamlessly market to, subscribe and onboard new users who purchased QuickBooks products. Whether or not the developer participated in Intuit’s application marketplace, the Sync Manager and the REST API provided them with some very important capabilities and supported new methods now recognized as “standards” for development of web-based solutions and services.

The World Wide Web has succeeded in large part because its software architecture has been designed to meet the needs of an Internet-scale distributed hypermedia system. The modern Web architecture emphasizes scalability of component interactions, generality of interfaces, independent deployment of components, and intermediary components to reduce interaction latency, enforce security, and encapsulate legacy systems. http://dl.acm.org/citation.cfm?doid=337180.337228

In order to integrate a solution with QuickBooks desktop products, there are two essential problems to solve. First, there must be access to the QuickBooks data. Few products are able to directly access the data in a QuickBooks data file; generally, the QuickBooks program itself is used to ‘broker’ access to the company file. So, developers need a way to work inside of QuickBooks to use it to access the data their applications need. Second, the data must be transported (via the Internet) to allow for data to come from QuickBooks into another app, or to allow data from the other app to come to QuickBooks. The REST API and the Sync Manager addressed both of those problems and provided developers with the mechanisms required to facilitate the data integration as well as transport the data.

REST (representational state transfer) is “the software architectural style of the World Wide Web [2]” and represents a standard for creating scalable, distributed system interactions. Using this method, developers were able to make their online solutions access, read and write data in QuickBooks desktop products because Intuit had first sync’d the data to its servers, so developers needed only to reach the Intuit servers to reach the data. The Sync Manager provided the transport, carrying the data to/from the desktop installation where the Sync Manager service was running. And, because the Sync Manager was basically built-in to QuickBooks, there was no additional software to install and maintain on the computer because it was all part of the QuickBooks installation.

Intuit did a fantastic job of getting developers to move to the API integration method, positioning all those lovely 3^rd party solutions for linkage via an Intuit.com account and, now, to QuickBooks Online. Intuit is clearly favoring the QuickBooks Online edition and the API integration method available with that platform, and is telling developers that they must convert their customers to QBO in order to retain the easy connective ability they had with the desktop editions via Sync Manager.

Now that Intuit has announced the discontinuation of the REST API and the Sync Manager, what options do QuickBooks integration developers have, and how can customers using 3^rd party integrations keep using them? Options do remain, and they aren’t all that bad. In fact, the options which remain continue to be the methods of choice for certain developers. These developers recognized early on that Intuit’s somewhat “lightweight” methods couldn’t handle the complexity or full functionality of their integrations facilitated their solutions using the SDK and never looked back (and still don’t). For this community of developers – many of whom likely never considered trying to market their solutions in the Intuit app marketplace – the elimination of the REST API and Sync Manager don’t really matter. They didn’t bother with them in the first place, just as they aren’t bothering with QBO. Those solutions don’t fit their customers, anyway.

The QuickBooks desktop SDK (Software Development Kit) has been around for years, and using the SDK developers have been able to craft tight integrations between their solutions and the QuickBooks desktop products. From payment plug-ins to fully integrated sales, customer relationship, inventory and manufacturing solutions – a broad range of integrated applications built with the SDK have been successfully deployed to QuickBooks customers all over the world. Many applications which integrate with QuickBooks desktop solutions are desktop products themselves and are designed to work within the same desktop and network environment as QuickBooks, so there is no need to worry about “transport” of the data over the Internet.

For other solutions, such as online applications and services, there may be a need to exchange data via the Web. The QuickBooks Web Connector has also been a very popular solution for developers of applications that integrate data with QuickBooks. The Web Connector is just what its name implies: it is a way to connect QuickBooks to the web and vice versa. With the Web Connector application and a web connector configuration file, developers could provide a method of exchanging data between QuickBooks desktop and another solution fairly simply. While the Web Connector is quite useful in providing a means to transport integrated data to/from the QuickBooks desktop to an external system (like an online application), it only allows access to whatever data Intuit decides. For this reason, many developers use both an SDK application and the Web Connector so their applications can access all data required and also have a web service available to transport it.

There are numerous implications relating to the sunset of QuickBooks REST API and Sync Manager, and another among them is the impact in hosted environments. For customers who are (or might) benefit from hosted QuickBooks delivery models, what does the end-of-life of the Sync Manager mean? Since the Sync Manager was basically built into QuickBooks desktop editions, it meant that there wasn’t any extra software to install or manage when a company wanted to adopt a Sync Manager-based 3^rd party integrated solution. In a hosting environment, this means that the customer could easily add integrated applications to work with their hosted QuickBooks and the service provider might never even know it was being done. There would be no additional software to install on the host servers; so many providers would simply be unaware that their customers were using these other solutions.

As developers return to SDK and Web Connector implementations in order to integrate with QuickBooks desktop, customers will ask their hosting providers to install the QWC (QuickBooks Web Connector) and/or integration software in their service. In shared service delivery models, this may be virtually impossible to do without potential compromise to existing customers using those servers or other applications resident on the systems. Hosting customers will not always understand that a “simple plug-in” actually represents installable software that must be secured, maintained, managed, and kept from improperly interacting with other software in the environment. Some providers may not even be willing to work with the new integration software, while others may allow it but will not take adequate precautions to ensure proper and secure function.

Intuit has said to many constituent groups that its focus on desktop editions of QuickBooks will continue, and new certifications and benefits for desktop ProAdvisors (and continued development of interoperability with other solutions, like the Revel POS integration for QuickBooks desktop) give support to those statements. Yet developers who support integrations with QuickBooks desktop are once again adjusting to the not infrequent changes Intuit makes to developer programs and philosophies. The push to QBO and connected apps may be the focus for QuickBooks marketing dollars, but there are still quite a number of (very busy!) developers supplying solutions to businesses who don’t shop inside their QuickBooks software.

Joanie Mann Bunny Feet Make Sense?

[1] https://developer.intuit.com/blog/2014/09/08/timeline-to-discontinue-the-quickbooks-desktop-rest-api

[2] https://en.wikipedia.org/wiki/Representational_state_transfer

September 8, 2015March 26, 2019

The Cloud, The Desktop and QuickBooks

subtitle: Just When They Told You the Desktop Was Dead…

along comes another desktop app.

Everything is moving to the cloud! Everything is going online! At least, that is what they’re telling you. And, to a certain extent, it is true that a lot of things are moving to the cloud; just not everything. And some of what has moved in is moving right back out. Use of the cloud and cloud services is increasing, but that certainly isn’t proving that the desktop is going away anytime soon. The only thing we can be certain of is that things are going to continue to change fairly rapidly, yet the lion’s share of business users will retain working models they have come to trust and rely upon until they are forced to do something else. Today, many accounting and business professionals feel that they are being forced out of the software they have known and worked with for years: QuickBooks desktop software.

I was recently asked to present to a group of accounting and tax professionals, the topic being “alternatives to QuickBooks Online”. I thought it was interesting that this would be a topic of such interest, as QuickBooks has long been recognized as the market leading application for small business bookkeeping and accounting. Accountants and bookkeepers, as well as tax professionals, have worked with QuickBooks for years – many having even styled their practices around the QuickBooks brand and offering QuickBooks-specific training and other services. Why are these professionals now asking to learn about alternatives? Well, it is an alternative to the online version of QuickBooks that these folks are seeking, and they have been given the impression that the desktop editions of their beloved QuickBooks are no more and their businesses are being forced to change.

Due to Intuit’s focus on promotion of the QuickBooks Online edition as THE QuickBooks to buy, there is a growing belief that the desktop products are going away. Many professionals who have worked with the product line for years are now operating under a belief that their only future with QuickBooks is with the online edition, so they are searching for alternatives for their clients and their own practices. The QuickBooks Desktop editions aren’t being eliminated (2016 editions and certifications coming!), but any real mention of them in the direct marketing is gone, because Intuit isn’t pushing these solutions to new customers. It is no wonder the accounting and tax pros are looking at alternatives – and their customers are, too.

QuickBooks has always been a direct-to-consumer solution and was pretty much the only thing a small business owner would find if they shopped for software at the local computer or office supply store. The high-value desktop editions continue to be available, but it is difficult to tell a business owner they need to purchase licensing and then pay for mobility for QuickBooks desktop editions while QBO sounds much cheaper and they can get it on their tablet or PC for that cheap price. Also, there is more shopping online – from phones and tablets as well as PCs – so consumers are being exposed to other brands and the plethora of new online solutions. Now that they are considering buying or changing accounting/bookkeeping software… they could just as easily elect to use something completely free and not spend anything with Intuit or anybody else.

The small business owner isn’t focusing on the qualities of the accounting solution or how it impacts their accounting professional’s processes – they are focusing on monthly price of the solution. Accounting professionals are now recognizing that the software isn’t (or shouldn’t be) the basis for their practices, it is simply a tool. And there are a LOT of tools available to work with, not just QuickBooks, so the value of aligning solely with that solution is perhaps not as good an idea as it once was, but it is not gone. There is still a tremendous volume of work to be done with businesses using the QB desktop products – you just wouldn’t know it from the marketing hype around QBO.

The thrill of exploring SaaS (software-as-a-service) and online application models has introduced new competition in markets where the dominant player once felt secure (small business accounting, for example). While Intuit’s QuickBooks products were a defacto standard and essentially owned the smb accounting market, the diminished response to the QBO product has created opportunity for many newcomers. Xero, for example, has been able to make great progress, even recruiting long-standing QB ProAdvisors as Xero advisors and promoters. gnuCash, once a bit of an outlier, is getting new business because it IS desktop based (some people like that!) yet it doesn’t require an an ongoing commitment to internet connectivity or to pay fees to the developer. NolaPro, Wave, Freshbooks and more are growing in popularity as more freelancers and small business owners begin using applications other than spreadsheets to manage their business finances. The generation that grew up with online banking is now readily adopting computerized bookkeeping, but they aren’t necessarily interested in QBO. Still, a great many move to QuickBooks desktop editions because QBD is a recognized and respected solution.

It also remains to be seen what happens with usage of some of these online smb accounting solutions when the business reaches some size or complexity. While they may be highly useful for startup or freelance business, many are not likely to satisfy business requirements far into the business lifecycle. This is when the going concern and growing business demands more functionality and performance, which often becomes the catalyst for seeking faster and more powerful software and systems and has been a driving force for businesses returning to locally-installed or hosted accounting and ERP solutions. Along with QuickBooks desktop editions, Sage is positioned extremely well here. The Sage 50 solutions (good old Peachtree!) can scale and also have very strong accounting functionality. These were actually the preferred solutions for most accounting pros for a time, but the momentum of QuickBooks pushed them to the side. With the attempt to now leverage the QB user base to the QB Online solution, Intuit has created the opportunity for Sage to regain a position with accounting professionals and their clients who demand more.

As these software and systems have (in some part) migrated from the local infrastructure to the web, we have also seen a lot of hybrid or “tweener” approaches come about. These approaches, just as cloud service of any type, come in many varieties and exist to solve different problems. The problem of browser-based functionality and modality is among the issues identified with QBO. The browser-based app doesn’t allow for multiple operating windows – you have to use browser functionality for that. And it is relatively slow – performing data updates and screen refreshes like with a website and not as one would require of a business application. The solution provided is a great example of a hybrid approach. The desktop app for QuickBooks Online (yeah) is a software app that comes in a flavor for Windows and Mac, and which provides more of a desktop user experience even though it mimics the interface and connects to the data of QBO. It is faster, and multiple windows can be used, and more… which are some of the great benefits of running software on the local device and why desktop software is so great a performer. This hybrid model simply allows for desktop software to work with cloud-stored data and back-end processes, and potentially delivers some of the best of both technology models: cloud and localized.

If you consider how much of the actual QuickBooks desktop product has been turned into web service (payroll, merchant processing, etc), it seems like QuickBooks desktop is already beginning to be a bit of a hybrid approach. And when QB desktop is run with a hosting service provider, the whole thing becomes available anytime/anywhere. Hosting is the way to provide the management and mobility aspects of QuickBooks and other desktop software. The hosting model delivers benefits of cloud service – providing users with all the features and functionality of the desktop solution – and introduces the system management and mobility that is part of the underlying value of a web-based or SaaS application approach.

The real discussion, I believe, is not about the death or near death of the desktop and locally installed applications – that’s just silly. Even phones are now being touted as possible desktop replacements, as the processing and storage capacity has increased to rival the most useful portables and laptops. Clearly, devices continue to be more powerful and capable, and these advancements aren’t done solely to make web browsing more enjoyable.

pendulum Devices are more powerful so that they can run more applications – fast – and deliver more useful functionality to the user. Maybe the data will be in a cloud, and maybe even some app functionality will be delivered via a cloud, but it is very unlikely that everything will be in the cloud. Complexity and cost drove developers to seek out alternatives, and advancements in technology will introduce new options that change everyone’s thinking again. While the pendulum did swing to one extreme (move it all to the cloud and off the device!), we are now seeing it swing back in the other direction a bit and those who didn’t swing all the way the first time are in a position to reap some benefit.

Joanie Mann Bunny Feet Make Sense?

December 19, 2012September 17, 2013

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?