Closing cash
£13,051
Sample Data
Please avoid entering personal information or confidential information that you do not have permission to use.
Mia · Cash Flow Manager · Harbour Roast Coffee
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
£168,987
Cash out
£177,436
Net cash movement
-£8,449
Overdue invoices
£12,600
Cash flow at a glance
Money in, money out and your bank balance
Cash inCash outClosing balanceForward view (faded)
£26.5K£27.5K
Jan£27.4K£27.7K
Feb£26.8K£29.2K
Mar£29K£29.8K
Apr£29K£31.2K
May£30.3K£32.1K
Jun£28.2K£29.6K
Month +1£28.2K£29.6K
Month +2£28.2K£29.6K
Month +3£20.5K£20.2K£17.9K£17.1K£14.8K£13.1K£11.6K£10.2K£8.8K
Mia’s analysis
Your cash position
Where you stand today
After 6 months your cash balance is 13,051 in your chosen currency, having moved down across the period.
You are using cash each month
On average you use about 1,408 a month. June used 1,774.
What's causing the biggest outflow
Fixed costs are 41.6% of everything leaving the business and variable costs 49.9%. Fixed costs continue whether sales rise or fall, so they set your minimum monthly requirement.
How long your cash lasts
At the current rate of spending your cash would last roughly 9.3 months. This is a guide based on your recent average, not a prediction.
Money owed to you
Customers owe you 15,700, of which 12,600 is already late. The oldest is Northgate Retail at 41 days. Reviewing overdue invoices is one place to investigate when looking for ways 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 £28,165 · Out £29,573
£11,643
-£1,408 this month
Month +2
In £28,165 · Out £29,573
£10,235
-£1,408 this month
Month +3
In £28,165 · Out £29,573
£8,827
-£1,408 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 specialistDecision-support only. LetsFix uses the figures and assumptions you provide to help you understand your business. Results are for information and planning purposes and are not financial, accounting, tax or legal advice. Please verify important business decisions independently. Full disclaimer