Monday, August 3, 2015

After constant follow up and persuation by this Union Deptt. released proforma SBCO manual for Finacle which is published for all SBCO users. It may not appear good when posted in blog , but AD(SB) WB circle has already sent it to all Divn.Heads and Postmasters, interested persons can ask them for a copy.





India Post

    SBCO Manual














 Detective Controls-Other Reports……………………………………………………………………………………………………………15-21




                                                                                                                                     


The accounts that are used by the Post Offices and Financial Institutions for their internal purposes are called Office Accounts in Finacle. The Office Accounts are opened for accounting purpose. The three types of Office Accounts are, office accounts basics (OAB), Office accounts pointing (OAP) and System office accounts.
In general, all income accounts, expenditure accounts, asset accounts are basic Office Accounts. The Sundry creditors and the Suspense Payment accounts are the office pointing accounts and Proxy accounts are the System office accounts.
The transactions in the office accounts are to be monitored very carefully by the SBCO  controlling office and also various agencies that come to the Post Office for audit / inspection (internal auditors or statutory auditors).
Finacle provides the auditors both the options to view the report and also take hard copy of the report of various activities / transactions conducted by the employees working in a Post Office.  These reports and inquiries are effective for operations as well as detective controls for SBCO Users.
Office Accounts – Menu Options:
Menu Option
Function

1
HIOT
Inquire on transaction
2
HIOGLT
Inquiry on GL transactions
3
HACLINQ
Account Ledger Inquiry
4
HACLPOA
Office A/c. Ledgers Print

Folded Corner: HOW can we do that?   
Let us look and explore each of the option in detail:

Folded Corner: HOW can we do that?   
Let us look and explore each of the option in detail:

Folded Corner: HOW can we do that?   
Let us look and explore each of the option in detail:

Folded Corner: HOW can we do that?   
Let us look and explore each of the option in detail:

Folded Corner: HOW can we do that?   
Let us look and explore each of the option in detail:

Invoke HIOT menu option to inquire on transactions in a particular Office Account.
Notes             
·   To start, Log-in to Finacle with User Name and Password.

Oval: 7Oval: 9Oval: 8Oval: 6Oval: 5Oval: 4Oval: 3Oval: 2Oval: 1

No
Field
Action
Remarks
1.     
SOL Set Id
·   Enter the SOL Set ID
-     SOL ID means Service Outlet ID. Each Post Office will be given a unique Id.
-     Alternatively, the search icon can be used to select the SOL Set ID.
2.     
Scheme type
·   Select the required scheme type for which the inquiry is to be made
-     Alternatively, the search icon can be used to select the scheme type.
3.     
Report
·   Select the required option
-     Finacle provides the facility to print a particular report as well as report can be viewed.
4.     
Account ID.
·   Enter the office account ID
-     Alternatively, the search icon can be used to select the account ID.
5.     
Start Date
·   Enter the start date from which the report is required.
-     Alternatively, the calendar icon can be used to select the start date.
6.     
End Date
·   Enter the end date from which the report is required.
-     Alternatively, the calendar icon can be used to select the end date.
7.     
Filter
·   Select the required type of entry
-     The filters are used to get the relevant data.
8.     
Ref. No.
·   Enter the reference number
-     The reports for this particular reference number will be generated.
9.     
Submit
·   Click Submit
-          The report is generated.

1.                  Invoke HIOGLT to inquire on the General Ledger transactions for a particular GL Head or GL Sub head between two dates.  

Notes             
·   To start, Log-in to Finacle with User Name and Password.

Oval: 10Oval: 9Oval: 8Oval: 7Oval: 6Oval: 5Oval: 4Oval: 3Oval: 1Oval: 2

