Banking in TallyPrime (2024)

Tally Solutions |Updated on: October 27, 2022
  • How does TallyPrime help business owners manage their banking activities?
  • Banking utilities in TallyPrime
  • How to create bank ledger in TallyPrime?
  • Auto Bank reconciliation
  • Cheque management
  • Post-dated cheque management
  • Cheque Printing in TallyPrime
  • E-payments
  • Deposit Slip
  • View cash deposit slip report
  • View Cheque Deposit Slip

One of the most crucial and useful features that TallyPrime offers businesses, is its banking capability. Bank-related activities are performed almost on a daily basis by business owners. And so the need to automate and facilitate smooth maintenance of records and processes that are fundamental to effective recording of accounting transactions for timely payments, is extremely significant.

How does TallyPrime help business owners manage their banking activities?

The banking feature in TallyPrime, enables business owners to perform a host of bank-related activities, including payments to parties, bank reconciliation, and cheque management. Usage of this feature enhances and simplifies the banking experience significantly by saving time, reducing errors, improving productivity, and scaling up traceability.

It provides amazing banking capabilities for running your company. You can use its e-payments capability to make timely payments to your parties, manage cheques, reconcile bank statements, and others. TallyPrime’s banking feature supports the following major areas of your business operations.

Banking utilities in TallyPrime

As a business owner, if you use a specific bank to manage your transactions wrt receiving and making payments, TallyPrime offers you a host of utilities including:

  • Auto bank reconciliation
  • Cheque management
  • E-payments
  • Deposit Slip

How to create bank ledger in TallyPrime?

Bank ledgers contain crucial information about a bank that you use to make or receive payments. You can provide information such as Bank name, Account no., IFS code, and address while creating bank ledgers.

Simply go to Gateway of Tally > Create > type or select Ledger and press Enter.

OR

Alt+G (Go To) > Create Master > type or select Ledger and press Enter.

Fill in the required details such as;

  • Name of the bank
  • Bank Accounts (Saving Account (Bank Account), Over Draft account ( Bank OD), Cash Credit account (Bank OCC))
  • Account details – Account holder’s name, A/C number, IFSC, Branch, etc.

Banking in TallyPrime (1)

Once you have configured all the details, you can seamlessly perform the required actions based on the preset details you’ve entered for that bank’s ledger.

Auto Bank reconciliation

Reconciling company’s bank books with the banker’s statement is a regular task of accounting. Thus, TallyPrime offers you bank reconciliation capability, which explains the difference between the bank balance shown in an organization’s bank statement, as supplied by the bank, and the corresponding amount shown in the organization’s own [accounting] records at a particular point of time. With TallyPrime, you can:

  • Check correctness of reconciliation
  • Recover reconciliation of any date
  • Auto Bank Reconciliation
  • Reconcile manually

TallyPrime’s auto bank reconciliation enables users to reconcile bank statements with a long list of transactions, in the most simplified manner. All you got to do is simply import the bank statements, and the reconciliation will happen, automatically. Yes, it is that simple!

You need to enable the option provided for auto bank reconciliation in the bank ledger to reconcile the transactions made with that bank.

Learn how to do auto bank reconciliation in TallyPrime:

Cheque management

With TallyPrime, you can manage a host of pre-defined cheque formats, multiple cheque books and powerful cheque register, manage your banking needs effortlessly. You can maintain record of all payment made using cheques or if you have received payments through cheques from your parties. In TallyPrime, you can configure the cheques based on the type of cheque book you use in your business. Configure the cheques as your need and get them printed to suit your business needs.

In order to print a self cheque in TallyPrime, cheque printing has to be configured. Then you have to pass a contra entry by enteringSelfas theFavouring Namein theBank Allocationscreen.

  • Gateway of Tally>Vouchers> pressF4(Contra). Creditthe bank account
  • Enter the amount in theCredit column
  • PressEnter to go to theBank Allocationsscreen
  • PressF12(Configure) > setShow favouring nameasYes, to enterSelfas theFavouring name.
    TheBank Allocationsscreen appears as shown below:

Banking in TallyPrime (2)

  • PressCtrl+Ato accept and return to theAccounting Voucher Creationscreen
  • Debit the cash account. TheAccounting Voucher Creationscreen appears as shown below:

Banking in TallyPrime (3)

  • PressEnterto go to theCheque Printingscreen and PressP(Print) to print the self-cheque.

Post-dated cheque management

Post-dated cheque as the name suggests is the one that the recipient enchases on a future date. Accounting books usually enter such transactions only once the payment is made.

