Applies to versions: 1.11, 2.0, 2.1

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

Export Format

There are many different file formats available to export and view the payroll report. A preset will need to be created using your desired format in order to export.

1. Click the + (plus) sign to the left of Payroll Format Settings bar to expand the window.
2. From the drop down box, select the File Format to modify.
NOTE: In the example above, "Manual (.csv)" has been chosen. The manual payroll export offers a basic comma separated values file that can be opened in a s spreadsheet program such as Open Office Calc or Microsoft Excel.
3. Click the Edit Payroll Export Settings button to bring up the editing screen.

 

 


If you have not already created a preset for this file type, you will see the following screen.




Click the Add Preset button to begin setting up a preset for the chosen file type.

 

 






There are several other different options available which vary depending on the file type being created.

4. Give the preset a unique Name.
5. Make the appropriate selections for your company's needs.
6. Click on the Save Settings button.

 

 







7. On the next screen be sure that your new preset is the one selected in the Export Settings Preset drop down menu.
8. Optionally if you wish to add a comment to the export making it unique and easily identifiable you can do so now.
9. Click Continue

 

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. 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. Click the Prepare Payroll for Export button.





 

Next you should see the payroll calculation being scheduled.

Export Payroll

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

1. Choose a file format from the drop down menu.
   NOTE: There are many export formats available, in the above example Manual (.csv) has been chosen. 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 labeled Export Payroll Data.
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 preset for this file type, you will see the following screen.

Click the Add Preset button to begin setting up a preset for the chosen file type.

There are several different options available for customization which vary depending on the file type being created. Name your new preset and make the appropriate selections for your company's needs before clicking on the Save Settings button.

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

 

 

Next you should see the payroll calculation being scheduled.

Payroll Export Data - Final Step

The final step of exporting payroll data is virtually the same regardless of file type chosen, though the window/image may vary.

Example 1:

• Click the blue link to Download the data and open it in a spreadsheet program such as Open Office Calc or Microsoft Excel.
• If you have confirmed that the information contained in this export is correct and wish to permanently lock the payroll period, click the button labeled Lock This Payroll Period, otherwise choose Unlock and Return to TimeIPS. Locking the payroll period prevents future modifications of any kind.
  NOTE: If you choose "Unlock and Return to TimeIPS.", the export will be listed as "Pending" and futher changes can be made to the data. Pending exports can be exported again to other payroll output formats as often as you like until they have been accepted/locked.
  If you choose "Lock This Payroll Period", the payroll status will show "Exported". Exported payroll runs are locked and time can no longer be edited in the system for that period of time.

Example 2:

• Click the blue links to Download the newly created files and open them in a spreadsheet program such as Open Office Calc or Microsoft Excel.
• If you have confirmed that the information contained in this export is correct and wish to permanently lock the payroll period, click the button labeled Yes, the export was accepted otherwise choose Cancel, return to TimeIPS. Locking the payroll period prevents future modifications of any kind.
  
  NOTE: If you choose "Cancel, return to TimeIPS", the export will be listed as "Pending" and futher changes can be made to the data. Pending exports can be exported again to other payroll output formats as often as you like until they have been accepted/locked.
  If you choose "Yes, the export was accepted", the payroll status will show "Exported". Exported payroll runs are locked and time can no longer be edited in the system for that period of time.