No
Field
Action
Remarks
1.     
Filter Indicator
·   Select the required option
-     Generally, the filter selected here will be AND for better indicator and this is default populated.
2.     
Date Indicator
·   Select the required option
-     Depending upon the requirement of the auditor the date should be selected.
3.     
SOL Set ID
·   Enter the SOL Set ID
-     Alternatively, the search icon can be used to select the SOL Set ID.
4.     
Currency
·   Enter the currency code
-     Alternatively, the search icon can be used to select the currency.
5.     
General Ledger Sub Head code
·   Enter the General Ledger Sub Head code
-     Every office account will be attached to a particular GL Sub head for which the report is required.
-     Alternatively, the search icon can be used to select the GL Subhead code.
6.     
General Ledger code
·   Enter the General Ledger code
-     Alternatively, the search icon can be used to select the GL Head code.
7.     
Date (Low)
·   Enter the start date from which the report is required.
-     Alternatively, the calendar icon can be used to select the start date.
8.     
Date (High)
·   Enter the end date from which the report is required.
-     Alternatively, the calendar icon can be used to select the end date.
9.     
Display Order
·   Select the required option
-          The reports will be generated based on the criteria selected.
10.               
Submit
·   Click Submit
-          The inquiry results are displayed.
2.                  Invoke HACLINQ to inquire on the Account Ledger Inquiry for a particular Office account between two dates.  

Notes             
·   To start, Log-in to Finacle with User Name and Password.

Oval: 2Oval: 3Oval: 4Oval: 1


No
Field
Action
Remarks
1.
Account Id
·   Enter Account ID
-      
2.
Start Date
·   Enter the Start Date
-     Depending upon the requirement of the auditor the date should be selected.
3.
End Date
·   Enter the End Date
-     Depending upon the requirement of the auditor the date should be selected.
4.
Go
·   Click Go
-     The report is generated.

3.                  Invoke HACLPOA to Office Account Ledger Print for a Range of Office account between two dates.  

Oval: 1Oval: 2Oval: 3Oval: 4Oval: 5Oval: 6


No
Field
Action
Remarks
1.
Report To
·   Enter Report To
-      
2.
From Account Range
·   Enter From Account Number
-     Depending upon the requirement of the auditor the account no. should be selected.
3.
To Account Range
·   Enter To Account Number
-     Depending upon the requirement of the auditor the To Account should be selected.
4.
Period From
·   Enter From Period
-     Depending upon the requirement of the auditor the date should be selected.
5.
Period To
·   Enter To Period
-     Depending upon the requirement of the auditor the date should be selected.
6.
Submit
·   Click Submit
-     The report is generated.




Detective Controls - Interest Inquiries

All Financial organizations will be receiving various incomes. The major share of the income comes from interest. SBCO has to see that annual interest, closing interest and the Post maturity (overdue) interest has been correctly taken and accounted for. 
The two types of interest inquiries are:
·      Interest Inquiries (on screen views)
·      Interest Reports (printable formats)

These inquiries are on the various activities / transactions conducted by the employees working in a Post Office.  These reports and inquiries are effective for operations as well as detective controls for SBCO staff.
INTEREST

Interest Inquiry – Menu Options

Menu Option
Function

1
HAITINQ
Account interest inquiry
2
HCUIR
Customer interest report
3
HAINTRPT
Account interest report
4
HINTTI
Interest Details Inquiry
5
HLINTI
Inquiry on Interest
6
HIARM
Interest Adjustment

1.      Invoke HAITINQ menu option to inquire about the interest income received from a particular account.

The report on interest income can be generated using HPR menu option.

Notes             
·   To start, Log-in to Finacle with User Name and Password.

Oval: 2Oval: 1

No
Field
Action
Remarks
1.     
A/c ID.
·   Enter the account number
-     Alternatively, the search icon can be used to select the account number.
2.     
Go
·   Click Go
-     The report is generated

2.    Invoke HCUIR menu option to generate a report on interest earner through customer having multiple accounts under the same CIF.
Notes             
·   To start, Log-in to Finacle with User Name and Password.

Oval: 6Oval: 5Oval: 4Oval: 3Oval: 2Oval: 1
No
Field
Action
Remarks
1.     
Report to
·   Enter the name of person to whom you want to report.
-     This will be useful in case where one global printer is available, it becomes easy to identify to whom the report has to be delivered.
2.     
SOL ID
·   Select the required SOL ID
-     The search icon can be used to select the SOL
3.     
CIF ID
·   Enter the CIF ID of the customer
-     Alternatively, the search icon can be used to select the CIF ID.
4.     
Start Date
·   Enter the start date from which the report is required.
-     Alternatively, the calendar icon can be used to select the start date.
5.     
End Date
·   Enter the end date from which the report is required.
-     Alternatively, the calendar icon can be used to select the end date.
6.     
Submit
·   Click Submit
-     The report is generated
3.    Invoke HAINTRPT menu option to generate an interest report on a range of accounts.
Notes             
·   To start, Log-in to Finacle with User Name and Password.

