Category: Cloud Computing

Posted on

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 

Posted on

Simultaneous Syncing Sinks Solution: Extend Access but Control Integrations

Simultaneous Syncing Sinks Solution: Extend Access but Control Integrations

Accounts and ProAdvisors: Make sure you “enable” only those who need it

In this wonderfully interconnected world of hosted and online applications and the integrations which complement them, it is important to not let the excitement of connectivity and collaboration replace reasonable control.  While there is much conversation on this topic when it involves file sharing and similar services, the discussion of data synchronization and data integration doesn’t often come up.  However, it has been my experience that there is usually a misunderstanding in how, exactly, a particular sync or integration should be applied and who should have access to the functionality when it is deployed as an extension of the QuickBooks desktop financial software.

An example of the problem might be seen when QuickBooks desktop editions are set to integrate or sync data with a web-based solution such as Method Integration or Santrio Open for Business Order Bridge.  Solutions like these, which extend the functionality of QuickBooks through extending access and integrating data, rely upon QuickBooks integration functionality move data between their solutions and the QuickBooks database.  These solutions are quite beneficial for businesses because they can affordably deliver support for various business functions via a true web application and incorporate QuickBooks data in those application views.  Additionally, this type of solution is able to push information from the web application to QuickBooks, allowing for complete integration of financial and other relevant data.

While having this type of integrated service is beneficial, there are a lot of businesses who don’t fully understand how to appropriately implement the solution and end up creating a great deal of difficulty for themselves.  One of the most frequent failures I have seen when implementing this type of solution is where the customer doesn’t really understand who should or should not have the integration.

When a web-based solution exchanges data or syncs with QuickBooks, a path is created to communicate between the two systems – the web solution and the QuickBooks application and data file.  This path must be open, and both sides of the communication identified, in order for data to sync.  The most important thing to remember is that there should be only one controlling entity on each side handling the integration.   What this means for QuickBooks users is that only one installation – one PC accessing QuickBooks – should be configured to facilitate the primary integration with the QuickBooks company file.

To illustrate, consider an implementation of Method Integration and QuickBooks that was done for a business some time ago.  This business used Method-based applications for a variety of business functions, and those applications used data sync’d from QuickBooks desktop.  Just after implementation, it was discovered that system sync’s were not happening as they should, and sometimes when they went to sync data, it would take a huge amount of time (which was not supposed to be normal behavior).  In short, the system proved to be problematic and, at times, unusable.  But the problem didn’t have anything to do with the Method Integration system, nor the technology.

The problem was that all workstations in the office were set up to sync data between QuickBooks and Method.  QuickBooks was installed on all the PC’s, even though most of the users did not use QuickBooks (they used the Method Integration system to do their jobs), and each PC had the Method Integration sync engine installed and set up to run.  This caused the system to be frequently overloaded with sync requests and caused QuickBooks to behave erratically or crash.  In addition, users who did not need (and should not have had) access to QuickBooks financial information were starting up QuickBooks and opening the company file every day because they thought it was required to allow them to access or use QuickBooks data in the Method Integration system.

The benefits of using web applications which can connect to and integrate data with QuickBooks is that a business can give users functionality and data access required to get the job done, but not expose those users to more software or data than they need.  In most cases, if not all, QuickBooks is not necessary for users of the web application (saving you the cost of purchasing and installing QuickBooks for these users).  Further, to ensure proper functionality and to remove any possible conflict or confusion in the sync process, only one workstation with QuickBooks should be set up to sync data to/from the web solution.  While it makes sense to have a “backup” PC setup with the ability, syncing should remain inactive on this machine unless the primary “sync machine” is out of service.  The key element to remember here is that the data coming from the web application is being added to the QuickBooks company file.  Once the data is in QuickBooks, QuickBooks users may access the data from QuickBooks and do not need the connection to the web application.

When deploying this combination of solutions with a hosting service provider, the same rules will apply.  Only users who need the sync capability require service with both QuickBooks and the integration installed.  In some cases, this may make selection of host services more affordable, as only those who need the “additional application” (being the sync solution or integration tool) require customized service, and the rest of the QuickBooks-only users need standard QuickBooks service.  *It might also be worth noting that many hosting providers do not support “persistent” connections – sync connections which continue to run even when you are not logged in), so syncing of data would only be able to occur if the primary user was logged in to QuickBooks and had the sync integration active on the host solution.

Accounting professionals, QuickBooks ProAdvisors, and small business consultants can help their clients understand the value and potential of extending QuickBooks desktop editions with connected web-based solutions.  The additional value these professionals bring to the conversation is the understanding of the need for structure and control of the data flowing into and out of the financial systems, offering their expertise to ensure that the accountability and appropriate treatment of the information exists throughout the business.

Make Sense?

J

Read more …

There’s a lot of legacy ERP out there, and it’s not going anywhere any time soon

https://coopermann.wordpress.com/2012/05/29/theres-a-lot-of-legacy-erp-out-there-and-its-not-going-anywhere-any-time-soon/

Compliance in the Cloud – their system, your responsibility

https://coopermann.wordpress.com/2012/05/23/compliance-in-the-cloud-their-system-your-responsibility/

Beyond Bookkeeping to Total Business

https://coopermann.wordpress.com/2012/05/25/beyond-bookkeeping-to-total-business/

Posted on

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
Posted on

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
Posted on

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

Posted on

Finance and Accounting Support in Franchise Systems

Finance and Accounting Support in Franchise Systems

