Monthly Cash Flow Forecast Template: Set Up and Month-End Review

A monthly cash flow forecast is the planning backbone of most small businesses. It’s detailed enough to show seasonal swings, tax bills and the effect of a new hire, and simple enough to maintain in half an hour a month. This guide covers what a monthly template should include, the timing rules that make it accurate, and a month-end review that turns it from a one-off spreadsheet into a management tool.

What a monthly template should include

• Settings: first month, opening bank balance and a minimum buffer.
• Cash in: customer payments and collections, other income, loans and investment, tax refunds.
• Cash out: payroll, rent, suppliers, software, insurance, marketing, loan repayments, sales tax or VAT, income tax, equipment and owner drawings.
• Balances: net cash flow and a closing balance that becomes next month’s opening balance.
• Warnings and summary: red months below your buffer, the lowest balance and when it falls.

Timing rules that make it accurate

1. Cash, not sales. A January invoice paid in February is February cash.
2. Real months for lumps. Annual insurance paid in March goes in March, not a twelfth in every month.
3. Count pay dates. Fortnightly payroll means two months a year have three pay days. Weekly payroll means some months have five.
4. Seasonality from history. Use last year’s months as a base rather than an average.
5. Tax in the month it’s paid. Quarterly and annual tax payments often cause the lowest balances of the year.

An example year, month by month

A small business with steady costs of about $38,000 a month and seasonal sales builds its monthly forecast from last year’s figures:

Three things stand out. December is strong, January is the weakest month of the year because a quiet sales month coincides with a quarterly tax bill and an equipment purchase, and March is another small dip before sales recover. An average month would show roughly break-even and hide all three. With the monthly view, the owner keeps part of December’s surplus for January and moves the equipment purchase to the summer.

Monthly vs weekly

A monthly forecast shows the shape of the year. It can’t show a dip in the middle of a month when payroll goes out before customers pay. If your lowest monthly balance is close to your buffer, or you pay staff weekly, add a weekly forecast for the next 13 weeks. Many businesses run both.

The month-end review

This is the habit that makes a monthly forecast worth having. It takes 20 to 30 minutes:

1. Enter actuals. Replace the finished month’s forecast with actual receipts and payments from your bank statement or accounts.
2. Compare. For each line, note the difference between forecast and actual.
3. Explain. For any difference over 10 percent, write one line: “Client X paid late”, “Energy bill higher than expected”.
4. Adjust. If the reason will repeat, change future months. A customer who always pays two weeks late should be forecast that way.
5. Roll forward. Add a new month at the end, so you always look twelve months ahead.
6. Decide. Check the lowest balance and any red months, and agree actions.

After three or four months of this, your forecast will be noticeably more accurate, because the assumptions come from what really happens.

Handling seasonality

Seasonal businesses benefit most from a monthly forecast, because it shows how much of the busy season’s cash must be kept for the quiet one. Build each month from last year’s equivalent month. Then look at the running balance: if the lowest point is in the quiet season, decide in the busy season how much to set aside. See an industry guide such as landscaping or retail.

What to do with the results

A forecast is only useful if it changes decisions. After each review, look at three things and act on them:

• The lowest balance and its month. If it’s below your buffer, decide now what you’ll do: collect faster, move a purchase, spread a tax bill or arrange a facility. The earlier you act, the cheaper the fix.
• The trend in the closing balance. A balance that falls a little every month points to a structural problem, such as prices too low or costs too high, that timing changes won’t solve.
• The biggest variances. Lines that are always wrong deserve better assumptions. If customer payments always come in lower than forecast, find out why and forecast them realistically.

Write the agreed actions next to the forecast, and check them at the next month end.

Presenting a monthly forecast

Lenders, landlords and investors usually ask for a 12-month monthly forecast. Make it easy to read:

• Keep lines grouped and labelled plainly.
• Show totals and the closing balance clearly.
• Add a short note on the main assumptions: sales growth, payment timing, major purchases.
• Include actual figures for past months if you have them, so readers can see your forecasts are reliable.
• Show the lowest balance and how you plan to handle it; readers trust a forecast that admits a tight month more than one that shows none.

Common mistakes

• Averaging everything. Real months are uneven; the forecast should be too.
• Ignoring owner drawings. They are cash out.
• Treating loans as income. They are cash in, but repayments follow.
• Updating only when there’s a problem. By then it’s too late to use the forecast well.

Get the template

The free 12-month template has everything in this guide, including the summary and warnings. Premium industry templates add a 13-week view, scenarios, an actuals tab and a variance report that does the month-end comparison for you. The 12-month template guide explains every part of the free version.