ANTE User Manual

HR and Payroll Reports

These are the read-only reports in the HR menu that answer everyday HR and payroll questions: what did we pay a group of people over several cutoffs, who worked how many days, how much 13th month pay is accrued, who will owe or get back tax at year end, what is being deducted or paid as an allowance, and what leave and approved filings exist. None of them change any record β€” they only read what payroll, HRIS and the filings have already produced. The Payroll Register, Alphalist, BIR 2316, Monthly Remittance and Payslip Center have their own pages, and the SSS, PhilHealth, Pag-IBIG and Tax Withholding reports are on Government Contribution Reports.

How Report Screens Work

Every report in this group follows the same layout:

  • Filters on top. Pick the period first (a cutoff, a month, a year or a date range, depending on the report). Most reports then let you narrow by Branch and by one employee with Search Employee, which only finds people among the rows currently on screen. Clear all resets the optional filters but keeps the period you chose.
  • A table below. Click a column heading to sort. Where the figures can be added up, a totals line sits at the bottom of the table. Until you have chosen the period the report asks you to select one and shows nothing.
  • Export. The export button writes an Excel file for the same filters. Most reports first open a column picker so you can choose which columns go into the file and in what order; the employee code and name are always included.
Posted payroll versus live data

Reports differ in where their numbers come from, and it matters when you reconcile:

  • Posted payroll only β€” Payroll Summary Report and Annualization read cutoffs that have been Posted, so they are frozen figures that do not move afterwards. 13th Month Pay accrues from posted cutoffs as well.
  • Live records β€” Employee Timesheet (any cutoff status), Allowance Reports, Leave Balance Report, Leave Reports and Approval Applications read what is in the system right now, so their figures change as people file, get approved or have plans changed.
  • A mix β€” Deduction Reports lists current deduction plans but takes the amount actually deducted from the payroll of the period you choose.

Payroll Summary Report

The question it answers: what did each employee earn, have deducted and take home across one or several posted cutoffs added together? It is the report to use for a month, a quarter or any run of cutoffs, where the amounts per employee are summed.

Not the same as the Payroll Summary screen

The per-cutoff Payroll Summary screen you open from Payroll Center is a working screen: it is where one cutoff is reviewed, sent for approval and posted. This Payroll Summary Report is the after-the-fact report across posted cutoffs β€” you cannot approve or post from it. It shows the same kind of columns as the Payroll Register, and you pick several posted periods under one cutoff code.

FilterWhat it does
Cutoff CodeThe payroll group's cutoff setup. The page opens on the code of the current period. The period list stays disabled while no code is chosen, and choosing another code clears the periods.
Cutoff PeriodOne or more posted periods of that code. The page opens with the current period already selected, so the report usually appears populated straight away; if you clear the selection it stays cleared until you choose again. Nothing loads while no period is selected.
BranchLimits the report to employees in the selected branch(es), using the branch each employee was in for the cutoff; choosing a branch includes its sub-branches. Defaults to All Branches; changing it clears Search Employee.
Search EmployeeNarrows to one person among the rows shown.

Tabs: under the filters, Active Employees (the default) lists the employees on each cutoff's active payroll β€” the same list and amounts as the per-cutoff Payroll Summary and its bank file β€” and Inactive / Separated lists the employees on hold (separated on or before the cutoff start β€” or its last day when the company holds the last salary of employees separated during the cutoff β€” unless re-hired by its end, plus employees deactivated without a separation before the payroll is posted), matching its Separated Employees (On Hold) list. Each tab shows how many employees it holds within the chosen branches. Posted cutoffs keep the split frozen at posting. The table, totals, record count and export follow the selected tab; switching tabs clears Search Employee.

Key columns: Employee Code, Employee Name, Branch, Basic Pay, Overtime, Allowances, Gross Pay, Deductions, Tax Basis (Table or Fixed withholding), Allowance Reduction and Net Pay, with column totals at the bottom. Allowances and Deductions are shown as one total each per employee; the export lists them type by type. Basic Pay, Overtime, Gross Pay and Net Pay are added up across the selected periods.

Export: the column picker offers the standard columns plus one column per allowance type and per deduction type you have configured. The file is built from the same detailed layout as the per-cutoff Payroll Summary Excel, added up per employee across the periods you selected. It contains only the selected tab's employees, narrowed by the Branch and Search Employee filters, with an Employees: … line at the top naming the tab (plus lines naming the branch and its sub-branches when a branch is selected); an Inactive / Separated file is named …-inactive-separated.

Who uses it: payroll officers and finance for period totals, and managers who want what a team cost over several cutoffs.

Employee Timesheet

The question it answers: how many days did each employee attend and how many hours were credited in a cutoff, and can I get every employee's daily timesheet in one file?

