How to make a formula in Excel for my payroll

MsAH1993

New Member
I have just recently employed 4 employees and I would like to do the payroll myself, rather than paying an accountant. I am trying to do this months pay and am finding it quite time consuming and want to know if there are some formula I can use to speed things up. I am using this tax calculator and putting all the information and values into a spreadsheet. This calculator must be using some sort of formula and I'm wondering if I can replicate it in excel?
Is this the best way of doing this or is there some cost-effective software that can do this for me? Any advice would be appreciated.

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

LouisT

Board Regular
If you're simply calculating taxes, then it seems it's using 15% tax rate. thus your formula would be: =Salary*15% and that would calculate your taxed the employee has to pay and you must deduct. i.e. - if the Salary is \$1000, they would pay/you would deduct \$150 and their net pay would be \$850. However in Canada, your tax rate changes depending on how much you make so if that's the case for the UK you would have to account for that if you have different employees in different Tax brackets.

MsAH1993

New Member
If you're simply calculating taxes, then it seems it's using 15% tax rate. thus your formula would be: =Salary*15% and that would calculate your taxed the employee has to pay and you must deduct. i.e. - if the Salary is \$1000, they would pay/you would deduct \$150 and their net pay would be \$850. However in Canada, your tax rate changes depending on how much you make so if that's the case for the UK you would have to account for that if you have different employees in different Tax brackets.

There is pension contributions,national insurance (employee and employer), student loan deductions etc, there is different rules. Also our tax is not on all salary we get allowances dictating by tax code etc

LouisT

Board Regular
There is pension contributions,national insurance (employee and employer), student loan deductions etc, there is different rules. Also our tax is not on all salary we get allowances dictating by tax code etc
If that's the case then i think unless you can get all the different scenarios of calculations you're likely best off continuing to use the calculator.

Kyrie

New Member
If that's the case then i think unless you can get all the different scenarios of calculations you're likely best off continuing to use the calculator.

Honestly, you should probably use quickbooks for this:

MsAH1993

New Member
Honestly, you should probably use quickbooks for this:

Im just thinking cost of this vs the time its taking me, is it worth it?

Replies
3
Views
119
Replies
3
Views
149
Replies
4
Views
557
Replies
5
Views
80
Replies
1
Views
78

1,126,983
Messages
5,621,966
Members
415,869
Latest member
LWSkinner

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back