Application and Preparation of Demand Drafts

The first step includes visiting the bank and asking for a demand draft form or you can fill one through online services.

Next, you need to fill in all the necessary details such as

  • Payment mode: Cheque or cash,
  • Make the demand draft under whose name,
  • The total amount,
  • Cheque number,
  • Your bank account number,
  • Encashment details and
  • Your signature.

You will get your demand draft once you submit the required application form along with the services charges. Every bank has its own charge structure. You need to find out the charge of the bank from which you are availing the demand draft service. You can make your demand draft either at your own bank or at any other bank.

You need to give your PAN card details if the sum total is more than Rs. 50,000

If you making a demand draft online then all you need to do is fill in all the details and then collect the demand draft at the respective branch mentioned by the bank. You will get your demand draft after 2-5 days by courier.

Features of a Demand Draft

  • It can only be paid on demand.
  • Under the act of the Negotiable Instruments Act, 1881, in section 85, complete information has been laid out about demand drafts.
  • It shouldn’t be paid to the bearer
  • There is a specific amount of charge attached to the demand draft. RBI decides services charges for demand drafts but each and every bank is free to have their own service charges.

Preparation of Demand Drafts

Demand Draft Clearing Time

Demand Draft is unlike a cheque. While a cheque takes a specified time of a day or two to get cleared, the same cannot be said for the demand draft. There are no codified rules as to how long the banks have to take in clearing the DD, which is why the time taken by each bank varies. Ideally, it takes two business days for a demand draft to be cleared.

This time can be longer in case there are any issues with the instrument. As stated earlier, Demand Drafts are executed after several scrutinise and they are technically drawn by a bank on another bank. In situations where the amount has to be transferred from one bank to another, there is a possibility of it taking longer than two days.

How to Get a Demand Draft Issued

  • Visit the bank where you have your account.
  • Draw cash in the name of “self”
  • Ask the bank teller to give you the form needed to be filled for making the demand draft
  • Fill in the details and submit the form along with the cheque.
  • The teller will scrutinize all the details and once he is satisfied, he will ask you to pay a small charge for making the DD
  • He will then stamp the DD and hand it over to you.

Crossed Demand Draft

In case the Demand Draft is Crossed as Account Payee, it cannot be encashed over the counter from the Bank Branch and can only be cleared by depositing in the Bank Account of the Person in whose favor the DD has been made. However, in case the Instrument is not a Crossed Demand Draft, it can be encashed without depositing in the Bank Account, by encashing it over the counter from the Bank Branch.

The main purpose of Crossing a Demand Draft is the ensure that the payment is cleared by means of an account i.e. the payment is deposited in the Bank Account of the person in whose favour the DD has been drawn. This helps in preventing wrongful payment to any person and ensures that the payment is made only to the person in whose favour the DD has been drawn and not to any person.

If the DD is not crossed, the payment would be made by the bank to the holder of the Instrument after his proper identification. And in case, it is a crossed demand draft, the payment would be made only to the Bank Account of the person.

Difference between Demand Draft and Cheque

A Cheque is signed by an Individual and therefore there are chances that the cheque may or may not clear. However, a DD is prepared by the Banker and as it is signed by a banker, the chances of default are not there.

You would have seen that many organisations when receiving payments from the public don’t accept Cheque Payments and require that payments should be made through Bank Drafts. The reason for this is that there are chances that the Cheque may get dishonoured or may not clear due to any reason whatsoever, but that is not the case with DD. In case of a DD, the Payment is to be made by the Bank who has drawn the Demand Draft and therefore the chances of the cheque not clearing are Nil.

Filling up of pay in slips

  • First, you have to write the SBI branch name from where you are depositing the amount.
  • After the Branch, write down the deposit date and year separately.
  • After that, fill in the account number you want to deposit the money. Squares separate the account number section. You have to write 1 number in each square.
  • After filling in the account number, Fill in the Account holder’s name.
  • Below that, Enter the Deposit amount in words.
  • Fill the Deposit amount in numbers.
  • Fill the Sum of the total amount in numbers.
  • The depositor needs to sign in this Box.
  • Fill in your mobile number in this section. The mobile number’s filling process is the same as the 2nd step.
  • Here you need to fill in the pan card number. If your deposit amount is less than 50000, you don’t have to fill it.

