Skip to main content
Planview Customer Success Center

Aggregating Financials at the Contracts level

Financial behavior at the contract level is designed to provide a consolidated financial view of professional services engagements, independent of how delivery work is structured or scheduled. Contracts represent commercial commitments, while projects, milestones, and tasks represent execution. For this reason, financial aggregation focuses on delivery outcomes rather than delivery timelines.

Aggregating financials at the contract level allows organizations to track revenue performance across multiple work items, funding sources, and delivery structures under a single commercial agreement. This approach supports financial reporting, forecasting, and integration with downstream financial and revenue recognition systems.


Contract Dates vs. Delivery Dates

Contract start and end dates represent the commercial validity of the agreement. They are intentionally not dependent on the dates of associated projects, milestones, or tasks. This separation supports common professional services scenarios such as:

  • Contracts that span multiple delivery phases implemented as separate projects

  • Delivery work that starts before or ends after formal contract dates

  • Contract renewals or amendments without immediate delivery changes

  • Parallel or overlapping delivery work under the same commercial agreement

Contract dates define commercial scope. Delivery dates define execution planning. Financial aggregation is driven by delivery activity, not by contract timelines.

clipboard_e5f65fcece9f6af7cb79fd7e07f8fc5ce.png


Example Scenario

Scenario: One Contract, Multiple Projects

  • Contract Duration: January 1 – December 31

  • Contract Value: $1,000,000

The contract includes three delivery projects:

  • Project A (January – March)

  • Project B (April – August)

  • Project C (September – February of the following year)

Each project has its own milestones, tasks, budgets, and forecasts.

How financial aggregation works:

  • Actual, budget, and forecast revenue are collected from Projects A, B, and C

  • All values are aggregated at the Contract level

  • Project C revenue is included even though it extends beyond the contract end date

  • The contract provides a single consolidated financial view across all delivery work

This ensures financial visibility remains accurate even when delivery timelines vary.


Visual Explanation (Conceptual)

Contract
│
├── Project A (Jan–Mar)
│   └── Milestones / Tasks → Revenue
│
├── Project B (Apr–Aug)
│   └── Milestones / Tasks → Revenue
│
└── Project C (Sep–Feb)
    └── Milestones / Tasks → Revenue
  • The Contract is the financial aggregation point

  • Projects, milestones, and tasks contribute revenue through direct associations

  • Aggregation is based on delivery data, not contract dates

  • Purchase Orders provide funding context but do not drive aggregation


Currency Configuration

Contracts support separate currencies for cost and revenue tracking.

  • Revenue Currency
    Defines the currency used for revenue calculations

  • Currency Exchange Rate
    Defines the exchange rate used for contract-level financials


Financial Aggregation Rules

  • Financial aggregation is calculated based on direct links to Work Items

  • Purchase Orders are not used as a source for financial aggregation

  • Aggregated financials are calculated at the parent relationship level

  • Only direct associations are included in rollups

  • No additional aggregation logic is applied beyond the defined parent relationships


Aggregated Financial Metrics

Contracts calculate the following aggregated values from directly associated work items:

  • Aggregated Actual Revenue
    Aggregates actual revenue from delivery execution

  • Aggregated Budget Revenue
    Aggregates budgeted revenue from delivery planning

  • Aggregated Forecast Revenue
    Aggregates forecasted revenue based on current delivery expectations

These aggregated values provide consistent and reliable visibility into contract-level financial performance across delivery execution.