Cash runway & scenario planner

When does your money run out? Answer five quick questions for an instant answer. Want it more accurate? Add detail in the steps further down. No accounting knowledge needed.

Your figures stay on your own computer
How that works, and the two catches

This is a single web page that does its sums inside your browser. Nothing you type is uploaded, sent to us, or saved on any website. There is no login and no database.

We count how many people open the page and which buttons get pressed. No names, no figures, no cookies.

Catch one: the page remembers your figures in this browser, so press Reset when you finish on a shared computer. Catch two: Save puts a copy on your computer, and that is the only way to keep your work.

Quick check: how long will your cash last?

Five questions, about a minute. Rough figures are fine.

All your business accounts added together. Overdrawn? Put a minus sign in front.
What you invoice or take in a normal month, before VAT.
Everything you pay out: wages, rent, stock, software, fees. Leave out VAT.
Stock, materials, card fees and delivery follow your sales. Rent, wages and insurance usually don’t.
If yes, we allow for your quarterly VAT payments at the standard 20% rate.

The detailed version

Optional. Your quick check answers are already filled in. Open any step to add detail, such as unpaid invoices, loans, seasonal trade or a full cost list, for a more accurate answer.

1Where you stand today

Today’s position. Import your accounts, or type the figures in. Blanks count as nil, so a rough estimate beats a gap.

Where do I get a file to import?

Importing fills in the boxes below and builds your cost list in stage 3. It reads a trial balance, or a balance sheet and profit and loss together. Several files at once is fine.

A trial balance is a list of every account in your bookkeeping with its balance beside it. It is the most useful file to import, because it holds what you own and owe as well as what you earn and spend.

Xero: Accounting → Reports → Trial Balance → set the date to your last month end → Export → CSV.

QuickBooks: Reports → search “Trial Balance” → set the dates → export icon → CSV.

Sage Business Cloud: Reporting → Trial Balance → choose the period → Export → CSV. In Sage 50: Financials → Trial Balance → Export.

Anything else: use the blank template above. Two columns is all it needs — the name of the account and the amount.

Nothing is uploaded. The file is read by this page on your own computer.

All your business accounts added together, including any Stripe or PayPal balance. Overdrawn? Put a minus sign in front.
If you send invoices and wait to be paid, or get supplier bills to pay later, choose yes. It changes when money actually arrives.
Invoices you have sent that are not paid yet. Your bookkeeping calls this trade debtors or accounts receivable.
Supplier invoices waiting to be paid: trade creditors or accounts payable.
Average days from sending an invoice to the money arriving. Blank means 30, which is typical, 45 to 60 if you sell to big companies. A sale is not cash until it is paid.
The same in reverse. Blank means 30. Paying later keeps money in your account for longer, without changing your profit.
A year paid up front, a deposit, a retainer. Accountants call it deferred income. Nil if you invoice after the work.
Forecast settings  start month, how far ahead, equipment spending
Normally next month. Set for you if you import accounts.
Twelve suits most decisions. Shorter is sharper when cash is tight.
Things that last more than a year: computers, vehicles, a fit-out. An average month, or nil if you rarely buy any.
Blank means 20%, the rate for most UK businesses.
Your last VAT return will say. We assume you pay a month and a week after the quarter ends.
The amount due on your next return.
Fine-tune VAT (optional)
Blank means 100, right for most. Lower it only if some sales are zero-rated or exempt.
Wages carry no VAT, so this is usually well under half. Blank means 30.
Why VAT matters here

VAT you charge was never your money — you hold it for HMRC, subtract the VAT on your own purchases, and pay the difference every three months.

So it changes nothing about your profit, but it empties your bank in lumps. That is why businesses rarely run out of money gently: they fall over on a payment date. The three-monthly drops on the cash chart in stage 4 are these payments.

Bank loans, Bounce Back Loans, asset finance or an overdraft limit. Repayments and interest come out of your cash.
Limited companies pay it nine months after their financial year ends. Sole traders and partners pay income tax personally, which this does not model.
Bank loans, CBILS or Bounce Back Loan, asset finance: what you still owe in total.
Bounce Back Loans are 2.5%. Interest is charged on what is still owed each month.
The whole payment, interest included. Leave at nil and we assume you pay interest only.
What the bank lets you go overdrawn by. If you set one, “cash runs out” means going past this limit, not going below nil.
Charged each month on whatever you are overdrawn by.
The tax for each year is worked out on that whole year’s profit in the forecast, at 19% up to £50,000, 25% over £250,000 and in between on a sliding scale.
Tax on a year already finished that you have not paid yet.
The month it has to reach HMRC by.

2What brings the money in

Pick how you sell. Repeat customers → first. Job by job → second. Not selling yet → third. The boxes below change with your choice.

Most businesses can leave this on the first option. Subscription or membership businesses may prefer the second.
A normal recent month, before VAT. If last month was odd, use a typical one.
Small numbers mount up: 2% a month is about 27% over a year. Nil is an honest start.
Reliable money that is not sales: a sublet, a monthly grant, interest.
Change nothing for a year: what share of today’s customers’ spending would you still have? 90 means losing a tenth. Unsure? Use 90.
Monthly value, so a customer paying £200 a month counts as 200, not 2,400.
Upgrades and bigger packages, per month. Nil if you do not sell this way.
Used for costs that step up as customer numbers grow, in stage 3.
Is your trade seasonal?  optional — shifts when the sales arrive, not how many

