Posts

Solver QuickStart - Power BI Financial Dashboard Categories for Dynamics 365 Finance

Acumatica and Power BI are both rapidly growing cloud software applications. Although these technologies can be used independently, customers are increasingly using them together as an integrated platform.

As executives drive their accounting teams to migrate to a modern cloud ERP system like Acumatica, senior leaders are at the same time expecting to gain the ability to perform world-class analyses with their new ERP. For that reason, evaluation teams not only have to review core ERP functionality to make sure current and future needs are met, but they also must determine the tools to use for dashboards, reporting, and planning.

Power BI has become the world’s top business intelligence (BI) solution and is the natural data visualization dashboard choice for Acumatica. It is typically deployed as a stand-alone web service from Microsoft and often includes all kinds of non-financial data as well. As with any flexible dashboard software, however, developing Power BI models can be complex, time-consuming and costly, especially when building numerous dashboards and then tailoring them to your Acumatica business dimensions. And, if the Power BI models are not built wisely it can be a daunting task to maintain them when your chart of accounts grows and when you make other changes and additions in Acumatica.

Most people that have implemented dashboard models for financial data know that it can take hundreds of hours of integration and design time before managers can enjoy their “shiny” dashboard gadgets.

This blog will focus on rapid deployment of Power BI dashboards for Acumatica, as well as several factors you may want to think about to ensure your executives’ expectations are met or exceeded when it comes to providing them with:

  • Revenue Dashboards
  • Expense Dashboards
  • Variance Dashboards
  • Exception Dashboards
  • Trend Dashboards
  • Balance Sheet Dashboards
  • KPI Dashboards
  • Benchmarking Dashboards

Why Use Stand-alone Power BI Dashboards to Compliment the Native Tools in Acumatica?

Acumatica’s native dashboards offer simple, pre-built templates, but similarly to almost any other cloud ERP system’s native or embedded dashboard options, it lacks the full flexibility that a management team usually requires when it comes to producing highly professional, automated graphical dashboards that can combine their ERP data with other important data sources.

Here is a link to a showcase that features more than a hundred dashboard examples. It provides a general idea of the capabilities in both breadth and depth that many professional reporting tools offer. It can also help you improve and democratize analyses for better, faster decisions in your business. Additional ideas can be found by trying these interactive Power BI dashboards.

Solver QuickStart Dashboard Example

Solver QuickStart Dashboard Example

Many Acumatica customers support graphical analysis needs through Excel because the software is already owned, users already know how to use it, and the interface is easy and flexible to build while maintaining the underlying formulas. However, there is a rapidly growing demand for cloud-based, best-of-breed dashboard tools like Power BI that offer a dynamic and secure user experience with rich, interactive charting and drill-down that provides real-time, self-service reporting and analysis processes.

How to Pick the Right Dashboard Solution for Acumatica

Much can be written about the best and most affordable way to deploy Power BI. Most organizations find that delivering a rich and sustainable dashboard experience to their business and office of finance users does require more than just a Power BI license. These other components include:

  • Pre-built financial dashboard templates that work out-of-the box, and that can be changed or copied to support special custom needs.
  • Financial reporting and planning that complement Power BI graphical dashboards. Here is more information about things to look for in professional reporting and planning
  • A data warehouse or staging database to organize key Acumatica data and dimensions, with the added capability to include non-ERP data in order to deliver a comprehensive, clean data model to Power BI. Read more about pre-built financial data warehouses here.

We will not go into details about dashboard software evaluation in this blog but, if you want some ideas, this other blog highlights key areas many people want in a dashboard, while this interactive tool provides a simple way to compare and score vendors. It also includes an ROI calculator to analyze the cost and benefit of alternative tools versus your current solution.

In short, progressive executive and finance teams of the 2020s want dashboard solutions that are flexible; that are closely integrated with financial reporting, budgeting and forecasting functionality; and that provide quick time to value through template-based deployment.

What Is Considered a Quick Start with a Power BI Dashboard Solution for Acumatica?

Most Acumatica customers want their connected apps, including dashboards, to be cloud based. The questions that quickly come up include: How hard is it to go beyond the native visualization tools that already come with Acumatica, and to integrate a best-of-breed tool like Power BI with the ERP? How much cost and effort does it take to get key financial dashboards up and running?