TallyPrime facilitates smooth management of post-dated cheques and the underlying transactions:

  • You can mark an entry as post-dated and specify the date on which the cheque was received/issued
  • The transaction will automatically affect the accounting books on the date of the post-dated cheque
  • You can obtain a comprehensive summary of all transactions involving post-dated cheques, using thePost-dated Summaryreport
  • You can include post-dated transactions in other accounting reports such asLedger Vouchers,GroupSummary,Outstandingreports, and so on.

Check how to handle cheque management:

Cheque Printing in TallyPrime

This option provided in the Banking menu enables you to print the pending, already printed or the required cheques continuously from a single screen. You can also update the cheque details and have track of cheques to be printed, of a selected or all banks.

In order to print a self cheque in TallyPrime, cheque printing has to be configured. Then you have to pass a contra entry by entering Self as the Favouring Name in the Bank Allocation screen.

  • Gateway of Tally > Vouchers > press F4 (Contra)

OR

Alt+G (Go To) > Create Voucher > press F4 (Contra).

  • Credit the bank account
  • Enter the amount in the Credit column
  • Press Enter to go to the Bank Allocations screen
  • Press F12 (Configure) > set Show favouring name as Yes, to enter Self as the Favouring name

Banking in TallyPrime (4)

  • Press Ctrl+A to accept and return to the Accounting Voucher Creation screen
  • Debit the cash account. The Accounting Voucher Creation screen appears as shown below:

Banking in TallyPrime (5)

E-payments

This feature is a unique capability that syncs your bank master, party master and voucher entry into a common platform intimating the payment transaction to the bank. With e-payments, you can

  • Easily record transactions using the electronic mode of fund transfer, including e-Fund Transfer, e-Cheque, and e-Demand Draft/PO
  • Identify any incomplete information or mismatch in beneficiary details
  • You can send completed payment transactions to the bank, with accurate bank details, either during voucher creation or from an intuitive e-Payments report under Banking
  • You can also export either single or multiple transactions at a time, so you will not have to repeat the process of export. In case of DBS (India), you can also open the bank portal directly from the e-Payments report and authorise any pending transactions
  • View and track the status of your e-payment transactions using the e-Payments report

Getting started with e-payments is easy! All you have to do is, contact your bank to enable bulk upload and then enable e-payments in TallyPrime. In fact, recording an e-payment transaction in TallyPrime is also as easy as recording any other transaction. Simply open a payment voucher, select the party and the bank ledgers, and complete the payment transaction. What’s more, you can make e-payments to your parties or the employees on your company’s payroll using the same simple steps.

Banking in TallyPrime (6)

Once your e-payment transactions are recorded, the payment instructions are ready to be uploaded to the bank portal. Before uploading, the e-Payments report in TallyPrime will help you in checking the transactions to ensure that the details are complete and error-free. If there are any errors, then you can drill down to the relevant section and update the details.

Banking in TallyPrime (7)

You can view and track the status of your e-payment transactions and identify any incomplete information or mismatch in beneficiary details. You can view the e-payments that are sent (or ready to be sent) to the bank. You can also view the bank balance as per the company’s books and compare it with the balance as per the bank.

Gateway of Tally > Banking > e-Payments > press Enter

Banking in TallyPrime (8)

Deposit Slip

Any cash which is received by your business, must be deposited in the bank with relevant Cash Deposit Slip attached. You can generate as well as print the cash deposit slip for depositing cash into a bank on any particular date and period.

The Cash Deposit Slip option in the Banking menu is used to generate cash deposit slips, bank-wise. It has all the relevant information which once configured, need not be re-entered:

  • Account Number
  • Account Holder Name
  • Bank Name
  • Branch Name (information is fetched automatically from Bank ledger)
  • Company’s Telephone Number
  • Cash Denomination

To view cash deposit slip report:

  • Gateway of Tally > Banking > Deposit Slip

OR

Alt+G (Go To) > type or select Cash Deposit Slip and press Enter.

  • Select the required Bank account from the list for whose transaction you want to print Cash Deposit Slip and press Enter

Banking in TallyPrime (9)

Similarly, you can also generate and print cheque deposit slips for payments received through cheque or demand draft which need to be deposited into the bank.

To View Cheque Deposit Slip

  • Gateway of Tally > Banking > Deposit Slip

OR

Alternatively, Alt+G (Go To) > type or select Cheque Deposit Slip and press Enter.

  • Select the required Bank account from the list for whose transaction you want to print Cheque Deposit Slip and press Enter

Banking in TallyPrime (10)

