Financial Reports

The Financial Reports module provides a suite of project-level financial reports for cost analysis, budget monitoring, earned value performance, forecasting, and cash flow projections. Reports can be generated on demand with optional date range filtering and exported to PDF or Excel format.

Overview

Financial visibility is essential for managing transformation programs with significant capital investment. Project managers need to know whether spending is on track, where costs are concentrated, and what the forecast looks like for the remainder of the project. Finance teams and steering committees need standardized reports they can trust for governance decisions.

ProBeya's Financial Reports module generates seven distinct report types from a single project context. Each report provides a structured data payload suitable for chart rendering, tabular display, or document export. The reports draw from budget lines, cost entries, EVM snapshots, and WBS structures to provide comprehensive financial intelligence.

Getting Started

1. Navigate to a PPM Project and open the Financial Reports tab.
2. Select a report type from the available options.
3. Optionally set a date range to scope the report to a specific period.
4. Click Generate to view the report data.
5. Use the Export button to download as PDF or Excel.

Key Concepts

Report Types

Seven financial report types are available:

Budget vs Actual

Compares planned, committed, actual, and forecast amounts per budget category. This is the primary budget monitoring report that answers "are we spending according to plan?"

• Planned: the original budget allocation per category
• Committed: amounts obligated via purchase orders or contracts
• Actual: amounts already spent and recorded
• Forecast: projected final spend based on current trends

The report highlights categories where actual spending exceeds the budget and calculates the overall variance percentage.

CAPEX/OPEX Split

Breaks down the project budget into capital expenditure (CAPEX) and operating expenditure (OPEX) components. This report supports financial planning and compliance with accounting standards that require separate treatment of capital and operating costs.

The split shows planned vs. actual amounts for each expenditure type, with percentage distributions and variance indicators.

Cost by Category

Distributes project costs across defined categories (labor, materials, equipment, travel, external services, overhead, contingency). Each category shows its share of total cost and trend over time. This report helps identify cost concentration areas and supports category-level budget reallocation decisions.

Cost by WBS

Maps costs to the Work Breakdown Structure hierarchy, showing how spending distributes across project phases and deliverables. Each WBS element displays its planned budget, actual cost, and variance. The hierarchical view enables drill-down from summary packages to work packages.

EVM Performance

Presents Earned Value Management performance indicators in a time-series format:

• CPI (Cost Performance Index) and SPI (Schedule Performance Index) trends over time
• Current EVM indicators: EAC (Estimate at Completion), VAC (Variance at Completion), TCPI (To-Complete Performance Index)
• Performance thresholds: visual indicators for acceptable and concerning CPI/SPI ranges

This report complements the full EVM module by focusing on the financial performance narrative.

Forecast to Complete

Decomposes the Estimate at Completion (EAC) into its components:

• Budget at Completion (BAC): the original total budget
• Earned Value (EV): value of work completed
• Estimate to Complete (ETC): remaining cost to finish
• Estimate at Completion (EAC): total projected cost (EV + ETC)
• Variance at Completion (VAC): difference between BAC and EAC

The report includes confidence ranges (optimistic, most likely, pessimistic) based on CPI variance to help stakeholders understand the forecast uncertainty.

Cash Flow Projection

Projects monthly cash flow for a configurable future period (1-36 months). Each month shows:

• Planned outflows: based on budget phasing
• Projected outflows: adjusted for current spending trends
• Cumulative totals: running sum for cash requirement planning

This report supports treasury and finance teams in planning cash requirements for the project.

How It Works

Report Generation

All report procedures follow the same pattern:

1. Verify project access: confirm the project exists and belongs to the caller's organization
2. Fetch financial data: query budget lines, cost entries, EVM snapshots, and WBS elements as needed
3. Compute report data: aggregate, transform, and structure the data for the specific report type
4. Return structured JSON: the response contains the complete report payload ready for rendering

Reports are stateless -- they are generated fresh from current data on each request. There is no caching or pre-computation, ensuring reports always reflect the latest financial state.

Date Range Filtering

All reports accept optional dateFrom and dateTo parameters to scope the analysis to a specific period. When provided, only cost entries and EVM snapshots within the date range are included. Budget lines are always included in full (they represent the plan, not time-bounded actuals).

Export to PDF/Excel

The exportFinancialReport procedure accepts a report type, format (PDF or Excel), and project context. It generates the report data and wraps it in an export envelope with metadata (report type, format, project name, generation timestamp). The actual file generation is handled by the client-side rendering pipeline or a server-side report generator module.

Configuration

Setting	Location	Description
Report type	Report selection dropdown	Choose from the seven available report types
Date range	Report filter bar	Optional start and end dates to scope the analysis
Export format	Export button	PDF or Excel output format
Months ahead	Cash flow projection only	Number of future months to project (1-36, default 12)

Permissions

• View financial reports: all organization members with PPM project access
• Generate reports: all organization members with PPM project access
• Export reports: all organization members with PPM project access (no additional permission required)

Tips & Best Practices

• Start with Budget vs Actual: This is the most commonly needed report and provides the quickest overview of financial health.
• Use date ranges for periodic reporting: For monthly finance reviews, set the date range to the reporting period to isolate that month's activity.
• Cross-reference EVM Performance with the full EVM module: The financial report provides a summary view; the EVM module offers full S-curve charts and snapshot-level detail.
• Review Cost by WBS during phase transitions: At each stage-gate review, use this report to verify that spending is aligned with the current phase.
• Update cash flow projections quarterly: Cash flow projections depend on spending trends. Refresh them quarterly to keep treasury informed.
• Export reports for steering committees: PDF exports provide a standardized format suitable for offline review and archival.
• Compare CAPEX/OPEX split across projects: Use this report across multiple projects to understand the organization's capital investment profile.

Troubleshooting

Issue	Cause	Resolution
Report returns empty data	No budget lines or cost entries for the project	Ensure the project has budget data entered before generating reports.
EVM Performance shows no trends	No EVM snapshots recorded	Capture EVM snapshots periodically. See the EVM module for details.
Cash flow projection returns zero	No budget phasing configured	Set up phased budget distribution for the project.
Export returns no download URL	Server-side PDF generation not yet configured	Use client-side print/PDF functionality as an interim solution.
Cost by WBS shows flat structure	No WBS elements defined for the project	Create a WBS hierarchy before generating this report. See WBS.
Date range filter has no effect	Budget lines are always included	Budget lines represent the full plan. Only actuals and EVM data respect the date range.

Related Features

• Budgets & Costs -- Budget lines and cost entries are the primary data source for financial reports
• Earned Value Management -- EVM snapshots feed the EVM Performance and Forecast to Complete reports
• WBS -- Work breakdown structure provides the hierarchy for Cost by WBS
• Baselines -- Baseline snapshots provide the reference point for variance analysis
• Scenario Planning -- Scenario budget overrides can be compared against actual financial reports
• Product Management -- Product Lifetime Cost analysis uses the same underlying cost data