Excel Based Financial Reporting For Accountmate

F9 is an easy-to-use Financial Reporting tool that links live data from your AccountMate General Ledger (GL) to Microsoft Excel.

If you use Excel, then you already know how useful spreadsheets are for financial reporting. F9 provides a direct 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. F9 offers an unbeatable feature package including flexible cell based reporting, consolidations, drill down, budgeting, multiple date ranges, multi-currency, lists of account segments and report analysis. It does all of this while being dynamically hotlinked to the GL, ensuring that all numbers are timely, consistent and complete.

SPEED, POWER AND EASE OF USE

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.

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.

BUDGET WRITE-BACK

Budget Write-back allows you to create or edit your budgets inside Excel and then write the budget information back into the GL for subsequent reporting. Create customized financial reports in Excel, quickly and accurately – with no rekeying.

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 in 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.