Home Tutorials Videos Q&A MCQ Shortcuts Exercises Appointment Login
Tutorial Exercises MCQ Test Interview Q&A
Lesson 39 of 48 – Banking in Tally Prime
78%

🏦 Banking in Tally Prime

The Banking feature in Tally Prime helps businesses manage bank accounts, record bank payments and receipts, print cheques, perform bank reconciliation, generate deposit slips, and monitor banking transactions efficiently.

Lesson Objective Learn how to use banking features in Tally Prime, including cheque management, bank reconciliation, deposit slips, payment advice and banking reports.
1. What is Banking in Tally Prime?

Banking in Tally Prime provides tools to record and manage transactions involving bank accounts. It helps maintain accurate bank balances and simplifies reconciliation with bank statements.

Feature Purpose
Bank Ledger Maintain bank account transactions.
Cheque Printing Print cheques directly from Tally.
Bank Reconciliation Match books with bank statement.
Deposit Slip Prepare bank deposit slips.
Payment Advice Generate payment advice documents.
2. Why is Banking Important?
  • Maintains accurate bank balances.
  • Tracks all bank receipts and payments.
  • Supports cheque printing.
  • Helps reconcile bank statements.
  • Reduces accounting errors.
  • Improves cash flow monitoring.
  • Supports audit requirements.
  • Saves time through automation.
Using banking features helps maintain accurate financial records and simplifies day-to-day banking activities.
3. Banking Features Available
Feature Description
Bank Ledger Maintain bank accounts.
Cheque Printing Print payment cheques.
Cheque Register Track issued cheques.
Bank Reconciliation Match transactions with bank statement.
Deposit Slip Prepare cash and cheque deposit slips.
Payment Advice Generate supplier payment advice.
Bank Reports Review banking transactions.
These banking features improve control over business bank accounts and financial transactions.
4. Banking Workflow
  1. Create Bank Ledger.
  2. Record Receipts and Payments.
  3. Print Cheques (if required).
  4. Deposit Cash or Cheques.
  5. Perform Bank Reconciliation.
  6. Review Banking Reports.
  7. Resolve unmatched transactions.
  8. Maintain updated bank balances.
Following a proper banking workflow ensures accurate bank records and easier reconciliation.
5. Banking Reports Overview
Report Purpose
Bank Book View all bank transactions.
Cheque Register Track cheque status.
Bank Reconciliation Match book balance with bank balance.
Deposit Slip Print bank deposit details.
Payment Advice View supplier payment details.
Banking reports help monitor bank activity and verify financial transactions.
6. Creating a Bank Ledger

Before recording banking transactions, create a Bank Ledger in Tally Prime. The Bank Ledger stores all receipts, payments and bank balances.

Steps
  1. Go to Gateway of Tally → Create → Ledger.
  2. Enter the Bank Name.
  3. Select Under : Bank Accounts.
  4. Enter the Opening Balance (if applicable).
  5. Enter Bank Account Details if required.
  6. Press Ctrl + A to Save.
Example
Field Value
Ledger Name State Bank of India
Group Bank Accounts
Opening Balance ₹2,50,000
Each business bank account should have a separate Bank Ledger.
7. Recording Bank Payments & Receipts

Bank transactions are recorded using Payment and Receipt Vouchers.

Bank Payment
  • Use Payment Voucher (F5).
  • Select the Bank Ledger.
  • Select the Expense or Party Ledger.
  • Enter the Amount and Narration.
  • Save the voucher.
Bank Receipt
  • Use Receipt Voucher (F6).
  • Select the Bank Ledger.
  • Select the Customer or Income Ledger.
  • Enter the Amount.
  • Save the voucher.
Voucher Purpose
Payment Money paid through bank.
Receipt Money received into bank.
Always select the correct Bank Ledger to keep bank balances accurate.
8. Cheque Printing & Deposit Slip

Tally Prime supports cheque printing and deposit slip generation for bank transactions.

Cheque Printing
  1. Record a Bank Payment Voucher.
  2. Select the Bank Ledger.
  3. Enter Cheque Number (if applicable).
  4. Choose Print → Cheque.
  5. Select the cheque format.
  6. Print the cheque.
Deposit Slip
Deposit Type Purpose
Cash Deposit Deposit cash into the bank.
Cheque Deposit Deposit customer cheques.
Cheque printing reduces manual writing errors and produces professional-looking cheques.
9. Bank Reconciliation (BRS)

Bank Reconciliation compares transactions recorded in Tally Prime with the bank statement to identify differences.

Steps
  1. Open Display More Reports.
  2. Select Banking.
  3. Choose Bank Reconciliation.
  4. Select the Bank Ledger.
  5. Enter the dates appearing in the bank statement.
  6. Match each transaction.
  7. Save the reconciliation.
