Import Employee Calcs directly into Sage 100 Contractor. Simply download your employee calcs into Excel, review and apply employee calc information and import directly into Sage 100 Contractor 5-2-1 Employee Calcs.
Are you tired of manually keying in Employee Calcs one by one into Sage 100 Contractor? Would you rather download your employee calcs, 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-1 Employee Calcs data entry form.
Header | Reference | Data Type | Tab | Example | Description |
filetype | Required | PREMPCALC | PREMPCALC | PREMPCALC | |
recnum | Required ** | Numeric | Calculations | Employee No | |
clcnum | Required ** | Numeric | Calculations | Payroll Calc No | |
active | String (1) | Calculations | Y=Yes;N=No (Default=Y) | Active | |
dedrte | Numeric (6,4) | Calculations | Rate | ||
dedmax | Numeric (10,4) | Calculations | Maximum | ||
mrtsts | ** | Numeric | Calculations | 1=Single; 2=Married; 3=Head of Household; 4=Married/Separate; 5=Married/Joint | Marital Status |
allows | Numeric | Calculations | Standard Allowances | ||
addall | Numeric | Calculations | Additional Allowances | ||
tblnum | Numeric | Calculations | value between 1-99 | Table# | |
addste | Numeric (5,2) | Calculations | Additional Withholdings | ||
offset | Numeric (3,2) | Calculations | Offset |