reports46.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1				Payroll sheet for December 2015
2
3
4				Number of calendar days				31			Number of working days			23		Number of hours of the month			183			Minimum wage	$ 6 204,00
5
6
7	No.	Full name	Length in position	Accruals												Deductions									Scoop amount. income from the beginning of the year	Amount tax from beginning of the year	To issue
8
9
10				Salary	Number of work days	Fact. payment	Calculation for sick sheets		Vacation pay calculation		Length of service	Prize		Surcharge	Total accrued	Number of dependents	Privileges	Taxable amount	Income tax	By executing sheets	Trade union		Prepaid expense	Total withheld
11							Number of patients days	Accrued on used sheets	Number of vacation days	Accrued based on vacation pay.		%	Sum								Condition	Sum
12							Number of patients days	Accrued on used sheets	Number of vacation days	Accrued based on vacation pay.		%	Sum								Condition	Sum
13	1	Charlotte	8	20000,00	23	14838,71					1600,00	60%	8903,23	3561,29	28903,23	1	#REF!	#REF!	#REF!	#REF!	Not a member	#REF!	5935,48	#REF!	#REF!	#REF!	#REF!
14	2	Evelyn	7	17500,00	23	12983,87					1225,00	40%	5193,55	2726,61	22129,03	2	#REF!	#REF!	#REF!	#REF!	Not a member	#REF!	5193,55	#REF!	#REF!	#REF!	#REF!
15	3	Jacob	6	17500,00	23	12983,87					1050,00	40%	5193,55	2726,61	21954,03	1	#REF!	#REF!	#REF!	#REF!	Not a member	#REF!	5193,55	#REF!	#REF!	#REF!	#REF!
16	4	Sofia	5	16000,00	23	11870,97					800,00	45%	5341,94	2581,94	20594,84	1	#REF!	#REF!	#REF!	#REF!	Not a member	#REF!	4748,39	#REF!	#REF!	#REF!	#REF!
17	5
18	6
19	7
20	8
21	9
22	10
23	TOTAL			71000,00		52677,42	0,00	0,00	0,00	0,00	4675,00		24632,26	11596,45	93581,13		#REF!	#REF!	#REF!	#REF!		#REF!	21070,97	#REF!	#REF!	#REF!	#REF!
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100