Posts

pic 1

An increasing number of companies are adding subscriptions as one of the revenue models to their business. Two different examples of this service include:

  • Netflix, which is a 100% subscription-based company focused on B-to-C, or business to consumers.
  • Microsoft, which originated in an era where software sold as one-time licenses, has today become an increasingly subscription-based software provider, with most of their software delivered in a software-as-a-service (SaaS) model using their Azure cloud.

As companies begin to adopt subscription-based revenue models for their customers, accounting departments and finance teams find themselves in a new struggle. Tasks that once were relatively easy in a world of “one and done” sales deals, like invoicing, reporting and analysis, and budgeting for various types of subscription contracts can now be quite complex and time consuming. On top of that, companies now have to deal with monthly, annual and multi-year subscriptions. Other challenges center around existing customers and adding to or removing from their contracts, as well as, customer churn (cancelled subscriptions), and other complexities.

However, today’s customers using Microsoft’s two cloud accounting systems, Dynamics 365 Finance and Dynamics 365 Business Central are in luck. A Canadian software vendor by the name of Binary Stream has developed an add-in module called “Subscription Billing Management” (SBM), which in short allows accountants to elegantly manage their subscription contracts right within their Dynamics ERP system.

So, What About the Reporting, Budgeting and Forecasting for Subscription Data?

In collaboration with Binary Stream, the U.S.-based company, Solver, has expanded its Microsoft Dynamics 365 Finance and Dynamics 365 Business Central integrations to include key information from Binary Stream’s Subscription Billing Management app.

Solver is a modern Microsoft Azure-based, multi-tenant cloud solution that automates and streamlines reporting and planning processes. It is often referred to as a Corporate Performance Management (CPM) solution.

With Solver integrated to the Dynamics ERPs, as well as the Binary Stream app, customers benefit from financial and operational reporting that includes their subscription data, all in one single cloud portal. Furthermore, they can use Binary Stream SBM’s subscription data as a basis for single and multi-year revenue forecasts.

What are Examples of Subscription Reports and Budgets?  

The following are examples of specific reports and budget input forms created in Solver and based on actual subscription data flowing in from the integration available through Binary Stream’s SMB for Microsoft Dynamics app.

This first example shows a multi-year forecast going up to 10 years into the future. Based on the drivers seen in the yellow cells in the top left corner, the user can quickly generate monthly and annual subscription revenue forecasts.

Multi-year subscription revenue and churn budgeting and forecasting with monthly detail

Multi-year subscription revenue and churn budgeting and forecasting with monthly detail

When it comes to reporting, a flexible report writer like the one in Solver, can provide a multitude of report types to slice and dice subscription related data by metric, customer, and product.

The report below shows monthly recurring revenue (MRR) with metrics for new sales, upgrades/downgrades and churn. It also shows the monthly trend for the ending MRR.

Dashboard analysis of subscription metrics like MRR and Churn

Dashboard analysis of subscription metrics like MRR and Churn

The report below shows a chart and data on an eight-quarter rolling basis. This makes it easy for users to analyze subscription revenue over multiple years. Any individual quarterly column can be expanded to display detail for the three underlying months.

Eight quarter rolling subscription revenue report with monthly detail

Eight quarter rolling subscription revenue report with monthly detail

The Scheduled Billing report example seen below can be run for any given period. It helps accountants see the specific payment status per invoice per customer, including total, balance, deferred and recognized amounts.

Scheduled billing report showing recognized and deferred revenue per customer

Scheduled billing report showing recognized and deferred revenue per customer

Sometimes the finance team needs to analyze deferred revenue by customer. The example below shows deferrals by month for the remainder of the current year and then displays the summary for the next three years into the future.

Multi-year deferred revenue by customer report for the next three years

Multi-year deferred revenue by customer report for the next three years

In conclusion, as a company with a subscription-driven business model, you have a solid cloud-based accounting system with Microsoft Dynamics Finance or Dynamics Business Central. When adding Binary Stream’s app for Subscription Billing Management, you get a specialty add-in that is completely focused on helping you manage your subscriptions. By connecting Solver’s cloud-based reporting and planning solution, you now have a best-in-class suite to not only help with day-to-day accounting and analysis, but can also keep a keen eye on the future with world-class budgeting and forecasting functionality.