The typical answer: Weeks or months of effort and tens of thousands of dollars in services. Sometimes, the end result is static and the ability to maintain data models is complicated and hard. This often results in disappointing outcomes. However, Microsoft software partners like Solver, that work very closely with the Acumatica solution and its partner channel, have developed pre-built integrations, a data warehouse and out-of-the-box dashboards to solve these challenges. For example, Solver’s QuickStart integration to Acumatica helps a company get up and running in a single day, providing access to more than 50 pre-built Power BI financial dashboards, as well as, additional financial reports and budget input templates. All these turn-key options are available from a marketplace that continuously expands with new templates.

A note about tools that offer integrations to Acumatica:

While almost all dashboard vendors can claim to offer integration to popular ERPs like Acumatica, there can be big differences in the skill and effort involved to get such integrations ready and your financial data loaded into the reporting tool.

Generally, there are three categories of integrations, each with its own level of effort during implementation:

  • Usually gets you there: Generic integration tools that require a lot of skills and time to configure.
  • Works but often with limitations: Connectors specifically built for Acumatica, but do not include an app that configures dimensions and views in Acumatica nor pre-maps to popular fields to “light them up” for its API.
  • Quickest and easiest: Connectors specifically built for Acumatica that include an app or script(s) that properly and automatically configure dimensions and views in Acumatica and expose them to its API. This results in a “clean” data model that Power BI can easily consume. You can see an example of this type of integration here.

What Is a Cloud Dashboard Marketplace and Why Is It Important to Your Business?

While you are given a set of native dashboards with Acumatica, many companies end up designing their own graphical reports using a Power BI license. However, offering modern and flexible functionality that quickly delivers the dashboards your managers and executives need is often a pipe dream. There is at least one problem: Somebody must design all those dashboards and learn the underlying Power BI formula language referred to as “DAX”. This can be painful, especially when you consider the time and cost involved. More so if your leaders are eager and want their dashboards sooner rather than later and without a big consulting bill attached.

However, there is a growing trend for cloud business solutions to offer pre-built financial dashboards that are downloadable and ready-to-use from each vendor’s marketplace. Typically, this involves a few clicks to install and refresh the report with your own data. The process is not that different from apps you download to your iPhone or Samsung phone. For example, in Solver’s Marketplace, users can download more than 50 pre-built financial dashboards that plug right into your Power BI web service in addition to Profit & Loss Reports, Balance Sheets and other financial statements and planning input templates.

Solver QuickStart Financial Dashboard Categories for Acumatica

Solver QuickStart Financial Dashboard Categories for Acumatica

In other words, with true marketplace templates, you should be able to provide your managers with professional dashboards and reports the same day you install the reporting tool–and with no upfront formula design or Power BI model building! Now that’s a quick deployment!

Summary

For new or existing Acumatica customers, the 2020s hold a lot of promise. Acumatica is continuously improving and updating their ERP system, while a rapidly growing Marketplace of third-party apps further enhances the benefits of Acumatica. Picking the right solutions, like data visualization tools for dashboards as an example, can significantly improve your processes, save you time, and help drive faster and better decisions by putting the right information in front of your managers and executives when and where they need it.

Example of a Balanced Scorecard Report for Bank Branches

What is a Balanced Scorecard for Bank Branches?

Balanced Scorecard Reports are considered KPI tools and are used by bank executives and managers to measure branch performance. Some of the main functionality in this type of strategic report is that it presents a total score per bank branch based on a series of strategic KPIs. These include: Loan measures, Deposit measures, Profitability measures, FTE measures, and Customer measures. You find an example of this type of strategic report below.

Purpose of Balanced Scorecard Reports

Banks use Scorecard Reports to give leaders a tool to measure the success of their branches in executing on the company’s strategies. When used as part of good business practices in Executive- and FP&A Departments, a bank can improve its branch manager’s alignment with the corporate strategy and increase performance, and it can reduce the chances that branch leaders invest time and resources in areas outside of corporate plans and goals.

Example of a Balanced Scorecard Report

Here is an example of a Branch Balance Scorecard Report with strategic measures and values and scores.

