I need to know what shrinkage adjustment to make to my inventory value, so I ran the inventory history report for last year, focusing on the recount adjustments. Some are adjustments into inventory (additions to the inventory value) and some are adjustments out (subtraction from the inventory value). You can see the little up and down arrows in the example in this screenshot:
So, for example, my inventory went down in value by $37.80 because we were missing one planner, and up in value because we found a previously uncounted ball of silver yarn.
HOWEVER, after I export the report in order to be able to add up the numbers and get a number to use for the annual adjustment, the $37.80 and the $6.50 are both positive on the spreadsheet. Every single cost number is positive on the spreadsheet, regardless of whether it was an adjustment in or out of inventory. Adding up the numbers on my exported spreadsheet would be completely meaningless.
Am I missing something? How do I get the information that I need?
Ok, I've uploaded the exported spreadsheet to Google Drive at this link:
Here is a screenshot of the search (the goal was to find all adjustments made last year attributed to recounts):
And here is a sample from the report showing a few lines, some of which were transfers in, and some of which were transfers out. When you find the corresponding lines on the spreadsheet, you can see that all numbers are positive. So adding up this column would give me a meaningless number.
