Can anyone please tell me an easy way to calculate gross wages from net pay.
Thanks!!!
Michelle Ward
Replies (3)
Please login or register to join the discussion.
use a spreadsheet
sometimes there is a need to do this as clients say they want to take home a monkey a week or whatever.
The easiest way is to set up the current years
personal allownce , tax rates and ni rates etc on a spreadsheet.
they are all linked together by formulas and you change the gross pay and hey presto the net pay changes automatic.
Shouldn't take more than a few minutes to set up in Excel.
Net to Gross
Alternative solution is to invest in a dedicated payroll prog like Money Manager Payroll Manager. It allows you to gross up pay from a target net pay with one click of your mouse, as well as numerous other options including CIS payments, Contracts of Employment etc. for less that £100
www.moneysoft.co.uk