What is the variance formula?

Dollar variance is actual minus budget. For a positive budget, percentage variance is that difference divided by budget, multiplied by 100. Define the convention in the report and label its business meaning separately. For zero budgets, show the dollar difference and mark the percentage as not applicable.

Should I compare monthly or year-to-date results?

Use both. The monthly view identifies recent changes and close errors. The year-to-date view shows whether timing differences have reversed or accumulated. Use matching periods and consistent account categories.

Is a favorable expense variance always good?

No. Lower expense can reflect a missing invoice, a late hire, or deferred maintenance. Determine whether the books are complete and whether the saving changes future costs before treating it as an improvement.

Should I replace the budget with the latest forecast?

Keep the approved budget as the accountability baseline. Add the latest forecast as a separate comparison if useful. Replacing the budget makes it harder to see how performance differs from the original commitments.

Who should explain each variance?

Finance checks the accounting and assembles the report. The person responsible for the revenue or expense confirms the business cause and proposed action. A reviewer checks that the explanation accounts for the full material difference.

Guide

Budget against actual reporting for a monthly close

By the Vanward team · Last updated October 24, 2026

Budget against actual reporting compares closed financial results with the approved plan for the same month and year to date. Keep the original budget fixed, map actual accounts to the same categories, and calculate both dollar and percentage differences. Then explain material variances by cause, amount, and whether they will recur. Revenue above plan and expenses above plan have different implications, so label favorable and unfavorable results explicitly rather than relying on a sign alone. During the monthly close, resolve posting errors before distributing the report, retain the supporting detail, and assign an owner to any action or forecast change that follows.

Use the same basis on both sides

Save the approved budget version before reporting begins. Match the actual and budget entity, currency, month, and accounting basis. Map ledger accounts to budget categories consistently, including new accounts. Post or resolve close adjustments before calling the actual column final, and rerun the report if those adjustments change it.

Show budget, actual, dollar variance, percentage variance, and explanation for each major revenue and expense category. Add year-to-date columns to distinguish a shift between months from a lasting change. If a budget is zero, use a dollar explanation instead of dividing by zero. For negative budgets, define a meaningful convention or omit the percentage.

A worked monthly report

A fictional company uses actual minus budget for dollar variances. Percentages below use the positive budget as the denominator. These operating costs exclude cost of revenue, which is already included in gross profit.

Line	Budget	Actual	Variance	Interpretation
Revenue	$200,000	$180,000	-$20,000 / -10%	Unfavorable
Cost of revenue	$80,000	$75,000	-$5,000 / -6.25%	Favorable in dollars
Gross profit	$120,000	$105,000	-$15,000 / -12.5%	Unfavorable
Operating costs	$90,000	$96,000	+$6,000 / +6.67%	Unfavorable
Operating profit	$30,000	$9,000	-$21,000 / -70%	Unfavorable

The profit bridge is $30,000 less the $20,000 revenue shortfall, plus $5,000 lower cost of revenue, less $6,000 additional operating costs, giving $9,000. Lower cost of revenue alone does not establish improved efficiency: gross margin fell from 60% to about 58.3%.

Suppose a delayed customer launch explains the $20,000 revenue gap and related delivery costs explain the $5,000 reduction. A one-time legal invoice explains the $6,000 overrun. The sales owner should confirm the revised launch date, and finance should confirm that the legal invoice belongs in this month. Each explanation covers an amount and a cause.

Turn explanations into a review

Agree on dollar and percentage thresholds before reviewing results, with exceptions for sensitive accounts. Separate errors, timing differences, and lasting business changes. For timing, name the expected reversal month. For recurring changes, record the effect on the forecast. Give each unresolved item an owner and due date, then retain the reviewed report with the close package.

What this looks like in Vanward

FinReadi Close includes a variance review step. The step holds supporting files and explanations alongside preparer and reviewer assignments. Attach the budget comparison prepared in your reporting workbook so the review and its evidence stay with the period.

Use the free close check to assess the close process supporting the actual results before building the management report.

Questions controllers ask

What is the variance formula?: Dollar variance is actual minus budget. For a positive budget, percentage variance is that difference divided by budget, multiplied by 100. Define the convention in the report and label its business meaning separately. For zero budgets, show the dollar difference and mark the percentage as not applicable.
Should I compare monthly or year-to-date results?: Use both. The monthly view identifies recent changes and close errors. The year-to-date view shows whether timing differences have reversed or accumulated. Use matching periods and consistent account categories.
Is a favorable expense variance always good?: No. Lower expense can reflect a missing invoice, a late hire, or deferred maintenance. Determine whether the books are complete and whether the saving changes future costs before treating it as an improvement.
Should I replace the budget with the latest forecast?: Keep the approved budget as the accountability baseline. Add the latest forecast as a separate comparison if useful. Replacing the budget makes it harder to see how performance differs from the original commitments.
Who should explain each variance?: Finance checks the accounting and assembles the report. The person responsible for the revenue or expense confirms the business cause and proposed action. A reviewer checks that the explanation accounts for the full material difference.

How ready is your close?

Eight yes-or-no questions, two minutes, no account. You get a score out of 100 and the three gaps most likely to come up in an audit or a diligence request.

Take the free close check