Filters: Cutoff Code, then Cutoff Period (one period). Unlike the payroll reports, this list includes periods in any stage β€” current, on process and posted β€” and each is tagged with its status, so you can check a timesheet before payroll is posted. Then Branch and Search Employee.

Key columns: Employee Code, Employee Name, Branch, Department, Attendance (days) and Total Hours (shown as hours and minutes). The people listed are current employees plus anyone separated whose contract ended on or after the cutoff's start date.

Export: a single Excel workbook with one worksheet per employee for the selected cutoff, so the timesheet of the whole team can be handed over or filed at once. There is no column picker here.

Tip

For a period that is still open, the figures follow what is in Payroll Time Keeping now. Fix punches and filings there, then run the report again.

Who uses it: HR and supervisors verifying attendance before payroll, and anyone who needs a per-employee timesheet as evidence.

13th Month Pay Report

The question it answers: for a calendar year, how much 13th month pay has each employee accrued, how much has already been released, and how much is still owed? The accrual builds up from posted payroll cutoffs; the release side comes from the payments recorded on the 13th Month Pay screen.

Filters: Year, Branch, Employee Status and Search Employee. Employee Status defaults to Active because the report is the pay-from list for the year-end release; choose Resigned or All to see separated employees. Clear all returns the status to Active.

Key columns: Employee Code, Employee Name, Branch, Basic Pay (the base the accrual used), Accrued to Date, Released, Balance and Cutoffs Released, with totals at the bottom. When the 14th month benefit is switched on for the company, 14th Accrued, 14th Released and 14th Balance appear too. For companies that use the attendance-rate method, Attendance Rate (%) and Statutory Minimum also appear, the latter showing Floor paid where the legal minimum was applied.

Warning

A separated employee's accrued 13th month is paid through Separation Pay final pay, not the year-end release, so do not pay a resigned employee from this list.

Per-employee breakdown

Click any row to open that employee's 13th Month Breakdown for the year. It shows the employee's details (code, branch, year, company), the 13th and 14th totals (Accrued, Released, Balance), and two tables: Per-Cutoff Accrual β€” each posted cutoff with its Base, Accrued amount, a Released or Unreleased status, and a Variance flag β€” and Payment History with the paid date, benefit, type, amount and notes. Where the attendance-rate method is in use an Attendance rate section is added. Export Excel downloads the breakdown, and Back to 13th Month Pay returns to the list. The Excel export buttons (on the report and on the breakdown) show only for an account with the 13th Month Pay export permission, which is separate from permission to open the report.

Export: a column picker, then Excel with the same status filter as the screen. Who uses it: payroll and finance when planning and reconciling the year-end release.

Annualization Report

The question it answers: after a whole year of posted payroll, has each employee had too much tax withheld (a refund is due) or too little (tax is still payable)? The report recomputes each employee's annual tax against the annual tax table set up in Annualization settings and compares it with what was actually withheld.

Filters: Year, Branch and Search Employee. Changing the year clears the branch and employee choices.

Key columns: Employee Code, Employee Name, Gross Income, Taxable Income, Annualized Tax, Tax Withheld and Settlement. Settlement shows the amount followed by refund or payable, or Settled when the two agree; the totals line at the bottom nets refunds against amounts payable across the whole company. The export column picker adds Branch, Year, Non-Taxable Income, Gov. Contributions (EE Share), BIR Tax Computation (the bracket arithmetic), Tax Due and Tax Refund.

The current year is a projection

While the selected year is the current one, a notice explains that the figures are projections: tax is withheld each period as if that period's pay repeated all year, while the annualized tax is computed on what has actually been paid so far, so mid-year most employees show a refund larger than they will really be owed. Rely on the report once the year's last cutoff is posted.

Drill-down: clicking a row opens the employee's yearly breakdown, which is the same one used by the Alphalist, so this report, the Alphalist and BIR 2316 use one tax computation and cannot disagree.

Who uses it: payroll and finance doing the December true-up and preparing year-end tax settlement.

Released Payroll Alignment

Use this when the pay your company actually released to employees differs from the payroll posted in Ante β€” for example when payslips were edited outside Ante before payment. For each employee you upload the difference (released minus posted, year to date) up to one posted cutoff. Every annual figure then uses the released amounts: this report, the Alphalist, BIR 2316, the year-end true-up of later payrolls, and the tax refund in final pay. Posted payslips, the payroll journal and bank files are never changed.

  1. Open the alignment
    On the Annualization Report, pick the Year and click Released Payroll Alignment. The list shows every employee already aligned for that year, with the total adjustment for gross pay, contributions and tax withheld. Use the search box to find an employee by name, code or note. Each row shows the employee's adjustment, the cutoff it Covers Through, and when and by whom it was last Updated.
  2. Start an import
    Click Import File, then choose Covers posted payroll through β€” the last posted cutoff your file covers. Payrolls after it apply the adjustment; it defaults to the latest posted cutoff.
  3. Fill in the template
    Click Download template and enter one row per employee. Blank cells count as zero; use a minus sign when less was released than posted.
  4. Upload and review
    Choose the file and click Upload and review. Under the Gross Pay and Tax Withheld amounts of each row, a line shows the employee's posted year to date followed by the aligned figure (posted β†’ aligned), and a row that replaces an existing alignment says so. Unknown employee codes, repeated employees and non-numeric amounts are flagged and skipped. Nothing is saved yet.
  5. Import
    Click Import (the button shows how many rows will be saved). A row for an employee who is already aligned replaces their previous row.
