Resource Center Home
Resource Center Home

HR and Payroll for Dynamics GP

HR and Payroll for Dynamics GP

Clock Data Import

From your Advanced Time and Attendance Dashboard, click the Payroll Functions tab and select Imports.

Click on Add New Record.

  1. Name the import Clock Data Import, (or what ever type of import you are doing)
  2. Select File Type Delimited
  3. Delimiter use: ,
  4. Start import at row 2 (Use position 1 as a header)
  5. Special formats:
    1. Decimal separator use: .
    2.  Date format: MM/dd/yyyy hh:mm    *MM stands for month, mm stands for minute*
  6. File Structure (position #’s correlates to columns A, B, C etc. on import template)
    1. Card ID          Position 1
    2. Start Time     Position 2
    3. End Time       Position 3
    4. Total Time    Leave blank
    5. Punch Type   Position 6
    6. Punch Class  Position 1

Click Save

Now you will see it under your imports

These are the headers for the Clock Data Import template.  GP Position, Department, and Work Position Pay Code does not need to be used unless it is required for you company’s setup, (Org Levels or Dimensions).