Strategic KPI Report Example

What is a Strategic KPI Report?

Strategic KPI reports are considered executive dashboards and are often used by leadership teams to quickly determine how the organization is performing in key areas. Some of the key functionality in this type of dashboard report is that it provides the metrics in a professional and easy to read layout. It also displays top KPIs graphically in the charts at the bottom. Exceptions that breach target thresholds are highlighted with red or green background. The far right columns display KPI targets for the coming four years. You find an example of this type of dashboard report below.

Purpose of Strategic KPI Reports

Companies and organizations use Strategic KPI Reports to make it easy for their management teams to monitor the company’s most important performance indicators. When used as part of good business practices in a Financial Planning & Analysis (FP&A) Department, a company can improve its control and ensure that leadership teams prioritize the things that matter the most as well as reduce the chances that performance in strategic areas doesn’t get timely attention.

Strategic KPI Report Example

Here is an example of a Strategic KPI Report with metrics, multi-year targets and charts.

Strategic KPI Report Example

Strategic KPI Report Example

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: Boards and Executives.

Other Dashboard reports Often Used in Conjunction with Strategic KPI Reports

Progressive Financial Planning & Analysis (FP&A) Departments sometimes use several different Strategic KPI Reports, along with financial reports, operational reports, 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

KPI Alert Report Example

What is a KPI Alert Report?

KPI Alert Reports are considered exception reports and are often used by Executives, accountants or department managers to detect problems or opportunities as indicated by the alerts. Some of the key functionality in this type of report is that it can be automatically run at any frequency and distributed by email as often as needed. KPI owners can also run the report on demand. The KPI page itself acts like a summary dashboard and the other tabs in the book provides reports with supporting detail. You find an example of this type of report below.

Purpose of KPI Alert Reports

Companies and organizations use KPI Alert Reports to ensure that management teams at any time are being notified if there is an issue or an opportuntiy as indicated by a KPI breaching a threshold. When used as part of good business practices in a Financial Planning & Analysis (FP&A) Department, a company can improve its speed to detect and resolve issues as well as reduce the chances that a problem is brewing without anyone noticing.

KPI Alert Report Example

Here is an example of a KPI Alert Report book with supporting detailed reports on the other tabs.

KPI Alert Report Example

KPI Alert 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: CFOs, Accountants and Department Managers.

Other Reports Often Used in Conjunction with KPI Alert Reports

Progressive Financial Planning & Analysis (FP&A) Departments sometimes use several different KPI Alert Reports, along with financial reports, operational reports, 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

 

Top 10 KPI Report with 13 Month Rolling Trend Analysis Example

What is a Top 10 KPI Report with 13 Month Rolling Trend Analysis?

Top KPI trend reports are considered dashboards and are often used by CFOs and Executives to analyze trends and current statuses for the company’s most important key performance indicators (KPIs). Some of the key functionality in this type of report is that it the KPI page itself is very graphical with dynamic, rolling 13 month trend charts. Also, the current month is highlighted as a number in each chart. Maybe most useful is that this KPI dashboard is part of a complete report book with many other supporting reports that offers drill down into transactional detail. These can be seen in the example as additional tabs. You find an example of this type of report below.

Purpose of Top KPI Trend Reports

Companies and organizations use Top KPI Trend Reports to quickly see how each of their most important metrics are trending over the past 13 months. When used as part of good business practices in a Financial Planning & Analysis (FP&A) Department, a company can improve its ability to discover trends and drill down into the underlying reasons as well as reduce the chances that important exceptions or shifts in the business goes undetected.

Top KPI Trend Report Example

Here is an example of a report book with a Top 10 KPI dashboard with 13 month rolling trend charts and supplemental reports on the other tabs.

Top 10 KPI Report with 13 Month Rolling Trend Analysis Example

Top 10 KPI Report with 13 Month Rolling Trend Analysis Example

You can find hundreds of additional examples here

Who Uses This Type of Report?

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

Other Reports Often Used in Conjunction with Top KPI Trend Reports

Progressive Financial Planning & Analysis (FP&A) Departments sometimes use several different Top KPI Trend Reports, along with financial reports, operational reports and other management and control tools.

Where Does the Data for Analysis Originate From?

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

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

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

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

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

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Exception Report Focused on User Comments Example

