How to report the cost of the item vs. the amount it was sold for

[ForgottenH]

Is it possible to have a report stating how much the product costs to be made versus the amount we sold it for to see the profit gained by the purchase?

[Tom]

Hi @ForgottenH, welcome to the seller community! Yes, you can do this with Square for Retail. For more information on cost of goods reporting options, have a look at this product update: Introducing Square for Retail.

Hope that gets you in the right direction. Let us know if anything else comes up. 🙂

[bluem00n55]

Track Cost of Item amounts or overhead costs vs. Sales and profits.

I discovered a way that works for me without subscribing to the Square for Retail.  When adding items to my library, I used the Description line.  I put in a description followed by ";"  Then I put in a number that represents the cost of item.  (My cost not the cost to customer.)  My library exports into an Excel document.  I can then split the data divided by the ";".  I end up with a column with just numbers which represents the cost of item or overhead cost.  Then using Excel Product equations, I can multiply the COI column times the Stock column to get my current overhead amounts.

Then I can compare this to my Start of the year amounts to figure my sales and profits. 

Not sure if this is the right place to put this comment.  Only my second post.  What do you think?  Hope this helps somebody.

[Alex_]

Hi @ luem00n55,

That's a great workaround! Thanks so much for commenting in this thread. Definitely a great place to share this suggestion; we aim to have our sellers collaborate amongst each other as much as possible. 

Let us know if you ever have any questions or feedback.