Unbuilt Revenue by Month Report
The Unbuilt Revenue by Month report shows the sold work your jobs in production still have left to build, by calendar month. Each month breaks down by project manager or by lead carpenter, and each person breaks down to their jobs. Use it to plan monthly capacity and see each person's share of the work ahead.
It uses the same jobs and filters as Unbuilt Revenue by Week, so for the same filters the two reports have the same TOTAL.
Accessing the Report
Reports > Production > Unbuilt Revenue > By Month
What's Included
A job appears when it:
- Has been sold (its sales stage is a Won stage)
- Is in a production stage with an Open status (see Production Stages)
- Is not yet 100% complete
- Has a predicted finish date
- Is in a full-project division (by default; see Available Filters)
Jobs with no predicted finish date don't appear anywhere on the report.
How Each Month Is Calculated
A job's unbuilt revenue is the part of its total sold amount not yet marked complete. For example, a $100,000 job that is 40% complete has $60,000 unbuilt.
That amount is spread evenly over the days the job has left, weekends included:
- The days start at the job's start date, or today if the job has already started or has no start date
- The days run up to the job's predicted finish date
- A job whose start date is on or after its predicted finish date puts its whole unbuilt amount on the day it starts
Each month gets the days that fall in it. For example, a job with $1,400 unbuilt and 14 days left, 3 in January and 11 in February, shows $300 in January and $1,100 in February.
Amounts are split to the cent, so a job's monthly amounts add up to exactly its unbuilt revenue.
Jobs whose predicted finish date is today or earlier are not in any month. They are counted in the Past Unbuilt Total instead.
Past Unbuilt Total
The box above the table shows the unbuilt revenue on jobs whose predicted finish date is today or earlier, with the number of jobs. These jobs are not in any month.
Click the amount to see the jobs behind it, listed longest overdue first.
Report Rows
The table lists one row per calendar month, starting with the current month and running through the month 12 months ahead. For example, on November 3, 2026 it runs from November 2026 through November 2027.
| Column | Description |
|---|---|
| Month / Project Manager / Job | The month, person or job the row is for. The middle part follows your Break months down by choice and your company's label for that field. |
| Lead Carpenter or Project Manager | On job rows, the job's other person: its lead carpenter when you break down by project manager, and the reverse |
| Predicted Finish | On job rows, the job's predicted finish date |
| Unbuilt Revenue | Unbuilt revenue in that month, for the whole month, the person or the job |
| Percentage | On month rows, that month's share of the TOTAL |
Other rows in the table:
- Beyond - Unbuilt revenue after the last month shown
- TOTAL - All future unbuilt revenue: every month plus Beyond. It does not include the Past Unbuilt Total.
Month totals match the month totals in Unbuilt Revenue by Week.
Breaking a Month Down
Click a month, or Beyond, to see the people behind it. Click a person to see their jobs. Click the job's project ID to open the project.
Use Break months down by to choose Project Manager or Lead Carpenter. Both use your company's labels for these fields (for example Lead Remodeler). Your choice is kept in the page address.
Jobs with no project manager, or no lead carpenter, are listed under Unassigned, so a month's people always add up to the month total.
Sorting
Months always stay in date order. Inside each month, people open sorted by unbuilt revenue, largest first.
- Click Unbuilt Revenue to sort people and jobs by amount; click again to reverse the order
- Click Month / Project Manager / Job to sort people by name and jobs by project ID
To sort by lead carpenter instead of project manager, switch Break months down by to Lead Carpenter.
Available Filters
| Filter | Description |
|---|---|
| Project Manager | Only jobs assigned to this project manager |
| Lead Carpenter | Only jobs with this lead carpenter. The filter uses your company's label for this field. |
| Job | Only jobs whose project ID, title or client name contains what you type |
| Division / Function / Work Type | Limit the divisions shown. Function defaults to Operational and Work Type to Full Project. |
The filters apply to the months, the breakdowns and the Past Unbuilt Total. They are kept in the page address, so you can bookmark a filtered view.
The Division, Function, and Work Type filters appear only for companies that classify their divisions (using more than one function or work type). See Divisions for how these classifications are configured.
The three filters are combined: a project is included only when it matches every filter at once. For example, selecting the Handyman (Internal) and Design Build (Operational) divisions together with the Internal function shows Handyman only — it is the sole division that satisfies both.
Leaving a filter blank places no restriction on that dimension, so it reads as "All". Selecting Internal for Function with Division and Work Type blank gives the entire Internal compartment.
Exporting
Click Export CSV to download the rows currently shown: every month, the people and jobs under any month or person you opened, Beyond, the TOTAL and the Past Unbuilt Total. Rows you have not opened are not included.
The file starts with lines listing the date, the filters you applied and how months are broken down.
Common Use Cases
- Capacity planning: See which months are heavy or light on production work
- Accountability: Break a month down by project manager or lead carpenter to see each person's share
- Job review: Open a person to see which jobs make up their month
Related Reports
- Unbuilt Revenue by Week - The same unbuilt revenue, week by week
- Unbuilt Revenue by Project - The same unbuilt revenue, one row per job
- Built Revenue - Revenue built by project in a date range