Home Tutorials Videos Q&A MCQ Shortcuts Exercises Appointment Login
Tutorial Exercises MCQ Test Interview Q&A
Lesson 48 of 48 – Ledger Report in Tally Prime
100%

📒 Ledger Report in Tally Prime

The Ledger Report displays all transactions recorded against a specific ledger account during a selected period. It is widely used for account verification, customer and supplier reconciliation, expense tracking and financial analysis.

Lesson Objective Learn how to view Ledger Reports, understand transaction details, analyze balances, verify entries and use ledger reports for daily accounting and auditing.
1. What is a Ledger Report?

A Ledger Report shows every transaction posted to a particular ledger along with opening balance, voucher details and closing balance.

Feature Description
Opening Balance Balance at the beginning of the selected period.
Voucher Details Shows all transactions affecting the ledger.
Debit/Credit Entries Displays money received or paid.
Closing Balance Balance at the end of the selected period.
Date-wise Report Transactions arranged chronologically.
2. Importance of Ledger Reports
  • Verify ledger transactions.
  • Track customer and supplier balances.
  • Analyze expenses and income.
  • Detect accounting mistakes.
  • Support bank reconciliation.
  • Prepare financial statements.
  • Assist auditors.
  • Improve accounting accuracy.
Ledger Reports provide complete transaction history for every account maintained in Tally Prime.
3. Information Available in Ledger Report
Information Description
Date Transaction date.
Voucher Number Reference number.
Voucher Type Sales, Purchase, Payment, Receipt, etc.
Particulars Related ledger or party.
Debit Amount Money debited.
Credit Amount Money credited.
Running Balance Updated balance after each transaction.
The Ledger Report helps users understand every movement affecting a specific account.
4. How to Open a Ledger Report
Steps
  1. Open Tally Prime.
  2. Go to Display More Reports.
  3. Select Account Books.
  4. Choose Ledger.
  5. Select the required ledger.
  6. Choose the required period.
You can open any ledger report for any accounting period.
5. Common Ledger Reports
Ledger Purpose
Cash Ledger Cash transactions.
Bank Ledger Bank receipts and payments.
Sales Ledger Sales transactions.
Purchase Ledger Purchase transactions.
Sundry Debtors Customer balances.
Sundry Creditors Supplier balances.
Expense Ledger Business expenses.
Every ledger created in Tally Prime has its own Ledger Report.
6. Ledger Report Filters & Search Options

Tally Prime provides powerful filtering options that help accountants quickly locate transactions within a ledger report.

Available Filters
Filter Purpose
Date Range View transactions for a selected period.
Voucher Type Display only Sales, Purchase, Receipt, Payment, etc.
Amount Find transactions of a specific value.
Narration Search using voucher narration.
Voucher Number Locate a specific voucher.
Ledger Name Review related account entries.
Benefits
  • Locate transactions quickly.
  • Review customer and supplier accounts.
  • Simplify auditing.
  • Reduce time spent searching records.
Use filters regularly while verifying large ledger reports.
7. Viewing, Altering & Printing Ledger Reports

Ledger Reports allow authorized users to open, modify and print voucher details whenever required.

View a Voucher
  1. Open the Ledger Report.
  2. Select the required transaction.
  3. Press Enter.
Alter a Voucher
  1. Open the voucher.
  2. Edit the required information.
  3. Press Ctrl + A to Save.
Print Ledger Report
  1. Open the Ledger Report.
  2. Select the required period.
  3. Press Alt + P.
  4. Choose Print.
Action Shortcut
Open Voucher Enter
Save Changes Ctrl + A
Print Report Alt + P
Delete Voucher Alt + D
Always verify voucher details before saving changes because modifications immediately affect financial reports.
8. Ledger Reconciliation & Balance Verification

Ledger Reports are commonly used to reconcile customer, supplier, bank and expense accounts with supporting documents.

Verification Purpose
Opening Balance Verify beginning balance.
Debit Entries Confirm all debit transactions.
Credit Entries Confirm all credit transactions.
Running Balance Verify balance after each voucher.
Closing Balance Match with supporting records.
Example
Description Amount
Opening Balance ₹45,000
Total Debit ₹20,000
Total Credit ₹10,000
Closing Balance ₹55,000
Regular reconciliation helps detect missing entries and accounting mistakes at an early stage.
9. Ledger Analysis & Verification

Ledger Reports provide complete transaction analysis and help accountants verify financial accuracy.

Verification Item Purpose
Voucher Date Verify transaction period.
Voucher Number Check document reference.
Ledger Name Confirm correct account.
Debit Amount Verify debit entries.
Credit Amount Verify credit entries.
Closing Balance Confirm final balance.
Verification Checklist
  • Verify opening balance.
  • Review every voucher.
  • Check duplicate entries.
  • Verify debit and credit values.
  • Review narrations.
  • Confirm closing balance.
