Timetable Template

Update the list with your employee information, including their contracted hours, department information, hourly rate and public holiday rates (marked as PH), which could be different from regular hourly rates. The cell contracted hours (marked as CH) contains formula that multiplies employee regular hourly rate by a number of contracted hours and will be updated automatically. Once you've updated all information on your employee list tab, you are pretty much ready to start creating the shift schedule.

The timetable basically is a main tab that you'll be working on when creating the schedule of work hours for your staff. Most of the information on this worksheet, such as names, department name and contracted hours of your staff is automatically obtained from the employee list, so that you do not have to reenter everything again. Every column, staring from Monday contains 2 small columns to record a shift beginning and end times by selecting it from the drop down list, where you can also find the optional code, which you've created earlier on the settings tab to indicate OFF, PH, SICK or similar. You'll notice as you make changes that cells in the column marked Time will change the background color from blue, which indicates under timing to red, if more than contracted hours has been assigned to an employee (overtime hours).

The next tab that's also used frequently is a Time Card that allows you to print an individual time cards for all your staff individually by simply selecting the name in the employee list. The time card acts as a simple timesheet that includes all shift hours given to the staff member and also contains an empty cells to record an actual "In" and "Out" hours.

If your company or organization includes more than just one department then the labor cost distribution already is a known phrase for you. The salary distribution in between the departments directly involves distribution of your payroll budget, which you can do by going to the HR & Budget tab. You'll notice that the background color of the column in which you have to enter your figures is pink. The amounts that you see in the column labeled Actual are calculated automatically, when you create the staff shift schedule and calculated as a sum of hourly rate multiplied by the number of hours assigned to every employee individually within the department. The difference between your budget and actual salary within the departments is shown in the column labeled Variance that displayed negative values in the cells where the actual salary is more than your budget, meaning bad, of course. Next to the salary budget columns, you will also find columns, which represent the breakdown of the actual salary, so that you can easily see the amounts paid to your staff for holidays, sickness, overtime, etc.
Daily Attendance table, displays the number of staff members in every department daily, which is intended to help you to see, if you have enough employees on the day.