This template forecasts cash for a small business over twelve months. The Forecast tab lists each month with the sales, other money in, and the main costs out, such as wages, rent, software, marketing and tax. The cash in, cash out, net movement and balances are worked out for you.

The Assumptions tab holds the opening bank balance and the minimum cash you want to keep. The Dashboard shows the total cash in and out, the closing balance at the end of the year and the lowest month end, with a chart of the balance over time.

It comes with sample data. Make a copy, then replace the sample figures with your own. Formulas, highlights and charts update on their own.