Blogger
Share this content
0
13
26603

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.

avatar
18th Nov 2005 13:31

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

Thanks (0)
avatar
17th Nov 2005 16:03

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)
avatar
By ACDWebb
17th Nov 2005 17:02

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

Thanks (0)
avatar
18th Nov 2005 12:06

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

Thanks (0)
avatar
By Anonymous
21st Sep 2005 16:21

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)
avatar
By ACDWebb
21st Sep 2005 22:48

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)
avatar
By adamsgi
21st Sep 2005 17:39

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)
avatar
22nd Sep 2005 17:42

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)
avatar
03rd Oct 2005 09:19

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)
avatar
03rd Oct 2005 09:39

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)
avatar
29th Sep 2005 13:43

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

Thanks (0)
avatar
30th Sep 2005 12:08

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)
avatar
By ACDWebb
29th Sep 2005 22:51

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)