looking an excel operator

I want to streamline and improve on our current commission reporting system. Currently data gets imported from the accounting software to excel and there is a lot of manual entry to be done prior to calculating the final commission for each sales person. The final product thank to be readable and understood by board members as well as the sales team.