Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
There is no cost of goods sold on my version of online quickbooks.
Solved! Go to Solution.
@ stacey
inventory is only in QBO+, if you have plus, then COGS will show up in the chart of accounts when you enable qty tracking (inventory) in company settings
Other wise as Malcolm stated you have to use periodic inventory if you have essentials
There are two ways to do periodic inventory, choose one and stick with it, you can not mix and match
1. (my preference) Create an asset account called purchases and post all purchases of item for resale to that account. Periodically, weekly, monthly, etc value the inventory on hand, subtract that value from the amount shown in the purchases account and do a journal entry for the answer to the subtraction
debit COGS for that value
credit purchases for that value
OR
2. Post all purchases to COGS. Periodically, but at least at the end of the year, you value the inventory on hand and do a journal entry.
debit the asset purchases account for that value
credit COGS for that value
Print the P&L
then reverse the journal entry
debit COGS for that same value
credit the asset purchases account for that value
This last journal entry, moves the value of what was on hand at the end of year back to COGS so the cost will be counted against the new year sales.
@ stacey
inventory is only in QBO+, if you have plus, then COGS will show up in the chart of accounts when you enable qty tracking (inventory) in company settings
Other wise as Malcolm stated you have to use periodic inventory if you have essentials
There are two ways to do periodic inventory, choose one and stick with it, you can not mix and match
1. (my preference) Create an asset account called purchases and post all purchases of item for resale to that account. Periodically, weekly, monthly, etc value the inventory on hand, subtract that value from the amount shown in the purchases account and do a journal entry for the answer to the subtraction
debit COGS for that value
credit purchases for that value
OR
2. Post all purchases to COGS. Periodically, but at least at the end of the year, you value the inventory on hand and do a journal entry.
debit the asset purchases account for that value
credit COGS for that value
Print the P&L
then reverse the journal entry
debit COGS for that same value
credit the asset purchases account for that value
This last journal entry, moves the value of what was on hand at the end of year back to COGS so the cost will be counted against the new year sales.
If you don't want QBO to track inventory you can debit a COGS account called Purchases for all inventory purchases, and shipping in. Then at month-end or year-end whenever you want to produce financial statements, you would do an inventory count and create a journal entry where you adjust between a current asset Inventory account and a COGS account called "Change in Inventory", so that the asset account shows the inventory value at cost as per the count (the change in inventory value between the current and previous period end - could be positive or negative)
TIP:
If you're adopting "Periodic Inventory" method do not select "Inventory as Detail Type" in the Chart of Accounts. Instead use Other Current Assets for detail type and for the category type also select the same. For the name, you never want to use "Inventory Asset", this happens to be default account name designated for perpetual inventory tracking in QBO. If you want to switch later, it creates problems.
"Purchases" name on the B/S (as suggested by Rustler) works fine.
I agree with you Rustler.
Purchasing is a proper account name (conventional for a periodic system). "Inventory Purchases" are assets until it expensed (assigned to COGS). You do not recognize or realize the expense until the inventory is sold (moved to COGS). COGS appears on the income statement not the B/S.
Mark
I agree, the term Purchases is not an asset account. It's part of COGS
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here