Explore Categories

 

 PDF

Cash Book and Bank Book

The Cash Book is a record of the receipts and payments of cash. It is a book of original entry as well as a ledger account. Similarly, the Bank Book is a record of all the receipts and payments made through the bank. The Cash/Bank Book in TallyPrime is a two-in-one report where you can see both the cash and the bank transactions on the same screen, but in separate sections.

Both the Cash Book and Bank Book in TallyPrime are account books that are used to record individual transaction details. Though the items are posted to different ledgers, TallyPrime will help you see all the transactions of one category in one place. Accordingly, all transactions that affect cash will appear in the Cash Book, while all transactions that involve a bank, such as deposits, credits, and withdrawals, will appear in the Bank Book.

What’s more, you can view the Cash/Bank Book in your browser!

View Cash Book 

With the Cash Book in TallyPrime, you can view all the receipts and payments of cash at one place.

  1. Gateway of Tally > Display More Reports > Account Books > Cash/Bank Book(s).
    Alternatively, Alt+G (Go To) > type or search Cash/Bank Book > press Enter.Selecting Cash Book on the Cash/Bank Summary screen in TallyPrime
  2. Press Alt+F2 to select the required period, and drill down to view the ledger vouchers.Viewing the Ledger Monthly Summary by selecting a ledger from the Cash Book in TallyPrime
    The Cash ledger account screen displays the debit and credit amounts of all the vouchers for the period. If cash balance is negative for a particular date, then TallyPrime displays the credit cash balance in red colour as the Closing Balance.

View Bank Book 

With the Bank Book in TallyPrime, you can view all the bank-related receipts and payments in one place.

  1. Gateway of Tally > Display More Reports > Account Books > Cash/Bank Book(s).
    Alternatively, Alt+G (Go To) > type or search Cash/Bank Book > and press Enter.Selecting Bank Book on the Cash/Bank Summary screen in TallyPrime
  2. If you have more than one bank account, select the required account and drill down to view the Ledger Monthly Summary.Viewing the Ledger Monthly Summary by selecting a ledger from the Bank Book in TallyPrime

Daily Breakup

In the Cash/Bank Book in TallyPrime, you can easily view the daily break up of transactions for the ledger.

  1. In the Cash/Bank Book, drill down from the Cash ledger and select the required month.
  2. Press Ctrl+F6 (Daily) to view the daily breakup of the ledger.Monthly breakup of ledger in Ledger Monthly Summary in TallyPrime
    If cash balance is negative for a particular date, then the credit cash balance will appear in red colour.
  3. Press F12 (Configure) > Show Highest Balance & Lowest Balance > Yes, to see the highest or lowest cash balance of the day.Configuring Ledger Monthly Summary to view highest balance and lowest cash balance in TallyPrime

View Negative Cash Report

When the cash balance is less than the sale value, the differential amount goes into the negative cash report. Let’s say you have a cash balance of Rs. 30000, and you have made a payment of Rs. 32000. Thus, you will have Rs. 2000 as a negative cash balance with you.

This report allows you to identify in which month the negative cash occurred. Additionally, you can view the report by day to determine precisely when or on which date the cash fell short. The report will show you the running balance and any time the cash balance for the month is negative, you will see the Closing Balance in red color.

TallyPrime provides all these features, which allows you to identify negative cash balances that need to be corrected and take corrective measures to fix the data.

Scenario 1: In case you have a negative cash balance towards the middle of a month (anywhere between dates), but the balance is brought back to positive by the end of the month, then follow these steps to view the negative cash report.

  1. View negative cash balance.
    1. Open Cash/Bank Book.
    2. Press F2 (Period) to change the period of Cash/Bank Book by entering the dates in From and To fields, if needed.
    3. Drill down from the Cash ledger to view the negative cash report for the months with a negative cash balance.
      Negative Cash Report showing monthly breakdown of ledger in TallyPrime
      Note: You may see for any month, the overall transaction is positive, and you will see the Closing Balance for that month is black in color. In this case you can view the daily transactions and be able to identify on which day the negative cash balance happened.
  2. Press Ctrl+F6 (Daily) to view the transactions on daily basis.
    Negative Cash Report showing daily breakdown of ledger in TallyPrime
    Now you can further drill down to view the transaction details and correct the data.

Scenario 2: If you have negative cash balance for the overall month or if you are closing the month with a negative cash balance, then it will start showing in Exception Reports.

This is because it considers the period, based on that, it will show you the negative ledgers. The Exception Reports will show you the negative ledgers including Cash if you have negative balance as on today and not on middle date of any month.

  1. View Negative Ledger.
    1. Press Alt+G (Go To) > type List of Negative Ledgers > select Cash from the List of Negative Ledger A/cs > press Enter.
      Alternatively, Gateway of Tally > Display More Reports > Exception Reports > Negative Ledgers > select Cash from the List of Negative Ledger A/cs > press Enter.
    2. Press F2 (Period) to change the period of Negative Ledgers by entering the dates in From and To fields, if needed.
    3. Drill down from the Cash ledger to view the negative cash report for the months with a negative cash balance.
      Note: You may see for any month, the overall transaction is positive, and you will see the Closing Balance for that month is black in color. In this case you can view the daily transactions and be able to identify on which day the negative cash balance happened.
    4. Press Ctrl+F6 (Daily) to view the transactions on daily basis.
      Now you can further drill down to view the transaction details and correct the data.

Using these methods, you can access the negative cash report and identify negative cash balances that need to be corrected and take the necessary actions to fix you data.

Compare Information Using Cash/Bank Book

You can use the Cash/Bank Book as a powerful medium for comparison. You can compare Bank Book with Cash Book, or two or more banks in multiple columns. You can view the information for multiple periods (such as yearly, quarterly, monthly, and so on) on the same screen, instead of toggling between different periods or ledgers.

For example, let us say that you want to compare the quarter of April to June with the quarter of July to September.

  1. In the Cash/Bank Book, drill down from the Cash ledger. The Ledger Monthly Summary appears.
    Comparison of Debit, Credit, and Closing Balances from the Ledger Monthly Summary in TallyPrime
  2. Press Alt+(Auto Column), and select Quarterly in the Auto Column field.Comparing the Debit, Credit, and Closing Balances in a column from the Ledger Monthly Summary in TallyPrime

Now you can compare various components of the ledgers such as the Opening Balance and Closing Balance.

Configure Cash/Bank Book

In TallyPrime, you can configure the Cash/Bank Book to view the opening balance, transaction summary, closing balance, and more, on the same screen.

  1. Cash/Bank Book > press F12 (Configure).
    • Set Show Opening Balance to Yes.
    • Set Show Transactions to Yes.
    • Set Show Closing Balance to Yes.
  2. Accept the screen. As always, you can press Ctrl+A to save.

Now you can view the details of opening balance, transaction summary, and closing balance in the Cash/Bank Book.

Post a Comment

Is this information useful?
YesNo
Helpful?