4 Metrics For Inventory Management Success - QuickBooks Australia (2024)

QuickBooks Blog

Need help choosing a plan? 1800 917 771 Schedule a call

Need help?
We're here for you.

Schedule call

4 Metrics For Inventory Management Success - QuickBooks Australia (25)

Running a business

February 18, 20213 min read

One great reason to consider an inventory management system is to help your small business keep your inventorycarrying costs down. But how do you know if you’re inventory management process is making your business more efficient and saving on costs over time?

We’ve put together a list of four crucial metrics that you should keep a close eye on over the course of the year: inventory turnover, average days to sell, return on investment, and inventory carrying costs. Tracking metrics can help you make decisions about scaling your business, forecasting sales, and identifying opportunities to hone your supply chain operations.

1. What is inventory turnover?

4 Metrics For Inventory Management Success - QuickBooks Australia (26)

Inventory turnover is the amount of times your inventory is sold and replaced over a certain time period (like a year), letting you know how your business is performing.

To calculate inventory turnover, divide cost of goods sold (COGS) by average inventory for your specific time period. Use average inventory to take seasonal fluctuations in sales into account. COGS can include cost of materials, labour costs directly related to producing goods, and any factory overhead or fixed costs associated directly with production.

Generally, a higher inventory turnover rate means you’re enjoying brisk sales. A low inventory turnover suggests that you could be ordering too much and it may be time to revise your ordering or production strategy.

You can calculate your inventory turnover rate for your entire stock, or just for a specific SKU so you can tell if specific items are selling faster or staying on your shelves longer.

2. What is average days to sell inventory (DSI)?

4 Metrics For Inventory Management Success - QuickBooks Australia (27)

The average days to sell inventory (DSI) helps you put a figure on your inventory turnover. You’ll know how long it takes for you to sell your inventory each months, and it’ll also show how many days sales of inventory you have on hand at any given time.

Calculate DSI by dividing your average inventory by cost of goods sold. Multiply the result by 365.

Generally, a lower DSI is better because that shows that your inventory isn’t gathering dust in your warehouse for too long before being sold. However, if your average days needed to sell inventory is too low, you have the risk of running out of stock.

On the other hand, if you’re taking a long time to sell your inventory, you could be carrying too much slow-moving stock that is on the verge of turning intodead stock.

Different industries can expect different DSI. If you’re selling fresh foods, your DSI is likely to be a lot lower than if you’re selling furniture or other higher cost items.

Grow Your Business with QuickBooks

3. Return on investment (ROI)

4 Metrics For Inventory Management Success - QuickBooks Australia (28)

Calculating your return on investment (ROI) is an easy way to know how well your business is doing. You’ll know if you’re making a profit, and how much it is. And once you know how well your business is doing, you’ll be able to decide how much of your profit should be reinvested into the business to boost future growth.

To calculate your return on investment in your inventory stock, first subtract gain from investment (profit) from cost of investment. Divide the result by the cost of investment. Then multiply that total by 100.

Your cost of investment doesn’t just cover how much you’ve spent purchasing inventory, but also includes your inventory costs and the carrying costs attached to your inventory.

4. Carrying costs

Carrying costs include:

  1. Opportunity costs of investing in inventory.
  2. Storage costs for facility maintenance.
  3. Inventory service costs covering insurance and software applications.
  4. Inventory risks costs when shrinkage and obsolescence happen.

You need to keep your carrying costs at about 25% of your inventory value. If you want to reduce your expenditure on the carrying costs, you can start by reducing the size of your inventory.

To calculate carrying costs, use this formula:

Total inventory value/ Average annual inventory costs = Carrying costs

When it comes to keeping track of your costs and your sales, inventory management software can be a great help. With inventory management software, you’ll be able to generate sales reports, which can offer useful insights when you’re calculating key success metrics.

At some point in your inventory management journey, you might find that your inventory needs are complex enough that it’s time to make the move to a scalable inventory management solution. If you’re wondering about when’s the right time, check out thisarticle on how to decide when it’s time to upgrade.

Related Articles

Looking for something else?

Get QuickBooks

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

Help Me Choose

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

QuickBooks Support

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

      • 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.
      • 70% off for 3 months: For new subscribers, enjoy a 70% 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 3 months of your subscription (Offer). The discount will applied 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.
      • 70% off for 12 months: For new subscribers, enjoy a 70% 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.
      • 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 and Plus, 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 availablehere. Not applicable to QuickBooks Self Employed.
      • Reviews: Trustpilot, GetApp, Capterra, Google Play Store, Apple App Store reviews last updated on 23/08/22.
      • 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.
      • Sales 70% Offer: For new customers, receive up to 70% discount off the current monthly price of QuickBooks Online Simple Start, QuickBooks Online Essentials or QuickBooks Online Plus for the first 3 months of service, starting from the date of enrolment; from month 4 of enrolment, the price will then change to the then current monthly price. Or, purchase on an Annual Billing plan for 70% off for 12 months; from month 13 of enrolment, the price will then change to the then current annual price. See current prices here. This offer is only applicable if you call Sales on 1800 917 771. QuickBooks Payroll and QuickBooks Time prices are not eligible for this discount.
      • 2023 36-Month Pricing Offers: **Prices applicable from 14 March 2023. Offer ends 31 May 2023, unless withdrawn earlier. Free migration only available for purchases of Plus, Essentials and Firm Ledger subscriptions. Packages are billed to your firm. By purchasing this offer you agree to the terms and conditions available here for Simple Start, Essentials and Plus subscriptions, or here for Firm Ledger subscriptions. Terms and conditions, features, support, pricing and service options are subject to change.
      • 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.
      • Canstar Blue’s Best-Rated Accounting Software: ^Intuit QuickBooks Australia ranks #1 in Canstar Blue’s 2022 Small Business Accounting Software Awards. Find out more here
      • QuickBooks Time Disclaimers & Offers for Australia: See our Important pricing offers and disclaimers for further information.
      • Our Terms of Service apply to all QuickBooks Online subscriptions. Please review them carefully.

4 Metrics For Inventory Management Success - QuickBooks Australia (42)

4 Metrics For Inventory Management Success - QuickBooks Australia (43)

© 2023 Copyright © Intuit Australia Pty Ltd.

All rights reserved. Terms and conditions, features, support, pricing, and service options subject to change without notice.

By accessing and using this page you agree to the Terms and Conditions

4 Metrics For Inventory Management Success - QuickBooks Australia (2024)
Top Articles
Latest Posts
Article information

Author: Foster Heidenreich CPA

Last Updated:

Views: 5784

Rating: 4.6 / 5 (56 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Foster Heidenreich CPA

Birthday: 1995-01-14

Address: 55021 Usha Garden, North Larisa, DE 19209

Phone: +6812240846623

Job: Corporate Healthcare Strategist

Hobby: Singing, Listening to music, Rafting, LARPing, Gardening, Quilting, Rappelling

Introduction: My name is Foster Heidenreich CPA, I am a delightful, quaint, glorious, quaint, faithful, enchanting, fine person who loves writing and wants to share my knowledge and understanding with you.