ANTE User Manual

Payroll Register

The Payroll Register is a report that lists every employee's payroll figures for one or more selected cutoff periods β€” basic pay, overtime, allowances, gross pay, deductions, and net pay β€” in a single table you can review, total, and export to Excel. It is a read-only report: it shows what payroll has computed, it does not change any payroll figures.

Use it after a cutoff has been computed in Payroll Center to review a whole group side by side. It sits beside Salary Detail, which shows the same figures one employee at a time.

The Payroll Register β€” one row per employee, with column totals across the bottom

Overview

Use the Payroll Register when you need a per-employee breakdown of a cutoff (or several cutoffs combined). From this page you can:

  • Pick a cutoff code and one or more cutoff periods to report on
  • Narrow the results by branch and by individual employee
  • Read each employee's pay summary in one row, with column totals across the bottom
  • Sort the table by any column
  • Export the register to an Excel file, choosing exactly which columns to include and the order they appear in β€” your arrangement is remembered for next time, on any device

When you select more than one cutoff period, the figures for each employee are added together across those periods.

Accessing the Payroll Register

  1. Click HR in the sidebar
  2. Open Reports
  3. Select Payroll Register

The breadcrumb at the top of the page reads HR β€Ί Reports β€Ί Payroll Register.

How to View the Register

The report does not load any data until you have chosen a cutoff. When you first open the page it shows Select a Cutoff Period with the prompt to select a cutoff code and at least one cutoff period to view the payroll register.

  1. Choose a Cutoff Code from the first dropdown. This is the payroll group / cutoff code.
  2. Choose one or more periods in the Cutoff Period dropdown. This dropdown stays disabled until a cutoff code is selected, and it lets you pick several periods at once.
  3. The table loads automatically once at least one period is selected.

When the page opens, the most recent default cutoff code and its default period are selected for you, so the register usually appears already populated. You can change either selection at any time.

If there are no payroll records for what you selected, the page shows No Payroll Register Records Found with the note that no payroll register records are available for the selected period.

Filters

The filter bar sits above the table. The Cutoff Code and Cutoff Period are the primary selectors (the report needs them to show anything). The remaining filters are optional and narrow the results further.

FilterWhat it does
Cutoff CodeThe payroll group / cutoff code to report on. Required.
Cutoff PeriodOne or more periods within the chosen cutoff code. Required (pick at least one). Multiple periods are summed per employee.
BranchLimits the register to employees in the selected branch(es). Defaults to All Branches.
DepartmentLimits the register to one department, including its sub-departments. Defaults to All Departments.
Payroll GroupLimits the register to employees of one payroll group. Defaults to All payroll groups.
EmployeesAll employees (default) or Minimum wage earners only, which keeps only employees with a signed minimum-wage-earner declaration for the cutoff's tax year (see Minimum Wage Earners).
Export subtotals byChooses how the Excel export is grouped with subtotal rows: Branch, Department, Payroll group or Cost centre. Left on Default (cost centre or branch), the export keeps its usual grouping. It does not change the on-screen table.
Search EmployeeShows a single employee. The list of employees comes from those already in the loaded register; search by employee name.

When any optional filter (Branch, Department, Payroll Group, Employees, Export subtotals by or Search Employee) is active, a Clear All control appears so you can reset them in one click. Changing the cutoff code or periods, or changing the branch, department, payroll group or employee group, also resets the employee selection. The two tab counts follow these filters too.

Active Employees and Inactive / Separated tabs

Under the filters, two tabs split the register. Each tab shows how many employees it holds for the current filters.

  • Active Employees (the default) β€” the employees on the cutoff's active payroll: the same list, totals and amounts as the Payroll Summary and its bank file.
  • Inactive / Separated β€” the employees on hold for the cutoff: 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 the cutoff end) and, until the payroll is posted, employees deactivated without a separation. It matches the Payroll Summary's Separated Employees (On Hold) list.

For a posted cutoff the split is the one frozen when the payroll was posted. The table, the footer totals, the record count and the export all follow the selected tab. Switching tabs clears the Search Employee selection.

The Register Table

