ExecoreSign in
Back to blog

Cash Flow Dashboard for UK Small Businesses: What to Track

Business owner reviewing invoices beside a laptop

A cash flow dashboard is one screen that shows what you are owed, what you owe and what your cash position will be over the coming weeks. For a small business, the best one is the one that fills itself in from the emails you already send and receive, so it is accurate without an evening of data entry. Execore does this: you Bcc your invoices to a unique address and forward the bills you receive, and your cash position is calculated from them.

Execore
execore.co.uk
See Your Cash Position More Clearly
Execore builds a 30-day net cash position from invoices you Bcc and bills you forward, helping you track what is owed and due.
Visit

TL;DR

  • A useful cash flow dashboard answers three questions: what money is coming in, what is going out, and what will be left in the next 30 days.
  • Track a handful of figures: cash in hand, overdue invoices, bills due, debtor days and the net position over the next few weeks.
  • A dashboard is only as good as the data in it, so the less manual entry it needs, the more likely it is to stay current.
  • Review it weekly and compare forecast with actuals, adjusting when they drift apart.
  • Execore builds your 30-day net cash position from invoices you Bcc and bills you forward, with no bank connection and nothing sent or paid until you approve it.

Table of Contents

What a cash flow dashboard actually is

A cash flow dashboard pulls the numbers that describe your cash into one view. Instead of opening a bank app, a spreadsheet and an inbox full of invoices, you look at a single page and see where you stand.

The pages that rank for this term are mostly written for finance teams in larger companies: business intelligence templates, treasury reports and long lists of key performance indicators. A sole trader, a three-person electrical firm or a freelance designer does not need twelve charts. You need an honest answer to a simple question: can I pay everything that is due, and who still owes me money?

That is why the useful version for a small business is smaller than the examples you will find online. It has a few numbers, they are current, and they lead to an action, usually chasing an invoice or timing a payment.

The figures worth putting on it

The British Business Bank, a government-owned economic development bank, says a cashflow forecast should include indicators such as cash in hand, debtor days, inventory days, supplier days taken and total sales. Debtor days is the average number of days customers take to pay you. Supplier days is how long you take to pay your own suppliers.

For most small businesses, a working dashboard comes down to these:

Figure What it tells you Why it matters
Cash in hand What you have now The starting point for everything else
Money owed to you Invoices sent and unpaid Your largest source of incoming cash
Overdue invoices Money already past its due date The list you should act on first
Bills to pay What you owe suppliers, tax and others, and when Stops payments arriving as a surprise
Net position, next 30 days Money in minus money out over the coming month The number that says whether you are safe
Debtor days How slowly customers pay A rising figure warns of trouble before the bank balance does

If you carry stock, add inventory days. If you have regular outgoings such as wages, loan repayments or VAT, make sure they appear as dated items rather than a vague monthly total.

The Federation of Small Businesses (FSB), the UK’s small business membership body, advises that a forecast should cover cash coming in from sales and other income, regular outgoings such as operating costs, wages and suppliers, financing such as interest and debt repayments, and planned capital spending. It adds that many small businesses keep a rolling forecast of three to six months, updated regularly.

Cash position tracking and a cash flow forecast are different things

The searches around this topic mix two ideas, and it helps to separate them.

Tracking tells you where you are now: what has been paid, what has not, and what is due out. Forecasting tells you where you will be: it estimates income and costs forward and shows whether the money will cover the bills when they fall due.

Business Wales, a Welsh Government service, describes a cashflow forecast as a planning tool that shows whether you will have enough cash to pay your expenses when they are due. It recommends monitoring cashflow regularly, ideally at least once a week. Its method is straightforward: estimate income and costs, work out the net cashflow for each month, then carry each month’s closing balance forward as the next month’s opening balance.

Monthly cash flow balance carry-forward sequence

South Tyneside Council sets out the same layout: receipts, payments, the excess of receipts over payments, an opening bank balance and a closing bank balance.

A good dashboard shows both. The tracking half is today’s reality, and the forecast half is the next 30 days. If you want to go further on method, our guide to forecasting business cash flow over 30 days and monthly walks through it.

