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. 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.
To view Cash Flow Projection
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.
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.
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.
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.
'Viewing Cash Flow Projection' has been shared with
