Budget vs Actual Analysis: The Complete Guide
Budget vs actual (BvA) analysis is the bread and butter of advisory services. Searched 720+ times per month, it's one of the most requested financial reports by business owners — and one of the simplest for bookkeepers to deliver at premium rates.
What Is Budget vs Actual Analysis?
Budget vs actual analysis compares what a business planned to spend and earn against what actually happened. The differences (variances) reveal where the business is on track and where it's off course.
If you're a bookkeeper, you're already 90% of the way there. You have the "actual" side — the books you maintain monthly. You just need the "budget" side and the analytical framework.
Why Clients Love BvA Reports
- Accountability: BvA reports hold departments and managers accountable to their budgets
- Early warning: Catch problems before they become crises (e.g., "labor costs are 15% over budget in Q1")
- Decision support: "Can we afford to hire another person?" becomes answerable with BvA data
- Investor/lender confidence: Shows financial discipline and planning capability
Building a BvA Report: Step by Step
Step 1: Create (or Improve) the Budget
Many small businesses don't have a formal budget. This is your first advisory opportunity:
- Use last year's actuals as a starting point
- Adjust for known changes (new hires, price increases, growth plans)
- Break down by month (not just annual) — seasonality matters
- Get the business owner's input on revenue targets and planned investments
- Charge $1,000-$3,000 for annual budget creation
Step 2: Pull Monthly Actuals
Export the P&L from QuickBooks/Xero at the same level of detail as the budget. Ensure the chart of accounts matches the budget categories.
Step 3: Calculate Variances
For each line item: Variance = Actual − Budget. Calculate both dollar variance and percentage variance.
Step 4: Analyze & Explain
This is where you earn your advisory fee. For every material variance (we recommend >5% or >$1,000), provide:
- What caused it
- Whether it's a one-time item or recurring trend
- What action to take (if any)
Step 5: Present & Discuss
Schedule a 30-45 minute monthly call to walk through the BvA report. This is the advisory relationship builder — it's not just about the numbers, it's about the conversation.
BvA Report Template
| Category | Budget | Actual | Variance ($) | Variance (%) | Notes |
|---|---|---|---|---|---|
| Revenue | $100,000 | $95,000 | ($5,000) | -5.0% | Lost 2 clients in month |
| COGS | $40,000 | $38,500 | $1,500 | 3.8% | Favorable — new supplier pricing |
| Gross Profit | $60,000 | $56,500 | ($3,500) | -5.8% | |
| Payroll | $30,000 | $32,000 | ($2,000) | -6.7% | Overtime due to short staffing |
| Marketing | $5,000 | $3,000 | $2,000 | 40.0% | ⚠️ Underspending hurting lead gen |
| Rent | $4,000 | $4,000 | $0 | 0.0% | On budget |
| Net Income | $15,000 | $12,500 | ($2,500) | -16.7% | Action needed on staffing + revenue |
Pricing BvA Advisory Services
- Budget creation (annual): $1,000-$3,000 one-time
- Monthly BvA report + review call: $500-$1,500/month
- Quarterly BvA + strategic planning: $2,000-$4,000/quarter
- Full CFO service (BvA + forecasting + KPIs + strategic advice): $2,000-$5,000/month
Getting Started This Week
- Identify 3 clients without a formal budget
- Offer a free "financial snapshot" — show them how their spending compares to industry benchmarks
- Propose budget creation ($1,000-$2,000) + monthly BvA analysis ($500-$1,000/month)
- Even at minimum pricing, 3 clients × $500/month = $18,000/year in new advisory revenue
Our Bookkeeper-to-CFO course includes ready-to-use BvA templates, budget creation worksheets, and scripts for pitching advisory services to existing clients.
📊 Free Budget vs Actual Template
Professional BvA report template in Excel/Google Sheets — plug in your numbers and present to clients immediately.
Download Free Starter Kit →