Create GEBCorp Payroll Deduction File

SmartFusion Modules > Payroll > Deductions > Create GEBCorp Payroll Deduction File

Last Updated:Update:  6.27
- Updated export file to new format; Updated report to new UX standards; Added detail report option

Other Recent Updates: 6.21
- Added address to the export file

Introduction

The GEBCorp Payroll Deduction File allows GA customers to report contributions and deductions to GEBCorp

Explanation

Users are given an option to either print a report or create an export .txt file (or both).

GEBCorp exportExport fileFile layoutLayout (beginning Jul 2017)

Field Length Start PositionDescription Used in SFNotes
1SSN 91 Employee’s Social Security NumYesNumber
2SSN prior9Employee’s previous SSNnot avail
3ERID 2010numeric Plan Sponsor’s 457 or DB EIN Yesuser entry
4PayFreq 130 Employee’s Payroll Frequency YesA, M, S, B
5PayDate 831date Payroll Date Yescheck date
6Last Name 453930 Employee’s Full Name
Yes7First Name30Employee’s First Name
8Middle Name15Employee’s Middle Name or Initial
9 Gender 1 84Employee’s Gender YesM, F
10DOB 885date Employee’s Date of Birth Yes
11 DOH 893date Employee’s Original Hire Date Yes
12Eligible Pay 10101numeric Employee’s Pensionable Earning Yesgross wages
DBPlanID211113 Plan Identification NumberID YesnumericLegacy Plan ID<100
DBTaxType14 2113ContributionDB Tax Type YesnumericDefined Benefits Tax Type1 (Pre-tax); 2(Post-tax)
15DBEEContrib 10numeric 115DefinedDef Ben Employee’s ContYesContribution
DBERContrib16 10DBEEContribRate 125numeric DefinedDef Employer’sBen ContEmployee’s Contrib Rate Yesnot avail
17DBERContribnumericDef Ben Employer’s Contribution
18457EEContrib 10135numeric 457 Employee’s Contribution
Yes19457EEContribRatenumeric457 Employee’s Contrib Ratenot avail
20457ERContrib 10145numeric 457 Employer’s Contribution
Yes21401aEEContribnumeric401(a) Employee’s Contribution
22401aEEContribRatenumeric401(a) Employee’s Contrib Ratenot avail
23401aERBasenumeric401(a) Employer’s Base Contrib
24401aERMatch 10--numeric 401(a) Employer’s Match Nullnull
401aEEContrib25 10RothEEDed ?? 155numeric 401(a) Employee’sEmployer's ContributionRoth Base ?? Yescode reflects Employee; Desc reflects Employer
401aERBase26 10ROTHEE% 165numeric 401(a) Employer’sEmployee's ContributionRoth Contr Rate Yesnull
27 DeptCode 12 175Employee’s Department Code
No28Spouse SSNO9Spouse Social Security Numbernot avail
SpouseSSN29 9Spouse Last Name 18750? prob 30 Employee’sSpouse Spouse’sLast SSNName Nonot avail
SpouseName30 45196Employee’sSpouse Spouse’sFirst Name No30Spouse First Namenot avail
SpouseDOB31 8Spouse Middle Name 24130? prob 15 Employee’sSpouse Spouse’sMiddle DoBName Nonot avail
Status32 1Spouse DOB 249date Employee’sSpouse statusDate of Birth Yesnot avail
StatChgDate33 8Address1 25060 Employee’s statusStreet change dateYesAddress1
StatChgCode34 2Address2 25840 StatusEmployee’s changeStreet reason codeNoAddress2
Address13530260Employee’s Street AddressYes
Address230290Employee’s Street AddressYes
City 3032040 Employee’s City Yes
36 State 2 350Employee’s StateYes
37Zip 935210 Employee’s Zip Code
Yes38IPM_EMPLID9Protected Refr ID
Comments5036139 Comments No300Commentsnull

References

GEBCorp Export File Layout Prior to July 2017