thread Re: Calculate COGS by Customer in Archived Discussions (Read Only)

Calculate COGS by Customer

wise_industries — Tue, 10 Aug 2021 02:39:48 GMT

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?

Re: Calculate COGS by Customer

JessPoynter — Tue, 10 Aug 2021 19:57:48 GMT

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

Re: Calculate COGS by Customer

wise_industries — Thu, 12 Aug 2021 17:58:15 GMT

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.

Re: Calculate COGS by Customer

JessPoynter — Fri, 13 Aug 2021 13:59:06 GMT

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!