Create your report
Upload one row per employee on your snapshot date. We'll check the data and show your headline figures for free.
Not sure what to export?
Start from the CSV template; the table below explains each column. CSV template
Try it with sample data
A fictional 118-employee firm, so you can see the whole flow. sample dataset
Private by design
Your file is processed in memory and never stored. We keep only purchase records. Privacy
What goes in each column
| Column | What to enter |
|---|---|
employee_id | Your internal ID or payroll number. Do not use names. |
gender | M or F (self-identified). Use X for employees who do not identify as male or female or have not disclosed: they count in headcount only. |
ordinary_pay | Gross ordinary pay for work in the 12-month reporting period: basic pay, allowances, overtime, shift premium, piece-work, sick pay, leave top-ups. Exclude expenses reimbursements, redundancy/termination pay, BIK and back-pay for earlier periods. |
bonus_pay | Gross bonus remuneration paid in the period (money, vouchers, shares: profit-sharing, performance, incentive, commission). 0 if none. |
bonus_period_days | Optional. Length in days of the period the bonus relates to, if it differs from the 12-month reporting period (e.g. 730 for a 2-year LTIP). |
hours_worked | Total working hours in the 12-month reporting period (Reg 4 methods). |
hourly_pay | Optional. If you already calculated hourly remuneration ((ordinary + bonus) / hours) put it here; ordinary_pay and hours_worked can then be left blank. |
bik_received | Y if the employee received any benefit in kind in the period, else N. |
part_time | Y if part-time under the Protection of Employees (Part-Time Work) Act 2001. |
temporary | Y if on a temporary (fixed-term/specified-purpose) contract. |