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

PROFIT AND LOSS REPORT, COGS has weird amounts

Can someone explain to me why COGS on the Profit and Loss Report (Cash Basis) is showing amounts that do NOT coincide with the Vendor Bill and the Customer Invoice?

See my attached graphic...

 

I have QB Desktop Enterprise 24.0 Manufacturing Edition

1 Comment 1
JanbonN
QuickBooks Team

PROFIT AND LOSS REPORT, COGS has weird amounts

I'm here to provide insights about how the Cost of goods sold (COGS) is computed in QuickBooks Desktop (QBDT), @jeanieCETS.

 

When using the Cash basis reporting, COGS is affected when the bill is paid. Please run the report using the Accrual basis reporting to see if the amounts will be reflected correctly.

 

If it still doesn't show right, we need to verify and rebuild your company to check if this issue is related to the data of your company file.

 

To begin, let's verify your company data.

 

  1. Go to File and select Utilities.
  2. Click Verify Data. If you see:
  • QuickBooks detected no problems with your data—your data is clean, and you don’t need to do anything.
  • An error message—search for it on our QuickBooks Desktop support site for the steps to fix it.
  • Your data has lost integrityData damage was found in the file. Rebuild your data to fix it.

 

Then, let's rebuild your company data.

 

  1. Go to File and select Utilities.
  2. Click Rebuild Data.
  3. QuickBooks will prompt you to create a backup before it rebuilds your company file. Select OK.
  4. Select where you want to save your backup and click OK. Don’t replace another backup file. Enter a new name in the File name field and select Save.
  5. When the message Rebuild has completed shows, please click OK.
  6. Repeat steps 1 and 2 to check for additional damage.
  • If the verification finds more damage, you’ll have to fix it manually. Please search for the error(s) in the qbwin.log on the QBDT support site for the fix.
  • If your error can't be found, you can restore a recent backup. Go to File then select Open or Restore Company.

 

Please refer to this article for the detailed steps: Verify and Rebuild Data in QuickBooks Desktop.

 

Additionally, you can memorize your reports to save your current customizations.

 

Let us know if you have other concerns with COGS in your Profit and loss report. We're here to help you in any way we can.

Need to get in touch?

Contact us