Enhanced Consultant Spend Report

Updated March 18, 2026 20:53

Enhanced Standard Reporting Availability

Enhanced Standard Reporting is now available as an optional feature for your system.

Want to opt in NOW? Submit a support ticket or contact your CSM to enable this feature and access faster processing, extended historical data, and improved reliability.

Customizing and Sharing This Report

Columns: Use the column selector to show, hide, or reorder columns to match your workflow.

Filters: Your filter selections are remembered between sessions — the report opens with your last-used settings automatically.

Sharing (INSIGHTS users): You can duplicate, rename, and share customized versions of this report with team members, and schedule automated delivery by email. System-level reports remain unchanged and available to all users.

Sharing (Standard users): You can duplicate this report and customize filters for personal use. To share a customized version with your team, duplicate the report, apply your preferred filters, and share it directly with individual users. System-level reports cannot be modified or set as a default for all users. See Enhanced Standard Reporting Overview for more detail.

The Consultant Spend Report provides comprehensive financial visibility into your temporary staffing operations, tracking bill rates, pay rates, expenses, burden, and gross profit for every timesheet processed through Front Office invoicing. This report helps you understand the true cost of service for each placement and identify opportunities to improve profitability across jobs, consultants, and clients.

Enhanced Reports

Accessing the Report

Click the Analyze tab in the main navigation
The Reports section will automatically open in the left sidebar
In the search field or by scrolling, locate and click Consultant Spend
The report loads immediately with data based on your filtering options.

Note: Reports load with Today & Yesterday as the initial default. Once you adjust filters, the report remembers your selections for future sessions. If you see unexpected results, check your active filters in the right panel. The data you see depends on your security permissions—users with restricted access may see fewer consultant activities than colleagues with broader visibility.

Understanding This Report

What This Report Shows You

The Consultant Spend Report gives you a detailed financial breakdown of every timesheet day for consultants working through Front Office invoicing. Each row represents financial activity for a specific consultant on a specific job for a specific week, showing regular hours, overtime, doubletime, bill rates, pay rates, expenses, burden percentages, cost of service, and gross profit.

This granular visibility lets you analyze profitability at multiple levels—by individual consultant, by job, by client company, by office, or across your entire organization. You can see exactly where your margins are strongest and where cost of service may be eroding profitability.

Why Use This Report

This report helps you answer talent-specific and position-based questions about cost of service:

Which placements are most profitable? Compare gross profit across consultants and jobs to identify your highest-margin assignments and replicate those characteristics in future placements.
Where is cost of service highest? Identify jobs or consultants with high burden percentages, excessive expenses, or unfavorable bill-to-pay rate spreads that compress margins.
Are overtime costs impacting profitability? Track overtime and doubletime hours to see if premium pay rates are reducing gross profit on specific assignments or with particular clients.
How do expenses affect our bottom line? Separate expenses billed to clients from expenses paid to consultants to understand whether expense reimbursements are margin-neutral or creating profit leakage.
Which clients or job types deliver the best margins? Analyze profitability by company and job title to focus business development efforts on the most lucrative client relationships and position types.

Who Benefits from This Report

Recruiting Managers: Monitor profitability across your team's placements to ensure consultants are placed at rates that support business objectives. Identify recruiters who consistently negotiate favorable bill-to-pay spreads and coach others to improve margin performance.

Account Managers: Understand true profitability for each client account, including all cost components like burden and expenses. Use this data in contract negotiations to justify rate increases or identify clients where improved margins are critical.

Job Owners: Review financial performance for specific requisitions to ensure placements meet profitability targets. Spot issues like excessive overtime or high burden that may require adjustments to work arrangements or rate structures.

Business Development: Identify the most profitable client types, position categories, and job structures to target similar opportunities. Understand which market segments deliver the strongest margins to inform strategic growth decisions.

Using Filters

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

Available Filters

Working with the Week Ending Date Filter

The Week Ending filter offers flexible options for defining your time range. Date filter options include:

Include all (no filter applied): Shows all timesheet data regardless of date
Year: Select a specific year and filter by quarters, months, or weeks (ideal for year-over-year comparisons)
Last [X] Days: Dynamically shows the most recent days (includes a checkbox for "Including current")
From/To: Set a custom date range by selecting specific start and end dates—you can select dates spanning multiple years

Note: The "Showing" indicator at the bottom of the filter panel displays your current date range before you apply changes.

Applying Your Filter Selections

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

Reading the Data

Summary Section (Week Ending View)

The top section of the report groups financial data by week, giving you a high-level view of consultant spending patterns and profitability trends. Each row shows a week ending date with aggregated financial totals for all consultants who worked during that period.

Column	What It Tells You
WeekEnding	The Saturday date that closes the week. Activities are grouped by the week in which they occurred.
CNT (Activity Count Columns)	Each column represents a different recruiting activity associated with job-candidate interactions. The numbers show how many times that activity occurred during the week. Activities are tied to specific positions, helping you understand which jobs are generating candidate engagement versus sitting dormant.

How to Interpret What You're Seeing

