Posts

Example of a Balance Sheet Report for Bank Branches

What is a Balance Sheet Report for Bank Branches?

Branch-level Balance Sheets are considered essential month-end reports and are used by corporate executives and branch managers to track actual balances and variances for assets, liabilities and equity figures. Some of the main functionality in this type of report is that it enables the user to run them for any month and any bank branch, including at the consolidated level. The columns compares the current month to the same period last year as well as to the budget, and it calculates the variances and enables drill-down to detail. You find an example of this type of report below.

Purpose of Branch-level Balance Sheets

Banks use Branch-level Balance Sheets to enable variance analysis for branch-level balance sheet metrics. When used as part of good business practices in Financial Planning & Analysis (FP&A) departments, a bank can improve its fiscal- and strategic decisions, and it can reduce the chances that managers don’t quickly discover major variances and the reasons behind them.

Example of a Branch-level Balance Sheet

Here is an example of a Branch-level Income Statement Report with prior year and budget variances.

Example of a Balance Sheet Report for Bank Branches

Example of a Balance Sheet Report for Bank Branches

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Executives, branch managers, finance leader.

Other Reports Often Used in Conjunction with Branch-level Balance Sheets

Progressive Financial Planning & Analysis (FP&A) departments sometimes use several different Branch-level Balance Sheets, along with income statements, consolidated balance sheets, cash flow statements, trended financial statements, KPI reports, executive dashboards, budget models and forecasts 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

Example of an Income Statement Report for bank branches

What is a Income Statement Report for Bank Branches?

Branch-level Income Statements are considered essential month-end reports and are used by corporate executives and branch managers to track revenues, expenses and profitability. Some of the main functionality in this type of report is that it enables the user to run them for any month and any bank branch, including at the consolidated level. The columns compare the current month to the same period last year as well as to the budget, and it calculates the variances. You find an example of this type of report below.

Purpose of Branch-level Income Statements

Banks use Branch-level Income Statements to enable self-service analysis of the monthly performance of each branch, including monitoring of variances from plan and prior year. When used as part of good business practices in Financial Planning & Analysis (FP&A) departments, a bank can improve its strategic decisions and profitability, and it can reduce the chances that managers don’t quickly discover major variances and the reasons behind them.

Example of a Branch-level Income Statement

Here is an example of a Branch-level Income Statement Report with prior year and budget variances.

Example of an Income Statement Report for bank branches

Example of an Income Statement Report for bank branches

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Executives, branch managers, finance leader.

Other Reports Often Used in Conjunction with Branch-level Income Statements

Progressive Financial Planning & Analysis (FP&A) departments sometimes use several different Branch-level Income Statements, along with consolidated income statements, balance sheets, cash flow statements, KPI reports, executive dashboards, budget models and forecasts 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

Example of a Balance Sheet Report for credit union branches

What is a Balance Sheet Report for Credit Union Branches?

Branch-level Balance Sheets are considered essential month-end reports and are used by corporate executives and branch managers to track actual balances and variances for assets, liabilities and equity figures. Some of the main functionality in this type of report is that it enables the user, based on security access rights,  to run them for any month and any credit union branch, including at the consolidated level. The columns compare the current month to the same period last year as well as to the budget, and it calculates the variances. You find an example of this type of report below.

Purpose of Branch-level Balance Sheets

Credit Unions use Branch-level Balance Sheets to enable variance analysis for balance sheet metrics. When used as part of good business practices in Financial Planning & Analysis (FP&A) departments, a company can improve its fiscal- and strategic decisions, and it can reduce the chances that managers don’t quickly discover major variances and the reasons behind them.

Example of a Branch-level Balance Sheet

Here is an example of a Branch-level Balance Sheet Report with prior year and budget variances.

Example of a Balance Sheet Report for credit union branches

Example of a Balance Sheet Report for credit union branches

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Executives, branch managers, finance leaders.

Other Reports Often Used in Conjunction with Branch-level Balance Sheets

Progressive Financial Planning & Analysis (FP&A) departments sometimes use several different Branch-level Balance Sheets, along with income statements, consolidated balance sheets, cash flow statements, trended financial statements, KPI reports, executive dashboards, budget models and forecasts 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

Example of an Income Statement Report for credit union branches

What is an Income Statement Report for Credit Union Branches?

Branch-level Income Statements are considered essential month-end reports and are used by corporate executives and branch managers to track revenues, expenses and profitability. Some of the main functionality in this type of report is that it enables the user to run it for any month and any credit union branch, including at the consolidated level. The columns compare the current month to the same period last year as well as to the budget, and it calculates the variances. You find an example of this type of report below.

Purpose of Branch-level Income Statements

Credit Unions use Branch-level Income Statements to enable self-service analysis of the monthly performance of each branch, including monitoring of variances from plan and prior year. When used as part of good business practices in Financial Planning & Analysis (FP&A) departments, a company can improve its strategic decisions and profitability, and it can reduce the chances that managers don’t quickly discover major variances and the reasons behind them.

