Reference: Revenue Leakage Report

This report serves both operational and financial users to help identify where concessions are occurring on your projects. The report displays revenue leakage for the project overall, as well as project hours leaked, and the discrepancies between contractual versus actual rates. As a result, you can determine concession causes, such as the customer, the project, or the worker. This report displays the underlying details behind:

Any rate adjustments you've made.

Hours that haven't billed.

The consequences of not billing for these hours and of adjusting rates.

This report uses the base currency of the Company on the customer contract that the billable transaction passes through.

The Revenue Leakage report is a standard report and details concessions at the worker level. If you want to understand revenue leakage at a higher level, by project or company, you can copy the report and customize it to your needs.

Fields	Description
Company	Contract company for the customer contract related to the project.
Customer	Bill-To Customer for the billable transaction.
Project Role	Project role associated with the worker for the billable transaction.
Worker	Worker associated with the billable transaction.
Billable	Total eligible hours to bill. These billable hours are based on the worker time booked against the project, project role, and worker combination.
Actual	The current hours to bill that any applied billing rate rules or any manual override during the review billable project transaction process changed.
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 as listed 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 as listed on the contract rate sheet. The average contract rate takes the total billable transactions and averages the contract rates of those 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