Skip to main content

Earned Revenue Report

Track estimated earned revenue by division based on production hours worked during a selected month.

Accessing the Report​

Reports > General > Earned Revenue

Overview​

This report calculates earned revenue using a cost-based approach: production hours worked are converted to estimated costs, then converted to estimated revenue using configured margin rates. Data is aggregated by division (opportunity type), not individual projects.

Setup Required

Before using this report, configure your divisions and rates in Settings > Earned Revenue Setup. See Earned Revenue Setup for configuration instructions.

Report Columns​

ColumnDescription
Total Hours WorkedSum of production time entries in the period by division
# PeopleDistinct employees with production time entries
Est. COGS to DateCalculated cost of goods sold based on hours and rates
Est. DMEstimated Direct Margin (from projects or configuration override)
Est. Earned RevenueRevenue earned based on work performed to date
Est. Month RevenueProjected full-month revenue at the current pace
Budgeted RevenueYour target from configuration
DifferenceEst. Month Revenue − Budgeted Revenue

Available Filters​

FilterDescription
MonthSelect the month to analyze
YearSelect the year
Project ManagerFilter to projects managed by a specific user

Calculation Methodology​

The report uses production time entries to estimate revenue through the following calculation chain:

Step-by-Step Formulas​

Burdened Payroll = Production Hours × Burdened Rate
Est. COGS = Burdened Payroll ÷ (Percent COGS / 100)
Earned Revenue = Est. COGS ÷ ((100 - Est. Margin) / 100)
Month Revenue Est. = (Earned Revenue ÷ Working Days Elapsed) × Total Working Days

Example Calculation​

StepFormulaExample
Hours Worked—500 hours
Burdened Rate(from config)$45/hour
Burdened Payroll500 × $45$22,500
Percent COGS(from config)60%
Est. COGS$22,500 ÷ 0.60$37,500
Est. Direct Margin(from projects or override)35%
Earned Revenue$37,500 ÷ 0.65$57,692
Working Days10 elapsed / 22 total—
Month Revenue Est.($57,692 ÷ 10) × 22$126,923

Working Days​

  • Working days count Monday through Friday only
  • For the current month, calculations use working days through yesterday
  • Past months use all working days in that month

Understanding the Metrics​

Est. Earned Revenue vs. Est. Month Revenue​

  • Est. Earned Revenue: Revenue earned based on actual work performed to date
  • Est. Month Revenue: Projected revenue if the current daily rate continues through month-end

Difference Column​

DifferenceInterpretation
PositiveTracking ahead of budget
ZeroOn target
NegativeTracking behind budget

Direct Margin​

By default, the system uses the average margin from all projects in each division. The Direct Margin Override in configuration lets you use a fixed margin instead when project-level margins are unreliable.

Using the Report​

Monthly Revenue Tracking​

  1. Select the current month
  2. Review each division's progress against budget
  3. Identify divisions tracking behind target
  4. Take action on underperforming areas

Month-End Close​

  1. Run report for the closing month
  2. Compare Est. Earned Revenue to budgeted targets
  3. Document variances for management review
  4. Use data for financial reporting

Trend Analysis​

Compare month-over-month by changing the Month/Year filters to identify:

  • Seasonal patterns
  • Division performance trends
  • Staffing efficiency changes

Export Options​

Click Export to CSV to download the report data for:

  • Further analysis in spreadsheets
  • Management presentations
  • Historical record keeping

Tips​

  • Review weekly: Don't wait until month-end to spot issues
  • Keep configuration current: Update burdened rates when labor costs change
  • Validate Percent COGS: If results seem off, check this configuration value
  • Use Project Manager filter: Identify which PMs are driving results

Troubleshooting​

No Data Showing​

  1. Verify divisions are selected in Earned Revenue Setup
  2. Check that configuration exists for the selected month
  3. Confirm production time entries exist for projects in those divisions

Numbers Seem Wrong​

  1. Check Percent COGS in configuration—this significantly affects calculations
  2. Verify Burdened Rate matches actual costs
  3. Review if Direct Margin Override is set when it shouldn't be
  4. Confirm production time entries are categorized correctly

Division Missing from Report​

The division must be both:

  1. Selected in Customize Divisions (Setup page)
  2. Have configuration saved for the selected month