Revenue by Contract Dashboard

The Revenue by Contract dashboard displays actual revenue for contracts for a specified billing type, contract business unit, and accounting year ordered by contract number.

The dashboard uses the Project Billing - Revenue Real Time subject area.

The dashboard consists of the Revenue by Contract analysis and you can drill down to the following analyses from the Revenue by Contract analysis.

  • Project Revenue - Recognized Transactions

  • Project Revenue - Contract Lines

Key Insights

This dashboard answers the following business questions:

  • Which contracts have actual revenue in the current accounting year?

  • Which contracts have the lowest actual revenue in the current accounting period?

  • What is the actual revenue trend for accounting periods in the selected accounting year?

Frequently Asked Questions

The following table lists the frequently asked questions about this dashboard.

FAQ

Answer

How do I find this dashboard?

Reports and Analytics - Shared Folders - Projects - Project Financials Sample Reports

Who uses this dashboard?

  • Grants Accountant

  • Project Accountant

  • Project Manager

  • Project Team Member

When do I use this dashboard?

When you need to view contracts listed by their actual revenue values.

What can I do with this dashboard?

You can:

  • View contracts in this analysis by:

    • Accounting Year

    • Billing Type

    • Business Unit

  • Drill down to the:

    • Project Revenue - Recognized Transactions analysis using the Revenue in Ledger Currency column.

    • Project Revenue - Contract Lines analysis using the Revenue in Ledger Currency column.

What type of dashboard is this?

Oracle Transactional Business Intelligence

Details

The following table lists the prompts and filters used in the dashboard.

Column

Type

Rules

Business Unit

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

  • Default selection: All values

Accounting Year

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

  • Default selection server variable: NQ_SESSION.CURRENT_FSCL_YEAR

Billing Type

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

  • Default selection: All values

The following table lists the views in the Revenue by Contract analysis.

View

Displayed Information

View Name

Revenue by Contract

View Sections

None

Table Column and Measures

  1. Contract Business Unit

  2. Billing Type

  3. Contract Number

  4. Contract Name

  5. Contract Status

  6. Contract Start Date

  7. Contract End Date

  8. Last Recognized Date

  9. Revenue in Ledger Currency

  10. Ledger Currency

  11. Accounting Period

  12. Accounting Year