Company Info

Sage 100 Contractor 5-5-1 Daily Payroll


Import Daily Payroll directly into Sage 100 Contractor. Simply download your daily payroll into Excel, review and apply daily payroll information and import directly into Sage 100 Contractor 5-5-1 Daily Payroll.

Are you tired of manually keying in Daily Payroll one by one into Sage 100 Contractor? Would you rather download your daily payroll, fill in the blanks in Excel and import the details directly into Sage 100 Contractor? The following integration template allows you to do just that. It mimics every feature and function of the 5-5-1 Daily Payroll data entry form.

Key Features:

Import Template Download:

Import File Layout:

HeaderReferenceData TypeTabExampleDescription
paydteRequiredDateyyyy-mm-ddTime Entry Date
empnum**NumericEmployee No
dscrptString (50)Description
wrkord**String (20)Service Invoice No
jobnum**NumericJob No
loctax**NumericLocal Payroll Tax
crtfidString (1)Y=yes;N=noCertified Payroll
phsnum**NumericPhase No
cstcde**Numeric (12,3)Cost Code
paytyp**Numeric1=Regular; 2=Overtime; 3=Premium; 4=sick; 5=Vacation; 6=Holiday; 7=Piece Pay; 8=PerDiem; 9=Misc PayPay Type (1)
paygrp**NumericPay Group
payrteNumeric (6,4)Pay Rate
payhrsNumeric (5,2)Pay Hours
pcerteNumeric (6,4)(1) Pay Type = 7Pieces Rate
piecesNumeric (8,2)(1) Pay Type = 7Pieces Units
cmpcde**Numeric(Required if Emp No)Workers Comp Code
eqpnum**NumericEquip Repaired No (2)
opreqp**NumericOperated Equipment (3)
eqpuntNumeric1=Hours; 2=Days; 3=Weeks; 4=Months; 5=Miles (3) Operated Equip RequiredEquip Cost Unit Type
oprhrsNumeric (5,2)(2) Equip Repair No Required (3) Operated Equip RequiredEquip Operated Cost Units
stdhrsNumeric (5,2)(2) Equip Repair No Required (3) Operated Equip RequiredEquip Standby Cost Units
idlhrsNumeric (5,2)(2) Equip Repair No Required (3) Operated Equip RequiredEquip Idle Cost Units
blluntNumeric1=Hours; 2=Days; 3=Weeks; 4=Months; 5=Miles (3) Operated Equip RequiredEquip Rental Unit type
oprbllNumeric (6,2)(3) Operated Equip RequiredEquip Operated Rental Units
stdbllNumeric (6,2)(3) Operated Equip RequiredEquip Standby Rental Units
idlbllNumeric (6,2)(3) Operated Equip RequiredEquip Idle Rental Units
usrdf1String (50)User Defined

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor

File Example:
PRDAILY,"2019-06-23",8547,"import time",1,1,20,8,5606
PRDAILY,"2019-06-23",8548,"import time",1,1,20,8,5606


System Requirements:

Requires the Sage 100 Contractor Data Integration Suite