Get HR Software

Need Help Creating an Excel Salary Sheet That Calculates Pay Based on Days Worked?


I need an excel salary sheet in which salary of the month comes automatically by just pressing no. of days, this also include column for casual and eaerned leaves
From India, Delhi
Acknowledge(1)
HE
Amend(0)

Hi, to calculate, use this formula to create the salary sheet: Add the balance of leaves and leaves earned in the next month, then subtract the leaves availed. This will give you the balance leave for the month. Maybe this will help you.
From India, New Delhi
Acknowledge(0)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.

Other Discussions That May Be Relevant
Understanding pf deductions: how to calculate employee and employer contributions?
If the basic salary is inr 15000 what will be the deduction amount of pf on: 1 employee contribution 2 employer contribution pension 8.33 3 employer contribution pf balance on...
2 Replies 1 Files 3 Participants
Need help with the new 2009-10 income tax calculator? check out this useful tool!
Hi all attached is the new format as per the union budget 2009. please find the attached excel file for calculating salary income tax and for investment declaration. i hope...
16 Replies 4 Files 10 Participants
Salary calculation excel sheet for up to 20 employees: download and simplify payroll tasks
Hi everyone just sharing a salary calculation excel sheet for easy salary calculations. it is limited to 20 employees: 01. salary sheet. 02. challans esic and pf. 03. salary slips....
12 Replies 3 Files 11 Participants
Need a simple spreadsheet for tax calculation using salary and investment details?
Does anyone have a spreadsheet that can be used for tax calculation by entering the salary components and investment details? thanks monoswi...
3 Replies 1 Files 3 Participants
Need help finding an excel sheet with it calculations for 2006-2007?
Hi does anyone have an it calculation in an excel sheet with all the formulas for the year 2006 2007? thanking you all in anticipation anil...
2 Replies 1 Files 3 Participants
Navigating income tax regulations: how do you stay compliant and avoid penalties?
Regulations for income tax the regulations for income tax vary depending on the country or jurisdiction in which you reside. in general income tax regulations govern how individuals and businesses...
2 Replies 1 Files 2 Participants
Salary calculation confusion: can anyone simplify ctc and net salary steps for me?
Dear all can you please help me with the steps of salary calculation? is there any format available for ctc and net salary calculation? please make it as simple as...
6 Replies 1 Files 7 Participants

Related Files & Downloads Shared By Members
 Excel sheet for Tax deduction.xls
 SALARY SHEET CALCULATION.xls
 Salary Sheet & PF PT Calculation & Challan.xls


Human Resource Management (HRM) Community Journal & KnowledgeBase (Entry: 442431)

India, Delhi
06 December 2012 07.50.22 PM
Views: 2149 Replies: 1 Appreciations: 2

TOP ENTRIES ON SUBJECT

Salary Calculation
Salary Calculation Made Easy: Download My Free Excel Tool And Simplify Your Payroll Process
Confused About Calculating Daily Salary In India For Different Month Lengths? Let's Discuss!
Curious About Automated Salary Calculations? Check Out This Handy Excel Tool!
How Should We Calculate Employee Salaries: 30 Days Or 26 Days? Seeking Your Thoughts!
Struggling With Salary Breakdown? How To Calculate Basic Pay, DA, And HRA From Gross Salary
Need Urgent Help: How Do I Calculate Basic Salary In Excel Using Gross Salary And Attendance?

Excel Sheet
Need Help With PF, ESI, And Gratuity Calculations In Excel – Can Anyone Share Their Process?
How My Excel Sheet Simplifies Salary And Payslip Management – Your Feedback Needed!
Understanding PF Calculation: How To Accurately Compute Contributions And Use The Excel Sheet Provided
Need Help With New PF ECR File Format In Excel For Registration And Contributions?
New To HR? Seeking Advice On Creating An Employee Database In Excel
Transforming Attendance Tracking: Would An Excel Sheet Or App Work Better For You?

Tax Deduction
Curious About Professional Tax Deductions In Maharashtra? Let's Discuss The Current Slabs
Understanding TDS: How Do You Calculate It From Your Salary And Why Is It Deducted?
Confused About Professional Tax Deductions On Payslip? Let's Figure It Out Together
Tax-Saving Tips For Salaried Employees: How Do You Maximize Savings Without Medical Reimbursement?
New To HR? Need Help Understanding Salary Slip Formats And Deductions?
Understanding Salary After Tax: How Much Should Be Deducted For Income Tax?





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.