# 12-Month Cash Flow Forecast Template: Free Download and Guide Source: https://www.cashflowforecasttemplates.co.uk/guides/12-month-cash-flow-forecast-template-free-download-and-guide Updated: September 25, 2026 > A 12-month cash flow forecast template shows your opening balance, expected cash in and cash out, and closing balance for each of the next twelve months. It is the standard format for annual planning, business plans and loan applications. Fill in your bank balance, receipts and payments by month, check the lowest balance, and update it monthly with actual figures. A 12-month cash flow forecast is the standard view of a business’s year: one column per month, with the money you expect to come in, the money you expect to go out, and the bank balance at the end of each month. It’s what banks ask for in loan applications, what advisers use for annual planning, and the best single tool for spotting the tight months before they arrive. This guide explains how to use the free 12-month template, how to read the results, and how to keep it useful all year. ## What’s in the template The free template has two tabs. **Start Here** explains the colour key and setup steps. **Forecast** holds: - **Settings:** business name, first month, bank balance at the start, minimum cash buffer and currency. - **Cash in:** customer payments, invoice collections, owner investment, loan drawdowns, tax refunds and other income. - **Cash out:** payroll, rent and utilities, suppliers, loan repayments, insurance, software, marketing, sales tax, income tax, equipment, owner drawings and other costs. - **Totals and balances:** monthly totals, net cash flow and a closing balance that carries forward automatically. - **Warnings:** any month below your minimum buffer turns red. - **Summary:** the lowest balance and its month, the number of months below your buffer, the year-end balance and average monthly net cash flow. - **Chart:** cash in and out as bars, and the balance as a line. Every line can be renamed, and you can insert rows inside a section. ## How to fill it in 1. **Set the first month and opening balance.** Use the combined balance of all business accounts on the first day. 2. **Choose a minimum buffer.** Four to eight weeks of fixed costs is a common starting point. 3. **Enter receipts in the month they’ll arrive.** A sale invoiced in January on 30-day terms is February cash, or March if that customer pays late. 4. **Enter regular payments.** Payroll, rent, software and loan repayments, month by month. 5. **Enter the lumpy ones.** Quarterly tax, annual insurance, equipment and bonuses in the months they fall. 6. **Delete the example figures** you don’t use, so they don’t distort the totals. ## How to read the results Start with the **summary box**. The lowest balance and its month are the two numbers that matter most. If the lowest balance is below your buffer, the red months show when, and the lines in those months show why. Then look at the **shape of the year** in the chart. A steadily falling line means the business spends more than it brings in and needs structural changes. A line with one or two dips means a timing problem that can usually be fixed by moving payments, collecting faster or arranging a short-term facility. Finally, check the **year-end balance** against where you started. That tells you whether the business is building cash or using it over the year. ## A worked example A small business starts the year with $25,000 and a $15,000 buffer. The forecast shows a comfortable autumn and winter, then four months below the buffer, with the lowest point of $12,000 in March. March combines a quiet sales month, a quarterly tax payment and a planned equipment purchase earlier in the year. With that information, the owner moves the equipment purchase to the summer, sets aside a little each month for tax, and schedules a sales push for February. The March low point rises above the buffer. The forecast didn’t change the business; it changed the timing of three decisions. ## Who uses a 12-month forecast - **Owners** planning hires, equipment purchases and quiet seasons. - **Lenders** assessing a loan or overdraft, who want to see how repayments fit alongside the rest of the year. - **Landlords and suppliers** checking whether a new tenant or trade customer can meet their commitments. - **Accountants and bookkeepers** preparing clients for tax payments and year-end. - **Investors and boards** tracking whether the business is building or using cash. ## Keep it up to date A 12-month forecast is most useful as a rolling plan: 1. At each month end, replace the forecast for that month with actual figures. 2. Compare the two and note why big differences happened. 3. Adjust future months if your assumptions have changed. 4. Add a new month at the end so it always looks twelve months ahead. ## Common mistakes with 12-month forecasts - **Spreading annual costs evenly.** If insurance is paid in one lump in March, put it in March. Averaging it across the year hides the dip it causes. - **Using the same sales figure every month.** Almost every business has a seasonal pattern. Use last year’s monthly sales as a guide, even if you adjust them for growth. - **Forgetting that months have different lengths and pay dates.** If you pay staff fortnightly or weekly, some months have an extra payroll. Check your payroll calendar. - **Counting sales instead of receipts.** Customers on credit terms pay one or two months later. The template’s rows are for cash received. - **Leaving out your own pay.** Owner drawings are real cash out, and leaving them out makes the forecast look healthier than it is. - **Never looking back.** Without comparing actual results with the forecast, you won’t know which assumptions to fix. ## When 12 months isn’t enough, or is too much - **Need more detail?** When cash is tight, add a [13-week weekly forecast](/guides/13-week-cash-flow-forecast) for the next quarter. The [free 13-week template](/templates/free-13-week-cash-flow-forecast-template) uses the same layout. - **Need a longer view?** Business plans and investors often want three years. Premium templates add a 3-year outlook built from the 12-month forecast and your growth rates. - **Need scenarios?** Premium templates switch between expected, best and worst case in one click. ## Building it yourself instead If you’d rather build your own, the [Excel step-by-step guide](/guides/how-to-make-a-cash-flow-forecast-in-excel) and [Google Sheets guide](/guides/how-to-create-a-cash-flow-forecast-in-google-sheets) explain every formula. The general method is in [how to make a cash flow forecast](/guides/how-to-make-a-cash-flow-forecast). ## Industry versions Every industry template includes a 12-month forecast, plus the cash lines and calculations your industry needs: progress billing for [construction](/cash-flow-forecast-template/construction), stock purchases for [retail](/cash-flow-forecast-template/retail), subscribers and churn for [SaaS](/cash-flow-forecast-template/saas), and more. ### What is a 12-month cash flow forecast? A month-by-month projection of the cash a business expects to receive and pay over the next year, showing the bank balance at the end of each month. ### Is the 12-month template free? Yes. The simple 12-month template is free to download and works in Excel and Google Sheets. ### Do I need a 12-month or a 13-week forecast? Use 12 months for planning the year and 13 weeks for managing the next quarter in detail. Many businesses use both. ### How often should I update a 12-month forecast? Monthly. Replace the finished month with actual figures and extend the forecast by a month so it always looks a year ahead. ### Can I use it for a business plan or loan application? Yes. Lenders often ask for a 12-month forecast, sometimes with a 3-year summary. Explain your main assumptions alongside it.