Using Day Book for Transaction Records in Tally ERP.9

Every business, big or small, generates transactions all day long – a cash sale in the morning, a payment to a supplier by afternoon, and maybe a bank deposit before closing. Recording each of these as they happen, in the order they occur, is where the day book comes in. In manual bookkeeping, this concept goes back centuries. In Tally ERP.9, it becomes a single, searchable screen that shows you everything your business did on any given day. Let’s understand how this works and why it’s one of the most useful reports you’ll use in real accounting practice.

What exactly is a day book? 🔗

A day book, in classical accounting terms, is a book of original entry – a place where transactions are first recorded by date, as they occur, before that information is later transferred to the ledger accounts. This is the core definition accountants have used long before computerised accounting existed. Nothing is summarised or classified at this stage; it is simply a chronological log.

The purpose of maintaining this first record is straightforward. Every transaction needs to be documented with evidence before it is posted to the appropriate ledger account, and without this step, ledger-writing itself cannot begin. This is why the day book, or journal, is often called the foundation of the accounting cycle.

Where the day book fits among books of original entry 🔗

In traditional manual bookkeeping, businesses don’t maintain just one day book. They typically maintain several specialised ones, each dedicated to a category of transaction. These usually include a sales journal for credit sales, a purchases journal for credit purchases, a cash book for cash and bank transactions, and a general journal for entries that don’t fit anywhere else, such as adjustments, accruals, and corrections. Each of these feeds into the general ledger once the entries are complete.

This is where computerised accounting software changes the picture. Instead of maintaining five or six separate books and manually posting each one to the ledger, Tally ERP.9 consolidates all of it into a single, unified day book that pulls data directly from the vouchers you enter.

The day book in Tally ERP.9: one screen, every transaction 🔗

In Tally ERP.9, the day book is not a separate register you fill in by hand. It is a report that is generated automatically from the vouchers you record – sales, purchases, payments, receipts, contra entries, journal entries, and more. By default, it displays the transactions for the current date, meaning the date of the last voucher entered, though you can change this to any period you need. This means the moment you post a voucher, it reflects in the day book – there’s no separate step of “writing it into the day book” the way there would be with a physical register.

How to open the day book 🔗

The day book is accessed through Gateway of Tally > Display > Daybook. Once opened, the screen lists every transaction recorded for that date, along with the voucher type, party name, and amount. Since the report pulls straight from your voucher entries, there’s no risk of a transaction being missed simply because someone forgot to note it down separately.

Changing the date or period 🔗

A day book that only shows today’s date wouldn’t be very useful for review or audit purposes. This is why Tally lets you move across dates freely. Using the F2: Period option on the button bar, you can specify any date range you need – a single day, a full month, or an entire financial quarter – and the day book will pull up every transaction from vouchers recorded within that window. This is particularly useful when reconciling accounts at month-end or preparing for a GST filing, where you need to check every entry made within a specific period.

Filtering by voucher type 🔗

Sometimes you don’t want to see every transaction – you only want to review, say, sales vouchers, or only payment vouchers, for a particular day. The F4: Change Vouch option lets you select a specific voucher type, after which the day book filters to display only that category of entries. This is a small feature, but it saves a lot of scrolling when a business is processing dozens of transactions daily and someone just needs to confirm, for instance, that all of yesterday’s cash payments were entered correctly.

Sales day book: a specialised view 🔗

Alongside the general day book, Tally also maintains category-specific registers that behave like specialised day books. The Sales Register is one example. It functions as a comprehensive day book dedicated to sales information, letting you drill down month by month into every sales voucher recorded. This mirrors how a manual accountant would maintain a separate sales day book, except here it updates automatically as invoices are entered and can be exported or reconfigured with a few clicks.

Why this matters for a business 🔗

The value of the day book isn’t just historical record-keeping. It plays an active role in day-to-day financial control.

• Up-to-date visibility: Since the report is generated live from vouchers, a business owner or accountant can check the day book at any point and know exactly what has been recorded so far, without waiting for month-end reports.
• Error detection: Because every transaction appears in chronological order, unusual entries, missing narrations, or duplicated vouchers tend to stand out quickly, long before they get buried inside a full ledger.
• Audit trail: Auditors and tax consultants frequently start their review from the day book precisely because it shows transactions exactly as they were entered, in sequence, with voucher references intact.
• Cross-verification: Since cash, bank, sales, and purchase entries all appear together, it’s easy to cross-check whether a day’s cash sales tally with the amount deposited in the bank, for instance.

Manual day books versus the Tally day book 🔗

A quick example 🔗

Suppose a small trading firm records the following on a single day: a cash sale of goods worth ₹15,000, a payment of ₹8,000 to a supplier by cheque, and a receipt of ₹5,000 from a customer clearing an old bill. Each of these gets entered as a separate voucher – a sales voucher, a payment voucher, and a receipt voucher respectively. The moment these three vouchers are saved, all three appear together in the day book for that date, in the order they were entered, along with the party names and amounts. If the accountant wants to check only the payment made to the supplier, switching the voucher type filter to “Payment” through F4 will narrow the list down to that single entry. There’s no need to search through separate cash books or purchase registers to piece the day together.

A step further: linking the day book to reporting 🔗

For students studying financial accounting, it’s worth remembering that the day book is not an end in itself – it’s the starting point of the reporting chain. Once transactions are captured here, they flow into ledger accounts, then into the trial balance, and eventually into the final financial statements such as the trading account, profit and loss account, and balance sheet. Understanding how the day book operates in software like Tally makes it easier to appreciate why accuracy at the point of entry matters so much: a mistake made while recording a voucher doesn’t stay isolated. It travels all the way through to the final reports unless it’s caught early, and the day book is often exactly where that catch happens.

What do you think? If you were auditing a business’s accounts for a month, would you rely on the day book as your first checkpoint, or start directly from the ledger? And how do you think the shift from multiple manual day books to one consolidated digital report has changed the accountant’s daily workflow?

References

1. https://www.accountingtools.com/articles/daybook
2. https://tallysolutions.com/accounting/books-of-original-entry/
3. https://www.superfastcpa.com/what-are-books-of-original-entry/
4. https://help.tallysolutions.com/article/Tally.ERP9/Reports/Display_Registers_Ledgers/Display_Day_Book.htm
5. https://help.tallysolutions.com/article/Tally.ERP9/Reports/Display_Registers_Ledgers/Sales_Register_Sales_Day_Book.htm