office, business, notebook, statistics, technology, digital, computer, internet, marketing, accounting, corporate, job, communication, creative, table, meeting, businessman, ideas, woman, project, coworking, brainstorming, loft, plan, documents, discussion, group, man, team, mobile, mock, work, laptop, professional, startup, management, teamwork, network, account, paperwork, hipster, young, cooperation, object, papers, global, millennials, living room, sofa, blue business, blue computer, blue office, blue technology, blue laptop, blue work, blue meeting, blue paper, blue marketing, blue team, blue mobile, blue network, blue community, blue room, blue internet, blue digital, blue table, blue group, blue job, blue company, blue conference, blue global, blue businessman, blue teamwork, blue plan, blue planning, blue creative, blue document, blue accounting, blue idea, blue management, statistics, statistics, marketing, marketing, marketing, accounting, accounting, accounting, accounting, accounting, project, management
Photo by Goumbik on Pixabay

Measurement

Part of Measuring startup funding across five layers, from cash need to outcomes

A four-page startup funding dashboard with a data-quality panel

Build an England startup funding dashboard for cash, process, economics, delivery, data quality and decisions without overstating certainty.

Editorial Desk · · 4 min read

A funding dashboard should help a board decide, not decorate an update. Keep it small enough to review and detailed enough to trace. Separate current cash, process evidence, forecast, transaction economics and post-funding delivery.

What to take away

  • Keep the dashboard small enough to review and detailed enough to trace each figure.
  • Separate cash, process evidence, forecast, transaction economics and post-funding delivery across four pages.
  • Do not combine unlike funding routes into a single conversion rate.
  • Record the decision, owner and due date arising from the dashboard at each meeting.

Write dashboard questions

Dashboard questions to answer

  • When does cash become unsafe?
  • Which route is producing qualified progress?
  • What evidence blocks a decision?
  • What will the company receive after fees?
  • Is funded delivery on track?

The GOV.UK Service Manual's performance-data guidance recommends defining success, deciding which data show it and using performance information to improve a service. Adapt that practice to the company rather than copying government measures.

For each page, write the question before the metric. Examples:

  • What decision does the board need from cash and runway?
  • Which receipts are committed, and which are uncertain?
  • Which funding route owns each target, and what evidence closes a stage?
  • Which delivery milestones are funded, and who owns each action?

Page 1: cash and decision

Show unrestricted cash, committed receipts, monthly net use, runway floor and forecast variance. Add minimum and target funding, expected net proceeds and fallback trigger. Label uncertain receipts.

Page 1 cash metrics

  • Unrestricted cashcash available now
  • Committed receiptsmoney confirmed
  • Monthly net usecash burn per month
  • Runway floorminimum safe months
  • Forecast varianceplan versus actual

Use one reporting date and comparison period. A dashboard mixing today's bank cash with last month's pipeline creates false precision.

Worked example (illustrative figures): unrestricted cash £420,000 plus committed receipts £30,000 gives £450,000 available. Monthly net use is £75,000. Runway = £450,000 / £75,000 = 6.0 months.

Page 2: funding process

Count targets by route and verified fit, then show cases at submitted, screening, diligence, proposal, documents and conditions. Add time in stage, material evidence gaps and next decision.

Funding case stages

  1. Targets by route and verified fit
  2. Submitted
  3. Screening
  4. Diligence
  5. Proposal
  6. Documents and conditions

Do not add unlike routes into a single conversion rate. A grant competition, loan application and equity approach have different populations and processes. For an England-based company, an Innovate UK grant, a bank loan and an SEIS or EIS equity round are not comparable.

Page 3: economics

Report gross funding, cash deductions, fees paid, net proceeds and receipt timing. For debt, show scheduled payments and covenant headroom. For equity, include fully diluted ownership and modelled later-round effects. For grants, show eligible spend, company contribution and claim timing.

Page 4: delivery

Link funds to milestone activities, budget, evidence and owner. Show variance, grant claims, debt payments, investor reporting and unresolved conditions. Keep outputs separate from business outcomes.

Add a data-quality panel

List stale sources, missing fields, reconciliations, corrections and known coverage gaps. Every metric should link to its definition and owner. A red data-quality flag can be more useful than a green performance indicator based on weak records.

Worked flag: bank statement shows £420,000 but the ledger shows £405,000. The £15,000 difference is an unpresented cheque. Mark the reconciliation amber until the cheque clears, then correct the source record.

HMRC's EIS and SEIS release covers defined tax schemes and may revise recent periods. A company dashboard should not treat those totals as its target.

For reconciliation, HMRC supplies tax and scheme records, Companies House supplies filed accounts, and the FCA supplies records for regulated firms. Treat them as source evidence.

Control access and publication

The dashboard may contain personal, confidential and price-sensitive information. Use role-based access, versioning and retention. Produce a separate publication view with appropriate aggregation and reviewed claims.

Build and test the data flow

Map each panel to an authoritative record and define the owner. Use a controlled manual process in Excel or Google Sheets until field meaning and ownership are stable. Keep refresh time and failure status visible.

Board reporting template

Begin with the decision needed, then show cash, material changes, stage movement, net economics, delivery variance, risks and open approvals. End with named actions and dates. Put detailed target and data-quality records in controlled supporting views.

Before you act

  • Use one reporting date and comparison period throughout.
  • Label uncertain receipts and keep outputs separate from outcomes.
  • Link every metric to its definition and owner.
  • Reconcile source records before automating refresh.
  • Test missing records, duplicate targets and a delayed receipt.
  • Review access after every adviser, investor or staff change.

Common questions

Why should the dashboard avoid a single conversion rate across funding routes?

The article says a grant competition, loan application and equity approach have different populations and processes. Adding unlike routes into one conversion rate would mix those populations, so count targets by route and verified fit instead.

What should the data-quality panel list?

It should list stale sources, missing fields, reconciliations, corrections and known coverage gaps.

How should the dashboard be built and tested before automating refresh?

Map each panel to an authoritative record, use a controlled manual process until ownership is stable, and keep refresh time visible.

Filed understartup funding reporting dashboard

More in Measurement