{"id":160,"date":"2020-11-04T16:44:03","date_gmt":"2020-11-05T00:44:03","guid":{"rendered":"http:\/\/omtiblog.com\/metarecords101\/?p=160"},"modified":"2026-06-23T18:06:53","modified_gmt":"2026-06-24T01:06:53","slug":"sales-commissions-report","status":"publish","type":"post","link":"https:\/\/omtiblog.com\/metarecords101\/modules\/payables\/sales-commissions-report\/","title":{"rendered":"View sales commissions as a report"},"content":{"rendered":"<h6>Lesson #72<\/h6>\n<h5>Payables \u2013 Sales Commission Report function<\/h5>\n<p><strong>The Sales Commission Report lists all invoices that include a commission, grouped and subtotaled by Sales Rep.<\/strong> A commission is automatically generated from invoices on orders initiated by a Sales Rep\u2019s client.<\/p>\n<p>The default report list all invoices posted today that include sales rep commissions. It includes commissions on both originals and copies \u2014 and doesn\u2019t deduct expenses from commission calculations.<\/p>\n<h2>Customize report views<\/h2>\n<p>You can view reports:<\/p>\n<ul>\n<li>For different days or date ranges.<\/li>\n<li>By payment post date instead of invoice post date.<\/li>\n<li>For a single sales rep.<\/li>\n<li>For originals only if you do not pay commissions on copy sales.<\/li>\n<li>For copy sales only.<\/li>\n<li>Excluding custodial fees if you pay commissions based on NIBO (Net Income Before Overhead).<\/li>\n<li>For one or more of your company\u2019s business units.<\/li>\n<\/ul>\n<p>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\u2019s footer will display which Date Type and date range you used to generate the report.<\/p>\n<p>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\u2019s total is further broken down into subtotals for ordering contacts and firms.<\/p>\n<p>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.<\/p>\n<h2>Using the report<\/h2>\n<p>Besides looking up details about sales commissions, you can use the report to help you adjust commissions in the <a href=\"https:\/\/omtiblog.com\/metarecords101\/modules\/payables\/override-default-sales-commissions\/\">Override Sales Commission<\/a> function, and in other ways:<\/p>\n<p>Voided invoices and invoices for which you have issued credit memos or debit memos are listed at the end of each person\u2019s 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.)<\/p>\n<p>Export the report to save it, give to resources, edit in another application, or print.<\/p>\n<p><strong>TL;DR: View all invoices that include a commission grouped and subtotaled by Sales Rep. Invoices that may require an adjustment to the commission \u2014 such as voids \u2014 are listed separately for each person.<\/strong><\/p>\n<h4>MR9 concepts in this lesson<\/h4>\n<p><strong>Business Unit (BU):<\/strong>\u00a0One of your company\u2019s revenue centers or any\u00a0entity in your business that you want to track separately.<\/p>\n<p><strong>Contact:<\/strong> Person who works for a firm you do business with.<\/p>\n<p><strong>Date Type:<\/strong> Depending on the function you are using, you can choose to see results for different date categories \u2014 such as the date an invoice or client payment was posted.<\/p>\n<p><strong>Firm:<\/strong> Business you provide services to \u2014 usually law firms.<\/p>\n<p><strong>Scheduling Contact:<\/strong> Contact who initiates orders with your company.<\/p>\n<p><strong>Scheduling Firm:<\/strong> Firm that initiates orders with your company.<\/p>\n<p><strong>Sold To Firm:<\/strong> Usually the Ordering Firm on a job.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>View all invoices that include a commission, grouped and subtotaled by sales rep (account executive) <a href=\"https:\/\/omtiblog.com\/metarecords101\/modules\/payables\/sales-commissions-report\/\">&hellip;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39,226,23],"tags":[3,24,199],"class_list":["post-160","post","type-post","status-publish","format-standard","hentry","category-function","category-lesson","category-payables","tag-mr9","tag-payables","tag-sales-commission-report"],"_links":{"self":[{"href":"https:\/\/omtiblog.com\/metarecords101\/wp-json\/wp\/v2\/posts\/160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/omtiblog.com\/metarecords101\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/omtiblog.com\/metarecords101\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/omtiblog.com\/metarecords101\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/omtiblog.com\/metarecords101\/wp-json\/wp\/v2\/comments?post=160"}],"version-history":[{"count":0,"href":"https:\/\/omtiblog.com\/metarecords101\/wp-json\/wp\/v2\/posts\/160\/revisions"}],"wp:attachment":[{"href":"https:\/\/omtiblog.com\/metarecords101\/wp-json\/wp\/v2\/media?parent=160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/omtiblog.com\/metarecords101\/wp-json\/wp\/v2\/categories?post=160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/omtiblog.com\/metarecords101\/wp-json\/wp\/v2\/tags?post=160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}