13th Month Pay Calculator Philippines
Are you a Filipino worker wondering how much is my 13th month pay calculator or magkano ang 13th month pay calculator? The 13th month pay is a mandatory end-of-year bonus under Presidential Decree No. 851, ensuring rank-and-file employees get at least 1/12 of their annual basic salary by December 24. In 2025, with no major changes from DOLE, this tax-free perk (up to PHP 90,000) remains a holiday highlight, but prorated amounts apply for partial-year work, absences, or resignations. This guide covers the 13th month pay calculator with absences, prorated, with tax, and DOLE rules, including how to compute 13th month pay calculator, paano mag compute ng 13th month pay calculator, and ano ang 13th month pay calculator. Use our formulas and examples to estimate your payout—perfect for budgeting or HR compliance. Also Check out: Metrobank Car Loan Calculator
What Is 13th Month Pay and Who Qualifies?
The 13th month pay calculator estimates your bonus as 1/12 of total basic salary earned in a calendar year. It’s for private-sector rank-and-file employees who worked at least one month, including full-time, part-time, or probationary workers. Managers and supervisors are excluded unless company policy includes them.
Key DOLE rules for 2025:
- Paid by December 24.
- Based on basic salary only—no allowances, overtime, holiday pay, or bonuses (unless integrated via agreement).
- Prorated for less than 12 months or unpaid absences.
- Tax-exempt up to PHP 90,000; excess taxed as income.
If unpaid, report to DOLE hotline 1349—fines apply to non-compliant employers.
13th Month Pay Calculator Formula: Basic Computation
The how to compute 13th month pay calculator starts simple:
13th Month Pay = (Total Basic Salary Earned in the Year) / 12
For full-year workers: Total Basic = Monthly Basic Salary × 12.
Example: PHP 20,000 monthly basic = PHP 240,000 annual / 12 = PHP 20,000 13th month.
For 13th month pay calculator per day or with absences: Use actual earnings, deducting unpaid days.
Prorated 13th Month Pay Calculator: For Partial Year or Absences
A prorated 13th month pay calculator or how to compute pro rated 13th month pay calculator adjusts for incomplete service. DOLE counts months with at least one day worked; unpaid absences reduce total salary.
Formula: Prorated 13th Month = (Monthly Basic Salary × Months Worked) / 12
- Months worked: Full or partial (e.g., July hire = 6 months).
- For absences: Compute daily rate = Monthly Salary / 26 (or 365/12 for annual); deduct unpaid days.
Example from DOLE: Employee with PHP 30,000 monthly, hired April (9 months): (30,000 × 9) / 12 = PHP 22,500.
With absences: PHP 15,000 monthly, 5 unpaid days in year (daily rate PHP 577): Annual basic = (15,000 × 12) – (577 × 5) = PHP 179,115 / 12 = PHP 14,926.
For 13th month pay calculator with absences: Track via payroll—30 days (including breaks) qualifies a month.
| Scenario |
Monthly Basic (PHP) |
Months/Adjustments |
Prorated 13th (PHP) |
| Full Year |
25,000 |
12 months |
25,000 |
| Partial Year |
25,000 |
6 months |
12,500 |
| With 10 Unpaid Days |
25,000 |
12 months – PHP 962 deduction |
24,038 |
13th Month Pay Calculator with Tax: After Exemption
The 13th month pay calculator with tax applies only over PHP 90,000—most get it tax-free under TRAIN Law. Excess is taxed at your income bracket (0-35%).
Formula: Taxable = 13th Month – 90,000 (if positive); Total Tax = Taxable × Bracket Rate.
Example: PHP 100,000 13th month, 20% bracket: PHP 10,000 taxable × 20% = PHP 2,000 tax; Net = PHP 98,000.
For 13th month pay calculator dole, report compliance by January 15, 2026—exemptions don’t change.
13th Month Pay Calculator Excel: DIY Template
A 13th month pay calculator excel automates via spreadsheet:
- Cell A1: Monthly Basic Salary.
- A2: Months Worked (1-12).
- A3: Total Basic = A1 × A2.
- A4: 13th Month = A3 / 12.
- A5: Taxable = MAX(A4 – 90000, 0).
- A6: Tax (e.g., =A5 × 0.20 for 20% bracket).
- A7: Net = A4 – A6.
For absences: Add column for unpaid days, deduct (A1 / 26 × days). Download free templates or build in Google Sheets for prorated 13th month pay calculator philippines.
Regional and Special Cases: Paano Ang 13th Month Pay Calculator
For Tagalog queries like paano ang 13th month pay calculator or how to solve 13th month pay calculator:
- Ano ang 13th month pay calculator? Ito ay tool na nagko-compute ng bonus mo base sa basic salary, prorated kung hindi full year.
- Include maternity pay differentials if integrated.
- Resigned employees: Prorated up to separation date.
For daily wage earners: Use equivalent monthly rate (daily × 365 / 12).
Tips to Maximize and Verify Your 13th Month Pay
- Track attendance—use apps for accurate prorated 13th month pay calculator with absences.
- Request payslip breakdowns—ensure basic salary integration.
- For Excel: Add formulas for tax brackets (0% under 250K annual).
- File DOLE complaint if shorted—recovery possible via NLRC.
- Plan ahead: Combine with Christmas bonus (non-integrated) for tax-free up to PHP 90,000 total.
FAQs
How to Compute 13th Month Pay Calculator?
Total Basic Salary / 12. For prorated: (Monthly × Months) / 12; deduct unpaid absences via daily rate.
Prorated 13th Month Pay Calculator Philippines?
For partial year: (Basic Salary × Months Worked) / 12. Counts any day worked per month.
13th Month Pay Calculator with Absences?
Deduct unpaid days from annual basic: Daily Rate = Monthly / 26; then /12.
How Much Is My 13th Month Pay Calculator?
Input your annual basic into the formula—e.g., PHP 300,000 / 12 = PHP 25,000 (tax-free if under 90K).
Paano Mag Compute ng 13th Month Pay Calculator?
Gamitin ang formula: (Sweldo × Buwan) / 12; bawas ang hindi bayad na absences.
Ano Ang 13th Month Pay Calculator?
Isang calculator para sa bonus na katumbas ng 1/12 ng basic salary mo taun-taon.
How to Calculate 13 Months?
“13 months” refers to the 12 months of regular salary plus the 13th month pay as a year-end bonus. Calculate it by totaling your annual basic salary (Monthly Basic × 12) and adding the 13th month pay (Annual Basic / 12). For example, with a PHP 15,000 monthly basic: Annual = PHP 180,000; 13th month = PHP 15,000; Total = PHP 195,000 for the year. For partial years or absences, prorate by months worked: (Monthly Basic × Months) / 12. Ensure you include only basic salary, per DOLE guidelines.
How to Calculate Bonus Pay?
In the Philippines, the 13th month pay is the mandatory “bonus” for rank-and-file employees, calculated as above. Other bonuses (e.g., performance, Christmas) depend on company policy and aren’t guaranteed. For non-mandatory bonuses, use: Bonus Pay = Gross Bonus – Taxes (if over PHP 90,000 combined with 13th month). For example, a PHP 20,000 company bonus + PHP 20,000 13th month = PHP 40,000 (tax-free). If taxable, apply your income bracket (e.g., 20% on excess). Always check if bonuses are fixed or performance-based and exclude non-basic pay elements like allowances.
How Is 13th Month Pay Calculated for Resigned Employees in the Philippines?
For resigned employees, the 13th month pay is prorated based on months worked in the year of resignation, as long as at least one month was served. Formula: Prorated 13th Month = (Monthly Basic Salary × Months Worked) / 12. A month counts if any day is worked. For example, an employee with a PHP 25,000 monthly basic who resigned after 7 months (January-July) gets: (25,000 × 7) / 12 = PHP 14,583. Unpaid absences deduct from total basic (Daily Rate = Monthly / 26). DOLE requires payment by December 24 or upon separation, whichever comes first, tax-free up to PHP 90,000.
