Employee Work Schedule

Stampa

 

Download here your Excel file. Test it on your computer. Use it or simply delete it.
 
The system consists of - 5 levels - for the initial configuration and use. 
For more than 7 or 11 employees you can use several copies of the system.

Here what you'll find: 

Panoramica fogli payroll
 
I : \ REGISTER /
Fill in according to directions by the same sheet.         
 
PAYROLL REGISTER1
 
 
II : \ CALENDAR and EXTRA /
Update the calendar as you need; fix here public holiday - PH -  and enter other information, which are initial claims for the current year. EXTRA are more informations managed by the system (eg, holidays / sick leave / etc) and they may be absences or other records that respond to practical needs.
 
PAYROLL CALENDAR11
 
         
III : Filling employee Journal  -  \ EMP # /
Every employee has his own presence Journal (EMP 1 / EMP 2 / etc.). Each sheet already shows normal values (previously entered) and therefore you must fill in only if there are NOT ORDINARY time to report or in case you want to report some EXTRA. On ordinary days, all sheets are already filled out. Each footer gives a brief summary of the current year. AVAILABLE 1 System with #7 Employees and 1 System with #11 Employees.
 
PAYROLL EMP JOURNAL2 PAYROLL EMP JOURNAL3 PAYROLL EMP JOURNAL4 PAYROLL EMP JOURNAL5 PAYROLL EMP JOURNAL6 PAYROLL EMP JOURNAL7
 
Example: 
PAYROLL EMP JOURNAL1
 
 
IV : EMPLOYEES ATTENDANCE BOOK - \ EMP BOOK /
As it has been previously entered for any EMP in his Journal, the system automatically collects all informations and displays them in the EMP BOOK. Not required any change in this sheet; you can only change the view option (1 or 2) or the order of the employees (the little red numbers).
 
View 1 and view 2:
PAYROLL BOOK1 PAYROLL BOOK121
 
         
V : \ STAFF COSTS /
Here you can enter your values for GROSS and NET pay and get the different values for a selected period (per hour, daily, weekly, monthly, annually). The system also takes into consideration same social costs (you can personalize), paid hollidays, overtime and other bonus.
 
Gross and Net overview:
PAYROLL STAFF1 PAYROLL STAFF2 
 
More configurations you change according to your needs:
PAYROLL STAFF EXTRA1 PAYROLL STAFF EXTRA2
 
Employee payroll 1 von 7 - View 1 and 2
PAYROLL STAFF3 PAYROLL STAFF321

 

Almost everything is controlled with drop-down menu:

Cattura1 Cattura2 Cattura3 Cattura4          

 

Download here your Excel file. Test it on your computer. Use it or simply delete it. 

MP - Questo indirizzo email è protetto dagli spambots. E' necessario abilitare JavaScript per vederlo.

 

 

 

 

 

 

        Marco Piccoli, tutti i diritti riservati.
Sunday the 16th.
Copyright 2012

©

Template © QualityJoomlaTemplates