Enhanced Back Office Commissions Report

The Back Office Commissions report provides detailed commission amounts and percentages per individual job based on an entered time frame. It also displays total bill, pay, burdens, and costs of service, giving you a complete financial picture of commission activity tied to placements and timesheets.

This article covers the Enhanced version of the Back Office Commissions report, available in Avionté BOLD Analyze. For a full list of available Enhanced Reports, see the List of BOLD Analyze Reports.

Note: This report pulls invoicing-related data entered in Bold.

Accessing the Report

  1. Click on the Analyze tab.
    The Reports sub tab will automatically be selected.
  2. In the Search Reports field, type BACK OFFICE.
  3. Click on the Back Office Commissions report.
Note: The report automatically loads with all filters set to include all data. Data refreshes every 5 minutes to reflect current activity.

Understanding This Report

What This Report Shows You

The Back Office Commissions report displays each commission record as a separate row, tied to a specific job and timesheet week ending date. It captures the talent, company, job office, commission user, commission type, and a full breakdown of bill amounts, pay amounts, burden, cost of service, gross profit, and commission allocation. This gives you a complete financial view of how commission is distributed across your placements.

Why Use This Report

This report helps you manage commission accountability and answer critical operational questions:

  • What is the total commission earned by a specific user or team during a given period?
  • What are the bill, pay, burden, and gross profit amounts for a particular job or company?
  • Which commission type is associated with each placement?
  • How is commission being allocated across users on shared placements?
  • What are the expenses billed and paid for a given timesheet period?
  • Which jobs or companies are generating the most commission activity?

Who Benefits From This Report

Different roles use this report to address specific operational needs:

Recruiters: Review their own commission history by week ending date and confirm that all eligible placements have been captured with the correct allocation percentage.

Branch Managers: Monitor commission totals across their office, identify top-producing users, and reconcile gross profit against payouts for their location.

Finance and Payroll Teams: Pull commission data for specific timesheet periods to support payroll processing, invoicing reconciliation, and financial reporting.

Operations Leaders: Analyze commission and gross profit trends across divisions, regions, and offices to assess business performance and identify growth opportunities.

Customizing and Sharing This Report

Columns: Show or hide columns using the column selector. Drag columns to reorder them. Click any column header to sort.

Filters: Use the filter panel on the right to narrow results. All filters default to “Include all.”

Sharing (INSIGHTS users): Save a customized view and share it as a dashboard tile with your team.

Sharing (Standard users): Export the report as a CSV, PDF, or image. See the Enhanced Standard Reporting Overview article for full details.

Using Filters

Filters appear on the right side of your screen and help you focus on specific segments of your data. All filters default to “Include all” when you first open the report.

Available Filters

Filter Name What It Does When to Use It
Division Limits results to jobs associated with a specific employer. Use when reviewing commission activity for a particular employer entity.
Region Limits results to jobs within a specific region. Use when analyzing commission performance across a geographic area.
Office Limits results to jobs assigned to a specific branch. Use when reviewing commission activity for a single office location.
Company Limits results to jobs at a specific client company. Use when reconciling commission activity for a particular account.
HCM User Filters results to commissions allocated to a specific user. Use when reviewing an individual recruiter’s commission activity.
Commission Type Limits results to a specific commission type. Use when comparing activity across different commission categories.
Date Range Applies a preset date range (e.g., Yesterday, This Week, Last Month) based on the timesheet week ending date. Use for quick, recurring views without manually entering date values.
 
Note: When using Date Range, the Date From and Date To fields automatically disable. Select either Date Range or manually enter Date From and Date To — not both.

Applying Your Filter Selections

  1. Click on the edit icon next to any filter name to expand it.
  2. Make your selections by checking boxes or choosing from dropdowns.
  3. Click Apply to update the report with your filtered view.
  4. Click Cancel to discard changes and return to the previous filter state.

Reading the Data

The Back Office Commissions report displays each commission record as a separate row with full details about the placement, job, timesheet, and financial breakdown. The field list gives you everything you need to analyze bill amounts, pay amounts, gross profit, and commission allocation across any time period, office, or company.

Key Field Categories

Field Name Description
Applicant ID The Talent ID associated with the placement.
Commission Type The commission type assigned to the placement extension.
Custom Bill Name The custom bill name from the timesheet.
Job Office The branch associated with the job.
Week Ending The week ending date of the timesheet.
User The commission user assigned to the placement extension.
User Office The branch associated with the commission user.
Requisition ID The system-generated Job ID (visible in the URL).
Requisition The Job ID as entered in Avionté BOLD.
Company The company name associated with the job.
Consultant The talent name from the placement.
Job Title The title of the job.
Req Type The system job type.
Employment Type The employment type from the placement extension.
Expenses Bill The total expenses billed.
Expenses Paid The total expenses paid.
Total Bill The total amount billed.
Total Pay The total amount paid.
Burden (%) The burden percentage applied to the record.
Cost of Service The cost of service amount.
Total Gross Profit The total gross profit amount.
Allocation (%) The commission percentage from the commission allocation.
Total Commission The total commission amount.
Start Date The placement’s start date.
1.0 Total Commission The total commission amount at full (1.0) allocation.
Company ID The company ID. This field is hidden by default but can be enabled using the column selector.

Practical Applications

The Back Office Commissions report gives finance and operations teams a complete record of commission activity tied to placements and timesheets, making it essential for payroll reconciliation and profitability analysis. Branch managers can run this report at the end of a pay period to confirm that all commission records have been captured and that totals align with expected payouts. Finance teams can pull a date-scoped export filtered by office or division to support month-end close or annual compensation reviews. Recruiters can filter by their own user name to review their commission history by week ending date and verify that every eligible placement is accounted for with the correct allocation percentage. Operations leaders can compare gross profit and cost of service trends across divisions and regions to identify where margin improvement opportunities exist.

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.
Note: Your export will include only the data visible based on your current filter selections. To export all commission records, ensure all filters are set to “Include all” before downloading.

Additional Export Options

The three-dot menu also provides options to repeat rows (useful for printing), merge rows, and other display customizations. These settings affect how your report appears on screen and in exports.

Refreshing the Report

Avionté automatically refreshes report data every 5 minutes. If you want to see the most current information immediately after changing filters or after new commission activity has been recorded, you can manually refresh.

  1. Locate the circular arrow icon above the filter panel on the right side.
  2. Hover over the icon to see it expand and display the word UPDATE.
  3. 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 commission records or updates 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.