Low or negative gross profit on specific placements: If a consultant shows minimal or negative gross profit, investigate whether bill-to-pay spreads are too narrow, burden percentages are unexpectedly high, or expenses are eroding margins. These placements may require rate renegotiations with the client or adjustments to work arrangements.

High overtime or doubletime volume: Consultants with significant overtime or doubletime hours may still be profitable if bill rates adequately cover premium pay, but excessive premium work often compresses margins. If overtime is routine rather than exceptional, consider whether standard rates should be adjusted or if the client needs to approve higher base rates to reduce reliance on premium hours.

Expense recovery gaps: When Expense Paid significantly exceeds Expense Billed, your organization is absorbing costs that should be client responsibilities. This directly reduces gross profit and may indicate billing practices that need correction or contract terms that don't adequately address expense reimbursement.

Varying profitability across similar job titles or clients: If two consultants in similar roles show dramatically different gross profit, investigate whether one placement has more favorable rates, lower burden, or better expense management. Use high-performing placements as models for improving less profitable assignments. If certain clients consistently show lower margins than others, this signals opportunities for rate discussions or strategic account decisions.

Regional or office profitability patterns: Offices or regions showing consistently lower gross profit may face local market rate pressures, higher burden costs due to regulatory environments, or less effective rate negotiation. Compare cost structures and pricing strategies across locations to identify best practices that can be replicated or systemic issues that require regional strategy adjustments.

Strategic Applications

Pricing Strategy & Rate Negotiation

Use historical cost of service data to build rate cards that ensure minimum acceptable margins across different job types and skill levels. When clients request rate reductions or negotiate contracts, reference actual gross profit data from similar placements to quantify the financial impact and defend pricing decisions with concrete numbers.

Identify your most profitable client relationships and job types to inform which opportunities to pursue aggressively. If certain position categories consistently deliver 25% gross profit margins while others struggle to reach 15%, adjust business development priorities and sales team incentives to focus on high-margin work.

Cost of Service Analysis & Control

Track burden percentages over time to understand how taxes, benefits, insurance, and overhead affect profitability. If burden rates increase, you may need to adjust bill rates accordingly or find ways to reduce administrative costs. Compare burden rates across employment types (W2 vs. 1099) to make informed decisions about which arrangements deliver better net margins.

Audit expense recovery regularly by filtering placements where Expense Paid exceeds Expense Billed. These gaps represent direct profit leakage. Work with account managers to ensure client contracts clearly define expense reimbursement terms and implement billing practices that recover all legitimate costs.

Account Management & Client Profitability

Generate quarterly profitability reports by client company to inform account strategy decisions. High-revenue clients who deliver low gross profit may require rate adjustments or operational changes. Conversely, smaller clients with excellent margins may warrant increased relationship investment and expansion efforts.

When preparing for contract renewals, export complete financial history for the account showing total revenue, total cost of service, and gross profit across all placements. This data provides objective evidence for rate increase requests and demonstrates the value you deliver relative to the costs you incur.

Overtime Management & Work Arrangement Optimization

Filter for placements with high overtime or doubletime hours to identify assignments where premium rates are routine rather than exceptional. Calculate whether these arrangements remain profitable or if margins are being compressed by excessive premium pay obligations. Consider whether converting high-overtime assignments to higher base rates with less overtime would improve overall profitability.

Share overtime patterns with operations teams to forecast staffing needs. If certain clients or positions consistently require overtime, you may need additional consultants to handle the workload at regular rates rather than relying on premium-rate hours that reduce margins.

Performance Evaluation & Recruiter Effectiveness

Evaluate recruiters not just on placement volume but on the profitability of their placements. Track average gross profit per placement by recruiter to identify who consistently negotiates favorable bill-to-pay spreads and who may need coaching on rate negotiations or candidate qualification.

Use consultant-level profitability data to inform placement strategy. If certain consultants consistently deliver strong margins while others don't, investigate whether this reflects their skill levels, the types of jobs they're placed in, or rate negotiation effectiveness. Adjust placement strategies to maximize profitable consultant utilization.

Exporting Your Data

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

Apply any filters you want to include in your export
Click the three-dot menu icon (⋮) in the top right corner of the report area
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
- Excel File: Creates a native Excel workbook with formatted data

Note: Your export will include only the data visible based on your current filter selections. To export everything, 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

Report data refreshes automatically in the background. However, if you want to see the most current information immediately after changing filters or if you know recent activities have occurred, you can manually refresh.

Locate the circular arrow icon above the filter panel on the right side
Hover over the icon to see it expand and display the word "UPDATE"
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 activities or changes that occurred since you last viewed it.

Filter Name	Options	Explanation
Division	All available Employers	Filters Job's Employer
Region	All available Regions	Filters Job's Region
Office	All available Branches	Filters Job's Branch
Company	All available Companys	Filters Job's Company
Week Ending Date	Yesterday, Today, Tomorrow, ...	When 'Week Ending Date' is selected, it will automatically filter the results by week ending date, and can be used to filter for specific weeks.