Weekly Timesheet records the working hours of your employees on daily basis for a particular week. In simple terms, timesheet is a document that records the number of hours spent by the employee on the job. Timesheet is the summary of hours worked by employees during the pay period.
Earlier, timesheets were sheets of paper with data arranged in tables. Currently, these timesheets have been turned into digital documents or spreadsheets.
Timesheets can be:
We have created a ready-to-use excel template for Weekly Timesheet With Payslip. Now you can manage in and out times of your employees and prepare their payslips at the end of the month without any hassle with our Weekly Timesheet With Payslip Excel Template.
Click here to download Weekly Timesheet With Payslip Excel Template.
Click here to Download All HR & Payroll Excel Templates for ₹299.You can download other HR documents like Salary Sheet With Attendance Register, Employee Mileage Log and many more templates given on the left bar. ⇐⇐
Weekly Timesheet with Payslip Excel Template consists of 2 worksheets:
This sheet consists of 3 sections
Usually, the Header Section consists of the Company name, the Title of the Sheet and the company logo.
Timesheet consists of the following:
Month: Month for which the Weekly Timesheet is prepared.
Day: When you will enter the date it will automatically update the name of the day of the week. Text function has been used for this
Date: Enter only the first date, with the help of formula it will automatically display dates of whole 7 days of the week.
Name of Employees: You can enter names of employees up to 40 individuals.
Designation: Designation of the Employee
Employee ID: A unique number to identify the employee.
In: Time when the employees will enter the organization. Time should be entered in 24 hours format. For example, “1:00 PM” will be entered as “13:00”.
Out: Time when the employees will exit the organization. Time should be entered in 24 hours format. For example, “1:00 PM” will be entered as “13:00”.
Hourly Summary consists of the following:
Regular Hours: Total hours of the week except for Sunday (the weekly day off/holiday).
Hourly Rate: Hourly Rate for Regular Hours. Usually, the hourly rates are different for regular hours and overtime.
Overtime Hours: Total hours worked on Sunday (the weekly day off/holiday).
Overtime Rate: Hourly rate for overtime hours.
Total Hours: Total hours are the regular hours plus the overtime hours.
Total Hours = Regular Hours + Overtime Hours
You will maintain the time of each employee for a whole week and at the end of the week, you can start preparing the Payslip for all the 40 employees.
Start Date, End Date and the month will be automatically updated from the timesheet.
In the payslip template, just select the name of the employee from the dropdown list created with the help of data validation function.
When you select the name of the employee, it will automatically update following details in the Payslip:
Designation
Employee ID
No. of Days
Regular Hours
Rate/Hr
Overtime Hours
Rate/Hr
With the help of predefined formula, it will calculate the total amount of money for regular as well as overtime hours.
Furthermore, you can add allowances and bonus. Additionally, you can deduct the deductions, taxes, loans etc if applicable in your organization.
You can select the mode of payment from the dropdown list viz; Bank Transfer, Cheque or Cash. If selecting The Bank Transfer mode you need to enter the employee’s bank name and bank account number.
Lastly, enter the remarks and print the document. Then get it signed by the authorized signatory.
This template will help you save a lot of time. Apart from general businesses, this template can also be useful to those allocate their project/works to freelance on an hourly basis.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. I will be more than happy to assist you.
To simplify the process, we have created a simple and easy UK VAT Taxable Turnover…
Every business has to register for VAT with HM Revenue and Customs if their VAT…
We have created the UK VAT Dual Currency Invoice excel template with predefined formulas that…
We have created a simple and easy UK VAT Purchase Register Excel Template with predefined…
We have created a simple and easy UK VAT Sales Register Excel Template with predefined…
We have created a ready to use UK VAT Progress Billing Invoice template in excel…