Calculate Hours & Wages including deductions and VAT

[KxrlPlays]

Hey guys,

So over the last two months I feel like that I have been under-paid from my work place, however as I have only been their 7 months now, I have let it slide and haven't said anything without knowing they're not paying me correctly.

I know that a lot of people use Excel to create a rough estimate of their wages but I wanted to create a rough estimate by implementing variables, to make it more accurate, however I suck with Excel formula that exceeds the =SUM. I've managed to do some Hlookups and Vlookups but that was with the guidance of a teacher.

Would anyone be able to help me setup a spreadsheet that contains 12 sub sheets (1 for each month of the year) where I can input the hours I work for each day of the week.

I want the hours Monday-Saturday times by £6.83, and on a Sunday times by £10.00.

I would also like the formula to takeaway 1/4 of £6.83 (or £10.00) for any shift equal to 4 hours and up to 7 hours 45, and 1 and 1/4 pay for any shifts equal to or over 8 hours.

Would it also be possible to implement some formula that will accumulate all of the hours worked per month (including the deductions).

Finally I'll need to apply 20% VAT to anything earned over £330 per month.

Sorry I'm useless

Merry Christmas

Thanks, Karl

[Pete_UK]

Where does VAT come into a wages calculation? Do you mean Income Tax?

Pete

[FDibbins]

Hi, welcome to the forum

1st, I would advise against using a sheet for each month, excel works best if all data is on the same sheet. the extract can be done on a seperate sheet using a sumifs and/or countifs.

If you can upload a sample of what you have and what you would like it to look like, we can help you put something together

[newdoverman]

I would suggest that you NOT have a worksheet for each month but register your hours in one single worksheet giving the Date, Start Time, End time, Hours, then you can add the rate of pay and the pay (gross per day).

Enclosed is an very small example workbook that only uses 1 worksheet and has a couple of example days. The Income tax and benefits are related to salary amount so I don't have any idea what your rate of tax is or the rate of benefit payment. This is just to give you an idea.

I this is something that you want to pursue and have more details on the deductions from salary, we may be able to help you.