Within Teamwork, you can use profitability reports to track the profitability of your projects and people.
The profitability report feature is currently in a Beta release phase and is available on Scale subscriptions.
Go to the Reports area of your site and select the Profitability tab.
In the report, you will see a series of columns highlighting important properties for each project and user based on their time, cost, and budget.
Note: The profitability report is only accessible to owner company site administrators.
The profitability report uses a simple calculation to determine whether a user or project is profitable over a given period of time.
Profitability = (billable rate x billable time) — (cost rate x total time logged)
The percentage profit calculation is based on gross profit margin, meaning the profit is expressed as a percentage of the overall revenue (billable total).
% Profit = ((billable total - total cost) / billable total)) x 100
The Projects column details each project's name and associated company.
Clicking the arrow to the left of a project name will expand the project row to display project members along with their user avatar, name, and job role.
Note: Users will only show in the expanded rows if they have logged time against the project and have rates set within the selected report time period.
The Set Rates option will open the user rates modal allowing you to edit the billable rates for anyone on the associated project.
For projects with a project owner currently set, their user avatar will be shown in the owner field. You can click the avatar to change the owner. If no owner is set, hover over the field and click Set Owner.
Shows the total time that all users have logged against the project in the selected date range.
When a project row is expanded, you will be able to see the proportion of total logged time that applies to each individual user.
Shows the total amount of time logged as billable on the project in the selected date range.
Shows the total amount of time logged as non-billable on the project in the selected date range.
Represents the amount of money this project has cost the company so far. This is calculated by multiplying each user's cost rate by the amount of logged time (total) against the project and adding the cost of each user up to get the total.
Represents the amount of money this project has made the company so far. This is calculated by multiplying each user's billable rate by the amount of billable time they have logged against the project and adding the cost of each user up to get the total.
Shows a visual representation of the percentage of the project's current budget already used.
If a project has no active budget, you can hover over the budget field and click Setup a budget.
This column represents the amount of profit each project has made in the selected time period. Profit is calculated by subtracting the total cost from the billable total.
You can use the profit toggle in the top right of the report area to display the profit column as a currency amount or a percentage of cost that the profit represents.
Note: The currency used in the profitability report is based on the site currency selected in your general site settings.
At the bottom of the report, a Total row is displayed detailing a running total of the sum of all rows in each supported column.
Using the filter options to filter by company, for example, will allow you to see that company's total profit, cost, and time for the selected period.
Click the options button (three dots) to the far right of the report header and use the toggles in the dropdown menu to show or hide relevant columns.
You can also customize the order of the columns in the table by clicking and dragging a column heading to a new position in the report.
You can quickly sort the report based on a specific column by clicking the column heading. Clicking multiple times will switch the sorting between ascending and descending order.
An arrow will appear to the right of a column title to indicate that active sorting is currently based on that column. To clear the current sorting, click the v to the right of the column heading and select Clear sort.
In the top right of the report area, you can use the search field to locate a specific project, company, or owner.
Using the duration dropdown, you can set a date range for the report.
You can also use the arrows beside the currently selected date range in the top left to move to the previous or next period.
Selecting the filters button in the top right will open a dropdown of advanced filter options. Clicking any of the dropdown fields within this menu will allow you to select specific items to filter by in the report.
You can use the Save Filter button to save the filtered view you are currently using. Once you give the filter a name, press Enter / Return on your keyboard to save the filter.
Note: The option to save filters is available on paid Teamwork subscriptions.
You can also access your existing saved filters via the Saved filters button in the bottom left of the filter options dropdown. Clicking a saved filter will apply it to the report.
The Saved filters view will list any existing saved filters for the view along with some suggested filter options.
Using the export option in the top right of the report area, you can download a copy of the report in PDF, Excel or CSV format.
For more information, see: Updating a User's Working Hours