Blog · Board and management reporting · Construction
Compare recorded construction revenue, project billings and cash without mixing their meanings. Work from approved finance exports to explain project movements and the revenue associated with approved scope changes.
Construction revenue analysis compares recorded revenue by project and contract, then explains how the total changed between comparable periods. Keep billings, cash receipts and approved scope changes alongside that analysis as separate measures. A higher invoice total alone does not establish higher recorded revenue.
Ask finance for the project-level amounts already recorded for August and September 2026. Include legal entity, project ID, contract ID, posting period, revenue account, journal reference and revenue amount. Preserve adjustments and reversals with their signs rather than removing them as inconvenient rows.
Use separate exports for invoices, cash applications and approved changes. Each needs the same project and contract identifiers. A project name is a display label; it is a poor matching key when several jobs share a customer or location.
The distinction between earnings and collection is fundamental. The IRS explanation of accrual accounting describes income as generally reported when earned, regardless of when payment arrives. That tax explanation illustrates the timing distinction; it does not determine your contract's financial reporting treatment. Finance owns the approved recognition inputs used here.
Before calculating movements, agree on the period and scope. This example covers a US contractor's construction revenue in USD, excluding sales tax and separate financing income. Both months use the same projects, including projects with no activity in one month. The construction budget analysis covers the related cost and budget review.
The following illustrative summary is rebuilt from those approved exports. All amounts are whole dollars; growth percentages are rounded to one decimal place.
| Project | August revenue (USD) | September revenue (USD) | Revenue movement (USD) | September billings (USD) | September cash applied (USD) |
|---|---|---|---|---|---|
| Cedar office renovation | 180,000 | 240,000 | 60,000 | 210,000 | 190,000 |
| River utility works | 220,000 | 200,000 | -20,000 | 230,000 | 205,000 |
| Depot expansion | 100,000 | 135,000 | 35,000 | 120,000 | 90,000 |
| Total | 500,000 | 575,000 | 75,000 | 560,000 | 485,000 |
Revenue rose by $75,000, or $75,000 / $500,000 = 15.0%. Cedar contributed $60,000 and Depot $35,000, offset by River's $20,000 decline. Those movements add to the company change; the invoice and cash columns do not enter that calculation.
For the summary above, columns B and C hold August and September revenue. In Excel or Google Sheets, enter the following formulas in D2, D5 and G5, respectively:
=C2-B2
=SUM(D2:D4)
=IF(B5=0,"",D5/B5)
Format G5 as a percentage. A blank when the prior period is zero means there is no meaningful percentage growth base. Show the dollar movement and the new activity instead.
To rebuild September revenue from detailed rows, suppose Revenue!A:A contains project IDs, B contains actual posting dates and C contains signed recorded revenue. Put the required project ID in summary cell A2:
=SUMIFS(Revenue!C:C,Revenue!A:A,A2,Revenue!B:B,">="&DATE(2026,9,1),Revenue!B:B,"<"&DATE(2026,10,1))
The Google Sheets SUMIFS documentation describes summing rows that satisfy multiple criteria. Here, both the project and posting-date conditions must match. Covirage is not affiliated with Microsoft or Google.
An approved change register answers what additional scope was authorized. The revenue schedule answers what was recorded in the period. Do not add the entire approved amount to revenue again.
For the same projects, finance provides the following supporting detail. The last column is a documented component of September's recorded revenue, already included in the first table.
| Project | Changes approved in September (USD) | September revenue attributed to that scope (USD) |
|---|---|---|
| Cedar office renovation | 30,000 | 10,000 |
| River utility works | 0 | 0 |
| Depot expansion | 15,000 | 5,000 |
| Total | 45,000 | 15,000 |
The supporting schedule attributes $15,000 of September revenue to scope approved that month. If that scope had no August revenue, it explains $15,000 of the $75,000 movement. The remaining movement is $60,000, which needs explanation from the approved schedules for the existing work.
Do not label that residual as faster production without evidence. It could include delivery progress, approved estimate changes, corrections or a different mix of contract work. Have the project manager and controller confirm the explanation together. Use construction bid analysis for estimating prospective work rather than treating an awarded bid as recorded revenue.
The first check is $500,000 + $75,000 = $575,000. The second is that September's project revenue sums to the construction revenue accounts in the ledger. Billings must separately total $560,000 in the invoice register; cash applications must separately total $485,000 in their own export.
September revenue less September billings is $15,000. That is a period-flow comparison, not a closing contract asset balance. Opening balances, cumulative activity, contract terms and accounting classifications are needed before drawing a balance-sheet conclusion.
Likewise, cash applied in September may settle earlier invoices. It cannot be subtracted from September revenue and called overdue receivables. Review outstanding invoices using their due dates and application history.
Assign revenue adjustments to the controller, billing questions to project accounting and collection questions to the receivables team. For patterns across several jobs for the same buyer, customer revenue analysis provides the account-level view.
Bring a sample of your own approved revenue, billing and change exports to Covirage; it maps the columns, and its tools compute and check the project comparisons. The external AI model explains the results with every figure traced to its rows, using your supplied accounting inputs. Create a free Covirage account, which takes about a minute, then set up your business and bring your files.
See Covirage for construction teams for the industry context.
No. Recorded revenue follows the accounting treatment approved for the contract, while billings follow invoicing events. They can differ in the same month. Compare both using a consistent project identifier, but reconcile each to its own finance source before interpreting the gap.
Approval can change the authorized contract scope or value, but it does not establish how much belongs in a particular period's recorded revenue. Use the amount included in the finance-approved revenue schedule and retain the approval record as supporting evidence.
Use a project revenue export reconciled to the ledger, an invoice register, a cash application export and an approved change register. Include project and contract identifiers, posting periods, document references and status fields so each measure can be checked separately.