Posts

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 Certificates of Deposit Production Trend Report for Banks

What is a Certificates of Deposit Production Trend Report for Banks?

Certificates of Deposit (CDs) Trend Reports are considered production analysis tools and are used by executives and branch managers to monitor trends and anomalies in sales of CDs. Some of the main functionality in this type of report is that it displays all the months of the year across the columns and loan metrics with totals down the rows. The far right column shows the year-to-date (YTD) figures and the bottom of the report (not visible in the screenshot below) shows grand totals for all CD types. Key figures for each CD category are: Average balance, FTP income, Interest expense, FTP income (%), Interest rate, Net interest margin, and Doc fees. For user convenience the first three of these metrics and hidden rows and can be expanded by clicking the “+” button on the rows. Examples of CD types in this report are: Retail CD (<6 months), Retail CD (6 Mo’s to 1 Yr), Retail CD (> 1 Year), Jumbo CD, and IRA. You find an example of this type of report below.

Purpose of CD Production Trend Reports

Banks use CD Production Trend Reports to give leaders and branch managers a clear picture of trends and anomalies in the CD production figures for each branch. When used as part of good business practices in Production- and Finance departments, a bank can improve its CD sales and marketing strategies, and it can reduce the chances that decision-makers lack key monthly trend insights when they create or modify CD products and terms.

Example of a CD Production Trend Report

Here is an example of a CD Production Trend Report with KPIs per CD category.

Example of a Certificates of Deposit (CD) Production Trend Report for Banks

Example of a Certificates of Deposit Production (CD) Trend 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, branch managers, product managers, finance leaders, risk managers, analysts.

Other Reports Often Used in Conjunction with CD Production Trend Reports

Progressive Production- and Finance departments sometimes use several different CD Production Trend Reports, along with detailed CD reports, CD portfolio dashboards, KPI dashboards, branch benchmarking reports, annual budgets, profit & loss trend reports, balance sheets and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from bank CD systems 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 Loan Production Trend Report for Banks

What is a Loan Production Trend Report for Banks?

Loan Production Trend Reports are considered operational analysis tools and are used by executives and loan managers to monitor trends and anomalies in branch-level and consolidated loan metrics. Some of the main functionality in this type of report is that it displays all the months of the year across the columns and loan metrics with totals down the rows. Key figures for each loan category are: Interest Rate, FTP Expense, Net Interest Margin, Loan Fees and Origination Fees. Examples of loan types in this report are: Commercial/Construction Loans, Mortgages, Consumer Loans, and Total for All Loans (not visible in the screenshot below). You find an example of this type of report below.

Purpose of Loan Production Trend Reports

Banks use Loan Production Trend Reports to give managers a clear picture of trends and anomalies in the loan portfolio of each branch. When used as part of good business practices in Loan- and Finance departments, a bank can improve its product offerings and profitability, and it can reduce the chances that decision-makers lack key monthly trend insights when they create or modify loan products and terms.

Example of a Loan Production Trend Report

Here is an example of a Loan Production Trend Report with key metrics per loan category.

Example of a Loan Production Trend Report for Banks

Example of a Loan Production Trend 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, branch managers, loan managers, finance leaders, risk managers, analysts.

Other Reports Often Used in Conjunction with Loan Production Trend Reports

Progressive Loan- and Finance departments sometimes use several different Loan Production Trend Reports, along with detailed loan reports, loan portfolio dashboards, KPI dashboards, branch benchmarking reports, annual budgets, profit & loss trend reports, balance sheets and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from loan management systems 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 Yield and Rate Analysis Report by Bank Branch

What is a Yield and Rate Analysis Report by Bank Branch?

Yield and Interest Rate Reports are considered analysis tools and are used by Executives and CFOs to analyze actual and budgeted rates and yields by branch. Some of the main functionality in this type of report is that it is parameter-driven by branch and period and it compares current month metrics with prior year and budget. The rows show interest rates, fees and yields per financial product, including: Loans, Leases, and Securities. The last section (not visible in the screenshot below) includes Demand Deposits with interest expense and interest rate. You find an example of this type of report below.

