Jira & Confluence 
Bitrix24 01
Fill it in the browser
Type into the computation right on this page — no sign-up. Save it to a free Layers account to keep it.
- Works today Pages, spreadsheets and documents in the browser
Philippines · Due 24 December 2026
13th month pay computation 2026 — fill it in, print the payslips, pay by 24 December
Enter salaries right on the page — each 13th month pay is computed, printed and ready as an Excel file. Free, no sign-up.
Pay it on or before 24 December 2026. The computation is open below: type each employee's basic salary earned — the 13th month pay is the total ÷ 12, prorated for anyone who joined or left during the year.
| 13TH MONTH PAY 2026 — SETTINGS | ||
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. | ||
| Employer | Sampaguita Trading (sample) | |
| Calendar year | 2026 | |
| Pay on or before | 2026-12-24 | P.D. No. 851 and its rules: not later than 24 December each year (DOLE labor advisories repeat the deadline). |
| Days left to the deadline (from today) | 66 | |
| Tax-exempt ceiling for 13th month + other benefits (PHP) | 90,000 | NIRC Sec. 32(B)(7)(e) as amended by TRAIN (RA 10963): ₱90,000. Proposals to raise it (e.g. ₱150,000) are not law as of October 2026 — check BIR. |
| Report of compliance to DOLE due | 2027-01-15 | Usual DOLE requirement: compliance report by 15 January of the next year — check the current labor advisory. |
| Who gets it: all rank-and-file employees who worked at least one month in the year, regardless of how they are paid (monthly, daily, piece rate). Resigned or separated employees get a prorated amount. | ||
| What counts: basic salary actually earned, including paid leave. Usually excluded: overtime, night differential, holiday premium, allowances, cash value of unused leave — unless your company treats them as basic pay. | ||
| Formula: 13th month pay = total basic salary earned during the calendar year ÷ 12. | ||
| © Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers. | ||
| 13TH MONTH PAY — MONTHLY-PAID EMPLOYEES (basic salary actually earned each month) | ||||||||||||||||||||||
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. | ||||||||||||||||||||||
| Employee | Monthly basic (PHP) | Date hired | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Unpaid absences (PHP) | Total basic earned | 13th month pay | Advanced (e.g. June) | Balance to pay by 24 Dec | Other bonuses this year | Tax-exempt part | Taxable excess |
| Santos, Maria L. | 25,000.00 | 2019-03-01 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 25,000 | 300,000.00 | 25,000.00 | 12,500.00 | 12,500.00 | 25,000.00 | - | ||
| Reyes, Jose P. | 18,000.00 | 2026-04-16 | 9,000 | 18,000 | 18,000 | 18,000 | 18,000 | 18,000 | 18,000 | 18,000 | 18,000 | 153,000.00 | 12,750.00 | 12,750.00 | 12,750.00 | - | ||||||
| Cruz, Ana B. | 32,000.00 | 2021-06-01 | 32,000 | 32,000 | 32,000 | 32,000 | 32,000 | 32,000 | 32,000 | 32,000 | 32,000 | 32,000 | 32,000 | 32,000 | 1,454.55 | 382,545.45 | 31,878.79 | 16,000.00 | 15,878.79 | 31,878.79 | - | |
| Garcia, Mark T. | 120,000.00 | 2015-01-05 | 120,000 | 120,000 | 120,000 | 120,000 | 120,000 | 120,000 | 120,000 | 120,000 | 120,000 | 120,000 | 120,000 | 120,000 | 1,440,000.00 | 120,000.00 | 120,000.00 | 5,000.00 | 90,000.00 | 35,000.00 | ||
| Bautista, Liza R. | 21,000.00 | 2023-09-01 | 21,000 | 21,000 | 21,000 | 21,000 | 21,000 | 21,000 | 21,000 | 147,000.00 | 12,250.00 | 12,250.00 | 12,250.00 | - | ||||||||
| - | - | - | - | - | ||||||||||||||||||
| - | - | - | - | - | ||||||||||||||||||
| TOTAL | 2,422,545.45 | 201,878.79 | 28,500.00 | 173,378.79 | 5,000.00 | 171,878.79 | 35,000.00 | |||||||||||||||
| Months: type the basic salary actually earned (a new hire's first half-month, a resigned employee's last months = 0). Sample: Reyes hired 16 April; Bautista resigned 31 July (prorated). | ||||||||||||||||||||||
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. | ||||||||||||||||||||||
| © Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers. |
| 13TH MONTH PAY — DAILY-PAID AND MINIMUM-WAGE EMPLOYEES (days actually paid each month) | |||||||||||||||||
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. | |||||||||||||||||
| Employee | Daily rate (PHP) | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Days paid | Total basic earned | 13th month pay | Balance to pay |
| Mendoza, Rico A. | 695.00 | 26 | 24 | 26 | 25 | 26 | 25 | 27 | 26 | 25 | 26 | 25 | 22 | 303 | 210,585.00 | 17,548.75 | 17,548.75 |
| Flores, Joy C. | 645.00 | 20 | 26 | 26 | 25 | 26 | 25 | 22 | 170 | 109,650.00 | 9,137.50 | 9,137.50 | |||||
| - | - | - | - | ||||||||||||||
| - | - | - | - | ||||||||||||||
| TOTAL | 320,235.00 | 26,686.25 | 26,686.25 | ||||||||||||||
| Daily rate × days actually paid (include paid regular holidays and paid leave). Rates in the sample are illustrative — use your region's current wage order. | |||||||||||||||||
| © Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers. |
| 13TH MONTH PAY SLIP | |
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. | |
| Employee (choose) | Santos, Maria L. |
| Employer | Sampaguita Trading (sample) |
| Year | 2026 |
| Total basic salary earned | 300,000.00 |
| 13th month pay (÷ 12) | 25,000.00 |
| Less: advanced earlier | 12,500.00 |
| AMOUNT PAID NOW | 12,500.00 |
| Tax-exempt part (13th + other benefits up to the ceiling) | 25,000.00 |
| Pay date | 24 December 2026 |
| Received by: ____________________ Date: __________ | |
| © Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers. |
Start typing right in the document — no sign-up. It stays in this browser; save it to your free Layers account to keep it, open it on your phone and share it.
- 1Fill in. Type into the 13th month pay computation right here on the page — no sign-up, nothing to install.
- 2Print or download. Print it in one click, or download the Excel file to keep and edit.
- 3Send. Print the 13th month payslips for signature and keep a copy for DOLE.
- 4Deadline. Pay on or before 24 December 2026; the DOLE 13th month pay report is due by 15 January 2027.
Your numbers
Your 13th month pay for 2026 — computed
Salary, start date, a raise if you had one, and any advance. The total is 1/12 of the basic salary earned January to December.
Download Excel computation Download the acknowledgment receipt (Word) Save + reminder before 24 December
- HR: pay by 24 December 2026 and have the employee sign the acknowledgment receipt — keep it with payroll.
- Employee: not paid by 24 December — a written request to HR, then DOLE (SEnA).
- Reminders worth setting: 1 December (prepare payroll), 20 December, 24 December.
Rules: 13th month = 1/12 of the basic salary earned within the calendar year (P.D. 851 rules, Sec. 2(a)); due not later than 24 December (Memorandum Order No. 28, 1986); tax-exempt up to ₱90,000 together with other benefits (NIRC Sec. 32(B)(7)(e), R.A. 10963). Allowances not integrated into basic salary are excluded.
What is inside
The Excel file, sheet by sheet
Monthly-paid
Basic salary earned each month, unpaid absences, total ÷ 12, advance paid in June, balance to pay.
Daily-paid
Daily rate × days actually paid each month ÷ 12 — for minimum-wage and daily workers.
Tax
13th month + other benefits up to ₱90,000 tax-exempt; the excess flagged as taxable.
Payslip
Choose an employee — the 13th month pay slip is ready to print and sign.
Yellow cells are for you to type, blue cells are calculated. Ordinary formulas, no macros — opens in Excel, Google Sheets and LibreOffice. Licence CC BY 4.0 · © Layers (layers.md).
How to use it
Five steps
1
List employees
Everyone rank-and-file who worked at least one month in 2026, including those who resigned.
2
Basic salary earned
Type the basic pay actually earned each month — zero before hiring or after leaving.
3
Deduct unpaid absences
Leave without pay reduces basic salary earned; paid leave does not.
4
Advances
If you paid half in June, type it — the balance is what you pay in December.
5
Pay and report
Pay by 24 December; keep the payslips; submit the compliance report to DOLE as required.
What people do next
Year-end payroll
Annualized tax and BIR Form 2316 come next — the 13th month pay above ₱90,000 is part of taxable compensation.
Share with your accountant
One folder with payroll, payslips and the DOLE report.
What Layers does with it
Honest status: Works today is live now; Coming is not yet.
02
The real Excel file
Formulas, checks and print layout in .xlsx — opens in Excel, Google Sheets and LibreOffice.
- Works today Download as .xlsx
03
Share and work together
One folder for the team: everyone sees the latest version; comments instead of e-mail threads.
- Works today Drive with shared folders, chat, calls
04
Edit the Excel file in Layers
Open the .xlsx in the Layers spreadsheet editor with formulas, without Microsoft Office.
- Works today For signed-in users
- Coming Right on this page, without an account
Questions
How is 13th month pay computed?
Total basic salary earned from January to December ÷ 12 (P.D. No. 851). An employee who earned ₱300,000 basic in 2026 gets ₱25,000.
How do I compute it for an employee who worked only 6 months?
Add the basic salary earned in those months and divide by 12: ₱18,000 × 6 = ₱108,000 ÷ 12 = ₱9,000.
Is 13th month pay taxable?
It is tax-exempt together with other benefits up to ₱90,000 a year (NIRC as amended by the TRAIN law). Only the excess is taxable. Proposals to raise the ceiling were not law as of October 2026 — check BIR before you compute.
Can I still receive 13th month pay after resignation?
Yes. An employee who resigned or was separated during the year gets 13th month pay in proportion to the basic salary earned up to the last day (P.D. No. 851 rules) — usually released with the final pay.
When is the deadline?
On or before 24 December each year. Employers may pay half before the school opening in June and the rest by 24 December.
What is included in basic salary?
Basic pay actually earned, including paid leave. Overtime, night differential, holiday premium, allowances and cash conversion of unused leave are usually excluded unless your company treats them as basic pay.
More free Excel templates
Keep it, share it, open it on your phone
The template and the editor are free. Layers is free for teams of up to 20 people.
Templates are starting points. Check figures and rules with your accountant, engineer or the agency concerned. Layers is an independent product.