Tag: legacy application

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

The Cloud Makes Time Travel Possible: Hosted applications can deliver immediate business benefits

The Cloud Makes Time Travel Possible: Hosted applications can deliver immediate business benefits

In an article published on CIO.com, author Kevin Fogarty describes how moving to a cloud IT approach proved to be a highly beneficial and strategic decision for an on-site diesel fuel distributor.  The focus of the article was on how existing software and processes were enabled by centralizing them in a cloud hosting environment, and not by replacing them with new subscription-based applications.

For many businesses, this is the secret that nobody’s talking about: you can have the benefits of “the cloud” without having to radically change everything you have and everything you do.  Retention of knowledge assets is critical to business continuity, and moving existing systems and process to platforms where they can be leveraged to greater business advantage is a way to do that.  With centralization of systems and services, information can be processed far more efficiently than before, eliminating delays and improving cash flows dramatically.  Time is money, and the cloud helps businesses spend less of both.

“A lot of the invoices have to go out every day by certain times, so third-party accounting companies can do their thing for the fleet owners.” The setup sounds like a classic for any overhyped business-process-automation system, but Daniel Abrams and other Diesel Direct managers weren’t interested in managing their business using sophisticated business systems that require more motivation, money and technical staff than Abrams was willing to use or pay for.”

The initial benefit is being able to use the products already in place, just from a more secure and redundant location, but when you begin to consider the positive ramifications of reducing the time between delivery and invoicing, billing and payment receipt, or customer demand and product supply, you rapidly realize that the cloud means much more to the business than just another way to run software.

“Those changes save Diesel Direct both money and time. Rather than running reports and invoices all night Tuesdays, for example, the additional capacity lets the company run those resource-intensive processes during the day rather than overnight. That gets critical work done faster and more accurately than a process left to complete itself unattended.”

In short, the cloud makes time travel possible, because the result is available almost immediately upon completion of the task.  It’s kind of like getting your expense check as you walk off the plane in your home town, because you reported all your expenses in real time as they were incurred (snap a picture of the receipt at the bar, and like that).

Yet most business owners and IT managers for small and mid-sized businesses are being told that the cloud is best applied when innovation is required, and should be reserved for NEW things, and not thought of as a way to improve the status quo with existing or legacy architecture.

“It’s not unusual for mid-sized companies to come to depend on cloud services, according to James Staten, vice president and principal analyst for Forrester’s Infrastructure and Operations practice.

It is unusual for them to be more concerned with infrastructure than with applications, he says.”

With affordable and secure application hosting services being widely available for small and medium businesses, owners and managers no longer have to look to new solutions just to enable mobility, remote access, and a fundamentally stronger and better-managed system.  Legacy applications can be hosted and delivered, extending their useful life as well as the value of the development and intellectual property, and giving customers capabilities not readily available with local implementations.

“Diesel Direct can’t accomplish anything if its minimal IT infrastructure is offline for any length of time.

Abrams, worried about storms taking out his business as well as the power, didn’t know what technical solution he wanted until Callow “described for him what an enterprise infrastructure looked like,” Callow says.

“They didn’t need one, didn’t want one, but they did want the security, the reliability of a redundant IT infrastructure,” he says. “The most effective way to get that at the lowest possible cost is the cloud.”

Among the greatest benefits of outsourcing application delivery to a cloud hosting provider are the increased monitoring and security, application of best practices, and high levels of system fault tolerance and recovery capabilities offered.  While business subscribers focus on features and functionality of the application, the real focus for hosting providers is the platform – and the management and security of it.  This behind the scenes work offers tremendous business benefit to subscribing customers, but is often not the focus when discussing overall benefits of a cloud computing approach in the context of Software-as-a-Service, which is where many smbs focus their investigations.  As an alternative, businesses who may seek to adopt hosted solutions for their existing applications and software frequently do so for reasons of security and redundancy, not recognizing that their business processes may likely experience significant improvement, as well.

“Enterprises might have the luxury of making strategic decisions about cloud or other technology,” Golden says. “In mid-sized companies things are very tactical. No cloud evangelist is going around the refueling industry saying ‘there are ways to solve this problem.’ “Companies make tactical decisions to solve their own problems and, five or 10 years later, we’ll all wake up and realize we’ve changed the way we do everything,” Golden says.”

Make Sense?

J

The company in the article could be just like yours.  You don’t have to adopt new software and systems to benefit from the cloud.  How could your business change, if you could remove the problems of time and distance?

Posted on

Data Warriors – Accounting in the Cloud

Data Warriors – Accounting in the Cloud

The cornerstones of building and supporting a professional accounting, bookkeeping or financial services firm are the tools and resources that assist the professional in building their practice clientele.  In today’s market, that means understanding the value and application of cloud computing models and services.

