Payroll pension contribution worksheet calculator

Calculate earnings in entered contribution band and employee contribution after entered cap with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use earnings in entered contribution band and employee contribution after entered cap to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Entered eligible period earnings ($)
1000
Lower earnings offset ($)
200
Upper earnings ceiling ($)
800
Employee contribution rate (%)
5
Employer contribution rate (%)
3
Remaining employee contribution cap for this model ($)
20
Earnings in entered contribution band ($)
$600.00
Employee contribution after entered cap ($)
$20.00
Employer contribution on band ($)
$18.00
Combined model contribution ($)
$38.00

Try another scenario

Entered eligible period earnings ($)
1000
Lower earnings offset ($)
200
Upper earnings ceiling ($)
800
Employee contribution rate (%)
5
Employer contribution rate (%)
3
Remaining employee contribution cap for this model ($)
100
Earnings in entered contribution band ($)
$600.00
Employee contribution after entered cap ($)
$30.00
Employer contribution on band ($)
$18.00
Combined model contribution ($)
$48.00
Calculation method

Calculation method

Earnings in entered contribution band ($)

max(0,min(earnings,upper ceiling)−lower offset).

Employee contribution after entered cap ($)

Round band×employee rate; limit to supplied remaining employee cap.

Employer contribution on band ($)

Round band×employer rate, independently of the employee cap.

Combined model contribution ($)

Add employee and employer components.

Symbols and units
a
Entered eligible period earnings ($)
b
Lower earnings offset ($)
c
Upper earnings ceiling ($)
d
Employee contribution rate (%)
e
Employer contribution rate (%)
f
Remaining employee contribution cap for this model ($)

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • A user-defined earnings band, contribution rates and employee cap. It does not infer pension scheme rules, tax relief, contribution eligibility or statutory thresholds.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

US Department of Labor: pay/time recordkeeping background; actual rules vary ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.