Posts

Grant Dashboard Example for Higher Education Institutions

What is a Grant Dashboard?

Grant Dashboards are considered analytical management tools and are used by grant managers and financial officers to analyze KPIs related to their grant activities. Some of the main functionality in this type of visualization report is that it gives six graphical views of important KPIs in this area. They include: 1) Granted vs requested revenue by type, 2) Granted vs requested revenue by school, 3) Granted vs requested revenue by major, 4) Grant amount trend, 5) Encumbered amount trend, and 6) Grant requested by school. Below the charts is a tabular report with the figures that support the charts. You find an example of this type of visualization report below.

Purpose of Grant Dashboards

Universities and colleges use Grant Dashboards to offer managers an easy way to get a picture of grant requests and revenues from different viewpoints. When used as part of good business practices in a Financial Planning & Analysis (FP&A) department and in an Office of Contract and Grant Administration, a higher education institution can improve its grant strategies and policies, and it can reduce the chances that the decisions related grant revenues and requests are sub optimized.

Grant Dashboard Example

Here is an example of a Grant Dashboard with requested and granted amounts as well as encumbrances.

Higher Ed – Grant Dashboard

You can find hundreds of additional examples here

Who Uses This Type of Visualization report?

The typical users of this type of visualization report are: CFOs, budget managers, analysts, deans, grant managers.

Other Visualization Reports Often Used in Conjunction with Grant Dashboards

Progressive Financial Planning & Analysis (FP&A) and Office of Contract and Grant Administration departments sometimes use several different Grant Dashboards, along with detailed grant reports, encumbrance reports, grant budgets, sources and uses of funds statements and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from grant management software and enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Higher Education - Student Enrollment Dashboard Example

What is a Student Enrollment Dashboard?

Student Enrollment Dashboards are considered operational analysis tools and are used by enrollment officers and dean of students to analyze student demographics and expected headcount. Some of the main functionality in this type of visualization report is that it provides insight into student statistics from six different KPI perspectives: 1) Applicants by semester/quarter, 2) Enrollment by ethnicity, 3) Enrollment by gender, 4) Enrollment trend, 5) Top 5 enrollment figures by school, 6) Enrollment by campus. All the figures from the charts are also listed below the dashboard in a tabular report format. You find an example of this type of visualization report below.

Purpose of Student Enrollment Dashboards

Universities and colleges use Student Enrollment Dashboards to provide their decisionmakers with an easy way to understand enrollment data. When used as part of good business practices in a Student Recruiting and Enrollment department, a higher education institution can improve its strategies and initiatives related to student headcount and demographics as well as associated financial planning. It can also reduce the chances that the employees make inferior decisions because they lack quick and easy access to these key statistics.

Student Enrollment Dashboard Example

Here is an example of a Student Enrollment Dashboard with applicant metrics and enrollment trends.

Higher Education - Student Enrollment Dashboard Example

Higher Education – Student Enrollment Dashboard Example

You can find hundreds of additional examples here

Who Uses This Type of Visualization report?

The typical users of this type of visualization report are: Enrollment officers, Dean of Students, School administrators and Planners.

Other Visualization Reports Often Used in Conjunction with Student Enrollment Dashboards

Progressive Student Recruiting and Enrollment departments sometimes use several different Student Enrollment Dashboards, along with detailed enrollment reports, student dashboards, staff and tuition revenue budgets and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from admission and enrollment management software, student information systems as well as enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Higher Education Revenue Dashboard Example

What is a Higher Education Revenue Dashboard?

Revenue dashboards are considered executive analysis tools and are used by financial officers and leaders to analyze trends and budget variances for the institution’s revenues. Some of the main functionality in this type of visualization report is that it provides insight into revenues from five different perspectives: 1) Actual versus budget for the current period, 2) Actual versus budget broken down by major revenue categories such as for Alumni, Tuition and Other, 3) Actual and budget revenue trend, 4) Revenue trend consolidated for all schools and/or campuses, and 5) Revenue for the current period broken down by detail account. You find an example of this type of visualization report below.

