How do I find the cost of goods sold report?

[MADBros]

The title of this thread has been edited from the original.

looking for help

did they remove the "cost of goods sold" Report?

I can not find it anywhere

[GLG]

I need a COG report that = the cost of my sold inventory + items lost due to "damage", "theft", & "loss" (as those are the only inventory adjustments I use other than "stock received"). I have found no way to do this automatically or even manually if were to colelct numbers from other places.

A Sales & Loss Report does NOT give me the information I need. This report includes inventory recount down. I do NOT want this. I do inventory recounts for quantity typos. I ONLY want to see actual Sales & Losses (items marked as theft, loss, or damage). (I can run a report for Sales & Inventory Re-Count so why is inventory recount included in a Sales & Loss Report?)

What I have determined so far:

I can see costs/losses individually when I go to Items > Inventory Management > History & choose an adjustment type. BUT, it's just a scrolling list by date that I cannot download, get a cost summary of, or organize by item. Not being able to download it is pretty ridiculous. I have found no other place to get this information. Additionally, even though "theft" is an inventory loss option when adjusting inventory in an item, is not an option on the adjustment type drop down on this History page. Why not & where can I get that isolated information?

Again:

I need a COG report that = the cost of my sold inventory + items lost due to "damage", "theft", & "loss" (as those are the only inventory adjustments I use other than "stock received"). How can I obtain that information directly by creating a report or how I can I extrapolate it from a larger report? Even if I have to do it manually?

[GLG]

I need help with this please.

[Joe]

Hi there, @GLG - thanks for taking the time to reach out to us here on the Seller Community! Good to hear from you again.

I've merged your original post into an existing thread of Sellers who were also curious about generating a Cost of Goods report. I would reference Isabelle's Best Answer from that same thread. It will point you in the right direction for getting this report!

Feel free to shoot us a reply if you have any clarifying questions. We are here to help! 

[GLG]

This doesn't answer my question. I know how to run a COG report. My question is about the types of reports. This is my issue, copy-pasted from my original post:

"A Sales & Loss Report ... includes inventory recount down. I do NOT want this. I do inventory recounts for quantity typos. I order 10 pots, I get 8 because 2 are broken, the company reimburses me for the 2 pots. So I recount my inventory down. It is not a loss. I ONLY want to see actual Sales & Losses (items marked as theft, loss, or damage)."

How do I view my loss due to theft, loss, or damage? If I have to get those numbers & subtract them manually from a Sales (only) Report, that is fine. But I can't get this isolated information from anywhere. Where can I get that? What is the point in marking something as damaged or stolen if I can't actually get that information?

And why is there no option to edit quantity mistakes if recounts count toward losses? 

[ashc]

Hi @GLG,

Sorry for the late response. I had to reach out to our Retail team and things have been a little hectic lately on their side volume-wise.

I sent your questions in and they said when you mark something as a recount down- it will be included in the sales and losses COGS report. These can not be filtered out.

What you need to do in the "broken pot" scenario is to adjust the quantity that was received in the history tab of the inventory management. This will correct the amount of items received, but not mark it as a loss.

For the second question, you will need to manually track losses and damages, but these can be filtered by the type of adjustment in history.

If you have any further questions, please reach out to our Retail specialists directly here.

[GLG]

Regarding filtering for "damage" or "loss" in history: I suspect I will have hundreds of lines of damaged & lost items as I have a perishable goods business. You're telling me that the ONLY way I can get information on the total amount of damaged or lost goods is to scroll down the page with one hand & use a calculator with the other? That's absolutely absurd. What is the point in having this information & being able to filter it? Clearly I'm filtering for a reason.

On the backend, all of this information is in tables so it should be easy to let me download that information as a CSV so I can do my own addition, etc. Literally there is no way for me to extract the information I need? Like, it's universally impossible?

[GLG]

Also, the inventory history filter doesn't include theft. How can I see what items were marked as stolen? 

[GLG]

One more thing I noticed, in light of your response, what is the difference between a "Sales & Inventory Re-Count" & a "Sales & Losses" Report in Inventory History. What do they or do they not include?

