Using Day Book for Transaction Records in Tally ERP.9

Last updated on:

The day book in Tally ERP.9 serves as your business’s financial diary, capturing every transaction that flows through your company in real-time. Think of it as a comprehensive ledger that automatically updates whenever you enter a voucher, giving you instant access to all financial activities recorded in your accounting system. This powerful feature transforms how businesses track their daily transactions, making financial monitoring both efficient and accurate.

Table of Contents

What is a day book in Tally ERP.9?

A day book is essentially a chronological record of all transactions entered into Tally ERP.9 through various vouchers. Unlike traditional manual accounting where you’d write entries in physical books, Tally’s day book automatically compiles every financial transaction as soon as you create a voucher. Whether you’re recording a sale, purchase, payment, or receipt, each entry appears in the day book with complete details including date, voucher number, account names, and amounts.

The beauty of Tally’s day book lies in its real-time functionality. As soon as you save a voucher, it immediately reflects in the day book, ensuring your records are always current. This eliminates the traditional lag between transaction recording and ledger updates that often plagued manual accounting systems.

How the day book captures transaction data

Every voucher type in Tally ERP.9 contributes to the day book. When you create a sales voucher, purchase voucher, payment voucher, receipt voucher, or any other transaction type, the system automatically extracts key information and displays it in the day book format. This includes:

Transaction date: The date when the transaction occurred or was recorded

Voucher type and number: Identifies the specific voucher and its sequential number

Account details: Shows which accounts were debited and credited

Amount: The monetary value of the transaction

Narration: Any additional description or reference information

This comprehensive capture ensures that no transaction detail is lost, providing a complete audit trail for all business activities.

Accessing and navigating the day book

To access the day book in Tally ERP.9, you typically navigate from the main menu through the Reports section. The system presents transactions in chronological order, with the most recent entries appearing first. The interface is designed to be user-friendly, allowing you to scroll through entries or jump to specific dates quickly.

The day book display shows transactions in a structured format, making it easy to scan through multiple entries. Each line represents a complete transaction, with clear columns showing all relevant information. This organized presentation helps users quickly locate specific transactions or review activity patterns.

Viewing transactions for specific dates

One of the most valuable features of Tally’s day book is the ability to filter transactions by date. This functionality is crucial for businesses that need to review activity for specific periods, whether for daily reconciliation, weekly reviews, or monthly closing procedures.

Changing the date range

Tally ERP.9 allows you to modify the date range displayed in the day book through simple navigation controls. You can:

Select a specific date: View all transactions that occurred on a particular day

Choose a date range: Display transactions between two specific dates

Use predefined periods: Access common periods like current month, previous month, or financial year

This flexibility ensures that you can quickly access the exact information you need without scrolling through unnecessary data.

Real-time date updates

As you change dates in the day book, Tally instantly updates the display to show relevant transactions. This real-time response means you don’t have to wait for the system to process your request – the information appears immediately, making your workflow more efficient.

Benefits of using day book for transaction tracking

The day book offers several advantages over traditional transaction tracking methods. First, it provides immediate visibility into all financial activities, eliminating the need to check multiple ledgers or reports. This centralized view saves time and reduces the risk of overlooking important transactions.

Second, the chronological arrangement helps identify patterns and trends in business activity. You can quickly spot unusual transactions, verify transaction sequences, or analyze daily business volume. This insight is valuable for both operational management and financial analysis.

Third, the day book serves as an excellent tool for daily reconciliation. By reviewing the day’s transactions at the end of each business day, you can ensure that all activities were properly recorded and identify any discrepancies before they become larger problems.

Practical applications in business operations

Different types of businesses can leverage the day book in various ways. Retail businesses might use it to track daily sales and cash flow, while service companies could monitor client billing and payment patterns. Manufacturing businesses often use the day book to track material purchases and production-related expenses.

For small businesses, the day book becomes particularly valuable during tax preparation or financial statement creation. Having a comprehensive, chronological record of all transactions simplifies the process of gathering information for accountants or tax preparers.

Ensuring accuracy and completeness

The day book’s automatic population from vouchers significantly reduces the risk of manual errors common in traditional bookkeeping. However, the accuracy of the day book depends entirely on the quality of voucher entry. This makes it crucial to maintain proper voucher entry procedures and regular review processes.

Regular day book review also helps identify missing transactions or data entry errors. By comparing the day book against bank statements, cash records, and other source documents, businesses can ensure their Tally records are complete and accurate.

Integration with other Tally reports

The day book doesn’t operate in isolation – it integrates seamlessly with other Tally ERP.9 reports and features. Transactions visible in the day book automatically appear in relevant ledger accounts, trial balances, and financial statements. This integration ensures consistency across all reporting functions and eliminates the need for manual data transfer between different accounting components.

