Skip to content
Tutorials Center
My learning

Topics

Lesson 31 of 38 ยท Reports and Banking

Day Book, Registers and Outstanding Reports in Tally Prime

Use the Day Book, voucher registers, receivables and payables, bill-wise ageing and reminder letters in Tally Prime to track who owes what and keep entries clean.

Day-to-day accounting needs answers to simple questions: What was entered today? How much did we invoice this month? Which customers are late paying? Tally Prime answers these with transaction reports (Day Book and registers) and outstanding reports (receivables and payables with ageing). This lesson explains both.

Tally runs on the desktop, not on this site, so the screens are described and Python stand-ins show the calculations behind them. Customer names and amounts are invented.

Day Book

Gateway of Tally > Day Book lists every voucher for a date: voucher type, number, particulars and amount. Press Enter on a row to open the voucher; Alt+D (in the voucher) deletes it, and Ctrl+Enter or the alter option edits it. Use F2 to change the date. The button bar lets you filter by voucher type, view only Cancelled or Optional vouchers, or switch the display to show narration, quantities or ledger-wise entries.

Use it at the end of each day to verify what you or your staff entered. If the numbers look odd, the Day Book is the first place to find a mis-typed ledger.

Registers

A register is the Day Book for one voucher type over a period:

  • Sales Register, Purchase Register, Payment Register, Receipt Register, Journal Register, Contra Register, and the credit/debit note registers.
  • Find them under Display More Reports > Account Books (for example Sales Register).
  • They show month totals and let you drill into a month, then a day, then a voucher.

Registers are what you reconcile with GST returns: the sales register total should match GSTR-1's taxable value plus tax; the purchase register should match your ITC claim after adjustments.

Python Stand-in: month totals in a sales register

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Receivables and payables

Sundry debtors (customers) and sundry creditors (suppliers) should be created with Maintain balances bill-by-bill = Yes and a default credit period (for example 30 days). Then every sale or purchase voucher asks for a bill reference:

  • New Ref: a fresh invoice creates a pending bill.
  • Agst Ref: a receipt or payment settles one or more pending bills (full or partial).
  • Advance: money received before an invoice, adjusted later.
  • On Account: a payment not tied to any bill.

Reports (Display More Reports > Statements of Accounts > Outstandings):

  • Receivables and Payables: pending bills by party, with due date and overdue days.
  • Ageing analysis (Alt+F6 in many releases): buckets such as 0-30, 31-60, 61-90 and over 90 days, so collections can prioritize the oldest.
  • Bills Receivable/Payable by party or group.
Python Stand-in: ageing buckets for receivables

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Chasing payments

  • Reminder letters: from the outstanding report press Alt+O (Reminder Letter) in many releases to print a polite letter for selected parties.
  • Credit limits: set on the party ledger; Tally warns (or blocks) when a new invoice would cross it.
  • Interest on overdue balances: enable Activate interest calculation in features; set rate and basis per ledger, and Tally computes interest due.
  • Bill settlement: use Receipt (F6) against reference and tick off invoices instead of leaving money "on account".

More useful books

  • Cash Book and Bank Book: ledger-wise inflow and outflow by day or month.
  • Ledger Account: all vouchers for one ledger with running balance (Gateway of Tally > Display More Reports > Account Books > Ledger).
  • Group Summary and Group Vouchers: ledgers and entries by group (for example all indirect expenses).
  • Statistics: number of vouchers per type, handy for sanity checks.

Common mistakes

  1. Receiving money without selecting Agst Ref, leaving invoices open and money on account, so ageing looks worse than reality.
  2. Backdating entries after reports were shared, which silently changes closed periods.
  3. Using the same bill reference for two invoices, so settlement is ambiguous.
  4. Leaving the credit period blank, so overdue days are never computed.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What does Agst Ref do in a receipt voucher?

    Against reference ties the receipt to an existing pending bill.
  2. 2. Which report shows a list of vouchers of one type over a period?

    Registers list vouchers by type, with month totals and drill-down.
  3. 3. A bill dated 20 March, report date 30 June. In which bucket is it?

    March 20 to June 30 is 102 days, so it falls in 90+.
  4. 4. What must be enabled on a party ledger for bill-wise tracking?

    Bill-by-bill balances produce references and ageing.

Summary

  • The Day Book shows all vouchers for a date; registers show one voucher type over time.
  • Bill-by-bill tracking turns receivables and payables into pending bills with due dates.
  • Use Agst Ref for settlements; avoid leaving money on account.
  • Ageing buckets prioritize collections; reminders and interest support follow-up.
  • Reconcile registers with GST returns and the trial balance.

Next: Bank reconciliation and cheque printing