Purpose of Yield and Rate Reports

Banks use Yield and Rate Reports to enable executives and branch managers to get a single view of key financial metrics for their product offerings. When used as part of good business practices in Investment- and Finance departments, a bank can improve its product offerings and profitability, and it can reduce the chances that a branch is offering terms that not driving the same results as that of other branches.

Example of a Yield and Rate Report

Here is an example of a Yield and Rate Report by Branch with comparison of actual and budget figures.

Example of a Yield and Rate Analysis Report by Bank Branch

Example of a Yield and Rate Analysis Report by Bank Branch

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, analysts.

Other Reports Often Used in Conjunction with Yield and Rate Reports

Progressive Investment- and Finance departments sometimes use several different Yield and Rate Reports, along with securities transaction reports, investment dashboards, KPI dashboards, securities dashboards, branch benchmarking reports and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from bank systems 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 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 Securities by Category Report for Banks

What is a Securities by Category Report for Banks?

Securities Reports are considered portfolio analysis tools and are used by investment managers and analysts to monitor market- and book values of different security categories. Some of the main functionality in this type of report is that it is parameter driven and for any select group of securities it displays book- and market values as well as variances between these. The security categories are listed in the rows. Across the columns you find: Book value and its yield- and life metrics, market value with yield and life metrics, and variances between book and life metrics. You find an example of this type of report below.

Purpose of Securities by Category Reports

Banks use Securities by Category Reports to analyze book- and market value KPIs and variances. When used as part of good business practices in Investment- and Finance Departments, a bank can improve its securities strategies and profitability, and it can reduce the chances that lack of easy on-demand reports reduces the ability to make faster and better decisions.

Example of a Securities by Category Report

Here is an example of a Securities by Category Report with value and yield metrics and variances.

Example of a Securities by Category Report for Banks

Example of a Securities by Category 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: Investment managers, securities portfolio managers, analysts.

Other Reports Often Used in Conjunction with Securities by Category Reports

Progressive Investment- and Finance departments sometimes use several different Securities by Category Reports, along with securities transaction reports, investment dashboards, KPI dashboards, securities dashboards and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from securities 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

Example of a Trended Securities Summary Portfolio Report for Banks

What is a Trended Securities Summary Report for Banks?

Trended Securities Summary Reports are considered monthly trend analysis tools and are used by investment managers and analysts to monitor monthly trends in their portfolio. Some of the main functionality in this type of monthly trend report is that it dynamically lists months up to the current period across the columns with market yield in percent and amount figures down the rows. The top section (not visible in the screenshot below) shows the current market value of each security type. Color coding at the cell level helps the user quickly see high and low performing months and securities. You find an example of this type of monthly trend report below.

Purpose of Trended Securities Portfolio Reports

Banks use Trended Securities Portfolio Reports to easily discover trends and compare security values and yields. When used as part of good business practices in Investment- and Finance Departments, a bank can improve its securities strategies and profitability, and it can reduce the chances that important trends and outliers are discovered later than necessary.

Example of a Trended Securities Portfolio Report

Here is an example of a Trended Securities Summary Report with monthly values and yields by security category.

Example of a Trended Securities Summary Portfolio Report for Banks

Example of a Trended Securities Summary Portfolio Report for Banks

You can find hundreds of additional examples here

Who Uses This Type of Monthly Trend Report?

The typical users of this type of monthly trend report are: Investment managers, securities portfolio managers, analysts.

Other Reports Often Used in Conjunction with Trended Securities Portfolio Reports

Progressive Investment- and Finance departments sometimes use several different Securities Portfolio Reports, along with securities transaction reports, investment dashboards, KPI dashboards, securities dashboards and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from securities 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

Example of a Securities Summary Portfolio Report for Banks

What is a Securities Summary Portfolio Report for Banks?

