Budget vs Actuals: How to Analyze Variance

You've built your budget. Now comes the hard part: actually using it. Budget vs actuals (BvA) analysis is where the rubber meets the road. It's how you know whether your startup is on track or drifting off course. Without this analysis, your budget is just a document that gathers dust. But with proper variance analysis, you can identify problems early, make better decisions, and build credibility with investors and your board. In this guide, we'll walk through how to set up budget vs actuals tracking, analyze variances effectively, and turn insights into action.

Budget vs actuals (BvA) analysis is the process of comparing what you planned to spend or earn (the budget) against what actually happened (actuals). The difference between these two numbers is called the variance. For example, if you budgeted $50,000 for marketing in Q1 but spent $42,000, you have an $8,000 favorable variance (you spent less than planned). If you budgeted $100,000 in revenue but only earned $85,000, you have a $15,000 unfavorable variance (you fell short). This sounds simple—and it is conceptually. But the art lies in understanding WHY variances occur and determining whether they warrant action. A $10,000 variance in revenue might seem concerning, but if it's due to a large deal shifting from March to April (timing difference), it's not a real problem. The same $10,000 variance due to losing a key customer (true variance) is a serious issue that needs response.

Before you can analyze variances, you need a proper report structure. Here's how to set up budget vs actuals tracking: Choose Your Timeframe Most startups review BvA monthly, with quarterly roll-ups. Monthly is granular enough to catch issues early but aggregated enough to avoid noise from daily fluctuations. Align with Your Close Close your books within 5-10 business days after month end. The faster you close, the faster you can analyze and act. Budget vs actuals is only useful if the data is fresh. Define Your Categories Your budget categories should match your P&L categories for easy comparison. Common categories include: Revenue (by product line or channel if applicable) Payroll (can be broken into departments) Marketing (paid acquisition, content, events, tools) Software and tools Facilities Professional services Other expenses Create the Report Format A standard BvA report should show: Category, Budget amount, Actual amount, Variance ($), Variance (%), and Notes/Explanation. Add a column for year-to-date (YTD) comparison as well, since monthly numbers can be misleading for seasonality or lumpy expenses.

Not all variances are created equal. Understanding the type of variance helps you determine whether action is needed. Timing Variances A timing variance occurs when a transaction is expected in one period but actually occurs in another. Example: A $50,000 invoice was expected in March but was sent in April. Revenue is down $50,000 in March but will be up in April. No real problem—just cash timing. How to identify: The year-to-date numbers are close, but monthly varies significantly. Volume Variances A volume variance occurs when the quantity of something differs from plan. Example: You planned to hire 3 salespeople but only hired 2. Payroll is under budget because you have fewer people. Rate Variances A rate variance occurs when prices or costs per unit differ from plan. Example: You budgeted $100,000 for software but spent $120,000 because you upgraded to a more expensive tier. True Variances A true variance is when the underlying assumption was simply wrong. Example: You expected 10% monthly revenue growth but only grew 5%. The variance represents real shortfall, not timing or rate differences. This is the most important type to understand and address.

Now that you understand variance types, here's how to actually do the analysis: Step 1: Review All Categories Start by looking at everything. Don't just focus on the big numbers—sometimes small categories reveal important insights. Step 2: Focus on Material Variances Anything over 10% or $1,000 (whichever is larger) deserves attention. Smaller variances are usually noise. Step 3: Classify Each Variance Determine whether each material variance is timing, volume, rate, or true. This is where experience and judgment matter. Step 4: Investigate Root Causes Ask: Why did this variance occur? What assumptions were wrong? What can we learn? Step 5: Determine Action Needed Some variances require action (adjust plans, re-forecast, change processes). Others are just information. Step 6: Document Insights Keep a log of why variances occurred. Over time, this helps you improve budget accuracy. Step 7: Update Future Budgets Use insights to make next month's or next quarter's budget more accurate.

Understanding common variance causes helps you investigate more efficiently. Here are the most frequent reasons startups miss their budgets: Revenue Variances Pipeline overestimation (too optimistic about close rates) Customer churn higher than expected Delayed decision-making by prospects Competitor actions affecting your market Deals slipping to next quarter or lost entirely Payroll Variances Hiring delays (roles take longer to fill than planned) Signing bonuses to secure candidates Higher than expected salary demands Departures causing temporary gaps (continuing to pay departed employees in error) Marketing Variances Campaign performance (CPC higher than expected) Timing of campaigns (running earlier/later than planned) Unexpected opportunities (new channel that wasn't in budget) Vendor price changes Software Variances Volume-based pricing (more usage = more cost) Adding tools not originally planned Price increases from vendors Annual subscription true-ups Unexpected needs (security tools, compliance requirements)

Variance analysis should inform whether you need to re-forecast. Here are the triggers: Consistent Unfavorable Variance If you're 15-20% over budget for 2-3 consecutive months, your budget is no longer a useful planning tool. Re-forecast immediately. Material One-Time Events A major customer loss, unexpected large expense, or significant revenue win warrants immediate re-forecast regardless of trend. Board or Investor Concerns If your board asks about a specific variance or expresses concern, address it through re-forecast if needed. Strategic Changes Any change in strategy (new product, market expansion, pivot) invalidates your current forecast.

Make BvA analysis a habit, not an event. Here's how: Schedule It Block time monthly for BvA review—it's as important as your all-hands. Involve Department Heads Share variance reports with team leads. They often have better explanations than finance. Look for Patterns Single variances are information; trends are insights. Track month-over-month to spot patterns. Don't Over-React One bad month doesn't mean your budget is wrong. Look for sustained trends. Communicate Transparently Share variance analysis with your board. They appreciate honesty about challenges. Use the Right Tools Set up your accounting software or FP&A tool to generate BvA reports automatically.