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).

If it is required by your company setup, you need to add your levels to the Clock Data.

Make sure that you format Start Time & End Time columns, (MM/dd/yyyy HH:mm) each time you use the csv file, they will not keep formatting when closed and opened again.

When you have completed your import template setup, click on save changes and close.

From Imports in ATA, click on Execute on your Clock Data Import.

Click on Choose your File to browse to your import file.

Select your file and click on open.

Click on Upload

If there are no errors, you will receive this message. Click on Ok.

Questions / Resources
If you have questions or comments please email
Find demos, tutorials, and more at our video library.
Last Review: 06/07/2022

Was this article helpful?
Views: 6