Why most dashboards go stale

The usual failure is not the layout. It is the upkeep. A spreadsheet dashboard looks excellent in the week you build it. Then an invoice goes out and is not entered, a supplier bill sits in your inbox, and within a month the numbers describe a business that no longer exists.

The British Business Bank makes the point that forecasts are only as reliable as the assumptions and data put into them. That puts the weight on data entry. The more of it you do by hand, the more gaps appear, and the less you trust the screen, so you stop looking at it.

The ICAEW, ACCA and Ernst & Young guide to financial management for SMEs, published through GOV.UK, states that small businesses fail when they run out of cash. It asks whether you monitor cash flow and whether someone is responsible for chasing customer payments. In a business of one to five people, that someone is usually you, on top of the actual work.

Tradespeople will recognise the pattern. You finish a job on a Friday, send the invoice from your phone and move on to the next one. Three weeks later you are paying a materials bill and realise two customers have not paid. The invoice was sent, but nothing was tracking it.

The FSB recommends digital tools that track money in and out without relying on manual spreadsheets, updating automatically and setting invoice reminders so you are paid sooner. The principle is the right one: take the typing out.

Why most dashboards go stale

A dashboard that fills itself from your inbox

Every invoice you send and every bill you receive already passes through your email. That makes email the most reliable place to capture the data, because nothing needs retyping and nothing depends on remembering.

Execore works this way:

  1. Outgoing invoices: you add your unique Execore address in Bcc when you send an invoice, from whatever invoicing tool or template you already use.
  2. Incoming bills: you forward supplier bills to the same system.
  3. Cash position: Execore calculates your net cash position for the next 30 days from what it has captured, with overdue amounts highlighted so you can see what needs action.
  4. Chasing: for overdue invoices it drafts a follow-up email, including the statutory late-payment interest and compensation calculations.
  5. Approval: drafts go to a review queue, and nothing is sent or paid until you approve it.

You do not need a new invoicing system, a bank connection or software installed on your machine. Your existing workflow stays as it is, with one extra address in the Bcc line. For bills you need to pay, Execore can produce exportable payment files, so you stay in control of the money without handing over bank access.

What good looks like: a worked example

Take a freelance web developer with three live clients and a typical month. The figures are illustrative.

  • Cash in hand on the 1st: £4,200
  • Invoices outstanding: £1,800 (due in 10 days), £2,400 (14 days overdue), £950 (due in 25 days)
  • Bills and commitments over the next 30 days: £600 software and hosting, £1,100 personal drawings, £1,500 tax set-aside

Income expected: £1,800 + £950 = £2,750, plus the £2,400 if it is paid. Outgoings: £3,200. Without the overdue invoice, the 30-day position is £4,200 + £2,750 - £3,200 = £3,750. With it, £6,150.

The dashboard’s real value is not the arithmetic, it is what it flags. The £2,400 invoice is 14 days late, and it is the difference between a comfortable month and a tight one. The right response is a polite, accurate chase email today, not in three weeks.

The overdue list is the page you act on. If you want practical ways to shorten the wait for payment, see our guide on getting paid faster.

Setting up your dashboard step by step

1. Decide the horizon

Business Wales says a forecast usually covers 12 months but can be shorter or longer. For day-to-day control, a 30-day net position is the most practical. Add a three to six month view for planning, as the FSB describes.

2. Get every invoice and bill into one place

This step is where dashboards succeed or fail. Capture every outgoing invoice and every incoming bill, including the small ones. With email capture, this is one Bcc and one forward, repeated each time. Skipping a step here undermines every figure that follows.

3. Record due dates, not just amounts

Cash flow is about timing. A £3,000 bill due in two weeks matters far more than one due in two months. Make sure each item has a due date, and use your payment terms for invoices that do not state one.

4. Separate what is certain from what is hopeful

The British Business Bank advises against forecasting optimistically. Treat an invoice that is 30 days late differently from one due next week, and do not count income you have not yet invoiced as money in the bank.

5. Review weekly

