Regarding our conversation, I'm sending our stock report as of Dec-2014 (all shops and WH) for your reference.
For shop report, you can check the stock movement in "MONTHLY" sheet.
For WH report, "ENDING ALL" sheet will represent actual count as at end of the month with update purchase price per unit for all items.
For more info or any inquires, pls let me know.