If you’re an HR officer, business owner, or employee who wants to easily compute 13th month pay, you’re in the right place! We’ve prepared a free Excel template that automatically calculates your 13th month pay based on your total basic salary — no need to do it manually!
📘 What Is 13th Month Pay?
In the Philippines, 13th month pay is a mandatory benefit required under Presidential Decree No. 851. All rank-and-file employees who have worked for at least one month are entitled to this additional compensation.
Formula:
13th Month Pay = (Total Basic Salary Earned for the Year ÷ 12)
📂 Download the Free Excel Template
You can download the 13th Month Pay Calculator Excel Template below and start computing right away.
👉 Download 13th Month Pay Excel Template (Free)
This Excel file automatically computes:
- Total Basic Salary per Month
- Number of Months Worked
- Automatic 13th Month Pay Computation
- Adjustment for Absences and Lates
🧠 How to Use the 13th Month Pay Excel Template
- Open the Excel File – After downloading, open the template on Microsoft Excel or Google Sheets.
- Enter Monthly Salary – Input the employee’s monthly basic pay in the corresponding cells.
- Input the Number of Months Worked – Enter how many months the employee worked during the year.
- View Computed 13th Month Pay – The calculator automatically displays the computed 13th month pay!
🧾 Example Computation
| Employee | Basic Monthly Salary | Months Worked | 13th Month Pay |
|---|---|---|---|
| Juan Dela Cruz | ₱20,000 | 12 | ₱20,000 |
| Maria Santos | ₱15,000 | 6 | ₱7,500 |
💡 Why Use an Excel Calculator?
- ✅ Free and easy to use
- ✅ No coding or formula setup needed
- ✅ Perfect for SMEs and HR departments
- ✅ Helps ensure compliance with DOLE guidelines
🧩 Alternative Online Calculator
If you prefer to calculate instantly online, try our 13th Month Pay Calculator Philippines 2025 — no download required!
🏁 Key Takeaway
Whether you’re an employee verifying your pay or an HR computing benefits, our 13th Month Pay Excel Template helps you save time and avoid errors.
👉 Download for Free and get accurate results in seconds!