Contents

Timesheet margin report introduction

Margin reporting is an important metric for any recruitment Agency.  InTime’s timesheet margin report allows you to see the difference between your sales and costs.

As recruitment agencies differ in their reporting requirements, InTime’s timesheet margin report provides you with a number of configurable options that can be tailored and saved for later use.

This guide will provide you with some instructions as a starting point to run a basic pay and bill timesheet margin report.

Timesheet margin report summary instructions

Step 1.                 Navigate to Reports > Margin Report

Step 2.                 Click on the “Saved Reports” and choose the “Default Margin Layout” report

Step 3.                 Enter the pay frequencies you want to filter from the main tab.

Step 4.                 Enter the payroll reference under “ID/Ref Ranges” tab > “Payroll Reference” field

                           Or

                           Enter the exported date range through the “Date Ranges” tab > “Exported Date” field

Step 5.                 Click “Gross Margin”

The default timesheet margin report

Pay and bill clients will have access to a pre-configured default margin saved report.

To run a default margin, please follow the steps below:

Through the menu option, navigate to:

• Reports > Margin Report

• Select the “Saved Report” tab

• Click on the “Default Margin Layout” report from the saved list

Open

Depending on your requirements, populate the filter options listed below.

If you have multiple payroll frequencies (i.e. weekly and monthly), you will need to ensure that you have only included those frequencies in your report.  Frequencies can be updated by:

• Clicking on the “Main Filters” tab.

• Ensure the frequencies you want to include in the report are selected.

Open

Date ranges or payroll ref ranges

There aren’t defined closed periods within InTime.  This allows flexibility when running reports over a bespoke date rate.

To run a timesheet margin report for a specific payroll period you will need to enter the appropriate date or payroll ref ranges.

Using Payroll reference (see below to run based on dates)

Once the pay and bill team begin processing your payroll for a given period, a “payroll reference” will be assigned to all the timesheets included within that payroll and mark them with an “Exported” status.  The “Exported” status indicates the timesheet has been processed for payment.

The payroll reference is applied to timesheets in the following format:

• Tax Year followed by the Tax Week/Month (for example: 202301).

To run the timesheet margin report by the payroll period the timesheet were processed in, you must enter the payroll period into the field shown below.  If you are unsure which period, you should be entering, please consult your pay and bill contact.

Open

Using Date Ranges

Timesheets processed through a given payroll will be timestamped with an exported date and have the “Export” status applied.

To run a margin analysis for a particular period using dates rather than the payroll reference, it is strongly recommended that you use the “Exported Date” field shown below.

Set the export date range to cover the entire week of the timesheet margin period you want to view.  The dates you set in the date field will return all timesheets processed for payment within that period.

Open

Generating the report

After applying the correct payroll period, payroll reference or dates as per the points above, the report can be generated by clicking on the “Gross Margin” button.

Open

The report results

A list of timesheets will be displayed in the results table.  The basic margin will output a single row for each separate rate applied to the timesheet (i.e. Standard Rate, Overtime Rate etc).

Open

The timesheet margin report will highlight rows based on the margin percentage.

• 5% and below - items are coloured red

• Between 5% and 10% items are coloured lilac

• Between 25% and 50% items are colour lilac

• 50% and above - items are coloured green

Holiday calculation displayed on the report

The holiday amounts displayed in the report are estimated accrual values rather than holiday actually paid out to the worker.  For reporting purposes, the holiday amount is calculated by taking the pay and multiplying the value by the rate of accrual set on the worker or placement record (i.e. a worker paid £100 and accrues at 28 days per year would have a holiday value of £12.07).

The results can be extracted to Excel by clicking the CSV button.