Reyuko does not currently calculate sales commission for your own salespeople. There is no commission rate on an employee, no commission report and no commission posting. This lesson is a workaround, not a built-in feature. You tag each sale with the salesperson, take the sales base from Reyuko, calculate the commission outside the app, and record it through payroll or a manual journal.
Key takeaways
- Reyuko does not currently calculate commission for your own salespeople. You calculate it outside the app.
- Set the Staff / ID on each sales document. This ties the sale to a salesperson.
- Sales by sales rep gives the sales base per person. It does not subtract sales returns.
- Pay commission with the monthly salary as a payroll component, or separately with a manual journal to 5-3009 Commission Expense.
- Do not give commission as an invoice discount. A discount lowers sales instead of recording an expense.
Step 1: Tag every sale with the salesperson
The Staff / ID field on a sales document is a dropdown of Employee contacts. Choose the salesperson when you create the invoice. A sale with no Staff / ID does not appear under any person in the sales-by-rep report (check your version).
Step 2: Get the sales base for each person
Go to Sales > Reports and open Sales by sales rep. The report counts invoices with status Posted in the date range. Amounts are before tax. Set From and To to the commission month.
Illustration: Harbor Wholesale is a fictional business; numbers are examples. Harbor's salesperson Dewi has two October invoices, for 120,000,000 and 60,000,000. The report shows 180,000,000 for her. Sales returns on her October sales total 5,000,000. The report does not subtract returns, so you work that out yourself. At a 2% commission rate, the figures are:
| Item | Amount |
|---|---|
| Sales by sales rep, October | 180,000,000 |
| Less sales returns on her sales (your calculation) | (5,000,000) |
| Commission base | 175,000,000 |
| Commission at 2% | 3,500,000 |
Step 3: Pay the commission
You have two routes. Choose one per payment and keep the rule the same every month.
Route A: with the monthly salary
- Go to HR > Payroll and click New Run for October.
- In step 2, Input Components, click Add Component. Name it Sales commission and enter 3,500,000 as a positive amount.
- In step 3, Review & Post, post the run.
- Pay the net salary in Payment > Salary.
The commission then sits inside the month's pay. Posting uses the salary expense account, 5-2001. Check your version for how income tax is calculated on this component, and whether it can post to a different account.
Route B: paid separately
Use a manual journal when you pay commission outside the payroll run. Go to Accounting > Journal. For a bank transfer of 3,500,000:
| Account | Debit | Credit |
|---|---|---|
| 5-3009 Commission Expense | 3,500,000 | |
| 1-1002 Bank | 3,500,000 |
The Wholesale template adds 5-3009 in both blank and sample starts. If it is missing from your chart of accounts, check Chart of Accounts before you create it. A manual journal does not go through the payroll tax engine, so ask your accountant how to treat it.
A discount on the invoice reduces your sales and revenue. The commission then never shows as an expense. Use payroll or a manual journal instead.
Reyuko does not store a commission rule or a commission history for an employee. Keep a sheet with the rate, the base, the returns and the approval for each month.
For commissions on goods your agents sell, which is a different case, see Agent Sales Reports and Commission Calculation.
Check yourself: commission after returns
Dewi's commission base after returns is 98,000,000. At 2%, what is her commission? Answer: 98,000,000 × 2% = 1,960,000.
Reyuko