النتائج 1 إلى 3 من 3

الموضوع: Payroll Solution in Single Sheet

  1. #1
    نبذه عن الكاتب
     
    البلد
    الصومال
    مجال العمل
    أعمال ادارية
    المشاركات
    4,362

    Payroll Solution in Single Sheet

    [LTR]Here is an excellent sheet which solves your big problem named "Payroll Solution" from a single work sheet.

    It includes all the stuff required for calculating salary and leaves.

    Please Note that You can enter your Detail in White Background Cells Only
    Follow Following Steps
    1) Enter Your Company Details in "Company Detail Shee"
    You can setup Salary structure as per of your company Policy (change figures in white Backgrround).
    (Change % according to your need,ex. Basic is indicated 25% of Gross salary, You can Change This as per Your Policy)
    Please note that salary of All Employee will be generated according to This Figures
    Enter List of All Department of Your Company in any order
    Enter List of All Designation of Your Company in any order
    Select Income Tax Slab of Perticular Year
    2) Enter Your Employee Details in "Master Data Sheet"
    Here You can Enter Employee Details (Like Emp Code,Bank Details,DOB,DOJ.etc)
    Here You have to enter His/hers Monthly Gross Salary remaning Salary structure will be generated as per
    your details provided by you in "Company Detail Sheet"
    Here You can enter His/Her's Leave Detail,Rent Details(Yearly amount),80D,80G (Yearly Amount).
    Income Tax Will be calculated as per your Income Tax Slab Provided by You
    3) Attendance Register
    You can Enter Employee Attendance in Attendance Register given in Monthly
    If You want to enter Attendance of Jan-Open "Jan" sheet enter Present,Absent..(Each meaning is given
    in "Company Detail Sheet")
    Special Leave is a Leave Against work on Holidays
    You can also Enter Overtime in this sheet
    4) Generate Salary slip
    You can generate Salary Slip By Each month
    Open Perticular month Sheet's (Attdence is already taken from "Attendance Sheet" of that month
    You have to only enter other details of perticular Employee
    5) Print out Salary slip
    Print out Salary slip of Each Employee from"Salary Print Out sheet"
    6) You can also find out Leave History of Each and Every Employee from " Personal Leave Graph"
    7) You can also track of Your All employees' Salary from "Salary Master Sheet"

    [/LTR]
    الملفات المرفقة

  2. #2
    الصورة الرمزية Hamed El Sawy
    Hamed El Sawy غير متواجد حالياً تحت التمرين
    نبذه عن الكاتب
     
    البلد
    مصر
    مجال العمل
    تجارة ومحاسبة
    المشاركات
    1
    صفحة الفيس بوك
    صفحة الفيسبوك لـ Hamed El Sawy

    رد: Payroll Solution in Single Sheet

    السلام عليكم ورحمة الله وبركاته
    اشكرك على هذا المجهود الممتاز ولكن انا عندى بعض الملاحظات
    1- اولا الباسورد المرفقة مع الملف غير صحيحة
    2- ثانيا هناك بعض المصطلحات الموجودة بالملف غير مفهومة

    ارجو الافادة والرد لانى الملف عجبنى جدا بس محتاج اضيف عليه بعض التعديلات حتى توائم العمل

  3. #3
    الصورة الرمزية samerhassan82
    samerhassan82 غير متواجد حالياً مستشار
    نبذه عن الكاتب
     
    البلد
    سوريا
    مجال العمل
    موارد بشرية
    المشاركات
    520

    رد: Payroll Solution in Single Sheet

    شكرا جزيلا أخي الكريم..............

موضوعات ذات علاقة
Agile Development & Business Goals: The Six Week Solution
Agile Development and Business Goals describes a unique, state-of-the-art methodology that aligns the critical but often "silo-ed" software development process... (مشاركات: 0)

Payroll-Cv
vacancy.job.ksa@gmail.com NOTE:PLEASE MENTION YOUR JOB TITLE IN SUBJECT. (مشاركات: 0)

5 Steps in Selecting a Time and Attendance Solution
Here are 5 steps to help you in the selection process: 1) Assess your current time and attendance system. The first step is to learn how your current time... (مشاركات: 0)

Payroll
Payroll is the sum of all financial records of salaries, wages, bonus and deductions. Payroll refers to the amount paid to employees for services they provided... (مشاركات: 1)

PF calculation Sheet in Excel
ESI is contributed from both the sides Employee as well as Employer. It is been calculated on the basis of Gross salary per month and the maximum ceiling is... (مشاركات: 0)

أحدث المرفقات