QuickBooks SDK Integrations, Cloud Hosting, and the Customer Relationship

QuickBooks SDK Integrations, Cloud Hosting, and the Customer Relationship

Intuit QuickBooks desktop editions are the most popular small business accounting software products on the market, boasting somewhere in the neighborhood of 3.5M users.  In contrast to the QuickBooks Online Edition, which has approximately 300,000, desktop QuickBooks still reigns supreme with small business.

While QuickBooks satisfies most of the general business functionality required from a general accounting product, it doesn’t address much else.  For this reason, numerous software developers have created the software products – the extensions, integrations, widgets, and tools – that make QuickBooks more useful to the business.

The sheer popularity of the QuickBooks product line has supported the creation of a very large and diverse community of developers who make things that work with QuickBooks.  However, as with any attempt to bring like-minded people together, the QuickBooks developer “community” is not all-inclusive, and there are lots of ISVs (independent software developers) out there who aren’t communicating with Intuit frequently, and who aren’t necessarily exposing their solutions through the Intuit marketplace and other Intuit-branded venues.  In many cases, these are developers who have line-of-business solutions that represent the operational priority for their business clients, and where the integration to QuickBooks financial is somewhat of an after-thought.  In many cases, these solutions rely on QuickBooks only for general back-office account functions, where the GL, AR and AP are all that really matter.  The “tough stuff” is done in the line-of-business application.

Most of these types of solutions, as well as many with more complicated functionality or data integration requirements,   utilize a method of communicating with QuickBooks developed using the QuickBooks SDK, or software development kit.  This SDK was originally introduced as a means to replace the clumsy IIF import facility, an early way to get data into QuickBooks from other systems.  The SDK is really a tool kit designed to facilitate desktop application integrations, which is why so many developers use this method.  Particularly when an application is intended to be used on the desktop in conjunction with QuickBooks, it makes sense for developers to use an integration method that will allow them to produce the rich experience and seamless re-use of data that the desktop environment allows.  The SDK requires that the QuickBooks program be present, and QuickBooks controls access to the data file rather than allowing the 3rd party application to have direct data access.

The new method for integrating with a QuickBooks application is by using the IPP (Intuit Partner Platform) method, which is essentially an API (application programming interface) which simplifies the creation of data streams to and from the QuickBooks database.  This method of integration is intended to be serviced by the Intuit Sync Manager (included with QuickBooks), where your data first syncs to Intuit servers, and then connected apps sync from that source.  In this case, Intuit acts as the intermediary, hosting the synchronized data and controlling the sync with the QuickBooks database.  While this may be much easier in terms of offering stricter standards for QuickBooks data integration, it is not a method which addresses the needs of those solutions requiring an integrated experience involving QuickBooks programs and data, or which have more complex data integration requirements than may be served through the IPP.

Because the QuickBooks SDK has been around for many years, it allowed for very stable QuickBooks-integrated solutions to be developed.  In comparison, the IPP is pretty new and has taken Intuit a few tries to get working.  For this reason, there is a limited catalogue of solutions available in the Intuit App Center, which is where IPP solutions are promoted.  Moving forward, Intuit has stated that the focus will remain on the IPP, with the SDK no longer being a preferred (or supported) method.

The method of integrating with QuickBooks desktop editions matters, especially if you’re looking to bring your business applications to the cloud.  Application hosting services is the way to “cloud-enable” desktop solutions, yet not all hosting providers recognize or understand the differences in how applications might integrate with QuickBooks, and what that means to the technical and user environments.  Not all applications are created equal, and not all QuickBooks integrations are, either.  Some integrations sound simple enough to implement, yet have hidden requirements that make deployment with a host or outsourced infrastructure provider an interesting endeavor to say the least.

Developers using SDK integrations with QuickBooks should make certain that they have thoroughly discussed their solution requirements prior to deploying their applications with any host, particularly with a client-selected provider.  Companies experienced in hosting QuickBooks are not necessarily adept at understanding the nuances of SDK-developed integrations, and may minimize the technical requirement to the point of leaving your company and your customer with a bad feeling about hosting.  In worst-case scenarios, the software developer loses their customer altogether due to a poor experience with the solution in a hosted environment.


