• View Page Source

• Recent Changes
  Page Index
  About
  SystemInfo
  

  IT_slab_2010
  UndefinedPages
  

Formatting of data in Excel#

Here is the list of points to check while formatting the data. Ensuring that the data is error free will help in quick and hassle free upload

1. There should not be any empty row in the beginning of the sheet. The first row of the template should be the heading like: Emp ID, Total Gross, Total Deduction etc.
2. Emp ID Column – this is a text field. Ensure that this column is filled and has no space.
3. To format the Emp ID column to text: Incase the data sheet needs formatting to “text” field, copy the desired sheet into a new worksheet. Select Data > Text to Columns > Select Delimited and Click Next till Step 3.
4. Under Step 3 select the radio button Text and Click Finish to complete the formatting.
5. Columns with out any values should be marked 0.
6. Each column in the template belongs to a Component. Columns with out any value can be removed/deleted from the template.
7. The column names should be unique. No two columns should be of the same name.
8. Bank Account number / Tax ID – this column is a numeric field. Hence the data should have the prescribed count (for example : bank account number – 10 digits, Tax ID – 14 or 15 digits)