Register now or log in to join your professional community.
The cash flow projection worksheet in this file provides a systematic method of recording estimates of cash receipts and expenditures, which can be compared with actual receipts and expenditures as they become known. The entries listed in the Excel sheet will not necessarily apply to every business, and some entries may not be included which would be pertinent to specific businesses. It is suggested, therefore, that you adapt the Excel sheet to the particular business for which the projection is being made, with appropriate changes in the entries as required. Before the cash flow projection can be completed and a pricing structure established,
By recording all the cash transaction on daily basis in excel cash outflow and cash inflow this way you can maintain the cash flow statement. in simple words,Just record transaction in the excel and maintain.
Start with opening balances, add all the receipt and less all the payments made during the day you will have the closing balance verify that balance with the physical cash balances these should be equal.(This method is only for daily actual cash flows, for estimated cash flows there would be other method, daily cash flows and cash flow statement according to IAS-7 are different).
