Import Timecard Data

You may create time sheets in a CSV spreadsheet to import into Horizon Payroll Timecards.

Create Import File

The columns must be in the order shown below.

  1. The Amount column is not needed and is present only to calculate the pay amount for the person inputting the spreadsheet.
    1. You may add additional columns for user information to the right of the required columns.
  2. Do not add any information below your last line of data.
  3. Do not insert any blank lines between your data.
  4. Do not format the number columns with commas or $.
  5. You may format number columns to show decimal places.
  6. Format the IFC and GL columns as text.
  7. The Date field may be left blank to use the default Time Card Date entered during the import process.
  8. Enter dates for Sick, Vacation, PTO, Overtime, etc. that should be different than the default Time Card Date.
  9. You may save the sample spreadsheet which will download from the following link: ftp://ftp.horizon-is.com/documents/Downloads/PR-Time_Import.xls
  10. Save the CSV file
    1. Once you have completed entering time and have verified the information.
    2. Save the file as a .csv (comma delimited).
    3. This will save in the proper format for importing.  
    4. Once you save the file as a .csv format, do not reopen the file as this will create improper formatting.

Import File

NAVIGATION: UTILITIES menu > Import Time Care Information

  1. Select Horizon Standard Import GL Version
  2. File Name:  Browse for the time card .csv file you have saved
  3. Enter or select the correct Time Card Date to apply to all records
  4. Place a check in the Initialize Time Card File box if you want all entries already in Time Card Entry to be deleted before importing.
    1. This will delete all time card data that may have been entered and reset the timecard totals to zero.
    2. Do not check this box if you want the time already entered in the Timecards to remain.
  5. Press IMPORT PROCESS on the Quick Links bar. When the Activity box disappears, press CLOSE.
  6. Review the Time Card Register to verify the import is correct
  7. If the import process detects an error in the file, an error report will be created.  Please review and fix the file, then import again.
  8. TIP:  You may import two timecard dates by using two excel files.
    1. Import using the first date such as 12/31/2020.  The Initialize Time Card File box may be checked or unchecked as needed.  
    2. Import the second file with the second date, such as 1/1/2021. The Initialize Time Card File box must be unchecked during the second import so the previously imported data is not deleted.
  9. TIP:  You may delete all entered timecard data to reset and start over by importing a blank .csv file with the Initialize Time Card File box checked.
    1. You may then run auto-setup time cards to bring time card information over from the Employee Master.
    2. This is helpful if the auto-setup of time card process was run more than once.

See Process Payroll

12/2023

NEED MORE HELP?  Submit a ticket to the Help Desk or call (814) 535-7810 or (800) 889-3388