Skip to main content

Built Revenue Report

Track revenue recognition on production projects using the percentage of completion method.

Accessing the Report​

Reports > Production > Built Revenue submenu:

  • Built Revenue - Current built revenue
  • Built Revenue Month over Month - Trend comparison
  • Built Revenue Weekly - Weekly detail

Key Metrics​

MetricDescription
Contract ValueTotal project contract
% CompleteProject completion percentage
Built RevenueRevenue recognized to date
Billed to DateAmount invoiced
Over/UnderDifference between built and billed

Calculation Method​

Built revenue uses the percentage-of-completion method, calculating revenue based on progress changes during the selected date range:

Period Built Revenue = Contract Value × Change in % Complete

Example​

A $100,000 project moves from 50% to 60% complete during the month:

  • Contract: $100,000
  • Change in % Complete: 10% (60% - 50%)
  • Built Revenue for period: $10,000

Cumulative vs Period​

  • Cumulative Built Revenue = Contract × Current % Complete (total earned to date)
  • Period Built Revenue = Contract × Change in % (earned during selected period)

This report shows period built revenue - the amount recognized during your selected date range.

Understanding Over/Under Billing​

Over Billing​

Billed > Built Revenue
  • Customer paid ahead of work
  • Positive for cash flow
  • Liability until work catches up

Under Billing​

Built Revenue > Billed
  • Work ahead of billing
  • Revenue earned, not yet invoiced
  • Opportunity to bill

Report Views​

Current Built Revenue​

Point-in-time snapshot:

  • All active production projects
  • Current % complete
  • Current billing status

Month over Month​

Trend comparison:

  • Built revenue by month
  • Growth/decline patterns
  • Seasonal analysis

Weekly Detail​

Granular view:

  • Week-by-week changes
  • Progress tracking
  • Recent activity focus

Available Filters​

FilterDescription
Date RangeAs-of date or period
DivisionBusiness unit
Project ManagerFilter by PM
Production StageActive stages

Analysis Use Cases​

Revenue Recognition​

For accounting purposes:

  • Month-end revenue calculation
  • Financial statement support
  • Audit documentation

Cash Flow Management​

Identify billing opportunities:

  • Large under-billing = invoice now
  • Track billing efficiency
  • Forecast cash inflows

Project Health​

Spot potential issues:

  • Progress stalled but billed ahead
  • Progress moving but not billing
  • Unusual patterns

Timing Considerations​

Built revenue timing depends on:

  • When % complete is updated
  • Production stage changes
  • Manual progress entries

Best Practice: Update % complete weekly minimum.

Export Options​

Click Export CSV to download for:

  • Accounting entries
  • Management reporting
  • Historical tracking

Tips​

  • Update % complete regularly for accuracy
  • Review over-billing to ensure work catches up
  • Bill under-billed projects promptly
  • Compare to WIP Report for cross-validation