Understanding this integration helps users appreciate how the day book fits into the broader accounting ecosystem within Tally ERP.9, making it easier to leverage the software’s full potential for financial management.

What do you think? How could implementing a systematic day book review process improve your business’s financial accuracy and decision-making capabilities?

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

PDF 📄

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Financial Accounting

1 Nature and Scope of Accounting

  1. Need for Accounting
  2. Objectives of Accounting
  3. Definition and Scope of Accounting
  4. Book-Keeping, Accounting and Accountancy
  5. Users of Financial Accounting Information
  6. Accounting as an Information System
  7. Branches of Accounting
  8. Advantages of Accounting
  9. Limitations of Accounting
  10. Bases of Accounting
  11. Qualitative Characteristics of Accounting Information
  12. Functions of Accounting

2 Accounting Process and Rules

  1. Accounting Process
  2. What is an Account?
  3. Classification of Accounts
  4. Principle of Double Entry
  5. Accounting Rules

3 Accounting Principles

  1. Some Basic Terms
  2. Accounting Principles
  3. Systems of Book-Keeping

4 Accounting Standards

  1. Concept of Accounting Standards
  2. Benefits of Accounting Standards
  3. Procedure for Issuing AS in India
  4. Salient Features of First Time Adoption of Indian Accounting Standards (Ind-AS)
  5. Currently Prevailing Accounting Standards in India
  6. International Financial Reporting Standards
  7. Need and Procedure of IFRS
  8. Convergence to IFRS
  9. Distinction between Indian AS and International AS
  10. Measurement of Business Income
  11. Objectives of Measurement of Business Income
  12. Approaches for Measuring Income
  13. Accounting Concept Relevant to Measurement of Business Income – Realization Concept

5 Journal and Ledger

  1. What is Journal?
  2. Form of the Journal
  3. Steps in Journalising
  4. Transactions of Different Types
  5. Compound Journal Entry
  6. Opening Entry
  7. Casting and Carry Forward
  8. What is Ledger?
  9. Form of a Ledger Account
  10. Posting into Ledger

6 Subsidiary Books

  1. Need for Sub-division of Journal
  2. Subsidiary Books
  3. Advantages of Subsidiary Books
  4. Cash Book
  5. Single Column Cash Book
  6. Two Column Cash Book
  7. Petty Cash Book
  8. Imprest System
  9. Recording, Posting and Balancing the Petty Cash Book
  10. What is a Bank?
  11. Types of Bank Accounts
  12. Advantages of Having a Bank Account
  13. How to Open and Operate a Bank Account?
  14. Crossing of Cheques
  15. Endorsement and Dishonour of Cheques
  16. Three Column Cash Book
  17. Recording in Three Column Cash Book
  18. Posting the Three Column Cash Book
  19. Balancing the Three Column Cash Book

7 Trial Balance

  1. What is a Trial Balance?
  2. Preparation of a Trial Balance
  3. Preparation of Trial Balance from a Given List of Balances
  4. Causes for the Disagreement of a Trial Balance
  5. Locating Errors When the Trial Balance Disagrees
  6. Errors Not Disclosed by Trial Balance
  7. Advantages of a Trial Balance
  8. Limitations of a Trial Balance
  9. Rectification of Errors
  10. Suspense Account and Rectification
  11. Effect of Rectifying Entries on Profits

8 Depreciation

  1. What is Depreciation?
  2. Depreciation and other Related Concepts
  3. Causes of Depreciation
  4. Objectives of Providing Depreciation
  5. Factors Influencing Depreciation
  6. Methods of Recording Depreciation
  7. Methods for Providing Depreciation
  8. Fixed Instalment Method
  9. Diminishing Balance Method
  10. Difference between Fixed Instalment Method and Diminishing Balance Method
  11. Change of Method

9 Final Accounts-I

  1. Final Accounts and Trial Balance
  2. Trading and Profit and Loss Account
  3. Trading Account
  4. Profit and Loss Account
  5. Closing Entries
  6. Balance Sheet
  7. Vertical Presentation of Final Accounts
  8. Manufacturing Account

10 Final Accounts-II

  1. Need for Adjustments
  2. Treatment of Adjustments in Final Accounts
  3. Closing Stock
  4. Outstanding Expenses
  5. Prepaid Expenses
  6. Accrued Income
  7. Income Received in Advance
  8. Depreciation
  9. Interest on Capital
  10. Interest on Drawings
  11. Interest on Loan
  12. Bad Debts
  13. Provision for Bad Debts
  14. Provision for Discount on Debtors
  15. Provision for Discount on Creditors
  16. Manager’s Commission
  17. Abnormal Loss of Stock
  18. Drawings of Goods by the Proprietor
  19. Preparation of Final Accounts with Adjustments
  20. Adjustments given in Trial Balance

