Standard Payroll Format
Key Takeaway
The following is a template for uploading standard payroll contributions.
- Excel (.xls) is the standard file format. If using a payroll software program to extract data, the payroll format indicated below may be submitted in a comma delimited text (.txt) file.
- The standard naming convention of each file is your six-digit Alerus account number followed by the actual payroll date in YYMMDD format (e.g., 123456220811.xls).
- Use the text under the “Description” column as the column headings in the file. Fields that will not contain data should remain blank.
- Enter each employee’s information in one row.
- When submitting compensation and hours, submit data for all employees – participating and non‐participating.
- Fields identified as Type “A” are alphabetic and must be left justified and in all caps. Fields identified as Type “N” are numeric, must be right justified, and cannot contain commas or $.
- For assistance in determining which contribution source columns to use (columns Q – X), please call your account administrator at 800.433.1685.