[HappyTime] Mẫu bảng lương nhân viên theo tháng.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
2	MẪU BẢNG LƯƠNG DÀNH CHO DOANH NGHIỆP
3	THÁNG... NĂM...
4
5	STT	Mã nhân viên	Họ và tên	Chức vụ	Lương chính	Phụ cấp					Thu Nhập Danh Nghĩa	Ngày công thực tế	Tổng lương thực tế	Lương đóng bảo hiểm	Các khoản trích vào chi phí doanh nghiệp					Các khoản trích trừ vào lương				Thuế TNCN	Tạm ứng	Thực lĩnh	Ghi chú
6	STT	Mã nhân viên	Họ và tên	Chức vụ	Lương chính	Trách nhiệm	Ăn trưa	Điện thoại	Xăng xe	Hỗ trợ khác	Thu Nhập Danh Nghĩa	Ngày công thực tế	Tổng lương thực tế	Lương đóng bảo hiểm	KPCĐ (2%)	BHXH (17,5%)	BHYT (3%)	BHTN (1%)	Tổng	BHXH (8%)	BHYT (1,5%)	BHTN (1%)	Tổng	Thuế TNCN	Tạm ứng	Thực lĩnh	Ghi chú
7	A	Bộ phận Quản lý			18,000,000	6,000,000	3,600,000	900,000	750,000	4,600,000	33,850,000	75	35,479,167	24,000,000	480,000	4,200,000	720,000	240,000	5,640,000	1,920,000	360,000	240,000	2,520,000	123,667	100,000	32,735,500
8	01	TOPCV001	Nguyễn Văn A	GĐ	7,000,000	3,000,000	1,500,000	400,000	350,000	1,590,000	13,840,000	26	14,993,333	10,000,000	200,000	1,750,000	300,000	100,000	2,350,000	800,000	150,000	100,000	1,050,000	123,667		13,819,667
9	02	TOPCV002	Nguyễn Thị B	PGĐ	6,000,000	2,000,000	1,200,000	300,000	250,000	1,670,000	11,420,000	25	11,895,833	8,000,000	160,000	1,400,000	240,000	80,000	1,880,000	640,000	120,000	80,000	840,000		100,000	10,955,833
10	03	TOPCV003	Phạm Đức C	TK	5,000,000	1,000,000	900,000	200,000	150,000	1,340,000	8,590,000	24	8,590,000	6,000,000	120,000	1,050,000	180,000	60,000	1,410,000	480,000	90,000	60,000	630,000			7,960,000
11	...	...
12	B	Bộ phận Hành chính - Nhân sự			44,000,000	1,200,000	6,150,000	2,050,000	1,100,000	10,250,000	64,750,000	238	64,462,500	45,200,000	904,000	7,910,000	1,356,000	452,000	10,622,000	3,616,000	678,000	452,000	4,746,000	0	1,500,000	58,216,500
13	01	TOPCV004	Trần Xuân D	TP	5,300,000	1,200,000	750,000	250,000	200,000	1,250,000	8,950,000	26	9,695,833	6,500,000	130,000	1,137,500	195,000	65,000	1,527,500	520,000	97,500	65,000	682,500			9,013,333
14	02	TOPCV005	Lý Thị E	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	24	6,200,000	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500		200,000	5,548,500
15	03	TOPCV006	Lê Quang G	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	22	5,683,333	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500			5,231,833
16	04	TOPCV007	Trần Văn Đ	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	21	5,425,000	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500		100,000	4,873,500
17	05	TOPCV008	Nguyễn Thị Thanh N	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	22	5,683,333	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500		750,000	4,481,833
18	06	TOPCV009	Phạm Văn S	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	26	6,716,667	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500			6,265,167
19	07	TOPCV010	Trần Văn N	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	25	6,458,333	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500		200,000	5,806,833
20	08	TOPCV011	Lê Quang G	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	22	5,683,333	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500			5,231,833
21	01	TOPCV012	Quách Thị T	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	24	6,200,000	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500			5,748,500
22	02	TOPCV013	Trịnh Thăng B	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	26	6,716,667	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500		250,000	6,015,167
23	...	...
24	C	Bộ phận Bán Hàng			44,000,000	1,200,000	6,150,000	2,050,000	1,100,000	10,250,000	64,750,000	239	64,491,667	45,200,000	904,000	7,910,000	1,356,000	452,000	10,622,000	3,616,000	678,000	452,000	4,746,000	0	1,800,000	57,945,667
25	01	TOPCV014	Phan Văn M	TP	5,300,000	1,200,000	750,000	250,000	200,000	1,250,000	8,950,000	24	8,950,000	6,500,000	130,000	1,137,500	195,000	65,000	1,527,500	520,000	97,500	65,000	682,500			8,267,500
26	02	TOPCV015	Trần Hoàn N	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	26	6,716,667	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500		250,000	6,015,167
27	03	TOPCV016	Nguyễn Thu H	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	24	6,200,000	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500			5,748,500
28	04	TOPCV017	Lê Hà D	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	26	6,716,667	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500		500,000	5,765,167
29	05	TOPCV018	Phạm Thị Thuỳ T	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	25	6,458,333	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500			6,006,833
30	06	TOPCV019	Bùi Văn T	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	21	5,425,000	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500		200,000	4,773,500
31	07	TOPCV020	Lê Thành K	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	22	5,683,333	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500			5,231,833
32	08	TOPCV021	Trần Quỳnh N	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	25	6,458,333	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500		100,000	5,906,833
33	09	TOPCV022	Nguyễn Phúc M	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	20	5,166,667	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500		750,000	3,965,167
34	10	TOPCV023	Phạm Thuỳ Y	NV	4,300,000		600,000	200,000	100,000	1,000,000	6,200,000	26	6,716,667	4,300,000	86,000	752,500	129,000	43,000	1,010,500	344,000	64,500	43,000	451,500			6,265,167
35	...	...
36	Tổng				106,000,000	8,400,000	15,900,000	5,000,000	2,950,000	25,100,000	163,350,000	552	164,433,333	114,400,000	2,288,000	20,020,000	3,432,000	1,144,000	26,884,000	9,152,000	1,716,000	1,144,000	12,012,000	123,667	3,400,000	148,897,667
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