Prorata Salary Calculator added
For a very long time, people have been asking me to add a prorata tax calculator to The Salary Calculator – I have finally created it and added it to the site. As I have mentioned in an earlier post, prorata salary is normally calculated quite easily. For reduced hours, most employers will multiply the fulltime salary by the reduced number of hours divided by the fulltime hours.
For example, if the fulltime salary is £20,000 per year for 37.5 hours’ work per week, the prorata salary based on a 18hour working week would be:
£20,000 x (18 / 37.5) = £9,600
Income tax, National Insurance and other deductions are then calculated based on this new salary. To use this new tool, you just need to enter the fulltime salary, the fulltime hours, and the new hours that the prorata salary is to be calculated from. To check it out for yourself, get started with the pro rata Salary Calculator.
None of the content on this website, including blog posts, comments, or responses to user comments, is offered as financial advice. Figures used are for illustrative purposes only.
11 Comments to Prorata Salary Calculator added
Leave a comment
Categories
Tags

50% tax
April 2010
April 2011
April 2012
books
budget
careers
debt
dollar
economics
Economy
election
Employed and Self Employed
euro
Foreign Currency
foreign exchange rates
HMRC
holiday
holiday money
house prices
houses
Income Tax
income tax
Jobs
Loans
Mortgages
national insurance
Pay As You Earn
pension
Pensions
personal allowance
pound
recession
recovery
savings
self employed
student loan company
student loans
tax rates
The Salary Calculator
unemployment
united states
us
usa
VAT
Sponsored Links
Archive
 April 2018
 March 2018
 January 2018
 May 2017
 March 2017
 February 2017
 September 2016
 June 2016
 March 2016
 February 2016
 January 2016
 June 2015
 April 2015
 March 2015
 February 2015
 January 2015
 November 2014
 October 2014
 July 2014
 June 2014
 May 2014
 March 2014
 February 2014
 January 2014
 November 2013
 October 2013
 August 2013
 July 2013
 June 2013
 May 2013
 April 2013
 March 2013
 February 2013
 January 2013
 December 2012
 November 2012
 October 2012
 September 2012
 August 2012
 July 2012
 June 2012
 May 2012
 April 2012
 March 2012
 February 2012
 January 2012
 December 2011
 October 2011
 May 2011
 April 2011
 March 2011
 January 2011
 December 2010
 August 2010
 July 2010
 June 2010
 May 2010
 April 2010
 March 2010
 February 2010
 January 2010
 December 2009
 November 2009
 October 2009
 September 2009
 August 2009
 July 2009
 June 2009
