Lesson #72
Payables – Sales Commission Report function
The Sales Commission Report lists all invoices that include a commission, grouped and subtotaled by Sales Rep. A commission is automatically generated from invoices on orders initiated by a Sales Rep’s client.
The default report list all invoices posted today that include sales rep commissions. It includes commissions on both originals and copies — and doesn’t deduct expenses from commission calculations.
Customize report views
You can view reports:
- For different days or date ranges.
- By payment post date instead of invoice post date.
- For a single sales rep.
- For originals only if you do not pay commissions on copy sales.
- For copy sales only.
- Excluding custodial fees if you pay commissions based on NIBO (Net Income Before Overhead).
- For one or more of your company’s business units.
Depending on your search conditions, MR9 lists all of the relevant invoices as a report, grouped by Sales Rep, with each having their own page(s) and a grand total page of all commissionable amounts and commissions. The report’s footer will display which Date Type and date range you used to generate the report.
The report breaks out scheduling firm and contact, invoice number and date, whether a commission is for an original or copy, order part number and date, commissionable amount, commission, case name, and Sold To firm. In addition to the report subtotaling commissionable amount and commissions by resource, each resource’s total is further broken down into subtotals for ordering contacts and firms.
You can search for a word or phrase in the onscreen report. MR9 will highlight all instances of your searched word/phrase in the report and list them in a scroll box along with the page number where they occur.
Using the report
Besides looking up details about sales commissions, you can use the report to help you adjust commissions in the Override Sales Commission function, and in other ways:
Voided invoices and invoices for which you have issued credit memos or debit memos are listed at the end of each person’s commissions as adjustments so you can void, decrease, or increase the commissions if desired. (You also have the option when voiding or issuing a credit/debit memo on an invoice to not alter the commission, then that invoice will not appear in the Adjustment list.)
Export the report to save it, give to resources, edit in another application, or print.
TL;DR: View all invoices that include a commission grouped and subtotaled by Sales Rep. Invoices that may require an adjustment to the commission — such as voids — are listed separately for each person.
MR9 concepts in this lesson
Business Unit (BU): One of your company’s revenue centers or any entity in your business that you want to track separately.
Contact: Person who works for a firm you do business with.
Date Type: Depending on the function you are using, you can choose to see results for different date categories — such as the date an invoice or client payment was posted.
Firm: Business you provide services to — usually law firms.
Scheduling Contact: Contact who initiates orders with your company.
Scheduling Firm: Firm that initiates orders with your company.
Sold To Firm: Usually the Ordering Firm on a job.