What is an Exception Report Focused on User Comments?

Exception Reports are considered analytical tools and are often used by analysts and accountants to quickly find items from the monthly financials where users made comments. Some of the key functionality in this type of report is that it automatically tracks all account balances where users entered comments. It then displays the department, account and comment, along with the monthly and year-to-date figures. You find an example of this type of report below.

Purpose of Exception Reports with Comments

Companies and organizations use Exception Reports with Comments to present all user comments from the financial statements in a single report for easy review. When used as part of good business practices in a Financial Planning & Analysis (FP&A) Department, a company can improve its tracking of variances that likely are of significance because the users made comments there, as well as reduce the chances that executives and managers miss user comments and never take action.

Exception Reports with Comment Example

Here is an example of an Exception report that displays all financial items where users made comments.

Exception Report Focused on User Comments Example

Exception Report Focused on User Comments Example

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: CFOs, Controllers and Accountants.

Other Reports Often Used in Conjunction with Exception Reports with Comments

Progressive Financial Planning & Analysis (FP&A) Departments sometimes use several different Exception Reports with Comments, along with monthly 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

Cash, AR and Expense Trend Analysis Dashboard Example

What is a Cash, AR and Expense Trend Analysis Dashboard?

Expense and liquidity-related dashboards are considered operational dashboards and are often used by Executives and CFOs to perform trend and comparative analysis. Some of the key functionality in this type of report is that it dynamically displays the past 15 months of salaries, sales & marketing expenses, cash and receivables. It also shows the mont-over-month change in cash. The charts makes it easy to follow the trends. At the bottom of the report, below the charts, there is a numerical data section. You find an example of this type of report below.

Purpose of Expense and Liquidity Dashboard Reports

Companies and organizations use Expense and Liquidity Dashboard Reports to track trends and discover anomalies in key metrics that drive cost, profitability and available funds. When used as part of good business practices in a Financial Planning & Analysis (FP&A) Department, a company can improve its focus on expense and liquidity analysis as well as reduce the chances that managers react late to opportunities or exceptions that require their attention.

Expense and Liquidity Dashboard Report Example

Here is an example of a Cash, AR and Expense Trend Analysis Dashboard with 15 month rolling trend charts.

Cash, AR and Expense Trend Analysis Dashboard Example

Cash, AR and Expense Trend Analysis Dashboard Example

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: CFOs, Analysts and Executives.

Other Reports Often Used in Conjunction with Expense and Liquidity Dashboard Reports

Progressive Financial Planning & Analysis (FP&A) Departments sometimes use several different Expense and Liquidity Dashboard Reports, along with revenue dashboards, financial statements and other management and control tools.

Where Does the Data for Analysis Originate From?

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

Rolling Revenue Trend Analysis dashboard Example

What is a Rolling Revenue Trend Analysis?

Revenue dashboards are considered essential analytical reports and are often used by Executives, VP of Sales and CFOs to analyze trends in revenues and their causes. Some of the key functionality in this type of report is that it dynamically displays the past 15 months of revenues. It also shows column charts for the current fiscal year compared to last year and budgets. Furthermore, it displays a ranked list of each major revenue component. Finally, in the trend chart in the upper right hand corner of the example below the report automatically predicts the next three months based on historical data. At the bottom of the report, below the charts, there is a numerical data section. You find an example of this type of report below.

Purpose of Revenue Dashboard Reports

Companies and organizations use Revenue Dashboard Reports to enable managers to go beyond the numbers and allow the charts to tell the revenue story. When used as part of good business practices in a Financial Planning & Analysis (FP&A) Department, a company can improve its ability to quicker and easier detect upswings and downturns in sales and other revenues as well as reduce the chances that trends and anomalies goes under the radar.

Revenue Dashboard Report Example

Here is an example of a graphical Revenue Dashboard with rolling 15 month- and comparative charts.

Rolling Revenue Trend Analysis Dashboard Example

Rolling Revenue Trend Analysis Dashboard Example

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: VP of Sales, CFOs, Analysts and Executives.

Other Reports Often Used in Conjunction with Revenue Dashboard Reports

Progressive Financial Planning & Analysis (FP&A) Departments sometimes use several different Revenue Dashboard Reports, along with sales reports, profit & loss 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

Graphical Cash Flow Analysis Tool and Dashboard Report Example