Enter each calendar month as a percentage of an ordinary month: 100 is normal, 150 is half as busy again, 60 is a quiet month. We scale the set so the year’s total is unchanged, so this moves when sales land rather than adding or removing any. It is what turns a comfortable-looking year into a tight February. The presets are rough starting points. Replace them with your own pattern.

One thing to know: your “invoiced last month” figure already contains its own season. We take that out before projecting, so enter what you actually billed.

3Which costs follow your sales, and which do not

Two figures are enough for a good answer. Break them down line by line only if you want more accuracy.

Rent, wages, insurance, software: bills that arrive whatever you sell.
Stock, materials, card fees, delivery. If every £100 of sales costs you £30 to deliver, enter 30.
Or import your accounts in step 1.
Fixed, variable and stepped costs: what they mean and why it matters
FixedSame bill whatever you sell. Rent, salaries, insurance.
VariableRises and falls with sales. Card fees, stock, delivery.
SteppedStill, then jumps. One more person every 35 customers.

Two businesses, identical on paper. Both invoice £100,000 a month and spend £90,000, so both make £10,000.

An agency has £72,000 of salaries, rent and software. A shop has £63,000 of stock it only buys when it sells something.

Sales fall 10%. The agency saves almost nothing. The shop buys less stock.

PROFIT IN A NORMAL MONTH, THEN AFTER A 10% DIP Agency £10,000 £1,800 Shop £10,000 £6,300 Same sales, same costs. Only the shape of the costs differs.

That is what “locked in” means wherever you see it here: fixed plus stepped, as a share of your total cost. It is the spending that still arrives in a month when nothing sells.

Nearly everybody guesses low. Any one cost feels like something you could deal with, but “could cancel, given three months and an awkward conversation” is not the same as “falls away by itself this month”.

It cuts both ways on growth. A high locked-in share means each extra £1,000 of sales is nearly all profit. The catch is stepped costs: growth crosses a line where you need another person or a bigger unit, and that lump lands before the sales that justify it. That is how a profitable business runs out of money.

What the cost isHow it behavesHow much Per how many customersReal money?
Two columns: what the cost is, and how much a month.
What does “real money?” mean?

Leave it ticked for anything you actually pay out. Untick it for depreciation, which lowers your profit without money leaving your account. Unticked costs still count against profit, but are ignored when we work out your bank balance.

4The answer

Profit over 24 months
—
What is this?

Your sales less your costs across the whole period. It ignores when money moves, so you can show a profit and still be short of cash — which is why the next box exists.

Cash runs out
—
What is this?

The month your bank balance first goes below nil, on these figures. If it never does, this shows the lowest point instead. This is the number that decides whether you have a problem this year, and it is driven as much by when people pay you as by whether you are profitable.

Sales needed to break even
—
What is this?

The level of sales that would leave you at exactly nil profit. Below it you are losing money, above it you are making it. We work it out by taking the costs that arrive whatever happens, and seeing how much you must sell to cover them once your sales-linked costs are paid.

Locked in whatever happens
—
arrives even in a month with no sales
What is this?

Your fixed and stepped costs as a share of total cost, from how you sorted them in stage 3. The higher it is, the more a quiet month hurts, because little of your spending falls away with your sales. Above about 70% is worth taking seriously.

Your bank balance, month by month

Money left at each month end. Red is below nil.

From cash today to cash at the end

Profit is only the start. This shows what else moves your bank balance over the whole forecast.

Where the money goes

Every cost over the whole forecast, biggest first.

Profit and loss over the period, in pounds

What if trade is better or worse than you think?

5Test a change

Change one thing and watch your answer move. The from box sets when it starts.

What each slider actually does

Prices. Most businesses can only reprice at renewal, so a rise phases in evenly over twelve months. That is why +5% does not add 5% next month. Nothing else moves, so it all lands on profit.

Keep more customers. Replaces the retention figure from stage 2, from the month you choose. Only does anything if you picked the retention option there.

New business. Scales your stage 2 figure. 100% is as you are, 150% is half again, 0% is winning nothing — a useful worst case.

Cut every cost / fixed costs only. A percentage off every line, or off the fixed ones alone. The second is more realistic: variable costs are usually a price you cannot argue with, while fixed costs are choices.

One-off costs. What the change costs to make — redundancy, exit fees, advice. It comes out of profit and out of your bank in the month you pick.

How the sums work. Every slider move rebuilds all the months from your own figures: sales, then each cost by its behaviour, then when money actually arrives and leaves, then VAT. No industry averages, nothing hidden.

What the sliders assume, and life does not

A slider assumes you get the change and keep it, with no side effects. Real changes have them, so test the side effect too.

Put prices up 5% and some customers will leave — lower retention at the same time and see if you are still better off. Cut costs and something gets slower, so add the redundancy cost on the right. Win more new business and you will have paid to get it.

Used that way these sliders are a fair guide. Used alone, they will flatter you.

Goes into your bank in the month you pick. It is not counted as profit.

A word on what this is. This tool gives you a considered estimate from the figures you enter. It is not a statutory forecast, an audit, or financial, tax or investment advice, and it models corporation tax only in a simple form (no losses carried back, no associated companies, no tax adjustments to profit), does not model income tax for sole traders and partners, and knows nothing specific to your trade. Decisions with real consequences deserve a proper look at your actual books — do not rely on this alone.

Built by Your Books and Balances — accountancy, bookkeeping and financial forecasting for SMEs. ybab.co.uk · 07471 422082

Cash runway report