Calculate COGS by Customer

[wise_industries]

My business is unique, I only sell to two customers. I need to be able to view COGS separately for each customer.

The COGS report in inventory reporting shows you the entire COGS for the date range selected, but it doesn't seem like there is any way to view COGS by customer.

Is there a way to do this?

 

[JessPoynter]

Each transaction has the ability to have a customer attached to it. Have you looked through the transaction details for each day?

[wise_industries]

Yes, I have. If I export the daily transactions from the transactions tab, the export has the customer name and product price they paid, but the export does not include the unit cost of the products that they purchased in that transaction.

I am still actively trying to figure out where to find the COGS by customer. Any help is appreciated. 

[JessPoynter]

Hmmmm....I can't remember seeing this ability in any of the menus. I think you might have to create a separate Excel sheet and figure out the COGS independently. You can work backwards with the information you get from the various reports now, and just calculate by hand or inputting in a separate excel sheet. I wish I had a better answer for you!