How to fill Right Section of SBI Bank Deposit Slip

  • First, you have to fill in the bank branch name as same as before.
  • After That, mark on your account type.
  • Below that, fill up the Bank Account Number in which you want to deposit the money. Filling the account number process is the same as before we discussed it.
  • In the Next section, Fill the Account Holder’s Name.
  • Fill the Deposit amount in numbers below that Fill the Sum of the total amount in numbers.
  • In this section, enter the total deposit amount in words (If you were depositing Rs. 2000, then write “Two Thousand Only”).

Note: If you were depositing more them Rs. 50000, then you have to write the Pan Card number in the Pan card option.

Fixed Deposit account and FD Receipts

A fixed deposit (FD) is a financial instrument provided by banks or NBFCs which provides investors a higher rate of interest than a regular savings account, until the given maturity date. It may or may not require the creation of a separate account. It is known as a term deposit or time deposit in Canada, Australia, New Zealand, India and the United States, and as a bond in the United Kingdom and for a fixed deposit is that the money cannot be withdrawn from the FD as compared to a recurring deposit or a demand deposit before maturity. Some banks may offer additional services to FD holders such as loans against FD certificates at competitive interest rates. It’s important to note that banks may offer lesser interest rates under uncertain economic conditions. The interest rate varies between 4 and 7.50 percent. The tenure of an FD can vary from 7, 15 or 45 days to 1.5 years and can be as high as 10 years. These investments are safer than Post Office Schemes as they are covered by the Deposit Insurance and Credit Guarantee Corporation (DICGC). However, DICGC guarantees amount up to ₹ 500000 per depositor per bank. They also offer income tax and wealth tax benefits.

Fixed deposits are high-interest-yielding term deposits and are offered by banks in India. The most popular form of term deposits are fixed deposits, while other forms of term deposits are recurring deposit and Flexi Fixed deposits (the latter is actually a combination of demand deposit and fixed deposit).

To compensate for the low liquidity, FDs offer higher rates of interest than saving accounts. The longest permissible term for FDs is 10 years. Generally, the longer the term of deposit, the higher is the rate of interest but a bank may offer a lower rate of interest for a longer period if it expects interest rates, at which the Central Bank of a nation lends to banks (“repo rates”), will dip in the future.

Usually in India, the interest on FDs is paid every three months from the date of the deposit (e.g. if FD a/c was opened on 15 Feb, the first interest installment would be paid on 15 May). The interest is credited to the customers’ Savings bank account or sent to them by cheque. This is a Simple FD. The customer may choose to have the interest reinvested in the FD account. In this case, the deposit is called the Cumulative FD or compound interest FD. For such deposits, the interest is paid with the invested amount on maturity of the deposit at the end of the term.

Although banks can refuse to repay FDs before the expiry of the deposit, they generally don’t. This is known as a premature withdrawal. In such cases, interest is paid at the rate applicable at the time of withdrawal. For example, a deposit is made for 5 years at 8% but is withdrawn after 2 years. If the rate applicable on the date of deposit for 2 years is 5 percent, the interest will be paid at 5 percent. Banks can charge a penalty for premature withdrawal.

Banks issue a separate receipt for every FD because each deposit is treated as a distinct contract. This receipt is known as the Fixed Deposit Receipt (FDR), which has to be surrendered to the bank at the time of renewal or encashment.

Many banks offer the facility of automatic renewal of FDs where the customers do give new instructions for the matured deposit. On the date of maturity, such deposits are renewed for a similar term as that of the original deposit at the rate prevailing on the date of renewal.

Income tax regulations require that FD maturity proceeds exceeding Rs 20,000 not to be paid in cash. Repayment of such and larger deposits has to be either by “A/c payee” crossed cheque in the name of the customer or by credit to the saving bank a/c or current a/c of the customer.

FD Receipts

As one of the most common savings and investment options used by individuals, fixed deposits are risk free and offer guaranteed returns. Fixed deposits provide investors with an interest rate that is higher than what is offered on normal savings accounts. The maturity value of a fixed deposit is based on the date of maturity chosen by the individual. Individuals opt for fixed deposits as they are not risky and also provide assured returns, even if these returns are not very high such as those provided by mutual investments and equities.

Applicants can procure Fixed Deposits by visiting their bank or even on their bank’s website as many banks have enabled the facility of providing fixed deposits online. Once applicants apply for their fixed deposit scheme and all formalities are complete, they will receive a fixed deposit receipt as an acknowledgment. This is an important document and should be kept safely.

