Hailey & Hayden
New Member
- Joined
- May 21, 2010
- Messages
- 4
Excel PAY AS YOU EARN (PAYE) FORTNIGHT TAX CALCULATOR
Hi i manage to design a payroll spreadsheet for my company of +- 60 employees. The spredsheet works fine,The only thing is when i deduct tax i have to do it manually everything else is automatic. i have a fortnight tax DEDUCTION table 2010 on paper. It has all the different amount I must deduct salaries per fortnight.
Its literally hundreds of amounts with different salaries.
So how do i insert all that amounts into my spreadsheet so that when i enter the employee hours it calculates and deducts automatically.
Any help will be appreciated. Thank you
Regards
Sherman
Hi i manage to design a payroll spreadsheet for my company of +- 60 employees. The spredsheet works fine,The only thing is when i deduct tax i have to do it manually everything else is automatic. i have a fortnight tax DEDUCTION table 2010 on paper. It has all the different amount I must deduct salaries per fortnight.
Its literally hundreds of amounts with different salaries.
So how do i insert all that amounts into my spreadsheet so that when i enter the employee hours it calculates and deducts automatically.
Any help will be appreciated. Thank you
Regards
Sherman