What is a Graphical Cash Flow Analysis Tool and Dashboard Report?

Cash Flow Analysis tools are considered key corporate reports and are often used by CFOs and Analysts to monitor and predict liquidity. Some of the key functionality in this type of report is that it first (see tabs at bottom of image below) provides 13 months of trended profit & loss, balance sheet and cash flow data. Then this data is utilized to present the graphical flow chart that ultimately shows the company’s cash position and related trends. The percent metrics shows the year-over-year change for the current month. You find an example of this type of report below.

Purpose of Cash Flow Analytical Tools

Companies and organizations use Cash Flow Analytical Tools to easily detect trends both in the revenues, expenses and balance sheet items that drive cash flow, and the resulting cash position. When used as part of good business practices in a Financial Planning & Analysis (FP&A) Department, a company can improve its liquidity analysis as well as reduce the chances that the FP&A team discover issues with cash drivers after they already have become a problem.

Cash Flow Analytical Tool Example

Here is an example of a graphical Cash Flow Analysis tool with 13 month trended financial statements (see tabs at bottom of image).

Graphical Cash Flow Analysis Tool and Dashboard Report Example

Graphical Cash Flow Analysis Tool and Dashboard 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: CFOs, Analysts and Executives.

Other Reports Often Used in Conjunction with Cash Flow Analytical Tools

Progressive Financial Planning & Analysis (FP&A) Departments sometimes use several different Cash Flow Analytical Tools, along with dashboards, regular 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

Monthly Cash Flow Statement with Current and Prior Month Figures Example

What is a Monthly Cash Flow Statement with Current and Prior Month Figures?

Monthly Cash Flow reports are considered essential month-end financial statements and are often used by CFOs and Analysts to review the cash inflows and outflows of the business. Some of the key functionality in this type of report is that it is parameter driven so the figures are presented automatically when the user runs the report. This layout is showing an indirect cash flow report layout. You find an example of this type of report below.

Purpose of Monthly Cash Flow Statements

Companies and organizations use Monthly Cash Flow Statements to closely monitor the cash inflows and cash outflows that drive the overall cash position of the business. When used as part of good business practices in a Finance and Accounting Department, a company can improve its liquidity analysis as well as reduce the chances that the company runs into an unexpected cash crunch.

Monthly Cash Flow Statement Example

Here is an example of a Monthly Cash Flow Statement with columns for current and prior month figures.

Monthly Cash Flow Statement with Current and Prior Month Figures Example

Monthly Cash Flow Statement with Current and Prior Month Figures Example

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: CFOs, Controllers and Accountants.

Other Reports Often Used in Conjunction with Monthly Cash Flow Statements

Progressive Finance and Accounting Departments sometimes use several different Monthly Cash Flow Statements, along with monthly profit & loss, balance sheet reports and other management and control tools.

Where Does the Data for Analysis Originate From?

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

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

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

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

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

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Trended Profit & Loss Report for Current versus Last Year Example

What is a Trended Profit & Loss Report for Current versus Last Year?

Trended, current versus last year financial statements are considered comparative reports and are used by CFOs and financial managers to discover signficant trends and anomalies. Some of the functionality in this type of report is that it dynamically displays all periods up to the current month for this year as well as for last year. It also provides year-over-year variances for each month. Also, each year can be expanded and collapsed for easier readability of the report. You find an example of this type of report below.

Purpose of Comparative Multi-Year Profit & Loss Reports

Companies and organizations use Comparative Multi-Year Profit & Loss Reports to make it easy to find trends and anomalizes. When used as part of good business practices in a Finance and Accounting Department, a company can improve its ability to detect financial issues or opportunities as well as reduce the chances that managers limit their analysis to monthly, year-to-date and budget variances.

Comparative Multi-Year Profit & Loss Report Example

Here is an example of a trended Profit & Loss Report that displays individual months for current and last year with variances.

Trended Profit & Loss Report Example for Current versus Last Year

Trended Profit & Loss Report Example for Current versus Last Year

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Executives and Financial Managers.

Other Reports Often Used in Conjunction with Comparative Multi-Year Profit & Loss Reports

Progressive Finance and Accounting Departments sometimes use several different Comparative Multi-Year Profit & Loss Reports, along with trended 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 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