For instance, the employer portion of the payroll tax is 6.2 percent, so the calculation would multiply the employee's gross pay by 6.2 percent. So if the gross pay was in cell D3, the formula ...

If you want to calculate your employee's income after FICA tax, you may add a new column, "Income After FICA," in cell F1. Under this column, put "=B2-E2," which gives you the income you must pay ...

2. Protect your worksheet by clicking on ‘Review’ > ‘Protect Sheet’ > set a password to avoid unauthorized changes. In conclusion, preparing payroll in Excel streamlines the payroll process, reduces ...