Purpose of Revenue Dashboards

Universities and colleges use Revenue Dashboards to provide executives with an easy, self-service method of analyzing essential revenue metrics. When used as part of good business practices in a Financial Planning & Analysis (FP&A) department, a higher education institution can improve its revenue-related strategies, and it can reduce the chances that the decisions are slowed down because managers lack clear and on-demand revenue insights.

Revenue Dashboard Example

Here is an example of a Revenue Dashboard with trends and budget variances.

Higher Education Revenue Dashboard Example

Higher Education Revenue Dashboard Example

You can find hundreds of additional examples here

Who Uses This Type of Visualization report?

The typical users of this type of visualization report are: Financial officers, executives, boards.

Other Visualization and Reports Often Used in Conjunction with Revenue Dashboards

Progressive Financial Planning & Analysis (FP&A) departments sometimes use several different Revenue Dashboards, along with  trial balances, consolidation reports, sources and uses of funds, balance sheets, KPI dashboards, transactional revenue reports and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Higher Education Reporting - Intercampus Matching Report Example

What is an Intercampus Matching Report?

Intercampus Matching Reports are considered month end closing tools  and are used by accountants to automate the reconciliation of eliminations of financial transactions when campuses lend, borrow, buy or sell to each other. Some of the main functionality in this type of matching report is that it automatically matches monthly intercampus transactions. For each “due to” and “due from” account pair, the report shows a total with a green color if there is a complete match and a red color if there is a difference. You find an example of this type of matching report below.

Purpose of Intercampus Matching Reports

Universities and colleges use Intercampus Matching Reports to automatically match internal transactions between their campuses. When used as part of good business practices in a Financial Planning & Analysis (FP&A) department, a higher education institution can improve its month end close process, and it can reduce the chances that the there are accounting mistakes when campus financials are consolidated for the entire organization and all its entities.

Intercampus Matching Report Example

Here is an example of an Intercampus Matching Report with Exception Colors and automated reconciliation.

Higher Education Reporting - Intercampus Matching Report Example

Higher Education Reporting – Intercampus Matching Report Example

You can find hundreds of additional examples here

Who Uses This Type of Matching report?

The typical users of this type of matching report are: Financial officers, controllers, accountants.

Other Matching Reports Often Used in Conjunction with Intercampus Matching Reports

Progressive Financial Planning & Analysis (FP&A) departments sometimes use several different Intercampus Matching Reports, along with  trial balances, consolidating multi-entity reports, sources and uses of funds, balance sheets and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Higher Education Reporting - Grant Summary Report with Awards and Encumbrances

What is a Grant Summary Report with Awards and Encumbrances?

Grant Summary Reports are considered grant analysis tools and are used by financial officers and grant managers to analyze financial metrics for grants. Some of the main functionality in this type of report is that it shows grant awards by school with grouping and sub-totals by grant type. In the columns, you find Granted Award, Encumbered Amount, and Balance. The chart on top of the report shows the total granted awards by grant type. You find an example of this type of report below.

Purpose of Grant Summary Reports

Universities and colleges use Grant Summary Reports to provide managers with an easy to read financial status of grants by school. When used as part of good business practices in a Financial Planning & Analysis (FP&A) department, a higher education institution can improve its grant strategies and related decisions, and it can reduce the chances that the grants are over- or under-encumbered because managers don’t keep a keen eye on grant balances.

Grant Summary Report Example

Here is an example of a Grant Summary Report with granted awards, encumbered amount and balances.

Higher Education Reporting - Grant Summary Report with Awards and Encumbrances

Higher Education Reporting – Grant Summary Report with Awards and Encumbrances

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Financial officers, grant managers.

Other Reports Often Used in Conjunction with Grant Summary Reports

