Quote Originally Posted by OBP
One thing that I don't understand is where the 2nd Amount comes from?
Sorry I missed this one.

Basically if sales person makes a sell we run an invoice to setup the equipment. Then the following month we send a monthly invoice(recurring for subscription).

They get 1/2 when the setup is paid and 1/2 when the first monthly is paid. So if a total commission is 100, they get 50 when after the first invoice and 50 when the subscription invoice is paid... there are various rules to that based on what plan year we work in.

Also if it is for a prior plan then they were getting a residual on the customer. $100 sell gets a $1 commission, that starts after 36 months. So.. I've had to recalculate because I realized as I sent that spreadsheet that for a 36 month period the startDate Jan 1-2009 would actually have an end date of Dec 1-2011 as Jan 1-2012 would actually be 37 months.