A Cash Flow Projection is an integral part of the financial section of all business plans, literally describing how cash is projected to flow in and out of a business.
A cash flow statement concentrates on the transactions that have a direct impact on cash. It deals with the inflow and outflow of cash between two Balance Sheet dates. That is, it explains the changes in cash position between the two periods. Here the term cash stands for cash and bank balances. Cash flow statements can also be used as receipts and payments statement. This is particularly useful for businesses such as Non Profit Organizations where receipts and payments statements need to be generated. Unlike Cash Flow Statements which are used to explain the previous actual cash flow, the Cash Flow Projections are used to anticipate the cash to be generated or expended over a chosen period of time in the future.
On this page
View Cash Flow Projection report
Button options in Cash Flow Projection report
1. Go to Gateway of Tally > Display > Cash/Funds Flow > Cash Flow Projection . The Cash Flow Projection screen appears as shown:
2. By default, the projected columns are displayed on monthly basis. Click N : Auto Column or press Alt+N to select the required column details.
Note: The first column displays the date of last entry made till the end of the month/period selected.
3. A. Current Balance : This row displays the projected opening balances of Bank / Bank OD accounts available for each column period. The opening balance of Cash Accounts may also be included by enabling it from F12: Configure .
4. B: Receivables : This row displays the amounts which are receivable from the customers / other receivables for each projected columnar period.
For example, a Sales Invoice was raised on 3rd July 2010 for Rs.10000/-, and the credit days given was 30 days, the outstanding amount receivable would appear in August'10 month column.
Note: In the Bill-wise details if Due Date/Credit Days is specified for New Ref/Advance the projection report will consider the due date .
In case On Account is selected, the projection report will consider the Sales Bill date as the due date .
● Select Receivables to view the party details, the due dates and the transaction amount in the respective column periods.
● Click F1 : Detailed or press Alt+F1 to view the voucher details, as shown:
● Select the required voucher to further drill down to the voucher level.
Note: You may also select the required period columns in the Receivables row to view the transactions.
5. C: Payables : This row displays the amounts which are payable to the suppliers / other payables for each projected columnar period.
For example, a Purchase Invoice was raised on 3rd July 2010 for Rs.10000/-, and the credit days given was 30 days, the outstanding amount payable would appear in August'10 month column.
Note: In the Bill-wise details if Due Date/Credit Days is specified as New Ref / Advance , the projection report will consider the due date .
In case the On Account is selected, the projection report will consider the Purchase voucher date as the due date .
● Select Payables to view the party details, the due dates and the transaction amount in the respective column periods.
● Click F1 : Detailed or press Alt+F1 to view the voucher details, as shown below:
● Select the required voucher to further drill down to the voucher level.
Note: You may also select the required period columns in the Payables row to view the transactions.
● F1 : Detailed : View the Cash Flow Projection Report in detailed format, as shown:
Note: This button toggles between Detailed/Condensed.
● F2: Period: Change the period of the Cash Flow Projection report.
● F3: Company : Select a Company from the list to view the report of the selected company.
Note: This button will be active only when more than one company is loaded.
● S : Set OD Limit : This button allows you to set the overdraft limit to your Bank OD accounts to project the cash flow based on the required limit provided. To set the OD limit:
o Click S : Set OD Limit or press Alt+S
o The Bank OD Limit screen appears.
o Provide the OD limits to the required banks as shown:
● Accept to save the settings.
Note: The OD limit specified to a Bank a/c will exclude / include the opening balance brought forward having credit / debit balance while displaying in the cash flow projection.
