Budget vs Actual Report: Layout, Variance Rules and Commentary

Build one table for the month and a matching one for year to date, with these columns:

• Line item, grouped by revenue, cost of goods, and operating expense by department.
• Budget.
• Actual.
• Variance in dollars.
• Variance as a percentage of budget.
• A flag for lines that exceed your threshold.
• A short comment field.

Add a full-year column showing the latest forecast against the annual budget once you're a few months in. Keep the account list at the level your managers control. A budget owner shouldn't have to hunt through forty accounts to find the two that matter.

For example, say subscription revenue was budgeted at $250,000 and came in at $262,000, so the variance is +$12,000 or 4.8 percent, which is favorable. Say sales and marketing was budgeted at $80,000 and came in at $94,000, so the variance is $14,000 over, or 17.5 percent, which is unfavorable and worth a note.

Pick one convention and state it on the report. The clearest is to show variance as actual minus budget for revenue and budget minus actual for expenses, so a positive number is always good and a negative one always bad. Then label the column Favorable or Unfavorable so nobody has to work it out.

Mixing conventions is the most common cause of misread reports. A reader sees a plus sign on an expense line and assumes good news, when it means overspend. If your accounting system exports actual minus budget for everything, add a column that flips expenses, or color-code the flags consistently.

Treat percentage variances with care on small lines. For example, a 50 percent overrun on a $200 budget line doesn't deserve a meeting. That's why the threshold should combine a percentage and a dollar amount.

Set a rule and apply it every month. For example, you might require an explanation when a line is off by more than ten percent and by more than a set dollar amount, with the dollar figure tied to your size. Keep the threshold stable so managers know what to expect, and adjust it once or twice a year, not every month.

Margins tell you why small misses matter. In NYU Stern's January 2026 industry data, net margins range from 1.25 percent for healthcare support services to 25.49 percent for software¹. In a business at the low end, a one-point cost overrun can wipe out most of the profit, so the threshold should be tighter there than in a high-margin business.

Also flag lines that are within the threshold but drifting in the same direction for three months in a row. Slow leaks don't trip a one-month rule.

Ask each budget owner to answer four questions in a sentence or two:

1. What happened? State the cause in operational terms, such as a conference deposit paid earlier than planned or a contractor hired for a project that wasn't in the budget.
2. Is it timing or permanent? A timing variance reverses; a permanent one changes the full-year number.
3. What's the effect on the full year? Give a revised estimate.
4. What action is planned? Cut spend elsewhere, ask for more budget or accept the change.

Banish comments like higher than expected or per plan. They restate the number. Good commentary explains something the table can't. Review the flagged lines in a short monthly meeting rather than circulating a document nobody opens, and record decisions next to each item.

A budget set in December can be wrong by April. Don't keep measuring against a plan everyone knows is out of date. Instead, keep the original budget as the fixed reference and add a reforecast: actuals to date plus your updated estimate for the remaining months. Show both, so leadership sees the plan, the current expectation and the gap between them.

Build the forecast from operating drivers, such as headcount and volumes, instead of extending last year's totals. Tools like Jirav and Mosaic can connect actuals from your accounting system to budgets and produce these comparisons automatically; see Jirav vs Cube vs Mosaic and confirm in a demo how each handles your chart of accounts. For a fuller monthly package, the board financial reporting package template shows where BvA fits. If you're building the plan itself, start with the SaaS financial model guide.