Each row is one employee for the selected cutoff(s). The columns are:

ColumnDescription
Employee CodeThe employee's payroll code.
Employee NameThe employee's full name.
BranchThe employee's branch (shows - when none).
Basic PayBasic pay for the period, after time deductions (Late/Undertime/Absent) and excluding any manual salary adjustment β€” that adjustment (plus any Carry-over pay) is reported separately as Manual Earnings in the exported file, so the two never overlap.
OvertimeOvertime pay.
AllowancesTotal of all allowance amounts for the employee. For an allowance type that is grossed up, the column shows its face amount (for example Housing β‚±5,000); the company-paid tax on it is not added here but shown in the Tax Gross-up (Company-paid) column.
Tax Gross-up (Company-paid)All company-paid tax added to pay, in one column: the gross-up of an employee on fixed net pay (see Company-Paid Tax (Gross-Up)), plus the gross-up of every grossed-up allowance. This matches the payslip, which lists the allowance and a separate Tax gross-up – allowances/pay (company-paid) line. It is inside Gross Pay. The column appears only when at least one employee in the loaded cutoff(s) has such an amount; otherwise it is hidden.
Gross PayTotal gross pay.
DeductionsTotal of all deduction amounts.
Tax BasisTable or Fixed β€” whether the cutoff's withholding tax came from the BIR bracket table or an employee's fixed withholding tax setup.
Allowance ReductionFor banded or absence-exempt allowances, a note of the month-to-date absence %, the absent days out of scheduled days, and the band payout % that applied (shown as - when none). The Excel export includes the same column.
Fringe BenefitThe taxable fringe benefit paid through payroll, added after deductions and outside Gross Pay. The column appears only when at least one row has a fringe benefit.
FBT (Company)The fringe benefit tax the company bears on it. It is an employer cost, never deducted from the employee and not part of Net Pay. Appears together with Fringe Benefit.
Net PayTake-home pay after deductions.

The table is sorted by Employee Name by default. Click any column header to sort by that column. A totals row runs along the bottom, summing Basic Pay, Overtime, Allowances, Tax Gross-up (Company-paid), Gross Pay, Deductions, and Net Pay across every employee shown.

Exporting the Register

The export produces an Excel file that is far more detailed than the on-screen table β€” it includes attendance counts, holiday and night-differential pay, statutory deductions, and a column for each allowance and deduction type your company uses.

Step 1: Open the export dialog

  1. Make sure the register is showing the cutoff(s) you want to export
  2. Pick the tab β€” Active Employees or Inactive / Separated. The file contains only that tab's employees, with an Employees: … line at the top saying which tab it came from (an Inactive / Separated file is also named …-inactive-separated).
  3. Click Export on the table

A Select Columns to Export dialog opens, listing every available column. Its subtitle reads "Choose and arrange the columns for the Excel file. Your layout is remembered." Only the columns you tick, untick or drag are remembered; columns you leave alone keep following their default each time (for example, Tax Gross-up (Company-paid) is ticked whenever the payroll has one).

Step 2: Choose and arrange your columns

  • Some columns are marked Required β€” these are pinned in their own list at the top, are always included, and cannot be unticked or moved (for example No., Employee Code, and Name).
  • The remaining (optional) columns start ticked, except a few verbose ones that start unticked (they remain available to add).
  • Use Select All / Deselect All at the top to toggle every optional column at once.
  • Drag to reorder: grab the drag handle (β Ώ) on the left of any optional column and drag it up or down to change where it lands in the exported file. Required columns always stay first, ahead of any optional column.
  • Click Reset to Default to restore the default column selection and order and clear your saved arrangement.

