How to get the payment automatically filled

Hello,

I'm working with an income statement. I want to record the money that I received from my customer into each month of the year. But there are different payment mode: single, monthly, quarterly, semiannual and annual. What I want is:

For example customer wants to pay for the sum of $100 semiannual (2 times a year) and the first payment of $50 is made in June. The next payment of $50 will be made in December. My question is how I have the payment automatically divided by 2 and added in to the June and December ?

this is how the worksheet may look like:

Sheet1: When I Fill in all the information in this page

Name Month receive Payment amount Payment mode
A June $100 semiannual

Sheet2: I will have this page automatically done like this

Sum of the Payment receive in month

month 1 2 3 4 5 6 7..... 12


$50 $50