Skip to main content

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.

ColumnDescription
Month / Project Manager / JobThe 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 ManagerOn job rows, the job's other person: its lead carpenter when you break down by project manager, and the reverse
Predicted FinishOn job rows, the job's predicted finish date
Unbuilt RevenueUnbuilt revenue in that month, for the whole month, the person or the job
PercentageOn 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​

FilterDescription
Project ManagerOnly jobs assigned to this project manager
Lead CarpenterOnly jobs with this lead carpenter. The filter uses your company's label for this field.
JobOnly jobs whose project ID, title or client name contains what you type
Division / Function / Work TypeLimit 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.

Division, Function & Work Type filters

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​

  1. Capacity planning: See which months are heavy or light on production work
  2. Accountability: Break a month down by project manager or lead carpenter to see each person's share
  3. Job review: Open a person to see which jobs make up their month