Commissions for sales personal

Data from Quickbooks exported to excel. First export depicting client list with invoices limked sales rep and other details. Second export, amount amounts paid by clients defined by customer and linked to class/rep. Commissions calculated based on collection less sales tax with a maximum commission per client. Spreadsheet enclosed.