Day Book in Tally: Record, View and Reconcile Daily Transactions

Day Book in TallyPrime is a chronological daily transaction register that records all cash, bank, and credit entries. It enables real-time verification of transaction accuracy, reconciliation with bank statements, and ensures financial data integrity before report generation.

What Is a Day Book in Tally and Why It Matters

A Day Book in TallyPrime is a fundamental accounting tool that maintains a complete, date-wise record of every financial transaction entered into your system. Unlike traditional ledgers that organize data by account head, the Day Book arranges all transactions chronologically, showing exactly what was recorded on each day. This sequential view is essential for daily reconciliation, fraud detection, and ensuring no transaction is missed or duplicated.

For businesses operating in Purnea, Bihar, or anywhere across India, the Day Book serves as a bridge between raw transaction data and final financial statements. It provides transparency, supports GST compliance (particularly for GSTR-1 and GSTR-2B reconciliation), and creates an audit trail that regulators and auditors expect to see. Whether you run a small retail shop or a mid-sized trading company, the Day Book is your first line of defense against accounting errors.

Accessing Day Book in TallyPrime: Step-by-Step Navigation

Opening the Day Book report in TallyPrime is straightforward. From the main company screen, press Alt+G to open the Gateway of Tally. Navigate to Display More Reports, then select Accounts Books, and click on Day Book. TallyPrime will prompt you to select the voucher type (such as Sales, Purchase, Receipt, Payment, or Journal) and specify your date range. Once configured, press Enter to generate the report.

For faster access, you can also use the keyboard shortcut directly from the main screen. If you frequently use the Day Book, consider bookmarking it in your favorites within TallyPrime for one-click access. The system remembers your last-used filters, so subsequent views load with your preferred settings intact.

Day Book vs. Cash Book: Understanding the Difference

While both Day Book and Cash Book in Tally display transactions, they serve different purposes. The Day Book shows all transactions entered on a specific date across all ledgers (cash, bank, credit sales, credit purchases, and journal entries). The Cash Book, by contrast, focuses exclusively on cash inflows and outflows, making it ideal for reconciling your physical cash drawer or safe at day-end.

Use the Day Book when you need a complete snapshot of daily activity across your entire business. Use the Cash Book when you need to verify that your recorded cash matches your physical cash on hand. Together, these two reports form a comprehensive daily reconciliation framework.

Recording Transactions That Appear in Day Book

Every transaction you enter in TallyPrime, regardless of type, appears in the Day Book on the date it was recorded. This includes sales invoices, purchase orders, cash receipts, bank payments, inter-company transfers, and adjustment journal entries. The Day Book captures the complete debit-credit pair for each entry, ensuring the accounting equation (Assets = Liabilities + Equity) remains balanced.

When you create a voucher in TallyPrime (by pressing Alt+C for Cash Receipt, Alt+P for Payment, or Alt+J for Journal), the system immediately records it with a timestamp and sequence number. This data flows into the Day Book, which displays it in the exact order it was entered. This chronological integrity is critical for audit trails and regulatory compliance, especially under GST and Income Tax rules.

Filtering and Customizing Day Book Display

TallyPrime allows you to customize the Day Book view to focus on specific transaction types or parties. Once the Day Book is displayed, press F12 to access the configuration menu. Here you can filter by voucher type (Receipt, Payment, Journal, Sales, Purchase), party name, amount range, or reference number. You can also toggle the display of optional columns such as cost center, cost category, or project allocation.

These customization options are saved as display sets, meaning you can create multiple Day Book views for different purposes. For example, you might create one view showing only bank transactions and another showing only cash transactions. This flexibility accelerates daily reconciliation and reduces the time spent scrolling through irrelevant entries.

Day Book for Daily Reconciliation and Error Detection

The primary strength of the Day Book lies in its role as a reconciliation tool. At the end of each business day, print or export the Day Book and compare it against your bank statement, cash register tape, or supplier invoices. Any discrepancy between the Day Book and physical records indicates either a data entry error, a missing transaction, or a duplicate entry that needs correction.

For example, if your bank statement shows a deposit of Rs 50,000 on 15th January, but the Day Book shows only Rs 45,000 in bank receipts for that date, you have identified a Rs 5,000 gap. This prompts you to investigate whether the remaining Rs 5,000 was deposited on a different date, entered under a different ledger, or not yet recorded. Early detection prevents these discrepancies from cascading into incorrect Balance Sheet in Tally and Profit and Loss in Tally reports.

Day Book and GST Compliance in TallyPrime

Under GST rules, every business transaction must be recorded with the correct tax treatment. The Day Book in TallyPrime displays all transactions with their associated GST amounts (CGST, SGST, UTGST, or IGST as applicable). When you generate GSTR-1 (outward supply) and GSTR-2B (inward supply) reports, TallyPrime pulls data from the same transaction records visible in your Day Book.

To enable GST in TallyPrime, press F11 (Company Settings), navigate to Statutory and Taxation, and enable GST. Once activated, every sales and purchase entry will capture the applicable tax rate and amount. The Day Book then serves as your first-level verification that GST has been correctly applied before you file your monthly GSTR-3B return (due by the 20th of the following month for regular taxpayers).

Worked Example: Day Book Reconciliation

Let us walk through a practical scenario. Suppose you operate a small retail electronics store in Purnea. On 10th February 2026, you expect the following transactions:

