Vivid Software Back to the site

Sample reports

Nine reports from one September close.

Hollisand Builders is invented: a commercial general contractor with nine jobs and sample books. Its reports tie to each other the way real ones must, and to the construction dashboard on the home page. No figure here comes from a client.

Income statement with variance commentary

Hollisand Builders

September 2026, against budget and September 2025

Sample company, sample data

September 2026ActualBudgetVariance%Sep 2025
Contract revenue5,412,3005,300,000112,3002.1%F4,930,000
Subcontractors2,986,4002,915,00071,4002.4%U2,712,000
Materials873,600848,00025,6003.0%U801,000
Field labor and burden731,200702,00029,2004.2%U668,000
Equipment138,800132,5006,3004.8%U129,000
Other job costs54,50066,500(12,000)−18.0%F49,000
Total job costs4,784,5004,664,000120,5002.6%U4,359,000
Gross profit627,800636,000(8,200)−1.3%U571,000
Gross margin11.6%12.0%−0.4 pts11.6%
Office salaries and benefits228,400231,000(2,600)−1.1%F214,000
Rent and utilities31,90032,000(100)−0.3%F30,800
Insurance and bonding46,20044,0002,2005.0%U41,500
Estimating and business development22,60026,000(3,400)−13.1%F19,900
IT, accounting and legal18,70019,500(800)−4.1%F17,200
Vehicles and other24,30022,5001,8008.0%U21,600
Total overhead372,100375,000(2,900)−0.8%F345,000
Operating income255,700261,000(5,300)−2.0%U226,000
Other income4,1003,0001,10036.7%F2,600
Interest(9,800)(10,000)2002.0%F(11,400)
Net income250,000254,000(4,000)−1.6%U217,200

Commentary

  • Revenue $112,300 over budget. Both the warehouse expansion and the school addition earned ahead of schedule on cost to cost.
  • Subcontractors $71,400 over. Most of it is the fire station's concrete and steel, forecast $420,000 over bid across the job.
  • Field labor $29,200 over. Overtime was 5.4% of field hours, mostly concrete finishers chasing pours.
  • Other job costs $12,000 under. Fewer small tools and dumpster pulls than planned.
  • Net income $250,000, $4,000 under budget and ahead of last September by $32,800. Year to date: $1,642,000.

Balance sheet

Hollisand Builders

At 30 September 2026, against 31 December 2025

Sample company, sample data

30 Sep 202631 Dec 2025
Current assets
Cash3,512,0003,960,000
Contract receivables, less retention4,348,0004,120,000
Retention receivable2,883,0002,410,000
Costs and estimated earnings in excess of billings850,712412,000
Prepaid expenses188,000162,000
Property and equipment, net1,284,0001,340,000
Other assets412,000398,000
Total assets13,477,71212,802,000
Liabilities
Accounts payable, less retention2,306,0002,480,000
Retention payable1,815,0001,360,000
Billings in excess of costs and estimated earnings979,5171,140,000
Accrued payroll, taxes and other393,195254,000
Equipment notes742,000918,000
Total liabilities6,235,7126,152,000
Members' equity7,242,0006,650,000
Total liabilities and equity13,477,71212,802,000

Commentary

  • Ties out. Over billings $979,517 and under billings $850,712 are the WIP schedule's totals. Receivables $4,348,000 is the aging's total. Retention matches the job ledger both ways.
  • Equity moved from $6,650,000 by $1,642,000 of net income less $1,050,000 of distributions.
  • Working capital is $6,288,000, current assets less current liabilities.

13-week cash flow

Hollisand Builders

From the week of Oct 19, starting cash $3,840,000

Sample company, sample data

  • Ending cash
  • Lowest week
  • Floor, $2.0M
$0$2.0M$4.0M$6.0MOct 19Oct 26Nov 2Nov 9Nov 16Nov 23Nov 30Dec 7Dec 14Dec 21Dec 28Jan 4Jan 11$2.81MOct 19$1.21M in$1.38M out$3.67M ending cashOct 26$1.64M in$1.29M out$4.02M ending cashNov 2$980K in$1.46M out$3.54M ending cashNov 9$1.42M in$1.21M out$3.75M ending cashNov 16$1.58M in$1.64M out$3.69M ending cashNov 23$1.11M in$1.39M out$3.41M ending cashNov 30$1.69M in$1.31M out$3.79M ending cashDec 7$860K in$1.52M out$3.13M ending cashDec 14$1.52M in$1.28M out$3.37M ending cashDec 21$1.38M in$1.47M out$3.28M ending cashDec 28$610K in$1.08M out$2.81M ending cashJan 4$1.74M in$1.36M out$3.19M ending cashJan 11$1.46M in$1.41M out$3.24M ending cash
Week ofStartingPay applications inSubs and suppliersPayrollOverhead and debtEnding
Oct 193,840,0001,210,000(1,020,000)(268,000)(92,000)3,670,000
Oct 263,670,0001,640,000(1,198,000)0(92,000)4,020,000
Nov 24,020,000980,000(1,100,000)(268,000)(92,000)3,540,000
Nov 93,540,0001,420,000(1,118,000)0(92,000)3,750,000
Nov 163,750,0001,580,000(1,280,000)(268,000)(92,000)3,690,000
Nov 233,690,0001,110,000(1,298,000)0(92,000)3,410,000
Nov 303,410,0001,690,000(950,000)(268,000)(92,000)3,790,000
Dec 73,790,000860,000(1,428,000)0(92,000)3,130,000
Dec 143,130,0001,520,000(920,000)(268,000)(92,000)3,370,000
Dec 213,370,0001,380,000(1,378,000)0(92,000)3,280,000
Dec 283,280,000610,000(720,000)(268,000)(92,000)2,810,000
Jan 42,810,0001,740,000(1,268,000)0(92,000)3,190,000
Jan 113,190,0001,460,000(1,050,000)(268,000)(92,000)3,240,000
13 weeks3,840,00017,200,000(14,728,000)(1,876,000)(1,196,000)3,240,000

