Planned Profit Report
The Planned Profit Report gives you insights into your profitability based on all of your projects across your firm in a month-by-month view. This can also be used on a more granular level to show the profitability based on Status and Phase Fee Types.
The goal of this report is to provide further visibility into your firm's financial health and help you grow your profit. For the report to be accurate you'll need to enter compensation details for your team and overhead cost.
How to Use the Planned Profit Report
Located under Reports > Planned Profit, this report can only be accessed by those who have Admin level permission.
First, select the Date Range that you'd like to include in your report.
Next, use Filter By to drill further down into your projects:
Statuses (multi-select) - only include the projects with the selected statuses.
Note: this defaults to include "Active" and Complete" statuses.
Fee Type (single select) - review fixed and/or hourly phases in the report.
After selecting your Date Range and Filtering options, you'll be left with a bar graph and table comparing the monthly costs and revenue, and hovering over the bars will provide more detail. Profit will appear as green and Loss will appear as red.
The table chart below the bar graph also shows you the totals based on your grouping and filtering selections.
How We Calculate Planned Profit
The Planned Profit Report is calculated using the project information entered into the Project Planner for each phase, in conjunction with the Compensation information that you add to your team members' profiles, as well as the Organizational Overhead Costs that you complete within your Organization's Settings. Without all of this information being completed, your report will be inaccurate.
Here is how the math works:
Planned Margin - calculated by dividing the Planned Profit by the Planned Revenue and multiplying the result by 100.
Planned Profit/Loss - the difference between planned revenue and costs. If your Planned Profit is instead a Loss, the dollar amount will appear in parenthesis.
Planned Revenue - comes from the Project Planner. It’s calculated based on the project phases that are ongoing during the selected time range in the report. For fixed phases, the revenue comes from the "Phase Budget". For hourly phases, the revenue comes from the "Max Cap".
Planned Costs - calculated using all your team's compensation and overhead. For each employee that's "active", we use their salary or hourly wage to determine their pay-per-day. We multiply that by the overhead multiplier to get their cost per day. Next, we add the monthly overhead amount on top of that.