This web page contains a live and functional spreadsheet created with
excelcrib.comr
. Please enable JavaScript in your web browser for the live calculations to work properly.
Home
Semi-monthly Tax Calculator
Effective: January 2018 to December 2022
Tax Table
1
2
3
4
5
6
Compensation
0 to
"-"
"-"
"-"
"-"
"-"
Range
10,416
16,666
33,332
83,332
333,332
500,000
Withholding
0.00 +
0.00 +
1,250.00 +
5,416.67 +
20,416.67 +
100,416.67 +
Tax
+0% over
+20% over
+25% over
+30% over
+32% over
+35% over
Half of Monthly Salary
Half of monthly salary
Overtime Pay:
SSS
SSS Deduction
No. of hours
Philhealth
Philhealth Deduction
Daily Rate
Pag-ibig Premium
Pag-ibig Deduction
Rate/hour
Anniversary Bonus
OT Rate/hour
13th Month Pay
Overtime pay
Other Adjustments
Input like perfect attendance bonus, performance bonus, etc.
OT Transpo Allow
Compensation
"-"
OT Meal Allow
range
"0"
Taxable Income
Withholding
"-"
tax
"-"
Total Tax
Total Tax
Take Home Pay
www.excelcrib.com
Update
Reset
Print