Skip to main content

Built Revenue Summary Report

Analyze built revenue trends with monthly aggregation, working day calculations, and productivity metrics.

Accessing the Report​

Reports > Production > Built Revenue Summary

Overview​

This report aggregates built revenue by month and calculates productivity metrics based on working days. Use it to:

  • Track monthly revenue recognition trends
  • Measure revenue productivity per working day
  • Compare project throughput across periods
  • Support capacity planning decisions

Report Columns​

ColumnDescription
MonthCalendar month (e.g., "Oct 2024")
Built RevenueTotal revenue recognized in that month
Working DaysBusiness days in the month (excludes weekends and company holidays)
Revenue/DayBuilt revenue divided by working days
# ProjectsCount of projects with progress in that month (a project appearing in multiple months is counted once per month)
Project AvgAverage revenue per project

How Built Revenue is Calculated​

Built revenue uses the percentage-of-completion method:

Built Revenue = Contract Value × Change in % Complete

When a project's completion percentage changes from 50% to 60% on a $100,000 contract, the built revenue for that period is $10,000.

The report aggregates these changes by the month they occurred.

Summary Section​

Below the main table, the summary shows:

MetricDescription
Working WeeksTotal working days divided by 5
Revenue per WeekTotal built revenue divided by working weeks
Unique ProjectsCount of distinct projects with progress in the selected period
Avg Revenue per ProjectTotal built revenue divided by unique projects

Understanding Working Weeks​

Working weeks represents the number of full 5-day work weeks in the selected period:

Working Weeks = Total Working Days ÷ 5

Example for a full year:

  • 365 calendar days
  • Minus 104 weekend days (52 weeks × 2)
  • Minus 9 company holidays
  • = 252 working days
  • 252 ÷ 5 = 50.4 working weeks

This metric normalizes revenue across periods with different numbers of holidays, making it useful for comparing productivity between quarters or years.

Filters​

Date Range​

Select a date range to analyze. Defaults to the current quarter.

Quick selections available:

  • This Month / Last Month
  • This Quarter / Last Quarter
  • This Year / Last Year
  • Custom range

Understanding the Metrics​

Revenue/Day​

Normalizes revenue across months with different working days. Useful for:

  • Comparing productivity between months
  • Identifying seasonal patterns
  • Setting realistic monthly targets

Example:

  • February (20 working days): $200,000 built = $10,000/day
  • March (22 working days): $198,000 built = $9,000/day

March had lower productivity despite similar total revenue.

Project Counts: Table vs Summary​

The report shows two different project counts:

  • # Projects (table column): Projects with progress in each specific month. A project appearing in multiple months is counted once per month.
  • Unique Projects (summary): Distinct projects across the entire date range. Each project is counted only once regardless of how many months it had progress.

Example: If Project A has progress in both January and February:

  • January row shows 1 project, February row shows 1 project
  • Unique Projects in summary shows 1 project

Understanding Project Averages​

  • High count, low average: Many smaller projects progressing
  • Low count, high average: Fewer large projects driving revenue

Use these metrics to understand your revenue mix.

Working Days Calculation​

Working days exclude:

  • Weekends (Saturday, Sunday)
  • Company holidays (configured in Admin > Company > Holidays)

This ensures accurate productivity comparisons across different months and years.

Export Options​

Click Export CSV to download the report including:

  • All monthly data rows
  • Totals row
  • Summary metrics

Use exports for:

  • Board presentations
  • Financial reporting
  • Trend analysis in spreadsheets

Best Practices​

  1. Update % complete regularly - Built revenue accuracy depends on timely progress updates
  2. Review monthly - Compare actual vs expected productivity
  3. Track trends - Look for patterns across quarters
  4. Cross-reference - Compare with WIP Report for billing alignment