How would you use square when deducting inventory for internal use?

[Brownbagroaster]

We are trying to figure out how to take items out of our warehouse inventory when we use them in house. We sell products retail and wholesale that we also use in our shop. For example: We take six bottles of syrup from our warehouse for use in our own shop, and would like to scan the SKU and deduct them without having to show a sale. This would allow us to keep track of our own usage. Currently, we have a "front of house" deduction in our system (100%) but it shows as a sale for the day of 'x' amount with a 100% deduction. I'm just not sure how this is going to affect our accounting. Has anyone figured out how to reduce inventory without having to manually go in on each item and click on 'inventory recount' which would not actually show that an item had been used, just that there was one less?

[Candlestore]

@Brownbagroaster ;

The only other ways I know of are:

1. - Do a Price Override and make the price 0.00.  This would get rid of the 100% discount.... again not sure how this effects accounting
2.  - I used my Accounting software and in there I was able to have it used as a production, display, or test item.  I had an accountant set this up.

When I use method B, I just export my inventory count total to square, and upload that new quantity by csv file.  So there is not a loss of an item or my quantity is off.  Square is setup to count the number of your items and not as a Accounting package.  This is where things gets messy.  Whenever we do a demo item, or sample thing for instore use, I write it in a log book and then at the end of the day I enter this into the accounting software.  If it is 1 item I find the item in my catalog and just reduce over all quantity by the number we used.  Sometime if we do this alot (around the holidays), I create a Google sheets Spreedsheet.  Barcode and quantity used.  Then I download and use Xlookup on the Barcode to make new quantity number, Square Stock - Number on the google sheet.  I have a scanner attached to a chromebook to keep it simple and have Tab set on the scanner.  I scan item then enter the quantity <enter>, ready for next item if any.  Save the sheet for the end of the day.  I use the same thing to adjust my accounting package but adjust as needed by headers and columns.  Demo item for reason or Store use.

I know this is not the quick response but may help you and have your accountant or bookkeeper look at these and see which works the best for them and you.