Company Info

Sage 100 Contractor 5-2-2 Payroll Records

Overview:

Import Payroll Records directly into Sage 100 Contractor. Simply download your payroll records into Excel, review and apply payroll record information and import directly into Sage 100 Contractor 5-2-2 Payroll Records.

Are you tired of manually keying in Payroll Records one by one into Sage 100 Contractor? Would you rather download your payroll records, 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-2-2 Payroll Records data entry form.

Key Features:

Import Template Download:

Import File Layout:

COL1RequiredString (3)PRRPRR
COL2RequiredString (1)HHeader Record
COL3RequiredNumericEmployee No
COL4RequiredDateyyyy-mm-ddPeriod Start
COL5RequiredDateyyyy-mm-ddPeriod End
COL6RequiredString (20)If no check enter '0000'Check No
COL7RequiredDateyyyy-mm-ddCheck Date
COL8Required **Numeric1=Regular; 2=Bonus; 3=Hand Computed; 4=Startup; 5=Advance; 6=Third PartyPayroll Type
COL9Required **Numeric1,2,3 or 4Quarter
COL10RequiredString (2)Blank = Emp SetupState
COL11Numeric1=True;0=FalseDirect Deposit (1)
COL12Numeric (10,2)Blank or 0 = Emp SetupSalary
COL13Numeric (6,4)Blank or 0 = Emp SetupReg Hrly Rate
COL14Numeric (6,4)Blank or 0 = Emp SetupOT Hrly Rate
COL15Numeric (6,4)Blank or 0 = Emp SetupPremium Hrly Rate
COL16TextNotes

** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
COL: a placeholder must be provided for each column even if no value is provided
(1) If marked as True then Direct Deposits must be activated for the respective employee, otherwise the entry will be rejected, If left "Blank" the direct deposit flag will be derived from the Employee Setup Record

Details
COL1RequiredString (3)PRRPRR
COL2RequiredString (1)DDetail Record
COL3RequiredNumericEmployee No
COL4RequiredDateWork Date
COL5String (50)Line Description
COL6**String (20)Service Order No
COL7**NumericBlank=derived from COL6 Svc Order NoJob No (1)(2)
COL8**NumericEquip Repaired No (1)
COL9**NumericLocal Payroll Tax
COL10String (1)Y=yes;N=no;Blank=dervied from JobCertified Payroll
COL11**NumericPhase No
COL12**Numeric (12,3)(2) Required if Job No or Service Order specifiedCost Code
COL13Required **Numeric1=Regular; 2=Overtime; 3=Premium; 4=sick; 5=Vacation; 6=Holiday; 7=Piece Pay; 8=PerDiem; 9=Misc PayPay Type (3)
COL14**NumericBlank=derived from EmployeePay Group
COL15Numeric (6,4)Blank=dervied from Employee based on pay typePay Rate
COL16Numeric (5,2)Hours Worked
COL17Numeric (6,4)(3) Required if Pay Type = 7Pieces Rate
COL18Numeric (8,2)(3) Required if Pay Type = 7Pieces Units
COL19Required **NumericBlank=derived from EmployeeWorkers Comp Code
COL20**NumericBlank=dervied from JobDepartment
COL21**NumericAbsence
COL22String (50)Userdefined
COL23TextNotes

** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
COL: a placeholder must be provided for each column even if no value is provided
(1) Either a Job No or Equip Repaired No may be entered but not both
(2) Cost Code is Required if a Job Number or Service Order is specified. If Service Order is specified and the cost code is blank the cost code will be derived from the Service Order
(3) Pieces Rate and Unit are required if Pay Type = 7

Calc Override
COL1RequiredString (3)PRRPRR
COL2RequiredString (1)CCalc Record
COL3RequiredNumericEmployee No
COL4Required **NumericPayroll Calc No
COL5RequiredNumeric (10,2)Amount

** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
COL: a placeholder must be provided for each column even if no value is provided
Note: This section is for importing calculation "override" amounts


File Example:
PRR,H,"10",9/15/2019,"9/27/2019","0000","9/27/2019",1,"4",CA,,,,,""
PRR,D,"10","9/16/2019","Day1",,"2017008","","",,,2120.000,"1",,25,5,,,8810,,,,,,"",""
PRR,D,"10","9/17/2019","Day2",,"2017008","","",,,2120.000,"1",,32,3,,,8810,,,,,,"",""


REQUEST A DEMO

System Requirements:

Requires the Sage 100 Contractor Data Integration Suite