Progressive Financial Planning & Analysis (FP&A) departments sometimes use several different Grant Summary Reports, along with  grant dashboards, encumbrance reports, grant detail reports, financial statements, grant budgets and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from dedicated grant management systems or enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Higher Education Reporting - Enrollment by School Example

What is an Enrollment by School Analysis Report?

Student Enrollment Reports are considered statistical analysis tools and are used by enrollment officers to monitor the enrolled student population by semester/quarter/year and by school. Some of the main functionality in this type of report is that it uses data from the student information system and can be filtered based on parameters such as school and semester (quarter). The example shows the number of enrolled students by school with sub-totals and a grand total. The pie chart helps compare each school’s enrollment to each other. You find an example of this type of report below.

Purpose of Student Enrollment Reports

Universities and colleges use Student Enrollment Reports to provide officers and other staff with an easy, self-service method to analyze student enrolled during any given academic year. When used as part of good business practices in a Student Recruiting and Enrollment department, a higher education institution can improve its strategies and initiatives related to student recruiting, retention as well as associated financial planning, and it can reduce the chances that employees make inferior decisions because they lack quick and easy access to these key statistics.

Student Enrollment Report Example

Here is an example of a Student Enrollment Report with count by school and graphical analysis.

Higher Education Reporting - Enrollment by School Example

Higher Education Reporting – Enrollment by School Example

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: University Board Members, Dean of Students, Enrollment Officers, Recruiting Managers, Planners.

Other Reports Often Used in Conjunction with Student Enrollment Reports

Progressive Student Recruiting and Enrollment departments sometimes use several different Student Enrollment Reports, along with  student dashboards, KPI dashboards, tuition revenue budgets, recruiting dashboards and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from student information systems integrated with enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Higher Education Reporting - Student Detail Report Example

What is a Student Detail Report?

Student reports are considered operational tools and are used by the Dean of Students and other administrators to view key demographic data and other information by student. Some of the main functionality in this type of report is that it it uses data from the student information system and can be filtered based on parameters such as school and year. The example shows all students in a particular school and campus, along with birth date, age, gender, ethnicity, major and GPA. You find an example of this type of report below.

Purpose of Student Detail Reports

Universities and colleges use Student Detail Reports to provide administrators with self-service, web-based access to retrieve student data in a user-friendly format. When used as part of good business practices, a higher education institution can improve its time spent to retrieve student data, and it can reduce the chances that users have to wait for days for IT or other system experts to provide them with reports.

Student Detail Report Example

Here is an example of a Student Detail report with demographics, major and GPA information.

Higher Education Reporting - Student Detail Report Example

Higher Education Reporting – Student Detail Report Example

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Dean of Students, school administrators and department heads.

Other Reports Often Used in Conjunction with Student Detail Reports

Progressive higher ed institutions sometimes use several different Student Detail Reports, along with  student dashboards, individual records by student, GPA reports and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from best-of-breed student information systems integrated with enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Higher Education Reporting - Actual versus Budget Payroll Variance Analysis

What is a Actual versus Budget Payroll Variance Report?

Payroll variance reports are considered monthly analysis tools and are used by finance and HR managers to review potential significant variances in actual employee compensation compared to the budget. Some of the main functionality in this type of report is that it it groups employees in two main categories and presents the actual salaries with a comparison to the budget and displays the difference. The two employee categories are: 1) Classified salaries with subsections for permanent and temporary positions, and 2) Unclassified salaries with subsections for permanent and temporary positions. You find an example of this type of report below.

Purpose of Actual to Budget Payroll Variance Reports

Universities and colleges use Actual to Budget Payroll Variance Reports to easily detect major differences between budgeted and actual compensation. When used as part of good business practices in a Financial Planning & Analysis (FP&A) department, a higher education institution can improve its budget accuracy and it can address any unplanned hiring or compensation discrepancies, and it can reduce the chances that the major variances goes undetected.

