www.TallyERP9Help.Com

Cash Flow Projection in Tally.ERP 9

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 Statementswhich 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.

Cash Flow Projection is an important tool for cash flow management, as it lets you know when the expenditures are too high or when the short term investments to handle cash flow surplus need to be made.

The Cash Flow Projection report in Tally.ERP 9 displays the projections on monthly basis (default) based on the last date of entry made till the end of the selected period. The user is allowed to specify the required period and also include scenarios for projection. It displays the availability of funds, the expected receipts and the payments for each columnar period.

To view Cash Flow Projection:

  • Go to Gateway of Tally > Display > Cash/Funds Flow > Cash Flow Projection

The Cash Flow Projection screen appears as shown:


[Img-38]

  1. By default, the projected columns are displayed on monthly basis. Click N: Auto Column or press Alt+N to select the required column details.


[Img-39]

Note: The first column displays the date of last entry made till the end of the month/period selected.

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.

B: Receivables:

This row displays the amounts which are receivable from the customers / other receivables for each projected columnar period.

Say for instance:

  • 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:


[Img-40]

  • 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.

C: Payables:

This row displays the amounts which are payable to the suppliers / other payables for each projected columnar period.

Say for instance:

  • 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:


[Img-41]

  • 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.

Other Functions

  • F1: Detailed: View the Cash Flow Projection Report in detailed format, as shown:


[Img-42]

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:

  • Click S: Set OD Limit or press Alt+S

  • The Bank OD Limit screen appears.

  • Provide the OD limits to the required banks as shown:


[Img-43]

  • 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.

 
 
 
 
Tally.ERP 9 Reference Manual LIBRARY
1.
Installation of Tally.ERP9
2.
Site Licensing of Tally.ERP9
3.
Shortcut Keys in Tally.ERP9
4.
Maintaining Company Data
5.
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
6.
Voucher Entry
7.
Reports in Tally.ERP9
8.
Excise for Dealer
9.
Excise for Manufacturer
10.
Reports [ Excise for Manufacturer]
11.
Excise for Importer
12.
Service Tax in Tally.ERP9
13.
Tax Collected at Source (TCS) in Tally.ERP9
14.
Tax Deducted at Source (TDS) in Tally.ERP9
15.
Value Added Tax (VAT) in Tally.ERP9
16.
Central Sales Tax (CST) in Tally.ERP9
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
Our Portal : www.TallyERP9Book.Com www.IncomeTaxManagement.Com www.Tally9Book.com www.TallyERP9Help.Com
Disclaimer :
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications