13th Month Report Breakdown

Overview

The 13th Month Report Breakdown provides a detailed computation and summary of each employee’s 13th Month Pay based on all processed payroll runs within the calendar year. It consolidates payroll components such as basic salary, adjustments, allowances, and other taxable and non-taxable earnings to ensure transparency and traceability of the computed 13th Month Pay.

Accessing the Report

Users can access the report in two ways, depending on whether it is during or outside the 13th Month Pay run:

A. During 13th Month Pay Run

Path:
Download Reports > 13th Month Report Breakdown

B. Payroll Reports (Historical or Ad Hoc Downloads)

Path:
Reports > Payroll > 13th Month Report Breakdown

Report Description

The 13th Month Report Breakdown file lists employee-level payroll data used in the computation of 13th Month Pay. It includes payroll components from January to December within the selected year and shows both monthly and cumulative totals.

Each record reflects amounts derived from actual payroll runs within the year.

Report Columns

Column Name	Description
Employee Number	Unique identifier of the employee.
Employee Name	Full name of the employee.
Department	Employee’s assigned department.
Position	Employee’s job title or position.
Year	Calendar year of the payroll period covered.
Period	Payroll period number for the given month.
Payroll Run Type	Type of payroll run (e.g., Normal Payroll, Adjustment).
Basic	Employee’s basic pay for the payroll run.
Absent Deduction	Deductions for absences during the period.
Late/Undertime Deduction	Deductions for late arrivals or undertime.
Basic Adjustment	Adjustments applied to basic pay.
Salary Adjustment	Salary-related adjustments outside of basic pay.
De Minimis	Regular non-taxable benefits classified as de minimis.
De Minimis Allowance	Allowances under de minimis classification.
De Minimis Adjustment	Adjustments made to de minimis benefits.
DM Absent Deduction	Deductions against de minimis benefits due to absences.
Overtime	Overtime pay for the period.
Allowance	Regular taxable allowance.
Allowance Deduction	Deductions from allowances.
Daily Allowance	Daily allowance entitlement.
Daily Allowance Absent Deduction	Deductions on daily allowance due to absences.
Reimbursable Allowance	Non-taxable allowances or reimbursements.
Bonus	Any other bonus included in payroll runs.
Commission	Commission income earned during the period.
Other Taxable Income	Other taxable income not categorized above.

Note:
The breakdown reflects values based on processed payroll runs only.
Reference fields like “Advanced - Actual Basic” and “Current - Recent Basic for all months” are for internal calculation tracking and not included in the final report file.

Sample Computation Summary

At the end of the report, the following summary computations are presented:

Computation Line Item	Description	Example Value
Total (All Periods)	Sum of all processed payroll run data from January to December.	₱1,181,232.00
Gross 13th Month Pay	(Total Monthly Basic Pay for the Year ÷ 12)	₱98,436.00
Taxable 13th Month Pay	Portion exceeding ₱90,000 ceiling, if applicable.	₱8,436.00
Tax (if applicable)	Computed withholding tax for taxable portion.	₱2,952.60
Net Total 13th Month Amount	Gross 13th Month – Tax	₱95,483.40

Summary Section

The Summary section provides a high-level breakdown of 13th Month computation results after accounting for previously released amounts and applicable taxes.

Summary Field	Description	Example Value
Previously Released 13th Month	Total 13th Month amounts already paid (from prior runs or adjustments).	₱30,000.00
Non-Taxable 13th Month Pay	Portion within the ₱90,000 non-taxable ceiling (net of previously released).	₱60,000.00
Taxable 13th Month Pay	Amount exceeding ₱90,000.00	₱8,436.00
Tax	Tax computed for taxable portion.	₱2,952.60
13th Month to be Released	Net amount remaining for release (Gross – Tax – Previously Released).	₱65,483.40

If the taxable amount is negative, zero (₱0.00) will be displayed.

Important Notes

Taxable and non-taxable components are automatically computed based on the ₱90,000 ceiling threshold.
Any 13th Month payments or adjustments processed within the same calendar year are reflected in the “Previously Released 13th Month” section.
The report is intended for reference and audit purposes; all final amounts are based on system-calculated payroll data.