Transcription of SALARY UPLOAD IN CSV FORMAT Open MS Excel, …
1 SALARY UPLOAD IN CSV FORMAT Open MS Excel, Type details & save as .csv file FORMAT (instead of .xls or .xlsx): Do not enter any , (comma) in any field. 1. The 1st row should contain file header: Column A FILEHDR Column B CORPORATE_ID Maximum length 32 Column C File_Sequence_Number Maximum length 6, should be a number Sample: Example : 2. The 2nd row should contain debit account details: Column A Branch sol id First 5 digit of your debit account number Column B Debit account no. Maximum length 15 characters Column C Currency code Maximum length 3 characters Column D Transaction type Maximum length 2 characters (DR - debit) Column E Amount Maximum length 12 characters Sample: Column F Remarks Maximum length 13 characters Example: 3.
2 The 3rd row should contain credit account details: Column A Branch sol id First 5 digit of your credit account number Column B Credit account no. Maximum length 15 characters Column C Currency code Maximum length 3 characters (INR) Column D Transaction type Maximum length 2 characters (CR - credit) Page 1 of 2 Column E Amount Maximum length 3 characters Column F Remarks Maximum length 13 characters Example: 4. Consecutive rows to be done as per 3rd row logic. 5. Total sum of credit amounts should be same as the debit amount. 6. After completing the file in MS Excel to save the file select Save As and select CSV(MS-DOS)(*.csv) FORMAT . Sample File ( ) shown below : Page 2 of 2