Oval: 14Oval: 13Oval: 12Oval: 2Oval: 3Oval: 4Oval: 5Oval: 6Oval: 7Oval: 8Oval: 10Oval: 11Oval: 1

No
Field
Action
Remarks
1.     
Set ID
·   Enter the set ID
-     Alternatively, the search icon can be used to select the Set ID.
2.     
Report to
·   Enter the name of person to whom you want to report.
-     This will be useful in case where one global printer is available, it becomes easy to identify to whom the report has to be delivered.
3.     
Scheme Type
·   Enter the scheme type
-     Alternatively, the search icon can be used to select the scheme type.
4.     
Currency
·   Enter the currency code
-     Alternatively, the search icon can be used to select the currency.
5.     
From A/c. ID
·   Enter the account number from which the report is to be generated
-     Alternatively, the search icon can be used to select the account number.
6.     
To A/c. ID
·   Enter the account number up to which the report is to be generated
-     Alternatively, the search icon can be used to select the account number.
7.     
From GL Sub Head code
·   Enter the General Ledger Sub Head code from which the report is to be generated
-     Every office account will be attached to a particular GL Sub head for which the report is required.
-     Alternatively, the search icon can be used to select the GL Subhead code.
8.     
To General Ledger Sub Head code
·   Enter the General Ledger Sub Head code up to which the report is to be generated
-     Every office account will be attached to a particular GL Sub head for which the report is required.
-     Alternatively, the search icon can be used to select the GL Subhead code.
9.     
From Date
·   Enter the start date from which the report is required.
-     Alternatively, the calendar icon can be used to select the start date.
10.               
To Date
·   Enter the end date from which the report is required.
-     Alternatively, the calendar icon can be used to select the end date.
11.               
From CIF Id
·   Enter the CIF ID from which the required is to be generated
-     Alternatively, the search icon can be used to select the CIF ID.
12.               
To CIF Id
·   Enter the CIF ID up to which the required is to be generated


-     Alternatively, the search icon can be used to select the CIF ID.
13.               
MRT file name
·   Select the required MRT file
-     Use the search icon to select
14.               
Submit
·   Click Submit


-     The report is generated

Notes             
·          All other fields shown in the screen are auto populated. The Auditors can even specify what type of Interest they are looking for, for example, additional, overdue or penal and so on, by choosing from the dropdown in interest type.

4.    Invoke HINTTI menu option to generate an interest detail inquiry report for an account on a range of Dates
Oval: 5Oval: 4Oval: 3Oval: 2Oval: 1

No
Field
Action
Remarks
1.
Menu Shortcut
·   Enter HINTTI
-      
2.
Account Id
·   Enter the Account Number
-     Alternatively, the search icon can be used to select the account number.
3.
Start Date
·   Enter the Start Date
-     Alternatively, the calendar icon can be used to select the start date.
4.
End Date
·   Enter the End Date
-     Alternatively, the calendar icon can be used to select the end date.
5.
Go
·   Click Go
-     The report is generated
5.    Invoke HLINTI menu option to generate an interest inquiry for an account.
Oval: 1Oval: 2Oval: 3
No
Field
Action
Remarks
1.
Menu Shortcut
·   Enter HILINTI
-      
2.
Account Id
·   Enter the Account Number
-     Alternatively, the search icon can be used to select the account number.
3.
Go
·   Click Go
-     The report is generated
6.    Invoke HIARM menu option to generate an interest adjustment Register Maintenance report for an account.
Oval: 1Oval: 2Oval: 3Oval: 4Oval: 5
No
Field
Action
Remarks
1.
Menu Shortcut
·   Enter HIARM
-      
2.
Function
·   Select Inquire
-      
3.
Account/Bill/Disbursement
·   Select A-A/c
-      
4.
SOL Id
·   Select the required SOL ID
-     The search icon can be used to select the SOL
5.
Go
·   Click Go
-     Report Generated





