Cash Flow Budget in Excel: Template with Automatic Calculations

You can have strong sales and a positive result on paper and still be unable to pay salaries at the end of the month. Liquidity and profitability are not the same thing. A cash flow budget shows you exactly when cash comes in and goes out.

After 15 years as a financial consultant, I have seen too many companies end up in acute liquidity crises that were entirely predictable. A seasonal business that did not plan for low sales in winter. A construction company that forgot that customers pay 60 days later. A consulting firm that did not account for VAT payments every quarter.

All of them could have been avoided with a simple cash flow budget.

This guide shows you how to build and use a cash flow budget in Excel so that you are never surprised by a cash shortfall again.

Download the free cash flow budget template

Our cash flow template for Excel includes: – Weekly or monthly basis (your choice) – Automatic calculations of receipts and payments – Rolling balance with warnings – Colour coding for critical periods – Support for seasonal variation – Instruction sheet

Download the free cash flow budget template

The template works in Excel 2016 and later, on both Windows and Mac.

The difference between an income budget and a cash flow budget

Many people think an ordinary budget is enough. It is not.

The income budget shows profitability

An income budget is based on accrual accounting: – Sales are booked when the invoice is sent – Costs are booked when they are incurred

You can show 100,000 SEK in sales in January even if the customer pays in March.

The cash flow budget shows cash flow

A cash flow budget is based on actual receipts and payments: – A receipt is booked when the customer PAYS – A payment is booked when you PAY the supplier

Real example:

A consulting firm had an income budget showing a profit of 200,000 SEK in Q1. The cash flow budget showed a cash deficit of 150,000 SEK in the same period.

Why? They invoiced heavily in March (income), but customers paid 30-60 days later (cash flow). Meanwhile they paid salaries and rent in cash every month.

The income statement said “everything is fine”. The cash flow said “you will get into trouble in April if you don’t act”.

What a cash flow budget contains

The basic structure is simple but powerful.

Opening balance

How much cash do you have at the start of the period?

First period: Actual bank balance today Following periods: Closing balance from the previous period

Receipts

All cash coming in:

Customer payments – From earlier sales (receivables) – From new sales (cash)

Keep payment terms in mind! If customers pay 30 days later, you must move the receipt forward one month from the sales date.

Other receipts – Loans or credits – Investor capital – Grants – Insurance payouts – Interest income

Payments

All cash going out:

Variable costs – Purchase of goods – Materials – Freight costs – Commissions

Fixed costs – Salaries (important: include social security contributions) – Rent and premises costs – Insurance – IT and subscriptions – Marketing

Special payments – VAT (quarterly or monthly) – Tax (specific dates) – Loan repayments – Investments (equipment, premises)

Closing balance

Utgående balans = Ingående balans + Inbetalningar - Utbetalningar

This becomes the next period’s opening balance.

How to build a cash flow budget in Excel – step by step

Here is the process for creating your own cash flow budget.

Step 1: Choose the time period

Weekly budget: Good for small businesses with frequent cash flows or companies in crisis Monthly budget: Standard for most companies Quarterly budget: Works for stable companies with predictable cash flows

Recommendation: Start with a monthly budget, planning 12 months ahead.

Step 2: Identify the opening balance

Check the bank account today. That is your opening balance for the first period.

If you have several accounts, add them all together.

Step 3: List all receipts

Go through every source of income:

For customer payments: 1. Look at your customer invoices 2. Analyse historical payment times 3. Allocate receipts based on actual payment, not invoice date

Example: You invoice 100,000 SEK in January with 30 days’ payment terms. → Budget the receipt in February, not January

For seasonal businesses: If you sell most in summer but little in winter, show it in the budget. A cash flow budget must reflect reality.

Step 4: List all payments

Categorise all costs:

Regular (every month): – Salaries: Always the same date (often the 25th) – Rent: Often the first of each month – Subscriptions: Fixed dates

Quarterly: – VAT: Paid the month after the quarter (April, July, October, January)

Annual: – Insurance: Often at the renewal date – Licence renewals

Variable: – Purchases: Based on the sales forecast – Marketing: According to the campaign plan

Step 5: Build the Excel template

Create columns for each month (or week):

Description	Jan	Feb	Mar	Apr	…
OPENING BALANCE	50 000	=C30	=D30	=E30	…
RECEIPTS
Customer payments	80 000	95 000	110 000	120 000
Other receipts	0	0	20 000	0
Total receipts	=SUM(B4:B5)	=SUM(C4:C5)
PAYMENTS
Salaries	-45 000	-45 000	-45 000	-50 000
Rent	-12 000	-12 000	-12 000	-12 000
Purchases	-30 000	-35 000	-40 000	-45 000
VAT	0	0	0	-25 000
Other costs	-8 000	-8 000	-10 000	-8 000
Total payments	=SUM(B8:B12)
CLOSING BALANCE	=B2+B6+B13	=C2+C6+C13

The formulas are copied automatically to the right when you drag.

Step 6: Add warnings

Conditional formatting to highlight problems:

Closing balance: – Red background if <0 (cash deficit) – Yellow background if <20,000 (close to the limit) – Green background if >50,000 (good buffer)

