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.

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 Manpower in the sidebar
  2. Open Reports
  3. Select Payroll Register

The breadcrumb at the top of the page reads Manpower › 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.
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 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, also resets the 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.
Gross PayTotal gross pay.
DeductionsTotal of all deduction amounts.
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, 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. 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."

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
  • Attendance: Total Days Present, No. of Days Leave, Late, Undertime, Absent
  • Earnings: Basic Salary, Basic Pay, Ordinary Overtime Pay, Night Differential (Overtime) Pay, Regular / Special Holiday Pay, Rest Day Pay, allowance breakdowns, De Minimis Benefits, Total Allowance, 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

Your company's individual allowance and deduction types each appear as their own column. Allowance breakdown columns start unticked (most users export the rolled-up totals instead). 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 Manpower › 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.

← Previous
Payroll Center
Next →
Payroll Summary