Budget vs Actual Variance Report Generator

What budget vs actual variance analysis tells you

Variance analysis compares planned (budgeted) financial performance to actual results for a given period. It is one of the most fundamental management accounting tools, helping finance teams identify where performance diverged from expectations, investigate the causes, and take corrective action before small variances become large problems.

A favourable variance means actual results are better than budget (higher revenue or lower costs). An unfavourable variance means the opposite. For cost lines, spending less than budget is favourable. For revenue lines, earning more than budget is favourable. This report automatically applies the correct interpretation based on the line item category.

Best practice is to flag any variance exceeding 10% of the budgeted amount for management review. Small variances (under 5%) are typically noise. Variances between 5-10% should be monitored over consecutive periods to identify emerging trends.

Worked example: wholesale distribution business, March review

A Brisbane industrial supplies distributor with AU$12 million annual revenue runs a monthly variance review. The March report shows:

Three variances are significant. Revenue is down 6.5%, which investigation reveals is a single large customer delaying orders until April. COGS is favourable because lower revenue means fewer purchases. The freight variance at -21.9% is the real concern: a fuel surcharge increase from the primary carrier added AU$9,200 to outbound freight costs. That cost increase will persist into April unless the distributor renegotiates or switches carriers.

The wages variance at -2.1% is below the investigation threshold. Rent is fixed and on budget. Without the variance report, the freight cost increase might not surface until the quarterly review, by which time it has cost the business AU$27,000+.

Common causes of budget variances

• Volume variances: Sales volumes higher or lower than forecast, affecting both revenue and variable costs like COGS and freight.
• Price variances: Changes in input costs (materials, wages, fuel surcharges) or selling prices not reflected in the budget.
• Timing variances: Expenses falling in a different period than budgeted. Annual insurance premiums, quarterly BAS payments, and upfront software licences create large single-month variances that net out over the year.
• Efficiency variances: More or fewer resources consumed per unit than budgeted. A manufacturing business using 12% more raw material per unit than the standard produces an unfavourable efficiency variance even if prices are on budget.
• One-off items: Unplanned capital expenditure, legal costs, bad debt write-offs, or windfall revenue from a large project win.

The most useful variance reports separate these causes. A revenue variance of -AU$68,000 could be a volume problem (fewer units sold), a price problem (same units at lower margin), or a timing problem (orders delayed). Without that distinction, the corrective action is unclear.

Getting actuals from Xero or MYOB

Both Xero and MYOB can export a profit and loss report for any period. In Xero, navigate to Reports → Profit and Loss, select the month, and export to Excel. In MYOB, use Reports → Accounts → Profit & Loss Statement. The challenge is that your chart of accounts must align with your budget categories. If your budget tracks "freight outbound" and "freight inbound" separately but your accounting system groups them under a single "freight" account, the variance report cannot separate the two.

For businesses where AP invoices make up the bulk of expenses, the accuracy of the actuals depends entirely on whether invoices have been coded correctly and posted to the right period. Late-coded invoices create timing variances that are accounting artefacts, not real business variances. AP automation that codes invoices at the point of capture and posts them to the correct period removes this source of noise.

How often should variance analysis be performed?

Monthly is the standard frequency for operating businesses. Quarterly variance analysis is common for board reporting. The key is consistency: comparing the same categories and time periods each cycle allows trends to emerge. For businesses with high seasonal variation, comparing to the same month in the prior year (rather than the prior month) often provides more meaningful insight.

How to use this variance report generator

1. Enter your company name and the reporting period (month, quarter, or year).
2. Use the "Standard P&L Categories" quick-fill to pre-populate common line items, or add your own.
3. Enter the budgeted and actual amounts for each category. Variances calculate automatically.
4. Add commentary for significant variances to explain the underlying drivers.
5. Download the completed report as a PDF for board reporting or management review.

Frequently asked questions

What variance threshold should trigger investigation?

Most businesses use 10% as the threshold for mandatory investigation. Variances under 5% are generally noise. Between 5-10%, monitor over consecutive months. The absolute dollar amount matters too: a 15% variance on a AU$2,000 line item may not warrant the same attention as a 7% variance on a AU$500,000 line item.

How often should variance analysis be performed?

Monthly for management review, quarterly for board reporting. For businesses with seasonal variation, compare each month to the same month in the prior year rather than the prior month. Consistency matters more than frequency.

Should I use a fixed or flexible budget for variance analysis?

A fixed budget compares actuals to the original plan regardless of volume. A flexible budget adjusts variable cost budgets based on actual volume. For businesses where costs are heavily volume-dependent (distribution, manufacturing), a flexible budget produces more actionable variances because it separates volume effects from price and efficiency effects.