Project Profitability Analysis
Track project budgets, compare estimated vs actual hours, and understand your profit margins
What You'll Learn
- Track budget consumption across projects
- Compare estimated hours (from quotes) vs actual hours (from time tracking)
- Understand how hourly rates affect profitability
- Monitor individual task progress against estimates
- Use profitability data to improve future quotes
How Budgets Are Set
When a quote converts to a project, the quote's financial details automatically become the project's budget. This gives you a baseline to track against as work progresses.
| Project Field | Source |
|---|---|
| Budget Amount | Quote total amount |
| Budget Type | Quote billing type (fixed project, not-to-exceed, or time & materials) |
| Estimated Hours | Sum of all quote line item quantities |
| Hourly Rate | Blended rate from line items (single rate if uniform, or total amount ÷ total hours) |
Fixed Project
A set total price regardless of hours worked. Budget tracks total consumption against the fixed amount.
Not-to-Exceed
Bill for time worked up to a maximum cap. Budget shows how close you are to hitting the ceiling.
Time & Materials
Bill for all hours at the agreed rate. Budget serves as an estimate for planning purposes.
Automatic Budget Setup
When you convert a quote to a project, the budget is set automatically — no manual entry needed. Each quote line item becomes a task with its own estimated hours and hourly rate.
Estimated vs Actual Hours
Every task tracks two key numbers: estimated hours (from the quote) and actual hours (accumulated from time entries). This comparison is the foundation of profitability tracking.
Task-Level Tracking
Estimated hours set from quote
When a quote converts to a project, each line item's quantity becomes the task's estimated hours. For example, a line item of "Logo Design — 8 hours" creates a task with 8 estimated hours.
Actual hours accumulate from timers
Every time a timer stops or a manual time entry is added, the task's actual hours are incremented automatically.
Visual comparison on Kanban cards
Each task card on the Kanban board displays actual hours / estimated hours. Actual hours turn red when they exceed the estimate, giving you an instant visual warning.
2.5 hours over estimate
Example: Task card showing hours over estimate
Project-Level Rollup
At the project level, you can see total estimated vs actual hours across all tasks. This gives you a bird's-eye view of whether the overall project is on track or trending over budget.
Profit Margin Tracking
WorkCentral calculates profitability metrics on every time entry, then rolls them up to project-level totals.
Billable Amount
Hours × Hourly Rate for billable entries. Non-billable entries have a billable amount of $0.
hours × hourly_rateInternal Cost
Your cost for the work. Currently set at 1:1 with the hourly rate, designed for future separation.
hours × internal_costProfit Margin
The dollar difference between what you bill and what it costs you.
billable_amount - internal_cost_amountProfit Percentage
Your margin as a percentage of the billable amount.
(profit_margin / billable_amount) × 100Rate Hierarchy
The hourly rate used for profitability calculations follows a priority order:
Future Cost Separation
The internal cost field is designed for future separation from the billing rate. For example, if you bill a client $150/hr but your internal cost is $105/hr (70%), you'll see real profit margins. Currently, internal cost is set at 1:1 with the hourly rate.
Budget Consumption
For fixed-project and not-to-exceed billing types, track how much of the total budget has been consumed by logged time. This helps you catch projects going over budget before it's too late.
What Gets Tracked
Total Budget
The project's budget amount, set from the quote total when the project was created.
Consumed Amount
Sum of all billable time entries (hours × hourly rate) logged against the project.
Remaining Budget
How much of the budget is left. Negative values mean the project is over budget.
Catch Overruns Early
Monitor budget consumption regularly, especially for fixed-project work. If a project hits 80% of its budget with significant work remaining, it's time to review scope or have a conversation with the client about change orders.
Using Data for Future Quotes
The most valuable use of profitability data is improving your future estimates. Compare estimated vs actual hours across completed projects to spot patterns.
Review completed projects
After completing a project, compare the original quote estimates to actual time logged. Note which tasks took longer than expected.
Identify patterns
If you consistently underestimate certain types of work (e.g., "Website Redesign" projects always run 20% over), you've found a pattern worth correcting.
Adjust future estimates
Use your findings to adjust AI quote generation parameters or manual estimates. Build in appropriate buffers for work you know tends to run over.
Pro Tip
Review profitability on completed projects before creating similar quotes. If a "Website Redesign" project consistently takes 20% more hours than quoted, factor that into your next quote's estimates.
You're All Set!
You now understand how WorkCentral tracks project profitability. Use budget tracking and estimated vs actual comparisons to keep projects on track, and leverage historical data to create more accurate quotes over time.