Dashboards That Don’t Gather Dust: Open Books for Real Co-op Members

Open books are easy to say and surprisingly hard to do well. The temptation is to publish everything: the full ledger, every invoice, a spreadsheet with seventeen tabs and a colour scheme only the treasurer understands. That is not transparency. That is a data dump with a login screen.

A good dashboard passes what I call the member’s eye test. A tired member, on their phone, between school pick-up and a shift, should be able to answer three questions in under a minute: Are we okay? What changed? What do you need from me? If your dashboard cannot do that, it is a compliance box-tick, not open books.

Start with the reader, not the spreadsheet

Before you choose a single metric, name the people you are publishing for. A worker co-op member needs different information from a community shareholder in a village pub or a parent who uses the community shop. You probably have three reader modes: the thirty-second scanner, the five-minute reader who wants context, and the deep diver who will read the notes.

Design for all three. Put a plain-English summary at the top. Then a scorecard of six to eight headline numbers with trends. Then the detail, with links to the full accounts or board papers. If someone has to download a PDF to find out whether the co-op is solvent, you have buried the lede.

The numbers that earn their place

Financial metrics should be boringly useful. Cash in the bank is the first one. Not profit, not turnover, not a projected surplus three years out. Cash, and how many weeks or months of normal costs it covers. Add income and expenditure for the period, with a comparison to budget and last year. Show reserves against your own reserves policy. Show any debt, rent and major commitments. If a single grant or contract makes up a large chunk of income, say so—income concentration is a risk members should see.

For community businesses, separate restricted and unrestricted funds if that distinction matters. Publish membership share capital, but explain that it is not a savings account and withdrawals can be limited. Payroll is often the biggest cost, so show staff costs as a proportion of expenditure rather than individual salaries. Individual pay is a matter for your pay policy, not a dashboard.

Non-financial metrics should connect to your purpose. Member numbers, new members, lapsed members and attendance at meetings. Volunteer hours, if volunteers are part of the model. Customer or participant numbers, but only if they tell you something real. Community impact—events run, discounted access, local suppliers used, hours of advice given—is often more meaningful than another spreadsheet row.

Keep the list short. A dashboard with forty metrics is a dashboard nobody reads. Choose the ones that would change a decision.

What to leave out

Leave out the raw ledger and the invoice-level detail. Leave out individual salaries, personal member data, safeguarding cases, commercially sensitive negotiations and supplier contract terms. Leave out anything you cannot explain in plain English or act on if members ask questions. False precision is not honesty; it is noise.

Be careful with speculation. Members deserve early warning of risks, but a dashboard is not a rumour mill. Say what you know, what you do not know and when you will update. And do not publish a number just because it is easy to count. Vanity metrics—social media likes, footfall with no context, total cups of coffee sold—can crowd out the things that matter.

Plain English is a design feature

Use labels people recognise. ‘Money in the bank’ beats ‘cash and cash equivalents’. ‘How long we could keep going if income stopped’ beats ‘liquidity runway’. Round to whole pounds. Show the trend, not just the current figure. Add a short ‘what this means’ box next to each headline metric.

Accessibility is not a nice extra. Publish in HTML as well as PDF, with alt text, high contrast and a mobile-friendly layout. Offer a printed copy in the pub, shop or community hub. Consider an audio summary or a short video for members who do not read long documents. If your membership includes Welsh speakers, think about translation. If you have members with low digital confidence, do not make the dashboard app-only.

Turn reading into participation

A dashboard should end with an invitation. One question per issue. A feedback form. A ‘ask the treasurer’ slot at the next member meeting. A short online session where the board walks through the numbers and takes questions. Publish the responses and the decisions that follow. Close the loop: ‘You asked about the energy bill; here is what we did.’

Open books work best when bad news is included. A dashboard that only appears when things are rosy is a marketing leaflet. Members can handle uncertainty if you are honest about it. What they cannot handle is finding out at the AGM that the roof repair was known about for eight months.

A simple template to steal

Top line: one sentence on how things are. Scorecard: six to eight metrics with trend arrows and a short note. Money: cash, runway, income and expenditure, reserves. People and participation: members, volunteers, attendance, staff absence if relevant. Decisions and risks: what the board decided, top three risks, what is coming up. Ask: one specific thing members can do. Glossary and contact: who to ask.

Monthly for cash and decisions; quarterly for impact and the fuller picture. Pick a rhythm and stick to it. A dashboard that arrives late is a history lesson.

The member’s eye test is simple. Read your dashboard as if you are tired, busy and mildly suspicious. Can you tell whether the co-op is okay? Can you see what changed? Can you find one way to get involved? If yes, you have built something useful. If not, cut it back and start again. Open books are not about publishing everything. They are about publishing what matters, in a way people can use.