Start your business
Start your business
Run your business
Run your business
Grow your business
Grow your business
Accountants and Bookkeepers
Accountants and Bookkeepers
- Accountants and Bookkeepers
  Learn how accountants and bookkeepers can be productive in these articles & guides
- Learning and Development
  A range of informative content to enhance your QuickBooks experience.
Updates
Updates
- Product Updates
  Watch this space for monthly product updates.
- Intuit News
  Latest news, articles & guides

Need help choosing a plan?

1800 917 771 Schedule a call

Schedule call

Variance analysis: a 2021 guide to cost control

January 16, 20216 min read

Variance analysis is the practice of evaluating the difference between budgeted costs and actual costs within your business. Whether you’re assessing sales, employee efficiency or overhead costs, understanding discrepancies between expectations and outcomes is essential to maintain a steady cash flow.

Knowing that you missed your target budget is one thing, but you need to see more than the bottom line. You need a quantitative investigation into why your target budget wasn’t met so that you can make evidence-based decisions for the financial future of your business. That’s where variance analysis comes in.

In this article, we will explore the different types of variances and how analysing them can help you take control of your budget.

What is a variance analysis?

Before we dig into the specifics of this financial analysis technique, it’s important to understand what a variance is in the first place. The simplest definition of a variance is a discrepancy between what you planned to spend and what you actually spent.

Accordingly, a variance analysis is the practice of extracting insights from the variance numbers in order to make more informed budgeting decisions in the future.

What does analysis of variance tell you?

In statistics, analysis of variance is sometimes abbreviated to ANOVA. It can be applied to many different uses in science and engineering, but the main business objectives of conducting this kind of analysis are:

Controlling costs
Identifying trends

What is an example of variance?

Let’s say a mechanic anticipated $10,000 in profits for one month but actually generated $8,000; that would be a $2,000 unfavourable variance. If it’s determined through a variance analysis that the discrepancy in anticipated profits can be traced to rising costs of automobile parts, the mechanic can adjust their rates to make a more accurate budget or find a cheaper supplier.

Depending on your goals, you can analyse any of the following variances in order to optimise your operational performance.

Four types of variances analysis

Variances can be broadly classified into four main categories with corresponding sub-categories. Let’s break down each one and see how they can help businesses identify potential weak spots in their budgets.

1. Material efficiency variance

Calculating material variance helps you see how efficiently you are using your materials. Material cost variance, for example, is the difference between the standard cost of direct materials and the actual cost of direct materials that you use in your business.

Material quantity variance, on the other hand, measures the difference between the standard quantity of materials expected to complete a project and the actual amount you used.

Finally, there is material price variance, which is the actual unit cost of an item minus its standard cost. Say you manufacture clothes, and you paid $9 per unit of fabric. If the standard cost was $10, you have a favourable efficiency variance because you paid less than the standard.

2. Labour variance

If your business is labour intensive, it’s important to understand how your employees’ productivity compares to your labour costs. Calculating the direct labour efficiency variance determines whether your employees are spending time the way you anticipated. Say it takes four hours to sew a dress: If you budgeted five hours, that yields a favorable variance.

Another way to evaluate labour variance is by analysing your labour costs. The labour rate variance is determined by calculating how much you spent on labour hours and seeing how that number compares to your original budget. For example, if a contractor who makes a dress for you charges $30 per hour, but you budgeted $32 per hour, you would have a favorable variance.

3. Overhead variance

Overhead variance refers to the difference between actual overhead and applied overhead.

In some cases, this can be a variable overhead variance which occurs when there is a discrepancy between your actual variable overhead and the standard variable overhead. Furthermore, the difference between the actual time it takes to manufacture a unit and the time budgeted for it is called the “variable overhead efficiency variance”.

On the other hand, a “fixed overhead variance” occurs when there is a difference between the standard fixed overhead for actual output and the actual fixed overhead.

4. Sales variance

If your business exceeds, or comes up short of, its sales goals, this is called a sales variance. If you know how to calculate a volume variance, you can understand whether you reached your expected sales levels.

