One of the most satisfying parts of using Monograph is using reports which pull insights from your project budgets and hour allocations to give you a forecast of your expected revenue.
📚 Keep learning by watching the video, reading below, or taking a live tour.
What is in the forecast report?
Monograph provides you with a forecast report which shows your projected fee and/or hours by project, status, or category within a date range.
💡 To be included a project have a start and end date, a phase and have a project budget or hours allocated. We don't include projects with no phases, no phase budgets or hourly phases.
The data displayed in the report is derived from the project planner and averaged out over the duration of the project/phase. Please note that this report is designed to be a forecast and does not account for any time tracked against the projects.
Navigate to Reports
Navigate to the forecast report by clicking on "Reports" from the main menu.
If you do not see the "Reports" option, it means that your current access level doesn't permit you to see company reports, please ask your admin for assistance. Only those with "Admin" level permissions will have access.
Customize your Forecast
To run the most accurate forecast, start by adjusting the date range. You can run the report for that date range only or isolate one or multiple projects, statuses or categories.
Filtering by billable will isolate any projects that are non-billable if you need to understand what part of your upcoming work doesn't support your revenue goals.
Parts of the Forecast Graph
Total Sums - the large numbers at the top indicate the total sums based on your selections, they include the total number of projects, total projected fee, the total projected hours, and percent that is billable. You'll find a per-project breakdown further below
Bar Line Graph - the colorful bar line graph is a visual representation of your work across your selected date range. It will be grouped by day, month or year based on the length of the range.
Highlight Single Project - hovering over the color segment of a project, will highlight it throughout the chart and give you the sum of its fee and hours for that period.
Date Amount - hovering over the date will display the total projected fee and hours for that day, month, or year.
Per Project Forecast Breakdown
Beneath the bar line graph, you will see a complementary list that breakdown which projects are included in the totals presented above based on your date and filtering criteria.
For each project, we highlight its status (proposed, active, paused, canceled, completed), whether it's billable or not, the projected fee, and projected hours.
🚨 If a project has a projected fee but no projected hours, it means that no hours were allocated to your team for that project/phase despite it having a budget. To fix this you'll need to go back into that project and edit the allocations.
Projected fees and projected hours are derived from the hours entered in the Project Planner. Since this report is looking at projected hours, it does not include actual time logged from Timesheets.
After filtering the information for the forecast, you can export the data as a CSV. The exported document will reflect the filtered data, and you can do further calculations or manipulations in another software program if needed.
To export, click on the "Export" button on the top right side corner.
Forecast Report Ideas
How much billable work will I have in this time period?
Select date range, and filter status to active only
How many of my upcoming projects have been paused or canceled?
Select date range, and filter status to paused and canceled
How much of my project revenue is coming from this category(s)?
Select date range, and filter categories, such as "Commercial" or "Residential. You can select one or several.
If I only worked on these projects would I have enough revenue?
Select date range, and filter projects to include one or several only.
Which months in the next 12 months have the most/least work?
Select the date range, and filter status to active and proposed only