Monday, November 30, 2009

FRx Poised to Permeate Many More General Ledgers Part Three: Market Impact continued

FRx Poised to Permeate Many More General Ledgers Part Three: Market Impact continued

Nevertheless, since FRx already has direct integration built to over forty leading mid-market general ledgers (and now a scalable tool kit available to accommodate virtually all others), the idea behind that was for users to leverage the investment they have already made in their GL and to add on increased functionality as their needs become more sophisticated. To that end, another recent addition to the FRx stable, MBS for AnalyticsForecaster (formerly FRx Forecaster), a Web-based budgeting and planning application, depending upon the GL that is in use, can work with or without FRx. The product has been delivered as to cater for the growing needs of the companies to be able to produce "rolling budgets" that account for changing conditions instead of being static quarterly reports, and often after the fact. As an integral part of their corporate performance management strategy, more nimble companies are turning to iterative, continuous budgeting, and planning processes to better manage in today's volatile business climate.

In fact, planning and budgeting have become a means of translating strategy into a coherent set of objectives, as well as a basis for assessing achievement. As planning and budgeting should be a collaborative process (a forum on the future direction of the organization), there have been indications that even during unrelenting economic pressures, corporate managers are still seeing value in providing desktop portal views of key business process analytics to an increasing number of corporate workers. As a result, many financial executives have been marking active financial planning tools as a top investment. On the other hand, the majority of those annual plans are still completed in Excel spreadsheets, which wreaks havoc for business analysts and IT as they try to figure out complicated links and how to import and export data to and from the spreadsheets.

Contrary to that, Forecaster's collaborative capabilities should save time and help improve the quality of the final budget, making it more realistic and accurate. Users can collaborate using features such as automatic e-mail notification of upcoming deadlines and a centralized bulletin board where goals, objectives, business tactics, and instructions are posted for enterprise-wide access. Through the use of memos, notes and attachments, managers can understand the rationale behind important numbers and assumptions made by other departmental managers, reducing, or eliminating time spent in meetings.

Furthermore, Forecaster lets department managers interact with each other to insure their budgets complement each other's. For example, if a department budgets for a new program that impacts other departments, all budgets can reflect the impact of the new program. With the roll ups feature, reorganizing the company's chart of accounts is facilitated, since roll ups are parent-child relationships that control how the posting data summarizes. Users can create rollups for accounts, cost centers, and for many other accounting entities they choose to use in their application by defining roll ups using Forecaster' intuitive drag-and-drop interface, then run a simple restate function to consolidate the data.

Forecaster allows managers to input their own numbers, eliminating the duplicate entry or potential for errors. Managers can readily make changes to their cost centers by entering data directly to accounts or by using copy/grow functions, calculated accounts, or spread-back methods. In addition to improving the accuracy of the numbers, Forecaster should improve the quality of the numbers because totals and consolidated numbers are available for reporting as soon as they are input. If there are any problems or any adjustments required, they can be performed immediately by those who understand the numbers. Furthermore, by simply entering a dollar or percentage change, the budget administrator can make an adjustment that will ripple through the entire plan. As a result, budgets should be completed more quickly, allowing for more iterations and "what if" analyses as necessary.

Forecaster streamlines many of the tasks that comprise the budgeting process, including individual creation of budgets, changing the budget model, budget consolidations, and reporting and collaborating with interrelated departments to improve the chances of achieving set goals. This streamlining of tasks gives managers more time to construct a thoughtful budget that is based on valid data and assumptions (e.g., headcounts, project schedules, costs, etc. can be changed and simulated to reflect different economic assumptions) and thus more predictive of the future. Accessing up-to-date and historical information from the general ledger and existing financial reports, users can budget and plan with greater precision.

Through the use of views (the reporting mechanism in Forecaster) users are able to customize and analyze information that is important to their organization. Forecaster consists of the following modules that allow users to perform customized analysis:

* Expense budgeting, allows customers to define templates specific to cost centers, and thereby enables managers to focus on the information that is important to them.

* Human resource, allows a company to better understand the effect of salary adjustments, bonuses, overtime, and benefits, given employees often account for the highest part of the expense in a company's budget.

* Capital expense, lets the company standardize the accounting of capital expenditures by cost centers;

* Revenue planning, allows customized accounts and formulas to be used to calculate revenues and cost of sales, whereby formulas can be customized to meet organizational needs such as production, staffing, raw materials, and outside revenue planning.

