Posts

Revenue and Expense Exception Report Example

What is a Revenue and Expense Exception Report?

Exception Reports are considered monthly analysis tools and are often used by Controllers and Analysts to quickly and easily find budget variances. Some of the key functionality in this type of report is that it shows all key GL dimensions in the rows with their monthly balance for actual, budget and variance. This allows the user to see across all companies, departments and accounts in one single report. The sort feature on the columns and the traffic lights highlights key budget variances. You find an example of this type of report below.

Purpose of Revenue and Expense Exception Reports

Companies and organizations use Revenue and Expense Exception Reports to allow a user to detect significant positive or negative budget variances. When used as part of good business practices in a Finance & Accounting Department, a company can improve its budget variance analysis as well as reduce the risk that major budget variances (by amount or percent) go undetected.

Revenue and Expense Exception Report Example

Here is an example of a Revenue and Expense Exception Report to help find budget variances across all accounts and entities in the organization.

Revenue and Expense Exception Report Example

Revenue and Expense Exception Report Example

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Group Controllers and Analysts.

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

Progressive Finance & Accounting Departments sometimes use several different Revenue and Expense Exception Reports, along with trial balances, financial statements 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

Multi-Year Forecast Input Template Example

What is a Multi-Year Forecast Input Template?

Multi-Year Forecasts are considered strategic planning tools that are used by executives and budget managers to get a long term perspective on the organization’s financial outlook. A key functionality in this type of planning template allows input of next year’s budget at the monthly level, while the following years are entered as quarterly figures. The row level data can be entered by GL account or at a more summarized level. You will find an example of this type of planning template below.

Purpose of Multi-Year Forecasts

Companies and organizations use Multi-Year Forecasts to enable executives and planning managers to get a long term perspective of key revenues, expenses and other relevant metrics. When used as part of good business practices in a Financial Planning & Analysis (FP&A) Department, a company can improve its decision-making capability as well as mitigate the risk that the company makes short term decisions that are misaligned with its long range direction.

Multi-Year Forecast Example

Here is an example of a Multi-Year forecast template that enables input of a 5 year plan.

Multi-Year Forecast Input Template Example

Multi-Year Forecast Input Template Example

You can find hundreds of additional examples here.

Who Uses This Type of Planning Template?

The typical users of this type of planning template are: The Board of Directors, Executives, CFO and the Budget Manager.

Other Planning templates Often Used in Conjunction with Multi-Year Forecasts

Progressive Financial Planning & Analysis (FP&A) Departments sometimes use several different Multi-Year Forecasts, along with strategic plans, Key Performance Indicators (KPIs) 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 SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Netsuite and others.

In analyses where budgets or forecasts are used, the 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) Technology Solutions and More Examples

Department Revenue and Expense Forecast Form

What is a Department Revenue and Expense Forecast Form?

Financial forecasts by department are considered important corporate planning tools and are used by budget managers and department heads to manage revenues and expenses and to replace annual budget figures. One key functionality in this type of forecast form allows users to view actual historical amounts through the current month and input forecast amounts for the rest of the year. You will find an example of this type of forecast form below.

Purpose of Departmental Forecast Forms

Companies and organizations use Departmental Forecast Forms to replace annual budgets for the current year and have a fresh outlook for the remaining periods. When used as part of good business practices in a Financial Planning & Analysis (FP&A) and Accounting Department, a company can improve its planning accuracy and its use of resources, as well as reduce the risk that the company completely misses its financial targets.

Departmental Forecast Form Example

Here is an example of a parameter-driven forecast input template by GL account and department.

Department Revenue and Expense Forecast Form

Department Revenue and Expense Forecast Form

You can find 100’s of additional examples here.

Who Uses This Type of Forecast Form?

The typical users of this type of forecast form are: CFOs, controllers, budget managers and department heads.

Other Forecast Forms Often Used in Conjunction with Departmental Forecast Forms

Progressive Financial Planning & Analysis (FP&A) and Accounting Departments sometimes use several different Departmental Forecast Forms, along with sales forecasts, cash flow plans 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 SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Netsuite and others.

In analyses where budgets or forecasts are used, the 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) Technology Solutions and More Examples

Expense Budget Input Form with Line Item Detail

What is an Expense Budget Input Form with Line Item Detail?

Departmental expense budget input forms are considered to be a key element in the annual budget process and are used by budget managers to plan for next year’s general ledger (GL) expenses. Some of the key functionality in this type of budget form allows users to input the company’s expenses by department, and typically includes features like spreading of annual totals and textual comments. You find an example of this type of budget form below.

Purpose of Departmental Expense Budgets

Companies and organizations use Departmental Expense Budgets to plan for future expenses and related profitability. It also helps them to set spending thresholds for their managers. When used as part of good business practices in a Planning & Budgeting Department, a company can improve its expense control as well as reduce the risk that department heads don’t feel any ownership in the company’s overall performance.

Departmental Expense Budget Example

Here is an example of a budget input form used by department managers and it includes various features such as comments, spreading, and line items detail.

Department Expense Budget Input Form with Line Item Detail

Expense Budget Input Form with Line Item Detail

You can find 100’s of additional examples here.

Who Uses This Type of Budget Form?

The typical users of this type of budget form are: CFOs, Budget Managers, and Department Heads.

Other Budget Forms Often Used in Conjunction with Departmental Expense Budgets

Most Planning & Budgeting Departments use several different Departmental Expense Budgets, along with input templates for payroll, capital expenses, sales 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 SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Netsuite and others.

In analyses where budgets or forecasts are used, the 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) Technology Solutions and More Examples

Bank CFO

  The focus of this article will be on balanced scorecards for banks.  Implementation of the balanced scorecard for banks and financial institutions is a very tricky thing, according to BSC Designer, as there is huge temptation to focus on financial indicators only.  We all know that banks work with money to make more money.  […]

This article will focus on what you will be looking for in a Performance Management Tool for Banks.

 

Image taken from Shutterstock.

Image taken from Shutterstock.


What is Performance Management?  According to the Harvard Business School, performance measurement focuses on four main areas:
-Communicating with external investors to ensure that a firm’s securities are fairly priced and that they are able to access capital
-Measure and evaluate a firm’s economic performance
-Improve resource allocation and strategy implementation within a firm
-Build accountability for performance through effective external and internal governance
 
The emphasis of this article will be on improving resource allocation and strategy implementation, specifically for banks.  Though banks have evolved over time, their basic function is to take in deposits and reinvest those funds back into the community in the form of loans for such things as houses, cars, education, and infrastructure.
Read more