Monthly Thirteen Week Cash Forecast Tool

A cash forecast is an absolute must for any business.  This is a  forecast tool which you can use to look three months ahead on a monthly basis, helping you to catch any issues or opportunities early. This version covers thirteen weeks, week by week. It also allows you to keep track of where you are against the forecast.

Elsewhere amongst these downloads is a Daily forecasting tool, for those of you who need to keep a closer grip on the cash situation.

The download link is right at the bottom of the page.

There are two main sheets : the Forecast and the  Revised Forecast.  The second sheet allows you to reforecast as you go through the month, and to compare the original forecast's accuracy at the end of the month.  To do this, copy the numbers from the original forecast over to this sheet, then as the month progresses overwrite them with the actuals for the previous day / week.

All entries are in £'000s.  Amounts are shown to one decimal point so entries are to the nearest £100  e.g. £1,355.25 would be entered as 1.4   Don't waste time thinking about the pennies - this is a forecast.  Often you will need to be guesstimating.

Do make sure your bank account has been reconciled. This is a critical basic control.  If the reconciliation has not been done, you will not know if your starting point, the opening balance,  is accurate.

Weekly cashInput cells are white

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Over limit

 

 

 

 

 

If the overdraft limit is exceeded the balance is highlighted in red

 

 

 

Click the download attachment link below to get this Excel spreadsheet.

Login to post comments