Set up Stock tracking in QuickBooks Online Plus to help you track  quantity, sales revenue, and cost of goods sold. Enabling this feature gives you the extra time to focus on your business.

Stock tracking: What you need to know

  • The value of an stock item in your books is the amount you paid for it.
  • Recording the purchase of an stock item increases the value of Stock Asset account on your Balance Sheet report by the cost of the item and increases the Quantity on Hand units for that item.
  • Recording the sale of an stock item decreases the value of Stock Asset account by the original cost of the item and decreases the Quantity on Hand units for that item.
  • Recording this sale also increases the Cost of Goods Sold account (COGS) by the original cost of the item and increases the Sales of Product Income account by the amount your customer paid you for the item. The difference between the income amount and the COGS amount is your gross profit on that item.
  • At times, you may pay more for some units of a given product than for other units due to price fluctuations. When this happens, QuickBooks Online uses a method called First In First Out (FIFO) to manage the cost accounting as you sell units of that product.

Four Types of Stock Items to Track

QuickBooks Online allows you track 4 different types of items.

  • Stock items: These are the items you buy and/or sell and that you track quantities of. Stock items require that the Tracking Quantity on Hand option be selected. (See the Enable Stock Tracking section below for more information.)
  • Non-stock items: These are items you buy and/or sell but don't need to (or can't) track quantities of. Example are nuts and bolts used in an installation.
  • Services: These are services you provide to customers. For example, landscaping or tax preparation services.
  • Bundle: A collection of products and/or services that you sell together such as a gift basket of fruit, cheese, and wine.
Important:
  • The default items created by QuickBooks (Hours or Services) cannot be changed to an Stock Item type.
  • Items that have been classified as Stock cannot be changed.

Items that have been added as either Non-stock items or Services can be reclassified into either category by editing the product or service. To do this:

  1. Select the Gear icon on the Toolbar, then choose Products and Services.

  2. On the Products and Services list, select Edit next to the item that needs to be changed.
  3. Within the edit screen, select Change type and choose the appropriate selection.

Enable stock tracking

To enable stock tracking, you need to turn on stock tracking.

Turn on stock tracking with quantity on hand:

  1. Select the Gear icon on the Toolbar.

  2. Under Your Company, choose Account and Settings (or Company Settings).

  3. In the left sidebar, select Sales.
  4. Select the pencil next to Products and services and mark the option Track stock quantity on hand. (Note: This will enable the new item type called Stock item when selecting New under Products and Services.)
  5. Select Save.

Tip :
  •  If you need to track stock quantity on hand and costs, use the Stock type.
  • You now have the ability to include “Taxable” data for each stock item that has been imported via CSV/Excel.

After you've turned on stock, you'll need to set up your products.

Create stock items

  1. Select the Gear icon on the Toolbar.

  2. Under Lists, select Products and Services.

  3. Select New.

  4. Choose Stock as the type.

On the Product/Service information window:

  1. Enter a name for the product/service.
  2. (Optional) Upload an image and enter SKU. Note that SKU will print if you are using the Airy form template.
  3. In the Category drop-down, add a category or choose the appropriate selection if available.
  4. Enter the Initial quantity on hand.
  5. In the As of date field, enter the date you start to track the stock item’s quantity on hand. (Note: Remember that you cannot save a transaction with an stock item in QuickBooks if the date comes before the as of date.)
  6. (Optional) In the Reorder point field, enter the minimum quantity of the stock item you want to have in stock.
  7. From the Stock asset account drop-down, choose or add an asset account. This account must be of the Stock detail type. (See Account detail types for steps to change the detail type if necessary.) Complete the following optional fields:
    • Sales information
    • Sales price/rate
    • Purchasing information
  8. In the Income account field, select Sales of Product Income.
  9. In the Expense account field, select Cost of Goods Sold.
  10. Select Save and close.

Continue this process until all the appropriate products have been marked for stock tracking.

Add stock items to products and services

The Products and Services page lets you see all your products and services along with the available quantities, costs, selling price, and more. To go to this page:

  1. Select the Gear icon on the Toolbar.

  2. Under Lists, select Products and Services.

When you are on the page, you can choose to add individual items by selecting the New button or import from Excel in bulk (New Import). On the Product/Service information window, you may select one of the four types of items:

  • Stock
  • Non-stock
  • Service
  • Bundle
Tip :
  • Stock tracking can't be turned off for an item after it's been turned on. Instead, you can select Make inactive for the item and add a new item if you no longer want to track stock. Making an item inactive doesn't affect the transactions that use it.
  • Historical account usage of the product or service item cannot be changed if the option for Track Quantity on Hand is turned on.

Edit products and services by batch

Products and services can also be edited as a group. To edit multiple products, place a check mark in the box next to the items and choose the appropriate selection at the top. You can assign different categories, make the items inactive, or change the type (non-stock item or service).

User-added image

Do more with your stock

Using stock items in transactions

Once you've set up your entire stock list, you can start selling and purchasing items by creating new invoices, bills, purchase orders etc. You can even add new products or services on the fly within transaction forms (e.g., invoices) by clicking in the Product/Service column and selecting Add new from the drop-down list.

Using categories to group your products and services

If you have the Categories option turned on and using the new Redesigned Reports you can filter by category. To learn more, see Introduction to categories in Products and Services.

Using reports to better understand your stock performance

QuickBooks online has a number of reports that can help you better understand the performance of your products and services. You can access reports by selecting Reports from the left menu.

To go to all stock reports:

  1. From the left menu, select Reports.

  2. Some relevant stock reports are:
    • Stock Valuation summary
    • Sales by Product/Service summary
    • Sales by Product/Service detail
    • Purchases by Product/Service detail

Stock Take Worksheet

You may print and use the Stock Take Worksheet when you conduct a stock take at your warehouse. This report is accessible under the Manage Products and Stock section of the Reports page.

 

 

More resources

Now you know how to set up your stock tracking. If you want more information on stock processes and best practices, please check out the following resources: