Page 2 of 2 FirstFirst 12
Results 11 to 20 of 20

Thread: here is my payroll spreadsheet

  1. #11
    Join Date
    Sep 2005
    Posts
    2,394
    Rep Power
    0

    Default

    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 09:16 PM.
    To find what you seek in the road of life, the best proverb of all is that which says: "Leave no stone unturned." Edward Bulwer Lytton

  2. #12
    Join Date
    Feb 2007
    Posts
    2,656
    Rep Power
    0

    Default

    ok, dumb question. but how do you use the sheet python?
    i love my country, but i fear my elected officials
    Call me on 3538447.
    topdogclu @ hotmail.com

  3. #13
    Join Date
    Sep 2005
    Posts
    2,394
    Rep Power
    0

    Default

    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
    To find what you seek in the road of life, the best proverb of all is that which says: "Leave no stone unturned." Edward Bulwer Lytton

  4. #14
    Join Date
    Aug 2002
    Posts
    6,223
    Rep Power
    0

    Default

    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.
    .
    PC - Ubuntu 15.04 64bit Desktop
    HP Pav G60-236US 3GB RAM Laptop, Ubuntu 15.04 64bit and Win7 Home

    "So Daddy, how come you telling me stealing not right when YOU copying DVDs? How come? How Come?"


    RIP Ramesh ...

  5. #15
    Join Date
    Mar 2005
    Posts
    7,052
    Rep Power
    0

    Default

    ^^ Wonder if someone can whip up a refined one based on above?
    Lover of Technology, period!!||Currently loaded: Samsung Galaxy Note 10+

  6. #16
    Join Date
    Aug 2007
    Posts
    735
    Rep Power
    0

    Default

    Quote Originally Posted by Technoboy View Post
    ^^ Wonder if someone can whip up a refined one based on above?
    Great suggestion but will use this one till something new is available.
    my location 10.10.10.10 subnet ?

  7. #17
    Join Date
    Sep 2005
    Posts
    2,394
    Rep Power
    0

    Default

    @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
    To find what you seek in the road of life, the best proverb of all is that which says: "Leave no stone unturned." Edward Bulwer Lytton

  8. #18
    Join Date
    Nov 2004
    Posts
    2,489
    Rep Power
    0

    Default

    Quote Originally Posted by Technoboy View Post
    ^^ 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 10:57 PM.
    1nsp1ron: Core 2 Duo T5450 1.66 GHz 2MB L2|GM965 Express|2 GB DDR2 667|70.1 GB SATA|DVD±RW|14.1 TFT Display|Intel GMA X3100|Windows 7 Ultimate

  9. #19
    Join Date
    Mar 2005
    Posts
    7,052
    Rep Power
    0

    Default

    Quote Originally Posted by juiceheadband View Post
    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.
    Please resend the password...
    Lover of Technology, period!!||Currently loaded: Samsung Galaxy Note 10+

  10. #20
    Join Date
    Mar 2005
    Posts
    161
    Rep Power
    0

    Default

    Why the forum don't allow us to upload files? It does... just click go advanced and upload your attachment...
    Last edited by Wallizzle; Mar 28, 2013 at 11:15 AM.
    Owned:
    >> Samsung Galaxy Note 3; LG Optimus G; Nexus 4; Samsung Galaxy Ace Duos
    << Microsoft Surface RT; Dell Venue 8; Asus Transformer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •