Scribd
Upload
28 views3 pages

CashFlow Projection

The document outlines the requirements for a Cash Flow Projection report, including input parameters such as report type and date range. It specifies various financial metrics to be included, such as bank balances, pending cheques, priority payables, and overdue receivables. Additionally, it details the logic for calculating these metrics and the structure for both detailed and day-wise summary reports.

Uploaded by

suprikumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
28 views3 pages

CashFlow Projection

The document outlines the requirements for a Cash Flow Projection report, including input parameters such as report type and date range. It specifies various financial metrics to be included, such as bank balances, pending cheques, priority payables, and overdue receivables. Additionally, it details the logic for calculating these metrics and the structure for both detailed and day-wise summary reports.

Uploaded by

suprikumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Cash Flow Projection

A Finance Report for Cash Flow Projections needs to be developed.

This Report must be Under Cash and Bank Reports.

Report Name: Cash Flow Projection

Input Parameters:

Report Type: Summary / Detail / Day wise

From Date:

To Date:

Particulars Bank 1 Bank 2 Bank 3 Bank 4 Total


Balance As Per
Bank
Cheques
pending
clearance
Effective Bank
Balance

Priority Payables

Balance
Available for
Other Payments
Cheques issued
& to be due till
31-08-2023.

Receivables
cheques to be
encased.

Other overdue
payables

Overdue/
receivables -
collection
planned 31-08-
2023.
Overdue/
receivables -
collections
unplanned

Net
excess/(shortfall)
projected till 31-
08-2023.

Stressed
receivables

Logic for bringing the data to the above summary report.

 Balance As Per Bank: Closing Balance of that Bank as on Date

 Cheques pending clearance: PDC Cheques Not Cleared

 Effective Bank Balance: Balance as Per Bank - Cheques pending clearance.

 Priority Payables - Sum of Payments to the High Potential Suppliers.

 Balance Available for Other Payments: Effective Bank Balance - Priority Payables

 Cheques issued & to be due till 31-08-2023: Cheque issued until last date of previous month and
are due for payment. Sum of All Payment Vouchers with Pay Mode as Cheque should be
considered until last date of Prev Month.

 Receivable Cheques to be Encashed: Should Consider the sum of all Receipt Vouchers with
Cheque as Payment Mode.
 Other Overdue Payables: Sum of all Ageing Payments. This should be picked up from the AP
Ageing View where Payment Due is > some slab. As on date overdue not paid, and those
invoices until the month date for a given period.

 Overdue/ receivables - collection planned 31-08-2023 – AR Ageing View – Amount should be


picked up basis this Ageing View as per the respective banks as on the specified date. As on date
overdue not received, and those invoices until the month date for a given period.

 Overdue/ receivables - collections unplanned

Receivables who are Blacklisted and whose Invoices are not settled. The amount can be fetched
from the Ageing Report.

Detailed Report :

Report Parameters :

As on Date :

Bank : ALL / BANK 1/BANK 2/BANK 3 (Default Value should be All)

Day Wise Summary :

Report Parameters :

As On Date :

Bank : ALL / BANK 1/BANK 2/BANK 3 (Default Value should be All)

This report should list all the transactions daywise in the ascending order for the As On Date .

Cash Transactions as on Date with Party Details and Due Date .

You might also like