Commentary

  • Lowest week: Dec 28, $2,810,000, $810,000 above the floor agreed with the bank.
  • Pay applications in are the amounts due under each contract, less retention, timed on each owner's paying history.

Receivables and payables aging

Hollisand Builders

At 30 September 2026, retention shown on the balance sheet

Sample company, sample data

Receivables by jobCurrent1 to 3031 to 6061 to 90Over 90Total
J-2401 Harbor medical office building668,000260,000120,000001,048,000
J-2403 Riverside self-storage200,000120,00060,00038,0000418,000
J-2405 Fire station 7430,000180,00092,00000702,000
J-2407 Oakmont retail center210,000110,0000064,000384,000
J-2408 Elementary school addition516,000210,00090,00080,0000896,000
J-2409 Dental clinic build-out102,00040,000000142,000
J-2410 Credit union branch156,00030,00050,00000236,000
J-2411 Warehouse expansion374,00030,000000404,000
J-2412 Church fellowship hall118,0000000118,000
Total2,774,000980,000412,000118,00064,0004,348,000
Payables by tradeCurrent1 to 3031 to 6061 to 90Over 90Total
Concrete subcontractors272,000180,00060,00000512,000
Steel fabricator and erector218,000150,00070,00000438,000
Mechanical, plumbing and electrical subs334,000230,00040,00020,0000624,000
Material suppliers204,000140,00024,00018,0000386,000
Equipment rental82,00056,00010,00000148,000
Other vendors138,00050,00010,00000198,000
Total1,248,000806,000214,00038,00002,306,000

Commentary

  • $64,000 over 90 days is one change order on the Oakmont retail center, approved in the field and not yet signed by the owner.
  • Payables over 60 days, $38,000, are held against punch-list items on two subcontracts.

Work in progress schedule

Hollisand Builders

At 30 September 2026, percent complete by cost to cost

Sample company, sample data

JobContractEst. costEst. gross profitCost to dateCompleteEarnedBilledOver (under)Backlog
J-2401 Harbor medical office building14,850,00013,215,0001,635,00011,890,00090%13,361,06713,520,000158,9331,488,933
J-2403 Riverside self-storage6,420,0005,650,000770,0005,105,00090%5,800,7265,640,000(160,726)619,274
J-2405 Fire station 78,960,0008,310,000650,0004,120,00050%4,442,2624,880,000437,7384,517,738
J-2407 Oakmont retail center5,380,0004,760,000620,0002,950,00062%3,334,2443,050,000(284,244)2,045,756
J-2408 Elementary school addition11,240,00010,170,0001,070,0006,330,00062%6,995,9886,710,000(285,988)4,244,012
J-2409 Dental clinic build-out1,860,0001,610,000250,0001,402,00087%1,619,7021,560,000(59,702)240,298
J-2410 Credit union branch3,270,0002,880,000390,0001,145,00040%1,300,0521,240,000(60,052)1,969,948
J-2411 Warehouse expansion7,680,0006,950,000730,0001,610,00023%1,779,1082,120,000340,8925,900,892
J-2412 Church fellowship hall2,940,0002,610,000330,000380,00015%428,046470,00041,9542,511,954
Nine jobs62,600,00056,155,0006,445,00034,932,00062%39,061,19539,190,000128,80523,538,805

Commentary

  • Over billings $979,517, under billings $850,712. Both carry to the balance sheet as they stand.
  • Estimated gross profit 10.3% against 11.0% at bid. Fire station 7 accounts for most of the fade.
  • Backlog $23,538,805, about 4.3 months of September's revenue.

Job cost report, J-2405 Fire station 7

Hollisand Builders

At 30 September 2026. Contract $8,960,000, 50% complete

Sample company, sample data

  • Forecast at completion
  • Cost to date
  • Budget at bid