Information management paradigms are changing, and professionals who can help their clients to achieve maximum performance and profitability through increased efficiency and innovation will find that the practice evolves into a more effective and agile organization, and the quality of their client engagements is taken to an entirely new level

Not participating in a cloud technology model is making a decision to not participate in today’s technology-enabled flow of business opportunity.  Ensure your continued relevance and value, and communicate to your clients and peers that your firm is prepared to meet the demands of an intelligent and informed clientele and market.

What does the “cloud” really mean to accounting and business?  Well, it means a lot of things.

  • Centralized access to information resources
  • Distributed storage and management of information resources
  • Collaboration and co-working
  • MORE data collection than ever before
    • MORE data being produced by various operational systems
      • MORE need for controls on data flows and exchanges
        • MORE need for analysis
          • MORE need for critical thinking

It’s been proven that any time things become more complicated or complex, it creates a need (read = opportunity) for specialists.

There is a current a growing need for accounting and business professionals who understand how all of this “connectedness” will work.  And the question isn’t really a technology question, as there are people way smarter than me handling all that.  What I’m talking about is the flow of information and data throughout the system.

This used to be more in the domain of the CIO; information systems guys and data analysts.  Accounting and finance, for all its business value, was the final dumping ground for after-the-fact financial data.  Operationally, things could be humming along in the business and looking just fine, but the business was losing money and nobody knew it before it was too late.

But we’re finally coming to understand that virtually EVERYTHING in business has a financial impact leaving an imprint on the business: every action and activity, every relationship and interaction.

With the applications and service now being made available to businesses of all sizes, even small businesses are  now able to leverage the tools and gain the insight that only the largest of enterprises were able to do in times past.

The key is in enabling the business – facilitating their processing and getting their work done – using connected applications and mobile data access tools, or even simply helping with the collection of job or invoice or expense information electronically and in real time.

The earlier in the process, where you convert information into electronic data, the better.  You can then use connected systems or integrations to move and share data with others – other systems or other processes – within the business.

Accountants are already familiar with many of these concepts and tasks, where detailed customer activity and information is distilled into an AR entry, or where vendor and payments and various enterprise expenditures and resource utilizations are summarized into AP transactions and inventory valuations.  Operational systems are simply ‘exploded’ views of these subledgers and subsystems, where operational data and process-specific functionality resides.

With a traditional ERP/MRP approach, software systems were designed to meet the integrated business model by hanging all of the functionality and capability off a single framework or foundation.  Everything in the business was an extension from the core accounting and finance system.  Less intuitive for the user than a function or process-specific tool, at least the comprehensive integration of data was there.

What businesses may benefit from with a cloud-supported model is a similar result in terms of information being shared and enterprise collaboration being supported.  The difference, and the real and amazing benefit, is that specific and unique tools can be applied to support each operational segment or functional requirement in the business, and it can be done affordably and dynamically because it comes with the integration and real time information (data) exchange that single-framework enterprise systems provide.

The accounting professional becomes of greater importance in this connected system of data and functionality.  Their experience with and understanding of back-office and bookkeeping process, and the collection and preparation of subledger data for proper accounting treatment, is an integral role to play in establishing the proper integrations, syncs and data flows to and from “accounting”. Accounting becomes not an after-the-fact silo of historical data, but the centerpiece – the key – to unlocking business intelligence which leads to deeper understanding of business performance. When information is power, data analysis becomes the weapon, and the accountant the warrior who wields it.

Make Sense?

J

Posted on

Use the Cloud to extend “connectedness” beyond traditional boundaries

Use the Cloud to connect beyond traditional boundaries

With the number of definitions being applied to the term “cloud” these days, it’s no wonder business owners and IT managers are having a hard time keeping up. Depending on who you talk to, cloud can mean anything from “all things related to the internet” to a description of a more complex, distributed method of provisioning and utilizing the various elements (or layers) involved in a network computing model. There are purists in the industry who don’t agree with the broad use of the term “cloud”, as it creates confusion in the market as to what is and is not true cloud computing. Over time, however, this situation should be resolved through the understanding that, no matter what software or system you elect to implement, there will likely be an aspect of “cloud” in it. The popular term will become less important, and the market will simply recognize that this is how business computing is done.  It becomes “normal” IT, and not something special.

The stealthy inclusion of web services and connected applications has been happening for a few years now.  Even the tried-and-true QuickBooks desktop editions have become the center points for a large number of Internet delivered product features. Where payroll was once simply part of the program, it’s now an outsourced service delivered seamlessly from within the application. It’s the same with credit card processing, bill payments, attaching documents, and more. The cloud is involved in a lot more than most people really understand, because so much of the “magic” happens behind the scenes. This makes it easier for the user to adopt, but doesn’t go a long way towards helping them understand the model or the intrinsic benefits derived from it. Cloud is here, and it’s probably in the solution you are currently using. It’s already “normal” IT, you just didn’t know it.

