

#EASY CASHFLOW FORECAST CURVE DRIVERS#
Even if (and this would be very unusual) reliable balance sheet reconciliation is done weekly, you will then also need to contend with cash drivers weekly for this approach to work.

If your business is close to breaching covenants or limits or is likely to do so imminently, and conditions are such that weekly cash volatility might be “smoothed” in a monthly forecast, then weekly forecasting is the way to go.īut because balance sheet reconciliation is usually, at best, done monthly, weekly cash flow forecasting cannot be integrated reliably within a balanced balance sheet - and therefore tested. Trading during the COVID-19 crisis is a lot more uncertain.

And business performance forecasts are usually done with budget holders who can be held to account for their performance against forecast. Therefore, integrating a cash flow forecast into a rolling 12-month calendar year business forecast automatically ensures that cash forecasts are the result of business performance forecasts. Most businesses budget monthly for a financial year and many do rolling forecasts to keep a year forward view.
#EASY CASHFLOW FORECAST CURVE UPDATE#
This means you can test the reliability of projected month-end cash balances against these cash drivers within the overall balance sheet.Īlso, once your cash flow model is built, it’s usually relatively simple to refine using the drivers, and to update with opening balances - and it remains robust. But, more importantly, balance sheet reconciliation is usually most complete at the end of each month and a forecast cash balance is one element of a balanced balance sheet. This is because cash drivers, such as debtor days, creditor days and inventory days, typically operate in monthly cycles and are often performance measures for a business. Under normal trading conditions, monthly cash forecasting is ideal. In this article, we’ll be recommending a rolling 13-week cash flow forecast cycle - here’s why. They show how much money is expected to come in and go out of your business accounts, as well as when these flows are expected to happen. The COVID-19 crisis has put cash and liquidity front and center for many businesses.Ĭash flow forecasts are an essential business tool to help you monitor your cash. Keeping tabs of cash during the ongoing crisis
