cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
DG_99
Level 1
posted
‎April 08, 2023 06:28 AM
last updated ‎April 08, 2023 6:28 AM

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  need to have  a report of showing COGS and Closing stock (inventory) for  goods sold in a month in a single report
Reply
1 Comment 1
MadelynC
Moderator
Moderator
‎April 08, 2023 08:50 AM

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.
    1.png
    1.png
    1.png


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

 


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!

Reply