thread Re: How do I print a report of loss inventory in Archived Discussions (Read Only)

Report - total inventory loss

GLG — Mon, 20 Jan 2020 21:55:14 GMT

I'm putting together a report & I need an Inventory Loss line that shows the dollar amount of inventory that was damaged, stolen, or reported as a "loss" in the inventory stock action drop down menu. I have a perishable good business so there is quite a bit of inventory loss.

I know I can run a report for Total Sales as well as Total Sales & Losses. However, how can I see JUST my total losses?

If there really no way to isolate this information? If not, how do I calculate it?

These are my numbers:

2019 sales & losses

TOTAL COST OF GOODS SOLD

$91,240.22

TOTAL REVENUE

$211,790.27

PROFIT

$120,550.05

PROFIT MARGIN

56.9%

2019 sales only

TOTAL COST OF GOODS SOLD

$81,927.02

TOTAL REVENUE

$211,790.27

PROFIT

$129,863.25

PROFIT MARGIN

61.3%

Being able to see inventory loss by item would be AMAZING so I can quit stocking items with the greatest loss.

Inventory recount showing up in "Sales & Losses" Report

GLG — Tue, 21 Jan 2020 16:30:45 GMT

Inventory recounts are showing up even when I run a "Sales & Losses" Report. I do not want this. I have products I sell on commission. I put in the inventory but if an artist picks up an item because they need it, I need to do a recount to subtract it from my inventory. Same when quantities have been incorrectly entered by mistake. This is creating a HUGE problem for my COG 2019 report.

I need help ASAP please!!!!

Also, how can I pull out the items by stock action? Particularly, losses, so I can see what items I lost the most of?

Thank you.

Re: Inventory recount showing up in "Sales & Losses" Report

GLG — Tue, 21 Jan 2020 16:47:23 GMT

Follow up: I have 100s of items that are showing recount when those marked as "recount" should actually be inventory received. During end of year recounting, I had to edit the exported item spreadsheet to increase items that were showing up as negative. (I do not enter all inventory when received & monitor sales based on a negative amount. Ex: -10 = 10 sales). When I entered the new quantity in the new quantity column, I would enter "0" thinking the -10 would go to 0 & Square would assume the increase of 10 was inventory received, not a recount. That is not what happened. This makes me wonder what the point is of the spreadsheet for entering tons of new inventory if a new quantity increase shows up as a recount & not stock received. What am I missing? This is infuriating because my numbers are totally F'd. I can't tell what my TRUE COGS is!

Re: Inventory recount showing up in "Sales & Losses" Report

Valentina — Wed, 22 Jan 2020 21:25:07 GMT

Sorry to hear about the reporting confusion here, @GLG! I would recommend taking a look at this Support Center article - it goes into a good bit of detail about the Cost of Goods Sold, Projected Profit, and Inventory by Category reports.

For more immediate assistance with your reporting questions, I would urge you to get in touch with us. When you call us, you can request to speak directly with a Square for Retail specialist - our team will be happy to transfer you over to them to receive some one-on-one help!

How do I export the data on the items damaged?

MPursley — Wed, 08 Apr 2020 18:39:59 GMT

I need to export the data on my damaged report. I don't see a way to do this. Any ideas?

Re: How do I export the data on the items damaged?

nika — Fri, 10 Apr 2020 12:28:41 GMT

Hello @MPursley-

Take a look at @Valentina's answer above. There is Cost of Goods Sold report that she links to which should get you that information you're looking for.

How do I print a report of loss inventory

Colarussop — Mon, 03 May 2021 19:00:47 GMT

I need to print out a list of lost inventory that we pulled and the value... how do I do that?

Re: How do I print a report of loss inventory

JustinC — Wed, 05 May 2021 18:39:44 GMT

@Colarussop

These details are found in the Cost of Goods report if sub'd to Square for Retail. Moved your post to a relevant thread.