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.

Image Placeholder

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.

Image Placeholder


Calculations

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



Projects

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.

Image Placeholder


The Set Rates option will open the user rates modal allowing you to edit the billable rates for anyone on the associated project.

Image Placeholder


Owner

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.

Image Placeholder


Logged time (total)

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.

Image Placeholder


Billable time

Shows the total amount of time logged as billable on the project in the selected date range.

Image Placeholder


Non-billable time

Shows the total amount of time logged as non-billable on the project in the selected date range.

Image Placeholder


Total cost

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.

Image Placeholder


Billable 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.

Image Placeholder


Budget

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.

Image Placeholder



Profit

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.

Image Placeholder


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.


Image Placeholder


Total

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.

Image Placeholder


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.

Image Placeholder



Column options

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.

Image Placeholder

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.

Image Placeholder



Sorting options

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.

Image Placeholder

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.

Image Placeholder



Filter options

In the top right of the report area, you can use the search field to locate a specific project, company, or owner.

Image Placeholder


Using the duration dropdown, you can set a date range for the report.

Image Placeholder


You can also use the arrows beside the currently selected date range in the top left to move to the previous or next period.

Image Placeholder


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.

Image Placeholder



Saved filters 

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.

Image Placeholder

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.

Image Placeholder

The Saved filters view will list any existing saved filters for the view along with some suggested filter options.

Image Placeholder


Export

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.
Image Placeholder

For more information, see: Updating a User's Working Hours