Ledger verification should be performed before preparing financial statements.
10. Common Ledger Report Mistakes
Common Mistake Correct Practice
Wrong Ledger Selected Verify ledger before viewing the report.
Incorrect Date Range Select the correct accounting period.
Ignoring Opening Balance Verify opening balance first.
Duplicate Voucher Entries Review transactions carefully.
Incorrect Voucher Modification Verify entries before saving changes.
Missing Narration Enter proper narration for every voucher.
Ignoring Closing Balance Match closing balance with financial reports.
No Backup Before Changes Take regular backups before major modifications.
Regular review of Ledger Reports improves accounting accuracy and helps maintain reliable financial records.
11. Real Business Case Studies

Let's understand how Ledger Reports are used in different types of businesses for financial monitoring and decision-making.

Business Ledger Used Purpose
Retail Store Sales Ledger & Customer Ledger Track daily sales and customer balances.
School / College Student Fee Ledger Monitor fee collection and outstanding dues.
Hospital Patient Ledger Review patient billing and payment history.
Manufacturing Company Supplier & Expense Ledgers Monitor purchases, expenses and supplier balances.
IT Company Client Ledger Track invoices, receipts and pending payments.
NGO / Trust Donation Ledger Maintain transparent records of donations and expenses.
Ledger Reports help businesses monitor account-wise transactions and improve financial decision-making.
12. Complete Ledger Verification Checklist
Checklist Status
Correct Ledger Selected ✔
Period Verified ✔
Opening Balance Checked ✔
All Debit Entries Verified ✔
All Credit Entries Verified ✔
Voucher Numbers Reviewed ✔
Narrations Verified ✔
Duplicate Entries Checked ✔
Closing Balance Confirmed ✔
Ledger Printed/Exported ✔
Supporting Documents Matched ✔
Company Backup Taken ✔
Following this checklist helps maintain accurate ledger records and simplifies auditing.
13. Professional Ledger Management Best Practices
  • Review important ledger accounts regularly.
  • Reconcile customer and supplier ledgers every month.
  • Verify opening balances before entering transactions.
  • Use meaningful voucher narrations.
  • Avoid duplicate ledger entries.
  • Restrict voucher alteration and deletion to authorized users.
  • Review outstanding balances frequently.
  • Export Ledger Reports for audit and analysis.
  • Maintain supporting bills and invoices.
  • Take regular backups of company data.
Well-maintained Ledger Reports improve financial accuracy, support audits and assist in better business planning.
14. Practical Exercise & Interview Questions
Practical Exercise
  1. Create a Customer Ledger.
  2. Create a Supplier Ledger.
  3. Record one Sales Voucher.
  4. Record one Purchase Voucher.
  5. Open the Customer Ledger Report.
  6. Verify the running balance.
  7. Print or Export the Ledger Report.
  8. Reconcile the ledger with supporting documents.
Interview Questions
  1. What is a Ledger Report in Tally Prime?
  2. Why is a Ledger Report important?
  3. How do you open a Ledger Report?
  4. What information does a Ledger Report contain?
  5. What is the purpose of the opening balance?
  6. What is the purpose of the closing balance?
  7. How do you filter a Ledger Report?
  8. How do you alter a voucher from a Ledger Report?
  9. How do you print a Ledger Report?
  10. Can a Ledger Report be exported?
  11. Why are voucher narrations important?
  12. How does a Ledger Report help in auditing?
  13. How do you identify duplicate entries?
  14. Why is reconciliation necessary?
  15. How do you verify customer balances?
  16. How do you verify supplier balances?
  17. What precautions should be taken before deleting a voucher?
  18. Why should Ledger Reports be reviewed regularly?
  19. How does Tally Prime simplify ledger management?
  20. Why are Ledger Reports essential for accountants?
15. Lesson Summary
  • Learned the purpose of Ledger Reports.
  • Reviewed ledger transactions and balances.
  • Applied filters and search options.
  • Viewed, altered and printed Ledger Reports.
  • Verified ledger balances and transactions.
  • Studied practical business examples.
  • Completed practical exercises.
  • Prepared for accounting interviews.
  • Learned professional ledger management techniques.
  • Built a strong understanding of account-wise reporting.
Congratulations! You can now confidently use Ledger Reports in Tally Prime to review account transactions, reconcile balances, verify accounting records and generate accurate financial reports.

🧠 Quick Quiz

What does a Ledger Report primarily display in Tally Prime?



← Previous Next →