Pick a regular slot, Monday morning for example, and spend ten minutes on it. Look at the net position, the overdue list and the bills due this week. Business Wales recommends checking at least weekly.

6. Compare forecast with reality

Business Wales suggests adding a second column beside each month’s forecast to record actual figures, then adjusting the rest of the year if the differences are significant. The British Business Bank likewise says to revise your forecast as things change or your estimates become more exact. A large customer paying late or an unexpected tax bill are exactly the events that should trigger a fresh look.

Keeping it accurate over time

Three habits keep a dashboard honest.

Capture at the moment of sending. An invoice entered a week later is an invoice that sometimes never gets entered. Bcc-ing at send time means the record exists the second the invoice leaves.

Mark things paid promptly. Money that has arrived but still shows as owed makes you chase customers who have already paid, which is awkward and damages relationships.

Chase early and consistently. An overdue invoice is not just a number on the screen. Late payment law gives you a statutory right to interest and fixed compensation on commercial debts, and having the calculation done in the chase email takes the awkwardness out of asking. Our guides on charging interest on a late invoice and recovering unpaid invoices cover the steps.

If you are weighing up how much time smarter admin could return to you each week, you can estimate the return on automation before deciding where to invest effort.

What to look for in cash position software

If you are comparing tools, these are the questions that matter for a small business:

  • How does data get in? The less typing, the better the data. Capture from email avoids duplicate entry.
  • Does it show the next 30 days clearly? A net position you can read in five seconds beats a dozen charts.
  • Does it highlight what is overdue? The dashboard should point to the action.
  • Does it help you chase? Seeing a late invoice is only half the job. A drafted, accurate reminder saves the other half.
  • Do you stay in control? Nothing should go out or be paid without your approval.
  • Does it fit how you already work? A tool that demands a new invoicing system will often be abandoned within weeks.

South Tyneside Council notes that software can help prepare forecasts, update projections and run “what if” calculations. For a small business, the point of all of it is the same: fewer surprises.

For a wider look at how small firms handle this, read our guides to small business cash flow and cash flow visibility.

Execore: your cash position from the emails you already send

Execore is an email-based invoice and bill tracker for UK small businesses, freelancers and tradespeople. Bcc your unique address on invoices, forward the bills you receive, and it keeps your 30-day net cash position up to date, highlights overdue invoices and drafts chase emails with the statutory interest and compensation worked out. Everything waits in a review queue until you approve it.

There is a Free plan, and the Business plan costs £29 per month. You can see both on the Execore pricing page, or start from the Execore homepage.

Execore

Our perspective: control without a new system

Most small businesses do not have a cash flow problem so much as a visibility problem. The money is owed, the bills are known, but the information sits in a sent folder, an inbox and a head, and nobody has the time to bring it together.

We built Execore around one idea: you should not have to change how you work to see your cash. You keep your invoicing tool, you add one address to the Bcc line, and you forward the bills you receive. There is no bank connection and no installation, and nothing is sent or paid until you have approved it.

We think that is the right balance for an owner who is already busy doing the actual work. The dashboard is a by-product of what you do anyway, and the chase emails arrive written, with the late-payment interest and compensation calculated, ready for you to approve.

the author

FAQ

What should a cash flow dashboard show?

At minimum: cash in hand, money owed to you, which invoices are overdue, bills you need to pay and your net position over the next 30 days. Debtor days is a useful extra, because it shows whether customers are paying more slowly over time.

How often should I check my cash position?

Business Wales recommends monitoring cashflow regularly, ideally at least once a week. A short weekly review of your net position and overdue list is enough for most small businesses, with an extra look whenever a large payment is due in or out.

What is the difference between a cash position forecast and cash position tracking?

Tracking shows where your cash stands now: what has been paid and what is outstanding. A forecast estimates what will come in and go out over a future period, so you can see whether you can cover your bills. A good dashboard combines both.

Do I need to connect my bank account to see my cash position?

Not with Execore. It builds your position from invoices you Bcc and bills you forward, so there is no bank connection and no new invoicing system to learn. You approve anything it drafts before it is sent.

Sources