There are various reports available in Finacle which will be helpful to SBCO staff in conducting day to day operations:-
Reports – Menu Options
Menu Option
Function

1
HPR
Print report
2
HEXCPRPT
Exceptions Report
3
HFINRPT
FINRPT Report Generation
4
CWDREP
Report of SB Withdrawals exceeding Rs.5000
5
HMEMOPAD
Memo pad Maintenance

1.   Invoke HPR menu option to print the generated report.
Notes             
·   To start, Log-in to Finacle with User Name and Password.

Oval: 1
No
Field
Action
Remarks
1.     
Go
·   Click Go
-      
Oval: 3Oval: 2
No
Field
Action
Remarks
2.     
Select
·   Select the required report
-      
3.     
View Details
·   Click the view details icon
-      

Oval: 4
No
Field
Action
Remarks
4.     
Type
·   Click Type
-     The report is displayed.
-      






2.                  Invoke HEXCPRPT menu option to generate Exceptions report.
Oval: 1Oval: 2Oval: 3Oval: 4Oval: 5Oval: 6

No
Field
Action
Remarks
1.
Menu Shortcut
·   Enter HEXCPRPT
-      
2.
Report To
·   Enter Report to
-      
3.
Exception Type
·   Select Exception Type
-      
4.
From Date
·   Enter From Date
-     Alternatively, the calendar icon can be used to select the start date.
5.
To Date
·   Enter To date
-     Alternatively, the calendar icon can be used to select the end date.
6.
Submit
·   Click Submit
-     Report Generated








3.   Invoke HFINRPT menu option to generate FINRPT Reports.
Oval: 2Oval: 1
No
Field
Action
Remarks
1.
Menu Shortcut
·   Enter HFINRPT
-      
2.
List of Reports
·   Select the Appropriate Report
-     Report Generated

The List of reports available in HFINRPT
1.      Agents Agent Commission Consolidation Report
2.      Agents Agent Commission Report
3.      Agents Agent Commission Transaction Details Report
4.      CIF Document Status Report
5.      CIF_KYC Status Report
6.      Common Account Statistics Report
7.      Common Account Statistics Transfer In/Out
8.      Common Account With Nominations
9.      Common Account without Nomination
10.  Common Account without Nominations and Balance above X Amount
11.  Common Accounts Transferred
12.  Common Bill Payment Transaction
13.  Common Counter Wise Transactions Report - Discontinued Scheme
14.  Common Counter Wise Transactions Report - Inter Post Office
15.  Common Counter Wise Transactions Report – MISBottom of Form
16.  Common Counter Wise Transactions Report – PPF
17.  Common Counter Wise Transactions Report – RD
18.  Common Counter Wise Transactions Report – SBA
19.  Common Counter Wise Transactions Report – SCSS
20.  Common Counter Wise Transactions Report – TD
21.  Common Net Accretion Report
22.  Common No Of Live Accounts
23.  Common No Of Transactions
24.  Common Nomination History Details Report
25.  Common Nominee Amendment Audit Report
26.  Common Outstanding Balances Of Small Savings Collections- Annexure - IV (I)
27.  Common Outstanding Balances Of Small Savings Collections- Annexure - IV (II)
28.  Common Settled/Unsettled Claims
29.  Common Statistical Register of Deposits/Withdrawal
30.  Common Statistical Statement Report
31.  Common User Login ReportBottom of Form
32.  Common User Profile and Login Access Report
35.  Consolidated RD Account Journal of Deposits and Withdrawals
40.  GL Inter sol Report

4.                  Invoke HMEMOPAD menu option to lookup Memo Pad.
Oval: 2Oval: 3Oval: 4Oval: 5Oval: 1
No
Field
Action
Remarks
1.
Menu Shortcut
·   Enter HMEMOPAD
-      
2.
Topic
·   Enter  Topic
-      
3.
Function
·   Enter Function
-      
4.
Memo Text
·   Enter Memo Text
-      
5.
Submit
·   Click Submit
-     Report Generated