For example, if you anticipated selling 100 bicycles this year but only sold 92, your sales volume variance is the cost of the eight bicycles you didn’t sell. Because you didn’t sell quite as many bicycles as you budgeted for, this is an unfavorable variance.

Keep in mind: you only need to analyse the variances that are applicable to your business. For example, a service-based business like a law firm may need to analyse only its labour efficiency variance. A construction company, on the other hand, would want to keep close tabs on its material quantity variance.

Understanding relationships between variances

The above types of variances have relationships that can help you discover patterns in your business. Let’s say you spent $26,000 on raw materials in a year but only budgeted for $25,000. As mentioned earlier, it’s crucial to understand where that $1,000 unfavorable variance came from: higher prices? Did a project require more materials than you expected? A combination of both?

Performing a variance analysis gets to the root cause of budgeting inconsistencies so you can avoid them in the future.

Advantages and disadvantages of variance analysis

While financial variance analyses can give you a deeper level of understanding into the finances of your business, it’s important to weigh the advantages and disadvantages of this reporting tool before going all in.

Advantages of variance analysis

Rather than relying on guesswork to determine why you’re missing your budget, a variance analysis can help you pinpoint the true cause, giving you peace of mind.
A robust view of budget variances can direct you towards which products to make/sell, what suppliers to use and which customers to target, ultimately improving your cash flow and giving you a competitive advantage in the marketplace.
By mitigating risks, discovering trends and identifying weak spots, variance analysis can build trust among team members working towards a common goal.

Disadvantages of variance analysis

It takes time for your staff to conduct variance analysis and send results to the management accounting team, which can be a problem if your business operates at a fast pace and needs data on the spot.
In order to conduct accurate analyses, your accounting team may need to track down additional data such as bills of material, labour routings and overtime records in order to do an accurate analysis.
Comparing your actual results to arbitrary industry standards can cause confusion as to whether you’re on track or need to make changes.

Is variance analysis right for your business?

As we saw in the examples throughout this article, variance analysis can yield valuable financial insights across a myriad of industries.

From spotting bottlenecks in manufacturing to improving profit margins on construction projects, variance analyses can give your business the insight it needs to continually improve over time.

It can be tempting to keep pushing forward when results don’t meet expectations, but by diagnosing why things went amiss, your business can quickly make adjustments to get back on track.

Looking for something else?

Get QuickBooks

Smart features made for your business. We've got you covered.

See how it works

Help Me Choose

Use our product selector to find the best accounting software for you.

Choose your product

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.

Start learning

Stay up-to-date with the latest small business insights and trends!

Want more? Visit our tools and templates!

First Name*

Email*

What best describes you?*

By signing up you are agreeing to our terms and privacy policy.