Employee Code*
The employee's code in Employee Records. Employees who moved to another company during the year can still be aligned in the company that paid them.
Gross Payamount
Released minus posted gross pay, including the basic pay, non-taxable and contribution parts below.
Basic Payamount
Released minus posted basic pay β€” the part of Gross Pay that is basic pay, counted the way the 13th month counts it. It moves the BIR 2316 Basic Salary (Item 39); the rest of the taxable difference is overtime, holiday pay and other earnings (Item 51A). Leave it empty when the basic pay is the same. A file without this column still imports: its whole taxable difference then comes out of Item 51A first, and only what Item 51A cannot cover comes off basic.
Non-Taxable Allowance / De Minimisamount
Released minus posted non-taxable amounts that are part of gross pay.
Non-Taxable (After Deductions)amount
Released minus posted non-taxable amounts paid on top of net pay.
Employee Contributionsamount
Released minus posted SSS, PhilHealth and Pag-IBIG employee share.
Tax Withheldamount
Released minus posted withholding tax.
Notes
Optional, up to 500 characters β€” why the amounts differ.
Example: one employee's annual figures after alignment
Posted gross pay, year to dateβ‚±250,000.00
Gross Pay in the file (released βˆ’ posted)+βˆ’β‚±1,500.00
Gross pay the annualization uses=β‚±248,500.00
Posted tax withheld, year to dateβ‚±2,000.00
Tax Withheld in the file+βˆ’β‚±150.00
Tax withheld the annualization uses=β‚±1,850.00
The employee's posted payslips still show β‚±250,000.00 and β‚±2,000.00.

A banner on the report says when the year includes an alignment and how many employees were adjusted (with a View button that opens the list). In the employee's breakdown, a Released Payroll Alignment card shows the amounts added, so the posted per-cutoff rows plus the alignment add up to the annual totals. An employee with an all-zero row is confirmed as "released equals posted": payslips posted after their separation are then counted too.

Warning

If a cutoff the alignment covers is posted again with different amounts, the row shows a Re-check badge under Covers Through (hover it to see the posted amounts before and after), and the list and the report banner say how many rows need it. Compare the amounts and upload a corrected file β€” otherwise the difference may be counted twice.

Use the trash icon to remove an employee's row; their annual figures go back to posted payroll. Viewing the list needs access to the Annualization Report; importing and removing need the Released Payroll Alignment permission.

Deduction Reports

The question it answers: which deduction plans does each employee have, and how much was deducted from them in a given month? It is also used to list loan balances and to prepare the MP2 line of a Pag-IBIG remittance.

Filters: Period Covered (Month) (defaults to the current month), Branch, Deduction Type and Search Employee.

What is listed: one row per employee per deduction plan β€” the plans that are currently active for current employees, plus any plan that had an amount deducted in the chosen month.

Key columns: Employee Code, Employee Name, Branch Name, Deduction Name, Effectivity Date, Monthly Amortization, Deducted This Period (the amount actually taken in the chosen month, added up from the cutoffs that fall in it), Principal, Total Paid to Date and Remaining Balance. The last three describe the plan over its whole life, not just the month. SSS / Pag-IBIG No. shows the SSS number or Pag-IBIG MID that a government loan or MP2 plan is keyed by (blank for other deduction types), so the sheet matches the remittance file. The export column picker also offers Sub Type (the specific plan underneath a deduction category) and an opt-in MP2 Account No. column β€” filter to the MP2 deduction and turn it on to get a sheet you can file as the MP2 line of the Pag-IBIG remittance. See the HR overview for how Deduction Type and Sub Type read, and Deduction for the setup.

Who uses it: payroll for loan and savings follow-up, HR for plan audits, and finance for reconciling deductions to what is remitted.

Allowance Reports

The question it answers: which allowances are assigned to which employees, for how much a month, and how much did payroll actually pay from each one in the month?

Filters: Period Covered (Month) (defaults to the current month), Branch, Allowance Type and Search Employee.

What is listed: active allowance plans of current employees that are in force at some point of the chosen month: the plan started on or before the month's last day and did not end before its first day. A plan that started in an earlier month and is still running is listed, and so is one that ends inside the month.

