cancel
Showing results for 
Search instead for 
Did you mean: 
Becky7483
Level 1

Detail in Cost of Goods Sold

I have Quickbooks Desktop Enterprise. When looking at the detail of Cost of Goods Sold on the P&L Statement, I have Debit / Original Amounts that are at 0.00.  Why is this?  

4 Comments 4
JanbonN
QuickBooks Team

Detail in Cost of Goods Sold

Let's confirm if the item's profile has a cost, @Becky7483. Let me walk you through the steps.

 

The amount may be zero in the Profit and Lost (P&L) report because no cost was entered for your items. To resolve this, open your QuickBooks Desktop App and follow the steps below.

 

  1. Go to Lists and choose Item List.
  2. Navigate to the item that has the 0.00 amount.
  3. Double-click the item to open it.
  4. Check if the Cost area has an amount.

 

In case there is an amount, we can proceed with the  Verify and Rebuild troubleshooting. The verify tool finds the most common issues in a company file, and the rebuild tool fixes them.

 

Here are the steps to verify your company data:

 

  1. Go to Window and click Close All.
  2. Go to File and choose Utilities.
  3. Select Verify Data. If you see: 
    1. QuickBooks detected no problems with your data—your data is clean, and you don’t need to do anything else.
    2. An error message—search for it on our QuickBooks Desktop support site for how to fix it.
    3. Your data has lost integrity—Data damage was found in the file. Rebuild your data to fix it.

 

Now, let's Rebuild your company file data:

 

  1. Go to File and choose Utilities.
  2. Select Rebuild Data.
  3. QuickBooks will ask you to make a backup before it rebuilds your company file. Select OK.
  4. Choose where you want to save your backup, then OK. Ensure to create a new file and don't replace other files.
  5. Select OK. When you get the message Rebuild has completed.

 

Verify the data again to double-check if all the problems are resolved.

 

Additionally, you can memorize your reports to save the customizations you've made.

 

Please let us know if you have any other concerns with your P&L reports. We'll be here to help you in any way we can.

Becky7483
Level 1

Detail in Cost of Goods Sold

There is an item cost in all that have 0.00, and correct account Cost of Goods Sold.

Verified Data - it says Data is good.

Becky7483
Level 1

Detail in Cost of Goods Sold

Do I still need to do the Rebuild and is there a cost for the online backup?

 

ShyMae
QuickBooks Team

Detail in Cost of Goods Sold

Greetings, Becky7483. My primary goal is to guarantee the precision of financial reporting and transactions. I'll also provide details regarding the Cost of Good Sold (COGS). 

 

Since you've verified that there are no issues with your data, you don't need to do anything else. Besides, backing up your company file won't cost you anything. 

 

On the other hand, please know that the COGS account is affected by inventory transactions, such as purchases, sales, and adjustments. Therefore, if there were no such transactions during the period or if there were no inventory sales, the report will display a value of 0.00.

 

If you've already sold an item, we can check the transaction history of those invoices that haven't been posted to the COGS. This way, we can verify if the posting is correct. 

 

To track the posting accounts of the invoice/bill transaction, let's run the Transaction Journal. 

 

Here's how:

 

  1. Go to the Reports menu, then choose Sales.
  2. Pick the Sales by Customer Detail and click an invoice.
  3. Hover over the Reports menu again. Select Transaction Journal
  4. Manually check the account assigned to each item. 

Sample.PNG


Meanwhile, you can assign a specific account to your items. That way, you can easily track their posting account when creating transactions. 

 

Here's how to edit your items:

 

  1. Go to the Lists menu and choose Item List
  2. Double-click the item you want to edit.
  3. In the Account section, select Cost of Goods Sold. 

Sample.PNG


For additional information, visit this page: Understand inventory assets and cost of goods sold tracking. 

 

I recommend consulting your accountant for further guidance, ensuring all your transactions and items are accurately recorded. You can use our Find an Accountant tool if you don't have one. 

 

Furthermore, here are some resources you can visit to help manage your inventories and items in QuickBooks Desktop. 

 

 

You can make well-informed decisions and guarantee that your transactions are accurately recorded after all the information above. If you require further assistance, I am always available to help. Please feel free to leave your response below. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us