)
)
We've added a batch of new columns to custom reports and the profitability report, so you can see revenue, cost targets and effective rates without exporting data or building formulas yourself. If you run delivery or finance for a services team, these are the numbers you check most, now sitting right where you report.
This is part of our ongoing work on financial reporting. Less digging, more answers you can trust.
What new columns are now available in custom reports?
Seven new columns landed in custom reports, spread across user, project and task level. Each one answers a question you were probably calculating by hand before.
Here's the full list and where you'll find it:
Expense revenue (user, project): the revenue tied to expenses, not just billed time
Effective hourly rate (user, project, task): what you're actually earning per hour once the real numbers are in
Invoiced time (project): time that's already gone out the door on an invoice
Profit target (project): the margin you're aiming for, in currency
Profit target (%) (project): the same target as a percentage
Cost target (project): the cost you've planned against
Parent task name (task): so task-level reports keep their context
The effective hourly rate column is the one worth pausing on. It's not your standard rate or your quoted rate. It's what the work actually returned once time, cost and revenue met reality. That's the number that tells you whether a project is quietly leaking margin.
What's changed in the profitability report?
Two new columns joined the profitability report: Revenue (time based) and Billable time ($).
Together they let you separate revenue driven by time from everything else, and see the dollar value of billable time at a glance. If you've ever wanted to know how much of a project's return comes purely from the hours logged, that split is now in front of you.
)
Why we made the calculations easier to read
We also reworked the column popovers so the maths behind each number is explicit. Hover over a column and you'll see how it's calculated, in plain terms, no guessing.
This matters more than it sounds. A report is only useful if people trust the numbers in it. When a delivery lead and a finance lead read the same column and interpret it two different ways, the report stops being a decision tool and starts being an argument. Making the calculations visible closes that gap.
What's coming next for custom reports?
The next batch of custom report columns is already on the way, with six more data points in the works. Here's what we're building:
Completed tasks revenue
Estimated at completion
Billable time (financial)
Non-billable time cost
Effective cost rate
Estimated at completion is one we're particularly keen to ship. It's the difference between knowing where a project stands today and knowing where it'll land by the end. That forward view is where reactive decisions turn into deliberate ones.
Each new data point ships with proper documentation too: what the calculation does, which report types it's available on, and a popover description so the meaning travels with the number wherever it appears.
)
How to start using the new columns
The new columns are live now in both custom reports and the profitability report. If you're already building custom reports, you'll find the new fields when you add or edit columns. If you're new to reporting in Teamwork.com, our create a custom report guide walks you through the setup.
For a deeper look at margin reporting, the profitability report guide and the project profitability docs cover how the numbers fit together.
Open a report, add one of the new columns, and see what it tells you about a project you thought you already understood. Most tools track work. We make it profitable.
)
)
)
)
)
)
)