Commission Desk

Documentation

Getting started

Add each rep under Reps with a name and a commission rate. Rates are entered as percentages: 5 for 5%, 7.5 for 7.5%. Leave New rate applies from empty for a new rep: the rate then applies to all of the rep's deals.

Open Import deals and paste the month's closed deals, or choose a CSV file. The first row names four columns: deal, rep, date and amount. The rep is the rep's name as it is under Reps. Dates are written YYYY-MM-DD. Amounts are written like 1250.00; an amount with a comma must be in quotes, as spreadsheet programs write it.

If any row is doubtful, nothing is imported and each problem is listed with its line. Importing the same file twice changes nothing.

Open Statements to see each rep's month. Deal lines shows every deal with the commission it earned. You can also add a single deal by hand under Deals.