How to Use the Sales Rep Report in Elite Core
The Sales Rep Report gives users a flexible way to review sales performance across representatives, teams, customers, industries, and time periods. It is designed to answer more than one sales question, so the report includes several report types rather than forcing every user into a single table.
Depending on the view selected, the report can help users understand booked sales, invoiced sales, sales against budget, forecast performance, weekly activity, new versus repeat business, customer sales, industry performance, customer margin by representative, customer sales history, and average order size by customer.
Where to Find the Sales Rep Report
Open the Reports area in Elite Core and select the Sales Rep Report. The exact menu visibility depends on the user’s role and permissions.
When the report opens, Elite Core loads the available sales data for the organization and presents filters, summary values, report-type controls, sorting, saved-report tools, column visibility, and export options.
What the Sales Rep Report Measures
The Sales Rep Report can look at sales from two main financial perspectives: Booked and Invoiced.
The Booked view uses approved Sales Order cart totals. This view is useful when users want to understand business that has been sold and committed, even if the customer has not yet completed the Invoice payment process.
The Invoiced view uses paid or received Invoice amounts. This view is useful when users want to review sales based on revenue that has progressed further through the financial lifecycle.
Because Booked and Invoiced answer different questions, users should always confirm which sales view is selected before comparing numbers between reports or periods.
Understanding the Summary Values
The report includes summary values such as Total Sales, Total Orders, Average Order Size, Total Margin, and Margin Percentage where those values are relevant to the selected report type.
Total Sales represents the sales value included in the current filtered report. Total Orders shows the number of qualifying orders. Average Order Size helps users understand the typical value of the included orders. Total Margin shows the profit or margin amount represented by the report, and Margin Percentage expresses that margin relative to the applicable sales value.
These values change with the selected report type, period, sales view, rep, team, assignment type, customer or industry filters.
Choosing a Report Type
The Sales Rep Report contains several report types. Each one is intended for a different kind of sales analysis.
Sales Summary
Sales Summary is the general-purpose view for reviewing sales performance over the selected period. Use it when you want a broad picture of sales, orders, average order value and margin without focusing on a specialized analysis.
Sales to Budget
Sales to Budget is used to compare actual sales performance against an available budget or target. This view helps managers see whether a rep or team is ahead, behind or otherwise tracking against the expected sales level.
If a budget has not been configured for the relevant period or user, the report may identify that the budget is missing rather than presenting a meaningful comparison.
Forecast
The Forecast view helps users examine expected sales performance. It is useful when management needs to look beyond completed historical sales and understand the expected direction of the selected period.
Forecast information should be reviewed as a planning view rather than treated as completed financial revenue.
Weekly Performance
Weekly Performance narrows the analysis to a selected week. When this report type is selected, Elite Core provides a week filter so users can evaluate short-term sales activity and performance.
This view can be especially useful for sales meetings, weekly coaching and identifying sudden changes in performance that may be less visible in a monthly or annual report.
New vs Repeat
New vs Repeat helps users understand whether sales are coming from new business or returning customers. This can help a manager distinguish customer acquisition from repeat-account development.
A healthy interpretation depends on the organization’s goals. A rep focused on account growth may naturally have more repeat business, while a business-development role may be expected to generate a larger share of new customers.
By Customer
The By Customer report groups or presents sales information around customer accounts. Use it to understand which clients are producing the most sales and to review customer-level performance within the selected date range and sales view.
By Industry
The By Industry report allows users to examine sales by customer industry. This can help management understand which market segments are producing revenue and where the organization may be gaining or losing concentration.
The industry filter is particularly relevant to this view. Records without a classified industry can also be represented separately so users can identify incomplete customer data.
Customer Margin by Rep
Customer Margin by Rep combines customer performance with the representative responsible for the business. This is useful when sales volume alone does not provide enough information and the user needs to understand the profitability associated with a rep’s customer portfolio.
Customer Sales History
Customer Sales History focuses on how a customer’s sales have developed across time. It is useful for reviewing account growth, decline, seasonality and changes in purchasing behaviour.
Average Order by Customer
Average Order by Customer helps users compare the typical order size of different customer accounts. A customer may have high total annual sales because of many small orders, while another may place fewer but much larger orders. This report makes that difference easier to see.
Filtering by Date and Period
The report supports date-based filtering so users can compare the period that matters to the review. Available period behaviour includes fiscal-year, calendar-year and custom-period approaches, depending on the selected report configuration.
Users can also group applicable report data by month, quarter or year. Grouping changes the level at which the report is summarized and can make trends easier to identify.
Before comparing two reports, make sure both reports use the same period definition. A fiscal-year report and a calendar-year report can produce different totals even when they appear to cover a similar timeframe.
Filtering by Sales Representative
The report can be narrowed to a specific representative. This is useful for individual performance reviews, coaching, commission context and comparing one rep’s results with a team or organizational total.
The available representatives depend on the selected assignment filter and the user’s own permissions. Client Rep and Order Rep users can be self-scoped so they see the appropriate sales information connected to their role rather than freely switching to unrelated representatives.
Client Rep vs Order Rep Assignment
The Assignment filter determines how Elite Core decides whether a row belongs to a representative.
Any Assignment includes qualifying rows without restricting the report to only one assignment role, unless another Rep or Team filter narrows the result. Client Rep Assignment limits the report to the representative assigned in the client-rep role. Order Rep Assignment limits the report to the representative assigned at the order level.
This distinction is important when a client relationship is owned by one person but an individual Sales Order is managed by another. Users should select the assignment method that matches the question they are trying to answer.
Filtering by Team
The Sales Rep Report can also filter by team. This allows managers to review a group of representatives together instead of selecting users one at a time.
Team filtering is useful for regional teams, sales groups, departments or other configured team structures. When comparing teams, confirm that their membership is current because report results depend on the users included in the selected team.
Filtering by Industry
Industry filtering is available where industry analysis is relevant to the selected report type. It can help users focus on a particular vertical or isolate customers that have not yet been assigned an industry classification.
If industry results look incomplete, review the customer records themselves. A report cannot reliably group customers by industry if that customer data has not been maintained.
Using Quick Find
The Quick Find field helps users narrow the visible data when they need to locate a specific customer, order, representative or other searchable report value.
Quick Find is useful for investigation, but it should not replace the formal filters when producing a report that will be exported, shared or compared over time. Formal filters make the report criteria easier to reproduce.
Understanding Booked Sales
Booked sales represent approved Sales Order values. They are useful for measuring what the organization has sold and committed.
Booked sales can be ahead of actual customer payments because a Sales Order can be approved before the Invoice is paid. For this reason, Booked sales should not automatically be interpreted as cash collected or finalized accounting revenue.
Understanding Invoiced Sales
Invoiced sales use paid or received Invoice amounts in the current report logic. This means the Invoiced view is more closely connected to completed customer payment activity than the Booked view.
If a row appears different between Booked and Invoiced views, review the Sales Order, Invoice status and payment information. The difference may simply reflect that the order has been sold but has not yet moved fully through the Invoice and payment workflow.
Understanding Invoice Payment Indicators
Where Invoice payment status is shown, the report can visually distinguish paid, partially paid and unpaid conditions. These indicators help users understand whether a sales result has moved from a booked commitment into actual customer payment.
A partially paid Invoice should not be treated the same as a fully paid Invoice. Review the remaining balance and the selected report view before drawing conclusions from the sales value.
Understanding Margin
Margin helps users understand the profitability behind the sales volume. A representative can have strong sales while producing weaker margin if pricing is heavily discounted or costs are high.
When reviewing rep performance, use both sales and margin where possible. Total revenue explains how much was sold, while margin helps explain the financial quality of those sales.
Sorting and Reviewing Columns
Report columns can be sorted so users can quickly identify highest or lowest sales, margins, order counts or other available values. The report also supports column visibility controls, which allow a user to simplify the table for a particular review.
Hiding a column changes only the display. It does not remove the data from Elite Core or change how the report itself is calculated.
Saved Reports
The Sales Rep Report supports saved-report settings. This allows users to preserve a useful filter and display configuration for repeated analysis.
For example, a sales manager could save a quarterly team view, while Finance could save a separate Invoiced-sales view. Saved reports help make recurring reviews more consistent because users do not have to rebuild the same filter combination each time.
Exporting the Sales Rep Report
The report supports CSV export. Exporting is useful when the data needs to be reviewed in a spreadsheet, shared with management or used for further analysis.
The exported file should be treated as a snapshot of the selected report criteria at that time. If Sales Orders, Invoice payments, customer assignments, teams or other underlying records change afterward, a newer live report may no longer match the older export.
How to Review an Individual Sales Rep
Start by selecting the intended date period and choosing whether the review should use Booked or Invoiced sales. Then select the appropriate assignment type, because Client Rep and Order Rep can represent different responsibilities.
Select the representative and, if needed, narrow the report by team, customer or industry. Review Total Sales, Total Orders, Average Order Size, Margin and Margin Percentage. Then switch report types when you need additional context such as budget performance, weekly trends, new versus repeat business or customer history.
A useful performance review should not rely on one number. High sales, low average order size, weak margin or a high concentration in one customer can each tell a different part of the story.
How to Troubleshoot Unexpected Sales Results
If a report total looks incorrect, first confirm the date period, report type and Booked versus Invoiced view. A large portion of apparent report differences can be explained by those settings.
Next, review the Assignment filter and representative. Confirm whether the business should belong to the Client Rep, Order Rep or another qualifying assignment. If a Team filter is active, confirm that the representative is currently included in that team.
For customer or industry reports, verify the customer’s underlying account data. For Invoiced results, review the Invoice and payment status. For Booked results, review the approved Sales Order. If margin appears incorrect, review the sales and cost information behind the order rather than changing the report.
Suggested Visual: Sales Rep Report Anatomy
A useful illustration would show the Sales Rep Report with callouts for Report Type, Period, Booked/Invoiced view, Assignment filter, Team, Rep, Industry, summary cards, table columns, saved reports, column visibility and Export. This would help a first-time user understand which controls change the report calculation and which controls only change the display.
Suggested Visual: Booked vs Invoiced Sales
A second visual could show one Sales Order moving through the lifecycle: Approved Sales Order → Booked Sales → Client Invoice → Customer Payment → Invoiced Sales view. The graphic should emphasize that the two report views answer different questions rather than representing competing versions of the same number.
Suggested Visual: Choosing the Right Sales Report Type
A third visual could use a simple decision tree. A user asking “How much did we sell?” would choose Sales Summary. “Are we on target?” would lead to Sales to Budget. “What is likely to happen?” would lead to Forecast. “How did this week perform?” would lead to Weekly Performance. Customer, industry, margin and order-size questions would branch to their corresponding report types.
Key Takeaway
The Sales Rep Report is a multi-purpose sales analysis tool in Elite Core. It can be used to review individual reps, teams, customers, industries, budgets, forecasts and sales trends while allowing the user to choose between Booked Sales Order values and Invoiced payment-based values.
Before comparing or sharing results, always confirm the report type, date period, Booked versus Invoiced view and assignment filters. Those settings determine what the report is actually measuring.