11 Hire Purchase Accounts-I

  1. Nature of Hire Purchase Agreement
  2. Legal Position
  3. Ascertaining the Interest and Cash Price
  4. Accounting Records in the Books of the Purchaser
  5. Accounting Records in the Books of Vendor

12 Hire Purchase Accounts-II

  1. Default and Repossession
  2. Accounting for Default and Repossession
  3. Instalment Payment System
  4. Accounting for Instalment Payment System
  5. Basic Record for Goods of Small Value Sold on Hire Purchase
  6. Ascertainment of Profit
  7. Treatment of Goods Repossessed
  8. Calculation of Missing Figures

13 Branch Accounts-I

  1. Need for Branch Accounting
  2. Types of Branches
  3. Accounting for Dependent Branches
  4. Debtors System
  5. Cost Price Method
  6. Invoice Price Method
  7. Final Accounts System
  8. Stock and Debtors System

14 Branch Accounts-II

  1. Accounting System of an Independent Branch
  2. Goods in Transit
  3. Cash in Transit
  4. Head Office Expenses Chargeable to Branch
  5. Depreciation on Branch Fixed Assets
  6. Inter-branch Transactions
  7. Incorporation of Branch Trial Balance in the Head Office Books
  8. Closing Entries in Branch Books

15 Consignment Accounts-I

  1. What is Consignment?
  2. Parties to Consignment
  3. Features of Consignment
  4. Distinction between Sale and Consignment
  5. Important Terms in Consignment
  6. Books of the Consignor
  7. Books of the Consignee
  8. Direct Recording in the Ledger
  9. Valuation of Unsold Stock
  10. Accounting Treatment of Unsold Stock
  11. Normal Loss
  12. Abnormal Loss
  13. Where Normal and Abnormal Losses Occur Simultaneously

16 Consignment Accounts-II

  1. Concepts of Invoice Price
  2. Calculation of Cost Price and Invoice Price
  3. What is Loading
  4. Items which Involve Loading
  5. Adjustment of Loading
  6. Accounting for Goods Sent at Invoice Price

17 Joint Venture Accounts

  1. What is a Joint Venture?
  2. Joint Venture and Consignment
  3. Joint Venture and Partnership
  4. Recording in the Books of one Co-venturer
  5. Recording in the Books of all Co-venturers
  6. Memorandum Joint Venture Account Method
  7. Separate Set of Books

18 Introduction to Computerised Accounting and Creation of Company

  1. Introduction to Computerised Accounting
  2. Difference between Manual and Computerised Accounting System
  3. Advantages and Disadvantages of Computerised Accounting System
  4. Consideration while Choosing Accounting Software
  5. Accounting Software in India
  6. Introduction to Tally ERP.9
  7. Creation of a Company
  8. Features and Configurations
  9. Shutting Tally ERP.9

19 Creating Masters

  1. Introduction
  2. Ledgers and Groups
  3. Single Ledger Creation
  4. Multiple Ledger Creation
  5. Altering and Displaying Ledger
  6. Deleting Ledger
  7. Group Creation
  8. Inventory Masters Creation
  9. Creating Stock Group
  10. Creating Stock Category
  11. Creating Unit of Measure
  12. Creating Godowns
  13. Creating Stock Items
  14. Altering, Displaying and Deleting Inventory Masters

20 Voucher Entries and Invoicing

  1. Introduction to Vouchers
  2. Contra Voucher (F4)
  3. Payment Voucher (F5)
  4. Receipt Voucher (F6)
  5. Journal Voucher (F7)
  6. Sales Voucher / Invoice
  7. Credit Note Voucher (Ctrl + F8)
  8. Purchase Voucher / Invoice (F9)
  9. Debit Note Voucher (Ctrl + F9)
  10. Reversing Journal Voucher (F10)
  11. Memo Voucher (Ctrl + F10)
  12. Post-Dated Voucher
  13. Altering, Deleting and Displaying Voucher Entry
  14. Creating Voucher Type
  15. Creating Account Invoice
  16. Creating Item Invoice

21 Preparation of Reports

  1. Introduction
  2. Balance Sheet
  3. Profit and Loss Account
  4. Trial Balance
  5. Ratio Analysis
  6. Day Book
  7. Purchase and Sales Register
  8. Cash/Bank Books
  9. Statements of Accounts
  10. Statistics
  11. Restore and Backup of Data