Budget vs Actual: How to Build a Variance Report (With Example)

Quick answer: A budget vs actual report puts each budgeted line beside the real result for the same period and shows the variance (actual minus budget) in dollars and percent. Label each variance favorable or unfavorable, investigate the ones above your threshold, and use the causes to adjust spending, pricing or next period's budget.

A budget only helps if you check it. The budget vs actual comparison, often presented as a variance report, is how small business owners turn a plan into a monthly management tool. Much of the revenue side comes straight from the invoices you send, so consistent invoicing with a tool like our free invoice generator makes the actual column far easier to trust.

This guide explains the formulas, shows a complete variance report with numbers that reconcile, covers flexible budgets and volume vs rate analysis, and lists the actions that typically follow each type of variance.

What is a budget vs actual report?

A budget vs actual report (also called a budget variance report or plan vs actual) compares the figures in your small business budget with the results recorded in your books for the same period. The actual side normally comes from your profit and loss statement, so the report follows the same line structure: revenue, cost of sales, operating expenses and profit.

The US Small Business Administration encourages owners to compare costs with the revenue they generate as part of managing their finances (see the SBA guide to managing your finances). A monthly variance report is the most practical way to do that across the whole business, not just one campaign.

Budget vs actual formulas

You need three calculations:

• Dollar variance = Actual minus Budget.
• Percent variance = (Actual minus Budget) divided by Budget, multiplied by 100.
• Favorable or unfavorable: for revenue and profit, actual above budget is favorable. For costs, actual below budget is favorable.

The sign trap catches many people. A plus $1,200 variance on revenue is good news; a plus $1,200 variance on contractor costs is bad news. Always add an F or U label (favorable or unfavorable) so the report reads correctly at a glance.

How to build a variance report in 7 steps

1. Close the month first. Reconcile bank and card accounts, enter all supplier bills and issue all customer invoices for the period. A rushed actual column creates fake variances. Our month-end close checklist covers the essentials.
2. Match the line structure. Use the same account groupings in budget and actual. If your budget has "Software" but your books split it across three accounts, roll them up the same way.
3. Use the same accounting basis. Accrual budget, accrual actuals; cash budget, cash actuals. Our guide to cash vs accrual accounting explains why this matters.
4. Calculate dollar and percent variances for every line, plus subtotals for total revenue, total expenses and profit.
5. Label each variance F or U.
6. Apply your materiality rule. For example, investigate lines that are both more than 10% and more than $500 off budget.
7. Write a one-line explanation and an action for every flagged line, and carry the actions into next month's plan or cash flow forecast.

Worked example: a monthly variance report

A small design agency budgets 400 billable hours in September at $100 an hour, and expects to use 200 contractor hours at $60 an hour. Here is the September budget vs actual report.

Line	Budget	Actual	Variance ($)	Variance (%)	F/U
Revenue	$40,000	$36,500	-$3,500	-8.8%	U
Contractor costs	$12,000	$13,200	+$1,200	+10.0%	U
Software	$1,500	$1,380	-$120	-8.0%	F
Rent	$3,000	$3,000	$0	0.0%	-
Marketing	$2,500	$1,900	-$600	-24.0%	F
Total expenses	$19,000	$19,480	+$480	+2.5%	U
Net profit	$21,000	$17,020	-$3,980	-19.0%	U

Check the totals: budgeted expenses are $12,000 + $1,500 + $3,000 + $2,500 = $19,000, and actual expenses are $13,200 + $1,380 + $3,000 + $1,900 = $19,480. Budgeted profit is $40,000 minus $19,000 = $21,000; actual profit is $36,500 minus $19,480 = $17,020. The profit variance of minus $3,980 equals the revenue variance (minus $3,500) less the extra $480 of net expense. As a percentage, $3,980 divided by $21,000 is 18.95%, shown rounded to 19.0%.

Which lines to investigate

Using the "more than 10% and more than $500" rule:

• Revenue is $3,500 off but 8.8%, just under the percentage limit. Because it is the largest dollar gap and drives the profit shortfall, most owners would still review it. A sensible tweak is to always review revenue and profit regardless of the rule.
• Contractor costs are exactly 10.0% and $1,200 over. Flag it.
• Marketing is 24% and $600 under. Favorable, but check whether a campaign was simply delayed into October (a timing variance).
• Software is $120 under: below the dollar floor, so no action.

Volume vs rate: finding the real cause

A variance tells you where to look, not why. Splitting it into volume and rate effects gets you closer.

In the example, the agency billed 365 hours at the planned $100 rate: 365 multiplied by $100 = $36,500. The whole revenue shortfall is a volume variance: 35 fewer hours multiplied by $100 = $3,500. The rate held, so pricing was not the problem; capacity or demand was.

Contractor costs tell a different story. The agency paid the planned $60 rate but used 220 hours: 220 multiplied by $60 = $13,200. That is 20 extra hours, or $1,200, even though billable work fell. When paid hours rise while billable hours fall, the usual suspects are rework, unbilled extra scope or poor scheduling. Our guide on billing extra work with a scope creep change order covers how to recover that cost from clients when the extra work was their request.

Flexible budget comparison

A static budget compares against the original 400-hour plan. A flexible budget first adjusts variable costs to the actual activity level. Contractor costs were planned at $12,000 for 400 billable hours, so at 365 hours the flexed budget is $12,000 multiplied by 365 divided by 400 = $10,950. Actual contractor cost of $13,200 is therefore $2,250 over the flexed budget, almost double the static variance of $1,200. The flexible view shows the efficiency problem more clearly. Knowing which of your costs are variable is essential here; see fixed vs variable costs, and our guide to contribution margin shows how variable costs eat into each dollar of revenue.

