• toll free 888.419.1939
  • Follow us on linkedin
  • Follow us on twitter

Guide TechnologiesGuide Technologies

The ERP Experts for Today’s Complex Manufacturer

PDF Document Download

F9 is an easy-to-use financial reporting tool that dynamically links General Ledger (GL) data to Microsoft Excel and is available for over 150 different accounting and ERP systems. It provides a significant scope of reporting functions all within one simple GL function.

Link your GL to Excel for powerful, automated reporting capabilities

What It is

If you use Excel, then you already know how useful spreadsheets are for financial reporting. F9 provides a dynamic link from your GL to Excel and gives you the most current information with a push of a button with no exports or manual entries required.

What It Means

With Infor F9, your organization will be able to:

  • Maximize accounting resources
  • Enhance productivity
  • Deliver in-depth flexible reporting
  • Free up technical resources due to ease of use for non-technical staff
  • Improve profitability
  • Save time and money

What It Does

F9 offers unbeatable features including:

  •  Flexible Cell Based Reporting
  • Consolidations
  • Drill Down
  • Budgeting
  • Multi-currency
  • Report Analysis
  • Pivot Table Reports
  • Dashboards
  • Web Reporting
  • Report Scheduling

It does all this while being dynamically linked to the GL, ensuring that all numbers are timely, consistent and complete.

The true value of F9 becomes apparent when you realize the scope of reporting functions that become available with this one simple GL function. When one GL function is entered once and then copied to other cells the report grows. New data columns are created by copying existing columns and editing the heading. A one month report becomes a 12 month report with one copy command! No need to manually rekey numbers. Everything you know about your spreadsheet can be applied to the reports you create using F9. Use Excel’s functionality to add graphs, buttons and backgrounds to your reporting systems. You already know how to use your spreadsheet therefore you already know how to use F9.

  • Report wizard: The F9 Report Wizard allows you to go from a blank spreadsheet to a fully formatted, hotlinked report in just seconds! Follow a graphical representation and step by step procedure; point and click your way to a finished report complete with F9’s formulas, automatically. It is so powerful; it’s the only feature many people need to use. Leverage your knowledge of Excel to get started immediately.
  • Drill down: No financial reporting application would be complete without drill down capabilities. F9’s drill down lets you analyze any balance by the various account code segments or by the general ledger transactions that created it. You can also make use of the drill results in the body of the report for trend analysis or other purposes. Drill down lets you explore the numbers in your reports to their origins.
  • Consolidation: F9 can consolidate general ledgers that do not share the same account structures or are from different accounting systems. All with the push of a button.
  • Report analysis:  Analyze by various criteria such as multi-company or multi-department reports and see which accounts are missing or duplicated.
  • Mining information with F9: Take any slice of data to create a report or do analysis. F9’s hotlink technology makes your most critical business data (your general ledger) instantly accessible, solving the biggest concerns accountants have about their financial systems. Report on any date range. Many businesses require reporting for other than fiscal periods.  Manufacturing, distribution, non-profit organizations, etc. rely on evaluating information from many non-standard date ranges. With F9, you can create reports for any date range you want; a day, a week, a weekend, whatever makes sense for your particular business.
  • Report automation: Create a full-featured production reporting interface for generating consistent reports on a monthly, weekly or even daily basis. F9 allows you to define and design your report quickly and easily through drop down menus and graphics.
  • Report migration: F9 reports grow with your business, if and when you change your accounting database to another version or product, F9 reports can easily be migrated. F9 is customizable to any accounting or ERP package. F9 can be custom configured to any accounting or ERP package within a matter of days.
Guide Technologies