Actual to Budget Payroll Variance Report Example

Here is an example of a Actual versus Budget Payroll Variance Report.

Higher Education Reporting - Actual versus Budget Payroll Variance Analysis

Higher Education Reporting – Actual versus Budget Payroll Variance Analysis

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: HR managers, CFOs, budget officers, department managers.

Other Reports Often Used in Conjunction with Actual to Budget Payroll Variance Reports

Progressive Financial Planning & Analysis (FP&A) departments sometimes use several different Actual to Budget Payroll Variance Reports, along with  budget accuracy reports, detailed monthly payroll reports, HR and Payroll dashboards, financial statements and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from management systems or enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Higher Education Report Example - Comparison Between Current Year and Next Year Budgets

What is a Budget Comparison Report?

Budget comparison reports are considered budget analysis tools and are used by budget managers to provide executives with a clear picture of variances between the current and next year’s budget. Some of the main functionality in this type of budget report is that it it shows the differences between two annual budgets and displays these both as amounts and in percent. The general ledger (GL) accounts are listed down the rows with funds as the most detailed level. The report can be produced at the detailed department level or consolidated to a school or university level. You find an example of this type of budget report below.

Purpose of Budget Comparison Reports

Universities and colleges use Budget Comparison Reports to make it easy for executives to see where the major changes are in the current budget versus that of the prior year. When used as part of good business practices in a Financial Planning & Analysis (FP&A) department, a higher education institution can improve its budget accuracy, and it can reduce the chances that the major budget changes are approved without proper scrutiny.

Budget Comparison Report Example

Here is an example of a Budget Variance Report comparing the new budget with prior year’s budget.

Higher Education Report Example - Comparison Between Current Year and Next Year Budgets

Higher Education Report Example – Comparison Between Current Year and Next Year Budgets

You can find hundreds of additional examples here

Who Uses This Type of Budget report?

The typical users of this type of budget report are: Executives, budget officers, department managers.

Other Budget reports Often Used in Conjunction with Budget Comparison Reports

Progressive Financial Planning & Analysis (FP&A) departments sometimes use several different Budget Variance Reports, along with  budget accuracy reports, budget comment reports, budget dashboards, transaction detail budget reports and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from management systems or enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Higher Education Reporting - Monthly Trends in Revenues and Expenses Example

What is a Monthly Trends in Revenues and Expenses Report?

Revenue and Expense trend reports, sometimes referred to as Statement of Activity trend reports, are considered monthly financial statements and are used by finance teams and executives to easily get a broad view of financial seasonality and other trends. Some of the main functionality in this type of report is that it automatically displays actual (or budget) for all months of the year. Another popular version of this report shows rolling twelve or eighteen months in the columns. The rows are laid out like a typical sources and uses of funds financial statement. The charts on top of the report help the user visualize the key metrics. You find an example of this type of report below.

Purpose of Revenue and Expense Trend Reports

Universities and colleges use Revenue and Expense Trend Reports to easily detect month to month or quarter to quarter trends and anomalies in the organization’s financial results. When used as part of good business practices in a Financial Planning & Analysis (FP&A) department, a higher education institution can improve its speed and agility to make important business decisions, and it can reduce the chances that the avoidable outcomes are left untouched for longer than necessary.

Revenue and Expense Trend Report Example

Here is an example of a Revenue & Expense Trend Report that can be produced for actual or budgeted financials.

Higher Education Reporting - Monthly Trends in Revenues and Expenses Example

Higher Education Reporting – Monthly Trends in Revenues and Expenses Example

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: CFOs, budget managers, and analysts.

Other Reports Often Used in Conjunction with Revenue and Expense Trend Reports

Progressive Financial Planning & Analysis (FP&A) departments sometimes use several different Revenue and Expense Trend Reports, along with  monthly variance reports, balance sheets, cash flow statements, financial dashboards and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from management systems or enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples