Enhanced Commission Gross Profit Report

The Commission Gross Profit report shows commission and gross profit details for your commissioned users, grouped by employer, office, and company, and broken out by accounting period, so you can see exactly how commission percentages and profit dollars are calculated and allocated across your team. This report is based on the AviontéCLASSIC Commission Split (AQ) report.

Note: This report is part of the INSIGHTS product. Contact your Account Manager to learn more about accessing INSIGHTS and Analyze Reports.

Accessing the Report

  1. Click on the Analyze tab. The Reports sub tab will automatically be selected.
  2. In the Search Reports field, type COMMISSION.
  3. Click on the Commission Gross Profit Report, located under the Gross Profit category.
Note: The report automatically loads with the Employer, Region, Office, Company, and Commission User filters set to "Include all," and the Accounting Period Date filter set to Last Month.

Understanding This Report

What This Report Shows You

The Commission Gross Profit report displays commission and profitability data grouped by employer, office, company, and commission user, based on the Commission Allocation setup in AviontéBOLD. Each company is broken out by accounting period (shown weekly), with the commission percentage, gross profit, and resulting Commission Gross Profit calculated for that period. A Grand Total row at the bottom of the report sums Gross Profit and Commission Gross Profit across every record currently in view.

Why Use This Report

This report helps you manage commission payouts and answer critical questions:

  • What is a specific commission user's Commission Gross Profit for a given accounting period?
  • How does gross profit vary by employer, office, or company?
  • Which companies are generating the most commission-eligible gross profit?
  • What is the total commission gross profit owed across all commissioned users for a period?
  • Which office or branch is generating the most commission gross profit?

Who Benefits From This Report

Different roles use this report to address specific operational needs:

Sales and Commission Managers: Use this report to generate and distribute weekly commission information to their sales team without manually exporting and manipulating data from Back Office.

Finance Managers: Rely on this report to validate that commission and gross profit calculations tie out to source data.

Executive Leadership: Use the report to monitor commission payouts relative to profitability across branches and regions.

Branch and Regional Managers: Track commission performance for their team and answer commission questions without requesting a Back Office export.

Using Filters

Filters appear on the right side of your screen and help you focus on specific segments of your data.

Available Filters

Filter Name What It Does When to Use It
Employer Filters the report to specific employers. Cascades into the Region and Office filters below it. Use to narrow results to one or more employers before drilling into region or office.
Region Filters the report to specific regions within the selected employer(s). Use when comparing commission and gross profit for a particular region.
Office Filters the report to specific offices within the selected region(s). Use to focus the report on one or more individual offices.
Company Filters the report to specific customer companies. Use to isolate commission and gross profit results for a specific client company.
Commission User Filters the report to specific users, based on the Commission Allocation > User setup in AviontéBOLD. Use to review commission and gross profit for an individual recruiter, salesperson, or other commissioned user.
Accounting Period Date Filters the report to a specific accounting period. Defaults to Last Month. Use to change the time period the report covers, such as a prior month or the current month to date.
Note: Employer, Region, and Office are cascading filters — narrowing Employer limits which Regions are available, and narrowing Region limits which Offices are available.

Applying Your Filter Selections

  1. Click Include all on a filter to include every value for that filter, or click the > chevron on the Company or Commission User filter to expand it and choose specific values.
  2. Use the toggle on the right side of a filter to turn that filter on or off.
  3. Click the trash icon on a filter to clear its current selections.

Reading the Data

The Commission Gross Profit report groups results hierarchically by employer, office, and company, with each company broken out by accounting period (shown weekly) and commission user. A Grand Total row at the bottom of the report sums Gross Profit and Commission Gross Profit across every record currently in view.

Key Field Categories

Field Name Description
Employer The employer associated with the commission record.
Office The office, or branch, associated with the commission record.
Company The customer company associated with the commission record.
Commission User The user the commission record is attributed to, based on the Commission Allocation > User setup in AviontéBOLD.
Accounting Period Date The weekly accounting period the commission record falls in.
Commission % The commission percentage applied to Gross Profit for that record.
Gross Profit The gross profit amount for that record.
Commission Gross Profit The dollar amount of commission owed, calculated as Commission % multiplied by Gross Profit.
Grand Total The summary row at the bottom of the report, totaling Gross Profit and Commission Gross Profit across all records currently in view.

Practical Applications

The Commission Gross Profit report lets sales and commission managers generate and distribute weekly commission information to their sales teams directly from Insights, instead of manually exporting and manipulating Commission Split AQ data from Back Office. Because every row breaks results down by employer, office, company, and commission user, managers can quickly answer questions about an individual recruiter's commission for the period, compare commission gross profit across offices, and use the Grand Total row to confirm overall commission payouts line up with gross profit before checks go out.

Exporting Your Data

Export your report data to share with stakeholders, perform additional analysis, or maintain records outside of Avionté.

  1. Apply any filters you want to include in your export.
  2. Click the three-dot menu icon (⋮) in the top right corner of the report area.
  3. Select your preferred format from the Download submenu:
    • Image: Creates a visual snapshot of the report as currently displayed
    • CSV File: Exports raw data compatible with Excel, Google Sheets, and database tools
    • PDF File: Generates a formatted document suitable for printing or formal distribution
Export menu showing Image, CSV File, and PDF File download options
Note: Your export will include only the data visible based on your current filter selections. To export all commission users, ensure all filters are set to "Include all" before downloading.

Refreshing the Report

Avionté automatically refreshes report data every 5 minutes. However, if you want to see the most current information immediately after changing filters, you can manually refresh.

Circular refresh icon above the filter panel
  1. Locate the circular arrow icon above the filter panel on the right side.
Refresh icon expanded showing UPDATE label
  1. Hover over the icon to see it expand and display the word "UPDATE."
  2. Click the icon to re-run the report based on your current filter selections.

The report will reload with the latest data from your database, reflecting any new transactions or updated information since you last viewed it.

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share

Comments

0 comments

Please sign in to leave a comment.