![]() The remaining codes and totals in the Section Footer are preformatted. You will enter this total manually under column E-NoEmp. The Section Footer also includes the total number of records/employees in the section.06 wage code for a negative wage adjustment.05 wage code for a positive wage adjustment.98 indicates the beginning of the wage adjustment report.00 indicates the beginning of the regular wage report.Codes 00, 99, and 98 must stay in their formatted positions at the beginning and ending of each report section.In the examples above and below you will see codes in the Section Header and Footer as well as codes in the employee line items.It is important that you do not change any of the formatting or your report will fail to load. The example below shows how the formatting appears in the report spreadsheet.The retirement report is an Excel spreadsheet that is divided into three worksheet tabs indicated at the bottom of the workbook.Updating the DB Retirement Report SpreadsheetĪfter reviewing the DB Excel spreadsheet report, if all employee data is the same, you will need to change the pay period begin and end dates only. Keep a copy of the report for your records. Save the file using the corresponding pay period end date in the naming convention MMDDYY (example: 09-28-13.xls).Enter the employee information into the new blank row.Select the row that alphabetically follows the new employee’s name and insert a new row this row will already be in the correct format.Note: To ensure that the report loads properly, do not make changes to the preformatted headers. Click on the Regular Wages tab of your retirement report. ![]() When it is necessary to add a new employee to your report you will complete the following steps. Use the links to jump to the sections below. If you are referencing the DC report format, see the DC Reporting Process page. ![]() Note: This section applies to the DB-specific report format only.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |