The Project Earnings and Remaining Value report compares the hours budgeted for each person or timesheet category on a project with the time tracked so far. Project managers and finance teams use it to see what has been invoiced, what is still to invoice, and what the remaining budget hours are worth.
Before you start
The report only includes projects whose Budget Type and Billing Method match:
- Person Hours with Person Hourly Rate: a budget of hours per person, billed at each person's hourly rate, or
- Category Hours with Category Hourly Rate: a budget of hours per timesheet category, billed at each category's hourly rate.
Set both on the Billing & Budget tab of the project's settings. Then enter each person's Billable Rate, Cost Rate and Budget Hours on the Members tab, or each category's Rate Amount, Cost Amount and Budget Hours on the Categories tab. See entering a project budget and cost rates and billable rates.
Open the report
Go to Reports in the left menu. On the Standard tab, find Project Earnings and Remaining Value under Project Management, or type "earnings" in Search.
Administrators, Finance Managers and Portfolio Managers can run this report. Project Managers don't see it. It covers every project in the account, whoever runs it.
Choose what to include
- Customer and Project: choose at least one customer, then at least one of their projects. The report stays empty until you do.
- Date Range: runs for All Time by default. Pick a preset such as This Month, Last 90 Days or Year To Date, or choose Custom Date Range and enter a Start Date and End Date. The dates apply to the day the time was worked.
- Archive Status: Active projects, Archive projects, or both. Active is selected by default.
- Project Status: only include projects with the statuses you pick.
- Time Format: show hours as decimals or as hours and minutes. It starts with your account's format.
- Apply Rounding: round each time entry using your account's rounding settings. See timesheet rounding.
- Timesheet Approval Status: a person or category only appears if they have time on the project in one of these statuses (approved and automatically approved by default). It decides which rows appear, not which hours count: the hour columns include time in every status.
Read the report
Rows are grouped by project, with the customer and currency next to the project name and a subtotal for each project. Each row is one person or category with budget hours.
Column | What it shows |
|---|---|
Person/Category | The team member or timesheet category the budget belongs to. |
Billable Rate/hr, Cost Rate/hr | Their rates on the project. |
Budget Hours | Their hours budget on the project. |
Invoiced Hours | Time that is already on an invoice. |
Uninvoiced Hours | Billable time that isn't invoiced yet. |
Uninvoiced Amount | Uninvoiced hours × billable rate. |
Uninvoiced Net Amount | Uninvoiced hours × (billable rate − cost rate). |
Remaining Hours | Budget hours − invoiced hours − uninvoiced hours. A negative number means the budget is used up. |
Remaining Hours Billable Amount | Remaining hours × billable rate. |
Remaining Hours Net Amount | Remaining hours × (billable rate − cost rate). |
Non-billable time that hasn't been invoiced doesn't count as used hours. The Total line at the end adds up all the projects in the report. Its amounts show NA when the projects are in more than one currency.
No data found?
If the report says No data found, check the projects you chose:
- They use one of the two Budget Type and Billing Method combinations above.
- Budget hours are entered for at least one person or category.
- At least one of those people or categories has time on the project in the selected Timesheet Approval Status. With the default filter, a project that only has draft or pending time shows no data. Add those statuses, or approve the time first.
- Archive Status and Project Status include the project, and the date range isn't leaving out all of its time. Try All Time.
Save, schedule or export
Save the report with your choices so you can run it again in one click: see saving and sharing reports. On a paid plan, you can also schedule it for email delivery. Any report can be exported.