Cash Flow Forecast Template for Personal Finances

A personal cash flow forecast answers a simple question: will there be enough in my account to pay everything, every month, for the next year? Most households know their monthly budget but get caught by the months that aren’t typical: an annual insurance bill, holiday spending, a car repair or a tax bill. A forecast lays out the year so those months are planned, not surprises.

Why personal cash flow is different from a budget

• A budget says how much. A forecast says when. You might budget $1,200 a year for insurance, but if it’s paid in one go in March, March is tight.
• Pay dates matter. Being paid monthly, fortnightly or weekly changes which bills fall before payday.
• Irregular income needs planning. Bonuses, side income and tax refunds arrive in specific months.
• Big annual costs cluster. Holidays, car tax, memberships and gifts often fall in the same few months.
• Savings need a plan. Transferring a fixed amount to savings each month works only if every month can afford it.

A worked example

A household takes home $5,100 a month and spends about $4,700 in a normal month, including $300 to savings.

December’s gifts and travel, and March’s annual bills, turn a comfortable household into one that needs to dip into savings twice a year. Seeing that in October means spreading the cost: saving $400 a month from October covers both.

How to build a personal cash forecast

1. Enter your current bank balance.
2. List income by the month it arrives: salary, side income, benefits and refunds.
3. List regular bills: rent or mortgage, utilities, transport, insurance, childcare and debt payments.
4. Add everyday spending: groceries, eating out and subscriptions.
5. Add irregular costs in the month they fall: holidays, gifts, annual bills and car costs.
6. Set a minimum balance, often one month of essential costs.

Common mistakes

Forgetting annual subscriptions and renewals. Assuming every month is average. Counting a bonus before it’s paid. And saving whatever is left over at month end, rather than paying yourself first.

What the template gives you

The Personal & Household template includes a Savings Plan tab that sets savings transfers as a percentage of your salary, so saving happens automatically in the forecast. The dashboard shows the month your balance is lowest and how many months fall below your minimum. Want to start free? Try the free personal cash flow template.

Key assumptions built into the Personal & Household template

• The Savings Plan tab calculates savings rate at 10% of salary. Change a percentage once and every month of the forecast updates, so costs rise and fall with the sales that drive them.
• 5 cash in lines and 9 cash out lines are already named for personal & household businesses, and every one can be renamed or extended.
• The example figures follow a fairly even year, which suits most personal & household businesses; add your own seasonal pattern if you have one.

Every assumption sits in a yellow input cell, so you replace the example with your own numbers in minutes. The same figures flow through a 13-week weekly view, a 12-month monthly view and a 3-year outlook, and a dashboard shows your lowest balance, the weeks that fall below your minimum buffer and your cash runway.

Free or premium?

If you only need the basics, the free 12-month template or the free 13-week template will get you started today. The premium Personal & Household template saves the setup time and adds the tabs above, best and worst case scenarios, and an actual vs forecast tracker that shows where your forecast was wrong, so next month’s is better.

Personal & Household cash flow forecasting: questions

What is the difference between a budget and a cash flow forecast?

A budget sets how much you plan to spend on each category. A cash flow forecast shows when money comes in and goes out, so you can see which months will be tight.

How much should I keep in my current account as a buffer?

Many people keep about one month of essential costs, with a separate emergency fund of three to six months in savings.

How do I plan for annual bills?

List each one in the month it’s due, then save a monthly amount towards them so the lump never lands on an already tight month.