Securities Portfolio Reports are considered analysis tools and are used by investment managers and analysts to monitor the market- and book values of different securities. Some of the main functionality in this type of dashboard report is that it combines charts, figures and exception highlighting to optimize analysis. The top left chart shows book value of securities on the left axis and yield on the right axis. The top right chart shows market value of securities on the left axis and yield on the right axis. The body of the report lists securities down the rows. The columns include: Book value, Gross Yield, Gross Life, Book Value Yield, Book Value Life, Market Value, Gross Yield, Gross Life, Market Yield, Market Life, Market versus Book Value Variance, Yield Variance, and Life Variance. You find an example of this type of dashboard report below.

Purpose of Security Summary Portfolio Reports

Banks use Security Summary Portfolio Reports to give managers an easy way to compare book value with market value and analyze the variances. When used as part of good business practices in Investment departments, a bank can improve its securities strategies and profitability, and it can reduce the chances that managers react slowly to significant book to market value variances.

Example of a Security Summary Portfolio Report

Here is an example of a graphical securities portfolio summary report with details for book and market value metrics.

Example of a Securities Summary Portfolio Report for Banks

Example of a Securities Summary Portfolio Report for Banks

You can find hundreds of additional examples here

Who Uses This Type of Dashboard Report?

The typical users of this type of dashboard report are: Investment managers, securities portfolio managers, analysts.

Other Reports Often Used in Conjunction with Security Summary Portfolio Reports

Progressive Investment departments sometimes use several different Security Portfolio Reports, along with securities transactions reports, investment dashboards, KPI dashboards, securities dashboards and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from securities management systems 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 Deposit and GL Reconciliation Report for Banks

What is a Deposit and GL Reconciliation Report for Banks?

Reconciliation Reports are considered data control tools and are used by accountants to help ensure that loan-related transactions tie to the General Ledger. Some of the main functionality in this type of report is that it for any given GL account chosen by the user will list and match with the related deposit transactions. In the columns display months up to the current period to make it easy to track historical balances. You find an example of this type of report below.

Purpose of Deposit and GL Reconciliation Reports

Banks use Deposit and GL Reconciliation Reports to automate and speed up the monthly close process and to ensure that data from deposit transactions match with the related GL postings. When used as part of good business practices in Accounting departments, a bank can improve its accounting staff efficiency, and it can reduce the chances that mistakes carry through to financial reports.

Example of a Deposit and GL Reconciliation Report

Here is an example of a Deposit and GL Reconciliation Report with user-defined parameters for Entity and Account.

Example of a Deposit and GL Reconciliation Report for Banks

Example of a Deposit and GL Reconciliation 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: Controllers and Accountants.

Other Reports Often Used in Conjunction with Deposit and GL Reconciliation Reports

Progressive Accounting departments sometimes use several different Deposit and GL Reconciliation Reports, along with detailed deposit reports, profit & loss reports, balance sheets, cash flow statements and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from deposit management systems for retail banks 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 Loan and GL Reconciliation Report for Banks

What is a Loan and GL Reconciliation Report for Banks?

Reconciliation Reports are considered data control tools and are used by accountants to help ensure that loan-related transactions tie to the General Ledger. Some of the main functionality in this type of report is that it for any given GL account chosen by the user will list and match with the related loan transactions. The columns list months up to the current period to make it easy to track historical balances. You find an example of this type of report below.

Purpose of Loan and GL Reconciliation Reports

Banks use Loan and GL Reconciliation Reports to automate and speed up the monthly close process and to ensure that data from loan transactions match with the related GL postings. When used as part of good business practices in Accounting departments, a bank can improve its accounting staff efficiency, and it can reduce the chances that mistakes carry through to financial reports.

Example of a Loan and GL Reconciliation Report

Here is an example of a Loan and GL Reconciliation Report with user-defined parameters for Entity and Account.

Example of a Loan and GL Reconciliation Report for Banks

Example of a Loan and GL Reconciliation 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: Controllers and Accountants.

Other Reports Often Used in Conjunction with Loan and GL Reconciliation Reports

Progressive Accounting departments sometimes use several different Loan and GL Reconciliation Reports, along with Detailed loan reports, profit & loss reports, balance sheets, cash flow statements and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from loan management systems 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