Small Business Budget Template: Monthly Variance Review

Keep the original budget beside actual results

Choose one month and one currency. Preserve the approved budget in a dated backup before entering actual results. Use a consistent accounting basis for the two columns: do not compare billed sales in one column with cash collected in the other. Collect the sales report, expense records and outstanding bills needed to explain the month. If a cost has not been recorded yet, mark that limitation in its explanation rather than treating a blank as proof of zero spending.

Use a filled-in monthly example

The fictional business budgets $10,000 revenue, $4,000 variable costs and $3,000 fixed costs. Its planned remainder is $3,000. Actual revenue is $9,000, variable costs $3,800 and fixed costs $3,200, leaving $2,000.

Revenue variance is negative $1,000; variable-cost variance is negative $200; fixed-cost variance is positive $200. Because costs reduce the remainder, the lower variable-cost total adds $200 while the higher fixed-cost total removes $200. Overall remainder is $1,000 below plan.

Explain percentages without a false zero

Amount variance is actual minus budget. Divide by the budget to get a percentage only when the budget is nonzero. Sales variance is negative 10% in the example.

If a line had zero budget and $200 actual spending, the percentage is undefined; the actionable information is the unplanned $200. Do not write 0% or describe an infinite percentage as a meaningful comparison. Review whether the spending was approved and whether it belongs in next month's budget.

Check activity before celebrating lower costs

Lower variable spending can result from fewer orders. In a separate fictional unit check, 200 planned orders at $20 direct cost give $4,000. If 180 actual orders cost $3,800, average cost becomes about $21.11 per order.

Total spending fell, but unit cost rose. Check price, volume, product mix and timing before choosing an action. The free variance worksheet compares totals; it does not calculate this unit-cost diagnosis automatically.

Assign the next decision and keep cash separate

For each material difference, enter its explanation, review owner and review date. An owner can check a supplier price change, a delayed bill or a sales shortfall without rewriting the whole plan. Keep the original variance report, then create a revised forward budget if the evidence warrants it. Check collections, supplier due dates, debt payments and owner withdrawals in a dated cash forecast. The operating remainder here excludes items you have not entered and should not be presented as audited net profit.

Questions about the budget worksheet

Should every variance trigger a change? No; investigate differences that affect your decisions. Can I use GBP, CAD or AUD?

Yes, with amounts already in that currency; the selector does not convert them. Does this replace accounting software? No. Use reconciled records for actual results and keep the report as a planning review.