Enterprise Functionality for Small Business | Relating to Customer Data

Enterprise Functionality for Small Business | Relating to Customer Data

handshake

Many small business owners are under the impression that most powerful business process management solutions are just for big businesses. A common misconception, for example, is that robust CRM products with turn-key functionality are too complicated and expensive.  This misconception leaves most small business owners to frequently turn to inexpensive online solutions or to their favorite email client in order to store and manage customer information. In today’s competitive business environment, the intelligent and innovative use of technology and business information is often the determining factor between success and failure. Now more than ever, small businesses must leverage tools with the same capabilities as their enterprise counterparts in order to help the business perform at levels necessary to drive growth and maintain profitability.

The data developed within the solutions supporting various business processes is the key which unlocks business intelligence. This data may only be captured and used if the systems and tools in place allow for it. With far too many small business CRM solutions, the assumption is that simplicity of use is the equivalent of less functionality. Approaching the problem from the standpoint of what most small business owners KNOW they need to know, developers have sometimes failed in delivering the capability (and resultant data) small business owners didn’t know they needed or would benefit from. What business owners need to know about is the customer.

Customer Relationship Management (CRM) solutions help businesses identify, acquire and retain customers. Almost any business relationship or interaction represents a customer opportunity. Present customers are customers now, past customers are not just past customers but prospects and everyone else is a prospective future customer. Consider that vendors or resellers are different types of customers, too.  Even employees and coworkers can be seen as “internal” customers. Keeping useful and relevant information about these various “customers” and documenting how the business interacts with them is essential to understanding the entire relationship lifecycle, which is a step towards understanding the business better.

When a small business elects to use a software solution to handle the various interactions with customers, it is often approach in pieces rather than in a comprehensive manner.   Traditionally, Contact Management solutions are applied to sales efforts, providing tools for communicating with leads and prospects as well as current customers. However, related information is also often stored in accounting systems, which handle billing and payment processes involving customers (clients, suppliers, employees, etc.). Some businesses also may use other systems for time management, service or work order management, project management and to archive related documents and emails at various levels of the relationship, where customer information is used and data is created.  With segmented pieces of information in numerous databases, it is hard to achieve true Business Intelligence and a comprehensive view of the entire operation.  Smaller companies can easily miss out on the benefits that their enterprise counterparts possess.

It’s not really unusual for businesses to store some of the same information in several systems, generally in order to support specific job functions for workers in those areas, and delivering data on the equivalent of a “need to know” basis.  For most small businesses, though, an integrated Business Management system that provides CRM as a component of its overall offering could be the answer to providing a single comprehensive solution for all departments.  An integrated solution of this sort would seamlessly integrate with the accounting, email, and document management products Small Businesses use every day.  Examples of such solutions include, but are not limited to, Results CRM, Method CRM and LeGrand CRM.

Beware, however, that not all integrated CRM solutions are created equally. If your organization delivers billable services, make sure that the integrated CRM system that you select can take a billable appointment that was scheduled in the CRM system and automatically place that on an invoice for you – without duplicate data entry and manual tracking of timesheets – so you’re not leaving money on the table. If you manage projects, make sure that the CRM system has the cohesiveness to include project and resource management functionality so that the full business relationship – from sales to the delivery of services to billing – can be managed and tracked in one system without duplicated data entry.

When systems are not tightly and intelligently integrated, sharing data between them becomes very problematic.  Without the ability to check for duplicate records or properly map data points and related fields between systems, there is a great potential for errors in or duplication of data. The result could be a large amount of unrelated and unusable information, which is often what happens when list or transaction data is simply copied between applications without the necessary logic to understand changes in various records, record types, or record states.

There’s a reason why “legacy” integrated software solutions made sense for businesses, and why many enterprises continue to hold on to their solutions – they include the wide variety of tightly integrated functionality and logical data sharing that has been a benefit to the business for years. As organizations seek to start up or reassess their software and systems, they would be wise to keep in mind that generating “big” data with a bunch of loosely connected applications isn’t enough. The data must be intelligently related – just like the business and the customer. 

A tightly integrated and well-managed CRM and Business Management solution, whether in-the-cloud or on premises, is not out of financial reach for small business.  While a solution of this type is not free, the reasonable investment in a quality solution will provide the Business Intelligence necessary to build and maintain a competitive advantage.

Joanie Mann Bunny FeetMake Sense?

J

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/