EXCEL how to build storage management table

We are electronics companies, many kinds.I have a request:Date (day), type, the number of Jincang, a number of warehouses, waste explosion in the number of each type of balance.Per lose any data can be displayed automatically balance .We can see every day what the goods into, out of any goods.

This very easy to leave your e-mail address We are now electronic, variety.I have a request:Date (day), type, variety and specifications, the number of Jincang, a number of positions, scrapped the number of each type of balance.Per lose any data Automatically show the balance.Can be seen every day of what goods into and out of what goods