I am creating a simple database that controls my company's stock

I am creating a simple database that controls my company's stock

We have already have a CRM software but it doesn't have stock control
ability. I am thinking to create another database from central MSSQL
server which has a table of list of product, price, quantity and other
information. In addition, we want to generate a monthly, quarterly and
annual report of our stock.
So I am thinking to create a table monthly named as e.g. 201308, 201309..
201312.. 201405.... Every time when I need to do reporting, I can
consolidate multiple tables into a pivot table in excel to do some
analysis.
Basically, this is my idea. I don't know the best practice is in this
scenario.
Can anyone give me some advices?