General conditions▲ $48.0KGeneral conditions$742K budget$790K forecast at completion$361K cost to dateSitework▲ $34.0KSitework$618K budget$652K forecast at completion$604K cost to dateConcrete▲ $82.0KConcrete$1.05M budget$1.13M forecast at completion$1.02M cost to dateStructural steel▲ $78.0KStructural steel$884K budget$962K forecast at completion$786K cost to dateMasonry▼ $4.0KMasonry$712K budget$708K forecast at completion$402K cost to dateRoofing▲ $8.0KRoofing$396K budget$404K forecast at completion$96.0K cost to dateMechanical and plumbing▲ $56.0KMechanical and plumbing$1.49M budget$1.54M forecast at completion$418K cost to dateElectrical▲ $42.0KElectrical$1.02M budget$1.06M forecast at completion$296K cost to dateInteriors and finishes▲ $76.0KInteriors and finishes$988K budget$1.06M forecast at completion$139K cost to date
PhaseBudgetCommittedCost to dateCost to completeForecastOver (under)
General conditions742,000380,000361,000429,000790,00048,000
Sitework618,000640,000604,00048,000652,00034,000
Concrete1,046,0001,102,0001,018,000110,0001,128,00082,000
Structural steel884,000948,000786,000176,000962,00078,000
Masonry712,000698,000402,000306,000708,000(4,000)
Roofing396,000404,00096,000308,000404,0008,000
Mechanical and plumbing1,486,0001,492,000418,0001,124,0001,542,00056,000
Electrical1,018,0001,046,000296,000764,0001,060,00042,000
Interiors and finishes988,000940,000139,000925,0001,064,00076,000
Job7,890,0007,650,0004,120,0004,190,0008,310,000420,000

Commentary

  • Forecast $8,310,000 against a $7,890,000 budget: gross profit falls from 11.9% at bid to 7.3%.
  • Cost to date $4,120,000 is the WIP schedule's cost to date for this job, line for line.

Payroll and labor

Hollisand Builders

September 2026, field payroll

Sample company, sample data

Labor share of revenue
  • Field labor, share of revenue
  • Target 13%
12.5%13%13.5%14%14.5%OctDecFebAprJunAugSeptarget13.5% laborOct13.2% labor13.0% targetNov13.6% labor13.0% targetDec14.1% labor13.0% targetJan13.4% labor13.0% targetFeb13.0% labor13.0% targetMar12.8% labor13.0% targetApr12.9% labor13.0% targetMay13.1% labor13.0% targetJun13.6% labor13.0% targetJul13.9% labor13.0% targetAug13.4% labor13.0% targetSep13.5% labor13.0% target
CraftPeopleHoursOvertimeOT shareWagesBurdenLabor cost
Carpenters325,3763205.6%181,53657,187238,723
Laborers284,7042605.2%117,16236,908154,070
Concrete finishers122,0161808.2%64,00820,16484,172
Equipment operators81,344966.7%50,59215,93766,529
Superintendents91,51200.0%142,74044,966187,706
Field8914,9528565.4%556,038175,162731,200

Commentary

  • Field labor cost $731,200, 13.5% of revenue. It is the P&L's field labor line to the dollar.
  • Burden 31.5% of wages: payroll taxes, workers' compensation, health and retirement.

KPI scorecard

Hollisand Builders

September 2026

Sample company, sample data

MeasureTargetActualStatusTrend
Revenue, September$5,300,000$5,412,300On track
Gross margin12.0%11.6%Watch
Net income$254,000$250,000Watch
Estimated gross profit in WIP11.0% at bid10.3%Watch
Backlog, months of revenue5.04.3Watch
Net over billingsAbove zero$129KOn track
Cash, lowest of 13 weeksOver $2.0M$2.81MOn track
Receivable days, retention asideUnder 3524On track
Field labor, share of revenue13.0%13.5%Watch
Overtime, share of field hoursUnder 5%5.4%Watch

Commentary

  • 4 on track, 6 to watch, 0 off target. Most of the watch list traces to one job: the fire station's fade, and the overtime spent catching it up.

Board pack

Hollisand Builders

September 2026, for the meeting of Thu 22 Oct

Sample company, sample data

Revenue$5.41M$112K over budget
Net income$250K$1.64M year to date
Backlog$23.5M4.3 months of revenue
Cash$3.51Mlowest ahead $2.81M

The month in four sentences

Revenue beat budget and gross profit missed it, because the fire station's concrete and steel are running over bid. The other eight jobs are within a point of their bid margins. Billings are $129K ahead of the work across the company, and cash stays above the floor all quarter. Up for decision: whether to claim a change order for the fire station's concrete overrun, on page 6.

  1. Summary and scorecard1
  2. Income statement with commentary2
  3. Balance sheet3
  4. 13-week cash flow4
  5. Work in progress schedule5
  6. Job cost, fire station 76
  7. Receivables and payables aging7
  8. Payroll and labor8