Using these key features of banking utilities provided by TallyPrime, your banking transactions will become must more seamless and worry-free. So, what’s holding you back? Take a free trial of TallyPrime today and experience its banking capabilities for yourself!

Banking in TallyPrime (2024)

FAQs

What are the uses of Banking options in Tally prime? ›

You can make payments through the bank using modes of payment such as cheque or e-payments depending on the nature of transactions. Payments using cheques: In TallyPrime, you can configure the cheques based on the type of cheque book you use in your business.

How to pass bank statement entries in Tally? ›

Go to Gateway of Tally > Banking > Bank Reconciliation > select the bank ledger. 2. Click B : Import . The import progress bar is displayed followed by the Success message with count of Total Entries in Bank Statement , Reconciled transactions and Additional Bank Entries .

Is Tally necessary for Banking? ›

Tally can maintain each and every calculation in businesses and in the banking sector, the tally software maintains a major and important role in slips deposits, maintaining transaction details, printing pending cheques, saving user details like user name, phone number, account number, account details, etc.

Which type of bank account is used in Tally prime? ›

In the Ledger Creation that screen appears, Enter the name of the bank, for which a Bank ledger needs to be created, in the Name field. Three types of Bank Accounts are supported in Tally. ERP 9 - Saving Account (Bank Account), Over Draft account ( Bank OD), Cash Credit account (Bank OCC).

How to enable Banking features in Tally? ›

Simply go to Gateway of Tally > Create > type or select Ledger and press Enter. Alt+G (Go To) > Create Master > type or select Ledger and press Enter. Fill in the required details such as; Name of the bank.

How does Tally bank work? ›

Tally is a brand new asset-backed currency. Every 1 tally in your account represents 1 milligram of physical gold, securely vaulted and insured on your behalf.

Why do we pass journal entry in Tally? ›

There are several reasons why journal entry is important in tally. First, it helps you keep accurate records of your company's spending and income. Second, it provides an orderly way to track money flow in and out of your business. Third, journal entry allows you to make adjustments to your ledger accounts.

What are the golden rules of accounting? ›

What are the Golden Rules of Accounting? 1) Debit what comes in - credit what goes out. 2) Credit the giver and Debit the Receiver. 3) Credit all income and debit all expenses.

How to allow cash and bank in journal entry in Tally prime? ›

In F12: Configure, select Yes for Allow Cash Accounts in Journals (Voucher Entry Configuration). To use Cash/Bank Ledger to pass a Journal voucher, 1. Go to Tally's Gateway > Accounting Vouchers > Accounting Vouchers > Accounting Vouchers > Accounting Vouchers > Accounting Vouchers F7: Journal is the option.

Can I provide bank details in employee master in Tally prime? ›

The Bank Details screen appears. Under the For Statutory & Payroll Reports section, provide the A/c no., IFS code, Bank name, and Branch details. Provide the A/c no., IFS code, and Bank name. You can enable Show favoring name and Allow multiple beneficiary details from F12 (Configure).

How to import bank details in Tally prime from Excel? ›

Import Data from Sample Excel File into TallyPrime
  1. Press Alt+O (Import) > select Masters or Transactions. ...
  2. Provide details of the Excel file from which the data needs to be imported. ...
  3. Configure for the impact of import on existing masters using the option Behaviour of Import if Masters already exists.

How to allow bank and cash in journal entry in Tally prime? ›

Go to Tally's Gateway > Accounting Vouchers > Accounting Vouchers > Accounting Vouchers > Accounting Vouchers > Accounting Vouchers F7: Journal is the option. 2. In the Debit or Credit area, press the spacebar. The Journal Voucher Screen will appear, with the Cash/Bank Ledger option selected.

How to pass debit and Credit Note in Tally prime? ›

Press Alt+G (Go To) > Create Voucher > press F10 (Other Vouchers) > type or select Debit Note and press Enter. Alternatively, Gateway of Tally > Vouchers > press F10 (Other Vouchers) > type or select Debit Note and press Enter.

Top Articles
Latest Posts
Article information

Author: Edwin Metz

Last Updated:

Views: 6416

Rating: 4.8 / 5 (78 voted)

Reviews: 93% of readers found this page helpful

Author information

Name: Edwin Metz

Birthday: 1997-04-16

Address: 51593 Leanne Light, Kuphalmouth, DE 50012-5183

Phone: +639107620957

Job: Corporate Banking Technician

Hobby: Reading, scrapbook, role-playing games, Fishing, Fishing, Scuba diving, Beekeeping

Introduction: My name is Edwin Metz, I am a fair, energetic, helpful, brave, outstanding, nice, helpful person who loves writing and wants to share my knowledge and understanding with you.