Variance Analysis: The Complete Guide for Advisory Professionals
Variance analysis is one of the most powerful — and most underused — tools in a bookkeeper's advisory toolkit. With 2,900+ monthly searches, it's clear that businesses want help understanding why their actual results differ from their budgets. This is your opportunity.
What Is Variance Analysis?
Variance analysis compares actual results to planned/budgeted figures and investigates the reasons for any differences (variances). It's the difference between saying "you spent $50,000 on materials" and saying "you spent $8,000 more on materials than planned because supplier prices increased 12% and you ordered 5% more than budgeted."
The second statement is worth paying for. The first is just bookkeeping.
Types of Variances
Favorable vs. Unfavorable
- Favorable variance: Actual results are better than budget (lower costs or higher revenue)
- Unfavorable variance: Actual results are worse than budget (higher costs or lower revenue)
- Important: "Favorable" doesn't always mean "good" — spending less on marketing might be "favorable" on paper but hurt growth
Key Variance Categories
| Variance Type | Formula | What It Tells You |
|---|---|---|
| Revenue Variance | Actual Revenue − Budgeted Revenue | Are you selling more or less than planned? |
| Price Variance | (Actual Price − Standard Price) × Actual Quantity | Are you paying more or less per unit than expected? |
| Quantity Variance | (Actual Quantity − Standard Quantity) × Standard Price | Are you using more or less material/time than expected? |
| Spending Variance | Actual Spending − Budgeted Spending | Did you overspend or underspend vs. plan? |
| Volume Variance | (Actual Units − Budgeted Units) × Standard Contribution Margin | Did you sell more or fewer units than planned? |
| Mix Variance | Difference due to selling a different product mix than budgeted | Did your product mix shift toward higher or lower margin items? |
Variance Analysis as an Advisory Service
Here's why variance analysis is the perfect advisory upsell for bookkeepers:
- You already have the data. As their bookkeeper, you have all their actual financial data. You just need to compare it to a budget.
- It's recurring. Variance analysis is done monthly — that's a monthly advisory fee.
- It's actionable. Every variance report leads to a conversation about what to do differently. Clients love this.
- It's hard to automate. Software can calculate variances, but interpreting them and recommending actions requires human judgment.
How to Price Variance Analysis Services
- Basic (5-10 line items): $500-$750/month — compare actual vs. budget for major categories
- Standard (20-30 line items): $1,000-$1,500/month — detailed departmental analysis with monthly review call
- Premium (full P&L + balance sheet): $2,000-$3,000/month — comprehensive analysis with written commentary and strategic recommendations
Building a Variance Analysis Report
A good variance report has four sections:
1. Executive Summary
One paragraph: Overall performance vs. budget. Net income variance. Top 3 variances that need attention.
2. Revenue Analysis
Break down revenue variance by: price vs. volume, product/service line, customer segment, and geography (if applicable).
3. Expense Analysis
Walk through each major expense category: COGS, labor, overhead, marketing, G&A. For each, explain the variance and its root cause.
4. Recommendations
This is where the advisory magic happens. Don't just report what happened — tell the client what to do about it. Specific, actionable recommendations tied to the data.
Common Pitfalls in Variance Analysis
- Ignoring materiality: Don't waste time on $50 variances when there's a $50,000 one to investigate
- Bad budgets: Garbage in, garbage out. If the budget is unrealistic, variances are meaningless. Help clients build better budgets.
- One-time items: Separate recurring variances (need attention) from one-time items (just note and move on)
- Percentage obsession: A 200% variance on a $100 item is less important than a 5% variance on a $500,000 item
Getting Started
Ready to add variance analysis to your service offering? Start here:
- Pick one client who already has a budget (or help them create one)
- Pull actual vs. budget data for last month
- Calculate variances for the top 10 expense categories + total revenue
- Write a one-page summary with 3 recommendations
- Present it in a 30-minute call
- Propose making this a monthly service
Our Bookkeeper-to-CFO course includes variance analysis templates, client presentation decks, and step-by-step guides for building this into a premium advisory service.
📊 Free Variance Analysis Template
Download our Excel/Google Sheets template that automatically calculates variances and generates a client-ready report.
Download Free Starter Kit →