Banking Entry in Tally.ERP 9 | Tally Solutions

Banking in Tally

  • 1. Introduction
  • 2. Bank Entry in Tally. ERP 9
  • 3. How to enable Banking features in Tally.ERP 9 ?
  • 4. How to enter bank transactions in Tally.ERP 9 ?

1. Introduction

An account statement or bank statement is a summary of financial transactions which have occurred over a given period on a bank account held by a person or business with a financial institution.

These statements have historically been and continue to be typically printed on one or several pieces of paper and either mailed directly to the account holder, or kept at the financial institution's local branch for pick up. But over a period of time there has been a shift towards paperless, electronic statements, and some financial institutions offer direct download into account holders accounting software.

And the process of entering these entries based on account books, and supporting vouchers in books of accounts and reconciling the same with bank entries as standing in bank statements issued by bank marks the beginning of channelizing banking entries into books of accounts which plays a vital role for every business and ERP machines serves as a effective medium or source for journalizing or routing these entries into books of accounts.

2. Bank Entry in Tally. ERP 9

The process to enter a bank entry in Tally.ERP 9 would be as follows-

Process No 1 Create a ledger under bank accounts and then save the same.
Process No 2 Go to accounting vouchers menu and then we need to select what kind of voucher do we need to pass using the bank account. One can use 3 voucher type to pass a bank Entry in Tally.ERP 9

Payment - To make payment entry. Debit the Expenses Ledger (for cash transactions)/Party Ledger (for non cash transactions) and Credit the Bank. The short cut key to Select Payment Voucher is F5.

Receipt - To make receipt entry. Debit the Bank Ledger and Credit the Party Ledger (for cash transactions) / Income ledger (for non cash transactions). The shortcut key to Select Receipt Voucher is F6.

Contra - Use for only cash transaction. Debit / Credit Bank /Cash. The Short cut key to Select Contra Voucher is F4.      

3. How to enable Banking features in Tally.ERP 9 ?

To list the features of Tally.ERP 9 under the module Banking could be as follows :

Banking Features in Tally.ERP 9
  • Cheque Printing
  • Deposit Slips
  • Bank Reconciliation
  • Payment Advice

How to enable banking features in Tally.ERP 9 ?

  • Cheque Printing : To access Cheque Printing screen,
    • Go to Gateway of Tally > Banking > Cheque Printing.
    • The Select Bank screen displaying the List of Bank appears
    • Select All or the required Bank account and press Enter
    • The Cheque Printing screen of the selected Bank is displayed now. (Note : By default, this screen displays list of pending cheques of the current date’s month.)
    • Press F6: Show All to display all the cheques.
    • F2: Period: Allows to change the period.
    • F4: Bank: Allows to select All / Other required Bank from the list.
    • F7: Edit challan Details: Allows to edit/update the Favouring Name, Instrument No, and Instrument Date columns.

    This is how cheque printing feature is activated or enabled in Tally.ERP 9.

  • Bank Reconciliation : To access Cheque Printing screen, follow these steps.
    • Go to Gateway of Tally > Banking > Bank Reconciliation
    • The Select Bank screen displaying the List of Bank appears
    • Select the required Bank account and press Enter.
    • The Bank Reconciliation screen of the selected Bank is displayed

    (Or) one can just make an access to accounts book from gateway of Tally.ERP 9 and then to Cash/Bank books and open the bank ledger of the month which needs to be reconciled and Press F5 for Bank reconciliation.

  • Deposit Slip : The Deposit Slip option in the Banking menu allows the user to generate the deposit slip for payments received through cheque/demand draft which need to be deposited into the bank.

    To access Deposit Slip screen,

    • Go to Gateway of Tally > Banking > Deposit Slip.
    • The Select Bank screen displaying the List of Bank appears
    • Select the required Bank account and press Enter.
    • The Deposit Slip screen of the selected Bank is displayed
    • Select the required row from the Deposit Slip list and press Enter to open the voucher in alteration mode.
    • F2: Period: Allows to change the period.
    • F4: Bank: Allows to select other required Bank from the list.
    • F7: Edit Challan Details: Allows to edit/update the Received From Name and Instrument Number (Note : The Received From is an addition field available in the Deposit Slip screen to specify the name of Individual/Business Organisation who has issued the cheque, to be printed in the deposit slip/report.)
    • Accept the screen to save the settings.

    Note : The Deposit Slip screen displays only those transactions which have Cheque/Demand Draft as Transaction type allocated in the Bank Allocation table in the Receipt voucher entry.

  • Payment Advice : The Payment Advice option in the Banking menu allows the user to generate the payment advice sent to the suppliers / other parties along with the cheques/other instruments.

    To access Payment Advice screen,

    • Go to Gateway of Tally > Banking > Payment Advice
    • The Ledger selection screen displaying the List of Ledgers appears
    • Select the required Ledger and press Enter.
    • The Payment Advice screen displays the payment list of the selected ledger
    • Select the required row from the Payment Advice list and press Enter to open the voucher in alteration mode.
    • F2: Period: Allows to change the period.
    • F4: Ledger: Allows to select other required Ledger from the list.

4. How to enter bank transactions in Tally.ERP 9 ?

Transaction Details Explanation Voucher Type to Select Journal Entry
Cash Deposit Bank entry in Tally.ERP 9 Depositing cash into bank account is a usual practice cash generated through sales proceeds is usually deposited into bank.

This is called a contra entry because this transaction does not create any result in business, and it is only an internal moving of cash from cash-in-hand to cash at bank.
Contra Voucher Shortcut Key - F4 Bank A/c (Dr) *** To Cash (Cr)  ***
How to Set Bank allocation in Tally.ERP 9 for this entry : To fill the bank allocation for above transaction in Tally. ERP 9 : After entering the data in the account field, and selecting the Cash ledger in Particulars field, Press enter to fill bank allocation in Tally.

Received from : Cashier           Transaction type : Cash         Amount: Automatically selected
Denomination: 2000 x  ___        Branch: _______
                      500 x  ___
                      200 x  ___
                      100 x  ___
                      50  x  ___
                      20  x  ___
                      10  x  ___
 
Bank entry in Tally.ERP 9 for cheque Issued or given to a supplier When cheque is issued to a supplier, We enter the transactions immediately in Tally and the bank balance & Liability decreases. Payment Voucher

Short Cut Key - F5
Supplier A/c (Dr) ***

Bank A/c (Cr)  ***
How to set bank allocation in Tally for this entry : In bank allocation screen, fill up the following :

Favouring name : Supplier _____          Transaction Type: Cheque              Amount: ______

Instrument No: _____                             Instrument Date: _____           Cross Using:  _____

Notes :
  1. Instrument Date : Can be any date on the cheque , need not be same as transaction date.
  2. Cross Using : A/c Payee if cheque is crossed.
  3. Amount : Is automatically selected
  4. Transaction Type : Select from the following : E Fund Transfer/Cheque/Demand Draft


GST Software Free Trial
 
Thank You !