ANTE User ManualBIR 1604-C Alphalist Report
The Alphalist Report lists every employee's annual compensation figures for a selected year — gross compensation, non-taxable and taxable totals, and tax withheld — the same data BIR Form 1604-C requires. Export it as a ready-to-file, multi-sheet Excel workbook, or click any employee to see exactly how their figures were computed on the Alphalist Breakdown.
Accessing the Alphalist Report
- Click Manpower in the sidebar
- Open Reports
- Select Alphalist Report (1604-C)
The breadcrumb at the top of the page reads Manpower › Reports › Alphalist Report (1604-C).
Filtering the Report
- Year — the filing year (defaults to the current year)
- Search Employee — narrow the table to one employee
Filing Readiness Banners
Up to three banners can appear above the table, checking the year's data against Minimum Wage Compliance declarations. The report itself always stays viewable as a working document — these banners are advisory, not a block:
- DRAFT — N unconfirmed MWE candidate(s) (warning) — lists employees whose live evaluation is an MWE candidate but who have no signed declaration yet for the year. A Review MWE Declarations button opens the compliance page directly.
- N below-minimum wage(s) need correction (info) — employees whose compared rate is currently below the statutory minimum wage.
- N declared MWE(s) with tax withheld (info) — employees declared MWE who nonetheless have tax withheld for the year on record; the report keeps their real, honest figures rather than zeroing them out. A signed declaration now exempts an MWE's statutory pay from withholding going forward, and a mid-year declaration also refunds the tax over-withheld on earlier cutoffs on the employee's next payroll run — so this usually means other taxable income, a cutoff evaluated above the minimum wage, a cutoff the correction could not resolve, a correction that has not posted on a next cutoff yet, or a year posted before the exemption took effect.
Each banner names up to three affected employees, then "+N more" for the rest.
The Employee Table
| Column | Meaning |
|---|---|
| Employee Code / Employee Name | Identifies the employee |
| Branch | The employee's branch |
| TIN | The employee's Tax Identification Number |
| Status | Employment status |
| Gross Compensation | Total annual compensation (BIR Item 19) |
| Total Non-Taxable | Exempt income for the year (BIR Item 38) |
| Total Taxable | Taxable compensation for the year (BIR Item 52) |
| Tax Withheld | Total tax withheld as adjusted for the year. This includes any amounts withheld under an employee's fixed withholding tax setup — a variance against the annual tax due is expected in that case and is settled by the December true-up, the same as any other shortfall or refund. |
| MWE | Flags employees with an active, signed Minimum Wage Earner declaration for the year — no declaration means the employee is not flagged MWE here, even if their withheld tax happens to be zero |
A totals row across Gross Compensation, Total Taxable, and Tax Withheld sits at the bottom of the table.
Viewing an Employee's Computation
Click any employee's row to open the Alphalist Breakdown for that employee — every posted payroll cutoff behind their annual figures, the BIR item computation, and (for a separated employee) their released final pay settlement.
Exporting to Excel
The export produces one workbook with three sheets, ready for filing:
- Schedule 1: Alphalist of Employees — the same rows and columns as the on-screen table
- Schedule 1: Tax Reconciliation — the withholding reconciliation behind each employee's Tax Withheld figure
- Schedule 2: Minimum Wage Earners — the declared-MWE employees, with the statutory minimum wage rates from their signed declaration (not re-derived at export time), and the wage-board region from that declaration's jurisdiction
Schedule 2's Region No. column comes from the signed declaration's wage-board jurisdiction. If that jurisdiction was never resolved, the column is left blank rather than defaulting to NCR or any other region — resolve it on Minimum Wage Compliance before filing.
If a separated employee has a Released Separation Pay package for this year, its taxable and exempt components, tax refund, and any collected tax deficiency are already folded into this employee's Gross Compensation, Total Non-Taxable, Total Taxable, and Tax Withheld figures — no separate step is needed. See the Final-Pay Settlement section of the breakdown for the itemized effect.
Finalizing the Filing
Once the year's figures are correct, click Finalize filing in the page header to freeze the Alphalist as the official, unchangeable record of what was submitted to BIR for that year. Finalizing:
- Freezes every row on the table exactly as it stands at that moment
- Renders and permanently stores two artifacts alongside the frozen rows: the Alphalist Excel workbook (the same three-sheet export described above) and the BIR 2316 batch PDF (every employee's certificate, the same batch produced on the BIR 2316 Certificates page)
Finalizing needs a separate permission from viewing the report — if the button doesn't appear, ask an administrator to grant it.
Finalize refuses, and explains why, in three situations:
- An MWE candidate for the year is still unconfirmed — the same rule Minimum Wage Compliance enforces before a declaration is signed. Confirm or mark each one MWE or Ordinary there first — the button stays disabled, with a tooltip explaining why, until every candidate is resolved.
- The report is empty — there is no posted payroll for the year yet.
- An active filing already exists for the year and you have not chosen to amend it — see Amending a Filing below.
The Finalize filing dialog previews exactly what will be frozen — the row count and the headline totals (Gross Compensation, Taxable Compensation, Tax Withheld) — plus the same below-minimum-wage and declared-MWE-with-tax-withheld notices shown in the readiness banners above, since those are frozen into the filing's warnings too. Add an optional note, then click Finalize.
The Filed Banner and As-Filed View
Once a year has been finalized, a banner appears above the table reading Filed on [date] by [name], with any note attached at finalize time. From the banner you can:
- Download the stored As-filed workbook and As-filed 2316 PDF — the exact files generated and saved at finalize time, not a fresh regeneration from current data
- Click History to open the filing history — see Amending a Filing below
- Toggle View as filed / View live data to switch the table between the frozen snapshot and the current live report
A Live data differs from the filed version badge appears on the banner whenever the live report's headline totals no longer match what was filed — expected after a later correction to a posted payroll cutoff, and it does not change the filed record itself.
If a year was finalized before an employee's Minimum Wage Earner declaration started actually exempting their pay from withholding, that employee's live Total Non-Taxable and Total Taxable figures can now be lower than what was filed — the original filing over-withheld them. The filed workbook and 2316 PDF are unchanged and their evidence hash still verifies; nothing about the frozen record is altered by this. To correct a filed year, see Amending a Filing below.
Switching to View as filed shows the table exactly as it was frozen: an As filed chip appears above the table, clicking a row no longer opens the Alphalist Breakdown (the frozen rows have no live drill-down), and the export button is replaced with Download as-filed workbook, which downloads the same stored artifact as the banner.
Amending a Filing
Filed years are append-only — a finalized filing is never overwritten or deleted. To correct a filed year (for example, after a payroll correction changes the figures), click Finalize filing again for the same year. Because an active filing already exists, the dialog opens directly in Amend filing mode and requires a non-empty Amend reason before you can submit. Finalizing again supersedes the previous filing — it does not replace or delete it.
Click History on the banner to see the full chain for a year: every version ever finalized, newest first, each marked Current or Superseded, who finalized it and when, the amend reason on a superseded entry, and a SHA-256 evidence hash of the exact frozen payload.
BIR audits and later payroll corrections both need to know exactly what was submitted at filing time. If a finalized filing could simply be overwritten, a correction made months later would silently rewrite history, with no way to reproduce what was actually filed. Because amending always supersedes rather than overwrites, the originally filed version — and its stored Excel workbook and 2316 PDF — stays permanently retrievable, even after the live report has moved on.
Related Topics
- Alphalist Breakdown — the per-employee computation this report drills into
- BIR 2316 Certificates — the same annual figures, printed as each employee's certificate
- Separation Pay — releasing a final pay package is what feeds this report's final-pay figures
- Minimum Wage Compliance — where MWE declarations are signed; a signed declaration is what puts an employee on Schedule 2
- Monthly Remittance Return (1601-C) — the same finalize / amend / as-filed pattern, applied per month