1. Here is the link: https://www.dropbox.com/s/woj79vmzs2...meTax_Calc.xls

I haven't checked yet if the new Income Tax threshold has become effective. The effective date should have been June 2012

Edit: Did some checks and found that the effective date is now January 1, 2013 for the Income tax threshold change
Last edited by lovepython; Nov 18, 2012 at 08:16 PM.

2. ok, dumb question. but how do you use the sheet python?

3. You have 2 row in which calculation can be done. In the first row you enter the monthly gross salary and the second row the monthly gross salary will be calculated from the annual salary that you will enter in A10

4. Just my thought, but the excel sheet seems a bit simplified and doesn't take into account YTD payroll data, which is important if the payroll dips below the tax threshold for any reason, plus there should be both Employer deductions as well as Employee deductions so that the employer can use it to evaluate their own payments. Rightfully a monthly paid employee should have their amounts running down the sheet by month with the threshold accumulating each month Jan - Dec.

5. ^^ Wonder if someone can whip up a refined one based on above?

6. Originally Posted by Technoboy
^^ Wonder if someone can whip up a refined one based on above?
Great suggestion but will use this one till something new is available.

7. @ramesh Mine is not really a payroll sheet. Its just for an individual to calculate their own salary. I use it to check an make sure i'm getting my correct pay as well as check what my figures are like when i see job listing that post the annual salary for the position

8. Originally Posted by Technoboy
^^ Wonder if someone can whip up a refined one based on above?
Check out this version
https://www.dropbox.com/s/2qs4ctlutz...%20Payslip.xls

The sheet is protected. It's a very basic sheet which calculates the year to date values based on whatever date is used on the payslip. It assumes that earnings remain constant throughout the year.
Last edited by juiceheadband; Nov 22, 2012 at 09:57 PM.

Check out this version
https://www.dropbox.com/s/2qs4ctlutz...%20Payslip.xls

The sheet is protected. It's a very basic sheet which calculates the year to date values based on whatever date is used on the payslip. It assumes that earnings remain constant throughout the year.

10. Junior Techie
Join Date
Mar 2005
Posts
161
Rep Power
0