Types of variance and what to do about them

Variance type	Typical sign	Likely action
Timing (bill or invoice in a different month)	Reverses next month	Note it, check year-to-date, no change needed
Volume (more or fewer units or hours)	Revenue and variable costs move together	Review sales pipeline, capacity, staffing
Rate or price	Same volume, different price	Review pricing, supplier terms, discounts given
Efficiency	More input per unit of output	Fix process, scope control, scheduling
One-off	Single large item	Document it, exclude from trend analysis
Coding error	Over in one line, under in another	Correct the books, rerun the report
Budget error	Same variance every month	Re-forecast the budget line

Revenue variances start with your invoices

On an accrual basis, revenue in the actual column is the total of invoices issued for the period. Late or missing invoices are one of the most common causes of a revenue variance that turns out to be timing. Issue invoices on the same day work is delivered, number them consistently with an invoice number generator, and record discounts on the invoice itself rather than as a separate adjustment, so price variances are visible.

On a cash basis, revenue is money received, so slow payers create variances even when sales are on plan. In that case, the fix is collection rather than sales: clearer invoice payment terms, reminders and deposits.

Budget vs actual best practices

• Show year-to-date as well as the month. A month can be noisy; year-to-date shows the trend.
• Keep the report to one page. Owners and managers will read a single page with clear F/U flags.
• Explain, then act. Every flagged line gets one sentence of cause and one action with an owner.
• Re-forecast when the budget is clearly wrong. Keep the original budget for reference but add a forecast column so decisions use realistic numbers.
• Watch overhead separately. Rent, software and insurance rarely vary by volume, so creeping overhead costs show up as small, persistent unfavorable variances.
• Review cash too. A profit variance and a cash variance are not the same. Pair this report with a cash flow management routine.

Month vs year-to-date: reading both views

A single month can mislead. Suppose the agency's marketing line was $600 under budget in September because a $600 campaign slipped into October. In October, marketing will then be $600 over budget, and the September favorable variance and October unfavorable variance cancel out. A year-to-date column shows this immediately: if year-to-date marketing is on budget, the monthly swings are timing, not a problem.

A practical layout puts the month and year-to-date side by side:

Line	Sept budget	Sept actual	Sept var.	YTD budget	YTD actual	YTD var.
Marketing	$2,500	$1,900	-$600 F	$22,500	$22,350	-$150 F

Here the year-to-date budget is nine months at $2,500, or $22,500, and year-to-date actual spend is $22,350, so the business is only $150 under plan for the year. The $600 September gap is almost entirely timing. Revenue and profit deserve the same treatment: a weak month inside a strong year-to-date result calls for a closer look at the pipeline, not a panic cut in spending.

Budget vs actual report template

You can build a reusable variance report in any spreadsheet. Use one row per budget line and these columns:

Line | Budget (month) | Actual (month) | Variance $ | Variance % | F/U | Budget (YTD) | Actual (YTD) | Variance $ (YTD) | Variance % (YTD) | Flag | Explanation | Action | Owner

Useful formulas:

• Variance $ = Actual minus Budget.
• Variance % = Variance $ divided by Budget (guard against division by zero when a line has no budget).
• F/U for revenue lines: "F" if variance is positive, otherwise "U". For cost lines, reverse it.
• Flag: "Review" if the absolute variance is above your dollar floor and the absolute percentage is above your percentage limit.

Paste the actual figures from your accounting software each month, or link them from an export. Keep the explanation and action columns short and specific: "Rework on two client projects; add review step before handoff" is more useful than "contractor costs high".

Common budget vs actual mistakes

• Comparing different periods. A budget built on calendar months compared with actuals pulled for a four-week period will always show false variances.
• Ignoring small lines forever. A $120 favorable variance is noise once, but the same overspend every month adds up to $1,440 a year. Scan the year-to-date column for persistent drift.
• Celebrating every favorable variance. Spending less than planned on marketing or maintenance can hurt next quarter's revenue or cause bigger repairs later. Ask whether the saving was deliberate.
• Changing the budget to hide variances. Re-forecast in a separate column, but keep the original budget so you can learn how accurate your planning was.
• No follow-up. A report without actions is a history lesson. Check last month's actions before you discuss this month's numbers.

Who should see the report

In a small business, the owner, any managers responsible for budget lines, and the bookkeeper or accountant should all see the monthly report. Give each manager the lines they control, and agree the actions at a short monthly meeting. When people know their lines will be reviewed every month, budgets become commitments rather than guesses, and the next annual budget becomes more accurate because it is built on twelve months of explained variances.

Budget vs actual for very small businesses

If you are a freelancer or a two-person business, you do not need a 40-line report. Five lines are enough: revenue, direct costs, overhead, owner pay and profit. Build the budget once a year, compare it monthly, and focus on the two biggest variances. If your budget feels unreliable, rebuilding it from zero can help; see our guide to zero-based budgeting.

Make the actual column easy to trust. Accurate invoices are the starting point for every budget vs actual report. Create, number and download professional invoices for free with our invoice generator, or choose a clean, readable layout from our minimal invoice template. No sign-up is needed, and your PDF invoice is ready to send in a few minutes.