Sales vs Cost of Goods on my Profit and Loss

Glad you checked in the QuickBooks Support page, Laurie.

I want to help you further with this, but I need more information so I can replicate everything. When you're referring to "bills", are these for Accounts Payable entries, or expenses? Also, can you please clarify the acronyms used such as "PN", "D" and "W"? Any additional details will help.

To share further insights, the Profit and Loss reports details your income and expenses. The posting of amounts depends on the accounts or category used on the item lists or transactions. You can review the transactions and make sure the items has the correct Income Account (Revenue) and Cost of Goods Sold Account (Expense).

To do that, follow the steps below:

1. Go to the Lists menu and choose Item List.
2. Double-click the item then check if the correct accounts are assigned.
3. Update any incorrect information before saving.

Now, go back to the Profit and Loss report and check if it changes the balances. 

Please post here again for the updates and additional details. I'll be right here to help you out. Have a good day!

Hi,

I have attached a screen shots to help me better explain my issue.   I actually tried to attach 2 screenshots, but it doesn't seem like I can do both.  I attached cost of Goods screen shot from my P&L report.  the 9th entry down doesn't have an amount listed, there are a few of them that don't.  These are the ones that I updated in the Item List with the correct Type (cost of goods).  I did find that I needed to create a new part number for vendor and for customer.  Originally the company was using the same part number such as 5012A33, for Sales orders and PO's and Bills, but I found this not efficient as the part number, 5012A33 was for our Customer.  For our Vendors I added a letter which determined what the vendor does for us, ie, 5012A33 D for deburring and 5012A33 W for welding, those I changed to Cost of goods.  Some of the Bills showing up under Sales on the P&L Report were not changed until yesterday, once I updated the bills they moved to Cost of Goods but now there is no amount listed.  Is there something I can do to get the amount to show up?  Let me know if you want to see the Sales portion of the P&L and I can screen shot that and send it to you.

Thanks adding a clarification and sharing a screenshot, @Laurie3118.

Let me join in this conversation and sort this out. 

There might be a minor data issue in your company file that's causing this behavior. This may be the reason why the amount in your updated bills aren't showing on the P&L report. 

To check, go back to the report and double-click the transaction. This will open the bill and verify if the amount is showing on it. If yes, then let's run some basic troubleshooting steps to address the issue. 

You can start by updating QuickBooks Desktop to its latest release. Doing this will refresh the program and fix some minor data issue in the system. Here's how:
 

1. Go to the Help menu and select Update QuickBooks Desktop.
2. Click the Update Now tab. 
3. Select Get Updates to start the download.
4. When the download finishes, restart QuickBooks.
5. Accept the option to install the new release when prompted.

If you're still getting the same result, run the Verify and Rebuild Data tools. This way, we can identify the source of the issue and fix it. 

If you still have data issues, use the QuickBooks File Doctor to fix your company file.

Also, this guide provides an overview of how to keep the customization set on the report: Create, access, and modify memorized reports.

I'm always here to help if you have any other concerns or questions. Just tag my name in the comment section and I'll get back to you as soon as I can. Have a good one!

Hi ReymondO

I did the suggestions listed in your reply and still my amounts are not showing up after I adjusted the Items list to the correct one in my Profit and Loss Detail report.  This file is a new file that I created on June 14th, as the previous one was not usable.  I took over for someone else and after taking an online class for QB's and finding the reports section and learning about each one, we made the decision to create a new file.  

Do you have another suggestions I could try to get those amounts to show up?

Thank you

Laurie

Thanks for keeping us updated, Laurie.

Let's work together to find a solution. I need to verify some information so I can provide the best solution for fixing your profit and loss report.

As per checking on the screenshot, it seems like you've created a billable expense transaction from your customer. Can you double-click to open the affected transaction and provide me with the screenshot? This helps me determine in resolving your issue since it may be possible that the service entered on that invoice or bill has zero amount.

I'll keep an eye on your response. Please take care and have a good one.

Hi,

I had just left the shop when you replied yesterday.  Attached is the screenshot I took after clicking on the line where the amount that is blank on the P&L.

Hello again, Laurie3118.

Thanks for adding the screenshots. Since there's an amount added on the bill, let me direct you to the support who can further investigate what's causing this issue. Our Customer Care Team have more tools available and might request a screen sharing session with you to check the item setup, transactions, and report. 

Here's how you can reach out to us:

1. In your QuickBooks Desktop program, go to Help > QuickBooks Desktop Help.
2. In the Have a Question window, click the Contact Us link at the bottom.
3. From the Contact Us page, select any topics.
4. Under Here's how to connect with a QuickBooks expert section, click the Start a Message or Get Phone Number button.

You can also get our phone number through this link: Contact QuickBooks Desktop support

To learn more about the different reports in QuickBooks Desktop and how you can customize them, please check out these articles:

• Understand reports
• Customize reports in QuickBooks Desktop

You're welcome to reply on this thread if you have more questions or need help with other task in your account. We're always available to help you out. Take care and stay safe.