Alphalist Breakdown
The Alphalist Breakdown is the per-employee drill from the Alphalist Report. For one employee's year it shows, line by line, exactly how their annual BIR figures were built β every posted payroll cutoff behind the numbers, the figures mapped to their BIR 1604-C / 2316 item numbers, and (when it applies) a released final pay settlement folded into the certificate. A set of computation checks re-verifies the identities in your browser, so you can confirm the annual statement ties out before you file.
Accessing the Breakdown
- Open the Alphalist Report and set the Year
- Click any employee's row
The breadcrumb reads Manpower βΊ Reports βΊ Alphalist Report (1604-C) βΊ [Employee Name]. Use Back at the top of the page to return to the report at the same year.
Clicking a row on the Annualization Report lands here too. Both reports run the same year-end computation, so rather than keeping two detail views that could drift apart, they share one. The columns the Annualization table does not show β the employee-share government contributions, and the BIR bracket arithmetic behind the annualized tax β are on this page: the contributions under Non-taxable / Exempt (Item 38), and the bracket computation directly beneath Annual tax due (Item 24) in Tax Reconciliation.
Employee Details
The top of the page identifies the employee and the year being reported:
- Employee Code, TIN, Branch
- BIR Status Code β the employee's BIR employment status code
- Employment Period β contract start through end (or "Present")
- Monthly Rate, Employer, Year
- A Minimum Wage Earner badge, shown only when the employee is flagged MWE
- A Separation badge, shown only when the employee separated within the reported year β its value is the BIR alphalist reason-of-separation code (T, R, D, or TR) from the employee's separation type, or T if the type has no code mapped
The Four Headline Figures
Four cards summarize the year at a glance:
| Card | Meaning |
|---|---|
| Gross Compensation (Item 19) | Total annual compensation |
| Non-Taxable / Exempt (Item 38) | Total exempt income for the year |
| Taxable Compensation (Item 52) | Gross Compensation minus Non-Taxable/Exempt |
| Tax withheld as adjusted | The year's total withholding tax, adjusted for any year-end settlement |
Computation Checks
Above the annual statement, a chip reads either "Computation verified Β· N checks" (every identity ties out) or "N check(s) need review". The checks independently re-add the figures in your browser from the posted cutoffs and re-verify identities such as:
- Item 52 = Item 19 β Item 38 (taxable identity)
- Item 38 sums correctly from its component lines
- The 13th month non-taxable/taxable split adds up and respects the pool ceiling β a previous employer's 13th month and other benefits (when recorded) reduce that ceiling before this split is checked
- Item 26 = previous-employer withholding + payroll withholding Β± final-pay settlement (tax reconciliation)
- For a declared MWE, the RR 11-2018 exempt items 29-33 (statutory minimum wage, holiday pay, overtime pay, night shift differential, hazard pay) foot to the amount folded into Item 38 β shown as not applicable for a non-MWE, and noting when the figures were reconstructed from the declaration or had to be capped
- The annual statement ties to the posted payroll cutoffs listed below it
If any check is off, a warning banner appears above the statement naming how many checks need review β the affected section's badge also turns to a warning so you can find it quickly.
The Annual Statement (BIR 1604-C / 2316)
A composition bar shows the split between non-taxable and taxable compensation against the Gross Compensation total, followed by the full derivation broken into sections. Every money line is shown with the BIR item number it feeds, where the certificate prints one.
Gross Compensation (Item 19)
| Line | Note |
|---|---|
| Gross pay (posted payroll) | β |
| 13th month committed outside payroll | Committed 13th month pay not yet inside posted gross pay |
| Non-taxable net allowances | Paid on top of net pay β outside posted gross pay |
| Final pay β taxable components | Shown only when non-zero β taxable separation pay plus leave conversion above the de minimis ceiling, from a released final pay package |
| Final pay β exempt components | Shown only when non-zero β exempt separation pay plus de-minimis leave conversion, from a released final pay package |
| Gross compensation (Item 19) | Total of the lines above |
Non-Taxable / Exempt (Item 38)
| Line | Note |
|---|---|
| 13th month pay & other benefits, non-taxable (Item 34) | β |
| De minimis benefits (Item 35) | β |
| Other benefits absorbed by the pool | De-minimis excess and taxable allowances exempted under the company's β±90,000 (or configured) other-benefits pool ceiling |
| SSS / PhilHealth / Pag-IBIG, employee share (Item 36) | β |
| Non-taxable allowances (Item 37) | β |
| Non-taxable net allowances | β |
| Separation pay (exempt) | Shown only when non-zero β NIRC Β§32(B)(6)(b)-exempt separation pay from a released final pay package |
| Leave conversion (de minimis) | Shown only when non-zero β leave monetization within the de-minimis ceiling, from a released final pay package |
| Total non-taxable compensation (Item 38) | Sum of the lines above |
For a declared Minimum Wage Earner, the RR 11-2018 exemption on their statutory minimum wage plus holiday pay, overtime pay, night shift differential pay, and hazard pay is folded into the total above, in addition to the lines listed β it is not broken out as its own line on this table. The same figures back items 29-33 on this employee's BIR 2316 certificate, and the Computation Checks above verify them. Hazard pay is always β±0 β see Minimum Wage Compliance for why.
13th Month & Other Benefits Pool
Lists the year's committed 13th (and 14th, when enabled) month payments, the committed total, the company's other-benefits pool threshold, how much of it this employee's allowances already used, the remaining pool capacity, and the resulting non-taxable portion versus taxable excess of the 13th month pay. When the employee has a previous employer recorded for the year, that employer's 13th month and other benefits are deducted from the pool first β the present employer's exemption headroom shrinks by that amount, since both employers share the one annual ceiling.
Taxable Compensation (Item 52)
| Line | Note |
|---|---|
| Basic salary (Item 39) | Net of SSS, PhilHealth and Pag-IBIG employee shares |
| 13th month pay in excess of the pool threshold (Item 48) | β |
| Other taxable compensation | In the exported Excel, broken into Withheld at source (from allowances whose Tax treatment is Regular compensation) plus above the pool ceiling (from Other benefit allowances that spilled over the annual ceiling) |
| Total taxable compensation (Item 52) | Item 19 β Item 38 |
Tax Reconciliation
When the tax year has payroll periods left to run, the page shows This tax year is still running above the statement and the badge reads Projected refund (or Projected payable) rather than Refund or Payable.
The two halves of this reconciliation are computed on different bases. Tax is withheld each period as though that period's pay repeated for all twelve months, while the annual tax due is computed on what has actually been paid so far. Run mid-year the two diverge sharply, and the gap can be several times what the employee will really be owed β it closes as the remaining payroll is posted. Do not pay out a projected refund.
The badge returns to a plain Refund or Payable once the year has nothing left to run for that employee. A mid-year hire is not treated as unfinished (nothing is outstanding ahead of them), and a released final pay package closes the year outright, because final-pay annualization already settled it.
| Line | Note |
|---|---|
| Tax withheld by previous employer (col 15a / Item 25B) | Shown only when the employee has a previous employer recorded for the year β HR-entered from the prior employer's BIR 2316 |
| Tax withheld January to November | β |
| Tax withheld December | Includes any tax deficiency collected through a released final pay package, when present |
| Final-pay tax refund | Shown only when non-zero, as a negative line β the annualization refund actually paid through the released package |
| Annual tax due (Item 24) | Computed on the annual bracket table, not summed from withholding β on the consolidated base (present plus previous employer) when a previous employer is recorded for the year. The bracket arithmetic that produced it is printed underneath, e.g. 15% Γ (β±380,250.00 β β±250,000.00) = β±19,537.50, so the figure can be checked without leaving the page |
| Over-withheld tax (refund) / Tax still payable | Shown only when applicable |
| Tax withheld as adjusted (Item 26) | See below |
Without a final pay settlement or a previous employer this year, Item 26 = JanβNov + December withholding. When either applies, the formula becomes Item 26 = previous-employer withholding + payroll withholding + deficiency collected β refund paid β the section's badge shows Refund, Payable, or Tax settled depending on the result.
When any of the year's cutoffs withheld under an employee's fixed withholding tax setup, a variance between what was actually withheld and the bracket-table figure this reconciliation computes is expected β the fixed amounts are counted as tax withheld the same as a table cutoff, and this year-end true-up settles the difference the same way it would for any other employee.
Final-Pay Settlement
This section appears only when the employee has an effective Released Separation Pay package for the reported year. It itemizes exactly what that package contributed to the figures above:
| Line | Meaning |
|---|---|
| Separation pay β taxable | The taxable portion of separation pay, per the separation type's tax policy |
| Separation pay β exempt | NIRC Β§32(B)(6)(b)-exempt involuntary-separation benefits |
| Leave conversion β taxable | Monetized leave above the de-minimis ceiling |
| Leave conversion β exempt (de minimis) | Monetized leave within the de-minimis ceiling |
| Tax refund paid | Reduces tax withheld as adjusted (Item 26) |
| Tax deficiency collected | Included in the December withholding figure |
| Release date(s) | The date(s) the final pay package(s) behind this settlement were released, and how many released records make up the total (an employee can have two same-year separations) |
These figures are not additional numbers on top of the statement above β they are the breakdown of amounts already folded into Gross Compensation, Non-Taxable, and Tax Reconciliation. This section exists so you can see the final pay package's exact effect on the certificate without re-deriving it by hand.
Previous Employer (RR 11-2018 consolidation)
This section appears only when HR has recorded a Previous Employer (tax year) record for this employee and year β the mid-year hire's prior employer's BIR 2316 figures, entered on the employee's edit page. It shows what that record contributed to the figures above:
| Line | Meaning |
|---|---|
| Employer name / Employer TIN | The previous employer's identity, as entered by HR |
| Taxable compensation β previous employer (Item 22) | Joins the annual tax due computation (Item 23 = 21 + 22); the present-employer columns above stay present-only |
| Tax withheld β previous employer | Credited into tax withheld as adjusted (col 15a / 2316 Item 25B) |
| Non-taxable compensation β previous employer | As entered by HR, for reference |
| 13th month and other benefits β previous employer | Consumes the same annual exemption pool, reducing the present employer's headroom β see 13th Month & Other Benefits Pool above |
A previous employer on record also disqualifies the employee from substituted filing β with two employers in the same tax year, they must file their own annual return (BIR Form 1700) rather than have this employer's 2316 stand in for it.
Schedule 2 β Minimum Wage Earner
Shown only when the employee has an active, signed MWE declaration for the year. The rate basis method, minimum daily rate, daily/monthly/annual statutory minimum wage, factor used, wage order number, and wage board region all come from that signed declaration's snapshot β not re-derived at breakdown time β alongside Declared by and the date it was signed. The MWE-specific holiday pay, overtime pay, night shift differential, 13th month & other benefits, and de minimis benefits for the year are still live year sums of what was actually paid.
These figures are reporting context. What actually got exempted from this employee's tax β the amount folded into Non-Taxable / Exempt (Item 38) above and printed on the BIR 2316 certificate's items 29-33 β is resolved cutoff by cutoff: a cutoff payroll stamped as exempt at withholding time reads that stamp, a cutoff posted before the declaration existed (the mid-year case) is reconstructed from this signed declaration's rate, and a cutoff the engine judged paying above the minimum wage at the time is correctly left taxable rather than retro-exempted. For a mid-year declaration, that reconstructed portion is also what refunds on the employee's next payslip. The Computation Checks above call out a year with any reconstructed cutoffs, and flag when a requested exemption had to be capped.
If the live rate derivation no longer matches what was signed (a raise, a wage order update, or a payroll-group change since), the section's badge shows a Stale chip β hover it for the reason. The certificate still prints the signed snapshot; re-confirm or re-declare on Minimum Wage Compliance once the drift is reviewed.
Posted Payroll Cutoffs
Below the annual statement, a table lists every posted payroll cutoff that contributed to this employee's year β cutoff period, branch, and the full per-cutoff pay breakdown (gross pay, basic pay, overtime, holiday, night differential, de minimis, allowances, 13th month, government contributions, tax withheld, net pay) β with column totals across the bottom. These totals are what the annual statement's figures tie out against. A cutoff withheld under the employee's fixed withholding tax setup shows a Fixed chip next to its Tax Withheld figure.
Exporting
Click Export Excel at the top of the page (or on the cutoffs table) to download this single employee's annual statement and cutoff breakdown as an Excel file.
If Taxable Compensation shows as negative, an alert explains that exempt items exceed gross pay for the year for this employee β review the employee's postings before filing.
Related Topics
- Alphalist Report β the list this breakdown drills into
- BIR 2316 Certificates β the same figures printed as each employee's certificate
- Separation Pay β releasing a final pay package is what produces this page's Final-Pay Settlement section
- Employee Records (HRIS) β Previous Employer (tax year) β where HR enters the prior employer's income that produces this page's Previous Employer section
- Minimum Wage Compliance β where the signed declaration behind this page's Schedule 2 section is created and re-confirmed