Budget vs Actual — Year to Date and Full-Year Projection
Projection = actuals for months already closed plus the approved budget for the months still ahead. Favorable variances are green.
Year to date
Full year
Line
Actual YTD
Budget YTD
Variance $
Var %
Projected
Annual Budget
Variance $
Ledger activity with no budget line
These accounts posted in 2026 but the approved budget has no matching row, so they sit outside every variance above. Left in plain sight rather than folded into a line that was never budgeted.
Account
Description
Posted YTD
Monthly Overhead — Budget vs Actual
Quarterly Revenue & Gross Margin — Budget vs Actual
Closings — Budget vs Actual by Quarter
Quarters with a full general-ledger load (blue) pull revenue and margin from the same accounts as the income statement, so this summary always ties to the F/S. Other quarters sum the closing rows below.
Quarter
Act Units
Act Revenue
Act Margin $
Act GM%
Bud Units
Bud Revenue
Bud Margin $
Bud GM%
Rev Var $
Margin Var $
Actual Closings
Seeded from the budget's closing schedule, which was itself actual through April. Edit any cell to record what really closed; use Add to record a home the budget did not have.
#
Month
Lot
Comm
Buyer
Sales Price
Construction
Lot Cost
Realtor
Financing
Closing
Margin $
Margin %
Unit Sales — Forecast vs Actual
The budget's forecast row is what was approved. Enter units actually written in the Actual row; months at or before the actuals cut-off that you have not touched carry the forecast.
Sales Compensation — Budget vs Actual
Commission cascades and the recoverable draw are recomputed on actual unit sales using the same rules as the budget:
Line
Actual YTD
Budget YTD
Variance $
Projected
Annual Budget
Variance $
G&A Overhead — Actuals by Month
Technology — Actuals by Month
Construction Overhead — Actuals by Month
Selling & Marketing — Actuals by Month
Financing & Closing Costs — Actuals by Month
Payroll — Budget vs Actual
Actual payroll is read from the salary, burden and benefit accounts posted in the four overhead tabs, so it always ties to the general ledger. The roster below is the approved budget for reference.