Date printed: 01-18-2019   Last updated: 07-08-2007

To view our complete support knowledge base and most current version of this article visit

Applies to versions: 1.5

Manual Payroll Export Settings

TimeIPS Payroll Export can generate a file with your payroll data. The file can be opened in a spreadsheet application, such as Microsoft Excel or Open Office. Using the Payroll Integration with Benefits Tracking (IPSQBI) optional module, the file can be imported in your payroll application.

Security Level Required: Payroll Administrator

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

Step 2: Configure Export

Before you export:

  1. After selecting your export contents (date range, employees and export format), click on the Continue to Step 2 --> button.

  2. The first time you run a payroll export, you will be asked to provide a "preset", or template, for your export. Click on the Add Preset button to configure your payroll preset.
    - OR -
    If you already have a defined preset you wish to use, select the preset name from the Export Settings pull-down, then skip to Step 4.

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

  4. The preset window will appear.

  5. Click on Save Settings to save, or Cancel to exit without saving.

  6. (Optional) Enter a descriptive Comment to assist in differentiating past and future payroll runs.

    NOTE: If you decide not to calculate time for your payroll export at this time, click on "<-- Back to Step 1"
  7. Once you are ready to calculate payroll, click on the Continue to Step 3 --> button. TimeIPS will calculate your payroll and generate the export file based on the settings in the selected Preset.

  8. Once payroll has been calculated, your screen will refresh back to Step 1 and you will see your pending export at the bottom of the screen. Click on Mark Paid to examine your export file and/or to export the file into your payroll application.

  9. NOTE: TimeIPS locks the selected payroll events from editing while the payroll is in Pending status. This prevents employees from adjusting time events that are being processed for payroll.

  10. Click on the file name link (manual-payroll-Jun-03-2007-1183925958.csv in the example below) to view the contents of the export in a spreadsheet application such as Excel or OpenOffice Calc. Once you have confirmed that the contents have exported correctly, click on Yes, the export was accepted to import the file into your payroll software, or click the <-- Cancel button to return to Step 1.

    NOTE: Once your transactions have been payrolled, TimeIPS will lock the time events from future edits.

    With the default settings, the following fields will be exported:

    • Employee Name
    • SSN
    • Alt. Employee Number
    • Department
    • Hourly
    • Work Day Starting On
    • Hours
    • Pay Type
    • Pay Rate
    • Total Pay
    • Notes

  11. When your payroll has been successfully imported into your payroll software, the screen will refresh and you will see that the "Mark Paid" status has changed to Payrolled.

  12. As you continue to export payroll, TimeIPS will maintain a list of all of your payroll exports. The latest export will always be at the top of this list.

See Also:
Payroll Export (TimeIPS Version 1.5) (1.5)

©2004-2019 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.