Reference: Revenue Leakage Report

The

Revenue Leakage

report helps you identify where concessions are occurring on your projects. The report displays revenue leakage for the overall project, the project hours leaked, and the discrepancies between contractual and actual rates. You can also use the report to determine concession causes associated with the company, customer, project, project role, or worker. You can view:

Rate adjustments that you made.

Hours that you haven't billed.

The report uses the base currency of the company on the customer contract.

Fields	Description
Company	The company for the customer contract associated with the project.
Customer	The bill-to customer for the billable transaction.
Project Role	The project role associated with the worker for the billable transaction.
Worker	The worker associated with the billable transaction.
Billable	The total available hours to bill. The billable hours include the worker time booked against the project, project role, and worker combination.
Actual	The current hours to bill that the billing rate rules or manual overrides changed during the review billable project transaction process.
Hours Leaked	The difference between the actual hours and the billable hours.
Average Rate - Standard	The rate by project role before any negotiations or discounts. When you select the Standard Rate Sheet check box on the customer contract, Workday uses the rates that you define in the standard rate sheet. When you clear the check box, Workday uses the rates that you define in the contract rate sheet. The average standard rate takes the total billable transactions and averages the standard rate of those billable transactions.
Average Rate - Contract	The rate by project role. When you select the Standard Rate Sheet check box on the customer contract, Workday uses the rates that you define in the standard rate sheet. When you clear the check box, Workday uses the rates that you define in the contract rate sheet. The average contract rate takes the total billable transactions and averages the contract rates of those billable transactions.
Average Rate - Actual	The rate to bill the customer for a given billable transaction. The average actual rate takes the total of the billable transactions and averages the actual rates of those billable transactions.
Billable Amount	Contract Rate x Billable Hours.
Actual Amount	Actual Rate x Actual Hours.
Revenue Leakage	Actual Amount - Billable Amount.
Revenue Leakage %	Revenue Leakage / Billable Amount.
Variances - Contract Rate vs. Standard Rate	Standard Rate - Contract Rate. Variance % = (Standard Rate - Contract Rate) / Standard Rate.
Variances - Contract Rate vs. Actual Rate	Actual Rate - Contract Rate. Variance % = (Actual Rate - Contract Rate) / Contract Rate.
Variances - Standard Rate vs. Actual Rate	Actual Rate - Standard Rate. Variance % = (Actual Rate - Standard Rate) / Standard Rate.

Concept: Project Dashboard

Reference: Project Billing Reports