Fixed Deposit Receipt

A Fixed Deposit Receipt (FDR) is nothing but a document provided by the bank after the applicant procures a fixed deposit scheme from their bank. This document contains details such as the individual’s name, age, address, details of the scheme chosen by them such as deposit amount, tenure and interest rate applicable on the deposit and so on.

Components and Importance of a Fixed Deposit Receipt

A Fixed Deposit Receipt contains all the details related to the deposit option procured by the individual. These details include:

  • Name of the applicant
  • Age of the applicant
  • Account Number of the applicant
  • Amount of principal that has been placed
  • Rate of Interest that is applicable
  • Date of Maturity
  • Amount of interest that the individual will receive on maturity
  • Instructions regarding maturity date such as account transfer or rollover amount.

Checklist:

Auto renewal and date of maturity: It is convenient for individuals to opt for auto renewal if they have a guaranteed salary every month as it saves on hassle and time during the next renewal. Also, date of maturity is another detail that should not be missed by individuals as this will help them plan out their financials better and also with regard to the day, they can withdraw their fixed deposit investment.

Term and interest rate offered: Although this is a basic component of the receipt and may already be known to the customer, it is important to check these details again. This has to be given priority especially when individuals are renewing their fixed deposit scheme as certain rates may be discontinued by the bank.

Penalty for Prepayment: Banks sometimes charge a penalty on their fixed deposit if prepayment has been done. For example, if a bank charges 1% as the penalty for prepayment and individuals withdraw their fixed deposit (valued at 9%) after a period of 6 months, then they will receive an interest rate of only 6%, assuming the bank provides 7% as the interest for a 6-month FD.

Nomination: The receipt must provide details of the nomination in case the individual has made one. In the event of the unfortunate death of the individual, his/her nominee will receive the proceeds of the fixed deposit.

Declaration to save TDS: Tax at source is deducted by the bank in case the income from interest is over Rs.10,000. In case an individual’s income falls into the bracket of ‘no income tax’ then declaration through Form 15G or Form 15H can be submitted and this must be mentioned in the receipt.

Pass Book

A passbook or bankbook is a paper book used to record bank or building society transactions on a deposit account.

A page with a pre-printed table. It has handwritten entries showing amounts of deposits and withdrawals, and the balance. Each entry has a post office date stamp.

Traditionally, a passbook is used for accounts with a low transaction volume, such as savings accounts. A bank teller or postmaster would write by hand the date and amount of the transaction and the updated balance and enter his or her initials. In the late 20th century, small dot matrix or inkjet printers were introduced that were capable of updating the passbook at the account holder’s convenience, either at an automated teller machine or a passbook printer, either in a self-serve mode, by post, or in a branch.

Credits and deposits

To add credit to an account by bringing cash to a bank in person, the account holder can fill a small credit slip or deposit slip. The total amount of each note and coin is counted and entered on the slip, along with who it is paid in by and the date. The cash and details are counted and checked by the teller at the bank, if everything is in order the deposit is credited to the account, the credit slip is then kept by the bank and the credit slip booklet is stamped with the date and then returned to the account holder. An account holder uses their passbook to record their history of transactions with their bank.

Debits and Withdrawals

Withdrawals normally required the account holder to visit the branch where the account was held, where a debit slip or withdrawal slip would be prepared and signed. If the account holder was not known to the teller, the signature on the slip and the authorities would be checked against the signature card at the branch, before money was paid out. In the 1980s, banks adopted the black light signature system for passbooks, which enabled withdrawals to be made from passbooks at a branch other than the one where an account was opened, unless prior arrangements were made to transfer the signature card to the other branch. Under this system, the passbook’s owner would sign in the back of the passbook in an invisible ink and the signing authorities would also be noted. At the paying branch, the signature on the withdrawal slip would be checked against the signature in the book, which required a special ultraviolet reader to read. Nowadays, customer verification is more likely to be by PIN and commonly from an automated teller machine.

Features of a Pass Book

A pass book resembles a lot like a ledger and all the transactions are entered by the banker. It too has a debit column and credit column to enter the deposits and withdrawals. A brief description of each transaction will be given in the descriptive column. This enables the account holder to have a clear idea of his transactions. Its main function is to act as a unquestionable record of banking transactions between the customer and the banker. If you notice any change in the entries made in your pass book, you will have to bring it to the attention of the concerned person then and there. It is considered to be the duty of the account holder to examine his pass book for any wrong entries. The bank will also not acknowledge the deposit of any sum that is not mentioned in your pass book. Hence examine your pass book and get the transactions recorded once in a while.