Possible Difference Reason
Outstanding Cheque Cheque issued but not yet cleared.
Deposit in Transit Deposit recorded but not yet credited by the bank.
Bank Charges Charges not yet recorded in books.
Interest Credit Interest credited by the bank but not yet recorded.
Regular Bank Reconciliation helps maintain accurate financial records and detect errors quickly.
10. Common Banking Mistakes
Common Mistake Correct Practice
Selecting the wrong Bank Ledger. Verify the bank account before saving.
Incorrect Amount. Match the bank document carefully.
Skipping Bank Reconciliation. Reconcile bank accounts regularly.
Wrong Cheque Number. Verify cheque details before printing.
Ignoring Bank Charges. Record all bank charges promptly.
Not recording Interest. Record interest credited or debited by the bank.
Duplicate Entries. Check vouchers before saving.
Not reviewing Bank Reports. Review Bank Book and BRS regularly.
Proper banking practices help ensure accurate bank balances and reliable financial statements.
11. Real Business Case Studies

Let's understand how different businesses use the Banking features in Tally Prime.

Business Banking Activity Purpose
Retail Shop Daily Cash Deposit Deposit daily sales into the bank.
Manufacturing Company Supplier Payments Pay suppliers through bank transfers or cheques.
School / College Fee Collection Receive student fees directly into the bank.
Hospital Patient Receipts Record online and cheque payments.
Software Company Salary & Vendor Payments Pay employees and vendors through banking channels.
Wholesale Distributor Customer Collections Receive NEFT, RTGS, IMPS and cheque payments.
Efficient banking management helps maintain accurate financial records, improves cash flow and simplifies auditing.
12. Banking Reports & Bank Reconciliation Checklist
Checklist Status
Bank Ledger Created ✔
Receipt Vouchers Verified ✔
Payment Vouchers Verified ✔
Cheque Numbers Verified ✔
Cheque Printing Completed ✔
Deposit Slips Generated ✔
Bank Charges Recorded ✔
Interest Entries Recorded ✔
Bank Reconciliation Completed ✔
Outstanding Transactions Reviewed ✔
Bank Book Verified ✔
Closing Bank Balance Matched ✔
Complete this checklist regularly to maintain accurate bank records and simplify month-end closing.
13. Professional Banking & Cash Management Tips
  • Create a separate Bank Ledger for each bank account.
  • Record all bank transactions on the same day whenever possible.
  • Perform Bank Reconciliation every week or month.
  • Verify cheque numbers before printing.
  • Record bank charges and interest immediately.
  • Review the Bank Book regularly.
  • Keep supporting documents such as deposit slips and bank statements safely.
  • Monitor outstanding cheques and deposits in transit.
  • Use narrations for every banking transaction.
  • Back up Tally Prime data regularly.
Professional accountants reconcile bank accounts at the end of every month to ensure that the book balance matches the bank statement.
14. Practical Exercise & Interview Questions
Practical Exercise
  1. Create a Bank Ledger named State Bank of India.
  2. Record one Bank Receipt Voucher.
  3. Record one Bank Payment Voucher.
  4. Enter a cheque number in a Payment Voucher.
  5. Print a sample cheque.
  6. Generate a Deposit Slip.
  7. Open the Bank Reconciliation Report.
  8. Reconcile at least two bank transactions.
Interview Questions
  1. What is Banking in Tally Prime?
  2. Why is a Bank Ledger created?
  3. Which group is used for a Bank Ledger?
  4. How do you record a bank payment?
  5. How do you record a bank receipt?
  6. What is Cheque Printing?
  7. What is a Deposit Slip?
  8. What is Bank Reconciliation?
  9. Why is Bank Reconciliation important?
  10. What is an Outstanding Cheque?
  11. What is a Deposit in Transit?
  12. How are bank charges recorded?
  13. How is bank interest recorded?
  14. Which report shows all bank transactions?
  15. What is the purpose of the Bank Book?
  16. What precautions should be taken while recording bank transactions?
  17. How often should Bank Reconciliation be performed?
  18. What reports should be reviewed before month-end closing?
  19. How does Tally Prime simplify banking?
  20. Why is banking knowledge important for accountants?
15. Lesson Summary
  • Learned the Banking features in Tally Prime.
  • Created Bank Ledgers.
  • Recorded Bank Receipt and Payment Vouchers.
  • Learned Cheque Printing.
  • Generated Deposit Slips.
  • Performed Bank Reconciliation.
  • Reviewed Banking Reports.
  • Studied real business examples.
  • Completed practical exercises.
  • Prepared for banking and accounting interviews.
Congratulations! You can now confidently use the Banking features in Tally Prime to manage bank accounts, record receipts and payments, print cheques, perform bank reconciliation and maintain accurate banking records.

🧠 Quick Quiz

Which feature in Tally Prime is used to match book transactions with the bank statement?



← Previous Next →