Working with Reports

Reports are spreadsheets designed to help review and analyze your organization's financial data. Axiom Financial Planning reports can query data from any table in the Axiom database. This chapter provides details about the Axiom Financial Planning reports and how to work with them.

Like plan files, reports pull data from the database and, in some cases, allow you to input data and save it back to the database. Unlike plan files, however, reports are not associated with a particular file group or forecastcapital budget year. You can use this same report to view data for any forecastcapital budget year or to compare data across multiple budget years. Reports can even incorporate data from other Axiom Healthcare Suite products, provided that you have the necessary security permissions.

After you have generated projections for various scenarios, Axiom Financial Planning offers a comprehensive library of standard reports to help analyze and compare the data. These reports take the form of spreadsheet workbooks, often with multiple graphs and charts. A few examples of Axiom Financial Planning reports include:

  • Financial Statements – Shows financials and statistics at the model or consolidation of multiple models.
  • Consolidating by Node – Shows the detail financials by node within a model for a single year.
  • Consolidating by Model-Enterprise – Financial statements for a single year shown by model.
  • Model Assumptions – Tailored financial statements report to display many of the high-level assumptions used in creating projections.
  • Payor Analysis – Shows all of the payor detail information (cases, days, visits, gross and net revenue).

You can access reports from the Financial Planning Reports section of the Fin Plan Admin or Fin Plan task pane or the Reports Library in the Explorer task pane.

A few examples of Axiom Rolling Forecast reports include:

  • RF Dept Summary – Summary for the six key performance indicators by department within the forecast group compared to the forecast group target. Used to track progress toward the forecast group targets.

  • RF FTE Summary – Used to compare FTEs for the four most recently completed quarters vs the next four quarters in the forecast.

  • RF Key Ratio Trend – Shows key ratios and performance indicators for a selected forecast group.