Budget vs Actual: The Monthly Variance Review That Runs Your Business
Your Budget Is Collecting Dust
You built a budget in January and nobody has opened it since. Your bookkeeper closes the month, sends a P&L, and you scan it for anything scary. That is not a budget vs actual review. That is a flinch.
A budget vs actual review compares every planned line to what actually happened, then splits each gap into the part caused by price and the part caused by volume. Run monthly against a materiality threshold, it turns a two-page P&L into three decisions you can act on before the quarter closes.
Key Takeaways
- A budget vs actual variance is only useful once you separate rate from volume. A revenue miss from lower bill rates is a pricing problem; the same miss from unsold hours is a sales problem.
- Set a dual materiality threshold before you open the report, a percentage and a dollar floor, so a 15% swing on a $12,000 line does not steal attention from a 6% swing on a $210,000 line.
- Budgets and Budget vs Actuals reports require QuickBooks Online Plus or Advanced. Simple Start and Essentials cannot run them natively.
Build the Report in QuickBooks Online
- Confirm your subscription is Plus or Advanced.
- Go to Reports, then Financial planning, then Budgets.
- Select Create new, choose Profit and loss, pick the fiscal year, and enter amounts by account.
- Save, then run the Budgets vs Actuals report for the closed month and export it to a sheet for the variance columns.
Xero users run the equivalent through Budget Manager and the Budget Variance report. One prerequisite beats the software: the month has to be closed and reconciled first, or the report just measures your bookkeeping lag. That is why the month-end close checklist comes first.
No budget yet? Do not start with a full year. Build a 90-day plan for the eight lines that move the most money, which for most owner-operated businesses are revenue, direct labor, contractors, materials or hosting, rent, insurance, software, and owner compensation. Leave everything else at a trailing three-month average.
Set Materiality Before You Look
Decide what counts as material before you see the numbers, because deciding afterward is just rationalizing. Use a dual threshold, so a line gets investigated only when it clears both gates.
| Annual revenue | Percentage gate | Dollar floor |
|---|---|---|
| $1M to $3M | 5% | $2,500 |
| $3M to $10M | 5% | $5,000 |
| $10M to $20M | 4% | $15,000 |
The dollar floor is the part people skip, and it is the part that saves the meeting. Without it, every small account produces a scary-looking percentage.
Split Every Variance Into Rate and Volume
- Rate variance equals actual rate minus budget rate, times actual volume.
- Volume variance equals actual volume minus budget volume, times budget rate.
Together they reconcile to the line’s total variance. The two drivers translate by industry: billable hours versus effective rate for an agency, subscribers versus average revenue per user for SaaS, orders versus average order value for e-commerce, jobs versus average ticket for trades.
Three Patterns That Predict Trouble
- Favorable subcontractors plus unfavorable payroll. Work did not arrive, so you spent nothing outsourcing it, but your fixed team stayed on payroll. A sales problem wearing a cost mask.
- Favorable revenue plus unfavorable gross margin. You sold more and earned less per unit, usually from discounting or a mix shift. Check price realization before you celebrate the top line.
- Everything favorable except cash. Profit beat plan, yet the bank balance fell. The gap sits in working capital, so pull days sales outstanding alongside the report.
The 30-Minute Review Meeting
Same three people, within five business days of close. Confirm the close is final. Read only the lines that cleared both gates. Split each into rate and volume out loud. Assign one owner and one due date per line. Translate the total operating variance into cash days and decide whether the forecast changes. Then write a variance memo of six sentences or fewer per line. Six months of those memos becomes the most honest history of your business you will ever own.
Frequently Asked Questions
How often should I run a budget vs actual report? Monthly, within five business days of close. Quarterly reviews catch problems a full quarter late.
Can I run it in QuickBooks Online Simple Start? No. Budgeting is available only in Plus and Advanced. Simple Start and Essentials users must upgrade or build the comparison in a spreadsheet.
What is the difference between a rate variance and a volume variance? A rate variance measures the effect of prices or wages that differed from plan, calculated as the rate difference times actual volume. A volume variance measures selling or delivering a different quantity, calculated as the volume difference times the budgeted rate.
Turn the Variance Into a Decision
Thirty minutes, no pitch, no obligation — and you leave with a Custom Financial Roadmap.