FRx Poised to Permeate Many More General Ledgers

Thus, the competition from more rounded BI providers, such as Cognos, Business Objects, SAS Institute, Informatica, and Hyperion, and from tier one ERP providers, will only become a greater challenge for FRx, despite many of these vendors' likely less sharp focus on financial reporting, planning, and budgeting at this stage. It will be particularly interesting to watch the approach of the parent, Microsoft, to Crystal Reports (now part of Business Objects), which made quite a splash a decade ago when selected as the reporting engine for Microsoft Visual Basic. Its technology partners largely overlap with FRx to include Best, ACCPAC, MBS, Exact Macola, and Epicor.

For example, across all Solomon series of modules, there is the OEM embedded, industry-accepted, and familiar Crystal report writer, which can publish reports directly to the Web (using an embedded Crystal Reports Smart Viewer) or into Excel. Crystal is also designed to consolidate data from existing front- and back-office applications, and provide speedy analysis and distribution of this information in a suitable reporting format. Web-enabled Crystal Enterprise allows reports to be deployed over the Internet or a corporate intranet, and to a variety of formats including XML, PDF, DHTML, RTF, Word, Excel, text, e-mail, and version 7 .rpt.

Any report can easily incorporate charts, pictures, logos, colors, field highlighting, or running totals. However, given Microsoft's intended foray into the reporting sector of the broader BI market with its recent unveiling of SQL Server Reporting Services, slated for a foreseeable future, may seriously strain the partnership with Crystal Decisions, which could deprive MBS products' users of this sleek reporting feature. While a complementary, tandem strategy is more likely than a replacement strategy, given MBS is still currently evaluating the latest offering from Crystal Decisions for incorporation in future versions of MBS's products, one can never be sure of how any co-opetitive software partnership may turn out in the end.

Also, while FRx Software and Microsoft will address the unification of the above islands of analytics under the Microsoft BI umbrella, through Web parts leveraging FRx and Forecaster data; integration to Microsoft SharePoint 2.0 and Digital Dashboards portals; more specific details are not available at this stage, which will likely mean several years lag behind competitive products.

The competition does not end with more rounded BI providers either, given a slew of slick budgeting and planning products that many go well beyond leveraging GL data. In addition to the above-mentioned BI powerhouses, Applix, Cartesis, Longview, Comshare (now part of Geac), Closedloop (now part of Lawson), OutlookSoft, Prophix, and SRC Software would be only some. For example, OutlookSoft's software allows for bidirectional data collection, analysis, and communication of information contained in internal and external data stores such as ERP and CRM systems.

Further, while FRx Software's advantage is its interface's familiar look to financial personnel, it still requires certain training, given its particular spreadsheet-like interface is not exactly Excel-like. Some competitors are lowering customer's training and ongoing costs by taking advantage of functionality in Microsoft Excel and Outlook, while streamlining consolidation and preserving data and referential integrity issues. Web services will accelerate this trend by making it easy to combine Microsoft Office functionality with corporate procedures.
Possibly the best example would be the financial reporting archrival F9 product delivered formerly by Synex Systems, and now owned by Lasata, which promotes itself with the tag line: "You know Excel ... you know F9." It also integrates with more than forty accounting packages, many of which are also from the FRx Software fold, and it can easily populate a spreadsheet with "live" data from the GL to create a custom report publishable on paper or digitally. Users can create reports for any time period, and F9 can consolidate GLs that do not share the same account structure. Another competitor, Timeline, with its slew of patented "accounting intelligent" and analytically richer products like Analyst Reporting, Analyst Filter, and Analyst Consolidations has also occupied some space and thereby limited FRx's opportunities through a number of private label agreements, such as with Sage, ACCPAC, Lawson, and Deltek Systems.

Another intruder into FRx Software's hunting grounds would be Cetova, a spin-off of consulting firm GL Associates, which has created a financial statement reporting product, C-FAR, leveraging its years of implementation experience with former J.D. Edwards World and OneWorld product lines (now part of PeopleSoft), which has been a coveted but never penetrated market for FRx. Given Geac and Lawson's recent acquisitions of former FRx Software competitors, the opportunity shrinkage for FRx is likely to occur in that manner too. To possibly wrap up FRx Software's potential market erosion, one should mention Epicor's own eIntelligence Reporting offering, as well as Bennet/Porter & Associates' Crystal Vision product's existence too.