Create Paychecks from Time Records

Create Paychecks from Time Records

This section provides an overview of the process for creating paychecks from time records in OnTarget.


Confirm that the system is configured to create paychecks from time records.  This setting is managed under List Configuration, Payroll, Rules.  When this check box is de-selected, the source of the paycheck is time records rather than timesheets.





The first step is to click on Calculation Options under the Time Records desktop.  Enter in the check date of the payroll and select the pay period.  A list of all of the deductions is shown.  Any deduction that is checked will be withheld from employee’s paycheck, as long as the employee record has a deduction set up to be withheld.  These deductions can be unchecked in the event that a paycheck should be created but deductions should not be withheld for the particular payroll run.  An example of this scenario is for a correction check where an employee and their health insurance has already been withheld for the pay period.  For the correction check, deductions should not be withheld again, so this would be an easy way of creating the check without taking the deduction.  Keep in mind that If a deduction needs to be discontinued altogether for an employee, then it should be inactivated at the employee record.





Click save once the form has been completed.


Next, go to Employee Timesheet.  To run this report, enter at the minimum, a date range.  The report will then show all unpaid hours for that timeframe.  To get a glimpse into the hours that will create paychecks, run this report either for a particular cost center or employee, or for all employees.





Adjust the start date of the pay period in order to show time from previous pay periods that may not have been paid.  This is helpful for showing any time associated with documentation that may have been entered late that needs to be paid.  Any of those older dates of service will show on the report as long as the start date of the pay period is backed up to include those dates of service.


Run the report for either a particular cost center or employee, or for all employees across all cost centers.  In the standard version of the report, the total hours per pay type display for the specified pay period, along with their respective rates and the grand total.


An important feature of this report is that it will display an error for any hours that will not transfer to a paycheck due to missing pay types.  The system will force that a pay type is setup to support each service and cost center the employee worked.  This is of great benefit as it ensures that the revenue for cost center and service matches to the payroll wages.  It will also report on overlapping time making certain that individuals are not being overpaid. It will also help catch any keying errors.


Any errors will be listed on the very bottom of the report.  In this case, Clara Barton provided the IISB-A service in the Winston Salem cost center and therefore a pay type needs to be setup.






This same report can be run in the unformatted version if the data needs to be dumped to excel for filtering of the data.  The report can also be run in a daily summary format in order to get a break down of the hours per day.


Once the errors have been cleared up and the hours reviewed, the next step is to create paychecks.  To create paychecks from time records, set the necessary filters first. 


First, set the payroll date range.  Next, set the Imported to Pay Transactions filter to "Not Imported".  This will present only records that do not have an associated check.  Set the Paid filter to "Not Paid".  This will ensure that only records that have not been marked as paid by the system will be returned.  Click the Search button to refresh the Time Records search grid based on the filter settings.  Finally, click on the Create Paychecks button.  If specific time records are selected, choose the From Selected option.  Select "From All" to create checks from all time records presented in the grid view. 





Any errors in creating paychecks will be presented.  This report can be exported for further review.  All errors must be cleaned up before the check can be created.  Most of the errors rely on components of the employee record to be addressed.  Once the error has been fixed, click the Create Paychecks button again.  This will only create checks for any employee whose check has not yet already been created. There is no need to select the individuals name, as the system will not duplicate a check if one has already been created.


Below is list with descriptions of commonly encountered paycheck creation errors and how to correct them:


No zero non-disbursements are defined for this employee:  Go to Maintain Employees Pay disbursements tab.  Add in the correct pay disbursement method for the stated employee.  Repeat the Create Paychecks step so the calculation will pick up the edit.


No tax information configured for this employee:  Go to Maintain Employees Taxes tab.  Add in the correct marital status and tax withholdings for both the Federal and State lines for the stated employee.  Repeat the Create Paychecks step so the calculation will pick up the edit.


Negative Net Pay Calculated:  The amount of deductions being withheld from the stated employee exceed the amount of net pay calculated.  Go to Maintain Employees Misc. Deductions tab and adjust a deduction amount so that it doesn’t exceed the gross pay.  Repeat the Create Paychecks step so the calculation will pick up the edit.


Be aware that the filters for cost center or employee can be used to toggle how the deductions are to be withheld when creating the paychecks.  This allows for flexibility in handling any exceptions for how deductions should be applied on an individual basis, if necessary.


Once all of the paychecks have been created and the errors cleaned up, then it is time to review the paychecks.  To do so, go to Paychecks. Search for paychecks using any combination of the filter options.  To review all paychecks created for the check date, enter in the check date or use the pay period filter and search.





To review the details of a check, open up the check.  Pay transaction details for each pay type are displayed as well as the pay stub below  to review the gross, deduction and net totals.





If there are any additional ways to pay the employee, the units can be directly keyed in against the corresponding pay types. Edits can also be made against pay types for imported time.  To do so, simply adjust the unit value and then hit save and calculate.  A new stub will appear with the new totals.


An important function to know about is the Reduce Salary function.  This function allows payroll to correctly allocate the billable hours a salaried employee worked per service and cost center and to still only pay them their salaried rate.  Another way this is helpful is to track paid time off for salaried employees.  To perform this function, click the Reduce Salary check box for each hourly pay type that should be included in the salary rate.  When the box is checked, a ‘Reduce Salary’ button will appear at the bottom right of the screen.  Click this button to reduce the salary amount by the imported hours.  The salary and hourly pay types combined will equal to the flat salaried rate.





Continue to edit paychecks as necessary by opening them up individually from the search grid.


Collectively review the checks by using the Check Review report.  Review all checks in the grid by selecting "From All" or select checks to review and choose the "From Selected" option.  Check Review Summary is a 1 page report that provides grand totals for the checks in the grid.  Check Review Unformatted shows the break down on units by pay type and cost center.





Generate checks by clicking on the Print Checks button.





It may be beneficial to use the disbursement filter to separately prepare the direct deposit file and the physical checks if both disbursement types are included.  This is a good way to save paper if direct deposit stubs aren't needed, while keeping in mind that OnTarget user will still get their stub on their dashboard in the Paychecks dashlet.



[advanced_iframe securitykey=”omnistream” allowfullscreen=”” frameborder=”0″ height=”315″ src=”” width=”560″][/advanced_iframe]