While the market works through this realization, there is much to do in terms of educating folks on how they can use this new paradigm to their greater benefit. Business process automation, outsourcing non-core processes, and using integrated systems to improve information sharing and exchange within an organization aren’t entirely new concepts. What’s new, and what is enabled through this distributed yet interconnected technology model, is the ability for organizations to extend their “connectedness” beyond traditional boundaries. The walled garden of the enterprise can be safely and affordably opened to allow interaction at deeper levels with entities outside of the firewall, allowing metrics relating to those interactions to be captured, collected and analyzed in real time.

Make Sense?

J

Posted on

The Holistic Approach to Cloud-Enabling Your Firm

The Holistic Approach to Cloud-Enabling Your Firm

Today’s professional accounting or law practice has a number of issues to contend with, not the least of which is technology.  While IT has been serving the firm for years, shifting paradigms in computing are leading professionals to wonder exactly which direction they should turn for advice.  It’s easy, at a high level, to see the value and benefit of outsourced IT services and being able to focus on your core offerings, but it’s a little harder to find exactly which path your firm should follow.  One thing has proven true over the past few years: taking a holistic approach to cloud-enabling your firm is far better than any uncoordinated exchange of applications and services.

There are four areas the firm should explore when looking to more fully leverage technology to its benefit, which is what “cloud-enabling” the practice really means:

  1. Transitioning to a paperless (or less paper) office
  2. Exploring alternative billing methods (value versus time?)
  3. Outsourcing non-core and non-strategic tasks and processes
  4. Streamlining procedures to create consistency in service levels

The challenge is that firms have numerous options and approaches being thrown about, none of which represent obvious solutions to the entire problem.  In pieces, cloud services and online applications can deliver new capability and functionality, but a professional practice has the requirement for systems to work together to be effective.  Re-entry or redundant storage of data is inefficient, so it is difficult to streamline procedures when the systems run on different platforms or don’t integrate well.

One approach is the “hybrid” approach, where you take the best of the tried and true, and deploy it in new ways to create new capabilities.  Also introducing cloud-based and SaaS solutions where they can truly help the firm innovate makes sense, as long as those solutions can connect back to the core systems. The key is to not lose what efficiency and business intelligence the firm already has while attempting to transform and improve upon those models (digital transformation).

The new thinking by some firms is to adopt web-based practice management solutions that make it easier to collaborate with team  members and clients.  Many of these solutions get great reviews and indeed do make it easier for users to access information from anywhere and on mobile devices.  Lots of neat features for the forward-thinking practice are available, yet the problem is that these solutions usually don’t have general accounting functionality required by the business, nor do they address some of the fundamental capabilities that apps on the desktop can.

For the online applications serving line-of-business functionality, the easy answer to finance department questions is to connect to an online accounting solution, like QuickBooks Online.  While this may serve the needs of the developer, the needs of the business finance department often outpace the functionality available in the smb online accounting products.  To address this reality, many developers have created the means to export data to the QuickBooks software running on the local desktop.

The desktop editions of QuickBooks remain extremely popular with professional service firms and the businesses they serve. In a cloud and mobile world, the firm and their client doesn’t have to be tied to the local desktop in order to keep their desktop software or collaboratively work in the data.  When the QuickBooks desktop software is setup within a secure remote access environment (whether on-premises or with a hosting provider), users benefit from the same mobility and realtime collaboration advantages as with a SaaS solution, like anytime/anywhere access.

Virtual desktops and remote application models allow users to access what seems like a workstation in the cloud, with business applications such as QuickBooks and Microsoft Office and whatever else the firm uses. The desktop is a true Windows platform, so the features and functionality are just as they are when working directly on a local PC.

Most remote or virtual desktop setups also let the user access the Internet and use a browser on the remote desktop, allowing users to run the SaaS solutions they’ve subscribed to alongside their desktop applications yet still remain in a totally virtual and mobile working environment. This approach allows the firm to centralize management and administration of internal servers and networking resources, or eliminate much of the maintenance and management by outsourcing to a hosting provider. Outsourcing the hosting and management of systems further establishes predictability in cost and increases IT agility.

The thing to remember is that one size does not fit all, and every firm will need to work within their own requirements and motivations to come up with the proper approach.  What works for a solo practitioner or small firm won’t necessarily work for a larger firm… or maybe it will, depending on the company culture and structure. There are a lot of options with the cloud when it comes to outsourced information technology models, online practice management and other business solutions, and mobile services which reduce the impacts of time and distance.  It’s time to start implementing on-demand access and mobile-friendly service options before the competition leaves you behind.  Interestingly enough… the competition that looks like a huge and successful firm could be just one person using some really smart IT.

 

Make sense?

J

Posted on

One-Write System Revolutionizes Accounting

