How to Use Cash Book in TallyPrime for Daily Cash Transactions

Cash book in TallyPrime is a daily record of all cash receipts and payments. Set up cash or bank accounts, record transactions via vouchers, and reconcile using built-in reports to maintain accurate cash flow and spot discrepancies quickly.

What Is a Cash Book in TallyPrime?

A cash book is the backbone of cash management in any business. It records every rupee that enters and leaves your business in chronological order. In TallyPrime, the cash book is not a separate module but rather a collection of cash and bank account transactions that you can view, filter, and reconcile in real time. Unlike a manual cash book, TallyPrime's digital cash book auto-calculates running balances, prevents duplicate entries, and integrates seamlessly with your profit and loss statement and balance sheet.

The primary purpose of maintaining a cash book is threefold: to track daily cash position, to detect errors or fraud, and to reconcile your accounting records with actual bank statements. In TallyPrime, this becomes effortless because every transaction is timestamped, user-tagged, and reversible.

Setting Up Cash and Bank Accounts in TallyPrime

Before you can record a single transaction, you must create the accounts that will hold your cash. In TallyPrime, cash and bank accounts are created under the Bank Accounts group.

Follow these steps:

1. Open TallyPrime and press Gateway of Tally.
2. Select Chart of Accounts.
3. Press Alt+C (Create).
4. Choose Ledger.
5. Enter the account name, e.g., "Cash in Hand" or "HDFC Current Account".
6. Set the group to Bank Accounts (for bank accounts) or Cash (for petty cash).
7. If using GST, enable it under F11 > GST Details for the company first, then set GST applicability for the account if needed.
8. Press Ctrl+S to save.

You can create multiple cash and bank accounts. For example, a small business in Purnea might have "Cash in Hand", "HDFC Current Account", and "Petty Cash" as three separate accounts. Each account will have its own running balance.

Recording Cash Receipts and Payments

Once your accounts are set up, you record daily transactions using vouchers. The most common voucher types for cash transactions are the Accounting Voucher and the Journal.

To record a cash receipt (money in):

1. Press Ctrl+A (Accounting Voucher).
2. Select Receipt from the voucher type menu.
3. Enter the date of the transaction.
4. In the first line, debit your cash account (e.g., "Cash in Hand").
5. In the second line, credit the source account (e.g., "Sales" or "Capital Account").
6. Enter the amount and narration.
7. Press Ctrl+S to save.

To record a cash payment (money out):

1. Press Ctrl+A (Accounting Voucher).
2. Select Payment from the voucher type menu.
3. Enter the date of the transaction.
4. In the first line, debit the expense account (e.g., "Rent Paid" or "Office Supplies").
5. In the second line, credit your cash account.
6. Enter the amount and narration.
7. Press Ctrl+S to save.

Worked Example: Daily Cash Transactions

Let us walk through a real-world example. Suppose Global IT Care, our Tally 3 Star Certified Partner in Purnea, records the following cash transactions on 15 January 2026:

Transaction	Type	Account	Amount (Rs)
Opening cash balance	Balance	Cash in Hand	50,000
Cash sales from consulting	Receipt	Cash in Hand (Dr) / Sales (Cr)	15,000
Paid office rent	Payment	Rent (Dr) / Cash in Hand (Cr)	10,000
Received from customer	Receipt	Cash in Hand (Dr) / Debtors (Cr)	8,500
Paid for stationery	Payment	Stationery (Dr) / Cash in Hand (Cr)	2,000
Closing cash balance	Balance	Cash in Hand	61,500

In TallyPrime, each transaction is recorded as a separate voucher. The running balance updates automatically. At the end of the day, the closing balance (61,500) should match your physical cash count. If it does not, you have a discrepancy to investigate.

Viewing Your Cash Book via Day Book

The day book in Tally is your cash book. It shows all transactions for a selected account in chronological order with running balances.

To view your cash book:

1. Press Alt+D (Day Book).
2. Select the cash account you want to view (e.g., "Cash in Hand").
3. Specify the date range (e.g., 1 January to 31 January 2026).
4. Press Enter.

TallyPrime will display all receipts and payments for that account with a running balance column. You can print this report, export it to Excel, or email it directly from Tally.

Reconciling Cash with Physical Count

Physical cash reconciliation is the process of matching your Tally cash book balance with the actual cash you have in your safe or till. Perform this daily or weekly.

Steps:

1. Count the physical cash in your till or safe.
2. Open TallyPrime and press Alt+D to view the Day Book for your cash account.
3. Note the closing balance in Tally.
4. Compare the two figures.
5. If they match, reconciliation is complete.
6. If they do not match, identify the difference and trace the error (e.g., unrecorded payment, incorrect amount entered).
7. Once the error is found, create a correcting voucher (e.g., a journal entry) to adjust the balance.

Bank Reconciliation Statement in TallyPrime

When you use a bank account, your Tally balance may not match your bank statement due to timing differences (cheques not yet cleared, deposits in transit, bank charges). The Bank Reconciliation Statement helps you identify and resolve these differences.

To access the Bank Reconciliation Statement:

1. Press Gateway of Tally.
2. Select Display More Reports.
3. Choose Bank Reconciliation Statement.
4. Select your bank account.
5. Enter the bank statement date and closing balance.
6. TallyPrime will list all uncleared cheques and deposits.
7. Verify each item and mark it as cleared once it appears in the bank statement.

This report is essential for monthly or quarterly reconciliation and is often required by auditors and tax authorities.

Petty Cash Management in Tally

Petty cash is small cash kept for minor expenses like postage, tea, or taxi fares. In TallyPrime, petty cash is managed as a separate account under the Cash group.

