Liquidity Planning for Freelancers: Build Your Own Liquidity Plan in 5 Steps
A liquidity plan shows you month by month whether your money will last – long before things get tight. Here is how to build one yourself in an hour.
- Liquidity is the money that is actually in your account – not the profit in your books.
- A liquidity plan lists all expected inflows and outflows per month and rolls the balance forward.
- The three most common holes: late customer payments, VAT and tax prepayments.
- Once set up, maintenance takes 20 minutes a month – and shows shortfalls three to six months ahead.
Most freelancers know fairly precisely how much revenue they make. Far fewer know how long their money will last when a big client pays in 60 days and VAT is due at the same time. That is exactly the question a liquidity plan answers – and it is simpler to build than many think.
What liquidity planning actually is
Liquidity is the money that is really available: the account balance plus what will certainly still come in, minus what will certainly still go out. Profit is something else. Profit arises in the books when an invoice is written – liquidity arises only when the money lands in the account. Weeks often lie in between.
A liquidity plan is a table with one column per month. Each column holds the expected inflows (customer payments, not invoices issued), the expected outflows (rent, software, insurance, taxes, your own owner's salary) and the resulting balance at month end. That end balance is the opening balance of the next month. No more maths is needed.
Step 1: Record the starting point
Note today's balance of all business accounts. If private and business money share one account, now is a good time to separate them – the separation alone makes planning far easier.
Step 2: Plan inflows realistically
For each month, enter the payments you expect. What counts is the payment date, not the invoice date. If your clients take 30 days on average, an invoice from 15 March only lands in the April column.
Three categories help with estimating
- Certain: ongoing contracts, retainers, invoices already issued.
- Likely: proposals that are usually accepted.
- Hope: everything else. This category does not go into the plan.
If you plan only the first two categories, you rarely get nasty surprises.
Step 3: Capture outflows completely
This is where most mistakes happen, because irregular payments get forgotten. Go through the bank statements of the last twelve months once and sort everything into three groups:
- Monthly: rent, software, phone, insurance, health insurance, owner's salary.
- Quarterly: VAT prepayment (depending on your cycle), income tax prepayment, contributions.
- Annually: vehicle insurance, professional association, accountant, annual accounts, larger purchases.
Your own owner's salary belongs in the plan as a fixed outflow. Whoever "takes what is left" is not planning but hoping.
Step 4: Roll the balance forward
Now the table calculates: opening balance plus inflows minus outflows gives the closing balance, which carries into the next month. Mark every month in which the closing balance drops below your reserve – for example below three months of expenses. These months are your early warning.
Example (fictional figures)
A consultant starts with €14,000 in the account. She expects €7,500 of inflows in January against €6,200 of outflows, €4,000 against €6,200 in February (a client pays late) and €9,000 against €10,700 in March, because VAT and the income tax prepayment fall due.
| Month | Opening | Inflows | Outflows | Closing |
|---|---|---|---|---|
| January | €14,000 | €7,500 | €6,200 | €15,300 |
| February | €15,300 | €4,000 | €6,200 | €13,100 |
| March | €13,100 | €9,000 | €10,700 | €11,400 |
At first glance everything looks fine. But if you take a reserve of three months of expenses (around €18,600) as the target, the balance is below it in every month – and the plan shows that March, despite the highest revenue, is the most expensive month. You do not see connections like that without a plan.
Step 5: Reconcile monthly
At the start of the month you replace last month's planned values with the actual figures and move the horizon one month further. That takes about 20 minutes. After three months you know how good your estimates are – and you automatically get better.
Typical mistakes that make the plan worthless
- Entering the invoice date instead of the payment date.
- Treating VAT as your own money. It is only parked in your account temporarily.
- Forgetting tax prepayments because they "only" come quarterly.
- Not defining a reserve. Without a target there is no warning.
- Setting up the plan and never touching it again.
If you avoid these five points, you already have better planning than most small businesses.
Conclusion
A liquidity plan is neither bookkeeping nor a business plan, but a simple look ahead at your account. Building it takes an hour, maintaining it 20 minutes a month. In return you see shortfalls months in advance and can act instead of react. If you do not want to start from scratch: a ready-made cockpit with a twelve-month forecast, scenarios and reserve planner is at liquidity planning – and the free liquidity quick check gives you a quick first impression.
Frequently asked questions
How far ahead should I plan?
Is Excel enough for this?
What is the difference between a liquidity plan and a business plan?
Note: THA·ONE is a planning aid, not tax advice (German StBerG). Talk to your tax advisor about your individual situation.
See in 60 seconds how long your money will last.
The Liquidity Tool is the complete cockpit as an Excel file: 12-month forecast, scenarios, reserve planner and traffic light. Buy once, start immediately – or try the online module free for 14 days.