QUICK TAKEAWAY
Primary Insight: A budget vs. actual report is only useful when it separates variances you caused from variances you absorbed, because a revenue beat and a margin collapse can appear in the same quarter and cancel each other out on the bottom line.
Key Fact: The federal tax system is pay-as-you-go, and the IRS generally expects estimated payments in four equal amounts. A profit variance you discover in December is a tax problem you can no longer solve by adjusting your remaining installments.
Best Suited For: Owners and controllers at California businesses doing $1M to $20M in revenue who set an annual budget and then never look at it again.
Most businesses in the $1M to $20M range build a budget once a year, present it, save the file, and never open it again. The budget becomes a document rather than a control, and by March nobody could tell you whether the company is ahead of plan or behind it.
A budget vs. actual report closes that loop. It compares what you planned against what happened, line by line, and turns the difference into a question somebody has to answer. Done well, it is the single most useful management report a growing business produces, because it is the only one that measures performance against intent rather than against history.
This post covers what the report contains, which variances are worth investigating, how to tell a volume variance from a margin variance, what a written variance narrative looks like, and why an unexamined profit variance turns into a tax surprise.
What a budget vs. actual report shows
A budget vs. actual report places your budgeted amount and your actual result side by side for every line on the income statement, then reports the difference in both dollars and percentage terms. It is sometimes called a budget to actual report, a variance report, or a plan versus performance report.
The report should always carry four columns for each line: budget, actual, dollar variance, and percentage variance. Both variance columns matter, and for opposite reasons. A 40% overage on a $2,000 line is noise. A 3% overage on a $1.6 million line is $48,000. Reading only percentages sends you chasing small accounts, and reading only dollars hides deterioration in accounts that have not yet grown large.
Two conventions prevent confusion. Variances should be labelled favorable or unfavorable rather than positive or negative, since a positive number is good on revenue and bad on expenses. And year-to-date columns belong next to period columns, because a single month can mislead in ways a cumulative figure will not.
Which variances actually deserve investigation
Variances deserve investigation when they cross a defined threshold in both dollars and percentage, and that threshold should be written down before the report is produced rather than decided after everyone sees the numbers. Without a rule, investigation follows whatever line is most uncomfortable to discuss.
| Variance size | Response | Why |
|---|---|---|
| Under both thresholds | No action | Normal timing and estimation noise. Chasing it wastes the review meeting and trains people to ignore the report |
| Over percentage only | Note and monitor | Usually a small account behaving oddly. Worth watching for a pattern before spending time on it |
| Over dollar only | Explain | A large account drifting slightly. Small percentages on big numbers are where real money leaks |
| Over both thresholds | Investigate and assign | Something changed materially. This gets a named owner and a written explanation, not a verbal one |
| Favorable and over both | Investigate anyway | Favorable variances are skipped almost universally, and they frequently turn out to be timing, a missed accrual, or an unrecorded expense rather than genuine outperformance |
The last row is the discipline most businesses lack. An expense line that comes in far under budget usually means a bill has not arrived yet, and treating it as savings produces a decision built on a number that will reverse next month.
Separating volume variance from rate variance
Separating a volume variance from a rate variance is the step that turns a variance report into a diagnosis, because it answers whether a number moved due to activity level or due to unit economics. Costs that scale with revenue will always appear over budget when revenue beats plan, and reading that as overspending sends you after the wrong problem.
The arithmetic is straightforward. Take the budgeted cost as a percentage of budgeted revenue, apply that percentage to actual revenue, and you have what the cost should have been at the volume you actually achieved. The gap between budget and that figure is volume. The gap between that figure and actual is rate.
Consider a hypothetical Central Valley manufacturer reviewing a quarter that, on the surface, looks like a win.
| Line | Budget | Actual | Variance | Var % |
|---|---|---|---|---|
| Revenue | $2,400,000 | $2,607,000 | +$207,000 | +8.6% |
| Cost of goods sold | $1,440,000 | $1,616,340 | +$176,340 | +12.2% |
| Gross profit | $960,000 | $990,660 | +$30,660 | +3.2% |
| Payroll | $432,000 | $441,000 | +$9,000 | +2.1% |
| Facilities | $108,000 | $108,000 | $0 | 0.0% |
| Other operating | $156,000 | $171,600 | +$15,600 | +10.0% |
| Operating income | $264,000 | $270,060 | +$6,060 | +2.3% |
Revenue beat plan by 8.6%. Operating income beat plan by 2.3%. That gap is the whole story, and no line on the report announces it.
Run the decomposition on cost of goods sold. Budgeted COGS was 60% of budgeted revenue. Applying 60% to actual revenue of $2,607,000 gives $1,564,200, which is what COGS should have been at the volume actually achieved. Actual COGS came in at $1,616,340.
| Cost of goods sold variance | Amount | Meaning |
|---|---|---|
| Volume effect: cost of supporting higher sales | +$124,200 | Expected and healthy |
| Rate effect: margin erosion per dollar of sales | +$52,140 | The actual problem |
| Total variance | +$176,340 |
Gross margin fell from a budgeted 40.0% to an actual 38.0%, two full percentage points. At this revenue level, each point is worth roughly $26,000 a quarter, and the erosion is permanent unless someone identifies the cause. Materials pricing, an unfavorable job mix, discounting to win volume, and rework all produce this exact signature.
Without the decomposition, the quarter reads as a success and nobody investigates. With it, the conversation becomes specific: which jobs carried the lower margin, and was the discounting deliberate. For construction and manufacturing businesses this analysis pairs directly with project-level profitability tracking, which is where the answer usually lives.
The variance narrative that turns a report into a decision
A variance narrative is a short written explanation attached to the report, covering each variance that crossed the investigation threshold. It is the deliverable most businesses never receive, and its absence is why so many budget vs. actual reports get distributed, skimmed, and forgotten.
Each entry needs four things and should run no longer than a short paragraph:
- What moved, stated as the line item and the dollar amount rather than as a percentage alone.
- Why it moved, with the volume and rate components separated where the line scales with revenue.
- Whether it repeats, which is the difference between a timing difference and a permanent change to the run rate.
- What happens next, named to a person with a date, or explicitly marked as accepted with no action.
The third point carries the most weight. A one-time legal expense and a permanent increase in materials cost can produce an identical variance, and they demand opposite responses. Distinguishing them is judgment work, which is why the narrative is written by whoever understands the operations rather than generated automatically.
Written narratives also create a record. Twelve months of them show you which variances recur, which explanations proved wrong, and whether your budgeting is improving. That history is worth more than any single month of analysis.
Why an unexamined profit variance becomes a tax problem
A profit variance you find late is a tax problem you can no longer fix, because the federal system is pay-as-you-go. IRS Topic No. 306 states that income tax must be paid as income is earned or received during the year, through withholding or estimated payments, and that taxpayers should generally make estimated payments in four equal amounts to avoid a penalty.
The mechanics matter for a business running ahead of plan. Estimated payments are frequently set at the start of the year based on the prior year return. If actual profit is running 20% above budget by the third quarter and nobody has revisited those payments, the shortfall is discovered at filing, when the only remaining options are paying the balance and absorbing whatever penalty applies.
The IRS does provide relief for uneven income. Topic 306 notes that a taxpayer receiving income unevenly during the year may be able to vary payment amounts using the annualized installment method, with Form 2210 used to determine whether a penalty is owed. That option only helps if someone is watching the numbers in time to use it.
The reverse case is just as costly. A business running well behind plan may be overpaying estimates all year, handing the government an interest-free loan out of working capital it needs. Either direction, quarterly variance review is what makes proactive tax planning possible rather than retrospective. Your specific situation depends on entity type and prior-year figures, so the calculation belongs with your CPA rather than a rule of thumb.
How to build the report if you do not have one
Building a usable budget vs. actual report takes a working budget, a clean chart of accounts, and a monthly rhythm. Most businesses in this range already have two of the three and simply never connect them.
- Start with a rolling budget rather than a perfect annual one. A directionally correct budget reviewed monthly outperforms a precise budget nobody opens.
- Match the budget to your chart of accounts exactly, since a budget built at a different level of detail than your reporting cannot be compared without manual mapping every month.
- Budget the lines you can influence, and hold fixed commitments like rent and insurance flat rather than spreading estimation effort evenly across everything.
- Set thresholds in writing before the first review, with both a dollar floor and a percentage floor, so investigation follows a rule and not a mood.
- Attach it to the close, producing the report as the final step of the month-end close so it arrives while the period is still actionable.
- Review quarterly with the tax picture included, because the profit variance and the estimated payment schedule are the same conversation.
The report is only as timely as the close that feeds it, which is why businesses that struggle here usually have a close that runs long rather than a budgeting problem. Fixing the sequence tends to fix the report.
Frequently asked questions about budget vs. actual reporting
What is a budget vs. actual report?
A budget vs. actual report compares budgeted amounts against actual results for each line of the income statement, showing the difference in both dollars and percentage terms. It is also called a budget to actual report or a variance report, and its purpose is to measure performance against intent rather than against prior periods.
What is a favorable variance?
A favorable variance is one that improves operating income relative to plan, meaning revenue came in above budget or an expense came in below it. Favorable variances still warrant investigation when they are large, because they frequently reflect timing differences, a missing accrual, or an invoice that has not yet arrived rather than genuine outperformance.
How large does a variance need to be before investigating it?
Variances warrant investigation when they exceed both a dollar threshold and a percentage threshold set in advance, since either test alone produces misleading priorities. Percentage-only rules send attention to small accounts, and dollar-only rules miss deterioration in accounts that have not yet grown large.
What is the difference between a volume variance and a rate variance?
A volume variance is the portion of a cost difference explained by activity level, while a rate variance is the portion explained by unit economics. Separating them shows whether costs rose because you sold more or because each sale became less profitable, and only the second requires a change in how the business operates.
How often should a business review budget vs. actual?
Reviewing budget vs. actual monthly as part of the close is the standard for businesses doing $1M to $20M in revenue, with a deeper quarterly review that includes year-to-date figures and the tax picture. Monthly review catches drift early enough to act, while quarterly review is the natural point to reconsider estimated tax payments.
Can a budget variance affect my estimated tax payments?
A profit variance can significantly affect estimated tax payments, because the federal system requires tax to be paid as income is earned during the year. A business running well ahead of plan may be underpaying estimates set from a prior year return, and a business running behind may be overpaying and tying up working capital unnecessarily.
A Budget Nobody Checks Is Just a Wish
The budget is not the valuable part. The comparison is. A plan that never gets measured against reality produces no information, and the effort that went into building it is spent the moment the file is saved.
What separates businesses that use this report from businesses that merely receive it is not analytical sophistication. It is that someone writes down what changed, why, whether it repeats, and who is handling it, every single month, and that the same person is still asking those questions a year later.
At MBS Accountancy, we produce budget vs. actual reporting with written variance narratives for California businesses doing $1M to $20M in revenue, and we tie the quarterly review to tax projections so the profit picture and the tax picture stay in the same conversation. If your budget lives in a file nobody has opened since January, that is worth talking about.
Ready to talk about your situation? Schedule a free 20-minute call.