It is only important that you record all incoming and outgoing cash flows so that the overview on your dashboard is correct. There can be many more categories in your company.

You then enter this in the table in the corresponding category. To get to this overview, categorise the individual incoming and outgoing cash flows in each month and add them up to a total. TOTAL cash balance = Balance from previous month + balance from current month revenues and expenses), for example like this: Cash flow balance at start of year: £3,000 On your dashboard, you can create a monthly overview of your incoming and outgoing cash flows (i.e. Each incoming or outgoing transaction represents a cash flow. The basic variables for the input of your cash flow dashboard are the transactions on your business accounts. Depending on which key figures or correlations you want to look at, you will need different data sources. You can create a cash flow dashboard in Excel yourself. This helps them to plan the funds better so that they are available in time and the project does not get bogged down. Project managers can see on the dashboard whether the planned funds are sufficient or whether more money is needed.

Target-performance comparison between planned expenditure and actual expenditure.Possible income related to the project (e.g.Instead of looking at the cash flow of the entire company, you can also display the cash flow for a single project on a dashboard, for example: What are the advantages of a project cashflow dashboard?Ĭash flow dashboards are not only important tools for financial managers, but also for project managers. Target/actual comparison between planned and actual cash flow.Total accounts receivables and accounts payables.Cash burn rate of the past months and expected burn rate in the coming months.Past expenditure and income as well as expected development of expenditure and income in the coming months.Total past, current and estimated future bank balances.Cash flow dashboard exampleĬommon cash flow measures that are displayed on a cash flow dashboard are, for example: Therefore, no two cash flow dashboards are alike and are individually adapted to the user's needs. For example, a CEO needs different presentations and key figures than a project manager. Cashflow dashboard: What does it contain?Ī cashflow dashboard contains the most important cashflow figures of a company or a project, as well as graphical representations of various past, current and future cashflow figures.ĭifferent representations are relevant for different users. We show you here what a cash flow dashboard contains and which tools you can use to create it. It is used by those responsible for monitoring liquid funds and for better planning, so that no cash shortages occur. A cash flow dashboard graphically displays important cash flow key figures and cash flow developments of a company.