Cooper Mann Consulting
 is working to help developers and commercial ISVs with QuickBooks-connected solutions get their products to the cloud, and in a way that they can influence and help control the all-important customer experience.  Rather than being just one of a few hundred hosted products customers can select from the provider menu of offerings, we believe your solution should be delivered with your values, your message, and your unique service approach.   Doing so allows you to keep your arms firmly wrapped around your customers and users, working closely with them as you develop your solutions towards a true SaaS or cloud application model, and easing the transition from desktop to web application delivery and subscription service.

Intuit believes they own the relationship to all QuickBooks customers, and they’re right to the extent that the user relies on QuickBooks for some business functionality.  Hosting service providers think they own the customer relationship because they have significant influence over the products accessed from their servers.

Operational support solutions go deeper into the business than any high-level accounting product, and the method of deploying the solution (locally installed or hosted) is an IT issue and nothing more.  As a developer or provider of essential solutions which address specific vertical industry or line-of-business needs, and as the company who understands the business of your customer and supplies those solutions that help them perform, don’t you really think you should own that customer relationship?  We do.

Make Sense?

J

Want to know more about how Intuit is changing their approach to QuickBooks integration?  Read Charlie Russell’s rant: Is Intuit Abandoning QuickBooks SDK Developers?

Read more about QuickBooks cloud hosting: Cloud Hold-Out No More: QuickBooks Desktop Editions in the Cloud

Read more about cloud development: Lessons Learned (or Not): Development and the Cloud

Read more about legacy application modernization, and why IT and back-office outsourcing makes sense for a lot of reasons 

Managing The Purchasing Process: More than just expenses

Managing The Purchasing Process: More than just expenses

When a business owner hears the term “expense management”, they immediately get a vision of traveling employees with piles of receipts and vouchers to be organized, accounted, and possibly reimbursed for.  The image is fleeting, gone out of mind with no lingering thought, because this business owner does not have personnel who travel frequently, and does not have to deal with volumes of expense reports from employees.  Expense management solutions aren’t anything this business owner is looking for.

Yet, what does happen every day is that equipment, materials, supplies, and services must be purchased to keep the business operation going.  Calls are made to vendors, price quotes are developed, and purchase requests are typed up in Excel spreadsheets and piled on the owner’s desk for approval.  The business owner rifles through the various requests, and brings in the bookkeeper to help work through the decision of which items to authorize based on current cash availability.  Because the availability of working capital changes frequently with billings being sent out and receipts being deposited daily, the owner and the bookkeeper spend much of their time together figuring out which purchases to make and when.  It is a continual and ongoing process, taking a lot of time and attention away from other important business matters.

Too often, thoughts of managing these efforts with more structure places the problem “in a box” and addresses only half of the issue – the purchase.  While managing materials requirements and predicting when parts or supplies will be needed is one side of the problem, factoring those purchasing plans in to the cash requirements of the business, and having a meaningful and effective way to monitor current cash, expected receipts and purchase requirements together is essential.  This ability requires that the payments management solution also address receivables in order to have the cash flow and availability information necessary.

Expense and purchase management processes generally involve three main steps: planning, tracking, and reporting.  As the process involves planning, it suggests a proactive rather than a reactive approach to cash management and purchasing activities.  By bringing together all of the critical data which describes “inflows and outflows”, the business owner has the information necessary to not only forecast (plan) cash requirements but to also understand the availability of working capital.  Knowing ahead of time that traditionally slow paying contracts aren’t factored into immediately available cash is important, and being able to make adjustments to purchase schedules based on availability of funds is essential.

Expense reporting may not be a big part of the business, but managing cash flow and purchasing goods and services is, even in the smallest of enterprises.  Make sure the business has the tools in place to help bring an additional level of intelligence to purchasing activities, and that those tools deliver the benefits of a structured (but not time-consuming) purchasing approvals and proactive cash flow management process.

For accounting and finance professionals, this is a highly valuable area of service you could be providing to your clients – helping to implement the tools and solutions which not only allow you to work in more depth with client businesses, but which deliver immediate visible and actionable benefit to the client.  This is just one of the ways accounting professionals can work closer with their clients, and the benefit is delivered each and every day (not just at tax time).

Make Sense?

J

  • Is your purchasing and expense approvals process holding up your business? Read more…
  • Read more about using the cloud to extend “connectedness” beyond traditional boundaries 
  • Read more about how there’s no fear and loathing in accounting
  • Read more about the pressure on accountants to deliver more value and intelligence to their clients
  • Read more about Data Warriors: accounting in the cloud

