x

Inventory Transfer Report

hi..... we have 2 locations: a physical bookstore and a virtual e-commerce location. When I transfer inventory from the bookstore to the e-com location, I'd like to be able to generate a report that shows which items/stock were transferred on a particular date.  Is there such a report available in Square? I can't seem to find one.  Thank you.

888 Views
Message 1 of 6
Report
5 REPLIES 5
Square Community Moderator

Hello there @sharkie_rich

 

This report you're looking for is located under your Inventory Management > History Report. Once there you will want to filter the adjustment type to Transferred and the time frame you're looking into. 

 

This is what it looks like:

 

 

I hope this information is helpful!

JJ
Community Moderator, Square
Sign in and click Mark as Best Answer if my reply answers your question.
830 Views
Message 2 of 6
Report

Thank you very much!

784 Views
Message 3 of 6
Report

Awesome! Thank you!

697 Views
Message 4 of 6
Report

JJ - this was very helpful.  Could I ask a related question?  I can't see to find a simple way to transfer stock from one location to a second, which would allow the transfer to show the actual cost of the stock (not the retail cost).  Here's why I'm looking for this:

- we are a small business with a brick and mortar bookstore and a small online shop.

- we've set up Square with two locations: one is the physical bookstore (named "Hermitage"), and the other, named 'ecom', is for our virtual online store.

- we offer some of the same items we sell in the physical store in our online shop as well.

- when an item sells online, an employee has to walk over to the bookstore and select it from stock, then take it back to the shipping department and package/mail it to the online buyer.

- we need to show our accounting department that the stock from the store didn't "disappear" - that it was actually used for a sale on our ecommerce site. This report should show the item description used for the online sale, any SKU it has, and its actual cost to acquire (not the retail cost but our cost).  Then the bookkeeper can account for it in the accounting books.

- in order to do this, the only way I found was to create a customer named 'ecommerce' and then "sell" the items purchased in the online sales to this 'ecommerce' customer, listing the sales price as the actual cost (so we don't appear to make money on our own ecommerce sales).  

- that is why I wanted to know how to get a report on transferred items in my original question - I'm trying to give the bookkeepers a way to track what was transferred from the physical store to the online store.

 

But does Square have a simpler more straightforward way to transfer items from one location (our physical store) to another location (our shipping department, or 'ecommerce'), without creating all these hoops to jump through?  It surprises me that it doesn't have an obvious way to do this, since this is quite a common business practice.  Any ideas?

640 Views
Message 5 of 6
Report
Square Community Moderator

Hello there @sharkie_rich 

 

At this time, Square doesn't have a way to transfer or report items or stock sold at a different location. However, with Square for Retail Plus, you can easily move inventory from one location to another before it is sold. What I'm suggesting here is moving the items that are sold online to online only and whenever the item will be sold in the store you can have your employee perform the action from the point of sale to transfer the stock from the ecom location to the Hermitage location.

 

This might be a bit complicated to explain here in the Seller Community but our Retail Team can definitely point you in the right direction. They can be reached at 855-700-6000 between 6 am - 6 pm Pacific Time Monday-Friday. If you call outside of these hours, you will be required to enter your Customer Code to validate your account.

JJ
Community Moderator, Square
Sign in and click Mark as Best Answer if my reply answers your question.
592 Views
Message 6 of 6
Report