Best practice workflow:

1. Create a "Petty Cash" account under Chart of Accounts > Cash.
2. Allocate an initial amount, e.g., Rs 5,000, via a journal entry from your main cash account.
3. Record each petty cash expense as a payment voucher (Ctrl+A > Payment).
4. Weekly or monthly, reconcile petty cash by counting physical cash and comparing it with the Tally balance.
5. Replenish petty cash by transferring from the main cash account when it runs low.

Using the Trial Balance to Verify Cash Accounts

The Trial Balance is a list of all account balances at a specific date. It is a quick way to verify that your cash and bank accounts are balanced.

To view the Trial Balance:

1. Press Alt+T (Trial Balance).
2. Specify the date (e.g., 31 January 2026).
3. Press Enter.

Look at the Bank Accounts and Cash groups. The sum of all debit balances should equal the sum of all credit balances. If they do not, you have an error somewhere in your entries.

Generating Cash Flow Reports

Beyond the Day Book, TallyPrime offers cash flow reports that show your cash position over time. These are useful for forecasting and planning.

To access cash flow reports:

1. Press Gateway of Tally.
2. Select Display More Reports.
3. Choose Cash Flow Statement.
4. Select the period you want to analyze.

This report categorizes cash movements into operating, investing, and financing activities, giving you a clear picture of where your cash is coming from and where it is going.

GST Considerations for Cash Transactions

If your business is GST-registered, you must account for GST on cash sales and purchases. In TallyPrime, GST is enabled at the company level under F11 > GST Details.

When recording a cash sale subject to GST:

1. Press Ctrl+A (Accounting Voucher).
2. Select Receipt.
3. Debit Cash in Hand with the gross amount (including GST).
4. Credit Sales with the net amount.
5. Credit Output GST (GST Payable) with the GST portion.

TallyPrime automatically calculates GST and populates your GST reports (GSTR-1, GSTR-3B) with these transactions, streamlining your GST compliance.

Common Cash Book Errors and How to Fix Them

Even with TallyPrime, errors can occur. Here are the most common ones and how to fix them:

Error: Duplicate entry of the same transaction. Solution: Use Alt+D (Day Book) to find the duplicate, then delete the extra entry by opening the voucher and pressing Ctrl+X (Delete).

Error: Wrong amount entered. Solution: Open the voucher, correct the amount, and save. TallyPrime automatically reverses the old entry and records the new one.

Error: Transaction recorded in the wrong account. Solution: Reverse the original entry by creating an opposite voucher, then record the transaction in the correct account.

Error: Cash balance does not match physical count. Solution: Review the Day Book for the period, count physical cash again, and trace the discrepancy. Often it is an unrecorded expense or a data entry typo.

Best Practices for Cash Book Management

To maintain an accurate and reliable cash book in TallyPrime, follow these practices:

• Record transactions daily. Do not wait until the end of the week or month. Daily recording reduces errors and makes reconciliation easier.
• Use clear narrations. Always describe what the transaction is for, e.g., "Cash sales - Invoice #1234" instead of just "Sales".
• Reconcile weekly. Count physical cash and compare it with the Tally balance. This catches errors early.
• Segregate cash accounts. Keep petty cash, main cash, and bank accounts separate for better control and visibility.
• Back up your data regularly. Use Gateway of Tally > Company > Backup to save your data daily.
• Review the Day Book monthly. Print or export the Day Book and review it for anomalies.

Exporting and Printing Your Cash Book

TallyPrime allows you to export your cash book in multiple formats for sharing with stakeholders, auditors, or tax authorities.

To export the Day Book:

1. Press Alt+D (Day Book) and select your cash account.
2. Once the report is displayed, press Ctrl+E (Export).
3. Choose the format: Excel, PDF, or HTML.
4. Specify the file name and location.
5. Press Enter.

To print, press Ctrl+P from the Day Book view. You can customize the print layout to include or exclude columns as needed.

Troubleshooting Cash Book Issues in TallyPrime

If you encounter issues with your cash book, such as missing transactions or balance discrepancies, TallyPrime has built-in troubleshooting tools.

To repair your data:

1. Press Alt+Y (Data) > Repair.
2. Or press F1 (Help) > Troubleshooting > Repair.
3. TallyPrime will scan your data and fix minor inconsistencies.
4. Always back up your company data before running a repair.

If the issue persists, contact your Tally support team or a certified Tally partner for assistance.

Integrating Cash Book with Other Tally Reports

Your cash book data flows into all other financial reports in TallyPrime. The cash balance appears in your balance sheet under Current Assets, and cash transactions affect your profit and loss statement through income and expense accounts.

To view how your cash book integrates:

1. Press Alt+T to view the Trial Balance and see all account balances.
2. Press Alt+B to view the Balance Sheet and see cash as a current asset.
3. Press Alt+I to view the Profit and Loss Statement and see how cash transactions affect profitability.

Managing a cash book in TallyPrime is straightforward and powerful. By setting up proper accounts, recording transactions daily, and reconciling regularly, you maintain a clear, auditable record of your business cash. Whether you are a small trader in Purnea or a growing enterprise, TallyPrime's cash book features give you real-time visibility and control over one of your most critical assets.

If you need help setting up your cash book in TallyPrime or want to optimize your cash management processes, reach out to Global IT Care, a Tally 3 Star Certified Partner in Purnea, Bihar, serving businesses since 2010. We offer expert guidance on TallyPrime implementation, data migration, training, and ongoing support. Contact us today at +91 75469 00951 to schedule a consultation and see how we can streamline your financial operations.