Hi a good addition to the calculator would be adding sick days so you can see the effect of unpaid sick days has on take home pay.
Hello,
I was wondering if you could explain whether my employer has calculated my mid month salary adjustment correctly, as I do not agree with the method used.
The following calculation shows how November’s Reference Pay was calculated by the company’s payroll. The calculation did not reflect actual hours/days worked (100 hours/14 days) in November and therefore resulting in underpayments.
Step 1
A salary of £12542.61 has been paid to reflect increased hours from 14.5 a week to 35.5 a week.
Step 2
Oracle Software used by the company has paid one twelfth of the increased salary which is £1045.24 a month (12542.61/12 months).
Step 3
The company had to calculate how many days need to be paid on the old shift (Weekends) by using the following process:
a. Work out the difference between increased Annual Salary and old Annual Salary
£12542.61 increased salary – £5119.66 old salary = £7419.68 adjusted Annual salary
b. Then the formula below had to be used in order to calculate how many days needed to be paid on the old salary
Adjusted Annual Pay x Actual Days worked on the Weekend Shift
Number of working days a year
• Annual Adjusted Pay £7419.68 (£12534.34 – £5119.66)
• Number of working days a year (Weekend Shift) 104
• Actual Number of Days worked 6
So,
£7419.68 x 6 = £428.06 is the amount that needs to be paid on the old salary
104
Step 4
The amount needed to be paid on the old salary is then deducted from the new monthly salary in order to arrive to the final Reference Pay for November, as follow:
£1045.24 new monthly salary – £428.06 amount paid on the old salary = £617.18 a new Reference Pay for November
I do not agree with this method because it did not reflect the number of hours/days worked and the followings shows how I dispute their calculation:
1. The adjusted figure (£7419.68) used to work out days to be paid out on the old salary is wrong as it does not represent correct amount earned on a day. The amount earned per day using this figure is £71.34 per day (7419.68/104 days) which is higher than the actual amount employees received per day £49.22 (6.79 per hour x 7.25 hours per day). Hence, there is an extra of £22.116 (71.343 – 49.227) added to the daily pay which is not given and therefore contribute to this underpayment.
Note: In order to arrive to the correct value for those 6 days worked on the Weekend Shift, correct Annual Salary should be used and in this case the figure needed is the Annual Salary from the Weekend Shift (£5119.66)
2. The actual Monthly Reference Pay based on adjusted annual wage of £7414.68 would work out as £617.18 a month (£7414.68/12 months) without using the formula. This amount represents only 91 hours or 12.5 days a month (£617.18/£6.79 per hour) whilst the actual hours worked from 01st to 30th November 2012 were 100 hours or 14 days (29 hours on the weekends + 71 hours on the nights). Therefore, 9 hours or 1.5 days (100 – 91) has not been included in November’s Reference Pay.
3. The deduction amount of £428.06 for the actual 6 working days on the weekend shift exceeded the actual amount of the Reference Pay that is given (£426.64) monthly for the Weekend Shift employees. Therefore, the calculation done is clearly wrong and does not represent true value of those days.
Hi Pablo,
Thanks for taking the time to write such a detailed message! Unfortunately I don’t think I can give you a categorical answer, because I don’t know enough about the situation and how your employer does their calculations. However, here are a few thoughts I had while reading your comments:
In my experience, when someone’s salary changes part of the way through the month, their salary that month gets some of the increase in proportion to when in the month their salary changed – 100% if it changed on the first of the month and only about 5% or less if it was on the 31st. With some rough calculations, the salary you received in November (£617.18) would suggest you changed shift on about the 20th.
I should say, though, that different employers are likely to do this calculation in different ways so if you think they have got it wrong your line manager, HR or payroll department should be able to talk you through it. If you still think that they have made a mistake then Citizens Advice should be able offer advice.
Please do monthly salary cover weakend days as well
Hi Eve,
Could you give me a bit more information about what you want to work out? Is it overtime at the weekend, or different shifts or something? Let me know what you’d like to see and I’ll try to add it!
How do you work out 4 on 4 off monthly income
Hi Erika,
I imagine that your monthly income changes depending on how many days you work in a particular month? I’m afraid I can’t think of a good way to work it out using The Salary Calculator – all of the options that might help are based on weeks rather than months. I suggest you ask your employer if they can tell you more about how they work it out – this might help you to figure it out.
You will get a pretty good idea if you work out your total pay for the year and simply enter that as the salary on the takehome pay page – this will show you the annual amount and the average amount each month. If the number of days you work each month affects that month’s pay, it will vary a little around that monthly amount.
i have discovered that my pro rata wage has been incorrectly calculated. Well i think it has, maybe you could confirm if I am calculating it correctly.
full time wage is £27500.00 for 35 hours a week. I now work 22 hours a week, but they are saying my wage is £16380.00 per year. I make it £17285.00.
The other problem i have is that i went part time in Oct. 2015, but have only just realised this is not correct. I did not sign a new contract agreeing to this new wage however. I was sent a letter in Dec. 2015 stating my pro rata salary. The reason I had only just discovered this is incorect, is that i had asked for a wage review and looked back through my papaerwork.
I suppose my question to you is: am i correct with my calculations and does my employed have to correct and back pay the owed amount?
thanks in advance
Hi Rebecca,
With the numbers you have provided in your comment, I get the same result as you – i.e., if the salary for 35 hours is £27,500 then the salary for 22 hours is £17,285. However, it strikes me that a more common fulltime week is 37.5 hours, and if we start from that then 22 hours would equate to about £16,133. If you’d had a small costofliving pay rise since October 2015, this could make it around £16,380. Another possibility is that the fulltime week is 37 hours, from which 22 hours would give a salary of £16,351, very close to your current salary. So it might be that your employer used a different “full time” week than you did.
My suggestion would be to discuss this with your employer if you haven’t already – either with your line manager or with the HR / Payroll department – they should be able to explain the situation to you. If you’re not happy with what they say, then Citizens Advice may be able to help – they have lots of information about what your employer is required to do.
Hi we use the 260 method in calculating payroll. If an employee starts mid month do I calculate by days worked or not worked.
Help really appreciated!
Hi Tasha,
I’m sorry, I’m afraid I don’t know the answer to that question! The Salary Calculator (as you will have seen) only does calculations with whole pay periods, so I have never got into part periods like employees starting mid month. I also don’t know where to suggest you might find the answer – I’m sorry I can’t be of more help!