[Release Notes - External] New 13th Month Sample Computation

	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
1	Sample computation for 258 Factor rate Semi- Monthly Regular
2
3	Employee Name:	Employee		Employee Name:	Employee 1		Employee Name:	Employee 2			Employee Name:	Employee 3			Employee Name:	Employee 4			Employee Name:	Employee 5			Employee Name:	Employee 6
4	Hired Date:	January 4 2021		Hired Date:	January 1 2021		Hired Date:	January 4 2021			Hired Date:	June 1 2021			Hired Date:	June 7 2021			Hired Date:	December 1 2021			Hired Date:	December 20 2020
5	Factor rate:	0.00		Factor rate:	258.00		Factor rate:	258.00			Factor rate:	258.00			Factor rate:	258.00			Factor rate:	258.00			Factor rate:	258.00
6
7	Employee Profile			Employee Profile			Employee Profile		Basic Employee from YTD		Employee Profile		Basic Employee Proactive days		Employee Profile		Basic Employee Proactive days		Employee Profile		Basic Employee Proactive days		Employee Profile
8	Basic Salary:	30000.00		Basic Salary:	30000.00		Basic Salary:	30000.00	January	22500	Basic Salary:	75500.00	June	22	Basic Salary:	100000.00	June	18	Basic Salary:	25500.00	December	21	Basic Salary:	85000.00
9	Deminimis:	4100.00		Deminimis:	4100.00		Deminimis:	4100.00	February	22500	Deminimis:	4300.00	July	22	Deminimis:	4200.00	July	22	Deminimis:	4600.00		not include 24 and 31	Deminimis:	3900.00
10	Ecola:	700.00		Ecola:	700.00		Ecola:	700.00	March	22500	Ecola:	900.00	August	22	Ecola:	800.00	August	22	Ecola:	1200.00			Ecola:	500.00
11									April	22500			September	22			September	22
12	Note: Recurring Adjustment and One time adjustment is included in Employee 2 test data			Note: Recurring Adjustment and One time adjustment is included in Employee 1 test data			Note: Recurring Adjustment and One time adjustment is included in Employee 2 test data		May	22500	Note: Recurring Adjustment and One time adjustment is included in Employee 3 test data		October	21	Note: Recurring Adjustment and One time adjustment is included in Employee 4 test data		October	21	Note: Recurring Adjustment and One time adjustment is included in Employee 5 test data				Note: Recurring Adjustment and One time adjustment is included in Employee 6 test data
13	Note: Employee 2 is prorated Employee			Note: Employee 1 is prorated employee but the active days is same as tenured attendance			Note: Employee 2 is prorated Employee		June	30000	Note: Employee 3 is prorated Employee		November	21	Note: Employee 4 is prorated Employee		November	21	Note: Employee 5 is prorated Employee				Note: Employee 6 is tenured employee
14									July	30000			December	21			December	21
15	13TH MONTH RUN PAYSLIP			13TH MONTH RUN PAYSLIP			13TH MONTH RUN PAYSLIP		August	30000	13TH MONTH RUN PAYSLIP			151	13TH MONTH RUN PAYSLIP			147	13TH MONTH RUN PAYSLIP				13TH MONTH RUN PAYSLIP
16	COMPENSATION			COMPENSATION			COMPENSATION		September	30000	COMPENSATION				COMPENSATION				COMPENSATION				COMPENSATION
17	BASIC	0.00		BASIC	0.00		BASIC	0.00	October	30000	BASIC	0.00			BASIC	0.00			BASIC	0.00			BASIC	0.00
18	13th Month NonTaxable	46187.00		13th Month NonTaxable	46187.00		13th Month NonTaxable	46187.00	November	30000	13th Month NonTaxable	64794.26			13th Month NonTaxable	64794.26			13th Month NonTaxable	4330.60			13th Month NonTaxable	46187.00
19	13th Month Taxable	33439.59		13th Month Taxable	54260.20		13th Month Taxable	33536.05	December	30000	13th Month Taxable	6085.73			13th Month Taxable	19165.76							13th Month Taxable	103284.25
20
21
22	Monthly Basic	30000.00		Monthly Basic	30000.00		Monthly Basic	30000.00			Monthly Basic	75500.00			Monthly Basic	100000.00			Monthly Basic	25500.00			Monthly Basic	85000.00
23	DM Basic	4100.00		DM Basic	4100.00		DM Basic	4100.00			DM Basic	4300.00			DM Basic	4200.00			DM Basic	4600.00			DM Basic	3900.00
24	Ecola	8025.58		Ecola	6900.00	Sum of Ecola in YTD report	Ecola	8025.58	Sum of Ecola in YTD report		Ecola	5850.00	Sum of Ecola in YTD report		Ecola	5057.47	Sum of Ecola in YTD report		Ecola	600.00	Sum of Ecola in YTD report		Ecola	5750.00	Sum of Ecola in YTD report
25	Sum of Work month per year	0		Basic Adjustment	44450.00	Sum of Basic Adjustment Taxable and Non Taxable in YTD adjustment	Sum of Work month per year	12			Sum of Work month per year	12			Sum of Work month per year	12			Sum of Work month per year	12			Basic Adjustment	44450.00	Sum of Basic Adjustment Taxable and Non Taxable in YTD adjustment
26	Sum Of Work days per year	0		13th Month	2350.00	Sum of 13th month Adjustment Taxable and Non Taxablein YTD adjustment	Sum Of Work days per year	258			Sum Of Work days per year	258			Sum Of Work days per year	258			Sum Of Work days per year	258			13th Month	2350.00	Sum of 13th month Adjustment Taxable and Non Taxablein YTD adjustment
27	Prorated Active Days	0		Salary Adjustment	44450.00	Sum of Salary Adjustment Taxable and Non Taxable in YTD adjustment	Prorated Active Days	257	Note: 257 because of the hire date of employee 2		Prorated Active Days	151	Note: 151 because of the hire date of employee 3		Prorated Active Days	147	Note: 147 because of the hire date of employee 4		Prorated Active Days	21	Note: 257 because of the hire date of employee 5		Salary Adjustment	44450.00	Sum of Salary Adjustment Taxable and Non Taxable in YTD adjustment
28	Basic Adjustment	44450.00		Bonus Ceiling	41463.00		Basic Adjustment	44450.00	Sum of Basic Adjustment Taxable and Non Taxable in YTD adjustment		Basic Adjustment	25350.00	Sum of Basic Adjustment Taxable and Non Taxable in YTD adjustment		Basic Adjustment	25350.00	Sum of Basic Adjustment Taxable and Non Taxable in YTD adjustment		Basic Adjustment	2750.00	Sum of Basic Adjustment Taxable and Non Taxable in YTD adjustment		Bonus Ceiling	41463.00
29	13th Month	2350.00		Allowance	48711.63	Sum of Allowance Adjustment Taxable and Non Taxable in YTD adjustment not include the alllowance late	13th Month	2350.00	Sum of 13th month Adjustment Taxable and Non Taxablein YTD adjustment		13th Month	1350.00	Sum of 13th month Adjustment Taxable and Non Taxablein YTD adjustment		13th Month	1350.00	Sum of 13th month Adjustment Taxable and Non Taxablein YTD adjustment		13th Month	150.00	Sum of 13th month Adjustment Taxable and Non Taxablein YTD adjustment		Allowance	49950.00	Sum of Allowance Adjustment Taxable and Non Taxable in YTD adjustment not include the alllowance late
30	Salary Adjustment	44450.00		Other taxable income	44450.00	Sum of Other Taxable Income Adjustment Taxable and Non Taxable in YTD adjustment	Salary Adjustment	44450.00	Sum of Salary Adjustment Taxable and Non Taxable in YTD adjustment		Salary Adjustment	25350.00	Sum of Salary Adjustment Taxable and Non Taxable in YTD adjustment		Salary Adjustment	25350.00	Sum of Salary Adjustment Taxable and Non Taxable in YTD adjustment		Salary Adjustment	2750.00	Sum of Salary Adjustment Taxable and Non Taxable in YTD adjustment		Other taxable income	44450.00	Sum of Other Taxable Income Adjustment Taxable and Non Taxable in YTD adjustment
31	Bonus Ceiling	41463.00		Commission	54450.00	Sum of Commision Adjustment Taxable and Non Taxable in YTD adjustment	Bonus Ceiling	41463.00			Bonus Ceiling	23855.74			Bonus Ceiling	23855.74			Bonus Ceiling	0.00			Commission	54450.00	Sum of Commision Adjustment Taxable and Non Taxable in YTD adjustment
32	Allowance	48508.14		Bonus	41463.00	Sum of Bonus Adjustment Taxable and Non Taxable in YTD adjustment	Allowance	48508.14	Sum of Allowance Adjustment Taxable and Non Taxable in YTD adjustment not include the alllowance late		Allowance	29605.75	Sum of Allowance Adjustment Taxable and Non Taxable in YTD adjustment not include the alllowance late		Allowance	28620.12	Sum of Allowance Adjustment Taxable and Non Taxable in YTD adjustment not include the alllowance late		Allowance	1505.75	Sum of Allowance Adjustment Taxable and Non Taxable in YTD adjustment not include the alllowance late		Bonus	41463.00	Sum of Bonus Adjustment Taxable and Non Taxable in YTD adjustment
33	Other taxable income	44450.00		Overtime	174368.52	Sum of Overtime in YTD report	Other taxable income	44450.00	Sum of Other Taxable Income Adjustment Taxable and Non Taxable in YTD adjustment		Other taxable income	25350.00	Sum of Other Taxable Income Adjustment Taxable and Non Taxable in YTD adjustment		Other taxable income	25350.00	Sum of Other Taxable Income Adjustment Taxable and Non Taxable in YTD adjustment		Other taxable income	2750.00	Sum of Other Taxable Income Adjustment Taxable and Non Taxable in YTD adjustment		Overtime	287291.96	Sum of Overtime in YTD report
34	Commission	54450.00		OT Adjustment	44450.00	Sum of Overtime Adjustment Taxable and Non Taxable in YTD adjustment	Commission	54450.00	Sum of Commision Adjustment Taxable and Non Taxable in YTD adjustment		Commission	35350.00	Sum of Commision Adjustment Taxable and Non Taxable in YTD adjustment		Commission	35350.00	Sum of Commision Adjustment Taxable and Non Taxable in YTD adjustment		Commission	2750.00	Sum of Commision Adjustment Taxable and Non Taxable in YTD adjustment		OT Adjustment	44450.00	Sum of Overtime Adjustment Taxable and Non Taxable in YTD adjustment
35	Bonus	41463.00		Denimis allowance	43211.63	Sum of Deminimis Allowance Adjustment Taxable and Non Taxable in YTD adjustment	Bonus	41463.00	Sum of Bonus Adjustment Taxable and Non Taxable in YTD adjustment		Bonus	23855.74	Sum of Bonus Adjustment Taxable and Non Taxable in YTD adjustment		Bonus	23855.74	Sum of Bonus Adjustment Taxable and Non Taxable in YTD adjustment		Bonus	2750.00	Sum of Bonus Adjustment Taxable and Non Taxable in YTD adjustment		Denimis allowance	44450.00	Sum of Deminimis Allowance Adjustment Taxable and Non Taxable in YTD adjustment
36	Overtime	111549.70		Deminimis Adjustment	44450.00	Sum of Deminimis Adjustment Taxable and Non Taxable in YTD adjustment	Overtime	111549.70	Sum of Overtime in YTD report		Overtime	31681.03	Sum of Overtime in YTD report		Overtime	40409.48	Sum of Overtime in YTD report		Overtime	0.00	Sum of Overtime in YTD report		Deminimis Adjustment	44450.00	Sum of Deminimis Adjustment Taxable and Non Taxable in YTD adjustment
37	OT Adjustment	44450.00		Reimbursement allowance	48211.63	Sum of Reimbursement Adjustment Taxable and Non Taxable in YTD adjustment not include the reimbursable late	OT Adjustment	44450.00	Sum of Overtime Adjustment Taxable and Non Taxable in YTD adjustment		OT Adjustment	25350.00	Sum of Overtime Adjustment Taxable and Non Taxable in YTD adjustment		OT Adjustment	25350.00	Sum of Overtime Adjustment Taxable and Non Taxable in YTD adjustment		OT Adjustment	2750.00	Sum of Overtime Adjustment Taxable and Non Taxable in YTD adjustment		Reimbursement allowance	49450.00	Sum of Reimbursement Adjustment Taxable and Non Taxable in YTD adjustment not include the reimbursable late
38	Denimis allowance	43008.14					Denimis allowance	43008.14	Sum of Deminimis Allowance Adjustment Taxable and Non Taxable in YTD adjustment		Denimis allowance	24105.75	Sum of Deminimis Allowance Adjustment Taxable and Non Taxable in YTD adjustment		Denimis allowance	23120.12	Sum of Deminimis Allowance Adjustment Taxable and Non Taxable in YTD adjustment		Denimis allowance	1505.75	Sum of Deminimis Allowance Adjustment Taxable and Non Taxable in YTD adjustment
39	Deminimis Adjustment	44450.00					Deminimis Adjustment	44450.00	Sum of Deminimis Adjustment Taxable and Non Taxable in YTD adjustment		Deminimis Adjustment	25350.00	Sum of Deminimis Adjustment Taxable and Non Taxable in YTD adjustment		Deminimis Adjustment	25350.00	Sum of Deminimis Adjustment Taxable and Non Taxable in YTD adjustment		Deminimis Adjustment	2750.00	Sum of Deminimis Adjustment Taxable and Non Taxable in YTD adjustment
40	Reimbursement allowance	48008.14		(Basic + DM Basic)*12	409200.00		Reimbursement allowance	48008.14	Sum of Reimbursement Adjustment Taxable and Non Taxable in YTD adjustment not include the reimbursable late		Reimbursement allowance	29105.75	Sum of Reimbursement Adjustment Taxable and Non Taxable in YTD adjustment not include the reimbursable late		Reimbursement allowance	28120.12	Sum of Reimbursement Adjustment Taxable and Non Taxable in YTD adjustment not include the reimbursable late		Reimbursement allowance	1505.75	Sum of Reimbursement Adjustment Taxable and Non Taxable in YTD adjustment not include the reimbursable late		(Basic + DM Basic)*12	1066800.00
41		0.00		Sum of Basic + DM *12 + Ecola +Basic Adjsutment +Salary Adjustment + Allowance + Other Taxable Income + Commission +Bonus +Overtime+OT adjustment + Deminimis Allowance + Deminimis Adjustment + Reimbursable Allowance / 12	87397.20																		Sum of Basic + DM *12 + Ecola +Basic Adjsutment +Salary Adjustment + Allowance + Other Taxable Income + Commission +Bonus +Overtime+OT adjustment + Deminimis Allowance + Deminimis Adjustment + Reimbursable Allowance / 12	151821.25
42	(Basic + DM Basic)*11	375100.00					(Basic + DM Basic)Work month per year) / Work days per year ) Proactive days	407613.95			(Basic + DM Basic)Work month per year) / Work days per year ) Proactive days	560455.81			(Basic + DM Basic)Work month per year) / Work days per year ) Proactive days	712437.21			(Basic + DM Basic)Work month per year) / Work days per year ) Proactive days	29400.00
43	Sum of Basic + DM Basic)*11 + Ecola +Basic Adjsutment +Salary Adjustment + Allowance + Other Taxable Income + Commission +Bonus +Overtime+OT adjustment + Deminimis Allowance + Deminimis Adjustment + Reimbursable Allowance	952362.70					Sum of Basic + DM Basic)Work month per year) / Work days per year ) Proactive days+ Ecola +Basic Adjsutment +Salary Adjustment + Allowance + Other Taxable Income + Commission +Bonus +Overtime+OT adjustment + Deminimis Allowance + Deminimis Adjustment + Reimbursable Allowance / 12	82073.05			Sum of Basic + DM Basic)Work month per year) / Work days per year ) Proactive days+ Ecola +Basic Adjsutment +Salary Adjustment + Allowance + Other Taxable Income + Commission +Bonus +Overtime+OT adjustment + Deminimis Allowance + Deminimis Adjustment + Reimbursable Allowance / 12	72229.99			Sum of Basic + DM Basic)Work month per year) / Work days per year ) Proactive days+ Ecola +Basic Adjsutment +Salary Adjustment + Allowance + Other Taxable Income + Commission +Bonus +Overtime+OT adjustment + Deminimis Allowance + Deminimis Adjustment + Reimbursable Allowance / 12	85310.02			Sum of Basic + DM Basic)Work month per year) / Work days per year ) Proactive days+ Ecola +Basic Adjsutment +Salary Adjustment + Allowance + Other Taxable Income + Commission +Bonus +Overtime+OT adjustment + Deminimis Allowance + Deminimis Adjustment + Reimbursable Allowance / 12	4480.60
44
45
46
47
48
49				Sum - 13th month	85047.20																		Sum - 13th month	149471.25
50				Bonus Ceiling + 13th month	43813.00																		Bonus Ceiling + 13th month	43813.00
51				Total Sum	128860.20																		Total Sum	193284.25
52	(Sum + prorated Basic + Prorated DM in January ) /12 - 13th month	79626.59		Total Sum - (90k Ceiling)	38860.20	13th Month Taxable	Sum - 13th month	79723.05			Sum - 13th month	70879.99			Sum - 13th month	83960.02			Sum - 13th month	4330.60	13th Month NonTaxable		Total Sum - (90k Ceiling)	103284.25	13th Month Taxable
53	Bonus Ceiling + 13th month	43813.00		Sum - 13th Month Taxable	46187.00	13th Month NonTaxable	Bonus Ceiling + 13th month	43813.00			Bonus Ceiling + 13th month	25205.74			Bonus Ceiling + 13th month	25205.74							Sum - 13th Month Taxable	46187.00	13th Month NonTaxable
54	Total Sum	123439.59					Total Sum	123536.05			Total Sum	96085.73			Total Sum	109165.76
55	Total Sum - (90k Ceiling)	33439.59	13th Month Taxable				Total Sum - (90k Ceiling)	33536.05	13th Month Taxable		Total Sum - (90k Ceiling)	6085.73	13th Month Taxable		Total Sum - (90k Ceiling)	19165.76	13th Month Taxable
56	Sum - 13th Month Taxable	46187.00	13th Month NonTaxable				Sum - 13th Month Taxable	46187.00	13th Month NonTaxable		Sum - 13th Month Taxable	64794.26	13th Month NonTaxable		Sum - 13th Month Taxable	64794.26	13th Month NonTaxable
57
58		Basic	Deminimis
59	January	27586.2069	3770.114943
60	February	30000	4100
61	March	30000	4100
62	April	30000	4100
63	May	30000	4100
64	June	30000	4100
65	July	30000	4100
66	August	30000	4100
67	September	30000	4100
68	October	30000	4100
69	November	30000	4100
70	December	30000	4100
71		1379.310345	188.5057471
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