How do i calculate monthly balance for multiple product?

I work in a project delivery department
The department source a few products from overseas and we use quickbase to facilitate the delivery and orders
we currently extract all data into excel and use excel to report the products balance each month.
we have been trying hard to find a solution within Quickbase to provide a live update  in graph format each time the product movement is updated/created
below is a screen shot of the graph we try to achieve in Quickbase
any help is much appreciated


------------------------------
Leon Wong
------------------------------