Skip to end of metadata
Go to start of metadata

This is an example of what the file format should be when importing time cards or job costing.

USE Time America

SamplePayrollImport.txt

L373-TRA,102,4,0
L373-TRA,101,0,152.32
L322-JIM,102,80,0
L322-JIM,103,4,0

Column Description:
1- Employee ID
2- Payroll Category Code
3- Rate
4- Quantity of hours

 

 

SampleJobCostImport.txt

W,L373-TRA,102,10/10/2009,4,14.50,0,MAIN,001,001
W,L373-TRA,102,11/10/2009,3,14.50,0,MAIN,001,001
W,L373-TRA,102,11/10/2009,4,23.20,0,SECS,001,001



Column		Descr1
1		"Work Detail Identifier"
2		Employee ID
3		Category Number
4		Date
5		Hours
6		Rate
7		Amount
8		Department
9		Job Center
10		Cost center