NEWS & RESOURCES

What Is a Variance Analysis (and Why Should You Create One)?

Charlie Miracle

Charlie Miracle, CPA, Member, and Director of Client Accounting Services

By: Charlie Miracle, CPA, Member, and Director of Client Accounting Services

Creating a budget is a crucial task for any business. It helps owners, executives, and managers estimate revenues and expenses, set goals, and closely monitor costs throughout the year.

Of course, budgets are just that — estimates. The actual amounts for revenues and expenses at the end of the month, quarter, or year will almost certainly differ from budget projections. Those differences are called variances and analyzing those variances can give leaders a deeper understanding of a company’s financial well-being. 

What is variance analysis?

Variance analysis investigates the differences between budgeted and actual results.

For example, if you budget for $1 million in sales and actual sales are $800,000, your variance is negative $200,000. Comparing your budget to actual results is a helpful first step but investigating the reason for the difference is essential.

  • Why did the company not meet its revenue goal?
  • Did they lose a big customer?
  • Is demand for the product or service waning?
  • Is a new marketing campaign not having the desired result?
  • Are high prices turning customers away?

These factors and others can contribute to variances, so taking the time to understand why fluctuations occur can help management know what they need to do to change the situation. 

What causes budget variances?

Variances can occur for various reasons. Some of the most common include:

  • Economic changes. Inflation, recessions, consumer confidence levels, and other market changes can impact sales and costs.
  • Errors. Humans and computers may make errors, such as transposing numbers, misplacing a decimal, missing a transaction, or posting the same transaction twice.
  • Pricing changes. A supplier may increase prices after you’ve finalized your budget, leading to an unfavorable variance in the cost of goods sold.
  • Fraud. Employees may misappropriate assets, engage in payroll fraud, or manipulate numbers to make their results appear better than they are. Dishonest vendors or suppliers can engage in billing schemes, check tampering, or price-fixing, resulting in overinflated expenses.
  • Process improvement. Improving processes can increase efficiency and lower costs, creating favorable variances.
  • Competition. New competitors entering the market can negatively impact sales. On the other hand, a competitor going out of business can lead to an unexpected influx of customers.

How is a variance analysis created?

Modern accounting software makes creating a variance analysis relatively straightforward. Most solutions include a budget-to-actual report that compares actual results to the budget and finds the difference between the two values as a number and a percentage.

You can then export this report to an Excel or Google spreadsheet, adding a column for explanations for any budget deviations.

The following best practices can make this process more manageable.

  • Implement thresholds for materiality. To avoid wasting time investigating minor variances, determine a materiality threshold. That threshold will be different for each company. For example, a company with $200 million in revenue might not be concerned with a $200,000 variance, but the same variance could be very significant for a company with $2 million in revenue. You can define your materiality levels in terms of absolute figures (i.e., investigate all variances of more than $1,000) or percentages (i.e., investigate all variances higher than 10% from budgeted amounts).
  • Work with a cross-functional team. Accounting and finance professionals usually are tasked with creating and reporting on variances. However, getting to the bottom of those variances requires input from several departments, including sales, operations, marketing, human resources, and purchasing.
  • Investigate positive and negative variances. Negative variances are those unfavorable regarding the company’s profits, while positive variances are those favorable for company profits. It’s tempting to look only at negative variances; however, it’s just as important to analyze favorable variances, as this can help business leaders identify what is working and lead to more accurate budgets in the future.
  • Compile a variance report. Compile the results of your analysis into a variance report for management. The report should include the variances identified, the root causes of each variance, and corrective actions or recommendations.

How often should you prepare variance reports?

The cadence with which you prepare variance reports will depend on the size of your company and management needs. A small business might only go through the process quarterly or annually.

On the other hand, a larger company or one that is experiencing rapid growth might perform the analysis every month.

At a minimum, you should review your budget to actual numbers every month, looking for unexpected discrepancies. This high-level review can help you quickly spot errors or identify trends so you can take action to keep the business on track.

Do you need help analyzing or setting up your variance reports? Give our team of professionals at Cordell, Neher & Company, PLLC a call at (509) 663-1661 to set up a strategy.

Events & Deadlines

Latest Past Events

2024 Shred Event

Cordell Neher & Company, PLLC 175 E Penny Rd #1, Wenatchee

CNC Newsletter

Subscribe and stay informed on policy changes that could have an impact on you.
Something went wrong. Please check your entries and try again.

Leave a Comment





TaxCaddy Login

Avantax Login

SafeSend

CPA/Tax Documents Only

Footer Contact

  • This field is for validation purposes and should be left unchanged.

(509) 663-1661  - Wenatchee
(800) 767-7725  - Toll Free

(509) 662-5678
Fax Number

P.O. Box 3068
Wenatchee, WA 98807-3068

Check the background of your financial professional on FINRA's BrokerCheck®

Privacy & Usage: The information on the Cordell, Neher & Company, PLLC website is provided with the understanding that it should not be substituted, in any way, for consultation with a professional Certified Public Accountant, accountant, tax, legal or other competent advisor. Cordell, Neher & Company, PLLC makes every attempt to ensure that the information contained on their websites are obtained from reliable sources, but is not responsible for any errors and/or omissions or from the results obtained from the use of any information. This site contains links to servers maintained by other organizations. Cordell, Neher & Company, PLLC cannot provide any warranty regarding the accuracy or source of information found on any of these servers, the content of any file the user might use to download from a third-party site, and is not responsibility for the content found on any of these servers or for any links these servers maintain with other servers.

Avantax affiliated advisors may only conduct business with residents of the states for which they are properly registered. Please note that not all of the investments and services mentioned are available in every state. Securities offered through Avantax Investment ServicesSM, Member FINRA, SIPC, Investment Advisory services offered through Avantax Advisory ServicesSM,Insurance services offered through an Avantax affiliated insurance agency. 3200 Olympus Blvd., Suite 100 Dallas, TX 75019 972-870-6000.

Avantax financial professionals may only conduct business with residents of the states for which they are properly registered. Please note that not all of the investments and services mentioned are available in every state. Securities offered through Avantax Investment Services.SM, Member FINRA, SIPC. Investment Advisory Services offered through Avantax Advisory Services SM. Insurance services offered through an Avantax affiliated insurance agency. Method 10® is property of Avantax Wealth Management.SM All rights reserved 2020. The Avantax family of companies exclusively provide investment products and services through its representatives. Although Avantax Wealth Management does not provide tax or legal advice, or supervise tax, accounting or legal services, Avantax representatives may offer these services through their independent outside business. This information is not intended as tax or legal advice. Please consult legal or tax professionals for specific information regarding your individual situation.

The Avantax family of companies exclusively provide financial products and services through its financial representatives. Although Avantax Wealth ManagementSM does not provide or supervise tax or accounting services, Avantax Representatives may offer these services through their independent outside business. Content, links, and some material within this website may have been created by a third party for use by an Avantax affiliated representative. This content is for educational and informational purposes only and does not represent the views and opinions of Avantax Wealth ManagementSM or its subsidiaries. Avantax Wealth ManagementSM is not responsible for and does not control, adopt, or endorse any content contained on any third party website.

This information is not intended as tax or legal advice. Please consult legal or tax professionals for specific information regarding your individual situation. Investments & Insurance Products: Are not insured by the FDIC or any federal government agency- Are not deposits of or guaranteed by the bank or any bank affiliate- May lose Value

Avantax Investment ServicesSM and Avantax Advisory ServicesSM are not affiliated with CNC Financial Group, LLC.

CNC-icon-white-02

© 2024 Cordell, Neher & Company PLLC • Designed by Pixel to Press