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

Cost of Goods Sold

Hello All, 

 

Right now my P&L report has one line item inventory sold, under COGS. Is it possible to customize the P&L report to show COGS as "Beginning Inventory +Purchases - Ending Inventory?"

 

Thank You, 

Priya 

1 Comment 1
MaryLandT
Moderator

Cost of Goods Sold

Hi there, @adminatet,

 

At this point, we're unable to customize the P&L report to add the Beginning Inventory and Purchases. This report summarizes your income and expenses for the year to know whether you're operating at a profit or loss.

 

I'll share another workaround so you can get the ending inventory. You can pull up the Inventory Valuation Detail report to see the purchased items.

 

Here's how to accomplish the report:

  1. Click the Reports menu.
  2. Select Inventory, then Inventory Valuation Detailinventoryreport1.PNG
  3. Click Customize Reportinventoryreport2.PNG
  4. Go to the Filters tab.
  5. Search for Paid Status under the Choose Filter section. 
  6. Choose Closed from the Paid Status section.
  7. Click OK to save the changes. inventoryreport3.PNG

Here's a useful article to help you customize your financial reports: Customize company and financial reports.

 

Please leave a comment below for more queries with customizing reports in QuickBooks Desktop. I'd be glad to help.

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

Need to get in touch?

Contact us