Example of a Balanced Scorecard Report for Bank Branches

Example of a Balanced Scorecard Report for Bank Branches

You can find hundreds of additional examples here

Who Uses This Type of Strategic report?

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

Other Reports Often Used in Conjunction with Balanced Scorecard Reports

Progressive Executive- and FP&A departments sometimes use several different Balanced Scorecard Reports, along with profit & loss reports, 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 various bank 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

Example of a Trended Balance Sheet Report for Banks

What is a Trended Balance Sheet Report for Banks?

Trended Balance Sheets are considered analytical financial reports and are used by executives and CFOs to track monthly trends in assets, liabilities and equity. Some of the main functionality in this type of report is that it dynamically expands months across the columns based on the period you run the report for. The rows in the reports show a typical balance sheet layout with Assets, Liabilities and Equity sections and account balance details rolling up to sub-totals. The user can get further detail by drilling down on individual cells to see transaction-level information. You find an example of this type of report below.

Purpose of Trended Balance Sheet Reports

Banks use Trended Balance Sheet Reports to give executives both detailed and summarized views of assets and liabilities for each month up to the current period. When used as part of good business practices in Executive- and Financial Planning & Analysis (FP&A) departments, a bank can improve its strategies and profitability, and it can reduce the chances that leaders make poor decisions because they don’t see if a figure is a trend or an outlier.

Example of a Trended Balance Sheet Report

Here is an example of Trended Balance Sheet Report with dynamic listing of year-to-date months and rows that can expand/collapse to simplify analysis.

Example of a Trended Balance Sheet Report for Banks

Example of a Trended Balance Sheet Report for Banks

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Executives, Regional Managers, Branch Managers, CFOs, Analysts.

Other Reports Often Used in Conjunction with Trended Balance Sheet Reports

Progressive Executive- and Financial Planning & Analysis (FP&A) departments sometimes use several different Balance Sheet Reports, along with income statement variance and trend reports, cash flow statements, financial dashboards, KPI dashboards, budget 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 Trended Income Statement for Banks

What is a Trended Income Statement for Banks?

Trended Income Statements are considered core financial reports and are used by executives and branch managers to track monthly trends in revenues, expenses and profitability. Some of the main functionality in this type of report is that it dynamically expands months across the columns based on the period you run the report for. The rows in the reports are collapsed to provide an easily readable summary. Users click on the ‘+’ sign on the rows to expand and see account detail. You find an example of this type of report below.

Purpose of Trended Income Statements

Banks use Trended Income Statements to give executives both detailed and summarized views of revenues, expenses, margins and totals for each month up to the current period. When used as part of good business practices in Executive- and Financial Planning & Analysis (FP&A) departments, a bank can improve its strategies and profitability, and it can reduce the chances that leaders make poor decisions because they don’t see if a figure is a trend or an outlier.

Example of a Trended Income Statement

Here is an example of Trended Income Statement with dynamic listing of year-to-date months and rows that can expand/collapse to simplify analysis.

Example of a Trended Income Statement for Banks

Example of a Trended Income Statement for Banks

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Executives, Regional Managers, Branch Managers.

Other Reports Often Used in Conjunction with Trended Income Statements

Progressive Executive- and Financial Planning & Analysis (FP&A) departments sometimes use several different Trended Income Statements, along with income statement variance reports, balance sheets, cash flow statements, financial dashboards, budget 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 Product KPI Report for Banks

What is a Product KPI Report for Banks?

Product KPI Reports are considered operational analysis tools and are used by executives and product managers to track key production metrics by product offering and branch. Some of the main functionality in this type of KPI report is that it can be filtered by any region and period, and it provides both detailed and summarized figures. The three charts on the top of the report show: 1) New and approved applications, 2) Declined applications and customer defaults, 3) Approved amount and default amount. The main body of the report contains the same six metrics as in the charts, and the rows show product figures by bank branch. You find an example of this type of KPI report below.

Purpose of Product Reports

Banks use Product Reports to give leaders a detailed and summary view of pipeline and performance across product offerings and branches. When used as part of good business practices in Executive-, Loan- and Financial Planning & Analysis (FP&A) departments, a bank can improve its product strategies and profitability, and it can reduce the chances that decisions are being made without a near real-time picture of key product performance metrics.

