Scribd Logo
Upload

Welcome to Scribd!

  • 147 views

    Attendance Sheet in Excel

    Uploaded by

    salman
    The document contains payroll information for employees of an organization for the month of July 2017. It includes details like name, department, salary structure, attendance and leave records. The payroll shows monthly salary breakdown with components like basic salary, DA, HRA, conveyance allowance, medical reimbursement, bonus, TDS deductions for individuals. It also provides department-wise staff count and a recommended salary structure template with common compensation elements and their benchmarks.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Attendance Sheet in Excel

    Uploaded by

    salman
    147 views14 pages
    The document contains payroll information for employees of an organization for the month of July 2017. It includes details like name, department, salary structure, attendance and leave records. The payroll shows monthly salary breakdown with components like basic salary, DA, HRA, conveyance allowance, medical reimbursement, bonus, TDS deductions for individuals. It also provides department-wise staff count and a recommended salary structure template with common compensation elements and their benchmarks.

    Original Description:

    ATTENDANCE SHEET

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains payroll information for employees of an organization for the month of July 2017. It includes details like name, department, salary structure, attendance and leave records. The payroll shows monthly salary breakdown with components like basic salary, DA, HRA, conveyance allowance, medical reimbursement, bonus, TDS deductions for individuals. It also provides department-wise staff count and a recommended salary structure template with common compensation elements and their benchmarks.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    147 views14 pages

    Attendance Sheet in Excel

    Uploaded by

    salman
    The document contains payroll information for employees of an organization for the month of July 2017. It includes details like name, department, salary structure, attendance and leave records. The payroll shows monthly salary breakdown with components like basic salary, DA, HRA, conveyance allowance, medical reimbursement, bonus, TDS deductions for individuals. It also provides department-wise staff count and a recommended salary structure template with common compensation elements and their benchmarks.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 14

    www.myelesson.org www.myelesson.

    org
    Name 1-Jul 2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul 8-Jul
    Like Singh P P P L A P P
    Share KumarP P P P P P P
    Comment GP P L P P P P
    Subscribe MeA P A P P A P
    www.myelesson.org www.myelesson.org
    9-Jul ### ### ### ### ### ### ### ### ###
    P L A P P P L A
    P P P P P P P P
    L P P P P P P P
    A P P A P P P P
    lesson.org www.myelesson.org www.myelesson.or
    ### ### ### ### ### ### ### ### ### ###
    P P P P A P P P P
    P P P P P P P P P
    P P P L P P P P L
    A P P A P A P P A

    5
    w.myelesson.org www.myelesson.org www.myelesson.
    ### ### ### P L A Salary Days
    L A 17 4 5 26
    P P 26 0 0 31
    P P 22 4 0 31
    P L 16 1 9 22

    P Present
    L Leave - Paid Leave
    A Absent -Non Paid Leave
    Salary DayNumber of days for which salary w
    Blank CellsWeek Of
    w.myelesson.org

    hich salary will be paid


    www.myelesson.org
    Total
    Days of Salary CTC for
    Sr.no Name Department Month Year CTC
    Month Days Apr

    1 Like Singh Accounts July 2017 31 26 50000 41935


    2 Share Kumar Marketing July 2017 31 31 50000 50000
    3 Comment G Operations July 2017 31 31 25000 25000
    4 Subscribe Me Marketing July 2017 31 22 40000 28387
    TOTAL GROSS SALARY TOTAL DEDUCTIONS
    50% 12% 20% 16% 2% 12%
    Contribu Professi
    Conveyanc Medical Bonus TA
    Basic Salary DA HRA TOTAL tion to on Tax TDS
    e Expense PF
    20968 5032 8387 6710 839 0 0 41935 2516 200
    25000 6000 10000 8000 1000 0 0 50000 3000 200
    12500 3000 5000 4000 500 0 0 25000 1500 200
    14194 3406 5677 4542 568 0 0 28387 1703 200
    TAL DEDUCTIONS

    Salary TOTAL NET


    Adv PAYABLE

    2716 39219
    3200 46800
    1700 23300
    1903 26484
    Department Name
    Sales
    Accounts
    Operations
    Admin
    Marketing
    Component
    Basic
    DA
    HRA
    Conveyance
    Medical
    LTA
    ESIC
    Special
    Provident Fund (Employ
    Provident Fund (Employ
    Professional Tax
    Labour Welfare Fund
    Recommendation
    40-50% of CTC
    5% of CTC
    50% of Basic + DA if metro and 40% if non-metro
    Rs. 1,600 a month
    Rs. 1,600 a month
    No real benchmark, can even be used as a plug, but if not ca
    6.5% of Gross Salary
    Usually used as a balancing component
    12% of Basic + DA
    Rs. 1,600 a month
    As per statewise slabs
    As per statewise slabs
    an set as 10% of Basic

    You might also like