Tip

For the payment of one cutoff, use the Payroll Register; its Allowances column comes from the payslips.

Key columns: Employee Code, Employee Name, Branch Name, Allowance Type, Effectivity Date, End Date (blank when the plan has no end), and two money columns that answer different questions:

  • Amount is what the plan is set to pay a month, not a payment: the monthly amount in force on the month's last day (or today, for the current month), with scheduled amount changes applied.
  • Paid in Posted Payroll is what posted payroll actually paid from the plan in payroll runs that end in the month. Runs not yet posted are left out, because their figures can still change. It is what the employee received, before any company-paid tax on a grossed-up allowance.

For example, a Post allowance of β‚±3,500 a month paid in the last cutoff shows Amount β‚±3,500 and Paid in Posted Payroll β‚±3,500 once that cutoff is posted, and β‚±0 before. A note above the table and an info icon on each header repeat these meanings. The export column picker also offers the allowance Category.

Who uses it: HR and payroll to verify allowance assignments after onboarding or a promotion, and finance to see how much each plan has cost. The plans themselves are set up under Allowance.

Leave Balance Report

The question it answers: how many leave credits does each employee have right now, per leave type? Credits come from the employee's leave plan; see Service Incentive Leaves for how plans earn, use and carry over credits.

Filters: Leave Type (default: all leave types) and Search Employee. There is no period filter β€” the report always shows today's balances for current employees with an active leave plan.

Key columns: Employee Code, Employee Name, Branch Name, Leave Type, Leaves Earned, Leaves Used, Carried Over, Current Year and Leaves Balance, with totals at the bottom. Leaves Balance is the total remaining; Carried Over is the part of it brought forward from last year and Current Year is the rest. Leaves still waiting for approval are not deducted yet; the export column picker includes a column for them.

Drill-down: click a row to open that employee's leave plan detail and its history. Export: column picker, then Excel. Who uses it: HR checking entitlements before approving leave, and payroll preparing leave conversions.

Leave Reports

The question it answers: which leaves were filed in a date range, by whom, for how many days and with what outcome? Where the Leave Balance Report shows what is left, this one lists the individual leave filings.

Filters: Date Range (defaults to the current month), Leave Type and Search Employee.

Key columns: Employee Code, Employee Name, Leave Type, Paid / Unpaid, Leave Dates, Leave Days, Reason and Status. Any From and To date works, and a leave that starts before the range but runs into it is included. All leave filings in the range are listed whatever their status (pending, approved or otherwise), so read the Status column before counting a leave as taken. The export column picker also offers branch, filing reference, reason, filed and approved dates and the approver.

Who uses it: HR and supervisors reviewing leave patterns, and payroll cross-checking leave days against a cutoff. Filings themselves are made and approved on Leave Filing.

Approval Applications

The question it answers: which filings were approved in a date range, and who approved them? It is the audit trail of approved requests across filing types.

Filters: Date Range (defaults to the current month), Filing Type and Search Employee. Filing Type offers Leave, Overtime, Certificate of Attendance, Official Business and Schedule Adjustment; the default is all types. Only approved filings are listed.

Key columns: Employee Code, Employee Name, Branch, Type, Start Date, End Date, Duration (days for leave, hours for the others), Remarks and Approver. The export column picker adds more detail such as the filing reference and filed and approved dates.

Who uses it: HR and auditors checking that payroll-affecting changes had an approval, and managers reviewing what their team has had approved. See Approval Configuration for who approves each type.

How It Connects

Set up first

  • Cut-Off Management β€” defines the pay periods that the cutoff-based reports let you pick.
  • Annualization β€” holds the annual tax table the Annualization Report compares withholding against.
  • Service Incentive Leaves β€” defines the leave types and plans behind the leave reports.
  • Approval Configuration β€” decides who approves the filings that appear in Approval Applications.

Gets its data from

  • Payroll Summary β€” once a cutoff is posted there, its figures become available to the posted-payroll reports.
  • Payroll Time Keeping β€” supplies the attendance days and credited hours in Employee Timesheet.
  • Filings β€” leave and other approved filings feed the leave and approval reports.
  • 13th Month Pay β€” records the releases that the 13th Month Pay Report subtracts from the accrual.
  • Deduction β€” the deduction plans listed in Deduction Reports.
  • Employee Records β€” provides the employee, branch and department details shown in every report.

Feeds into

  • Alphalist Report β€” uses the same year-end tax computation as the Annualization Report.
  • BIR 2316 β€” uses the same year-end tax computation as the Annualization Report.
  • Separation Pay β€” releases the accrued 13th month of separated employees shown in the 13th Month Pay Report.
  • Payroll Center β€” the year-end true-up of payrolls after a Released Payroll Alignment adds its amounts.