# Employee Activity Summary

<p class="doc-lead">A scorecard of what each employee did in a period — calls, meetings, tasks, and the path from new leads to invoices and collections — compared with the previous period.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/crm/reports/employee-activity-summary?id=overview">Overview</a>
<a href="#/crm/reports/employee-activity-summary?id=use-cases">Use Cases</a>
<a href="#/crm/reports/employee-activity-summary?id=filters">Filters</a>
<a href="#/crm/reports/employee-activity-summary?id=columns">Columns</a>
<a href="#/crm/reports/employee-activity-summary?id=one-employee">One employee</a>
<a href="#/crm/reports/employee-activity-summary?id=actions">Actions</a>
<a href="#/crm/reports/employee-activity-summary?id=faq">FAQ</a>
</div>
</div>

<hr class="doc-section-divider">

<h2 id="overview">Overview</h2>

Go to <b>CRM → Reports → Employee Activity Summary</b>.

Permission: <b>Employee Activity Summary</b> (<b>crm.r.eas</b>).

<p><b>What it shows.</b> One row per employee for the selected dates, with the same length of time immediately before it shown as a change under each figure. A funnel across the top runs from new leads to money collected. The step with the weakest conversion is marked <b>biggest drop</b>.</p>

<p><b>When to use it.</b> Use in a sales meeting to see who is active, where the pipeline is leaking, and who still has overdue tasks.</p>

<p><b>Who is included.</b> Employees in the signed-in user’s employee data filter. Advanced Filter can narrow that to one branch or one employee. Activity with no employee is omitted.</p>

For the signed-in employee only, use <a href="#/crm/reports/my-summary">My Summary</a>.

<hr class="doc-section-divider">

<h2 id="use-cases">Use Cases</h2>

<ul>
<li><b>Monday pipeline review</b> — This month versus last month: who raised quotes, who invoiced, and where the funnel drops.</li>
<li><b>Coaching</b> — Open one employee and read the leads they worked, the call outcomes, and the tasks still overdue.</li>
<li><b>Branch manager</b> — Filter to one branch and compare the team on the same dates.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="filters">Filters</h2>

| **Filter** | **Location** | **Notes** |
|------------|--------------|-----------|
| Date range | Header | Default is this month. The range cannot be longer than 6 months. The previous period is the same number of days immediately before the start date. |
| Branch | Advanced Filter | Shown when the company has more than one branch and the user can list branches. |
| Employee | Advanced Filter | Employees shown in the Sale module. |

Toolbar: <b>Generate</b>, <b>Advanced Filter</b>, clear (when a filter is active), <b>Export</b>, <b>Print</b>.

<hr class="doc-section-divider">

<h2 id="columns">Columns</h2>

Column groups are <b>Activity</b>, <b>Pipeline</b>, <b>Results</b>, and <b>Now</b>. A percentage or arrow under a cell is the change against the previous period. For <b>Lost</b> and <b>Overdue tasks</b>, an increase is shown as worse.

Click a number to open the matching records. Click the employee name to open that person’s detail.

| **Column** | **Shows** |
|------------|-----------|
| Calls | Lead log entries of type call in the period, counted for the lead owner. |
| Meetings | Lead log entries of type meeting. |
| Notes | Lead log entries of type notes. |
| Tasks done | Reminders completed in the period. |
| Status changes | Lead status changes in the period. |
| New leads | Active leads created in the period, by lead owner. |
| Won | Those leads whose status is the Won status from <a href="#/crm/crm-settings">CRM Settings</a>. |
| Lost | Those leads whose status is the Lost status. |
| Lead → Opp | Share of the new leads that have an opportunity (cancelled opportunities ignored). |
| Opportunities | Opportunities dated in the period, except cancelled, by the opportunity’s employee. |
| Opp → Quote | Share of those opportunities that have a quotation (cancelled and revised quotations ignored). |
| Quotations | Sale quotations dated in the period, except cancelled and revised. |
| Orders | Sale orders dated in the period, except drafts and cancelled. |
| Proformas | Pro forma invoices dated in the period, except drafts and cancelled. |
| Invoices | Approved and closed sale invoices dated in the period. Opening invoices are excluded. |
| Invoiced | Total of those invoices. |
| Collected | Receipt vouchers from customers, plus cash, bank, wallet, and cheque sales, plus cheques cleared in the period, minus cash credit notes. |
| New customers | Leads converted to a customer in the period. |
| Open leads | Active leads for the owner that are not Won or Lost. This is the position now, not only leads created in the period. |
| Overdue tasks | Pending or snoozed reminders that are past due now. Compared with how many were already overdue at the start of the period. |

A total row is shown when there is more than one employee.

<hr class="doc-section-divider">

<h2 id="one-employee">One employee</h2>

Click a name, or use <b>All employees</b> to return to the team. The detail view shows:

<ul>
<li>Cards for calls, meetings, tasks done, new leads, opportunities, quotations, invoiced, collected, and overdue tasks.</li>
<li>The same funnel, for that employee.</li>
<li>Call outcomes and meeting outcomes. Click an outcome to list those logs.</li>
<li><b>Leads worked</b> — leads created, logged, or with a task completed in the period, with each event. The list stops at the latest 200 leads.</li>
<li><b>Tasks</b> — done in the period, and overdue now.</li>
<li>Opportunities, quotations, orders, pro formas, and invoices created in the period, and the collections that make up <b>Collected</b>.</li>
</ul>

Document lists opened from a count are capped at 500 rows.

<hr class="doc-section-divider">

<h2 id="actions">Actions</h2>

<ul>
<li><b>Generate</b> — run the report.</li>
<li><b>Export</b> — export the scorecard on screen to Excel.</li>
<li><b>Print</b> — print the scorecard. On the detail view, the print title includes the employee name.</li>
<li>Click a count, a funnel step, or an outcome chip to open the underlying records.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="faq">FAQ</h2>

<p><b>Why do Won and Lost look empty?</b><br>Set <b>Won Status</b> and <b>Lost Status</b> in <a href="#/crm/crm-settings">CRM Settings</a>. Won and Lost count new leads in the period that are now in those statuses.</p>

<p><b>Why is the date range rejected?</b><br>The start must be on or before the end, and the range must be within 6 months.</p>

<p><b>Does Collected equal receipt vouchers only?</b><br>No. It also includes cash, bank, wallet, and cheque sales in the period, and cheques cleared in the period, and it subtracts cash credit notes.</p>

<p><b>Are open leads limited to the date range?</b><br>No. Open leads and overdue tasks are the position now. The other columns count what happened inside the dates.</p>

<p><b>How is this different from Lead Owner Report?</b><br><a href="#/crm/reports/lead-owner-report">Lead Owner Report</a> is leads created in the range, with conversion and reminder totals. Employee Activity Summary adds calls, meetings, quotations, orders, invoices, and collections, and compares them with the previous period.</p>

<hr class="doc-section-divider">

<h2 id="related">Related</h2>

<ul>
<li><a href="#/crm/reports/my-summary">My Summary</a></li>
<li><a href="#/crm/reports/lead-owner-report">Lead Owner Report</a></li>
<li><a href="#/crm/reports/my-tasks-report">My Tasks Report</a></li>
<li><a href="#/crm/crm-settings">CRM Settings</a></li>
</ul>
