Learn more

Payroll reports

Using the Payroll Job Register Report

This report is available only if you use Sage 300 Project and Job Costing. Print the report to verify the accuracy of posted job-related information, and to file as the audit trail for the payroll run.

Information on the report

This report shows job-related information, either in a detailed or summary format. Information includes:

  • Employee number and name.

  • Check information, such as check number, date, amount, calculation sequence, posting sequence, and so on.

  • A list of the jobs to which the employee's earnings were allocated. The details for each job are shown, such as the related earning, accrual or expense reimbursement, the number of hours that were worked, overhead account and amount, labor burden account and amount, and so on. This reflects the data that you entered during timecard or manual check entry.

  • If you choose to include billing information, the report shows the billing type, rate, currency, and so on.

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 the Payroll Transaction Reports folder, select Payroll Job 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 payroll program) manual checks, and reversed checks on the register.
  8. If you choose to print in summary format, choose whether to include employee subtotals on the register.

    9. If you choose to print in detailed format, choose whether to include:

    • Detail dates and hours that were entered on the timecard or manual check.
    • Description for each G/L account reported, if your database is integrated with General Ledger.
    • Billing information.
    • Optional fields, if you have defined optional fields in the payroll program for transactions.

  9. 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 choose 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 choose to sort the register by Posting Sequence, enter a range of posting sequences at the From and To fields.
  10. If you have defined optional fields in Payroll for transactions, you can choose to print only the checks 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.
  11. Click Print.
  12. When finished, click Close.