Can a report showing COGS ledgers as well as finished goods stock ledgers transaction wise for one month in a single report be generated on QBO?

I’ve got a workaround for you to get your Cost of goods sold (COGS) and closing stock information in a single report, @DG_99.

In QuickBooks Online, generating a report that shows COGS ledgers as well as closing stock in a single report isn’t possible. You may consider accessing the Profit and Loss and Inventory Valuation Detail Report and then exporting them to Excel to get the details you need in one spreadsheet. I’m glad to show you the steps:

1. Go to your Reports menu.
2. Search Profit and Loss/Inventory Valuation Detail Report.
3. Click Customize.
4. Filter the date period and other necessary info. You can sort your Profit and loss to Products/Services to display all COGS figures.
5. Tap Run report.
6. Click Export icon, then choose Export to Excel.
   
   
   

You can read these resources to learn more about inventory tracking and COGS:

• How to calculate and record COGS
• Impacts of inventory tracking on the balance sheet and profit & loss reports

I appreciate you for reaching out to the Community for assistance. If you need more help with COGS and inventories, never hesitate to mention me or add comments. I’ll be more than happy to help. Take care always!