Salary / Pension Credit in Finacle
Creation of excel file
For pension credits, an excel file containing Finacle Account number, Credit Amount and PPO Number should be generated separately. List of pension accounts can be generated using HACSP menu in Finacle, specifying scheme as SBPEN (pension accounts without cheque) / SBPWC (pension accounts with cheque).
For salary credits, an excel file containing Finacle Account number, Credit Amount and remarks (eg. Salary for Feb.14) should be generated separately.
For debiting individual BO SB accounts after dispersal of NREGS payment, a debit option has been provided. Debit option is to be selected and the option ‘OTHERS’ is to be selected; SOL ID is to be entered. Excel file should contain only Finacle account number, Debit Amount and remarks (eg. NREGS payment). BO settlement account 0339 will be credited.
The excel file should not contain column headers and total; also, the account numbers should be exactly typed as available in Finacle including the prefixed zeroes.
Conversion of excel file to Finacle format
Run the file ‘TTUM.exe’. Select ‘Credit / Debit’ option and then the option (Salary / Pension / Others). Enter your SOLID. Then, click on ‘Create Finacle Format File’ option. Select the excel file needs to be uploaded. The excel file will be converted into Finacle format and message mentioning the file name / no. of accounts along with total amount included in text file will be displayed.
If the excel file is not in the required format, the conversion will fail and error message will be displayed.
Required corrections should be made in excel file and then conversion has to be done using the new excel file.
Uploading the file in Finacle
In Finacle the file has to be uploaded on the day of credit only; i.e. For February on 28/02 morning only.
Menu ‘HTTUM’ is to be used for uploading the file in Finacle. The menu is available for SystemAdmin work class.
Enter ‘PM’ in ‘Report To’ field. Select the transaction sub type as ‘Transfer – Bank Induced’.
Select ‘Trial’ for Action. Select ‘On Successful Upload’ for ‘Rename File after Upload’ option.
Select ‘Local File Path’ and click on ‘Submit’ button (or Press F10).
Next screen with ‘Browse’ button will be displayed; select the text file generated using ‘TTUM.exe’ and click on ‘Go’ button (or Press F4).
A message ‘Batch program successfully initiated’ will be displayed.
Go to HPR to see the success / failure report.
If failure report is generated, the errors such as invalid account number, should be corrected in the excel file and the excel file is to be converted into finacle format using ‘TTUM.exe’.
After success report is generated, you have to proceed with the following steps.
Invoke ‘HTTUM’ menu in System Admin login.
Enter ‘PM’ in ‘Report To’ field.
Select the transaction sub type as ‘Transfer – Bank Induced’.
Select ‘POST’ for Action.
Select ‘On Successful Upload’ for ‘Rename File after Upload’ option.
Select ‘Local File Path’ and click on ‘Submit’ button (or Press F10).
Next screen with ‘Browse’ button will be displayed; select the correct text file generated using ‘TTUM.exe’ and click on ‘Go’ button (or Press F4).
A message ‘Batch program successfully initiated’ will be displayed.
Go to HPR to see the success / failure report.
In the report, the transaction id will be displayed (here S19873). Note down the transaction id.
Check whether the ‘Salary account’ (SOLID0409) / ‘Pension account’ (SOLID0408) is debited for the entire amount and also check the individual credit of salary for each account.
Salary and Pension account will always be in Credit (-ve) to that extent of salary and pension payment made.
The Dr should be equivalent to the salary or pension credited for the month. It is the duty and responsibility of the Supervisor to ensure that the amount debited from Salary and Pension account is equivalent to the credits made in respective salary and pension accounts.
HTTUM report available in HFINRPT is to be used for taking print out of the transactions created through TTUM upload.
For downloading exe and pdf format, CLICK HERE
