Hi, I can create for you a Sales Commission Module in Excel to calculate commissions to salespersons based on sales, personal parameters, by sales or collections (including by partitional payments). I will add a procedure to connect between salespersons to customers including transferring customers to other salespersons from any date. The sales and commission reports will show the outstanding commission for each salesperson and his sales which were not paid yet by the customers. The module will have tables with information as follows: Customer list (Customer name, salesperson name).Sales by invoices (invoice no, invoice date payment terms, amount)Salespersons list (name, commission rate, minimum sales, sale or cash)list of payments by customer (date, amount)List of payment to salespersons (salesperson name, date, amount).
I am an expert and guru in Financial, Math and Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script for charts). I am sure that my combined knowledge, skills and creativity will lead to exceptional results that will exceed your expectations.