Loss of a Pass Book

It is the responsibility of the account holder to keep his/her pass book safely and the bank will not take the responsibility related to the loss of a pass book. When your pass book is lost, mutilated or destroyed, you can apply for a duplicate one. However, a charge of Rs. 50.00 applies in this case, even though the original pass book was issued free of cost. At certain cases, the bank may waive off the said amount if the bank believes that the depositor had no control over the pass book being lost or destroyed. It is your responsibility to immediately inform your bank regarding the missing of your pass book. You may have to fill up an application form or sign a letter of indemnity to get a duplicate one. Once you get the new pass book you can request the banker to include all the previous transactions in it but the bank may charge a nominal fee for the extra labour work involved.

Offer letter, Appointment letter

Offer letter

An offer letter is a document which is given to a candidate after he has been selected for the position. The letter clearly, mentions the salary package, designation, department and other benefits that he will be entitled to, if he joins the company. Other than this, a statement of at-will employment, list of contingencies, and a confidentiality agreement. A signed offer letter doesn’t mean that you are legally bound to join the company after that. However, that may be possible in very rare circumstances.

Purpose:

  • It provides information about the job role, compensation and benefits, and other conditions of employment.
  • It marks the beginning of a positive employment relationship.
  • It acts as a legal document.
  • It sets the right expectations.

Content:

  • The job title of the employee being hired.
  • A brief job description of the same.
  • The joining date of the new employee.
  • The work time and workable schedule of the employee.
  • Their place in the hierarchical structure of the team or the org.
  • A brief about the leave policy and details about list of leaves.
  • A breakdown of the salary and other financial benefits.
  • A description of the employee benefits being given to the new joinee.
  • A list and breakdown of the privacy policies that the employee is supposed to abide by.

Appointment letter

An appointment letter or employment letter is a formal letter provided in writing to a candidate joining for employment. Appointment letters are usually provided after offer letter on the first day of the candidate starting work. The appointment letter describes in length the position offered, salary, benefits, confidentiality policy, work policy, starting date, and important information about the employment. The candidate usually would receive the appointment letter on the first day after beginning employment and would return a signed copy back to the employer indicating acceptance of the appointment letter.

Content:

  • Name and current address details of the organization (employer)
  • Name and address of the applicant
  • Name of the position (position title)
  • Additional details about job duties and responsibilities of the job
  • Conditions of job: whether permanent or temporary, office employee time, performing another job simultaneously.
  • Monthly salary per employee’s agreed-upon salary.
  • Time length of the contract.

Text Functions: LEN, TRIM, PROPER, UPPER, LOWER, CONCATENATE

Function Description
ASC function Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
BAHTTEXT function Converts a number to text, using the ß (baht) currency format
CHAR function Returns the character specified by the code number
CLEAN function Removes all nonprintable characters from text
CODE function Returns a numeric code for the first character in a text string
CONCAT function Combines the text from multiple ranges and/or strings, but it doesn’t provide the delimiter or IgnoreEmpty arguments.
CONCATENATE function Joins several text items into one text item
DBCS function Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters
DOLLAR function Converts a number to text, using the $ (dollar) currency format
EXACT function Checks to see if two text values are identical
FIND, FINDB functions Finds one text value within another (case-sensitive)
FIXED function Formats a number as text with a fixed number of decimals
LEFT, LEFTB functions Returns the leftmost characters from a text value
LEN, LENB functions Returns the number of characters in a text string
LOWER function Converts text to lowercase
MID, MIDB functions Returns a specific number of characters from a text string starting at the position you specify
NUMBERVALUE function Converts text to number in a locale-independent manner
PHONETIC function Extracts the phonetic (furigana) characters from a text string
PROPER function Capitalizes the first letter in each word of a text value
REPLACE, REPLACEB functions Replaces characters within text
REPT function Repeats text a given number of times
RIGHT, RIGHTB functions Returns the rightmost characters from a text value
SEARCH, SEARCHB functions Finds one text value within another (not case-sensitive)
SUBSTITUTE function Substitutes new text for old text in a text string
T function Converts its arguments to text
TEXT function Formats a number and converts it to text
TEXTJOIN function Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.
TRIM function Removes spaces from text
UNICHAR function Returns the Unicode character that is references by the given numeric value
UNICODE function Returns the number (code point) that corresponds to the first character of the text
UPPER function Converts text to uppercase
VALUE function Converts a text argument to a number