The available export columns include, among others:

  • Identity: No., Employee Code, Name, Branch, and the optional (unticked by default) Department, Payroll Group and Daily Rate
  • Attendance: Total Days Present, No. of Days Leave, Late, Undertime, Absent
  • Earnings: Basic Salary, Basic Pay, Overtime Pay, Night Differential (Overtime) Pay, Regular / Special Holiday Pay, Rest Day Pay, allowance breakdowns (including Taxable Allowances (Withheld at Source), so the category columns add up to Total Allowance; they still include the allowance gross-up, since it is taxable regular compensation), De Minimis Benefits, Total Allowance, Tax Gross-up (Company-paid), Manual Earnings (includes any Carry-over pay from a filing approved after an earlier cutoff was already locked), Total Earnings, Gross Pay
  • Deductions: SSS, PhilHealth, HDMF (Pag-IBIG), Tax, individual loan / deduction columns, Manual Deductions, Total Deductions
  • Net Pay
  • More detail, all unticked by default: overtime split by kind of day (Ordinary Day, Rest Day, Regular Holiday and Special Holiday OT minutes and OT pay), Night Differential minutes (including OT and holiday night differential), Regular Holiday, Special Holiday and Rest Day worked minutes, the employer shares (SSS, PhilHealth and HDMF) and Employer Contribution Total
  • Leave: one (leave type) Pay (est.) column per leave type, placed after Basic Pay. A leave type with no pay on any row of the cutoff starts unticked.

Your company's individual allowance and deduction types each appear as their own column. A deduction type is listed as soon as any employee has ever been assigned to it β€” whether it's set up on its own or grouped under a category label (for example an "SSS Loan" or "HDMF Loan" heading) β€” and it stays listed even after that plan is completed or deactivated, so reporting on an earlier cutoff still shows a since-paid-off loan's column. Only category labels with no employee plans of their own are left out. Allowance breakdown columns start unticked (most users export the rolled-up totals instead). The Tax Gross-up (Company-paid) column sits after the allowance columns in the file; it holds all company-paid gross-up (fixed-net-pay and allowance) and starts unticked when no employee in the loaded cutoff(s) has a company-paid gross-up, so you only see it by default when it carries figures. Deduction breakdown columns start ticked, except any deduction that is zero for every employee in the current cutoff β€” those start unticked so the file isn't cluttered with empty columns. You can still tick any of these on.

Step 3: Confirm

  1. Click Export in the dialog
  2. The file downloads once it's ready (the button shows a loading state while the export runs). The exported Excel file's columns follow the order you arranged.

Your column selection and order are saved to your account as soon as you export, and are restored automatically the next time you open the dialog β€” even from a different device. Use Reset to Default at any time to clear this saved arrangement and start over.

You can click Cancel to close the dialog without exporting.

Common Tasks

Review one cutoff for all employees

  1. Open HR β€Ί Reports β€Ί Payroll Register
  2. Pick the Cutoff Code, then tick the Cutoff Period
  3. Read the table; check the totals row at the bottom for cutoff-wide totals

Combine several periods for an employee

  1. Select the Cutoff Code
  2. In Cutoff Period, tick every period you want included β€” the figures are summed together
  3. (Optional) Use Search Employee to focus on one person

Look at a single branch

  1. Load the register for your cutoff
  2. Open the Branch filter and pick the branch(es) you want
  3. Use Clear All to return to All Branches

Export a detailed payroll register to Excel

  1. Load the register for the cutoff(s) you want
  2. Click Export
  3. Tick/untick columns (Required columns stay on) and drag optional columns into the order you want them in the file
  4. Click Export in the dialog and wait for the download β€” your arrangement is remembered for next time

πŸ“Œ Tip: The Payroll Register is a reporting view only β€” it never changes payroll figures. To recompute, approve, or publish a cutoff, use the Payroll Center.

How It Connects

Set up first

  • Settings β€” how many decimal places every payroll amount shows here (Set Payroll Decimal Places).
  • Payroll Group β€” the cutoff code you pick first is a payroll group's cutoff code.
  • Cut-Off Management β€” defines the cutoff periods you can select.
  • Allowance β€” each allowance type gets its own column and can be ticked for the export.
  • Deduction β€” each deduction type gets its own column and can be ticked for the export.

Gets its data from

  • Payroll Center β€” the figures shown are the ones payroll computed for each cutoff.
  • Salary Detail β€” the same per-employee figures, opened one employee at a time with every adjustment.
← Previous
Schedule Management
Next β†’
Payroll Summary