Interview Questions

A commercial bank is a financial body which performs the functions of accepting deposits from the general public and giving short term loans for investment with the aim of earning profit.

Financial statements can be prepared from the Adjusted trial balance. A trial balance is a report containing list of all the general ledger accounts i.e, debits and credits contained in the ledger of a business. The types of trial balance include : Unadjusted trial balance, Adjusted trial balance and the Post- closing trial balance.

Rupess is the currency of our country and only govt has the authority to issue indian currency it has been signed by ministry of finance, all other notes are bearer notes which are signed by governor.

no interference by RBI.

RBI has the right to print currency notes in the country except coins & 1 Re note which are issued by Govt. Thus, it bears the sign of MoF.

Fact is key performance indicator to analyze the business.From the additive values, which are used to analyse the business by using report generation. Dimension is used to analyze the fact, are the non-additive ( text format) values, Which are used to drill down reports.Without dimension there is no meaning for fact. Measure is the quantity of data we create to process.

KPO stands for Knowledge Process Outsourcing. It is a subset of call centers. The ways in which a KPO differs from a call center are :

1. In KPO knowledge and information related work is carried out.

2. Staff requirement is for highly skilled people.

3. Is mainly related to support and not sales.

4. Carries out works mainly for research and analysis process besides support.

The Debit balance recovery is usually made by raising a credit memo for the regular vendors. However if there are no future transactions from the supplier, we ask the vendor to send the check / make an EFT for the amount due from him.

When payment is made to the wrong vendor or payment made in excess, in that case overpayment has gone to the vendor, So for us it is vendor debit balance.

For debit balance recovery, we can either follow-up with the vendor to send us the excess amount / refund back, or we can adjust that extra amount in future invoices submitted by that vendor

In Case no future transactions, we have to follow-up with the vendor, falling whicch we have to write off this amount.

MIS report is known as Management Information System... regarding the Manpower status of a particular month, place and overall..

It helps the Management in decision making.. like what are the reasons of resignation.. in which area attrition is high.. and so many things to help in decision making.. with the help of MIS you may prepare a lot of reports.. Like annual attrition.. region wise attrition.. region wise manpower.. graphical representation of regions manpower status.. and so on..

You may prepare the same at your end.As it will help you to prepare other such formats too.

I am describing you the contents with sheet wise..

First Sheet - Details of employee

a. E.Code

b. Name of employee

c. Date of birth          

d. Designation

e. CTC

f. Address for communication

g.Permanent address

h. Contact number

i. Blood group

j. Maximum qualification

k. Extra qualification

l.Total Experience

Second Sheet- Salary structure

In this sheet write down the complete salary structure.. and make a column what is salary after any revision

Third Sheet - New Joinees

In this sheet write down the name of New joinees of that month with detail like CTC,  Designation, DOB etc. 

Forth Sheet - Resigned employees

In this sheet write the name of employees who resigned during that particular month with details like name, designation, date of joining, Date of resignation, last working day.

Fifth sheet - Attrition rate

Based on this MIS report, you may find out the attrition report, Qualification analysis reports, team management reports and so on can prepare a number of reports..