What information is included in the Sage 100 Payroll Perpetual History report

Description

When using Tips Earned (TE) earnings code, FICA TIP Taxes Withheld (Tax Type=F) are not updated to Perpetual History Detail File (PR_23) in Data File Display and Maintenance. Only the FICA Taxes withheld on non tip earnings are updated in PR_23.

The field for FICA taxes withheld combines FICA taxes and FICA Tip taxes on the report. 

Resolution

The Perpetual History Report lists payroll check detail retained by employee and check number. This report includes detailed earnings and deduction code information and can be retained indefinitely.

The report can be printed for all employees or for the following:

  • a selected range of employees
  • by check date or a specific range of check dates
  • by a specific pay period ending date or a range of pay period ending dates.

The report is sorted and subtotaled by employee number and department and can be produced in a summary or detail format. In addition, this report can be printed with a page break by employee or department.

Important Note: This report is available only if the ‘Retain Perpetual Payroll History’ check box is selected in the Payroll Options (under Payroll, Setup menu).  If this option is unchecked when payroll data entry is updated, the check details will not update to the perpetual history files for that particular check register update.

  1. Open Payroll, Reports, Perpetual History Report.
  2. In the Report Type To Print drop-down box, select Detail by Check or Summary by Employee.
  3. In the Page Break Option drop-down box, select “By Employee”, “By Department”, or “Standard Break”.
  4. Select the Print Earnings, Deducts and Tax Totals check box to include earnings, deductions, and tax totals. Clear the check box to exclude earnings, deductions, and tax totals.
  5. In the Employee Number field, enter a range of employee numbers, or select the ‘All’ check box to include all employee numbers. Click the lookup button to list all employee numbers.
  6. In the Check Date field, enter a range of check dates, or select the ‘All’ check box to include all check dates.
  7. In the Pay Period Ending Date field, enter a range of pay period ending dates, or select the ‘All’ check box to include all dates.
  8. Click Print or Preview button.