Cost of Goods Sold Report

Follow

Cameron Dixon

• August 29, 2018 01:27

Just curious which report will yield me something that shows me the cost of goods sold? Is there a report available or do I have to manually figure this out using multiple reports?

Our bookkeeper is asking for that report but I am really uncertain as to which report I can use. Thought I would check here and in the meantime, I will offer her some reports to see if they come close to what she is looking for.

Thank you.

0

• 

  Chris Muench

  • August 29, 2018 05:14

  Could you tell me the formula to calculate cost of goods sold? If we have the data we can add to report

  0

  Comment actions Permalink
• 

  RGV BREW

  • September 05, 2018 15:59

  I export the SALES and then calculate the COGS by subtracting the profit from the Sale amount.

  So the formula is simply SALE minus PROFIT in this case. 

  PHPPOS must be determining PROFIT using the inverse, ie, SALE minus COST and depends upon how Cost is setup in Store Config

   

  0

  Comment actions Permalink
• 

  Chris Muench

  • September 05, 2018 17:58

  Profit is sale - cost. So you are saying COGS is sale - profit

   

  example

  selling price 4

  cost price 1

  profit = 3

   

  COGS = 1?

   

  Does this work for everyone?

  0

  Comment actions Permalink
• 

  Cameron Dixon

  • September 07, 2018 02:57

  Sorry for the late reply, I had asked out bookkeeper a couple of times without a response. This is what she was asking for as quoted, "

  "The report just needs to list the cost price of the stock that was sold.  For your own purposes, it can also show the sales and therefore the profit but I don’t need those as they are recorded in the bookkeeping."
  
  Is there a current report that shows the cost price of the stock sold? I think the formula above would show that if I were to use it for any given month but am not certain if there is anything available in the current list of reports in your software.

   

  Thanks for checking in on this question, I think it would be a great additional report to offer in the future.

  0

  Comment actions Permalink
• 

  Chris Muench

  • September 07, 2018 15:15

  Lets use this as an example

   

  Item: Tennis Can

  cost price 1.50

  selling price:4

  quantity: 3

  would cost of goods be 4.50? Is that really all that is needed?

  0

  Comment actions Permalink
• 

  Cameron Dixon

  • September 11, 2018 01:58

  Yeah, she says that is all she needs. Is that a worthy report to create? I think it would be helpful to have something like that for many business owners.
  Thanks again for looking into this for me.

  0

  Comment actions Permalink
• 

  Chris Muench

  • September 11, 2018 02:33

  We have added to sales > detailed and items -> summary report for our next release. Do you want it on any other reports?

  0

  Comment actions Permalink
• 

  Cameron Dixon

  • September 11, 2018 02:39

  I think that will be great if it integrated. Thanks so much.

  0

  Comment actions Permalink

Please sign in to leave a comment.