Earned Revenue Report
Track revenue recognition across production projects using percentage of completion accounting.
Accessing the Report
Reports > General > Earned Revenue
Key Metrics
| Metric | Description |
|---|---|
| Project | Project name |
| Contract Value | Total contract amount |
| % Complete | Completion percentage |
| Earned Revenue | Revenue recognized |
| Billed to Date | Amount invoiced |
| Over Billing | Billed ahead of work |
| Under Billing | Work ahead of billing |
Available Filters
| Filter | Description |
|---|---|
| As of Date | Point-in-time report |
| Division | Business unit |
| Production Stage | Active stages |
| Project Manager | Filter by PM |
Revenue Recognition Method
Percentage of Completion
% Complete = Actual Cost ÷ Total Estimated Cost
Earned Revenue = Contract Value × % Complete
Example
- Contract: $100,000
- Estimated Cost: $70,000
- Actual Cost: $35,000
- % Complete: 50%
- Earned Revenue: $50,000
Over/Under Billing
Over Billing (Unearned Revenue)
Billed > Earned Revenue
- Customer paid ahead
- Liability on balance sheet
- Cash flow positive
Under Billing (Unbilled Revenue)
Earned Revenue > Billed
- Work ahead of billing
- Asset on balance sheet
- Bill to collect
Billing Status Analysis
| Status | Action |
|---|---|
| Significantly over-billed | Monitor work progress |
| Slightly over-billed | Normal for some billing methods |
| Even | Billing aligned with work |
| Slightly under-billed | Consider billing soon |
| Significantly under-billed | Bill immediately |
Accounting Implications
Balance Sheet Impact
Over Billing creates:
- Deferred Revenue (liability)
- Reduces current assets
Under Billing creates:
- Unbilled Revenue (asset)
- Increases receivables
Income Statement
Earned Revenue is recognized income regardless of billing status.
Using the Report
Month-End Close
- Run as of month-end date
- Calculate revenue recognition
- Record journal entries
- Document for audit
Cash Flow Management
- Identify under-billed projects
- Prioritize billing
- Improve collections
Project Health
- Spot billing/work misalignment
- Address stuck projects
- Monitor customer payment patterns
Export Options
Click Export CSV to download:
- Revenue recognition data
- For accounting entries
- Audit documentation
Tips
- Update % complete regularly
- Review before month-end
- Address large under-billing
- Document revenue recognition basis
Related Reports
- WIP Report - Full financial view
- Built Revenue - Revenue tracking
- Active Jobs - % complete status