Tally Accounting

Cash Flow Projection in Tally

Posted by Asok K Nadhani on

Cash Flow Projection in Tally

Cash Flow Projection or Cash Flow Forecasting, is a financial statement showing the estimated Cash Inflow and Outflow in the organisation to ascertain cash availability to meet financial obligation  in time, and utilisation of surplus cash for optimum use.

Cash Flow Projection in Tally

Cash Flow Projections show adequacy of available Cash (Cash and Free Bank Balance / OD Limit) to meet the Payment Liabilities (Payables) in time, in future period, for better cash management.

Display > Cash & Funds Flow>Cash Flow Projections to get Cash Flow Projection Report .

Cash Flow Projection Display

Click F2:Period to set the Period . By default the Cash Flow Projection would be shown for the date of last voucher entered), as this is a Projection Report (Report for a future Period). So, the Start Date of the Period to set should be higher than the last Voucher entered, otherwise an error message would elicit and you will not be able to proceed.

Cash Flow Projections Period  Set Up

Cash Flow Projections Period  Error message

Cash Flow Projections Configuration

At Cash Flow Projection Display, click F12:Configure to get  Cash Flow Projection Configuration to set up the Configuration options

Cash Flow Projection Configuration in Tally

Cash Flow Projection Configuration in Tally

  • All Details : Having set F1:Detailed button, at Expand all Levels in Details Format,
    • Set Yes to show complete details of all lower level Accounts
    • Set No. Lower Level details are not shown
  • Cash Account : At Include Cash Account,
    • Set Yes to Include Cash Account also in the Report
    • Set No to exclude Include Cash Account in the Report (Bank Accounts are included)
  • Scenarios :  At  Include Scenarios,
    • Set Yes to Include Scenarios also in the Report
    • Set No to exclude Scenarios in the Report 
  • Overdues :  At Include Overdues,
    • Set Yes to Include Overdues (Receivables & Payables) also in the Report
    • Set No to exclude Overdues in the Report  (only Dues till the report date are included)

Cash Flow Projections Display Buttons

At Cash Flow Projection Display, you get the following buttons

  • S:Set OD Limit : To set Bank OD Limit, as described next

Cash Flow Projection Button Bar

Bank OD Limit Set Up in Tally

At Cash Flow Projection Display, click S:Set OD Limit to get OD Limit Set Up screen to set the OD limit of Bank Accounts (under Bank Accounts, Bank OCC/OD Group).

Against each of the Bank Account, enter the OD Limit sanctioned / available.

OD Limit Set Up for Cash Flow Projections

Click here to see PDF