Rules to Format
To ensure an error-free upload, format the Excel file before you upload it to greytHR. This applies to both the sample you may download from the system and modify or a file of your choice. To format, apply the following rules:
|Row||There should not be any empty row at the beginning of the worksheet. The first row of the template should be the header row.|
|Date||Ensure that date values are dd-MMM-yy.|
|Text||Ensure that text values are Text.|
|Negative Values||Do not enter negative values in the Deduction column because the deduction will automatically subtract in the application. However, the year-end adjustments can have negative values.|
Format a Column as Text
- Copy the desired worksheet into a new worksheet.
- Select Data > Text to Columns > Select Delimited.
- Click Next till Step 3.
- In Step 3, select the Text option button.
- Click Finish to complete the formatting.