In this article, you will learn about Sellercloud’s Sales Rep Commission report. This report calculates the commission earned by sales representatives based on their set commission rate and the profit of each order.
The report can also take into account a Sales Rep Cost, which is an optional additional percentage added to the cost of an item to account for external costs such as warehousing fees.
The commission is calculated by subtracting the total costs (including the Sales Rep Cost) from the total payments and then multiplying that number by the sales rep’s commission rate. The report also allows for multiple sales reps on one order, with the commission being divided among them.
You can generate the report based on:
- Date range: Date Range, Payment From Date, and Payment To Date.
- Sales information: Sales Rep, Transaction Type, and Order Number.
Access and Customize the Report
To use the report, follow these steps:
- Navigate to Reports > Sales > Show more > Sales Rep Commission.
- Set up the Filter Options to have the report show precisely what you need.
- Click Run Report.
- To export the report to a spreadsheet, click the Export to Excel icon.
- To create a scheduled task that automatically runs this report periodically, click the Schedule a task to run this report icon.
Filter and Column Definitions
Click the drop-downs below for filter and column descriptions.
|View sales commission info for specific preset date ranges.
|Payment From Date
|View sales commission info for a custom preset date – enter the From date.
|Payment To Date
|View sales commission info for a custom preset date – enter the To date.
|View sales commission info for a specific sales rep.
|Filter sales commissions by credits or debits.
|View sales commission info for one or more specific orders.
|View info filtered by order status – select between Settled order only or All Orders.
|Shows the Sellercloud order number.
|Shows the transaction type – Debit or Credit.
|Shows the date of the transaction.
|Sales Rep Cost
|Some businesses add a percentage to the purchasing cost of an item to account for external costs. This added percentage is calculated to create a special Sales Rep Cost. The sales rep cost will be used in calculating the commission:
You can enable the Sales rep cost by going to Client Settings > Enable Salesman Cost.
|Shipping amount charged to the customer.
|The amount paid for shipping the order.
|Shows the total amount of the order, calculated as follows: (Subtotal + Shipping Total + Handling + Insurance + Gift Wrap + Tax) – (Discount + Shipping Discount).
|Shows the total profit from the order, calculated as follows: (Payments – Shipping Total – Handling Fee – Insurance – Gift Wrap – Tax – Refunds) – ((Items Cost * @salesmancostPercent) + Items Cost)
|Sales Rep Profit
|Shows the sales rep commission, based on a percentage set per employee. You can set the sales rep commission rate by going to Employees > Employee > General Information > Sales Man Commission.
The sales rep profit is calculated against the order profit as follows:
To allow multiple sales reps on order, go to Client Settings > Enable Multiple Sales Reps. Sales reps and their unique commission rates can be configured on the Sales Representatives page – go to Order Detail > Action Menu.
|Shows the email address of the sales rep.
|Sales Rep 2
|Shows the email address of the second sales rep.