Closing cash
£30,200
Mia · Cash Flow Manager
Let’s see where your money is going.
I’ll help you understand what came in, what went out and what could happen next.
Cash in
£240,500
Cash out
£231,800
Net cash movement
£8,700
Overdue invoices
£12,600
Monthly cash movement
Enter the money received and payments made each month.
| Month | Cash in | Fixed costs | Variable costs | Other payments | Cash out | Net movement | Closing balance |
|---|---|---|---|---|---|---|---|
| £33,400 | £2,700 | £24,200 | |||||
| £34,300 | £3,100 | £27,300 | |||||
| £38,200 | £3,000 | £30,300 | |||||
| £38,900 | £1,200 | £31,500 | |||||
| £42,500 | £100 | £31,600 | |||||
| £44,500 | -£1,400 | £30,200 |
Swipe across to see every figure.
Mia’s analysis
Your cash position
Where you stand today
After 6 months your cash balance is 30,200 in your chosen currency, having moved up across the period.
You are adding cash each month
On average you add about 1,450 a month. June used 1,400.
What's causing the biggest outflow
Fixed costs are 31.9% of everything leaving the business and variable costs 61.6%. Fixed costs continue whether sales rise or fall, so they set your minimum monthly requirement.
Your cash is building
Your recent months bring in more than they pay out, so at this rate you are not running your cash down.
Money owed to you
Customers owe you 15,700, of which 12,600 is already late. The oldest is Northgate Retail at 41 days. Collecting this is usually the quickest way to improve your cash position.
Forward view
What if sales change?
Using your recent monthly averages with sales at 0.0%. Variable costs move with sales; fixed costs stay the same.
Month +1
In £40,083 · Out £38,633
£31,650
£1,450 this month
Month +2
In £40,083 · Out £38,633
£33,100
£1,450 this month
Month +3
In £40,083 · Out £38,633
£34,550
£1,450 this month
This is a simple planning view based on your figures, not a guarantee.
Money owed to you
Track customer invoices that can affect your cash position.
| Customer | Amount | Days overdue | Status |
|---|---|---|---|
| 12 days late | |||
| 41 days late | |||
| Not overdue |
Cash is weakening despite healthy sales?
Ask Alex to investigate the wider performance picture.
Open specialistA price decision could change short-term cash?
Ask Max to explore the price and volume trade-off.
Open specialist