{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Overview","Template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":123,"n_cols":7,"rows_kept":123,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,null,null,"Version: 2024-11-04"]
[]
[null,"Payroll - 5-2-1 Employees"]
[]
[null,"The following template should be used to import one or more Employees into Sage 100 Contractor.  "]
[]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","PREMP",null,"PREMP","(File Type Code)"]
[null,"recnum","Required","Numeric","Header",null,"Employee No"]
[null,"fstnme","Required(I)","String (50)","Header",null,"First Name"]
[null,"lstnme","Required(I)","String (50)","Header",null,"Last Name"]
[null,"status","Required(I) **","Numeric","Header","1=Current; 2=On leave; 3=Quit; 4=Laid off; 5=Terminated; 6=On probation; 7=Deceased; 8=Retired","Status"]
[null,"emptyp","Required(I) **","Numeric","Human Resources","1=Reg full-time; 2=Reg part-time; 3=Temp full-time; 4=Temp part-time","Employment Type"]
[null,"gender","Required(I) **","Numeric","Human Resources","1=Male;2=Female;3=Nonbinary","Gender"]
[null,"wrkcmp","Required(I) **","Numeric","Human Resources",null,"Workers Comp Code"]
[null,"paypst","Required(I) **","Numeric","Human Resources",null,"Position"]
[null,"taxste","Required(I) **","String (2)","Human Resources","CA","Tax State"]
[null,"payprd","Required(I) **","Numeric","Compensation","1=Weekly; 2=Bi-weekly; 3=Semi-monthly; 4=Monthly; 5=Quarterly; 6=Semi-annual; 7=Annual","Pay Period"]
[null,"ncknme",null,"String (50)","Header",null,"Nickname"]
[null,"midini",null,"String (1)","Header",null,"Middle Initial"]
[null,"admacs",null,"Numeric",null,"1=Yes;0=No","Require Payroll Admin Access"]
[null,"addrs1",null,"String (50)","General",null,"Addr 1"]
[null,"addrs2",null,"String (50)","General",null,"Addr 2"]
[null,"ctynme",null,"String (50)","General",null,"City"]
[null,"state_",null,"String (2)","General",null,"State"]
[null,"zipcde",null,"String (10)","General",null,"Zip"]
[null,"phnnum",null,"String (14)","General",null,"Phone No"]
[null,"pagnum",null,"String (14)","General",null,"Pager No"]
[null,"faxnum",null,"String (14)","General",null,"Fax No"]
[null,"cllphn",null,"String (14)","General",null,"Cell No"]
[null,"homnum",null,"String (14)","General",null,"Home No"]
[null,"e_mail",null,"String (75)","General",null,"Email"]
[null,"usrdf1",null,"String (50)","General",null,"User Def 1"]
[null,"usrdf2",null,"String (50)","General",null,"User Def 2"]
[null,"eqpnum","**","Numeric","General",null,"Equipment"]
[null,"mrtsts","**","Numeric","Human Resources","0=Unassigned; 1=Single; 2=Married; 3=Single with dependents; 4=Married with dependents","Benefit Status"]
[null,"hertge","**","Numeric","Human Resources","0=Decline to state; 1=White (not Hispanic/Latino); 2=Black/African American; 3=Hispanic/Latino (any race); 4=Asian; 5=American Indian/Alaska Native; 6=Native hawaiian/Pacific Islander; 7=Two or more races","Heritage"]
[null,"empcmp",null,"Numeric","Human Resources","1=yes;0=No","Always use employee comp code"]
[null,"uninum","**","Numeric","Human Resources",null,"Union"]
[null,"loctax","**","Numeric","Human Resources",null,"Residence Locale Tax"]
[null,"locwrk","**","Numeric","Human Resources",null,"Work Locale Tax"]
[null,"soccde","**","Numeric","Human Resources",null,"Standard Occupation Classification code"]
[null,"socsec",null,"String (44)","Human Resources","[Encrypted Field]","Social Security ***"]
[null,"dtebth",null,"Date","Human Resources","yyyy-mm-dd","Birth Date"]
[null,"dtehre",null,"Date","Human Resources","yyyy-mm-dd","Hire Date"]
[null,"dteina",null,"Date","Human Resources","yyyy-mm-dd","Inactive Date"]
[null,"lstrse",null,"Date","Human Resources","yyyy-mm-dd","Last Raise"]
[null,"i9verf","**","Numeric","Human Resources","1=yes;0=No","I-9 verified"]
[null,"crtrpt","**","Numeric","Human Resources","1=yes;0=No","Exempt from certified reporting"]
[null,"exmovr","**","Numeric","Human Resources","1=yes;0=No","Exempt from overtime pay"]
[null,"hiract","**","Numeric","Human Resources","1=yes;0=No","Eligible under HIRE Act of 2010"]
[null,"eeoprx","**","Numeric","Human Resources","1=yes;0=No","Use proxy hours for EEO-1 reporting"]
[null,"paycls","**","Numeric","Compensation","0=Unassigned; 1=Hourly; 2=Shift; 3=Day; 4=Week; 5=Salary; 6=Piece; 7=Commission","Pay Classification"]
[null,"paygrp","**","Numeric","Compensation",null,"Paygroup"]
[null,"payrt1",null,"Numeric (6,4)","Compensation",null,"Regular Hourly Rate"]
[null,"payrt2",null,"Numeric (6,4)","Compensation",null,"Overtime Hourly Rate"]
[null,"payrt3",null,"Numeric (6,4)","Compensation",null,"Premium Hourly Rate"]
[null,"salary",null,"Numeric (10,2)","Compensation",null,"Salary"]
[null,"comisn",null,"Numeric (3,0)","Compensation",null,"Commission %"]
[null,"advdue",null,"Numeric (10,2)","Compensation",null,"Advanced Due"]
[null,"accsck",null,"Numeric (4,2)","Compensation",null,"Sick Accrued"]
[null,"sckrte",null,"Numeric (5,5)","Compensation",null,"Sick Accrual Rate"]
[null,"sckmth","**","Numeric","Compensation","1-Per period; 2-Per hour","Sick Accrual Method"]
[null,"sckmax",null,"Numeric (4,2)","Compensation",null,"Sick Accrual Max"]
[null,"sckbeg",null,"Numeric (10,0)","Compensation",null,"Sick Last Yr Carry Forward"]
[null,"accvac",null,"Numeric (4,2)","Compensation",null,"Vacation Accrued"]
[null,"vacrte",null,"Numeric (5,5)","Compensation",null,"Vacation Accrual Rate"]
[null,"vacmth","**","Numeric","Compensation","1-Per period; 2-Per hour","Vacation Accrual Method"]
[null,"vacmax",null,"Numeric (4,2)","Compensation",null,"Vacation Accrual Max"]
[null,"vacbeg",null,"Numeric (4,2)","Compensation",null,"Vacation Last Yr Carry Forward"]
[null,"retchk",null,"Numeric","Compensation","1=yes;0=No","Retirement Plan"]
[null,"sckchk",null,"Numeric","Compensation","1=yes;0=No","Third-Party Sick Pay"]
[null,"w_2elc",null,"Numeric","Compensation","1=yes;0=No","Consent for Electronic W-2"]
[null,"dirdep",null,"Numeric","Direct Deposit","1=yes;0=No","Enable Direct Deposit"]
[null,"prente","**","Numeric","Direct Deposit","0=None;1=Prenote;2=10 day wait;3=Active;4=Inactive","Dir Dep - Status 1"]
[null,"acttyp","**","Numeric","Direct Deposit","1=Checking;2=Savings","Dir Dep - Acct Type 1"]
[null,"rtnmbr",null,"String (9)","Direct Deposit",null,"Dir Dep - Route No 1"]
[null,"actnum",null,"String (64)","Direct Deposit",null,"Dir Dep - Acct No 1"]
[null,"rtetyp","**","Numeric","Direct Deposit","0=None; 1=Dollar amount; 2=Percent of net pay; 3=Remainder of check","Dir Dep - Rate Type 1"]
[null,"depamt",null,"Numeric (3,0)","Direct Deposit",null,"Dir Dep - Amount 1"]
[null,"prent2","**","Numeric","Direct Deposit","0=None; 1=Prenote; 2=10 day wait; 3=Active; 4=Inactive","Dir Dep - Status 2"]
[null,"acttp2","**","Numeric","Direct Deposit","1=Checking;2=Savings","Dir Dep - Acct Type 2"]
[null,"rtnmb2",null,"String (9)","Direct Deposit",null,"Dir Dep - Route No 2"]
[null,"actnm2",null,"String (64)","Direct Deposit",null,"Dir Dep - Acct No 2"]
[null,"rtetp2","**","Numeric","Direct Deposit","0=None; 1=Dollar amount; 2=Percent of net pay; 3=Remainder of check","Dir Dep - Rate Type 2"]
[null,"dp2amt",null,"Numeric (3,0)","Direct Deposit",null,"Dir Dep - Amount 2"]
[null,"prent3","**","Numeric","Direct Deposit","0=None; 1=Prenote; 2=10 day wait; 3=Active; 4=Inactive","Dir Dep - Status 3"]
[null,"acttp3","**","Numeric","Direct Deposit","1=Checking;2=Savings","Dir Dep - Acct Type 3"]
[null,"rtnmb3",null,"String (9)","Direct Deposit",null,"Dir Dep - Route No 3"]
[null,"actnm3",null,"String (64)","Direct Deposit",null,"Dir Dep - Acct No 3"]
[null,"rtetp3","**","Numeric","Direct Deposit","0=None; 1=Dollar amount; 2=Percent of net pay; 3=Remainder of check","Dir Dep - Rate Type 3"]
[null,"dp3amt",null,"Numeric (3,0)","Direct Deposit",null,"Dir Dep - Amount 3"]
[null,"prent4","**","Numeric","Direct Deposit","0=None; 1=Prenote; 2=10 day wait; 3=Active; 4=Inactive","Dir Dep - Status 4"]
[null,"acttp4","**","Numeric","Direct Deposit","1=Checking;2=Savings","Dir Dep - Acct Type 4"]
[null,"rtnmb4",null,"String (9)","Direct Deposit",null,"Dir Dep - Route No 4"]
[null,"actnm4",null,"String (64)","Direct Deposit",null,"Dir Dep - Acct No 4"]
[null,"rtetp4","**","Numeric","Direct Deposit","0=None; 1=Dollar amount; 2=Percent of net pay; 3=Remainder of check","Dir Dep - Rate Type 4"]
[null,"dp4amt",null,"Numeric (3,0)","Direct Deposit",null,"Dir Dep - Amount 4"]
[null,"pyreml",null,"String (75)","Direct Deposit",null,"Direct Deposit Email"]
[null,"w4_1_c","**","Numeric","W-4 Information","0-Not set up; 1-Single or Married Filing separately; 2-Married filing jointly (or Qualifying widow(er)); 3-Head of household","W-4 - Step 1 Personal Information"]
[null,"w4_2_c","**","Numeric","W-4 Information","1=yes;0=No","W-4 - Step 2 Multiple Jobs or Spouse Works"]
[null,"w4_3__",null,"Numeric (10,2)","W-4 Information",null,"W-4 - Step 3 Claim Dependants Total Amount"]
[null,"w4_4_a",null,"Numeric (10,2)","W-4 Information",null,"W-4 - Step 4(a) - Other Income"]
[null,"w4_4_b",null,"Numeric (10,2)","W-4 Information",null,"W-4 - Step 4(b) - Deductions"]
[null,"w4_4_c",null,"Numeric (10,2)","W-4 Information",null,"W-4 - Step 4(c) - Extra Witholding"]
[null,"w4_dte",null,"Date","W-4 Information","yyyy-mm-dd","W-4 - Step 5 - Date Signed"]
[null,"ntetxt",null,"Text","Header",null,"Notes"]
[]
[null,"Required(I) - required when the action type selected is insert or insert and update"]
[null,"** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor"]
[null,"*** Field Encryption - this field is encrypted by default, in order to import a value into this field, Encryption must be turned OFF"]
[null,"1) Go To 7-1 Company Information"]
[null,"2) Click Options, then Database Security Encryption"]
[null,"3) Select \"OFF\""]
[]
[null,"File Example:"]
[null,"filetype,recnum,fstnme,lstnme,status,emptyp,gender,wrkcmp,paypst,taxste,payprd"]
[null,"EMP,2001,\"Harold\",\"Jones\",1,1,1,5606,2,CA,2"]
[null,"EMP,2002,\"Stacey\",\"McCory\",1,1,1,5606,2,CA,2"]

{"sheet":"Template","index":1,"n_rows":10,"n_cols":101,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sample Template",null,"Note: you may delete any column from this template that is not used or needed other than the Required Columns"]
[]
[]
[null,"Filetype Code","Employee No","First Name","Last Name","Status","Employment Type","Gender","Workers Comp Code","Position","Tax State","Pay Period","Nickname","Middle Initial","Require Payroll Admin Access","Addr 1","Addr 2","City","State","Zip","Phone No","Pager No","Fax No","Cell No","Home No","Email","User Def 1","User Def 2","Equipment","Benefit Status","Heritage","Always use employee comp code","Union","Residence Locale Tax","Work Locale Tax","Standard Occupation Classification code","Social Security ***","Birth Date","Hire Date","Inactive Date","Last Raise","I-9 verified","Exempt from certified reporting","Exempt from overtime pay","Eligible under HIRE Act of 2010","Use proxy hours for EEO-1 reporting","Pay Classification","Paygroup","Regular Hourly Rate","Overtime Hourly Rate","Premium Hourly Rate","Salary","Commission %","Advanced Due","Sick Accrued","Sick Accrual Rate","Sick Accrual Method","Sick Accrual Max","Sick Last Yr Carry Forward","Vacation Accrued","Vacation Accrual Rate","Vacation Accrual Method","Vacation Accrual Max","Vacation Last Yr Carry Forward","Retirement Plan","Third-Party Sick Pay","Consent for Electronic W-2","Enable Direct Deposit","Dir Dep - Status 1","Dir Dep - Acct Type 1","Dir Dep - Route No 1","Dir Dep - Acct No 1","Dir Dep - Rate Type 1","Dir Dep - Amount 1","Dir Dep - Status 2","Dir Dep - Acct Type 2","Dir Dep - Route No 2","Dir Dep - Acct No 2","Dir Dep - Rate Type 2","Dir Dep - Amount 2","Dir Dep - Status 3","Dir Dep - Acct Type 3","Dir Dep - Route No 3","Dir Dep - Acct No 3","Dir Dep - Rate Type 3","Dir Dep - Amount 3","Dir Dep - Status 4","Dir Dep - Acct Type 4","Dir Dep - Route No 4","Dir Dep - Acct No 4","Dir Dep - Rate Type 4","Dir Dep - Amount 4","Direct Deposit Email","W-4 Step 1","W-4 Step 2","W-4 Step 3","W-4 Step 4(a)","W-4 Step 4(b)","W-4 Step 4(c)","W-4 Step 5","Notes"]
[null,"PREMP","Numeric","String (50)","String (50)","Numeric","Numeric","Numeric","Numeric","Numeric","String (2)","Numeric","String (50)","String (1)","Numeric","String (50)","String (50)","String (50)","String (2)","String (10)","String (14)","String (14)","String (14)","String (14)","String (14)","String (75)","String (50)","String (50)","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","String (44)","Date","Date","Date","Date","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric (6,4)","Numeric (6,4)","Numeric (6,4)","Numeric (10,2)","Numeric (3,0)","Numeric (10,2)","Numeric (4,2)","Numeric (5,5)","Numeric","Numeric (4,2)","Numeric (10,0)","Numeric (4,2)","Numeric (5,5)","Numeric","Numeric (4,2)","Numeric (4,2)","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","String (9)","String (64)","Numeric","Numeric (3,0)","Numeric","Numeric","String (9)","String (64)","Numeric","Numeric (3,0)","Numeric","Numeric","String (9)","String (64)","Numeric","Numeric (3,0)","Numeric","Numeric","String (9)","String (64)","Numeric","Numeric (3,0)","String (75)","Numeric","Numeric","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Date","Text"]
[null,null,"Header","Header","Header","Header","Human Resources","Human Resources","Human Resources","Human Resources","Human Resources","Compensation","Header","Header",null,"General","General","General","General","General","General","General","General","General","General","General","General","General","General","Human Resources","Human Resources","Human Resources","Human Resources","Human Resources","Human Resources","Human Resources","Human Resources","Human Resources","Human Resources","Human Resources","Human Resources","Human Resources","Human Resources","Human Resources","Human Resources","Human Resources","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Compensation","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","Direct Deposit","W-4 Info","W-4 Info","W-4 Info","W-4 Info","W-4 Info","W-4 Info","W-4 Info","Header"]
[]
["First Line of File==>","filetype","recnum","fstnme","lstnme","status","emptyp","gender","wrkcmp","paypst","taxste","payprd","ncknme","midini","admacs","addrs1","addrs2","ctynme","state_","zipcde","phnnum","pagnum","faxnum","cllphn","homnum","e_mail","usrdf1","usrdf2","eqpnum","mrtsts","hertge","empcmp","uninum","loctax","locwrk","soccde","socsec","dtebth","dtehre","dteina","lstrse","i9verf","crtrpt","exmovr","hiract","eeoprx","paycls","paygrp","payrt1","payrt2","payrt3","salary","comisn","advdue","accsck","sckrte","sckmth","sckmax","sckbeg","accvac","vacrte","vacmth","vacmax","vacbeg","retchk","sckchk","w_2elc","dirdep","prente","acttyp","rtnmbr","actnum","rtetyp","depamt","prent2","acttp2","rtnmb2","actnm2","rtetp2","dp2amt","prent3","acttp3","rtnmb3","actnm3","rtetp3","dp3amt","prent4","acttp4","rtnmb4","actnm4","rtetp4","dp4amt","pyreml","w4_1_c","w4_2_c","w4_3__","w4_4_a","w4_4_b","w4_4_c","w4_dte","ntetxt"]
[null,"PREMP",20,"John","Doe",1,1,1,8810,1,"CA",1]
[null,"PREMP",21,"Jerry","Springer",1,1,1,8810,1,"CA",1]