x

Report - total inventory loss

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.

2,054 Views
Message 1 of 8
Report
7 REPLIES 7

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.

2,063 Views
Message 2 of 8
Report

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!

2,060 Views
Message 3 of 8
Report
Alumni

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!

Valentina
Community Moderator, Square
Sign in and click Mark as Best Answer if my reply answers your question.
2,008 Views
Message 4 of 8
Report

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

1,990 Views
Message 5 of 8
Report
Admin

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.

Bea_
Beta Community Manager, Square
Join the Beta Community
Evaluate | Influence | Engage
1,944 Views
Message 6 of 8
Report

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

1,730 Views
Message 7 of 8
Report
Alumni

@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. 

Justin
Community Moderator, Square
Sign in and click Mark as Best Answer if my reply answers your question.
1,722 Views
Message 8 of 8
Report