Introduction and Need

Hello, I am just starting on the Excel Forum. I am ccarico, and in my work, I use excel occasionally. It just so happens that I am currently looking for a great way to keep up with inventory stock, both in-coming and outgoing. I also want to keep an available balance total for each stock item. My search involves the need for certain cells on the spreadsheet to both add and subtract due to receiving and assigning out and/or selling certain stock items. Due to this need, I will need a formula that allows me to maintain a good balance. Any suggestions?