One-Write System Revolutionizes Accounting

These guys had the right idea, they just didn’t have the cloud.

It’s amazing how much time and energy continues to be spent on duplicate data entry and re-keying information generated by one system into another.  Human-based data entry is prone to errors, takes time, and carries with it the burdens of employee costs and resources.  It is a problem that businesses of all types have battled for years, but new solutions are available, and many of them are enabled via great software, the Internet and the cloud.  You see, the cloud – which is the term popularly applied to all of the interconnected “things” on the Internet – creates the path of communication which allows data to be passed to a variety of applications or systems, allowing for seamless collection, integration, and aggregation of business data.

EDI (electronic data interchange) standards have existed for quite some time, and in recent years these methods have expanded to include a variety of platforms and more open “standards-based” approaches.  Even in the small business world, business owners using traditionally limited software products are now able to enjoy sophisticated extension and integration of their applications, largely enabled and facilitated by cloud technologies and software-as-a-service offerings.

To provide a really simple example of the problem: when an individual writes a check, that check must be recorded in a variety of places and for several purposes – to record the expense and to record the reduction of funds in the account, etc.  When a product is sold to a customer, inventory is relieved, sales are increased, accounts receivable or cash is increased, costs of goods sold are experienced, and customer activity is captured.  All of this information must be recorded and the activity accounted for throughout the financial and operational systems, and can represent a tremendous burden if not automated.

One of my clients, to provide an example, sells computer parts through an ecommerce website.  Orders from this fancy website are emailed to their order operators, who then turn around and re-key the orders into the ERP system.  Because of the number of orders to enter on a regular basis, there are two different operators working in the department – both of them responsible for making sure website orders make it into the “real” operational system.

By implementing a single software solution which could take automatic transaction file exports from the ecommerce system, format them and import them into the ERP system, the company was able to reduce personnel costs, improve accuracy and timeliness of data entry, and increase customer satisfaction. If we look closely at the need to use different pieces of business information in different ways, we begin to recognize the size and complexity of the problem and the true value of these integration solutions and automation tools.

Automation takes technology, but technology doesn’t have to be complicated.  A better pencil is technology, and we figured that one out pretty well.

OK, maybe our concept of what is complicated has changed a little bit.  Remember the One-Write checkbook systems?  It was pretty cool, and truly innovative.  You put the check on a little pegboard thingy, and when you wrote the check, the check register was “automagically” filled out for you.  Amazing.  Sounds pretty simple, but take a look at the description of this innovative, highly technical device, and tell me that it wasn’t at least a little intimidating at the time. But we got used to it, didn’t we?  Maybe even liked it?

Make Sense?

J

Accountant’s Apparatus 

RECORD KEEPING SYSTEM AND METHOD EMPLOYING PLURAL FORMS AND CO-OPERATING REUSABLE ADHESIVE STRIP

United States Patent 3661407

Two different, but related form sheets are provided for use in sequence by different departments. Each form sheet has two separate pluralities of headings thereon, one for each department. Each form sheet has also one or more strip receiving spaces extending transversely across both pluralities of headings thereon. A plurality of strips of re-usable, adhesive backed writing material are provided, each strip being of a size to fit onto, and to extend the entire length of, one of said spaces. With one of the strips adhesively applied to its space on a first form sheet, data entries are made on the strip by the originating department in register with each of the headings of the first plurality thereof. The strip is then peeled off and forwarded to a follow-up department, where the strip is adhesively applied to one of the spaces provided on a second form sheet and entries are made on the strip by the follow-up department in register with each of the headings of the second plurality thereof. The completed strip is then peeled off of the second form sheet and returned to the originating department, where it is adhesively reapplied to its previous space on the first form sheet for billing and filing as a permanent record of the complete procedure.”

 And then came the portable edition for all you mobile business executives, because portability and mobility was (is) essential.

“Pocket-size one-write checkbook

United States Patent 4332400

A wallet-sized checkbook particularly suited for use in conjunction with a one-write check record keeping system wherein an entry is made on a journal page simultaneously with the writing of a check. The checkbook enables records of checks written in the field to be subsequently transferred directly on to a one-write journal page. The book comprises a cover having an interior pocket and a writing surface fastened at one end to the inside of the cover. A data sheet of coated release paper overlies the writing surface and releasably carries a series of ink-receptive strips adapted to receive ink from a carbon strip extending along the reverse side of a one-write check. A check is positioned on top of a selected strip on the data sheet by a series of pins which project through pre-punched holes in a widthwise margin of the check. Indicia on the opposite margin of the release paper cooperate with the pins to assist in the check-positioning function. Thus, data written on the front of the check is transferred via the carbon to the underlying strip which can be subsequently peeled from the release sheet and applied at the appropriate line of a journal page to provide an accurate record of the field-written check.”