Date printed: 11-05-2024   Last updated: 07-21-2021

To view our complete support knowledge base and most current version of this article visit support.timeips.com.
316-264-1600
Information
Sales
Support

Applies to versions: 3.1, 3.2



Manual Payroll Export



TimeIPS Payroll Export can generate a file with your payroll data. Many of these files can be opened in a spreadsheet application, such as Microsoft Excel or OpenOffice Calc, or, if using the Payroll Integration with Benefits Tracking optional module, the file can be imported in your payroll application, such as ADP, Paychex, or QuickBooks.

 

 

Using the left pane Main Menu » Administration, click on: Payroll » Payroll Export

 

 

 

 

 

Prepare Payroll for Export

First, choose to generate the report by Payroll Type or Manually select employees and a range of time.

 

 

    Payroll Type

  1. Under Export Type, select Payroll Type to generate the report. (See "Manual" below for specifics on that option.) 
  2. Select a Payroll Type. All employees (including released employees) that are currently in the selected Payroll Type will be included in the prepared payroll data.
  3. Select the Payroll Period from the drop-down boxes.
  4. Select a Time Zone. The start and end time of the export can be interpreted in the company's timezone or separately for each employee.
  5. Required Break should generally not be set. When not set, the report runs for the exact time range selected for all employees and will generate accurate and easy-to-confirm results. If it is set, the start and end dates of the report may be moved forward as needed for each employee to the next point where a break in worked/benefit/holiday time exceeds this duration. This allows hours on a "shift" that runs past the normal end of the report range to be included at the end (and excluded from the beginning).  In special cases this can be helpful by allowing employees to see all the hours on their shifts, and avoiding have a shift split onto two reports.
  6. Select Pre-checks to determine what the system will check prior to attempting to prepare a payroll export.
    • The following choices are available in the drop-down box: All, Currently clocked in, Overlapping time events, Default Overtime Policy, Already payrolled events, and Timesheet approvals.
  7. Optionally, select whether or not to Lock While Preparing. In choosing to lock the payroll period while the export is pending, you can also choose to include influence bounds which expands to include the full range of time affected. 
  8. Optionally, click the Run pre-checks only. If you receive the "All chosen checks passed" message, you can choose to do a different check or progress forward to preparing payroll.
  9. Click the Prepare Payroll for Export button.

 

 

    Manual

  1. Under Export Type, select Manual to generate the report. (See "Payroll Type" above for specifics on that option.)
  2. Select an employee or group of employees to include in the export.
  3. Manually select a range of time for this report, or use the quick selection drop down box.
  4. Select a Time Zone. The start and end time of the export can be interpreted in the company's timezone or separately for each employee. 
  5. Required Break should generally not be set.  When not set, the report runs for the exact time range selected for all employees and will generate accurate and easy-to-confirm results.  If it is set, the start and end dates of the report may be moved forward as needed for each employee to the next point where a break in worked/benefit/holiday time exceeds this duration. This allows hours on a "shift" that runs past the normal end of the report range to be included at the end (and excluded from the beginning).  In special cases this can be helpful by allowing employees to see  all the hours on their shifts, and avoiding have a shift split onto two reports.
  6. Select Pre-checks to determine what the system will check prior to attempting to prepare a payroll export.
    • The following choices are available in the drop-down box: All, Currently clocked in, Overlapping time events, Default Overtime Policy, Already payrolled events, and Timesheet approvals.
  7. Optionally, select whether or not to Lock While Preparing. In choosing to lock the payroll period while the export is pending, you can also choose to include influence bounds which expands to include the full range of time affected. 
  8. Optionally, click the Run pre-checks only. If you receive the "All chosen checks passed" message, you can choose to do a different check or progress forward to preparing payroll.
  9. Click the Prepare Payroll for Export button.
  10.  

    Next you should see the payroll calculation being scheduled.

 

 

 

 

 

     

     

Export Manual Payroll

After the payroll data is prepared for export, the Pending Export window will open.

  1. Select Manual (.csv) from the drop down menu. The Manual payroll export offers a basic comma separated values file that can be opened in a spreadsheet program such as Open Office Calc or Microsoft Excel.
  2. Next click on the button labelled Export Payroll Data.
  3. NOTE: Editing of time events is locked during payroll processing to avoid having another user make changes via the Time/Edit Report that would not be reflected properly in the current payroll run.

     

 


If you have not already created a Manual , you will see the following screen.

Click the Add Settings button to begin setup.

NOTE: Export Settings are a set of stored settings that are used each time a payroll file is generated. If your preferences change from one group of employees to another, you may create multiple export settings and select the set that applies for the group you are exporting at the time.

 

 

 

 

  • Once your selections have been configured, click on Save Settings to save, or Cancel to exit without saving.
  •  

     

    1. On the next screen be sure that your new setting name is the one selected in the Export Settings drop down menu.
    2. Optionally, you can add a comment to the export making it unique and easily identifiable.
    3. Click Continue.
    4.  

       

      Next you should see the payroll calculation being scheduled.

     

     

     

    Payroll Export Data - Final Step

     



    ©2004-2023 TimeIPS, Inc. All Rights Reserved - TimeIPS and the TimeIPS logo are registered trademarks of TimeIPS, Inc.
    "Intelligent Personnel System" "Run your Business. We'll watch the clock." are trademarks of TimeIPS, Inc.
    TimeIPS is protected by one or more patents. Patent No. US 7,114.684 B2.