Finance Reports

You can generate customized spreadsheet reports using the filter and output options.

Note: Your report may look different based on the filter and output parameters you selected.

Project Finance Spreadsheet Report

This report generates a project finance report using the specified filter and output options. This CSV report is used in conjunction with the macro in the downloaded template. The Data sheet is an aggregation of project financial data based on the hierarchy configured in the finance template. The default range of the report is the current fiscal year. The report output is in CSV format.

Note: You must first download the template before you can view the output in MS Excel.

Project Detail Spreadsheet Report

This report displays a detailed project report using the specified filter and output parameters. This report is designed to be used with the macro in the downloaded template. The Data sheet shows one row per project and the default range of the report is the current fiscal year. The output is in CSV format.

Note: You must first download the template before you can view the output in MS Excel.

Financial Savings by Business Unit

This report displays financial savings by business unit using the specified filter and output options. The report groups projects by Business Unit (second level of the organization hierarchy) and displays the YTD and financial forecast for each project in the In-Realization phase. The output is in CSV format.

Financial Summary by Business Unit

This report displays the finance summary using the specified filter and output parameters. This report aggregates planed or actual finances by Group, Category, or Element for each fiscal year for all projects based on your filters. Before running this report, you must choose a Finance Template, Finance View, and a Finance Type. The available report formats are: CSV, HTML, and PDF.

Project Finances Group Aggregate

You can generate a finances group aggregate report by using the filter and output options. This report shows one row per project. It aggregates the Group 1 to Group 5 and Total financial values over a chosen date range based on the filter settings. Before running this report, you must choose a Finance Template. The output is in CSV format.

Project Finances Element Aggregate

You can generate a finances element aggregate report by using the filter and output options. This report shows multiple rows per project - one for each element configured item in the Finance Template. It aggregates finances at the financial detail level (total, group, category, element) based on the filter settings. Before running this report, you must choose a Finance Template. The report output format choices are CSV, HTML, and MS Excel.

Project Finances Element Monthly Detail

You can generate a finances element monthly detail report by using the filter and output options. This report shows multiple rows per project - one for each element configured item in the Finance Template. It displays month by month values for the date range based on the filter settings. Before running this report, you should choose a Finance Template. The report output format choices are CSV, HTML, and MS Excel.

Proposal Finances Element Monthly Detail

You can generate a proposal finances element monthly detail report by using the filter and output options. The number of rows displayed per proposal is controlled by the Finance Detail Level filter. It displays month by month values for the date range based on the filter settings. As this report only supports Plan view, you cannot use this report to compare views. Program filters are displayed only if your administrator has enabled the feature Allow Proposals in Programs. The report output format choices are CSV, HTML, and MS Excel.

Finance Validation Report

You can generate a proposal finances element monthly detail report by using the filter and output options. This report shows multiple rows per proposal - one for each element configured item in the Finance Template. It displays month by month values for the date range based on the filter settings. It displays only Plan values. Program filters are displayed only if the feature to allow Proposals in Programs is enabled.