How to Import Timecards

This help document will walk users through how to import time from third party timeclocks that users wish to create timecards for. The import feeds are written by the reports team. Once written, users may follow the below steps to run the import.

The timecard import process is broken into four parts:

  1. Import File - upload file to Enterprise
  2. Map Data - match timecards to employees in the system 
  3. Run Data Integrity Check - Review any errors or missing information
  4. Post Transactions - post the time information to the time entry area in Pay/Bill in order to complete payroll/billing

Locating the Timecard Import

To locate the timecard import:

 Navigate to Pay/ Bill and expand Other in the upper navigation tree

Once in "Other" select Timecard Import. 


Import a New File

To import a new file select the + icon

After selecting the + icon, a secondary window will populate. Within this window select the import  "Feed Type" you wish to use, if there are multiple they will also appear here.

Once the feed type is selected, select the customer that you will be importing time for.  All of your customers that will be using imports will be linked to the import they're using and will appear in the drop down:

The Weekend Bill is always going to be the open Weekend Bill from Pay/Bill:

For the file name, you'll need to use the folder icon to navigate to where the saved file with hours are stored from the customer you're importing. 

Once you've located the file, select the save icon:

Once you hit save, you will be brought to the worksheet page beneath Timecard import. Under step one you will have the opportunity to select a new document if you selected the wrong one, or you can hit the import button to start the process. 

At any time should you realize there was a typo on the document you can update the document and re-import it to fix any mapping issues resulting from the typo.


Mapping Imports

Once you've hit import, the Map button will become available. 

Selecting map will go through and locate the employees that are on the imported document. The system will let you know how many employees were mapped, and you can use this to validate whether or not all the employees you’re expecting have been located.

 

Data Integrity Check

Once you’re ready select the Run Check button to begin the integrity check on the data in the file.

If any errors occur (for instance if an employee in the file couldn’t be mapped or an employee has two open assignments at the current customer and the import doesn’t know which to choose), they will occur now and you’ll be told how many there are. To view these errors and correct them you can use the view button.

Under the view area is also where you can see any warnings brought up in the integrity check. Warnings are not hard stops and won’t prevent you from posting the data to time entry. On the right hand side you can also see how the data was mapped. The assignment, WEB, employee name and SSN, and Reg/OT/Total hours from the imported document are listed.


Posting Import

Once everything has passed the integrity check and all errors have been resolved or excluded select post, allowing the transactions to be created in time entry.

If you do a lot of time entry through the timecard import you can add the TCFeedID column to the time entry screen to sort on your imports. That column will relate back to the ID field from the worksheet page and the ID column on the Timecard Import page. 

Timecards that come over from a timecard import are also automatically thrown into a proofing session the name of whoever posted them. You can review the timecards in time entry or go straight to proofing.

Related Articles