Budget Projection

Hi everyone,

I am trying to setup a pipeline report that I can use as a budget projection. Here's the summary:

There are 2 products which receive payments at different visits and with different revenue amounts and outsourced expenses. I would like it so that if my staff project that we will sell 5 units of product 1 in February, that the revenue earned from those products appear in the respective month in which they are earned. (See same worksheet, I manually entered them in FYI). Then in March we sold 7 more and those automatically show in the Product 1 table, etc. We have about 300 different products, each with different values and timelines so I hope this can be achieved.

Thanks in advance.