Perform calculations by using MIN and MAX function

Select a cell below or to the right of the numbers for which you want to find the smallest number.

On the Home tab, in the Editing group, click the arrow next to AutoSum Button image, click Min (calculates the smallest) or Max (calculates the largest), and then press ENTER.

If the cells are not in a contiguous row or column

To do this task, use the MIN, MAX, SMALL, or LARGE functions.

Example

Copy the following data to a blank worksheet.

1 A
  Data
2 10
3 7
4 9
5 27
6 0
7 4
  Formula Description (Result)
  =MIN(A2:A7) Smallest number in the range (0)
  =MAX(A2:A7) Largest number in the range (27)
  =SMALL(A2:A7, 2) Second smallest number in the range (4)
  =LARGE(A2:A7,3) Third largest number in the range (9)

Perform calculations by using the AVERAGE function

Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

Syntax

AVERAGE(number1, [number2], …)

The AVERAGE function syntax has the following arguments:

Number1    Required. The first number, cell reference, or range for which you want the average.

Number2, …    Optional. Additional numbers, cell references or ranges for which you want the average, up to a maximum of 255.

  • Arguments can either be numbers or names, ranges, or cell references that contain numbers.
  • Logical values and text representations of numbers that you type directly into the list of arguments are not counted.
  • If a range or cell reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
  • Arguments that are error values or text that cannot be translated into numbers cause errors.
  • If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the AVERAGEA function.
  • If you want to calculate the average of only the values that meet certain criteria, use the AVERAGEIF function or the AVERAGEIFS function.
  • Average, which is the arithmetic mean, and is calculated by adding a group of numbers and then dividing by the count of those numbers. For example, the average of 2, 3, 3, 5, 7, and 10 is 30 divided by 6, which is 5.
  • Median, which is the middle number of a group of numbers; that is, half the numbers have values that are greater than the median, and half the numbers have values that are less than the median. For example, the median of 2, 3, 3, 5, 7, and 10 is 4.
  • Mode, which is the most frequently occurring number in a group of numbers. For example, the mode of 2, 3, 3, 5, 7, and 10 is 3.

To locate the Show a zero in cells that have a zero-value check box:

On the File tab, click Options, and then, in the Advanced category, look under Display options for this worksheet.

Example

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

Data
10 15 32
7
9
27
2
Formula Description Result
=AVERAGE(A2:A6) Average of the numbers in cells A2 through A6. 11
=AVERAGE(A2:A6, 5) Average of the numbers in cells A2 through A6 and the number 5. 10
=AVERAGE(A2:C2) Average of the numbers in cells A2 through C2. 19

Perform calculations by using the COUNT function

Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.

In its simplest form, COUNTIF says:

=COUNTIF(Where do you want to look?, What do you want to look for?)

For example:

=COUNTIF(A2:A5,”London”)

=COUNTIF(A2:A5,A4)

Examples

To use these examples in Excel, copy the data in the table below, and paste it in cell A1 of a new worksheet.

Data Data
apples 32
oranges 54
peaches 75
apples 86
Formula Description
=COUNTIF(A2:A5,”apples”) Counts the number of cells with apples in cells A2 through A5. The result is 2.
=COUNTIF(A2:A5,A4) Counts the number of cells with peaches (the value in A4) in cells A2 through A5. The result is 1.
=COUNTIF(A2:A5,A2)+COUNTIF(A2:A5,A3) Counts the number of apples (the value in A2), and oranges (the value in A3) in cells A2 through A5. The result is 3. This formula uses COUNTIF twice to specify multiple criteria, one criteria per expression. You could also use the COUNTIFS function.
=COUNTIF(B2:B5,”>55″) Counts the number of cells with a value greater than 55 in cells B2 through B5. The result is 2.

Perform calculations by using the SUM function

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done.

When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.

Here’s an example. To add the January numbers in this Entertainment budget, select cell B7, the cell immediately below the column of numbers. Then click AutoSum. A formula appears in cell B7, and Excel highlights the cells you’re totalling.

Press Enter to display the result (95.94) in cell B7. You can also see the formula in the formula bar at the top of the Excel window.

error: Content is protected !!