> For the complete documentation index, see [llms.txt](https://support.ordereazi.com/central/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://support.ordereazi.com/central/order-management/reports/commission-report.md).

# Commission Report

Work out each sales rep's commission for a period, on selling price or gross profit.

Paying commission from a spreadsheet means recapturing sales, and arguments about which orders count. The **Commission Report** in OrderEazi lists each rep's orders for a period, and works out their commission from the percentage on their user. You choose which orders count, and whether commission is paid on selling price or GP (gross profit).

### Before you start

You'll need the **Commission** permission, in the **Reports** permission group, and **Export (All Reports)** to export it. If you don't have them, ask your OrderEazi administrator.

Each rep's percentage comes from **Commission Percentage** on their user. See [Edit User](/central/order-management/settings/manage-users/edit-user.md).

### How to run the report

1. In the main menu, go to **Reports** > **Commission**.
2. Under **Include orders that are:**, choose which orders count (see below).
3. Tick **Include Expenses** to take a project's expenses off its GP.
4. Under **Calculate commission on:**, choose **Total Selling** or **GP Amount**.
5. Set the **Report date range**. It starts on the current month.
6. Select **Generate Report**.

### Which orders count

* **Approved:** Sales Orders created in the period.
* **Invoiced:** Tax Invoices dated in the period. Credit Notes in the period are taken off as negative rows.
* **Partially Paid:** Invoiced projects with part of their value paid.
* **Paid in Full:** Invoiced projects that have payments allocated to them.
* **Delivered:** Delivery Notes created in the period.

Voided documents and cancelled projects aren't included.

### What the report shows

The summary at the top has a row per rep, with their **Total Cost**, **Markup %**, **Total Selling (Excl)**, **GP Amount**, **GP %**, and **Comm**, and a **Grand Total**. **Total Expenses** and **Total Paid (Incl)** appear when there are expenses or payments.

Below it, each rep has a panel listing their orders, with the client, **Project Number**, **Document Number**, and the same figures. For invoiced orders it also shows the **ERP Number** from your accounting system, and the **Invoice Date**. A row marked "Late cost" is a cost added after the project was fully invoiced.

### How commission is worked out

* **Total Selling:** The selling price after discount, excluding VAT.
* **Total Cost:** The product cost plus shipping. A project's shipping, and its expenses if included, are shared across its documents by value.
* **GP Amount:** **Total Selling** less **Total Cost**, and less expenses when **Include Expenses** is ticked.
* **Comm:** **Total Selling** or **GP Amount**, times the rep's **Comm %**. **Comm %** starts as the **Commission Percentage** on the rep's user.

**Example:** Thandi's **Commission Percentage** is 5%. In March she has two invoiced projects: R40 000 selling with R28 000 cost, and R10 000 selling with R7 500 cost. On **Total Selling**, her commission is 5% of R50 000, which is R2 500. On **GP Amount**, it's 5% of R14 500 GP, which is R725.

To test a different rate, change **Comm %** on a row, or for all of a rep's rows in the header. The change isn't saved. The export still uses the **Commission Percentage** on each rep's user.

### How to export

Select **Export**. The Excel file has the full report, a summary, and a sheet for each rep.

### Related pages

* [Reports](/central/order-management/reports.md): the other reports
* [Edit User](/central/order-management/settings/manage-users/edit-user.md): set a rep's commission percentage