Import timesheet using the Standard interface

How to import timesheets using the standard interface.

 

  1. Start Acclaim and login into your company.
  2. Select the pay period : Payroll > select pay period > Save.
  3. Start payroll process: Payroll > Process payroll.
  4. From top menu click Batch > Batch Create Timesheet.
  5. Make your selection > click Batch.
  6. Confirm the overwriting to begin the process.
  7. Select the interface > select the File. Based on the interface select the entries will be different.
    Example of import using Standard Interface shown below.

The file to be imported using the Standard interface must have a Header, detail record and Trailer Record.

 

Timesheet Import Interface - Standard

The timesheet import file, Standard, is text file with the following structure:

Note: The file should have at least 3 lines.

Structure of the Header Record

PositionMeaningFieldTypeWidthDecimalValue
01RecIDAlpha1 H

Header record

02 to 250FillerAlpha249 <spaces>Filler

 

Structure of the Detail Record

All numeric fields have one space for sign (+ or -) For example Width of the field is 8 that consists of number and decimal point. Right after the number leave a blank for positive number or type (-) for negative number.

Position

Field

Type

Width

Decimal

Value

Meaning

01

RecID

Alpha

1

 

D

Detail Record

02 to 11

EmpNum

Alphanumeric

10

 

<Emp#>

Employee’s Number

12 to 19

EUnit1

Numeric

8

2

<99999.99+>

Number of units for Earnings Unit Type 1

21 to 28

EUnit2

Numeric

8

2

<99999.99+>

Number of units for Earnings Unit Type 2

30 to 37

EUnit3

Numeric

8

2

<99999.99+>

Number of units for Earnings Unit Type 3

39 to 46

EUnit4

Numeric

8

2

<99999.99+>

Number of units for Earnings Unit Type 4

48 to 55

EUnit5

Numeric

8

2

<99999.99+>

Number of units for Earnings Unit Type 5

57 to 64

EUnit6

Numeric

8

2

<99999.99+>

Number of units for Earnings Unit Type 6

66 to 75

EAmnt1

Numeric

10

2

<9999999.99+>

Amount for Earnings Amount Type 1

77 to 86

EAmnt2

Numeric

10

2

<9999999.99+>

Amount for Earnings Amount Type 2

88 to 97

EAmnt3

Numeric

10

2

<9999999.99+>

Amount for Earnings Amount Type 3

99 to 108

EAmnt4

Numeric

10

2

<9999999.99+>

Amount for Earnings Amount Type 4

110 to 119

BAmnt1

Numeric

10

2

<9999999.99+>

Amount for Benefits Amount Type 1

121 to 130

BAmnt2

Numeric

10

2

<9999999.99+>

Amount for Benefits Amount Type 2

132 to 141

BAmnt3

Numeric

10

2

<9999999.99+>

Amount for Benefits Amount Type 3

143 to 152

BAmnt4

Numeric

10

2

<9999999.99+>

Amount for Benefits Amount Type 4

154 to 163

DAmnt1

Numeric

10

2

<9999999.99+>

Amount for Deductions Amount Type 1

165 to 174

DAmnt2

Numeric

10

2

<9999999.99+>

Amount for Deductions Amount Type 2

176 to 185

DAmnt3

Numeric

10

2

<9999999.99+>

Amount for Deductions Amount Type 3

187 to 196

Damnt4

Numeric

10

2

<9999999.99+>

Amount for Deductions Amount Type 4

198 to 250

Filler

Alpha

54

 

 

 

Note: For all the numeric fields, the sign + may be - for negative amount.

 

Structure of the Trailer Record

Position

Field

Type

Width

Decimal

Value

Meaning

01

RecID

Alpha

1

T

 

Trailer record

02 to 07

NumRecs

Numeric

6

0

<999999>

Number of detail records

08 to 18

TotEUnit1

Numeric

10

2

<9999999.99+>

Grand total of EUnit1

19 to 29

TotEUnit2

Numeric

10

2

<9999999.99+>

Grand total of EUnit2

30 to 40

TotEUnit3

Numeric

10

2

<9999999.99+>

Grand total of EUnit3

41 to 51

TotEUnit4

Numeric

10

2

<9999999.99+>

Grand total of EUnit4

51 to 62

TotEUnit5

Numeric

10

2

<9999999.99+>

Grand total of EUnit5

63 to 73

TotEUnit6

Numeric

10

2

<9999999.99+>

Grand total of EUnit6

74 to 86

TotEAmnt1

Numeric

12

2

<9999999.99+>

Grand total of EAmnt1

87 to 99

TotEAmnt2

Numeric

12

2

<9999999.99+>

Grand total of EAmnt2

100 to 112

TotEAmnt3

Numeric

12

2

<9999999.99+>

Grand total of EAmnt3

113 to 125

TotEAmnt4

Numeric

12

2

<9999999.99+>

Grand total of EAmnt4

126 to 138

TotBAmnt1

Numeric

12

2

<9999999.99+>

Grand total of BAmnt1

139 to 151

TotBAmnt2

Numeric

12

2

<9999999.99+>

Grand total of BAmnt2

152 to 164

TotBAmnt3

Numeric

12

2

<9999999.99+>

Grand total of BAmnt3

165 to 177

TotBAmnt4

Numeric

12

2

<9999999.99+>

Grand total of BAmnt4

178 to 190

TotDAmnt1

Numeric

12

2

<9999999.99+>

Grand total of DAmnt1

191 to 203

TotDAmnt2

Numeric

12

2

<9999999.99+>

Grand total of DAmnt2

204 to 216

TotDAmnt3

Numeric

12

2

<9999999.99+>

Grand total of DAmnt3

217 to 229

TotDAmnt4

Numeric

12

2

<9999999.99+>

Grand total of DAmnt4

230 to 250

Filler

Alpha

21

 

 

 


Note
: For all the numeric fields, the sign + may be - for negative amount.

112 review(s) | Add your review