5
minutes read

Automate your Net to Gross calculations

Published on
Aug 21, 2018

Calling all payroll bureaux! Are you familiar with that sinking feeling when you need to process bonuses and you’re given them all as net amounts, meaning you have to find that ‘spare’ time to calculate what the equivalent gross amounts should be before processing in the pay run? Here come the tax tables, formulas and excel spreadsheets, with a side order of late nights. Well, we’ve got some good news! Our Net to Gross Calculator removes all manual calculations and guesswork, saving a lot of time and frustration.

Introducing our Net to Gross Calculator

The purpose of the Net to Gross Calculator is to automatically calculate what the equivalent gross amount should be based off a desired net amount. This calculation looks at an employee’s pay frequency, tax scale and any other earnings to be processed in that pay run.

The Net to Gross Calculator is available as an action within the pay run. Click on an employee’s name to expand their pay details, click on “Actions” and then “Calculate Gross Payment from Net”:

Once you’ve clicked on “Calculate Gross Payment from Net”, the following pop up will appear:

All you need to do is:

  1. Enter the desired net amount you want the employee to be paid;
  2. Select the appropriate pay category; and
  3. Click on “Add to Pay Run”.

In between steps 2 and 3, we will run the calculation for you!

The Net to Gross Calculator can be used for all pay category types. See examples below of the calculator in action.

Using the Net to Gross Calculator on fixed pay categories

Let’s process a bonus for a few employees. The employees are all to receive the same net bonus amount, being £1000.

We’ll start with Charlie:

For Charlie to be paid a net bonus amount of £1000, his gross bonus amount needs to be £1091.59

Now we’ll do the same for Jacob:

For Jacob to be paid a net bonus amount of £1000, his gross bonus amount needs to be £1047.73.

Obviously you can see that Charlie and Jacob’s gross bonus amounts are different – this is simply because the employee's tax codes are different.

Using the Net to Gross Calculator on hourly pay categories

Karina has worked additional hours, outside of her normal salaried hours, and the employer has agreed to pay her for these hours. The issue is that Karina cannot receive more than £1150 in net pay each week. Additionally, there is no obligation for the employer to pay these additional hours (salaried arrangements and all) and so there is no contracted minimum hourly rate to be applied for these additional hours.

Karina’s normal weekly pay is as follows:

Now we will add the additional hours:

  1. The desired net payment entered = £428.92. As Karina’s net earnings are already £721.08, we need to apply the difference between the two amounts needs as the desired net amount.
  2. The number of units = 4, being the number of additional hours Karina worked.
  3. The total gross payment is divided by the number of units entered to calculate the hourly rate of £111.15

The results in the pay run are as follows:

The Net to Gross Calculator is available within the pay run module and so is only accessible to admin (full access) users.

If you have any questions or feedback, don’t hesitate to email us at support@yourpayroll.co.uk.

Try KeyPay free for 30 days

Sign up

Related articles

Payroll Management
5
minutes read
Easy, breezy automated leave management

Everybody loves taking paid leave, so it's not surprising that employees don't take well to incorrectly set leave accruals! KeyPay’s leave automation functionality alongside its ability to configure leave accruals truly makes managing employees’ leave a ‘set and forget’ activity.