QuickBooks HelpQuickBooksHelpIntuit

Can I track stock manually in QuickBooks Online?

SOLVEDby QuickBooks11Updated January 17, 2024

You can track the value of your stock assets manually in QuickBooks Online following the steps below.

Note: If you're using QuickBooks Online Plus, you can use the built-in stock feature instead of tracking stock manually.

Create an account to track your stock value

  1. Select the Gear icon at the top, then Chart of Accounts.
  2. Select New.
  3. Select Current assets from the Account Type dropdown.
  4. Select Other current assets from the Detail Type dropdown.
  5. (Optional) Input a unique Name (system default will be Other current assets), Description, Default Tax Code, and Balance for the account.
  6. Select Save and Close.
  7. If desired, you can create an account for each type of stock. For example, if you sell used cars and motorcycles, you'd create an account for cars and another for motorcycles.

Create an account to track your cost of goods sold

  1. Select the Gear icon at the top, then Chart of Accounts.
  2. Select + New.
  3. Select Cost of Goods Sold from the Account Type dropdown.
  4. Select the closest type of Cost of Goods Sold that matches your situation from the Detail Type dropdown. If you're not sure, use Other Costs of Service - COS.
  5. (Optional) Input a unique Name, Description, and Default Tax Code for the Cost of Goods Sold item.
  6. Select Save and Close.

When you purchase stock (using Cheques, Expenses or Bills)

Use the asset account you created to track its value in the Account field. This "transfers" the money into the asset account, increasing the value of your stock.

When you sell stock

  1. Select + New.
  2. Select Journal entry.
  3. On one line, enter a Debit to your cost of goods sold account for the original cost of the product you sold. Do not use the sales price.
  4. On the next line, enter a Credit for the stock asset account for the original cost of the product you sold.
  5. Select Save.

This Journal Entry decreases the value of your stock (indicating you have less) and increases your Cost of sales.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Online EssentialsQuickBooks Online Simple Start

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this