If you’re unsure how to adjust bonuses for employees who didn’t work the full year — or who were paid a bonus covering a much longer period — you’re not alone. Bonus pro-ration is one of the most common (and costly) mistakes in gender pay gap reporting. Get it wrong and your statutory figures are wrong. This guide explains exactly what the regulations require, with a plain-English worked example.
Why Bonus Pro-Ration Matters for GPG Reporting
When you calculate each employee’s hourly pay for gender pay gap purposes, you don’t just use their basic salary. You also have to include any bonus paid to them in the pay period that includes your snapshot date — even if that bonus covered a much longer period, like a quarter or a whole year.
The problem? If you use the full bonus amount without adjustment, you’re artificially inflating that employee’s hourly pay. That skews your quartile results and can push your mean hourly pay gap figures in the wrong direction.
The regulations are specific about this. You must pro-rata any bonus that relates to a period longer than your pay period, so that you’re only counting the slice of bonus that corresponds to the pay period itself.
Important: This applies only to Step 3a — bonuses included in the hourly pay calculation for full-pay relevant employees. For Step 3b (the bonus pay gap calculations), you use the actual bonus paid over the full 12 months with no pro-ration needed.
The Eligibility Period: What Are You Actually Adjusting For?
The ‘eligibility period’ is the timeframe that the bonus was intended to reward. This might be:
- A quarterly performance bonus (3 months)
- A half-year incentive payment (6 months)
- An annual bonus (12 months)
- A multi-year long service award
Your pay period — the window your snapshot date falls in — is almost always much shorter than this. It’s typically a week, a fortnight, or a month.
The pro-ration formula converts the full bonus amount into the equivalent amount just for your pay period. Think of it as slicing a large cake down to just the portion that belongs in that single pay period.
The Pro-Ration Formula
Step 1: Divide the full bonus by the number of days in the eligibility period
Step 2: Multiply that result by the number of days in your pay period
Pro-rated bonus = (Full bonus ÷ Days in eligibility period) × Days in pay period
How to Count the Days
The regulations use standardised day counts to avoid inconsistency across different calendar months and years. Use these figures:
| Pay / Eligibility Period Type | Days to Use |
|---|---|
| Weekly | 7 |
| Monthly (1 month) | 30.44 |
| Quarterly (3 months) | 3 × 30.44 = 91.32 |
| Half-yearly (6 months) | 6 × 30.44 = 182.64 |
| Annual (1 year) | 365.25 |
Worked Example: Quarterly Bonus, Monthly Pay Period
Example: Sarah’s Quarterly Bonus
Sarah is a full-pay relevant employee, paid monthly (snapshot date: 5 April). In the April pay period, she received a £3,600 bonus relating to Q1 performance — a 3-month period.
Step 1: Days in the eligibility period
3 months × 30.44 = 91.32 days
Step 2: Divide the bonus by the eligibility period days
£3,600 ÷ 91.32 = £39.42 per day
Step 3: Multiply by the days in the pay period (monthly = 30.44)
£39.42 × 30.44 = £1,199.55
✅ The pro-rated bonus to include in Sarah’s hourly pay calculation: £1,199.55
Not £3,600 — which would have overstated her hourly rate by three times.
Notice how using the full £3,600 would have made Sarah’s hourly rate look nearly three times higher than it actually is. In a workforce with lots of high-earning bonus recipients, that kind of error systematically distorts your upper quartile — and your reported gender pay gap.
When You Don’t Need to Pro-Rate
Not every bonus needs adjustment. You can use the full bonus amount without pro-ration if:
- The bonus relates to the same period as your pay period (e.g. a monthly bonus paid in a monthly pay period)
- The bonus is not related to any specific time period at all (e.g. a discretionary one-off payment with no defined performance window)
- The bonus eligibility period is 12 months and aligns with the 12 months ending on your snapshot date
Remember: the pro-ration rule only applies to Step 3a — bonuses used in the hourly pay calculation. For Step 3b (bonus pay gap), use the actual total bonus paid in the 12 months with no adjustment.
Common Mistakes to Avoid
Using the full annual bonus in hourly pay
This is the most frequent error. If an employee receives a £12,000 annual bonus in the April pay period, you cannot use £12,000 in the hourly pay formula. You must pro-rate it to the monthly equivalent — roughly £1,000.
Pro-rating bonuses in Step 3b
Step 3b uses actual bonuses paid over 12 months — no pro-ration here. The two steps use different data for different purposes. Mixing them up is a common source of error.
Using calendar days instead of the regulatory day counts
April has 30 days. But the regulations say a month has 30.44 days. The differences are small, but using actual calendar days rather than the prescribed figures means your calculation is technically non-compliant.
Forgetting to include the pro-rated bonus in the hourly pay total
The hourly pay formula is: (Ordinary pay + pro-rated bonus) × multiplier ÷ weekly working hours. Omitting the bonus entirely — or forgetting to add it back after pro-rating — means you’re understating that employee’s hourly rate.
Make This Easier With the Right Tools
Manually tracking all of this — eligibility periods, day-count rules, which employees received bonuses in the pay period, which need adjusting — is genuinely time-consuming when you’re doing it in a blank spreadsheet.
📋 Free Download: Data Preparation Checklist
Step through every data decision in the right order — including bonus eligibility and pro-ration — before you start calculating.
Download Free →If you want to skip the manual work entirely, the Gender Pay Gap Report Toolkit handles all six statutory calculations in one place — including the pro-ration logic for Step 3a bonuses.
⚡ Gender Pay Gap Report Toolkit
Pre-built Excel calculator covering all 6 statutory figures. Enter your payroll data once — the tool handles the rest.
Get the Toolkit →Frequently Asked Questions
Do I pro-rate bonuses for part-time employees?
The pro-ration here is about the time period the bonus relates to — not the employee’s working pattern. Part-time status is accounted for separately through the weekly working hours in the hourly pay calculation. You pro-rate the bonus for the eligibility period regardless of whether the employee is full-time or part-time.
What if an employee received multiple bonuses in the pay period?
Pro-rate each bonus separately according to its own eligibility period, then add them together before applying the hourly pay formula.
What if I don’t know what period the bonus was for?
If the bonus is genuinely not related to any specific period — for example, a discretionary recognition payment — include the full amount with no pro-ration. If it’s unclear, check the documentation for the scheme. If it can reasonably be linked to a defined performance window, pro-rate it accordingly.
My snapshot date is 31 March — does anything change?
The formula and day-count rules are identical. The only difference is which pay period your snapshot date falls in. For most public authority employers on a 31 March snapshot date, the pay period will typically be 1–31 March. The pro-ration calculation works exactly the same way.