Calculating Inventory on Hand for Your Bookkeeper When Using External Inventory Tracking

Are you not using something ouside of QuickBooks Online to keep track of your inventory? If so, at the end of the year your bookkeeper will ask you for the cost of your “inventory on hand.” 
 
In this post, I’ll show you how to calculate that information.

Inventory On Hand

“Inventory on hand” refers to the inventory that you have in stock on a specific date. 

For tax purposes, you’ll need to know how much inventory you have on hand at the end of the year and the value of that inventory.

This is not how much that inventory is worth when you sell it, but how much it cost you when you purchased it.

Calculating the Value of Inventory On hand

To calculate the value of inventory on hand you’ll want to get a count of all your inventory. Get the purchase price of each item, multiply it by the quantity then add that all up.

Here’s a screenshot of a simple spreadsheet calculating the value of inventory on hand.

A simple spreadsheet calculating the value of inventory on hand

  • Description – Each “Thing” is a different inventory item
  • Quantity – how many are currently on hand
  • Purchase Price – how much the company paid for the item
  • Value = Quantity x Purchase Price
  • Total For Balance Sheet – Everything in the Value column is added together

When your bookkeeper asks for the value of inventory on hand, they’re asking for that total.

Unless your inventory is broken up into different categories on the balance sheet. For example, here is a QBO balance sheet with the inventory broken out into Floral Inventory and Retail Inventory:

Inventory on the balance sheet in QBO that's broken out in different categories.

If your inventory is broken out on the balance sheet like this then you will need to calculate the value for each category.

It’s that simple.

☕ If you found this helpful you can say “thanks” by buying me a coffee… https://www.buymeacoffee.com/gentlefrog

Below is a video if you prefer to watch a walkthrough.

If you have questions about working with inventory in QuickBooks Online click the green button below to schedule a free consultation.

Need some one-on-one QuickBooks assistance?
Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

Leave a Reply

Your email address will not be published. Required fields are marked *

Read similar articles

Testing SupaClerk Bank Statement Conversion to CSV for QuickBooks Online Import

Learn how to convert a PDF bank statement into a CSV and then import it into QuickBooks Online.

How to Upload Checks for Printing in QuickBooks Online Using SaasAnt

Learn how to use Saasant to upload multiple checks to QuickBooks Online for printing.

Have a QuickBooks / Bookkeeping Question?

Let me know what you’d like to see in future videos, blog posts, and courses.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.