Blogger
Share this content
0
13
26342

Is there a (free!) spreadsheet or calculator for grossing up net pay.

I have some employee/shareholders who are moving onto a more substantial salary rather than a £4K salary + dividends. They want to receive net pay of £45K, £50K & £100K per annum and are all on K codes. Is there a quick and easy method out there of calculating the gross equivalent salary?

Anon

Replies

Please login or register to join the discussion.

calcpay
www.calcpay.co.uk has a free utility you can download

Thanks (0)

Optimisation solution
This is a problem for the data solver/goal seek.
Create a simple model to calulate net pay and then use the data solver/goal seek to calculate the correct amount for the gross pay cell to give you the amount you require in the Net pay Cell.

Thanks (0)

Indeed it is
and that's what I used in the example sheet below :-)

Thanks (0)

Apologies Alan
apologies!!
I had not followed the link.
I have now - very nice!!!
Ken

Thanks (0)

Possibly
Certainly a payroll package such as DOSH does this type of calculation easily.

If you have to use a free source how about the HMR&C disk. I think you may be able to do such calculations on the disk containing the 'old' PAYE tables etc.?

Thanks (0)

I think think this does it
Net/Gross calculator

[EDIT] I should have put it on the spreadsheet, but it is E&OE, no liability accepted etc

Thanks (0)

Net to Gross calculator
Try www.avpay.co.uk They have a free net to gross and gross to net calculator accessible from the main page.

Adam Armstrong
www.armstrongpayrollsolutions.co.uk

Thanks (0)

Andica Payroll Software
Hi

Andica Payroll Software, provides a net to gross salary processing feature. It's not free but at prices starting from £69+VAT, it's almost free. Also has a File by Internet feature to submit your year end returns online. Details on http://www.andica.com

Bharat

Thanks (0)

Qtac Solutions - Payroll Software & Services
Qtac Solutions provides a Net to Gross calculation facility in all PAYE calculators and payroll software. If you'd like further information about our payroll software or services please call 0117 9353500 or visit our website www.qtac.co.uk.

Thanks (0)

Nicholas,
yes I am charging the client and fees are calculated on time spent. However this is a one-off client request and it is far more cost effective to use the spreadsheet kindly posted on the forum by Alan Webb than by wasting client fees trying miserably to come up with a formula myself. If I had no responses I would have had gone back to basics!

Thanks (0)

Net Salary Calculator
When I tried putting in a code of 489L, it gave allowances of 489 instead of 4895.

Thanks (0)

Pay for it
i know everyone wants something for nothing, are you providing your services for free?

we should pay for software if we are charging for our services based on it.

Thanks (0)

Oops!!
So it did

Now fixed - same link or Net/Gross calculator though 489 will give 4899, which if I remember rightly is what the pay tables give.

Thanks (0)