Create GEBCorp Payroll Deduction File
SmartFusion Modules > Payroll > Deductions > Create GEBCorp Payroll Deduction File
Last Update: 6.33
- Added a header line to the output file created.
Last Update: 6.32
- Fixed data pull to only pull pay information for subject to Retirement Pay Types when populating employees, instead of the gross pay
Last Update: 6.31
- Added option to include 401(a) Employer Match Deduction
- Deduction rates will now appear in export file if computation method is a percentage
Last Update: 6.27
- Updated export file to new format; Updated report to new UX standards; Added detail report optionIntroduction
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).
- Select process
- Create File
- Print & Create File
- Print Only
- Select report output
- Summary (default)
- Detail
- Enter submission frequency
- Biweekly
- Monthly
- Semimonthly
- Annually
- Enter period to report
- Enter filename (not required if print only)
- Enter your GEBCorp ERID
- Pay period end date (biweekly only)
- Select deductions to process (selected deduction must have an organization id code)
GEBCorp Export File Layout (beginning Jul 2017)
| Field | Length | Description | Notes | |
|---|---|---|---|---|
| 1 | SSN | 9 | Employee’s Social Security Number | |
| 2 | SSN prior | 9 | Employee’s previous SSN | not avail |
| 3 | ERID | numeric | Plan Sponsor’s 457 or DB EIN | user entry |
| 4 | PayFreq | 1 | Employee’s Payroll Frequency | A, M, S, B |
| 5 | PayDate | date | Payroll Date | check date |
| 6 | Last Name | 30 | Employee’s Full Name | |
| 7 | First Name | 30 | Employee’s First Name | |
| 8 | Middle Name | 15 | Employee’s Middle Name or Initial | |
| 9 | Gender | 1 | Employee’s Gender | M, F |
| 10 | DOB | date | Employee’s Date of Birth | |
| 11 | DOH | date | Employee’s Original Hire Date | |
| 12 | Eligible Pay | numeric | Employee’s Pensionable Earning | |
| 13 | Plan ID | numeric | Legacy Plan ID | <100 |
| 14 | DB Tax Type | numeric | Defined Benefits Tax Type | 01 for Tax Status = N |
| 02 for all other Tax Statuses | ||||
| 15 | DBEEContrib | numeric | Def Ben Employee’s Contribution | |
| 16 | DBEEContribRate | numeric | Def Ben Employee’s Contrib Rate | from Employee Master Deductions tab (not historical) |
| 17 | DBERContrib | numeric | Def Ben Employer’s Contribution | |
| 18 | 457EEContrib | numeric | 457 Employee’s Contribution | |
| 19 | 457EEContribRate | numeric | 457 Employee’s Contrib Rate | from Employee Master Deductions tab (not historical) |
| 20 | 457ERContrib | numeric | 457 Employer’s Contribution | |
| 21 | 401aEEContrib | numeric | 401(a) Employee’s Contribution | |
| 22 | 401aEEContribRate | numeric | 401(a) Employee’s Contrib Rate | from Employee Master Deductions tab (not historical) |
| 23 | 401aERBase | numeric | 401(a) Employer’s Base Contrib | |
| 24 | 401aERMatch | numeric | 401(a) Employer’s Match | a stand-alone deduction with an 'employer cost only' deduction type |
| 25 | RothEEDed ?? | numeric | 401(a) Employer's Roth Base ?? | code reflects Employee; Desc reflects Employer |
| 26 | ROTHEE% | numeric | 401(a) Employee's Roth Contr Rate | null |
| 27 | DeptCode | 12 | Employee’s Department Code | |
| 28 | Spouse SSNO | 9 | Spouse Social Security Number | not avail |
| 29 | Spouse Last Name | 50? prob 30 | Spouse Last Name | not avail |
| 30 | Spouse First Name | 30 | Spouse First Name | not avail |
| 31 | Spouse Middle Name | 30? prob 15 | Spouse Middle Name | not avail |
| 32 | Spouse DOB | date | Spouse Date of Birth | not avail |
| 33 | Address1 | 60 | Employee’s Street Address1 | |
| 34 | Address2 | 40 | Employee’s Street Address2 | |
| 35 | City | 40 | Employee’s City | |
| 36 | State | 2 | Employee’s State | |
| 37 | Zip | 10 | Employee’s Zip Code | |
| 38 | IPM_EMPLID | 9 | Protected Refr ID | not avail |
| 39 | Comments | 300 | Comments | null |