Understand inventory assets and cost of goods sold tracking
by Intuit•28• Updated 6 months ago
To successfully track inventory, you need to understand how QuickBooks handles inventory assets, average cost and Cost of Goods Sold (COGS). Learn how to compute for the average cost and know which report will help with inventory management in this article.
Inventory Accounts
When you set up your first inventory item in your Inventory List, QuickBooks automatically adds two accounts to your company file's Chart of Accounts:
- 12100 - Inventory Asset - Other Current Asset
- 50000 - Cost of Goods Sold (COGS) - Cost of Goods Sold
In addition, each inventory item requires an income account. You're not required to use either of the automatically set up accounts. You can set up your own accounts or subaccounts.
Note: If either of these account numbers is already in use, QuickBooks will assign the next available number to the new accounts.
Inventory Assets
When you buy an inventory item, your Bill, Check or Credit Card Charge will debit the Item's Inventory Asset account and credit your A/P, bank or credit card account. It is not debited to an expense account because it is an asset that you can sell for future benefit and you record the expense to match the income.
The best way to track your inventory purchases is to run the Inventory Valuation Summary/Detail reports for all dates.
Cost of Goods Sold
Normally, inventory COGS is only affected when you sell inventory items on invoices or sales receipts. When you sell an inventory item, run the Transaction Journal Report for the invoice/sales receipt and you see the Sales/Accounts Receivable transaction and you'll see the Inventory/COGS transactions which credits the Inventory Asset account and debits the COGS accounts.
However, if you sell inventory that you do not have, you can force the next bills, checks, or credit card charges to adjust the Inventory Asset account and the COGS account. The amount on each side of the Inventory/COGS transaction is: Number of Items Sold x Average Cost of Item.
Average Cost
QuickBooks uses the weighted average cost to determine the value of your inventory and the amount debited to COGS when you sell inventory. The average cost is the sum of the cost of all of the items in inventory divided by the number of items.
- You purchase a widget for $2.00. The average cost is $2.00.
- You purchase a second widget for $1.50. The average cost is now (2 + 1.5) / 2 = 1.75.
- You sell a widget. The inventory/COGS transaction debits COGS for $1.75 and credits inventory for $1.75.
- You purchase another widget for $2.00. Now your average cost is (1.75 + 2.00) / 2 = 1.88.
If you have any questions about an average cost, your best course of action is to run the Inventory Valuation Summary report. This shows you how QuickBooks got the item's average cost.
- Select Reports, then select Inventory.
- Select Inventory Valuation Summary, then set the dates to All.
- Double-click the item in question.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Impacts of inventory tracking on the Balance Sheet and Profit & Loss reports in QuickBooks Onlineby QuickBooks•283•Updated February 16, 2024
- What is FIFO and how is it used for inventory cost accounting?by QuickBooks•234•Updated August 26, 2024
- Track inventory manually in QuickBooks Onlineby QuickBooks•282•Updated June 04, 2024
- Set up inventory after converting from QuickBooks Desktop to QuickBooks Onlineby QuickBooks•68•Updated September 02, 2024