What Information Does the Report Show?
The fields displayed depend on the report selected and the payroll data maintained in Sage 100. Common information used in earnings reviews includes:
- Employee details: Employee number, name, department, or other available identifiers.
- Pay period and dates: The period covered by the report and the relevant payroll or check date.
- Hours and rates: Regular hours, overtime hours, applicable pay rates, and other recorded time-based details.
- Earnings categories: Regular pay, overtime, commissions, bonuses, and additional compensation types configured by the employer.
- Totals: Earnings by employee, pay category, department, or selected reporting range when supported by the report.
Gross earnings should be distinguished from net pay. Gross earnings represent compensation before employee deductions and tax withholding, while net pay is the amount remaining after applicable deductions. An earnings report may not display every deduction or payment detail, so use the payroll register or employee pay statement when those details are needed.
How to Run and Review an Earnings Report
Begin by confirming the reporting purpose. A payroll-period review may require one pay run, while labor cost analysis may require a longer date range or a department-level view. In Sage 100, open the applicable Payroll reporting options and select the earnings report available in your installation. Exact menu names, filters, and available columns can vary by version and configuration.
Set the employee range, department or other available filters, and date criteria. Confirm whether the report uses payroll dates, check dates, or another reporting basis. Generate the report and review its totals against the payroll register and source time records. If the total differs from expectations, check the selected period, employee selection, earnings codes, and any payroll adjustments before drawing a conclusion.
A Payroll System is the combination of software and procedures used to calculate wages, process employee payments, maintain deductions, and support payroll reporting. The earnings report is one output of this broader system, providing a structured view of compensation data for operational and financial decisions.
Using Earnings Reports for Financial Reconciliation
Finance teams can use earnings reports as supporting evidence when reconciling payroll expense with general ledger activity. For example, assume a report shows $82,000 in gross wages for a pay period and the related wage expense account contains $82,000 for the same payroll posting. The amounts agree for that comparison, but the reviewer should also check employer payroll taxes, benefits, payroll liabilities, timing differences, and any separate compensation accounts before concluding that the entire payroll posting reconciles.
Consistent Earnings Analysis involves examining how compensation changes across periods, departments, roles, or pay categories. It can reveal overtime patterns, changes in staffing costs, or differences between planned and actual labor spending. Cash Earnings describes earnings considered in relation to cash generated or received, depending on the specific financial context; it should not be treated as interchangeable with gross payroll earnings. Earnings At Risk describes earnings exposed to potential loss or variability, a broader financial idea rather than a standard payroll-report total.
For accounting leaders, the 2026 Director of Accounting Salary Benchmark Report and the 2026 Chief Accounting Officer Salary Benchmark Report provide compensation benchmark context for finance leadership roles. The Financial Controller Salary Benchmark Data Report similarly supports comparisons by company size, industry, and geography. These resources address market compensation benchmarks, while a Sage 100 earnings report reflects payroll data recorded by a specific organization.
Controls and Related Finance Workflows
Reliable reporting starts with accurate employee records, approved pay rates, complete time entries, and consistent earnings-code use. Restrict access to payroll information, retain reports according to company policy, and document the reporting period and filters used for important reconciliations. When a correction is required, trace it to the relevant payroll transaction or adjustment and follow the organization's approval procedures.
Human in the Loop describes workflows in which people review exceptions, approve decisions, and provide feedback where judgment is required. In broader finance operations, Process Specific Capabilities describe AI-supported workflows tailored to particular processes, while Ready to Deploy Capabilities use pre-trained agents and ERP connectors to support selected finance tasks. Self Learning Capabilities can use human feedback to refine supported workflows over time. These are broader automation concepts and do not replace verification of Sage 100 payroll data.
The Hyperbots Platform supports company-specific configurations for ERP integrations, workflows, roles, and general ledger structures through a no-code framework. Its Integrations List page describes supported connections with systems such as SAP, Oracle, and QuickBooks. For organizations exploring related finance automation, AI Copilots for Sage 300 discusses AI-supported finance workflows in Sage 300, which is a separate product from Sage 100. Such tools may complement wider finance processes, but the payroll earnings report itself must be reviewed against the organization's actual payroll records.
Summary
The Sage 100 Payroll Earnings Report helps payroll and finance teams review recorded compensation, validate hours and earnings, monitor labor costs, and support payroll-to-ledger reconciliation. Accurate results depend on choosing the correct date range and filters, understanding gross earnings versus net pay, and comparing report totals with payroll registers and accounting records. Consistent review, controlled access, and documented reconciliation procedures strengthen payroll accuracy and financial reporting.