Tag: bunny slippers

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

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

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

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

Ever since the first application service providers began offering hosting services for Intuit QuickBooks desktop products, the idea of running desktop editions of QuickBooks in the cloud has created both intrigue and confusion among accounting professionals and their clients alike.  Part of the problem is the term “cloud”, which seems to equate the hosted QuickBooks desktop editions with the true cloud app QuickBooks Online Edition.  But hosted QuickBooks isn’t QBOE, it’s a service model developed around the actual desktop versions of QuickBooks: Pro, Premier and Enterprise.

While it is true that both solutions – hosted QuickBooks and QuickBooks Online Edition – offer centrally managed and accessible online accounting functionality, the underlying services are very different and operate under completely different “rules”.  One of the rules, or conditions, which differs between the two solutions is that with hosted QuickBooks service, you may also be able to run other business applications and manage other business data, not just QB apps and data.  This is an essential capability when you consider that QuickBooks desktop software integrates with and takes advantage of functionality found in other popular business solutions, such as Microsoft Office.

In many QuickBooks hosting services, the inclusion of Office app hosting is typical due to the reliance upon functionality in those solutions (Excel reporting, Word letter-writing, and Outlook emailing).  When it comes to other tools or application integrations, however, customized hosting service becomes necessary.   When the need for additional applications or integrations arises, consideration should be given to the best way to orient and implement those add-ons.

For example, if a client business has a heavy reliance upon a solution which integrates with QuickBooks, and uses the solution to handle daily tasks in the business, then it makes a lot of sense to create a hosting environment specifically for that client.  The client would be able to access their unique set of solutions, and the accounting/bookkeeping professionals can be invited to participate in that system.  This keeps the data in one place, managed and controlled, yet allows all parties who need access to get access.

In other situations, there may be a tool or utility necessary to help get data from one place to another, and this tool or utility is not something the client uses in their daily work.  In this type of scenario, it may make sense for the accountant/bookkeeper to have a customized environment which allows them to use the tools and solutions which assist in data integration, organization, validation or review.  In many cases, the accountant or bookkeeper may perform these data integrations or sync operations directly in the client data file, so that the client (using “generic” service with just QuickBooks hosted) is able to then access and view the integrated data.  In this scenario, only the accounting professional has the additional tools necessary, allowing the cost of hosting for the client to remain lower.  Approaching a hosting environment in this manner might allow the accounting professional to develop a niche or customized approach to serving a specific type of client, incorporating behind-the-scenes data aggregation or integration and other types of process support as part of the overall service delivered.

The key to developing the right application hosting and outsourced accounting service model is to focus on how the practice will use the hosting solutions to improve service and process efficiency, serve client needs better and more fully, and differentiate themselves from their competitors in the market.  By applying the hosting service and online solution properly, business clients and the accounting professionals who support them will both benefit by getting the information and the application functionality they need, when they need it.

Make sense?

J

read more about the confusion over hosted licensing on The Progressive Accountant http://www.theprogressiveaccountant.com/tech-tips/confusion-over-hosted-licensing.html

Posted on

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

Posted on

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

Posted on

Knowing Your Options: Hosting QuickBooks for Shared and Remote Access

Intuit’s QuickBooks financial applications, the desktop editions in particular, are the most popular small business accounting solutions on the market.  The QuickBooks Online Edition, Intuit’s cloud-based contender, is not quite as accepted among accountants and advisors for a variety of reasons.  Being in the cloud isn’t necessarily one of those reasons, if you consider the growing demand for access to multi-user cloud-hosted QuickBooks desktop editions.  Mostly it comes down to functionality and how the application operates.  QBO just isn’t like good old desktop QuickBooks and isn’t the preferred solution for many financial professionals or their clients.  Yet these users still want and need remote access and mobility.  This is where hosting comes in.

QuickBooks hosting and creating the ability to access QuickBooks applications and data remotely is something that a lot of businesses can benefit from.  Whether it’s to outsource the management and maintenance of servers and systems to a 3rd party, or to create the ability for remote workers or contractors to collaborate with real-time applications and data, there may be a need for a hosted application approach.  Business owners and IT managers need to give consideration to the level of service and support they and their users will need before selecting their provider.  Knowing what the provider will handle and what the subscribers are responsible for might make all the difference in determining the right approach.

In-House DIY Hosting

Local networks and PCs allow users in the same location to share resources, like printers and data storage locations.  Typically, desktop computers have application software installed on them, and use the network to access shared data.  When users work outside of the network, getting access to applications and data might not be so easy.  Even extending the network via VPN access doesn’t solve the problem when the desktop applications are not designed to access data over remote connections (desktop applications like QuickBooks).  It used to be that the only reasonable way to allow remote users to access and run QuickBooks as if they were inside the LAN was to set up remote desktop or application servers (terminal servers).  MyQuickCloud is a product that addresses this need very gracefully, providing in-house personnel with the tools necessary to establish a secure cloud for QuickBooks access directly from existing on-premises systems.

Co-location and Outsourced Infrastructure (IaaS)

Instead of setting up remote access solutions in the office, many IT departments find that co-location with a 3rd party addresses a number of issues.  Leasing equipment, operating system and virtualization tools may be more cost-efficient than purchasing them directly, and the security and redundancy in most hosting facilities far exceeds what most businesses are able to afford to implement by themselves.  Co-location provides managed service for infrastructure elements, but doesn’t necessarily address business needs in terms of user security or application and data management.  These elements are traditionally left up to the subscriber; installing and configuring software applications, establishing user and application permissions, and managing updates and software upgrades.  For this reason, co-location may be a good option for a business with internal IT staff, but not necessarily for businesses seeking “full service” application hosting.

Application Service Providers (ASP) and Managed Application Hosting

Application hosting service providers handle software installation and management, user and security administration, and ongoing technical support as part of the subscription service.  Customers need only to provide their software licenses, name users and upload data in order to use the service.  The service provider does the software installation and configuration, sets up the users and establishes permissions, and connects users and applications to managed data storage.  This model allows businesses to enjoy many of the benefits of a cloud-based or SaaS solution model while also allowing them to continue to use software solutions they are already invested in, in terms of both software licensing and process development.  On the other hand, these models can be extremely restrictive in terms of the applications or integrations they will support, and can be quite costly as the number of users or applications hosted increase.

Whether you roll your own (DIY hosting) or work with a full service QuickBooks host, accessing business applications and data from anywhere is an option every business can take advantage of.

Make sense?

J

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