V9 - Commission report


 

Use case

The Commission report (Operations > Reports > Sales > Commission report) provides multiple avenues for commission information. These include the ability to display paid and unpaid transactions, value from returns, net or gross values, and commissions based on your settings (item-based commissions and sales representative commissions). The report shows commission data filtered by the sales representative, item name, customer, and order type. Only administrators have access to the Commission report. 

 

While the basics for running any report in SOS Inventory are covered in Reporting introduction and Running a report, the filters, options, and columns specific to the Commission report are explained below.

 

Filters

From date and To date.

 

Sales rep. This filter is required. Select All or individual sales representatives. All is the default. Multiple individual sales reps can be selected. You cannot run the report for a sales rep that has been deleted from the system.

 

Item name contains. Type all or part of an item name to display matching items.

 

Customer. Choose the desired customer from the dropdown.

 

Order type. Select the sales transaction type(s) to include in the report. Options are Invoices, Sales orders, and Sales receipts. The default is Sales orders. More than one Order type can be selected.

 

Options

Show transaction summary only. If enabled, provides a commission summary for the transaction. If disabled, displays line-by-line commission information for each transaction. The default is line by line.

 

Subtract customer returns. If an item was returned against a sales transaction, enabling this setting removes that line item from the report, since it is not eligible for commission.

 

Show only if order invoiced or invoice paid.

 

Use net instead of gross (beta). If enabled, commissions are calculated by the net margin instead of the gross margin. This feature is in an early-release state and might have more issues than normal. Use with caution, and contact Support if you run into any problems.

 

Show "from" and "to" dates. If checked, shows a date range at the top of the report, based on your From date and To date filters. The date range appears when Display is selected under Retrieve your report. If the report is retrieved by Email or Download, the header will appear only if you print your spreadsheet. If a header is also entered for the report, the date range will be displayed below the header.

 

Group by. A set of options that allows you to group data on the report. The options include: None, Customer, Item, or Sales rep. The default is None, which orders transactions by date, from oldest to newest. If your Group by option is set to Customer, Item, or Sales rep, the report shows the name of each as a subheading, followed by the associated transactions, which are also organized by date, from oldest to newest.  A Total line for each customer, item, or sales rep listed is also displayed.

 

Header. Enter header text for the report, if desired. The header appears when Display is selected under Retrieve your report. If the report is retrieved by Email or Download, the header will appear only if you print your spreadsheet.

 

Footer. Enter footer text for the report, if desired. The footer appears when Display is selected under Retrieve your report. If the report is retrieved by Email or Download, the footer will appear only if you print your spreadsheet and will show above the system-generated text, Report Generated [date] [timestamp].

 

Columns

The default columns for the Commission report are Order #, Order Date, Txn Type, Customer, Item, Description, Total Amt and Sales Rep. Twenty-four additional SOS column options are available, as well as any custom fields you have defined for items, sales orders, invoices, and sales receipts.

 

An order number is a clickable link to its record on the associated transaction list.

 

Sample Commission report

The sample Commission report below is filtered for a date range from 07/01/2026 to 07/31/2026, for Sales rep Johnny Stern, and Order type Sales orders. The default columns (Order #, Order Date, Txn Type, Customer, Item, Description, Total Amt and Sales Rep) have been selected.

 

Item-Based Commission, Rep-Based Commission, and Total Commission are built into the report. The Item-Based Commission is the amount of commission due based on the commission set in the item record. The Rep-Based Commission is the commission due based on the commission rate set for the sales rep.  The Total Commission for that line is the sum of the Item-Based Commission and the Rep-Based Commission.

 

A Total line at the bottom of the report reflects the sums for the Total Amt column and each of the built-in columns. The values in the Total Amt, Item-Based Commission, Rep-Based Commission, and Total Commission columns are in the home currency.

 

The first line of a transaction bears the total Rep-Based Commission and total discount for an entire order. Because of this, a negative amount may be displayed for the values in that line for the Rep-Based Commission and/or Total Commission columns on the report. Please note that the order of the items on a transaction is reversed in the report, so the first item on the transaction will be listed last in the Commission report.

 

For example, on sales order SO477, the items are listed with Hammer on Line 1, Air Duster Pro on Line 2, and 387450 - Flight Jacket -BL - LG on Line 3.
 

Sample sales order SO477

 

So all of Johnny Stern's commission for this sale, as well as the transaction-level discount (as reflected in the Discount Amt field on the sales order), are deducted from the Hammer item because it is the first line in the sales transaction.

 

However, the items on the Commission report for sales order SO477 are listed in reverse order. The 387450 - Flight Jacket - BL - LG has an Item-Based Commission of 132, a Rep-Based Commission of 99, and a Total Commission of 231. The Air Duster Pro has an Item-Based Commission of 6.3, a Rep-Based Commission of 4.73, and a Total Commission of 11.03. The Hammer's Item-Based Commission is 0, and the Rep-Based Commission and Total Commission values are -0.63.

 

A sample Commission report. Sales order SO477 is highlighted.

 

In Johnny's sales rep commission definition, his commission rate is 15%, and he earns a per-sale commission of 1.00 as well. The item definitions for the 387450 - Flight Jacket - BL - LG and Air Duster Pro also earn him per-unit commissions: 20% per flight jacket, and 15% for each Air Duster Pro.

 

Here is how the system calculated Johnny's commission for this sale:

 

 

Notes

For more information on sales commissions, see Sales commissions.