·    
-      


·    
-      


·    
-      

Finacle provides various menu options for generation of Customer balance/Transaction Inquiries and reports for SBCO staff. These are:-
Customer Account Inquiries and Reports – Menu Options
Menu Option
Function

1.
HACSP
Account/Scheme Balance Report
2
HACLI
Account ledger inquiry
3
HACLPCA
Account ledger print
4.
HACI
Customer Account Inquiry.

1.      Invoke HACSP menu option to generate and print various reports on accounts.
This menu option is used to get different lists like accounts opened during a specific period,  account closed during a specific period, list of freeze accounts, list of accounts of a particular scheme code, list of minor accounts and so on.  The user can get the print out of the generated reports.
Notes             
·   To start, Log-in to Finacle with User Name and Password.

Oval: 7Oval: 6Oval: 5Oval: 4Oval: 3Oval: 2Oval: 1
No
Field
Action
Remarks
1.     
CIF ID
·   Enter the CIF ID of the customer
-     All the existing accounts opened through the CIF will appear.
-     Alternatively, the search icon can be used to select the CIF ID.
2.     
Scheme Code
·   Enter the scheme code
-     All the accounts existing in the Post Office opened through the particular scheme code will appear.
-     Alternatively, the search icon can be used to select the scheme code.
3.     
Open Date (Low)
·   Enter a date from which date list is required
-     List of accounts opened from the mentioned date will appear.
-     Alternatively, the calendar icon can be used to select the date.
4.     
Open Date (High)
·   Enter the date to which date list is required
-     List of accounts opened upto the selected date will appear.
-     Alternatively, the calendar icon can be used to select the date.
5.     
Close Date (Low)
·   Enter a date from which date list is required
-     List of accounts closed from the mentioned date will appear.
-     Alternatively, the calendar icon can be used to select the date.
6.     
Close Date (High)
·   Enter the date to which date the list is required
-     List of accounts closed upto the selected date will appear.
-     Alternatively, the calendar icon can be used to select the date.
7.     
Submit
·   Click Submit
-      

2.      Invoke HACLI menu option to inquire on account ledger of a particular account.
Notes             
·   To start, Log-in to Finacle with User Name and Password.

Oval: 6Oval: 5Oval: 4Oval: 3Oval: 2Oval: 1

No
Field
Action
Remarks
1.     
A/c.  ID
·   Enter the account number
-     Alternatively, the search icon can be used to select the account number.
2.     
From Date
·   Enter the start date from which the report is required.
-     Alternatively, the calendar icon can be used to select the start date.
3.     
To Date
·   Enter the end date from which the report is required.
-     Alternatively, the calendar icon can be used to select the end date.
4.     
From Instrument No.
·   Enter the instrument number from which the report is required.
-     Alternatively, the search icon can be used to select the instrument number.
5.     
To Instrument No.
·   Enter the instrument number from which the report is required.
-     Alternatively, the search icon can be used to select the instrument number.
6.     
Go
·   Click Go
-     The details are displayed on the screen.

3.      Invoke HACLPCA menu option to print the ledger of various customer accounts. 
Notes             
·   To start, Log-in to Finacle with User Name and Password.
Oval: 8Oval: 7Oval: 6Oval: 5Oval: 4Oval: 3Oval: 2Oval: 1
No
Field
Action
Remarks
1.     
Report to
·   Enter the name of person to whom you want to report.
-     This will be useful in case where one global printer is available, it becomes easy to identify to whom the report has to be delivered.
2.     
From A/c. ID
·   Enter the account number from which the report is to be generated
-     Alternatively, the search icon can be used to select the account number.
3.     
To A/c. ID
·   Enter the account number up to which the report is to be generated
-     Alternatively, the search icon can be used to select the account number.
4.     
Currency
·   Enter the currency code
-     Alternatively, the search icon can be used to select the currency.
5.     
Open/Closed/Both A/c
·   Select the required option
-     For existing accounts, select open only option.
6.     
Period From
·   Enter the start date from which the report is required.
-     Alternatively, the calendar icon can be used to select the start date.
7.     
Period To
·   Enter the end date from which the report is required.
-     Alternatively, the calendar icon can be used to select the end date.
8.     
Submit
·   Click Submit
-     The report is generated.



