✦Template Printable Ideas Insights

Mastering Tally: Step-by-Step Guide to Creating a Bank Ledger

By

Creating a bank ledger in Tally, a popular accounting software, is a straightforward process that will enable you to monitor and manage your business finances effectively. Whether you're a small business owner or a professional accountant, understanding how to create and use a bank ledger in Tally can greatly streamline your accounting processes. This comprehensive guide will walk you through the steps, ensuring you get the most out of this powerful feature.

Before we dive into the process, it's essential to understand that a bank ledger in Tally records all the transactions related to your business' bank or cash account. By creating and maintaining a bank ledger, you can track deposits, withdrawals, balance adjustments, and other banking activities accurately. Now, let's proceed to creating a bank ledger in Tally.

Setting Up Tally for Creating a Bank Ledger

To begin, ensure that Tally is installed and up-to-date on your computer or server. Then, log in with your username and password, and navigate to the 'Books' menu. If this is your first time creating a ledger in Tally, you'll need to set up a new company and diary first.

Taly How to create (Bank Ledger) in tally
Taly How to create (Bank Ledger) in tally
Complete Tally Ledger List & Groups Explained
Complete Tally Ledger List & Groups Explained
Introduction to Voucher Entries and Ledger Creation in Tally ERP 9 Tutorial - Lesson 3
Introduction to Voucher Entries and Ledger Creation in Tally ERP 9 Tutorial - Lesson 3

Once you've created or selected your company and diary, you're ready to start setting up your bank ledger.

Defining Your Bank/Cash Account

Before creating the bank ledger, you'll need to define your bank or cash account in Tally. This account will serve as the basis for your bank ledger. To define your account, follow these steps:

an info sheet describing how to use the internet for business purposes, including email and other information
an info sheet describing how to use the internet for business purposes, including email and other information
Excel & Google Sheets Template: Bank Ledger Sheet, General Ledger Accounting, General Ledger SpreadSheet, Money Tracker,Bookkeeping Template
Excel & Google Sheets Template: Bank Ledger Sheet, General Ledger Accounting, General Ledger SpreadSheet, Money Tracker,Bookkeeping Template
Tally Ledger Groups List (Ledger under Which Head or Group in Accounts
Tally Ledger Groups List (Ledger under Which Head or Group in Accounts
  1. Go to 'F Procedures' > 'Accounting Vouchers' > 'Duties' > 'Create' > 'Define Accounts'.
  2. Enter the appropriate details for your bank or cash account, such as the account name, type (e.g., Savings, Current), and the applicable group and subgroup.
  3. Click 'Create' to save your new account.

Creating a New Ledger in Tally

Now that you've defined your bank/cash account, you can proceed to create the bank ledger. Follow these steps:

  1. Go to 'Books' > 'Sets' > 'Ledgers'.
  2. Click on 'Create > New' to open the 'Create New Ledger' window.
  3. Enter the ledger name (e.g., 'Bank Ledger'), select the 'Type' as 'Manual', and choose the previously created bank/cash account as the 'Opening Balance Account'.
  4. Set the 'Opening Balance' to the current balance of your bank account and click 'Create' to finalize the creation of your bank ledger.

Maintaining and Using Your Bank Ledger in Tally

With your bank ledger created, you can now start recording and tracking your bank transactions in Tally. To do this, you'll mainly use the 'Record Transaction' feature, which allows you to enter and verify deposits, withdrawals, and other banking activities.

To record a transaction, follow these steps:

a table with the basic rules for accounts to be used in different types of businesses
a table with the basic rules for accounts to be used in different types of businesses
Journal vs Ledger – Key Differences Every Commerce Student Should Know
Journal vs Ledger – Key Differences Every Commerce Student Should Know
the types of ledgers in english
the types of ledgers in english
General Ledger Accounting Printable, General Ledger Spreadsheet, Money Tracker,bookkeeping Template, Editalbe EXCEL / Google Sheets Template - Etsy
General Ledger Accounting Printable, General Ledger Spreadsheet, Money Tracker,bookkeeping Template, Editalbe EXCEL / Google Sheets Template - Etsy
Invoice Template Word: Streamline Your Billing Process Today
Invoice Template Word: Streamline Your Billing Process Today
37 Perfect General Ledger Templates [Excel, Word] ᐅ TemplateLab
37 Perfect General Ledger Templates [Excel, Word] ᐅ TemplateLab

Recording Bank Transactions

To record a transaction, go to 'F Procedures' > 'Accounting Vouchers' > 'Journal Entries' > 'Create' > 'Fresh'. In the 'Voucher' window, select your bank ledger as the 'Voucher Type'.

  • Enter the relevant transaction details, such as the date, narration (description), and the corresponding debits or credits.
  • Use the 'Mode of Payment/Discharge' section to categorize the transaction type (e.g., Cash, Cheque, Online Transfer).

After entering all the necessary details, click 'Post' to record the transaction. Tally will automatically update your bank ledger with the new transaction, and you can verify the changes by clicking on 'View Ledger' in the 'Details' section.

Reconciling Your Bank Ledger in Tally

Periodically reconciling your bank ledger with your actual bank statements ensures the accuracy of your accounting records. To reconcile your bank ledger in Tally, follow these steps:

How to Maintain Cash in Cash out Ledger in Excel by learning center in Urdu/hindi
How to Maintain Cash in Cash out Ledger in Excel by learning center in Urdu/hindi
the common legger's accounts guide is shown in this graphic above it
the common legger's accounts guide is shown in this graphic above it
Posting to a Ledger
Posting to a Ledger
  1. Go to 'Books' > 'Sets' > 'Ledgers' > 'View'.
  2. Select your bank ledger and click on 'Reconcile'. This will open the 'Bank Reconciliation' window.
  3. Enter the relevant reconciliation details, such as the date range and the closing balance as per your bank statement.
  4. Click 'Compute' to see the reconciling items, suspense items, and any differences between your Tally bank ledger and your actual bank statement.

The goal of reconciliation is to identify and address any discrepancies between your bank ledger and your bank statement. Once you've resolved all differences, update your bank ledger and repeat the reconciliation process regularly to maintain accurate records.

By following this comprehensive guide to creating and maintaining a bank ledger in Tally, you'll gain better control over your business' finances and ensure the accuracy of your accounting records. Stay proactive in managing your bank ledger, and Tally will empower you to make informed decisions and drive your business forward.