Your Report Is Late, and Nobody Acts on It

You export the budget vs actual variance analysis on the 20th. It is a wall of numbers. Nothing changes.

Budget vs actual variance analysis is the monthly process of comparing planned revenue and expense to booked results, explaining each gap by cause, and deciding what to do about it. Done right, it produces three to five decisions a month, not a spreadsheet nobody reads. Most owners stop at “there is a gap” and then guess at the reason, and a revenue miss caused by pricing needs a completely different fix than one caused by volume.

Why Generic Advice Fails Owner-Operators

Generic variance analysis answers “how much” and never “why.” Software gives you a difference column. It cannot tell you whether margin slipped because you discounted, because a contractor’s rate rose, or because a client’s scope quietly expanded. That distinction is the whole game, and it matters more now that rising costs of goods, services, and wages rank as the most common financial challenge for employer firms while profitability sits below pre-2020 levels.

There is a second, structural failure: comparing actuals to last year instead of to a budget. Last year tells you that you changed. A budget tells you whether you kept a promise.

Three Preconditions Nobody Mentions

Before any of this works, three things must be true. First, the books close on a schedule, because a variance on an open ledger is noise that late vendor bills will rewrite. Second, the budget is loaded at the same account level as the actuals, or every gap nets against itself and hides. Third, someone owns each line, because an unowned variance gets discussed, never explained.

The Five-Step Routine

Run it within five working days of a clean close.

1. Close and lock the period. Export the budget vs actuals report. In QuickBooks Online it lives under Reports, then Budget vs. Actuals.
2. Apply materiality thresholds, using both a dollar and a percentage floor.
3. Classify each flagged gap as volume, rate, timing, or error. One cause per line; split the dollars if two apply.
4. Write the explanation and the action, two sentences maximum, plus an owner and a date.
5. Roll it forward into the budget and the 13-week cash forecast. A variance that changes no forward number was not worth flagging.

Set thresholds before you look, or you will bend them to fit the story.

For gross margin, split the gap arithmetically instead of arguing about it. The volume effect equals the revenue shortfall times the budgeted gross margin percentage. The rate effect equals actual revenue times the change in gross margin percentage. The two must sum to the total gross profit variance, which gives you a built-in check.

What This Looks Like

Say an agency budgets $350,000 of August revenue and books $331,500, leaving gross profit $28,600 under plan. Budgeted gross margin was 65%; actual was 60%. The volume effect is $18,500 times 65%, or $12,025. The rate effect is $331,500 times the 5-point decline, or $16,575. They sum to $28,600. The lesson: most of the damage was rate, not volume. This is a delivery-cost problem, not a sales problem, and selling more at the same margin would have made it worse. If the rate problem repeats for four more months, it costs another $137,000 of operating income.

Frequently Asked Questions

What is budget vs actual variance analysis? Comparing each budgeted line to the actual booked result for the period, then assigning every material gap a cause and a decision, not just a difference column.

How often should I run it? Monthly, within five working days of a clean close, with a deeper quarterly review.

What variance percentage should I flag? There is no universal number. Set a dollar floor and a percentage floor per account class and require a line to break both. A workable start is $2,500 and 10%.