Query w.r.t reporting need (accrual report for commissions )

hi Team,

Scenario:

we need a commission accrual report for commissions on sales which have not been earned (eg cash not yet received)
 
we need the details of the commission amount that would accrue in future for those invoices which are yet to be paid by the customer. we want to create provision journals manually at the end of the period and they will be reversed in the next month. This is need for monthly closing as they need to record their provisions.
 
Can we get a report or extract of details of the likely commissions we would be paying for all the orders which are invoiced but customer payment is not yet received? (for cases where the actual commission plan would be based on customer receipt)