About this product

Make payroll simple and error-free with this ready-to-use 13th Month Pay Excel template. Designed for HR, small business owners, payroll clerks, and freelancers — the sheet calculates 13th month pay automatically from your monthly basic salary inputs. No manual math, no guesswork.

What it does:

Calculates 13th month pay automatically from monthly basic salaries.

Handles employees who worked partial year (proration) by allowing zero/blank months or partial-month entries.

Shows clear breakdown: total basic income, 13th month amount, and printable summary per employee.

Protects formula cells so you don’t accidentally overwrite calculations (optional).

Easy to customize (add columns for allowances or deductions if you need them).