Get 90% off your plan for your first 6 months*

See what’s coming with a cash flow forecast template

Wondering when money might get tight? Catch shortfalls months in advance and plan your spending calmly. Download the template and map out your cash.

Cash flow forecast template with 'your business name' circled

Download the cash flow forecast template

Fill in the form to get a free cash flow forecast template as an editable PDF. We’ll also link you to a guide on how to use it.

Got your template? Try Xero for free.

Ready to take control of your business? Xero's got everything you need to succeed, from accounting and invoicing to reporting and payroll.

3 ways Xero makes cash flow forecasting easier

Bring your finances together in Xero and plan what's next with a clear view of your cash.

  • Tick

    See your numbers come to life

    Get up-to-date visual insights and cash flow forecasts that show where your business is heading.

  • Tick

    Get clear cash flow insights

    See all the money moving in and out. Your latest transactions in Xero help you budget for upcoming expenses.

  • Tick

    Know where your business stands

    Keep an eye on your latest figures to spot anything unusual and plan your next move.

Map your cash flow forecast month by month

Where do you start? Pop your opening bank balance in the first month. Then add the money you expect in and out, including supplier bills, wages, VAT, and Corporation Tax. Your closing balance shows what's left, and it becomes next month's opening figure.

  • Included
    Record payments in the month cash moves
  • Included
    Enter a sale in the month your customer pays the invoice. That way, each month’s balance matches what lands in your bank.
See a worked cash flow forecast example
A completed cash flow forecast example showing money in, money out, net cash flow and closing balance

FAQs on Xero's cash flow forecast template

A cash flow forecast predicts the money coming in and going out of your business over the next few weeks or months. It shows when your bank balance will rise or dip, and helps you plan your spending.

A cash flow forecast predicts the money coming in and going out of your business over the next few weeks or months. It shows when your bank balance will rise or dip, and helps you plan your spending.

Work through each month in order:

1. Enter your opening bank balance

2. Add the money you expect to receive

3. List expected payments, including wages, rent, supplier bills and VAT

4. Check the closing balance and carry it into the next month

Work through each month in order:

1. Enter your opening bank balance

2. Add the money you expect to receive

3. List expected payments, including wages, rent, supplier bills and VAT

4. Check the closing balance and carry it into the next month

Your closing balance is your opening balance plus cash in, minus cash out, and net cash flow is cash in minus cash out for the period. To test your own figures, try Xero's cash flow calculator.

Your closing balance is your opening balance plus cash in, minus cash out, and net cash flow is cash in minus cash out for the period. To test your own figures, try Xero's cash flow calculator.

Update it monthly, or weekly when cash is tight. Each time, compare the figures with what really came in and went out.

Update it monthly, or weekly when cash is tight. Each time, compare the figures with what really came in and went out.

A forecast estimates the cash you expect in future, while a cash flow statement reports the cash that moved during a past period. Use the forecast to plan, and the statement to check how those plans played out.

A forecast estimates the cash you expect in future, while a cash flow statement reports the cash that moved during a past period. Use the forecast to plan, and the statement to check how those plans played out.

Both work well, so pick the view that matches what you're planning:

- weekly, if cash is tight or you're heading into a busy season

- monthly, for day-to-day budgeting

- 12 months, for a business plan or loan application.

Both work well, so pick the view that matches what you're planning:

- weekly, if cash is tight or you're heading into a busy season

- monthly, for day-to-day budgeting

- 12 months, for a business plan or loan application.

Banks use a forecast to see when cash comes in and how you'll fit loan repayments around your other costs, so it often sits inside your business plan. GOV.UK guidance on writing a business plan explains what to include.

Banks use a forecast to see when cash comes in and how you'll fit loan repayments around your other costs, so it often sits inside your business plan. GOV.UK guidance on writing a business plan explains what to include.

Yes, Xero's short-term cash flow projection shows expected cash in and out over the next 7 or 30 days, based on the due dates of your approved invoices and bills. Xero Central's step-by-step help article shows you how to set it up.

Explore Xero's cash flow forecasting software

Yes, Xero's short-term cash flow projection shows expected cash in and out over the next 7 or 30 days, based on the due dates of your approved invoices and bills. Xero Central's step-by-step help article shows you how to set it up.

Explore Xero's cash flow forecasting software

A forecast is an estimate based on your best assumptions, so it becomes more accurate each time you update it with what really happened. Pair it with these ways to manage cash flow to stay in control of your cash.

A forecast is an estimate based on your best assumptions, so it becomes more accurate each time you update it with what really happened. Pair it with these ways to manage cash flow to stay in control of your cash.

Disclaimer

Xero does not provide accounting, tax, business or legal advice. This template has been provided for information purposes only. You should consult your own professional advisors for advice directly relating to your business.