There has always been somewhat of a love/hate relationship between franchise operators and their franchisees. While many entrepreneurs elect to leverage a known brand, documented operating procedures, and combined purchasing power that is often a benefit of a franchise operation, the reluctance to open the books to the franchisor is sometimes based upon a fear that “big brother” will use the information to take advantage of the business owner. The two sides of the business model aren’t always operating in sync, even though a deeper level of finance and accounting process support might benefit both greatly.

Logic would suggest that both the franchisee and the franchisor would recognize the validity of sharing financial and business performance data for the benefit of the entire system, where benchmark data and performance comparisons can become the basis of tremendous business intelligence. But some franchisors, as their networks expand in size, find that their success in selling units begins to outweigh their concern for individual unit performance, and the brand value creates sufficient momentum to overcome a few bad business experiences. Especially in larger systems, the franchisors don’t often consider the benefits of providing back-office and accounting support for their franchisees, because they simply don’t feel they have to. That is changing to a degree, and reliance on quality accounting and financial data takes on entirely new meanings in an environment where franchising is increasingly more complicated and competitive.

High unemployment and low consumer confidence cause spending decreases which impact even the strongest of established businesses. With credit markets being as tight as they are and without qualify financial information to support the request, business owners are often unable to obtain the financing required to expand their businesses when required, to new locations or with additional personnel. The 2010 Franchise Business Outlook[1] suggested that, even as the economy starts to recover, franchised small businesses will continue to face these financing struggles. The forecast is for “a slow recovery with marginal increases in the number of establishments, jobs and output.”

Looking to Washington for help, a number of small business organizations, along with The International Franchise Association, are “calling upon Senators to include more provisions in new job creation legislation to help small businesses access credit.” [2] The fear is that if credit access for small business isn’t made available now, the best opportunity to create sustainable business and subsequent job growth will be lost. Reliance by small businesses upon credit is unquestionable.

According to the IFA, “the depletion of [SBA loan] funds last fall is proof that the SBA programs were, and continue to be, critically important for our nation’s creditworthy entrepreneurs”. However, without sound business accounting and provable data, even the most business savvy entrepreneur may find their business “unbankable” and must therefore rely upon personal credit guarantees to support business growth.

Possibly the strongest point in the argument for franchisors facilitating accounting and financial management assistance to the franchisee centers on Item 19 of the FTC and state Franchise Disclosure Documents (FDD)/Uniform Franchise Offering Circular (UFOC). Item 19 is the Earnings Claim, which are estimates or historical figures detailing sales, expenses, and income a prospective franchisee might realize as the owner of a particular franchise.

The Earnings Claim is often considered to be the single most important factor in buying a franchise. As with purchasing any business, it is critical to have a realistic and supportable projection of sales, expenses, and profits earned. Particularly in a case where a potential new franchisee has no experience running a business, or no applied experience in that particular type of business, the earnings claim becomes the only guidance available. Unfortunately, the only source for this information is the franchisor itself, which often introduces doubt as to the veracity of the data. It is difficult to determine which could raise more doubt about the sincerity of the franchisor: using unverifiable data, or not providing an earnings claim at all.

When a franchisor elects to provide services to their franchisees, such as back-office accounting support or financial management oversight, then the opportunity to obtain data for the earnings claim, performance benchmarking, and royalties verification become realistic goals. Further, the ability to verify and substantiate the data can prove invaluable in a tough franchise market where buyers want good, verifiable information, and Item 19 helps sell units.

Offering accounting support to small business owners isn’t a new concept, but the technology to facilitate a truly seamless relationship has only become available in recent years. As Internet and Web-based application services emerged on the market, businesses flocked to them in order to gain the benefits of anytime, anywhere access to applications and data. However, the poor performance and lack of features left some business users without the tools they needed to handle all their requirements efficiently, so many returned to manual or local PC-based systems.

Secure remote access and application hosting services are a technology approach which adapts trusted and proven software and systems to a cloud-based, collaborative online working model. The server-based application model, which is essentially a hosting approach delivered from on-premises computers or offsite hosting infrastructure) allows the businesses to continue use of applications with the functionality required to support the business, but improves the IT environment by managing and securing the applications and data within the confines of the host. This eliminates the need to install or maintain applications on different computers and eliminates the need to have data copied or sync’d to different computers and devices.

A valuable aspect of providing secure remote access and centralized access to applications and data is the ability to then integrate with reporting systems designed to assist in the translation, analysis, and comparison of data from a single business to an entire franchise system.

Deploying server-based (hosted) computing models with remote and mobile capability means owners are able to retain their investments in software applications and processes while introducing new efficiencies and flexibility in their working models. The evident benefits are the ability to access information from any location, to have multiple locations work seamlessly together, and to allow outside accountants or other service providers to work seamlessly in the organization. Adding commercial hosting of the server expands on centralized management and administration with professionally-secured systems, greater predictability in ongoing IT costs and an improved ability for the business owner to focus on the business.

In summary, the franchisor market must look more closely at the fiscal management and reporting systems of their franchisees, and provide avenues to better-address access and support for accounting and bookkeeping responsibilities in order to gain credible performance data and useful benchmark metrics. Only through the ongoing participation of accredited accounting and financial personnel can the business financial data provide the information – and the insight – required to support aggressive business growth in this difficult economy.

The key is seamless integration, and the technology solution is the cloud-enabled model.

Make Sense?

J

[1] Report that measures the economic impact of franchising in the United States, prepared by PricewaterhouseCoopers (PwC), and commissioned by the International Franchise Association Educational Foundation. http://franchise.org/uploadedFiles/Franchise_Industry/Resources/Education_Foundation/2010%20Franchise%20Business%20Outlook%20Report_Final%202009.12.21.pdf

[2] Franchise.org Press Release http://www.franchise.org/Franchise-News-Detail.aspx?id=49246