[ashc]

Hey @GLG,

As I mentioned above it'd be best to reach out to our Retail team directly to break down these questions for you since they are specialists for this.

They're available by phone Monday-Friday 6am-6pm PST. 

You can contact them through our Contact Page here. 

[FlowersCo]

Hi @GLG, did you ever get an answer on this? I am experiencing the same issue.

I just need a report that has the total cost value of the damaged and lost product. 

We were creating a "damages ticket" for a while that helped with both the volume of perishables we had on a daily basis but it also removed the items from inventory. We would comp the ticket (created a comp reason called damages) but unfortunately, that only gave us the retail value and not the cost needed for taxes. 

Now we painstakingly enter damages individually, having to open each item, change qt, give a reason, close item, and 300 stems later we still can't get a report.

[GLG]

@FlowersCo I was told to call the retail team. I'm constantly astounded by Square's limitations. Why am I marking items as "theft" if I can never ever ever run a report to find these items or see them again? Like, never again will I know which items were stolen. And how am I supposed to file my taxes properly & take necessary deductions if I can't actually get an accurate count of my losses? We shouldn't have to ask for these very basic & obvious features. Anyway - not sure when I'll find the time to call & be on hold for ages in order for someone to say, "That's not a feature." Let me know if you are able to!

[jsel2]

I've seen others posting to find the COGS report.  2019 the report was easily found and available.  Now in order to get the information needed on Cost of Goods I have to pay to subscribe to your retail reports?

[ashc]

Hi @jsel2,

I moved your post to an existing thread on how to find your COGS report. 

Check out @isabelle's answer above!

[isabelle · Accepted solution]

Hey @MADBros-

Thanks for posting in the Seller Community.

Yes, Square does offer a Cost of Goods Sold (COGs) report, if you subscribe to Square for Retail.

Once you're subscribed to Square for Retail, log into your online Square Dashboard, navigate Item Library > Inventory Management > Reports > Cost of Goods Sold. Other reporting, such as Projected Profit, and Inventory by Category also comes with a Square for Retail subscription. 

Let me know if you have any questions about this! 💭

[BruceKeith]

Can you use Square for Retail Free to track Cost of goods if you only have one location?

[littleflower]

When I imported my inventory, each item had a cost assigned to it.  The item cost differs each time because of special discounts or change in shipping costs. 

Does Square keep track of each item's cost each time it is received or do I need to average the cost myself to get an accurate valuation of my inventory?

For example, I have 1 card in stock with a cost of $1.00.  I receive another card, but this time the cost is $1.10.  Do I enter $1.10 for the cost when I add inventory or do I enter $1.05 to average the cost so that my inventory valuation is accurate?

[Kassi_]

Hey there, @littleflower - 

Welcome back to the Community! 

I moved your post to a thread about our Cost of Goods Sold report which will help you to keep track of those. 

Check out the Best Answer by our Incredible @Isabelle

Thank you!  

[ahudso]

I need to provide a listing of total inventory, (1000+) and compare units sold year to year. I can find info by time frame, but not comparing two or more years.  We need to reduce inventory getting rid of "dead weight" using a three year history.  Any suggestions greatly appreciated!  

Thanks,

Amy

[JustinC]

@ahudson,

Assuming you're subscribed to Square Retail, you can only view Cost of Goods Sold reports up to 1 year at a time. You'll need to cross reference yearly reports to compare them side by side. I suggest exporting each year so it's easier. 

[SmartyPantsJane]

We use Square for controlling our inventory.  type of business that we are in allows us to buy inventory at different cost. I  typically us the Inventory Library to calculate my cost but I am not sure that this is allowing me to capture the different cost levels for an item. How in square does the inventory value calculate different cost levels? Is there a report that will allow me to see the cost of all received items that are still in inventory at the cost they were received? Example: I purchase a book  for a cost of $2.00 and then I received a copy of this same book for free. I entered one book at the cost of $2.00 and the other at $0 cost. This would be an average cost of $1.00 for the to books. what report do I run to see the cost of my inventory at the different cost levels?