Example of a Branch-level Income Statement

Here is an example of a Branch-level Income Statement Report with prior year and budget variances.

Example of an Income Statement Report for credit union branches

Example of an Income Statement Report for credit union branches

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Executives, branch managers, finance leaders.

Other Reports Often Used in Conjunction with Branch-level Income Statements

Progressive Financial Planning & Analysis (FP&A) departments sometimes use several different Branch-level Income Statements, along with consolidated income statements, balance sheets, cash flow statements, KPI reports, executive dashboards, budget models, forecasts 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

Example of a Monthly Operating Summary Report for a Hospitality Company

What is a Monthly Operating Summary Report?

Operating Summary Reports are considered business- and departmental analysis tools and are used by financial managers and executives to analyze key metrics, revenues and profitability. Some of the main functionality in this type of report is that it combines KPIs with financial summaries. The top of the report shows charts with Total Occupied Rooms and Revenue for monthly and year-to-date (YTD) figures. The top section with figures shows KPIs with actual, budget, last year and variances. The next two sections show revenue and profitability (not visible in the screenshot below) by department. The bottom of each section shows the company-level total revenue and profit. You find an example of this type of report below.

Purpose of Monthly Operational Summary Reports

Hospitality companies use Operational Summary Reports to provide managers with a combined departmental and summary view of the company’s top metrics. When used as part of good business practices in Executive- and FP&A departments, a company can improve its operational tactics and profitability, and it can reduce the chances that leaders don’t have a convenient way to see the relationship between department and company revenue and profitability.

Example of an Operational Summary Report

Here is an example of an Operational Summary Report with monthly and YTD charts and KPIs.

Example of a Monthly Operating Summary Report for a Hospitality Company

Example of a Monthly Operating Summary Report for a Hospitality Company

You can find hundreds of additional examples here

Who Uses This Type of Report?

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

Other Reports Often Used in Conjunction with Operational Summary Reports

Progressive Executive- and FP&A departments sometimes use several different Operational Summary Reports, along with company financial statements, department P&L’s, forecast models, budgets, KPI scorecards 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

Example of a Department Dashboard for a Hospitality Company

What is a Department Dashboard for a Hospitality Company?

Departmental Dashboards are often considered revenue and expense analysis tools and are used by Finance and Department Managers to review major general ledger (GL) performance metrics and budget variances. Some of the main functionality in this type of report is that it can be filtered by department and it contains both a graphical section as well as figures (not visible in the screenshot below). The report shows three charts and include: 1) Top revenue categories ranked, 2) Top expense categories ranked, and 3) Monthly actual and budget revenue trend. You find an example of this type of report below.

Purpose of Departmental Dashboards

Hospitality companies use Departmental Dashboards to give managers an easily readable and quick snapshot of the key revenue and expense indicators. When used as part of good business practices by FP&A and by Department Managers, a company can improve its cost – and profit center tactics, and it can reduce the chances that over- or under performance in any particular department go undetected.

Example of a Departmental Dashboard

Here is an example of a Departmental Dashboard with revenue and expense analysis.

Example of a Department Dashboard for a Hospitality Company

Example of a Department Dashboard for a Hospitality Company

You can find hundreds of additional examples here

Who Uses This Type of Report?

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

Other Reports Often Used in Conjunction with Departmental Dashboards

Progressive FP&A and Department Managers departments sometimes use several different Departmental Dashboards, along with detailed F&B reports, financial statements, trail balance reports, forecast models, budgets, KPI scorecards 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

Example of a Food & Beverage Revenue Dashboard for Hospitality Companies

What is a Food & Beverage Revenue Dashboard?

Food and Beverage (F&B) Dashboards are considered revenue analysis tools and are used by Finance and restaurant managers to drill into revenues by looking at trends and comparing restaurants and F&B categories. Some of the main functionality in this type of dashboard is that it provides users with graphical analysis from eight different perspectives: 1) Breakfast revenue compared across restaurants, 2) Lunch revenue compared across restaurants, 3) Dinner revenue compared across restaurants, 4) Beverage revenue compared across restaurants, 5) Monthly revenue trend for breakfast revenue, 6) Monthly revenue trend for lunch revenue, 7) Monthly trend for dinner revenue, and 8) Monthly trend for beverage revenue. You find an example of this type of dashboard below.

Purpose of Food & Beverage Revenue Dashboards

Hospitality companies use Food & Beverage Revenue Dashboards to easily find trends and high/low performing F&B categories. When used as part of good business practices in FP&A and Operations departments, a company can improve its revenues by optimizing menu offerings and location strategies, and it can reduce the chances that poor performing F&B categories are not fixed with quick and informed decisions.

Example of a Food & Beverage Revenue Dashboard

Here is an example of a Food & Beverage Revenue Dashboard with restaurant comparisons and monthly trends.