- - QuickBooks reserves the right to change pricing, features, support and service at any time. Prices are in AUD and include GST. See our Terms of Service for further information.
  - Pricing: All prices are in AUD and include GST.
  - ProAdvisor Program: Please find the terms of our ProAdvisor program here.
  - 75% off for 6 months: For new subscribers, enjoy a 75% discount off the current monthly retail price for QuickBooks Self-Employed, QuickBooks Online Simple Start, QuickBooks Online Essentials or QuickBooks Online Plus for the first 6 months of your subscription (Offer). The discount will applied from the date of your enrolment and will continue for 6 months. From month 7, you will be charged the then current monthly retail price for your subscription. See current prices here. QuickBooks Payroll and QuickBooks Time prices are not eligible for any discount and will be invoiced separately according to your usage on a monthly basis during your subscription. Intuit reserves the right to request information to verify the eligibility of a purchaser of the Offer. Acceptance of such verification information is at the reasonable discretion of Intuit, which may revoke the Offer and impose a monthly cost for the subscription at the then current retail prices, at any time if it considers the purchaser is ineligible for the Offer.
  - 50% off for 12 months: For new subscribers, enjoy a 50% discount off the current monthly retail price for QuickBooks Self-Employed, QuickBooks Online Simple Start, QuickBooks Online Essentials or QuickBooks Online Plus for the first 12 months of your subscription (Offer). The discount will applied from the date of your enrolment and will continue for 12 months. From month 13, you will be charged the then current monthly retail price for your subscription. See current prices here. QuickBooks Payroll and QuickBooks Time prices are not eligible for any discount and will be invoiced separately according to your usage on a monthly basis during your subscription. Intuit reserves the right to request information to verify the eligibility of a purchaser of the Offer. Acceptance of such verification information is at the reasonable discretion of Intuit, which may revoke the Offer and impose a monthly cost for the subscription at the then current retail prices, at any time if it considers the purchaser is ineligible for the Offer.
  - 30% off for 3 months (Advanced): For new subscribers to QuickBooks Online Advanced, enjoy a 30% discount off the current monthly retail price for the first 3 months of your subscription (Offer). The discount will apply from the date of your enrolment and will continue for 3 months. From month 4, you will be charged the then current monthly retail price for your subscription. See current prices here. QuickBooks Payroll and QuickBooks Time prices are not eligible for any discount and will be invoiced separately according to your usage on a monthly basis during your subscription. Intuit reserves the right to request information to verify the eligibility of a purchaser of the Offer. Acceptance of such verification information is at the reasonable discretion of Intuit, which may revoke the Offer and impose a monthly cost for the subscription at the then current retail prices, at any time if it considers the purchaser is ineligible for the Offer.
  - 30% off for 12 months (Advanced): For new subscribers to QuickBooks Online Advanced, enjoy a 30% discount off the current monthly retail price for the first 12 months of your subscription (Offer). The discount will apply from the date of your enrolment and will continue for 12 months. From month 13, you will be charged the then current monthly retail price for your subscription. See current prices here. QuickBooks Payroll and QuickBooks Time prices are not eligible for any discount and will be invoiced separately according to your usage on a monthly basis during your subscription. Intuit reserves the right to request information to verify the eligibility of a purchaser of the Offer. Acceptance of such verification information is at the reasonable discretion of Intuit, which may revoke the Offer and impose a monthly cost for the subscription at the then current retail prices, at any time if it considers the purchaser is ineligible for the Offer.
  - 30% off for 3 months (existing subscribers): For existing QuickBooks subscribers who upgrade to QuickBooks Online Essentials, Plus or Advanced, enjoy a 30% discount off the current monthly retail price for 3 months of your subscription (Offer). The discount will be applied from the date you upgrade in-product and will continue for 3 months. From month 4, you will be charged the then current monthly retail price for your subscription. See current prices here. QuickBooks Payroll and QuickBooks Time services and prices are not eligible for any discount and will be invoiced separately according to your usage on a monthly basis during your subscription. Intuit reserves the right to request information to verify the eligibility of a purchaser of the Offer. Acceptance of such verification information is at the reasonable discretion of Intuit, which may revoke the Offer and impose a monthly cost for the subscription at the then current retail prices, at any time if it considers the purchaser is ineligible for the Offer.
  - Free Trial: First thirty (30) days of subscription to QuickBooks Online, QuickBooks Self-Employed and QuickBooks Payroll (including QuickBooks Advanced Payroll), starting from the date of enrolment, is free. During the free trial, you may pay any number of employees using QuickBooks Payroll free of charge. To continue using QuickBooks after your 30-day trial, you'll be asked to present a valid credit card for authorisation and you'll be charged monthly at the then-current fee for the service(s) you've selected.
  - QuickBooks Payroll powered by Employment Hero: Payroll services are offered by a third party, Employment Hero. QuickBooks Payroll is only accessible via QuickBooks Online subscriptions. You will be charged $5.00 (incl. GST) per month for each ‘active employee’ paid using QuickBooks Payroll. An ‘active employee’ is one who has been paid at least once in the billing month. For Advanced Payroll, there is an additional monthly subscription fee of $10 (incl GST). Pricing, terms and conditions, including service options, are subject to change.
  * Employment Hero was voted the leading payroll solution for SMBs <50 employees (Australian Payroll Association 2021 Payroll Benchmarking Study)
  - Customer support: Call or chat to an expert for QuickBooks Online Accountant, QuickBooks Simple Start, Essential, Plus, and Advanced or use in-product QB Assistant and chat for QuickBooks Self-Employed. You'll also find useful resources in the QuickBooks Community.
  - Compatible Devices: QuickBooks Online, QuickBooks Self-Employed and QuickBooks Payroll require a computer with Internet Explorer 10, Firefox, Chrome, or Safari 6 and an Internet connection (a high-speed connection is recommended). The QuickBooks Online mobile app works with iPhone, iPad, and Android phones and tablets. QuickBooks Online and QuickBooks Payroll are accessible on mobile browsers on iOS, Android, and Blackberry mobile devices. Devices sold separately; data plan required. QuickBooks Payroll cannot be used on the mobile apps. Not all features are available on the mobile apps and mobile browser. QuickBooks Online mobile access is included with your QuickBooks Online subscription at no additional cost. Data access is subject to cellular/internet provider network availability and occasional downtime due to system and server maintenance and events beyond your control. Product registration required.
  - Get paid faster: Get paid 2.5x faster invoicing with PayPal
  * PayPal and QuickBooks customers get paid on average in less than 5 days, which is over 7 days faster than the average for invoices that get paid with other payment methods. Data is for paid invoices that were created in QuickBooks in Australia between 23.05.22 and 23.11.22
  - Tax deductions: Tax deductions not guaranteed due to being subject to user data entry errors. Mileage calculation provided by the Australia Taxation Office - 78 cents per kilometre from 1 July 2022 for the 2022-2023 income year. To a maximum of 5,000 business kilometres per car (Deductions are only applicable to cars)
  - Customer Service Awards: Excellence in Customer Service Award at the CX Australia Awards 2022
  - Multiple file discount: Multiple file discount applies to QuickBooks Australia customers only and valid when signing up for more than one QuickBooks Online subscription in one order. Further terms and conditions available here. Not applicable to QuickBooks Self Employed.
  - Reviews: GetApp, Capterra, Google Play Store, Apple App Store reviews as at date 08/01/24.
  - Cost per day claim: Based on a QuickBooks Simple Start Plan at its regular retail price of $25 per month and a 31 day month.
  - Cost per day claim (annual): Based on a QuickBooks Simple Start Plan at its regular retail price of $270 per year and a 365 day year.
  - Annual Billing: You may pay for your QuickBooks Online subscription on an annual, upfront basis to enjoy a discount on the current fees. If you use QuickBooks Payroll powered by Employment Hero, your payroll costs will still be charged monthly to your nominated payment method in accordance with your usage as set out here. If you cancel your QuickBooks Online subscription within the pre-paid 12 month period, you will not be eligible for a refund, but will retain full access to your QuickBooks Online subscription for the remainder of the 12-month period. Unless cancelled by you prior, your annual subscription will auto-renew on the 12 month anniversary of your sign-up date using the billing details you have given us. Discounts, prices, terms and conditions are subject to change.
  - Over 7 million customers: Based on number of global QB customers (ecosystem) (7.1m) worldwide as of October 2022.
  - Free Onboarding: Applicable to Buy Now subscriptions on QuickBooks Simple Start, Essentials and Plus plans. Not available for QuickBooks Self-Employed.
  - Save Hours: Save up to an average of 29 hours per month with QuickBooks.
  - * Based on a survey conducted by Intuit Australia Pty Ltd in September 2022. Time saving is in comparison to previous accounting method, based on 184 responses from customers that saw time savings.
  - Get access to QuickBooks Tax: ***Access QuickBooks Tax, powered by LodgeiT, by becoming a member of the QuickBooks ProAdvisor Program (it’s free to join). Find out more about the ProAdvisor Program here, including the terms of the QuickBooks Tax offer in the Program here.
  - QuickBooks Time Disclaimers & Offers for Australia: For Important pricing offers and disclaimers with further information, please see here.
  - *Full terms and conditions for access to QuickBooks Tax, powered by LodgeiT as part of the the Proadvisor Program can be found here. QuickBooks reserves the right to change pricing, features, support and service at any time.
  - **Intuit conducted a study involving 56 interviews with accountants and bookkeepers who used Books Review for BAS preparation between March to December 2021 and found that when using Books Review, participants reduced the time spent preparing their clients BAS Reports by around 40%.
  - Our Terms of Service apply to all QuickBooks Online subscriptions. Please review them carefully.