How to do it: 1. Select the “Closing balance” row 2. Home > Conditional Formatting > New Rule 3. “Format only cells that contain” 4. Cell Value less than 0 → Red 5. Repeat for the other thresholds

Step 7: Create forecast scenarios

Build three versions:

Base scenario: Realistic forecast Optimistic: If everything goes well (+20% sales) Pessimistic: If things go worse (-20% sales)

This shows you the sensitivity and helps you plan for different outcomes.

Using the cash flow budget for decisions

The budget is not just a document – it is a basis for decisions.

Identify critical periods

When does the budget show a cash deficit or close to zero?

Handling: – Negotiate better payment terms with customers (shorter payment time) – Negotiate longer payment terms with suppliers – Secure a credit line in advance – Postpone non-critical investments

Plan investments

Do you want to buy new equipment for 80,000 SEK?

Check the cash flow budget: Do you have an 80,000 SEK+ buffer that month? Does the payment negatively affect later periods?

If the budget shows problems: Postpone the investment or finance it.

Optimise VAT reporting

Small businesses can choose monthly or quarterly VAT reporting.

Quarterly gives you longer credit (you hold the VAT for three months before paying). But some periods can become heavy.

Monthly gives a more even cash flow but less credit.

The cash flow budget shows which suits you best.

Common liquidity challenges and solutions

I see these problems often – and here is how to solve them.

Problem 1: Seasonal variations

Scenario: Sales are high in spring-summer and low in autumn-winter. Costs are even all year round.

Solution: – Build up a buffer during high season – Negotiate a credit line for low season – Renegotiate some fixed costs into variable ones

Problem 2: Long payment terms

Scenario: Customers pay in 60-90 days, you pay suppliers in 30 days.

Solution: – Incentives for faster payment (2% cash discount at 10 days) – Invoicing schedule instead of a final invoice – Factoring (sell the invoice to a finance company)

Problem 3: Large one-off expenses

Scenario: VAT, tax or investments create large payments in certain months.

Solution: – Set aside money monthly in a separate account – Finance investments instead of buying with cash – Negotiate instalment payments where possible

Problem 4: Growth requires more capital

Scenario: You are growing fast and need to buy more stock and materials before the customer pays.

Solution: – Secure working capital (bank loan or investors) – Request advance payment from customers – Drive sales but temporarily slow the pace of growth

Updating and following up the cash flow budget

A static budget quickly becomes unusable.

Monthly follow-up

Every month: 1. Enter the actual figures next to the budgeted ones 2. Calculate the variance 3. Analyse why (delayed customer payments? Unexpected cost?) 4. Adjust the forward-looking months based on the new information

Rolling forecast

Instead of making a 12-month budget in January that is never updated:

Use a rolling 12-month forecast. Every month you add one month ahead and adjust all upcoming months.

This always gives you a current 12-month outlook.

When you need a more advanced solution

An Excel-based cash flow budget works for most small businesses. But some situations require more.

Multiple companies or currencies

If you have several legal entities or handle several currencies, Excel becomes complex.

Dedicated financial software (Fortnox, Visma) has built-in liquidity reporting with consolidation.

Daily updating required

If the cash position is so tight that you need daily control, a monthly Excel budget will not do.

Real-time dashboards with a bank connection give you the current position at all times.

Advanced forecasting

If you want: – Automatic forecasts based on historical patterns – Scenario analysis with Monte Carlo simulation – Integration with invoicing and accounting systems

Then you need more advanced tools or a tailored Excel solution.

Common questions about cash flow budgets

How often should a cash flow budget be updated? Monthly at a minimum. Companies with tight cash flow or in crisis: weekly. Stable companies: quarterly may be enough.

What is the difference between a cash flow budget and a cash flow statement? A cash flow budget is forward-looking (forecast). A cash flow statement is backward-looking (what has happened).

How far ahead should I budget? Minimum 6 months. Recommended 12 months. Companies with seasonal variation: at least one full season cycle.

What is an acceptable minimum buffer? It depends on the industry and cost structure. Rule of thumb: At least one month of fixed costs as a buffer.

Can I use a cash flow budget to apply for a loan? Yes. Banks often require a cash flow budget with a credit application. It shows that you can pay back.

Next step: Build your cash flow budget today

Cash flow control gives you peace of mind and room to act. It takes 2-3 hours the first time but can save the company from a crisis.

Start here:

1. Download the free cash flow budget template
2. Gather information: current bank balance, upcoming invoices, planned costs
3. Fill in the template according to the guide
4. Identify critical periods
5. Plan actions

Need help?

If your liquidity situation is complex or you want a professional review:

• Free 15-minute consultation
• Tailored cash flow templates
• Integration with accounting systems
• Training in cash flow planning

Book a free consultation

Read on: – Budget template Excel: A complete guide – Excel templates for businesses: Free downloads – Excel consultant for financial solutions

Cash flow control is not complicated – but it is critical. Start planning today.

---

Written by Lukas Lilja, Excel Department. We have helped hundreds of companies avoid liquidity crises through better planning and control.