EPR - Filtering and Summarisation

Overview

The following columns will always be presented when you run the EPR. These are the standard profit columns.

Incoming	All income relating to the item. Includes Charges to a Customer and negative amounts paid to an employee
Outgoing	Sum of all costs, all Oncosts relating to the margin. Costs include all payments and Oncosts to an employee and all credit to a customer
Profit	Dollar value profit for the line (Incoming minus Outgoing)
Profit %	Percentage profit for the line

The report includes a range of options for summarising the data, allowing the report to be built in the format that you require. There are a number of summarisation options.

Key summarisation options add extra columns to the EPR when they are selected. Standard summarisation options will only add a column for that item (ie the report will comprise the standard profit columns plus a column for the summarisation option selected.

If multiple standard summarisation options are ticked, the EPR will include standard profit columns as well as a column for each option.

Key Summarisation Options	Summarise by Employee	Summarises by the employee being paid or whose work is being invoiced Columns in the report are: Employee (links to employee profiles) Customer (count) Jobs (count) Incoming Outgoing Profit Profit %
	Summarise by Job	Summarises by the employee’s job Columns in the report are: Employee (links to employee profiles) Job (links to jobs) Customer (links to customer profile) Incoming Outgoing Profit Profit %
	Summarise by Customer	Summarises by the Customer that was invoiced Columns in the report are: Customer (links to customer records) Employees (count) Jobs (count) Incoming Outgoing Profit Profit %
	Summarise by Recruiter	Summarises by the Recruiter linked to the job Columns in the report are: Recruiter (links to Recruiter profiles) Margin Split Employees (count) Jobs (count) Customer (count) Incoming Outgoing Profit Profit %
Standard Summarisation Options	Workplace	Summarises by the location that belongs to a Customer, configured in the Customer record and set on the job. If free text workplaces have been entered, these will list separately even if they have the same name. To roll this data up, you will need to use a workplace that has been configured for the Customer Columns in the report are: Workplace Incoming Outgoing Profit Profit %
	Billing Group	Summarises by the Billing Group that the invoice was sent to Columns in the report are: Billing Group Incoming Outgoing Profit Profit %
	Source Type	Summarises by the type of object that created the transaction record. Options are: Timesheet Expense Report Leave Accrual Manual (ie an item that was manually added to payroll or an invoice) Columns in the report are: Source Type Incoming Outgoing Profit Profit %
	Source	Summarises by the actual object that created the pay/charge item, eg ‘Invoice #1’If the Source was a Timesheet or an Expense it will provide a link to the object If the Source was Manual or Leave Accrual then there will not be a link Columns in the report are: Source (links to source) Source Type Incoming Outgoing Profit Profit %
	Parent Timesheet	Summarises all original timesheet, adjustment timesheet and current timesheet into one reporting line, by the parent (original) timesheet.  This summarisation method will consolidate all revenue and costs for the original timesheet and any adjustment timesheets.  Columns in the report are: Parent Timesheet Incoming Outgoing Profit Profit %
	Pay/Charge Item	Summarise by the Pay/Charge Item used Columns in the report are: Pay/Charge Item Units Paid Units Invoiced Incoming Outgoing Profit Profit %
	Months	Includes all transactions that occurred within the month. A month is defined as a calendar month (eg 1-31 January) Columns in the report are: Month Incoming Outgoing Profit Profit %
	Week	Includes all transactions that occurred within a week. A week is defined as Mon-Sun Columns in the report are: Week Beginning or Week Ending (depending on the configuration of the portal) Incoming Outgoing Profit Profit %
	Transaction Entities	Summarises by each unique combination of Pay and Billing Entities Columns in the report are: Pay Entity Billing Entity Incoming Outgoing Profit Profit %
	Pay Entity	Assigns all charges to the Pay Entity, ignoring the Billing Entity Columns in the report are: Pay Entity Incoming Outgoing Profit Profit %
	Bill Entity	Assigns all costs to the Billing Entity, ignoring the Pay Entity Columns in the report are: Billing Entity Incoming Outgoing Profit Profit %
	Branch	Summarises based on any branches that have been configured for the entity Columns in the report are: Branch Incoming Outgoing Profit Profit %
	Division	Summarises based on any divisions that have been configured for the entity Columns in the report are: Division Incoming Outgoing Profit Profit %

If no summarisation options are selected, each Pay and Charge Item will be listed on a separate row in the report.

A pay item with an associated charge item will appear on a single row, with both items should be listed in the Pay/Charge Item column. A pay item without a charge item will appear as a single row.

The report columns that appear when no summarisation is set are:

• Employee (link to employee profiles)
• Job (link to jobs)
• Customer (link to customers)
• Pay/Charge Items
• Source Type
• Units Paid
• Units Invoiced
• Incoming
• Outgoing
• Profit
• Profit %

Subtotal Options

The report can also be subtotalled by a number of the above categories. Options in the Subtotal drop-down list are:

• Transaction Entities
• Pay Entity
• Bill Entity
• Branch
• Division
• Customer
• Recruiter
• Source Type