Knowing More: CFO and Accountant Value in Understanding Business Operations

Knowing More: CFO and Accountant Value in Understanding Business Operations

Accounting professionals are being pressured to deliver more value and intelligence to their business clients every day.  The pressure comes from a variety of areas, not the least of which is the fact that a lot of do-it-yourself tools are now available which lead business owners and managers to believe that they know what’s going on in the business.  Lots of charts, graphs, and dashboard presentations make the numbers more readable, but they don’t say whether or not the numbers are even right.  Even more important, they don’t deliver insight based on experience and understanding.  This is where the accounting professional’s value really comes from – providing insight based on good data and quality data analysis backed by experience and understanding of the business.

You can’t be a good CFO or a strategic business partner to your CEO until you thoroughly understand operations and how they drive performance,
CFO.com (http://s.tt/1rtoZ)

Knowing what makes a business valuable is important, but what many business owners don’t fully understand is how to best increase that value.  Generalized reports which summarize financial information, distilling it into a standard set of metrics, often don’t tell the business owner what they really need to know – how to go about increasing the overall value of their business, whether it is through improved profitability or through growth.

The business owner understands the operations, but not necessarily how operational activities actually impact value and profitability.  Helping owners know more about their enterprises requires that the accounting professional also know more, where gaining a deep understanding of operations and learning what business functions are addressed and how becomes the key to bridging the gap between operational knowledge and business valuation. This is where the accounting professional or CFO can really make a difference, and can help to apply their knowledge in building business value directly towards those areas which fundamentally impact it.

Make Sense?

J

  • Read more about how accountants need business intelligence, too
  • Read more about how there’s no fear and loathing in accounting
  • Read more about Data Warriors: accounting in the cloud

QuickBooks Hosting Services and Accounting Professionals

The value of applying an application hosting model for your clients

The concept of application hosting is not at all new.  In fact, there are literally millions of business users accessing hosted applications and similar services every day, and adoption didn’t reach those numbers overnight.  For several years now, Intuit (the makers of QuickBooks financial software, among other things) has even had an “Authorized Commercial Host for QuickBooks” program.  If Intuit recognizes the value of a hosted application service model, then there must be something to it, because Intuit rarely does anything unless it’s big.

The value of application hosting services, such as QuickBooks hosting, may differ from business to business, but the underlying benefits are there for all to achieve.  For some, the main value is in being able to access business information and data while traveling.  Using mobile devices, business users are able to get information on customers, orders, payments, and other valuable data – from anywhere they choose to work.  Being able to keep tabs on the business even when they aren’t there is very important to some business owners.

For others, the value of application hosting services is the collaboration that it enables.  With public accounting in particular, the client business and the accounting professional do not work at the same place at the same time.  Being able to work on the same software and data, and doing that work at the same or different times (it doesn’t matter when or where they work) allows business owners and their accounting and bookkeeping professionals to work seamlessly together in support of the business.  This online model allows the business owner to benefit from better financial data in real-time, rather than waiting for the work to be done after the fact, at the end of the month or year.

The underlying benefit that all parties get from a hosted application and online working model is better information technology management and greater predictability in IT service costs and capabilities.  Businesses need to be able to focus on their business and not on the IT which supports it, and outsource professionals such as accountants and bookkeepers need to be able to work with clients efficiently without having to invest in expensive tools and services to make it happen.  A hosted application approach, when applied to the client business, delivers many benefits to the business owners while at the same time providing tangible benefits in efficiency through more effective time management and improved access to information for the professionals who support those businesses.

When developing a working model for outsourced bookkeeping, accounting, or virtual CFO services, it is essential to recognize that businesses need technology to support their operations, and there may be “line of business” solutions in use as well as accounting or financial software.  Too often, outsource bookkeeping and accounting professionals focus only on the accounting or financial systems, and fail to consider the critical aspects of the operational level applications which support the various functions of the business.   With a hosted application approach, the business solutions in use can be “enabled” – from operational solutions to accounting and finance supporting applications – so that accounting professionals may gain access to the complete realm of business data, putting them in a far better position to ensure that the information resulting in the accounting system is of high quality and may be trusted.

Make sense?

J

Read more about Accountants and Bookkeepers Working With QuickBooks Clients: App Hosting Approaches That Work

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

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

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

When it comes to using technology and the Internet to work closer with bookkeeping and consulting clients, it is important to recognize that there is never only one way to accomplish something, and different clients will have equally different ideas on and tolerances for how you work with them.  In order to serve each and every client to the best of your ability, you have to carry around a “toolbox” of solutions and services which will assist you in delivering the most effective and efficient service in each situation and under each set of conditions.  While you must do what you can to streamline and standardize your processes to be as efficient as possible while delivering a high level of service, but you can only work within the parameters allowed by each client and circumstance.

Paperless_468x80

I think we can all agree that, whenever possible, it is wise to avoid situations where you have to get in the car and drive somewhere just to pick up information or paperwork.  These are the activities which are most costly in terms of time and resources.  Using file sharing solutions, such as DropBox or ShareFile, is a great way to get documents from clients.  That is, if the documents are in electronic form already.  If not, then either scanning the files and saving to the Dropbox or web folder, or faxing them to a service such as eFax, is the process.

Sometimes Internet connectivity is the issue.  Using a fax-to-email solution like eFax takes that out of the picture, in terms of getting documents and other paperwork from the client.  But let’s face it… there is no good way to electronically exchange or share QuickBooks or other computer data files safely and quickly unless the client has broadband Internet access.  You can always go back to dialup modems and connect using the old version of PCAnywhere, the way we did it years back, or you can recognize that sometimes you just have to get in the car and bring a USB drive with you.

Internet-based remote control solutions, such as LogMeIn, provide you with the ability to connect your computer directly to the client computer in order to perform tasks on their system and with their data.  This is a better approach than going to the client office and doing the work there, but it doesn’t address a situation where both you and the client need to be working at the same time.  If you are controlling their computer, you take over the workstation while you are connected, which prevents the client from doing independent work while you are doing your job. The better option is to use a solution that allows you to both work at the same time, even when connecting to the same computer.  MyQuickCloud does this. MyQuickCloud is a remote access solution that can be applied as both a remote access and remote working solution. It is better than remote control because it can allow many users at the same time to connect to the computer and run applications.

In some cases, working online with the client may mean working in the same applications and data files by accessing a centralized online solution, such as QuickBooks Online Edition or hosted QuickBooks (QB Online and hosted QuickBooks are not the same thing).  When both people (the client and the accountant/bookkeeper) have access to the same programs and data files in real-time, it allows them to work together more closely yet at times and from locations which work for the individuals.  This arrangement works quite well when the accounting professional and the client can both serve their requirements with the same software solution.  If the client uses QuickBooks to perform their daily tasks, the bookkeeper and accountant are able to simply log in and use the same solution to perform their work.

A model which more people are beginning to recognize as valuable is the model where each user or functional area in the business has the solution which works best for them, and the various solutions in the business each integrate and share data as necessary.  For an accountant or bookkeeper working with a small business, this may mean that the software or solution used by the client to handle their daily tasks is different from the solution used by the accounting professional to do their job.  Just as a tax preparer will use accounting data to prepare a tax return using a tax preparation solution, accountants may use transactional or financial data from other systems to perform accounting functions in an accounting software solution.  As long as the data is easily accessed, via built-in integration or sync tools, it makes a lot of sense to give each user a solution designed to meet their process needs because they will use the solution more effectively.  Giving a user way too much functionality can be confusing, and expose them to areas of business activity or information they should not have access to (or which is meaningless to their job) can waste time and introduce risk.

Examples of this approach might be where a small business owner uses FreshBooks accounting to manage their daily invoicing, but the information is then exported to and integrated into QuickBooks financial software, where the accountant or bookkeeper handles the rest of the business accounting functions. Another example may be when services such as Bill.com, TSheets, Expensify, Concur, and other “point” solutions are in use. These web-based solutions provide specific functionality, such as bill payments and approvals, employee timesheet management and reporting, expense management, and more.   They make it easier for the client to handle certain functions and address related information management and reporting needs, and facilitate the data integration with core accounting and finance.  In many cases, this approach delivers not only more relevant functionality and process support for the business users, and still allows the accounting professional to do their work with the tools which work for them.

Providing a high level of service to your client while embedding as much efficiency in your processes as possible can be a challenge for any outsourced accounting or bookkeeping professional.  Your profitability and the goodwill you develop with your client depend on finding the best way to engage and deliver on the promise of great service.   Your toolkit  – the connected services and solutions you leverage to this task – can positively impact the “degree of success” you experience with each client or project.

Make Sense?

J