Pay commission
Export commission to payroll
Pay salespeople through payroll and export each settlement as a file.
updated: applies-to: 2.0.0.0
After posting a settlement, export the payroll CSV with one row per payroll salesperson and import it into your payroll system.
If commission is paid through your payroll system, set salespeople to the Payroll payout method and export each settlement as a file for payroll.
Set up a payroll salesperson
On the Salesperson/Purchaser card, in the Commission group:
- Set Commission Payout Method to Payroll.
- Enter the Commission Payroll ID, the employee number in your payroll system.
A salesperson paid through payroll.
A settlement with a payroll salesperson who has no payroll ID cannot be posted.
Export the file
- Create and post the settlement as usual. See Pay commission with a settlement. Payroll lines are paid when you post the settlement.
- On the posted settlement, choose Export Payroll File.
- Import the downloaded CSV file into your payroll system.
The file has one row per payroll salesperson: settlement number, posting date, salesperson code, name, payroll ID and amount. Reversed settlement lines are left out, so the file pays only what the settlement still pays.
With Settle Negative Balances on Commission Setup, a salesperson who owes commission back gets a row with a negative amount, so payroll can recover it.
To undo, choose Reverse on the settlement. Payroll lines are reversed too.
If you accrue commission in the general ledger, see Accrue commission in the general ledger for how payroll payments are cleared.