Open topic with navigation

Detailed Pay Entry Spreadsheet

Details

The pay entry spreadsheet contains time, pay, and any manual check data for the calculation of payroll.

Detailed Pay Entry Procedure

1. Open the payroll entry spreadsheet.
2. Select the Payroll Calendar for payroll time entry.
3. Select the first employee to enter or review time for from the selection list.
4. Review or enter the pertinent payroll information for each employee record.
5.  Save each record.
6. Navigate to the next employee's record, and repeat steps 4 and 5 for each employee.
7. Close the spreadsheet when you have created valid time records for all employees in the pay group that should be paid.

Buttons

The following defines the buttons on the spreadsheet entry screen.

• Delete Row.  To clear or delete the selected row, click on Delete Row. Remember to save after you delete.

• Apply Defaults.  To apply a row of default entries based on defined preferences, click on Apply Defaults.
•  Net to Gross.  Type the desired net amount in the field below it, then click the Net to Gross button, and the system calculates net-to-gross and displays it as a manual check.
•  Manual Check.  The gross-to-net is calculated for that time entry. The check calculation displays in edit mode. To keep the manual check, apply it.
• EE Profile.  Displays the employee profile and calendar information in read-only mode for the displayed employee.
•  Batch Detail.  Displays batch totals by User Group Code.

Checkbox Flags

The following checkboxes flag the row with the type of entry.

• Manual Check?  Is the row for a manual check?
• FLSA OT Record?  Did the row use the FLSA OT Record?
• Accum FLSA?  Did the row use the Accumulate FLSA calculation?
• Auto Pay?  Was the row a result of the "Create Auto Pay" feature?