Example of a Product Report

Here is an example of a Product KPI Report with metrics for applications, approvals, declined customers and defaults.

Example of a Product KPI Report for Banks

Example of a Product KPI Report for Banks

You can find hundreds of additional examples here

Who Uses This Type of KPI report?

The typical users of this type of KPI report are: Executives, Loan Managers, Product Managers, Analysts, Regional Managers, Branch Managers.

Other Reports Often Used in Conjunction with Product Reports

Progressive Executive-, Loan- and Financial Planning & Analysis (FP&A) departments sometimes use several different Product Reports, along with product dashboards, detailed and summary loan and credit card reports, profit & loss reports, balance sheets, cash flow statements, 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 Loan Performance Dashboard for Banks

What is a Loan Performance Dashboard for Banks?

Loan Performance Dashboards are considered operational analysis tools and are used by executives and loan officers to monitor approval and default trends and comparisons. Some of the main functionality in this type of dashboard is that it provides analysis from eight different perspectives including: 1) Monthly trend in total loan applications and loans approved versus declined, 2) Loans approved by product, 3) Monthly trend in loan defaults, 4) Loan approval count by branch, 5) Loan default count by branch, 6) Loan approval amount by branch, 7) Top five loan default count by branch, and 8) Top five loan default amounts by branch. You find an example of this type of dashboard below.

Purpose of Loan Performance Analysis Dashboards

Banks use Loan Performance Analysis Dashboards to give leaders an easy way to monitor loan trends and benchmark metrics across bank branches. When used as part of good business practices in Executive-, Loan- and Financial Planning & Analysis (FP&A) departments, a bank can improve its loan strategies and offerings, and it can reduce the chances that poorly designed policies leads to excessive loan defaults.

Example of a Loan Performance Analysis Dashboard

Here is an example of a Loan Performance Dashboard with monthly trends and branch comparisons.

Example of a Loan Performance Dashboard for Banks

Example of a Loan Performance Dashboard for Banks

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, Loan Managers, Analysts, Regional Managers, Branch Managers.

Other Reports Often Used in Conjunction with Loan Performance Analysis Dashboards

Progressive Executive-, Loan- and Financial Planning & Analysis (FP&A) departments sometimes use several different Loan Performance Analysis Dashboards, along with detailed and summary loan reports, profit & loss reports, balance sheets, cash flow statements, 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 CFO Dashboard for Banks

What is a CFO Dashboard for Banks?

CFO Dashboards are considered financial analysis tools and are used by CFOs and financial managers to monitor trends and budget variances for key financial metrics. Some of the main functionality in this type of dashboard is that it provides graphical analysis of eight different metrics, including: 1) Actual versus budgeted revenues by product, 2) Monthly revenue trend, 3) Actual and budget revenue comparison for departments, 4) Monthly expense trend, 5) Actual and budget revenue comparison by branch, 6) Monthly profit trend, 7) Top products by revenue, and 8) Bottom products by revenue. You find an example of this type of dashboard below.

Purpose of CFO Dashboards

Banks use CFO Dashboards to enable financial leaders to look beyond classic financial statements in their analysis. When used as part of good business practices in Financial Planning & Analysis (FP&A) departments, a bank can improve its expense control and profitability, and it can reduce the chances that any important outliers or trends are detected too late for corrective decisions.

Example of a CFO Dashboard

Here is an example of a Bank CFO Dashboard for actual and budget comparisons and trend analysis.

Example of a CFO Dashboard for Banks

Example of a CFO Dashboard for Banks

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: CFOs, Analysts, Product Managers, Budget Managers.

Other Reports Often Used in Conjunction with CFO Dashboards

Progressive Financial Planning & Analysis (FP&A) departments sometimes use several different CFO Dashboards, along with profit & loss reports, balance sheets, cash flow statements, 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 an Executive Dashboard for Banks

What is an Executive Dashboard for Banks?