4.         Invoke HACI menu option to generate report on Customer Account.
Oval: 2Oval: 3Oval: 1

No
Field
Action
Remarks
1.
Menu Shortcut
·   Enter HACI
-      
2.
Account Id
·   Enter Account Number
-      
3.
GO
·   Click Go
-     Report Generated
Transactions are very important in any financial organizations. As it involves money, Auditors will be cautious and look in to certain transactions which are of very high value.
These transactions may be affecting the accounts of the customers or of the organizations, and internal accounts, that is, office accounts. Since the office accounts have already been discussed in detail, this topic mostly covers transactions of customer’s account.



The Auditor should be able to check if proper accounts are being used during the respective events.  He should also be able to check and confirm that no unusual transactions have happened to these accounts and all the norms of the governing bodies are being adhered to, in case of cash transactions above Rs.50000/- and check if the PAN details have been entered.

The transactions inquiry and report are:
·      Transaction Inquiries (on screen views)
·      Transaction Reports (printable formats)

These inquiries are on the various activities / transactions conducted by the employees working in a Post Office.  These reports and inquiries are effective for operations as well as detective controls for managers and auditors.

Transaction – Menu Options
Menu Option
Function

1
HTI
Transaction inquiry
2
HFTI
Financial transaction inquiry
3
HFTR
Financial transactions report

 




1.      Invoke HTI menu option to inquire on the transaction of a particular ID made on a particular date.
Notes             
·   To start, Log-in to Finacle with User Name and Password.
Oval: 1Oval: 2Oval: 3Oval: 4
No
Field
Action
Remarks
1.     
Function
·   Select I-Inquire
-     Alternatively, the search icon can be used to select the CIF ID.
2.     
Transaction ID
·   Enter the transaction ID
-      
3.     
Transaction Date
·   Enter the transaction date
-     Alternatively, select the calendar icon to select the date.
4.     
Go
·   Click Go
-     The inquiry results are displayed.
Oval: 5Oval: 2Oval: 3
No
Field
Action
Remarks
5.     
OK
·   Click OK
-      

2.      Invoke HFTI menu option to inquire on financial transactions.
This menu shows the transactions with many filters and date range.  Transactions in a particular account can be viewed as per: date range, user ID, transaction status, reference code and other Post Office transactions.
Notes             
·   To start, Log-in to Finacle with User Name and Password.

Notes             
·   To start, Log-in to Finacle with User Name and Password.
Oval: 11Oval: 10Oval: 9Oval: 8Oval: 7Oval: 6Oval: 5Oval: 4Oval: 3Oval: 2Oval: 1
No
Field
Action
Remarks
1.     
Sol Set ID
·   Select the required scheme type for which the inquiry is to be made
-     Alternatively, the search icon can be used to select the SOL Set ID.
2.     
A/c ID.
·   Enter the account number
-     Alternatively, the search icon can be used to select the account number.
3.     
Transaction Type
·   Select the required transaction type
-      
4.     
Ref. No.
·   Enter the reference number
-     Enter 1
5.     
Transaction Amt. (Low)
·   Enter the lowest range of amount
-      
6.     
Transaction Amt. (High)
·   Enter the highest range of amount
-      
7.     
Post user ID
·   Enter the user ID of the person who posted the transaction
-      
8.     
Entry User ID
·   Enter the user ID of the person who created the transaction
-      
9.     
Transaction status
·   Select a relevant transaction status
-      
10.               
A/c. Status
·   Select the account status
-      
11.               
Go
·   Click Go
-     The inquiry results are displayed.
3.      Invoke HFTR to generate a report of financial transactions.
Using HFTR menu option the report can be viewed. When HFTR menu option is invoked, the system will generate the report and user has to further invoke HPR menu option and take the print of the report.
Notes             
·   To start, Log-in to Finacle with User Name and Password.
Oval: 2Oval: 1
No
Field
Action
Remarks
1.     
MRT File Name
·   Select the MRT File
-      
2.     
Go
·   Click Go
-      
*

No comments:

Post a Comment