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 payment 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 System Admin 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.
DOWNLOAD TTUM.EXE FILE
