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

Running a business

How to Calculate Beginning Inventory

By QuickBooks Australia

Published on June 11, 20244 min read

Beginning inventory is a metric that helps you evaluate demand, check in on how you’re managing inventory, and plan for tax deductions. As such, being able to calculate beginning inventory and understand what this number means for the health of your business is essential.

Learn more about beginning inventory, how to use the beginning inventory formula, and what it means for your business’s finances in this post. If you’re still getting the hang of inventory management, we recommend taking the time to read through the entire guide.

What is Beginning Inventory?

Beginning inventory, or opening inventory, is the valuation of all inventory held by a business at the start of an accounting period. This value represents all the goods a business can put toward generating revenue. Beginning inventory is classified as a current asset and is an important aspect of inventory accounting.

Not sure how to calculate beginning inventory? We’ve got you covered. You can use the beginning inventory formula to better understand the value of inventory at the start of a new accounting period.

When Will You Use Beginning Inventory?

You’ll calculate beginning inventory, or your opening Inventory, at the start of an accounting period.

Being able to compare beginning inventory period-over-period can provide insights into business performance, such as inventory turnover and the value of your inventory. There are several reasons why knowing the value of beginning inventory can prove useful to your business, including:

Noting changes in demand: Any change to beginning inventory compared with the previous period usually signals a shift in your business. For instance, a lower beginning inventory count compared to the month prior could be a result of growing sales during the period. Higher beginning inventory could signal a downward trend in sales.
Identifying inventory management issues: A greater number of units leftover than usual could indicate a breakdown in your inventory management process if you didn’t reorder sufficient Inventory. If you have little-to-no beginning inventory, it could indicate that you possibly over-ordered inventory during the previous period.
Highlighting supply chain issues: Similarly, having more or less Inventory than usual could be due to an issue in the supply chain. The case may be that your supplier didn’t fulfil your order correctly, or you only received a portion of your inventory purchases.
Preparing to file your taxes: If you can Quote your average inventory at the end of an accounting period and how much you’ll need in the following period, you can pre-purchase inventory. Doing this can lower your taxable income that you account for on your income statements, which can help you reduce how much you owe.
Keeping an eye out for shrinkage: Shrinkage occurs when there’s a discrepancy between how much inventory should have been accounted for and what was actually accounted for. This is a problem for retailers and e-commerce wholesalers alike, and can occur due to human error, damaged products, or potentially stolen goods. While errors may happen occasionally, it’s important to keep an eye out for shrinkage patterns to ensure employees aren’t stealing merchandise.

Beginning inventory is a tool to help you better understand the sales and operational trends of your small business. With this data and the conclusions you can draw from it, you can make improvements to your inventory management strategy. With a better inventory method, you can also optimise the cost of inventory and improve gross profit.

How to Calculate Beginning Inventory

The beginning inventory formula is simple:

Beginning inventory = Cost of goods sold + Ending inventory – Purchases

Want to know how to find beginning inventory? Let’s break down the steps you need to know:

1. Determine the cost of goods sold (COGS) using your previous period’s accounting records.

COGS = (Previous accounting period beginning inventory + previous accounting period purchases) – previous accounting period ending inventory

2. Multiply your ending inventory (sometimes called closing inventory) balance by the production cost of each inventory item. Do the same with the amount of new inventory.

Ending inventory = Previous accounting period beginning inventory + Net purchases for the month – COGS

3. Add the ending inventory and cost of goods sold. See the formula for calculating ending inventory above.

4. Subtract the amount of inventory purchased from the number above to calculate the value of beginning inventory.

If you’re going to use the beginning inventory formula to manually calculate this value, it’s important that you double-check your maths. Using an incorrect number for beginning inventory can create a domino effect of miscalculations and mislead future decisions. To ensure accuracy, you may want to consider using a beginning inventory calculator.

Beginning inventory calculation example

To help you get more comfortable using the beginning inventory formula, here’s an example:

1. Determine the COGS using your previous accounting period’s records. Example: Candles cost $2 each to produce, and Jen’s Candles sold 600 candles during the year.

COGS = 600 x $2 = $1,200

2. Use your balance sheet to calculate your ending inventory balance and the amount of new inventory purchased or produced during the period. Example: Jen’s Candles had 800 candles in Inventory at the end of the previous accounting period, and produced another 1,000 candles during the next year.

Ending inventory = 800 x $2 = $1,600

New inventory = 1,000 x $2 = $2,000

3. Add the ending inventory and cost of goods sold. Example: $1,600 + $1,200 = $2,800

4. To calculate beginning inventory, subtract the amount of inventory purchased from your result. Example: $2,800 – $2,000 = $800

Beginning Inventory Calculator

QuickBooks' Beginning Inventory Calculator allows you to calculate the value of all inventory held at the start of the accounting period. The calculator is a useful way to do proper record keeping for better financial management.

To start your calculation, you must enter the following details:

Cost of goods sold: Calculate this cash value by multiplying the cost of produced goods by the number of units sold in the preceding accounting period. Alternatively, you can use the QuickBooks COGS calculator to determine this value.
Ending inventory: This includes the cash value of any stock left on the shelves at the end of the accounting period.
Purchases: This is the value of purchases added to the inventory during the previous accounting period.

With just a few clicks, QuickBooks’ online calculator will perform computations in mere seconds. Try this simple online tool to make accurate calculations effortlessly.

Take the Next Step Toward Better Inventory Management

Understanding how to calculate beginning inventory is an important aspect of improving inventory system management and the financial health of your business. But, that’s just the start. An inventory management software solution like QuickBooks can help you manage your multichannel business much more efficiently.

With QuickBooks Online, you get access to features that allow you to track inventory, list and manage products, and fulfil orders all in one place. Plus, you’ll get access to reports that provide powerful insights above and beyond beginning inventory. Take control of your business and make smarter decisions that help you plan, sell, and grow.

Running a business

What is an invoice? A guide and what to include

June 26, 2024

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 plan for you.

Choose your product

QuickBooks Support

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

Start learning

A computer screen showing a picture of a computer.

TAKE A NO-COMMITMENT TEST DRIVE

Your free 30-day trial awaits

Our customers save an average of 9 hours per week with QuickBooks invoicing*

No credit card needed

Cancel anytime

Unlimited support

By entering your email, you are agree to our Terms and acknowledge our Privacy Statement.

- - 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.
  - 50% off for 3 months: For new subscribers, enjoy a 50% off price subscription on 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.
  - 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.
  - 50% off for 3 months (existing subscribers): For existing QuickBooks subscribers who upgrade to QuickBooks Online Essentials, Plus or Advanced, enjoy a 50% 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 $6.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 - 85 cents per kilometre for the 2023-2024 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 (annual): Based on a QuickBooks Simple Start plan at its regular retail price of $313 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.

Intuit helps put more money in consumers’ and small businesses’ pockets, saving them time by eliminating work, and ensuring they have confidence in every financial decision they make.

How to Calculate Beginning Inventory

What is Beginning Inventory?

When Will You Use Beginning Inventory?

How to Calculate Beginning Inventory

Beginning inventory calculation example

Beginning Inventory Calculator

Take the Next Step Toward Better Inventory Management

Related Articles

Looking for something else?

Get QuickBooks

Help Me Choose

QuickBooks Support

Your free 30-day trial awaits