Summary Revenue Amounts
Oracle Fusion Cloud Project Billing calculates summary revenue during revenue generation. Summarized revenue amounts enable you to identify problems with actual revenue for a contract, contract line, or the projects associated with a contract line.
After you identify problems at the summary level, review the details to determine if there are individual transactions for which revenue was incorrectly calculated.
View the actual cost and revenue for a contract, contract line, or associated project, and compare it to the following amounts and values to review profitability:
-
Actual margin
-
Actual margin percentage
-
Budget variance
-
Budget variance percentage
-
Forecast variance
-
Forecast variance percentage
Summary Revenue Amounts
The following table lists the formulas that calculate the summary revenue amounts for a contract, contract line, or associated project.
Value |
Formula |
---|---|
Actual margin |
actual margin = (actual project revenue - actual cost) |
Actual margin percentage |
actual margin percentage = (actual margin * 100) / actual project revenue |
Budget variance |
budget variance = (actual project revenue - budget revenue) |
Budget variance percentage |
budget variance percentage = (budget variance * 100 / budget revenue) |
Forecast variance |
forecast variance = (actual project revenue - forecast revenue) |
Forecast variance percentage |
forecast variance percentage = (forecast variance * 100) / forecast revenue |
Impact of Legal Entities and Multiple Contract Line Associations
Oracle Fusion Project Billing summarizes actual revenue by contract, using the ledger currency and accounting calendar from the primary ledger of the legal entity that owns the contract. Budget revenue, forecast revenue, and actual cost are summarized by project and task, using the ledger currency and accounting calendar from the primary ledger of the legal entity that owns the project.
For intercompany contracts only, the contract and associated project legal entities are not required to be identical, so the contract and project ledger currencies and accounting periods can be different. Therefore, actual contract revenue only is displayed for intercompany contracts. When a project or task is associated with multiple contract lines in the search results, actual project revenue, actual cost, budget revenue, and forecast revenue for that project or task is repeated for each contract line. This multiple reporting causes the totals (other than actual contract revenue) to be stated incorrectly. In this situation, review revenue and profitability by project in the Project Work Area or Project Manager dashboard.