Example of a Food & Beverage Revenue Dashboard for Hospitality Companies

Example of a Food & Beverage Revenue Dashboard for Hospitality Companies

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: Executives, CFOs, Analysts, Restaurant Managers.

Other Reports Often Used in Conjunction with Food & Beverage Revenue Dashboards

Progressive FP&A and Operations departments sometimes use several different Food & Beverage Dashboards, along with detailed F&B reports, financial statements, corporate dashboards, forecast models, budgets, KPI scorecards 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

Example of a Restaurant Performance Dashboard for Hospitality Companies

What is a Restaurant Performance Dashboard?

Restaurant Dashboards are considered performance analysis tools and are used by Finance and restaurant managers to look at essential metrics and trends. Some of the main functionality in this type of dashboard is that it provides analysis from six different perspectives, including: 1) Monthly trend in restaurant covers, 2) Revenue comparison across restaurants, 3) Top expenses, ranked, 4) Trend in food & beverage (F&B) revenues, 5) Beverage revenue ranked by category, and 6) Food revenue for breakfast, lunch and dinner. You find an example of this type of dashboard below.

Purpose of Restaurant Performance Dashboards

Hospitality companies use Restaurant Performance Dashboards to provide a high level snapshot of statistical and revenue trends and comparisons. When used as part of good business practices in FP&A  departments, a company can improve its operational tactics, and it can reduce the chances that low performing areas go under the radar with resulting lack of action.

Example of a Restaurant Performance Dashboard

Here is an example of a Restaurant Dashboard with trends and comparative metrics.

Example of a Restaurant Performance Dashboard for Hospitality Companies

Example of a Restaurant Performance Dashboard for Hospitality Companies

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: Executives, CFOs, Analysts, Restaurant Managers.

Other Reports Often Used in Conjunction with Restaurant Performance Dashboard

Progressive FP&A and Executive departments sometimes use several different Restaurant Performance Dashboards, along with detailed financial statements, corporate dashboards, forecast models, budgets, KPI scorecards 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

Example of a Hotel KPI Dashboard for Hospitality Companies

What is a Hotel KPI Dashboard?

Hotel KPI Dashboards are considered monitoring and analysis tools and are used by hotel managers and executives to get a graphical representation of essential performance metrics. Some of the main functionality in this type of dashboard is that it is parameter driven and it gives the user four different KPI views, including: 1) Monthly trend in room nights, 2) Top revenue categories ranked by amount, 3) Top expense categories ranked by amount, and 4) Monthly trend in revenues. You find an example of this type of dashboard below.

Purpose of Hotel KPI Dashboards

Hospitality companies use Hotel KPI Dashboards to give leaders a quick and easy way to see the big picture for financial metrics and occupancy. When used as part of good business practices in FP&A and Executive departments, a company can improve its strategic decisions, and it can reduce the chances that managers get lost in details and miss major trends in hotel performance.

Example of a Hotel KPI Dashboard

Here is an example of a Hotel KPI Dashboard with trends in room nights and revenue and expense comparisons.

Example of a Hotel KPI Dashboard for Hospitality Companies

Example of a Hotel KPI Dashboard for Hospitality Companies

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: CEOs, COOs, CFOs, Hotel Managers, Analysts.

Other Reports Often Used in Conjunction with Hotel KPI Dashboards

Progressive FP&A and Executive departments sometimes use several different Hotel KPI Dashboards, along with detailed financial statements, corporate dashboards, forecast models 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

Example of a Casino Game Comparison Dashboard for Hospitality Companies

What is a Casino Game Comparison Dashboard?

Game Comparison Dashboards are considered operational analysis tools and are used by casino managers and financial analysts to benchmark game metrics. Some of the main functionality in this type of dashboard is that it provides six different perspectives, including: 1) Revenue per game, 2) Monthly revenue trend, 3) Wagers per hour per game, 4) Monthly wagers trend, 5) Average bet per game, and 6) Monthly trend in average bets. You find an example of this type of dashboard below.

Purpose of Casino Game Comparison Dashboards

Hospitality companies use Casino Game Comparison Dashboards to enable performance benchmarking across the company’s game offerings. When used as part of good business practices in casino operations departments, a company can improve its game services analysis and revenue optimization, and it can reduce the chances that any individual game offering under- or over-performs without receiving proper analysis.

Example of a Casino Game Comparison Dashboard

Here is an example of a Game Comparison Dashboard with monthly trend analysis and benchmarking of revenues, average wagers and average bets.

Example of a Casino Game Comparison Dashboard for Hospitality Companies

Example of a Casino Game Comparison Dashboard for Hospitality Companies

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: Casino managers and Analysts.

Other Reports Often Used in Conjunction with Casino Game Comparison Dashboards

Progressive casino operations departments sometimes use several different Casino Game Comparison Dashboards, along with detailed gaming revenue reports, revenue budgets and forecasts, annual budgets, profit & loss reports, KPI dashboards 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