Business

What is a day book and how does it differ from a ledger?

A day book lists every transaction in date order; a ledger sorts the same entries by account. See one day in both forms, and how a cash book differs.

Editorial illustration for What is a day book and how does it differ from a ledger?

A day book is the chronological list of all transactions as they happen, day by day. A ledger takes the same entries and sorts them by account, so all the rent entries sit together and all the bank entries sit together. Same data, two arrangements: one to record, the other to answer questions.

What does a day book look like for one day?

Take a small shop on 12 March (hypothetical figures). Four things happened.

No.ParticularsMoney from or toAmount (₹)
1Cash sale of goodsCash received4,500
2Stationery boughtCash paid600
3Shop rent paidBank transfer18,000
4Customer paid an old invoiceBank received25,000

The day book is just this list, in the order things happened, with enough detail to know what each line was.

How does the ledger rearrange the same entries?

Each entry affects at least two accounts. Posting the four entries gives three ledger pages, and each page shows only what touched that account.

Ledger accountDebit side (₹)Credit side (₹)
Cash4,500 (sale)600 (stationery)
Bank25,000 (customer receipt)18,000 (rent)
Rent18,000-
Stationery600-
Sales-4,500
Customer-25,000

Now the questions are easy. Cash left at the end of the day is 4,500 minus 600, so 3,900 added to the opening cash. Bank moved up by 7,000 (25,000 minus 18,000). The day book is how the entries went in; the ledger is how you read them back.

Is a day book the same as a cash book?

Not quite. A day book usually records all transactions, including credit sales and purchases. A cash book records only cash and bank movements, with a running balance. Some small businesses use the cash book as their main record because most of what they do is cash or UPI; it can be simpler. The moment you sell on credit, you need somewhere to record what is owed, which is where the day book and the customer ledger earn their keep.

What columns should a day book have?

  • Date and a running entry number.
  • Particulars: who and what, in one plain line.
  • The accounts affected, or at least the category.
  • Amount.
  • Reference: bill number, UPI reference or cheque number.
  • A column for money in versus money out, if you want a quick view.

Do I need both?

Software keeps both automatically: you enter a voucher once and it appears in the day book and in each account's ledger. In a paper register, the work of posting from the day book into the ledger is a separate step and the usual place for slips. In a spreadsheet, a single table with date, particulars, account and amount lets you build ledger views by filtering on the account column. If you want the SUMIFS route, =SUMIFS($D$2:$D$500, $C$2:$C$500, "Rent") adds up everything tagged Rent.

How do I post from the day book into the ledger?

  1. Take the first day book line. Decide the two accounts affected.
  2. On the first account's ledger page, write the date, the other account's name, and the amount, on the correct side.
  3. Repeat on the second account's page, on the opposite side.
  4. Tick the day book line so you know it has been posted.
  5. At the end of the week, total each ledger page and check that all debit balances equal all credit balances.

For the 12 March entries above, the rent line goes on the Rent page as a debit and on the Bank page as a credit, both for ₹18,000.

Where to go next

Try this with a week of your own entries. Write them in a day book first, then pick one account, perhaps Bank, and rebuild its page. If the bank page's closing figure matches your bank statement, your day book is sound.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports