@Anonymous this is a pretty common requirement for many Shopify users, and there are several inventory systems out there to achieve this. You might also look into having a developer create a script for those specific reports if that’s all you need since most inventory apps will go more detailed than this.
If you end up needing a warehouse & inventory system to use for purchasing & check-in, allocation to bins, pick-pack-ship automation, everything you need to run your warehouse and fulfill orders, you should check out SKUSavvy which is a mobile WMS that would solve this for you.