Transaction	Type	Amount (Rs)	GST (18%)	Total (Rs)
Cash sale to walk-in customer	Sales	5,000	900	5,900
Bank deposit from previous day sales	Receipt	8,000	0	8,000
Purchase of stock from supplier (credit)	Purchase	15,000	2,700	17,700
Payment to supplier (cheque)	Payment	10,000	0	10,000

You enter all four transactions in TallyPrime on 10th February. When you access the Day Book for that date, it displays all four entries in the order you recorded them, showing the debit and credit accounts, amounts, and GST breakup. At day-end, you compare this Day Book against your cash register (should show Rs 5,900 in cash sales), your bank deposit receipt (Rs 8,000), your supplier invoice (Rs 17,700 purchase), and your cheque stub (Rs 10,000 payment). If all match, your Day Book is reconciled and accurate. If a mismatch appears, you investigate immediately rather than waiting until month-end when corrections are harder to trace.

Exporting and Printing Day Book Reports

TallyPrime allows you to export the Day Book in multiple formats: PDF, Excel, or printed hardcopy. To export, display the Day Book, press Ctrl+E to open the export dialog, select your desired format, and specify the file location. Exporting to Excel is particularly useful if you need to perform additional analysis, create pivot tables, or share the data with your accountant or auditor.

Many businesses maintain a daily printed Day Book as part of their statutory record-keeping. This hardcopy serves as evidence during GST audits, income tax assessments, or bank reconciliations. Ensure your printer is configured correctly and that you store these printouts in a secure, organized manner.

Day Book and the Trial Balance Connection

The Day Book feeds directly into the Trial Balance in Tally. Every debit and credit entry in the Day Book updates the corresponding ledger account. At month-end, when you generate the Trial Balance, it aggregates all Day Book entries by account head and verifies that total debits equal total credits. If your Trial Balance does not balance, the error almost always originates in the Day Book. By maintaining an accurate, reconciled Day Book throughout the month, you ensure your Trial Balance balances on the first attempt.

Data Repair and Day Book Integrity

In rare cases, TallyPrime data can become corrupted due to unexpected shutdowns, power failures, or software conflicts. If you notice inconsistencies in your Day Book (such as missing transactions or duplicate entries), use the data repair function. Press Alt+Y (Data) and select Repair, or access F1 (Help) > Troubleshooting > Repair. Always back up your company data before running repairs. TallyPrime will scan and correct errors, restoring Day Book integrity.

Day Book in Tally on Cloud

If you use Tally on Cloud, the Day Book functionality remains identical to desktop TallyPrime. You access it via secure RDP from Windows, Mac, Linux, Android, or iOS devices, with the same Alt+G navigation and F12 customization options. Cloud-hosted Tally offers the added benefit of daily automated backups and 99.9% uptime, ensuring your Day Book data is always safe and accessible. Pricing for Tally on Cloud ranges from Rs 175-290 per user per month (bring-your-own-licence) or Rs 899-1,299 per month (with licence included), making it ideal for distributed teams or remote work scenarios.

Best Practices for Day Book Management

Reconcile your Day Book every single day, not just at month-end. This habit catches errors when they are fresh and easy to correct. Ensure all users in your organization understand the importance of accurate, timely data entry. Use consistent naming conventions for parties and ledgers so the Day Book remains readable and searchable. Enable TSS (Tally Support Services) on your TallyPrime installation to receive automatic updates and connected services such as e-invoicing and GST filing. For Silver edition, TSS renewal costs approximately Rs 4,500 per year; for Gold edition, approximately Rs 13,500 per year (plus 18% GST). Early renewal adds roughly one free month, and two-year renewals offer around 10% discount.

Integrating Day Book with Other Reports

The Day Book is one piece of a larger reporting ecosystem in TallyPrime. Cross-reference it with the Outstanding Receivables in Tally report to verify that credit sales are being tracked correctly. Compare it with the Outstanding Payables in Tally report to ensure supplier invoices and payments are matched. Use the Day Book alongside TallyPrime Reports such as the Balance Sheet in Tally and Profit and Loss in Tally to ensure all transaction-level details roll up correctly into final financial statements. This integrated approach minimizes discrepancies and strengthens overall financial control.

Choosing the Right TallyPrime Edition for Your Day Book Needs

TallyPrime is available in two main editions: Silver (single user, perpetual licence, approximately Rs 22,500 plus 18% GST) and Gold (unlimited users on LAN, perpetual licence, approximately Rs 67,500 plus 18% GST). Both editions include full Day Book functionality and one year of TSS free. If you operate alone or with one other person, Silver is cost-effective. If you have multiple staff needing simultaneous access to Day Book reports and data entry, Gold is the better choice. You can upgrade from Silver to Gold for approximately Rs 45,000 plus GST. For current pricing details and your specific business scenario, consult the TallyPrime Price page or speak with a certified partner.

Day Book in TallyPrime is your daily window into transaction accuracy and financial health. By reconciling it consistently, filtering it intelligently, and integrating it with other reports, you build a robust accounting system that supports compliance, audit readiness, and informed decision-making. If you need hands-on guidance setting up Day Book workflows, configuring GST reporting, or optimizing your TallyPrime installation, Global IT Care, a Tally 3 Star Certified Partner serving Purnea, Bihar since 2010, is here to help. Contact us today at +91 75469 00951 for a free consultation and discover how we can streamline your daily accounting processes.