Tracking employee attendance and their overtime. Simple but useful format in excel.
You can do the following things
1. Ask to punch for timings if they are coming to factory and going out but evening not coming back.
2. Insist on self attendance weekly/monthly keeping his/her boss in loop.
and many more.
|
Employee Timecard |
|
|
Employee Name: |
|
E-mail: |
|
|
Year to date totals: |
|
|
|
|
|
Manager: |
|
Phone: |
|
|
Regular hrs: |
0.00 |
Overtime hrs: |
0.00 |
Total: |
0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
January, February, March Employee Timecard: Daily, Weekly, Monthly, Yearly |
|
January |
Week 1 |
Overtime |
Week 2 |
Overtime |
Week 3 |
Overtime |
Week 4 |
Overtime |
Week 5 |
Overtime |
|
Monday |
|
|
|
|
|
|
|
|
|
|
|
Tuesday |
|
|
|
|
|
|
|
|
|
|
|
Wednesday |
|
|
|
|
|
|
|
|
|
|
|
Thursday |
|
|
|
|
|
|
|
|
|
|
|
Friday |
|
|
|
|
|
|
|
|
|
|
|
Saturday |
|
|
|
|
|
|
|
|
|
|
|
Sunday |
|
|
|
|
|
|
|
|
|
|
|
Total weekly hours |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
Jan. total: Regular hours |
0.00 |
Jan. total: Overtime |
0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
February |
Week 1 |
Overtime |
Week 2 |
Overtime |
Week 3 |
Overtime |
Week 4 |
Overtime |
Week 5 |
Overtime |
|
Monday |
|
|
|
|
|
|
|
|
|
|
|
Tuesday |
|
|
|
|
|
|
|
|
|
|
|
Wednesday |
|
|
|
|
|
|
|
|
|
|
|
Thursday |
|
|
|
|
|
|
|
|
|
|
|
Friday |
|
|
|
|
|
|
|
|
|
|
|
Saturday |
|
|
|
|
|
|
|
|
|
|
|
Sunday |
|
|
|
|
|
|
|
|
|
|
|
Total weekly hours |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
Feb. total: Regular hours |
0.00 |
Feb. total: Overtime |
0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
March |
Week 1 |
Overtime |
Week 2 |
Overtime |
Week 3 |
Overtime |
Week 4 |
Overtime |
Week 5 |
Overtime |
|
Monday |
|
|
|
|
|
|
|
|
|
|
|
Tuesday |
|
|
|
|
|
|
|
|
|
|
|
Wednesday |
|
|
|
|
|
|
|
|
|
|
|
Thursday |
|
|
|
|
|
|
|
|
|
|
|
Friday |
|
|
|
|
|
|
|
|
|
|
|
Saturday |
|
|
|
|
|
|
|
|
|
|
|
Sunday |
|
|
|
|
|
|
|
|
|
|
|
Total weekly hours |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
Mar. total: Regular hours |
0.00 |
Mar. total: Overtime |
0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
April, May, June Employee Timecard: Daily, Weekly, Monthly, Yearly |
|
April |
Week 1 |
Overtime |
Week 2 |
Overtime |
Week 3 |
Overtime |
Week 4 |
Overtime |
Week 5 |
Overtime |
|
Monday |
|
|
|
|
|
|
|
|
|
|
|
Tuesday |
|
|
|
|
|
|
|
|
|
|
|
Wednesday |
|
|
|
|
|
|
|
|
|
|
|
Thursday |
|
|
|
|
|
|
|
|
|
|
|
Friday |
|
|
|
|
|
|
|
|
|
|
|
Saturday |
|
|
|
|
|
|
|
|
|
|
|
Sunday |
|
|
|
|
|
|
|
|
|
|
|
Total weekly hours |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
Apr. total: Regular hours |
0.00 |
Apr. total: Overtime |
0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
May |
Week 1 |
Overtime |
Week 2 |
Overtime |
Week 3 |
Overtime |
Week 4 |
Overtime |
Week 5 |
Overtime |
|
Monday |
|
|
|
|
|
|
|
|
|
|
|
Tuesday |
|
|
|
|
|
|
|
|
|
|
|
Wednesday |
|
|
|
|
|
|
|
|
|
|
|
Thursday |
|
|
|
|
|
|
|
|
|
|
|
Friday |
|
|
|
|
|
|
|
|
|
|
|
Saturday |
|
|
|
|
|
|
|
|
|
|
|
Sunday |
|
|
|
|
|
|
|
|
|
|
|
Total weekly hours |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
May total: Regular hours |
0.00 |
May total: Overtime |
0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
June |
Week 1 |
Overtime |
Week 2 |
Overtime |
Week 3 |
Overtime |
Week 4 |
Overtime |
Week 5 |
Overtime |
|
Monday |
|
|
|
|
|
|
|
|
|
|
|
Tuesday |
|
|
|
|
|
|
|
|
|
|
|
Wednesday |
|
|
|
|
|
|
|
|
|
|
|
Thursday |
|
|
|
|
|
|
|
|
|
|
|
Friday |
|
|
|
|
|
|
|
|
|
|
|
Saturday |
|
|
|
|
|
|
|
|
|
|
|
Sunday |
|
|
|
|
|
|
|
|
|
|
|
Total weekly hours |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
June total: Regular hours |
0.00 |
June total: Overtime |
0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
July, August, September Employee Timecard: Daily, Weekly, Monthly, Yearly |
|
July |
Week 1 |
Overtime |
Week 2 |
Overtime |
Week 3 |
Overtime |
Week 4 |
Overtime |
Week 5 |
Overtime |
|
Monday |
|
|
|
|
|
|
|
|
|
|
|
Tuesday |
|
|
|
|
|
|
|
|
|
|
|
Wednesday |
|
|
|
|
|
|
|
|
|
|
|
Thursday |
|
|
|
|
|
|
|
|
|
|
|
Friday |
|
|
|
|
|
|
|
|
|
|
|
Saturday |
|
|
|
|
|
|
|
|
|
|
|
Sunday |
|
|
|
|
|
|
|
|
|
|
|
Total weekly hours |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
July total: Regular hours |
0.00 |
July total: Overtime |
0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
August |
Week 1 |
Overtime |
Week 2 |
Overtime |
Week 3 |
Overtime |
Week 4 |
Overtime |
Week 5 |
Overtime |
|
Monday |
|
|
|
|
|
|
|
|
|
|
|
Tuesday |
|
|
|
|
|
|
|
|
|
|
|
Wednesday |
|
|
|
|
|
|
|
|
|
|
|
Thursday |
|
|
|
|
|
|
|
|
|
|
|
Friday |
|
|
|
|
|
|
|
|
|
|
|
Saturday |
|
|
|
|
|
|
|
|
|
|
|
Sunday |
|
|
|
|
|
|
|
|
|
|
|
Total weekly hours |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
Aug. total: Regular hours |
0.00 |
Aug. total: Overtime |
0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
September |
Week 1 |
Overtime |
Week 2 |
Overtime |
Week 3 |
Overtime |
Week 4 |
Overtime |
Week 5 |
Overtime |
|
Monday |
|
|
|
|
|
|
|
|
|
|
|
Tuesday |
|
|
|
|
|
|
|
|
|
|
|
Wednesday |
|
|
|
|
|
|
|
|
|
|
|
Thursday |
|
|
|
|
|
|
|
|
|
|
|
Friday |
|
|
|
|
|
|
|
|
|
|
|
Saturday |
|
|
|
|
|
|
|
|
|
|
|
Sunday |
|
|
|
|
|
|
|
|
|
|
|
Total weekly hours |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
Sept. total: Regular hours |
0.00 |
Sept. total: Overtime |
0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
October, November, December Employee Timecard: Daily, Weekly, Monthly, Yearly |
|
October |
Week 1 |
Overtime |
Week 2 |
Overtime |
Week 3 |
Overtime |
Week 4 |
Overtime |
Week 5 |
Overtime |
|
Monday |
|
|
|
|
|
|
|
|
|
|
|
Tuesday |
|
|
|
|
|
|
|
|
|
|
|
Wednesday |
|
|
|
|
|
|
|
|
|
|
|
Thursday |
|
|
|
|
|
|
|
|
|
|
|
Friday |
|
|
|
|
|
|
|
|
|
|
|
Saturday |
|
|
|
|
|
|
|
|
|
|
|
Sunday |
|
|
|
|
|
|
|
|
|
|
|
Total weekly hours |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
Oct. total: Regular hours |
0.00 |
Oct. total: Overtime |
0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
November |
Week 1 |
Overtime |
Week 2 |
Overtime |
Week 3 |
Overtime |
Week 4 |
Overtime |
Week 5 |
Overtime |
|
Monday |
|
|
|
|
|
|
|
|
|
|
|
Tuesday |
|
|
|
|
|
|
|
|
|
|
|
Wednesday |
|
|
|
|
|
|
|
|
|
|
|
Thursday |
|
|
|
|
|
|
|
|
|
|
|
Friday |
|
|
|
|
|
|
|
|
|
|
|
Saturday |
|
|
|
|
|
|
|
|
|
|
|
Sunday |
|
|
|
|
|
|
|
|
|
|
|
Total weekly hours |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
Nov. total: Regular hours |
0.00 |
Nov. total: Overtime |
0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
December |
Week 1 |
Overtime |
Week 2 |
Overtime |
Week 3 |
Overtime |
Week 4 |
Overtime |
Week 5 |
Overtime |
|
Monday |
|
|
|
|
|
|
|
|
|
|
|
Tuesday |
|
|
|
|
|
|
|
|
|
|
|
Wednesday |
|
|
|
|
|
|
|
|
|
|
|
Thursday |
|
|
|
|
|
|
|
|
|
|
|
Friday |
|
|
|
|
|
|
|
|
|
|
|
Saturday |
|
|
|
|
|
|
|
|
|
|
|
Sunday |
|
|
|
|
|
|
|
|
|
|
|
Total weekly hours |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
|
Dec. total: Regular hours |
0.00 |
Dec. total: Overtime |
0.00 |
|
|
|
|
|
|
Click Here To Download Employee Attendance
