Using the Payroll Register Report

This report lists payroll information for posted payroll.

Information on the report

  • Check date, amount of each check, the calculation sequence, and posting sequence. 
  • Employee number, name, SSN or SIN, and times late.
  • A list of the employee's earnings/deductions and taxes, itemized with amount, G/L accounts, number of pieces or base amount, if appropriate, the rate/amt/pct, pooled tips, and the workers' compensation group/code.
  • Dollar amounts of the employee's total earnings, deductions, and taxes.
  • A list of the employer's contributions and taxes, itemized with amount, G/L accounts, the number of pieces or base amount (if appropriate), the rate/amt/pct, and the workers' compensation group/code.
  • A section for workers' compensation information, including a list of each earning and the accounts associated to it, the base, the rate, the assessment amount, the workers' compensation group, and code.
  • Dollar amount totals are listed for salary and wages, reported tips disbursements, vacation pay, sick time pay, compensatory time pay, total earnings, employee deductions, employee taxes, expense reimbursements, reported tips - noncash, allocated tips, total amount of checks, employer contributions, employer taxes, cash benefits, noncash benefits, and workers' compensation assessments.
  • Hour totals are listed for regular hours, overtime hours, shift hours, vacation accrual hours, sick accrual hours, and compensatory time accrual hours.

Employment insurance information printed on the report

  • EI period end date
  • EI period earnings
  • EI period hours
  • EI insurable earnings
  • EI premium

If you sort by class, the report shows data associated at posting with the selected class code or range of class codes for the selected employees.

To print the report

  1. From Payroll Transaction Reports, select Payroll Register.
  2. At the Report Format field, choose to print the report in detail or summary.
  3. At the Employee Number From and To fields, enter the range of employees on which to base the register.
  4. Enter the range of check dates to include on the report.
  5. Select the pay frequencies to include on the register.
  6. If you want to use an employee selection list, enter it in the Selection List field.
  7. Choose whether to include system checks, (that is, checks printed from your Sage 300 Payroll program), manual checks, and reversed checks on the register.
  8. If you chose to print in summary format, choose whether to include employee subtotals on the register.
  9. If you chose to print in detailed format, choose whether to include:
    • Detail dates and hours that were entered on timecards or manualchecks.
    • Description for each G/L account reported, if your database is integrated with General Ledger.
    • Job-related information if you use Sage 300 Project and Job Costing.
    • Full (not masked) social security numbers or social insurance numbers. If you do not select the Show SSN or SIN Numbers option, SSN or SIN numbers in the report are masked, so only the last part of the number appears (for example, ***-**-1234***-***-123).
    • Optional fields, if you have defined optional fields in Sage 300 Payroll for transactions.
  10. Choose to sort the register by Employee Number, Employee Name, Class, Pay Frequency, Pay Period End Date, Check Date, Check Number, or Posting Sequence.
    • If you chose to sort the register by Class, Pay Frequency, Pay Period End Date, Check Date, Check Number, or Posting Sequence, choose to sort the register then by either Employee Number or Employee Name.
    • If you chose to sort the register by Class, choose the class to sort by (Class 1, Class 2, Class 3, or Class 4). Then enter the range of class codes at the From Class Code and To Class Code fields
    • If you chose to sort the register by Posting Sequence, enter a range of posting sequences at the From and To fields.
  11. If you have defined optional fields in Payroll for transactions, you can choose to print only the paycheck that contain the optional fields that you enter in the optional fields table on this dialog box. For each optional field you enter in the table, you can specify the range of its values in the From and To fields.
  12. Click Print.
  13. When finished, choose Close.