Cash Flow Statement

Every enterprise has to prepare a Cash Flow Statement to report cash flows during the period classified by Operating, Investing and Financing Activities in a manner which is most appropriate to its business.

An enterprise can report cash flows using either

1. Direct method – Where the major classes of gross cash receipts and gross cash payments are disclosed.

2. Indirect method – Where the net profit or loss is adjusted for the effects of transactions of a non-cash nature, any delays or accruals of past or future operating cash receipts or payments, and items of income or expense associated with investing or financing cash flows.

While reporting the cash flows of Operating, Investing and Financing activities, an enterprise has to disclose the details of:

Preparing Cash Flow Statement in Tally.ERP 9

To prepare the Cash Flow Statement,

Go to Gateway of Tally > Display > Statutory Reports > MCA Reports(2012) > List of Accounts > Cash Flow Statement

Tally.ERP 9, allows the user to prepare the Cash Flow Statements using Direct Method or Indirect Method.

In Cash Flow Statements screen, Indirect Method will be displayed as the default method used for generation of Cash Flow Statement.

If the company is following a different Type of Cash Flow Statement, the same can be configured in General Information about Financial Statements from the Additional Details screen. When the Type of Cash Flow Statement is configured, the same will be captured in Method Used to Generate Cash Flow Statement field in Cash Flow Statements screen.

Note: Tally.ERP 9 will not allow the user to change the Type of Cash Flow Statement in Cash Flow Statement screen. Cash Flow Statement Type can be configured only from General Information about Financial Statements only.

 

The path:

Gateway of Tally > MCA Reports (2012) > Additional Details > General Information

In Cash Flow Statement screen,

Under Cash flows from operating activities, enter the information of:

Under Cash flows from investing activities, enter the information of:

Under Cash flows from financing activities, enter the information of:

Enter the value of Effect of Exchange rate changes on Cash and Cash Equivalents.

The Cash Flow Statement appears as shown:

Note: If the company has previous year data, then the data can be loaded using the option Ctrl+F3: Previous Cmp. The previous year closing balances will be displayed in Previous Year Amount column.

Disclose Details in Cash Flow Statement Manually or Auto Fill

Company can disclose the Cash Flow details by either manually entering the Value or using the auto-fill feature.

Let us take a scenario where ABC Company has to disclose details of Decrease or Increase in Trade Receivables during the Period.

In this case to auto-fill the value,

In Reporting Year column tab down to Adjustments for decrease (increase) in trade receivables field and click on S: Show Ledger button or press Alt+S keys to view the List of Ledgers. By default the List of Ledgers screen displays the ledgers grouped under Bank Account.

From List of Ledgers screen, select the HDFC Bank LTD A/c Ledger to view the List of Transactions for selected Ledger screen.

In List of Transactions for Selected Ledger screen, select the appropriate transaction (use Spacebar to select the transaction).

Note: To view the transactions in Display mode for more information, press Ctrl+Enter key or press the button Ctrl+Enter: Voucher

The transaction amount will be displayed against the Ledger. Press Ctrl+A or click on Ctrl+A: Accept button.

Amount of Rs. 7,37,819.25 will be auto-filled automatically for Adjustments for decrease (increase) in trade receivables  in the Amount column.

Note: All the information for the Cash Flow Statement is mandatory and to be filled compulsorily. If value is not available, then Zero (0) needs to be specified.

Button options in Cash Flow Statements

Ctrl+C: Default CF

Click on Ctrl+C: Default CF button or press Ctrl+C keys to view the Default Cash Flow report available in Tally.ERP 9.

F9: Status

The status of completion of the Cash Flow Statements report can be marked as Complete or Incomplete by pressing F9 or clicking F9: Status. The same will appear in the Status Column in Additional Details screen.

Note: To return to XBRL Cash Flow Statements, press Escape from Default Cash Flow report.