How to Create an Excel Liquidity Plan: Guide with Free Template

A liquidity plan answers every entrepreneur's most important question: Do I have enough cash in the bank to pay my bills? In this guide, I'll show you step by step how to create a professional 12-month liquidity plan in Excel.

Why a Liquidity Plan Is Essential

One in four businesses fails not because of lacking revenue, but because of lacking liquidity. Even profitable companies can become insolvent — when customers pay late, large investments are due, or seasonal fluctuations strain cash flow.

A liquidity plan gives you:

• Early warning of impending bottlenecks — weeks or months in advance
• Planning certainty for investments, hiring, and growth
• Negotiating basis with banks and investors
• Control over your finances instead of gut feeling

The Basic Structure

Your liquidity plan follows a simple logic:

Closing Balance = Opening Balance + Inflows − Outflows

In Excel:

• Row 1: Months (Jan–Dec) as column headers
• Row 2: Opening balance
• Rows 3–10: Revenue categories
• Row 11: Total revenue
• Rows 12–22: Expense categories
• Row 23: Total expenses
• Row 24: Net cash flow (Revenue − Expenses)
• Row 25: Closing balance (Opening balance + Net cash flow)

Step 1: Define Revenue Categories

Category	Example	Planning Note
Product Revenue	SaaS subscriptions, goods	By payment receipt, not invoice date
Service Revenue	Consulting, services	Consider payment terms (30–60 days)
Grants	Government grants	Only when approved
Shareholder Loans	Equity, loans	Only when committed
Other	Interest, tax refunds	Plan conservatively

Important: Always plan by expected payment receipt, not invoice date.

Step 2: Define Expense Categories

Category	Type	Planning Note
Salaries & Social	Fixed	Same monthly (+ annual increase)
Rent & Utilities	Fixed	Watch index clauses
Insurance	Fixed	Annual or quarterly
Software & IT	Fixed/Semi	Subscription costs, licenses
Marketing	Variable	Plan campaign budgets separately
Contractors	Variable	By project planning
Materials	Variable	Link to revenue planning
VAT Prepayment	Variable	Quarterly
Credit Payments	Fixed	From loan agreement
Investments	One-time	Equipment, computers

Step 3: Set Up Formulas

Total Revenue: =SUM(B3:B10) Total Expenses: =SUM(B12:B22) Net Cash Flow: =B11-B23 Closing Balance: =B2+B24 Next Month Opening: =B25 (= previous closing balance)

Step 4: Conditional Formatting

1. Select closing balance cells B25:M25
2. Rule 1 (Red): Cell value < 0 → Red fill (Warning: insolvent!)
3. Rule 2 (Yellow): Cell value < 10,000 → Yellow fill (Warning threshold)
4. Rule 3 (Green): Cell value > 30,000 → Green fill (Comfortable)

Common Mistakes to Avoid

Mistake 1: Planning by invoice date instead of payment receipt Mistake 2: Forgetting VAT prepayments (can be 5 figures quarterly) Mistake 3: Being too optimistic (plan revenue conservatively, expenses with buffer) Mistake 4: Forgetting one-time items (annual licenses, insurance, tax payments) Mistake 5: Not updating regularly (a plan is only as good as its currency)

When Excel Is No Longer Enough

Excel is a good start, but at a certain point it becomes a bottleneck:

• Multiple bank accounts? Manual export and import costs time
• Team planning? Version chaos is inevitable
• Scenarios? Manual copying and adjusting is error-prone
• Real-time data? Excel always shows the last update's status

Finban solves exactly these problems: automatic bank sync, real-time categorization, scenarios at the click of a button, and team access in the cloud.

Ready for the next step? Finban connects to your bank accounts and creates your liquidity plan automatically — in 5 minutes instead of 2 hours. Try free now →