How the Financial overview report turns allocations, estimates and time logs into the figures you see. For how to use the report, see Using the Financial overview report.
How is time spread across periods in the Financial overview report?
When an allocation or task covers more than one day, the report splits its hours across the days so each period gets its share.
| Source | How it's spread |
|---|---|
| Allocations | Evenly across working days between start and end. Non-working days and time off are skipped. |
| Task estimates | Evenly across the assignee's working days between start and end. Split between assignees, or per-day if split capacity is set. Tasks without both dates are left out. |
| Time logs | Not spread. Each log counts on its own date. |
Example: a 10-hour allocation from Monday to Friday gives 2 hours a day. If a period ends on Wednesday, it shows 6 hours, and the next period shows 4.
Why don't the rows add up exactly to the total?
Each row and the total are rounded separately, so the rows can add up to a hundredth more or less than the total. The total is always exact. For example, 8 hours split across three projects shows 2.67 on each row and 8.00 as the total.
Revenue uses the billable rate that applied on the date of the work. The report checks rates in this order:
- User project rate
- Project rate
- User rate (the person's site-wide rate)
- Role rate, Client rate or Task rate
The drill-down panel shows which rate was used on each line.
Changing a rate from today doesn't affect past periods. Changing a rate with an earlier start date re-prices the time it covers.
How is each column calculated?
| Column | What it shows | Calculation |
|---|---|---|
| Allocated time ($) | Planned revenue from billable allocations in the period | Allocated time × billable rate |
| Estimated time ($) | Scoped revenue from task estimates in billable task lists | Estimated time × billable rate |
| Revenue (time based) | Earned revenue from billable time logged | Billable time × billable rate × exchange rate + billable expenses |
| Revenue | Revenue by budget type, including billable expenses | T&M: billable time × rate. Fixed fee: the fee, spread by the Fixed fee budgets setting. Retainer: the fee, adjusted for carryover or reduction |
| Total costs | What the work cost | (Logged time × cost rate) + expenses. Which time counts follows the budget's billable setting |
| Profit | Revenue left after costs | Revenue − total costs |
| Profit (%) | Profit as a share of revenue | (Revenue − total costs) ÷ revenue × 100 |
| Effective billable rate | What you earned per hour | Revenue ÷ billable time |
| Effective billable rate (budget-adj) | The same, by budget type | Budget-adjusted revenue, including billable expenses, ÷ billable time |
| Estimate to complete | Revenue still expected on the project | Remaining estimated revenue on incomplete tasks |
| Estimate at completion | Expected final revenue for the project | Revenue from time logged so far + Estimate to complete |
| Estimate at completion (budget-adj) | The same, by budget type | Calculated by the project's budget type |
Allocations and estimates that run past the date range only count the share inside it. Estimate to complete and Estimate at completion always cover the whole project and ignore the date range.
What's the difference between a dash and a zero?
A dash (–) means there was nothing to calculate from. A zero ($0, 0h, 0%) means the calculation ran and the answer was zero. Rows where every value is a dash are hidden unless you turn on Empty rows in report settings.
How is revenue shown when grouping by user, role, team or task?
Frequently asked questions
Which billable rate does the report use?
It checks the user project rate, then the project rate, then the user rate, then the role, client or task rate. The drill-down panel shows which rate was used on each line.
Does changing a rate affect past periods?
No, if the change starts from today. A rate change with an earlier start date re-prices the time it covers.
Do Estimate to complete and Estimate at completion follow the date range?
No. They always cover the whole project and ignore the date range.