Executive Dashboards are considered analysis tools and are used by leaders to track financial performance. Some of the main functionality in this type of dashboard is that it provides analysis of revenues, expenses and profit with comparisons to benchmark bank branches. The dashboard enables analysis from nine different perspectives: 1) Actual and budget revenues by branch, 2) Actual and budget expenses by branch, 3) Actual and budget profit by branch, 4) Monthly revenue trend, 5) Monthly expense trend, 6) Monthly profit trend, 7) Top five branches by revenue, 8) Top five branches by expenses, 9) Top five branches by profit. You find an example of this type of dashboard below.

Purpose of Executive Dashboards

Banks use Executive Dashboards to give leaders an easy way to review performance and benchmark financial metrics across their bank branches. When used as part of good business practices in Executive and Financial Planning & Analysis (FP&A) departments, a bank can improve its strategies and profitability, and it can reduce the chances that decision-makers lack real-time understanding of KPIs.

Example of an Executive Dashboard

Here is an example of a Bank Executive Dashboard with revenue, expense and profit comparisons across branches.

Example of an Executive Dashboard for Banks

Example of an Executive Dashboard for Banks

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, Regional Managers, Branch Managers.

Other Reports Often Used in Conjunction with Executive Dashboards

Progressive Executive and Financial Planning & Analysis (FP&A) departments sometimes use several different Executive Dashboards, along with profit & loss reports, balance sheets, cash flow statements, 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 Balanced Scorecard Report for Credit Union Branches

What is a Balanced Scorecard?

Balanced Scorecard Reports are considered KPI tools and are used by executives and managers to measure branch performance. Some of the main functionality in this type of strategic report is that it presents a total score per credit union branch based on a series of strategic KPIs. These include: Loan measures, Shares measures, Profitability measures, FTE measures, and Member measures. You find an example of this type of strategic report below.

Purpose of Balanced Scorecard Reports

Credit Unions use Balanced Scorecard Reports to give leaders a tool to measure the success of their branches in executing on the company’s strategies. When used as part of good business practices in Executive- and FP&A departments, a company can improve its branch managers’ alignment with the corporate strategy and increase its performance. It can also reduce the chances that branch leaders invest time and resources in areas outside of corporate plans and goals.

Example of a Balanced Scorecard Report

Here is an example of a Branch Balance Scorecard Report with strategic measures, values and scores.

Example of a Balanced Scorecard Report for Credit Union Branches

Example of a Balanced Scorecard Report for Credit Union Branches

You can find hundreds of additional examples here

Who Uses This Type of Strategic report?

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

Other Reports Often Used in Conjunction with Balanced Scorecard Reports

Progressive Executive- and FP&A departments sometimes use several different Balanced Scorecard tools, along with profit & loss reports, 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 various point solutions, surveys 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

Example of a Trended Balance Sheet for Credit Unions

What is a Trended Balance Sheet?

Trended Balance Sheets are considered analytical financial reports and are used by executives and CFOs to track monthly trends in assets, liabilities and equity. Some of the main functionality in this type of report is that it dynamically expands months across the columns based on the period you run the report for. The rows in the reports show a typical balance sheet layout with Assets, Liabilities and Equity sections and account balance details rolling up to sub-totals. The user can get further detail by drilling down on individual cells to see transaction-level information. You find an example of this type of report below.

Purpose of Trended Balance Sheet Reports

Credit Unions use Trended Balance Sheet Reports to give executives the ability to see trends for both detailed and summarized views of assets and liabilities for each month up to the current period. When used as part of good business practices in Executive- and Financial Planning & Analysis (FP&A) departments, a company can improve its strategies and performance, and it can reduce the chances that leaders make poor decisions because they don’t see if a figure is a trend or an outlier.

Example of an Trended Balance Sheet Report

Here is an example of a Trended Balance Sheet with dynamic listing of year-to-date months and rows that can expand/collapse to simplify analysis as well as actual to budget comparisons.

Example of a Trended Balance Sheet for Credit Unions

Example of a Trended Balance Sheet for Credit Unions

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Executives, Regional Managers, Branch Managers, CFOs, Analysts.

Other Reports Often Used in Conjunction with Trended Balance Sheet Reports

Progressive Executive- and Financial Planning & Analysis (FP&A) departments sometimes use several different Trended Balance Sheet Reports, along with income statement variance- and trend reports, cash flow statements, financial dashboards, KPI dashboards, budget 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