How Much Money Will I Have in Three Months? How to Build a Cash Flow Forecast as a Freelancer

There’s one question every freelancer should be able to answer in under thirty seconds: how much money will I have in my account three months from now?

If it takes you longer, or if the answer is “I have no idea,” you have a visibility problem. Not necessarily a money problem, but an information problem. And that distinction matters a lot.

A cash flow forecast isn’t accounting. It’s not for the Spanish Tax Agency (Agencia Tributaria). It’s for you: to know whether you can afford that expense, whether you’ll sail comfortably through the end of the quarter, or whether there’s a rough month on the horizon you’d better prepare for.

Why freelancers need this more than anyone

Someone with a salaried job gets paid the same amount on the same day every month. Their fixed expenses are relatively stable. Financial planning, while still useful, feels less urgent.

A freelancer lives in a completely different world. Income varies. Clients pay late, or very late. Social security contributions go up. And on top of that, quarterly tax obligations come around like clockwork (VAT returns, income tax installments) and the bills always seem to arrive all at once.

Without a forecast, financial management becomes constant improvisation. It works until it doesn’t.

What you need to build a useful forecast

A cash flow forecast doesn’t require fancy tools, but it does require two things: data and discipline.

Here’s the data you need:

• Current balance of all your relevant accounts.
• Expected income: invoices you’ve sent but haven’t been paid for yet, active contracts with estimated payment dates, stable recurring revenue (that client you invoice every month).
• Fixed expenses: social security or self-employment tax payments, insurance, subscriptions, office rent if you have one, your accountant’s fees.
• Predictable variable expenses: regular suppliers, consumables, materials.
• Taxes: your quarterly VAT and income tax installments. This is where most people get caught off guard.

The discipline is knowing that a forecast is only useful if it’s up to date. A three-month-old forecast that nobody has touched is worthless.

The most common mistake: ignoring taxes until they hurt

The VAT you charge your clients isn’t yours. It’s money the government lets you hold temporarily, and you’ll have to hand it back every quarter. If you mix it into your available balance and make spending decisions based on that inflated number, you’re fooling yourself.

A well-built cash flow forecast separates the money that’s actually yours from the money that isn’t. And it reminds you, with enough lead time, that in January, April, July, and October a chunk of cash is going to leave your account: cash you can already see today.

The second common mistake is forgetting about annual or semi-annual expenses. Car insurance, domain renewals, that yearly software subscription. These don’t happen every month, so they’re easy to leave out of the forecast. Until they show up.

How to structure a month-by-month forecast

The simplest approach is to work with a three-to-six-month horizon. Anything longer is hard to maintain accurately; anything shorter doesn’t give you enough time to react.

For each future month, note down:

1. Opening balance (the closing balance from the previous month).
2. Expected inflows: invoices collected, expected recurring payments.
3. Expected outflows: fixed costs, variable costs, taxes.
4. Closing balance: the sum of it all.

If the closing balance for any month is negative, or falls below a minimum you’re comfortable with, you now have useful information with enough time to act. Expedite an invoice, postpone an expense, have a conversation with a client. These are decisions you can only make if you know what’s coming.

The part most people neglect: variable income

Fixed expenses are relatively straightforward. Social security payments, rent, your accountant: they don’t change much and you can predict them with reasonable accuracy.

The tricky part is income. If you have steady clients on monthly contracts, great. But if you work on a project basis, or have clients who tend to pay late, forecasting income gets complicated.

There’s no magic here: you have to be conservative. If a client typically pays 60 days after invoicing, don’t include them in next month’s forecast. And if a project is “almost confirmed” but not signed, don’t include it either.

A pessimistic forecast isn’t there to make you anxious. It’s there to help you make decisions on solid ground.

Keeping it updated without it becoming a job in itself

The biggest enemy of cash flow forecasting isn’t the complexity of building the forecast: it’s the cost of maintaining it.

If you have to open a spreadsheet, manually update rows, recalculate totals, and adjust future months every time something changes, the odds of you doing it consistently are low. And a forecast that gets updated once a quarter, when it’s already too late, isn’t much help.

The key is to minimize the maintenance. Define your recurring expenses once and let them project themselves forward. Keep your current balance updated effortlessly. Make the view of upcoming months instant.

Cuéntamo, for instance, automatically generates future transactions from the recurring items you define, and calculates your projected balance day by day up to two years ahead. Not because it’s magic, but because the data it needs (recurring items, accounts, current balance) is already there. You enter it once, and the forecast takes care of itself.

What changes when you finally have visibility

A cash flow forecast isn’t a savings tool or an expense-cutting tool. It’s a control tool. And control, in a freelancer’s finances, means fewer surprises.

Knowing that October is going to be a tight month doesn’t make you richer. But it lets you make decisions in August, when you still have room to maneuver. That’s worth more than it sounds.

And if you want to take it a step further, you can ask “what if?”: what happens if I lose that client who pays me every month? What if I cancel that expensive subscription? How much does my forecast change if I land a new contract? Cuéntamo includes a scenario simulator that lets you disable, adjust, or add hypothetical recurring items and see how they affect your projected balance, chart, and spending capacity, all in real time, without touching your actual data.

How does Cuéntamo help with this?

The most tedious part of a forecast is keeping it alive, and that’s exactly what Cuéntamo automates. You define your recurring income and expenses just once (the rent, the membership fees, the subscriptions, the salary you pay yourself) and from there it projects your account balance forward, up to 24 months, without you having to touch a spreadsheet every Monday.

You see your balance curve month by month, and if it ever dips into the red, Cuéntamo warns you before that day arrives, not after. The “how much can I spend?” feature tells you how much real room you have right now without compromising the payments you already know are coming. That’s the difference between staring at today’s balance and understanding your liquidity over the coming months.

For the tax problem we mentioned earlier, the natural move is to log VAT and income tax as quarterly recurring items: that way they stop being a surprise and show up in your forecast for what they are, money already committed. And if you use the freelance module, working out how much VAT to pay each quarter comes straight from your own transactions.

You can try it for free at cuentamo.com.

Frequently asked questions

What is a cash flow forecast for a freelancer?

It’s an estimate of how much money you’ll have in your accounts over the coming months, subtracting expected outflows (fixed costs, variable costs, and taxes) from expected inflows. It isn’t accounting and it doesn’t go to the Agencia Tributaria: it’s a tool of your own to stay ahead of liquidity problems.

How many months ahead should the forecast go?

The most practical approach is to work with a three-to-six-month horizon. Anything longer is hard to maintain accurately, and anything shorter doesn’t give you enough time to react.

Why do I have to include VAT in the cash flow forecast?

Because the VAT you charge your clients isn’t yours: you’ll have to hand it over every quarter. If you count it as available balance and spend on that basis, you’ll run out of cash when the time comes to pay it.

How do I estimate income if I work on projects and get paid irregularly?

Be conservative: if a client usually pays after 60 days, don’t include them in next month’s forecast, and if a project is “almost confirmed” but unsigned, leave it out. A pessimistic forecast isn’t there to make you anxious, but to help you decide on solid ground.

How often should I update the forecast?

A forecast is only useful if it’s up to date; a three-month-old one that nobody has touched is worthless. The key is to keep maintenance minimal: define your recurring items once and let them project themselves.

This article is checked against official sources and reviewed periodically. If you spot anything out of date, email us at [email protected].